APPS.JTF_TASK_CUST_MERGE_PKG dependencies on HZ_ACCT_MERGE_UTIL

Line 122: HZ_ACCT_MERGE_UTIL.load_set(p_set_number, p_request_id);

118: ELSE
119: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
120: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JTF_TASKS_B',FALSE);
121:
122: HZ_ACCT_MERGE_UTIL.load_set(p_set_number, p_request_id);
123:
124: open merged_records;
125: LOOP
126: FETCH merged_records BULK COLLECT INTO

Line 141: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

137: exit;
138: END IF;
139:
140: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
141: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
142: END LOOP;
143:
144: IF g_profile_val IS NOT NULL AND g_profile_val = 'Y' THEN
145:

Line 255: HZ_ACCT_MERGE_UTIL.load_set(p_set_number, p_request_id);

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;
258: LOOP
259: FETCH merged_records BULK COLLECT INTO

Line 275: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

271: exit;
272: END IF;
273:
274: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
275: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
276: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
277: END LOOP;
278:
279: IF g_profile_val IS NOT NULL AND g_profile_val = 'Y' THEN

Line 276: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));

272: END IF;
273:
274: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
275: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
276: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
277: END LOOP;
278:
279: IF g_profile_val IS NOT NULL AND g_profile_val = 'Y' THEN
280:

Line 403: HZ_ACCT_MERGE_UTIL.load_set(p_set_number, p_request_id);

399: ELSE
400: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
401: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JTF_PERZ_QUERY_PARAM',FALSE);
402:
403: HZ_ACCT_MERGE_UTIL.load_set(p_set_number, p_request_id);
404: load_acct_number_set(p_set_number, p_request_id);
405:
406: open merged_records;
407: LOOP

Line 425: VCHAR_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(VCHAR_COL1_ORIG_LIST(I));

421: exit;
422: END IF;
423:
424: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
425: VCHAR_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(VCHAR_COL1_ORIG_LIST(I));
426: VCHAR_CN_NEW_LIST(I) := GETDUP_ACCOUNT_NUMBER(VCHAR_COL1_NEW_LIST(I));
427: END LOOP;
428:
429: IF g_profile_val IS NOT NULL AND g_profile_val = 'Y' THEN