APPS.WIP_MASSLOAD_PVT dependencies on WIP_CONSTANTS

Line 40: if (l_logLevel <= wip_constants.trace_logging) then

36: begin
37: x_returnStatus := fnd_api.g_ret_sts_success;
38: savepoint begin_process_wjsi;
39:
40: if (l_logLevel <= wip_constants.trace_logging) then
41: l_params(1).paramName := 'p_rowid';
42: l_params(1).paramValue := p_rowid;
43: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
44: p_params => l_params,

Line 56: if ( l_logLevel <= wip_constants.trace_logging ) then

52: into wjsi_row
53: from wip_job_schedule_interface
54: where rowid = p_rowid;
55:
56: if ( l_logLevel <= wip_constants.trace_logging ) then
57: wip_logger.log('Interface id: ' || wjsi_row.interface_id || ' load type is: ' || wjsi_row.load_type,
58: l_retStatus);
59: end if;
60:

Line 62: if ( wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) ) then

58: l_retStatus);
59: end if;
60:
61:
62: if ( wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) ) then
63: -- create job header record
64: createWIPEntity(p_rowid);
65:
66: if ( wjsi_row.load_type = wip_constants.create_job ) then

Line 66: if ( wjsi_row.load_type = wip_constants.create_job ) then

62: if ( wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) ) then
63: -- create job header record
64: createWIPEntity(p_rowid);
65:
66: if ( wjsi_row.load_type = wip_constants.create_job ) then
67: l_jobType := wip_constants.standard;
68: else
69: l_jobType := wip_constants.nonstandard;
70: end if;

Line 67: l_jobType := wip_constants.standard;

63: -- create job header record
64: createWIPEntity(p_rowid);
65:
66: if ( wjsi_row.load_type = wip_constants.create_job ) then
67: l_jobType := wip_constants.standard;
68: else
69: l_jobType := wip_constants.nonstandard;
70: end if;
71:

Line 69: l_jobType := wip_constants.nonstandard;

65:
66: if ( wjsi_row.load_type = wip_constants.create_job ) then
67: l_jobType := wip_constants.standard;
68: else
69: l_jobType := wip_constants.nonstandard;
70: end if;
71:
72: if ( nvl(wjsi_row.allow_explosion, 'Y') not in ('n', 'N') ) then
73: wip_bomRouting_pvt.createJob(p_orgID => wjsi_row.organization_id,

Line 114: and serial_number_control_code = wip_constants.full_sn);

110: and exists (select 1
111: from mtl_system_items
112: where inventory_item_id = wjsi_row.primary_item_id
113: and organization_id = wjsi_row.organization_id
114: and serial_number_control_code = wip_constants.full_sn);
115: elsif ( l_defaultSer = wip_constants.yes ) then
116: update wip_discrete_jobs
117: set serialization_start_op = (select nvl(min(operation_seq_num), 1)
118: from wip_operations

Line 115: elsif ( l_defaultSer = wip_constants.yes ) then

111: from mtl_system_items
112: where inventory_item_id = wjsi_row.primary_item_id
113: and organization_id = wjsi_row.organization_id
114: and serial_number_control_code = wip_constants.full_sn);
115: elsif ( l_defaultSer = wip_constants.yes ) then
116: update wip_discrete_jobs
117: set serialization_start_op = (select nvl(min(operation_seq_num), 1)
118: from wip_operations
119: where wip_entity_id = wjsi_row.wip_entity_id)

Line 125: and serial_number_control_code = wip_constants.full_sn);

121: and exists (select 1
122: from mtl_system_items
123: where inventory_item_id = wjsi_row.primary_item_id
124: and organization_id = wjsi_row.organization_id
125: and serial_number_control_code = wip_constants.full_sn);
126: end if;
127: end if;
128:
129: -- release job if necessary

Line 130: if ( wjsi_row.status_type in (wip_constants.released, wip_constants.hold) ) then

126: end if;
127: end if;
128:
129: -- release job if necessary
130: if ( wjsi_row.status_type in (wip_constants.released, wip_constants.hold) ) then
131: wip_mass_load_processor.ml_release(wjsi_row.wip_entity_id,
132: wjsi_row.organization_id,
133: wjsi_row.class_code,
134: wjsi_row.status_type,

Line 143: elsif ( wjsi_row.load_type = wip_constants.resched_job ) then

139: raise fnd_api.g_exc_unexpected_error;
140: end if;
141: end if;
142:
143: elsif ( wjsi_row.load_type = wip_constants.resched_job ) then
144: select bom_reference_id,
145: routing_reference_id,
146: bom_revision_date,
147: routing_revision_date,

Line 168: if ( wjsi_row.scheduling_method = wip_constants.routing ) then

164: from wip_discrete_jobs
165: where wip_entity_id = wjsi_row.wip_entity_id
166: and organization_id = wjsi_row.organization_id;
167:
168: if ( wjsi_row.scheduling_method = wip_constants.routing ) then
169: if ( wjsi_row.last_unit_completion_date is not null ) then
170: l_startDate := null;
171: l_endDate := wjsi_row.last_unit_completion_date;
172: elsif ( wjsi_row.first_unit_start_date is not null ) then

Line 219: l_statusType in (wip_constants.released, wip_constants.unreleased) ) then

215: end if;
216:
217: -- handle status change
218: if ( l_statusType <> wjsi_row.status_type and
219: l_statusType in (wip_constants.released, wip_constants.unreleased) ) then
220: wip_mass_load_processor.ml_status_change(
221: wjsi_row.wip_entity_id,
222: wjsi_row.organization_id,
223: wjsi_row.class_code,

Line 250: if ( wjsi_row.status_type in (wip_constants.comp_nochrg,

246: raise fnd_api.g_exc_unexpected_error;
247: end if;
248: end if;
249:
250: if ( wjsi_row.status_type in (wip_constants.comp_nochrg,
251: wip_constants.hold,
252: wip_constants.cancelled) ) then
253: wip_picking_pvt.cancel_allocations(p_wip_entity_id => wjsi_row.wip_entity_id,
254: p_wip_entity_type => wip_constants.discrete,

Line 251: wip_constants.hold,

247: end if;
248: end if;
249:
250: if ( wjsi_row.status_type in (wip_constants.comp_nochrg,
251: wip_constants.hold,
252: wip_constants.cancelled) ) then
253: wip_picking_pvt.cancel_allocations(p_wip_entity_id => wjsi_row.wip_entity_id,
254: p_wip_entity_type => wip_constants.discrete,
255: x_return_status => l_retStatus,

Line 252: wip_constants.cancelled) ) then

248: end if;
249:
250: if ( wjsi_row.status_type in (wip_constants.comp_nochrg,
251: wip_constants.hold,
252: wip_constants.cancelled) ) then
253: wip_picking_pvt.cancel_allocations(p_wip_entity_id => wjsi_row.wip_entity_id,
254: p_wip_entity_type => wip_constants.discrete,
255: x_return_status => l_retStatus,
256: x_msg_data => x_errorMsg);

Line 254: p_wip_entity_type => wip_constants.discrete,

250: if ( wjsi_row.status_type in (wip_constants.comp_nochrg,
251: wip_constants.hold,
252: wip_constants.cancelled) ) then
253: wip_picking_pvt.cancel_allocations(p_wip_entity_id => wjsi_row.wip_entity_id,
254: p_wip_entity_type => wip_constants.discrete,
255: x_return_status => l_retStatus,
256: x_msg_data => x_errorMsg);
257: if ( l_retStatus <> fnd_api.g_ret_sts_success ) then
258: raise fnd_api.g_exc_unexpected_error;

Line 266: wjsi_row.status_type = wip_constants.released and

262: -- Call the stored procedure to create a po req only if both old and new statuses
263: -- are released and the new quantity is > old quantity. When the status is
264: -- changed to released, already existing stored procedures will create a po req.
265: if ( wjsi_row.start_quantity > l_qty and
266: wjsi_row.status_type = wip_constants.released and
267: l_statusType = wip_constants.unreleased ) then
268: wip_osp.create_additional_req(wjsi_row.wip_entity_id,
269: wjsi_row.organization_id,
270: null,

Line 267: l_statusType = wip_constants.unreleased ) then

263: -- are released and the new quantity is > old quantity. When the status is
264: -- changed to released, already existing stored procedures will create a po req.
265: if ( wjsi_row.start_quantity > l_qty and
266: wjsi_row.status_type = wip_constants.released and
267: l_statusType = wip_constants.unreleased ) then
268: wip_osp.create_additional_req(wjsi_row.wip_entity_id,
269: wjsi_row.organization_id,
270: null,
271: wjsi_row.start_quantity - l_qty);

Line 288: if (l_logLevel <= wip_constants.trace_logging) then

284: set wip_supply_type = wjsi_row.wip_supply_type
285: where wip_entity_id = wjsi_row.wip_entity_id;
286: End if;
287:
288: if (l_logLevel <= wip_constants.trace_logging) then
289: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
290: p_procReturnStatus => x_returnStatus,
291: p_msg => 'success',
292: x_returnStatus => l_retStatus);

Line 299: if(l_logLevel <= wip_constants.trace_logging) then

295: exception
296: when fnd_api.g_exc_unexpected_error then
297: rollback to savepoint begin_process_wjsi;
298: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
299: if(l_logLevel <= wip_constants.trace_logging) then
300: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
301: p_procReturnStatus => x_returnStatus,
302: p_msg => x_errorMsg,
303: x_returnStatus => l_retStatus);

Line 307: if(l_logLevel <= wip_constants.trace_logging) then

303: x_returnStatus => l_retStatus);
304: end if;
305: when others then
306: rollback to savepoint begin_process_wjsi;
307: if(l_logLevel <= wip_constants.trace_logging) then
308: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
309: p_procReturnStatus => x_returnStatus,
310: p_msg => 'unexp error:' || SQLERRM,
311: x_returnStatus => l_retStatus);

Line 423: wip_constants.released,

