APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_NOAC_REMARKS

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

246:
247: --
248: -- This function simply returns the required flag (either Y or N) for a given remark id and NOAC
249: -- It is used on the post-query in the SF52 form to set the required indicator on the remarks block
250: FUNCTION get_noac_remark_req (p_first_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
251: ,p_second_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
252: ,p_remark_id IN ghr_noac_remarks.nature_of_action_id%TYPE
253: ,p_effective_date IN DATE)
254: RETURN VARCHAR2;

Line 251: ,p_second_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE

247: --
248: -- This function simply returns the required flag (either Y or N) for a given remark id and NOAC
249: -- It is used on the post-query in the SF52 form to set the required indicator on the remarks block
250: FUNCTION get_noac_remark_req (p_first_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
251: ,p_second_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
252: ,p_remark_id IN ghr_noac_remarks.nature_of_action_id%TYPE
253: ,p_effective_date IN DATE)
254: RETURN VARCHAR2;
255:

Line 252: ,p_remark_id IN ghr_noac_remarks.nature_of_action_id%TYPE

248: -- This function simply returns the required flag (either Y or N) for a given remark id and NOAC
249: -- It is used on the post-query in the SF52 form to set the required indicator on the remarks block
250: FUNCTION get_noac_remark_req (p_first_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
251: ,p_second_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
252: ,p_remark_id IN ghr_noac_remarks.nature_of_action_id%TYPE
253: ,p_effective_date IN DATE)
254: RETURN VARCHAR2;
255:
256: -- This function simply returns the person_id for the given username