[Home] [Help]
411: batch_steps_fetch_error EXCEPTION;
412: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_PROCESS_PARAMETER';
413: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
414: l_process_param_rec gme_process_parameters%ROWTYPE;
415: l_batch_steps gme_batch_steps%ROWTYPE;
416: l_proc_param_id NUMBER;
417: l_resource_id NUMBER;
418: l_activity_id NUMBER;
419: l_batchstep_id NUMBER;
467: /* Fetch the step status*/
468: l_batch_steps.batch_id := l_batch_id;
469: l_batch_steps.batchstep_id := l_batchstep_id;
470:
471: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_steps, l_batch_steps) ) THEN
472: RAISE batch_steps_fetch_error;
473: END IF;
474:
475: l_step_status := l_batch_steps.step_status;
842: l_act_count NUMBER := 0;
843: l_param_no NUMBER := 0;
844: l_param_id NUMBER;
845: l_batch_header gme_batch_header%ROWTYPE;
846: l_batch_steps gme_batch_steps%ROWTYPE;
847:
848: CURSOR cur_check_act_resource (
849: v_step_id NUMBER
850: ,v_activity VARCHAR2
945: -- use batch_id to fetch batchstep_id
946: l_batch_steps.batch_id := x_batch_id;
947: l_batch_steps.batchstep_no := p_batchstep_no;
948:
949: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_steps, l_batch_steps) ) THEN
950: RAISE batch_steps_fetch_error;
951: END IF;
952:
953: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN