APPS.CN_CUST_MERGE_PVT dependencies on CN_COMMISSION_HEADERS

Line 14: CN_COMMISSION_HEADERS.COMMISSION_HEADER_ID%TYPE

10: INDEX BY BINARY_INTEGER;
11: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
12:
13: TYPE COMMISSION_HEADER_ID_LIST_TYPE IS TABLE OF
14: CN_COMMISSION_HEADERS.COMMISSION_HEADER_ID%TYPE
15: INDEX BY BINARY_INTEGER;
16: PRIMARY_KEY_ID_LIST COMMISSION_HEADER_ID_LIST_TYPE;
17:
18: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 19: CN_COMMISSION_HEADERS.CUSTOMER_ID%TYPE

15: INDEX BY BINARY_INTEGER;
16: PRIMARY_KEY_ID_LIST COMMISSION_HEADER_ID_LIST_TYPE;
17:
18: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
19: CN_COMMISSION_HEADERS.CUSTOMER_ID%TYPE
20: INDEX BY BINARY_INTEGER;
21: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
22: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
23:

Line 25: CN_COMMISSION_HEADERS.BILL_TO_ADDRESS_ID%TYPE

21: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
22: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
23:
24: TYPE BILL_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF
25: CN_COMMISSION_HEADERS.BILL_TO_ADDRESS_ID%TYPE
26: INDEX BY BINARY_INTEGER;
27: NUM_COL2_ORIG_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
28: NUM_COL2_NEW_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
29:

Line 31: CN_COMMISSION_HEADERS.SHIP_TO_ADDRESS_ID%TYPE

27: NUM_COL2_ORIG_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
28: NUM_COL2_NEW_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
29:
30: TYPE SHIP_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF
31: CN_COMMISSION_HEADERS.SHIP_TO_ADDRESS_ID%TYPE
32: INDEX BY BINARY_INTEGER;
33: NUM_COL3_ORIG_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
34: NUM_COL3_NEW_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
35:

Line 45: FROM CN_COMMISSION_HEADERS_ALL yt, ra_customer_merges m

41: ,yt.COMMISSION_HEADER_ID
42: ,yt.CUSTOMER_ID
43: ,yt.BILL_TO_ADDRESS_ID
44: ,yt.SHIP_TO_ADDRESS_ID
45: FROM CN_COMMISSION_HEADERS_ALL yt, ra_customer_merges m
46: WHERE (
47: yt.CUSTOMER_ID = m.DUPLICATE_ID
48: OR ((yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID)
49: AND

Line 97: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_COMMISSION_HEADERS',FALSE);

93: ELSE
94:
95: IF l_custmerge_profile_value = 'Y' THEN
96: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
97: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_COMMISSION_HEADERS',FALSE);
98: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
99: END IF;
100:
101: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

Line 179: 'CN_COMMISSION_HEADERS',

175: LAST_UPDATE_LOGIN,
176: LAST_UPDATE_DATE,
177: LAST_UPDATED_BY
178: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
179: 'CN_COMMISSION_HEADERS',
180: MERGE_HEADER_ID_LIST(I),
181: PRIMARY_KEY_ID_LIST(I),
182: NUM_COL1_ORIG_LIST(I),
183: NUM_COL1_NEW_LIST(I),

Line 198: UPDATE CN_COMMISSION_HEADERS_ALL yt SET

194: hz_utility_pub.LAST_UPDATED_BY
195: );
196: END IF;
197: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
198: UPDATE CN_COMMISSION_HEADERS_ALL yt SET
199: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
200: ,BILL_TO_ADDRESS_ID=NUM_COL2_NEW_LIST(I)
201: ,SHIP_TO_ADDRESS_ID=NUM_COL3_NEW_LIST(I)
202: , LAST_UPDATE_DATE=SYSDATE