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 ARP_STANDARD

Line 170: , last_updated_by = arp_standard.profile.user_id

166:
167: UPDATE IEX_SCORE_HISTORIES yt SET
168: SCORE_OBJECT_ID = NUM_COL1_NEW_LIST(I)
169: , LAST_UPDATE_DATE = SYSDATE
170: , last_updated_by = arp_standard.profile.user_id
171: , last_update_login = arp_standard.profile.last_update_login
172: , REQUEST_ID = req_id
173: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
174: , PROGRAM_ID = arp_standard.profile.program_id

Line 171: , last_update_login = arp_standard.profile.last_update_login

167: UPDATE IEX_SCORE_HISTORIES yt SET
168: SCORE_OBJECT_ID = NUM_COL1_NEW_LIST(I)
169: , LAST_UPDATE_DATE = SYSDATE
170: , last_updated_by = arp_standard.profile.user_id
171: , last_update_login = arp_standard.profile.last_update_login
172: , REQUEST_ID = req_id
173: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
174: , PROGRAM_ID = arp_standard.profile.program_id
175: , PROGRAM_UPDATE_DATE = SYSDATE

Line 173: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

169: , LAST_UPDATE_DATE = SYSDATE
170: , last_updated_by = arp_standard.profile.user_id
171: , last_update_login = arp_standard.profile.last_update_login
172: , REQUEST_ID = req_id
173: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
174: , PROGRAM_ID = arp_standard.profile.program_id
175: , PROGRAM_UPDATE_DATE = SYSDATE
176: WHERE SCORE_HISTORY_ID=PRIMARY_KEY_ID_LIST(I);
177: l_count := l_count + SQL%ROWCOUNT;

Line 174: , PROGRAM_ID = arp_standard.profile.program_id

170: , last_updated_by = arp_standard.profile.user_id
171: , last_update_login = arp_standard.profile.last_update_login
172: , REQUEST_ID = req_id
173: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
174: , PROGRAM_ID = arp_standard.profile.program_id
175: , PROGRAM_UPDATE_DATE = SYSDATE
176: WHERE SCORE_HISTORY_ID=PRIMARY_KEY_ID_LIST(I);
177: l_count := l_count + SQL%ROWCOUNT;
178: end if;

Line 263: , last_updated_by = arp_standard.profile.user_id

259: if l_acc_status_cnt = 0 then
260: UPDATE IEX_SCORE_HISTORIES yt SET
261: SCORE_OBJECT_ID = NUM_COL2_NEW_LIST(I)
262: , LAST_UPDATE_DATE = SYSDATE
263: , last_updated_by = arp_standard.profile.user_id
264: , last_update_login = arp_standard.profile.last_update_login
265: , REQUEST_ID = req_id
266: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
267: , PROGRAM_ID = arp_standard.profile.program_id

Line 264: , last_update_login = arp_standard.profile.last_update_login

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

Line 266: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

262: , LAST_UPDATE_DATE = SYSDATE
263: , last_updated_by = arp_standard.profile.user_id
264: , last_update_login = arp_standard.profile.last_update_login
265: , REQUEST_ID = req_id
266: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
267: , PROGRAM_ID = arp_standard.profile.program_id
268: , PROGRAM_UPDATE_DATE = SYSDATE
269: WHERE SCORE_HISTORY_ID=PRIMARY_KEY_ID_LIST(I);
270: l_count := l_count + SQL%ROWCOUNT;

Line 267: , PROGRAM_ID = arp_standard.profile.program_id

263: , last_updated_by = arp_standard.profile.user_id
264: , last_update_login = arp_standard.profile.last_update_login
265: , REQUEST_ID = req_id
266: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
267: , PROGRAM_ID = arp_standard.profile.program_id
268: , PROGRAM_UPDATE_DATE = SYSDATE
269: WHERE SCORE_HISTORY_ID=PRIMARY_KEY_ID_LIST(I);
270: l_count := l_count + SQL%ROWCOUNT;
271: end if;

Line 352: , last_updated_by = arp_standard.profile.user_id

348: if l_acc_status_cnt = 0 then
349: UPDATE IEX_SCORE_HISTORIES yt SET
350: SCORE_OBJECT_ID = NUM_COL3_NEW_LIST(I)
351: , LAST_UPDATE_DATE = SYSDATE
352: , last_updated_by = arp_standard.profile.user_id
353: , last_update_login = arp_standard.profile.last_update_login
354: , REQUEST_ID = req_id
355: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
356: , PROGRAM_ID = arp_standard.profile.program_id

Line 353: , last_update_login = arp_standard.profile.last_update_login

349: UPDATE IEX_SCORE_HISTORIES yt SET
350: SCORE_OBJECT_ID = NUM_COL3_NEW_LIST(I)
351: , LAST_UPDATE_DATE = SYSDATE
352: , last_updated_by = arp_standard.profile.user_id
353: , last_update_login = arp_standard.profile.last_update_login
354: , REQUEST_ID = req_id
355: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
356: , PROGRAM_ID = arp_standard.profile.program_id
357: , PROGRAM_UPDATE_DATE = SYSDATE

Line 355: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

351: , LAST_UPDATE_DATE = SYSDATE
352: , last_updated_by = arp_standard.profile.user_id
353: , last_update_login = arp_standard.profile.last_update_login
354: , REQUEST_ID = req_id
355: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
356: , PROGRAM_ID = arp_standard.profile.program_id
357: , PROGRAM_UPDATE_DATE = SYSDATE
358: WHERE SCORE_HISTORY_ID=PRIMARY_KEY_ID_LIST(I);
359: l_count := l_count + SQL%ROWCOUNT;

Line 356: , PROGRAM_ID = arp_standard.profile.program_id

352: , last_updated_by = arp_standard.profile.user_id
353: , last_update_login = arp_standard.profile.last_update_login
354: , REQUEST_ID = req_id
355: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
356: , PROGRAM_ID = arp_standard.profile.program_id
357: , PROGRAM_UPDATE_DATE = SYSDATE
358: WHERE SCORE_HISTORY_ID=PRIMARY_KEY_ID_LIST(I);
359: l_count := l_count + SQL%ROWCOUNT;
360: end if;

Line 546: , last_updated_by = arp_standard.profile.user_id

542: if l_acc_status_cnt = 0 then
543: UPDATE IEX_DUNNINGS yt SET
544: DUNNING_OBJECT_ID = NUM_COL1_NEW_LIST(I)
545: , LAST_UPDATE_DATE = SYSDATE
546: , last_updated_by = arp_standard.profile.user_id
547: , last_update_login = arp_standard.profile.last_update_login
548: , REQUEST_ID = req_id
549: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
550: , PROGRAM_ID = arp_standard.profile.program_id

Line 547: , last_update_login = arp_standard.profile.last_update_login

543: UPDATE IEX_DUNNINGS yt SET
544: DUNNING_OBJECT_ID = NUM_COL1_NEW_LIST(I)
545: , LAST_UPDATE_DATE = SYSDATE
546: , last_updated_by = arp_standard.profile.user_id
547: , last_update_login = arp_standard.profile.last_update_login
548: , REQUEST_ID = req_id
549: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
550: , PROGRAM_ID = arp_standard.profile.program_id
551: , PROGRAM_UPDATE_DATE = SYSDATE

Line 549: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

545: , LAST_UPDATE_DATE = SYSDATE
546: , last_updated_by = arp_standard.profile.user_id
547: , last_update_login = arp_standard.profile.last_update_login
548: , REQUEST_ID = req_id
549: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
550: , PROGRAM_ID = arp_standard.profile.program_id
551: , PROGRAM_UPDATE_DATE = SYSDATE
552: WHERE DUNNING_ID=PRIMARY_KEY_ID_LIST(I);
553: -- WHERE DUNNING_OBJECT_ID=PRIMARY_KEY_ID_LIST(I); commented to fix 12746719 on 7/26/2011 by snuthala

Line 550: , PROGRAM_ID = arp_standard.profile.program_id

546: , last_updated_by = arp_standard.profile.user_id
547: , last_update_login = arp_standard.profile.last_update_login
548: , REQUEST_ID = req_id
549: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
550: , PROGRAM_ID = arp_standard.profile.program_id
551: , PROGRAM_UPDATE_DATE = SYSDATE
552: WHERE DUNNING_ID=PRIMARY_KEY_ID_LIST(I);
553: -- WHERE DUNNING_OBJECT_ID=PRIMARY_KEY_ID_LIST(I); commented to fix 12746719 on 7/26/2011 by snuthala
554:

Line 653: , last_updated_by = arp_standard.profile.user_id

