APPS.JL_CMERGE dependencies on HZ_CUSTOMER_MERGE_LOG

Line 89: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

85: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
86: END LOOP;
87: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
88: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
89: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
90: MERGE_LOG_ID,
91: TABLE_NAME,
92: MERGE_HEADER_ID,
93: PRIMARY_KEY_ID,

Line 103: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

99: CREATION_DATE,
100: LAST_UPDATE_LOGIN,
101: LAST_UPDATE_DATE,
102: LAST_UPDATED_BY
103: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
104: 'JL_BR_AR_BANK_RETURNS',
105: MERGE_HEADER_ID_LIST(I),
106: PRIMARY_KEY_ID_LIST(I),
107: NUM_COL1_ORIG_LIST(I),

Line 234: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

230: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
231: END LOOP;
232: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
233: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
234: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
235: MERGE_LOG_ID,
236: TABLE_NAME,
237: MERGE_HEADER_ID,
238: PRIMARY_KEY_ID,

Line 250: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

246: CREATION_DATE,
247: LAST_UPDATE_LOGIN,
248: LAST_UPDATE_DATE,
249: LAST_UPDATED_BY
250: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
251: 'JL_BR_AR_OCCURRENCE_DOCS',
252: MERGE_HEADER_ID_LIST(I),
253: PRIMARY_KEY_ID_LIST(I),
254: NUM_COL1_ORIG_LIST(I),

Line 374: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

370: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
371: END LOOP;
372: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
373: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
374: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
375: MERGE_LOG_ID,
376: TABLE_NAME,
377: MERGE_HEADER_ID,
378: PRIMARY_KEY_ID,

Line 388: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

384: CREATION_DATE,
385: LAST_UPDATE_LOGIN,
386: LAST_UPDATE_DATE,
387: LAST_UPDATED_BY
388: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
389: 'JL_BR_AR_PAY_SCHED_AUX',
390: MERGE_HEADER_ID_LIST(I),
391: PRIMARY_KEY_ID_LIST(I),
392: NUM_COL1_ORIG_LIST(I),

Line 724: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

720: END LOOP;
721:
722: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
723: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
724: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
725: MERGE_LOG_ID,
726: TABLE_NAME,
727: MERGE_HEADER_ID,
728: PRIMARY_KEY_ID,

Line 749: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

745: CREATION_DATE,
746: LAST_UPDATE_LOGIN,
747: LAST_UPDATE_DATE,
748: LAST_UPDATED_BY
749: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
750: 'JL_BR_JOURNALS_ALL',
751: MERGE_HEADER_ID_LIST(I),
752: PRIMARY_KEY1_LIST(I),
753: PRIMARY_KEY2_LIST(I),

Line 1595: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1591:
1592:
1593: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1594: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1595: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1596: MERGE_LOG_ID,
1597: TABLE_NAME,
1598: MERGE_HEADER_ID,
1599: PRIMARY_KEY1,

Line 1624: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1620: LAST_UPDATE_LOGIN,
1621: LAST_UPDATE_DATE,
1622: LAST_UPDATED_BY
1623: ) VALUES (
1624: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1625: 'JL_BR_BALANCES_ALL',
1626: MERGE_HEADER_ID_LIST(I),
1627: PRIMARY_KEY1_LIST(I),
1628: PRIMARY_KEY2_LIST(I),