APPS.ARP_CMERGE_ARTRX dependencies on AR_CASH_RECEIPTS

Line 21: AR_CASH_RECEIPTS.cash_receipt_id%TYPE

17: INDEX BY BINARY_INTEGER;
18: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
19:
20: TYPE cash_receipt_id_LIST_TYPE IS TABLE OF
21: AR_CASH_RECEIPTS.cash_receipt_id%TYPE
22: INDEX BY BINARY_INTEGER;
23: PRIMARY_KEY_ID_LIST cash_receipt_id_LIST_TYPE;
24:
25: TYPE pay_from_customer_LIST_TYPE IS TABLE OF

Line 26: AR_CASH_RECEIPTS.pay_from_customer%TYPE

22: INDEX BY BINARY_INTEGER;
23: PRIMARY_KEY_ID_LIST cash_receipt_id_LIST_TYPE;
24:
25: TYPE pay_from_customer_LIST_TYPE IS TABLE OF
26: AR_CASH_RECEIPTS.pay_from_customer%TYPE
27: INDEX BY BINARY_INTEGER;
28: NUM_COL1_ORIG_LIST pay_from_customer_LIST_TYPE;
29: NUM_COL1_NEW_LIST pay_from_customer_LIST_TYPE;
30:

Line 32: AR_CASH_RECEIPTS.customer_site_use_id%TYPE

28: NUM_COL1_ORIG_LIST pay_from_customer_LIST_TYPE;
29: NUM_COL1_NEW_LIST pay_from_customer_LIST_TYPE;
30:
31: TYPE customer_site_use_id_LIST_TYPE IS TABLE OF
32: AR_CASH_RECEIPTS.customer_site_use_id%TYPE
33: INDEX BY BINARY_INTEGER;
34: NUM_COL2_ORIG_LIST customer_site_use_id_LIST_TYPE;
35: NUM_COL2_NEW_LIST customer_site_use_id_LIST_TYPE;
36:

Line 43: FROM AR_CASH_RECEIPTS yt, ra_customer_merges m

39: SELECT distinct CUSTOMER_MERGE_HEADER_ID
40: ,cash_receipt_id
41: ,pay_from_customer
42: ,customer_site_use_id
43: FROM AR_CASH_RECEIPTS yt, ra_customer_merges m
44: WHERE ( (yt.pay_from_customer = m.DUPLICATE_ID AND
45: nvl(yt.customer_site_use_id,m.DUPLICATE_SITE_ID) = m.DUPLICATE_SITE_ID))
46: AND m.process_flag = 'N'
47: AND m.request_id = req_id

Line 56: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_CASH_RECEIPTS',FALSE);

52: IF process_mode='LOCK' THEN
53: NULL;
54: ELSE
55: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
56: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_CASH_RECEIPTS',FALSE);
57: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
58: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
59:
60: open merged_records;

Line 97: 'AR_CASH_RECEIPTS',

93: LAST_UPDATE_LOGIN,
94: LAST_UPDATE_DATE,
95: LAST_UPDATED_BY
96: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
97: 'AR_CASH_RECEIPTS',
98: MERGE_HEADER_ID_LIST(I),
99: PRIMARY_KEY_ID_LIST(I),
100: NUM_COL1_ORIG_LIST(I),
101: NUM_COL1_NEW_LIST(I),

Line 114: UPDATE AR_CASH_RECEIPTS yt SET

110: hz_utility_pub.LAST_UPDATED_BY
111: );
112:
113: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
114: UPDATE AR_CASH_RECEIPTS yt SET
115: pay_from_customer=NUM_COL1_NEW_LIST(I)
116: ,customer_site_use_id=NUM_COL2_NEW_LIST(I)
117: , LAST_UPDATE_DATE=SYSDATE
118: , last_updated_by=arp_standard.profile.user_id