IGI Maintain Code Combination Budget Control Flag - draft

Description

Application: Public Sector Financials International
Source: Budgeting: Maintain Code Combination Budget Control Flag (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBUCC_XML
DB package: IGI_IGIGBUCC_XMLP_PKG

Copy

SELECT
	null FLEXDATA,
	cc.code_combination_id ccid,
	'N' no_data, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_flexfield', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') CF_FLEXFIELD, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_flex_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') CF_FLEX_DESC, 
	IGI_IGIGBUCC_XMLP_PKG.cf_updateformula(cc.code_combination_id) CF_UPDATE, 
	IGI_IGIGBUCC_XMLP_PKG.cf_no_data_foundformula('N') CF_NO_DATA_FOUND
FROM
	gl_code_combinations cc
WHERE	cc.chart_of_accounts_id =:P_COA_ID
AND	&CP_WHERE_FLEX
ORDER BY
	&CP_SELECT_ALL,
	ccid