APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_IMPORT_COPY_OPTIONS

Line 490: FROM EGO_IMPORT_COPY_OPTIONS

486: END LOOP;
487:
488: SELECT TEMPLATE_ID
489: BULK COLLECT INTO l_template_table
490: FROM EGO_IMPORT_COPY_OPTIONS
491: WHERE BATCH_ID = p_batch_id
492: AND COPY_OPTION = 'APPLY_TEMPLATE'
493: ORDER BY TEMPLATE_SEQUENCE DESC;
494:

Line 788: EGO_IMPORT_COPY_OPTIONS eico,

784: SELECT
785: edlb.DATA_LEVEL_ID,
786: edlb.DATA_LEVEL_NAME
787: FROM
788: EGO_IMPORT_COPY_OPTIONS eico,
789: EGO_DATA_LEVEL_B edlb,
790: EGO_FND_DSC_FLX_CTX_EXT ag_ext
791: WHERE eico.COPY_OPTION LIKE 'COPY_ATTR_GROUP%'
792: AND eico.BATCH_ID = p_batch_id

Line 874: EGO_IMPORT_COPY_OPTIONS eico,

870: msii.TRANSACTION_ID,
871: ext_prod.ATTR_GROUP_ID,
872: ext_prod.EXTENSION_ID, #' || G_PROD_COL_LIST || q'#
873: FROM
874: EGO_IMPORT_COPY_OPTIONS eico,
875: MTL_SYSTEM_ITEMS_INTERFACE msii,
876: EGO_MTL_SY_ITEMS_EXT_VL ext_prod
877: WHERE eico.COPY_OPTION = 'COPY_ATTR_GROUP:#' || i.DATA_LEVEL_NAME || q'#'
878: AND eico.BATCH_ID = #' || p_batch_id || q'#

Line 890: EGO_IMPORT_COPY_OPTIONS eico,

886: l_ag_sql := q'#
887: SELECT
888: ext_prod.ATTR_GROUP_ID
889: FROM
890: EGO_IMPORT_COPY_OPTIONS eico,
891: MTL_SYSTEM_ITEMS_INTERFACE msii,
892: EGO_MTL_SY_ITEMS_EXT_VL ext_prod
893: WHERE eico.COPY_OPTION = 'COPY_ATTR_GROUP:#' || i.DATA_LEVEL_NAME || q'#'
894: AND eico.BATCH_ID = #' || p_batch_id || q'#

Line 1288: FROM EGO_IMPORT_COPY_OPTIONS

1284: -- get copy options here and depending on the options
1285: -- apply templates, copy, etc.
1286: BEGIN
1287: SELECT NVL(SELECTION_FLAG, 'N') INTO l_copy_first
1288: FROM EGO_IMPORT_COPY_OPTIONS
1289: WHERE BATCH_ID = p_batch_id
1290: AND COPY_OPTION = 'COPY_FIRST';
1291: EXCEPTION
1292: WHEN NO_DATA_FOUND THEN

Line 1412: FROM EGO_IMPORT_COPY_OPTIONS

1408: BEGIN
1409: Debug_Conc_Log('Apply_Templates_For_Items: Starting p_batch_id='||p_batch_id);
1410: SELECT TEMPLATE_ID
1411: BULK COLLECT INTO l_template_table
1412: FROM EGO_IMPORT_COPY_OPTIONS
1413: WHERE BATCH_ID = p_batch_id
1414: AND COPY_OPTION = 'APPLY_TEMPLATE'
1415: ORDER BY TEMPLATE_SEQUENCE DESC;
1416:

Line 1742: FROM EGO_IMPORT_COPY_OPTIONS

1738: -- get copy options here and depending on the options
1739: -- apply templates, copy, etc.
1740: BEGIN
1741: SELECT NVL(SELECTION_FLAG, 'N') INTO l_copy_first
1742: FROM EGO_IMPORT_COPY_OPTIONS
1743: WHERE BATCH_ID = p_batch_id
1744: AND COPY_OPTION = 'COPY_FIRST';
1745: EXCEPTION
1746: WHEN NO_DATA_FOUND THEN

Line 1838: FROM EGO_IMPORT_COPY_OPTIONS

1834:
1835: -- copying organization assignments
1836: BEGIN
1837: SELECT NVL(SELECTION_FLAG, 'N') INTO l_copy_org
1838: FROM EGO_IMPORT_COPY_OPTIONS
1839: WHERE BATCH_ID = p_batch_id
1840: AND COPY_OPTION = 'COPY_ORG_ASSIGNMENTS';
1841: EXCEPTION
1842: WHEN NO_DATA_FOUND THEN

Line 1898: FROM EGO_IMPORT_COPY_OPTIONS

1894:
1895: -- copying category assignments
1896: BEGIN
1897: SELECT NVL(SELECTION_FLAG, 'N') INTO l_copy_cat
1898: FROM EGO_IMPORT_COPY_OPTIONS
1899: WHERE BATCH_ID = p_batch_id
1900: --AND REQUEST_ID = l_request_id
1901: AND COPY_OPTION = 'COPY_CAT_ASSIGNMENTS';
1902: EXCEPTION

Line 1928: FROM EGO_IMPORT_COPY_OPTIONS

1924: l_copy_sup_site := 'N';
1925: l_copy_sup_site_org := 'N';
1926: l_cntr := 1;
1927: FOR i IN ( SELECT COPY_OPTION, NVL(SELECTION_FLAG, 'N') SELECTION_FLAG
1928: FROM EGO_IMPORT_COPY_OPTIONS
1929: WHERE BATCH_ID = p_batch_id
1930: AND COPY_OPTION IN ('COPY_SUPPLIER_ASSIGNMENTS',
1931: 'COPY_SUPPLIER_SITE_ASSIGNMENTS',
1932: 'COPY_SUPPLIER_SITE_ORG_ASSIGNMENTS')

Line 4010: FROM EGO_IMPORT_COPY_OPTIONS

4006: -- either SKU creation, Multiple item creation, Multiple
4007: -- copy item, multiple packaging hierarchy flow
4008: BEGIN
4009: SELECT 'Y' INTO l_copy_option_exists
4010: FROM EGO_IMPORT_COPY_OPTIONS
4011: WHERE BATCH_ID = p_batch_id
4012: AND ROWNUM = 1;
4013: EXCEPTION
4014: WHEN NO_DATA_FOUND THEN

Line 4747: FROM EGO_IMPORT_COPY_OPTIONS

4743:
4744: Debug_Conc_Log('Default_Item_People: Style to SKU copy option value-'||l_def_style_people_option);
4745: BEGIN
4746: SELECT SELECTION_FLAG INTO l_copy_people_option
4747: FROM EGO_IMPORT_COPY_OPTIONS
4748: WHERE BATCH_ID = p_batch_id
4749: AND COPY_OPTION = 'COPY_PEOPLE'
4750: AND ROWNUM = 1;
4751: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 5350: INSERT INTO ego_import_copy_options

5346:
5347: END IF;
5348:
5349: IF l_error = 0 THEN
5350: INSERT INTO ego_import_copy_options
5351: ( batch_id,
5352: copy_option,
5353: template_id,
5354: template_sequence,

Line 6098: FROM EGO_IMPORT_COPY_OPTIONS

6094: p_batch_id IN NUMBER )
6095: IS
6096: CURSOR attach_id_cur IS
6097: SELECT DISTINCT ATTACH_CATEGORY_ID
6098: FROM EGO_IMPORT_COPY_OPTIONS
6099: WHERE COPY_OPTION = 'COPY_ATTCH_CATEGORY'
6100: AND BATCH_ID = p_batch_id;
6101:
6102: CURSOR interface_items_cur IS