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.

[Home] [Help]

APPS.GME_MOBILE_TXN dependencies on GME_BATCH_STEPS

Line 1649: FROM gme_batch_steps s,

1645: AND batch_id = p_batch_id;
1646:
1647: CURSOR cur_get_step_status IS
1648: SELECT s.batchstep_no
1649: FROM gme_batch_steps s,
1650: gme_batch_step_items i,
1651: gme_material_details m
1652: WHERE m.batch_id = p_batch_id
1653: AND s.batch_id = p_batch_id

Line 3708: l_batch_step gme_batch_steps%ROWTYPE;

3704: l_step_qty NUMBER;
3705: l_act_strt_dt DATE;
3706: l_act_complt_dt DATE;
3707: message VARCHAR2(2000);
3708: l_batch_step gme_batch_steps%ROWTYPE;
3709: l_batch_step_out gme_batch_steps%ROWTYPE;
3710: x_batch_step gme_batch_steps%ROWTYPE;
3711: l_batch_header gme_batch_header%ROWTYPE;
3712: x_exception_material gme_common_pvt.exceptions_tab;

Line 3709: l_batch_step_out gme_batch_steps%ROWTYPE;

3705: l_act_strt_dt DATE;
3706: l_act_complt_dt DATE;
3707: message VARCHAR2(2000);
3708: l_batch_step gme_batch_steps%ROWTYPE;
3709: l_batch_step_out gme_batch_steps%ROWTYPE;
3710: x_batch_step gme_batch_steps%ROWTYPE;
3711: l_batch_header gme_batch_header%ROWTYPE;
3712: x_exception_material gme_common_pvt.exceptions_tab;
3713: step_alloc_error EXCEPTION;

Line 3710: x_batch_step gme_batch_steps%ROWTYPE;

3706: l_act_complt_dt DATE;
3707: message VARCHAR2(2000);
3708: l_batch_step gme_batch_steps%ROWTYPE;
3709: l_batch_step_out gme_batch_steps%ROWTYPE;
3710: x_batch_step gme_batch_steps%ROWTYPE;
3711: l_batch_header gme_batch_header%ROWTYPE;
3712: x_exception_material gme_common_pvt.exceptions_tab;
3713: step_alloc_error EXCEPTION;
3714: expected_error EXCEPTION;

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

3733: RAISE expected_error;
3734: END IF;
3735: l_batch_step.batch_id := p_batch_id;
3736: l_batch_step.batchstep_id := p_step_id;
3737: IF NOT (gme_batch_steps_dbl.fetch_row(l_batch_step, l_batch_step)) THEN
3738: RAISE expected_error;
3739: END IF;
3740:
3741: l_batch_step.actual_step_qty := p_act_step_qty;

Line 3783: FROM gme_batch_steps

3779: END IF;
3780: IF x_return_status = 'S' THEN
3781: IF p_act_step_qty IS NOT NULL THEN
3782: SELECT actual_step_qty INTO l_step_qty
3783: FROM gme_batch_steps
3784: WHERE batch_id = p_batch_id
3785: AND batchstep_id = p_step_id;
3786: IF l_step_qty <> p_act_step_qty THEN /* Update Act Step Qty */
3787: UPDATE gme_batch_steps

Line 3787: UPDATE gme_batch_steps

3783: FROM gme_batch_steps
3784: WHERE batch_id = p_batch_id
3785: AND batchstep_id = p_step_id;
3786: IF l_step_qty <> p_act_step_qty THEN /* Update Act Step Qty */
3787: UPDATE gme_batch_steps
3788: SET actual_step_qty = p_act_step_qty
3789: WHERE batch_id = p_batch_id
3790: AND batchstep_id = p_step_id;
3791: END IF;

Line 3920: l_batch_step gme_batch_steps%ROWTYPE;

3916: l_count NUMBER;
3917: l_act_strt_dt DATE;
3918: message VARCHAR2(2000);
3919: l_api_name VARCHAR2(30) := 'release_step';
3920: l_batch_step gme_batch_steps%ROWTYPE;
3921: l_batch_step_out gme_batch_steps%ROWTYPE;
3922: x_batch_step gme_batch_steps%ROWTYPE;
3923: l_batch_hdr_rec gme_batch_header%ROWTYPE;
3924: x_exception_material gme_common_pvt.exceptions_tab;

Line 3921: l_batch_step_out gme_batch_steps%ROWTYPE;

3917: l_act_strt_dt DATE;
3918: message VARCHAR2(2000);
3919: l_api_name VARCHAR2(30) := 'release_step';
3920: l_batch_step gme_batch_steps%ROWTYPE;
3921: l_batch_step_out gme_batch_steps%ROWTYPE;
3922: x_batch_step gme_batch_steps%ROWTYPE;
3923: l_batch_hdr_rec gme_batch_header%ROWTYPE;
3924: x_exception_material gme_common_pvt.exceptions_tab;
3925: step_alloc_error EXCEPTION;

Line 3922: x_batch_step gme_batch_steps%ROWTYPE;

3918: message VARCHAR2(2000);
3919: l_api_name VARCHAR2(30) := 'release_step';
3920: l_batch_step gme_batch_steps%ROWTYPE;
3921: l_batch_step_out gme_batch_steps%ROWTYPE;
3922: x_batch_step gme_batch_steps%ROWTYPE;
3923: l_batch_hdr_rec gme_batch_header%ROWTYPE;
3924: x_exception_material gme_common_pvt.exceptions_tab;
3925: step_alloc_error EXCEPTION;
3926: expected_error EXCEPTION;

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

3944: END IF;
3945:
3946: l_batch_step.batch_id := p_batch_id;
3947: l_batch_step.batchstep_id := p_step_id;
3948: IF NOT (gme_batch_steps_dbl.fetch_row(l_batch_step, l_batch_step)) THEN
3949: RAISE expected_error;
3950: END IF;
3951: l_batch_step.actual_start_date := l_act_strt_dt;
3952: