APPS.LNS_MERGE_PKG dependencies on LNS_PARTICIPANTS

Line 216: UPDATE LNS_PARTICIPANTS

212: If a duplicate exists then do not transfer and return the id of the duplicate record as the Merged To Id.
213: */
214:
215: /* updating HZ_PARTY_ID column */
216: UPDATE LNS_PARTICIPANTS
217: SET HZ_PARTY_ID = p_To_FK_id,
218: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
219: last_updated_by = HZ_UTILITY_V2PUB.user_id,
220: last_update_login = HZ_UTILITY_V2PUB.last_update_login

Line 224: UPDATE LNS_PARTICIPANTS

220: last_update_login = HZ_UTILITY_V2PUB.last_update_login
221: WHERE HZ_PARTY_ID = p_from_fk_id;
222:
223: /* updating CONTACT_PERS_PARTY_ID column */
224: UPDATE LNS_PARTICIPANTS
225: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
226: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
227: last_updated_by = HZ_UTILITY_V2PUB.user_id,
228: last_update_login = HZ_UTILITY_V2PUB.last_update_login

Line 232: UPDATE LNS_PARTICIPANTS

228: last_update_login = HZ_UTILITY_V2PUB.last_update_login
229: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;
230:
231: /* updating CONTACT_REL_PARTY_ID column */
232: UPDATE LNS_PARTICIPANTS
233: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
234: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
235: last_updated_by = HZ_UTILITY_V2PUB.user_id,
236: last_update_login = HZ_UTILITY_V2PUB.last_update_login

Line 531: LNS_PARTICIPANTS.PARTICIPANT_ID%TYPE

527: INDEX BY BINARY_INTEGER;
528: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
529:
530: TYPE PARTICIPANT_ID_LIST_TYPE IS TABLE OF
531: LNS_PARTICIPANTS.PARTICIPANT_ID%TYPE
532: INDEX BY BINARY_INTEGER;
533: PRIMARY_KEY_ID1_LIST PARTICIPANT_ID_LIST_TYPE;
534:
535: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 536: LNS_PARTICIPANTS.CUST_ACCOUNT_ID%TYPE

532: INDEX BY BINARY_INTEGER;
533: PRIMARY_KEY_ID1_LIST PARTICIPANT_ID_LIST_TYPE;
534:
535: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
536: LNS_PARTICIPANTS.CUST_ACCOUNT_ID%TYPE
537: INDEX BY BINARY_INTEGER;
538:
539: TYPE CUST_ACCT_SITE_ID_LIST_TYPE IS TABLE OF
540: LNS_LOAN_HEADERS.BILL_TO_ACCT_SITE_ID%TYPE

Line 553: FROM LNS_PARTICIPANTS yt, ra_customer_merges m

549: CURSOR merged_records IS
550: SELECT distinct CUSTOMER_MERGE_HEADER_ID
551: ,PARTICIPANT_ID
552: ,CUST_ACCOUNT_ID
553: FROM LNS_PARTICIPANTS yt, ra_customer_merges m
554: WHERE (
555: yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
556: ) AND m.process_flag = 'N'
557: AND m.request_id = req_id

Line 564: FROM LNS_PARTICIPANTS yt, ra_customer_merges m

560: CURSOR merged_records2 IS
561: SELECT distinct CUSTOMER_MERGE_HEADER_ID
562: ,PARTICIPANT_ID
563: ,CUSTOMER_ADDRESS_ID
564: FROM LNS_PARTICIPANTS yt, ra_customer_merges m
565: WHERE
566: (yt.BILL_TO_ACCT_SITE_ID = m.DUPLICATE_ADDRESS_ID)
567: AND m.process_flag = 'N'
568: AND m.request_id = req_id

Line 589: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','LNS_PARTICIPANTS',FALSE);

585:
586: ELSE
587:
588: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
589: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','LNS_PARTICIPANTS',FALSE);
590: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
591: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
592:
593: LogMessage(FND_LOG.LEVEL_STATEMENT,'Searching for ACCOUNT records...');

Line 636: 'LNS_PARTICIPANTS',

632: LAST_UPDATE_DATE,
633: LAST_UPDATED_BY
634: ) VALUES (
635: HZ_CUSTOMER_MERGE_LOG_s.nextval,
636: 'LNS_PARTICIPANTS',
637: MERGE_HEADER_ID_LIST(I),
638: PRIMARY_KEY_ID1_LIST(I),
639: NUM_COL1_ORIG_LIST(I),
640: NUM_COL1_NEW_LIST(I),

Line 658: UPDATE LNS_PARTICIPANTS yt SET

654: LogMessage(FND_LOG.LEVEL_STATEMENT,'Updating LNS_LOAN_HEADERS Table ...');
655:
656:
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

Line 731: 'LNS_PARTICIPANTS',

727: LAST_UPDATE_DATE,
728: LAST_UPDATED_BY)
729: VALUES
730: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
731: 'LNS_PARTICIPANTS',
732: MERGE_HEADER_ID_LIST(I),
733: PRIMARY_KEY_ID1_LIST(I),
734: NUM_COL2_ORIG_LIST(I),
735: NUM_COL2_NEW_LIST(I),

Line 751: UPDATE LNS_PARTICIPANTS yt SET

747:
748: LogMessage(FND_LOG.LEVEL_STATEMENT,'Updating custAcctSites in LNS_LOAN_HEADERS Table ...');
749:
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