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 264: ,p_nature_of_action_id IN OUT NOCOPY ghr_nature_of_actions.nature_of_action_id%TYPE

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

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

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

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

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

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

287: RETURN VARCHAR2;
288: pragma restrict_references (get_noa_pm_family, WNDS, WNPS);
289: --
290: -- As above except pass in a noa code and it returns the family it is in
291: FUNCTION get_noa_pm_family (p_noa_code IN ghr_nature_of_actions.code%TYPE)
292: RETURN VARCHAR2;
293: pragma restrict_references (get_noa_pm_family, WNDS, WNPS);
294: --
295: -- Given a position_id and a date check to see if anybody has been assigned

Line 337: ,p_noa_code IN ghr_nature_of_actions.code%TYPE

333: ,p_second_noa_family_code IN VARCHAR2)
334: RETURN VARCHAR2;
335: --
336: PROCEDURE get_corr_other_pay(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_to_basic_pay OUT NOCOPY NUMBER
339: ,p_to_adj_basic_pay OUT NOCOPY NUMBER
340: ,p_to_auo_ppi OUT NOCOPY VARCHAR2
341: ,p_to_auo OUT NOCOPY NUMBER

Line 358: ,p_noa_code IN ghr_nature_of_actions.code%TYPE

354: -- Corr Warn
355: );
356:
357: PROCEDURE get_corr_rpa_other_pay(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
358: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
359: ,p_from_basic_pay OUT NOCOPY NUMBER
360: ,p_to_basic_pay OUT NOCOPY NUMBER
361: ,p_to_adj_basic_pay OUT NOCOPY NUMBER
362: ,p_to_auo_ppi OUT NOCOPY VARCHAR2

Line 385: ,p_noa_code IN ghr_nature_of_actions.code%TYPE

381: --
382: -- This procedure gets the amounts that are not displayed in a correction form that
383: -- are needed to do an award
384: PROCEDURE get_corr_award (p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
385: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
386: ,p_from_basic_pay OUT NOCOPY NUMBER
387: ,p_from_pay_basis OUT NOCOPY VARCHAR2
388: );
389: --