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

Line 162: , last_updated_by = arp_standard.profile.user_id

158: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
159: UPDATE IEX_SCORE_HISTORIES yt SET
160: SCORE_OBJECT_ID = NUM_COL1_NEW_LIST(I)
161: , LAST_UPDATE_DATE = SYSDATE
162: , last_updated_by = arp_standard.profile.user_id
163: , last_update_login = arp_standard.profile.last_update_login
164: , REQUEST_ID = req_id
165: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
166: , PROGRAM_ID = arp_standard.profile.program_id

Line 163: , last_update_login = arp_standard.profile.last_update_login

159: UPDATE IEX_SCORE_HISTORIES yt SET
160: SCORE_OBJECT_ID = NUM_COL1_NEW_LIST(I)
161: , LAST_UPDATE_DATE = SYSDATE
162: , last_updated_by = arp_standard.profile.user_id
163: , last_update_login = arp_standard.profile.last_update_login
164: , REQUEST_ID = req_id
165: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
166: , PROGRAM_ID = arp_standard.profile.program_id
167: , PROGRAM_UPDATE_DATE = SYSDATE

Line 165: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

161: , LAST_UPDATE_DATE = SYSDATE
162: , last_updated_by = arp_standard.profile.user_id
163: , last_update_login = arp_standard.profile.last_update_login
164: , REQUEST_ID = req_id
165: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
166: , PROGRAM_ID = arp_standard.profile.program_id
167: , PROGRAM_UPDATE_DATE = SYSDATE
168: WHERE SCORE_HISTORY_ID=PRIMARY_KEY_ID_LIST(I);
169: l_count := l_count + SQL%ROWCOUNT;

Line 166: , PROGRAM_ID = arp_standard.profile.program_id

162: , last_updated_by = arp_standard.profile.user_id
163: , last_update_login = arp_standard.profile.last_update_login
164: , REQUEST_ID = req_id
165: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
166: , PROGRAM_ID = arp_standard.profile.program_id
167: , PROGRAM_UPDATE_DATE = SYSDATE
168: WHERE SCORE_HISTORY_ID=PRIMARY_KEY_ID_LIST(I);
169: l_count := l_count + SQL%ROWCOUNT;
170: IF l_last_fetch THEN

Line 247: , last_updated_by = arp_standard.profile.user_id

243: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
244: UPDATE IEX_SCORE_HISTORIES yt SET
245: SCORE_OBJECT_ID = NUM_COL2_NEW_LIST(I)
246: , LAST_UPDATE_DATE = SYSDATE
247: , last_updated_by = arp_standard.profile.user_id
248: , last_update_login = arp_standard.profile.last_update_login
249: , REQUEST_ID = req_id
250: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
251: , PROGRAM_ID = arp_standard.profile.program_id

Line 248: , last_update_login = arp_standard.profile.last_update_login

244: UPDATE IEX_SCORE_HISTORIES yt SET
245: SCORE_OBJECT_ID = NUM_COL2_NEW_LIST(I)
246: , LAST_UPDATE_DATE = SYSDATE
247: , last_updated_by = arp_standard.profile.user_id
248: , last_update_login = arp_standard.profile.last_update_login
249: , REQUEST_ID = req_id
250: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
251: , PROGRAM_ID = arp_standard.profile.program_id
252: , PROGRAM_UPDATE_DATE = SYSDATE

Line 250: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

246: , LAST_UPDATE_DATE = SYSDATE
247: , last_updated_by = arp_standard.profile.user_id
248: , last_update_login = arp_standard.profile.last_update_login
249: , REQUEST_ID = req_id
250: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
251: , PROGRAM_ID = arp_standard.profile.program_id
252: , PROGRAM_UPDATE_DATE = SYSDATE
253: WHERE SCORE_HISTORY_ID=PRIMARY_KEY_ID_LIST(I);
254: l_count := l_count + SQL%ROWCOUNT;

Line 251: , PROGRAM_ID = arp_standard.profile.program_id

