APPS.ARP_CMERGE_ARCOL dependencies on AR_STATEMENTS_HISTORY

Line 272: records in table ar_statements_history

268:
269: /*--------------------------- PRIVATE ROUTINES ------------------------------*/
270:
271: /* bug3541921 : Added following procedure ar_sh to update
272: records in table ar_statements_history
273: */
274: PROCEDURE ar_sh (
275: req_id NUMBER,
276: set_num NUMBER,

Line 285: AR_STATEMENTS_HISTORY.line_cluster_id%TYPE

281: INDEX BY BINARY_INTEGER;
282: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
283:
284: TYPE line_cluster_id_LIST_TYPE IS TABLE OF
285: AR_STATEMENTS_HISTORY.line_cluster_id%TYPE
286: INDEX BY BINARY_INTEGER;
287: PRIMARY_KEY_ID_LIST line_cluster_id_LIST_TYPE;
288:
289: TYPE customer_id_LIST_TYPE IS TABLE OF

Line 290: AR_STATEMENTS_HISTORY.customer_id%TYPE

286: INDEX BY BINARY_INTEGER;
287: PRIMARY_KEY_ID_LIST line_cluster_id_LIST_TYPE;
288:
289: TYPE customer_id_LIST_TYPE IS TABLE OF
290: AR_STATEMENTS_HISTORY.customer_id%TYPE
291: INDEX BY BINARY_INTEGER;
292: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
293: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
294:

Line 296: AR_STATEMENTS_HISTORY.site_use_id%TYPE

292: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
293: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
294:
295: TYPE site_use_id_LIST_TYPE IS TABLE OF
296: AR_STATEMENTS_HISTORY.site_use_id%TYPE
297: INDEX BY BINARY_INTEGER;
298: NUM_COL2_ORIG_LIST site_use_id_LIST_TYPE;
299: NUM_COL2_NEW_LIST site_use_id_LIST_TYPE;
300:

Line 308: FROM AR_STATEMENTS_HISTORY yt, ra_customer_merges m

304: SELECT distinct CUSTOMER_MERGE_HEADER_ID
305: ,line_cluster_id
306: ,yt.customer_id
307: ,site_use_id
308: FROM AR_STATEMENTS_HISTORY yt, ra_customer_merges m
309: WHERE ( yt.customer_id = m.DUPLICATE_ID AND
310: yt.site_use_id = m.DUPLICATE_SITE_ID)
311: AND m.process_flag = 'N'
312: AND m.request_id = req_id

Line 321: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_STATEMENTS_HISTORY',FALSE);

317: IF process_mode='LOCK' THEN
318: NULL;
319: ELSE
320: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
321: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_STATEMENTS_HISTORY',FALSE);
322: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
323: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
324:
325: open merged_records;

Line 362: 'AR_STATEMENTS_HISTORY',

358: LAST_UPDATE_LOGIN,
359: LAST_UPDATE_DATE,
360: LAST_UPDATED_BY
361: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
362: 'AR_STATEMENTS_HISTORY',
363: MERGE_HEADER_ID_LIST(I),
364: PRIMARY_KEY_ID_LIST(I),
365: NUM_COL1_ORIG_LIST(I),
366: NUM_COL1_NEW_LIST(I),

Line 379: UPDATE AR_STATEMENTS_HISTORY yt SET

375: hz_utility_pub.LAST_UPDATED_BY
376: );
377:
378: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
379: UPDATE AR_STATEMENTS_HISTORY yt SET
380: customer_id=NUM_COL1_NEW_LIST(I)
381: ,site_use_id=NUM_COL2_NEW_LIST(I)
382: ,bill_to_location = ( select hs.location
383: from hz_cust_site_uses hs