APPS.WIP_JSI_PROCESSOR dependencies on WIP_CONSTANTS

Line 57: if (x_load_type in (WIP_CONSTANTS.RESCHED_JOB, WIP_CONSTANTS.RESCHED_LOT_JOB)) then

53: l_move_order_required
54: from wip_job_schedule_interface
55: where rowid = WIP_JSI_Utils.current_rowid ;
56:
57: if (x_load_type in (WIP_CONSTANTS.RESCHED_JOB, WIP_CONSTANTS.RESCHED_LOT_JOB)) then
58: begin
59: select wdj.start_quantity
60: into x_old_start_quantity
61: FROM wip_discrete_jobs wdj,

Line 72: if (UPPER(l_move_order_required) = 'Y' and x_status_type = WIP_CONSTANTS.RELEASED) then

68: x_old_start_quantity := null;
69: end;
70: end if;
71:
72: if (UPPER(l_move_order_required) = 'Y' and x_status_type = WIP_CONSTANTS.RELEASED) then
73: l_allocTbl(1).wip_entity_id := x_entity_id;
74: l_allocTbl(1).repetitive_schedule_id := x_rep_sched_id;
75: l_allocTbl(1).project_id := l_project_id;
76: l_allocTbl(1).task_id := l_task_id;

Line 81: p_wip_entity_type => wip_constants.eam,

77: l_allocTbl(1).use_pickset_flag := 'N';
78:
79: wip_picking_pvt.allocate(p_alloc_tbl => l_allocTbl,
80: p_cutoff_date => null, -- no cutoff day
81: p_wip_entity_type => wip_constants.eam,
82: p_organization_id => x_org_id,
83: x_mo_req_number => x_mo_req_number,
84: x_conc_req_id => x_conc_req_id,
85: x_return_status => l_status,

Line 102: if (x_load_type IN (WIP_CONSTANTS.CREATE_JOB,

98: if(l_pm_sched_id is not null) then
99: l_plan_maint := 'Y';
100: end if;
101:
102: if (x_load_type IN (WIP_CONSTANTS.CREATE_JOB,
103: WIP_CONSTANTS.CREATE_NS_JOB,
104: WIP_CONSTANTS.CREATE_EAM_JOB))
105: then
106:

Line 103: WIP_CONSTANTS.CREATE_NS_JOB,

99: l_plan_maint := 'Y';
100: end if;
101:
102: if (x_load_type IN (WIP_CONSTANTS.CREATE_JOB,
103: WIP_CONSTANTS.CREATE_NS_JOB,
104: WIP_CONSTANTS.CREATE_EAM_JOB))
105: then
106:
107: INSERT INTO WIP_DISCRETE_JOBS

Line 104: WIP_CONSTANTS.CREATE_EAM_JOB))

100: end if;
101:
102: if (x_load_type IN (WIP_CONSTANTS.CREATE_JOB,
103: WIP_CONSTANTS.CREATE_NS_JOB,
104: WIP_CONSTANTS.CREATE_EAM_JOB))
105: then
106:
107: INSERT INTO WIP_DISCRETE_JOBS
108: (wip_entity_id,

Line 226: WIP_CONSTANTS.RELEASED,

222: wi.source_code,
223: wi.description,
224: wi.status_type,
225: decode(wi.status_type,
226: WIP_CONSTANTS.RELEASED,
227: decode(wi.date_released,NULL,SYSDATE,decode( sign(wi.date_released - sysdate),1,sysdate,wi.date_released)),
228: WIP_CONSTANTS.HOLD,
229: decode(wi.date_released,NULL,SYSDATE,decode( sign(wi.date_released - sysdate),1,sysdate,wi.date_released)),
230: WIP_CONSTANTS.UNRELEASED,

Line 228: WIP_CONSTANTS.HOLD,

224: wi.status_type,
225: decode(wi.status_type,
226: WIP_CONSTANTS.RELEASED,
227: decode(wi.date_released,NULL,SYSDATE,decode( sign(wi.date_released - sysdate),1,sysdate,wi.date_released)),
228: WIP_CONSTANTS.HOLD,
229: decode(wi.date_released,NULL,SYSDATE,decode( sign(wi.date_released - sysdate),1,sysdate,wi.date_released)),
230: WIP_CONSTANTS.UNRELEASED,
231: NULL,
232: NULL

Line 230: WIP_CONSTANTS.UNRELEASED,

226: WIP_CONSTANTS.RELEASED,
227: decode(wi.date_released,NULL,SYSDATE,decode( sign(wi.date_released - sysdate),1,sysdate,wi.date_released)),
228: WIP_CONSTANTS.HOLD,
229: decode(wi.date_released,NULL,SYSDATE,decode( sign(wi.date_released - sysdate),1,sysdate,wi.date_released)),
230: WIP_CONSTANTS.UNRELEASED,
231: NULL,
232: NULL
233: ),
234: wi.primary_item_id,

Line 235: decode(wi.load_type, WIP_CONSTANTS.CREATE_JOB, NULL,

231: NULL,
232: NULL
233: ),
234: wi.primary_item_id,
235: decode(wi.load_type, WIP_CONSTANTS.CREATE_JOB, NULL,
236: wi.bom_reference_id),
237: decode(wi.load_type, WIP_CONSTANTS.CREATE_JOB, NULL,
238: wi.routing_reference_id),
239: wi.firm_planned_flag,

Line 237: decode(wi.load_type, WIP_CONSTANTS.CREATE_JOB, NULL,

233: ),
234: wi.primary_item_id,
235: decode(wi.load_type, WIP_CONSTANTS.CREATE_JOB, NULL,
236: wi.bom_reference_id),
237: decode(wi.load_type, WIP_CONSTANTS.CREATE_JOB, NULL,
238: wi.routing_reference_id),
239: wi.firm_planned_flag,
240: decode(wi.load_type, WIP_CONSTANTS.CREATE_JOB, WIP_CONSTANTS.STANDARD,
241: WIP_CONSTANTS.NONSTANDARD),

Line 240: decode(wi.load_type, WIP_CONSTANTS.CREATE_JOB, WIP_CONSTANTS.STANDARD,

236: wi.bom_reference_id),
237: decode(wi.load_type, WIP_CONSTANTS.CREATE_JOB, NULL,
238: wi.routing_reference_id),
239: wi.firm_planned_flag,
240: decode(wi.load_type, WIP_CONSTANTS.CREATE_JOB, WIP_CONSTANTS.STANDARD,
241: WIP_CONSTANTS.NONSTANDARD),
242: wi.wip_supply_type,
243: wi.class_code,
244: wac.material_account,

Line 241: WIP_CONSTANTS.NONSTANDARD),

237: decode(wi.load_type, WIP_CONSTANTS.CREATE_JOB, NULL,
238: wi.routing_reference_id),
239: wi.firm_planned_flag,
240: decode(wi.load_type, WIP_CONSTANTS.CREATE_JOB, WIP_CONSTANTS.STANDARD,
241: WIP_CONSTANTS.NONSTANDARD),
242: wi.wip_supply_type,
243: wi.class_code,
244: wac.material_account,
245: wac.material_overhead_account,

Line 255: WIP_CONSTANTS.DT_NOSEC_FMT),

251: wac.std_cost_adjustment_account,
252: wac.overhead_account,
253: wac.overhead_variance_account,
254: TO_DATE(TO_CHAR(wi.first_unit_start_date,
255: WIP_CONSTANTS.DT_NOSEC_FMT),
256: WIP_CONSTANTS.DT_NOSEC_FMT),
257: TO_DATE(TO_CHAR(wi.last_unit_completion_date,
258: WIP_CONSTANTS.DT_NOSEC_FMT),
259: WIP_CONSTANTS.DT_NOSEC_FMT),

Line 256: WIP_CONSTANTS.DT_NOSEC_FMT),

