1 PACKAGE CHV_BUILD_SCHEDULES AUTHID CURRENT_USER as
2 /*$Header: CHVPRSBS.pls 115.4 2002/11/26 19:50:56 sbull ship $*/
3
4 /*===========================================================================
5 PACKAGE NAME: CHV_BUILD_SCHEDULES
6 DESCRIPTION: This package contains the server side of Supplier Scheduling
7 APIs to build schedules
8
9 CLIENT/SERVER: Server
10
11 OWNER: Shawna Liu
12
13 NOTE: All parameters passed in from concurrent program begin with
14 p_ in all procedures; All variables declared within procedures
15 begin with x_; There are other special rules for each
16 procedure.
17
18 FUNCTION/
19 build_schedule()
20 get_schedule_number()
21 create_items()
22
23 ============================================================================*/
24
25 /*===========================================================================
26 PROCEDURE NAME : build_schedule
27
28 DESCRIPTION : The schedule build process generates planning,
29 shipping and inquiry schedules and is invoked by
30 both the scheduler workbench (manual build) and
31 the AutoSchedule SRS process.
32
33 PARAMETERS : p_schedule_category in VARCHAR2,
34 p_autoschedule_flag in VARCHAR2,
35 p_autoconfirm_flag in VARCHAR2,
36 p_schedule_type in VARCHAR2,
37 p_schedule_subtype in VARCHAR2,
38 p_schedule_num in VARCHAR2 DEFAULT null,
39 p_horizon_start_date in DATE,
40 p_bucket_pattern_id in NUMBER DEFAULT null,
41 p_include_future_releases in VARCHAR2,
42 p_mrp_compile_designator in VARCHAR2 DEFAULT null,
43 p_mps_schedule_designator in VARCHAR2 DEFAULT null,
44 p_drp_compile_designator in VARCHAR2 DEFAULT null,
45 p_ship_to_organization_id in NUMBER,
46 p_multi_org_flag in VARCHAR2,
47 p_vendor_id in NUMBER DEFAULT null,
48 p_vendor_site_id in NUMBER DEFAULT null,
49 p_category_set_id in NUMBER DEFAULT null,
50 p_category_id in NUMBER DEFAULT null,
51 p_item_id in NUMBER DEFAULT null,
52 p_scheduler_id in NUMBER DEFAULT null,
53 p_buyer_id in NUMBER DEFAULT null,
54 p_planner_code in VARCHAR2 DEFAULT null
55
56 DESIGN REFERENCES :
57
58 ALGORITHM :
59
60 NOTES : All parameters passed in from concurrent program
61 begin with p_; All variables declared locally
62 within the procedure begin with x_.
63
64 OPEN ISSUES :
65
66 CLOSED ISSUES :
67
68 CHANGE HISTORY : Created 23-APR-1995 SXLIU
69 ==========================================================================*/
70
71 PROCEDURE build_schedule(p_schedule_category in VARCHAR2,
72 p_autoschedule_flag in VARCHAR2,
73 p_schedule_type in VARCHAR2,
74 p_schedule_subtype in VARCHAR2 DEFAULT null,
75 p_schedule_num in VARCHAR2 DEFAULT null,
76 p_schedule_revision IN NUMBER DEFAULT null,
77 p_horizon_start_date in DATE,
78 p_bucket_pattern_id in NUMBER DEFAULT null,
79 p_multi_org_flag in VARCHAR2 DEFAULT null,
80 p_ship_to_organization_id in NUMBER DEFAULT null,
81 p_mrp_compile_designator in VARCHAR2 DEFAULT null,
82 p_mps_schedule_designator in VARCHAR2 DEFAULT null,
83 p_drp_compile_designator in VARCHAR2 DEFAULT null,
84 p_include_future_releases in VARCHAR2 DEFAULT null,
85 p_autoconfirm_flag in VARCHAR2 DEFAULT null,
86 p_communication_code in VARCHAR2 DEFAULT null,
87 p_vendor_id in NUMBER DEFAULT null,
88 p_vendor_site_id in NUMBER DEFAULT null,
89 p_category_set_id in NUMBER DEFAULT null,
90 p_struct_num in NUMBER DEFAULT null,
91 p_yes_no in VARCHAR2 DEFAULT null,
92 p_category_id in NUMBER DEFAULT null,
93 p_item_org in NUMBER DEFAULT null,
94 p_item_id in NUMBER DEFAULT null,
95 p_scheduler_id in NUMBER DEFAULT null,
96 p_buyer_id in NUMBER DEFAULT null,
97 p_planner_code in VARCHAR2 DEFAULT null,
98 p_owner_id in NUMBER DEFAULT null,
99 p_batch_id in NUMBER DEFAULT null,
100 p_exclude_zero_quantity_lines in VARCHAR2 DEFAULT null);
101
102 /*===========================================================================
103 PROCEDURE NAME : get_schedule_number
104
105 DESCRIPTION : This procedure when executed will retreive the next
106 logical schedule number and revision for the schedule
107 header being generated.
108
109 PARAMETERS : x_schedule_category in VARCHAR2,
110 x_vendor_id in NUMBER,
111 x_vendor_site_id in NUMBER,
112 x_schedule_numb in out VARCHAR2,
113 x_schedule_revision out NUMBER
114
115 DESIGN REFERENCES :
116
117 ALGORITHM : If schedule_category is 'NEW' then schedule_num is
118 the total number of schedules generated today plus 1
119 and set revision to 0 at the same time;
120 If schedule_category is 'REVISION' then revision is
121 total number of schedule revisions under this name
122 plus 1.
123
124 NOTES : All parameters passed in from concurrent program
125 begin with p_; All variables declared locally
126 within the procedure begin with x_ and end with _l;
127 All variables declared in the calling procedure
128 build_schedule and passed into this procedure
129 begin with x_ and no special ending.
130
131 OPEN ISSUES :
132
133 CLOSED ISSUES :
134
135 CHANGE HISTORY : Created 30-APR-1995 SXLIU
136 ==========================================================================*/
137 PROCEDURE get_schedule_number(p_schedule_category in VARCHAR2,
138 x_vendor_id in NUMBER,
139 x_vendor_site_id in NUMBER,
140 x_schedule_num in out NOCOPY VARCHAR2,
141 x_schedule_revision out NOCOPY NUMBER);
142
143 /*===========================================================================
144 PROCEDURE NAME : create_items
145
146 DESCRIPTION : This procedure will create items based on the schedule
147 header information and user entered filters and
148 inserts into CHV_SCHEDULE_ITEMS table and calls other
149 API's.
150
151 PARAMETERS : p_schedule_category in VARCHAR2,
152 p_autoschedule_flag in VARCHAR2,
153 p_schedule_type in VARCHAR2,
154 p_schedule_subtype in VARCHAR2,
155 x_schedule_id in NUMBER,
156 x_schedule_num in VARCHAR2,
157 x_schedule_revision in NUMBER,
158 p_horizon_start_date in DATE,
159 x_bucket_pattern_id in NUMBER,
160 p_include_future_releases in VARCHAR2,
161 x_mrp_compile_designator in VARCHAR2,
162 x_mps_schedule_designator in VARCHAR2,
163 x_drp_compile_designator in VARCHAR2,
164 x_organization_id in NUMBER,
165 p_multi_org_flag in VARCHAR2,
166 x_vendor_id in NUMBER,
167 x_vendor_site_id in NUMBER,
168 p_category_set_id in NUMBER,
169 p_category_id in NUMBER,
170 p_item_id in NUMBER,
171 p_scheduler_id in NUMBER,
172 p_buyer_id in NUMBER,
173 p_planner_code in VARCHAR2,
174 x_user_id in NUMBER,
175 x_login_id in NUMBER,
176 x_bucket_descriptor_table in BKTTABLE,
177 x_bucket_start_date_table in BKTTABLE,
178 x_bucket_end_date_table in BKTTABLE
179
180
181 DESIGN REFERENCES :
182
183 ALGORITHM :
184
185 NOTES :
186
187 OPEN ISSUES :
188
189 CLOSED ISSUES :
190
191 CHANGE HISTORY : Created 2-MAY-1995 SXLIU
192 ==========================================================================*/
193 PROCEDURE create_items (p_schedule_category in VARCHAR2,
194 p_autoschedule_flag in VARCHAR2,
195 p_schedule_type in VARCHAR2,
196 x_schedule_subtype in VARCHAR2,
197 x_schedule_id in NUMBER,
198 x_schedule_num in VARCHAR2,
199 x_schedule_revision in NUMBER,
200 p_horizon_start_date in DATE,
201 x_bucket_pattern_id in NUMBER,
202 p_include_future_releases in VARCHAR2,
203 x_mrp_compile_designator in VARCHAR2,
204 x_mps_schedule_designator in VARCHAR2,
205 x_drp_compile_designator in VARCHAR2,
206 x_organization_id_l in NUMBER,
207 p_multi_org_flag in VARCHAR2,
208 x_vendor_id in NUMBER,
209 x_vendor_site_id in NUMBER,
210 p_category_set_id in NUMBER,
211 p_category_id in NUMBER,
212 p_item_id in NUMBER,
213 p_scheduler_id in NUMBER,
214 p_buyer_id in NUMBER,
215 p_planner_code in VARCHAR2,
216 x_user_id in NUMBER,
217 x_login_id in NUMBER,
218 x_horizon_end_date in DATE,
219 x_bucket_descriptor_table in out NOCOPY chv_create_buckets.bkttable,
220 x_bucket_start_date_table in out NOCOPY chv_create_buckets.bkttable,
221 x_bucket_end_date_table in out NOCOPY chv_create_buckets.bkttable,
222 x_item_created in out NOCOPY VARCHAR2,
223 x_old_schedule_id in NUMBER,
224 p_bucket_pattern_id in NUMBER,
225 p_schedule_subtype in VARCHAR2,
226 p_batch_id in NUMBER);
227
228
229 END CHV_BUILD_SCHEDULES;