APPS.FLM_EXECUTION_UTIL dependencies on WIP_CONSTANTS

Line 1472: nvl(fero.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL) basis_type,

1468: fero.quantity_per_assembly,
1469: fero.supply_subinventory,
1470: fero.supply_locator_id,
1471: fero.component_sequence_id,
1472: nvl(fero.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL) basis_type,
1473: msi.primary_uom_code,
1474: flm_util.get_key_flex_item(fero.inventory_item_id,fero.organization_id) inventory_item_name,
1475: msi.serial_number_control_code,
1476: msi.lot_control_code,

Line 1501: l_insertPhantom number := WIP_CONSTANTS.NO;

1497: l_comp_ev_seq_num NUMBER;
1498: l_rec_event_seq_num_tbl operation_seq_tbl_type;
1499: l_revision VARCHAR2(3);
1500: l_qty NUMBER;
1501: l_insertPhantom number := WIP_CONSTANTS.NO;
1502: l_msiSubinv varchar2(10);
1503: l_msiLocatorID number;
1504: l_wpSubinv varchar2(10);
1505: l_wpLocatorID number;

Line 1544: if(nvl(l_compTbl(v_idx).wip_supply_type, 1) = WIP_CONSTANTS.PHANTOM) then

1540: --remove the phantom comps if bom param for use_phantom_routing is not set to yes
1541: l_insertPhantom := wip_globals.use_phantom_routings(p_orgID);
1542: v_idx := l_compTbl.FIRST;
1543: WHILE v_idx IS NOT NULL LOOP
1544: if(nvl(l_compTbl(v_idx).wip_supply_type, 1) = WIP_CONSTANTS.PHANTOM) then
1545: if(l_insertPhantom <> WIP_CONSTANTS.YES) then
1546: l_compTbl.delete(v_idx);
1547: elsif(l_insertPhantom = WIP_CONSTANTS.YES) then
1548: if(l_compTbl(v_idx).operation_seq_num > 0) then

Line 1545: if(l_insertPhantom <> WIP_CONSTANTS.YES) then

1541: l_insertPhantom := wip_globals.use_phantom_routings(p_orgID);
1542: v_idx := l_compTbl.FIRST;
1543: WHILE v_idx IS NOT NULL LOOP
1544: if(nvl(l_compTbl(v_idx).wip_supply_type, 1) = WIP_CONSTANTS.PHANTOM) then
1545: if(l_insertPhantom <> WIP_CONSTANTS.YES) then
1546: l_compTbl.delete(v_idx);
1547: elsif(l_insertPhantom = WIP_CONSTANTS.YES) then
1548: if(l_compTbl(v_idx).operation_seq_num > 0) then
1549: l_compTbl(v_idx).operation_seq_num := -1*abs(l_compTbl(v_idx).operation_seq_num);

Line 1547: elsif(l_insertPhantom = WIP_CONSTANTS.YES) then

1543: WHILE v_idx IS NOT NULL LOOP
1544: if(nvl(l_compTbl(v_idx).wip_supply_type, 1) = WIP_CONSTANTS.PHANTOM) then
1545: if(l_insertPhantom <> WIP_CONSTANTS.YES) then
1546: l_compTbl.delete(v_idx);
1547: elsif(l_insertPhantom = WIP_CONSTANTS.YES) then
1548: if(l_compTbl(v_idx).operation_seq_num > 0) then
1549: l_compTbl(v_idx).operation_seq_num := -1*abs(l_compTbl(v_idx).operation_seq_num);
1550: end if;
1551: end if;

Line 1587: if(c_recorded_comps.revision_qty_control_code = wip_constants.revision_controlled) then

1583:
1584: for c_recorded_comps in recorded_comps(p_orgID, p_wip_ent_id) loop
1585: v_idx := v_idx +1;
1586: l_compTbl.extend;
1587: if(c_recorded_comps.revision_qty_control_code = wip_constants.revision_controlled) then
1588: bom_revisions.get_revision(examine_type => 'ALL',
1589: org_id => p_orgID,
1590: item_id => c_recorded_comps.inventory_item_id,
1591: rev_date => p_txnDate,

Line 1596: if(c_recorded_comps.basis_type = WIP_CONSTANTS.ITEM_BASED_MTL) then

1592: itm_rev => l_revision);
1593: else
1594: l_revision := null;
1595: end if;
1596: if(c_recorded_comps.basis_type = WIP_CONSTANTS.ITEM_BASED_MTL) then
1597: l_qty := nvl(c_recorded_comps.quantity_per_assembly * p_qty,0);
1598: else
1599: l_qty := nvl(c_recorded_comps.quantity_per_assembly,0);
1600: end if;

Line 1653: p_wipSupplyType => wip_constants.assy_pull,

1649: p_priQty => l_qty,
1650: p_priUomCode => c_recorded_comps.primary_uom_code,
1651: p_supplySubinv => c_recorded_comps.supply_subinventory,
1652: p_supplyLocID => c_recorded_comps.supply_locator_id,
1653: p_wipSupplyType => wip_constants.assy_pull,
1654: p_txnActionID => wip_constants.isscomp_action,
1655: p_mtlTxnsEnabledFlag => null,
1656: p_serialControlCode => c_recorded_comps.serial_number_control_code,
1657: p_lotControlCode => c_recorded_comps.lot_control_code,

Line 1654: p_txnActionID => wip_constants.isscomp_action,

1650: p_priUomCode => c_recorded_comps.primary_uom_code,
1651: p_supplySubinv => c_recorded_comps.supply_subinventory,
1652: p_supplyLocID => c_recorded_comps.supply_locator_id,
1653: p_wipSupplyType => wip_constants.assy_pull,
1654: p_txnActionID => wip_constants.isscomp_action,
1655: p_mtlTxnsEnabledFlag => null,
1656: p_serialControlCode => c_recorded_comps.serial_number_control_code,
1657: p_lotControlCode => c_recorded_comps.lot_control_code,
1658: p_revision => l_revision,