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.FLM_SUPPLY_DEMAND dependencies on FLM_SUPPLY_DEMAND

Line 1: PACKAGE BODY FLM_SUPPLY_DEMAND AS

1: PACKAGE BODY FLM_SUPPLY_DEMAND AS
2: /* $Header: FLMMTSDB.pls 120.3 2006/02/20 18:14:30 yulin noship $ */
3:
4:
5: -- Used SUPPLY DEMAND SOURCE TYPE (from the existing ones in mfg_lookups:)

Line 1749: l_sd_reservation_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;

1745: l_sys_seq_num NUMBER;
1746: l_inf_fence_ind NUMBER;
1747: l_sd_size NUMBER;
1748: l_rows_fetched NUMBER;
1749: l_sd_reservation_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1750: l_sd_src_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1751: l_sd_txn_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1752: l_sd_src_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1753: l_sd_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;

Line 1750: l_sd_src_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;

1746: l_inf_fence_ind NUMBER;
1747: l_sd_size NUMBER;
1748: l_rows_fetched NUMBER;
1749: l_sd_reservation_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1750: l_sd_src_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1751: l_sd_txn_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1752: l_sd_src_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1753: l_sd_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1754: l_sd_qty FLM_SUPPLY_DEMAND.Number_Tbl_Type;

Line 1751: l_sd_txn_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;

1747: l_sd_size NUMBER;
1748: l_rows_fetched NUMBER;
1749: l_sd_reservation_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1750: l_sd_src_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1751: l_sd_txn_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1752: l_sd_src_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1753: l_sd_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1754: l_sd_qty FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1755: l_sd_requirement_date FLM_SUPPLY_DEMAND.Number_Tbl_Type;

Line 1752: l_sd_src_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;

1748: l_rows_fetched NUMBER;
1749: l_sd_reservation_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1750: l_sd_src_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1751: l_sd_txn_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1752: l_sd_src_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1753: l_sd_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1754: l_sd_qty FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1755: l_sd_requirement_date FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1756: l_sd_inventory_item_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;

Line 1753: l_sd_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;

1749: l_sd_reservation_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1750: l_sd_src_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1751: l_sd_txn_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1752: l_sd_src_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1753: l_sd_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1754: l_sd_qty FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1755: l_sd_requirement_date FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1756: l_sd_inventory_item_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1757: l_sd_org_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;

Line 1754: l_sd_qty FLM_SUPPLY_DEMAND.Number_Tbl_Type;

1750: l_sd_src_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1751: l_sd_txn_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1752: l_sd_src_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1753: l_sd_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1754: l_sd_qty FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1755: l_sd_requirement_date FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1756: l_sd_inventory_item_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1757: l_sd_org_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1758: l_debug_line NUMBER;

Line 1755: l_sd_requirement_date FLM_SUPPLY_DEMAND.Number_Tbl_Type;

1751: l_sd_txn_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1752: l_sd_src_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1753: l_sd_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1754: l_sd_qty FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1755: l_sd_requirement_date FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1756: l_sd_inventory_item_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1757: l_sd_org_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1758: l_debug_line NUMBER;
1759: l_from_date_j NUMBER;

Line 1756: l_sd_inventory_item_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;

1752: l_sd_src_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1753: l_sd_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1754: l_sd_qty FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1755: l_sd_requirement_date FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1756: l_sd_inventory_item_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1757: l_sd_org_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1758: l_debug_line NUMBER;
1759: l_from_date_j NUMBER;
1760:

Line 1757: l_sd_org_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;

1753: l_sd_type FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1754: l_sd_qty FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1755: l_sd_requirement_date FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1756: l_sd_inventory_item_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1757: l_sd_org_id FLM_SUPPLY_DEMAND.Number_Tbl_Type;
1758: l_debug_line NUMBER;
1759: l_from_date_j NUMBER;
1760:
1761: l_cur_index NUMBER;

Line 1896: l_sd_size := FLM_SUPPLY_DEMAND.Collect_Supply_Demand_Info(p_group_id => l_group_id,

1892: 1,
1893: -1);
1894: END LOOP;
1895: l_debug_line := 50;
1896: l_sd_size := FLM_SUPPLY_DEMAND.Collect_Supply_Demand_Info(p_group_id => l_group_id,
1897: p_sys_seq_num => l_sys_seq_num,
1898: p_mrp_status => 1);
1899: l_debug_line := 60;
1900: FLM_SUPPLY_DEMAND.Get_Supply_Demand_Info(p_starting_index => 1,

Line 1900: FLM_SUPPLY_DEMAND.Get_Supply_Demand_Info(p_starting_index => 1,

1896: l_sd_size := FLM_SUPPLY_DEMAND.Collect_Supply_Demand_Info(p_group_id => l_group_id,
1897: p_sys_seq_num => l_sys_seq_num,
1898: p_mrp_status => 1);
1899: l_debug_line := 60;
1900: FLM_SUPPLY_DEMAND.Get_Supply_Demand_Info(p_starting_index => 1,
1901: p_ending_index => l_sd_size,
1902: x_rows_fetched => l_rows_fetched,
1903: x_reservation_type_tbl => l_sd_reservation_type,
1904: x_supply_demand_src_type_tbl => l_sd_src_type,

Line 1999: END FLM_SUPPLY_DEMAND;

1995: END read_comp_avail;
1996:
1997:
1998:
1999: END FLM_SUPPLY_DEMAND;