PACKAGE: APPS.JL_JLARPWFF_XMLP_PKG

Source

1 PACKAGE JL_JLARPWFF_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JLARPWFFS.pls 120.1 2007/12/25 16:35:47 dwkrishn noship $ */
3   P_DEBUG_SWITCH VARCHAR2(1);
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_MIN_PRECISION NUMBER;
8 
9   P_START_DATE DATE;
10 
11   P_END_DATE DATE;
12 
13   P_JURISDICTION_TYPE VARCHAR2(50);
14 
15   P_WITHHOLDING_TYPE_FROM VARCHAR2(30);
16 
17   P_WITHHOLDING_TYPE_TO VARCHAR2(30);
18 
19   P_INCLUDE_FOREIGN_SUPP VARCHAR2(30);
20 
21   P_DOCUMENT_CODE VARCHAR2(6);
22 
23   P_LOCATION_ID NUMBER;
24 
25   C_NLS_YES VARCHAR2(80);
26 
27   C_NLS_NO VARCHAR2(80);
28 
29   C_NLS_ALL VARCHAR2(25);
30 
31   C_NLS_NO_DATA_EXISTS VARCHAR2(240);
32 
33   C_NLS_VOID VARCHAR2(25);
34 
35   C_NLS_NA VARCHAR2(25);
36 
37   C_NLS_END_OF_REPORT VARCHAR2(100);
38 
39   C_REPORT_START_DATE DATE;
40 
41   C_COMPANY_NAME_HEADER VARCHAR2(50);
42 
43   C_BASE_CURRENCY_CODE VARCHAR2(15);
44 
45   C_BASE_PRECISION NUMBER;
46 
47   C_BASE_MIN_ACCT_UNIT NUMBER;
48 
49   C_BASE_DESCRIPTION VARCHAR2(240);
50 
51   C_CHART_OF_ACCOUNTS_ID NUMBER;
52 
53   FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN;
54 
55   FUNCTION CUSTOM_INIT RETURN BOOLEAN;
56 
57   FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
58 
59   FUNCTION GET_NLS_STRINGS RETURN BOOLEAN;
60 
61   FUNCTION BEFOREREPORT RETURN BOOLEAN;
62 
63   FUNCTION AFTERREPORT RETURN BOOLEAN;
64 
65   FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
66 
67   FUNCTION CF_WHT_AGENT_NUMFORMULA(COMP_PRIMARY_ID_NUMBER IN VARCHAR2
68                                   ,COMP_TAX_AUTHORITY_ID IN NUMBER
69                                   ,COMP_TAX_AUTHORITY_TYPE IN VARCHAR2) RETURN VARCHAR2;
70 
71   FUNCTION CF_SUPP_INSCRIPTIONFORMULA(SUPP_PRIMARY_ID_NUMBER IN VARCHAR2
72                                      ,SUPP_TAX_AUTHORITY_ID IN NUMBER
73                                      ,SUPP_TAX_AUTHORITY_TYPE IN VARCHAR2) RETURN VARCHAR2;
74 
75   FUNCTION CF_AMT_IN_EXCESSFORMULA RETURN VARCHAR2;
76 
77   FUNCTION CF_DOCUMENT_AMTFORMULA(DOCUMENT_AMOUNT IN NUMBER) RETURN VARCHAR2;
78 
79   FUNCTION CF_FEDERAL_RECFORMULA(DOCUMENT_DATE IN DATE
80                                 ,DOCUMENT_NUMBER IN VARCHAR2
81                                 ,CF_DOCUMENT_AMT IN VARCHAR2
82                                 ,DGI_TAX_TYPE_CODE IN VARCHAR2
83                                 ,DGI_TAX_REGIME_CODE IN VARCHAR2
84                                 ,WITHHOLDING_CODE IN VARCHAR2
85                                 ,CF_TAXABLE_AMT IN VARCHAR2
86                                 ,SUPPLIER_CONDITION_CODE IN VARCHAR2
87                                 ,CF_WH_AMT IN VARCHAR2
88                                 ,CF_EXEMPT_PERC IN VARCHAR2
89                                 ,BULLETIN_ISSUE_DATE IN VARCHAR2
90                                 ,SUPP_TAX_IDENTIFICATION_TYPE IN VARCHAR2
91                                 ,CUIT_NUMBER IN VARCHAR2
92                                 ,CF_CERT_NUM IN VARCHAR2) RETURN VARCHAR2;
93 
94   FUNCTION CF_PROV_RECFORMULA(DOCUMENT_DATE IN DATE
95                              ,DOCUMENT_NUMBER IN VARCHAR2
96                              ,CF_DOCUMENT_AMT IN VARCHAR2
97                              ,DGI_TAX_TYPE_CODE IN VARCHAR2
98                              ,DGI_TAX_REGIME_CODE IN VARCHAR2
99                              ,WITHHOLDING_CODE IN VARCHAR2
100                              ,CF_TAXABLE_AMT IN VARCHAR2
101                              ,SUPPLIER_CONDITION_CODE IN VARCHAR2
102                              ,CF_WH_AMT IN VARCHAR2
103                              ,CF_EXEMPT_PERC IN VARCHAR2
104                              ,BULLETIN_ISSUE_DATE IN VARCHAR2
105                              ,SUPP_TAX_IDENTIFICATION_TYPE IN VARCHAR2
106                              ,CUIT_NUMBER IN VARCHAR2
107                              ,CF_CERT_NUM IN VARCHAR2
108                              ,CF_WHT_AGENT_NUM IN VARCHAR2
109                              ,CF_SUPP_INSCRIPTION IN VARCHAR2) RETURN VARCHAR2;
110 
111   FUNCTION CF_ZONAL_RECFORMULA(DGI_TAX_REGIME_CODE IN VARCHAR2
112                               ,CUIT_NUMBER IN VARCHAR2
113                               ,CF_AMT_IN_EXCESS IN VARCHAR2
114                               ,DOCUMENT_DATE IN DATE
115                               ,CF_WH_AMT IN VARCHAR2
116                               ,CF_CERT_NUM IN VARCHAR2) RETURN VARCHAR2;
117 
118   FUNCTION CF_TAXABLE_AMTFORMULA(DOCUMENT_AMOUNT IN NUMBER) RETURN VARCHAR2;
119 
120   FUNCTION CF_WH_AMTFORMULA(WITHHOLDING_AMOUNT IN NUMBER) RETURN VARCHAR2;
121 
122   FUNCTION CF_SPACEFORMULA RETURN VARCHAR2;
123 
124   FUNCTION CF_CERT_NUMFORMULA(CERTIFICATE_NUMBER IN NUMBER) RETURN VARCHAR2;
125 
126   FUNCTION CF_EXEMPT_PERCFORMULA(EXEMPTION_PERCENTAGE IN NUMBER) RETURN VARCHAR2;
127 
128   FUNCTION C_NLS_YES_P RETURN VARCHAR2;
129 
130   FUNCTION C_NLS_NO_P RETURN VARCHAR2;
131 
132   FUNCTION C_NLS_ALL_P RETURN VARCHAR2;
133 
134   FUNCTION C_NLS_NO_DATA_EXISTS_P RETURN VARCHAR2;
135 
136   FUNCTION C_NLS_VOID_P RETURN VARCHAR2;
137 
138   FUNCTION C_NLS_NA_P RETURN VARCHAR2;
139 
140   FUNCTION C_NLS_END_OF_REPORT_P RETURN VARCHAR2;
141 
142   FUNCTION C_REPORT_START_DATE_P RETURN DATE;
143 
144   FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
145 
146   FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
147 
148   FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
149 
150   FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
151 
152   FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
153 
154   FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
155 
156 END JL_JLARPWFF_XMLP_PKG;
157 
158