[Home] [Help]
PACKAGE: APPS.PJM_SCHED_INT_WF_PRIV
Source
1 PACKAGE PJM_SCHED_INT_WF_PRIV AUTHID CURRENT_USER AS
2 /* $Header: PJMSIWPS.pls 115.4 99/09/19 11:03:57 porting shi $ */
3 /*---------------------------------------------------------------------------
4 Workflow common start procedure
5 ---------------------------------------------------------------------------*/
6
7 PROCEDURE common_start(c_item_type varchar2
8 ,c_item_key varchar2
9 ,c_process varchar2
10 ,c_owner varchar2
11 ,c_requestor varchar2
12 ,n_tolerance_days number
13 ,c_ntf_proj_mgr varchar2
14 ,c_ntf_task_mgr varchar2
15 ,c_project_number varchar2
16 ,c_project_name varchar2
17 ,d_project_start_date date
18 ,d_project_end_date date
19 ,c_task_number varchar2
20 ,c_task_name varchar2
21 ,d_task_start_date date
22 ,d_task_end_date date
23 ,c_exception_subject varchar2
24 ,c_exception_body varchar2
25 ,c_document_type varchar2
26 ,c_item_number varchar2
27 ,c_item_description varchar2
28 );
29
30 -- ---------------------------------------------------------------------
31 -- Public Functions / Procedures
32 -- ---------------------------------------------------------------------
33
34 PROCEDURE launch_wip(c_item_type varchar2
35 ,c_item_key varchar2
36 ,c_process varchar2
37 ,c_owner varchar2
38 ,c_requestor varchar2
39 ,n_tolerance_days number
40 ,c_ntf_proj_mgr varchar2
41 ,c_ntf_task_mgr varchar2
42 ,c_project_number varchar2
43 ,c_project_name varchar2
44 ,d_project_start_date date
45 ,d_project_end_date date
46 ,c_task_number varchar2
47 ,c_task_name varchar2
48 ,d_task_start_date date
49 ,d_task_end_date date
50 ,c_exception_subject varchar2
51 ,c_exception_body varchar2
52 ,c_document_type varchar2
53 ,c_item_number varchar2
54 ,c_item_description varchar2
55 ,c_wip_job_name varchar2
56 ,c_organization_name varchar2
57 ,d_job_start_date date
58 ,d_job_end_date date
59 ,c_status varchar2
60 ,c_job_type varchar2
61 ,n_start_quantity number
62 ,n_quantity_completed number
63 );
64
65 PROCEDURE launch_so (c_item_type varchar2
66 ,c_item_key varchar2
67 ,c_process varchar2
68 ,c_owner varchar2
69 ,c_requestor varchar2
70 ,n_tolerance_days number
71 ,c_ntf_proj_mgr varchar2
72 ,c_ntf_task_mgr varchar2
73 ,c_project_number varchar2
74 ,c_project_name varchar2
75 ,d_project_start_date date
76 ,d_project_end_date date
77 ,c_task_number varchar2
78 ,c_task_name varchar2
79 ,d_task_start_date date
80 ,d_task_end_date date
81 ,c_exception_subject varchar2
82 ,c_exception_body varchar2
83 ,c_document_type varchar2
84 ,c_item_number varchar2
85 ,c_item_description varchar2
86 ,c_so_number number
87 ,c_line_number number
88 ,c_warehouse varchar2
89 ,n_quantity number
90 ,d_requested_date date
91 ,d_promised_date date
92 );
93
94 PROCEDURE launch_forecast(c_item_type varchar2
95 ,c_item_key varchar2
96 ,c_process varchar2
97 ,c_owner varchar2
98 ,c_requestor varchar2
99 ,n_tolerance_days number
100 ,c_ntf_proj_mgr varchar2
101 ,c_ntf_task_mgr varchar2
102 ,c_project_number varchar2
103 ,c_project_name varchar2
104 ,d_project_start_date date
105 ,d_project_end_date date
106 ,c_task_number varchar2
107 ,c_task_name varchar2
108 ,d_task_start_date date
109 ,d_task_end_date date
110 ,c_exception_subject varchar2
111 ,c_exception_body varchar2
112 ,c_document_type varchar2
113 ,c_item_number varchar2
114 ,c_item_description varchar2
115 ,c_forecast_set varchar2
116 ,c_forecast_name varchar2
117 ,c_organization_name varchar2
118 ,n_quantity number
119 ,d_forecast_start_date date
120 ,d_forecast_end_date date
121 );
122
123 PROCEDURE launch_pr (c_item_type varchar2
124 ,c_item_key varchar2
125 ,c_process varchar2
126 ,c_owner varchar2
127 ,c_requestor varchar2
128 ,n_tolerance_days number
129 ,c_ntf_proj_mgr varchar2
130 ,c_ntf_task_mgr varchar2
131 ,c_project_number varchar2
132 ,c_project_name varchar2
133 ,d_project_start_date date
134 ,d_project_end_date date
135 ,c_task_number varchar2
136 ,c_task_name varchar2
137 ,d_task_start_date date
138 ,d_task_end_date date
139 ,c_exception_subject varchar2
140 ,c_exception_body varchar2
141 ,c_document_type varchar2
142 ,c_item_number varchar2
143 ,c_item_description varchar2
144 ,c_pr_number varchar2
145 ,c_ship_to_location varchar2
146 ,c_status varchar2
147 ,n_quantity number
148 ,d_need_by_date date
149 );
150
151 PROCEDURE launch_rfq(c_item_type varchar2
152 ,c_item_key varchar2
153 ,c_process varchar2
154 ,c_owner varchar2
155 ,c_requestor varchar2
156 ,n_tolerance_days number
157 ,c_ntf_proj_mgr varchar2
158 ,c_ntf_task_mgr varchar2
159 ,c_project_number varchar2
160 ,c_project_name varchar2
161 ,d_project_start_date date
162 ,d_project_end_date date
163 ,c_task_number varchar2
164 ,c_task_name varchar2
165 ,d_task_start_date date
166 ,d_task_end_date date
167 ,c_exception_subject varchar2
168 ,c_exception_body varchar2
169 ,c_document_type varchar2
170 ,c_item_number varchar2
171 ,c_item_description varchar2
172 ,c_rfq_number varchar2
173 ,c_ship_to_location varchar2
174 ,c_status varchar2
175 ,d_due_date date
176 );
177
178 PROCEDURE launch_quotation (c_item_type varchar2
179 ,c_item_key varchar2
180 ,c_process varchar2
181 ,c_owner varchar2
182 ,c_requestor varchar2
183 ,n_tolerance_days number
184 ,c_ntf_proj_mgr varchar2
185 ,c_ntf_task_mgr varchar2
186 ,c_project_number varchar2
187 ,c_project_name varchar2
188 ,d_project_start_date date
189 ,d_project_end_date date
190 ,c_task_number varchar2
191 ,c_task_name varchar2
192 ,d_task_start_date date
193 ,d_task_end_date date
194 ,c_exception_subject varchar2
195 ,c_exception_body varchar2
196 ,c_document_type varchar2
197 ,c_item_number varchar2
198 ,c_item_description varchar2
199 ,c_quotation_number varchar2
200 ,c_ship_to_location varchar2
201 ,c_status varchar2
202 ,d_eff_start_date date
203 ,d_eff_end_date date
204 );
205
206 PROCEDURE launch_mds(c_item_type varchar2
207 ,c_item_key varchar2
208 ,c_process varchar2
209 ,c_owner varchar2
210 ,c_requestor varchar2
211 ,n_tolerance_days number
212 ,c_ntf_proj_mgr varchar2
213 ,c_ntf_task_mgr varchar2
214 ,c_project_number varchar2
215 ,c_project_name varchar2
216 ,d_project_start_date date
217 ,d_project_end_date date
218 ,c_task_number varchar2
219 ,c_task_name varchar2
220 ,d_task_start_date date
221 ,d_task_end_date date
222 ,c_exception_subject varchar2
223 ,c_exception_body varchar2
224 ,c_document_type varchar2
225 ,c_item_number varchar2
226 ,c_item_description varchar2
227 ,c_mds_name varchar2
228 ,c_organization_name varchar2
229 ,n_quantity number
230 ,d_schedule_date date
231 ,d_schedule_end_date date
232 );
233
234 PROCEDURE launch_mps(c_item_type varchar2
235 ,c_item_key varchar2
236 ,c_process varchar2
237 ,c_owner varchar2
238 ,c_requestor varchar2
239 ,n_tolerance_days number
240 ,c_ntf_proj_mgr varchar2
241 ,c_ntf_task_mgr varchar2
242 ,c_project_number varchar2
243 ,c_project_name varchar2
244 ,d_project_start_date date
245 ,d_project_end_date date
246 ,c_task_number varchar2
247 ,c_task_name varchar2
248 ,d_task_start_date date
249 ,d_task_end_date date
250 ,c_exception_subject varchar2
251 ,c_exception_body varchar2
252 ,c_document_type varchar2
253 ,c_item_number varchar2
254 ,c_item_description varchar2
255 ,c_mps_name varchar2
256 ,c_organization_name varchar2
257 ,n_quantity number
258 ,d_schedule_date date
259 ,d_schedule_end_date date
260 );
261
262 PROCEDURE launch_po (c_item_type varchar2
263 ,c_item_key varchar2
264 ,c_process varchar2
265 ,c_owner varchar2
266 ,c_requestor varchar2
267 ,n_tolerance_days number
268 ,c_ntf_proj_mgr varchar2
269 ,c_ntf_task_mgr varchar2
270 ,c_project_number varchar2
271 ,c_project_name varchar2
272 ,d_project_start_date date
273 ,d_project_end_date date
274 ,c_task_number varchar2
275 ,c_task_name varchar2
276 ,d_task_start_date date
277 ,d_task_end_date date
278 ,c_exception_subject varchar2
279 ,c_exception_body varchar2
280 ,c_document_type varchar2
281 ,c_item_number varchar2
282 ,c_item_description varchar2
283 ,c_po_number varchar2
284 ,c_ship_to_location varchar2
285 ,c_status varchar2
286 ,n_ordered_quantity number
287 ,n_delivered_quantity number
288 ,d_promised_date date
289 ,d_need_by_date date
290 );
291
292 PROCEDURE launch_po_release (c_item_type varchar2
293 ,c_item_key varchar2
294 ,c_process varchar2
295 ,c_owner varchar2
296 ,c_requestor varchar2
297 ,n_tolerance_days number
298 ,c_ntf_proj_mgr varchar2
299 ,c_ntf_task_mgr varchar2
300 ,c_project_number varchar2
301 ,c_project_name varchar2
302 ,d_project_start_date date
303 ,d_project_end_date date
304 ,c_task_number varchar2
305 ,c_task_name varchar2
306 ,d_task_start_date date
307 ,d_task_end_date date
308 ,c_exception_subject varchar2
309 ,c_exception_body varchar2
310 ,c_document_type varchar2
311 ,c_item_number varchar2
312 ,c_item_description varchar2
313 ,c_po_number varchar2
314 ,c_release_number varchar2
315 ,c_ship_to_location varchar2
316 ,c_status varchar2
317 ,n_ordered_quantity number
318 ,n_delivered_quantity number
319 ,d_promised_date date
320 ,d_need_by_date date
321 );
322
323
324
325 END PJM_SCHED_INT_WF_PRIV;