APPS.CN_CUST_MERGE_PVT dependencies on CN_COMM_LINES_API

Line 235: CN_COMM_LINES_API.COMM_LINES_API_ID%TYPE

231: INDEX BY BINARY_INTEGER;
232: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
233:
234: TYPE COMM_LINES_API_ID_LIST_TYPE IS TABLE OF
235: CN_COMM_LINES_API.COMM_LINES_API_ID%TYPE
236: INDEX BY BINARY_INTEGER;
237: PRIMARY_KEY_ID_LIST COMM_LINES_API_ID_LIST_TYPE;
238:
239: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 240: CN_COMM_LINES_API.CUSTOMER_ID%TYPE

236: INDEX BY BINARY_INTEGER;
237: PRIMARY_KEY_ID_LIST COMM_LINES_API_ID_LIST_TYPE;
238:
239: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
240: CN_COMM_LINES_API.CUSTOMER_ID%TYPE
241: INDEX BY BINARY_INTEGER;
242: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
243: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
244:

Line 246: CN_COMM_LINES_API.BILL_TO_ADDRESS_ID%TYPE

242: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
243: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
244:
245: TYPE BILL_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF
246: CN_COMM_LINES_API.BILL_TO_ADDRESS_ID%TYPE
247: INDEX BY BINARY_INTEGER;
248: NUM_COL2_ORIG_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
249: NUM_COL2_NEW_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
250:

Line 252: CN_COMM_LINES_API.SHIP_TO_ADDRESS_ID%TYPE

248: NUM_COL2_ORIG_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
249: NUM_COL2_NEW_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
250:
251: TYPE SHIP_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF
252: CN_COMM_LINES_API.SHIP_TO_ADDRESS_ID%TYPE
253: INDEX BY BINARY_INTEGER;
254: NUM_COL3_ORIG_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
255: NUM_COL3_NEW_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
256:

Line 266: FROM CN_COMM_LINES_API_ALL yt, ra_customer_merges m

262: ,yt.COMM_LINES_API_ID
263: ,yt.CUSTOMER_ID
264: ,yt.BILL_TO_ADDRESS_ID
265: ,yt.SHIP_TO_ADDRESS_ID
266: FROM CN_COMM_LINES_API_ALL yt, ra_customer_merges m
267: WHERE (
268: yt.CUSTOMER_ID = m.DUPLICATE_ID
269: OR ((yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID)
270: AND

Line 315: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_COMM_LINES_API',FALSE);

311: ELSE
312:
313: IF l_custmerge_profile_value = 'Y' THEN
314: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
315: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_COMM_LINES_API',FALSE);
316: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
317: END IF;
318:
319: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

Line 393: 'CN_COMM_LINES_API',

389: LAST_UPDATE_LOGIN,
390: LAST_UPDATE_DATE,
391: LAST_UPDATED_BY
392: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
393: 'CN_COMM_LINES_API',
394: MERGE_HEADER_ID_LIST(I),
395: PRIMARY_KEY_ID_LIST(I),
396: NUM_COL1_ORIG_LIST(I),
397: NUM_COL1_NEW_LIST(I),

Line 413: UPDATE CN_COMM_LINES_API_ALL yt SET

409: );
410:
411: END IF;
412: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
413: UPDATE CN_COMM_LINES_API_ALL yt SET
414: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
415: ,BILL_TO_ADDRESS_ID=NUM_COL2_NEW_LIST(I)
416: ,SHIP_TO_ADDRESS_ID=NUM_COL3_NEW_LIST(I)
417: , LAST_UPDATE_DATE=SYSDATE