649: if l_acc_status_cnt = 0 then
650: UPDATE IEX_DUNNINGS yt SET
651: DUNNING_OBJECT_ID = NUM_COL2_NEW_LIST(I)
652: , LAST_UPDATE_DATE = SYSDATE
653: , last_updated_by = arp_standard.profile.user_id
654: , last_update_login = arp_standard.profile.last_update_login
655: , REQUEST_ID = req_id
656: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
657: , PROGRAM_ID = arp_standard.profile.program_id

Line 654: , last_update_login = arp_standard.profile.last_update_login

650: UPDATE IEX_DUNNINGS yt SET
651: DUNNING_OBJECT_ID = NUM_COL2_NEW_LIST(I)
652: , LAST_UPDATE_DATE = SYSDATE
653: , last_updated_by = arp_standard.profile.user_id
654: , last_update_login = arp_standard.profile.last_update_login
655: , REQUEST_ID = req_id
656: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
657: , PROGRAM_ID = arp_standard.profile.program_id
658: , PROGRAM_UPDATE_DATE = SYSDATE

Line 656: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

652: , LAST_UPDATE_DATE = SYSDATE
653: , last_updated_by = arp_standard.profile.user_id
654: , last_update_login = arp_standard.profile.last_update_login
655: , REQUEST_ID = req_id
656: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
657: , PROGRAM_ID = arp_standard.profile.program_id
658: , PROGRAM_UPDATE_DATE = SYSDATE
659: WHERE DUNNING_ID=PRIMARY_KEY_ID_LIST(I);
660: l_count := l_count + SQL%ROWCOUNT;

Line 657: , PROGRAM_ID = arp_standard.profile.program_id

653: , last_updated_by = arp_standard.profile.user_id
654: , last_update_login = arp_standard.profile.last_update_login
655: , REQUEST_ID = req_id
656: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
657: , PROGRAM_ID = arp_standard.profile.program_id
658: , PROGRAM_UPDATE_DATE = SYSDATE
659: WHERE DUNNING_ID=PRIMARY_KEY_ID_LIST(I);
660: l_count := l_count + SQL%ROWCOUNT;
661: end if;

Line 871: , last_updated_by = arp_standard.profile.user_id

867: UPDATE IEX_STRATEGIES yt SET
868: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
869: , PARTY_ID = PARTY_ID_LIST(I)
870: , LAST_UPDATE_DATE = SYSDATE
871: , last_updated_by = arp_standard.profile.user_id
872: , last_update_login = arp_standard.profile.last_update_login
873: , REQUEST_ID = req_id
874: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
875: , PROGRAM_ID = arp_standard.profile.program_id

Line 872: , last_update_login = arp_standard.profile.last_update_login

868: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
869: , PARTY_ID = PARTY_ID_LIST(I)
870: , LAST_UPDATE_DATE = SYSDATE
871: , last_updated_by = arp_standard.profile.user_id
872: , last_update_login = arp_standard.profile.last_update_login
873: , REQUEST_ID = req_id
874: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
875: , PROGRAM_ID = arp_standard.profile.program_id
876: , PROGRAM_UPDATE_DATE = SYSDATE

Line 874: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

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

Line 875: , PROGRAM_ID = arp_standard.profile.program_id

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

Line 969: , last_updated_by = arp_standard.profile.user_id

965:
966: UPDATE IEX_STRATEGIES yt SET
967: JTF_OBJECT_ID = NUM_COL2_NEW_LIST(I)
968: , LAST_UPDATE_DATE = SYSDATE
969: , last_updated_by = arp_standard.profile.user_id
970: , last_update_login = arp_standard.profile.last_update_login
971: , REQUEST_ID = req_id
972: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
973: , PROGRAM_ID = arp_standard.profile.program_id

Line 970: , last_update_login = arp_standard.profile.last_update_login

966: UPDATE IEX_STRATEGIES yt SET
967: JTF_OBJECT_ID = NUM_COL2_NEW_LIST(I)
968: , LAST_UPDATE_DATE = SYSDATE
969: , last_updated_by = arp_standard.profile.user_id
970: , last_update_login = arp_standard.profile.last_update_login
971: , REQUEST_ID = req_id
972: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
973: , PROGRAM_ID = arp_standard.profile.program_id
974: , PROGRAM_UPDATE_DATE = SYSDATE

Line 972: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

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

Line 973: , PROGRAM_ID = arp_standard.profile.program_id

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

Line 1080: , last_updated_by = arp_standard.profile.user_id

