PACKAGE: APPS.PAY_PYAUPYT_XMLP_PKG

Source

1 PACKAGE PAY_PYAUPYT_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PYAUPYLS.pls 120.0 2007/12/13 11:57:53 amakrish noship $ */
3   P_CONC_REQUEST_ID NUMBER;
4 
5   P_BUSINESS_GROUP_ID NUMBER;
6 
7   P_PERIOD DATE;
8   FINAL_DATE VARCHAR2(40);
9 
10   P_TAX_STATE VARCHAR2(40);
11 
12   P_REPORT_TYPE VARCHAR2(1);
13 
14   P_LEGAL_EMPLOYER VARCHAR2(80);
15 
16   P_VIC NUMBER;
17 
18   P_ACT NUMBER;
19 
20   P_NSW NUMBER;
21 
22   P_QLD NUMBER;
23 
24   P_SA NUMBER;
25 
26   P_TAS NUMBER;
27 
28   P_NT NUMBER;
29 
30   P_REPORT_NAME VARCHAR2(32767);
31 
32   P_WA NUMBER;
33 
34   P_START_DATE DATE;
35 
36   P_END_DATE DATE;
37 
38   P_PAYROLL_ACTION_ID VARCHAR2(40);
39 
40   P_STATE_CODE VARCHAR2(40);
41 
42   P_PAYROLL_ACTION_ID_LP VARCHAR2(40);
43   P_BUSINESS_GROUP_ID_LP NUMBER;
44   P_LEGAL_EMPLOYER_LP VARCHAR2(80);
45   P_PERIOD_LP DATE;
46   P_PERIOD_LP_1 VARCHAR2(40);
47   P_START_DATE_LP DATE;
48   P_START_DATE_LP_1 VARCHAR2(40);
49   P_END_DATE_LP DATE;
50   P_END_DATE_LP_1 VARCHAR2(40);
51   P_TAX_STATE_LP VARCHAR2(40);
52   P_ACT_LP NUMBER;
53   P_QLD_LP NUMBER;
54   P_SA_LP NUMBER;
55   P_TAS_LP NUMBER;
56   P_VIC_LP NUMBER;
57   P_WA_LP NUMBER;
58   P_NSW_LP NUMBER;
59   P_NT_LP NUMBER;
60   P_REPORT_TYPE_LP VARCHAR2(1);
61   P_REPORT_NAME_LP VARCHAR2(32767);
62 
63 
64 
65   CP_OT_MESSAGE VARCHAR2(100);
66 
67   CP_MESSAGE VARCHAR2(100);
68 
69   CP_CURRENCY VARCHAR2(20);
70 
71   CP_TAX_STATE VARCHAR2(80);
72 
73   CP_REPORT_TYPE VARCHAR2(80);
74 
75   CP_LEGAL_EMPLOYER VARCHAR2(80);
76 
77   CP_DGE NUMBER;
78 
79   FUNCTION AFTERREPORT RETURN BOOLEAN;
80 
81   FUNCTION CF_BUSINESS_GROUPFORMULA RETURN VARCHAR2;
82 
83   FUNCTION BEFOREREPORT RETURN BOOLEAN;
84 
85   FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2;
86 
87   FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2;
88 
89   FUNCTION CF_STATE_TAXFORMULA(NO_OF_STATES IN NUMBER
90                               ,CS_DGE_STATE IN VARCHAR2
91                               ,CS_DGE_GROUP_NAME IN VARCHAR2
92                               ,STATE_CODE IN VARCHAR2
93                               ,CS_STATE_TAXABLE_INCOME IN NUMBER
94                               ,LE_TAXABLE_INCOME IN NUMBER
95                               ,CS_NO_OF_STATES IN NUMBER
96                               ,CS_TOTAL_TAXABLE_INCOME_LE IN NUMBER) RETURN NUMBER;
97 
98   PROCEDURE SET_FORMAT_MASK;
99 
100   FUNCTION CP_OT_MESSAGE_P RETURN VARCHAR2;
101 
102   FUNCTION CP_MESSAGE_P RETURN VARCHAR2;
103 
104   FUNCTION CP_CURRENCY_P RETURN VARCHAR2;
105 
106   FUNCTION CP_TAX_STATE_P RETURN VARCHAR2;
107 
108   FUNCTION CP_REPORT_TYPE_P RETURN VARCHAR2;
109 
110   FUNCTION CP_LEGAL_EMPLOYER_P RETURN VARCHAR2;
111 
112   FUNCTION CP_DGE_P RETURN NUMBER;
113 
114 END PAY_PYAUPYT_XMLP_PKG;