419: wjsi.source_code,
420: wjsi.description,
421: wjsi.status_type,
422: decode(wjsi.status_type,
423: wip_constants.released,
424: decode(wjsi.date_released, null, sysdate,
425: decode(sign(wjsi.date_released-sysdate), 1, sysdate, wjsi.date_released)),
426: wip_constants.hold,
427: decode(wjsi.date_released, null, sysdate,

Line 426: wip_constants.hold,

422: decode(wjsi.status_type,
423: wip_constants.released,
424: decode(wjsi.date_released, null, sysdate,
425: decode(sign(wjsi.date_released-sysdate), 1, sysdate, wjsi.date_released)),
426: wip_constants.hold,
427: decode(wjsi.date_released, null, sysdate,
428: decode(sign(wjsi.date_released-sysdate), 1, sysdate, wjsi.date_released)),
429: null),
430: wjsi.primary_item_id,

Line 431: decode(wjsi.load_type, wip_constants.create_job, null, wjsi.bom_reference_id),

427: decode(wjsi.date_released, null, sysdate,
428: decode(sign(wjsi.date_released-sysdate), 1, sysdate, wjsi.date_released)),
429: null),
430: wjsi.primary_item_id,
431: decode(wjsi.load_type, wip_constants.create_job, null, wjsi.bom_reference_id),
432: decode(wjsi.load_type, wip_constants.create_job, null, wjsi.routing_reference_id),
433: wjsi.firm_planned_flag,
434: decode(wjsi.load_type, wip_constants.create_job, wip_constants.standard, wip_constants.nonstandard),
435: wjsi.wip_supply_type,

Line 432: decode(wjsi.load_type, wip_constants.create_job, null, wjsi.routing_reference_id),

428: decode(sign(wjsi.date_released-sysdate), 1, sysdate, wjsi.date_released)),
429: null),
430: wjsi.primary_item_id,
431: decode(wjsi.load_type, wip_constants.create_job, null, wjsi.bom_reference_id),
432: decode(wjsi.load_type, wip_constants.create_job, null, wjsi.routing_reference_id),
433: wjsi.firm_planned_flag,
434: decode(wjsi.load_type, wip_constants.create_job, wip_constants.standard, wip_constants.nonstandard),
435: wjsi.wip_supply_type,
436: wjsi.class_code,

Line 434: decode(wjsi.load_type, wip_constants.create_job, wip_constants.standard, wip_constants.nonstandard),

430: wjsi.primary_item_id,
431: decode(wjsi.load_type, wip_constants.create_job, null, wjsi.bom_reference_id),
432: decode(wjsi.load_type, wip_constants.create_job, null, wjsi.routing_reference_id),
433: wjsi.firm_planned_flag,
434: decode(wjsi.load_type, wip_constants.create_job, wip_constants.standard, wip_constants.nonstandard),
435: wjsi.wip_supply_type,
436: wjsi.class_code,
437: wac.material_account,
438: wac.material_overhead_account,

Line 449: round(wjsi.start_quantity, wip_constants.max_displayed_precision),

445: wac.overhead_account,
446: wac.overhead_variance_account,
447: nvl(wjsi.first_unit_start_date, wjsi.last_unit_completion_date),
448: nvl(wjsi.last_unit_completion_date, wjsi.first_unit_start_date),
449: round(wjsi.start_quantity, wip_constants.max_displayed_precision),
450: 0, -- quantity_completed
451: 0, -- quantity_scrapped
452: round(wjsi.net_quantity, wip_constants.max_displayed_precision),
453: bom.common_bill_sequence_id,

Line 452: round(wjsi.net_quantity, wip_constants.max_displayed_precision),

448: nvl(wjsi.last_unit_completion_date, wjsi.first_unit_start_date),
449: round(wjsi.start_quantity, wip_constants.max_displayed_precision),
450: 0, -- quantity_completed
451: 0, -- quantity_scrapped
452: round(wjsi.net_quantity, wip_constants.max_displayed_precision),
453: bom.common_bill_sequence_id,
454: rtg.common_routing_sequence_id,
455: wjsi.bom_revision,
456: wjsi.routing_revision,

Line 475: nvl(wjsi.priority, wip_constants.default_priority),

