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 300: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

296:
297: error_str := '003';
298: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
299: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_IP_ACCOUNTS',FALSE);
300: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
301:
302: error_str := '004';
303: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
304: l_prof_reltype_code := FND_PROFILE.VALUE('CSI_PARTY_ACCT_MERGE');

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

343: to_char(NUM_COL1_ORIG_LIST(I)) || '<>' ||
344: to_char(NUM_COL2_ORIG_LIST(I)) || '<>' ||
345: to_char(NUM_COL3_ORIG_LIST(I)) );
346:
347: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
348: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
349: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
350: INSTALL_CUSTOMER_SITE_ID_LIST(I):= NULL;
351: NUM_COL4_ORIG_LIST(I):= NULL;

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

344: to_char(NUM_COL2_ORIG_LIST(I)) || '<>' ||
345: to_char(NUM_COL3_ORIG_LIST(I)) );
346:
347: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
348: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
349: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
350: INSTALL_CUSTOMER_SITE_ID_LIST(I):= NULL;
351: NUM_COL4_ORIG_LIST(I):= NULL;
352: NUM_COL4_NEW_LIST(I):= NULL;

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

345: to_char(NUM_COL3_ORIG_LIST(I)) );
346:
347: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
348: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
349: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
350: INSTALL_CUSTOMER_SITE_ID_LIST(I):= NULL;
351: NUM_COL4_ORIG_LIST(I):= NULL;
352: NUM_COL4_NEW_LIST(I):= NULL;
353: NUM_COL5_ORIG_LIST(I):= NULL;

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

371: END;
372:
373: IF l_install_customer_site_id IS NOT NULL THEN
374:
375: INSTALL_CUSTOMER_SITE_ID_LIST(I):= HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(l_install_customer_site_id);
376:
377: --Added for Bug 6978155(FP for bug 6839035)
378: csi_t_gen_utility_pvt.add('INSTANCE_ID_LIST : '||INSTANCE_ID_LIST(I));
379: SELECT INSTALL_LOCATION_TYPE_CODE,INSTALL_LOCATION_ID,LOCATION_TYPE_CODE,LOCATION_ID

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

1535: write_to_cr_log( 'CSI : csi_systems_b_merge.....' || process_mode );
1536:
1537: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1538: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_SYSTEMS_B',FALSE);
1539: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1540: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1541:
1542: OPEN merged_records;
1543:

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

1565: to_char(NUM_COL1_ORIG_LIST(I)) || '<>' ||
1566: to_char(NUM_COL2_ORIG_LIST(I)) || '<>' ||
1567: to_char(NUM_COL3_ORIG_LIST(I)) );
1568:
1569: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1570: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1571: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1572:
1573: write_to_cr_log( to_char(i) || '.new1 new2 new3 : '||

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

1566: to_char(NUM_COL2_ORIG_LIST(I)) || '<>' ||
1567: to_char(NUM_COL3_ORIG_LIST(I)) );
1568:
1569: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1570: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1571: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1572:
1573: write_to_cr_log( to_char(i) || '.new1 new2 new3 : '||
1574: to_char(NUM_COL1_NEW_LIST(I)) || '<>' ||

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

1567: to_char(NUM_COL3_ORIG_LIST(I)) );
1568:
1569: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1570: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1571: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1572:
1573: write_to_cr_log( to_char(i) || '.new1 new2 new3 : '||
1574: to_char(NUM_COL1_NEW_LIST(I)) || '<>' ||
1575: to_char(NUM_COL2_NEW_LIST(I)) || '<>' ||

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

1925: write_to_cr_log( 'Starting to update the csi_t_party_accounts' );
1926:
1927: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1928: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);
1929: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1930: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1931:
1932: OPEN merged_records;
1933:

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

1948: EXIT;
1949: END IF;
1950:
1951: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1952: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1953: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1954: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1955: END LOOP;
1956:

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

1949: END IF;
1950:
1951: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1952: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1953: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1954: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1955: END LOOP;
1956:
1957: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

1950:
1951: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1952: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1953: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1954: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1955: END LOOP;
1956:
1957: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1958: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

2120: write_to_cr_log( 'Done Locking the CSI_T_TXN_SYSTEMS table' );
2121: ELSE
2122: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2123: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);
2124: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2125: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
2126:
2127: OPEN merged_records;
2128:

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

2144: EXIT;
2145: END IF;
2146:
2147: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2148: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
2149: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
2150: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
2151: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
2152: END LOOP;

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

2145: END IF;
2146:
2147: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2148: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
2149: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
2150: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
2151: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
2152: END LOOP;
2153:

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

2146:
2147: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2148: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
2149: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
2150: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
2151: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
2152: END LOOP;
2153:
2154: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

2147: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2148: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
2149: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
2150: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
2151: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
2152: END LOOP;
2153:
2154: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2155: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT