APPS.OKS_HZ_MERGE_PUB dependencies on HZ_CUSTOMER_MERGE_LOG

Line 172: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

168: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
169: END LOOP;
170: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
171: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
172: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
173: MERGE_LOG_ID,
174: TABLE_NAME,
175: MERGE_HEADER_ID,
176: PRIMARY_KEY_ID1,

Line 188: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

184: CREATION_DATE,
185: LAST_UPDATE_LOGIN,
186: LAST_UPDATE_DATE,
187: LAST_UPDATED_BY
188: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
189: 'OKS_BILLING_PROFILES_B',
190: MERGE_HEADER_ID_LIST(I),
191: PRIMARY_KEY_ID1_LIST(I),
192: NUM_COL1_ORIG_LIST(I),

Line 226: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

222: -- billing profile
223: /*CK old code
224: arp_message.set_name('AR','AR_UPDATING_TABLE');
225: arp_message.set_token('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);
226: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
227: MERGE_LOG_ID,
228: MERGE_HEADER_ID,
229: TABLE_NAME,
230: PRIMARY_KEY_ID,

Line 236: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

232: NUM_COL1_NEW,
233: NUM_COL2_ORIG,
234: NUM_COL2_NEW,
235: REQUEST_ID
236: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
237: CUSTOMER_MERGE_HEADER_ID,
238: 'OKS_BILLING_PROFILES_B',
239: ID,
240: DEPENDENT_CUST_ACCT_ID1,

Line 256: FROM HZ_CUSTOMER_MERGE_LOG l

252:
253: UPDATE OKS_BILLING_PROFILES_B yt SET (
254: DEPENDENT_CUST_ACCT_ID1, OBJECT_VERSION_NUMBER) = (
255: SELECT NUM_COL1_NEW, NUM_COL2_NEW
256: FROM HZ_CUSTOMER_MERGE_LOG l
257: WHERE l.REQUEST_ID = req_id
258: AND l.TABLE_NAME = 'OKS_BILLING_PROFILES_B'
259: AND l.PRIMARY_KEY_ID = ID
260: AND DEPENDENT_CUST_ACCT_ID1 = NUM_COL1_ORIG

Line 268: FROM HZ_CUSTOMER_MERGE_LOG l1, RA_CUSTOMER_MERGES h

264: , last_updated_by=arp_standard.profile.user_id
265: , last_update_login=arp_standard.profile.last_update_login
266: WHERE (ID) in (
267: SELECT PRIMARY_KEY_ID
268: FROM HZ_CUSTOMER_MERGE_LOG l1, RA_CUSTOMER_MERGES h
269: WHERE h.CUSTOMER_MERGE_HEADER_ID = l1.MERGE_HEADER_ID
270: AND l1.TABLE_NAME = 'OKS_BILLING_PROFILES_B'
271: AND l1.REQUEST_ID = req_id
272: AND h.set_number = set_number);

Line 381: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

377: NUM_COL4_NEW_LIST(I) := NUM_COL4_ORIG_LIST(I);
378: END LOOP;
379: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
380: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
381: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
382: MERGE_LOG_ID,
383: TABLE_NAME,
384: MERGE_HEADER_ID,
385: PRIMARY_KEY_ID1,

Line 397: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

393: CREATION_DATE,
394: LAST_UPDATE_LOGIN,
395: LAST_UPDATE_DATE,
396: LAST_UPDATED_BY
397: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
398: 'OKS_BILLING_PROFILES_B',
399: MERGE_HEADER_ID_LIST(I),
400: PRIMARY_KEY_ID1_LIST(I),
401: NUM_COL3_ORIG_LIST(I),

Line 458: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

454: NUM_COL2_NEW_LIST_QUOTE(I) := NUM_COL2_ORIG_LIST_QUOTE(I);
455: END LOOP;
456: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
457: FORALL I in 1..MERGE_HEADER_ID_LIST_QUOTE.COUNT
458: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
459: MERGE_LOG_ID,
460: TABLE_NAME,
461: MERGE_HEADER_ID,
462: PRIMARY_KEY_ID1,

Line 474: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

470: CREATION_DATE,
471: LAST_UPDATE_LOGIN,
472: LAST_UPDATE_DATE,
473: LAST_UPDATED_BY
474: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
475: 'OKS_K_HEADERS_B',
476: MERGE_HEADER_ID_LIST_QUOTE(I),
477: PRIMARY_KEY_ID1_LIST_QUOTE(I),
478: NUM_COL1_ORIG_LIST_QUOTE(I),