1076: -- CUST_ACCOUNT_ID = NUM_COL3_NEW_LIST(I) Updated for bug#6974531 by schekuri on 14-Aug-2008
1077: JTF_OBJECT_ID = NUM_COL3_NEW_LIST(I)
1078: , CUSTOMER_SITE_USE_ID = NUM_COL3_NEW_LIST(I)
1079: , LAST_UPDATE_DATE = SYSDATE
1080: , last_updated_by = arp_standard.profile.user_id
1081: , last_update_login = arp_standard.profile.last_update_login
1082: , REQUEST_ID = req_id
1083: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1084: , PROGRAM_ID = arp_standard.profile.program_id

Line 1081: , last_update_login = arp_standard.profile.last_update_login

1077: JTF_OBJECT_ID = NUM_COL3_NEW_LIST(I)
1078: , CUSTOMER_SITE_USE_ID = NUM_COL3_NEW_LIST(I)
1079: , LAST_UPDATE_DATE = SYSDATE
1080: , last_updated_by = arp_standard.profile.user_id
1081: , last_update_login = arp_standard.profile.last_update_login
1082: , REQUEST_ID = req_id
1083: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1084: , PROGRAM_ID = arp_standard.profile.program_id
1085: , PROGRAM_UPDATE_DATE = SYSDATE

Line 1083: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

1079: , LAST_UPDATE_DATE = SYSDATE
1080: , last_updated_by = arp_standard.profile.user_id
1081: , last_update_login = arp_standard.profile.last_update_login
1082: , REQUEST_ID = req_id
1083: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1084: , PROGRAM_ID = arp_standard.profile.program_id
1085: , PROGRAM_UPDATE_DATE = SYSDATE
1086: WHERE STRATEGY_ID = PRIMARY_KEY_ID_LIST(I);
1087: l_count := l_count + SQL%ROWCOUNT;

Line 1084: , PROGRAM_ID = arp_standard.profile.program_id

1080: , last_updated_by = arp_standard.profile.user_id
1081: , last_update_login = arp_standard.profile.last_update_login
1082: , REQUEST_ID = req_id
1083: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1084: , PROGRAM_ID = arp_standard.profile.program_id
1085: , PROGRAM_UPDATE_DATE = SYSDATE
1086: WHERE STRATEGY_ID = PRIMARY_KEY_ID_LIST(I);
1087: l_count := l_count + SQL%ROWCOUNT;
1088: end if;

Line 1224: , last_updated_by = arp_standard.profile.user_id

1220: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1221: UPDATE IEX_PROMISE_DETAILS yt SET
1222: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
1223: , LAST_UPDATE_DATE = SYSDATE
1224: , last_updated_by = arp_standard.profile.user_id
1225: , last_update_login = arp_standard.profile.last_update_login
1226: , REQUEST_ID = req_id
1227: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1228: , PROGRAM_ID = arp_standard.profile.program_id

Line 1225: , last_update_login = arp_standard.profile.last_update_login

1221: UPDATE IEX_PROMISE_DETAILS yt SET
1222: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
1223: , LAST_UPDATE_DATE = SYSDATE
1224: , last_updated_by = arp_standard.profile.user_id
1225: , last_update_login = arp_standard.profile.last_update_login
1226: , REQUEST_ID = req_id
1227: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1228: , PROGRAM_ID = arp_standard.profile.program_id
1229: , PROGRAM_UPDATE_DATE = SYSDATE

Line 1227: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

1223: , LAST_UPDATE_DATE = SYSDATE
1224: , last_updated_by = arp_standard.profile.user_id
1225: , last_update_login = arp_standard.profile.last_update_login
1226: , REQUEST_ID = req_id
1227: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1228: , PROGRAM_ID = arp_standard.profile.program_id
1229: , PROGRAM_UPDATE_DATE = SYSDATE
1230: WHERE PROMISE_DETAIL_ID=PRIMARY_KEY_ID_LIST(I);
1231: l_count := l_count + SQL%ROWCOUNT;

Line 1228: , PROGRAM_ID = arp_standard.profile.program_id

1224: , last_updated_by = arp_standard.profile.user_id
1225: , last_update_login = arp_standard.profile.last_update_login
1226: , REQUEST_ID = req_id
1227: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1228: , PROGRAM_ID = arp_standard.profile.program_id
1229: , PROGRAM_UPDATE_DATE = SYSDATE
1230: WHERE PROMISE_DETAIL_ID=PRIMARY_KEY_ID_LIST(I);
1231: l_count := l_count + SQL%ROWCOUNT;
1232: IF l_last_fetch THEN

