DBA Data[Home] [Help]

APPS.GME_DELETE_BATCH_STEP_PVT dependencies on GME_BATCH_HEADER

Line 33: l_batch_header gme_batch_header%ROWTYPE;

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;
36: l_batchstep_items gme_batch_step_items%ROWTYPE;
37: /* Local variables */

Line 95: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header, l_batch_header) ) THEN

91:
92: /* Load the batch header associated with the step */
93: l_batch_header.batch_id := l_batch_step.batch_id;
94:
95: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header, l_batch_header) ) THEN
96: RAISE batch_header_fetch_error;
97: END IF;
98:
99: /* Don't allow the Batch Step to be deleted if the Batch Status */

Line 450: FROM gme_batch_header

446: /* 2841929: Added parameters to the cursor and passing proper parameters */
447: CURSOR cur_get_update_inventory (v_batch_id IN NUMBER)
448: IS
449: SELECT update_inventory_ind
450: FROM gme_batch_header
451: WHERE batch_id = v_batch_id;
452:
453: --Rishi Varma bug# 3307549 10-05-2004
454: CURSOR cur_is_charge_associated (