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.JTF_TASK_CUST_MERGE_PKG dependencies on STANDARD

Line 183: , last_updated_by=arp_standard.profile.user_id

179: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
180: UPDATE JTF_TASKS_B yt SET
181: cust_account_id=NUM_COL1_NEW_LIST(I)
182: , LAST_UPDATE_DATE=SYSDATE
183: , last_updated_by=arp_standard.profile.user_id
184: , last_update_login=arp_standard.profile.last_update_login
185: WHERE task_id=PRIMARY_KEY_ID_LIST(I);
186:
187: l_count := l_count + SQL%ROWCOUNT;

Line 184: , last_update_login=arp_standard.profile.last_update_login

180: UPDATE JTF_TASKS_B yt SET
181: cust_account_id=NUM_COL1_NEW_LIST(I)
182: , LAST_UPDATE_DATE=SYSDATE
183: , last_updated_by=arp_standard.profile.user_id
184: , last_update_login=arp_standard.profile.last_update_login
185: WHERE task_id=PRIMARY_KEY_ID_LIST(I);
186:
187: l_count := l_count + SQL%ROWCOUNT;
188: IF l_last_fetch THEN

Line 323: , last_updated_by=arp_standard.profile.user_id

319: UPDATE JTF_TASK_AUDITS_B yt SET
320: old_cust_account_id=NUM_COL1_NEW_LIST(I)
321: , new_cust_account_id=NUM_COL2_NEW_LIST(I)
322: , LAST_UPDATE_DATE=SYSDATE
323: , last_updated_by=arp_standard.profile.user_id
324: , last_update_login=arp_standard.profile.last_update_login
325: WHERE task_audit_id=PRIMARY_KEY_ID_LIST(I)
326: ;
327: l_count := l_count + SQL%ROWCOUNT;

Line 324: , last_update_login=arp_standard.profile.last_update_login

320: old_cust_account_id=NUM_COL1_NEW_LIST(I)
321: , new_cust_account_id=NUM_COL2_NEW_LIST(I)
322: , LAST_UPDATE_DATE=SYSDATE
323: , last_updated_by=arp_standard.profile.user_id
324: , last_update_login=arp_standard.profile.last_update_login
325: WHERE task_audit_id=PRIMARY_KEY_ID_LIST(I)
326: ;
327: l_count := l_count + SQL%ROWCOUNT;
328: IF l_last_fetch THEN

Line 500: , last_updated_by=arp_standard.profile.user_id

496: -- Update account id
497: UPDATE JTF_PERZ_QUERY_PARAM yt SET
498: PARAMETER_VALUE=VCHAR_COL1_NEW_LIST(I)
499: , LAST_UPDATE_DATE=SYSDATE
500: , last_updated_by=arp_standard.profile.user_id
501: , last_update_login=arp_standard.profile.last_update_login
502: WHERE QUERY_PARAM_ID=PRIMARY_KEY_ID1_LIST(I);
503: l_count := l_count + SQL%ROWCOUNT;
504:

Line 501: , last_update_login=arp_standard.profile.last_update_login

497: UPDATE JTF_PERZ_QUERY_PARAM yt SET
498: PARAMETER_VALUE=VCHAR_COL1_NEW_LIST(I)
499: , LAST_UPDATE_DATE=SYSDATE
500: , last_updated_by=arp_standard.profile.user_id
501: , last_update_login=arp_standard.profile.last_update_login
502: WHERE QUERY_PARAM_ID=PRIMARY_KEY_ID1_LIST(I);
503: l_count := l_count + SQL%ROWCOUNT;
504:
505: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 510: , last_updated_by=arp_standard.profile.user_id

506: -- Update account number
507: UPDATE JTF_PERZ_QUERY_PARAM yt SET
508: PARAMETER_VALUE=VCHAR_CN_NEW_LIST(I)
509: , LAST_UPDATE_DATE=SYSDATE
510: , last_updated_by=arp_standard.profile.user_id
511: , last_update_login=arp_standard.profile.last_update_login
512: WHERE QUERY_PARAM_ID=PRIMARY_KEY_ID2_LIST(I);
513: l_count := l_count + SQL%ROWCOUNT;
514:

Line 511: , last_update_login=arp_standard.profile.last_update_login

507: UPDATE JTF_PERZ_QUERY_PARAM yt SET
508: PARAMETER_VALUE=VCHAR_CN_NEW_LIST(I)
509: , LAST_UPDATE_DATE=SYSDATE
510: , last_updated_by=arp_standard.profile.user_id
511: , last_update_login=arp_standard.profile.last_update_login
512: WHERE QUERY_PARAM_ID=PRIMARY_KEY_ID2_LIST(I);
513: l_count := l_count + SQL%ROWCOUNT;
514:
515: IF l_last_fetch THEN