DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG dependencies on HR_LOOKUPS

Line 25: ,p_lookup_type hr_lookups.lookup_type%TYPE

21: ,p_restricted_proc_method OUT NOCOPY VARCHAR2);
22: --
23: FUNCTION get_lookup_meaning(
24: p_application_id NUMBER
25: ,p_lookup_type hr_lookups.lookup_type%TYPE
26: ,p_lookup_code hr_lookups.lookup_code%TYPE)
27: RETURN VARCHAR2;
28:
29: -- This is very similar to the function get_lookup_meaning above except it returns the

Line 26: ,p_lookup_code hr_lookups.lookup_code%TYPE)

22: --
23: FUNCTION get_lookup_meaning(
24: p_application_id NUMBER
25: ,p_lookup_type hr_lookups.lookup_type%TYPE
26: ,p_lookup_code hr_lookups.lookup_code%TYPE)
27: RETURN VARCHAR2;
28:
29: -- This is very similar to the function get_lookup_meaning above except it returns the
30: -- description as opposed to the meaning, this is required in particular for Legal Authority

Line 34: ,p_lookup_type hr_lookups.lookup_type%TYPE

30: -- description as opposed to the meaning, this is required in particular for Legal Authority
31: -- since menaing is forced to be unique we use the description
32: FUNCTION get_lookup_description(
33: p_application_id NUMBER
34: ,p_lookup_type hr_lookups.lookup_type%TYPE
35: ,p_lookup_code hr_lookups.lookup_code%TYPE)
36: RETURN VARCHAR2;
37: -- Removed Pragma reference, not needed in 8i.
38: -- (See bug# 1014743)

Line 35: ,p_lookup_code hr_lookups.lookup_code%TYPE)

31: -- since menaing is forced to be unique we use the description
32: FUNCTION get_lookup_description(
33: p_application_id NUMBER
34: ,p_lookup_type hr_lookups.lookup_type%TYPE
35: ,p_lookup_code hr_lookups.lookup_code%TYPE)
36: RETURN VARCHAR2;
37: -- Removed Pragma reference, not needed in 8i.
38: -- (See bug# 1014743)
39: -- pragma restrict_references (get_lookup_description, WNDS, WNPS);