1 PACKAGE FLM_SUPPLY_DEMAND AS
2 /* $Header: FLMMTSDS.pls 120.1 2005/10/18 14:52:25 asuherma noship $ */
3
4 TYPE Supply_Demand_Record_Type IS RECORD
5 ( reservation_type NUMBER,
6 supply_demand_source_type NUMBER,
7 txn_source_type_id NUMBER,
8 supply_demand_source_id NUMBER,
9 supply_demand_type NUMBER,
10 supply_demand_quantity NUMBER,
11 supply_demand_date NUMBER,
12 inventory_item_id NUMBER,
13 organization_id NUMBER);
14
15
16 TYPE Supply_Demand_Tbl_Type IS TABLE OF Supply_Demand_Record_Type
17 INDEX BY BINARY_INTEGER;
18
19 TYPE Number_Tbl_Type IS TABLE OF NUMBER
20 INDEX BY BINARY_INTEGER;
21
22 TYPE comp_avail_record_type IS RECORD
23 (
24 inventory_item_id NUMBER,
25 requirement_date NUMBER,
26 qty NUMBER
27 );
28 TYPE comp_avail_tbl_type IS TABLE OF comp_avail_record_type INDEX BY BINARY_INTEGER;
29
30 g_supply_demand_table SUPPLY_DEMAND_TBL_TYPE;
31
32
33 FUNCTION Collect_Supply_Demand_Info(p_group_id IN NUMBER,
34 p_sys_seq_num IN NUMBER,
35 p_mrp_status IN NUMBER) RETURN NUMBER;
36
37
38 PROCEDURE Collect_Supply_Demand_Info(p_group_id IN NUMBER,
39 p_sys_seq_num IN NUMBER,
40 p_mrp_status IN NUMBER,
41 p_sup_dem_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
42 ERRBUF OUT NOCOPY VARCHAR2,
43 RETCODE OUT NOCOPY NUMBER);
44
45 PROCEDURE Get_Supply_Demand_Info(x_supply_demand_table OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE);
46
47
48 PROCEDURE Get_Supply_Demand_Info(p_starting_index IN NUMBER DEFAULT 1,
49 p_ending_index IN NUMBER DEFAULT -1,
50 x_rows_fetched OUT NOCOPY NUMBER,
51 x_reservation_type_tbl OUT NOCOPY Number_Tbl_Type,
52 x_supply_demand_src_type_tbl OUT NOCOPY Number_Tbl_Type,
53 x_txn_source_type_id_tbl OUT NOCOPY Number_Tbl_Type,
54 x_supply_demand_source_id_tbl OUT NOCOPY Number_Tbl_Type,
55 x_supply_demand_type_tbl OUT NOCOPY Number_Tbl_Type,
56 x_supply_demand_quantity_tbl OUT NOCOPY Number_Tbl_Type,
57 x_supply_demand_date_tbl OUT NOCOPY Number_Tbl_Type,
58 x_inventory_item_id_tbl OUT NOCOPY Number_Tbl_Type,
59 x_organization_id_tbl OUT NOCOPY Number_Tbl_Type);
60
61 PROCEDURE Clear_Supply_Demand_Info;
62
63
64 PROCEDURE Collect_Supply_Info(p_group_id IN NUMBER,
65 p_sys_seq_num IN NUMBER,
66 p_mrp_status IN NUMBER,
67 p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
68 ERRBUF OUT NOCOPY VARCHAR2,
69 RETCODE OUT NOCOPY NUMBER);
70
71 PROCEDURE Collect_Demand_Info(p_group_id IN NUMBER,
72 p_sys_seq_num IN NUMBER,
73 p_mrp_status IN NUMBER,
74 p_demand_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
75 ERRBUF OUT NOCOPY VARCHAR2,
76 RETCODE OUT NOCOPY NUMBER);
77
78 PROCEDURE Collect_OnHand_Supply(p_group_id IN NUMBER,
79 p_sys_seq_num IN NUMBER,
80 p_mrp_status IN NUMBER,
81 p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
82 ERRBUF OUT NOCOPY VARCHAR2,
83 RETCODE OUT NOCOPY NUMBER);
84
85 PROCEDURE Collect_User_Supply(p_group_id IN NUMBER,
86 p_sys_seq_num IN NUMBER,
87 p_mrp_status IN NUMBER,
88 p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
89 ERRBUF OUT NOCOPY VARCHAR2,
90 RETCODE OUT NOCOPY NUMBER);
91
92 PROCEDURE Collect_MTL_Supply(p_group_id IN NUMBER,
93 p_sys_seq_num IN NUMBER,
94 p_mrp_status IN NUMBER,
95 p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
96 ERRBUF OUT NOCOPY VARCHAR2,
97 RETCODE OUT NOCOPY NUMBER);
98
99 PROCEDURE Collect_DiscreteJob_Supply(p_group_id IN NUMBER,
100 p_sys_seq_num IN NUMBER,
101 p_mrp_status IN NUMBER,
102 p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
103 ERRBUF OUT NOCOPY VARCHAR2,
104 RETCODE OUT NOCOPY NUMBER);
105
106 PROCEDURE Collect_WipNegReq_Supply(p_group_id IN NUMBER,
107 p_sys_seq_num IN NUMBER,
108 p_mrp_status IN NUMBER,
109 p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
110 ERRBUF OUT NOCOPY VARCHAR2,
111 RETCODE OUT NOCOPY NUMBER);
112
113 PROCEDURE Collect_RepSched_Supply(p_group_id IN NUMBER,
114 p_sys_seq_num IN NUMBER,
115 p_mrp_status IN NUMBER,
116 p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
117 ERRBUF OUT NOCOPY VARCHAR2,
118 RETCODE OUT NOCOPY NUMBER);
119
120 PROCEDURE Collect_FlowSched_Supply(p_group_id IN NUMBER,
121 p_sys_seq_num IN NUMBER,
122 p_mrp_status IN NUMBER,
123 p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
124 ERRBUF OUT NOCOPY VARCHAR2,
125 RETCODE OUT NOCOPY NUMBER);
126
127 PROCEDURE Collect_DiscreteJob_Demand(p_group_id IN NUMBER,
128 p_sys_seq_num IN NUMBER,
129 p_mrp_status IN NUMBER,
130 p_demand_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
131 ERRBUF OUT NOCOPY VARCHAR2,
132 RETCODE OUT NOCOPY NUMBER);
133
134 PROCEDURE Collect_RepSched_Demand(p_group_id IN NUMBER,
135 p_sys_seq_num IN NUMBER,
136 p_mrp_status IN NUMBER,
137 p_demand_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
138 ERRBUF OUT NOCOPY VARCHAR2,
139 RETCODE OUT NOCOPY NUMBER);
140
141 PROCEDURE Collect_User_Demand(p_group_id IN NUMBER,
142 p_sys_seq_num IN NUMBER,
143 p_mrp_status IN NUMBER,
144 p_demand_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
145 ERRBUF OUT NOCOPY VARCHAR2,
146 RETCODE OUT NOCOPY NUMBER);
147
148 PROCEDURE Collect_FlowSched_Demand(p_group_id IN NUMBER,
149 p_sys_seq_num IN NUMBER,
150 p_mrp_status IN NUMBER,
151 p_demand_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
152 ERRBUF OUT NOCOPY VARCHAR2,
153 RETCODE OUT NOCOPY NUMBER);
154
155 PROCEDURE Collect_SalesOrder_Demand(p_group_id IN NUMBER,
156 p_sys_seq_num IN NUMBER,
157 p_mrp_status IN NUMBER,
158 p_demand_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
159 ERRBUF OUT NOCOPY VARCHAR2,
160 RETCODE OUT NOCOPY NUMBER);
161
162 PROCEDURE Get_Component_Qty(p_assembly_item_id IN NUMBER,
163 p_organization_id IN NUMBER,
164 p_alternate_bom_designator IN VARCHAR,
165 p_component_item_id IN NUMBER,
166 p_date IN DATE DEFAULT sysdate,
167 p_assembly_qty IN NUMBER DEFAULT 1,
168 x_qty OUT NOCOPY NUMBER,
169 x_err_code OUT NOCOPY NUMBER,
170 x_err_msg OUT NOCOPY VARCHAR
171 );
172
173 PROCEDURE Read_Comp_Avail(p_item_id_tbl IN Number_Tbl_Type,
174 p_org_id IN NUMBER,
175 p_from_date DATE,
176 p_to_date DATE,
177 p_ignore_line_id_tbl IN Number_Tbl_Type,
178 x_qty_tbl OUT NOCOPY Number_Tbl_Type,
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2);
182
183
184 END FLM_SUPPLY_DEMAND;