Line 1432: , last_updated_by = arp_standard.profile.user_id

1428: UPDATE IEX_DELINQUENCIES_ALL yt SET
1429: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
1430: , PARTY_CUST_ID = PARTY_LIST(I)
1431: , LAST_UPDATE_DATE = SYSDATE
1432: , last_updated_by = arp_standard.profile.user_id
1433: , last_update_login = arp_standard.profile.last_update_login
1434: , REQUEST_ID = req_id
1435: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1436: , PROGRAM_ID = arp_standard.profile.program_id

Line 1433: , last_update_login = arp_standard.profile.last_update_login

1429: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
1430: , PARTY_CUST_ID = PARTY_LIST(I)
1431: , LAST_UPDATE_DATE = SYSDATE
1432: , last_updated_by = arp_standard.profile.user_id
1433: , last_update_login = arp_standard.profile.last_update_login
1434: , REQUEST_ID = req_id
1435: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1436: , PROGRAM_ID = arp_standard.profile.program_id
1437: , PROGRAM_UPDATE_DATE = SYSDATE

Line 1435: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

1431: , LAST_UPDATE_DATE = SYSDATE
1432: , last_updated_by = arp_standard.profile.user_id
1433: , last_update_login = arp_standard.profile.last_update_login
1434: , REQUEST_ID = req_id
1435: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1436: , PROGRAM_ID = arp_standard.profile.program_id
1437: , PROGRAM_UPDATE_DATE = SYSDATE
1438: WHERE DELINQUENCY_ID=PRIMARY_KEY_ID_LIST(I);
1439: l_count := l_count + SQL%ROWCOUNT;

Line 1436: , PROGRAM_ID = arp_standard.profile.program_id

1432: , last_updated_by = arp_standard.profile.user_id
1433: , last_update_login = arp_standard.profile.last_update_login
1434: , REQUEST_ID = req_id
1435: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1436: , PROGRAM_ID = arp_standard.profile.program_id
1437: , PROGRAM_UPDATE_DATE = SYSDATE
1438: WHERE DELINQUENCY_ID=PRIMARY_KEY_ID_LIST(I);
1439: l_count := l_count + SQL%ROWCOUNT;
1440: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1545: , last_updated_by = arp_standard.profile.user_id

1541: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1542: UPDATE IEX_DELINQUENCIES_ALL yt SET
1543: CUSTOMER_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
1544: , LAST_UPDATE_DATE = SYSDATE
1545: , last_updated_by = arp_standard.profile.user_id
1546: , last_update_login = arp_standard.profile.last_update_login
1547: , REQUEST_ID = req_id
1548: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1549: , PROGRAM_ID = arp_standard.profile.program_id

Line 1546: , last_update_login = arp_standard.profile.last_update_login

1542: UPDATE IEX_DELINQUENCIES_ALL yt SET
1543: CUSTOMER_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
1544: , LAST_UPDATE_DATE = SYSDATE
1545: , last_updated_by = arp_standard.profile.user_id
1546: , last_update_login = arp_standard.profile.last_update_login
1547: , REQUEST_ID = req_id
1548: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1549: , PROGRAM_ID = arp_standard.profile.program_id
1550: , PROGRAM_UPDATE_DATE = SYSDATE

Line 1548: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id

1544: , LAST_UPDATE_DATE = SYSDATE
1545: , last_updated_by = arp_standard.profile.user_id
1546: , last_update_login = arp_standard.profile.last_update_login
1547: , REQUEST_ID = req_id
1548: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1549: , PROGRAM_ID = arp_standard.profile.program_id
1550: , PROGRAM_UPDATE_DATE = SYSDATE
1551: WHERE DELINQUENCY_ID=PRIMARY_KEY_ID_LIST(I);
1552: l_count := l_count + SQL%ROWCOUNT;

Line 1549: , PROGRAM_ID = arp_standard.profile.program_id

1545: , last_updated_by = arp_standard.profile.user_id
1546: , last_update_login = arp_standard.profile.last_update_login
1547: , REQUEST_ID = req_id
1548: , PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id
1549: , PROGRAM_ID = arp_standard.profile.program_id
1550: , PROGRAM_UPDATE_DATE = SYSDATE
1551: WHERE DELINQUENCY_ID=PRIMARY_KEY_ID_LIST(I);
1552: l_count := l_count + SQL%ROWCOUNT;
1553: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN