APPS.DPP_ACCOUNT_MERGE_PVT dependencies on DPP_CUSTOMER_CLAIMS_LOG

Line 148: | Account merge procedure for the table, dpp_customer_claims_log

144: |
145: | PROCEDURE
146: | merge_claim_account_log
147: | DESCRIPTION :
148: | Account merge procedure for the table, dpp_customer_claims_log
149: |
150: | NOTES:
151: |
152: |--------------------------------------------------------------*/

Line 166: DPP_CUSTOMER_CLAIMS_LOG.LOG_ID%TYPE

162:
163: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
164:
165: TYPE LOG_ID_LIST_TYPE IS TABLE OF
166: DPP_CUSTOMER_CLAIMS_LOG.LOG_ID%TYPE
167: INDEX BY BINARY_INTEGER;
168:
169: PRIMARY_KEY_ID1_LIST LOG_ID_LIST_TYPE;
170:

Line 184: FROM dpp_customer_claims_log yt, ra_customer_merges m

180: CURSOR merged_records IS
181: SELECT DISTINCT m.customer_merge_header_id
182: ,yt.log_id
183: ,m.customer_id
184: FROM dpp_customer_claims_log yt, ra_customer_merges m
185: WHERE (
186: yt.cust_account_id = m.duplicate_id
187: ) AND m.process_flag = 'N'
188: AND m.request_id = req_id

Line 200: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','dpp_customer_claims_log',FALSE);

196: IF process_mode='LOCK' THEN
197: NULL;
198: ELSE
199: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
200: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','dpp_customer_claims_log',FALSE);
201: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
202: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
203:
204: open merged_records;

Line 240: 'dpp_customer_claims_log',

236: LAST_UPDATE_LOGIN,
237: LAST_UPDATE_DATE,
238: LAST_UPDATED_BY
239: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
240: 'dpp_customer_claims_log',
241: MERGE_HEADER_ID_LIST(I),
242: PRIMARY_KEY_ID1_LIST(I),
243: NUM_COL1_ORIG_LIST(I),
244: NUM_COL1_NEW_LIST(I),

Line 257: UPDATE dpp_customer_claims_log yt SET

253:
254: END IF;
255: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
256:
257: UPDATE dpp_customer_claims_log yt SET
258: cust_account_id = TO_CHAR(NUM_COL1_NEW_LIST(I))
259: , LAST_UPDATE_DATE = SYSDATE
260: , last_updated_by = arp_standard.profile.user_id
261: , last_update_login = arp_standard.profile.last_update_login