APPS.GME_DELETE_BATCH_STEP_PVT dependencies on GME_BATCH_STEPS

Line 25: p_batch_step_rec IN gme_batch_steps%ROWTYPE

21: E - Error
22: U - Unexpected error
23: =============================================================================================*/
24: PROCEDURE delete_step (
25: p_batch_step_rec IN gme_batch_steps%ROWTYPE
26: ,x_return_status OUT NOCOPY VARCHAR2
27: ,p_reroute_flag IN BOOLEAN := FALSE)
28: IS
29: l_api_name CONSTANT VARCHAR2 (30) := 'delete_step';

Line 34: l_batch_step gme_batch_steps%ROWTYPE;

30: /* Collections for details etc */
31: l_gme_batchstep_activities gme_batch_step_activities%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);

Line 49: FROM gme_batch_steps

45:
46: CURSOR cur_get_count (v_batch_id NUMBER, v_batchstep_id NUMBER)
47: IS
48: SELECT COUNT (1)
49: FROM gme_batch_steps
50: WHERE batch_id = v_batch_id AND batchstep_id <> v_batchstep_id;
51:
52: CURSOR cur_get_dependency (v_batchstep_id NUMBER)
53: IS

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

84: /* Set the return status to success initially */
85: x_return_status := fnd_api.g_ret_sts_success;
86:
87: /* Initialize local batch step array */
88: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec, l_batch_step) ) THEN
89: RAISE batch_step_fetch_error;
90: END IF;
91:
92: /* Load the batch header associated with the step */

Line 195: IF NOT (gme_batch_steps_dbl.delete_row (l_batch_step) ) THEN

191: RAISE step_item_delete_error;
192: END IF;
193: END LOOP;
194:
195: IF NOT (gme_batch_steps_dbl.delete_row (l_batch_step) ) THEN
196: RAISE step_delete_error;
197: END IF;
198:
199: --Begin Bug#3109673 P.Raghu

Line 233: -- Update the plan_step_qty in GME_BATCH_STEPS

229: gme_debug.put_line ('done step calc...');
230: END IF;
231:
232: /*Bug 2395188 Bharati Satpute Replaced first,last with count */
233: -- Update the plan_step_qty in GME_BATCH_STEPS
234: FOR i IN 1 .. l_step_tbl.COUNT LOOP
235: UPDATE gme_batch_steps
236: SET plan_step_qty = l_step_tbl (i).step_qty
237: ,plan_mass_qty = l_step_tbl (i).step_mass_qty

Line 235: UPDATE gme_batch_steps

231:
232: /*Bug 2395188 Bharati Satpute Replaced first,last with count */
233: -- Update the plan_step_qty in GME_BATCH_STEPS
234: FOR i IN 1 .. l_step_tbl.COUNT LOOP
235: UPDATE gme_batch_steps
236: SET plan_step_qty = l_step_tbl (i).step_qty
237: ,plan_mass_qty = l_step_tbl (i).step_mass_qty
238: ,mass_ref_um = l_step_tbl (i).step_mass_uom
239: ,plan_volume_qty = l_step_tbl (i).step_vol_qty