APPS.PAP_CMERGE_BB1 dependencies on HZ_CUSTOMER_MERGE_LOG

Line 132: -- It inserts the data into HZ_CUSTOMER_MERGE_LOG table

128: --
129: /* Added for TCA audit */
130: IF pap_cmerge.g_audit_profile = 'Y' THEN
131: --
132: -- It inserts the data into HZ_CUSTOMER_MERGE_LOG table
133: -- for PA_AGREEMENTS table and stamps the new agreement
134: -- number and old agreement number.
135: --
136: INSERT INTO hz_customer_merge_log

Line 136: INSERT INTO hz_customer_merge_log

132: -- It inserts the data into HZ_CUSTOMER_MERGE_LOG table
133: -- for PA_AGREEMENTS table and stamps the new agreement
134: -- number and old agreement number.
135: --
136: INSERT INTO hz_customer_merge_log
137: ( MERGE_LOG_ID,
138: MERGE_HEADER_ID,
139: REQUEST_ID,
140: TABLE_NAME,

Line 151: HZ_CUSTOMER_MERGE_LOG_S.nextval,

147: LAST_UPDATED_BY ,
148: LAST_UPDATE_DATE,
149: LAST_UPDATE_LOGIN )
150: VALUES(
151: HZ_CUSTOMER_MERGE_LOG_S.nextval,
152: cust_merge_head_id,
153: request_id,
154: 'PA_AGREEMENTS_ALL',
155: var_agmt_agreement_id,

Line 285: -- Inserts data into HZ_CUSTOMER_MERGE_LOG table for

281: /* Added for TCA audit */
282: --
283: IF pap_cmerge.g_audit_profile = 'Y' THEN
284: --
285: -- Inserts data into HZ_CUSTOMER_MERGE_LOG table for
286: -- PA_AGREEMENTS table and stamps agreement id with old
287: -- and new customer id .
288:
289: INSERT INTO hz_customer_merge_log

Line 289: INSERT INTO hz_customer_merge_log

285: -- Inserts data into HZ_CUSTOMER_MERGE_LOG table for
286: -- PA_AGREEMENTS table and stamps agreement id with old
287: -- and new customer id .
288:
289: INSERT INTO hz_customer_merge_log
290: ( MERGE_LOG_ID,
291: MERGE_HEADER_ID ,
292: REQUEST_ID,
293: TABLE_NAME,

Line 304: HZ_CUSTOMER_MERGE_LOG_S.nextval,

300: LAST_UPDATED_BY ,
301: LAST_UPDATE_DATE,
302: LAST_UPDATE_LOGIN )
303: VALUES(
304: HZ_CUSTOMER_MERGE_LOG_S.nextval,
305: var_cust_merge_header_id,
306: req_id,
307: 'PA_AGREEMENTS', -- bug 3891382.
308: var_agmt_agreement_id,