APPS.GME_PROCESS_PARAMETERS_PVT dependencies on GME_BATCH_HEADER

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 77: l_batch_header gme_batch_header%ROWTYPE;

73: v_temp NUMBER;
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');

Line 383: FROM gme_batch_header b, gme_process_parameters p

379:
380: CURSOR cur_validate_batch_type (v_proc_param_id NUMBER)
381: IS
382: SELECT 1
383: FROM gme_batch_header b, gme_process_parameters p
384: WHERE b.batch_id = p.batch_id
385: AND p.process_param_id = v_proc_param_id
386: AND b.batch_type = 10;
387:

Line 665: FROM gme_batch_header b, gme_process_parameters p

661:
662: CURSOR cur_validate_batch_type (v_proc_param_id NUMBER)
663: IS
664: SELECT 1
665: FROM gme_batch_header b, gme_process_parameters p
666: WHERE b.batch_id = p.batch_id
667: AND p.process_param_id = v_proc_param_id
668: AND b.batch_type = 10;
669:

Line 674: FROM gme_batch_header

670: /*siva added following cursor */
671: CURSOR cur_validate_batch_status(v_batch_id NUMBER)
672: IS
673: SELECT batch_status
674: FROM gme_batch_header
675: WHERE batch_id = v_batch_id;
676:
677: input_param_missing EXCEPTION;
678: validate_param_failed EXCEPTION;

Line 845: l_batch_header gme_batch_header%ROWTYPE;

841: l_count NUMBER := 0;
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

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

932: l_batch_header.organization_id := gme_common_pvt.g_organization_id;
933: l_batch_header.batch_no := p_batch_no;
934: l_batch_header.batch_type := 0;
935:
936: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header, l_batch_header) ) THEN
937: RAISE batch_header_fetch_error;
938: END IF;
939:
940: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN