eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ACCT_MERGE_PKG dependencies on HZ_ACCT_MERGE_UTIL

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

263:
264: error_str := '003';
265: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
266: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_IP_ACCOUNTS',FALSE);
267: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
268:
269: error_str := '004';
270: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
271: l_prof_reltype_code := FND_PROFILE.VALUE('CSI_PARTY_ACCT_MERGE');

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

308: to_char(NUM_COL1_ORIG_LIST(I)) || '<>' ||
309: to_char(NUM_COL2_ORIG_LIST(I)) || '<>' ||
310: to_char(NUM_COL3_ORIG_LIST(I)) );
311:
312: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
313: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
314: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
315:
316: BEGIN

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

309: to_char(NUM_COL2_ORIG_LIST(I)) || '<>' ||
310: to_char(NUM_COL3_ORIG_LIST(I)) );
311:
312: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
313: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
314: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
315:
316: BEGIN
317:

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

310: to_char(NUM_COL3_ORIG_LIST(I)) );
311:
312: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
313: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
314: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
315:
316: BEGIN
317:
318: SELECT CUSTOMER_SITE_ID INTO l_install_customer_site_id

Line 331: INSTALL_CUSTOMER_SITE_ID_LIST(I):= HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(l_install_customer_site_id);

327: END;
328:
329: IF l_install_customer_site_id IS NOT NULL THEN
330:
331: INSTALL_CUSTOMER_SITE_ID_LIST(I):= HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(l_install_customer_site_id);
332: END IF;
333:
334:
335:

Line 351: /* NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL6_ORIG_LIST(I));*/

347: SELECT CUST_ACCT_SITE_ID
348: INTO NUM_COL6_NEW_LIST(I) FROM hz_cust_site_uses_all
349: WHERE SITE_USE_ID= INSTALL_CUSTOMER_SITE_ID_LIST(I);
350:
351: /* NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL6_ORIG_LIST(I));*/
352:
353: SELECT PARTY_SITE_ID INTO NUM_COL5_NEW_LIST(I)
354: FROM HZ_CUST_ACCT_SITES_ALL
355: WHERE CUST_ACCT_SITE_ID= NUM_COL6_NEW_LIST(I);

Line 388: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL6_ORIG_LIST(I));*/

384: INTO NUM_COL6_ORIG_LIST(I) FROM HZ_CUST_ACCT_SITES_ALL
385: WHERE PARTY_SITE_ID= l_party_site_id
386: AND CUST_ACCOUNT_ID= NUM_COL1_ORIG_LIST(I);
387:
388: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL6_ORIG_LIST(I));*/
389:
390:
391: SELECT PARTY_SITE_ID INTO l_party_site_id
392: FROM HZ_CUST_ACCT_SITES_ALL

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

1503: write_to_cr_log( 'CSI : csi_systems_b_merge.....' || process_mode );
1504:
1505: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1506: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_SYSTEMS_B',FALSE);
1507: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1508: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1509:
1510: OPEN merged_records;
1511:

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

1533: to_char(NUM_COL1_ORIG_LIST(I)) || '<>' ||
1534: to_char(NUM_COL2_ORIG_LIST(I)) || '<>' ||
1535: to_char(NUM_COL3_ORIG_LIST(I)) );
1536:
1537: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1538: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1539: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1540:
1541: write_to_cr_log( to_char(i) || '.new1 new2 new3 : '||

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

1534: to_char(NUM_COL2_ORIG_LIST(I)) || '<>' ||
1535: to_char(NUM_COL3_ORIG_LIST(I)) );
1536:
1537: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1538: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1539: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1540:
1541: write_to_cr_log( to_char(i) || '.new1 new2 new3 : '||
1542: to_char(NUM_COL1_NEW_LIST(I)) || '<>' ||

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

1535: to_char(NUM_COL3_ORIG_LIST(I)) );
1536:
1537: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1538: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1539: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1540:
1541: write_to_cr_log( to_char(i) || '.new1 new2 new3 : '||
1542: to_char(NUM_COL1_NEW_LIST(I)) || '<>' ||
1543: to_char(NUM_COL2_NEW_LIST(I)) || '<>' ||

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

1893: write_to_cr_log( 'Starting to update the csi_t_party_accounts' );
1894:
1895: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1896: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);
1897: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1898: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1899:
1900: OPEN merged_records;
1901:

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

1916: EXIT;
1917: END IF;
1918:
1919: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1920: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1921: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1922: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1923: END LOOP;
1924:

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

1917: END IF;
1918:
1919: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1920: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1921: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1922: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1923: END LOOP;
1924:
1925: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

1918:
1919: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1920: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1921: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1922: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1923: END LOOP;
1924:
1925: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1926: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

2088: write_to_cr_log( 'Done Locking the CSI_T_TXN_SYSTEMS table' );
2089: ELSE
2090: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2091: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);
2092: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2093: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
2094:
2095: OPEN merged_records;
2096:

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

2112: EXIT;
2113: END IF;
2114:
2115: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2116: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
2117: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
2118: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
2119: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
2120: END LOOP;

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

2113: END IF;
2114:
2115: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2116: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
2117: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
2118: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
2119: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
2120: END LOOP;
2121:

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

2114:
2115: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2116: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
2117: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
2118: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
2119: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
2120: END LOOP;
2121:
2122: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

Line 2119: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));

2115: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2116: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
2117: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
2118: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
2119: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
2120: END LOOP;
2121:
2122: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2123: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT