eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_CREATE_BATCH_PVT dependencies on GME_BATCH_STEPS

Line 322: l_batchstep_rec gme_batch_steps%ROWTYPE;

318: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
319: l_phantom_exc_material_tbl gme_common_pvt.exceptions_tab; -- nsinghi bug#5200395
320: l_phantom_exc_material_tbl_out gme_common_pvt.exceptions_tab; -- nsinghi bug#5200395
321: l_batch_header_rec gme_batch_header%ROWTYPE;
322: l_batchstep_rec gme_batch_steps%ROWTYPE;
323: x_batchstep_rec gme_batch_steps%ROWTYPE;
324: l_in_material_detail gme_material_details%ROWTYPE;
325: l_item_substituted BOOLEAN;
326: l_curr_item_substituted BOOLEAN;

Line 323: x_batchstep_rec gme_batch_steps%ROWTYPE;

319: l_phantom_exc_material_tbl gme_common_pvt.exceptions_tab; -- nsinghi bug#5200395
320: l_phantom_exc_material_tbl_out gme_common_pvt.exceptions_tab; -- nsinghi bug#5200395
321: l_batch_header_rec gme_batch_header%ROWTYPE;
322: l_batchstep_rec gme_batch_steps%ROWTYPE;
323: x_batchstep_rec gme_batch_steps%ROWTYPE;
324: l_in_material_detail gme_material_details%ROWTYPE;
325: l_item_substituted BOOLEAN;
326: l_curr_item_substituted BOOLEAN;
327: l_ingred_req_date DATE;

Line 511: FROM gme_batch_step_items a, gme_batch_steps b

507:
508: -- nsinghi bug#5674398 Added the Cursor
509: CURSOR c_batchsteps (p_material_detail_id IN NUMBER) IS
510: SELECT b.*
511: FROM gme_batch_step_items a, gme_batch_steps b
512: WHERE a.batchstep_id = b.batchstep_id AND a.material_detail_id = p_material_detail_id;
513:
514: error_count_exceeded EXCEPTION;
515: expected_error EXCEPTION;

Line 2908: l_batch_steps gme_batch_steps%ROWTYPE;

2904:
2905: FUNCTION update_step_mtq (p_batch_id IN NUMBER)
2906: RETURN BOOLEAN IS
2907:
2908: l_batch_steps gme_batch_steps%ROWTYPE;
2909: l_calculated_mtq gme_batch_steps.minimum_transfer_qty%TYPE;
2910: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_STEP_MTQ';
2911:
2912: l_numerator NUMBER;

Line 2909: l_calculated_mtq gme_batch_steps.minimum_transfer_qty%TYPE;

2905: FUNCTION update_step_mtq (p_batch_id IN NUMBER)
2906: RETURN BOOLEAN IS
2907:
2908: l_batch_steps gme_batch_steps%ROWTYPE;
2909: l_calculated_mtq gme_batch_steps.minimum_transfer_qty%TYPE;
2910: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_STEP_MTQ';
2911:
2912: l_numerator NUMBER;
2913: l_total_output_qty NUMBER;

Line 2918: FROM gme_batch_steps

2914: l_step_qty NUMBER;
2915:
2916: CURSOR step_mtq_cursor (x_batch_id gme_batch_header.batch_id%TYPE) IS
2917: SELECT *
2918: FROM gme_batch_steps
2919: WHERE batch_id = x_batch_id ;
2920:
2921: CURSOR calculate_mtq_cursor (x_batch_id gme_batch_header.batch_id%TYPE,
2922: x_routingstep_id fm_rout_dtl.routingstep_id%TYPE) IS

Line 2996: UPDATE gme_batch_steps

2992:
2993: IF (l_step_qty * l_total_output_qty) > 0 THEN
2994: l_calculated_mtq := l_numerator / (l_step_qty * l_total_output_qty);
2995:
2996: UPDATE gme_batch_steps
2997: SET minimum_transfer_qty = l_calculated_mtq
2998: WHERE batch_id = l_batch_steps.batch_id
2999: AND routingstep_id = l_batch_steps.routingstep_id
3000: AND batchstep_id = l_batch_steps.batchstep_id ;