1 PACKAGE gme_resource_engine_pvt AS
2 /* $Header: GMEVRXNS.pls 120.4.12000000.2 2007/01/26 23:06:46 snene ship $
3 *****************************************************************
4 * *
5 * Package GME_RESOURCE_ENGINE_PVT *
6 * *
7 * Contents CREATE_RESOURCE_TRANS *
8 * UPDATE_RESOURCE_TRANS *
9 * DELETE_RESOURCE_TRANS *
10 * FETCH_ALL_RESOURCES *
11 * BUILD_RESOURCE_TRAN *
12 * FETCH_ACTIVE_RESOURCES *
13 * *
14 * Use This is the private layer of the GME Resource *
15 * Transaction Processor. *
16 * *
17 * History *
18 ****************************************************************
19 */
20 PROCEDURE fetch_all_resources (
21 p_resource_rec IN gme_resource_txns_gtmp%ROWTYPE
22 ,x_resource_tbl OUT NOCOPY gme_common_pvt.resource_transactions_tab
23 ,x_return_status OUT NOCOPY VARCHAR2
24 ,p_active_trans IN NUMBER DEFAULT 0);
25
26 PROCEDURE create_resource_trans (
27 p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE
28 ,x_tran_rec OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE
29 ,x_return_status OUT NOCOPY VARCHAR2);
30
31 PROCEDURE delete_resource_trans (
32 p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE
33 ,x_return_status OUT NOCOPY VARCHAR2);
34
35 PROCEDURE update_resource_trans (
36 p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE
37 ,x_return_status OUT NOCOPY VARCHAR2);
38
39 PROCEDURE consolidate_batch_resources (
40 p_batch_id IN NUMBER
41 ,x_return_status OUT NOCOPY VARCHAR2);
42
43 PROCEDURE build_resource_tran (
44 p_tmp_rec IN gme_resource_txns_gtmp%ROWTYPE
45 ,p_resource_rec OUT NOCOPY gme_resource_txns%ROWTYPE);
46
47 PROCEDURE fetch_active_resources (
48 p_resource_rec IN gme_resource_txns_gtmp%ROWTYPE
49 ,p_calling_mode IN VARCHAR2 DEFAULT NULL --bug#5609683
50 ,x_resource_tbl OUT NOCOPY gme_common_pvt.resource_transactions_tab
51 ,x_return_status OUT NOCOPY VARCHAR2);
52
53 PROCEDURE resource_dtl_process (
54 p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
55 ,p_action_code IN VARCHAR2
56 ,p_check_prim_rsrc IN BOOLEAN := FALSE
57 ,x_step_resources_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
58 ,x_return_status OUT NOCOPY VARCHAR2);
59
60 PROCEDURE validate_resource (
61 p_batch_step_rec IN gme_batch_steps%ROWTYPE
62 ,p_step_activity_rec IN gme_batch_step_activities%ROWTYPE
63 ,p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
64 ,p_check_prim_rsrc IN BOOLEAN := FALSE
65 ,x_return_status OUT NOCOPY VARCHAR2);
66
67 PROCEDURE get_resource_usage (
68 p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
69 ,x_step_resources_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
70 ,x_return_status OUT NOCOPY VARCHAR2);
71
72 PROCEDURE check_primary_resource (
73 p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
74 ,x_return_status OUT NOCOPY VARCHAR2);
75
76 PROCEDURE check_primary_resource (
77 p_batch_id IN NUMBER
78 ,p_batchstep_id IN NUMBER
79 ,x_return_status OUT NOCOPY VARCHAR2);
80
81 PROCEDURE validate_rsrc_txn_param (
82 p_called_from IN NUMBER
83 ,p_batchstep_rsrc_id IN NUMBER
84 ,p_org_code IN VARCHAR2
85 ,p_batch_no IN VARCHAR2 := NULL
86 ,p_batchstep_no IN NUMBER := NULL
87 ,p_activity IN VARCHAR2 := NULL
88 ,p_resource IN VARCHAR2 := NULL
89 ,p_trans_date IN DATE
90 ,p_start_date IN DATE
91 ,p_end_date IN DATE
92 ,p_usage IN NUMBER
93 ,p_reason_name IN VARCHAR2
94 ,p_reason_id IN NUMBER
95 ,p_instance_id IN NUMBER
96 ,p_instance_no IN NUMBER
97 ,x_line_id OUT NOCOPY NUMBER
98 ,x_step_status OUT NOCOPY NUMBER
99 ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
100 ,x_instance_id OUT NOCOPY NUMBER
101 ,x_reason_id OUT NOCOPY NUMBER
102 ,x_return_status OUT NOCOPY VARCHAR2
103 --Rishi Varma 02-09-2004 B3856541
104 /*Added the new parameter to the procedure*/
105 , x_trans_date OUT NOCOPY DATE);
106
107 /*
108 PROCEDURE update_actual_resource_usagep
109 ( p_batchstep_rsrc_id IN NUMBER
110 , p_plant_code IN VARCHAR2 := NULL
111 , p_batch_no IN VARCHAR2 := NULL
112 , p_batchstep_no IN NUMBER := NULL
113 , p_activity IN VARCHAR2 := NULL
114 , p_resource IN VARCHAR2 := NULL
115 , p_trans_date IN DATE
116 , p_start_date IN DATE
117 , p_end_date IN DATE
118 , p_usage IN NUMBER
119 , p_reason_code IN VARCHAR2
120 , p_instance_id IN NUMBER
121 , p_instance_no IN NUMBER
122 , x_batch_id OUT NOCOPY NUMBER
123 , x_line_id OUT NOCOPY NUMBER
124 , x_return_status OUT NOCOPY VARCHAR2);
125 */
126 PROCEDURE update_actual_resource_usage (
127 /* start ,Punit Kumar
128 p_batchstep_rsrc_id IN NUMBER ,
129 p_plant_code IN VARCHAR2 := NULL,
130 */
131 p_org_code IN VARCHAR2
132 , /*, inventory organization under which the batch was created.*/
133 /*end*/
134 p_batch_no IN VARCHAR2 := NULL
135 ,p_batchstep_no IN NUMBER := NULL
136 ,p_activity IN VARCHAR2 := NULL
137 ,p_resource IN VARCHAR2 := NULL
138 ,
139 /* start ,Punit Kumar
140 p_trans_date IN DATE,
141 p_start_date IN DATE,
142 p_end_date IN DATE,
143 p_usage IN NUMBER,
144 p_reason_code IN VARCHAR2,
145 p_instance_id IN NUMBER ,
146 */
147 p_reason_name IN VARCHAR2,
148 p_instance_no IN NUMBER
149 ,
150 /*
151 x_batch_id OUT NOCOPY NUMBER,
152 x_line_id OUT NOCOPY NUMBER,
153 */
154 p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
155 ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
156 ,
157 /*end*/
158 x_return_status OUT NOCOPY VARCHAR2);
159
160 /*
161 PROCEDURE insert_incr_actual_rsrc_txnp
162 ( p_batchstep_rsrc_id IN NUMBER
163 , p_plant_code IN VARCHAR2 := NULL
164 , p_batch_no IN VARCHAR2 := NULL
165 , p_batchstep_no IN NUMBER := NULL
166 , p_activity IN VARCHAR2 := NULL
167 , p_resource IN VARCHAR2 := NULL
168 , p_trans_date IN DATE
169 , p_start_date IN DATE
170 , p_end_date IN DATE
171 , p_usage IN NUMBER
172 , p_reason_code IN VARCHAR2
173 , p_instance_id IN NUMBER
174 , p_instance_no IN NUMBER
175 , x_batch_id OUT NOCOPY NUMBER
176 , x_poc_trans_id OUT NOCOPY NUMBER
177 , x_return_status OUT NOCOPY VARCHAR2);
178 */
179 PROCEDURE insert_incr_actual_rsrc_txn (
180 /* start ,Punit Kumar
181 p_batchstep_rsrc_id IN NUMBER ,
182 p_plant_code IN VARCHAR2 := NULL,
183 */
184 p_org_code IN VARCHAR2
185 , /*inventory organization under which the batch was created.*/
186 /* end */
187 p_batch_no IN VARCHAR2 := NULL
188 ,p_batchstep_no IN NUMBER := NULL
189 ,p_activity IN VARCHAR2 := NULL
190 ,p_resource IN VARCHAR2 := NULL
191 ,
192 /* start , Punit Kumar
193 p_trans_date IN DATE,
194 p_start_date IN DATE,
195 p_end_date IN DATE,
196 p_usage IN NUMBER,
197 p_reason_code IN VARCHAR2,
198 p_instance_id IN NUMBER ,
199 */
200 p_reason_name IN VARCHAR2,
201 p_instance_no IN NUMBER
202 ,
203 /*
204 x_batch_id OUT NOCOPY NUMBER,
205 x_poc_trans_id OUT NOCOPY NUMBER,
206 */
207 p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
208 ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
209 ,
210 /*end*/
211 x_return_status OUT NOCOPY VARCHAR2);
212
213 /*
214 PROCEDURE insert_timed_actual_rsrc_txnp
215 ( p_batchstep_rsrc_id IN NUMBER
216 , p_plant_code IN VARCHAR2 := NULL
217 , p_batch_no IN VARCHAR2 := NULL
218 , p_batchstep_no IN NUMBER := NULL
219 , p_activity IN VARCHAR2 := NULL
220 , p_resource IN VARCHAR2 := NULL
221 , p_trans_date IN DATE
222 , p_start_date IN DATE
223 , p_end_date IN DATE
224 , p_reason_code IN VARCHAR2
225 , p_instance_id IN NUMBER
226 , p_instance_no IN NUMBER
227 , x_batch_id OUT NOCOPY NUMBER
228 , x_poc_trans_id OUT NOCOPY NUMBER
229 , x_return_status OUT NOCOPY VARCHAR2);
230 */
231 PROCEDURE insert_timed_actual_rsrc_txn (
232 /* start ,Punit Kumar
233 p_batchstep_rsrc_id IN NUMBER ,
234 p_plant_code IN VARCHAR2 := NULL,
235 */
236 p_org_code IN VARCHAR2
237 , /* inventory organization under which the batch was created.*/
238 /* end */
239 p_batch_no IN VARCHAR2 := NULL
240 ,p_batchstep_no IN NUMBER := NULL
241 ,p_activity IN VARCHAR2 := NULL
242 ,p_resource IN VARCHAR2 := NULL
243 ,
244 /* start, Punit Kumar
245 p_trans_date IN DATE,
246 p_start_date IN DATE,
247 p_end_date IN DATE,
248 p_reason_code IN VARCHAR2,
249 p_instance_id IN NUMBER ,
250 */
251 p_reason_name IN VARCHAR2,
252 p_instance_no IN NUMBER
253 ,
254 /*
255 x_batch_id OUT NOCOPY NUMBER,
256 x_poc_trans_id OUT NOCOPY NUMBER,
257 */
258 p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
259 ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
260 ,
261 /*end*/
262 x_return_status OUT NOCOPY VARCHAR2);
263
264 /*
265 PROCEDURE start_cmplt_actual_rsrc_txnp
266 ( p_batchstep_rsrc_id IN NUMBER
267 , p_plant_code IN VARCHAR2 := NULL
268 , p_batch_no IN VARCHAR2 := NULL
269 , p_batchstep_no IN NUMBER := NULL
270 , p_activity IN VARCHAR2 := NULL
271 , p_resource IN VARCHAR2 := NULL
272 , p_trans_date IN DATE
273 , p_start_date IN DATE
274 , p_reason_code IN VARCHAR2
275 , p_instance_id IN NUMBER
276 , p_instance_no IN NUMBER
277 , x_batch_id OUT NOCOPY NUMBER
278 , x_poc_trans_id OUT NOCOPY NUMBER
279 , x_return_status OUT NOCOPY VARCHAR2);
280 */
281 PROCEDURE start_cmplt_actual_rsrc_txn (
282 /* start , Punit Kumar
283 p_batchstep_rsrc_id IN NUMBER ,
284 p_plant_code IN VARCHAR2 := NULL,
285 */
286 p_org_code IN VARCHAR2
287 , /*inventory organization under which the batch was created */
288 /* end */
289 p_batch_no IN VARCHAR2 := NULL
290 ,p_batchstep_no IN NUMBER := NULL
291 ,p_activity IN VARCHAR2 := NULL
292 ,p_resource IN VARCHAR2 := NULL
293 ,
294 /* start , Punit Kumar
295 p_trans_date IN DATE,
296 p_start_date IN DATE,
297 p_reason_code IN VARCHAR2,
298 p_instance_id IN NUMBER ,
299 */
300 p_reason_name IN VARCHAR2,
301 p_instance_no IN NUMBER
302 ,
303 /*
304 x_batch_id OUT NOCOPY NUMBER,
305 x_poc_trans_id OUT NOCOPY NUMBER,
306 */
307 p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
308 ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
309 ,
310 /*end */
311 x_return_status OUT NOCOPY VARCHAR2);
312
313 /*
314 PROCEDURE end_cmplt_actual_rsrc_txnp
315 ( p_poc_trans_id IN NUMBER
316 , p_trans_date IN DATE
317 , p_end_date IN DATE
318 , p_reason_code IN VARCHAR2
319 , p_instance_id IN NUMBER
320 , p_instance_no IN NUMBER
321 , x_poc_trans_id OUT NOCOPY NUMBER --BUG#3479669 RAGHU
322 , x_batch_id OUT NOCOPY NUMBER
323 , x_return_status OUT NOCOPY VARCHAR2);
324 */
325 PROCEDURE end_cmplt_actual_rsrc_txn (
326 p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
327 ,p_reason_name IN VARCHAR2
328 ,p_instance_no IN NUMBER
329 ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
330 ,x_return_status OUT NOCOPY VARCHAR2);
331 END gme_resource_engine_pvt;