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 82: l_jobType := wip_constants.standard;

78: -- create job header record
79: createWIPEntity(p_rowid);
80:
81: if ( wjsi_row.load_type = wip_constants.create_job ) then
82: l_jobType := wip_constants.standard;
83: else
84: l_jobType := wip_constants.nonstandard;
85: end if;
86:

Line 84: l_jobType := wip_constants.nonstandard;

80:
81: if ( wjsi_row.load_type = wip_constants.create_job ) then
82: l_jobType := wip_constants.standard;
83: else
84: l_jobType := wip_constants.nonstandard;
85: end if;
86:
87: if ( nvl(wjsi_row.allow_explosion, 'Y') not in ('n', 'N') ) then
88: wip_bomRouting_pvt.createJob(p_orgID => wjsi_row.organization_id,

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

580: wjsi.primary_item_id,
581: decode(wjsi.load_type, wip_constants.create_job, null, wjsi.bom_reference_id),
582: decode(wjsi.load_type, wip_constants.create_job, null, wjsi.routing_reference_id),
583: wjsi.firm_planned_flag,
584: decode(wjsi.load_type, wip_constants.create_job, wip_constants.standard, wip_constants.nonstandard),
585: wjsi.wip_supply_type,
586: wjsi.class_code,
587: wac.material_account,
588: wac.material_overhead_account,

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

897: WDJ.BOM_REVISION_DATE),
898: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
899: NVL(WJ.BOM_REVISION,WDJ.BOM_REVISION),WDJ.BOM_REVISION),
900: NVL(WJ.SERIALIZATION_START_OP, WDJ.SERIALIZATION_START_OP),
901: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.BOM_REFERENCE_ID, WDJ.BOM_REFERENCE_ID), null),
902: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.ROUTING_REFERENCE_ID, WDJ.ROUTING_REFERENCE_ID), null),
903: /* Modified for bug 5479283. Now bom/routing reference fields will be maintained with old value when null is passed. */
904: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,
905: DECODE(nvl(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,

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

898: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
899: NVL(WJ.BOM_REVISION,WDJ.BOM_REVISION),WDJ.BOM_REVISION),
900: NVL(WJ.SERIALIZATION_START_OP, WDJ.SERIALIZATION_START_OP),
901: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.BOM_REFERENCE_ID, WDJ.BOM_REFERENCE_ID), null),
902: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.ROUTING_REFERENCE_ID, WDJ.ROUTING_REFERENCE_ID), null),
903: /* Modified for bug 5479283. Now bom/routing reference fields will be maintained with old value when null is passed. */
904: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,
905: DECODE(nvl(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
906: WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),

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

900: NVL(WJ.SERIALIZATION_START_OP, WDJ.SERIALIZATION_START_OP),
901: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.BOM_REFERENCE_ID, WDJ.BOM_REFERENCE_ID), null),
902: --DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard, nvl(WJ.ROUTING_REFERENCE_ID, WDJ.ROUTING_REFERENCE_ID), null),
903: /* Modified for bug 5479283. Now bom/routing reference fields will be maintained with old value when null is passed. */
904: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,
905: DECODE(nvl(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
906: WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
907: null),
908: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,

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

904: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,
905: DECODE(nvl(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
906: WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
907: null),
908: DECODE(WDJ.JOB_TYPE, wip_constants.nonstandard,
909: DECODE(nvl(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,
910: WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),
911: null),
912: --Bug 5230849:End of changes for checking job status.

Line 914: --Bom/Routing designator should be updatable for non-standard jobs also.

910: WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),
911: null),
912: --Bug 5230849:End of changes for checking job status.
913: --Bug 5230849:Start of changes:
914: --Bom/Routing designator should be updatable for non-standard jobs also.
915: --If bom/rou designator is g_miss_char,existing value should be retained.
916: --No check on status type is needed becaue this is already considered during validation phase.
917: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_BOM_DESIGNATOR, WDJ.ALTERNATE_BOM_DESIGNATOR), null),
918: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_ROUTING_DESIGNATOR, WDJ.ALTERNATE_ROUTING_DESIGNATOR), null)

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

913: --Bug 5230849:Start of changes:
914: --Bom/Routing designator should be updatable for non-standard jobs also.
915: --If bom/rou designator is g_miss_char,existing value should be retained.
916: --No check on status type is needed becaue this is already considered during validation phase.
917: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_BOM_DESIGNATOR, WDJ.ALTERNATE_BOM_DESIGNATOR), null),
918: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_ROUTING_DESIGNATOR, WDJ.ALTERNATE_ROUTING_DESIGNATOR), null)
919: /*DECODE(WDJ.JOB_TYPE, wip_constants.standard,
920: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR),
921: DECODE(

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

914: --Bom/Routing designator should be updatable for non-standard jobs also.
915: --If bom/rou designator is g_miss_char,existing value should be retained.
916: --No check on status type is needed becaue this is already considered during validation phase.
917: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_BOM_DESIGNATOR, WDJ.ALTERNATE_BOM_DESIGNATOR), null),
918: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_ROUTING_DESIGNATOR, WDJ.ALTERNATE_ROUTING_DESIGNATOR), null)
919: /*DECODE(WDJ.JOB_TYPE, wip_constants.standard,
920: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR),
921: DECODE(
922: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),

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

915: --If bom/rou designator is g_miss_char,existing value should be retained.
916: --No check on status type is needed becaue this is already considered during validation phase.
917: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_BOM_DESIGNATOR, WDJ.ALTERNATE_BOM_DESIGNATOR), null),
918: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_ROUTING_DESIGNATOR, WDJ.ALTERNATE_ROUTING_DESIGNATOR), null)
919: /*DECODE(WDJ.JOB_TYPE, wip_constants.standard,
920: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR),
921: DECODE(
922: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
923: NULL,NULL,

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

921: DECODE(
922: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
923: NULL,NULL,
924: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR))),
925: DECODE(WDJ.JOB_TYPE, wip_constants.standard,
926: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR),
927: DECODE(
928: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),
929: NULL,NULL,

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

929: NULL,NULL,
930: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR))),
931: Modified update on ALTERNATE_BOM_DESIGNATOR,ALTERNATE_ROUTING_DESIGNATOR for bug 5479283.
932: This maintains old value when null is passed */
933: DECODE(WDJ.JOB_TYPE, wip_constants.standard,WJ.ALTERNATE_BOM_DESIGNATOR,
934: DECODE(DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
935: NULL,NULL,WJ.ALTERNATE_BOM_DESIGNATOR)),
936: DECODE(WDJ.JOB_TYPE, wip_constants.standard,WJ.ALTERNATE_ROUTING_DESIGNATOR,
937: DECODE(DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),

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

932: This maintains old value when null is passed */
933: DECODE(WDJ.JOB_TYPE, wip_constants.standard,WJ.ALTERNATE_BOM_DESIGNATOR,
934: DECODE(DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
935: NULL,NULL,WJ.ALTERNATE_BOM_DESIGNATOR)),
936: DECODE(WDJ.JOB_TYPE, wip_constants.standard,WJ.ALTERNATE_ROUTING_DESIGNATOR,
937: DECODE(DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),
938: NULL,NULL,WJ.ALTERNATE_ROUTING_DESIGNATOR)),
939: nvl(wj.wip_supply_type,wdj.wip_supply_type), -- Fix for bug 5440109
940: nvl(wj.demand_class,wdj.demand_class) -- Fix for bug 5440109