366: WHERE xf.xml_file_id = p_file_id
367: AND xf.xml_file_type = 'ENTITY_LOADER'
368: AND xf.language = 'US';
369:
370: G_CHAN_FLG := gcs_utility_pkg.get_dimension_required('CHANNEL_ID');
371: G_CCTR_FLG := gcs_utility_pkg.get_dimension_required('COMPANY_COST_CENTER_ORG_ID');
372: G_CUST_FLG := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');
373: G_GEOG_FLG := gcs_utility_pkg.get_dimension_required('GEOGRAPHY_ID');
374: G_LN_ITEM_FLG := gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID');
367: AND xf.xml_file_type = 'ENTITY_LOADER'
368: AND xf.language = 'US';
369:
370: G_CHAN_FLG := gcs_utility_pkg.get_dimension_required('CHANNEL_ID');
371: G_CCTR_FLG := gcs_utility_pkg.get_dimension_required('COMPANY_COST_CENTER_ORG_ID');
372: G_CUST_FLG := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');
373: G_GEOG_FLG := gcs_utility_pkg.get_dimension_required('GEOGRAPHY_ID');
374: G_LN_ITEM_FLG := gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID');
375: G_NAT_ACCT_FLG := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');
368: AND xf.language = 'US';
369:
370: G_CHAN_FLG := gcs_utility_pkg.get_dimension_required('CHANNEL_ID');
371: G_CCTR_FLG := gcs_utility_pkg.get_dimension_required('COMPANY_COST_CENTER_ORG_ID');
372: G_CUST_FLG := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');
373: G_GEOG_FLG := gcs_utility_pkg.get_dimension_required('GEOGRAPHY_ID');
374: G_LN_ITEM_FLG := gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID');
375: G_NAT_ACCT_FLG := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');
376: G_PROD_FLG := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');
369:
370: G_CHAN_FLG := gcs_utility_pkg.get_dimension_required('CHANNEL_ID');
371: G_CCTR_FLG := gcs_utility_pkg.get_dimension_required('COMPANY_COST_CENTER_ORG_ID');
372: G_CUST_FLG := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');
373: G_GEOG_FLG := gcs_utility_pkg.get_dimension_required('GEOGRAPHY_ID');
374: G_LN_ITEM_FLG := gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID');
375: G_NAT_ACCT_FLG := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');
376: G_PROD_FLG := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');
377: G_PROJ_FLG := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
370: G_CHAN_FLG := gcs_utility_pkg.get_dimension_required('CHANNEL_ID');
371: G_CCTR_FLG := gcs_utility_pkg.get_dimension_required('COMPANY_COST_CENTER_ORG_ID');
372: G_CUST_FLG := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');
373: G_GEOG_FLG := gcs_utility_pkg.get_dimension_required('GEOGRAPHY_ID');
374: G_LN_ITEM_FLG := gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID');
375: G_NAT_ACCT_FLG := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');
376: G_PROD_FLG := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');
377: G_PROJ_FLG := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
378: G_USER1_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
371: G_CCTR_FLG := gcs_utility_pkg.get_dimension_required('COMPANY_COST_CENTER_ORG_ID');
372: G_CUST_FLG := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');
373: G_GEOG_FLG := gcs_utility_pkg.get_dimension_required('GEOGRAPHY_ID');
374: G_LN_ITEM_FLG := gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID');
375: G_NAT_ACCT_FLG := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');
376: G_PROD_FLG := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');
377: G_PROJ_FLG := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
378: G_USER1_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
379: G_USER2_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
372: G_CUST_FLG := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');
373: G_GEOG_FLG := gcs_utility_pkg.get_dimension_required('GEOGRAPHY_ID');
374: G_LN_ITEM_FLG := gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID');
375: G_NAT_ACCT_FLG := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');
376: G_PROD_FLG := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');
377: G_PROJ_FLG := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
378: G_USER1_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
379: G_USER2_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
380: G_USER3_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
373: G_GEOG_FLG := gcs_utility_pkg.get_dimension_required('GEOGRAPHY_ID');
374: G_LN_ITEM_FLG := gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID');
375: G_NAT_ACCT_FLG := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');
376: G_PROD_FLG := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');
377: G_PROJ_FLG := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
378: G_USER1_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
379: G_USER2_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
380: G_USER3_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
381: G_USER4_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
374: G_LN_ITEM_FLG := gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID');
375: G_NAT_ACCT_FLG := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');
376: G_PROD_FLG := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');
377: G_PROJ_FLG := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
378: G_USER1_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
379: G_USER2_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
380: G_USER3_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
381: G_USER4_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
382: G_USER5_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
375: G_NAT_ACCT_FLG := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');
376: G_PROD_FLG := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');
377: G_PROJ_FLG := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
378: G_USER1_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
379: G_USER2_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
380: G_USER3_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
381: G_USER4_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
382: G_USER5_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
383: G_USER6_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
376: G_PROD_FLG := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');
377: G_PROJ_FLG := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
378: G_USER1_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
379: G_USER2_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
380: G_USER3_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
381: G_USER4_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
382: G_USER5_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
383: G_USER6_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
384: G_USER7_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');
377: G_PROJ_FLG := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
378: G_USER1_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
379: G_USER2_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
380: G_USER3_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
381: G_USER4_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
382: G_USER5_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
383: G_USER6_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
384: G_USER7_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');
385: G_USER8_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM8_ID');
378: G_USER1_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
379: G_USER2_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
380: G_USER3_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
381: G_USER4_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
382: G_USER5_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
383: G_USER6_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
384: G_USER7_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');
385: G_USER8_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM8_ID');
386: G_USER9_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM9_ID');
379: G_USER2_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
380: G_USER3_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
381: G_USER4_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
382: G_USER5_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
383: G_USER6_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
384: G_USER7_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');
385: G_USER8_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM8_ID');
386: G_USER9_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM9_ID');
387: G_USER10_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM10_ID');
380: G_USER3_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
381: G_USER4_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
382: G_USER5_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
383: G_USER6_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
384: G_USER7_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');
385: G_USER8_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM8_ID');
386: G_USER9_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM9_ID');
387: G_USER10_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM10_ID');
388:
381: G_USER4_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
382: G_USER5_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
383: G_USER6_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
384: G_USER7_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');
385: G_USER8_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM8_ID');
386: G_USER9_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM9_ID');
387: G_USER10_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM10_ID');
388:
389: base_org_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BASE_ORGANIZATION')
382: G_USER5_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
383: G_USER6_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
384: G_USER7_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');
385: G_USER8_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM8_ID');
386: G_USER9_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM9_ID');
387: G_USER10_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM10_ID');
388:
389: base_org_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BASE_ORGANIZATION')
390: .attribute_id;
383: G_USER6_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
384: G_USER7_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');
385: G_USER8_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM8_ID');
386: G_USER9_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM9_ID');
387: G_USER10_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM10_ID');
388:
389: base_org_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BASE_ORGANIZATION')
390: .attribute_id;
391: base_org_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BASE_ORGANIZATION')
385: G_USER8_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM8_ID');
386: G_USER9_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM9_ID');
387: G_USER10_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM10_ID');
388:
389: base_org_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BASE_ORGANIZATION')
390: .attribute_id;
391: base_org_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BASE_ORGANIZATION')
392: .version_id;
393: contact_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT')
387: G_USER10_FLG := gcs_utility_pkg.get_dimension_required('USER_DIM10_ID');
388:
389: base_org_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BASE_ORGANIZATION')
390: .attribute_id;
391: base_org_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BASE_ORGANIZATION')
392: .version_id;
393: contact_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT')
394: .attribute_id;
395: contact_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT')
389: base_org_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BASE_ORGANIZATION')
390: .attribute_id;
391: base_org_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BASE_ORGANIZATION')
392: .version_id;
393: contact_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT')
394: .attribute_id;
395: contact_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT')
396: .version_id;
397: logo_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-IMAGE_NAME')
391: base_org_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BASE_ORGANIZATION')
392: .version_id;
393: contact_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT')
394: .attribute_id;
395: contact_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT')
396: .version_id;
397: logo_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-IMAGE_NAME')
398: .attribute_id;
399: logo_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-IMAGE_NAME')
393: contact_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT')
394: .attribute_id;
395: contact_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT')
396: .version_id;
397: logo_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-IMAGE_NAME')
398: .attribute_id;
399: logo_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-IMAGE_NAME')
400: .version_id;
401: src_sys_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SOURCE_SYSTEM_CODE')
395: contact_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT')
396: .version_id;
397: logo_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-IMAGE_NAME')
398: .attribute_id;
399: logo_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-IMAGE_NAME')
400: .version_id;
401: src_sys_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SOURCE_SYSTEM_CODE')
402: .attribute_id;
403: src_sys_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SOURCE_SYSTEM_CODE')
397: logo_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-IMAGE_NAME')
398: .attribute_id;
399: logo_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-IMAGE_NAME')
400: .version_id;
401: src_sys_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SOURCE_SYSTEM_CODE')
402: .attribute_id;
403: src_sys_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SOURCE_SYSTEM_CODE')
404: .version_id;
405: ledger_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
399: logo_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-IMAGE_NAME')
400: .version_id;
401: src_sys_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SOURCE_SYSTEM_CODE')
402: .attribute_id;
403: src_sys_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SOURCE_SYSTEM_CODE')
404: .version_id;
405: ledger_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
406: .attribute_id;
407: ledger_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
401: src_sys_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SOURCE_SYSTEM_CODE')
402: .attribute_id;
403: src_sys_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SOURCE_SYSTEM_CODE')
404: .version_id;
405: ledger_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
406: .attribute_id;
407: ledger_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
408: .version_id;
409: trs_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-TRANSFORM_RULE_SET_ID')
403: src_sys_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SOURCE_SYSTEM_CODE')
404: .version_id;
405: ledger_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
406: .attribute_id;
407: ledger_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
408: .version_id;
409: trs_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-TRANSFORM_RULE_SET_ID')
410: .attribute_id;
411: trs_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-TRANSFORM_RULE_SET_ID')
405: ledger_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
406: .attribute_id;
407: ledger_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
408: .version_id;
409: trs_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-TRANSFORM_RULE_SET_ID')
410: .attribute_id;
411: trs_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-TRANSFORM_RULE_SET_ID')
412: .version_id;
413: vrs_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-VALIDATION_RULE_SET_ID')
407: ledger_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
408: .version_id;
409: trs_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-TRANSFORM_RULE_SET_ID')
410: .attribute_id;
411: trs_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-TRANSFORM_RULE_SET_ID')
412: .version_id;
413: vrs_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-VALIDATION_RULE_SET_ID')
414: .attribute_id;
415: vrs_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-VALIDATION_RULE_SET_ID')
409: trs_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-TRANSFORM_RULE_SET_ID')
410: .attribute_id;
411: trs_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-TRANSFORM_RULE_SET_ID')
412: .version_id;
413: vrs_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-VALIDATION_RULE_SET_ID')
414: .attribute_id;
415: vrs_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-VALIDATION_RULE_SET_ID')
416: .version_id;
417: secure_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SECURITY_ENABLED_FLAG')
411: trs_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-TRANSFORM_RULE_SET_ID')
412: .version_id;
413: vrs_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-VALIDATION_RULE_SET_ID')
414: .attribute_id;
415: vrs_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-VALIDATION_RULE_SET_ID')
416: .version_id;
417: secure_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SECURITY_ENABLED_FLAG')
418: .attribute_id;
419: secure_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SECURITY_ENABLED_FLAG')
413: vrs_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-VALIDATION_RULE_SET_ID')
414: .attribute_id;
415: vrs_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-VALIDATION_RULE_SET_ID')
416: .version_id;
417: secure_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SECURITY_ENABLED_FLAG')
418: .attribute_id;
419: secure_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SECURITY_ENABLED_FLAG')
420: .version_id;
421: bal_rule_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
415: vrs_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-VALIDATION_RULE_SET_ID')
416: .version_id;
417: secure_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SECURITY_ENABLED_FLAG')
418: .attribute_id;
419: secure_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SECURITY_ENABLED_FLAG')
420: .version_id;
421: bal_rule_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
422: .attribute_id;
423: bal_rule_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
417: secure_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SECURITY_ENABLED_FLAG')
418: .attribute_id;
419: secure_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SECURITY_ENABLED_FLAG')
420: .version_id;
421: bal_rule_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
422: .attribute_id;
423: bal_rule_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
424: .version_id;
425: elim_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY')
419: secure_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-SECURITY_ENABLED_FLAG')
420: .version_id;
421: bal_rule_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
422: .attribute_id;
423: bal_rule_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
424: .version_id;
425: elim_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY')
426: .attribute_id;
427: elim_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY')
421: bal_rule_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
422: .attribute_id;
423: bal_rule_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
424: .version_id;
425: elim_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY')
426: .attribute_id;
427: elim_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY')
428: .version_id;
429: cont_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY')
423: bal_rule_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
424: .version_id;
425: elim_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY')
426: .attribute_id;
427: elim_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY')
428: .version_id;
429: cont_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY')
430: .attribute_id;
431: cont_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY')
425: elim_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY')
426: .attribute_id;
427: elim_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY')
428: .version_id;
429: cont_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY')
430: .attribute_id;
431: cont_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY')
432: .version_id;
433: entity_type_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
427: elim_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY')
428: .version_id;
429: cont_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY')
430: .attribute_id;
431: cont_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY')
432: .version_id;
433: entity_type_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
434: .attribute_id;
435: entity_type_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
429: cont_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY')
430: .attribute_id;
431: cont_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY')
432: .version_id;
433: entity_type_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
434: .attribute_id;
435: entity_type_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
436: .version_id;
437: recon_leaf_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-RECON_LEAF_NODE_FLAG')
431: cont_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY')
432: .version_id;
433: entity_type_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
434: .attribute_id;
435: entity_type_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
436: .version_id;
437: recon_leaf_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-RECON_LEAF_NODE_FLAG')
438: .attribute_id;
439: recon_leaf_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-RECON_LEAF_NODE_FLAG')
433: entity_type_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
434: .attribute_id;
435: entity_type_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
436: .version_id;
437: recon_leaf_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-RECON_LEAF_NODE_FLAG')
438: .attribute_id;
439: recon_leaf_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-RECON_LEAF_NODE_FLAG')
440: .version_id;
441:
435: entity_type_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
436: .version_id;
437: recon_leaf_attr_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-RECON_LEAF_NODE_FLAG')
438: .attribute_id;
439: recon_leaf_v_id := GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-RECON_LEAF_NODE_FLAG')
440: .version_id;
441:
442: user_id := FND_GLOBAL.user_id;
443: login_id := FND_GLOBAL.login_id;