PACKAGE: APPS.PAY_PAYIEP30_XMLP_PKG

Source

1 PACKAGE PAY_PAYIEP30_XMLP_PKG AS
2 /* $Header: PAYIEP30S.pls 120.3 2008/03/26 12:53:31 amakrish noship $ */
3   P_BUSINESS_GROUP_ID NUMBER;
4 
5   P_CONC_REQUEST_ID NUMBER;
6 
7   P_P30_ACTION_ID VARCHAR2(40);
8 
9   P_SUPPLEMENTARY_RUN VARCHAR2(32767);
10   LP_SUPPLEMENTARY_RUN VARCHAR2(32767);
11 
12   P_REPORT_MODE VARCHAR2(32767);
13   LP_REPORT_MODE VARCHAR2(32767);
14 
15   P_START_DATE DATE;
16 
17   P_END_DATE DATE;
18   P_START_DATE1 varchar2(40);
19 
20   P_END_DATE1 varchar2(40);
21 
22 format_mask varchar2(25) := 'DD-MON-YYYY';
23   P_REPORT_DATE VARCHAR2(30);
24   LP_REPORT_DATE VARCHAR2(30);
25 
26   P_SORT_BY VARCHAR2(32767);
27 
28   CP_PAYE_YTD NUMBER;
29 
30   CP_EE_PRSI_YTD NUMBER;
31 
32   CP_ER_PRSI_YTD NUMBER;
33 
34   CP_TOTAL_PRSI_REPORT NUMBER;
35 
36   CP_TOTAL_PRSI_YTD NUMBER;
37 
38   CP_PAYE_PTD NUMBER;
39 
40   CP_EE_PRSI_PTD NUMBER;
41 
42   CP_ER_PRSI_PTD NUMBER;
43 
44   CP_PAYROLL_ID VARCHAR2(60) := 'pact_er.ACTION_INFORMATION2';
45 
46   CP_SUPPLEMENTARY_RUN VARCHAR2(80);
47 
48   CP_REPORT_DATE DATE;
49 
50   CP_ORDER_BY VARCHAR2(100);
51 
52   CP_TAX_START_DATE DATE;
53 
54   FUNCTION BEFOREREPORT RETURN BOOLEAN;
55 
56   FUNCTION AFTERREPORT RETURN BOOLEAN;
57 
58   FUNCTION CF_BUSINESS_GROUPFORMULA RETURN VARCHAR2;
59 
60   FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2;
61 
62   FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2;
63 
64   PROCEDURE SET_CURRENCY_FORMAT_MASK;
65 
66   FUNCTION P_BUSINESS_GROUP_IDVALIDTRIGGE RETURN BOOLEAN;
67 
68   FUNCTION CF_CALCULATE_TOTAL_PRSIFORMULA(REPORT_ID IN NUMBER
69                                          ,ASSIGNMENT_ID IN NUMBER) RETURN NUMBER;
70 
71   FUNCTION CF_PAYROLL_NAMEFORMULA(PAYROLL_ID IN VARCHAR2) RETURN CHAR;
72 
73   FUNCTION CP_PAYE_YTD_P RETURN NUMBER;
74 
75   FUNCTION CP_EE_PRSI_YTD_P RETURN NUMBER;
76 
77   FUNCTION CP_ER_PRSI_YTD_P RETURN NUMBER;
78 
79   FUNCTION CP_TOTAL_PRSI_REPORT_P RETURN NUMBER;
80 
81   FUNCTION CP_TOTAL_PRSI_YTD_P RETURN NUMBER;
82 
83   FUNCTION CP_PAYE_PTD_P RETURN NUMBER;
84 
85   FUNCTION CP_EE_PRSI_PTD_P RETURN NUMBER;
86 
87   FUNCTION CP_ER_PRSI_PTD_P RETURN NUMBER;
88 
89   FUNCTION CP_PAYROLL_ID_P RETURN VARCHAR2;
90 
91   FUNCTION CP_SUPPLEMENTARY_RUN_P RETURN VARCHAR2;
92 
93   FUNCTION CP_REPORT_DATE_P RETURN DATE;
94 
95   FUNCTION CP_ORDER_BY_P RETURN VARCHAR2;
96 
97   FUNCTION CP_TAX_START_DATE_P RETURN DATE;
98 
99 END PAY_PAYIEP30_XMLP_PKG;