94:
95: IF l_custmerge_profile_value = 'Y' THEN
96: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
97: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_COMMISSION_HEADERS',FALSE);
98: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
99: END IF;
100:
101: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
102:
123:
124: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
125: IF 'Y' = l_custmerge_profile_value THEN --replace this with profile value
126: NUM_COL1_NEW_LIST(I) :=
127: HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
128: NUM_COL2_NEW_LIST(I) :=
129: HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
130: NUM_COL3_NEW_LIST(I) :=
131: HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
125: IF 'Y' = l_custmerge_profile_value THEN --replace this with profile value
126: NUM_COL1_NEW_LIST(I) :=
127: HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
128: NUM_COL2_NEW_LIST(I) :=
129: HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
130: NUM_COL3_NEW_LIST(I) :=
131: HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
132: ELSE
133:
127: HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
128: NUM_COL2_NEW_LIST(I) :=
129: HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
130: NUM_COL3_NEW_LIST(I) :=
131: HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
132: ELSE
133:
134: open CUST(NUM_COL1_ORIG_LIST(I));
135: open ADDR(NUM_COL2_ORIG_LIST(I));
312:
313: IF l_custmerge_profile_value = 'Y' THEN
314: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
315: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_COMM_LINES_API',FALSE);
316: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
317: END IF;
318:
319: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
320:
337:
338: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
339: IF 'Y' = l_custmerge_profile_value THEN --replace this with profile value
340: NUM_COL1_NEW_LIST(I) :=
341: HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
342: NUM_COL2_NEW_LIST(I) :=
343: HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
344: NUM_COL3_NEW_LIST(I) :=
345: HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
339: IF 'Y' = l_custmerge_profile_value THEN --replace this with profile value
340: NUM_COL1_NEW_LIST(I) :=
341: HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
342: NUM_COL2_NEW_LIST(I) :=
343: HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
344: NUM_COL3_NEW_LIST(I) :=
345: HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
346: ELSE
347: open CUST(NUM_COL1_ORIG_LIST(I));
341: HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
342: NUM_COL2_NEW_LIST(I) :=
343: HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
344: NUM_COL3_NEW_LIST(I) :=
345: HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
346: ELSE
347: open CUST(NUM_COL1_ORIG_LIST(I));
348: open ADDR(NUM_COL2_ORIG_LIST(I));
349: open SITE(NUM_COL3_ORIG_LIST(I));