247: , last_updated_by = arp_standard.profile.user_id
248: , last_update_login = arp_standard.profile.last_update_login
249: , REQUEST_ID = req_id
250: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
251: , PROGRAM_ID = arp_standard.profile.program_id
252: , PROGRAM_UPDATE_DATE = SYSDATE
253: WHERE SCORE_HISTORY_ID=PRIMARY_KEY_ID_LIST(I);
254: l_count := l_count + SQL%ROWCOUNT;
255: IF l_last_fetch THEN

Line 328: , last_updated_by = arp_standard.profile.user_id

324: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
325: UPDATE IEX_SCORE_HISTORIES yt SET
326: SCORE_OBJECT_ID = NUM_COL3_NEW_LIST(I)
327: , LAST_UPDATE_DATE = SYSDATE
328: , last_updated_by = arp_standard.profile.user_id
329: , last_update_login = arp_standard.profile.last_update_login
330: , REQUEST_ID = req_id
331: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
332: , PROGRAM_ID = arp_standard.profile.program_id

Line 329: , last_update_login = arp_standard.profile.last_update_login

325: UPDATE IEX_SCORE_HISTORIES yt SET
326: SCORE_OBJECT_ID = NUM_COL3_NEW_LIST(I)
327: , LAST_UPDATE_DATE = SYSDATE
328: , last_updated_by = arp_standard.profile.user_id
329: , last_update_login = arp_standard.profile.last_update_login
330: , REQUEST_ID = req_id
331: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
332: , PROGRAM_ID = arp_standard.profile.program_id
333: , PROGRAM_UPDATE_DATE = SYSDATE

Line 331: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

327: , LAST_UPDATE_DATE = SYSDATE
328: , last_updated_by = arp_standard.profile.user_id
329: , last_update_login = arp_standard.profile.last_update_login
330: , REQUEST_ID = req_id
331: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
332: , PROGRAM_ID = arp_standard.profile.program_id
333: , PROGRAM_UPDATE_DATE = SYSDATE
334: WHERE SCORE_HISTORY_ID=PRIMARY_KEY_ID_LIST(I);
335: l_count := l_count + SQL%ROWCOUNT;

Line 332: , PROGRAM_ID = arp_standard.profile.program_id

328: , last_updated_by = arp_standard.profile.user_id
329: , last_update_login = arp_standard.profile.last_update_login
330: , REQUEST_ID = req_id
331: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
332: , PROGRAM_ID = arp_standard.profile.program_id
333: , PROGRAM_UPDATE_DATE = SYSDATE
334: WHERE SCORE_HISTORY_ID=PRIMARY_KEY_ID_LIST(I);
335: l_count := l_count + SQL%ROWCOUNT;
336: IF l_last_fetch THEN

Line 493: , last_updated_by = arp_standard.profile.user_id

489: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
490: UPDATE IEX_DUNNINGS yt SET
491: DUNNING_OBJECT_ID = NUM_COL1_NEW_LIST(I)
492: , LAST_UPDATE_DATE = SYSDATE
493: , last_updated_by = arp_standard.profile.user_id
494: , last_update_login = arp_standard.profile.last_update_login
495: , REQUEST_ID = req_id
496: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
497: , PROGRAM_ID = arp_standard.profile.program_id

Line 494: , last_update_login = arp_standard.profile.last_update_login

490: UPDATE IEX_DUNNINGS yt SET
491: DUNNING_OBJECT_ID = NUM_COL1_NEW_LIST(I)
492: , LAST_UPDATE_DATE = SYSDATE
493: , last_updated_by = arp_standard.profile.user_id
494: , last_update_login = arp_standard.profile.last_update_login
495: , REQUEST_ID = req_id
496: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
497: , PROGRAM_ID = arp_standard.profile.program_id
498: , PROGRAM_UPDATE_DATE = SYSDATE

Line 496: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

492: , LAST_UPDATE_DATE = SYSDATE
493: , last_updated_by = arp_standard.profile.user_id
494: , last_update_login = arp_standard.profile.last_update_login
495: , REQUEST_ID = req_id
496: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
497: , PROGRAM_ID = arp_standard.profile.program_id
498: , PROGRAM_UPDATE_DATE = SYSDATE
499: WHERE DUNNING_OBJECT_ID=PRIMARY_KEY_ID_LIST(I);
500: l_count := l_count + SQL%ROWCOUNT;

Line 497: , PROGRAM_ID = arp_standard.profile.program_id

493: , last_updated_by = arp_standard.profile.user_id
494: , last_update_login = arp_standard.profile.last_update_login
495: , REQUEST_ID = req_id
496: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
497: , PROGRAM_ID = arp_standard.profile.program_id
498: , PROGRAM_UPDATE_DATE = SYSDATE
499: WHERE DUNNING_OBJECT_ID=PRIMARY_KEY_ID_LIST(I);
500: l_count := l_count + SQL%ROWCOUNT;
501: IF l_last_fetch THEN

Line 580: , last_updated_by = arp_standard.profile.user_id

576: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
577: UPDATE IEX_DUNNINGS yt SET
578: DUNNING_OBJECT_ID = NUM_COL2_NEW_LIST(I)
579: , LAST_UPDATE_DATE = SYSDATE
580: , last_updated_by = arp_standard.profile.user_id
581: , last_update_login = arp_standard.profile.last_update_login
582: , REQUEST_ID = req_id
583: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
584: , PROGRAM_ID = arp_standard.profile.program_id

Line 581: , last_update_login = arp_standard.profile.last_update_login

577: UPDATE IEX_DUNNINGS yt SET
578: DUNNING_OBJECT_ID = NUM_COL2_NEW_LIST(I)
579: , LAST_UPDATE_DATE = SYSDATE
580: , last_updated_by = arp_standard.profile.user_id
581: , last_update_login = arp_standard.profile.last_update_login
582: , REQUEST_ID = req_id
583: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
584: , PROGRAM_ID = arp_standard.profile.program_id
585: , PROGRAM_UPDATE_DATE = SYSDATE

Line 583: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

579: , LAST_UPDATE_DATE = SYSDATE
580: , last_updated_by = arp_standard.profile.user_id
581: , last_update_login = arp_standard.profile.last_update_login
582: , REQUEST_ID = req_id
583: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
584: , PROGRAM_ID = arp_standard.profile.program_id
585: , PROGRAM_UPDATE_DATE = SYSDATE
586: WHERE DUNNING_ID=PRIMARY_KEY_ID_LIST(I);
587: l_count := l_count + SQL%ROWCOUNT;

Line 584: , PROGRAM_ID = arp_standard.profile.program_id

580: , last_updated_by = arp_standard.profile.user_id
581: , last_update_login = arp_standard.profile.last_update_login
582: , REQUEST_ID = req_id
583: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
584: , PROGRAM_ID = arp_standard.profile.program_id
585: , PROGRAM_UPDATE_DATE = SYSDATE
586: WHERE DUNNING_ID=PRIMARY_KEY_ID_LIST(I);
587: l_count := l_count + SQL%ROWCOUNT;
588: IF l_last_fetch THEN

Line 784: , last_updated_by = arp_standard.profile.user_id

780: UPDATE IEX_STRATEGIES yt SET
781: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
782: , PARTY_ID = PARTY_ID_LIST(I)
783: , LAST_UPDATE_DATE = SYSDATE
784: , last_updated_by = arp_standard.profile.user_id
785: , last_update_login = arp_standard.profile.last_update_login
786: , REQUEST_ID = req_id
787: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
788: , PROGRAM_ID = arp_standard.profile.program_id

Line 785: , last_update_login = arp_standard.profile.last_update_login

781: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
782: , PARTY_ID = PARTY_ID_LIST(I)
783: , LAST_UPDATE_DATE = SYSDATE
784: , last_updated_by = arp_standard.profile.user_id
785: , last_update_login = arp_standard.profile.last_update_login
786: , REQUEST_ID = req_id
787: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
788: , PROGRAM_ID = arp_standard.profile.program_id
789: , PROGRAM_UPDATE_DATE = SYSDATE

Line 787: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

