DBA Data[Home] [Help]

APPS.XDP_PARTY_MERGE dependencies on HZ_CUSTOMER_MERGE_LOG

Line 93: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

Line 107: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

103: CREATION_DATE,
104: LAST_UPDATE_LOGIN,
105: LAST_UPDATE_DATE,
106: LAST_UPDATED_BY
107: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
108: 'XDP_ORDER_HEADERS',
109: MERGE_HEADER_ID_LIST(I),
110: PRIMARY_KEY_ID_LIST(I),
111: NUM_COL1_ORIG_LIST(I),

Line 171: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

Line 185: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

181: CREATION_DATE,
182: LAST_UPDATE_LOGIN,
183: LAST_UPDATE_DATE,
184: LAST_UPDATED_BY
185: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
186: 'XDP_ORDER_LINE_ITEMS',
187: MERGE_HEADER_ID_LIST(I),
188: PRIMARY_KEY_ID_LIST1(I),
189: NUM_COL1_ORIG_LIST1(I),