DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG2 dependencies on GHR_PA_REQUESTS

Line 1: PACKAGE ghr_pa_requests_pkg2 AS

1: PACKAGE ghr_pa_requests_pkg2 AS
2: /* $Header: ghparqs2.pkh 120.4 2005/08/25 11:30:10 vravikan noship $ */
3:
4: -- This function checks if there are any pending PA Request actions for a given person (not including the
5: -- given PA Request)

Line 111: IN ghr_pa_requests.altered_pa_request_id%type)

107: (p_duty_station_code in ghr_duty_stations_f.duty_station_code%TYPE)
108: RETURN BOOLEAN;
109:
110: FUNCTION get_corr_cop (p_altered_pa_request_id
111: IN ghr_pa_requests.altered_pa_request_id%type)
112: RETURN NUMBER;
113:
114: FUNCTION get_cop ( p_assignment_id IN per_assignments_f.assignment_id%type
115: ,p_effective_date IN date)

Line 145: END ghr_pa_requests_pkg2;

141: RETURN BOOLEAN;
142: --
143: --
144: --
145: END ghr_pa_requests_pkg2;
146: --