783: , LAST_UPDATE_DATE = SYSDATE
784: , last_updated_by = arp_standard.profile.user_id
785: , last_update_login = arp_standard.profile.last_update_login
786: , REQUEST_ID = req_id
787: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
788: , PROGRAM_ID = arp_standard.profile.program_id
789: , PROGRAM_UPDATE_DATE = SYSDATE
790: WHERE STRATEGY_ID=PRIMARY_KEY_ID_LIST(I);
791: l_count := l_count + SQL%ROWCOUNT;

Line 788: , PROGRAM_ID = arp_standard.profile.program_id

784: , last_updated_by = arp_standard.profile.user_id
785: , last_update_login = arp_standard.profile.last_update_login
786: , REQUEST_ID = req_id
787: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
788: , PROGRAM_ID = arp_standard.profile.program_id
789: , PROGRAM_UPDATE_DATE = SYSDATE
790: WHERE STRATEGY_ID=PRIMARY_KEY_ID_LIST(I);
791: l_count := l_count + SQL%ROWCOUNT;
792: IF l_last_fetch THEN

Line 873: , last_updated_by = arp_standard.profile.user_id

869: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
870: UPDATE IEX_STRATEGIES yt SET
871: JTF_OBJECT_ID = NUM_COL2_NEW_LIST(I)
872: , LAST_UPDATE_DATE = SYSDATE
873: , last_updated_by = arp_standard.profile.user_id
874: , last_update_login = arp_standard.profile.last_update_login
875: , REQUEST_ID = req_id
876: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
877: , PROGRAM_ID = arp_standard.profile.program_id

Line 874: , last_update_login = arp_standard.profile.last_update_login

870: UPDATE IEX_STRATEGIES yt SET
871: JTF_OBJECT_ID = NUM_COL2_NEW_LIST(I)
872: , LAST_UPDATE_DATE = SYSDATE
873: , last_updated_by = arp_standard.profile.user_id
874: , last_update_login = arp_standard.profile.last_update_login
875: , REQUEST_ID = req_id
876: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
877: , PROGRAM_ID = arp_standard.profile.program_id
878: , PROGRAM_UPDATE_DATE = SYSDATE

Line 876: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

872: , LAST_UPDATE_DATE = SYSDATE
873: , last_updated_by = arp_standard.profile.user_id
874: , last_update_login = arp_standard.profile.last_update_login
875: , REQUEST_ID = req_id
876: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
877: , PROGRAM_ID = arp_standard.profile.program_id
878: , PROGRAM_UPDATE_DATE = SYSDATE
879: WHERE STRATEGY_ID=PRIMARY_KEY_ID_LIST(I);
880: l_count := l_count + SQL%ROWCOUNT;

Line 877: , PROGRAM_ID = arp_standard.profile.program_id

873: , last_updated_by = arp_standard.profile.user_id
874: , last_update_login = arp_standard.profile.last_update_login
875: , REQUEST_ID = req_id
876: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
877: , PROGRAM_ID = arp_standard.profile.program_id
878: , PROGRAM_UPDATE_DATE = SYSDATE
879: WHERE STRATEGY_ID=PRIMARY_KEY_ID_LIST(I);
880: l_count := l_count + SQL%ROWCOUNT;
881: -- Begin Bug #6652858 bibeura 11-Dec-2007

Line 971: , last_updated_by = arp_standard.profile.user_id

967: -- CUST_ACCOUNT_ID = NUM_COL3_NEW_LIST(I) Updated for bug#6974531 by schekuri on 14-Aug-2008
968: JTF_OBJECT_ID = NUM_COL3_NEW_LIST(I)
969: , CUSTOMER_SITE_USE_ID = NUM_COL3_NEW_LIST(I)
970: , LAST_UPDATE_DATE = SYSDATE
971: , last_updated_by = arp_standard.profile.user_id
972: , last_update_login = arp_standard.profile.last_update_login
973: , REQUEST_ID = req_id
974: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
975: , PROGRAM_ID = arp_standard.profile.program_id

Line 972: , last_update_login = arp_standard.profile.last_update_login

968: JTF_OBJECT_ID = NUM_COL3_NEW_LIST(I)
969: , CUSTOMER_SITE_USE_ID = NUM_COL3_NEW_LIST(I)
970: , LAST_UPDATE_DATE = SYSDATE
971: , last_updated_by = arp_standard.profile.user_id
972: , last_update_login = arp_standard.profile.last_update_login
973: , REQUEST_ID = req_id
974: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
975: , PROGRAM_ID = arp_standard.profile.program_id
976: , PROGRAM_UPDATE_DATE = SYSDATE

Line 974: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

970: , LAST_UPDATE_DATE = SYSDATE
971: , last_updated_by = arp_standard.profile.user_id
972: , last_update_login = arp_standard.profile.last_update_login
973: , REQUEST_ID = req_id
974: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
975: , PROGRAM_ID = arp_standard.profile.program_id
976: , PROGRAM_UPDATE_DATE = SYSDATE
977: WHERE STRATEGY_ID = PRIMARY_KEY_ID_LIST(I);
978: l_count := l_count + SQL%ROWCOUNT;

Line 975: , PROGRAM_ID = arp_standard.profile.program_id

971: , last_updated_by = arp_standard.profile.user_id
972: , last_update_login = arp_standard.profile.last_update_login
973: , REQUEST_ID = req_id
974: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
975: , PROGRAM_ID = arp_standard.profile.program_id
976: , PROGRAM_UPDATE_DATE = SYSDATE
977: WHERE STRATEGY_ID = PRIMARY_KEY_ID_LIST(I);
978: l_count := l_count + SQL%ROWCOUNT;
979: -- Begin Bug #6652858 bibeura 11-Dec-2007

Line 1107: , last_updated_by = arp_standard.profile.user_id

1103: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1104: UPDATE IEX_PROMISE_DETAILS yt SET
1105: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
1106: , LAST_UPDATE_DATE = SYSDATE
1107: , last_updated_by = arp_standard.profile.user_id
1108: , last_update_login = arp_standard.profile.last_update_login
1109: , REQUEST_ID = req_id
1110: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1111: , PROGRAM_ID = arp_standard.profile.program_id

Line 1108: , last_update_login = arp_standard.profile.last_update_login

1104: UPDATE IEX_PROMISE_DETAILS yt SET
1105: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
1106: , LAST_UPDATE_DATE = SYSDATE
1107: , last_updated_by = arp_standard.profile.user_id
1108: , last_update_login = arp_standard.profile.last_update_login
1109: , REQUEST_ID = req_id
1110: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1111: , PROGRAM_ID = arp_standard.profile.program_id
1112: , PROGRAM_UPDATE_DATE = SYSDATE

Line 1110: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

1106: , LAST_UPDATE_DATE = SYSDATE
1107: , last_updated_by = arp_standard.profile.user_id
1108: , last_update_login = arp_standard.profile.last_update_login
1109: , REQUEST_ID = req_id
1110: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1111: , PROGRAM_ID = arp_standard.profile.program_id
1112: , PROGRAM_UPDATE_DATE = SYSDATE
1113: WHERE PROMISE_DETAIL_ID=PRIMARY_KEY_ID_LIST(I);
1114: l_count := l_count + SQL%ROWCOUNT;

Line 1111: , PROGRAM_ID = arp_standard.profile.program_id

1107: , last_updated_by = arp_standard.profile.user_id
1108: , last_update_login = arp_standard.profile.last_update_login
1109: , REQUEST_ID = req_id
1110: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1111: , PROGRAM_ID = arp_standard.profile.program_id
1112: , PROGRAM_UPDATE_DATE = SYSDATE
1113: WHERE PROMISE_DETAIL_ID=PRIMARY_KEY_ID_LIST(I);
1114: l_count := l_count + SQL%ROWCOUNT;
1115: IF l_last_fetch THEN

Line 1310: , last_updated_by = arp_standard.profile.user_id

