eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_CE_WORK_ORDER_LINES_PKG dependencies on FND_API

Line 92: IF (p_estimate_id IS NOT NULL) OR (p_estimate_id <> FND_API.G_MISS_NUM) THEN

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:

Line 180: decode(p_estimate_work_order_id ,FND_API.G_MISS_NUM,NULL,p_estimate_work_order_id ),

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 ),

Line 181: decode(p_src_cu_id ,FND_API.G_MISS_NUM,NULL,p_src_cu_id ),

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 ),

Line 182: decode(p_src_activity_id ,FND_API.G_MISS_NUM,NULL,p_src_activity_id ),

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 ),

Line 183: decode(p_src_activity_qty ,FND_API.G_MISS_NUM,NULL,p_src_activity_qty ),

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 ),

Line 184: decode(p_src_op_seq_num ,FND_API.G_MISS_NUM,NULL,p_src_op_seq_num ),

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,

Line 185: decode(p_src_acct_class_code ,FND_API.G_MISS_CHAR,NULL,p_src_acct_class_code ),

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 ),

Line 186: decode(p_src_diff_id ,FND_API.G_MISS_NUM,NULL,p_src_diff_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 ),

Line 187: decode(p_diff_qty ,FND_API.G_MISS_NUM,NULL,p_diff_qty ),

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 ),

Line 189: decode(p_organization_id ,FND_API.G_MISS_NUM,NULL,p_organization_id ),

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 ),

Line 190: decode(p_work_order_seq_num ,FND_API.G_MISS_NUM,NULL,p_work_order_seq_num ),

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 ),

Line 191: decode(p_work_order_number ,FND_API.G_MISS_CHAR,NULL,p_work_order_number ),

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 ),

Line 192: decode(p_work_order_description ,FND_API.G_MISS_CHAR,NULL,p_work_order_description ),

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 ),

Line 193: decode(p_ref_wip_entity_id ,FND_API.G_MISS_NUM,NULL,p_ref_wip_entity_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 ),

Line 194: decode(p_primary_item_id ,FND_API.G_MISS_NUM,NULL,p_primary_item_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 ),

Line 195: decode(p_status_type ,FND_API.G_MISS_NUM,NULL,p_status_type ),

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 ),

Line 196: decode(p_acct_class_code ,FND_API.G_MISS_CHAR,NULL,p_acct_class_code ),

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 ),

Line 197: decode(p_scheduled_start_date ,FND_API.G_MISS_DATE,sysdate,sysdate ),

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 ),

Line 198: decode(p_scheduled_completion_date ,FND_API.G_MISS_DATE,TO_DATE(NULL),p_scheduled_completion_date ),

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 ),

Line 199: decode(p_project_id ,FND_API.G_MISS_NUM,NULL,p_project_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 ),

Line 200: decode(p_task_id ,FND_API.G_MISS_NUM,NULL,p_task_id ),

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 ),

Line 201: decode(p_maintenance_object_id ,FND_API.G_MISS_NUM,NULL,p_maintenance_object_id ),

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 ),

Line 202: decode(p_maintenance_object_type ,FND_API.G_MISS_NUM,NULL,p_maintenance_object_type ),

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 ),

Line 203: decode(p_maintenance_object_source ,FND_API.G_MISS_NUM,NULL,p_maintenance_object_source ),

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 ),

Line 204: decode(p_owning_department_id ,FND_API.G_MISS_NUM,NULL,p_owning_department_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 ),

Line 205: decode(p_user_defined_status_id ,FND_API.G_MISS_NUM,NULL,p_user_defined_status_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 ),

Line 206: decode(p_op_seq_num ,FND_API.G_MISS_NUM,NULL,p_op_seq_num ),

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 ),

Line 207: decode(p_op_description ,FND_API.G_MISS_CHAR,NULL,p_op_description ),

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 ),

Line 208: decode(p_standard_operation_id ,FND_API.G_MISS_NUM,NULL,p_standard_operation_id ),

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 ),

Line 209: decode(p_op_department_id ,FND_API.G_MISS_NUM,NULL,p_op_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 ),

Line 210: decode(p_op_long_description ,FND_API.G_MISS_CHAR,NULL,p_op_long_description ),

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 ),

Line 211: decode(p_res_seq_num ,FND_API.G_MISS_NUM,NULL,p_res_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 ),

Line 212: decode(p_res_id ,FND_API.G_MISS_NUM,NULL,p_res_id ),

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 ),

Line 213: decode(p_res_uom ,FND_API.G_MISS_CHAR,NULL,p_res_uom ),

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 ),

