APPS.CSI_ACCT_MERGE_PKG dependencies on CSI_ITEM_INSTANCES

Line 17: CSI_ITEM_INSTANCES_MERGE(req_id, set_num, process_mode);

13: arp_message.set_line('CSI_ACCT_MERGE_PKG.MERGE()+');
14: /*
15: error_str := '001';
16: write_to_cr_log( ' Processing Item Instances Merge ' );
17: CSI_ITEM_INSTANCES_MERGE(req_id, set_num, process_mode);
18: write_to_cr_log( ' Ending process for Item Instances All ' );
19:
20: error_str := '002';
21: write_to_cr_log( ' Processing Systems All Merge ' );

Line 49: PROCEDURE csi_item_instances_merge( req_id IN NUMBER,

45: arp_message.set_line( 'CSI_ACCT_MERGE_PKG.MERGE()-');
46: RAISE;
47: END MERGE;
48:
49: PROCEDURE csi_item_instances_merge( req_id IN NUMBER,
50: set_num IN NUMBER,
51: process_mode IN VARCHAR2 ) IS
52: BEGIN
53: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()+');

Line 53: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()+');

49: PROCEDURE csi_item_instances_merge( req_id IN NUMBER,
50: set_num IN NUMBER,
51: process_mode IN VARCHAR2 ) IS
52: BEGIN
53: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()+');
54: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()-');
55: EXCEPTION
56: WHEN OTHERS THEN
57: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()');

Line 54: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()-');

50: set_num IN NUMBER,
51: process_mode IN VARCHAR2 ) IS
52: BEGIN
53: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()+');
54: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()-');
55: EXCEPTION
56: WHEN OTHERS THEN
57: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()');
58: RAISE;

Line 57: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()');

53: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()+');
54: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()-');
55: EXCEPTION
56: WHEN OTHERS THEN
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,

Line 59: END CSI_ITEM_INSTANCES_MERGE;

55: EXCEPTION
56: WHEN OTHERS THEN
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

Line 113: CSI_ITEM_INSTANCES.INSTANCE_ID%TYPE

109:
110: INSTANCE_PARTY_ID_LIST INSTANCE_PARTY_ID_LIST_TYPE;
111:
112: TYPE INSTANCE_ID_LIST_TYPE IS TABLE OF
113: CSI_ITEM_INSTANCES.INSTANCE_ID%TYPE
114: INDEX BY BINARY_INTEGER;
115:
116: INSTANCE_ID_LIST INSTANCE_ID_LIST_TYPE;
117:

Line 138: CSI_ITEM_INSTANCES.LOCATION_ID%TYPE

134: NUM_COL3_ORIG_LIST SHIP_TO_ADDRESS_LIST_TYPE;
135: NUM_COL3_NEW_LIST SHIP_TO_ADDRESS_LIST_TYPE;
136:
137: TYPE LOCATION_ID_LIST_TYPE IS TABLE OF
138: CSI_ITEM_INSTANCES.LOCATION_ID%TYPE
139: INDEX BY BINARY_INTEGER;
140:
141: NUM_COL4_ORIG_LIST LOCATION_ID_LIST_TYPE;
142: NUM_COL4_NEW_LIST LOCATION_ID_LIST_TYPE;

Line 146: CSI_ITEM_INSTANCES.INSTALL_LOCATION_ID%TYPE

142: NUM_COL4_NEW_LIST LOCATION_ID_LIST_TYPE;
143:
144:
145: TYPE INSTALL_LOCATION_ID_LIST_TYPE IS TABLE OF
146: CSI_ITEM_INSTANCES.INSTALL_LOCATION_ID%TYPE
147: INDEX BY BINARY_INTEGER;
148:
149:
150: NUM_COL5_ORIG_LIST INSTALL_LOCATION_ID_LIST_TYPE;

Line 173: , CSI_ITEM_INSTANCES CII

169: , CIP.INSTANCE_ID
170: , cii.last_vld_organization_id
171: FROM CSI_IP_ACCOUNTS YT
172: , CSI_I_PARTIES CIP
173: , CSI_ITEM_INSTANCES CII
174: , RA_CUSTOMER_MERGES M
175: WHERE (YT.BILL_TO_ADDRESS = M.DUPLICATE_SITE_ID OR
176: YT.SHIP_TO_ADDRESS = M.DUPLICATE_SITE_ID )
177: AND YT.INSTANCE_PARTY_ID = CIP.INSTANCE_PARTY_ID

Line 196: , CSI_ITEM_INSTANCES CII

192: , cii.last_vld_organization_id
193:
194: FROM CSI_IP_ACCOUNTS YT
195: , CSI_I_PARTIES CIP
196: , CSI_ITEM_INSTANCES CII
197: , (SELECT DISTINCT M2.CUSTOMER_MERGE_HEADER_ID
198: ,M2.DUPLICATE_ID
199: FROM RA_CUSTOMER_MERGES M2
200: WHERE M2.PROCESS_FLAG = 'N'

Line 381: FROM CSI_ITEM_INSTANCES WHERE INSTANCE_ID=INSTANCE_ID_LIST(I);

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
380: INTO l_install_location_type_code,NUM_COL5_ORIG_LIST(I),l_location_type_code,NUM_COL4_ORIG_LIST(I)
381: FROM CSI_ITEM_INSTANCES WHERE INSTANCE_ID=INSTANCE_ID_LIST(I);
382:
383: IF NUM_COL5_ORIG_LIST(I) IS NOT NULL THEN
384:
385: IF l_install_location_type_code = 'HZ_PARTY_SITES' THEN