1306: UPDATE IEX_DELINQUENCIES_ALL yt SET
1307: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
1308: , PARTY_CUST_ID = PARTY_LIST(I)
1309: , LAST_UPDATE_DATE = SYSDATE
1310: , last_updated_by = arp_standard.profile.user_id
1311: , last_update_login = arp_standard.profile.last_update_login
1312: , REQUEST_ID = req_id
1313: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1314: , PROGRAM_ID = arp_standard.profile.program_id

Line 1311: , last_update_login = arp_standard.profile.last_update_login

1307: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
1308: , PARTY_CUST_ID = PARTY_LIST(I)
1309: , LAST_UPDATE_DATE = SYSDATE
1310: , last_updated_by = arp_standard.profile.user_id
1311: , last_update_login = arp_standard.profile.last_update_login
1312: , REQUEST_ID = req_id
1313: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1314: , PROGRAM_ID = arp_standard.profile.program_id
1315: , PROGRAM_UPDATE_DATE = SYSDATE

Line 1313: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

1309: , LAST_UPDATE_DATE = SYSDATE
1310: , last_updated_by = arp_standard.profile.user_id
1311: , last_update_login = arp_standard.profile.last_update_login
1312: , REQUEST_ID = req_id
1313: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1314: , PROGRAM_ID = arp_standard.profile.program_id
1315: , PROGRAM_UPDATE_DATE = SYSDATE
1316: WHERE DELINQUENCY_ID=PRIMARY_KEY_ID_LIST(I);
1317: l_count := l_count + SQL%ROWCOUNT;

Line 1314: , PROGRAM_ID = arp_standard.profile.program_id

1310: , last_updated_by = arp_standard.profile.user_id
1311: , last_update_login = arp_standard.profile.last_update_login
1312: , REQUEST_ID = req_id
1313: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1314: , PROGRAM_ID = arp_standard.profile.program_id
1315: , PROGRAM_UPDATE_DATE = SYSDATE
1316: WHERE DELINQUENCY_ID=PRIMARY_KEY_ID_LIST(I);
1317: l_count := l_count + SQL%ROWCOUNT;
1318: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1423: , last_updated_by = arp_standard.profile.user_id

1419: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1420: UPDATE IEX_DELINQUENCIES_ALL yt SET
1421: CUSTOMER_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
1422: , LAST_UPDATE_DATE = SYSDATE
1423: , last_updated_by = arp_standard.profile.user_id
1424: , last_update_login = arp_standard.profile.last_update_login
1425: , REQUEST_ID = req_id
1426: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1427: , PROGRAM_ID = arp_standard.profile.program_id

Line 1424: , last_update_login = arp_standard.profile.last_update_login

1420: UPDATE IEX_DELINQUENCIES_ALL yt SET
1421: CUSTOMER_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
1422: , LAST_UPDATE_DATE = SYSDATE
1423: , last_updated_by = arp_standard.profile.user_id
1424: , last_update_login = arp_standard.profile.last_update_login
1425: , REQUEST_ID = req_id
1426: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1427: , PROGRAM_ID = arp_standard.profile.program_id
1428: , PROGRAM_UPDATE_DATE = SYSDATE

Line 1426: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

1422: , LAST_UPDATE_DATE = SYSDATE
1423: , last_updated_by = arp_standard.profile.user_id
1424: , last_update_login = arp_standard.profile.last_update_login
1425: , REQUEST_ID = req_id
1426: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1427: , PROGRAM_ID = arp_standard.profile.program_id
1428: , PROGRAM_UPDATE_DATE = SYSDATE
1429: WHERE DELINQUENCY_ID=PRIMARY_KEY_ID_LIST(I);
1430: l_count := l_count + SQL%ROWCOUNT;

Line 1427: , PROGRAM_ID = arp_standard.profile.program_id

1423: , last_updated_by = arp_standard.profile.user_id
1424: , last_update_login = arp_standard.profile.last_update_login
1425: , REQUEST_ID = req_id
1426: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1427: , PROGRAM_ID = arp_standard.profile.program_id
1428: , PROGRAM_UPDATE_DATE = SYSDATE
1429: WHERE DELINQUENCY_ID=PRIMARY_KEY_ID_LIST(I);
1430: l_count := l_count + SQL%ROWCOUNT;
1431: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN