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.

APPS.CSC_ACCOUNT_MERGE_PKG dependencies on STANDARD

Line 152: , last_updated_by=arp_standard.profile.user_id

148: UPDATE CSC_CUSTOMERS yt SET
149: cust_account_id=NUM_COL1_NEW_LIST(I)
150: , party_id=NUM_COL2_NEW_LIST(I)
151: , LAST_UPDATE_DATE=SYSDATE
152: , last_updated_by=arp_standard.profile.user_id
153: , last_update_login=arp_standard.profile.last_update_login
154: , REQUEST_ID=req_id
155: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
156: , PROGRAM_ID=arp_standard.profile.program_id

Line 153: , last_update_login=arp_standard.profile.last_update_login

149: cust_account_id=NUM_COL1_NEW_LIST(I)
150: , party_id=NUM_COL2_NEW_LIST(I)
151: , LAST_UPDATE_DATE=SYSDATE
152: , last_updated_by=arp_standard.profile.user_id
153: , last_update_login=arp_standard.profile.last_update_login
154: , REQUEST_ID=req_id
155: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
156: , PROGRAM_ID=arp_standard.profile.program_id
157: , PROGRAM_UPDATE_DATE=SYSDATE

Line 155: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

151: , LAST_UPDATE_DATE=SYSDATE
152: , last_updated_by=arp_standard.profile.user_id
153: , last_update_login=arp_standard.profile.last_update_login
154: , REQUEST_ID=req_id
155: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
156: , PROGRAM_ID=arp_standard.profile.program_id
157: , PROGRAM_UPDATE_DATE=SYSDATE
158: WHERE cust_account_id in ( SELECT m.duplicate_id FROM
159: ra_customer_merges m WHERE

Line 156: , PROGRAM_ID=arp_standard.profile.program_id

152: , last_updated_by=arp_standard.profile.user_id
153: , last_update_login=arp_standard.profile.last_update_login
154: , REQUEST_ID=req_id
155: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
156: , PROGRAM_ID=arp_standard.profile.program_id
157: , PROGRAM_UPDATE_DATE=SYSDATE
158: WHERE cust_account_id in ( SELECT m.duplicate_id FROM
159: ra_customer_merges m WHERE
160: m.process_flag = 'N'

Line 264: , last_updated_by=arp_standard.profile.user_id

260: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
261: UPDATE CSC_CUSTOMERS_AUDIT_HIST yt SET
262: cust_account_id=NUM_COL1_NEW_LIST(I)
263: , LAST_UPDATE_DATE=SYSDATE
264: , last_updated_by=arp_standard.profile.user_id
265: , last_update_login=arp_standard.profile.last_update_login
266: , REQUEST_ID=req_id
267: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
268: , PROGRAM_ID=arp_standard.profile.program_id

Line 265: , last_update_login=arp_standard.profile.last_update_login

261: UPDATE CSC_CUSTOMERS_AUDIT_HIST yt SET
262: cust_account_id=NUM_COL1_NEW_LIST(I)
263: , LAST_UPDATE_DATE=SYSDATE
264: , last_updated_by=arp_standard.profile.user_id
265: , last_update_login=arp_standard.profile.last_update_login
266: , REQUEST_ID=req_id
267: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
268: , PROGRAM_ID=arp_standard.profile.program_id
269: , PROGRAM_UPDATE_DATE=SYSDATE

Line 267: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

263: , LAST_UPDATE_DATE=SYSDATE
264: , last_updated_by=arp_standard.profile.user_id
265: , last_update_login=arp_standard.profile.last_update_login
266: , REQUEST_ID=req_id
267: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
268: , PROGRAM_ID=arp_standard.profile.program_id
269: , PROGRAM_UPDATE_DATE=SYSDATE
270: WHERE cust_account_id in ( SELECT m.duplicate_id FROM
271: ra_customer_merges m WHERE

Line 268: , PROGRAM_ID=arp_standard.profile.program_id

264: , last_updated_by=arp_standard.profile.user_id
265: , last_update_login=arp_standard.profile.last_update_login
266: , REQUEST_ID=req_id
267: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
268: , PROGRAM_ID=arp_standard.profile.program_id
269: , PROGRAM_UPDATE_DATE=SYSDATE
270: WHERE cust_account_id in ( SELECT m.duplicate_id FROM
271: ra_customer_merges m WHERE
272: m.process_flag = 'N'

Line 389: -- , last_updated_by=arp_standard.profile.user_id

385: UPDATE CSC_CUSTOMIZED_PLANS yt SET
386: cust_account_id=NUM_COL1_NEW_LIST(I)
387: , party_id=NUM_COL2_NEW_LIST(I)
388: -- , LAST_UPDATE_DATE=SYSDATE
389: -- , last_updated_by=arp_standard.profile.user_id
390: -- , last_update_login=arp_standard.profile.last_update_login
391: , REQUEST_ID=req_id
392: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
393: , PROGRAM_ID=arp_standard.profile.program_id

Line 390: -- , last_update_login=arp_standard.profile.last_update_login

386: cust_account_id=NUM_COL1_NEW_LIST(I)
387: , party_id=NUM_COL2_NEW_LIST(I)
388: -- , LAST_UPDATE_DATE=SYSDATE
389: -- , last_updated_by=arp_standard.profile.user_id
390: -- , last_update_login=arp_standard.profile.last_update_login
391: , REQUEST_ID=req_id
392: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
393: , PROGRAM_ID=arp_standard.profile.program_id
394: , PROGRAM_UPDATE_DATE=SYSDATE

Line 392: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

388: -- , LAST_UPDATE_DATE=SYSDATE
389: -- , last_updated_by=arp_standard.profile.user_id
390: -- , last_update_login=arp_standard.profile.last_update_login
391: , REQUEST_ID=req_id
392: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
393: , PROGRAM_ID=arp_standard.profile.program_id
394: , PROGRAM_UPDATE_DATE=SYSDATE
395: WHERE cust_account_id in ( SELECT m.duplicate_id FROM
396: ra_customer_merges m WHERE

Line 393: , PROGRAM_ID=arp_standard.profile.program_id

389: -- , last_updated_by=arp_standard.profile.user_id
390: -- , last_update_login=arp_standard.profile.last_update_login
391: , REQUEST_ID=req_id
392: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
393: , PROGRAM_ID=arp_standard.profile.program_id
394: , PROGRAM_UPDATE_DATE=SYSDATE
395: WHERE cust_account_id in ( SELECT m.duplicate_id FROM
396: ra_customer_merges m WHERE
397: m.process_flag = 'N'

Line 523: , last_updated_by=arp_standard.profile.user_id

519: UPDATE CSC_CUST_PLANS yt SET
520: cust_account_id=NUM_COL1_NEW_LIST(I)
521: , party_id=NUM_COL2_NEW_LIST(I)
522: , LAST_UPDATE_DATE=SYSDATE
523: , last_updated_by=arp_standard.profile.user_id
524: , last_update_login=arp_standard.profile.last_update_login
525: , REQUEST_ID=req_id
526: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
527: , PROGRAM_ID=arp_standard.profile.program_id

Line 524: , last_update_login=arp_standard.profile.last_update_login

520: cust_account_id=NUM_COL1_NEW_LIST(I)
521: , party_id=NUM_COL2_NEW_LIST(I)
522: , LAST_UPDATE_DATE=SYSDATE
523: , last_updated_by=arp_standard.profile.user_id
524: , last_update_login=arp_standard.profile.last_update_login
525: , REQUEST_ID=req_id
526: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
527: , PROGRAM_ID=arp_standard.profile.program_id
528: , PROGRAM_UPDATE_DATE=SYSDATE

Line 526: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

522: , LAST_UPDATE_DATE=SYSDATE
523: , last_updated_by=arp_standard.profile.user_id
524: , last_update_login=arp_standard.profile.last_update_login
525: , REQUEST_ID=req_id
526: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
527: , PROGRAM_ID=arp_standard.profile.program_id
528: , PROGRAM_UPDATE_DATE=SYSDATE
529: WHERE cust_account_id in ( SELECT m.duplicate_id FROM
530: ra_customer_merges m WHERE

Line 527: , PROGRAM_ID=arp_standard.profile.program_id

523: , last_updated_by=arp_standard.profile.user_id
524: , last_update_login=arp_standard.profile.last_update_login
525: , REQUEST_ID=req_id
526: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
527: , PROGRAM_ID=arp_standard.profile.program_id
528: , PROGRAM_UPDATE_DATE=SYSDATE
529: WHERE cust_account_id in ( SELECT m.duplicate_id FROM
530: ra_customer_merges m WHERE
531: m.process_flag = 'N'

Line 679: , last_updated_by=arp_standard.profile.user_id

675: UPDATE CSC_CUST_PLANS_AUDIT yt SET
676: cust_account_id=NUM_COL1_NEW_LIST(I)
677: , party_id=NUM_COL2_NEW_LIST(I)
678: , LAST_UPDATE_DATE=SYSDATE
679: , last_updated_by=arp_standard.profile.user_id
680: , last_update_login=arp_standard.profile.last_update_login
681: , REQUEST_ID=req_id
682: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
683: , PROGRAM_ID=arp_standard.profile.program_id

Line 680: , last_update_login=arp_standard.profile.last_update_login

676: cust_account_id=NUM_COL1_NEW_LIST(I)
677: , party_id=NUM_COL2_NEW_LIST(I)
678: , LAST_UPDATE_DATE=SYSDATE
679: , last_updated_by=arp_standard.profile.user_id
680: , last_update_login=arp_standard.profile.last_update_login
681: , REQUEST_ID=req_id
682: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
683: , PROGRAM_ID=arp_standard.profile.program_id
684: , PROGRAM_UPDATE_DATE=SYSDATE

Line 682: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

678: , LAST_UPDATE_DATE=SYSDATE
679: , last_updated_by=arp_standard.profile.user_id
680: , last_update_login=arp_standard.profile.last_update_login
681: , REQUEST_ID=req_id
682: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
683: , PROGRAM_ID=arp_standard.profile.program_id
684: , PROGRAM_UPDATE_DATE=SYSDATE
685: WHERE cust_account_id in ( SELECT m.duplicate_id FROM
686: ra_customer_merges m WHERE

Line 683: , PROGRAM_ID=arp_standard.profile.program_id

679: , last_updated_by=arp_standard.profile.user_id
680: , last_update_login=arp_standard.profile.last_update_login
681: , REQUEST_ID=req_id
682: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
683: , PROGRAM_ID=arp_standard.profile.program_id
684: , PROGRAM_UPDATE_DATE=SYSDATE
685: WHERE cust_account_id in ( SELECT m.duplicate_id FROM
686: ra_customer_merges m WHERE
687: m.process_flag = 'N'