eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.JE_JEPLPSSR_XMLP_PKG

Source


1 PACKAGE JE_JEPLPSSR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JEPLPSSRS.pls 120.1 2007/12/25 16:58:23 dwkrishn noship $ */
3   P_DEBUG_SWITCH VARCHAR2(1);
4 
5   P_CONC_REQUEST_ID NUMBER;
6 
7   P_LEDGER_ID NUMBER;
8 
9   P_TRACE_SWITCH VARCHAR2(1);
10 
11   P_REPORT_CURRENCY VARCHAR2(15);
12 
13   P_START_DATE date;
14 
15   LP_START_DATE date;
16 
17   --lp_start_date varchar2(30);
18 
19   P_SUPPLIER_NAME_FROM VARCHAR2(240);
20 
21   P_SUPPLIER_NAME_TO VARCHAR2(240);
22 
23   P_COUNTRY_CODE VARCHAR2(32767);
24 
25   P_SUPPLIER_TAX_ID VARCHAR2(30);
26 
27   P_MIN_PRECISION NUMBER;
28 
29   P_END_DATE DATE;
30 
31   LP_END_DATE DATE;
32 
33   --LP_END_DATE varchar2(30);
34 
35   P_DOCUMENT_CATEGORY VARCHAR2(32767);
36 
37   P_POSTED VARCHAR2(3);
38 
39   P_APPROVED VARCHAR2(10);
40 
41   P_WHERE VARCHAR2(100);
42 
43   P_PARAMETERS_DESC VARCHAR2(100);
44 
45   CP_PARAMETERS_DESC VARCHAR2(100);
46 
47   P_WHERE_CAT VARCHAR2(100):=' ';
48 
49   P_LEDGER_NAME VARCHAR2(70);
50 
51   P_VENDOR_ID NUMBER;
52 
53   P_REPORT_CURRENCY_DISP VARCHAR2(25);
54 
55   P_REPORTING_LEVEL VARCHAR2(30);
56 
57   P_REPORTING_ENTITY_ID NUMBER;
58 
59   P_ORG_WHERE_POSIT VARCHAR2(2000);
60 
61   P_ORG_WHERE_AI VARCHAR2(2000);
62 
63   P_ORG_WHERE_AID VARCHAR2(2000);
64 
65   P_ORG_WHERE_ALC VARCHAR2(2000);
66 
67   P_ORG_WHERE_AC VARCHAR2(2000);
68 
69   P_REPORTING_ENTITY_NAME VARCHAR2(50);
70 
71   P_REPORTING_LEVEL_NAME VARCHAR2(50);
72 
73   P_ORG_WHERE_AIP VARCHAR2(2000);
74 
75   P_ORG_WHERE_AI2 VARCHAR2(2000);
76 
77   P_ORG_WHERE_AID2 VARCHAR2(2000);
78 
79   P_CHECK_LEDGER_IN_SP VARCHAR2(10);
80 
81   P_PARTIAL_LEDGER_MSG VARCHAR2(240);
82 
83   CP_TEXT VARCHAR2(200);
84 
85   CP_REF_TRANS_NUM VARCHAR2(15);
86 
87   CP_REF_TRANS_TYPE VARCHAR2(32767);
88 
89   C_NLS_YES VARCHAR2(80);
90 
91   C_NLS_NO VARCHAR2(80);
92 
93   C_NLS_ALL VARCHAR2(25);
94 
95   C_NLS_NO_DATA_EXISTS VARCHAR2(240);
96 
97   C_NLS_VOID VARCHAR2(25);
98 
99   C_NLS_NA VARCHAR2(25);
100 
101   C_NLS_END_OF_REPORT VARCHAR2(100);
102 
103   C_REPORT_START_DATE DATE;
104 
105   C_COMPANY_NAME_HEADER VARCHAR2(50);
106 
107   C_BASE_CURRENCY_CODE VARCHAR2(15);
108 
109   C_BASE_PRECISION NUMBER;
110 
111   C_BASE_MIN_ACCT_UNIT NUMBER;
112 
113   C_BASE_DESCRIPTION VARCHAR2(240);
114 
115   C_CHART_OF_ACCOUNTS_ID NUMBER;
116 
117   APPLICATIONS_TEMPLATE_REPORT VARCHAR2(1);
118 
119   CP_CREATE_AWT_DISTS_TYPE VARCHAR2(32767);
120 
121   LP_SUPPLIER VARCHAR2(1000);
122 
123   CP_DATE4_FORMAT VARCHAR2(20);
124 
125   CP_MESSAGE VARCHAR2(300);
126 
127   CP_REPORT_CURRENCY VARCHAR2(32767);
128 
129   CP_REPORT_CURR_DISP VARCHAR2(20);
130 
131   CP_SUPPLIER_NAME_FROM VARCHAR2(240);
132 
133   CP_SUPPLIER_NAME_TO VARCHAR2(240);
134 
135   CP_POSTED_FLAG VARCHAR2(32767);
136 
137   CP_APPROVED_FLAG VARCHAR2(32767);
138 
139   CP_LEDGER_NAME VARCHAR2(50);
140 
141   CP_SUPPLIER_TAX_ID VARCHAR2(30);
142 
143   CP_DOCUMENT_CATEGORY VARCHAR2(100);
144 
145   CP_TITLE VARCHAR2(240);
146 
147   CP_PARTIAL_LEDGER_MSG VARCHAR2(240);
148 
149   FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN;
150 
151   FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
152 
153   FUNCTION GET_NLS_STRINGS RETURN BOOLEAN;
154 
155   FUNCTION BEFOREREPORT RETURN BOOLEAN;
156 
157   FUNCTION AFTERREPORT RETURN BOOLEAN;
158 
159   FUNCTION CF_REF_TRANS_DATEFORMULA(TRANS_TYPE IN VARCHAR2
160                                    ,TRANS_ID IN NUMBER) RETURN DATE;
161 
162   FUNCTION CF_AMOUNT_CURRENCYFORMULA(TRANS_AMT IN NUMBER
163                                     ,TRANS_BASE_AMT IN NUMBER) RETURN NUMBER;
164 
165   FUNCTION CF_AMOUNT_DUE_CURRENCYFORMULA(TRANS_TYPE IN VARCHAR2
166                                         ,TRANS_ID IN NUMBER
167                                         ,TRANS_AMT IN NUMBER
168                                         ,TRANS_BASE_AMT IN NUMBER
169                                         ,SECTION IN VARCHAR2
170                                         ,CF_TRX_PRECISION IN NUMBER) RETURN NUMBER;
171 
172   FUNCTION CF_SUPP_BBFORMULA(VENDOR_ID IN NUMBER
173                             ,GROUP_CURRENCY IN VARCHAR2
174                             ,CF_GROUP_PRECISION IN NUMBER) RETURN NUMBER;
175 
176   FUNCTION CF_GROUP_PRECISIONFORMULA(GROUP_CURRENCY IN VARCHAR2) RETURN NUMBER;
177 
178   FUNCTION CF_REMAIN_BALANCEFORMULA(CF_SUPP_BB IN NUMBER
179                                    ,CS_AMOUNT_APPLIED IN NUMBER) RETURN NUMBER;
180 
181   FUNCTION CF_TRX_PRECISIONFORMULA(TRANS_CURRENCY IN VARCHAR2) RETURN NUMBER;
182 
183   FUNCTION CF_ENDING_BALANCEFORMULA(CF_SUPP_BB IN NUMBER
184                                    ,CS_ACCUM_BALANCE IN NUMBER) RETURN NUMBER;
185 
186   FUNCTION ACCEPT_PARAMETERS RETURN BOOLEAN;
187 
188   FUNCTION CF_AMOUNT_TO_APPLYFORMULA(SECTION IN VARCHAR2
189                                     ,RELATE_TRANS_TYPE IN VARCHAR2
190                                     ,CF_AMOUNT_CURRENCY IN NUMBER
191                                     ,CF_AMOUNT_DUE_CURRENCY IN NUMBER) RETURN NUMBER;
192 
193   FUNCTION CF_1FORMULA(TRANS_ID IN NUMBER) RETURN CHAR;
194 
195   FUNCTION CF_TRANS_DATEFORMULA(TRANS_DATE IN DATE) RETURN CHAR;
196 
197   FUNCTION CF_REF_TRANS_DATE1FORMULA(REF_TRANS_DATE IN DATE) RETURN CHAR;
198 
199   FUNCTION CF_START_DATEFORMULA RETURN CHAR;
200 
201   FUNCTION CF_END_DATEFORMULA RETURN CHAR;
202 
203   FUNCTION CF_COVER_START_DATEFORMULA RETURN CHAR;
204 
205   FUNCTION CF_COVER_END_DATEFORMULA RETURN CHAR;
206 
207   FUNCTION CF_TEXTFORMULA(DESCRIPTION1 IN VARCHAR2
208                          ,GROUP_CURRENCY IN VARCHAR2
209                          ,CF_AMT_DUE_DSP IN VARCHAR2) RETURN CHAR;
210 
211   FUNCTION CF_AMOUNT_DUEFORMULA(VENDOR_ID IN NUMBER
212                                ,VENDOR_SITE_ID IN NUMBER
213                                ,CF_ENDING_BALANCE IN NUMBER) RETURN NUMBER;
214 
215   FUNCTION CF_VENDOR_CHECKFORMULA(VENDOR_ID IN NUMBER) RETURN NUMBER;
216 
217   FUNCTION CF_POSTED_ONLYFORMULA RETURN CHAR;
218 
219   FUNCTION CF_APPROVED_ONLYFORMULA RETURN CHAR;
220 
221   FUNCTION CF_GROUP_CURRFORMULA(GROUP_CURRENCY IN VARCHAR2) RETURN CHAR;
222 
223   FUNCTION CP_TEXTFORMULA(CF_TEXT IN VARCHAR2) RETURN CHAR;
224 
225   FUNCTION AFTERPFORM RETURN BOOLEAN;
226 
227   FUNCTION CF_ORG_NAMEFORMULA(ORGANIZATION_ID IN NUMBER) RETURN CHAR;
228 
229   FUNCTION P_CHECK_LEDGER_IN_SPVALIDTRIGG RETURN BOOLEAN;
230 
231   FUNCTION P_PARTIAL_LEDGER_MSGVALIDTRIGG RETURN BOOLEAN;
232 
233   FUNCTION CP_TEXT_P RETURN VARCHAR2;
234 
235   FUNCTION CP_REF_TRANS_NUM_P RETURN VARCHAR2;
236 
237   FUNCTION CP_REF_TRANS_TYPE_P RETURN VARCHAR2;
238 
239   FUNCTION C_NLS_YES_P RETURN VARCHAR2;
240 
241   FUNCTION C_NLS_NO_P RETURN VARCHAR2;
242 
243   FUNCTION C_NLS_ALL_P RETURN VARCHAR2;
244 
245   FUNCTION C_NLS_NO_DATA_EXISTS_P RETURN VARCHAR2;
246 
247   FUNCTION C_NLS_VOID_P RETURN VARCHAR2;
248 
249   FUNCTION C_NLS_NA_P RETURN VARCHAR2;
250 
251   FUNCTION C_NLS_END_OF_REPORT_P RETURN VARCHAR2;
252 
253   FUNCTION C_REPORT_START_DATE_P RETURN DATE;
254 
255   FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
256 
257   FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
258 
259   FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
260 
261   FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
262 
263   FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
264 
265   FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
266 
267   FUNCTION APPLICATIONS_TEMPLATE_REPORT_P RETURN VARCHAR2;
268 
269   FUNCTION CP_CREATE_AWT_DISTS_TYPE_P RETURN VARCHAR2;
270 
271   FUNCTION LP_SUPPLIER_P RETURN VARCHAR2;
272 
273   FUNCTION CP_DATE4_FORMAT_P RETURN VARCHAR2;
274 
275   FUNCTION CP_MESSAGE_P RETURN VARCHAR2;
276 
277   FUNCTION CP_REPORT_CURRENCY_P RETURN VARCHAR2;
278 
279   FUNCTION CP_REPORT_CURR_DISP_P RETURN VARCHAR2;
280 
281   FUNCTION CP_SUPPLIER_NAME_FROM_P RETURN VARCHAR2;
282 
283   FUNCTION CP_SUPPLIER_NAME_TO_P RETURN VARCHAR2;
284 
285   FUNCTION CP_POSTED_FLAG_P RETURN VARCHAR2;
286 
287   FUNCTION CP_APPROVED_FLAG_P RETURN VARCHAR2;
288 
289   FUNCTION CP_LEDGER_NAME_P RETURN VARCHAR2;
290 
291   FUNCTION CP_SUPPLIER_TAX_ID_P RETURN VARCHAR2;
292 
293   FUNCTION CP_DOCUMENT_CATEGORY_P RETURN VARCHAR2;
294 
295   FUNCTION CP_TITLE_P RETURN VARCHAR2;
296 
297   FUNCTION CP_PARTIAL_LEDGER_MSG_P RETURN VARCHAR2;
298 
299   FUNCTION CONVERT(P_YES_NO IN VARCHAR2) RETURN VARCHAR2;
300 
301   FUNCTION  CUSTOM_INIT RETURN BOOLEAN;
302 
303 END JE_JEPLPSSR_XMLP_PKG;
304 
305