DBA Data[Home] [Help]

APPS.DPP_ACCOUNT_MERGE_PVT dependencies on HZ_CUSTOMER_MERGE_LOG

Line 90: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

Line 104: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

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

Line 225: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

221: END LOOP;
222:
223: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
224: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
225: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
226: MERGE_LOG_ID,
227: TABLE_NAME,
228: MERGE_HEADER_ID,
229: PRIMARY_KEY_ID1,

Line 239: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

235: CREATION_DATE,
236: LAST_UPDATE_LOGIN,
237: LAST_UPDATE_DATE,
238: LAST_UPDATED_BY
239: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
240: 'dpp_customer_claims_log',
241: MERGE_HEADER_ID_LIST(I),
242: PRIMARY_KEY_ID1_LIST(I),
243: NUM_COL1_ORIG_LIST(I),