Line 214: decode(p_res_basis_type ,FND_API.G_MISS_NUM,NULL,p_res_basis_type ),

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 ),

Line 215: decode(p_res_usage_rate_or_amount ,FND_API.G_MISS_NUM,NULL,p_res_usage_rate_or_amount ),

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 ),

Line 216: decode(p_res_required_units ,FND_API.G_MISS_NUM,NULL,p_res_required_units ),

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 ),

Line 217: decode(p_res_assigned_units ,FND_API.G_MISS_NUM,NULL,p_res_assigned_units ),

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 ),

Line 218: decode(p_item_type ,FND_API.G_MISS_NUM,NULL,p_item_type ),

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 ),

Line 219: decode(p_required_quantity ,FND_API.G_MISS_NUM,NULL,p_required_quantity ),

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 ),

Line 220: decode(p_unit_price ,FND_API.G_MISS_NUM,NULL,p_unit_price ),

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 ),

Line 221: decode(p_uom ,FND_API.G_MISS_CHAR,NULL,p_uom ),

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 ),

Line 222: decode(p_basis_type ,FND_API.G_MISS_NUM,NULL,p_basis_type ),

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 ),

Line 223: decode(p_suggested_vendor_name ,FND_API.G_MISS_CHAR,NULL,p_suggested_vendor_name ),

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 ),

Line 224: decode(p_suggested_vendor_id ,FND_API.G_MISS_NUM,NULL,p_suggested_vendor_id ),

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 ),

Line 225: decode(p_suggested_vendor_site ,FND_API.G_MISS_CHAR,NULL,p_suggested_vendor_site ),

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 ),

Line 226: decode(p_suggested_vendor_site_id ,FND_API.G_MISS_NUM,NULL,p_suggested_vendor_site_id ),

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 ),

Line 227: decode(p_mat_inventory_item_id ,FND_API.G_MISS_NUM,NULL,p_mat_inventory_item_id ),

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 ),

Line 228: decode(p_mat_component_seq_num ,FND_API.G_MISS_NUM,NULL,p_mat_component_seq_num ),

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 ),

Line 229: decode(p_mat_supply_subinventory ,FND_API.G_MISS_CHAR,NULL,p_mat_supply_subinventory ),

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 ),

Line 230: decode(p_mat_supply_locator_id ,FND_API.G_MISS_NUM,NULL,p_mat_supply_locator_id ),

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 ),

Line 231: decode(p_di_amount ,FND_API.G_MISS_NUM,NULL,p_di_amount ),

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 ),

Line 232: decode(p_di_order_type_lookup_code ,FND_API.G_MISS_CHAR,NULL,p_di_order_type_lookup_code ),

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 ),

Line 233: decode(p_di_description ,FND_API.G_MISS_CHAR,NULL,p_di_description ),

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 ),

Line 234: decode(p_di_purchase_category_id ,FND_API.G_MISS_NUM,NULL,p_di_purchase_category_id ),

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 ),

Line 235: decode(p_di_auto_request_material ,FND_API.G_MISS_CHAR,NULL,p_di_auto_request_material ),

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 ),
239: decode(p_created_by ,FND_API.G_MISS_NUM,NULL,p_created_by ),

Line 236: decode(p_di_need_by_date ,FND_API.G_MISS_DATE,TO_DATE(NULL),p_di_need_by_date ),

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 ),
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 ),

Line 237: decode(p_work_order_line_cost ,FND_API.G_MISS_NUM,NULL,p_work_order_line_cost ),

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 ),
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 ),

Line 238: decode(p_creation_date ,FND_API.G_MISS_DATE,sysdate,sysdate ),

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 ),
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 ),
242: decode(p_last_update_login ,FND_API.G_MISS_NUM,NULL,p_last_update_login ),

Line 239: decode(p_created_by ,FND_API.G_MISS_NUM,NULL,p_created_by ),

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 ),
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 ),
242: decode(p_last_update_login ,FND_API.G_MISS_NUM,NULL,p_last_update_login ),
243: decode(p_work_order_type ,FND_API.G_MISS_NUM,NULL,p_work_order_type ),

Line 240: decode(p_last_update_date ,FND_API.G_MISS_DATE,sysdate,sysdate ),

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 ),
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 ),
242: decode(p_last_update_login ,FND_API.G_MISS_NUM,NULL,p_last_update_login ),
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 ),

Line 241: decode(p_last_updated_by ,FND_API.G_MISS_NUM,NULL,p_last_updated_by ),

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 ),
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 ),
242: decode(p_last_update_login ,FND_API.G_MISS_NUM,NULL,p_last_update_login ),
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 ),

