APPS.GME_TERMINATE_BATCH_PVT dependencies on GME_BATCH_STEPS

Line 47: FROM gme_batch_steps

43: /* Cursors */
44: CURSOR cur_get_wip_steps (v_batch_id NUMBER)
45: IS
46: SELECT *
47: FROM gme_batch_steps
48: WHERE batch_id = v_batch_id
49: AND step_status = 2 -- terminate only WIP steps
50: ORDER BY batchstep_id;
51:

Line 55: FROM gme_batch_steps

51:
52: CURSOR cur_get_pending_steps (v_batch_id NUMBER)
53: IS
54: SELECT *
55: FROM gme_batch_steps
56: WHERE batch_id = v_batch_id
57: AND step_status = 1 -- cancel pending steps
58: ORDER BY batchstep_id;
59:

Line 65: l_batch_step_rec gme_batch_steps%ROWTYPE;

61: l_material_details gme_material_details%ROWTYPE;
62: l_material_details_tab gme_common_pvt.material_details_tab;
63: l_batch_header_rec gme_batch_header%ROWTYPE;
64: l_in_batch_header_rec gme_batch_header%ROWTYPE;
65: l_batch_step_rec gme_batch_steps%ROWTYPE;
66: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
67: l_batch_step_ids gme_common_pvt.number_tab;
68: l_rsrc_trans_count NUMBER;
69: l_batch_step_tab gme_common_pvt.steps_tab;

Line 66: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

62: l_material_details_tab gme_common_pvt.material_details_tab;
63: l_batch_header_rec gme_batch_header%ROWTYPE;
64: l_in_batch_header_rec gme_batch_header%ROWTYPE;
65: l_batch_step_rec gme_batch_steps%ROWTYPE;
66: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
67: l_batch_step_ids gme_common_pvt.number_tab;
68: l_rsrc_trans_count NUMBER;
69: l_batch_step_tab gme_common_pvt.steps_tab;
70: m_batch_step_tab gme_common_pvt.steps_tab;