DBA Data[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;