DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_NOA_FAMILIES

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

210: RETURN NUMBER;
211:
212: -- This procedure will return the noac id, code and description if there is only one noac in the given
213: -- family, otherwise it returns null
214: PROCEDURE get_single_noac_for_fam (p_noa_family_code IN ghr_noa_families.noa_family_code%TYPE
215: ,p_effective_date IN DATE
216: ,p_nature_of_action_id IN OUT NOCOPY ghr_nature_of_actions.nature_of_action_id%TYPE
217: ,p_code IN OUT NOCOPY ghr_nature_of_actions.code%TYPE
218: ,p_description IN OUT NOCOPY ghr_nature_of_actions.description%TYPE);

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

228: FUNCTION get_restricted_form (p_person_id IN NUMBER)
229: RETURN VARCHAR2;
230: --
231: -- Given a noa of action id return the processing method family it is in
232: FUNCTION get_noa_pm_family (p_nature_of_action_id IN ghr_noa_families.nature_of_action_id%TYPE)
233: RETURN VARCHAR2;
234: pragma restrict_references (get_noa_pm_family, WNDS, WNPS);
235: --
236: -- Bug#3941541 Overloaded function with effective date as another parameter

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

233: RETURN VARCHAR2;
234: pragma restrict_references (get_noa_pm_family, WNDS, WNPS);
235: --
236: -- Bug#3941541 Overloaded function with effective date as another parameter
237: FUNCTION get_noa_pm_family (p_nature_of_action_id IN ghr_noa_families.nature_of_action_id%TYPE,
238: p_effective_date IN DATE)
239: RETURN VARCHAR2;
240: pragma restrict_references (get_noa_pm_family, WNDS, WNPS);
241: --