[Home] [Help]
PACKAGE: APPS.CSI_PROCESS_TXN_GRP
Source
1 PACKAGE csi_process_txn_grp AUTHID CURRENT_USER AS
2 /* $Header: csigptxs.pls 120.4.12020000.2 2012/07/26 17:33:35 dsingire ship $ */
3
4 -- global variable declarations
5 g_pkg_name CONSTANT VARCHAR2(30) := 'csi_process_txn_grp';
6 g_user_id NUMBER := fnd_global.user_id;
7 g_login_id NUMBER := fnd_global.login_id;
8 g_sysdate DATE := sysdate;
9
10 -- Name : txn_instance_rec
11 -- Description : record to hold the transacting instance attributes
12 -- the table based on thisbelow will hold the source,
13 -- non-source and parent instance details based on the
14 -- definition of ib_txn_sub_type_id.
15
16 TYPE txn_instance_rec is RECORD (
17 IB_TXN_SEGMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,-- S-Source,N-NonSource,P-Parent
18 INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- Pass if caller has one
19 NEW_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- Will contain ID if IB creates new
20 INSTANCE_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
21 EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
23 VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24 INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
25 INV_MASTER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
26 SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
27 MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28 LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
29 QUANTITY NUMBER := FND_API.G_MISS_NUM,
30 UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
31 ACCOUNTING_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
32 INSTANCE_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
33 INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
34 CUSTOMER_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
35 MERCHANT_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
36 SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
37 SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
38 INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39 ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
40 ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
41 LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
42 LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
43 INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
44 INV_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
45 INV_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
46 PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
47 PA_PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
48 IN_TRANSIT_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49 WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
50 PO_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
51 LAST_OE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
52 LAST_OE_RMA_LINE_ID NUMBER := FND_API.G_MISS_NUM,
53 LAST_PO_PO_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54 LAST_OE_PO_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
55 LAST_WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
56 LAST_PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
57 LAST_PA_TASK_ID NUMBER := FND_API.G_MISS_NUM,
58 LAST_OE_AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
59 INSTALL_DATE DATE := FND_API.G_MISS_DATE,
60 MANUALLY_CREATED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
61 RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
62 ACTUAL_RETURN_DATE DATE := FND_API.G_MISS_DATE,
63 CREATION_COMPLETE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64 COMPLETENESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
65 VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
66 VERSION_LABEL_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
67 CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
68 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
84 LAST_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
85 INSTALL_LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86 INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
87 INSTANCE_USAGE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88 MTL_TXN_CREATION_DATE DATE := FND_API.G_MISS_DATE, --bug 3804960
89 CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
90 CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
91 CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
92 CALL_CONTRACTS VARCHAR2(1) := FND_API.G_TRUE, -- Bug 12390649
93 OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR);
94
95 TYPE dest_location_rec IS RECORD (
96 parent_tbl_index NUMBER := fnd_api.g_miss_num,
97 location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98 location_id NUMBER := FND_API.G_MISS_NUM,
99 install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100 install_location_id NUMBER := FND_API.G_MISS_NUM,
101 instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102 inv_organization_id NUMBER := FND_API.G_MISS_NUM,
103 inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
104 inv_locator_id NUMBER := FND_API.G_MISS_NUM,
105 pa_project_id NUMBER := FND_API.G_MISS_NUM,
106 pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
107 in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
108 wip_job_id NUMBER := fnd_api.g_miss_num,
109 last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
110 po_order_line_id NUMBER := fnd_api.g_miss_num,
111 last_pa_project_id NUMBER := fnd_api.g_miss_num,
112 last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
113 external_reference VARCHAR2(30) := fnd_api.g_miss_char,
114 operational_status_code VARCHAR2(30) := fnd_api.g_miss_char);
115
116
117 TYPE txn_instances_tbl is TABLE OF txn_instance_rec INDEX BY BINARY_INTEGER;
118
119 -- Name : txn_i_party_rec
120 -- Description : record to hold information about an instance-party relationship.
121
122 TYPE txn_i_party_rec IS RECORD (
123 instance_party_id NUMBER := FND_API.G_MISS_NUM,
124 parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
125 instance_id NUMBER := FND_API.G_MISS_NUM,
126 party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
127 party_id NUMBER := FND_API.G_MISS_NUM,
128 relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
129 contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130 contact_ip_id NUMBER := FND_API.G_MISS_NUM,
131 active_start_date DATE := FND_API.G_MISS_DATE,
132 active_end_date DATE := FND_API.G_MISS_DATE,
133 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
134 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149 object_version_number NUMBER := FND_API.G_MISS_NUM
150 );
151
152 TYPE txn_i_parties_tbl IS TABLE OF txn_i_party_rec INDEX BY BINARY_INTEGER;
153
154 -- Name : txn_ip_account_rec
155 -- Description : record to hold information about a party-account relationship.
156
157 TYPE txn_ip_account_rec IS RECORD (
158 ip_account_id NUMBER := FND_API.G_MISS_NUM,
159 parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
160 instance_party_id NUMBER := FND_API.G_MISS_NUM,
161 party_account_id NUMBER := FND_API.G_MISS_NUM,
162 relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163 bill_to_address NUMBER := FND_API.G_MISS_NUM,
164 ship_to_address NUMBER := FND_API.G_MISS_NUM,
165 active_start_date DATE := FND_API.G_MISS_DATE,
166 active_end_date DATE := FND_API.G_MISS_DATE,
167 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
168 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
183 call_contracts VARCHAR2(1) := FND_API.G_TRUE, -- Bug 12390649
184 object_version_number NUMBER := FND_API.G_MISS_NUM
185 );
186
187 TYPE txn_ip_accounts_tbl IS TABLE OF txn_ip_account_rec INDEX BY BINARY_INTEGER;
188
189 -- Name : txn_ii_relationship_rec
190 -- Description : record to hold the attributes of an item instance relationship.
191
192 TYPE txn_ii_relationship_rec IS RECORD (
193 RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
194 RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
195 OBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196 OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197 SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
198 SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
199 SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
200 POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
201 ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
202 ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
203 DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
204 MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
205 CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
206 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
222 );
223
224 TYPE txn_ii_relationships_tbl IS TABLE OF txn_ii_relationship_rec INDEX BY BINARY_INTEGER;
225
226 -- Name : txn_ext_attrib_value_rec
227 -- Description : record to hold the values of an item instances extended attributes.
228
229 TYPE txn_ext_attrib_value_rec IS RECORD (
230 attribute_value_id NUMBER := FND_API.G_MISS_NUM,
231 parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
232 instance_id NUMBER := FND_API.G_MISS_NUM,
233 attribute_id NUMBER := FND_API.G_MISS_NUM,
234 attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
235 attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
236 active_start_date DATE := FND_API.G_MISS_DATE,
237 active_end_date DATE := FND_API.G_MISS_DATE,
238 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
239 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
252 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
253 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
254 object_version_number NUMBER := FND_API.G_MISS_NUM
255 );
256
257
258 TYPE txn_ext_attrib_values_tbl IS table of txn_ext_attrib_value_rec INDEX BY BINARY_INTEGER;
259
260 -- Name : txn_pricing_attrib_rec
261 -- Description : record to hold the pricing attributes of an item instance.
262
263
264 TYPE txn_pricing_attrib_rec IS RECORD (
265 pricing_attribute_id NUMBER := FND_API.G_MISS_NUM,
266 parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
267 instance_id NUMBER := FND_API.G_MISS_NUM,
268 active_start_date DATE := FND_API.G_MISS_DATE,
269 active_end_date DATE := FND_API.G_MISS_DATE,
270 pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
271 pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272 pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273 pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274 pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275 pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276 pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277 pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278 pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279 pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280 pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281 pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282 pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283 pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284 pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285 pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286 pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287 pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288 pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289 pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290 pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291 pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292 pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293 pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294 pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295 pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296 pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297 pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298 pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299 pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300 pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301 pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302 pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303 pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304 pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305 pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306 pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307 pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308 pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309 pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310 pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311 pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312 pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313 pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314 pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315 pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316 pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317 pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318 pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319 pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320 pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321 pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322 pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323 pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324 pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325 pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326 pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327 pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328 pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329 pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330 pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331 pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332 pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333 pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334 pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335 pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336 pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337 pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338 pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339 pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340 pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341 pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342 pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343 pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344 pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345 pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346 pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347 pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348 pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349 pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350 pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351 pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352 pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353 pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354 pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355 pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356 pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357 pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358 pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359 pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360 pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361 pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362 pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363 pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364 pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365 pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366 pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367 pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368 pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369 pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
370 pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
372 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
386 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
387 object_version_number NUMBER := FND_API.G_MISS_NUM
388 );
389
390 TYPE txn_pricing_attribs_tbl IS TABLE OF txn_pricing_attrib_rec INDEX BY BINARY_INTEGER;
391
392 -- Name : txn_org_unit_rec
393 -- Description : record to hold information about an instance-org association.
394
395
396 TYPE txn_org_unit_rec IS RECORD (
397 instance_ou_id NUMBER := FND_API.G_MISS_NUM,
398 parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
399 instance_id NUMBER := FND_API.G_MISS_NUM,
400 operating_unit_id NUMBER := FND_API.G_MISS_NUM,
401 relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
402 active_start_date DATE := FND_API.G_MISS_DATE,
403 active_end_date DATE := FND_API.G_MISS_DATE,
404 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
405 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
417 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
418 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
419 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
420 object_version_number NUMBER := FND_API.G_MISS_NUM
421 );
422
423 TYPE txn_org_units_tbl IS TABLE OF txn_org_unit_rec INDEX BY BINARY_INTEGER;
424
425 -- Name : txn_instance_asset_rec
426 -- Description : record to hold information about instance-asset association.
427
428 TYPE txn_instance_asset_rec IS RECORD (
429 instance_asset_id NUMBER := FND_API.G_MISS_NUM,
430 parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
431 instance_id NUMBER := FND_API.G_MISS_NUM,
432 fa_asset_id NUMBER := FND_API.G_MISS_NUM,
433 fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
434 fa_location_id NUMBER := FND_API.G_MISS_NUM,
435 asset_quantity NUMBER := FND_API.G_MISS_NUM,
436 update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
437 active_start_date DATE := FND_API.G_MISS_DATE,
438 active_end_date DATE := FND_API.G_MISS_DATE,
439 object_version_number NUMBER := FND_API.G_MISS_NUM);
440
441 TYPE txn_instance_asset_tbl IS TABLE OF txn_instance_asset_rec INDEX BY BINARY_INTEGER;
442
443
444
445 /*-------------------------------------------------------------------*/
446 /* Group API used to process one source transaction line */
447 /* This api reads a set op pl/sql tables and converts them in to */
448 /* instances .If an instance reference is found then it updates the */
449 /* instance for the location and party attributes */
450 /*-------------------------------------------------------------------*/
451
452 PROCEDURE process_transaction (
453 p_api_version IN NUMBER,
454 p_commit IN VARCHAR2 := fnd_api.g_false,
455 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
456 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
457 p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
458 p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
459 p_dest_location_rec IN OUT NOCOPY dest_location_rec,
460 p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
461 p_instances_tbl IN OUT NOCOPY txn_instances_tbl,
462 p_i_parties_tbl IN OUT NOCOPY txn_i_parties_tbl,
463 p_ip_accounts_tbl IN OUT NOCOPY txn_ip_accounts_tbl,
464 p_org_units_tbl IN OUT NOCOPY txn_org_units_tbl,
465 p_ext_attrib_vlaues_tbl IN OUT NOCOPY txn_ext_attrib_values_tbl,
466 p_pricing_attribs_tbl IN OUT NOCOPY txn_pricing_attribs_tbl,
467 p_instance_asset_tbl IN OUT NOCOPY txn_instance_asset_tbl,
468 p_ii_relationships_tbl IN OUT NOCOPY txn_ii_relationships_tbl,
469 px_txn_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
470 x_return_status OUT NOCOPY VARCHAR2,
471 x_msg_count OUT NOCOPY NUMBER,
472 x_msg_data OUT NOCOPY VARCHAR2,
473 p_inv_txn_typeid_from_cs IN NUMBER DEFAULT -1); -- Bug 10415554
474
475 /* overloading to supress the visibility of the signature change to field service */
476 PROCEDURE process_transaction (
477 p_api_version IN NUMBER,
478 p_commit IN VARCHAR2 := fnd_api.g_false,
479 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
480 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
481 p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
482 p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
483 p_dest_location_rec IN OUT NOCOPY dest_location_rec,
484 p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
485 p_instances_tbl IN OUT NOCOPY txn_instances_tbl,
486 p_i_parties_tbl IN OUT NOCOPY txn_i_parties_tbl,
487 p_ip_accounts_tbl IN OUT NOCOPY txn_ip_accounts_tbl,
488 p_org_units_tbl IN OUT NOCOPY txn_org_units_tbl,
489 p_ext_attrib_vlaues_tbl IN OUT NOCOPY txn_ext_attrib_values_tbl,
490 p_pricing_attribs_tbl IN OUT NOCOPY txn_pricing_attribs_tbl,
491 p_instance_asset_tbl IN OUT NOCOPY txn_instance_asset_tbl,
492 p_ii_relationships_tbl IN OUT NOCOPY txn_ii_relationships_tbl,
493 x_return_status OUT NOCOPY VARCHAR2,
494 x_msg_count OUT NOCOPY NUMBER,
495 x_msg_data OUT NOCOPY VARCHAR2 );
496
497 END csi_process_txn_grp;