APPS.EGO_IMPORT_PVT dependencies on EGO_IMPORT_EXCLUDED_SS_ITEMS

Line 1737: SELECT NULL FROM EGO_IMPORT_EXCLUDED_SS_ITEMS

1733: )
1734: rnk
1735: , ( SELECT 'Y' FROM DUAL
1736: WHERE EXISTS (
1737: SELECT NULL FROM EGO_IMPORT_EXCLUDED_SS_ITEMS
1738: WHERE SOURCE_SYSTEM_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
1739: AND SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
1740: )
1741: )

Line 7132: FROM EGO_IMPORT_EXCLUDED_SS_ITEMS

7128: AND PROCESS_FLAG = 0
7129: AND ORGANIZATION_ID = l_org_id
7130: AND EXISTS
7131: ( SELECT NULL
7132: FROM EGO_IMPORT_EXCLUDED_SS_ITEMS
7133: WHERE SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
7134: AND SOURCE_SYSTEM_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
7135: );
7136:

Line 7183: FROM EGO_IMPORT_EXCLUDED_SS_ITEMS

7179: AND PROCESS_FLAG = 0
7180: AND ORGANIZATION_ID = l_org_id
7181: AND EXISTS
7182: ( SELECT NULL
7183: FROM EGO_IMPORT_EXCLUDED_SS_ITEMS
7184: WHERE SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
7185: AND SOURCE_SYSTEM_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
7186: );
7187:

Line 12304: DELETE FROM EGO_IMPORT_EXCLUDED_SS_ITEMS

12300: AND ORGANIZATION_ID = (SELECT ORGANIZATION_id FROM EGO_IMPORT_BATCHES_B WHERE BATCH_ID = p_batch_id)
12301: AND NVL(PROCESS_FLAG, 0) < 1;
12302:
12303: IF l_old_status = G_EXCLUDED THEN
12304: DELETE FROM EGO_IMPORT_EXCLUDED_SS_ITEMS
12305: WHERE SOURCE_SYSTEM_ID = p_source_system_id
12306: AND SOURCE_SYSTEM_REFERENCE = p_source_system_reference;
12307: END IF;
12308:

Line 12310: MERGE INTO EGO_IMPORT_EXCLUDED_SS_ITEMS

12306: AND SOURCE_SYSTEM_REFERENCE = p_source_system_reference;
12307: END IF;
12308:
12309: IF p_new_status = G_EXCLUDED THEN
12310: MERGE INTO EGO_IMPORT_EXCLUDED_SS_ITEMS
12311: USING dual
12312: ON (SOURCE_SYSTEM_ID = p_source_system_id AND SOURCE_SYSTEM_REFERENCE = p_source_system_reference)
12313: WHEN matched THEN
12314: UPDATE SET LAST_UPDATED_BY = FND_GLOBAL.USER_ID, LAST_UPDATE_DATE = SYSDATE,