471: wjsi.overcompletion_tolerance_type,
472: wjsi.overcompletion_tolerance_value,
473: wjsi.end_item_unit_number,
474: wp.po_creation_time,
475: nvl(wjsi.priority, wip_constants.default_priority),
476: wjsi.due_date,
477: /* Bug 5745772: Requested start date and due date can only co exist if routing does not exist.*/
478: decode(wjsi.due_date, NULL,TO_DATE(
479: TO_CHAR(

Line 480: wjsi.requested_start_date,WIP_CONSTANTS.DT_NOSEC_FMT

476: wjsi.due_date,
477: /* Bug 5745772: Requested start date and due date can only co exist if routing does not exist.*/
478: decode(wjsi.due_date, NULL,TO_DATE(
479: TO_CHAR(
480: wjsi.requested_start_date,WIP_CONSTANTS.DT_NOSEC_FMT
481: ),WIP_CONSTANTS.DT_NOSEC_FMT
482: ),
483: DECODE(
484: wjsi.routing_revision,NULL, TO_DATE(

Line 481: ),WIP_CONSTANTS.DT_NOSEC_FMT

477: /* Bug 5745772: Requested start date and due date can only co exist if routing does not exist.*/
478: decode(wjsi.due_date, NULL,TO_DATE(
479: TO_CHAR(
480: wjsi.requested_start_date,WIP_CONSTANTS.DT_NOSEC_FMT
481: ),WIP_CONSTANTS.DT_NOSEC_FMT
482: ),
483: DECODE(
484: wjsi.routing_revision,NULL, TO_DATE(
485: TO_CHAR(

Line 486: wjsi.requested_start_date,WIP_CONSTANTS.DT_NOSEC_FMT

482: ),
483: DECODE(
484: wjsi.routing_revision,NULL, TO_DATE(
485: TO_CHAR(
486: wjsi.requested_start_date,WIP_CONSTANTS.DT_NOSEC_FMT
487: ),WIP_CONSTANTS.DT_NOSEC_FMT
488: ),NULL
489: )
490: ),

Line 487: ),WIP_CONSTANTS.DT_NOSEC_FMT

483: DECODE(
484: wjsi.routing_revision,NULL, TO_DATE(
485: TO_CHAR(
486: wjsi.requested_start_date,WIP_CONSTANTS.DT_NOSEC_FMT
487: ),WIP_CONSTANTS.DT_NOSEC_FMT
488: ),NULL
489: )
490: ),
491: --wjsi.requested_start_date,

Line 522: wip_constants.create_job, wjsi.primary_item_id,

518: and rtg.organization_id(+) = wjsi.organization_id
519: and nvl(rtg.alternate_routing_designator(+), 'NONEXISTENT') =
520: nvl(wjsi.alternate_routing_designator, 'NONEXISTENT')
521: and rtg.assembly_item_id(+) = decode(wjsi.load_type,
522: wip_constants.create_job, wjsi.primary_item_id,
523: wjsi.routing_reference_id)
524: and bom.assembly_item_id(+) = decode(wjsi.load_type,
525: wip_constants.create_job, wjsi.primary_item_id,
526: wjsi.bom_reference_id)

Line 525: wip_constants.create_job, wjsi.primary_item_id,

521: and rtg.assembly_item_id(+) = decode(wjsi.load_type,
522: wip_constants.create_job, wjsi.primary_item_id,
523: wjsi.routing_reference_id)
524: and bom.assembly_item_id(+) = decode(wjsi.load_type,
525: wip_constants.create_job, wjsi.primary_item_id,
526: wjsi.bom_reference_id)
527: and bom.organization_id(+) = wjsi.organization_id
528: and nvl(bom.alternate_bom_designator(+), 'NON_EXISTENT') =
529: nvl(wjsi.alternate_bom_designator, 'NON_EXISTENT')

Line 647: NVL(ROUND(WJ.START_QUANTITY, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

643: SYSDATE,
644: SYSDATE,
645: NVL(WJ.FIRM_PLANNED_FLAG,WDJ.FIRM_PLANNED_FLAG),
646: NVL(WJ.LOT_NUMBER,WDJ.LOT_NUMBER),
647: NVL(ROUND(WJ.START_QUANTITY, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
648: WDJ.START_QUANTITY),
649: NVL(ROUND(WJ.NET_QUANTITY, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
650: WDJ.NET_QUANTITY),
651: NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),

Line 649: NVL(ROUND(WJ.NET_QUANTITY, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

645: NVL(WJ.FIRM_PLANNED_FLAG,WDJ.FIRM_PLANNED_FLAG),
646: NVL(WJ.LOT_NUMBER,WDJ.LOT_NUMBER),
647: NVL(ROUND(WJ.START_QUANTITY, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
648: WDJ.START_QUANTITY),
649: NVL(ROUND(WJ.NET_QUANTITY, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
650: WDJ.NET_QUANTITY),
651: NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),
652: DECODE(WJ.STATUS_TYPE,
653: WIP_CONSTANTS.RELEASED,NVL(WDJ.DATE_RELEASED, NVL(WJ.DATE_RELEASED,SYSDATE)),

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

649: NVL(ROUND(WJ.NET_QUANTITY, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
650: WDJ.NET_QUANTITY),
651: NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),
652: DECODE(WJ.STATUS_TYPE,
653: WIP_CONSTANTS.RELEASED,NVL(WDJ.DATE_RELEASED, NVL(WJ.DATE_RELEASED,SYSDATE)),
654: WIP_CONSTANTS.HOLD,NVL(WDJ.DATE_RELEASED,NVL(WJ.DATE_RELEASED,SYSDATE)),
655: WIP_CONSTANTS.UNRELEASED, NULL, /*bug 3061143*/
656: WDJ.DATE_RELEASED),
657: DECODE(WJ.STATUS_TYPE,

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

650: WDJ.NET_QUANTITY),
651: NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),
652: DECODE(WJ.STATUS_TYPE,
653: WIP_CONSTANTS.RELEASED,NVL(WDJ.DATE_RELEASED, NVL(WJ.DATE_RELEASED,SYSDATE)),
654: WIP_CONSTANTS.HOLD,NVL(WDJ.DATE_RELEASED,NVL(WJ.DATE_RELEASED,SYSDATE)),
655: WIP_CONSTANTS.UNRELEASED, NULL, /*bug 3061143*/
656: WDJ.DATE_RELEASED),
657: DECODE(WJ.STATUS_TYPE,
658: WIP_CONSTANTS.COMP_CHRG , NVL(WDJ.DATE_COMPLETED, SYSDATE),

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

651: NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),
652: DECODE(WJ.STATUS_TYPE,
653: WIP_CONSTANTS.RELEASED,NVL(WDJ.DATE_RELEASED, NVL(WJ.DATE_RELEASED,SYSDATE)),
654: WIP_CONSTANTS.HOLD,NVL(WDJ.DATE_RELEASED,NVL(WJ.DATE_RELEASED,SYSDATE)),
655: WIP_CONSTANTS.UNRELEASED, NULL, /*bug 3061143*/
656: WDJ.DATE_RELEASED),
657: DECODE(WJ.STATUS_TYPE,
658: WIP_CONSTANTS.COMP_CHRG , NVL(WDJ.DATE_COMPLETED, SYSDATE),
659: WIP_CONSTANTS.RELEASED,NULL,

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

654: WIP_CONSTANTS.HOLD,NVL(WDJ.DATE_RELEASED,NVL(WJ.DATE_RELEASED,SYSDATE)),
655: WIP_CONSTANTS.UNRELEASED, NULL, /*bug 3061143*/
656: WDJ.DATE_RELEASED),
657: DECODE(WJ.STATUS_TYPE,
658: WIP_CONSTANTS.COMP_CHRG , NVL(WDJ.DATE_COMPLETED, SYSDATE),
659: WIP_CONSTANTS.RELEASED,NULL,
660: WIP_CONSTANTS.HOLD, NULL,
661: WIP_CONSTANTS.UNRELEASED, NULL,
662: WIP_CONSTANTS.CANCELLED, NULL,

Line 659: WIP_CONSTANTS.RELEASED,NULL,

655: WIP_CONSTANTS.UNRELEASED, NULL, /*bug 3061143*/
656: WDJ.DATE_RELEASED),
657: DECODE(WJ.STATUS_TYPE,
658: WIP_CONSTANTS.COMP_CHRG , NVL(WDJ.DATE_COMPLETED, SYSDATE),
659: WIP_CONSTANTS.RELEASED,NULL,
660: WIP_CONSTANTS.HOLD, NULL,
661: WIP_CONSTANTS.UNRELEASED, NULL,
662: WIP_CONSTANTS.CANCELLED, NULL,
663: WDJ.DATE_COMPLETED), /*Bug Number 4760788: Update date_completed*/

Line 660: WIP_CONSTANTS.HOLD, NULL,

656: WDJ.DATE_RELEASED),
657: DECODE(WJ.STATUS_TYPE,
658: WIP_CONSTANTS.COMP_CHRG , NVL(WDJ.DATE_COMPLETED, SYSDATE),
659: WIP_CONSTANTS.RELEASED,NULL,
660: WIP_CONSTANTS.HOLD, NULL,
661: WIP_CONSTANTS.UNRELEASED, NULL,
662: WIP_CONSTANTS.CANCELLED, NULL,
663: WDJ.DATE_COMPLETED), /*Bug Number 4760788: Update date_completed*/
664: /* Fix bug 5238435. WJSI dates are replacing the scheduler calculated dates of WDJ */

Line 661: WIP_CONSTANTS.UNRELEASED, NULL,

657: DECODE(WJ.STATUS_TYPE,
658: WIP_CONSTANTS.COMP_CHRG , NVL(WDJ.DATE_COMPLETED, SYSDATE),
659: WIP_CONSTANTS.RELEASED,NULL,
660: WIP_CONSTANTS.HOLD, NULL,
661: WIP_CONSTANTS.UNRELEASED, NULL,
662: WIP_CONSTANTS.CANCELLED, NULL,
663: WDJ.DATE_COMPLETED), /*Bug Number 4760788: Update date_completed*/
664: /* Fix bug 5238435. WJSI dates are replacing the scheduler calculated dates of WDJ */
665: DECODE(WJ.SCHEDULING_METHOD,

Line 662: WIP_CONSTANTS.CANCELLED, NULL,

658: WIP_CONSTANTS.COMP_CHRG , NVL(WDJ.DATE_COMPLETED, SYSDATE),
659: WIP_CONSTANTS.RELEASED,NULL,
660: WIP_CONSTANTS.HOLD, NULL,
661: WIP_CONSTANTS.UNRELEASED, NULL,
662: WIP_CONSTANTS.CANCELLED, NULL,
663: WDJ.DATE_COMPLETED), /*Bug Number 4760788: Update date_completed*/
664: /* Fix bug 5238435. WJSI dates are replacing the scheduler calculated dates of WDJ */
665: DECODE(WJ.SCHEDULING_METHOD,
666: WIP_CONSTANTS.ROUTING, WDJ.SCHEDULED_START_DATE,

Line 666: WIP_CONSTANTS.ROUTING, WDJ.SCHEDULED_START_DATE,

662: WIP_CONSTANTS.CANCELLED, NULL,
663: WDJ.DATE_COMPLETED), /*Bug Number 4760788: Update date_completed*/
664: /* Fix bug 5238435. WJSI dates are replacing the scheduler calculated dates of WDJ */
665: DECODE(WJ.SCHEDULING_METHOD,
666: WIP_CONSTANTS.ROUTING, WDJ.SCHEDULED_START_DATE,
667: NVL(WJ.FIRST_UNIT_START_DATE,WDJ.SCHEDULED_START_DATE)),
668: DECODE(WJ.SCHEDULING_METHOD,
669: WIP_CONSTANTS.ROUTING, WDJ.SCHEDULED_COMPLETION_DATE,
670: NVL(WJ.LAST_UNIT_COMPLETION_DATE, WDJ.SCHEDULED_COMPLETION_DATE)),

Line 669: WIP_CONSTANTS.ROUTING, WDJ.SCHEDULED_COMPLETION_DATE,

665: DECODE(WJ.SCHEDULING_METHOD,
666: WIP_CONSTANTS.ROUTING, WDJ.SCHEDULED_START_DATE,
667: NVL(WJ.FIRST_UNIT_START_DATE,WDJ.SCHEDULED_START_DATE)),
668: DECODE(WJ.SCHEDULING_METHOD,
669: WIP_CONSTANTS.ROUTING, WDJ.SCHEDULED_COMPLETION_DATE,
670: NVL(WJ.LAST_UNIT_COMPLETION_DATE, WDJ.SCHEDULED_COMPLETION_DATE)),
671: NVL(WJ.SCHEDULE_GROUP_ID,WDJ.SCHEDULE_GROUP_ID),
672: NVL(WJ.BUILD_SEQUENCE,WDJ.BUILD_SEQUENCE),
673: NVL(WJ.LINE_ID,WDJ.LINE_ID),

Line 738: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,

734: NVL(WJ.ATTRIBUTE15,WDJ.ATTRIBUTE15),
735: --Bug 5230849:Start of changes
736: --Routing and bom details should be updated only when the job is in unreleased status
737: --TO achieve this,decode on status type is added.
738: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
739: NVL(TO_DATE(TO_CHAR(wj.routing_revision_date, WIP_CONSTANTS.DT_NOSEC_FMT),
740: WIP_CONSTANTS.DT_NOSEC_FMT), WDJ.ROUTING_REVISION_DATE),
741: WDJ.ROUTING_REVISION_DATE),
742: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,

Line 739: NVL(TO_DATE(TO_CHAR(wj.routing_revision_date, WIP_CONSTANTS.DT_NOSEC_FMT),

735: --Bug 5230849:Start of changes
736: --Routing and bom details should be updated only when the job is in unreleased status
737: --TO achieve this,decode on status type is added.
738: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
739: NVL(TO_DATE(TO_CHAR(wj.routing_revision_date, WIP_CONSTANTS.DT_NOSEC_FMT),
740: WIP_CONSTANTS.DT_NOSEC_FMT), WDJ.ROUTING_REVISION_DATE),
741: WDJ.ROUTING_REVISION_DATE),
742: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
743: NVL(WJ.ROUTING_REVISION,WDJ.ROUTING_REVISION),WDJ.ROUTING_REVISION),

Line 740: WIP_CONSTANTS.DT_NOSEC_FMT), WDJ.ROUTING_REVISION_DATE),

736: --Routing and bom details should be updated only when the job is in unreleased status
737: --TO achieve this,decode on status type is added.
738: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
739: NVL(TO_DATE(TO_CHAR(wj.routing_revision_date, WIP_CONSTANTS.DT_NOSEC_FMT),
740: WIP_CONSTANTS.DT_NOSEC_FMT), WDJ.ROUTING_REVISION_DATE),
741: WDJ.ROUTING_REVISION_DATE),
742: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
743: NVL(WJ.ROUTING_REVISION,WDJ.ROUTING_REVISION),WDJ.ROUTING_REVISION),
744: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,

Line 742: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,

738: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
739: NVL(TO_DATE(TO_CHAR(wj.routing_revision_date, WIP_CONSTANTS.DT_NOSEC_FMT),
740: WIP_CONSTANTS.DT_NOSEC_FMT), WDJ.ROUTING_REVISION_DATE),
741: WDJ.ROUTING_REVISION_DATE),
742: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
743: NVL(WJ.ROUTING_REVISION,WDJ.ROUTING_REVISION),WDJ.ROUTING_REVISION),
744: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
745: NVL(TO_DATE(TO_CHAR(wj.bom_revision_date, WIP_CONSTANTS.DT_NOSEC_FMT),
746: WIP_CONSTANTS.DT_NOSEC_FMT),WDJ.BOM_REVISION_DATE),

Line 744: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,

740: WIP_CONSTANTS.DT_NOSEC_FMT), WDJ.ROUTING_REVISION_DATE),
741: WDJ.ROUTING_REVISION_DATE),
742: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
743: NVL(WJ.ROUTING_REVISION,WDJ.ROUTING_REVISION),WDJ.ROUTING_REVISION),
744: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
745: NVL(TO_DATE(TO_CHAR(wj.bom_revision_date, WIP_CONSTANTS.DT_NOSEC_FMT),
746: WIP_CONSTANTS.DT_NOSEC_FMT),WDJ.BOM_REVISION_DATE),
747: WDJ.BOM_REVISION_DATE),
748: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,

Line 745: NVL(TO_DATE(TO_CHAR(wj.bom_revision_date, WIP_CONSTANTS.DT_NOSEC_FMT),

741: WDJ.ROUTING_REVISION_DATE),
742: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
743: NVL(WJ.ROUTING_REVISION,WDJ.ROUTING_REVISION),WDJ.ROUTING_REVISION),
744: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
745: NVL(TO_DATE(TO_CHAR(wj.bom_revision_date, WIP_CONSTANTS.DT_NOSEC_FMT),
746: WIP_CONSTANTS.DT_NOSEC_FMT),WDJ.BOM_REVISION_DATE),
747: WDJ.BOM_REVISION_DATE),
748: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
749: NVL(WJ.BOM_REVISION,WDJ.BOM_REVISION),WDJ.BOM_REVISION),

Line 746: WIP_CONSTANTS.DT_NOSEC_FMT),WDJ.BOM_REVISION_DATE),

742: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
743: NVL(WJ.ROUTING_REVISION,WDJ.ROUTING_REVISION),WDJ.ROUTING_REVISION),
744: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
745: NVL(TO_DATE(TO_CHAR(wj.bom_revision_date, WIP_CONSTANTS.DT_NOSEC_FMT),
746: WIP_CONSTANTS.DT_NOSEC_FMT),WDJ.BOM_REVISION_DATE),
747: WDJ.BOM_REVISION_DATE),
748: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
749: NVL(WJ.BOM_REVISION,WDJ.BOM_REVISION),WDJ.BOM_REVISION),
750: NVL(WJ.SERIALIZATION_START_OP, WDJ.SERIALIZATION_START_OP),

Line 748: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,

744: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
745: NVL(TO_DATE(TO_CHAR(wj.bom_revision_date, WIP_CONSTANTS.DT_NOSEC_FMT),
746: WIP_CONSTANTS.DT_NOSEC_FMT),WDJ.BOM_REVISION_DATE),
747: WDJ.BOM_REVISION_DATE),
748: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
749: NVL(WJ.BOM_REVISION,WDJ.BOM_REVISION),WDJ.BOM_REVISION),
750: NVL(WJ.SERIALIZATION_START_OP, WDJ.SERIALIZATION_START_OP),
751: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.BOM_REFERENCE_ID, WDJ.BOM_REFERENCE_ID), null),
752: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.ROUTING_REFERENCE_ID, WDJ.ROUTING_REFERENCE_ID), null),

Line 751: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.BOM_REFERENCE_ID, WDJ.BOM_REFERENCE_ID), null),

747: WDJ.BOM_REVISION_DATE),
748: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
749: NVL(WJ.BOM_REVISION,WDJ.BOM_REVISION),WDJ.BOM_REVISION),
750: NVL(WJ.SERIALIZATION_START_OP, WDJ.SERIALIZATION_START_OP),
751: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.BOM_REFERENCE_ID, WDJ.BOM_REFERENCE_ID), null),
752: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.ROUTING_REFERENCE_ID, WDJ.ROUTING_REFERENCE_ID), null),
753: /* Modified for bug 5479283. Now bom/routing reference fields will be maintained with old value when null is passed. */
754: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,
755: DECODE(nvl(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,

Line 752: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.ROUTING_REFERENCE_ID, WDJ.ROUTING_REFERENCE_ID), null),

