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 133: CSI_ITEM_INSTANCES.LOCATION_ID%TYPE

129: NUM_COL3_ORIG_LIST SHIP_TO_ADDRESS_LIST_TYPE;
130: NUM_COL3_NEW_LIST SHIP_TO_ADDRESS_LIST_TYPE;
131:
132: TYPE LOCATION_ID_LIST_TYPE IS TABLE OF
133: CSI_ITEM_INSTANCES.LOCATION_ID%TYPE
134: INDEX BY BINARY_INTEGER;
135:
136: NUM_COL4_ORIG_LIST LOCATION_ID_LIST_TYPE;
137: NUM_COL4_NEW_LIST LOCATION_ID_LIST_TYPE;

Line 141: CSI_ITEM_INSTANCES.INSTALL_LOCATION_ID%TYPE

137: NUM_COL4_NEW_LIST LOCATION_ID_LIST_TYPE;
138:
139:
140: TYPE INSTALL_LOCATION_ID_LIST_TYPE IS TABLE OF
141: CSI_ITEM_INSTANCES.INSTALL_LOCATION_ID%TYPE
142: INDEX BY BINARY_INTEGER;
143:
144:
145: NUM_COL5_ORIG_LIST INSTALL_LOCATION_ID_LIST_TYPE;

Line 167: CSI_ITEM_INSTANCES cii,

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
170: yt.BILL_TO_ADDRESS = m.DUPLICATE_SITE_ID OR
171: yt.SHIP_TO_ADDRESS = m.DUPLICATE_SITE_ID )

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

336: --Added for Bug 6978155(FP for bug 6839035)
337:
338: SELECT INSTALL_LOCATION_TYPE_CODE,INSTALL_LOCATION_ID,LOCATION_TYPE_CODE,LOCATION_ID
339: INTO l_install_location_type_code,NUM_COL5_ORIG_LIST(I),l_location_type_code,NUM_COL4_ORIG_LIST(I)
340: FROM CSI_ITEM_INSTANCES WHERE INSTANCE_ID=INSTANCE_ID_LIST(I);
341:
342: IF NUM_COL5_ORIG_LIST(I) IS NOT NULL THEN
343:
344: IF l_install_location_type_code = 'HZ_PARTY_SITES' THEN