[Home] [Help]
PACKAGE BODY: APPS.EAM_CE_WORK_ORDER_LINES_PKG
Source
1 PACKAGE BODY EAM_CE_WORK_ORDER_LINES_PKG AS
2 /* $Header: EAMTCWOB.pls 120.2.12020000.2 2012/11/01 20:10:02 devijay ship $ */
3 -- Start of Comments
4 -- Package name : EAM_CE_WORK_ORDER_LINES_PKG
5 -- Purpose : Base Package to Insert/Delete/Update EAM_CE_WORK_ORDER_LINES
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_CE_WORK_ORDER_LINES_PKG';
11 G_FILE_NAME CONSTANT VARCHAR2(12) := 'EAMTCWOB.pls';
12
13 PROCEDURE INSERT_ROW
14 (
15 p_estimate_work_order_line_id NUMBER,
16 p_estimate_work_order_id NUMBER,
17 p_src_cu_id NUMBER,
18 p_src_activity_id NUMBER,
19 p_src_activity_qty NUMBER,
20 p_src_op_seq_num NUMBER,
21 p_src_acct_class_code VARCHAR2,
22 p_src_diff_id NUMBER,
23 p_diff_qty NUMBER,
24 p_estimate_id NUMBER,
25 p_organization_id NUMBER,
26 p_work_order_seq_num NUMBER,
27 p_work_order_number VARCHAR2,
28 p_work_order_description VARCHAR2,
29 p_ref_wip_entity_id NUMBER,
30 p_primary_item_id NUMBER,
31 p_status_type NUMBER,
32 p_acct_class_code VARCHAR2,
33 p_scheduled_start_date DATE,
34 p_scheduled_completion_date DATE,
35 p_project_id NUMBER,
36 p_task_id NUMBER,
37 p_maintenance_object_id NUMBER,
38 p_maintenance_object_type NUMBER,
39 p_maintenance_object_source NUMBER,
40 p_owning_department_id NUMBER,
41 p_user_defined_status_id NUMBER,
42 p_op_seq_num NUMBER,
43 p_op_description VARCHAR2,
44 p_standard_operation_id NUMBER,
45 p_op_department_id NUMBER,
46 p_op_long_description VARCHAR2,
47 p_res_seq_num NUMBER,
48 p_res_id NUMBER,
49 p_res_uom VARCHAR2,
50 p_res_basis_type NUMBER,
51 p_res_usage_rate_or_amount NUMBER,
52 p_res_required_units NUMBER,
53 p_res_assigned_units NUMBER,
54 p_item_type NUMBER,
55 p_required_quantity NUMBER,
56 p_unit_price NUMBER,
57 p_uom VARCHAR2,
58 p_basis_type NUMBER,
59 p_suggested_vendor_name VARCHAR2,
60 p_suggested_vendor_id NUMBER,
61 p_suggested_vendor_site VARCHAR2,
62 p_suggested_vendor_site_id NUMBER,
63 p_mat_inventory_item_id NUMBER,
64 p_mat_component_seq_num NUMBER,
65 p_mat_supply_subinventory VARCHAR2,
66 p_mat_supply_locator_id NUMBER,
67 p_di_amount NUMBER,
68 p_di_order_type_lookup_code VARCHAR2,
69 p_di_description VARCHAR2,
70 p_di_purchase_category_id NUMBER,
71 p_di_auto_request_material VARCHAR2,
72 p_di_need_by_date DATE,
73 p_work_order_line_cost NUMBER,
74 p_creation_date DATE,
75 p_created_by NUMBER,
76 p_last_update_date DATE,
77 p_last_updated_by NUMBER,
78 p_last_update_login NUMBER,
79 p_work_order_type NUMBER,
80 p_activity_type NUMBER,
81 p_activity_source NUMBER,
82 p_activity_cause NUMBER,
83 p_available_qty NUMBER,
84 p_item_comments VARCHAR2,
85 p_cu_qty NUMBER,
86 p_res_sch_flag NUMBER
87
88 )
89 IS
90 l_wo_line_id_seq NUMBER;
91 BEGIN
92 IF (p_estimate_id IS NOT NULL) OR (p_estimate_id <> FND_API.G_MISS_NUM) THEN
93
94 IF p_estimate_work_order_line_id IS NULL THEN
95 SELECT EAM_CE_WORK_ORDER_LINES_S.NEXTVAL INTO l_wo_line_id_seq FROM DUAL;
96
97
98
99 ELSE
100 l_wo_line_id_seq := p_estimate_work_order_line_id;
101 END IF;
102
103 INSERT INTO EAM_CE_WORK_ORDER_LINES(
104 ESTIMATE_WORK_ORDER_LINE_ID,
105 ESTIMATE_WORK_ORDER_ID
106 ,SRC_CU_ID
107 ,SRC_ACTIVITY_ID
108 ,SRC_ACTIVITY_QTY
109 ,SRC_OP_SEQ_NUM
110 ,SRC_ACCT_CLASS_CODE
111 ,SRC_DIFFICULTY_ID
112 ,DIFFICULTY_QTY
113 ,ESTIMATE_ID
114 ,ORGANIZATION_ID
115 ,WORK_ORDER_SEQ_NUM
116 ,WORK_ORDER_NUMBER
117 ,WORK_ORDER_DESCRIPTION
118 ,REF_WIP_ENTITY_ID
119 ,PRIMARY_ITEM_ID
120 ,STATUS_TYPE
121 ,ACCT_CLASS_CODE
122 ,SCHEDULED_START_DATE
123 ,SCHEDULED_COMPLETION_DATE
124 ,PROJECT_ID
125 ,TASK_ID
126 ,MAINTENANCE_OBJECT_ID
127 ,MAINTENANCE_OBJECT_TYPE
128 ,MAINTENANCE_OBJECT_SOURCE
129 ,OWNING_DEPARTMENT_ID
130 ,USER_DEFINED_STATUS_ID
131 ,OP_SEQ_NUM
132 ,OP_DESCRIPTION
133 ,STANDARD_OPERATION_ID
134 ,OP_DEPARTMENT_ID
135 ,OP_LONG_DESCRIPTION
136 ,RES_SEQ_NUM
137 ,RES_ID
138 ,RES_UOM
139 ,RES_BASIS_TYPE
140 ,RES_USAGE_RATE_OR_AMOUNT
141 ,RES_REQUIRED_UNITS
142 ,RES_ASSIGNED_UNITS
143 ,ITEM_TYPE
144 ,REQUIRED_QUANTITY
145 ,UNIT_PRICE
146 ,UOM
147 ,BASIS_TYPE
148 ,SUGGESTED_VENDOR_NAME
149 ,SUGGESTED_VENDOR_ID
150 ,SUGGESTED_VENDOR_SITE
151 ,SUGGESTED_VENDOR_SITE_ID
152 ,MAT_INVENTORY_ITEM_ID
153 ,MAT_COMPONENT_SEQ_NUM
154 ,MAT_SUPPLY_SUBINVENTORY
155 ,MAT_SUPPLY_LOCATOR_ID
156 ,DI_AMOUNT
157 ,DI_ORDER_TYPE_LOOKUP_CODE
158 ,DI_DESCRIPTION
159 ,DI_PURCHASE_CATEGORY_ID
160 ,DI_AUTO_REQUEST_MATERIAL
161 ,DI_NEED_BY_DATE
162 ,WO_LINE_PER_UNIT_COST
163 ,CREATION_DATE
164 ,CREATED_BY
165 ,LAST_UPDATE_DATE
166 ,LAST_UPDATED_BY
167 ,LAST_UPDATE_LOGIN
168 ,WORK_ORDER_TYPE
169 ,ACTIVITY_TYPE
170 ,ACTIVITY_CAUSE
171 ,ACTIVITY_SOURCE
172 ,AVAILABLE_QUANTITY
173 ,ITEM_COMMENTS
174 ,CU_QTY
175 ,RES_SCHEDULED_FLAG
176 )
177 VALUES
178 (
179 l_wo_line_id_seq,
180 decode(p_estimate_work_order_id ,FND_API.G_MISS_NUM,NULL,p_estimate_work_order_id ),
181 decode(p_src_cu_id ,FND_API.G_MISS_NUM,NULL,p_src_cu_id ),
182 decode(p_src_activity_id ,FND_API.G_MISS_NUM,NULL,p_src_activity_id ),
183 decode(p_src_activity_qty ,FND_API.G_MISS_NUM,NULL,p_src_activity_qty ),
184 decode(p_src_op_seq_num ,FND_API.G_MISS_NUM,NULL,p_src_op_seq_num ),
185 decode(p_src_acct_class_code ,FND_API.G_MISS_CHAR,NULL,p_src_acct_class_code ),
186 decode(p_src_diff_id ,FND_API.G_MISS_NUM,NULL,p_src_diff_id ),
187 decode(p_diff_qty ,FND_API.G_MISS_NUM,NULL,p_diff_qty ),
188 p_estimate_id,
189 decode(p_organization_id ,FND_API.G_MISS_NUM,NULL,p_organization_id ),
190 decode(p_work_order_seq_num ,FND_API.G_MISS_NUM,NULL,p_work_order_seq_num ),
191 decode(p_work_order_number ,FND_API.G_MISS_CHAR,NULL,p_work_order_number ),
192 decode(p_work_order_description ,FND_API.G_MISS_CHAR,NULL,p_work_order_description ),
193 decode(p_ref_wip_entity_id ,FND_API.G_MISS_NUM,NULL,p_ref_wip_entity_id ),
194 decode(p_primary_item_id ,FND_API.G_MISS_NUM,NULL,p_primary_item_id ),
195 decode(p_status_type ,FND_API.G_MISS_NUM,NULL,p_status_type ),
196 decode(p_acct_class_code ,FND_API.G_MISS_CHAR,NULL,p_acct_class_code ),
197 decode(p_scheduled_start_date ,FND_API.G_MISS_DATE,sysdate,sysdate ),
198 decode(p_scheduled_completion_date ,FND_API.G_MISS_DATE,TO_DATE(NULL),p_scheduled_completion_date ),
199 decode(p_project_id ,FND_API.G_MISS_NUM,NULL,p_project_id ),
200 decode(p_task_id ,FND_API.G_MISS_NUM,NULL,p_task_id ),
201 decode(p_maintenance_object_id ,FND_API.G_MISS_NUM,NULL,p_maintenance_object_id ),
202 decode(p_maintenance_object_type ,FND_API.G_MISS_NUM,NULL,p_maintenance_object_type ),
203 decode(p_maintenance_object_source ,FND_API.G_MISS_NUM,NULL,p_maintenance_object_source ),
204 decode(p_owning_department_id ,FND_API.G_MISS_NUM,NULL,p_owning_department_id ),
205 decode(p_user_defined_status_id ,FND_API.G_MISS_NUM,NULL,p_user_defined_status_id ),
206 decode(p_op_seq_num ,FND_API.G_MISS_NUM,NULL,p_op_seq_num ),
207 decode(p_op_description ,FND_API.G_MISS_CHAR,NULL,p_op_description ),
208 decode(p_standard_operation_id ,FND_API.G_MISS_NUM,NULL,p_standard_operation_id ),
209 decode(p_op_department_id ,FND_API.G_MISS_NUM,NULL,p_op_department_id ),
210 decode(p_op_long_description ,FND_API.G_MISS_CHAR,NULL,p_op_long_description ),
211 decode(p_res_seq_num ,FND_API.G_MISS_NUM,NULL,p_res_seq_num ),
212 decode(p_res_id ,FND_API.G_MISS_NUM,NULL,p_res_id ),
213 decode(p_res_uom ,FND_API.G_MISS_CHAR,NULL,p_res_uom ),
214 decode(p_res_basis_type ,FND_API.G_MISS_NUM,NULL,p_res_basis_type ),
215 decode(p_res_usage_rate_or_amount ,FND_API.G_MISS_NUM,NULL,p_res_usage_rate_or_amount ),
216 decode(p_res_required_units ,FND_API.G_MISS_NUM,NULL,p_res_required_units ),
217 decode(p_res_assigned_units ,FND_API.G_MISS_NUM,NULL,p_res_assigned_units ),
218 decode(p_item_type ,FND_API.G_MISS_NUM,NULL,p_item_type ),
219 decode(p_required_quantity ,FND_API.G_MISS_NUM,NULL,p_required_quantity ),
220 decode(p_unit_price ,FND_API.G_MISS_NUM,NULL,p_unit_price ),
221 decode(p_uom ,FND_API.G_MISS_CHAR,NULL,p_uom ),
222 decode(p_basis_type ,FND_API.G_MISS_NUM,NULL,p_basis_type ),
223 decode(p_suggested_vendor_name ,FND_API.G_MISS_CHAR,NULL,p_suggested_vendor_name ),
224 decode(p_suggested_vendor_id ,FND_API.G_MISS_NUM,NULL,p_suggested_vendor_id ),
225 decode(p_suggested_vendor_site ,FND_API.G_MISS_CHAR,NULL,p_suggested_vendor_site ),
226 decode(p_suggested_vendor_site_id ,FND_API.G_MISS_NUM,NULL,p_suggested_vendor_site_id ),
227 decode(p_mat_inventory_item_id ,FND_API.G_MISS_NUM,NULL,p_mat_inventory_item_id ),
228 decode(p_mat_component_seq_num ,FND_API.G_MISS_NUM,NULL,p_mat_component_seq_num ),
229 decode(p_mat_supply_subinventory ,FND_API.G_MISS_CHAR,NULL,p_mat_supply_subinventory ),
230 decode(p_mat_supply_locator_id ,FND_API.G_MISS_NUM,NULL,p_mat_supply_locator_id ),
231 decode(p_di_amount ,FND_API.G_MISS_NUM,NULL,p_di_amount ),
232 decode(p_di_order_type_lookup_code ,FND_API.G_MISS_CHAR,NULL,p_di_order_type_lookup_code ),
233 decode(p_di_description ,FND_API.G_MISS_CHAR,NULL,p_di_description ),
234 decode(p_di_purchase_category_id ,FND_API.G_MISS_NUM,NULL,p_di_purchase_category_id ),
235 decode(p_di_auto_request_material ,FND_API.G_MISS_CHAR,NULL,p_di_auto_request_material ),
236 decode(p_di_need_by_date ,FND_API.G_MISS_DATE,TO_DATE(NULL),p_di_need_by_date ),
237 decode(p_work_order_line_cost ,FND_API.G_MISS_NUM,NULL,p_work_order_line_cost ),
238 decode(p_creation_date ,FND_API.G_MISS_DATE,sysdate,sysdate ),
242 decode(p_last_update_login ,FND_API.G_MISS_NUM,NULL,p_last_update_login ),
239 decode(p_created_by ,FND_API.G_MISS_NUM,NULL,p_created_by ),
240 decode(p_last_update_date ,FND_API.G_MISS_DATE,sysdate,sysdate ),
241 decode(p_last_updated_by ,FND_API.G_MISS_NUM,NULL,p_last_updated_by ),
243 decode(p_work_order_type ,FND_API.G_MISS_NUM,NULL,p_work_order_type ),
244 decode(p_activity_type ,FND_API.G_MISS_NUM,NULL,p_activity_type ),
245 decode(p_activity_cause ,FND_API.G_MISS_NUM,NULL,p_activity_cause ),
246 decode(p_activity_source ,FND_API.G_MISS_NUM,NULL,p_activity_source ),
247 decode(p_available_qty ,FND_API.G_MISS_NUM,NULL,p_available_qty ),
248 decode(p_item_comments ,FND_API.G_MISS_CHAR,NULL,p_item_comments ),
249 decode(p_cu_qty ,FND_API.G_MISS_NUM,NULL,p_cu_qty ),
250 decode(p_res_sch_flag ,FND_API.G_MISS_NUM,NULL,p_res_sch_flag )
251 );
252
253 END IF; -- (p_estimate_id IS NOT NULL) OR (p_estimate_id <> FND_API.G_MISS_NUM)
254
255 EXCEPTION
256 WHEN OTHERS THEN
257 NULL;
258 END INSERT_ROW;
259
260 PROCEDURE UPDATE_ROW(
261 p_estimate_work_order_line_id NUMBER,
262 p_estimate_work_order_id NUMBER,
263 p_src_cu_id NUMBER,
264 p_src_activity_id NUMBER,
265 p_src_activity_qty NUMBER,
266 p_src_op_seq_num NUMBER,
267 p_src_acct_class_code VARCHAR2,
268 p_src_diff_id NUMBER,
269 p_diff_qty NUMBER,
270 p_estimate_id NUMBER,
271 p_organization_id NUMBER,
272 p_work_order_seq_num NUMBER,
273 p_work_order_number VARCHAR2,
274 p_work_order_description VARCHAR2,
275 p_ref_wip_entity_id NUMBER,
276 p_primary_item_id NUMBER,
277 p_status_type NUMBER,
278 p_acct_class_code VARCHAR2,
279 p_scheduled_start_date DATE,
280 p_scheduled_completion_date DATE,
281 p_project_id NUMBER,
282 p_task_id NUMBER,
283 p_maintenance_object_id NUMBER,
284 p_maintenance_object_type NUMBER,
285 p_maintenance_object_source NUMBER,
286 p_owning_department_id NUMBER,
287 p_user_defined_status_id NUMBER,
288 p_op_seq_num NUMBER,
289 p_op_description VARCHAR2,
290 p_standard_operation_id NUMBER,
291 p_op_department_id NUMBER,
292 p_op_long_description VARCHAR2,
293 p_res_seq_num NUMBER,
294 p_res_id NUMBER,
295 p_res_uom VARCHAR2,
296 p_res_basis_type NUMBER,
297 p_res_usage_rate_or_amount NUMBER,
298 p_res_required_units NUMBER,
299 p_res_assigned_units NUMBER,
300 p_item_type NUMBER,
301 p_required_quantity NUMBER,
302 p_unit_price NUMBER,
303 p_uom VARCHAR2,
304 p_basis_type NUMBER,
305 p_suggested_vendor_name VARCHAR2,
306 p_suggested_vendor_id NUMBER,
307 p_suggested_vendor_site VARCHAR2,
308 p_suggested_vendor_site_id NUMBER,
309 p_mat_inventory_item_id NUMBER,
310 p_mat_component_seq_num NUMBER,
311 p_mat_supply_subinventory VARCHAR2,
312 p_mat_supply_locator_id NUMBER,
313 p_di_amount NUMBER,
314 p_di_order_type_lookup_code VARCHAR2,
315 p_di_description VARCHAR2,
316 p_di_purchase_category_id NUMBER,
317 p_di_auto_request_material VARCHAR2,
318 p_di_need_by_date DATE,
319 p_work_order_line_cost NUMBER,
320 p_creation_date DATE,
321 p_created_by NUMBER,
322 p_last_update_date DATE,
323 p_last_updated_by NUMBER,
324 p_last_update_login NUMBER,
325 p_work_order_type NUMBER,
326 p_activity_type NUMBER,
327 p_activity_source NUMBER,
328 p_activity_cause NUMBER,
329 p_available_qty NUMBER,
330 p_item_comments VARCHAR2,
331 p_cu_qty NUMBER,
332 p_res_sch_flag NUMBER
333 )
334 IS
335 BEGIN
336 UPDATE EAM_CE_WORK_ORDER_LINES
337 SET ESTIMATE_WORK_ORDER_ID = decode(p_estimate_work_order_id, FND_API.G_MISS_NUM, ESTIMATE_WORK_ORDER_ID, p_estimate_work_order_id),
338 SRC_CU_ID = decode(p_src_cu_id, FND_API.G_MISS_NUM, SRC_CU_ID, p_src_cu_id),
339 SRC_ACTIVITY_ID = decode(p_src_activity_id, FND_API.G_MISS_NUM, SRC_ACTIVITY_ID, p_src_activity_id),
340 SRC_ACTIVITY_QTY = decode(p_src_activity_qty, FND_API.G_MISS_NUM, SRC_ACTIVITY_QTY, p_src_activity_qty),
341 SRC_OP_SEQ_NUM = decode(p_src_op_seq_num, FND_API.G_MISS_NUM, SRC_OP_SEQ_NUM, p_src_op_seq_num),
342 SRC_ACCT_CLASS_CODE = decode(p_src_acct_class_code, FND_API.G_MISS_CHAR, SRC_ACCT_CLASS_CODE, p_src_acct_class_code),
343 SRC_DIFFICULTY_ID = decode(p_src_diff_id ,FND_API.G_MISS_NUM,SRC_DIFFICULTY_ID,p_src_diff_id),
344 DIFFICULTY_QTY = decode(p_diff_qty,FND_API.G_MISS_NUM,DIFFICULTY_QTY,p_diff_qty),
345 ESTIMATE_ID = decode(p_estimate_id, FND_API.G_MISS_NUM, ESTIMATE_ID, p_estimate_id),
346 ORGANIZATION_ID = decode(p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
350 REF_WIP_ENTITY_ID = decode(p_ref_wip_entity_id, FND_API.G_MISS_NUM, REF_WIP_ENTITY_ID, p_ref_wip_entity_id),
347 WORK_ORDER_SEQ_NUM = decode(p_work_order_seq_num, FND_API.G_MISS_NUM, WORK_ORDER_SEQ_NUM, p_work_order_seq_num),
348 WORK_ORDER_NUMBER = decode(p_work_order_number, FND_API.G_MISS_CHAR, WORK_ORDER_NUMBER, p_work_order_number),
349 WORK_ORDER_DESCRIPTION = decode(p_work_order_description, FND_API.G_MISS_CHAR, WORK_ORDER_DESCRIPTION, p_work_order_description),
351 PRIMARY_ITEM_ID = decode(p_primary_item_id, FND_API.G_MISS_NUM, PRIMARY_ITEM_ID, p_primary_item_id),
352 STATUS_TYPE = decode(p_status_type, FND_API.G_MISS_NUM, STATUS_TYPE, p_status_type),
353 ACCT_CLASS_CODE = decode(p_acct_class_code, FND_API.G_MISS_CHAR, ACCT_CLASS_CODE, p_acct_class_code),
354 SCHEDULED_START_DATE = decode(p_scheduled_start_date, FND_API.G_MISS_DATE, SCHEDULED_START_DATE, NULL, SCHEDULED_START_DATE, p_scheduled_start_date),
355 SCHEDULED_COMPLETION_DATE = decode(p_scheduled_completion_date, FND_API.G_MISS_DATE, SCHEDULED_COMPLETION_DATE, p_scheduled_completion_date),
356 PROJECT_ID = decode(p_project_id, FND_API.G_MISS_NUM, PROJECT_ID, p_project_id),
357 TASK_ID = decode(p_task_id, FND_API.G_MISS_NUM, TASK_ID, p_task_id),
358 MAINTENANCE_OBJECT_ID = decode(p_maintenance_object_id, FND_API.G_MISS_NUM, MAINTENANCE_OBJECT_ID, p_maintenance_object_id),
359 MAINTENANCE_OBJECT_TYPE = decode(p_maintenance_object_type, FND_API.G_MISS_NUM, MAINTENANCE_OBJECT_TYPE, p_maintenance_object_type),
360 MAINTENANCE_OBJECT_SOURCE = decode(p_maintenance_object_source, FND_API.G_MISS_NUM, MAINTENANCE_OBJECT_SOURCE, p_maintenance_object_source),
361 OWNING_DEPARTMENT_ID = decode(p_owning_department_id, FND_API.G_MISS_NUM, OWNING_DEPARTMENT_ID, p_owning_department_id),
362 USER_DEFINED_STATUS_ID = decode(p_user_defined_status_id, FND_API.G_MISS_NUM, USER_DEFINED_STATUS_ID, p_user_defined_status_id),
363 OP_SEQ_NUM = decode(p_op_seq_num, FND_API.G_MISS_NUM, OP_SEQ_NUM, p_op_seq_num),
364 OP_DESCRIPTION = decode(p_op_description, FND_API.G_MISS_CHAR, OP_DESCRIPTION, p_op_description),
365 STANDARD_OPERATION_ID = decode(p_standard_operation_id, FND_API.G_MISS_NUM, STANDARD_OPERATION_ID, p_standard_operation_id),
366 OP_DEPARTMENT_ID = decode(p_op_department_id, FND_API.G_MISS_NUM, OP_DEPARTMENT_ID, p_op_department_id),
367 OP_LONG_DESCRIPTION = decode(p_op_long_description, FND_API.G_MISS_CHAR, OP_LONG_DESCRIPTION, p_op_long_description),
368 RES_SEQ_NUM = decode(p_res_seq_num, FND_API.G_MISS_NUM, RES_SEQ_NUM, p_res_seq_num),
369 RES_ID = decode(p_res_id, FND_API.G_MISS_NUM, RES_ID, p_res_id),
370 RES_UOM = decode(p_res_uom, FND_API.G_MISS_CHAR, RES_UOM, p_res_uom),
371 RES_BASIS_TYPE = decode(p_res_basis_type, FND_API.G_MISS_NUM, RES_BASIS_TYPE, p_res_basis_type),
372 RES_USAGE_RATE_OR_AMOUNT = decode(p_res_usage_rate_or_amount, FND_API.G_MISS_NUM, RES_USAGE_RATE_OR_AMOUNT, p_res_usage_rate_or_amount),
373 RES_REQUIRED_UNITS = decode(p_res_required_units, FND_API.G_MISS_NUM, RES_REQUIRED_UNITS, p_res_required_units),
374 RES_ASSIGNED_UNITS = decode(p_res_assigned_units, FND_API.G_MISS_NUM, RES_ASSIGNED_UNITS, p_res_assigned_units),
375 ITEM_TYPE = decode(p_item_type, FND_API.G_MISS_NUM, ITEM_TYPE, p_item_type),
376 REQUIRED_QUANTITY = decode(p_required_quantity, FND_API.G_MISS_NUM, REQUIRED_QUANTITY, p_required_quantity),
377 UNIT_PRICE = decode(p_unit_price, FND_API.G_MISS_NUM, UNIT_PRICE, p_unit_price),
378 UOM = decode(p_uom, FND_API.G_MISS_CHAR, UOM, p_uom),
379 BASIS_TYPE = decode(p_basis_type, FND_API.G_MISS_NUM, BASIS_TYPE, p_basis_type),
380 SUGGESTED_VENDOR_NAME = decode(p_suggested_vendor_name, FND_API.G_MISS_CHAR, SUGGESTED_VENDOR_NAME, p_suggested_vendor_name),
381 SUGGESTED_VENDOR_ID = decode(p_suggested_vendor_id, FND_API.G_MISS_NUM, SUGGESTED_VENDOR_ID, p_suggested_vendor_id),
382 SUGGESTED_VENDOR_SITE = decode(p_suggested_vendor_site, FND_API.G_MISS_CHAR, SUGGESTED_VENDOR_SITE, p_suggested_vendor_site),
383 SUGGESTED_VENDOR_SITE_ID = decode(p_suggested_vendor_site_id, FND_API.G_MISS_NUM, SUGGESTED_VENDOR_SITE_ID, p_suggested_vendor_site_id),
384 MAT_INVENTORY_ITEM_ID = decode(p_mat_inventory_item_id, FND_API.G_MISS_NUM, MAT_INVENTORY_ITEM_ID, p_mat_inventory_item_id),
385 MAT_COMPONENT_SEQ_NUM = decode(p_mat_component_seq_num, FND_API.G_MISS_NUM, MAT_COMPONENT_SEQ_NUM, p_mat_component_seq_num),
386 MAT_SUPPLY_SUBINVENTORY = decode(p_mat_supply_subinventory, FND_API.G_MISS_CHAR, MAT_SUPPLY_SUBINVENTORY, p_mat_supply_subinventory),
387 MAT_SUPPLY_LOCATOR_ID = decode(p_mat_supply_locator_id, FND_API.G_MISS_NUM, MAT_SUPPLY_LOCATOR_ID, p_mat_supply_locator_id),
388 DI_AMOUNT = decode(p_di_amount, FND_API.G_MISS_NUM, DI_AMOUNT, p_di_amount),
389 DI_ORDER_TYPE_LOOKUP_CODE = decode(p_di_order_type_lookup_code, FND_API.G_MISS_CHAR, DI_ORDER_TYPE_LOOKUP_CODE, p_di_order_type_lookup_code),
390 DI_DESCRIPTION = decode(p_di_description, FND_API.G_MISS_CHAR, DI_DESCRIPTION, p_di_description),
391 DI_PURCHASE_CATEGORY_ID = decode(p_di_purchase_category_id, FND_API.G_MISS_NUM, DI_PURCHASE_CATEGORY_ID, p_di_purchase_category_id),
392 DI_AUTO_REQUEST_MATERIAL = decode(p_di_auto_request_material, FND_API.G_MISS_CHAR, DI_AUTO_REQUEST_MATERIAL, p_di_auto_request_material),
393 DI_NEED_BY_DATE = decode(p_di_need_by_date, FND_API.G_MISS_DATE, DI_NEED_BY_DATE, p_di_need_by_date),
394 WO_LINE_PER_UNIT_COST = decode(p_work_order_line_cost, FND_API.G_MISS_NUM, WO_LINE_PER_UNIT_COST, p_work_order_line_cost),
395 CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
396 CREATED_BY = decode(p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
400 WORK_ORDER_TYPE = decode(p_work_order_type, FND_API.G_MISS_NUM, WORK_ORDER_TYPE, p_work_order_type),
397 LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
398 LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
399 LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
401 ACTIVITY_TYPE = decode(p_activity_type, FND_API.G_MISS_NUM, ACTIVITY_TYPE, p_activity_type),
402 ACTIVITY_CAUSE = decode(p_activity_cause, FND_API.G_MISS_NUM, ACTIVITY_CAUSE, p_activity_cause),
403 ACTIVITY_SOURCE = decode(p_activity_source, FND_API.G_MISS_NUM, ACTIVITY_SOURCE, p_activity_source),
404 AVAILABLE_QUANTITY = decode(p_available_qty, FND_API.G_MISS_NUM, AVAILABLE_QUANTITY, p_available_qty),
405 ITEM_COMMENTS = decode(p_item_comments, FND_API.G_MISS_CHAR, ITEM_COMMENTS, p_item_comments),
406 CU_QTY = decode(p_cu_qty, FND_API.G_MISS_NUM, CU_QTY, p_cu_qty ),
407 RES_SCHEDULED_FLAG = decode(p_res_sch_flag, FND_API.G_MISS_NUM, RES_SCHEDULED_FLAG, p_res_sch_flag)
408 WHERE ESTIMATE_WORK_ORDER_LINE_ID = p_estimate_work_order_line_id;
409
410 IF (SQL%NOTFOUND) THEN
411 RAISE NO_DATA_FOUND;
412 END IF;
413 END UPDATE_ROW;
414
415 PROCEDURE DELETE_ALL_WITH_ESTIMATE_ID
416 (
417 p_estimate_id IN NUMBER
418 )
419 IS
420 BEGIN
421 DELETE FROM EAM_CE_WORK_ORDER_LINES
422 WHERE ESTIMATE_ID = p_estimate_id;
423 EXCEPTION
424 WHEN OTHERS THEN
425 NULL;
426 END DELETE_ALL_WITH_ESTIMATE_ID;
427
428 PROCEDURE DELETE_ROW(
429 p_work_order_line_id IN NUMBER
430 )
431 IS
432 BEGIN
433
434 DELETE FROM EAM_CE_WORK_ORDER_LINES
435 WHERE ESTIMATE_WORK_ORDER_LINE_ID = p_work_order_line_id;
436
437 IF (SQL%NOTFOUND) THEN
438 RAISE NO_DATA_FOUND;
439 END IF;
440 END DELETE_ROW;
441
442 END EAM_CE_WORK_ORDER_LINES_PKG;