DBA Data[Home] [Help]

APPS.GME_DELETE_BATCH_STEP_PVT dependencies on GME_PROCESS_PARAMETERS

Line 147: DELETE gme_process_parameters

143: AND action_code NOT IN ('REVS', 'REVL', 'DEL')
144: AND delete_mark <> 1;
145:
146: -- 2. Delete all the process parameters
147: DELETE gme_process_parameters
148: WHERE batch_id = l_batch_step.batch_id
149: AND batchstep_id = l_batch_step.batchstep_id;
150:
151: -- 3. Delete all the resources

Line 483: l_rsrc_parameters gme_process_parameters%ROWTYPE;

479: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_resource';
480: /* Local variables */
481: l_return_status VARCHAR2 (1);
482: l_update_inventory_ind VARCHAR2 (1);
483: l_rsrc_parameters gme_process_parameters%ROWTYPE;
484: l_batch_step_resource gme_batch_step_resources%ROWTYPE;
485: /* Exceptions */
486: trans_delete_error EXCEPTION;
487: activity_resource_delete_error EXCEPTION;

Line 561: IF NOT (gme_process_parameters_dbl.delete_all

557: CLOSE cur_is_charge_associated;
558: END IF;
559:
560: --Rishi Varma bug 3307549 10/05/2004 end
561: IF NOT (gme_process_parameters_dbl.delete_all
562: (p_process_parameters => l_rsrc_parameters) ) THEN
563: RAISE rsrc_param_delete_error;
564: END IF;
565: