APPS.ARP_CMERGE_ARATC dependencies on AR_INTERIM_CASH_RECEIPT_LINES

Line 152: AR_INTERIM_CASH_RECEIPT_LINES.cash_receipt_id%TYPE

148: INDEX BY BINARY_INTEGER;
149: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
150:
151: TYPE cash_receipt_id_LIST_TYPE IS TABLE OF
152: AR_INTERIM_CASH_RECEIPT_LINES.cash_receipt_id%TYPE
153: INDEX BY BINARY_INTEGER;
154: PRIMARY_KEY1_LIST cash_receipt_id_LIST_TYPE;
155:
156: TYPE cash_receipt_line_id_LIST_TYPE IS TABLE OF

Line 157: AR_INTERIM_CASH_RECEIPT_LINES.cash_receipt_line_id%TYPE

153: INDEX BY BINARY_INTEGER;
154: PRIMARY_KEY1_LIST cash_receipt_id_LIST_TYPE;
155:
156: TYPE cash_receipt_line_id_LIST_TYPE IS TABLE OF
157: AR_INTERIM_CASH_RECEIPT_LINES.cash_receipt_line_id%TYPE
158: INDEX BY BINARY_INTEGER;
159: PRIMARY_KEY2_LIST cash_receipt_line_id_LIST_TYPE;
160:
161: TYPE sold_to_customer_LIST_TYPE IS TABLE OF

Line 162: AR_INTERIM_CASH_RECEIPT_LINES.sold_to_customer%TYPE

158: INDEX BY BINARY_INTEGER;
159: PRIMARY_KEY2_LIST cash_receipt_line_id_LIST_TYPE;
160:
161: TYPE sold_to_customer_LIST_TYPE IS TABLE OF
162: AR_INTERIM_CASH_RECEIPT_LINES.sold_to_customer%TYPE
163: INDEX BY BINARY_INTEGER;
164: NUM_COL1_ORIG_LIST sold_to_customer_LIST_TYPE;
165: NUM_COL1_NEW_LIST sold_to_customer_LIST_TYPE;
166:

Line 173: FROM AR_INTERIM_CASH_RECEIPT_LINES yt, ra_customer_merges m

169: SELECT distinct CUSTOMER_MERGE_HEADER_ID
170: ,cash_receipt_id
171: ,cash_receipt_line_id
172: ,sold_to_customer
173: FROM AR_INTERIM_CASH_RECEIPT_LINES yt, ra_customer_merges m
174: WHERE (
175: yt.sold_to_customer = m.DUPLICATE_ID
176: ) AND m.process_flag = 'N'
177: AND m.request_id = req_id

Line 186: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_INTERIM_CASH_RECEIPT_LINES',FALSE);

182: IF process_mode='LOCK' THEN
183: NULL;
184: ELSE
185: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
186: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_INTERIM_CASH_RECEIPT_LINES',FALSE);
187: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
188: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
189:
190: open merged_records;

Line 225: 'AR_INTERIM_CASH_RECEIPT_LINES',

221: LAST_UPDATE_LOGIN,
222: LAST_UPDATE_DATE,
223: LAST_UPDATED_BY
224: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
225: 'AR_INTERIM_CASH_RECEIPT_LINES',
226: MERGE_HEADER_ID_LIST(I),
227: PRIMARY_KEY1_LIST(I),
228: PRIMARY_KEY2_LIST(I),
229: NUM_COL1_ORIG_LIST(I),

Line 241: UPDATE AR_INTERIM_CASH_RECEIPT_LINES yt SET

237: hz_utility_pub.LAST_UPDATED_BY
238: );
239:
240: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
241: UPDATE AR_INTERIM_CASH_RECEIPT_LINES yt SET
242: sold_to_customer=NUM_COL1_NEW_LIST(I)
243: , LAST_UPDATE_DATE=SYSDATE
244: , last_updated_by=arp_standard.profile.user_id
245: , last_update_login=arp_standard.profile.last_update_login