748: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
749: NVL(WJ.BOM_REVISION,WDJ.BOM_REVISION),WDJ.BOM_REVISION),
750: NVL(WJ.SERIALIZATION_START_OP, WDJ.SERIALIZATION_START_OP),
751: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.BOM_REFERENCE_ID, WDJ.BOM_REFERENCE_ID), null),
752: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.ROUTING_REFERENCE_ID, WDJ.ROUTING_REFERENCE_ID), null),
753: /* Modified for bug 5479283. Now bom/routing reference fields will be maintained with old value when null is passed. */
754: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,
755: DECODE(nvl(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
756: WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),

Line 754: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,

750: NVL(WJ.SERIALIZATION_START_OP, WDJ.SERIALIZATION_START_OP),
751: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.BOM_REFERENCE_ID, WDJ.BOM_REFERENCE_ID), null),
752: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.ROUTING_REFERENCE_ID, WDJ.ROUTING_REFERENCE_ID), null),
753: /* Modified for bug 5479283. Now bom/routing reference fields will be maintained with old value when null is passed. */
754: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,
755: DECODE(nvl(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
756: WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
757: null),
758: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,

Line 755: DECODE(nvl(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,

751: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.BOM_REFERENCE_ID, WDJ.BOM_REFERENCE_ID), null),
752: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.ROUTING_REFERENCE_ID, WDJ.ROUTING_REFERENCE_ID), null),
753: /* Modified for bug 5479283. Now bom/routing reference fields will be maintained with old value when null is passed. */
754: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,
755: DECODE(nvl(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
756: WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
757: null),
758: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,
759: DECODE(nvl(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,

Line 758: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,

754: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,
755: DECODE(nvl(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
756: WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
757: null),
758: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,
759: DECODE(nvl(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
760: WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),
761: null),
762: --Bug 5230849:End of changes for checking job status.

Line 759: DECODE(nvl(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,

755: DECODE(nvl(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
756: WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
757: null),
758: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,
759: DECODE(nvl(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
760: WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),
761: null),
762: --Bug 5230849:End of changes for checking job status.
763: --Bug 5230849:Start of changes:

Line 767: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_BOM_DESIGNATOR, WDJ.ALTERNATE_BOM_DESIGNATOR), null),

763: --Bug 5230849:Start of changes:
764: --Bom/Routing designator should be updatable for non-standard jobs also.
765: --If bom/rou designator is g_miss_char,existing value should be retained.
766: --No check on status type is needed becaue this is already considered during validation phase.
767: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_BOM_DESIGNATOR, WDJ.ALTERNATE_BOM_DESIGNATOR), null),
768: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_ROUTING_DESIGNATOR, WDJ.ALTERNATE_ROUTING_DESIGNATOR), null)
769: /*DECODE(WDJ.JOB_TYPE, wip_constants.standard,
770: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR),
771: DECODE(

Line 768: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_ROUTING_DESIGNATOR, WDJ.ALTERNATE_ROUTING_DESIGNATOR), null)

764: --Bom/Routing designator should be updatable for non-standard jobs also.
765: --If bom/rou designator is g_miss_char,existing value should be retained.
766: --No check on status type is needed becaue this is already considered during validation phase.
767: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_BOM_DESIGNATOR, WDJ.ALTERNATE_BOM_DESIGNATOR), null),
768: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_ROUTING_DESIGNATOR, WDJ.ALTERNATE_ROUTING_DESIGNATOR), null)
769: /*DECODE(WDJ.JOB_TYPE, wip_constants.standard,
770: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR),
771: DECODE(
772: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),

Line 769: /*DECODE(WDJ.JOB_TYPE, wip_constants.standard,

765: --If bom/rou designator is g_miss_char,existing value should be retained.
766: --No check on status type is needed becaue this is already considered during validation phase.
767: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_BOM_DESIGNATOR, WDJ.ALTERNATE_BOM_DESIGNATOR), null),
768: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_ROUTING_DESIGNATOR, WDJ.ALTERNATE_ROUTING_DESIGNATOR), null)
769: /*DECODE(WDJ.JOB_TYPE, wip_constants.standard,
770: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR),
771: DECODE(
772: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
773: NULL,NULL,

Line 772: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),

768: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_ROUTING_DESIGNATOR, WDJ.ALTERNATE_ROUTING_DESIGNATOR), null)
769: /*DECODE(WDJ.JOB_TYPE, wip_constants.standard,
770: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR),
771: DECODE(
772: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
773: NULL,NULL,
774: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR))),
775: DECODE(WDJ.JOB_TYPE, wip_constants.standard,
776: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR),

Line 775: DECODE(WDJ.JOB_TYPE, wip_constants.standard,

771: DECODE(
772: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
773: NULL,NULL,
774: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR))),
775: DECODE(WDJ.JOB_TYPE, wip_constants.standard,
776: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR),
777: DECODE(
778: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),
779: NULL,NULL,

Line 778: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),

774: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR))),
775: DECODE(WDJ.JOB_TYPE, wip_constants.standard,
776: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR),
777: DECODE(
778: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),
779: NULL,NULL,
780: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR))),
781: Modified update on ALTERNATE_BOM_DESIGNATOR,ALTERNATE_ROUTING_DESIGNATOR for bug 5479283.
782: This maintains old value when null is passed */

Line 783: DECODE(WDJ.JOB_TYPE, wip_constants.standard,WJ.ALTERNATE_BOM_DESIGNATOR,

779: NULL,NULL,
780: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR))),
781: Modified update on ALTERNATE_BOM_DESIGNATOR,ALTERNATE_ROUTING_DESIGNATOR for bug 5479283.
782: This maintains old value when null is passed */
783: DECODE(WDJ.JOB_TYPE, wip_constants.standard,WJ.ALTERNATE_BOM_DESIGNATOR,
784: DECODE(DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
785: NULL,NULL,WJ.ALTERNATE_BOM_DESIGNATOR)),
786: DECODE(WDJ.JOB_TYPE, wip_constants.standard,WJ.ALTERNATE_ROUTING_DESIGNATOR,
787: DECODE(DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),

Line 784: DECODE(DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),

780: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR))),
781: Modified update on ALTERNATE_BOM_DESIGNATOR,ALTERNATE_ROUTING_DESIGNATOR for bug 5479283.
782: This maintains old value when null is passed */
783: DECODE(WDJ.JOB_TYPE, wip_constants.standard,WJ.ALTERNATE_BOM_DESIGNATOR,
784: DECODE(DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
785: NULL,NULL,WJ.ALTERNATE_BOM_DESIGNATOR)),
786: DECODE(WDJ.JOB_TYPE, wip_constants.standard,WJ.ALTERNATE_ROUTING_DESIGNATOR,
787: DECODE(DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),
788: NULL,NULL,WJ.ALTERNATE_ROUTING_DESIGNATOR)),

