PACKAGE: APPS.JL_JLZZPSSR_XMLP_PKG

Source

1 PACKAGE JL_JLZZPSSR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JLZZPSSRS.pls 120.1 2007/12/25 16:54:47 dwkrishn noship $ */
3   P_DEBUG_SWITCH VARCHAR2(1);
4 
5   CP_SOB_ID  VARCHAR2(15);
6 
7   CP_START_DATE VARCHAR2(20);
8 
9   CP_END_DATE VARCHAR2(20);
10 
11   P_CONC_REQUEST_ID NUMBER;
12 
13   P_SOB_ID VARCHAR2(15);
14 
15   P_TRACE_SWITCH VARCHAR2(1);
16 
17   P_REPORT_CURRENCY VARCHAR2(15);
18 
19   P_START_DATE DATE;
20 
21   P_SUPPLIER_NAME_FROM VARCHAR2(240);
22 
23   P_SUPPLIER_NAME_TO VARCHAR2(240);
24 
25   P_COUNTRY_CODE VARCHAR2(32767) :='CL';
26 
27   P_ORG_ID VARCHAR2(15);
28 
29   P_SUPPLIER_TAX_ID VARCHAR2(30);
30 
31   P_MIN_PRECISION NUMBER;
32 
33   P_END_DATE DATE;
34 
35   P_CA_SET_OF_BOOKS_ID NUMBER;
36 
37   LP_AP_SYSTEM_PARAMETERS VARCHAR2(50);
38 
39   P_CA_ORG_ID NUMBER;
40 
41   P_MRCSOBTYPE VARCHAR2(10);
42 
43   LP_AP_INVOICES VARCHAR2(50) := 'ap_invoices_all';
44 
45   LP_AP_INVOICE_DISTRIBUTIONS VARCHAR2(50) := 'ap_invoice_distributions_all';
46 
47   P_LEGAL_ENTITY_ID NUMBER;
48 
49   LP_AP_INVOICE_PAYMENTS VARCHAR2(50) := 'ap_invoice_payments_all';
50 
51   LP_AP_CHECKS VARCHAR2(50);
52 
53   P_REPORTING_LEVEL VARCHAR2(60);
54 
55   P_REPORTING_CONTEXT NUMBER;
56 
57   LP_AP_CHECKS_WH VARCHAR2(500);
58 
59   LP_AP_INVOICES_WH VARCHAR2(500);
60 
61   LP_AP_INVOICE_DISTRIBUTIONS_WH VARCHAR2(500);
62 
63   LP_AP_INVOICE_PAYMENTS_WH VARCHAR2(500);
64 
65   CP_REF_TRANS_NUM VARCHAR2(15);
66 
67   CP_REF_TRANS_TYPE VARCHAR2(32767);
68 
69   C_NLS_YES VARCHAR2(80);
70 
71   C_NLS_NO VARCHAR2(80);
72 
73   C_NLS_ALL VARCHAR2(25);
74 
75   C_NLS_NO_DATA_EXISTS VARCHAR2(240);
76 
77   C_NLS_VOID VARCHAR2(25);
78 
79   C_NLS_NA VARCHAR2(25);
80 
81   C_NLS_END_OF_REPORT VARCHAR2(100);
82 
83   C_REPORT_START_DATE DATE;
84 
85   C_COMPANY_NAME_HEADER VARCHAR2(50);
86 
87   C_BASE_CURRENCY_CODE VARCHAR2(15);
88 
89   C_BASE_PRECISION NUMBER;
90 
91   C_BASE_MIN_ACCT_UNIT NUMBER;
92 
93   C_BASE_DESCRIPTION VARCHAR2(240);
94 
95   C_CHART_OF_ACCOUNTS_ID NUMBER;
96 
97   APPLICATIONS_TEMPLATE_REPORT VARCHAR2(1);
98 
99   CP_CREATE_AWT_DISTS_TYPE VARCHAR2(32767);
100 
101   LP_SUPPLIER VARCHAR2(1000);
102 
103   CP_DATE4_FORMAT VARCHAR2(20);
104 
105   CP_MESSAGE VARCHAR2(300);
106 
107   FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN;
108 
109   FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
110 
111   FUNCTION GET_NLS_STRINGS RETURN BOOLEAN;
112 
113   FUNCTION BEFOREREPORT RETURN BOOLEAN;
114 
115   FUNCTION AFTERREPORT RETURN BOOLEAN;
116 
117   FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
118 
119   FUNCTION CF_REF_TRANS_DATEFORMULA(TRANS_TYPE IN VARCHAR2
120                                    ,TRANS_ID IN NUMBER) RETURN DATE;
121 
122   FUNCTION CF_AMOUNT_CURRENCYFORMULA(TRANS_AMT IN NUMBER
123                                     ,TRANS_BASE_AMT IN NUMBER) RETURN NUMBER;
124 
125   FUNCTION CF_AMOUNT_DUE_CURRENCYFORMULA(TRANS_TYPE IN VARCHAR2
126                                         ,TRANS_ID IN NUMBER
127                                         ,TRANS_AMT IN NUMBER
128                                         ,TRANS_BASE_AMT IN NUMBER
129                                         ,SECTION IN VARCHAR2
130                                         ,CF_TRX_PRECISION IN NUMBER) RETURN NUMBER;
131 
132   PROCEDURE GET_AWT_TIME;
133 
134   FUNCTION CF_SUPP_BBFORMULA(VENDOR_ID IN NUMBER
135                             ,GROUP_CURRENCY IN VARCHAR2
136                             ,CF_GROUP_PRECISION IN NUMBER) RETURN NUMBER;
137 
138   FUNCTION CF_GROUP_PRECISIONFORMULA(GROUP_CURRENCY IN VARCHAR2) RETURN NUMBER;
139 
140   FUNCTION CF_REMAIN_BALANCEFORMULA(CF_SUPP_BB IN NUMBER
141                                    ,CS_AMOUNT_APPLIED IN NUMBER) RETURN NUMBER;
142 
143   FUNCTION CF_TRX_PRECISIONFORMULA(TRANS_CURRENCY IN VARCHAR2) RETURN NUMBER;
144 
145   FUNCTION CF_ENDING_BALANCEFORMULA(CF_SUPP_BB IN NUMBER
146                                    ,CS_ACCUM_BALANCE IN NUMBER) RETURN NUMBER;
147 
148   FUNCTION ACCEPT_PARAMETERS RETURN BOOLEAN;
149 
150   FUNCTION CF_AMOUNT_TO_APPLYFORMULA(SECTION IN VARCHAR2
151                                     ,CF_AMOUNT_CURRENCY IN NUMBER
152                                     ,CF_AMOUNT_DUE_CURRENCY IN NUMBER) RETURN NUMBER;
153 
154   FUNCTION AFTERPFORM RETURN BOOLEAN;
155 
156   FUNCTION CP_REF_TRANS_NUM_P RETURN VARCHAR2;
157 
158   FUNCTION CP_REF_TRANS_TYPE_P RETURN VARCHAR2;
159 
160   FUNCTION C_NLS_YES_P RETURN VARCHAR2;
161 
162   FUNCTION C_NLS_NO_P RETURN VARCHAR2;
163 
164   FUNCTION C_NLS_ALL_P RETURN VARCHAR2;
165 
166   FUNCTION C_NLS_NO_DATA_EXISTS_P RETURN VARCHAR2;
167 
168   FUNCTION C_NLS_VOID_P RETURN VARCHAR2;
169 
170   FUNCTION C_NLS_NA_P RETURN VARCHAR2;
171 
172   FUNCTION C_NLS_END_OF_REPORT_P RETURN VARCHAR2;
173 
174   FUNCTION C_REPORT_START_DATE_P RETURN DATE;
175 
176   FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
177 
178   FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
179 
180   FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
181 
182   FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
183 
184   FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
185 
186   FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
187 
188   FUNCTION APPLICATIONS_TEMPLATE_REPORT_P RETURN VARCHAR2;
189 
190   FUNCTION CP_CREATE_AWT_DISTS_TYPE_P RETURN VARCHAR2;
191 
192   FUNCTION LP_SUPPLIER_P RETURN VARCHAR2;
193 
194   FUNCTION CP_DATE4_FORMAT_P RETURN VARCHAR2;
195 
196   FUNCTION CP_MESSAGE_P RETURN VARCHAR2;
197 
198  FUNCTION  CUSTOM_INIT   RETURN BOOLEAN;
199 
200 END JL_JLZZPSSR_XMLP_PKG;
201 
202 
203