APPS.GME_DELETE_BATCH_STEP_PVT dependencies on GME_BATCH_STEP_ACTIVITIES

Line 31: l_gme_batchstep_activities gme_batch_step_activities%ROWTYPE;

27: ,p_reroute_flag IN BOOLEAN := FALSE)
28: IS
29: l_api_name CONSTANT VARCHAR2 (30) := 'delete_step';
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;

Line 157: DELETE gme_batch_step_activities

153: WHERE batch_id = l_batch_step.batch_id
154: AND batchstep_id = l_batch_step.batchstep_id;
155:
156: -- 4. Delete all the activities
157: DELETE gme_batch_step_activities
158: WHERE batch_id = l_batch_step.batch_id
159: AND batchstep_id = l_batch_step.batchstep_id;
160:
161: -- 5. Delete all the chanrges

Line 301: p_batch_step_activities_rec IN gme_batch_step_activities%ROWTYPE

297: E - Error
298: U - Unexpected error
299: =============================================================================================*/
300: PROCEDURE delete_activity (
301: p_batch_step_activities_rec IN gme_batch_step_activities%ROWTYPE
302: ,x_return_status OUT NOCOPY VARCHAR2)
303: IS
304: l_api_name CONSTANT VARCHAR2 (30) := 'delete_activity';
305: /* Collections for details etc */

Line 319: FROM gme_batch_step_activities

315: --Rishi Varma bug 3307549 13-May-2004 start
316: CURSOR cur_get_batch_id (v_batchstep_activity_id NUMBER)
317: IS
318: SELECT batch_id
319: FROM gme_batch_step_activities
320: WHERE batchstep_activity_id = v_batchstep_activity_id;
321:
322: l_batch_id NUMBER;
323: --Rishi Varma bug 3307549 13-May-2004 end

Line 390: IF NOT (gme_batch_step_activities_dbl.delete_row

386: RAISE gmf_cost_failure;
387: END IF;
388: END IF;
389:
390: IF NOT (gme_batch_step_activities_dbl.delete_row
391: (p_batch_step_activities_rec) ) THEN
392: RAISE step_activity_delete_error;
393: END IF;
394: