eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on EGO_AML_INTF

Line 149: FROM EGO_AML_INTF

145: SELECT
146: ORGANIZATION_ID,
147: TRANSACTION_ID,
148: PROCESS_FLAG
149: FROM EGO_AML_INTF
150: WHERE DATA_SET_ID = p_data_set_id
151: AND PROCESS_FLAG IN (33379, 33389);
152: --R12C:BEGIN
153: CURSOR c_ssxref_null_assocs IS

Line 250: UPDATE EGO_AML_INTF EAI

246: )
247: );
248:
249: -- EAI
250: UPDATE EGO_AML_INTF EAI
251: SET PROCESS_FLAG = (CASE WHEN EAI.SOURCE_SYSTEM_REFERENCE IS NULL THEN 33379 ELSE 33389 END),
252: TRANSACTION_ID = NVL(TRANSACTION_ID, MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
253: PROGRAM_APPLICATION_ID = l_prog_appid,
254: PROGRAM_ID = l_prog_id,

Line 486: ,'EGO_AML_INTF'

482: ,l_request_id
483: ,i.TRANSACTION_ID
484: ,l_msg_text
485: ,'SOURCE_SYSTEM_REFERENCE'
486: ,'EGO_AML_INTF'
487: ,'INV_IOI_ERR'
488: ,l_err_text);
489: ELSIF i.PROCESS_FLAG = 33389 THEN
490: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');

Line 502: ,'EGO_AML_INTF'

498: ,l_request_id
499: ,i.TRANSACTION_ID
500: ,l_msg_text
501: ,'SOURCE_SYSTEM_ID'
502: ,'EGO_AML_INTF'
503: ,'INV_IOI_ERR'
504: ,l_err_text);
505: END IF;
506: END LOOP;

Line 573: UPDATE EGO_AML_INTF

569: SET PROCESS_STATUS =3
570: WHERE PROCESS_STATUS IN (33379, 33389)
571: AND DATA_SET_ID = p_data_set_id;
572:
573: UPDATE EGO_AML_INTF
574: SET PROCESS_FLAG =3
575: WHERE PROCESS_FLAG IN (33379, 33389)
576: AND DATA_SET_ID = p_data_set_id;
577: --R12C: BEGIN

Line 681: -- checking whether stats needs to be collected on EGO_AML_INTF

677: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_PEOPLE_INTF');
678: Debug_Conc_Log('Collected Statistics on EGO_ITEM_PEOPLE_INTF');
679: END IF;
680:
681: -- checking whether stats needs to be collected on EGO_AML_INTF
682: SELECT COUNT(1) INTO l_records
683: FROM EGO_AML_INTF
684: WHERE DATA_SET_ID = p_data_set_id;
685:

Line 683: FROM EGO_AML_INTF

679: END IF;
680:
681: -- checking whether stats needs to be collected on EGO_AML_INTF
682: SELECT COUNT(1) INTO l_records
683: FROM EGO_AML_INTF
684: WHERE DATA_SET_ID = p_data_set_id;
685:
686: IF (l_records > l_stats_profile) AND l_ego_installed AND l_schema IS NOT NULL THEN
687: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_AML_INTF');

Line 687: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_AML_INTF');

683: FROM EGO_AML_INTF
684: WHERE DATA_SET_ID = p_data_set_id;
685:
686: IF (l_records > l_stats_profile) AND l_ego_installed AND l_schema IS NOT NULL THEN
687: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_AML_INTF');
688: Debug_Conc_Log('Collected Statistics on EGO_AML_INTF');
689: END IF;
690:
691: -- checking whether stats needs to be collected on EGO_ITM_USR_ATTR_INTRFC

Line 688: Debug_Conc_Log('Collected Statistics on EGO_AML_INTF');

684: WHERE DATA_SET_ID = p_data_set_id;
685:
686: IF (l_records > l_stats_profile) AND l_ego_installed AND l_schema IS NOT NULL THEN
687: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_AML_INTF');
688: Debug_Conc_Log('Collected Statistics on EGO_AML_INTF');
689: END IF;
690:
691: -- checking whether stats needs to be collected on EGO_ITM_USR_ATTR_INTRFC
692: SELECT COUNT(1) INTO l_records

Line 5750: UPDATE EGO_AML_INTF

5746: AND PROCESS_STATUS = 0
5747: AND SOURCE_SYSTEM_ID = i.SOURCE_SYSTEM_ID
5748: AND SOURCE_SYSTEM_REFERENCE = i.SOURCE_SYSTEM_REFERENCE;
5749:
5750: UPDATE EGO_AML_INTF
5751: SET PROCESS_FLAG = 7,
5752: PROGRAM_APPLICATION_ID = l_prog_appid,
5753: PROGRAM_ID = l_prog_id,
5754: REQUEST_ID = l_request_id,

Line 5814: UPDATE EGO_AML_INTF

5810: AND PROCESS_STATUS = 0
5811: AND SOURCE_SYSTEM_ID = i.SOURCE_SYSTEM_ID
5812: AND SOURCE_SYSTEM_REFERENCE = i.SOURCE_SYSTEM_REFERENCE;
5813:
5814: UPDATE EGO_AML_INTF
5815: SET PROCESS_FLAG = 7,
5816: PROGRAM_APPLICATION_ID = l_prog_appid,
5817: PROGRAM_ID = l_prog_id,
5818: REQUEST_ID = l_request_id,

Line 6524: UPDATE EGO_AML_INTF EAI

6520: WHERE DATA_SET_ID = p_data_set_id AND
6521: (PROCESS_STATUS IS NULL OR PROCESS_STATUS IN (0, 1)) AND
6522: ORGANIZATION_ID IS NULL;
6523:
6524: UPDATE EGO_AML_INTF EAI
6525: SET ORGANIZATION_ID =
6526: CASE
6527: WHEN ORGANIZATION_CODE IS NOT NULL
6528: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EAI.ORGANIZATION_CODE)

Line 6711: UPDATE EGO_AML_INTF EAI

6707: AND PROCESS_STATUS = 1
6708: AND ITEM_NUMBER IS NULL
6709: AND INVENTORY_ITEM_ID IS NOT NULL;
6710:
6711: UPDATE EGO_AML_INTF EAI
6712: SET item_number = (SELECT CONCATENATED_SEGMENTS
6713: FROM MTL_SYSTEM_ITEMS_KFV
6714: WHERE INVENTORY_ITEM_ID = EAI.INVENTORY_ITEM_ID
6715: AND ORGANIZATION_ID = EAI.ORGANIZATION_ID)

Line 6801: FROM EGO_AML_INTF EAI

6797: , l_insert_date -- LAST_UPDATE_DATE
6798: , MAX( EAI.created_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) CREATED_BY
6799: , MAX( EAI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
6800: , MAX( EAI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
6801: FROM EGO_AML_INTF EAI
6802: -- , MTL_PARAMETERS MP
6803: WHERE
6804: EAI.data_set_id = p_data_set_id
6805: AND EAI.process_flag = 1

Line 6951: UPDATE EGO_AML_INTF

6947: SET PROCESS_STATUS = 0
6948: WHERE DATA_SET_ID = p_data_set_id AND
6949: PROCESS_STATUS IS NULL;
6950:
6951: UPDATE EGO_AML_INTF
6952: SET PROCESS_FLAG = 0
6953: WHERE DATA_SET_ID = p_data_set_id AND
6954: PROCESS_FLAG IS NULL;
6955:

Line 7023: FROM EGO_AML_INTF EAI

7019: , l_insert_date -- LAST_UPDATE_DATE
7020: , MAX( EAI.created_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) CREATED_BY
7021: , MAX( EAI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
7022: , MAX( EAI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
7023: FROM EGO_AML_INTF EAI
7024: -- , MTL_PARAMETERS MP
7025: WHERE
7026: EAI.data_set_id = p_data_set_id
7027: AND EAI.process_flag = 0

Line 8825: UPDATE EGO_AML_INTF EAI

8821: AND MSII.ORGANIZATION_ID = l_org_id);
8822:
8823: Debug_Conc_Log('Resolve_Child_Entities - After resolving item people rows' );
8824: -- updating item_number, item_id from MSII table
8825: UPDATE EGO_AML_INTF EAI
8826: SET (PROCESS_FLAG, TRANSACTION_TYPE, INVENTORY_ITEM_ID, ITEM_NUMBER) =
8827: (SELECT
8828: 1,
8829: (CASE

Line 9164: UPDATE EGO_AML_INTF EAI

9160: Debug_Conc_Log('Resolve_Child_Entities - After updating user attrs intf table for items that has XXref');
9161:
9162: -- updating the item AML interface
9163: l_sql := q'#
9164: UPDATE EGO_AML_INTF EAI
9165: SET (PROCESS_FLAG, TRANSACTION_TYPE, INVENTORY_ITEM_ID) =
9166: (SELECT
9167: 1,
9168: NVL(EAI.TRANSACTION_TYPE, 'SYNC'),

Line 9597: UPDATE EGO_AML_INTF

9593: );
9594: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9595:
9596: -- updating item AML
9597: UPDATE EGO_AML_INTF
9598: SET PROCESS_FLAG = 1
9599: WHERE ( INVENTORY_ITEM_ID = l_item_id
9600: OR ( ITEM_NUMBER = l_item_number
9601: AND INVENTORY_ITEM_ID IS NULL

Line 9696: UPDATE EGO_AML_INTF

9692: );
9693: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9694:
9695: -- updating item AML
9696: UPDATE EGO_AML_INTF
9697: SET PROCESS_FLAG = 1
9698: WHERE ITEM_NUMBER = l_item_number
9699: AND PROCESS_FLAG = 3
9700: AND DATA_SET_ID = p_batch_id

Line 9959: UPDATE EGO_AML_INTF

9955: );
9956: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9957:
9958: -- updating item AML
9959: UPDATE EGO_AML_INTF
9960: SET PROCESS_FLAG = 1
9961: WHERE SOURCE_SYSTEM_ID = l_ss_id
9962: AND SOURCE_SYSTEM_REFERENCE = l_ssr
9963: AND PROCESS_FLAG = 3

Line 11912: -- EGO_AML_INTF --

11908: AND SOURCE_SYSTEM_REFERENCE = p_src_system_ref
11909: AND PROCESS_FLAG = 0;
11910:
11911: ------------------
11912: -- EGO_AML_INTF --
11913: ------------------
11914: UPDATE EGO_AML_INTF EAI
11915: SET ORGANIZATION_ID =
11916: NVL(ORGANIZATION_ID,

Line 11914: UPDATE EGO_AML_INTF EAI

11910:
11911: ------------------
11912: -- EGO_AML_INTF --
11913: ------------------
11914: UPDATE EGO_AML_INTF EAI
11915: SET ORGANIZATION_ID =
11916: NVL(ORGANIZATION_ID,
11917: (SELECT MP.ORGANIZATION_ID
11918: FROM MTL_PARAMETERS MP

Line 12588: FROM EGO_AML_INTF eai

12584: THEN 1
12585: ELSE NULL
12586: END
12587: ) UPDATE_CNT
12588: FROM EGO_AML_INTF eai
12589: WHERE eai.DATA_SET_ID = p_set_process_id
12590: AND EXISTS
12591: (
12592: SELECT NULL