Line 786: DECODE(WDJ.JOB_TYPE, wip_constants.standard,WJ.ALTERNATE_ROUTING_DESIGNATOR,

782: This maintains old value when null is passed */
783: DECODE(WDJ.JOB_TYPE, wip_constants.standard,WJ.ALTERNATE_BOM_DESIGNATOR,
784: DECODE(DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
785: NULL,NULL,WJ.ALTERNATE_BOM_DESIGNATOR)),
786: DECODE(WDJ.JOB_TYPE, wip_constants.standard,WJ.ALTERNATE_ROUTING_DESIGNATOR,
787: DECODE(DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),
788: NULL,NULL,WJ.ALTERNATE_ROUTING_DESIGNATOR)),
789: nvl(wj.wip_supply_type,wdj.wip_supply_type), -- Fix for bug 5440109
790: nvl(wj.demand_class,wdj.demand_class) -- Fix for bug 5440109

Line 787: DECODE(DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),

783: DECODE(WDJ.JOB_TYPE, wip_constants.standard,WJ.ALTERNATE_BOM_DESIGNATOR,
784: DECODE(DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
785: NULL,NULL,WJ.ALTERNATE_BOM_DESIGNATOR)),
786: DECODE(WDJ.JOB_TYPE, wip_constants.standard,WJ.ALTERNATE_ROUTING_DESIGNATOR,
787: DECODE(DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),
788: NULL,NULL,WJ.ALTERNATE_ROUTING_DESIGNATOR)),
789: nvl(wj.wip_supply_type,wdj.wip_supply_type), -- Fix for bug 5440109
790: nvl(wj.demand_class,wdj.demand_class) -- Fix for bug 5440109
791: --Bug 5230849:End of changes for bom/alternate designator updation.