APPS.LNS_MERGE_PKG dependencies on LNS_LOAN_HEADERS

Line 38: UPDATE LNS_LOAN_HEADERS_ALL

34: If a duplicate exists then do not transfer and return the id of the duplicate record as the Merged To Id.
35: */
36:
37: /* updating PRIMARY_BORROWER_ID column */
38: UPDATE LNS_LOAN_HEADERS_ALL
39: SET PRIMARY_BORROWER_ID = p_To_FK_id,
40: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
41: last_updated_by = HZ_UTILITY_V2PUB.user_id,
42: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

Line 48: UPDATE LNS_LOAN_HEADERS_ALL

44: program_id = HZ_UTILITY_V2PUB.program_id
45: WHERE PRIMARY_BORROWER_ID = p_from_fk_id;
46:
47: /* updating CONTACT_PERS_PARTY_ID column */
48: UPDATE LNS_LOAN_HEADERS_ALL
49: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
50: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
51: last_updated_by = HZ_UTILITY_V2PUB.user_id,
52: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

Line 58: UPDATE LNS_LOAN_HEADERS_ALL

54: program_id = HZ_UTILITY_V2PUB.program_id
55: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;
56:
57: /* updating CONTACT_REL_PARTY_ID column */
58: UPDATE LNS_LOAN_HEADERS_ALL
59: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
60: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
61: last_updated_by = HZ_UTILITY_V2PUB.user_id,
62: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

Line 161: LNS_LOAN_HEADERS.LOAN_ID%TYPE

157: INDEX BY BINARY_INTEGER;
158: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
159:
160: TYPE LOAN_ID_LIST_TYPE IS TABLE OF
161: LNS_LOAN_HEADERS.LOAN_ID%TYPE
162: INDEX BY BINARY_INTEGER;
163: PRIMARY_KEY_ID1_LIST LOAN_ID_LIST_TYPE;
164:
165: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 166: LNS_LOAN_HEADERS.CUST_ACCOUNT_ID%TYPE

162: INDEX BY BINARY_INTEGER;
163: PRIMARY_KEY_ID1_LIST LOAN_ID_LIST_TYPE;
164:
165: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
166: LNS_LOAN_HEADERS.CUST_ACCOUNT_ID%TYPE
167: INDEX BY BINARY_INTEGER;
168: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
169: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
170:

Line 176: FROM LNS_LOAN_HEADERS yt, ra_customer_merges m

172: CURSOR merged_records IS
173: SELECT distinct CUSTOMER_MERGE_HEADER_ID
174: ,LOAN_ID
175: ,CUST_ACCOUNT_ID
176: FROM LNS_LOAN_HEADERS yt, ra_customer_merges m
177: WHERE
178: (yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID)
179: AND m.process_flag = 'N'
180: AND m.request_id = req_id

Line 192: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','LNS_LOAN_HEADERS',FALSE);

188: NULL;
189: ELSE
190:
191: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
192: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','LNS_LOAN_HEADERS',FALSE);
193: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
194: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
195:
196: open merged_records;

Line 233: 'LNS_LOAN_HEADERS',

229: LAST_UPDATE_DATE,
230: LAST_UPDATED_BY)
231: VALUES
232: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
233: 'LNS_LOAN_HEADERS',
234: MERGE_HEADER_ID_LIST(I),
235: PRIMARY_KEY_ID1_LIST(I),
236: NUM_COL1_ORIG_LIST(I),
237: NUM_COL1_NEW_LIST(I),

Line 249: UPDATE LNS_LOAN_HEADERS yt SET

245:
246: END IF;
247:
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