DBA Data[Home] [Help]

APPS.GME_PROCESS_PARAMETERS_PVT dependencies on GME_BATCH_STEPS

Line 415: l_batch_steps gme_batch_steps%ROWTYPE;

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;

Line 471: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_steps, l_batch_steps) ) THEN

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;

Line 846: l_batch_steps gme_batch_steps%ROWTYPE;

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

Line 949: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_steps, l_batch_steps) ) THEN

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