PACKAGE: APPS.PAY_PYAUAPL_XMLP_PKG

Source

1 PACKAGE PAY_PYAUAPL_XMLP_PKG AS
2 /* $Header: PYAUAPLS.pls 120.1 2008/03/25 06:23:34 amakrish noship $ */
3   P_CONC_REQUEST_ID NUMBER;
4 
5   P_BUSINESS_GROUP_ID NUMBER;
6 
7   P_PAYROLL_NAME VARCHAR2(80);
8 
9   P_EMPLOYEE_NAME VARCHAR2(240);
10 
11   P_START_DATE DATE;
12 
13   P_START_DATE1 DATE;
14 
15   P_ADVANCE_PERIOD NUMBER;
16 
17   P_END_DATE DATE;
18 
19   P_PAYROLL_ID NUMBER;
20 
21   P_PERSON_ID NUMBER;
22 
23   P_EMPLOYEE_NUMBER VARCHAR2(30);
24 
25   CP_LEAVE_START_DATE DATE;
26 
27   CP_PAY_DATE DATE;
28   CP_PAY_DATE1 DATE ;
29 
30   CP_LEAVE_END_DATE DATE;
31 
32   CP_LV_ADV DATE;
33   CP_LV_ADV_m date;
34 
35   CP_CURRENT VARCHAR2(32767);
36 
37   CP_FUTURE VARCHAR2(32767);
38 
39   CP_YES VARCHAR2(3);
40 
41   CP_NO VARCHAR2(3);
42 
43   FUNCTION AFTERREPORT RETURN BOOLEAN;
44 
45   FUNCTION CF_BUSINESS_GROUPFORMULA RETURN VARCHAR2;
46 
47   FUNCTION BEFOREREPORT RETURN BOOLEAN;
48 
49   FUNCTION CF_CURRENT_FUTURE_FLAGFORMULA RETURN CHAR;
50 
51   FUNCTION CF_PROCESS_FLAGFORMULA(P_CP_LEAVE_START_DATE in DATE,P_CP_LEAVE_END_DATE in DATE) RETURN CHAR;
52 
53   FUNCTION CF_END_DATEFORMULA RETURN varchar2;
54 
55   FUNCTION CF_DATE_CONVERSIONFORMULA(LEAVE_START_DATE IN VARCHAR2
56                                     ,LEAVE_END_DATE IN VARCHAR2
57                                     ,PAY_DATE IN VARCHAR2) RETURN NUMBER;
58 
59   FUNCTION CP_LEAVE_START_DATE_P RETURN DATE;
60 
61   FUNCTION CP_PAY_DATE_P RETURN DATE;
62 
63   FUNCTION CP_LEAVE_END_DATE_P RETURN DATE;
64 
65   FUNCTION CP_LV_ADV_P RETURN DATE;
66 
67   FUNCTION CP_CURRENT_P RETURN VARCHAR2;
68 
69   FUNCTION CP_FUTURE_P RETURN VARCHAR2;
70 
71   FUNCTION CP_YES_P RETURN VARCHAR2;
72 
73   FUNCTION CP_NO_P RETURN VARCHAR2;
74 
75 END PAY_PYAUAPL_XMLP_PKG;