APPS.GME_PROCESS_PARAMETERS_PVT dependencies on GME_BATCH_STEP_RESOURCES

Line 32: FROM gme_batch_header b, gme_batch_step_resources r

28: IS
29: CURSOR cur_validate_batch_type (v_resource_id NUMBER)
30: IS
31: SELECT 1
32: FROM gme_batch_header b, gme_batch_step_resources r
33: WHERE b.batch_id = r.batch_id
34: AND r.batchstep_resource_id = v_resource_id
35: AND b.batch_type = 10;
36:

Line 78: l_resource_row gme_batch_step_resources%ROWTYPE;

74: l_value NUMBER;
75: l_proc_param_id NUMBER;
76: l_resources VARCHAR2 (16);
77: l_batch_header gme_batch_header%ROWTYPE;
78: l_resource_row gme_batch_step_resources%ROWTYPE;
79: BEGIN
80: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
81: gme_debug.put_line ('Calling public Insert process parameters Row');
82: END IF;

Line 98: IF NOT (gme_batch_step_resources_dbl.fetch_row (l_resource_row

94: -- validate the resource provided
95: l_resource_row.batchstep_resource_id :=
96: p_process_param_rec.batchstep_resource_id;
97:
98: IF NOT (gme_batch_step_resources_dbl.fetch_row (l_resource_row
99: ,l_resource_row) ) THEN
100: gme_common_pvt.log_message ('GME_RSRCID_NOT_FOUND'
101: ,'BATCHSTEP_RSRC_ID'
102: ,l_resource_row.batchstep_resource_id);

Line 855: FROM gme_batch_step_activities a, gme_batch_step_resources r

851: ,v_batch_id NUMBER
852: ,v_resource VARCHAR2)
853: IS
854: SELECT COUNT (*)
855: FROM gme_batch_step_activities a, gme_batch_step_resources r
856: WHERE a.batch_id = r.batch_id
857: AND a.batchstep_id = r.batchstep_id
858: AND a.batchstep_activity_id = r.batchstep_activity_id
859: AND a.batch_id = v_batch_id

Line 878: FROM gme_batch_step_resources

874:
875: CURSOR cur_fetch_resource_dtl (v_activity_id NUMBER, v_resource VARCHAR2)
876: IS
877: SELECT batchstep_resource_id
878: FROM gme_batch_step_resources
879: WHERE batchstep_activity_id = v_activity_id
880: AND resources = v_resource;
881:
882: CURSOR cur_check_parameter (v_parameter VARCHAR2)