APPS.IEX_MERGE_PVT dependencies on HZ_ACCT_MERGE_UTIL

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

91: NULL;
92: ELSE
93: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
94: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_SCORE_HISTORIES',FALSE);
95: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
96: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
97:
98: /* process IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE='IEX_ACCOUNT' */
99: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

114: goto iex_score_account_site;
115: END IF;
116:
117: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
118: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
119: END LOOP;
120: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
121: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
122: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

198: goto iex_score_account_site_use;
199: END IF;
200:
201: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
202: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
203: END LOOP;
204:
205: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
206: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 284: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));

280: exit;
281: END IF;
282:
283: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
284: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
285: END LOOP;
286: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
287: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
288: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

419: END IF;
420:
421: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
422: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_DUNNING',FALSE);
423: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
424: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
425:
426: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */
427: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

443: goto iex_account;
444: END IF;
445:
446: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
447: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
448: END LOOP;
449:
450: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
451: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

530: EXIT;
531: END IF;
532:
533: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
534: --NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
535: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I)); -- 5874874 gnramasa 25-Apr-2007
536: END LOOP;
537: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
538: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 535: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I)); -- 5874874 gnramasa 25-Apr-2007

531: END IF;
532:
533: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
534: --NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
535: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I)); -- 5874874 gnramasa 25-Apr-2007
536: END LOOP;
537: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
538: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
539: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

711: END IF;
712:
713: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
714: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_STRATEGIES',FALSE);
715: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
716: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
717:
718: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */
719: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

737: goto iex_account;
738: END IF;
739:
740: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
741: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
742: END LOOP;
743:
744: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
745: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

824: goto iex_billto;
825: END IF;
826:
827: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
828: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
829: END LOOP;
830: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
831: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
832: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 924: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));

920: exit;
921: END IF;
922:
923: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
924: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
925: END LOOP;
926: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
927: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
928: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

1044: NULL;
1045: ELSE
1046: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1047: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_PROMISE_DETAILS',FALSE);
1048: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1049: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1050:
1051: open merged_records;
1052: LOOP

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

1064: exit;
1065: END IF;
1066:
1067: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1068: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1069: END LOOP;
1070:
1071: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1072: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

1217: NULL;
1218: ELSE
1219: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1220: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_DELINQUENCIES',FALSE);
1221: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1222: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1223:
1224: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1225: IEX_DEBUG_PUB.logMessage('l_profile_val = ' || l_profile_val);

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

1255: goto iex_delinquency_acc_site_use;
1256: END IF;
1257:
1258: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1259: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1260: END LOOP;
1261:
1262: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1263: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1365: exit;
1366: END IF;
1367:
1368: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1369: --NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
1370: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1371: END LOOP;
1372:
1373: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

Line 1370: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));

1366: END IF;
1367:
1368: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1369: --NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
1370: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1371: END LOOP;
1372:
1373: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1374: