APPS.GME_TERMINATE_BATCH_PVT dependencies on GME_BATCH_STEPS

Line 43: FROM gme_batch_steps

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

Line 51: FROM gme_batch_steps

47:
48: CURSOR cur_get_pending_steps (v_batch_id NUMBER)
49: IS
50: SELECT *
51: FROM gme_batch_steps
52: WHERE batch_id = v_batch_id
53: AND step_status = 1 -- cancel pending steps
54: ORDER BY batchstep_id;
55:

Line 61: l_batch_step_rec gme_batch_steps%ROWTYPE;

57: l_material_details gme_material_details%ROWTYPE;
58: l_material_details_tab gme_common_pvt.material_details_tab;
59: l_batch_header_rec gme_batch_header%ROWTYPE;
60: l_in_batch_header_rec gme_batch_header%ROWTYPE;
61: l_batch_step_rec gme_batch_steps%ROWTYPE;
62: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
63: l_batch_step_ids gme_common_pvt.number_tab;
64: l_rsrc_trans_count NUMBER;
65: l_batch_step_tab gme_common_pvt.steps_tab;

Line 62: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

58: l_material_details_tab gme_common_pvt.material_details_tab;
59: l_batch_header_rec gme_batch_header%ROWTYPE;
60: l_in_batch_header_rec gme_batch_header%ROWTYPE;
61: l_batch_step_rec gme_batch_steps%ROWTYPE;
62: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
63: l_batch_step_ids gme_common_pvt.number_tab;
64: l_rsrc_trans_count NUMBER;
65: l_batch_step_tab gme_common_pvt.steps_tab;
66: m_batch_step_tab gme_common_pvt.steps_tab;