Line 242: decode(p_last_update_login ,FND_API.G_MISS_NUM,NULL,p_last_update_login ),

238: decode(p_creation_date ,FND_API.G_MISS_DATE,sysdate,sysdate ),
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 ),
242: decode(p_last_update_login ,FND_API.G_MISS_NUM,NULL,p_last_update_login ),
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 ),

Line 243: decode(p_work_order_type ,FND_API.G_MISS_NUM,NULL,p_work_order_type ),

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 ),
242: decode(p_last_update_login ,FND_API.G_MISS_NUM,NULL,p_last_update_login ),
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 ),

Line 244: decode(p_activity_type ,FND_API.G_MISS_NUM,NULL,p_activity_type ),

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 ),
242: decode(p_last_update_login ,FND_API.G_MISS_NUM,NULL,p_last_update_login ),
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 ),

Line 245: decode(p_activity_cause ,FND_API.G_MISS_NUM,NULL,p_activity_cause ),

241: decode(p_last_updated_by ,FND_API.G_MISS_NUM,NULL,p_last_updated_by ),
242: decode(p_last_update_login ,FND_API.G_MISS_NUM,NULL,p_last_update_login ),
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 ),

Line 246: decode(p_activity_source ,FND_API.G_MISS_NUM,NULL,p_activity_source ),

242: decode(p_last_update_login ,FND_API.G_MISS_NUM,NULL,p_last_update_login ),
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 )

Line 247: decode(p_available_qty ,FND_API.G_MISS_NUM,NULL,p_available_qty ),

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: );

Line 248: decode(p_item_comments ,FND_API.G_MISS_CHAR,NULL,p_item_comments ),

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:

Line 249: decode(p_cu_qty ,FND_API.G_MISS_NUM,NULL,p_cu_qty ),

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)

Line 250: decode(p_res_sch_flag ,FND_API.G_MISS_NUM,NULL,p_res_sch_flag )

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:

Line 253: END IF; -- (p_estimate_id IS NOT NULL) OR (p_estimate_id <> FND_API.G_MISS_NUM)

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;

Line 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),

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),

Line 338: SRC_CU_ID = decode(p_src_cu_id, FND_API.G_MISS_NUM, SRC_CU_ID, p_src_cu_id),

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),

Line 339: SRC_ACTIVITY_ID = decode(p_src_activity_id, FND_API.G_MISS_NUM, SRC_ACTIVITY_ID, p_src_activity_id),

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),

Line 340: SRC_ACTIVITY_QTY = decode(p_src_activity_qty, FND_API.G_MISS_NUM, SRC_ACTIVITY_QTY, p_src_activity_qty),

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),

Line 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),

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),

Line 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),

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),

Line 343: SRC_DIFFICULTY_ID = decode(p_src_diff_id ,FND_API.G_MISS_NUM,SRC_DIFFICULTY_ID,p_src_diff_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),
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),

Line 344: DIFFICULTY_QTY = decode(p_diff_qty,FND_API.G_MISS_NUM,DIFFICULTY_QTY,p_diff_qty),

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),
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),

Line 345: ESTIMATE_ID = decode(p_estimate_id, FND_API.G_MISS_NUM, ESTIMATE_ID, p_estimate_id),

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),
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),

Line 346: ORGANIZATION_ID = decode(p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),

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),
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),
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),

Line 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),

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),
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),
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),
351: PRIMARY_ITEM_ID = decode(p_primary_item_id, FND_API.G_MISS_NUM, PRIMARY_ITEM_ID, p_primary_item_id),

Line 348: WORK_ORDER_NUMBER = decode(p_work_order_number, FND_API.G_MISS_CHAR, WORK_ORDER_NUMBER, p_work_order_number),

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),
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),
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),
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),

Line 349: WORK_ORDER_DESCRIPTION = decode(p_work_order_description, FND_API.G_MISS_CHAR, WORK_ORDER_DESCRIPTION, p_work_order_description),

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),
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),
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),
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),

Line 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),

346: ORGANIZATION_ID = decode(p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_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),
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),
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),

Line 351: PRIMARY_ITEM_ID = decode(p_primary_item_id, FND_API.G_MISS_NUM, PRIMARY_ITEM_ID, p_primary_item_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),
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),
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),

Line 352: STATUS_TYPE = decode(p_status_type, FND_API.G_MISS_NUM, STATUS_TYPE, p_status_type),

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),
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),
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),

