APPS.LNS_MERGE_PKG dependencies on STANDARD

Line 394: , last_updated_by=arp_standard.profile.user_id

390: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
391: UPDATE LNS_LOAN_HEADERS yt SET
392: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
393: , LAST_UPDATE_DATE=SYSDATE
394: , last_updated_by=arp_standard.profile.user_id
395: , last_update_login=arp_standard.profile.last_update_login
396: , REQUEST_ID=req_id
397: , PROGRAM_ID=arp_standard.profile.program_id
398: WHERE LOAN_ID=PRIMARY_KEY_ID1_LIST(I);

Line 395: , last_update_login=arp_standard.profile.last_update_login

391: UPDATE LNS_LOAN_HEADERS yt SET
392: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
393: , LAST_UPDATE_DATE=SYSDATE
394: , last_updated_by=arp_standard.profile.user_id
395: , last_update_login=arp_standard.profile.last_update_login
396: , REQUEST_ID=req_id
397: , PROGRAM_ID=arp_standard.profile.program_id
398: WHERE LOAN_ID=PRIMARY_KEY_ID1_LIST(I);
399:

Line 397: , PROGRAM_ID=arp_standard.profile.program_id

393: , LAST_UPDATE_DATE=SYSDATE
394: , last_updated_by=arp_standard.profile.user_id
395: , last_update_login=arp_standard.profile.last_update_login
396: , REQUEST_ID=req_id
397: , PROGRAM_ID=arp_standard.profile.program_id
398: WHERE LOAN_ID=PRIMARY_KEY_ID1_LIST(I);
399:
400: l_count := l_count + SQL%ROWCOUNT;
401:

Line 488: , last_updated_by=arp_standard.profile.user_id

484: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
485: UPDATE LNS_LOAN_HEADERS yt SET
486: BILL_TO_ACCT_SITE_ID=NUM_COL2_NEW_LIST(I)
487: , LAST_UPDATE_DATE=SYSDATE
488: , last_updated_by=arp_standard.profile.user_id
489: , last_update_login=arp_standard.profile.last_update_login
490: , REQUEST_ID=req_id
491: , PROGRAM_ID=arp_standard.profile.program_id
492: WHERE LOAN_ID=PRIMARY_KEY_ID1_LIST(I);

Line 489: , last_update_login=arp_standard.profile.last_update_login

485: UPDATE LNS_LOAN_HEADERS yt SET
486: BILL_TO_ACCT_SITE_ID=NUM_COL2_NEW_LIST(I)
487: , LAST_UPDATE_DATE=SYSDATE
488: , last_updated_by=arp_standard.profile.user_id
489: , last_update_login=arp_standard.profile.last_update_login
490: , REQUEST_ID=req_id
491: , PROGRAM_ID=arp_standard.profile.program_id
492: WHERE LOAN_ID=PRIMARY_KEY_ID1_LIST(I);
493:

Line 491: , PROGRAM_ID=arp_standard.profile.program_id

487: , LAST_UPDATE_DATE=SYSDATE
488: , last_updated_by=arp_standard.profile.user_id
489: , last_update_login=arp_standard.profile.last_update_login
490: , REQUEST_ID=req_id
491: , PROGRAM_ID=arp_standard.profile.program_id
492: WHERE LOAN_ID=PRIMARY_KEY_ID1_LIST(I);
493:
494: l_count := l_count + SQL%ROWCOUNT;
495:

Line 661: , last_updated_by=arp_standard.profile.user_id

657: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
658: UPDATE LNS_PARTICIPANTS yt SET
659: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
660: , LAST_UPDATE_DATE=SYSDATE
661: , last_updated_by=arp_standard.profile.user_id
662: , last_update_login=arp_standard.profile.last_update_login
663: WHERE PARTICIPANT_ID=PRIMARY_KEY_ID1_LIST(I);
664:
665: l_count := l_count + SQL%ROWCOUNT;

Line 662: , last_update_login=arp_standard.profile.last_update_login

658: UPDATE LNS_PARTICIPANTS yt SET
659: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
660: , LAST_UPDATE_DATE=SYSDATE
661: , last_updated_by=arp_standard.profile.user_id
662: , last_update_login=arp_standard.profile.last_update_login
663: WHERE PARTICIPANT_ID=PRIMARY_KEY_ID1_LIST(I);
664:
665: l_count := l_count + SQL%ROWCOUNT;
666:

Line 754: , last_updated_by=arp_standard.profile.user_id

750: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
751: UPDATE LNS_PARTICIPANTS yt SET
752: BILL_TO_ACCT_SITE_ID=NUM_COL2_NEW_LIST(I)
753: , LAST_UPDATE_DATE=SYSDATE
754: , last_updated_by=arp_standard.profile.user_id
755: , last_update_login=arp_standard.profile.last_update_login
756: WHERE PARTICIPANT_ID=PRIMARY_KEY_ID1_LIST(I);
757:
758: l_count := l_count + SQL%ROWCOUNT;

Line 755: , last_update_login=arp_standard.profile.last_update_login

751: UPDATE LNS_PARTICIPANTS yt SET
752: BILL_TO_ACCT_SITE_ID=NUM_COL2_NEW_LIST(I)
753: , LAST_UPDATE_DATE=SYSDATE
754: , last_updated_by=arp_standard.profile.user_id
755: , last_update_login=arp_standard.profile.last_update_login
756: WHERE PARTICIPANT_ID=PRIMARY_KEY_ID1_LIST(I);
757:
758: l_count := l_count + SQL%ROWCOUNT;
759: