APPS.GME_CREATE_BATCH_PVT dependencies on GME_BATCH_STEPS

Line 249: l_batchstep_rec gme_batch_steps%ROWTYPE;

245: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
246: l_phantom_exc_material_tbl gme_common_pvt.exceptions_tab; -- nsinghi bug#5200395
247: l_phantom_exc_material_tbl_out gme_common_pvt.exceptions_tab; -- nsinghi bug#5200395
248: l_batch_header_rec gme_batch_header%ROWTYPE;
249: l_batchstep_rec gme_batch_steps%ROWTYPE;
250: x_batchstep_rec gme_batch_steps%ROWTYPE;
251: l_in_material_detail gme_material_details%ROWTYPE;
252: l_item_substituted BOOLEAN;
253: l_curr_item_substituted BOOLEAN;

Line 250: x_batchstep_rec gme_batch_steps%ROWTYPE;

246: l_phantom_exc_material_tbl gme_common_pvt.exceptions_tab; -- nsinghi bug#5200395
247: l_phantom_exc_material_tbl_out gme_common_pvt.exceptions_tab; -- nsinghi bug#5200395
248: l_batch_header_rec gme_batch_header%ROWTYPE;
249: l_batchstep_rec gme_batch_steps%ROWTYPE;
250: x_batchstep_rec gme_batch_steps%ROWTYPE;
251: l_in_material_detail gme_material_details%ROWTYPE;
252: l_item_substituted BOOLEAN;
253: l_curr_item_substituted BOOLEAN;
254: l_ingred_req_date DATE;

Line 383: FROM gme_batch_step_items a, gme_batch_steps b

379:
380: -- nsinghi bug#5674398 Added the Cursor
381: CURSOR c_batchsteps (p_material_detail_id IN NUMBER) IS
382: SELECT b.*
383: FROM gme_batch_step_items a, gme_batch_steps b
384: WHERE a.batchstep_id = b.batchstep_id AND a.material_detail_id = p_material_detail_id;
385:
386: error_count_exceeded EXCEPTION;
387: expected_error EXCEPTION;

Line 2613: l_batch_steps gme_batch_steps%ROWTYPE;

2609:
2610: FUNCTION update_step_mtq (p_batch_id IN NUMBER)
2611: RETURN BOOLEAN IS
2612:
2613: l_batch_steps gme_batch_steps%ROWTYPE;
2614: l_calculated_mtq gme_batch_steps.minimum_transfer_qty%TYPE;
2615: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_STEP_MTQ';
2616:
2617: CURSOR step_mtq_cursor (x_batch_id gme_batch_header.batch_id%TYPE) IS

Line 2614: l_calculated_mtq gme_batch_steps.minimum_transfer_qty%TYPE;

2610: FUNCTION update_step_mtq (p_batch_id IN NUMBER)
2611: RETURN BOOLEAN IS
2612:
2613: l_batch_steps gme_batch_steps%ROWTYPE;
2614: l_calculated_mtq gme_batch_steps.minimum_transfer_qty%TYPE;
2615: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_STEP_MTQ';
2616:
2617: CURSOR step_mtq_cursor (x_batch_id gme_batch_header.batch_id%TYPE) IS
2618: SELECT *

Line 2619: FROM gme_batch_steps

2615: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_STEP_MTQ';
2616:
2617: CURSOR step_mtq_cursor (x_batch_id gme_batch_header.batch_id%TYPE) IS
2618: SELECT *
2619: FROM gme_batch_steps
2620: WHERE batch_id = x_batch_id ;
2621:
2622: CURSOR calculate_mtq_cursor (x_batch_id gme_batch_header.batch_id%TYPE,
2623: x_routingstep_id fm_rout_dtl.routingstep_id%TYPE) IS

Line 2677: UPDATE gme_batch_steps

2673: OPEN calculate_mtq_cursor (p_batch_id, l_batch_steps.routingstep_id);
2674: FETCH calculate_mtq_cursor INTO l_calculated_mtq ;
2675: CLOSE calculate_mtq_cursor ;
2676:
2677: UPDATE gme_batch_steps
2678: SET minimum_transfer_qty = l_calculated_mtq
2679: WHERE batch_id = l_batch_steps.batch_id
2680: AND routingstep_id = l_batch_steps.routingstep_id
2681: AND batchstep_id = l_batch_steps.batchstep_id ;