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(TO_DATE(TO_CHAR(WJ.FIRST_UNIT_START_DATE,WIP_CONSTANTS.DT_NOSEC_FMT), WIP_CONSTANTS.DT_NOSEC_FMT),

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(TO_DATE(TO_CHAR(WJ.FIRST_UNIT_START_DATE,WIP_CONSTANTS.DT_NOSEC_FMT), WIP_CONSTANTS.DT_NOSEC_FMT),
522: WDJ.SCHEDULED_START_DATE),/*Fix for Bug 8784056 (FP of 8704687), format date before upate WDJ*/

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(TO_DATE(TO_CHAR(WJ.FIRST_UNIT_START_DATE,WIP_CONSTANTS.DT_NOSEC_FMT), WIP_CONSTANTS.DT_NOSEC_FMT),
522: WDJ.SCHEDULED_START_DATE),/*Fix for Bug 8784056 (FP of 8704687), format date before upate WDJ*/
523: NVL(TO_DATE(TO_CHAR(WJ.LAST_UNIT_COMPLETION_DATE,WIP_CONSTANTS.DT_NOSEC_FMT), WIP_CONSTANTS.DT_NOSEC_FMT),

Line 521: NVL(TO_DATE(TO_CHAR(WJ.FIRST_UNIT_START_DATE,WIP_CONSTANTS.DT_NOSEC_FMT), WIP_CONSTANTS.DT_NOSEC_FMT),

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(TO_DATE(TO_CHAR(WJ.FIRST_UNIT_START_DATE,WIP_CONSTANTS.DT_NOSEC_FMT), WIP_CONSTANTS.DT_NOSEC_FMT),
522: WDJ.SCHEDULED_START_DATE),/*Fix for Bug 8784056 (FP of 8704687), format date before upate WDJ*/
523: NVL(TO_DATE(TO_CHAR(WJ.LAST_UNIT_COMPLETION_DATE,WIP_CONSTANTS.DT_NOSEC_FMT), WIP_CONSTANTS.DT_NOSEC_FMT),
524: WDJ.SCHEDULED_COMPLETION_DATE),/*Fix for Bug 8784056 (FP of 8704687), format date before upate WDJ*/
525: NVL(WJ.SCHEDULE_GROUP_ID,WDJ.SCHEDULE_GROUP_ID),

Line 523: NVL(TO_DATE(TO_CHAR(WJ.LAST_UNIT_COMPLETION_DATE,WIP_CONSTANTS.DT_NOSEC_FMT), WIP_CONSTANTS.DT_NOSEC_FMT),

519: WIP_CONSTANTS.CANCELLED, NULL,
520: WDJ.DATE_COMPLETED), /*Bug Number 4760788: Update date_completed*/
521: NVL(TO_DATE(TO_CHAR(WJ.FIRST_UNIT_START_DATE,WIP_CONSTANTS.DT_NOSEC_FMT), WIP_CONSTANTS.DT_NOSEC_FMT),
522: WDJ.SCHEDULED_START_DATE),/*Fix for Bug 8784056 (FP of 8704687), format date before upate WDJ*/
523: NVL(TO_DATE(TO_CHAR(WJ.LAST_UNIT_COMPLETION_DATE,WIP_CONSTANTS.DT_NOSEC_FMT), WIP_CONSTANTS.DT_NOSEC_FMT),
524: WDJ.SCHEDULED_COMPLETION_DATE),/*Fix for Bug 8784056 (FP of 8704687), format date before upate WDJ*/
525: NVL(WJ.SCHEDULE_GROUP_ID,WDJ.SCHEDULE_GROUP_ID),
526: NVL(WJ.BUILD_SEQUENCE,WDJ.BUILD_SEQUENCE),
527: NVL(WJ.LINE_ID,WDJ.LINE_ID),

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 605: WIP_CONSTANTS.DT_NOSEC_FMT),

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

Line 606: WIP_CONSTANTS.DT_NOSEC_FMT),

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 668: p_wip_entity_type => wip_constants.discrete,

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

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

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

Line 756: WIP_CONSTANTS.PEND_REPML,

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

Line 762: WIP_CONSTANTS.DT_NOSEC_FMT),

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

Line 763: WIP_CONSTANTS.DT_NOSEC_FMT),

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

Line 768: WIP_CONSTANTS.DT_NOSEC_FMT),

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

Line 769: WIP_CONSTANTS.DT_NOSEC_FMT),

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

Line 771: WIP_CONSTANTS.DT_NOSEC_FMT),

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

Line 772: WIP_CONSTANTS.DT_NOSEC_FMT),

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

Line 774: WIP_CONSTANTS.DT_NOSEC_FMT),

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

Line 775: WIP_CONSTANTS.DT_NOSEC_FMT),

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

Line 777: WIP_CONSTANTS.DT_NOSEC_FMT),

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

Line 778: WIP_CONSTANTS.DT_NOSEC_FMT),

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

Line 780: WIP_CONSTANTS.DT_NOSEC_FMT),

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

Line 781: WIP_CONSTANTS.DT_NOSEC_FMT),

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

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

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

Line 840: WIP_CONSTANTS.CREATE_SCHED

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

Line 842: x_status_type = WIP_CONSTANTS.released)

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

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

860: BEGIN
861:
862: req_id := FND_REQUEST.SUBMIT_REQUEST
863: ('WIP','WIPMLINT',NULL,NULL,FALSE,
864: to_char(P_Group_Id), NULL, to_char(WIP_CONSTANTS.NO),
865: chr(0), 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,
868: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 899: WHERE PROCESS_PHASE = WIP_CONSTANTS.ML_COMPLETE

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

Line 901: AND PROCESS_STATUS = WIP_CONSTANTS.ML_COMPLETE);

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

Line 905: AND PROCESS_PHASE = WIP_CONSTANTS.ML_COMPLETE

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

Line 906: AND PROCESS_STATUS = WIP_CONSTANTS.ML_COMPLETE;

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

Line 923: WIP_CONSTANTS.UNRELEASED,

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