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 CSI_IP_ACCOUNTS

Line 27: CSI_IP_ACCOUNTS_MERGE(req_id, set_num, process_mode);

23: write_to_cr_log( ' Ending process for Systems All ' );
24:
25: error_str := '003';
26: write_to_cr_log( ' Processing IP Accounts Merge ' );
27: CSI_IP_ACCOUNTS_MERGE(req_id, set_num, process_mode);
28: write_to_cr_log( ' Ending process for IP Accounts Merge ' );
29:
30: error_str := '004';
31: write_to_cr_log( ' Processing Party Accounts Merge ' );

Line 61: PROCEDURE csi_ip_accounts_merge( req_id IN NUMBER,

57: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()');
58: RAISE;
59: END CSI_ITEM_INSTANCES_MERGE;
60:
61: PROCEDURE csi_ip_accounts_merge( req_id IN NUMBER,
62: set_num IN NUMBER,
63: process_mode IN VARCHAR2 ) IS
64:
65: error_str VARCHAR2(3);

Line 94: CSI_IP_ACCOUNTS.IP_ACCOUNT_ID%TYPE

90:
91: INSTALL_CUSTOMER_SITE_ID_LIST CUSTOMER_SITE_ID_LIST_TYPE;
92:
93: TYPE IP_ACCOUNT_ID_LIST_TYPE IS TABLE OF
94: CSI_IP_ACCOUNTS.IP_ACCOUNT_ID%TYPE
95: INDEX BY BINARY_INTEGER;
96:
97: PRIMARY_KEY_ID_LIST IP_ACCOUNT_ID_LIST_TYPE;
98:

Line 100: CSI_IP_ACCOUNTS.PARTY_ACCOUNT_ID%TYPE

96:
97: PRIMARY_KEY_ID_LIST IP_ACCOUNT_ID_LIST_TYPE;
98:
99: TYPE PARTY_ACCT_ID_LIST_TYPE IS TABLE OF
100: CSI_IP_ACCOUNTS.PARTY_ACCOUNT_ID%TYPE
101: INDEX BY BINARY_INTEGER;
102:
103: NUM_COL1_ORIG_LIST PARTY_ACCT_ID_LIST_TYPE;
104: NUM_COL1_NEW_LIST PARTY_ACCT_ID_LIST_TYPE;

Line 119: CSI_IP_ACCOUNTS.BILL_TO_ADDRESS%TYPE

115:
116: INSTANCE_ID_LIST INSTANCE_ID_LIST_TYPE;
117:
118: TYPE BILL_TO_ADDRESS_LIST_TYPE IS TABLE OF
119: CSI_IP_ACCOUNTS.BILL_TO_ADDRESS%TYPE
120: INDEX BY BINARY_INTEGER;
121:
122: NUM_COL2_ORIG_LIST BILL_TO_ADDRESS_LIST_TYPE;
123: NUM_COL2_NEW_LIST BILL_TO_ADDRESS_LIST_TYPE;

Line 126: CSI_IP_ACCOUNTS.SHIP_TO_ADDRESS%TYPE

122: NUM_COL2_ORIG_LIST BILL_TO_ADDRESS_LIST_TYPE;
123: NUM_COL2_NEW_LIST BILL_TO_ADDRESS_LIST_TYPE;
124:
125: TYPE SHIP_TO_ADDRESS_LIST_TYPE IS TABLE OF
126: CSI_IP_ACCOUNTS.SHIP_TO_ADDRESS%TYPE
127: INDEX BY BINARY_INTEGER;
128:
129: NUM_COL3_ORIG_LIST SHIP_TO_ADDRESS_LIST_TYPE;
130: NUM_COL3_NEW_LIST SHIP_TO_ADDRESS_LIST_TYPE;

Line 165: FROM CSI_IP_ACCOUNTS yt,

161: yt.BILL_TO_ADDRESS ,
162: yt.SHIP_TO_ADDRESS ,
163: cip.INSTANCE_PARTY_ID ,
164: cip.INSTANCE_ID
165: FROM CSI_IP_ACCOUNTS yt,
166: CSI_I_PARTIES cip,
167: CSI_ITEM_INSTANCES cii,
168: RA_CUSTOMER_MERGES m
169: WHERE ( yt.PARTY_ACCOUNT_ID = m.DUPLICATE_ID OR

Line 244: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_IP_ACCOUNTS_MERGE()+');

240:
241: BEGIN -- {1
242:
243: error_str := '001';
244: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_IP_ACCOUNTS_MERGE()+');
245:
246: IF (process_mode = 'LOCK') THEN -- {2
247:
248: error_str := '002';

Line 249: write_to_cr_log( 'Locking the csi_ip_accounts table' );

245:
246: IF (process_mode = 'LOCK') THEN -- {2
247:
248: error_str := '002';
249: write_to_cr_log( 'Locking the csi_ip_accounts table' );
250:
251: arp_message.set_name('AR','AR_LOCKING_TABLE');
252: arp_message.set_token('TABLE_NAME','CSI_IP_ACCOUNTS',FALSE);
253:

Line 252: arp_message.set_token('TABLE_NAME','CSI_IP_ACCOUNTS',FALSE);

248: error_str := '002';
249: write_to_cr_log( 'Locking the csi_ip_accounts table' );
250:
251: arp_message.set_name('AR','AR_LOCKING_TABLE');
252: arp_message.set_token('TABLE_NAME','CSI_IP_ACCOUNTS',FALSE);
253:
254: OPEN merged_records;
255: CLOSE merged_records;
256:

Line 257: write_to_cr_log( 'Done Locking the csi_ip_accounts table' );

253:
254: OPEN merged_records;
255: CLOSE merged_records;
256:
257: write_to_cr_log( 'Done Locking the csi_ip_accounts table' );
258:
259: ELSE -- } 2 {
260:
261: l_msg_string := 'CSI:Processing';

Line 266: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_IP_ACCOUNTS',FALSE);

262: write_to_cr_log( l_msg_string );
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');

Line 457: 'CSI_IP_ACCOUNTS' ,

453: )
454: VALUES
455: (
456: HZ_CUSTOMER_MERGE_LOG_s.nextval ,
457: 'CSI_IP_ACCOUNTS' ,
458: MERGE_HEADER_ID_LIST(I) ,
459: PRIMARY_KEY_ID_LIST(I) ,
460: NUM_COL1_ORIG_LIST(I) ,
461: NUM_COL1_NEW_LIST(I) ,

Line 514: -- Get the account_id from csi_ip_accounts

510: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP -- {
511:
512: l_msg_string := 'CSI:------->processing next record from the cursor...';
513: write_to_cr_log( l_msg_string );
514: -- Get the account_id from csi_ip_accounts
515: error_str := '008';
516: SELECT party_account_id, bill_to_address, ship_to_address
517: INTO l_party_account_id, l_bill_to_address, l_ship_to_address
518: FROM csi_ip_accounts

Line 518: FROM csi_ip_accounts

514: -- Get the account_id from csi_ip_accounts
515: error_str := '008';
516: SELECT party_account_id, bill_to_address, ship_to_address
517: INTO l_party_account_id, l_bill_to_address, l_ship_to_address
518: FROM csi_ip_accounts
519: WHERE ip_account_id = PRIMARY_KEY_ID_LIST(I);
520:
521: -- TODO : remove the next line
522: --NUM_COL1_NEW_LIST(i) := 4565;

Line 1402: arp_message.set_line( 'Done with the update of CSI_IP_ACCOUNTS' );

1398: CLOSE merged_records;
1399:
1400: arp_message.set_name('CSI','CSI_ROWS_UPDATED');
1401: arp_message.set_token('NUM_ROWS',to_char(l_count));
1402: arp_message.set_line( 'Done with the update of CSI_IP_ACCOUNTS' );
1403: END IF; -- } 2
1404:
1405: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_IP_ACCOUNTS_MERGE()-');
1406:

Line 1405: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_IP_ACCOUNTS_MERGE()-');

1401: arp_message.set_token('NUM_ROWS',to_char(l_count));
1402: arp_message.set_line( 'Done with the update of CSI_IP_ACCOUNTS' );
1403: END IF; -- } 2
1404:
1405: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_IP_ACCOUNTS_MERGE()-');
1406:
1407: EXCEPTION
1408: WHEN OTHERS THEN
1409: CLOSE merged_records;

Line 1413: END csi_ip_accounts_merge; -- } 1

1409: CLOSE merged_records;
1410: l_msg_data := error_str || '-' || l_msg_data;
1411: arp_message.set_error('CRM_MERGE.CUSTOMER_PRODUCTS_MERGE', l_msg_data);
1412: RAISE;
1413: END csi_ip_accounts_merge; -- } 1
1414:
1415: PROCEDURE csi_systems_b_merge(req_id IN NUMBER,
1416: set_num IN NUMBER,
1417: process_mode IN VARCHAR2) IS