252: wac.overhead_account,
253: wac.overhead_variance_account,
254: TO_DATE(TO_CHAR(wi.first_unit_start_date,
255: WIP_CONSTANTS.DT_NOSEC_FMT),
256: WIP_CONSTANTS.DT_NOSEC_FMT),
257: TO_DATE(TO_CHAR(wi.last_unit_completion_date,
258: WIP_CONSTANTS.DT_NOSEC_FMT),
259: WIP_CONSTANTS.DT_NOSEC_FMT),
260: ROUND(wi.start_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

Line 258: WIP_CONSTANTS.DT_NOSEC_FMT),

254: TO_DATE(TO_CHAR(wi.first_unit_start_date,
255: WIP_CONSTANTS.DT_NOSEC_FMT),
256: WIP_CONSTANTS.DT_NOSEC_FMT),
257: TO_DATE(TO_CHAR(wi.last_unit_completion_date,
258: WIP_CONSTANTS.DT_NOSEC_FMT),
259: WIP_CONSTANTS.DT_NOSEC_FMT),
260: ROUND(wi.start_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
261: 0,
262: 0,

Line 259: WIP_CONSTANTS.DT_NOSEC_FMT),

255: WIP_CONSTANTS.DT_NOSEC_FMT),
256: WIP_CONSTANTS.DT_NOSEC_FMT),
257: TO_DATE(TO_CHAR(wi.last_unit_completion_date,
258: WIP_CONSTANTS.DT_NOSEC_FMT),
259: WIP_CONSTANTS.DT_NOSEC_FMT),
260: ROUND(wi.start_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
261: 0,
262: 0,
263: ROUND(wi.net_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

Line 260: ROUND(wi.start_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

256: WIP_CONSTANTS.DT_NOSEC_FMT),
257: TO_DATE(TO_CHAR(wi.last_unit_completion_date,
258: WIP_CONSTANTS.DT_NOSEC_FMT),
259: WIP_CONSTANTS.DT_NOSEC_FMT),
260: ROUND(wi.start_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
261: 0,
262: 0,
263: ROUND(wi.net_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
264: bom.common_bill_sequence_id,

Line 263: ROUND(wi.net_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

259: WIP_CONSTANTS.DT_NOSEC_FMT),
260: ROUND(wi.start_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
261: 0,
262: 0,
263: ROUND(wi.net_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
264: bom.common_bill_sequence_id,
265: rtg.common_routing_sequence_id,
266: wi.bom_revision,
267: wi.routing_revision,

Line 269: WIP_CONSTANTS.DT_NOSEC_FMT),

265: rtg.common_routing_sequence_id,
266: wi.bom_revision,
267: wi.routing_revision,
268: TO_DATE(TO_CHAR(wi.bom_revision_date,
269: WIP_CONSTANTS.DT_NOSEC_FMT),
270: WIP_CONSTANTS.DT_NOSEC_FMT),
271: TO_DATE(TO_CHAR(wi.routing_revision_date,
272: WIP_CONSTANTS.DT_NOSEC_FMT),
273: WIP_CONSTANTS.DT_NOSEC_FMT),

Line 270: WIP_CONSTANTS.DT_NOSEC_FMT),

266: wi.bom_revision,
267: wi.routing_revision,
268: TO_DATE(TO_CHAR(wi.bom_revision_date,
269: WIP_CONSTANTS.DT_NOSEC_FMT),
270: WIP_CONSTANTS.DT_NOSEC_FMT),
271: TO_DATE(TO_CHAR(wi.routing_revision_date,
272: WIP_CONSTANTS.DT_NOSEC_FMT),
273: WIP_CONSTANTS.DT_NOSEC_FMT),
274: wi.lot_number,

Line 272: WIP_CONSTANTS.DT_NOSEC_FMT),

268: TO_DATE(TO_CHAR(wi.bom_revision_date,
269: WIP_CONSTANTS.DT_NOSEC_FMT),
270: WIP_CONSTANTS.DT_NOSEC_FMT),
271: TO_DATE(TO_CHAR(wi.routing_revision_date,
272: WIP_CONSTANTS.DT_NOSEC_FMT),
273: WIP_CONSTANTS.DT_NOSEC_FMT),
274: wi.lot_number,
275: wi.alternate_bom_designator,
276: wi.alternate_routing_designator,

Line 273: WIP_CONSTANTS.DT_NOSEC_FMT),

269: WIP_CONSTANTS.DT_NOSEC_FMT),
270: WIP_CONSTANTS.DT_NOSEC_FMT),
271: TO_DATE(TO_CHAR(wi.routing_revision_date,
272: WIP_CONSTANTS.DT_NOSEC_FMT),
273: WIP_CONSTANTS.DT_NOSEC_FMT),
274: wi.lot_number,
275: wi.alternate_bom_designator,
276: wi.alternate_routing_designator,
277: wi.completion_subinventory,

Line 282: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, NULL, wi.schedule_group_id),

278: wi.completion_locator_id,
279: wi.demand_class,
280: wi.project_id,
281: wi.task_id,
282: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, NULL, wi.schedule_group_id),
283: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, NULL, wi.build_sequence),
284: wi.line_id,
285: wi.kanban_card_id,
286: wi.overcompletion_tolerance_type,

Line 283: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, NULL, wi.build_sequence),

279: wi.demand_class,
280: wi.project_id,
281: wi.task_id,
282: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, NULL, wi.schedule_group_id),
283: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, NULL, wi.build_sequence),
284: wi.line_id,
285: wi.kanban_card_id,
286: wi.overcompletion_tolerance_type,
287: wi.overcompletion_tolerance_value,

Line 290: nvl(wi.priority,WIP_CONSTANTS.DEFAULT_PRIORITY),

286: wi.overcompletion_tolerance_type,
287: wi.overcompletion_tolerance_value,
288: wi.end_item_unit_number,
289: params.po_creation_time,
290: nvl(wi.priority,WIP_CONSTANTS.DEFAULT_PRIORITY),
291: TO_DATE(TO_CHAR(wi.due_date,
292: WIP_CONSTANTS.DT_NOSEC_FMT),
293: WIP_CONSTANTS.DT_NOSEC_FMT),
294: TO_DATE(TO_CHAR(wi.requested_start_date,

Line 292: WIP_CONSTANTS.DT_NOSEC_FMT),

288: wi.end_item_unit_number,
289: params.po_creation_time,
290: nvl(wi.priority,WIP_CONSTANTS.DEFAULT_PRIORITY),
291: TO_DATE(TO_CHAR(wi.due_date,
292: WIP_CONSTANTS.DT_NOSEC_FMT),
293: WIP_CONSTANTS.DT_NOSEC_FMT),
294: TO_DATE(TO_CHAR(wi.requested_start_date,
295: WIP_CONSTANTS.DT_NOSEC_FMT),
296: WIP_CONSTANTS.DT_NOSEC_FMT),

Line 293: WIP_CONSTANTS.DT_NOSEC_FMT),

289: params.po_creation_time,
290: nvl(wi.priority,WIP_CONSTANTS.DEFAULT_PRIORITY),
291: TO_DATE(TO_CHAR(wi.due_date,
292: WIP_CONSTANTS.DT_NOSEC_FMT),
293: WIP_CONSTANTS.DT_NOSEC_FMT),
294: TO_DATE(TO_CHAR(wi.requested_start_date,
295: WIP_CONSTANTS.DT_NOSEC_FMT),
296: WIP_CONSTANTS.DT_NOSEC_FMT),
297: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.parent_wip_entity_id, NULL),

Line 295: WIP_CONSTANTS.DT_NOSEC_FMT),

291: TO_DATE(TO_CHAR(wi.due_date,
292: WIP_CONSTANTS.DT_NOSEC_FMT),
293: WIP_CONSTANTS.DT_NOSEC_FMT),
294: TO_DATE(TO_CHAR(wi.requested_start_date,
295: WIP_CONSTANTS.DT_NOSEC_FMT),
296: WIP_CONSTANTS.DT_NOSEC_FMT),
297: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.parent_wip_entity_id, NULL),
298: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_group_id, NULL),
299: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_number, NULL),

Line 296: WIP_CONSTANTS.DT_NOSEC_FMT),

292: WIP_CONSTANTS.DT_NOSEC_FMT),
293: WIP_CONSTANTS.DT_NOSEC_FMT),
294: TO_DATE(TO_CHAR(wi.requested_start_date,
295: WIP_CONSTANTS.DT_NOSEC_FMT),
296: WIP_CONSTANTS.DT_NOSEC_FMT),
297: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.parent_wip_entity_id, NULL),
298: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_group_id, NULL),
299: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_number, NULL),
300: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.owning_department, NULL),

Line 297: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.parent_wip_entity_id, NULL),

293: WIP_CONSTANTS.DT_NOSEC_FMT),
294: TO_DATE(TO_CHAR(wi.requested_start_date,
295: WIP_CONSTANTS.DT_NOSEC_FMT),
296: WIP_CONSTANTS.DT_NOSEC_FMT),
297: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.parent_wip_entity_id, NULL),
298: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_group_id, NULL),
299: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_number, NULL),
300: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.owning_department, NULL),
301: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_item_id, NULL),

Line 298: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_group_id, NULL),

294: TO_DATE(TO_CHAR(wi.requested_start_date,
295: WIP_CONSTANTS.DT_NOSEC_FMT),
296: WIP_CONSTANTS.DT_NOSEC_FMT),
297: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.parent_wip_entity_id, NULL),
298: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_group_id, NULL),
299: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_number, NULL),
300: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.owning_department, NULL),
301: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_item_id, NULL),
302: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_serial_number, NULL),

Line 299: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_number, NULL),

295: WIP_CONSTANTS.DT_NOSEC_FMT),
296: WIP_CONSTANTS.DT_NOSEC_FMT),
297: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.parent_wip_entity_id, NULL),
298: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_group_id, NULL),
299: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_number, NULL),
300: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.owning_department, NULL),
301: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_item_id, NULL),
302: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_serial_number, NULL),
303: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.manual_rebuild_flag, NULL),

Line 300: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.owning_department, NULL),

296: WIP_CONSTANTS.DT_NOSEC_FMT),
297: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.parent_wip_entity_id, NULL),
298: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_group_id, NULL),
299: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_number, NULL),
300: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.owning_department, NULL),
301: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_item_id, NULL),
302: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_serial_number, NULL),
303: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.manual_rebuild_flag, NULL),
304: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_type, NULL),

Line 301: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_item_id, NULL),

297: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.parent_wip_entity_id, NULL),
298: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_group_id, NULL),
299: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_number, NULL),
300: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.owning_department, NULL),
301: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_item_id, NULL),
302: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_serial_number, NULL),
303: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.manual_rebuild_flag, NULL),
304: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_type, NULL),
305: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_cause, NULL),

Line 302: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_serial_number, NULL),

298: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_group_id, NULL),
299: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_number, NULL),
300: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.owning_department, NULL),
301: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_item_id, NULL),
302: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_serial_number, NULL),
303: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.manual_rebuild_flag, NULL),
304: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_type, NULL),
305: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_cause, NULL),
306: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_source, NULL),

Line 303: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.manual_rebuild_flag, NULL),

299: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.asset_number, NULL),
300: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.owning_department, NULL),
301: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_item_id, NULL),
302: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_serial_number, NULL),
303: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.manual_rebuild_flag, NULL),
304: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_type, NULL),
305: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_cause, NULL),
306: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_source, NULL),
307: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.work_order_type, NULL),

Line 304: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_type, NULL),

300: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.owning_department, NULL),
301: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_item_id, NULL),
302: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_serial_number, NULL),
303: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.manual_rebuild_flag, NULL),
304: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_type, NULL),
305: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_cause, NULL),
306: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_source, NULL),
307: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.work_order_type, NULL),
308: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.notification_required, NULL),

Line 305: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_cause, NULL),

301: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_item_id, NULL),
302: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_serial_number, NULL),
303: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.manual_rebuild_flag, NULL),
304: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_type, NULL),
305: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_cause, NULL),
306: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_source, NULL),
307: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.work_order_type, NULL),
308: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.notification_required, NULL),
309: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.shutdown_type, NULL),

Line 306: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_source, NULL),

302: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.rebuild_serial_number, NULL),
303: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.manual_rebuild_flag, NULL),
304: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_type, NULL),
305: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_cause, NULL),
306: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_source, NULL),
307: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.work_order_type, NULL),
308: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.notification_required, NULL),
309: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.shutdown_type, NULL),
310: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.pm_schedule_id, NULL),

Line 307: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.work_order_type, NULL),

303: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.manual_rebuild_flag, NULL),
304: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_type, NULL),
305: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_cause, NULL),
306: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_source, NULL),
307: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.work_order_type, NULL),
308: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.notification_required, NULL),
309: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.shutdown_type, NULL),
310: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.pm_schedule_id, NULL),
311: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, l_plan_maint, NULL),

Line 308: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.notification_required, NULL),

304: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_type, NULL),
305: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_cause, NULL),
306: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_source, NULL),
307: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.work_order_type, NULL),
308: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.notification_required, NULL),
309: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.shutdown_type, NULL),
310: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.pm_schedule_id, NULL),
311: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, l_plan_maint, NULL),
312: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.tagout_required, NULL),

Line 309: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.shutdown_type, NULL),

305: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_cause, NULL),
306: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_source, NULL),
307: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.work_order_type, NULL),
308: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.notification_required, NULL),
309: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.shutdown_type, NULL),
310: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.pm_schedule_id, NULL),
311: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, l_plan_maint, NULL),
312: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.tagout_required, NULL),
313: wi.attribute_category,

Line 310: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.pm_schedule_id, NULL),

