APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_IMPORT_COPY_OPTIONS

Line 546: FROM EGO_IMPORT_COPY_OPTIONS

542: END LOOP;
543:
544: SELECT TEMPLATE_ID
545: BULK COLLECT INTO l_template_table
546: FROM EGO_IMPORT_COPY_OPTIONS
547: WHERE BATCH_ID = p_batch_id
548: AND COPY_OPTION = 'APPLY_TEMPLATE'
549: ORDER BY TEMPLATE_SEQUENCE DESC;
550:

Line 889: EGO_IMPORT_COPY_OPTIONS eico,

885: SELECT
886: edlb.DATA_LEVEL_ID,
887: edlb.DATA_LEVEL_NAME
888: FROM
889: EGO_IMPORT_COPY_OPTIONS eico,
890: EGO_DATA_LEVEL_B edlb,
891: EGO_FND_DSC_FLX_CTX_EXT ag_ext
892: WHERE eico.COPY_OPTION LIKE 'COPY_ATTR_GROUP%'
893: AND eico.BATCH_ID = p_batch_id

Line 975: EGO_IMPORT_COPY_OPTIONS eico,

971: msii.TRANSACTION_ID,
972: ext_prod.ATTR_GROUP_ID,
973: ext_prod.EXTENSION_ID, #' || G_PROD_COL_LIST || q'#
974: FROM
975: EGO_IMPORT_COPY_OPTIONS eico,
976: MTL_SYSTEM_ITEMS_INTERFACE msii,
977: EGO_MTL_SY_ITEMS_EXT_VL ext_prod
978: WHERE eico.COPY_OPTION = 'COPY_ATTR_GROUP:#' || i.DATA_LEVEL_NAME || q'#'
979: AND eico.BATCH_ID = #' || p_batch_id || q'#

Line 991: EGO_IMPORT_COPY_OPTIONS eico,

987: l_ag_sql := q'#
988: SELECT
989: ext_prod.ATTR_GROUP_ID
990: FROM
991: EGO_IMPORT_COPY_OPTIONS eico,
992: MTL_SYSTEM_ITEMS_INTERFACE msii,
993: EGO_MTL_SY_ITEMS_EXT_VL ext_prod
994: WHERE eico.COPY_OPTION = 'COPY_ATTR_GROUP:#' || i.DATA_LEVEL_NAME || q'#'
995: AND eico.BATCH_ID = #' || p_batch_id || q'#

Line 1445: FROM EGO_IMPORT_COPY_OPTIONS

1441: -- get copy options here and depending on the options
1442: -- apply templates, copy, etc.
1443: BEGIN
1444: SELECT NVL(SELECTION_FLAG, 'N') INTO l_copy_first
1445: FROM EGO_IMPORT_COPY_OPTIONS
1446: WHERE BATCH_ID = p_batch_id
1447: AND COPY_OPTION = 'COPY_FIRST';
1448: EXCEPTION
1449: WHEN NO_DATA_FOUND THEN

Line 1582: FROM EGO_IMPORT_COPY_OPTIONS

1578: BEGIN
1579: Debug_Conc_Log('Apply_Templates_For_Items: Starting p_batch_id='||p_batch_id);
1580: SELECT TEMPLATE_ID
1581: BULK COLLECT INTO l_template_table
1582: FROM EGO_IMPORT_COPY_OPTIONS
1583: WHERE BATCH_ID = p_batch_id
1584: AND COPY_OPTION = 'APPLY_TEMPLATE'
1585: ORDER BY TEMPLATE_SEQUENCE DESC;
1586:

Line 1912: FROM EGO_IMPORT_COPY_OPTIONS

1908: -- get copy options here and depending on the options
1909: -- apply templates, copy, etc.
1910: BEGIN
1911: SELECT NVL(SELECTION_FLAG, 'N') INTO l_copy_first
1912: FROM EGO_IMPORT_COPY_OPTIONS
1913: WHERE BATCH_ID = p_batch_id
1914: AND COPY_OPTION = 'COPY_FIRST';
1915: EXCEPTION
1916: WHEN NO_DATA_FOUND THEN

Line 2008: FROM EGO_IMPORT_COPY_OPTIONS

2004:
2005: -- copying organization assignments
2006: BEGIN
2007: SELECT NVL(SELECTION_FLAG, 'N') INTO l_copy_org
2008: FROM EGO_IMPORT_COPY_OPTIONS
2009: WHERE BATCH_ID = p_batch_id
2010: AND COPY_OPTION = 'COPY_ORG_ASSIGNMENTS';
2011: EXCEPTION
2012: WHEN NO_DATA_FOUND THEN

Line 2068: FROM EGO_IMPORT_COPY_OPTIONS

2064:
2065: -- copying category assignments
2066: BEGIN
2067: SELECT NVL(SELECTION_FLAG, 'N') INTO l_copy_cat
2068: FROM EGO_IMPORT_COPY_OPTIONS
2069: WHERE BATCH_ID = p_batch_id
2070: --AND REQUEST_ID = l_request_id
2071: AND COPY_OPTION = 'COPY_CAT_ASSIGNMENTS';
2072: EXCEPTION

Line 2098: FROM EGO_IMPORT_COPY_OPTIONS

2094: l_copy_sup_site := 'N';
2095: l_copy_sup_site_org := 'N';
2096: l_cntr := 1;
2097: FOR i IN ( SELECT COPY_OPTION, NVL(SELECTION_FLAG, 'N') SELECTION_FLAG
2098: FROM EGO_IMPORT_COPY_OPTIONS
2099: WHERE BATCH_ID = p_batch_id
2100: AND COPY_OPTION IN ('COPY_SUPPLIER_ASSIGNMENTS',
2101: 'COPY_SUPPLIER_SITE_ASSIGNMENTS',
2102: 'COPY_SUPPLIER_SITE_ORG_ASSIGNMENTS')

Line 4645: FROM EGO_IMPORT_COPY_OPTIONS

4641: -- either SKU creation, Multiple item creation, Multiple
4642: -- copy item, multiple packaging hierarchy flow
4643: BEGIN
4644: SELECT 'Y' INTO l_copy_option_exists
4645: FROM EGO_IMPORT_COPY_OPTIONS
4646: WHERE BATCH_ID = l_batch_id -- bug 12693246 changed from p_batch_id to l_batch_id
4647: AND ROWNUM = 1;
4648: EXCEPTION
4649: WHEN NO_DATA_FOUND THEN

Line 5497: FROM EGO_IMPORT_COPY_OPTIONS

5493:
5494: Debug_Conc_Log('Default_Item_People: Style to SKU copy option value-'||l_def_style_people_option);
5495: BEGIN
5496: SELECT SELECTION_FLAG INTO l_copy_people_option
5497: FROM EGO_IMPORT_COPY_OPTIONS
5498: WHERE BATCH_ID = p_batch_id
5499: AND COPY_OPTION = 'COPY_PEOPLE'
5500: AND ROWNUM = 1;
5501: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 6134: INSERT INTO ego_import_copy_options

6130:
6131: END IF;
6132:
6133: IF l_error = 0 THEN
6134: INSERT INTO ego_import_copy_options
6135: ( batch_id,
6136: copy_option,
6137: template_id,
6138: template_sequence,

Line 6882: FROM EGO_IMPORT_COPY_OPTIONS

6878: p_batch_id IN NUMBER )
6879: IS
6880: CURSOR attach_id_cur IS
6881: SELECT DISTINCT ATTACH_CATEGORY_ID
6882: FROM EGO_IMPORT_COPY_OPTIONS
6883: WHERE COPY_OPTION = 'COPY_ATTCH_CATEGORY'
6884: AND BATCH_ID = p_batch_id;
6885:
6886: CURSOR interface_items_cur IS