1 PACKAGE WPS_SUPPLY_DEMAND AUTHID CURRENT_USER AS
2 /* $Header: wpsmtsds.pls 120.2 2006/03/09 11:18:35 mlouie 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
23 g_supply_demand_table SUPPLY_DEMAND_TBL_TYPE;
24
25
26 FUNCTION Collect_Supply_Demand_Info(p_group_id IN NUMBER,
27 p_sys_seq_num IN NUMBER,
28 p_mrp_status IN NUMBER,
29 p_org_id IN NUMBER) RETURN NUMBER;
30
31
32 PROCEDURE Collect_Supply_Demand_Info(p_group_id IN NUMBER,
33 p_sys_seq_num IN NUMBER,
34 p_mrp_status IN NUMBER,
35 p_org_id IN NUMBER,
36 p_sup_dem_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
37 ERRBUF OUT NOCOPY VARCHAR2,
38 RETCODE OUT NOCOPY NUMBER);
39
40 PROCEDURE Get_Supply_Demand_Info(x_supply_demand_table OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE);
41
42
43 PROCEDURE Get_Supply_Demand_Info(p_starting_index IN NUMBER DEFAULT 1,
44 p_ending_index IN NUMBER DEFAULT -1,
45 x_rows_fetched OUT NOCOPY NUMBER,
46 x_reservation_type_tbl OUT NOCOPY Number_Tbl_Type,
47 x_supply_demand_src_type_tbl OUT NOCOPY Number_Tbl_Type,
48 x_txn_source_type_id_tbl OUT NOCOPY Number_Tbl_Type,
49 x_supply_demand_source_id_tbl OUT NOCOPY Number_Tbl_Type,
50 x_supply_demand_type_tbl OUT NOCOPY Number_Tbl_Type,
51 x_supply_demand_quantity_tbl OUT NOCOPY Number_Tbl_Type,
52 x_supply_demand_date_tbl OUT NOCOPY Number_Tbl_Type,
53 x_inventory_item_id_tbl OUT NOCOPY Number_Tbl_Type,
54 x_organization_id_tbl OUT NOCOPY Number_Tbl_Type);
55
56 PROCEDURE Clear_Supply_Demand_Info;
57
58
59 PROCEDURE Collect_Supply_Info(p_group_id IN NUMBER,
60 p_sys_seq_num IN NUMBER,
61 p_mrp_status IN NUMBER,
62 p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
63 ERRBUF OUT NOCOPY VARCHAR2,
64 RETCODE OUT NOCOPY NUMBER);
65
66 PROCEDURE Collect_Demand_Info(p_group_id IN NUMBER,
67 p_sys_seq_num IN NUMBER,
68 p_mrp_status IN NUMBER,
69 p_org_id IN NUMBER,
70 p_demand_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
71 ERRBUF OUT NOCOPY VARCHAR2,
72 RETCODE OUT NOCOPY NUMBER);
73
74 PROCEDURE Collect_OnHand_Supply(p_group_id IN NUMBER,
75 p_sys_seq_num IN NUMBER,
76 p_mrp_status IN NUMBER,
77 p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
78 ERRBUF OUT NOCOPY VARCHAR2,
79 RETCODE OUT NOCOPY NUMBER);
80
81 PROCEDURE Collect_User_Supply(p_group_id IN NUMBER,
82 p_sys_seq_num IN NUMBER,
83 p_mrp_status IN NUMBER,
84 p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
85 ERRBUF OUT NOCOPY VARCHAR2,
86 RETCODE OUT NOCOPY NUMBER);
87
88 PROCEDURE Collect_MTL_Supply(p_group_id IN NUMBER,
89 p_sys_seq_num IN NUMBER,
90 p_mrp_status IN NUMBER,
91 p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
92 ERRBUF OUT NOCOPY VARCHAR2,
93 RETCODE OUT NOCOPY NUMBER);
94
95 PROCEDURE Collect_DiscreteJob_Supply(p_group_id IN NUMBER,
96 p_sys_seq_num IN NUMBER,
97 p_mrp_status IN NUMBER,
98 p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
99 ERRBUF OUT NOCOPY VARCHAR2,
100 RETCODE OUT NOCOPY NUMBER);
101
102 PROCEDURE Collect_WipNegReq_Supply(p_group_id IN NUMBER,
103 p_sys_seq_num IN NUMBER,
104 p_mrp_status IN NUMBER,
105 p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
106 ERRBUF OUT NOCOPY VARCHAR2,
107 RETCODE OUT NOCOPY NUMBER);
108
109 PROCEDURE Collect_RepSched_Supply(p_group_id IN NUMBER,
110 p_sys_seq_num IN NUMBER,
111 p_mrp_status IN NUMBER,
112 p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
113 ERRBUF OUT NOCOPY VARCHAR2,
114 RETCODE OUT NOCOPY NUMBER);
115
116 PROCEDURE Collect_FlowSched_Supply(p_group_id IN NUMBER,
117 p_sys_seq_num IN NUMBER,
118 p_mrp_status IN NUMBER,
119 p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
120 ERRBUF OUT NOCOPY VARCHAR2,
121 RETCODE OUT NOCOPY NUMBER);
122
123 PROCEDURE Collect_DiscreteJob_Demand(p_group_id IN NUMBER,
124 p_sys_seq_num IN NUMBER,
125 p_mrp_status IN NUMBER,
126 p_demand_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
127 ERRBUF OUT NOCOPY VARCHAR2,
128 RETCODE OUT NOCOPY NUMBER);
129
130 PROCEDURE Collect_RepSched_Demand(p_group_id IN NUMBER,
131 p_sys_seq_num IN NUMBER,
132 p_mrp_status IN NUMBER,
133 p_demand_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
134 ERRBUF OUT NOCOPY VARCHAR2,
135 RETCODE OUT NOCOPY NUMBER);
136
137 PROCEDURE Collect_User_Demand(p_group_id IN NUMBER,
138 p_sys_seq_num IN NUMBER,
139 p_mrp_status IN NUMBER,
140 p_demand_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
141 ERRBUF OUT NOCOPY VARCHAR2,
142 RETCODE OUT NOCOPY NUMBER);
143
144 PROCEDURE Collect_FlowSched_Demand(p_group_id IN NUMBER,
145 p_sys_seq_num IN NUMBER,
146 p_mrp_status IN NUMBER,
147 p_demand_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
148 ERRBUF OUT NOCOPY VARCHAR2,
149 RETCODE OUT NOCOPY NUMBER);
150
151 PROCEDURE Collect_SalesOrder_Demand(p_group_id IN NUMBER,
152 p_sys_seq_num IN NUMBER,
153 p_mrp_status IN NUMBER,
154 p_org_id IN NUMBER,
155 p_demand_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
156 ERRBUF OUT NOCOPY VARCHAR2,
157 RETCODE OUT NOCOPY NUMBER);
158
159 END WPS_SUPPLY_DEMAND;