APPS.FLM_SUPPLY_DEMAND dependencies on WIP_CONSTANTS

Line 1644: l_basis_type NUMBER := WIP_CONSTANTS.ITEM_BASED_MTL;

1640: x_err_msg OUT NOCOPY VARCHAR
1641: ) IS
1642: l_ext_qty NUMBER := 0;
1643: l_qty NUMBER := 0;
1644: l_basis_type NUMBER := WIP_CONSTANTS.ITEM_BASED_MTL;
1645: l_top_bill_sequence_id NUMBER := 0;
1646: l_cnt NUMBER := 0;
1647: l_wip_supply_type NUMBER;
1648: l_sort_order VARCHAR2(2000);

Line 1689: select NVL(bic.wip_supply_type,WIP_CONSTANTS.PUSH), NVL(bic.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL),be.component_quantity

1685: EXIT WHEN find_comps%NOTFOUND;
1686: l_cnt := 0;
1687: l_ext_qty := 1;
1688: WHILE (length(l_sort_order) > l_sort_order_len) LOOP
1689: select NVL(bic.wip_supply_type,WIP_CONSTANTS.PUSH), NVL(bic.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL),be.component_quantity
1690: into l_wip_supply_type,l_basis_type,l_qty
1691: from bom_explosions be, bom_inventory_components bic
1692: where be.top_bill_sequence_id = l_top_bill_sequence_id
1693: and be.explosion_type = 'ALL'

Line 1697: if ((l_cnt <> 0) and (l_wip_supply_type <> WIP_CONSTANTS.PHANTOM)) then

1693: and be.explosion_type = 'ALL'
1694: and be.sort_order = l_sort_order
1695: and be.component_sequence_id = bic.component_sequence_id;
1696: l_ext_qty := l_ext_qty * l_qty;
1697: if ((l_cnt <> 0) and (l_wip_supply_type <> WIP_CONSTANTS.PHANTOM)) then
1698: l_ext_qty := 0;
1699: exit;
1700: end if;
1701: if (l_basis_type = WIP_CONSTANTS.LOT_BASED_MTL) then

Line 1701: if (l_basis_type = WIP_CONSTANTS.LOT_BASED_MTL) then

1697: if ((l_cnt <> 0) and (l_wip_supply_type <> WIP_CONSTANTS.PHANTOM)) then
1698: l_ext_qty := 0;
1699: exit;
1700: end if;
1701: if (l_basis_type = WIP_CONSTANTS.LOT_BASED_MTL) then
1702: exit;
1703: end if;
1704: l_cnt := l_cnt+1;
1705:

Line 1709: if (l_basis_type = WIP_CONSTANTS.ITEM_BASED_MTL) then

1705:
1706: /* Get the parent sort_order */
1707: l_sort_order := SUBSTR(l_sort_order,0,length(l_sort_order)-l_sort_order_len);
1708: END LOOP;
1709: if (l_basis_type = WIP_CONSTANTS.ITEM_BASED_MTL) then
1710: l_ext_qty := l_ext_qty * nvl(p_assembly_qty,1);
1711: end if;
1712: l_total_qty := l_total_qty + l_ext_qty;
1713: END LOOP;