306: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.activity_source, NULL),
307: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.work_order_type, NULL),
308: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.notification_required, NULL),
309: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.shutdown_type, NULL),
310: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.pm_schedule_id, NULL),
311: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, l_plan_maint, NULL),
312: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.tagout_required, NULL),
313: wi.attribute_category,
314: wi.attribute1,

Line 311: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, l_plan_maint, NULL),

307: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.work_order_type, NULL),
308: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.notification_required, NULL),
309: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.shutdown_type, NULL),
310: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.pm_schedule_id, NULL),
311: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, l_plan_maint, NULL),
312: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.tagout_required, NULL),
313: wi.attribute_category,
314: wi.attribute1,
315: wi.attribute2,

Line 312: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.tagout_required, NULL),

308: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.notification_required, NULL),
309: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.shutdown_type, NULL),
310: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.pm_schedule_id, NULL),
311: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, l_plan_maint, NULL),
312: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, wi.tagout_required, NULL),
313: wi.attribute_category,
314: wi.attribute1,
315: wi.attribute2,
316: wi.attribute3,

Line 333: decode(wi.load_type, WIP_CONSTANTS.CREATE_JOB, wi.serialization_start_op,

329: wi.maintenance_object_id,
330: wi.maintenance_object_type,
331: wi.maintenance_object_source,
332: wi.material_issue_by_mo,
333: decode(wi.load_type, WIP_CONSTANTS.CREATE_JOB, wi.serialization_start_op,
334: WIP_CONSTANTS.CREATE_NS_JOB, wi.serialization_start_op, NULL)
335: FROM wip_accounting_classes wac,
336: bom_operational_routings rtg,
337: bom_bill_of_materials bom,

Line 334: WIP_CONSTANTS.CREATE_NS_JOB, wi.serialization_start_op, NULL)

330: wi.maintenance_object_type,
331: wi.maintenance_object_source,
332: wi.material_issue_by_mo,
333: decode(wi.load_type, WIP_CONSTANTS.CREATE_JOB, wi.serialization_start_op,
334: WIP_CONSTANTS.CREATE_NS_JOB, wi.serialization_start_op, NULL)
335: FROM wip_accounting_classes wac,
336: bom_operational_routings rtg,
337: bom_bill_of_materials bom,
338: wip_parameters params,

Line 387: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, 6, 1),

383: wi.program_application_id,
384: wi.program_id,
385: SYSDATE,
386: wi.job_name,
387: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, 6, 1),
388: wi.description,
389: wi.primary_item_id,
390: MTL_GEN_OBJECT_ID_S.nextval
391: FROM WIP_JOB_SCHEDULE_INTERFACE wi

Line 395: if ((x_load_type = WIP_CONSTANTS.CREATE_EAM_JOB)

391: FROM WIP_JOB_SCHEDULE_INTERFACE wi
392: WHERE wi.rowid = WIP_JSI_Utils.current_rowid ;
393:
394: /* Fix for Bug#3201290 */
395: if ((x_load_type = WIP_CONSTANTS.CREATE_EAM_JOB)
396: and (x_status_type = WIP_CONSTANTS.RELEASED)) then
397: WIP_EAM_UTILS.create_default_operation ( x_org_id,
398: x_entity_id
399: ) ;

Line 396: and (x_status_type = WIP_CONSTANTS.RELEASED)) then

392: WHERE wi.rowid = WIP_JSI_Utils.current_rowid ;
393:
394: /* Fix for Bug#3201290 */
395: if ((x_load_type = WIP_CONSTANTS.CREATE_EAM_JOB)
396: and (x_status_type = WIP_CONSTANTS.RELEASED)) then
397: WIP_EAM_UTILS.create_default_operation ( x_org_id,
398: x_entity_id
399: ) ;
400: end if ;

Line 427: elsif (x_load_type IN (WIP_CONSTANTS.RESCHED_JOB, WIP_CONSTANTS.RESCHED_EAM_JOB)) then

423: x_cmn_routing_seq_id /* p_common_routing_sequence_id IN NUMBER */
424: );
425:
426:
427: elsif (x_load_type IN (WIP_CONSTANTS.RESCHED_JOB, WIP_CONSTANTS.RESCHED_EAM_JOB)) then
428:
429: UPDATE WIP_DISCRETE_JOBS WDJ
430: SET ( LAST_UPDATED_BY,
431: last_update_login,

Line 502: WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

498: NVL(WJ.FIRM_PLANNED_FLAG,WDJ.FIRM_PLANNED_FLAG),
499: NVL(WJ.LOT_NUMBER,WDJ.LOT_NUMBER),
500: decode(wj.load_type, 7, 1, 8, WDJ.START_QUANTITY,
501: NVL(ROUND(WJ.START_QUANTITY,
502: WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
503: WDJ.START_QUANTITY)),
504: decode(wj.load_type, 7, 1, 8, WDJ.START_QUANTITY,
505: NVL(ROUND(WJ.NET_QUANTITY,
506: WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

Line 506: WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

502: WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
503: WDJ.START_QUANTITY)),
504: decode(wj.load_type, 7, 1, 8, WDJ.START_QUANTITY,
505: NVL(ROUND(WJ.NET_QUANTITY,
506: WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
507: WDJ.NET_QUANTITY)),
508: NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),
509: DECODE(WJ.STATUS_TYPE,
510: WIP_CONSTANTS.RELEASED,NVL(WDJ.DATE_RELEASED, NVL(WJ.DATE_RELEASED,SYSDATE)),

Line 510: WIP_CONSTANTS.RELEASED,NVL(WDJ.DATE_RELEASED, NVL(WJ.DATE_RELEASED,SYSDATE)),

506: WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
507: WDJ.NET_QUANTITY)),
508: NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),
509: DECODE(WJ.STATUS_TYPE,
510: WIP_CONSTANTS.RELEASED,NVL(WDJ.DATE_RELEASED, NVL(WJ.DATE_RELEASED,SYSDATE)),
511: WIP_CONSTANTS.HOLD,NVL(WDJ.DATE_RELEASED,NVL(WJ.DATE_RELEASED,SYSDATE)),
512: WIP_CONSTANTS.UNRELEASED, NULL, /*bug 3061143*/
513: WDJ.DATE_RELEASED),
514: DECODE(WJ.STATUS_TYPE,

Line 511: WIP_CONSTANTS.HOLD,NVL(WDJ.DATE_RELEASED,NVL(WJ.DATE_RELEASED,SYSDATE)),

507: WDJ.NET_QUANTITY)),
508: NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),
509: DECODE(WJ.STATUS_TYPE,
510: WIP_CONSTANTS.RELEASED,NVL(WDJ.DATE_RELEASED, NVL(WJ.DATE_RELEASED,SYSDATE)),
511: WIP_CONSTANTS.HOLD,NVL(WDJ.DATE_RELEASED,NVL(WJ.DATE_RELEASED,SYSDATE)),
512: WIP_CONSTANTS.UNRELEASED, NULL, /*bug 3061143*/
513: WDJ.DATE_RELEASED),
514: DECODE(WJ.STATUS_TYPE,
515: WIP_CONSTANTS.COMP_CHRG , NVL(WDJ.DATE_COMPLETED, SYSDATE),

Line 512: WIP_CONSTANTS.UNRELEASED, NULL, /*bug 3061143*/

508: NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),
509: DECODE(WJ.STATUS_TYPE,
510: WIP_CONSTANTS.RELEASED,NVL(WDJ.DATE_RELEASED, NVL(WJ.DATE_RELEASED,SYSDATE)),
511: WIP_CONSTANTS.HOLD,NVL(WDJ.DATE_RELEASED,NVL(WJ.DATE_RELEASED,SYSDATE)),
512: WIP_CONSTANTS.UNRELEASED, NULL, /*bug 3061143*/
513: WDJ.DATE_RELEASED),
514: DECODE(WJ.STATUS_TYPE,
515: WIP_CONSTANTS.COMP_CHRG , NVL(WDJ.DATE_COMPLETED, SYSDATE),
516: WIP_CONSTANTS.RELEASED,NULL,

Line 515: WIP_CONSTANTS.COMP_CHRG , NVL(WDJ.DATE_COMPLETED, SYSDATE),

511: WIP_CONSTANTS.HOLD,NVL(WDJ.DATE_RELEASED,NVL(WJ.DATE_RELEASED,SYSDATE)),
512: WIP_CONSTANTS.UNRELEASED, NULL, /*bug 3061143*/
513: WDJ.DATE_RELEASED),
514: DECODE(WJ.STATUS_TYPE,
515: WIP_CONSTANTS.COMP_CHRG , NVL(WDJ.DATE_COMPLETED, SYSDATE),
516: WIP_CONSTANTS.RELEASED,NULL,
517: WIP_CONSTANTS.HOLD, NULL,
518: WIP_CONSTANTS.UNRELEASED, NULL,
519: WIP_CONSTANTS.CANCELLED, NULL,

Line 516: WIP_CONSTANTS.RELEASED,NULL,

512: WIP_CONSTANTS.UNRELEASED, NULL, /*bug 3061143*/
513: WDJ.DATE_RELEASED),
514: DECODE(WJ.STATUS_TYPE,
515: WIP_CONSTANTS.COMP_CHRG , NVL(WDJ.DATE_COMPLETED, SYSDATE),
516: WIP_CONSTANTS.RELEASED,NULL,
517: WIP_CONSTANTS.HOLD, NULL,
518: WIP_CONSTANTS.UNRELEASED, NULL,
519: WIP_CONSTANTS.CANCELLED, NULL,
520: WDJ.DATE_COMPLETED), /*Bug Number 4760788: Update date_completed*/

Line 517: WIP_CONSTANTS.HOLD, NULL,

513: WDJ.DATE_RELEASED),
514: DECODE(WJ.STATUS_TYPE,
515: WIP_CONSTANTS.COMP_CHRG , NVL(WDJ.DATE_COMPLETED, SYSDATE),
516: WIP_CONSTANTS.RELEASED,NULL,
517: WIP_CONSTANTS.HOLD, NULL,
518: WIP_CONSTANTS.UNRELEASED, NULL,
519: WIP_CONSTANTS.CANCELLED, NULL,
520: WDJ.DATE_COMPLETED), /*Bug Number 4760788: Update date_completed*/
521: NVL(WJ.FIRST_UNIT_START_DATE,WDJ.SCHEDULED_START_DATE),

Line 518: WIP_CONSTANTS.UNRELEASED, NULL,

514: DECODE(WJ.STATUS_TYPE,
515: WIP_CONSTANTS.COMP_CHRG , NVL(WDJ.DATE_COMPLETED, SYSDATE),
516: WIP_CONSTANTS.RELEASED,NULL,
517: WIP_CONSTANTS.HOLD, NULL,
518: WIP_CONSTANTS.UNRELEASED, NULL,
519: WIP_CONSTANTS.CANCELLED, NULL,
520: WDJ.DATE_COMPLETED), /*Bug Number 4760788: Update date_completed*/
521: NVL(WJ.FIRST_UNIT_START_DATE,WDJ.SCHEDULED_START_DATE),
522: NVL(WJ.LAST_UNIT_COMPLETION_DATE,

Line 519: WIP_CONSTANTS.CANCELLED, NULL,

515: WIP_CONSTANTS.COMP_CHRG , NVL(WDJ.DATE_COMPLETED, SYSDATE),
516: WIP_CONSTANTS.RELEASED,NULL,
517: WIP_CONSTANTS.HOLD, NULL,
518: WIP_CONSTANTS.UNRELEASED, NULL,
519: WIP_CONSTANTS.CANCELLED, NULL,
520: WDJ.DATE_COMPLETED), /*Bug Number 4760788: Update date_completed*/
521: NVL(WJ.FIRST_UNIT_START_DATE,WDJ.SCHEDULED_START_DATE),
522: NVL(WJ.LAST_UNIT_COMPLETION_DATE,
523: WDJ.SCHEDULED_COMPLETION_DATE),

Line 569: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.work_order_type, WDJ.WORK_ORDER_TYPE),

565: NVL(WJ.END_ITEM_UNIT_NUMBER,
566: WDJ.END_ITEM_UNIT_NUMBER),
567: NVL(WJ.PRIORITY,WDJ.PRIORITY),
568: NVL(WJ.DUE_DATE,WDJ.DUE_DATE),
569: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.work_order_type, WDJ.WORK_ORDER_TYPE),
570: WDJ.WORK_ORDER_TYPE),
571: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(WJ.OWNING_DEPARTMENT, WDJ.OWNING_DEPARTMENT),
572: WDJ.OWNING_DEPARTMENT),
573: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_type, WDJ.ACTIVITY_TYPE),

Line 571: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(WJ.OWNING_DEPARTMENT, WDJ.OWNING_DEPARTMENT),

567: NVL(WJ.PRIORITY,WDJ.PRIORITY),
568: NVL(WJ.DUE_DATE,WDJ.DUE_DATE),
569: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.work_order_type, WDJ.WORK_ORDER_TYPE),
570: WDJ.WORK_ORDER_TYPE),
571: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(WJ.OWNING_DEPARTMENT, WDJ.OWNING_DEPARTMENT),
572: WDJ.OWNING_DEPARTMENT),
573: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_type, WDJ.ACTIVITY_TYPE),
574: WDJ.ACTIVITY_TYPE),
575: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_cause, WDJ.ACTIVITY_CAUSE),

Line 573: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_type, WDJ.ACTIVITY_TYPE),

569: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.work_order_type, WDJ.WORK_ORDER_TYPE),
570: WDJ.WORK_ORDER_TYPE),
571: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(WJ.OWNING_DEPARTMENT, WDJ.OWNING_DEPARTMENT),
572: WDJ.OWNING_DEPARTMENT),
573: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_type, WDJ.ACTIVITY_TYPE),
574: WDJ.ACTIVITY_TYPE),
575: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_cause, WDJ.ACTIVITY_CAUSE),
576: WDJ.ACTIVITY_CAUSE),
577: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_source, WDJ.ACTIVITY_SOURCE),

Line 575: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_cause, WDJ.ACTIVITY_CAUSE),

571: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(WJ.OWNING_DEPARTMENT, WDJ.OWNING_DEPARTMENT),
572: WDJ.OWNING_DEPARTMENT),
573: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_type, WDJ.ACTIVITY_TYPE),
574: WDJ.ACTIVITY_TYPE),
575: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_cause, WDJ.ACTIVITY_CAUSE),
576: WDJ.ACTIVITY_CAUSE),
577: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_source, WDJ.ACTIVITY_SOURCE),
578: WDJ.ACTIVITY_SOURCE),
579: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(WJ.NOTIFICATION_REQUIRED, WDJ.NOTIFICATION_REQUIRED),

