APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_NOAC_REMARKS

Line 202: FUNCTION get_noac_remark_req (p_first_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE

198:
199: --
200: -- This function simply returns the required flag (either Y or N) for a given remark id and NOAC
201: -- It is used on the post-query in the SF52 form to set the required indicator on the remarks block
202: FUNCTION get_noac_remark_req (p_first_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
203: ,p_second_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
204: ,p_remark_id IN ghr_noac_remarks.nature_of_action_id%TYPE
205: ,p_effective_date IN DATE)
206: RETURN VARCHAR2;

Line 203: ,p_second_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE

199: --
200: -- This function simply returns the required flag (either Y or N) for a given remark id and NOAC
201: -- It is used on the post-query in the SF52 form to set the required indicator on the remarks block
202: FUNCTION get_noac_remark_req (p_first_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
203: ,p_second_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
204: ,p_remark_id IN ghr_noac_remarks.nature_of_action_id%TYPE
205: ,p_effective_date IN DATE)
206: RETURN VARCHAR2;
207:

Line 204: ,p_remark_id IN ghr_noac_remarks.nature_of_action_id%TYPE

200: -- This function simply returns the required flag (either Y or N) for a given remark id and NOAC
201: -- It is used on the post-query in the SF52 form to set the required indicator on the remarks block
202: FUNCTION get_noac_remark_req (p_first_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
203: ,p_second_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
204: ,p_remark_id IN ghr_noac_remarks.nature_of_action_id%TYPE
205: ,p_effective_date IN DATE)
206: RETURN VARCHAR2;
207:
208: -- This function simply returns the person_id for the given username