APPS.EGO_IMPORT_PVT dependencies on EGO_IMPORT_EXCLUDED_SS_ITEMS

Line 1771: SELECT NULL FROM EGO_IMPORT_EXCLUDED_SS_ITEMS

1767: )
1768: rnk
1769: , ( SELECT 'Y' FROM DUAL
1770: WHERE EXISTS (
1771: SELECT NULL FROM EGO_IMPORT_EXCLUDED_SS_ITEMS
1772: WHERE SOURCE_SYSTEM_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
1773: AND SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
1774: )
1775: )

Line 7226: FROM EGO_IMPORT_EXCLUDED_SS_ITEMS

7222: AND PROCESS_FLAG = 0
7223: AND ORGANIZATION_ID = l_org_id
7224: AND EXISTS
7225: ( SELECT NULL
7226: FROM EGO_IMPORT_EXCLUDED_SS_ITEMS
7227: WHERE SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
7228: AND SOURCE_SYSTEM_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
7229: );
7230:

Line 7277: FROM EGO_IMPORT_EXCLUDED_SS_ITEMS

7273: AND PROCESS_FLAG = 0
7274: AND ORGANIZATION_ID = l_org_id
7275: AND EXISTS
7276: ( SELECT NULL
7277: FROM EGO_IMPORT_EXCLUDED_SS_ITEMS
7278: WHERE SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
7279: AND SOURCE_SYSTEM_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
7280: );
7281:

Line 12424: DELETE FROM EGO_IMPORT_EXCLUDED_SS_ITEMS

12420: AND ORGANIZATION_ID = (SELECT ORGANIZATION_id FROM EGO_IMPORT_BATCHES_B WHERE BATCH_ID = p_batch_id)
12421: AND NVL(PROCESS_FLAG, 0) < 1;
12422:
12423: IF l_old_status = G_EXCLUDED THEN
12424: DELETE FROM EGO_IMPORT_EXCLUDED_SS_ITEMS
12425: WHERE SOURCE_SYSTEM_ID = p_source_system_id
12426: AND SOURCE_SYSTEM_REFERENCE = p_source_system_reference;
12427: END IF;
12428:

Line 12430: MERGE INTO EGO_IMPORT_EXCLUDED_SS_ITEMS

12426: AND SOURCE_SYSTEM_REFERENCE = p_source_system_reference;
12427: END IF;
12428:
12429: IF p_new_status = G_EXCLUDED THEN
12430: MERGE INTO EGO_IMPORT_EXCLUDED_SS_ITEMS
12431: USING dual
12432: ON (SOURCE_SYSTEM_ID = p_source_system_id AND SOURCE_SYSTEM_REFERENCE = p_source_system_reference)
12433: WHEN matched THEN
12434: UPDATE SET LAST_UPDATED_BY = FND_GLOBAL.USER_ID, LAST_UPDATE_DATE = SYSDATE,