Line 577: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_source, WDJ.ACTIVITY_SOURCE),

573: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_type, WDJ.ACTIVITY_TYPE),
574: WDJ.ACTIVITY_TYPE),
575: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_cause, WDJ.ACTIVITY_CAUSE),
576: WDJ.ACTIVITY_CAUSE),
577: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_source, WDJ.ACTIVITY_SOURCE),
578: WDJ.ACTIVITY_SOURCE),
579: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(WJ.NOTIFICATION_REQUIRED, WDJ.NOTIFICATION_REQUIRED),
580: WDJ.NOTIFICATION_REQUIRED),
581: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.shutdown_type, WDJ.SHUTDOWN_TYPE),

Line 579: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(WJ.NOTIFICATION_REQUIRED, WDJ.NOTIFICATION_REQUIRED),

575: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_cause, WDJ.ACTIVITY_CAUSE),
576: WDJ.ACTIVITY_CAUSE),
577: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_source, WDJ.ACTIVITY_SOURCE),
578: WDJ.ACTIVITY_SOURCE),
579: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(WJ.NOTIFICATION_REQUIRED, WDJ.NOTIFICATION_REQUIRED),
580: WDJ.NOTIFICATION_REQUIRED),
581: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.shutdown_type, WDJ.SHUTDOWN_TYPE),
582: WDJ.SHUTDOWN_TYPE),
583: NVL(WJ.ATTRIBUTE_CATEGORY,WDJ.ATTRIBUTE_CATEGORY),

Line 581: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.shutdown_type, WDJ.SHUTDOWN_TYPE),

577: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.activity_source, WDJ.ACTIVITY_SOURCE),
578: WDJ.ACTIVITY_SOURCE),
579: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(WJ.NOTIFICATION_REQUIRED, WDJ.NOTIFICATION_REQUIRED),
580: WDJ.NOTIFICATION_REQUIRED),
581: decode(wj.load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, NVL(wj.shutdown_type, WDJ.SHUTDOWN_TYPE),
582: WDJ.SHUTDOWN_TYPE),
583: NVL(WJ.ATTRIBUTE_CATEGORY,WDJ.ATTRIBUTE_CATEGORY),
584: NVL(WJ.ATTRIBUTE1,WDJ.ATTRIBUTE1),
585: NVL(WJ.ATTRIBUTE2,WDJ.ATTRIBUTE2),

Line 604: WIP_CONSTANTS.DT_NOSEC_FMT),

600: NVL(WJ.MAINTENANCE_OBJECT_TYPE,WDJ.MAINTENANCE_OBJECT_TYPE),
601: NVL(WJ.MAINTENANCE_OBJECT_SOURCE,WDJ.MAINTENANCE_OBJECT_SOURCE),
602: NVL(WJ.material_issue_by_mo,WDJ.material_issue_by_mo),
603: NVL(TO_DATE(TO_CHAR(wj.bom_revision_date,
604: WIP_CONSTANTS.DT_NOSEC_FMT),
605: WIP_CONSTANTS.DT_NOSEC_FMT),
606: WDJ.BOM_REVISION_DATE),
607: NVL(WJ.BOM_REVISION,WDJ.BOM_REVISION),
608: DECODE(WJ.LOAD_TYPE, WIP_CONSTANTS.RESCHED_JOB,

Line 605: WIP_CONSTANTS.DT_NOSEC_FMT),

601: NVL(WJ.MAINTENANCE_OBJECT_SOURCE,WDJ.MAINTENANCE_OBJECT_SOURCE),
602: NVL(WJ.material_issue_by_mo,WDJ.material_issue_by_mo),
603: NVL(TO_DATE(TO_CHAR(wj.bom_revision_date,
604: WIP_CONSTANTS.DT_NOSEC_FMT),
605: WIP_CONSTANTS.DT_NOSEC_FMT),
606: WDJ.BOM_REVISION_DATE),
607: NVL(WJ.BOM_REVISION,WDJ.BOM_REVISION),
608: DECODE(WJ.LOAD_TYPE, WIP_CONSTANTS.RESCHED_JOB,
609: NVL(WJ.SERIALIZATION_START_OP, WDJ.SERIALIZATION_START_OP), WDJ.SERIALIZATION_START_OP)

Line 608: DECODE(WJ.LOAD_TYPE, WIP_CONSTANTS.RESCHED_JOB,

604: WIP_CONSTANTS.DT_NOSEC_FMT),
605: WIP_CONSTANTS.DT_NOSEC_FMT),
606: WDJ.BOM_REVISION_DATE),
607: NVL(WJ.BOM_REVISION,WDJ.BOM_REVISION),
608: DECODE(WJ.LOAD_TYPE, WIP_CONSTANTS.RESCHED_JOB,
609: NVL(WJ.SERIALIZATION_START_OP, WDJ.SERIALIZATION_START_OP), WDJ.SERIALIZATION_START_OP)
610: FROM WIP_JOB_SCHEDULE_INTERFACE WJ
611: WHERE WJ.ROWID = WIP_JSI_Utils.current_rowid)
612: WHERE WDJ.WIP_ENTITY_ID = x_entity_id ;

Line 636: if ((x_load_type = WIP_CONSTANTS.RESCHED_EAM_JOB)

632: WHERE WJ.ROWID = WIP_JSI_Utils.current_rowid)
633: WHERE WE.WIP_ENTITY_ID = x_entity_id ;
634:
635: /* Fix for Bug#3201290 */
636: if ((x_load_type = WIP_CONSTANTS.RESCHED_EAM_JOB)
637: and (x_status_type = WIP_CONSTANTS.RELEASED)) then
638: WIP_EAM_UTILS.create_default_operation ( x_org_id,
639: x_entity_id
640: ) ;

Line 637: and (x_status_type = WIP_CONSTANTS.RELEASED)) then

633: WHERE WE.WIP_ENTITY_ID = x_entity_id ;
634:
635: /* Fix for Bug#3201290 */
636: if ((x_load_type = WIP_CONSTANTS.RESCHED_EAM_JOB)
637: and (x_status_type = WIP_CONSTANTS.RELEASED)) then
638: WIP_EAM_UTILS.create_default_operation ( x_org_id,
639: x_entity_id
640: ) ;
641: end if ;

Line 643: if (x_load_type in (WIP_CONSTANTS.RESCHED_JOB, WIP_CONSTANTS.RESCHED_LOT_JOB) and

639: x_entity_id
640: ) ;
641: end if ;
642:
643: if (x_load_type in (WIP_CONSTANTS.RESCHED_JOB, WIP_CONSTANTS.RESCHED_LOT_JOB) and
644: wip_picking_pub.is_job_pick_released(x_entity_id, x_rep_sched_id, x_org_id) and
645: x_old_start_quantity <> x_new_start_quantity) then
646: FND_MESSAGE.set_name('WIP','WIP_QTY_REQ_CHANGE_WARNING');
647: wip_jsi_utils.record_current_error(TRUE);

Line 664: if(x_load_type = WIP_CONSTANTS.RESCHED_JOB AND x_status_type in

660: end if;
661: end if;
662:
663:
664: if(x_load_type = WIP_CONSTANTS.RESCHED_JOB AND x_status_type in
665: (WIP_CONSTANTS.COMP_NOCHRG, WIP_CONSTANTS.HOLD, wip_constants.cancelled)) then
666: wip_picking_pvt.cancel_allocations(p_wip_entity_id => x_entity_id,
667: p_wip_entity_type => wip_constants.discrete,
668: x_return_status => l_status,

Line 665: (WIP_CONSTANTS.COMP_NOCHRG, WIP_CONSTANTS.HOLD, wip_constants.cancelled)) then

661: end if;
662:
663:
664: if(x_load_type = WIP_CONSTANTS.RESCHED_JOB AND x_status_type in
665: (WIP_CONSTANTS.COMP_NOCHRG, WIP_CONSTANTS.HOLD, wip_constants.cancelled)) then
666: wip_picking_pvt.cancel_allocations(p_wip_entity_id => x_entity_id,
667: p_wip_entity_type => wip_constants.discrete,
668: x_return_status => l_status,
669: x_msg_data => l_msg_data);

Line 667: p_wip_entity_type => wip_constants.discrete,

663:
664: if(x_load_type = WIP_CONSTANTS.RESCHED_JOB AND x_status_type in
665: (WIP_CONSTANTS.COMP_NOCHRG, WIP_CONSTANTS.HOLD, wip_constants.cancelled)) then
666: wip_picking_pvt.cancel_allocations(p_wip_entity_id => x_entity_id,
667: p_wip_entity_type => wip_constants.discrete,
668: x_return_status => l_status,
669: x_msg_data => l_msg_data);
670: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
671: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');

Line 678: elsif (x_load_type = WIP_CONSTANTS.CREATE_SCHED) then

674: wip_jsi_utils.record_current_error;
675: end if;
676: end if;
677:
678: elsif (x_load_type = WIP_CONSTANTS.CREATE_SCHED) then
679:
680: INSERT INTO WIP_REPETITIVE_SCHEDULES(
681: repetitive_schedule_id,
682: organization_id,

Line 755: WIP_CONSTANTS.PEND_REPML,

751: ri.wip_entity_id,
752: wi.line_id,
753: wi.daily_production_rate,
754: wi.processing_work_days,
755: WIP_CONSTANTS.PEND_REPML,
756: wi.firm_planned_flag,
757: ri.alternate_bom_designator,
758: bom.common_bill_sequence_id,
759: wi.bom_revision,

Line 761: WIP_CONSTANTS.DT_NOSEC_FMT),

757: ri.alternate_bom_designator,
758: bom.common_bill_sequence_id,
759: wi.bom_revision,
760: TO_DATE(TO_CHAR(wi.bom_revision_date,
761: WIP_CONSTANTS.DT_NOSEC_FMT),
762: WIP_CONSTANTS.DT_NOSEC_FMT),
763: ri.alternate_routing_designator,
764: bor.common_routing_sequence_id,
765: wi.routing_revision,

Line 762: WIP_CONSTANTS.DT_NOSEC_FMT),

758: bom.common_bill_sequence_id,
759: wi.bom_revision,
760: TO_DATE(TO_CHAR(wi.bom_revision_date,
761: WIP_CONSTANTS.DT_NOSEC_FMT),
762: WIP_CONSTANTS.DT_NOSEC_FMT),
763: ri.alternate_routing_designator,
764: bor.common_routing_sequence_id,
765: wi.routing_revision,
766: TO_DATE(TO_CHAR(wi.routing_revision_date,

Line 767: WIP_CONSTANTS.DT_NOSEC_FMT),

763: ri.alternate_routing_designator,
764: bor.common_routing_sequence_id,
765: wi.routing_revision,
766: TO_DATE(TO_CHAR(wi.routing_revision_date,
767: WIP_CONSTANTS.DT_NOSEC_FMT),
768: WIP_CONSTANTS.DT_NOSEC_FMT),
769: TO_DATE(TO_CHAR(wi.first_unit_start_date,
770: WIP_CONSTANTS.DT_NOSEC_FMT),
771: WIP_CONSTANTS.DT_NOSEC_FMT),

Line 768: WIP_CONSTANTS.DT_NOSEC_FMT),

764: bor.common_routing_sequence_id,
765: wi.routing_revision,
766: TO_DATE(TO_CHAR(wi.routing_revision_date,
767: WIP_CONSTANTS.DT_NOSEC_FMT),
768: WIP_CONSTANTS.DT_NOSEC_FMT),
769: TO_DATE(TO_CHAR(wi.first_unit_start_date,
770: WIP_CONSTANTS.DT_NOSEC_FMT),
771: WIP_CONSTANTS.DT_NOSEC_FMT),
772: TO_DATE(TO_CHAR(wi.first_unit_completion_date,

Line 770: WIP_CONSTANTS.DT_NOSEC_FMT),

766: TO_DATE(TO_CHAR(wi.routing_revision_date,
767: WIP_CONSTANTS.DT_NOSEC_FMT),
768: WIP_CONSTANTS.DT_NOSEC_FMT),
769: TO_DATE(TO_CHAR(wi.first_unit_start_date,
770: WIP_CONSTANTS.DT_NOSEC_FMT),
771: WIP_CONSTANTS.DT_NOSEC_FMT),
772: TO_DATE(TO_CHAR(wi.first_unit_completion_date,
773: WIP_CONSTANTS.DT_NOSEC_FMT),
774: WIP_CONSTANTS.DT_NOSEC_FMT),

Line 771: WIP_CONSTANTS.DT_NOSEC_FMT),

767: WIP_CONSTANTS.DT_NOSEC_FMT),
768: WIP_CONSTANTS.DT_NOSEC_FMT),
769: TO_DATE(TO_CHAR(wi.first_unit_start_date,
770: WIP_CONSTANTS.DT_NOSEC_FMT),
771: WIP_CONSTANTS.DT_NOSEC_FMT),
772: TO_DATE(TO_CHAR(wi.first_unit_completion_date,
773: WIP_CONSTANTS.DT_NOSEC_FMT),
774: WIP_CONSTANTS.DT_NOSEC_FMT),
775: TO_DATE(TO_CHAR(wi.last_unit_start_date,

Line 773: WIP_CONSTANTS.DT_NOSEC_FMT),

769: TO_DATE(TO_CHAR(wi.first_unit_start_date,
770: WIP_CONSTANTS.DT_NOSEC_FMT),
771: WIP_CONSTANTS.DT_NOSEC_FMT),
772: TO_DATE(TO_CHAR(wi.first_unit_completion_date,
773: WIP_CONSTANTS.DT_NOSEC_FMT),
774: WIP_CONSTANTS.DT_NOSEC_FMT),
775: TO_DATE(TO_CHAR(wi.last_unit_start_date,
776: WIP_CONSTANTS.DT_NOSEC_FMT),
777: WIP_CONSTANTS.DT_NOSEC_FMT),

Line 774: WIP_CONSTANTS.DT_NOSEC_FMT),

