DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_NOAC_LAS

Line 222: PROCEDURE get_single_lac_for_noac (p_nature_of_action_id IN ghr_noac_las.nature_of_action_id%TYPE

218: ,p_description IN OUT NOCOPY ghr_nature_of_actions.description%TYPE);
219: --
220: -- This procedure will return the Legal Authority Code and Description if there is only one for the given
221: -- NOAC, otherwise it returns null
222: PROCEDURE get_single_lac_for_noac (p_nature_of_action_id IN ghr_noac_las.nature_of_action_id%TYPE
223: ,p_effective_date IN DATE
224: ,p_lac_code IN OUT NOCOPY ghr_noac_las.lac_lookup_code%TYPE
225: ,p_description IN OUT NOCOPY VARCHAR2);
226: --

Line 224: ,p_lac_code IN OUT NOCOPY ghr_noac_las.lac_lookup_code%TYPE

220: -- This procedure will return the Legal Authority Code and Description if there is only one for the given
221: -- NOAC, otherwise it returns null
222: PROCEDURE get_single_lac_for_noac (p_nature_of_action_id IN ghr_noac_las.nature_of_action_id%TYPE
223: ,p_effective_date IN DATE
224: ,p_lac_code IN OUT NOCOPY ghr_noac_las.lac_lookup_code%TYPE
225: ,p_description IN OUT NOCOPY VARCHAR2);
226: --
227: -- This function simply returns the restricted form (if any) for the given person
228: FUNCTION get_restricted_form (p_person_id IN NUMBER)