DBA Data[Home] [Help]

APPS.GME_REROUTE_BATCH_PVT dependencies on GME_BATCH_HEADER

Line 31: p_batch_header_rec IN gme_batch_header%ROWTYPE

27: Sunitha ch Bug#5391396 included the code to rescedule_step of the child batch when the product
28: is associated to step and its release type is autobystep.
29: =============================================================================================*/
30: PROCEDURE reroute_batch (
31: p_batch_header_rec IN gme_batch_header%ROWTYPE
32: ,p_validity_rule_id IN NUMBER
33: ,p_use_workday_cal IN VARCHAR2
34: DEFAULT fnd_api.g_false
35: ,p_contiguity_override IN VARCHAR2

Line 37: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

33: ,p_use_workday_cal IN VARCHAR2
34: DEFAULT fnd_api.g_false
35: ,p_contiguity_override IN VARCHAR2
36: DEFAULT fnd_api.g_false
37: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
38: ,x_return_status OUT NOCOPY VARCHAR2)
39: IS
40: l_api_name CONSTANT VARCHAR2 (30) := 'REROUTE_BATCH';
41: l_formula_master fm_form_mst%ROWTYPE;

Line 85: l_phantom_batch_header_rec gme_batch_header%ROWTYPE;

81: l_total_output_qty_b NUMBER;
82: l_total_output_qty_c NUMBER;
83: l_phantom_ids_tab gme_common_pvt.number_tab;
84: l_phantom_associated_to_step BOOLEAN;
85: l_phantom_batch_header_rec gme_batch_header%ROWTYPE;
86: l_phantom_batch_header_rec_out gme_batch_header%ROWTYPE;
87: no_continous_periods EXCEPTION;
88: l_no_steps BOOLEAN := FALSE;
89: l_inventory_item_id pls_integer;

Line 86: l_phantom_batch_header_rec_out gme_batch_header%ROWTYPE;

82: l_total_output_qty_c NUMBER;
83: l_phantom_ids_tab gme_common_pvt.number_tab;
84: l_phantom_associated_to_step BOOLEAN;
85: l_phantom_batch_header_rec gme_batch_header%ROWTYPE;
86: l_phantom_batch_header_rec_out gme_batch_header%ROWTYPE;
87: no_continous_periods EXCEPTION;
88: l_no_steps BOOLEAN := FALSE;
89: l_inventory_item_id pls_integer;
90: l_prim_item_um mtl_units_of_measure.uom_code%TYPE;

Line 322: ,p_gme_batch_header_rec => x_batch_header_rec

318: ,p_recipe_rout_resc_tbl => gme_common_pvt.resources
319: ,p_resc_parameters_tbl => l_process_parameters_tab
320: ,p_recipe_rout_matl_tbl => gme_common_pvt.routing_materials
321: ,p_routing_depd_tbl => gme_common_pvt.step_dependencies
322: ,p_gme_batch_header_rec => x_batch_header_rec
323: ,p_use_workday_cal => p_use_workday_cal
324: ,p_contiguity_override => p_contiguity_override
325: ,x_return_status => x_return_status);
326:

Line 587: IF NOT gme_batch_header_dbl.update_row (x_batch_header_rec) THEN

583: IF x_batch_header_rec.FINITE_SCHEDULED_IND = 1 THEN
584: x_batch_header_rec.FINITE_SCHEDULED_IND := 0;
585: END IF;
586: -- Bug#5359091 end.
587: IF NOT gme_batch_header_dbl.update_row (x_batch_header_rec) THEN
588: RAISE fnd_api.g_exc_error;
589: END IF;
590:
591: IF (NVL (g_debug, 0) IN

Line 730: p_batch_header_rec IN gme_batch_header%ROWTYPE

726: END IF;
727: END delete_all_steps;
728:
729: PROCEDURE validate_validity_id_from_pub (
730: p_batch_header_rec IN gme_batch_header%ROWTYPE
731: ,p_validity_rule_id IN NUMBER
732: ,x_return_status OUT NOCOPY VARCHAR2)
733: IS
734: l_api_name CONSTANT VARCHAR2 (30) := 'validate_validity_id_from_pub';

Line 870: p_batch_header_rec IN gme_batch_header%ROWTYPE

866: p_validity_rule_id The validity_rule
867:
868: =============================================================================================*/
869: PROCEDURE validate_validity_id (
870: p_batch_header_rec IN gme_batch_header%ROWTYPE
871: ,p_validity_rule_id IN NUMBER
872: ,x_return_status OUT NOCOPY VARCHAR2)
873: IS
874: l_api_name CONSTANT VARCHAR2 (30) := 'validate_validity_id';