APPS.JTF_TASK_CUST_MERGE_PKG dependencies on JTF_TASK_AUDITS_B

Line 204: -- in jtf_task_audits_b table.

200: END merge_tasks;
201:
202: ----------------------------------------------------------------------
203: -- merge_audits(): merge old_cust_account_id, new_cust_account_id
204: -- in jtf_task_audits_b table.
205: ----------------------------------------------------------------------
206: PROCEDURE merge_audits (
207: p_request_id IN NUMBER,
208: p_set_number IN NUMBER,

Line 218: JTF_TASK_AUDITS_B.task_audit_id%TYPE

214: INDEX BY BINARY_INTEGER;
215: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
216:
217: TYPE task_audit_id_LIST_TYPE IS TABLE OF
218: JTF_TASK_AUDITS_B.task_audit_id%TYPE
219: INDEX BY BINARY_INTEGER;
220: PRIMARY_KEY_ID_LIST task_audit_id_LIST_TYPE;
221:
222: TYPE old_cust_account_id_LIST_TYPE IS TABLE OF

Line 223: JTF_TASK_AUDITS_B.old_cust_account_id%TYPE

219: INDEX BY BINARY_INTEGER;
220: PRIMARY_KEY_ID_LIST task_audit_id_LIST_TYPE;
221:
222: TYPE old_cust_account_id_LIST_TYPE IS TABLE OF
223: JTF_TASK_AUDITS_B.old_cust_account_id%TYPE
224: INDEX BY BINARY_INTEGER;
225: NUM_COL1_ORIG_LIST old_cust_account_id_LIST_TYPE;
226: NUM_COL1_NEW_LIST old_cust_account_id_LIST_TYPE;
227:

Line 229: JTF_TASK_AUDITS_B.new_cust_account_id%TYPE

225: NUM_COL1_ORIG_LIST old_cust_account_id_LIST_TYPE;
226: NUM_COL1_NEW_LIST old_cust_account_id_LIST_TYPE;
227:
228: TYPE new_cust_account_id_LIST_TYPE IS TABLE OF
229: JTF_TASK_AUDITS_B.new_cust_account_id%TYPE
230: INDEX BY BINARY_INTEGER;
231: NUM_COL2_ORIG_LIST new_cust_account_id_LIST_TYPE;
232: NUM_COL2_NEW_LIST new_cust_account_id_LIST_TYPE;
233:

Line 239: FROM JTF_TASK_AUDITS_B yt, ra_customer_merges m

235: SELECT distinct CUSTOMER_MERGE_HEADER_ID
236: ,task_audit_id
237: ,old_cust_account_id
238: ,new_cust_account_id
239: FROM JTF_TASK_AUDITS_B yt, ra_customer_merges m
240: WHERE (
241: yt.old_cust_account_id = m.DUPLICATE_ID
242: OR yt.new_cust_account_id = m.DUPLICATE_ID
243: ) AND m.process_flag = 'N'

Line 253: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JTF_TASK_AUDITS_B',FALSE);

249: IF p_process_mode='LOCK' THEN
250: NULL;
251: ELSE
252: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
253: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JTF_TASK_AUDITS_B',FALSE);
254:
255: HZ_ACCT_MERGE_UTIL.load_set(p_set_number, p_request_id);
256:
257: open merged_records;

Line 300: 'JTF_TASK_AUDITS_B',

296: LAST_UPDATE_DATE,
297: LAST_UPDATED_BY
298: ) VALUES (
299: HZ_CUSTOMER_MERGE_LOG_s.nextval,
300: 'JTF_TASK_AUDITS_B',
301: MERGE_HEADER_ID_LIST(I),
302: PRIMARY_KEY_ID_LIST(I),
303: NUM_COL1_ORIG_LIST(I),
304: NUM_COL1_NEW_LIST(I),

Line 319: UPDATE JTF_TASK_AUDITS_B yt SET

315:
316: END IF;
317:
318: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
319: UPDATE JTF_TASK_AUDITS_B yt SET
320: old_cust_account_id=NUM_COL1_NEW_LIST(I)
321: , new_cust_account_id=NUM_COL2_NEW_LIST(I)
322: , LAST_UPDATE_DATE=SYSDATE
323: , last_updated_by=arp_standard.profile.user_id