DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_NOAC_LAS

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

266: ,p_description IN OUT NOCOPY ghr_nature_of_actions.description%TYPE);
267: --
268: -- This procedure will return the Legal Authority Code and Description if there is only one for the given
269: -- NOAC, otherwise it returns null
270: PROCEDURE get_single_lac_for_noac (p_nature_of_action_id IN ghr_noac_las.nature_of_action_id%TYPE
271: ,p_effective_date IN DATE
272: ,p_lac_code IN OUT NOCOPY ghr_noac_las.lac_lookup_code%TYPE
273: ,p_description IN OUT NOCOPY VARCHAR2);
274: --

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

268: -- This procedure will return the Legal Authority Code and Description if there is only one for the given
269: -- NOAC, otherwise it returns null
270: PROCEDURE get_single_lac_for_noac (p_nature_of_action_id IN ghr_noac_las.nature_of_action_id%TYPE
271: ,p_effective_date IN DATE
272: ,p_lac_code IN OUT NOCOPY ghr_noac_las.lac_lookup_code%TYPE
273: ,p_description IN OUT NOCOPY VARCHAR2);
274: --
275: -- This function simply returns the restricted form (if any) for the given person
276: FUNCTION get_restricted_form (p_person_id IN NUMBER)