DBA Data[Home] [Help]

APPS.ISC_DBI_ACCT_MERGE_PKG dependencies on HZ_CUSTOMER_MERGE_LOG

Line 87: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

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: 'ISC_BOOK_SUM2_PDUE_F',
105: MERGE_HEADER_ID_LIST(I),
106: PRIMARY_KEY_ID1_LIST(I),
107: NUM_COL1_ORIG_LIST(I),

Line 225: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

221:
222: END LOOP;
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 241: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

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

Line 363: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

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: 'ISC_BOOK_SUM2_BKORD_F',
381: MERGE_HEADER_ID_LIST(I),
382: PRIMARY_KEY_ID1_LIST(I),
383: NUM_COL1_ORIG_LIST(I),