APPS.FLM_EXECUTION_UTIL dependencies on WIP_CONSTANTS

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

1248: fero.quantity_per_assembly,
1249: fero.supply_subinventory,
1250: fero.supply_locator_id,
1251: fero.component_sequence_id,
1252: nvl(fero.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL) basis_type,
1253: msi.primary_uom_code,
1254: flm_util.get_key_flex_item(fero.inventory_item_id,fero.organization_id) inventory_item_name,
1255: msi.serial_number_control_code,
1256: msi.lot_control_code,

Line 1281: l_insertPhantom number := WIP_CONSTANTS.NO;

1277: l_comp_ev_seq_num NUMBER;
1278: l_rec_event_seq_num_tbl operation_seq_tbl_type;
1279: l_revision VARCHAR2(3);
1280: l_qty NUMBER;
1281: l_insertPhantom number := WIP_CONSTANTS.NO;
1282: l_msiSubinv varchar2(10);
1283: l_msiLocatorID number;
1284: l_wpSubinv varchar2(10);
1285: l_wpLocatorID number;

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

1320: --remove the phantom comps if bom param for use_phantom_routing is not set to yes
1321: l_insertPhantom := wip_globals.use_phantom_routings(p_orgID);
1322: v_idx := l_compTbl.FIRST;
1323: WHILE v_idx IS NOT NULL LOOP
1324: if(nvl(l_compTbl(v_idx).wip_supply_type, 1) = WIP_CONSTANTS.PHANTOM) then
1325: if(l_insertPhantom <> WIP_CONSTANTS.YES) then
1326: l_compTbl.delete(v_idx);
1327: elsif(l_insertPhantom = WIP_CONSTANTS.YES) then
1328: if(l_compTbl(v_idx).operation_seq_num > 0) then

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

1321: l_insertPhantom := wip_globals.use_phantom_routings(p_orgID);
1322: v_idx := l_compTbl.FIRST;
1323: WHILE v_idx IS NOT NULL LOOP
1324: if(nvl(l_compTbl(v_idx).wip_supply_type, 1) = WIP_CONSTANTS.PHANTOM) then
1325: if(l_insertPhantom <> WIP_CONSTANTS.YES) then
1326: l_compTbl.delete(v_idx);
1327: elsif(l_insertPhantom = WIP_CONSTANTS.YES) then
1328: if(l_compTbl(v_idx).operation_seq_num > 0) then
1329: l_compTbl(v_idx).operation_seq_num := -1*abs(l_compTbl(v_idx).operation_seq_num);

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

1323: WHILE v_idx IS NOT NULL LOOP
1324: if(nvl(l_compTbl(v_idx).wip_supply_type, 1) = WIP_CONSTANTS.PHANTOM) then
1325: if(l_insertPhantom <> WIP_CONSTANTS.YES) then
1326: l_compTbl.delete(v_idx);
1327: elsif(l_insertPhantom = WIP_CONSTANTS.YES) then
1328: if(l_compTbl(v_idx).operation_seq_num > 0) then
1329: l_compTbl(v_idx).operation_seq_num := -1*abs(l_compTbl(v_idx).operation_seq_num);
1330: end if;
1331: end if;

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

1363:
1364: for c_recorded_comps in recorded_comps(p_orgID, p_wip_ent_id) loop
1365: v_idx := v_idx +1;
1366: l_compTbl.extend;
1367: if(c_recorded_comps.revision_qty_control_code = wip_constants.revision_controlled) then
1368: bom_revisions.get_revision(examine_type => 'ALL',
1369: org_id => p_orgID,
1370: item_id => c_recorded_comps.inventory_item_id,
1371: rev_date => p_txnDate,

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

1372: itm_rev => l_revision);
1373: else
1374: l_revision := null;
1375: end if;
1376: if(c_recorded_comps.basis_type = WIP_CONSTANTS.ITEM_BASED_MTL) then
1377: l_qty := nvl(c_recorded_comps.quantity_per_assembly * p_qty,0);
1378: else
1379: l_qty := nvl(c_recorded_comps.quantity_per_assembly,0);
1380: end if;

Line 1433: p_wipSupplyType => wip_constants.assy_pull,

1429: p_priQty => l_qty,
1430: p_priUomCode => c_recorded_comps.primary_uom_code,
1431: p_supplySubinv => c_recorded_comps.supply_subinventory,
1432: p_supplyLocID => c_recorded_comps.supply_locator_id,
1433: p_wipSupplyType => wip_constants.assy_pull,
1434: p_txnActionID => wip_constants.isscomp_action,
1435: p_mtlTxnsEnabledFlag => null,
1436: p_serialControlCode => c_recorded_comps.serial_number_control_code,
1437: p_lotControlCode => c_recorded_comps.lot_control_code,

Line 1434: p_txnActionID => wip_constants.isscomp_action,

1430: p_priUomCode => c_recorded_comps.primary_uom_code,
1431: p_supplySubinv => c_recorded_comps.supply_subinventory,
1432: p_supplyLocID => c_recorded_comps.supply_locator_id,
1433: p_wipSupplyType => wip_constants.assy_pull,
1434: p_txnActionID => wip_constants.isscomp_action,
1435: p_mtlTxnsEnabledFlag => null,
1436: p_serialControlCode => c_recorded_comps.serial_number_control_code,
1437: p_lotControlCode => c_recorded_comps.lot_control_code,
1438: p_revision => l_revision,