Line 353: ACCT_CLASS_CODE = decode(p_acct_class_code, FND_API.G_MISS_CHAR, ACCT_CLASS_CODE, p_acct_class_code),

349: WORK_ORDER_DESCRIPTION = decode(p_work_order_description, FND_API.G_MISS_CHAR, WORK_ORDER_DESCRIPTION, p_work_order_description),
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),
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),

Line 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),

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),
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),

Line 355: SCHEDULED_COMPLETION_DATE = decode(p_scheduled_completion_date, FND_API.G_MISS_DATE, SCHEDULED_COMPLETION_DATE, p_scheduled_completion_date),

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),

Line 356: PROJECT_ID = decode(p_project_id, FND_API.G_MISS_NUM, PROJECT_ID, p_project_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),

Line 357: TASK_ID = decode(p_task_id, FND_API.G_MISS_NUM, TASK_ID, p_task_id),

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),

Line 358: MAINTENANCE_OBJECT_ID = decode(p_maintenance_object_id, FND_API.G_MISS_NUM, MAINTENANCE_OBJECT_ID, p_maintenance_object_id),

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),

Line 359: MAINTENANCE_OBJECT_TYPE = decode(p_maintenance_object_type, FND_API.G_MISS_NUM, MAINTENANCE_OBJECT_TYPE, p_maintenance_object_type),

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),

Line 360: MAINTENANCE_OBJECT_SOURCE = decode(p_maintenance_object_source, FND_API.G_MISS_NUM, MAINTENANCE_OBJECT_SOURCE, p_maintenance_object_source),

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),

Line 361: OWNING_DEPARTMENT_ID = decode(p_owning_department_id, FND_API.G_MISS_NUM, OWNING_DEPARTMENT_ID, p_owning_department_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),

Line 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),

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),

Line 363: OP_SEQ_NUM = decode(p_op_seq_num, FND_API.G_MISS_NUM, OP_SEQ_NUM, p_op_seq_num),

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),

Line 364: OP_DESCRIPTION = decode(p_op_description, FND_API.G_MISS_CHAR, OP_DESCRIPTION, p_op_description),

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),

Line 365: STANDARD_OPERATION_ID = decode(p_standard_operation_id, FND_API.G_MISS_NUM, STANDARD_OPERATION_ID, p_standard_operation_id),

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),

Line 366: OP_DEPARTMENT_ID = decode(p_op_department_id, FND_API.G_MISS_NUM, OP_DEPARTMENT_ID, p_op_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),

Line 367: OP_LONG_DESCRIPTION = decode(p_op_long_description, FND_API.G_MISS_CHAR, OP_LONG_DESCRIPTION, p_op_long_description),

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),

Line 368: RES_SEQ_NUM = decode(p_res_seq_num, FND_API.G_MISS_NUM, RES_SEQ_NUM, p_res_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),

Line 369: RES_ID = decode(p_res_id, FND_API.G_MISS_NUM, RES_ID, p_res_id),

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),

Line 370: RES_UOM = decode(p_res_uom, FND_API.G_MISS_CHAR, RES_UOM, p_res_uom),

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),

Line 371: RES_BASIS_TYPE = decode(p_res_basis_type, FND_API.G_MISS_NUM, RES_BASIS_TYPE, p_res_basis_type),

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),

Line 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),

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),

Line 373: RES_REQUIRED_UNITS = decode(p_res_required_units, FND_API.G_MISS_NUM, RES_REQUIRED_UNITS, p_res_required_units),

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),

Line 374: RES_ASSIGNED_UNITS = decode(p_res_assigned_units, FND_API.G_MISS_NUM, RES_ASSIGNED_UNITS, p_res_assigned_units),

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),

Line 375: ITEM_TYPE = decode(p_item_type, FND_API.G_MISS_NUM, ITEM_TYPE, p_item_type),

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),

Line 376: REQUIRED_QUANTITY = decode(p_required_quantity, FND_API.G_MISS_NUM, REQUIRED_QUANTITY, p_required_quantity),

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),

Line 377: UNIT_PRICE = decode(p_unit_price, FND_API.G_MISS_NUM, UNIT_PRICE, p_unit_price),

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),

Line 378: UOM = decode(p_uom, FND_API.G_MISS_CHAR, UOM, p_uom),

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),

Line 379: BASIS_TYPE = decode(p_basis_type, FND_API.G_MISS_NUM, BASIS_TYPE, p_basis_type),

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),

Line 380: SUGGESTED_VENDOR_NAME = decode(p_suggested_vendor_name, FND_API.G_MISS_CHAR, SUGGESTED_VENDOR_NAME, p_suggested_vendor_name),

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),

