DBA Data[Home] [Help]

APPS.QP_CUST_MERGE dependencies on HZ_CUSTOMER_MERGE_LOG

Line 104: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

100: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
101: END LOOP;
102: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
103: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
104: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
105: MERGE_LOG_ID,
106: TABLE_NAME,
107: MERGE_HEADER_ID,
108: PRIMARY_KEY_ID,

Line 120: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

116: CREATION_DATE,
117: LAST_UPDATE_LOGIN,
118: LAST_UPDATE_DATE,
119: LAST_UPDATED_BY
120: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
121: 'OE_AGREEMENTS_B',
122: MERGE_HEADER_ID_LIST(I),
123: PRIMARY_KEY_ID_LIST(I),
124: NUM_COL1_ORIG_LIST(I),

Line 362: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

358:
359: END LOOP;
360: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
361: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
362: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
363: MERGE_LOG_ID,
364: TABLE_NAME,
365: MERGE_HEADER_ID,
366: PRIMARY_KEY_ID,

Line 379: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

375: CREATION_DATE,
376: LAST_UPDATE_LOGIN,
377: LAST_UPDATE_DATE,
378: LAST_UPDATED_BY
379: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
380: 'QP_QUALIFIERS',
381: MERGE_HEADER_ID_LIST(I),
382: PRIMARY_KEY_ID_LIST(I),
383: VCHAR_COL1_ORIG_LIST(I),