[Home] [Help]
PACKAGE: APPS.PQP_US_SRS_FUNCTIONS
Source
1 PACKAGE pqp_us_srs_functions AUTHID CURRENT_USER AS
2 /* $Header: pqussrfn.pkh 115.1 2002/07/08 19:06:18 tmehra noship $ */
3 ----------------------------------------------------------------------------+
4 -- FUNCTION GET_SRS_LIMIT
5 ----------------------------------------------------------------------------+
6 FUNCTION get_srs_limit(p_payroll_action_id IN NUMBER
7 ,p_limit IN VARCHAR2)
8 RETURN NUMBER;
9 ----------------------------------------------------------------------------+
10 -- FUNCTION get_date_paid
11 ----------------------------------------------------------------------------+
12 FUNCTION get_date_paid (p_payroll_action_id IN NUMBER)
13
14 RETURN DATE;
15 ----------------------------------------------------------------------------+
16 -- FUNCTION get_srs_plan_type
17 ----------------------------------------------------------------------------+
18 FUNCTION get_srs_plan_type (p_element_type_id IN NUMBER)
19
20 RETURN VARCHAR2;
21
22 ----------------------------------------------------------------------------+
23 -- FUNCTION check_srs_enrollment
24 ----------------------------------------------------------------------------+
25 FUNCTION check_srs_enrollment (p_element_type_id IN NUMBER
26 ,p_assignment_id IN NUMBER
27 ,p_payroll_action_id IN NUMBER
28 ,p_enrollment_type IN VARCHAR2
29 )
30 RETURN VARCHAR2;
31 ----------------------------------------------------------------------------+
32
33 END pqp_us_srs_functions;