APPS.GME_DELETE_BATCH_STEP_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 36: l_batchstep_items gme_batch_step_items%ROWTYPE;

32: l_material_ids gme_common_pvt.number_tab;
33: l_batch_header gme_batch_header%ROWTYPE;
34: l_batch_step gme_batch_steps%ROWTYPE;
35: l_batchstep_dependency gme_batch_step_dependencies%ROWTYPE;
36: l_batchstep_items gme_batch_step_items%ROWTYPE;
37: /* Local variables */
38: l_return_status VARCHAR2 (1);
39: l_inv_trans_count NUMBER;
40: l_rsrc_trans_count NUMBER;

Line 62: FROM gme_batch_step_items

58:
59: CURSOR cur_get_item_assoc (v_batchstep_id NUMBER)
60: IS
61: SELECT material_detail_id
62: FROM gme_batch_step_items
63: WHERE batchstep_id = v_batchstep_id;
64:
65: /* Exceptions */
66: step_activity_delete_error EXCEPTION;

Line 190: IF NOT (gme_batch_step_items_dbl.delete_row (l_batchstep_items) ) THEN

186: /* Fetch all the item association details */
187: FOR i IN 1 .. l_material_ids.COUNT LOOP
188: l_batchstep_items.material_detail_id := l_material_ids (i);
189:
190: IF NOT (gme_batch_step_items_dbl.delete_row (l_batchstep_items) ) THEN
191: RAISE step_item_delete_error;
192: END IF;
193: END LOOP;
194: