[Home] [Help]
PACKAGE: APPS.ENG_LAUNCH_ECO_OI_PK
Source
1 PACKAGE ENG_LAUNCH_ECO_OI_PK AUTHID CURRENT_USER AS
2 /* $Header: ENCOINS.pls 120.0.12000000.2 2007/09/04 07:23:11 jiabraha ship $ */
3
4 G_ROWS_TO_COMMIT CONSTANT NUMBER := 500;
5 G_SUCCESS CONSTANT NUMBER := 0;
6 G_WARNING CONSTANT NUMBER := 1;
7 G_ERROR CONSTANT NUMBER := 2;
8 G_CREATE CONSTANT VARCHAR2(10) := 'CREATE';
9 G_UPDATE CONSTANT VARCHAR2(10) := 'UPDATE';
10 G_DELETE CONSTANT VARCHAR2(10) := 'DELETE';
11 G_CANCEL CONSTANT VARCHAR2(10) := 'CANCEL';
12
13 -- Process Flag Values
14 G_PF_PENDING CONSTANT NUMBER := 1;
15 G_PF_ERROR CONSTANT NUMBER := 3;
16 G_PF_SUCCESS CONSTANT NUMBER := 7;
17
18 -- PLM Changemanagement Upload Revised Items
19 G_PLM_OR_ERP VARCHAR2(100) := 'ERP';
20
21 -- Eco record type
22
23 TYPE Encoin_Eco_Rec_Type IS RECORD
24 ( change_notice VARCHAR2(10) --:= NULL --FND_API.G_MISS_NUM
25 , organization_code VARCHAR2(3) --:= NULL --FND_API.G_MISS_CHAR
26 , request_id NUMBER --:= NULL --FND_API.G_MISS_NUM
27 , program_application_id NUMBER --:= NULL --FND_API.G_MISS_NUM
28 , program_id NUMBER --:= NULL --FND_API.G_MISS_NUM
29 , program_update_date DATE --:= NULL --FND_API.G_MISS_DATE
30 , approval_status_type NUMBER --:= NULL --FND_API.G_MISS_NUM
31 , approval_date DATE --:= NULL --FND_API.G_MISS_DATE
32 , approval_list_id NUMBER --:= NULL --FND_API.G_MISS_NUM
33 , change_order_type_id NUMBER --:= NULL --FND_API.G_MISS_NUM
34 , responsible_org_id NUMBER --:= NULL --FND_API.G_MISS_NUM
35 , approval_request_date DATE --:= NULL --FND_API.G_MISS_DATE
36 , last_update_date DATE --:= NULL --FND_API.G_MISS_DATE
37 , last_updated_by NUMBER --:= NULL --FND_API.G_MISS_NUM
38 , creation_date DATE --:= NULL --FND_API.G_MISS_DATE
39 , created_by NUMBER --:= NULL --FND_API.G_MISS_NUM
40 , last_update_login NUMBER --:= NULL --FND_API.G_MISS_NUM
41 , description VARCHAR2(2000) --:= NULL --FND_API.G_MISS_CHAR
42 , status_type NUMBER --:= NULL --FND_API.G_MISS_NUM
43 , initiation_date DATE --:= NULL --FND_API.G_MISS_DATE
44 , implementation_date DATE --:= NULL --FND_API.G_MISS_DATE
45 , cancellation_date DATE --:= NULL --FND_API.G_MISS_DATE
46 , cancellation_comments VARCHAR2(240) --:= NULL --FND_API.G_MISS_CHAR
47 , priority_code VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
48 , reason_code VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
49 , estimated_eng_cost NUMBER --:= NULL --FND_API.G_MISS_NUM
50 , estimated_mfg_cost NUMBER --:= NULL --FND_API.G_MISS_NUM
51 , requestor_id NUMBER --:= NULL --FND_API.G_MISS_NUM
52 , attribute_category VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
53 , attribute1 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
54 , attribute2 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
55 , attribute3 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
56 , attribute4 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
57 , attribute5 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
58 , attribute6 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
59 , attribute7 VARCHAR2(150) --:= NULL FND_API.G_MISS_CHAR
60 , attribute8 VARCHAR2(150) --:= NULL FND_API.G_MISS_CHAR
61 , attribute9 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
62 , attribute10 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
63 , attribute11 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
64 , attribute12 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
65 , attribute13 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
66 , attribute14 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
67 , attribute15 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
68 , process_flag NUMBER --:= NULL --FND_API.G_MISS_NUM
69 , transaction_id NUMBER --:= NULL --FND_API.G_MISS_NUM
70 , approval_list_name VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
71 , change_order_type VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
72 , responsible_org_code VARCHAR2(3) --:= NULL --FND_API.G_MISS_CHAR
73 , return_status VARCHAR2(1) --:= NULL --FND_API.G_MISS_CHAR
74 , db_flag VARCHAR2(1) --:= NULL --FND_API.G_MISS_CHAR
75 , operation VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
76 , eng_changes_ifce_key VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
77 );
78
79 TYPE Encoin_Eco_Tbl_Type IS TABLE OF Encoin_Eco_Rec_Type
80 INDEX BY BINARY_INTEGER;
81
82 -- Eco_Revision record type
83
84 TYPE Encoin_Eco_Revision_Rec_Type IS RECORD
85 ( attribute11 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
86 , attribute12 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
87 , attribute13 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
88 , attribute14 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
89 , attribute15 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
90 , program_application_id NUMBER --:= NULL --FND_API.G_MISS_NUM
91 , program_id NUMBER --:= NULL --FND_API.G_MISS_NUM
92 , program_update_date DATE --:= NULL --FND_API.G_MISS_DATE
93 , request_id NUMBER --:= NULL --FND_API.G_MISS_NUM
94 , revision_id NUMBER --:= NULL --FND_API.G_MISS_NUM
95 , change_notice VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
96 , organization_id NUMBER --:= NULL --FND_API.G_MISS_NUM
97 , rev VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
98 , last_update_date DATE --:= NULL --FND_API.G_MISS_DATE
99 , last_updated_by NUMBER --:= NULL --FND_API.G_MISS_NUM
100 , creation_date DATE --:= NULL --FND_API.G_MISS_DATE
101 , created_by NUMBER --:= NULL --FND_API.G_MISS_NUM
102 , last_update_login NUMBER --:= NULL --FND_API.G_MISS_NUM
103 , comments VARCHAR2(240) --:= NULL --FND_API.G_MISS_CHAR
104 , attribute_category VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
105 , attribute1 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
106 , attribute2 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
107 , attribute3 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
108 , attribute4 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
109 , attribute5 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
110 , attribute6 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
111 , attribute7 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
112 , attribute8 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
113 , attribute9 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
114 , attribute10 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
115 , new_revision VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
116 , organization_code VARCHAR2(3) --:= NULL --FND_API.G_MISS_CHAR
117 , process_flag NUMBER --:= NULL --FND_API.G_MISS_NUM
118 , transaction_id NUMBER --:= NULL --FND_API.G_MISS_NUM
119 , return_status VARCHAR2(1) --:= NULL --FND_API.G_MISS_CHAR
120 , db_flag VARCHAR2(1) --:= NULL --FND_API.G_MISS_CHAR
121 , operation VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
122 , eng_changes_ifce_key VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
123 , eng_eco_revisions_ifce_key VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
124 );
125
126 TYPE Encoin_Eco_Revision_Tbl_Type IS TABLE OF Encoin_Eco_Revision_Rec_Type
127 INDEX BY BINARY_INTEGER;
128
129 -- Revised_Item record type
130
131 TYPE Encoin_Revised_Item_Rec_Type IS RECORD
132 (
133 /* using_assembly_id NUMBER := NULL --FND_API.G_MISS_NUM
134 ,*/
135 change_notice VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
136 , organization_id NUMBER --:= NULL --FND_API.G_MISS_NUM
137 , revised_item_id NUMBER --:= NULL --FND_API.G_MISS_NUM
138 , last_update_date DATE --:= NULL --FND_API.G_MISS_DATE
139 , last_updated_by NUMBER --:= NULL --FND_API.G_MISS_NUM
140 , creation_date DATE --:= NULL --FND_API.G_MISS_DATE
141 , created_by NUMBER --:= NULL --FND_API.G_MISS_NUM
142 , last_update_login NUMBER --:= NULL --FND_API.G_MISS_NUM
143 , implementation_date DATE --:= NULL --FND_API.G_MISS_DATE
144 , cancellation_date DATE --:= NULL --FND_API.G_MISS_DATE
145 , cancel_comments VARCHAR2(240) --:= NULL --FND_API.G_MISS_CHAR
146 , disposition_type NUMBER --:= NULL --FND_API.G_MISS_NUM
147 , new_item_revision VARCHAR2(3) --:= NULL --FND_API.G_MISS_CHAR
148 , early_schedule_date DATE --:= NULL --FND_API.G_MISS_DATE
149 , attribute_category VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
150 , attribute2 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
151 , attribute3 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
152 , attribute4 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
153 , attribute5 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
154 , attribute7 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
155 , attribute8 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
156 , attribute9 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
157 , attribute11 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
158 , attribute12 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
159 , attribute13 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
160 , attribute14 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
161 , attribute15 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
162 , status_type NUMBER --:= NULL --FND_API.G_MISS_NUM
163 , scheduled_date DATE --:= NULL --FND_API.G_MISS_DATE
164 , bill_sequence_id NUMBER --:= NULL --FND_API.G_MISS_NUM
165 , mrp_active NUMBER --:= NULL --FND_API.G_MISS_NUM
166 , request_id NUMBER --:= NULL --FND_API.G_MISS_NUM
167 , program_application_id NUMBER --:= NULL --FND_API.G_MISS_NUM
168 , program_id NUMBER --:= NULL --FND_API.G_MISS_NUM
169 , program_update_date DATE --:= NULL --FND_API.G_MISS_DATE
170 , update_wip NUMBER --:= NULL --FND_API.G_MISS_NUM
171 , use_up NUMBER --:= NULL --FND_API.G_MISS_NUM
172 , use_up_item_id NUMBER --:= NULL --FND_API.G_MISS_NUM
173 , revised_item_sequence_id NUMBER --:= NULL --FND_API.G_MISS_NUM
174 , use_up_plan_name VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
175 , descriptive_text VARCHAR2(240) --:= NULL --FND_API.G_MISS_CHAR
176 , auto_implement_date DATE --:= NULL --FND_API.G_MISS_DATE
177 , attribute1 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
178 , attribute6 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
179 , attribute10 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
180 , requestor_id NUMBER --:= NULL --FND_API.G_MISS_NUM
181 , comments VARCHAR2(240) --:= NULL --FND_API.G_MISS_CHAR
182 , process_flag NUMBER --:= NULL --FND_API.G_MISS_NUM
183 , transaction_id NUMBER --:= NULL --FND_API.G_MISS_NUM
184 , organization_code VARCHAR2(3) --:= NULL --FND_API.G_MISS_CHAR
185 , revised_item_number VARCHAR2(81) --:= NULL --FND_API.G_MISS_CHAR
186 , new_rtg_revision VARCHAR2(3) --:= NULL --FND_API.G_MISS_CHAR
187 , use_up_item_number VARCHAR2(81) --:= NULL --FND_API.G_MISS_CHAR
188 , alternate_bom_designator VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
189 , return_status VARCHAR2(1) --:= NULL --FND_API.G_MISS_CHAR
190 , db_flag VARCHAR2(1) --:= NULL --FND_API.G_MISS_CHAR
191 , operation VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
192 , eng_changes_ifce_key VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
193 , eng_revised_items_ifce_key VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
194 --11.5.10
195 , parent_revised_item_name VARCHAR2(240)
196 , parent_alternate_name VARCHAR2(240)
197 , updated_item_revision VARCHAR2(3) -- Bug 3432944
198 , New_scheduled_date DATE -- Bug 3432944
199 , From_Item_Revision VARCHAR2(3) -- 11.5.10E
200 , New_Revision_Label VARCHAR2(80)
201 , New_Revised_Item_Rev_Desc VARCHAR2(240)
202 , New_Revision_Reason VARCHAR2(80)
203 --, basis_type NUMBER --:= NULL --ENH
204 , from_end_item_unit_number VARCHAR2(30) /*Bug 6377841*/
205 );
206
207 TYPE Encoin_Revised_Item_Tbl_Type IS TABLE OF Encoin_Revised_Item_Rec_Type
208 INDEX BY BINARY_INTEGER;
209
210 -- Rev_Component record type
211
212 TYPE Encoin_Rev_Component_Rec_Type IS RECORD
213 ( supply_subinventory VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
214 , op_lead_time_percent NUMBER --:= NULL --FND_API.G_MISS_NUM
215 , revised_item_sequence_id NUMBER --:= NULL --FND_API.G_MISS_NUM
216 , cost_factor NUMBER --:= NULL --FND_API.G_MISS_NUM
217 , required_for_revenue NUMBER --:= NULL --FND_API.G_MISS_NUM
218 , high_quantity NUMBER --:= NULL --FND_API.G_MISS_NUM
219 , component_sequence_id NUMBER --:= NULL --FND_API.G_MISS_NUM
220 , program_application_id NUMBER --:= NULL --FND_API.G_MISS_NUM
221 , wip_supply_type NUMBER --:= NULL --FND_API.G_MISS_NUM
222 , supply_locator_id NUMBER --:= NULL --FND_API.G_MISS_NUM
223 , bom_item_type NUMBER --:= NULL --FND_API.G_MISS_NUM
224 , operation_seq_num NUMBER --:= NULL --FND_API.G_MISS_NUM
225 , component_item_id NUMBER --:= NULL --FND_API.G_MISS_NUM
229 , created_by NUMBER --:= NULL --FND_API.G_MISS_NUM
226 , last_update_date DATE --:= NULL --FND_API.G_MISS_DATE
227 , last_updated_by NUMBER --:= NULL --FND_API.G_MISS_NUM
228 , creation_date DATE --:= NULL --FND_API.G_MISS_DATE
230 , last_update_login NUMBER --:= NULL --FND_API.G_MISS_NUM
231 , item_num NUMBER --:= NULL --FND_API.G_MISS_NUM
232 , component_quantity NUMBER --:= NULL --FND_API.G_MISS_NUM
233 , component_yield_factor NUMBER --:= NULL --FND_API.G_MISS_NUM
234 , component_remarks VARCHAR2(240) --:= NULL --FND_API.G_MISS_CHAR
235 , revised_item_number VARCHAR2(81) --:= NULL --FND_API.G_MISS_CHAR
236 , effectivity_date DATE --:= NULL --FND_API.G_MISS_DATE
237 , change_notice VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
238 , implementation_date DATE --:= NULL --FND_API.G_MISS_DATE
239 , disable_date DATE --:= NULL --FND_API.G_MISS_DATE
240 , attribute_category VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
241 , attribute1 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
242 , attribute2 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
243 , attribute3 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
244 , attribute4 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
245 , attribute5 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
246 , attribute6 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
247 , attribute7 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
248 , attribute8 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
249 , attribute9 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
250 , attribute10 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
251 , attribute11 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
252 , attribute12 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
253 , attribute13 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
254 , attribute14 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
255 , attribute15 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
256 , planning_factor NUMBER --:= NULL --FND_API.G_MISS_NUM
257 , quantity_related NUMBER --:= NULL --FND_API.G_MISS_NUM
258 , so_basis NUMBER --:= NULL --FND_API.G_MISS_NUM
259 , optional NUMBER --:= NULL --FND_API.G_MISS_NUM
260 , mutually_exclusive_opt NUMBER --:= NULL --FND_API.G_MISS_NUM
261 , include_in_cost_rollup NUMBER --:= NULL --FND_API.G_MISS_NUM
262 , check_atp NUMBER --:= NULL --FND_API.G_MISS_NUM
263 , shipping_allowed NUMBER --:= NULL --FND_API.G_MISS_NUM
264 , required_to_ship NUMBER --:= NULL --FND_API.G_MISS_NUM
265 , include_on_ship_docs NUMBER --:= NULL --FND_API.G_MISS_NUM
266 , include_on_bill_docs NUMBER --:= NULL --FND_API.G_MISS_NUM
267 , low_quantity NUMBER --:= NULL --FND_API.G_MISS_NUM
268 , acd_type NUMBER --:= NULL --FND_API.G_MISS_NUM
269 , old_component_sequence_id NUMBER --:= NULL --FND_API.G_MISS_NUM
270 , bill_sequence_id NUMBER --:= NULL --FND_API.G_MISS_NUM
271 , request_id NUMBER --:= NULL --FND_API.G_MISS_NUM
272 , program_id NUMBER --:= NULL --FND_API.G_MISS_NUM
273 , program_update_date DATE --:= NULL --FND_API.G_MISS_DATE
274 , pick_components NUMBER --:= NULL --FND_API.G_MISS_NUM
275 , assembly_type NUMBER --:= NULL --FND_API.G_MISS_NUM
276 , interface_entity_type VARCHAR2(4) --:= NULL --FND_API.G_MISS_CHAR
277 , reference_designator VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
278 , new_effectivity_date DATE --:= NULL --FND_API.G_MISS_DATE
279 , old_effectivity_date DATE --:= NULL --FND_API.G_MISS_DATE
280 , substitute_comp_id NUMBER --:= NULL --FND_API.G_MISS_NUM
281 , new_operation_seq_num NUMBER --:= NULL --FND_API.G_MISS_NUM
282 , old_operation_seq_num NUMBER --:= NULL --FND_API.G_MISS_NUM
283 , substitute_comp_number VARCHAR2(81) --:= NULL --FND_API.G_MISS_CHAR
284 , organization_code VARCHAR2(3) --:= NULL --FND_API.G_MISS_CHAR
285 , assembly_item_number VARCHAR2(81) --:= NULL --FND_API.G_MISS_CHAR
286 , component_item_number VARCHAR2(81) --:= NULL --FND_API.G_MISS_CHAR
287 , location_name VARCHAR2(81) --:= NULL --FND_API.G_MISS_CHAR
288 , organization_id NUMBER --:= NULL --FND_API.G_MISS_NUM
289 , assembly_item_id NUMBER --:= NULL --FND_API.G_MISS_NUM
290 , alternate_bom_designator VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
291 , process_flag NUMBER --:= NULL --FND_API.G_MISS_NUM
292 , transaction_id NUMBER --:= NULL --FND_API.G_MISS_NUM
293 , return_status VARCHAR2(1) --:= NULL --FND_API.G_MISS_CHAR
294 , db_flag VARCHAR2(1) --:= NULL --FND_API.G_MISS_CHAR
295 , operation VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
296 , eng_changes_ifce_key VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
297 , eng_revised_items_ifce_key VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
298 , bom_inventory_comps_ifce_key VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
299 , revised_item_tbl_index NUMBER --:= NULL --FND_API.G_MISS_NUM
300 -- Bug 3396529
301 , New_revised_Item_Revision VARCHAR2(3)
302 , basis_type NUMBER --:= NULL --ENH
303 , from_end_item_unit_number VARCHAR2(30) /*Bug 6377841*/
304 , to_end_item_unit_number VARCHAR2(30) /*Bug 6377841*/
305
306 );
307
308 TYPE Encoin_Rev_Component_Tbl_Type IS TABLE OF Encoin_Rev_Component_Rec_Type
309 INDEX BY BINARY_INTEGER;
310
311 -- Ref_Designator record type
312
313 TYPE Encoin_Ref_Designator_Rec_Type IS RECORD
314 ( ref_designator VARCHAR2(15) --:= NULL --FND_API.G_MISS_CHAR
315 , last_update_date DATE --:= NULL --FND_API.G_MISS_DATE
316 , last_updated_by NUMBER --:= NULL --FND_API.G_MISS_NUM
317 , creation_date DATE --:= NULL --FND_API.G_MISS_DATE
318 , created_by NUMBER --:= NULL --FND_API.G_MISS_NUM
319 , last_update_login NUMBER --:= NULL --FND_API.G_MISS_NUM
320 , ref_designator_comment VARCHAR2(240) --:= NULL --FND_API.G_MISS_CHAR
321 , change_notice VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
322 , component_sequence_id NUMBER --:= NULL --FND_API.G_MISS_NUM
323 , acd_type NUMBER --:= NULL --FND_API.G_MISS_NUM
324 , request_id NUMBER --:= NULL --FND_API.G_MISS_NUM
325 , program_application_id NUMBER --:= NULL --FND_API.G_MISS_NUM
326 , program_id NUMBER --:= NULL --FND_API.G_MISS_NUM
327 , program_update_date DATE --:= NULL --FND_API.G_MISS_DATE
328 , attribute_category VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
329 , attribute1 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
330 , attribute2 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
331 , attribute3 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
332 , attribute4 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
333 , attribute5 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
334 , attribute6 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
335 , attribute7 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
336 , attribute8 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
337 , attribute9 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
338 , attribute10 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
339 , attribute11 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
340 , attribute12 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
341 , attribute13 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
342 , attribute14 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
343 , attribute15 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
344 , new_designator VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
345 , process_flag NUMBER --:= NULL --FND_API.G_MISS_NUM
346 , transaction_id NUMBER --:= NULL --FND_API.G_MISS_NUM
347 , assembly_item_number VARCHAR2(81) --:= NULL --FND_API.G_MISS_CHAR
348 , component_item_number VARCHAR2(81) --:= NULL --FND_API.G_MISS_CHAR
349 , organization_code VARCHAR2(3) --:= NULL --FND_API.G_MISS_CHAR
350 , organization_id NUMBER --:= NULL --FND_API.G_MISS_NUM
351 , assembly_item_id NUMBER --:= NULL --FND_API.G_MISS_NUM
352 , alternate_bom_designator VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
353 , component_item_id NUMBER --:= NULL --FND_API.G_MISS_NUM
354 , bill_sequence_id NUMBER --:= NULL --FND_API.G_MISS_NUM
355 , operation_seq_num NUMBER --:= NULL --FND_API.G_MISS_NUM
356 , effectivity_date DATE --:= NULL --FND_API.G_MISS_DATE
357 , interface_entity_type VARCHAR2(4) --:= NULL --FND_API.G_MISS_CHAR
358 , return_status VARCHAR2(1) --:= NULL --FND_API.G_MISS_CHAR
359 , db_flag VARCHAR2(1) --:= NULL --FND_API.G_MISS_CHAR
360 , operation VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
361 , eng_changes_ifce_key VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
362 , eng_revised_items_ifce_key VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
363 , bom_inventory_comps_ifce_key VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
364 , bom_ref_desgs_ifce_key VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
365 , revised_item_tbl_index NUMBER --:= NULL --FND_API.G_MISS_NUM
366 , revised_comp_tbl_index NUMBER --:= NULL --FND_API.G_MISS_NUM
367 -- Bug 3396529
368 , New_revised_Item_Revision VARCHAR2(3)
369
370 );
371
372 TYPE Encoin_Ref_Designator_Tbl_Type IS TABLE OF Encoin_Ref_Designator_Rec_Type
373 INDEX BY BINARY_INTEGER;
374
375 -- Sub_Component record type
376
380 , last_updated_by NUMBER --:= NULL --FND_API.G_MISS_NUM
377 TYPE Encoin_Sub_Component_Rec_Type IS RECORD
378 ( substitute_component_id NUMBER --:= NULL --FND_API.G_MISS_NUM
379 , last_update_date DATE --:= NULL --FND_API.G_MISS_DATE
381 , creation_date DATE --:= NULL --FND_API.G_MISS_DATE
382 , created_by NUMBER --:= NULL --FND_API.G_MISS_NUM
383 , last_update_login NUMBER --:= NULL --FND_API.G_MISS_NUM
384 , substitute_item_quantity NUMBER --:= NULL --FND_API.G_MISS_NUM
385 , component_sequence_id NUMBER --:= NULL --FND_API.G_MISS_NUM
386 , acd_type NUMBER --:= NULL --FND_API.G_MISS_NUM
387 , change_notice VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
388 , request_id NUMBER --:= NULL --FND_API.G_MISS_NUM
389 , program_application_id NUMBER --:= NULL --FND_API.G_MISS_NUM
390 , program_update_date DATE --:= NULL --FND_API.G_MISS_DATE
391 , attribute_category VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
392 , attribute1 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
393 , attribute2 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
394 , attribute4 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
395 , attribute5 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
396 , attribute6 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
397 , attribute8 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
398 , attribute9 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
399 , attribute10 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
400 , attribute12 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
401 , attribute13 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
402 , attribute14 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
403 , attribute15 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
404 , program_id NUMBER --:= NULL --FND_API.G_MISS_NUM
405 , attribute3 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
406 , attribute7 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
407 , attribute11 VARCHAR2(150) --:= NULL --FND_API.G_MISS_CHAR
408 , new_sub_comp_id NUMBER --:= NULL --FND_API.G_MISS_NUM
409 , process_flag NUMBER --:= NULL --FND_API.G_MISS_NUM
410 , transaction_id NUMBER --:= NULL --FND_API.G_MISS_NUM
411 , new_sub_comp_number VARCHAR2(81) --:= NULL --FND_API.G_MISS_CHAR
412 , assembly_item_number VARCHAR2(81) --:= NULL --FND_API.G_MISS_CHAR
413 , component_item_number VARCHAR2(81) --:= NULL --FND_API.G_MISS_CHAR
414 , substitute_comp_number VARCHAR2(81) --:= NULL --FND_API.G_MISS_CHAR
415 , organization_code VARCHAR2(3) --:= NULL --FND_API.G_MISS_CHAR
416 , organization_id NUMBER --:= NULL --FND_API.G_MISS_NUM
417 , assembly_item_id NUMBER --:= NULL --FND_API.G_MISS_NUM
418 , alternate_bom_designator VARCHAR2(10) --:= NULL --FND_API.G_MISS_CHAR
419 , component_item_id NUMBER --:= NULL --FND_API.G_MISS_NUM
420 , bill_sequence_id NUMBER --:= NULL --FND_API.G_MISS_NUM
421 , operation_seq_num NUMBER --:= NULL --FND_API.G_MISS_NUM
422 , effectivity_date DATE --:= NULL --FND_API.G_MISS_DATE
423 , interface_entity_type VARCHAR2(4) --:= NULL --FND_API.G_MISS_CHAR
424 , return_status VARCHAR2(1) --:= NULL --FND_API.G_MISS_CHAR
425 , db_flag VARCHAR2(1) --:= NULL --FND_API.G_MISS_CHAR
426 , operation VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
427 , eng_changes_ifce_key VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
428 , eng_revised_items_ifce_key VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
429 , bom_inventory_comps_ifce_key VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
430 , bom_sub_comps_ifce_key VARCHAR2(30) --:= NULL --FND_API.G_MISS_CHAR
431 , revised_item_tbl_index NUMBER --:= NULL --FND_API.G_MISS_NUM
432 , revised_comp_tbl_index NUMBER --:= NULL --FND_API.G_MISS_NUM
433 -- Bug 3396529
434 , New_revised_Item_Revision VARCHAR2(3)
435
436 );
437
438 TYPE Encoin_Sub_Component_Tbl_Type IS TABLE OF Encoin_Sub_Component_Rec_Type
439 INDEX BY BINARY_INTEGER;
440
441 PROCEDURE Eng_Launch_Import (
442 ERRBUF OUT NOCOPY VARCHAR2,
443 RETCODE OUT NOCOPY NUMBER,
444 p_org_id NUMBER,
445 p_all_org NUMBER := 1,
446 p_del_rec_flag NUMBER := 1);
447
448 PROCEDURE Eng_Launch_RevisedItems_Import (
449 ERRBUF OUT NOCOPY VARCHAR2,
450 RETCODE OUT NOCOPY NUMBER,
451 p_org_id NUMBER,
452 p_all_org NUMBER := 1,
453 p_del_rec_flag NUMBER := 1);
454
455 END ENG_LAUNCH_ECO_OI_PK;