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