DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_NATURE_OF_ACTIONS

Line 61: p_nature_of_action_id IN ghr_nature_of_actions.nature_of_action_id%TYPE)

57: ,p_effective_date date)
58: RETURN VARCHAR2;
59:
60: FUNCTION get_noa_descriptor(
61: p_nature_of_action_id IN ghr_nature_of_actions.nature_of_action_id%TYPE)
62: RETURN VARCHAR2;
63: --
64: FUNCTION get_remark_descriptor(
65: p_remark_id IN ghr_remarks.remark_id%TYPE)

Line 216: ,p_nature_of_action_id IN OUT NOCOPY ghr_nature_of_actions.nature_of_action_id%TYPE

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);
219: --
220: -- This procedure will return the Legal Authority Code and Description if there is only one for the given

Line 217: ,p_code IN OUT NOCOPY ghr_nature_of_actions.code%TYPE

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);
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

Line 218: ,p_description IN OUT NOCOPY ghr_nature_of_actions.description%TYPE);

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);
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

Line 243: FUNCTION get_noa_pm_family (p_noa_code IN ghr_nature_of_actions.code%TYPE)

239: RETURN VARCHAR2;
240: pragma restrict_references (get_noa_pm_family, WNDS, WNPS);
241: --
242: -- As above except pass in a noa code and it returns the family it is in
243: FUNCTION get_noa_pm_family (p_noa_code IN ghr_nature_of_actions.code%TYPE)
244: RETURN VARCHAR2;
245: pragma restrict_references (get_noa_pm_family, WNDS, WNPS);
246: --
247: -- Given a position_id and a date check to see if anybody has been assigned

Line 289: ,p_noa_code IN ghr_nature_of_actions.code%TYPE

285: ,p_second_noa_family_code IN VARCHAR2)
286: RETURN VARCHAR2;
287: --
288: PROCEDURE get_corr_other_pay(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
289: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
290: ,p_to_basic_pay OUT NOCOPY NUMBER
291: ,p_to_adj_basic_pay OUT NOCOPY NUMBER
292: ,p_to_auo_ppi OUT NOCOPY VARCHAR2
293: ,p_to_auo OUT NOCOPY NUMBER

Line 310: ,p_noa_code IN ghr_nature_of_actions.code%TYPE

306: -- Corr Warn
307: );
308:
309: PROCEDURE get_corr_rpa_other_pay(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
310: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
311: ,p_from_basic_pay OUT NOCOPY NUMBER
312: ,p_to_basic_pay OUT NOCOPY NUMBER
313: ,p_to_adj_basic_pay OUT NOCOPY NUMBER
314: ,p_to_auo_ppi OUT NOCOPY VARCHAR2

Line 337: ,p_noa_code IN ghr_nature_of_actions.code%TYPE

333: --
334: -- This procedure gets the amounts that are not displayed in a correction form that
335: -- are needed to do an award
336: PROCEDURE get_corr_award (p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
337: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
338: ,p_from_basic_pay OUT NOCOPY NUMBER
339: ,p_from_pay_basis OUT NOCOPY VARCHAR2
340: );
341: --