APPS.QP_CUST_MERGE dependencies on HZ_ACCT_MERGE_UTIL

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

69: NULL;
70: ELSE
71: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
72: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OE_AGREEMENTS_B',FALSE);
73: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
74: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
75:
76: open merged_records;
77: LOOP

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

87: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
88: exit;
89: END IF;
90: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
91: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
92: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
93: END LOOP;
94: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
95: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

88: exit;
89: END IF;
90: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
91: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
92: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
93: END LOOP;
94: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
95: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
96: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

250: NULL;
251: ELSE
252: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
253: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','QP_QUALIFIERS',FALSE);
254: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
255: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
256:
257: open merged_records;
258: LOOP

Line 278: VCHAR_COL1_NEW_LIST(I) := to_char(HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(to_number(VCHAR_COL1_ORIG_LIST(I))));

274: --Modified code for bug fix 3649761
275: IF (QUALIFIER_CONTEXT_LIST(I) = 'CUSTOMER' AND
276: QUALIFIER_ATTRIBUTE_LIST(I) = 'QUALIFIER_ATTRIBUTE2') --Customer Name
277: THEN
278: VCHAR_COL1_NEW_LIST(I) := to_char(HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(to_number(VCHAR_COL1_ORIG_LIST(I))));
279: VCHAR_COL2_ORIG_LIST(I) := NULL;
280: VCHAR_COL2_NEW_LIST(I) := NULL;
281: ELSIF ((QUALIFIER_CONTEXT_LIST(I) = 'CUSTOMER' AND
282: QUALIFIER_ATTRIBUTE_LIST(I) = 'QUALIFIER_ATTRIBUTE11') --Ship To

Line 291: VCHAR_COL2_NEW_LIST(I) := to_char(HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(to_number(VCHAR_COL2_ORIG_LIST(I))));

287: (QUALIFIER_CONTEXT_LIST(I) = 'CUSTOMER' AND
288: QUALIFIER_ATTRIBUTE_LIST(I) = 'QUALIFIER_ATTRIBUTE14') --Bill To
289: )
290: THEN
291: VCHAR_COL2_NEW_LIST(I) := to_char(HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(to_number(VCHAR_COL2_ORIG_LIST(I))));
292: VCHAR_COL1_ORIG_LIST(I) := NULL;
293: VCHAR_COL1_NEW_LIST(I) := NULL;
294: END IF;
295: