DBA Data[Home] [Help]

APPS.EGO_ITEM_ASSOCIATIONS_PUB dependencies on EGO_COMMON_PVT

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

2171: l_default_option_code := G_ASSIGN_STYLE_SUP_SUPSITE;
2172: ELSIF ( G_DATA_LEVEL_NAMES(I) = G_ITEM_SUP_SITE_ORG_LEVEL_NAME ) THEN
2173: l_data_level_id := G_ITEM_SUPPLIERSITE_ORG_LEVEL;
2174: l_default_option_code := G_ASSIGN_STYLE_SS_ORG;
2175: IF ego_common_pvt.get_option_value(l_default_option_code) = 'Y' THEN
2176: INSERT INTO ego_item_associations_intf
2177: (
2178: BATCH_ID
2179: ,ORGANIZATION_ID

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

2248: AND NVL(eia2.pk2_value,-1) = NVL(eia.pk2_value,-1)
2249: );
2250: END IF;
2251: END IF;
2252: --dbms_output.put_line(' Defaulting option ' || ego_common_pvt.get_option_value(l_default_option_code) );
2253: IF ego_common_pvt.get_option_value(l_default_option_code) = 'Y' THEN
2254: INSERT INTO ego_item_associations_intf
2255: (
2256: BATCH_ID

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

2249: );
2250: END IF;
2251: END IF;
2252: --dbms_output.put_line(' Defaulting option ' || ego_common_pvt.get_option_value(l_default_option_code) );
2253: IF ego_common_pvt.get_option_value(l_default_option_code) = 'Y' THEN
2254: INSERT INTO ego_item_associations_intf
2255: (
2256: BATCH_ID
2257: ,ORGANIZATION_ID

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

2531: ELSIF ( G_DATA_LEVEL_NAMES(I) = G_ITEM_SUP_SITE_ORG_LEVEL_NAME ) THEN
2532: l_data_level_id := G_ITEM_SUPPLIERSITE_ORG_LEVEL;
2533: l_default_option_code := G_ASSIGN_PACK_SS_ORG;
2534: END IF;
2535: --dbms_output.put_line(' Defaulting option ' || ego_common_pvt.get_option_value(l_default_option_code) );
2536: FOR l_pack_rec IN l_pack_item_csr(p_batch_id)
2537: LOOP
2538: bom_exploder_pub.exploder_userexit(
2539: org_id => l_pack_rec.organization_id,

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

2563: ELSIF ( G_DATA_LEVEL_NAMES(I) = G_ITEM_SUP_SITE_ORG_LEVEL_NAME ) THEN
2564: l_data_level_id := G_ITEM_SUPPLIERSITE_ORG_LEVEL;
2565: l_default_option_code := G_ASSIGN_PACK_SS_ORG;
2566: END IF;
2567: IF ego_common_pvt.get_option_value(l_default_option_code) = 'Y' THEN
2568: INSERT INTO ego_item_associations_intf
2569: (
2570: BATCH_ID
2571: ,SOURCE_SYSTEM_REFERENCE