DBA Data[Home] [Help]

APPS.LNS_MERGE_PKG dependencies on STANDARD

Line 252: , last_updated_by=arp_standard.profile.user_id

248: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
249: UPDATE LNS_LOAN_HEADERS yt SET
250: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
251: , LAST_UPDATE_DATE=SYSDATE
252: , last_updated_by=arp_standard.profile.user_id
253: , last_update_login=arp_standard.profile.last_update_login
254: , REQUEST_ID=req_id
255: , PROGRAM_ID=arp_standard.profile.program_id
256: WHERE LOAN_ID=PRIMARY_KEY_ID1_LIST(I);

Line 253: , last_update_login=arp_standard.profile.last_update_login

249: UPDATE LNS_LOAN_HEADERS yt SET
250: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
251: , LAST_UPDATE_DATE=SYSDATE
252: , last_updated_by=arp_standard.profile.user_id
253: , last_update_login=arp_standard.profile.last_update_login
254: , REQUEST_ID=req_id
255: , PROGRAM_ID=arp_standard.profile.program_id
256: WHERE LOAN_ID=PRIMARY_KEY_ID1_LIST(I);
257:

Line 255: , PROGRAM_ID=arp_standard.profile.program_id

251: , LAST_UPDATE_DATE=SYSDATE
252: , last_updated_by=arp_standard.profile.user_id
253: , last_update_login=arp_standard.profile.last_update_login
254: , REQUEST_ID=req_id
255: , PROGRAM_ID=arp_standard.profile.program_id
256: WHERE LOAN_ID=PRIMARY_KEY_ID1_LIST(I);
257:
258: l_count := l_count + SQL%ROWCOUNT;
259: IF l_last_fetch THEN

Line 381: , last_updated_by=arp_standard.profile.user_id

377: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
378: UPDATE LNS_PARTICIPANTS yt SET
379: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
380: , LAST_UPDATE_DATE=SYSDATE
381: , last_updated_by=arp_standard.profile.user_id
382: , last_update_login=arp_standard.profile.last_update_login
383: WHERE PARTICIPANT_ID=PRIMARY_KEY_ID1_LIST(I);
384:
385: l_count := l_count + SQL%ROWCOUNT;

Line 382: , last_update_login=arp_standard.profile.last_update_login

378: UPDATE LNS_PARTICIPANTS yt SET
379: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
380: , LAST_UPDATE_DATE=SYSDATE
381: , last_updated_by=arp_standard.profile.user_id
382: , last_update_login=arp_standard.profile.last_update_login
383: WHERE PARTICIPANT_ID=PRIMARY_KEY_ID1_LIST(I);
384:
385: l_count := l_count + SQL%ROWCOUNT;
386: IF l_last_fetch THEN