APPS.GMS_CMERGE dependencies on HZ_ACCT_MERGE_UTIL

Line 94: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

90: NULL;
91: ELSE
92: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
93: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','GMS_AWARDS',FALSE);
94: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
95: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
96:
97: open merged_records;
98: LOOP

Line 117: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));

113: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
114: exit;
115: END IF;
116: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
117: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
118:
119: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
120:
121: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));

Line 119: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));

115: END IF;
116: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
117: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
118:
119: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
120:
121: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
122:
123: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));

Line 121: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));

117: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
118:
119: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
120:
121: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
122:
123: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));
124:
125: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));

Line 123: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));

119: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
120:
121: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
122:
123: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));
124:
125: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));
126: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL6_ORIG_LIST(I));
127: END LOOP;

Line 125: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));

121: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
122:
123: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));
124:
125: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));
126: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL6_ORIG_LIST(I));
127: END LOOP;
128: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
129: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 126: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL6_ORIG_LIST(I));

122:
123: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));
124:
125: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));
126: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL6_ORIG_LIST(I));
127: END LOOP;
128: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
129: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
130: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 272: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

268: NULL;
269: ELSE
270: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
271: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','GMS_AWARDS_CONTACTS',FALSE);
272: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
273: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
274:
275: open merged_records;
276: LOOP

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

289: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
290: exit;
291: END IF;
292: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
293: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
294: END LOOP;
295: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
296: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
297: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 408: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

404: NULL;
405: ELSE
406: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
407: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','GMS_REPORTS',FALSE);
408: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
409: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
410:
411: open merged_records;
412: LOOP

Line 426: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));

422: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
423: exit;
424: END IF;
425: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
426: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
427: END LOOP;
428: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
429: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
430: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 532: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

528: NULL;
529: ELSE
530: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
531: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','GMS_DEFAULT_REPORTS',FALSE);
532: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
533: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
534:
535: open merged_records;
536: LOOP

Line 550: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));

546: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
547: exit;
548: END IF;
549: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
550: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
551: END LOOP;
552: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
553: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
554: INSERT INTO HZ_CUSTOMER_MERGE_LOG (