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

APPS.WIP_MASSLOAD_PVT dependencies on STANDARD

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 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 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 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 764: --Bom/Routing designator should be updatable for non-standard jobs also.

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

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