50: /* Cursor declarations */
51: CURSOR cur_get_resources (v_batchstep_id NUMBER)
52: IS
53: SELECT *
54: FROM gme_batch_step_resources
55: WHERE batchstep_id = v_batchstep_id;
56:
57: CURSOR cur_get_activities (v_batchstep_id NUMBER)
58: IS
137: IF l_resources_tab (i).actual_rsrc_qty IS NULL THEN
138: l_resources_tab (i).actual_rsrc_qty := 0;
139: END IF;
140:
141: IF NOT (gme_batch_step_resources_dbl.update_row (l_resources_tab (i) ) ) THEN
142: RAISE resource_upd_err;
143: END IF;
144:
145: IF (p_update_inventory_ind = 'Y') THEN