1 PACKAGE CHV_LOAD_ORDERS AUTHID CURRENT_USER as
2 /* $Header: CHVPRLOS.pls 115.0 99/07/17 01:30:13 porting ship $ */
3 /*===========================================================================
4
5 PACKAGE NAME: CHVLORDS.pls
6
7 DESCRIPTION: This package contains the server side of Supplier Scheduling
8 APIs to load discrete item orders.
9
10 CLIENT/SERVER: Server
11
12 OWNER: Sri Rumalla
13
14 FUNCTION/
15 PROCEDURE: load_item_orders()
16 load_planned_orders()
17 load_approved_requisitions()
18 load_approved_releases()
19
20 =============================================================================*/
21 /*=============================================================================
22 PROCEDURE NAME: load_item_orders
23
24 DESCRIPTION: Procedure when executed will evaluate the schedule_type
25 and subtype and execute the procedures load_planned_orders
26 load_approved_requisitions and load_approved_releases
27 accordingly.
28
29 PARAMETERS: x_organization_id in NUMBER,
30 x_schedule_id in NUMBER,
31 x_schedule_item_id in NUMBER,
32 x_vendor_id in NUMBER,
33 x_vendor_site_id in NUMBER,
34 x_item_id in NUMBER,
35 x_purchasing_unit_of_measure in VARCHAR2,
36 x_primary_unit_of_measure in VARCHAR2,
37 x_horizon_start_date in DATE,
38 x_horizon_end_date in DATE,
39 x_include_future_rel_flag in VARCHAR2,
40 x_schedule_type in VARCHAR2,
41 x_schedule_subtype in VARCHAR2,
42 x_plan_designator in VARCHAR2);
43
44 DESIGN REFERENCES:
45
46 ALGORITHM:
47
48 NOTES:
49
50 OPEN ISSUES:
51
52 CLOSED ISSUES:
53
54 CHANGE HISTORY: Created 01-NOV-1995 SRUMALLA
55
56 ============================================================================*/
57
58 PROCEDURE load_item_orders(x_organization_id in NUMBER,
59 x_schedule_id in NUMBER,
60 x_schedule_item_id in NUMBER,
61 x_vendor_id in NUMBER,
62 x_vendor_site_id in NUMBER,
63 x_item_id in NUMBER,
64 x_purchasing_unit_of_measure in VARCHAR2,
65 x_primary_unit_of_measure in VARCHAR2,
66 x_conversion_rate in NUMBER,
67 x_horizon_start_date in DATE,
68 x_horizon_end_date in DATE,
69 x_include_future_rel_flag in VARCHAR2,
70 x_schedule_type in VARCHAR2,
71 x_schedule_subtype in VARCHAR2,
72 x_plan_designator in VARCHAR2);
73
74 /*=============================================================================
75 PROCEDURE NAME: load_planned_orders
76
77 DESCRIPTION: Loads unimplemented orders from mrp_recommendations based
78 on the horizon_end_date and inserts into chv_item_orders.
79
80
81 PARAMETERS: x_organization_id in NUMBER,
82 x_schedule_id in NUMBER,
83 x_schedule_item_id in NUMBER,
84 x_vendor_id in NUMBER,
85 x_vendor_site_id in NUMBER,
86 x_item_id in NUMBER,
87 x_purchasing_unit_of_measure in VARCHAR2,
88 x_primary_unit_of_measure in VARCHAR2,
89 x_horizon_start_date in DATE,
90 x_horizon_end_date in DATE,
91 x_schedule_type in VARCHAR2,
92 x_schedule_subtype in VARCHAR2,
93 x_plan_designator in VARCHAR2);
94
95 DESIGN REFERENCES:
96
97 ALGORITHM:
98
99 NOTES:
100
101 OPEN ISSUES:
102
103 CLOSED ISSUES:
104
105 CHANGE HISTORY: Created 01-NOV-1995 SRUMALLA
106
107 ============================================================================*/
108
109 PROCEDURE load_planned_orders(x_organization_id in NUMBER,
110 x_schedule_id in NUMBER,
111 x_schedule_item_id in NUMBER,
112 x_vendor_id in NUMBER,
113 x_vendor_site_id in NUMBER,
114 x_item_id in NUMBER,
115 x_purchasing_unit_of_measure in VARCHAR2,
116 x_primary_unit_of_measure in VARCHAR2,
117 x_conversion_rate in NUMBER,
118 x_horizon_start_date in DATE,
119 x_horizon_end_date in DATE,
120 x_schedule_type in VARCHAR2,
121 x_schedule_subtype in VARCHAR2,
122 x_plan_designator in VARCHAR2);
123
124 /*=============================================================================
125 PROCEDURE NAME: load_approved_requisitions
126
127 DESCRIPTION: Loads approved requisitions from po tables based
128 on the horizon_end_date and inserts into chv_item_orders.
129
130 PARAMETERS: x_organization_id in NUMBER,
131 x_schedule_id in NUMBER,
132 x_schedule_item_id in NUMBER,
133 x_vendor_id in NUMBER,
134 x_vendor_site_id in NUMBER,
135 x_item_id in NUMBER,
136 x_purchasing_unit_of_measure in VARCHAR2,
137 x_primary_unit_of_measure in VARCHAR2,
138 x_horizon_start_date in DATE,
139 x_horizon_end_date in DATE,
140 x_schedule_type in VARCHAR2,
141 x_schedule_subtype in VARCHAR2);
142
143 DESIGN REFERENCES:
144
145 ALGORITHM:
146
147 NOTES:
148
149 OPEN ISSUES:
150
151 CLOSED ISSUES:
152
153 CHANGE HISTORY: Created 01-NOV-1995 SRUMALLA
154
155 ============================================================================*/
156
157 PROCEDURE load_approved_requisitions(x_organization_id in NUMBER,
158 x_schedule_id in NUMBER,
159 x_schedule_item_id in NUMBER,
160 x_vendor_id in NUMBER,
161 x_vendor_site_id in NUMBER,
162 x_item_id in NUMBER,
163 x_purchasing_unit_of_measure in VARCHAR2,
164 x_primary_unit_of_measure in VARCHAR2,
165 x_conversion_rate in NUMBER,
166 x_horizon_start_date in DATE,
167 x_horizon_end_date in DATE,
168 x_schedule_type in VARCHAR2,
169 x_schedule_subtype in VARCHAR2);
170
171 /*=============================================================================
172 PROCEDURE NAME: load_approved_releases
173
174 DESCRIPTION: Loads approved releases from po tables based
175 on the horizon_end_date and inserts into chv_item_orders.
176
177 PARAMETERS: x_organization_id in NUMBER,
178 x_schedule_id in NUMBER,
179 x_schedule_item_id in NUMBER,
180 x_vendor_id in NUMBER,
181 x_vendor_site_id in NUMBER,
182 x_item_id in NUMBER,
183 x_purchasing_unit_of_measure in VARCHAR2,
184 x_primary_unit_of_measure in VARCHAR2,
185 x_horizon_start_date in DATE,
186 x_horizon_end_date in DATE,
187
188 DESIGN REFERENCES:
189
190 ALGORITHM:
191
192 NOTES:
193
194 OPEN ISSUES:
195
196 CLOSED ISSUES:
197
198 CHANGE HISTORY: Created 01-NOV-1995 SRUMALLA
199
200 ============================================================================*/
201 PROCEDURE load_approved_releases(x_organization_id in NUMBER,
202 x_schedule_id in NUMBER,
203 x_schedule_item_id in NUMBER,
204 x_vendor_id in NUMBER,
205 x_vendor_site_id in NUMBER,
206 x_item_id in NUMBER,
207 x_purchasing_unit_of_measure in VARCHAR2,
208 x_primary_unit_of_measure in VARCHAR2,
209 x_conversion_rate in NUMBER,
210 x_horizon_start_date in DATE,
211 x_horizon_end_date in DATE,
212 x_only_past_due_flag in VARCHAR2,
213 x_include_future_rel_flag in VARCHAR2
214 );
215
216
217 END CHV_LOAD_ORDERS;