770: WIP_CONSTANTS.DT_NOSEC_FMT),
771: WIP_CONSTANTS.DT_NOSEC_FMT),
772: TO_DATE(TO_CHAR(wi.first_unit_completion_date,
773: WIP_CONSTANTS.DT_NOSEC_FMT),
774: WIP_CONSTANTS.DT_NOSEC_FMT),
775: TO_DATE(TO_CHAR(wi.last_unit_start_date,
776: WIP_CONSTANTS.DT_NOSEC_FMT),
777: WIP_CONSTANTS.DT_NOSEC_FMT),
778: TO_DATE(TO_CHAR(wi.last_unit_completion_date,

Line 776: WIP_CONSTANTS.DT_NOSEC_FMT),

772: TO_DATE(TO_CHAR(wi.first_unit_completion_date,
773: WIP_CONSTANTS.DT_NOSEC_FMT),
774: WIP_CONSTANTS.DT_NOSEC_FMT),
775: TO_DATE(TO_CHAR(wi.last_unit_start_date,
776: WIP_CONSTANTS.DT_NOSEC_FMT),
777: WIP_CONSTANTS.DT_NOSEC_FMT),
778: TO_DATE(TO_CHAR(wi.last_unit_completion_date,
779: WIP_CONSTANTS.DT_NOSEC_FMT),
780: WIP_CONSTANTS.DT_NOSEC_FMT),

Line 777: WIP_CONSTANTS.DT_NOSEC_FMT),

773: WIP_CONSTANTS.DT_NOSEC_FMT),
774: WIP_CONSTANTS.DT_NOSEC_FMT),
775: TO_DATE(TO_CHAR(wi.last_unit_start_date,
776: WIP_CONSTANTS.DT_NOSEC_FMT),
777: WIP_CONSTANTS.DT_NOSEC_FMT),
778: TO_DATE(TO_CHAR(wi.last_unit_completion_date,
779: WIP_CONSTANTS.DT_NOSEC_FMT),
780: WIP_CONSTANTS.DT_NOSEC_FMT),
781: 0, /* quantity completed */

Line 779: WIP_CONSTANTS.DT_NOSEC_FMT),

775: TO_DATE(TO_CHAR(wi.last_unit_start_date,
776: WIP_CONSTANTS.DT_NOSEC_FMT),
777: WIP_CONSTANTS.DT_NOSEC_FMT),
778: TO_DATE(TO_CHAR(wi.last_unit_completion_date,
779: WIP_CONSTANTS.DT_NOSEC_FMT),
780: WIP_CONSTANTS.DT_NOSEC_FMT),
781: 0, /* quantity completed */
782: wi.description,
783: wi.demand_class,

Line 780: WIP_CONSTANTS.DT_NOSEC_FMT),

776: WIP_CONSTANTS.DT_NOSEC_FMT),
777: WIP_CONSTANTS.DT_NOSEC_FMT),
778: TO_DATE(TO_CHAR(wi.last_unit_completion_date,
779: WIP_CONSTANTS.DT_NOSEC_FMT),
780: WIP_CONSTANTS.DT_NOSEC_FMT),
781: 0, /* quantity completed */
782: wi.description,
783: wi.demand_class,
784: ac.material_account,

Line 838: if (x_load_type in (WIP_CONSTANTS.CREATE_JOB,

834: end if ;
835: /*
836: Fix for Bug#2034660
837:
838: if (x_load_type in (WIP_CONSTANTS.CREATE_JOB,
839: WIP_CONSTANTS.CREATE_SCHED
840: ) and
841: x_status_type = WIP_CONSTANTS.released)
842: then

Line 839: WIP_CONSTANTS.CREATE_SCHED

835: /*
836: Fix for Bug#2034660
837:
838: if (x_load_type in (WIP_CONSTANTS.CREATE_JOB,
839: WIP_CONSTANTS.CREATE_SCHED
840: ) and
841: x_status_type = WIP_CONSTANTS.released)
842: then
843: WIP_OSP.release_validation(x_entity_id, x_org_id, x_rep_sched_id) ;

Line 841: x_status_type = WIP_CONSTANTS.released)

837:
838: if (x_load_type in (WIP_CONSTANTS.CREATE_JOB,
839: WIP_CONSTANTS.CREATE_SCHED
840: ) and
841: x_status_type = WIP_CONSTANTS.released)
842: then
843: WIP_OSP.release_validation(x_entity_id, x_org_id, x_rep_sched_id) ;
844: end if;
845:

Line 863: to_char(P_Group_Id), NULL, to_char(WIP_CONSTANTS.NO),

859: BEGIN
860:
861: req_id := FND_REQUEST.SUBMIT_REQUEST
862: ('WIP','WIPMLINT',NULL,NULL,FALSE,
863: to_char(P_Group_Id), NULL, to_char(WIP_CONSTANTS.NO),
864: chr(0), NULL, NULL, NULL, NULL, NULL, NULL,
865: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
866: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
867: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 898: WHERE PROCESS_PHASE = WIP_CONSTANTS.ML_COMPLETE

894: DELETE FROM WIP_INTERFACE_ERRORS
895: WHERE INTERFACE_ID IN
896: (SELECT INTERFACE_ID
897: FROM WIP_JOB_SCHEDULE_INTERFACE
898: WHERE PROCESS_PHASE = WIP_CONSTANTS.ML_COMPLETE
899: AND GROUP_ID = P_Group_Id
900: AND PROCESS_STATUS = WIP_CONSTANTS.ML_COMPLETE);
901:
902: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE

Line 900: AND PROCESS_STATUS = WIP_CONSTANTS.ML_COMPLETE);

896: (SELECT INTERFACE_ID
897: FROM WIP_JOB_SCHEDULE_INTERFACE
898: WHERE PROCESS_PHASE = WIP_CONSTANTS.ML_COMPLETE
899: AND GROUP_ID = P_Group_Id
900: AND PROCESS_STATUS = WIP_CONSTANTS.ML_COMPLETE);
901:
902: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE
903: WHERE GROUP_ID = P_Group_Id
904: AND PROCESS_PHASE = WIP_CONSTANTS.ML_COMPLETE

Line 904: AND PROCESS_PHASE = WIP_CONSTANTS.ML_COMPLETE

900: AND PROCESS_STATUS = WIP_CONSTANTS.ML_COMPLETE);
901:
902: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE
903: WHERE GROUP_ID = P_Group_Id
904: AND PROCESS_PHASE = WIP_CONSTANTS.ML_COMPLETE
905: AND PROCESS_STATUS = WIP_CONSTANTS.ML_COMPLETE;
906:
907: END Delete_Completed_Records;
908:

Line 905: AND PROCESS_STATUS = WIP_CONSTANTS.ML_COMPLETE;

901:
902: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE
903: WHERE GROUP_ID = P_Group_Id
904: AND PROCESS_PHASE = WIP_CONSTANTS.ML_COMPLETE
905: AND PROCESS_STATUS = WIP_CONSTANTS.ML_COMPLETE;
906:
907: END Delete_Completed_Records;
908:
909: PROCEDURE ML_Release(P_Wip_Entity_Id IN NUMBER,

Line 922: WIP_CONSTANTS.UNRELEASED,

918: (P_Wip_Entity_Id,
919: P_Organization_Id,
920: NULL, NULL,
921: P_Class_Code,
922: WIP_CONSTANTS.UNRELEASED,
923: P_New_Status_Type,
924: x_dummy);
925:
926: P_Success_Flag := 1;