1 PACKAGE gme_common_pvt AUTHID CURRENT_USER AS
2 /* $Header: GMEVCMNS.pls 120.17.12010000.1 2008/07/25 10:29:52 appldev ship $ */
3
4 --Package/GLOBAL variables for GME
5 /* APPS related global variables */
6 g_login_id NUMBER (10);
7 g_user_ident NUMBER (10);
8 g_user_name VARCHAR2 (240);
9 /* INV related org parameters */
10 g_organization_code VARCHAR2 (3);
11 g_organization_id NUMBER (10);
12 g_calendar_code VARCHAR2 (10);
13 g_allow_neg_inv NUMBER (1);
14 g_org_locator_control NUMBER;
15 /* GMD related org parameters */
16 g_plant_ind NUMBER (1);
17 g_lab_ind NUMBER (1);
18 g_yield_type VARCHAR2 (10);
19 g_release_type NUMBER (5);
20 g_byprod_active NUMBER (1);
21 g_mass_um_type VARCHAR2(10);
22 g_volume_um_type VARCHAR2(10);
23 /* GME related org parameters */
24 g_auto_consume_supply_sub_only NUMBER (1);
25 g_subinv_loc_ind NUMBER (1); --Bug#5663458
26 g_supply_subinventory VARCHAR2 (10);
27 g_supply_locator_id NUMBER (10);
28 g_yield_subinventory VARCHAR2 (10);
29 g_yield_locator_id NUMBER (10);
30 g_delete_material_ind NUMBER (1);
31 g_validate_plan_dates_ind NUMBER (1);
32 --Bug#5111078
33 g_ib_factor_ind NUMBER (1);
34 g_display_unconsumed_material NUMBER (1);
35 g_step_controls_batch_sts_ind NUMBER (1);
36 g_backflush_rsrc_usg_ind NUMBER (1);
37 g_def_actual_rsrc_usg_ind NUMBER (1);
38 g_calc_interim_rsrc_usg_ind NUMBER (1);
39 g_allow_qty_below_min_ind NUMBER (1);
40 g_display_non_work_days_ind NUMBER (1);
41 g_check_shortages_ind NUMBER (1);
42 g_copy_formula_text_ind NUMBER (1);
43 g_copy_routing_text_ind NUMBER (1);
44 g_create_high_level_resv_ind NUMBER (1);
45 g_create_move_orders_ind NUMBER (1);
46 g_reservation_timefence NUMBER (5);
47 g_move_order_timefence NUMBER (5);
48 g_batch_doc_numbering NUMBER (1);
49 g_batch_no_last_assigned NUMBER (32);
50 g_fpo_doc_numbering NUMBER (1);
51 g_fpo_no_last_assigned NUMBER (32);
52 g_rule_based_resv_horizon NUMBER (5);
53 --nsinghi bug#5674398 Added the global variable for ingr subs date type
54 g_ingr_sub_date NUMBER (1);
55
56 /* Global Variables */
57 g_max_errors CONSTANT NUMBER := 100;
58 g_exceptions_err CONSTANT VARCHAR2 (1) := 'X';
59 g_inv_short_err CONSTANT VARCHAR2 (1) := 'V';
60 g_not_transactable CONSTANT VARCHAR2 (1) := 'T';
61 g_setup_done BOOLEAN := FALSE;
62 g_timestamp DATE;
63 g_transaction_header_id NUMBER;
64 g_error_count NUMBER;
65 g_batch_scale_factor NUMBER;
66 g_routing_scale_factor NUMBER;
67 g_doc_type_batch CONSTANT NUMBER := 0;
68 g_doc_type_fpo CONSTANT NUMBER := 10;
69 g_line_type_ing CONSTANT NUMBER := -1;
70 g_line_type_prod CONSTANT NUMBER := 1;
71 g_line_type_byprod CONSTANT NUMBER := 2;
72 g_hour_uom_code VARCHAR2 (3);
73 g_precision CONSTANT NUMBER := 5;
74 g_pairs_reversal_type CONSTANT NUMBER := 1;
75 g_pairs_phantom_type CONSTANT NUMBER := 2;
76 g_check_primary_rsrc NUMBER := 0;
77 g_flex_validate_prof NUMBER := 0;
78 /* Transaction types for GME */
79 g_txn_source_type CONSTANT NUMBER := 5;
80 g_ing_issue CONSTANT NUMBER := 35;
81 g_ing_return CONSTANT NUMBER := 43;
82 g_prod_completion CONSTANT NUMBER := 44;
83 g_prod_return CONSTANT NUMBER := 17;
84 g_byprod_completion CONSTANT NUMBER := 1002;
85 g_byprod_return CONSTANT NUMBER := 1003;
86 /* Transaction actions */
87 g_ing_issue_txn_action CONSTANT NUMBER := 1;
88 g_ing_ret_txn_action CONSTANT NUMBER := 27;
89 g_prod_comp_txn_action CONSTANT NUMBER := 31;
90 g_prod_ret_txn_action CONSTANT NUMBER := 32;
91 g_byprod_comp_txn_action CONSTANT NUMBER := 31;
92 g_byprod_ret_txn_action CONSTANT NUMBER := 32;
93 g_move_to_temp VARCHAR2 (1) := fnd_api.g_true;
94 g_batch_status_check VARCHAR2 (1) := fnd_api.g_true;
95 g_temp_table CONSTANT NUMBER := 2;
96 g_interface_table CONSTANT NUMBER := 1;
97 /* Wip Entity Types for GME */
98 g_wip_entity_type_batch CONSTANT NUMBER := 10;
99 g_wip_entity_type_fpo CONSTANT NUMBER := 9;
100 /* Tree modes */
101 g_tree_reservation_mode CONSTANT NUMBER := 1;
102 g_tree_transaction_mode CONSTANT NUMBER := 2;
103 /* Move Order Types for GME */
104 g_move_order_type CONSTANT NUMBER := 5;
105 g_invis_move_order_type CONSTANT NUMBER := 8;
106 g_backflush_transfer CONSTANT NUMBER := 51;
107 /* Batch Status */
108 g_batch_pending CONSTANT NUMBER := 1;
109 g_batch_wip CONSTANT NUMBER := 2;
110 g_batch_completed CONSTANT NUMBER := 3;
111 g_batch_closed CONSTANT NUMBER := 4;
112 g_batch_cancelled CONSTANT NUMBER := -1;
113 /* Step Status */
114 g_step_pending CONSTANT NUMBER := 1;
115 g_step_wip CONSTANT NUMBER := 2;
116 g_step_completed CONSTANT NUMBER := 3;
117 g_step_closed CONSTANT NUMBER := 4;
118 g_step_cancelled CONSTANT NUMBER := 5;
119 /* Material release type */
120 g_mtl_auto_release CONSTANT NUMBER := 0;
121 g_mtl_manual_release CONSTANT NUMBER := 1;
122 g_mtl_incremental_release CONSTANT NUMBER := 2;
123 g_mtl_autobystep_release CONSTANT NUMBER := 3;
124 /* Step release types */
125 g_auto_step_release CONSTANT NUMBER := 2;
126 g_manual_step_release CONSTANT NUMBER := 1;
127 /* Document numbering */
128 g_auto_doc_numbering CONSTANT NUMBER := 2;
129 g_manual_doc_numbering CONSTANT NUMBER := 1;
130 /* Phantom definitions */
131 g_auto_phantom CONSTANT NUMBER := 1;
132 g_manual_phantom CONSTANT NUMBER := 2;
133 /* Step dependency types */
134 g_dep_type_finish_start CONSTANT NUMBER := 0;
135 g_dep_type_start_start CONSTANT NUMBER := 1;
136
137 /* Bug 5763818 - Added eres constants */
138 g_batch_created CONSTANT VARCHAR2(50) := 'oracle.apps.gme.batch.created';
139 g_batch_reservations CONSTANT VARCHAR2(50) := 'oracle.apps.gme.batch.reservations';
140
141 g_batchmtl_added CONSTANT VARCHAR2(50) := 'oracle.apps.gme.batchmtl.added';
142 g_batchmtl_updated CONSTANT VARCHAR2(50) := 'oracle.apps.gme.batchmtl.updated';
143 g_batchmtl_removed CONSTANT VARCHAR2(50) := 'oracle.apps.gme.batchmtl.removed';
144
145 g_batchstep_created CONSTANT VARCHAR2(50) := 'oracle.apps.gme.batchstep.created';
146 g_batchstep_removed CONSTANT VARCHAR2(50) := 'oracle.apps.gme.batchstep.removed';
147 g_batchstep_added CONSTANT VARCHAR2(50) := 'oracle.apps.gme.batchstep.added';
148 g_batchstep_update CONSTANT VARCHAR2(50) := 'oracle.apps.gme.batchstep.update';
149
150 g_resource_added CONSTANT VARCHAR2(50) := 'oracle.apps.gme.resource.added';
151 g_resource_removed CONSTANT VARCHAR2(50) := 'oracle.apps.gme.resource.removed';
152 g_resource_update CONSTANT VARCHAR2(50) := 'oracle.apps.gme.resource.update';
153
154 g_activity_added CONSTANT VARCHAR2(50) := 'oracle.apps.gme.activity.added';
155 g_activity_removed CONSTANT VARCHAR2(50) := 'oracle.apps.gme.activity.removed';
156 g_activity_updated CONSTANT VARCHAR2(50) := 'oracle.apps.gme.activity.updated';
157
158 g_bstep_rel_wf CONSTANT VARCHAR2(50) := 'oracle.apps.gme.bstep.rel.wf';
159
160 /* GME row and table types */
161 TYPE p_field IS RECORD (
162 p_value VARCHAR2 (50)
163 );
164
165 -- nsinghi bug#5176319.
166 /* Material Transaction Header ID table for all materials within a batch.
167 This table has been created to store the transaction_ids and corresponding material_detail_ids used during
168 unrelease_batch and unrelease_step. The issue was, during unrelease, the onhands should get updated first and
169 then reservations should be recreated. To do this, it was required to have a pl/sql table that stores transaction_ids
170 and the material for which the reservation had to be created. Hence g_mat_txn_hdr_tbl has been created for the same.
171 */
172 TYPE mat_txn_id_rec IS RECORD (
173 txn_header_id NUMBER,
174 material_dtl_id NUMBER
175 );
176 TYPE txn_hdr_tab IS TABLE OF mat_txn_id_rec INDEX BY BINARY_INTEGER;
177 g_mat_txn_hdr_tbl txn_hdr_tab;
178 -- g_txn_hdr_tbl_cnt NUMBER; -- nsinghi bug#5176319.
179
180 TYPE field_values_tab IS TABLE OF p_field
181 INDEX BY BINARY_INTEGER;
182
183 TYPE batch_headers_tab IS TABLE OF gme_batch_header%ROWTYPE
184 INDEX BY BINARY_INTEGER;
185
186 TYPE material_details_tab IS TABLE OF gme_material_details%ROWTYPE
187 INDEX BY BINARY_INTEGER;
188
189 TYPE steps_tab IS TABLE OF gme_batch_steps%ROWTYPE
190 INDEX BY BINARY_INTEGER;
191
192 TYPE resource_txns_tab IS TABLE OF gme_resource_txns_gtmp%ROWTYPE
193 INDEX BY BINARY_INTEGER;
194
195 TYPE resources_tab IS TABLE OF gme_batch_step_resources%ROWTYPE
196 INDEX BY BINARY_INTEGER;
197
198 TYPE activities_tab IS TABLE OF gme_batch_step_activities%ROWTYPE
199 INDEX BY BINARY_INTEGER;
200
201 TYPE item_masters_tab IS TABLE OF mtl_system_items_kfv%ROWTYPE
202 INDEX BY BINARY_INTEGER;
203
204 TYPE exceptions_tab IS TABLE OF gme_exceptions_gtmp%ROWTYPE
205 INDEX BY BINARY_INTEGER;
206
207 TYPE recipe_validity_rule_tab IS TABLE OF gmd_recipe_validity_rules%ROWTYPE
208 INDEX BY BINARY_INTEGER;
209
210 TYPE mtl_trans_lots_inter_tbl IS TABLE OF mtl_transaction_lots_interface%ROWTYPE
211 INDEX BY BINARY_INTEGER;
212
213 TYPE mtl_trans_lots_num_tbl IS TABLE OF mtl_transaction_lot_numbers%ROWTYPE
214 INDEX BY BINARY_INTEGER;
215
216 TYPE mtl_mat_tran_tbl IS TABLE OF mtl_material_transactions%ROWTYPE
217 INDEX BY BINARY_INTEGER;
218
219 TYPE mtl_tran_int_tbl IS TABLE OF mtl_transactions_interface%ROWTYPE
220 INDEX BY BINARY_INTEGER;
221
222 TYPE reservations_tab IS TABLE OF mtl_reservations%ROWTYPE
223 INDEX BY BINARY_INTEGER;
224
225 TYPE mo_lines_tab IS TABLE OF mtl_txn_request_lines%ROWTYPE
226 INDEX BY BINARY_INTEGER;
227
228 TYPE resource_transactions_tab IS TABLE OF gme_resource_txns_gtmp%ROWTYPE
229 INDEX BY BINARY_INTEGER;
230
231 TYPE pending_lots_tab IS TABLE OF gme_pending_product_lots%ROWTYPE
232 INDEX BY BINARY_INTEGER;
233
234 TYPE text_tab IS TABLE OF gme_text_table%ROWTYPE
235 INDEX BY BINARY_INTEGER;
236
237 TYPE number_tab IS TABLE OF NUMBER
238 INDEX BY BINARY_INTEGER;
239
240 --Buffers for recipe upload
241 routings gmd_recipe_fetch_pub.recipe_rout_tbl;
242 routing_materials gmd_recipe_fetch_pub.recipe_rout_matl_tbl;
243 steps gmd_recipe_fetch_pub.recipe_step_tbl;
244 step_dependencies gmd_recipe_fetch_pub.routing_depd_tbl;
245 activities gmd_recipe_fetch_pub.oprn_act_tbl;
246 resources gmd_recipe_fetch_pub.oprn_resc_tbl;
247 materials gmdfmval_pub.formula_detail_tbl;
248 process_parameters gmd_recipe_fetch_pub.recp_resc_proc_param_tbl;
249
250 PROCEDURE log_message (
251 p_message_code IN VARCHAR2
252 ,p_token1_name IN VARCHAR2 := NULL
253 ,p_token1_value IN VARCHAR2 := NULL
254 ,p_token2_name IN VARCHAR2 := NULL
255 ,p_token2_value IN VARCHAR2 := NULL
256 ,p_token3_name IN VARCHAR2 := NULL
257 ,p_token3_value IN VARCHAR2 := NULL
258 ,p_token4_name IN VARCHAR2 := NULL
259 ,p_token4_value IN VARCHAR2 := NULL
260 ,p_token5_name IN VARCHAR2 := NULL
261 ,p_token5_value IN VARCHAR2 := NULL
262 --FPBug#4351032 Added new token and value
263 ,p_token6_name IN VARCHAR2 := NULL
264 ,p_token6_value IN VARCHAR2 := NULL
265 ,p_product_code IN VARCHAR2 := 'GME');
266
267 FUNCTION setup (p_org_id IN NUMBER := NULL, p_org_code IN VARCHAR2 := NULL)
268 RETURN BOOLEAN;
269
270 PROCEDURE set_timestamp;
271
272 PROCEDURE set_who;
273
274 PROCEDURE set_txn_header_id(p_txn_header_id NUMBER);
275
276 PROCEDURE reset_txn_header_id;
277
278 PROCEDURE reset_txn_hdr_tbl; --nsinghi bug#5176319.
279
280 FUNCTION get_txn_header_id
281 RETURN NUMBER;
282
283 PROCEDURE set_move_to_temp_off;
284
285 FUNCTION get_timestamp
286 RETURN DATE;
287
288 PROCEDURE count_and_get (
289 p_encoded IN VARCHAR2 := 'T'
290 ,x_count OUT NOCOPY NUMBER
291 ,x_data OUT NOCOPY VARCHAR2);
292
293 PROCEDURE get_who (
294 x_user_ident OUT NOCOPY NUMBER
295 ,x_login_id OUT NOCOPY NUMBER
296 ,x_timestamp OUT NOCOPY DATE
297 ,x_return_status OUT NOCOPY VARCHAR2);
298
299 PROCEDURE get_supply_defaults (
300 p_organization_id IN NUMBER
301 ,p_inventory_item_id IN NUMBER
302 ,x_subinventory OUT NOCOPY VARCHAR2
303 ,x_locator_id OUT NOCOPY NUMBER
304 ,x_return_status OUT NOCOPY VARCHAR2);
305
306 PROCEDURE get_yield_defaults (
307 p_organization_id IN NUMBER
308 ,p_inventory_item_id IN NUMBER
309 ,p_line_type IN NUMBER
310 ,x_subinventory OUT NOCOPY VARCHAR2
311 ,x_locator_id OUT NOCOPY NUMBER
312 ,x_return_status OUT NOCOPY VARCHAR2);
313
314 PROCEDURE construct_material_detail (
315 p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
316 ,p_item_master_rec IN mtl_system_items_kfv%ROWTYPE
317 ,p_batch_header_rec IN gme_batch_header%ROWTYPE
318 ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
319 ,x_return_status OUT NOCOPY VARCHAR2);
320
321 FUNCTION get_process_loss (
322 p_batch_id IN NUMBER DEFAULT NULL
323 ,p_validity_rule_id IN NUMBER DEFAULT NULL
324 ,p_organization_id IN NUMBER DEFAULT NULL
325 ,p_total_output_qty_scaled IN NUMBER
326 ,p_total_output_qty_pre_scale IN NUMBER)
327 RETURN NUMBER;
328
329 PROCEDURE create_document_no (
330 p_batch_header_rec IN gme_batch_header%ROWTYPE
331 ,x_batch_header_rec IN OUT NOCOPY gme_batch_header%ROWTYPE);
332
333 FUNCTION calc_date_from_prod_rule (
334 p_organization_id IN NUMBER
335 ,p_inventory_item_id IN NUMBER
336 ,p_item_qty IN NUMBER
337 ,p_start_date IN DATE
338 ,p_cmplt_date IN DATE
339 ,x_start_date IN OUT NOCOPY DATE
340 ,x_cmplt_date IN OUT NOCOPY DATE)
341 RETURN BOOLEAN;
342
343 PROCEDURE calc_mtl_req_date (
344 p_batch_header_rec IN gme_batch_header%ROWTYPE
345 DEFAULT NULL
346 ,p_batchstep_rec IN gme_batch_steps%ROWTYPE
347 DEFAULT NULL
348 ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE
349 ,x_mtl_req_date OUT NOCOPY DATE
350 ,x_return_status OUT NOCOPY VARCHAR2);
351
352 FUNCTION is_qty_below_capacity (
353 p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE)
354 RETURN BOOLEAN;
355
356 FUNCTION resource_qty_below_capacity (p_batch_id IN NUMBER)
357 RETURN BOOLEAN;
358
359 FUNCTION eff_locator_control (
360 p_organization_id IN NUMBER
361 ,p_subinventory IN VARCHAR2 DEFAULT NULL
362 ,p_inventory_item_id IN NUMBER DEFAULT NULL
363 ,p_org_control IN NUMBER DEFAULT NULL
364 ,p_sub_control IN NUMBER DEFAULT NULL
365 ,p_item_control IN NUMBER DEFAULT NULL
366 ,p_item_loc_restrict IN NUMBER DEFAULT NULL
367 ,p_org_neg_allowed IN NUMBER DEFAULT NULL
368 ,p_action IN NUMBER)
369 RETURN NUMBER;
370
371 FUNCTION check_locator (
372 p_organization_id IN NUMBER
373 ,p_locator_id IN NUMBER
374 ,p_subinventory IN VARCHAR2
375 ,p_inventory_item_id IN NUMBER
376 ,p_org_control IN NUMBER
377 ,p_sub_control IN NUMBER
378 ,p_item_control IN NUMBER
379 ,p_item_loc_restrict IN NUMBER
380 ,p_org_neg_allowed IN NUMBER
381 ,p_txn_action_id IN NUMBER)
382 RETURN BOOLEAN;
383
384 FUNCTION check_subinventory (
385 p_organization_id IN NUMBER
386 ,p_subinventory IN VARCHAR2
387 ,p_inventory_item_id IN NUMBER
388 ,p_restrict_subinv IN NUMBER DEFAULT NULL)
389 RETURN BOOLEAN;
390
391 FUNCTION validate_validity_rule (
392 p_validity_rule_id IN NUMBER
393 ,p_organization_id IN NUMBER
394 ,p_prim_product_id IN NUMBER
395 ,p_qty IN NUMBER
396 ,p_uom IN VARCHAR2
397 ,p_object_type IN VARCHAR2
398 ,p_start_date IN DATE
399 ,p_cmplt_date IN DATE
400 ,p_creation_mode IN VARCHAR2 DEFAULT NULL)
401 RETURN BOOLEAN;
402
403 PROCEDURE get_batch_shortages (
404 p_organization_id IN NUMBER
405 ,p_batch_id IN NUMBER
406 ,p_invoke_mode IN VARCHAR2
407 ,p_tree_mode IN NUMBER
408 ,x_return_status OUT NOCOPY VARCHAR2
409 ,x_exception_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
410
411 PROCEDURE get_open_qty (
412 p_mtl_dtl_rec IN gme_material_details%ROWTYPE
413 ,p_called_by IN VARCHAR2
414 , /* P- picking, R-reservation, S-shortages */
415 p_item_location_control IN NUMBER DEFAULT NULL
416 ,p_item_restrict_locators IN NUMBER DEFAULT NULL
417 ,x_open_qty OUT NOCOPY NUMBER
418 ,x_return_status OUT NOCOPY VARCHAR2);
419
420 FUNCTION insert_exceptions (p_exception_rec IN gme_exceptions_gtmp%ROWTYPE)
421 RETURN BOOLEAN;
422
423 FUNCTION populate_temp_from_struct (
424 p_exception_tbl IN gme_common_pvt.exceptions_tab)
425 RETURN BOOLEAN;
426
427 FUNCTION is_material_assoc_to_step (
428 p_material_detail_id IN gme_material_details.material_detail_id%TYPE)
429 RETURN BOOLEAN;
430
431 FUNCTION get_batch_header (
432 p_batch_header_rec IN gme_batch_header%ROWTYPE
433 ,p_org_code IN VARCHAR2
434 ,p_batch_type IN NUMBER
435 ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
436 RETURN BOOLEAN;
437
438 FUNCTION get_batch_step (
439 p_batch_step_rec IN gme_batch_steps%ROWTYPE
440 ,p_org_code IN VARCHAR2
441 ,p_batch_no IN VARCHAR2
442 ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
443 ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
444 RETURN BOOLEAN;
445
446 FUNCTION create_history (
447 p_batch_header_rec IN gme_batch_header%ROWTYPE
448 ,p_original_status IN NUMBER
449 ,p_event_id IN NUMBER DEFAULT NULL)
450 RETURN BOOLEAN;
451
452 FUNCTION close_period_check_flexible (
453 p_org_id IN NUMBER
454 ,p_trans_date IN DATE
455 ,x_trans_date OUT NOCOPY DATE
456 ,x_period_id OUT NOCOPY INTEGER)
457 RETURN BOOLEAN;
458
459 FUNCTION get_batchstep_rsrc (
460 p_batchstep_rsrc_rec IN gme_batch_step_resources%ROWTYPE
461 ,p_org_code IN VARCHAR2
462 ,p_batch_no IN VARCHAR2
463 ,p_batchstep_no IN NUMBER
464 ,p_activity IN VARCHAR2
465 ,p_resource IN VARCHAR2
466 ,x_batchstep_rsrc_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE)
467 RETURN BOOLEAN;
468
469 FUNCTION check_validity_rule_dates (
470 p_validity_rule_id IN NUMBER
471 ,p_start_date IN DATE
472 ,p_cmplt_date IN DATE
473 ,p_batch_header_rec IN gme_batch_header%ROWTYPE DEFAULT NULL
474 --Sunitha Ch. Bug 5336007 added the parameter p_validate_plan_dates_ind that indicates whether to validate
475 --value -0 Validate Only start date
476 --Value -1 Validate Both the dates
477 ,p_validate_plan_dates_ind IN NUMBER DEFAULT 0)
478 RETURN BOOLEAN;
479 /*B6408612 --Added function for checking the operation efffectivity dates */
480 FUNCTION check_oprn_effectivity_dates (
481 p_oprn_id IN NUMBER
482 ,p_start_date IN DATE
483 ,p_cmplt_date IN DATE
484
485 )
486 RETURN BOOLEAN;
487
488 PROCEDURE material_date_change (
489 p_material_detail_id IN NUMBER
490 ,p_material_date IN DATE
491 ,x_return_status OUT NOCOPY VARCHAR2);
492
493 FUNCTION is_material_auto_release (
494 p_line_id IN gme_material_details.material_detail_id%TYPE)
495 RETURN NUMBER;
496
497 FUNCTION get_assoc_step (
498 p_material_detail_id IN gme_material_details.material_detail_id%TYPE
499 ,x_batchstep_id OUT NOCOPY NUMBER
500 ,x_batchstep_status OUT NOCOPY NUMBER)
501 RETURN BOOLEAN;
502
503 FUNCTION get_material_detail (
504 p_material_detail_rec IN gme_material_details%ROWTYPE
505 ,p_org_code IN VARCHAR2
506 ,p_batch_no IN VARCHAR2
507 ,p_batch_type IN NUMBER
508 ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
509 ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
510 RETURN BOOLEAN;
511 -- Pawan Kumar Added for bug 5138929
512 FUNCTION check_close_period (
513 p_org_id IN NUMBER
514 ,p_trans_date IN DATE)
515 RETURN BOOLEAN;
516 Procedure Validate_batch (
517 p_batch_header_rec IN gme_batch_header%ROWTYPE
518 ,p_org_code IN VARCHAR2
519 ,p_batch_type IN NUMBER
520 ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
521 ,x_message_count OUT NOCOPY NUMBER
522 ,x_message_list OUT NOCOPY VARCHAR2
523 ,x_return_status OUT NOCOPY VARCHAR2);
524
525 Procedure Validate_material_detail (
526 p_material_detail_rec IN gme_material_details%ROWTYPE
527 ,p_org_code IN VARCHAR2
528 ,p_batch_no IN VARCHAR2
529 ,p_batch_type IN NUMBER
530 ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
531 ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
532 ,x_message_count OUT NOCOPY NUMBER
533 ,x_message_list OUT NOCOPY VARCHAR2
534 ,x_return_status OUT NOCOPY VARCHAR2);
535 Procedure Validate_batch_step (
536 p_batch_step_rec IN gme_batch_steps%ROWTYPE
537 ,p_org_code IN VARCHAR2
538 ,p_batch_no IN VARCHAR2
539 ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
540 ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
541 ,x_message_count OUT NOCOPY NUMBER
542 ,x_message_list OUT NOCOPY VARCHAR2
543 ,x_return_status OUT NOCOPY VARCHAR2);
544
545 --Bug#5394232 to default transaction date
546 PROCEDURE fetch_trans_date (
547 p_material_detail_id IN NUMBER
548 ,p_invoke_mode IN VARCHAR2 DEFAULT 'T'
549 ,x_trans_date OUT NOCOPY DATE
550 ,x_return_status OUT NOCOPY VARCHAR2);
551
552 END gme_common_pvt;