[Home] [Help]
Skip to content
PACKAGE: APPS.CSI_PROCESS_TXN_GRP
Source
1 PACKAGE csi_process_txn_grp AS
2 /* $Header: csigptxs.pls 120.3 2006/07/24 11:42:04 aradhakr noship $ */
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 OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR);
93
94 TYPE dest_location_rec IS RECORD (
95 parent_tbl_index NUMBER := fnd_api.g_miss_num,
96 location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
97 location_id NUMBER := FND_API.G_MISS_NUM,
98 install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
99 install_location_id NUMBER := FND_API.G_MISS_NUM,
100 instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
101 inv_organization_id NUMBER := FND_API.G_MISS_NUM,
102 inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
103 inv_locator_id NUMBER := FND_API.G_MISS_NUM,
104 pa_project_id NUMBER := FND_API.G_MISS_NUM,
105 pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
106 in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
107 wip_job_id NUMBER := fnd_api.g_miss_num,
108 last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
109 po_order_line_id NUMBER := fnd_api.g_miss_num,
110 last_pa_project_id NUMBER := fnd_api.g_miss_num,
111 last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
112 external_reference VARCHAR2(30) := fnd_api.g_miss_char,
113 operational_status_code VARCHAR2(30) := fnd_api.g_miss_char);
114
115
116 TYPE txn_instances_tbl is TABLE OF txn_instance_rec INDEX BY BINARY_INTEGER;
117
118 -- Name : txn_i_party_rec
119 -- Description : record to hold information about an instance-party relationship.
120
121 TYPE txn_i_party_rec IS RECORD (
122 instance_party_id NUMBER := FND_API.G_MISS_NUM,
123 parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
124 instance_id NUMBER := FND_API.G_MISS_NUM,
125 party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
126 party_id NUMBER := FND_API.G_MISS_NUM,
127 relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
128 contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
129 contact_ip_id NUMBER := FND_API.G_MISS_NUM,
130 active_start_date DATE := FND_API.G_MISS_DATE,
131 active_end_date DATE := FND_API.G_MISS_DATE,
132 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
133 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148 object_version_number NUMBER := FND_API.G_MISS_NUM
149 );
150
151 TYPE txn_i_parties_tbl IS TABLE OF txn_i_party_rec INDEX BY BINARY_INTEGER;
152
153 -- Name : txn_ip_account_rec
154 -- Description : record to hold information about a party-account relationship.
155
156 TYPE txn_ip_account_rec IS RECORD (
157 ip_account_id NUMBER := FND_API.G_MISS_NUM,
158 parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
159 instance_party_id NUMBER := FND_API.G_MISS_NUM,
160 party_account_id NUMBER := FND_API.G_MISS_NUM,
161 relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
162 bill_to_address NUMBER := FND_API.G_MISS_NUM,
163 ship_to_address NUMBER := FND_API.G_MISS_NUM,
164 active_start_date DATE := FND_API.G_MISS_DATE,
165 active_end_date DATE := FND_API.G_MISS_DATE,
166 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
167 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182 object_version_number NUMBER := FND_API.G_MISS_NUM
183 );
184
185 TYPE txn_ip_accounts_tbl IS TABLE OF txn_ip_account_rec INDEX BY BINARY_INTEGER;
186
187 -- Name : txn_ii_relationship_rec
188 -- Description : record to hold the attributes of an item instance relationship.
189
190 TYPE txn_ii_relationship_rec IS RECORD (
191 RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
192 RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
193 OBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
194 OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
195 SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196 SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197 SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
198 POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
199 ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
200 ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
201 DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
202 MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
203 CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
204 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
220 );
221
222 TYPE txn_ii_relationships_tbl IS TABLE OF txn_ii_relationship_rec INDEX BY BINARY_INTEGER;
223
224 -- Name : txn_ext_attrib_value_rec
225 -- Description : record to hold the values of an item instances extended attributes.
226
227 TYPE txn_ext_attrib_value_rec IS RECORD (
228 attribute_value_id NUMBER := FND_API.G_MISS_NUM,
229 parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
230 instance_id NUMBER := FND_API.G_MISS_NUM,
231 attribute_id NUMBER := FND_API.G_MISS_NUM,
232 attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
233 attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
234 active_start_date DATE := FND_API.G_MISS_DATE,
235 active_end_date DATE := FND_API.G_MISS_DATE,
236 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
237 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
238 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
239 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
252 object_version_number NUMBER := FND_API.G_MISS_NUM
253 );
254
255
256 TYPE txn_ext_attrib_values_tbl IS table of txn_ext_attrib_value_rec INDEX BY BINARY_INTEGER;
257
258 -- Name : txn_pricing_attrib_rec
259 -- Description : record to hold the pricing attributes of an item instance.
260
261
262 TYPE txn_pricing_attrib_rec IS RECORD (
263 pricing_attribute_id NUMBER := FND_API.G_MISS_NUM,
264 parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
265 instance_id NUMBER := FND_API.G_MISS_NUM,
266 active_start_date DATE := FND_API.G_MISS_DATE,
267 active_end_date DATE := FND_API.G_MISS_DATE,
268 pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
269 pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
270 pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
271 pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272 pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273 pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274 pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275 pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276 pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277 pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278 pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279 pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280 pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281 pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282 pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283 pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284 pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285 pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286 pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287 pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288 pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289 pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290 pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291 pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292 pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293 pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294 pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295 pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296 pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297 pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298 pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299 pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300 pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301 pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302 pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303 pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304 pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305 pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306 pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307 pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308 pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309 pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310 pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311 pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312 pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313 pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314 pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315 pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316 pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317 pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318 pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319 pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320 pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321 pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322 pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323 pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324 pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325 pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329 pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326 pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327 pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328 pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330 pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331 pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332 pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333 pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334 pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335 pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336 pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337 pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338 pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339 pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340 pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341 pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342 pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343 pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344 pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345 pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346 pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347 pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348 pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349 pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350 pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351 pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352 pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353 pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354 pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355 pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356 pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357 pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358 pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359 pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360 pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361 pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362 pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363 pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364 pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365 pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366 pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367 pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368 pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
370 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
372 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385 object_version_number NUMBER := FND_API.G_MISS_NUM
386 );
387
388 TYPE txn_pricing_attribs_tbl IS TABLE OF txn_pricing_attrib_rec INDEX BY BINARY_INTEGER;
389
390 -- Name : txn_org_unit_rec
391 -- Description : record to hold information about an instance-org association.
392
393
394 TYPE txn_org_unit_rec IS RECORD (
395 instance_ou_id NUMBER := FND_API.G_MISS_NUM,
396 parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
397 instance_id NUMBER := FND_API.G_MISS_NUM,
398 operating_unit_id NUMBER := FND_API.G_MISS_NUM,
399 relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
400 active_start_date DATE := FND_API.G_MISS_DATE,
401 active_end_date DATE := FND_API.G_MISS_DATE,
402 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
403 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
404 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
405 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
417 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
418 object_version_number NUMBER := FND_API.G_MISS_NUM
419 );
420
421 TYPE txn_org_units_tbl IS TABLE OF txn_org_unit_rec INDEX BY BINARY_INTEGER;
422
423 -- Name : txn_instance_asset_rec
424 -- Description : record to hold information about instance-asset association.
425
426 TYPE txn_instance_asset_rec IS RECORD (
427 instance_asset_id NUMBER := FND_API.G_MISS_NUM,
428 parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
429 instance_id NUMBER := FND_API.G_MISS_NUM,
430 fa_asset_id NUMBER := FND_API.G_MISS_NUM,
431 fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
432 fa_location_id NUMBER := FND_API.G_MISS_NUM,
433 asset_quantity NUMBER := FND_API.G_MISS_NUM,
434 update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
435 active_start_date DATE := FND_API.G_MISS_DATE,
436 active_end_date DATE := FND_API.G_MISS_DATE,
437 object_version_number NUMBER := FND_API.G_MISS_NUM);
438
439 TYPE txn_instance_asset_tbl IS TABLE OF txn_instance_asset_rec INDEX BY BINARY_INTEGER;
440
441
442
443 /*-------------------------------------------------------------------*/
444 /* Group API used to process one source transaction line */
445 /* This api reads a set op pl/sql tables and converts them in to */
446 /* instances .If an instance reference is found then it updates the */
447 /* instance for the location and party attributes */
448 /*-------------------------------------------------------------------*/
449
450 PROCEDURE process_transaction (
451 p_api_version IN NUMBER,
452 p_commit IN VARCHAR2 := fnd_api.g_false,
453 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
454 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
455 p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
456 p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
457 p_dest_location_rec IN OUT NOCOPY dest_location_rec,
458 p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
459 p_instances_tbl IN OUT NOCOPY txn_instances_tbl,
460 p_i_parties_tbl IN OUT NOCOPY txn_i_parties_tbl,
461 p_ip_accounts_tbl IN OUT NOCOPY txn_ip_accounts_tbl,
462 p_org_units_tbl IN OUT NOCOPY txn_org_units_tbl,
463 p_ext_attrib_vlaues_tbl IN OUT NOCOPY txn_ext_attrib_values_tbl,
464 p_pricing_attribs_tbl IN OUT NOCOPY txn_pricing_attribs_tbl,
465 p_instance_asset_tbl IN OUT NOCOPY txn_instance_asset_tbl,
466 p_ii_relationships_tbl IN OUT NOCOPY txn_ii_relationships_tbl,
467 px_txn_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
468 x_return_status OUT NOCOPY VARCHAR2,
469 x_msg_count OUT NOCOPY NUMBER,
470 x_msg_data OUT NOCOPY VARCHAR2 );
471
472 /* overloading to supress the visibility of the signature change to field service */
473 PROCEDURE process_transaction (
474 p_api_version IN NUMBER,
475 p_commit IN VARCHAR2 := fnd_api.g_false,
476 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
477 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
478 p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
479 p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
480 p_dest_location_rec IN OUT NOCOPY dest_location_rec,
481 p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
482 p_instances_tbl IN OUT NOCOPY txn_instances_tbl,
483 p_i_parties_tbl IN OUT NOCOPY txn_i_parties_tbl,
484 p_ip_accounts_tbl IN OUT NOCOPY txn_ip_accounts_tbl,
485 p_org_units_tbl IN OUT NOCOPY txn_org_units_tbl,
486 p_ext_attrib_vlaues_tbl IN OUT NOCOPY txn_ext_attrib_values_tbl,
487 p_pricing_attribs_tbl IN OUT NOCOPY txn_pricing_attribs_tbl,
488 p_instance_asset_tbl IN OUT NOCOPY txn_instance_asset_tbl,
489 p_ii_relationships_tbl IN OUT NOCOPY txn_ii_relationships_tbl,
490 x_return_status OUT NOCOPY VARCHAR2,
491 x_msg_count OUT NOCOPY NUMBER,
492 x_msg_data OUT NOCOPY VARCHAR2 );
493
494 END csi_process_txn_grp;