APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_PA_DATA_FIELDS

Line 8: ,p_form_block_name IN ghr_pa_data_fields.form_block_name%TYPE

4: -- For a particuar NOA Family this function returns the procesing method for a given
5: -- item in a form
6: PROCEDURE get_process_method(
7: p_noa_family_code IN ghr_noa_fam_proc_methods.noa_family_code%TYPE
8: ,p_form_block_name IN ghr_pa_data_fields.form_block_name%TYPE
9: ,p_form_field_name IN ghr_pa_data_fields.form_field_name%TYPE
10: ,p_effective_date IN DATE
11: ,p_process_method_code OUT NOCOPY VARCHAR2
12: ,p_navigable_flag OUT NOCOPY VARCHAR2) IS

Line 9: ,p_form_field_name IN ghr_pa_data_fields.form_field_name%TYPE

5: -- item in a form
6: PROCEDURE get_process_method(
7: p_noa_family_code IN ghr_noa_fam_proc_methods.noa_family_code%TYPE
8: ,p_form_block_name IN ghr_pa_data_fields.form_block_name%TYPE
9: ,p_form_field_name IN ghr_pa_data_fields.form_field_name%TYPE
10: ,p_effective_date IN DATE
11: ,p_process_method_code OUT NOCOPY VARCHAR2
12: ,p_navigable_flag OUT NOCOPY VARCHAR2) IS
13:

Line 18: ,ghr_pa_data_fields pdf

14: CURSOR cur_nfp IS
15: SELECT nfp.process_method_code pm_code
16: ,nfp.navigable_flag
17: FROM ghr_noa_fam_proc_methods nfp
18: ,ghr_pa_data_fields pdf
19: WHERE pdf.pa_data_field_id = nfp.pa_data_field_id
20: AND pdf.form_block_name = p_form_block_name
21: AND pdf.form_field_name = p_form_field_name
22: AND nfp.noa_family_code = p_noa_family_code

Line 45: p_form_block_name IN ghr_pa_data_fields.form_block_name%TYPE

41:
42: END get_process_method;
43:
44: FUNCTION get_data_field_name(
45: p_form_block_name IN ghr_pa_data_fields.form_block_name%TYPE
46: ,p_form_field_name IN ghr_pa_data_fields.form_field_name%TYPE)
47: RETURN VARCHAR2 IS
48: --
49: CURSOR cur_pdf IS

Line 46: ,p_form_field_name IN ghr_pa_data_fields.form_field_name%TYPE)

42: END get_process_method;
43:
44: FUNCTION get_data_field_name(
45: p_form_block_name IN ghr_pa_data_fields.form_block_name%TYPE
46: ,p_form_field_name IN ghr_pa_data_fields.form_field_name%TYPE)
47: RETURN VARCHAR2 IS
48: --
49: CURSOR cur_pdf IS
50: SELECT pdf.name

Line 51: FROM ghr_pa_data_fields pdf

47: RETURN VARCHAR2 IS
48: --
49: CURSOR cur_pdf IS
50: SELECT pdf.name
51: FROM ghr_pa_data_fields pdf
52: WHERE pdf.form_block_name = p_form_block_name
53: AND pdf.form_field_name = p_form_field_name;
54: --
55: BEGIN

Line 66: ,p_form_block_name IN ghr_pa_data_fields.form_block_name%TYPE

62: END get_data_field_name;
63: --
64: PROCEDURE get_restricted_process_method(
65: p_restricted_form IN ghr_restricted_proc_methods.restricted_form%TYPE
66: ,p_form_block_name IN ghr_pa_data_fields.form_block_name%TYPE
67: ,p_form_field_name IN ghr_pa_data_fields.form_field_name%TYPE
68: ,p_restricted_proc_method OUT NOCOPY VARCHAR2) IS
69:
70: -- there is no need to pass in an effective data since the restricted form is for a user and is not

Line 67: ,p_form_field_name IN ghr_pa_data_fields.form_field_name%TYPE

63: --
64: PROCEDURE get_restricted_process_method(
65: p_restricted_form IN ghr_restricted_proc_methods.restricted_form%TYPE
66: ,p_form_block_name IN ghr_pa_data_fields.form_block_name%TYPE
67: ,p_form_field_name IN ghr_pa_data_fields.form_field_name%TYPE
68: ,p_restricted_proc_method OUT NOCOPY VARCHAR2) IS
69:
70: -- there is no need to pass in an effective data since the restricted form is for a user and is not
71: -- relevant to the 'effective date' on the SF52 we will do the restricted form as of todays date

Line 74: FROM ghr_pa_data_fields pdf

70: -- there is no need to pass in an effective data since the restricted form is for a user and is not
71: -- relevant to the 'effective date' on the SF52 we will do the restricted form as of todays date
72: CURSOR cur_rpm IS
73: SELECT rpm.restricted_proc_method
74: FROM ghr_pa_data_fields pdf
75: ,ghr_restricted_proc_methods rpm
76: WHERE pdf.pa_data_field_id = rpm.pa_data_field_id
77: AND rpm.restricted_form = p_restricted_form
78: AND pdf.form_block_name = p_form_block_name