DBA Data[Home] [Help]

APPS.GME_DELETE_BATCH_STEP_PVT dependencies on GME_BATCH_STEP_DEPENDENCIES

Line 35: l_batchstep_dependency gme_batch_step_dependencies%ROWTYPE;

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);
39: l_inv_trans_count NUMBER;

Line 55: FROM gme_batch_step_dependencies

51:
52: CURSOR cur_get_dependency (v_batchstep_id NUMBER)
53: IS
54: SELECT batchstep_id, dep_step_id
55: FROM gme_batch_step_dependencies
56: WHERE (batch_id = l_batch_header.batch_id)
57: AND (batchstep_id = v_batchstep_id OR dep_step_id = v_batchstep_id);
58:
59: CURSOR cur_get_item_assoc (v_batchstep_id NUMBER)