DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_NOA_FAMILIES

Line 262: PROCEDURE get_single_noac_for_fam (p_noa_family_code IN ghr_noa_families.noa_family_code%TYPE

258: RETURN NUMBER;
259:
260: -- This procedure will return the noac id, code and description if there is only one noac in the given
261: -- family, otherwise it returns null
262: PROCEDURE get_single_noac_for_fam (p_noa_family_code IN ghr_noa_families.noa_family_code%TYPE
263: ,p_effective_date IN DATE
264: ,p_nature_of_action_id IN OUT NOCOPY ghr_nature_of_actions.nature_of_action_id%TYPE
265: ,p_code IN OUT NOCOPY ghr_nature_of_actions.code%TYPE
266: ,p_description IN OUT NOCOPY ghr_nature_of_actions.description%TYPE);

Line 280: FUNCTION get_noa_pm_family (p_nature_of_action_id IN ghr_noa_families.nature_of_action_id%TYPE)

276: FUNCTION get_restricted_form (p_person_id IN NUMBER)
277: RETURN VARCHAR2;
278: --
279: -- Given a noa of action id return the processing method family it is in
280: FUNCTION get_noa_pm_family (p_nature_of_action_id IN ghr_noa_families.nature_of_action_id%TYPE)
281: RETURN VARCHAR2;
282: pragma restrict_references (get_noa_pm_family, WNDS, WNPS);
283: --
284: -- Bug#3941541 Overloaded function with effective date as another parameter

Line 285: FUNCTION get_noa_pm_family (p_nature_of_action_id IN ghr_noa_families.nature_of_action_id%TYPE,

281: RETURN VARCHAR2;
282: pragma restrict_references (get_noa_pm_family, WNDS, WNPS);
283: --
284: -- Bug#3941541 Overloaded function with effective date as another parameter
285: FUNCTION get_noa_pm_family (p_nature_of_action_id IN ghr_noa_families.nature_of_action_id%TYPE,
286: p_effective_date IN DATE)
287: RETURN VARCHAR2;
288: pragma restrict_references (get_noa_pm_family, WNDS, WNPS);
289: --