Line 381: SUGGESTED_VENDOR_ID = decode(p_suggested_vendor_id, FND_API.G_MISS_NUM, SUGGESTED_VENDOR_ID, p_suggested_vendor_id),

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),

Line 382: SUGGESTED_VENDOR_SITE = decode(p_suggested_vendor_site, FND_API.G_MISS_CHAR, SUGGESTED_VENDOR_SITE, p_suggested_vendor_site),

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),

Line 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),

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),

Line 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),

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),

Line 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),

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),

Line 386: MAT_SUPPLY_SUBINVENTORY = decode(p_mat_supply_subinventory, FND_API.G_MISS_CHAR, MAT_SUPPLY_SUBINVENTORY, p_mat_supply_subinventory),

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),

Line 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),

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),

Line 388: DI_AMOUNT = decode(p_di_amount, FND_API.G_MISS_NUM, DI_AMOUNT, p_di_amount),

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),

Line 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),

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),

Line 390: DI_DESCRIPTION = decode(p_di_description, FND_API.G_MISS_CHAR, DI_DESCRIPTION, p_di_description),

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),

Line 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),

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),

Line 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),

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),

Line 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),

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),
397: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 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),

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),
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),

Line 395: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

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),
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),

Line 396: CREATED_BY = decode(p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

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),
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),
400: WORK_ORDER_TYPE = decode(p_work_order_type, FND_API.G_MISS_NUM, WORK_ORDER_TYPE, p_work_order_type),

Line 397: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

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),
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),
400: WORK_ORDER_TYPE = decode(p_work_order_type, FND_API.G_MISS_NUM, WORK_ORDER_TYPE, p_work_order_type),
401: ACTIVITY_TYPE = decode(p_activity_type, FND_API.G_MISS_NUM, ACTIVITY_TYPE, p_activity_type),

Line 398: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

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),
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),
400: WORK_ORDER_TYPE = decode(p_work_order_type, FND_API.G_MISS_NUM, WORK_ORDER_TYPE, p_work_order_type),
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),

Line 399: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

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),
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),
400: WORK_ORDER_TYPE = decode(p_work_order_type, FND_API.G_MISS_NUM, WORK_ORDER_TYPE, p_work_order_type),
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),

Line 400: WORK_ORDER_TYPE = decode(p_work_order_type, FND_API.G_MISS_NUM, WORK_ORDER_TYPE, p_work_order_type),

396: CREATED_BY = decode(p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
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),
400: WORK_ORDER_TYPE = decode(p_work_order_type, FND_API.G_MISS_NUM, WORK_ORDER_TYPE, p_work_order_type),
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),

Line 401: ACTIVITY_TYPE = decode(p_activity_type, FND_API.G_MISS_NUM, ACTIVITY_TYPE, p_activity_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),
400: WORK_ORDER_TYPE = decode(p_work_order_type, FND_API.G_MISS_NUM, WORK_ORDER_TYPE, p_work_order_type),
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),

Line 402: ACTIVITY_CAUSE = decode(p_activity_cause, FND_API.G_MISS_NUM, ACTIVITY_CAUSE, p_activity_cause),

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),
400: WORK_ORDER_TYPE = decode(p_work_order_type, FND_API.G_MISS_NUM, WORK_ORDER_TYPE, p_work_order_type),
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 ),

Line 403: ACTIVITY_SOURCE = decode(p_activity_source, FND_API.G_MISS_NUM, ACTIVITY_SOURCE, p_activity_source),

399: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
400: WORK_ORDER_TYPE = decode(p_work_order_type, FND_API.G_MISS_NUM, WORK_ORDER_TYPE, p_work_order_type),
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)

Line 404: AVAILABLE_QUANTITY = decode(p_available_qty, FND_API.G_MISS_NUM, AVAILABLE_QUANTITY, p_available_qty),

400: WORK_ORDER_TYPE = decode(p_work_order_type, FND_API.G_MISS_NUM, WORK_ORDER_TYPE, p_work_order_type),
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;

Line 405: ITEM_COMMENTS = decode(p_item_comments, FND_API.G_MISS_CHAR, ITEM_COMMENTS, p_item_comments),

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:

Line 406: CU_QTY = decode(p_cu_qty, FND_API.G_MISS_NUM, CU_QTY, p_cu_qty ),

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

Line 407: RES_SCHEDULED_FLAG = decode(p_res_sch_flag, FND_API.G_MISS_NUM, RES_SCHEDULED_FLAG, p_res_sch_flag)

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;