DBA Data[Home] [Help]

APPS.EGO_ITEM_ASSOCIATIONS_PUB dependencies on EGO_COMMON_PVT

Line 2243: IF ego_common_pvt.get_option_value(l_default_option_code) = 'Y' THEN

2239: l_default_option_code := G_ASSIGN_STYLE_SUP_SUPSITE;
2240: ELSIF ( G_DATA_LEVEL_NAMES(I) = G_ITEM_SUP_SITE_ORG_LEVEL_NAME ) THEN
2241: l_data_level_id := G_ITEM_SUPPLIERSITE_ORG_LEVEL;
2242: l_default_option_code := G_ASSIGN_STYLE_SS_ORG;
2243: IF ego_common_pvt.get_option_value(l_default_option_code) = 'Y' THEN
2244: INSERT INTO ego_item_associations_intf
2245: (
2246: BATCH_ID
2247: ,ORGANIZATION_ID

Line 2320: --dbms_output.put_line(' Defaulting option ' || ego_common_pvt.get_option_value(l_default_option_code) );

2316: AND NVL(eia2.pk2_value,-1) = NVL(eia.pk2_value,-1)
2317: );
2318: END IF;
2319: END IF;
2320: --dbms_output.put_line(' Defaulting option ' || ego_common_pvt.get_option_value(l_default_option_code) );
2321: IF ego_common_pvt.get_option_value(l_default_option_code) = 'Y' THEN
2322: INSERT INTO ego_item_associations_intf
2323: (
2324: BATCH_ID

Line 2321: IF ego_common_pvt.get_option_value(l_default_option_code) = 'Y' THEN

2317: );
2318: END IF;
2319: END IF;
2320: --dbms_output.put_line(' Defaulting option ' || ego_common_pvt.get_option_value(l_default_option_code) );
2321: IF ego_common_pvt.get_option_value(l_default_option_code) = 'Y' THEN
2322: INSERT INTO ego_item_associations_intf
2323: (
2324: BATCH_ID
2325: ,ORGANIZATION_ID

Line 2603: --dbms_output.put_line(' Defaulting option ' || ego_common_pvt.get_option_value(l_default_option_code) );

2599: ELSIF ( G_DATA_LEVEL_NAMES(I) = G_ITEM_SUP_SITE_ORG_LEVEL_NAME ) THEN
2600: l_data_level_id := G_ITEM_SUPPLIERSITE_ORG_LEVEL;
2601: l_default_option_code := G_ASSIGN_PACK_SS_ORG;
2602: END IF;
2603: --dbms_output.put_line(' Defaulting option ' || ego_common_pvt.get_option_value(l_default_option_code) );
2604: FOR l_pack_rec IN l_pack_item_csr(p_batch_id)
2605: LOOP
2606: bom_exploder_pub.exploder_userexit(
2607: org_id => l_pack_rec.organization_id,

Line 2635: IF ego_common_pvt.get_option_value(l_default_option_code) = 'Y' THEN

2631: ELSIF ( G_DATA_LEVEL_NAMES(I) = G_ITEM_SUP_SITE_ORG_LEVEL_NAME ) THEN
2632: l_data_level_id := G_ITEM_SUPPLIERSITE_ORG_LEVEL;
2633: l_default_option_code := G_ASSIGN_PACK_SS_ORG;
2634: END IF;
2635: IF ego_common_pvt.get_option_value(l_default_option_code) = 'Y' THEN
2636: INSERT INTO ego_item_associations_intf
2637: (
2638: BATCH_ID
2639: ,SOURCE_SYSTEM_REFERENCE