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_MOBILE_TXN dependencies on GME_BATCH_STEPS

Line 1553: FROM gme_batch_steps s,

1549: AND batch_id = p_batch_id;
1550:
1551: CURSOR cur_get_step_status IS
1552: SELECT s.batchstep_no
1553: FROM gme_batch_steps s,
1554: gme_batch_step_items i,
1555: gme_material_details m
1556: WHERE m.batch_id = p_batch_id
1557: AND s.batch_id = p_batch_id

Line 3612: l_batch_step gme_batch_steps%ROWTYPE;

3608: l_step_qty NUMBER;
3609: l_act_strt_dt DATE;
3610: l_act_complt_dt DATE;
3611: message VARCHAR2(2000);
3612: l_batch_step gme_batch_steps%ROWTYPE;
3613: l_batch_step_out gme_batch_steps%ROWTYPE;
3614: x_batch_step gme_batch_steps%ROWTYPE;
3615: l_batch_header gme_batch_header%ROWTYPE;
3616: x_exception_material gme_common_pvt.exceptions_tab;

Line 3613: l_batch_step_out gme_batch_steps%ROWTYPE;

3609: l_act_strt_dt DATE;
3610: l_act_complt_dt DATE;
3611: message VARCHAR2(2000);
3612: l_batch_step gme_batch_steps%ROWTYPE;
3613: l_batch_step_out gme_batch_steps%ROWTYPE;
3614: x_batch_step gme_batch_steps%ROWTYPE;
3615: l_batch_header gme_batch_header%ROWTYPE;
3616: x_exception_material gme_common_pvt.exceptions_tab;
3617: step_alloc_error EXCEPTION;

Line 3614: x_batch_step gme_batch_steps%ROWTYPE;

3610: l_act_complt_dt DATE;
3611: message VARCHAR2(2000);
3612: l_batch_step gme_batch_steps%ROWTYPE;
3613: l_batch_step_out gme_batch_steps%ROWTYPE;
3614: x_batch_step gme_batch_steps%ROWTYPE;
3615: l_batch_header gme_batch_header%ROWTYPE;
3616: x_exception_material gme_common_pvt.exceptions_tab;
3617: step_alloc_error EXCEPTION;
3618: expected_error EXCEPTION;

Line 3641: IF NOT (gme_batch_steps_dbl.fetch_row(l_batch_step, l_batch_step)) THEN

3637: RAISE expected_error;
3638: END IF;
3639: l_batch_step.batch_id := p_batch_id;
3640: l_batch_step.batchstep_id := p_step_id;
3641: IF NOT (gme_batch_steps_dbl.fetch_row(l_batch_step, l_batch_step)) THEN
3642: RAISE expected_error;
3643: END IF;
3644:
3645: l_batch_step.actual_step_qty := p_act_step_qty;

Line 3687: FROM gme_batch_steps

3683: END IF;
3684: IF x_return_status = 'S' THEN
3685: IF p_act_step_qty IS NOT NULL THEN
3686: SELECT actual_step_qty INTO l_step_qty
3687: FROM gme_batch_steps
3688: WHERE batch_id = p_batch_id
3689: AND batchstep_id = p_step_id;
3690: IF l_step_qty <> p_act_step_qty THEN /* Update Act Step Qty */
3691: UPDATE gme_batch_steps

Line 3691: UPDATE gme_batch_steps

3687: FROM gme_batch_steps
3688: WHERE batch_id = p_batch_id
3689: AND batchstep_id = p_step_id;
3690: IF l_step_qty <> p_act_step_qty THEN /* Update Act Step Qty */
3691: UPDATE gme_batch_steps
3692: SET actual_step_qty = p_act_step_qty
3693: WHERE batch_id = p_batch_id
3694: AND batchstep_id = p_step_id;
3695: END IF;

Line 3816: l_batch_step gme_batch_steps%ROWTYPE;

3812: l_count NUMBER;
3813: l_act_strt_dt DATE;
3814: message VARCHAR2(2000);
3815: l_api_name VARCHAR2(30) := 'release_step';
3816: l_batch_step gme_batch_steps%ROWTYPE;
3817: l_batch_step_out gme_batch_steps%ROWTYPE;
3818: x_batch_step gme_batch_steps%ROWTYPE;
3819: l_batch_hdr_rec gme_batch_header%ROWTYPE;
3820: x_exception_material gme_common_pvt.exceptions_tab;

Line 3817: l_batch_step_out gme_batch_steps%ROWTYPE;

3813: l_act_strt_dt DATE;
3814: message VARCHAR2(2000);
3815: l_api_name VARCHAR2(30) := 'release_step';
3816: l_batch_step gme_batch_steps%ROWTYPE;
3817: l_batch_step_out gme_batch_steps%ROWTYPE;
3818: x_batch_step gme_batch_steps%ROWTYPE;
3819: l_batch_hdr_rec gme_batch_header%ROWTYPE;
3820: x_exception_material gme_common_pvt.exceptions_tab;
3821: step_alloc_error EXCEPTION;

Line 3818: x_batch_step gme_batch_steps%ROWTYPE;

3814: message VARCHAR2(2000);
3815: l_api_name VARCHAR2(30) := 'release_step';
3816: l_batch_step gme_batch_steps%ROWTYPE;
3817: l_batch_step_out gme_batch_steps%ROWTYPE;
3818: x_batch_step gme_batch_steps%ROWTYPE;
3819: l_batch_hdr_rec gme_batch_header%ROWTYPE;
3820: x_exception_material gme_common_pvt.exceptions_tab;
3821: step_alloc_error EXCEPTION;
3822: expected_error EXCEPTION;

Line 3844: IF NOT (gme_batch_steps_dbl.fetch_row(l_batch_step, l_batch_step)) THEN

3840: END IF;
3841:
3842: l_batch_step.batch_id := p_batch_id;
3843: l_batch_step.batchstep_id := p_step_id;
3844: IF NOT (gme_batch_steps_dbl.fetch_row(l_batch_step, l_batch_step)) THEN
3845: RAISE expected_error;
3846: END IF;
3847: l_batch_step.actual_start_date := l_act_strt_dt;
3848: