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.INV_INVSTMVT_XMLP_PKG

Source


1 PACKAGE INV_INVSTMVT_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: INVSTMVTS.pls 120.1 2007/12/25 11:02:29 dwkrishn noship $ */
3   PLEX_COMMODITY_FLEX VARCHAR2(900);
4 
5 QTY_PRECISION varchar2(100);
6 
7   PLEX_COMMODITY_ORDER_BY VARCHAR2(900);
8 
9   PLEX_COMMODITY_STRUCT_NUM VARCHAR2(15);
10 
11   PLEX_ITEM_FLEX VARCHAR2(900);
12 
13   PLEX_ITEM_STRUCT_NUM VARCHAR2(15);
14 
15   P_LEGAL_ENTITY_ID NUMBER;
16 
17   P_ZONE_CODE VARCHAR2(10);
18 
19   P_USAGE_TYPE VARCHAR2(30);
20 
21   P_STAT_TYPE VARCHAR2(30);
22 
23   P_MOVEMENT_TYPE VARCHAR2(30);
24 
25   P_PERIOD_NAME VARCHAR2(15);
26 
27   P_REPORT_OPTION VARCHAR2(30);
28 
29   P_CONC_REQUEST_ID NUMBER;
30 
31   P_USER_ID NUMBER;
32 
33   P_QUANTITY_PRECISION NUMBER;
34 
35   P_OE_OR_OM VARCHAR2(30);
36 
37   P_CURRENCY_CODE VARCHAR2(15);
38 
39   P_EXCHANGE_RATE NUMBER;
40 
41   P_EXCHANGE_RATE_CHAR VARCHAR2(38);
42 
43   P_MVT_ID_WHERE VARCHAR2(1000);
44 
45   P_AMOUNT_DISPLAY VARCHAR2(32767);
46 
47   P_REP_PRECISION NUMBER;
48 
49   P_REP_ROUNDING VARCHAR2(30);
50 
51   CP_REQUESTED_BY VARCHAR2(100);
52 
53   CP_APPLICATION VARCHAR2(240);
54 
55   CP_RESPONSIBILITY VARCHAR2(200);
56 
57   CP_REQUEST_TIME VARCHAR2(30);
58 
59   CP_LEGAL_ENTITY_NAME VARCHAR2(240);
60 
61   CP_ENTITY_ADDRESS_LINE_1 VARCHAR2(240);
62 
63   CP_ENTITY_ADDRESS_LINE_2 VARCHAR2(240);
64 
65   CP_ENTITY_ADDRESS_LINE_3 VARCHAR2(240);
66 
67   CP_TELEPHONE_NUMBER_1 VARCHAR2(60);
68 
69   CP_TELEPHONE_NUMBER_2 VARCHAR2(60);
70 
71   CP_CONTACT_PERSON_NAME VARCHAR2(240);
72 
73   CP_VAT_REGISTRATION_NUMBER VARCHAR2(150);
74 
75   CP_SET_OF_BOOKS_NAME VARCHAR2(30);
76 
77   CP_TAX_OFFICE_NAME VARCHAR2(240);
78 
79   CP_TAX_OFFICE_ADDRESS_LINE_1 VARCHAR2(240);
80 
81   CP_TAX_OFFICE_ADDRESS_LINE_2 VARCHAR2(240);
82 
83   CP_TAX_OFFICE_ADDRESS_LINE_3 VARCHAR2(240);
84 
85   CP_START_DATE DATE;
86 
87   CP_END_DATE DATE;
88 
89   CP_STANDARD_UOM VARCHAR2(20);
90 
91   CP_SYSDATE VARCHAR2(20);
92 
93   CP_EXT_PRECISION_FUNC NUMBER;
94 
95   CP_ZONE_NAME_COV VARCHAR2(80);
96 
97   CP_MV_TYPE_COV VARCHAR2(80);
98 
99   CP_REP_OPTION_COV VARCHAR2(30);
100 
101   CP_USAGE_TYPE_COV VARCHAR2(80);
102 
103   CP_STAT_TYPE_COV VARCHAR2(80);
104 
105   CP_PRECISION_FUNC NUMBER;
106 
107   CP_REPORT_TITLE VARCHAR2(100);
108 
109   FUNCTION CF_PARENT_MVT_TERR_CODEFORMULA(C_DISPATCH_TERR_EU_CODE IN VARCHAR2
110                                          ,C_DESTINATION_TERR_EU_CODE IN VARCHAR2) RETURN VARCHAR2;
111 
112   PROCEDURE FORMAT_QUANTITY(P_PRECISION IN NUMBER);
113 
114   FUNCTION CF_COMMODITY_FIELDFORMULA RETURN VARCHAR2;
115 
116   FUNCTION CF_1FORMULA RETURN VARCHAR2;
117 
118   FUNCTION CF_INVOICEFORMULA(C_DOCUMENT_SOURCE_TYPE IN VARCHAR2
119                             ,C_INVOICE_REFERENCE IN VARCHAR2
120                             ,C_INVOICE_ID IN NUMBER
121                             ,C_MOVEMENT_TYPE IN VARCHAR2) RETURN CHAR;
122 
123   FUNCTION CF_INVOICE_BATCHFORMULA(C_DOCUMENT_SOURCE_TYPE IN VARCHAR2
124                                   ,C_INVOICE_BATCH_REFERENCE IN VARCHAR2
125                                   ,C_INVOICE_BATCH_ID IN NUMBER) RETURN CHAR;
126 
127   FUNCTION CF_INVOICE_LINEFORMULA(C_DOCUMENT_SOURCE_TYPE IN VARCHAR2
128                                  ,C_INVOICE_LINE_REFERENCE IN VARCHAR2
129                                  ,C_MOVEMENT_TYPE IN VARCHAR2
130                                  ,C_DISTRIBUTION_LINE_NUMBER IN NUMBER
131                                  ,C_CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN CHAR;
132 
133   FUNCTION CF_INVOICE_UOM_CODEFORMULA(C_CUSTOMER_TRX_LINE_ID IN NUMBER
134                                      ,C_TRANSACTION_UOM_CODE IN VARCHAR2) RETURN VARCHAR2;
135 
136   FUNCTION CF_RECEIPT_NUMBERFORMULA(C_DOCUMENT_SOURCE_TYPE IN VARCHAR2
137                                    ,C_RECEIPT_REFERENCE IN VARCHAR2
138                                    ,C_PICK_SLIP_REFERENCE IN VARCHAR2
139                                    ,C_SHIPMENT_HEADER_ID IN NUMBER
140                                    ,C_SHIPMENT_REFERENCE IN VARCHAR2) RETURN VARCHAR2;
141 
142   FUNCTION CF_SHIPMENT_LINEFORMULA(C_DOCUMENT_SOURCE_TYPE IN VARCHAR2
143                                   ,C_SHIPMENT_LINE_REFERENCE IN VARCHAR2
144                                   ,C_SHIPMENT_LINE_ID IN NUMBER) RETURN VARCHAR2;
145 
146   FUNCTION CF_SHIPMENT_NUMBERFORMULA(C_DOCUMENT_SOURCE_TYPE IN VARCHAR2
147                                     ,C_SHIPMENT_REFERENCE IN VARCHAR2
148                                     ,C_PO_LINE_LOCATION_ID IN NUMBER) RETURN VARCHAR2;
149 
150   FUNCTION CF_SOURCE_LINE_NUMBERFORMULA(C_DOCUMENT_SOURCE_TYPE IN VARCHAR2
151                                        ,C_DOCUMENT_LINE_REFERENCE IN VARCHAR2
152                                        ,C_PO_LINE_ID IN NUMBER
153                                        ,C_ORDER_LINE_ID IN NUMBER
154                                        ,C_MOVEMENT_TYPE IN VARCHAR2
155                                        ,C_REQUISITION_LINE_ID IN NUMBER) RETURN VARCHAR2;
156 
157   FUNCTION CF_SOURCE_NUMBERFORMULA(C_DOCUMENT_SOURCE_TYPE IN VARCHAR2
158                                   ,C_DOCUMENT_REFERENCE IN VARCHAR2
159                                   ,C_PO_HEADER_ID IN NUMBER
160                                   ,C_ORDER_HEADER_ID IN NUMBER
161                                   ,C_MOVEMENT_TYPE IN VARCHAR2
162                                   ,C_REQUISITION_HEADER_ID IN NUMBER
163                                   ,C_MTL_TRANSACTION_ID IN NUMBER) RETURN VARCHAR2;
164 
165   FUNCTION CF_TRADER_NAMEFORMULA(C_DOCUMENT_SOURCE_TYPE IN VARCHAR2
166                                 ,C_CUSTOMER_NAME IN VARCHAR2
167                                 ,C_SHIP_TO_CUSTOMER_ID IN NUMBER
168                                 ,C_VENDOR_NAME IN VARCHAR2
169                                 ,C_FROM_ORGANIZATION_ID IN NUMBER
170                                 ,C_TO_ORGANIZATION_ID IN NUMBER
171                                 ,C_TRANSACTING_FROM_ORG IN VARCHAR2
172                                 ,C_TRANSACTING_TO_ORG IN VARCHAR2) RETURN VARCHAR2;
173 
174   FUNCTION CF_TRADER_NUMBERFORMULA(C_DOCUMENT_SOURCE_TYPE IN VARCHAR2
175                                   ,C_CUSTOMER_NUMBER IN VARCHAR2
176                                   ,C_SHIP_TO_CUSTOMER_ID IN NUMBER
177                                   ,C_VENDOR_NUMBER IN VARCHAR2
178                                   ,C_TRANSACTING_FROM_ORG IN VARCHAR2
179                                   ,C_TRANSACTING_TO_ORG IN VARCHAR2) RETURN VARCHAR2;
180 
181   FUNCTION CF_TRADER_SITEFORMULA(C_DOCUMENT_SOURCE_TYPE IN VARCHAR2
182                                 ,C_CUSTOMER_LOCATION IN VARCHAR2
183                                 ,C_SHIP_TO_SITE_USE_ID IN NUMBER
184                                 ,C_VENDOR_SITE IN VARCHAR2
185                                 ,C_CUSTOMER_NAME IN VARCHAR2
186                                 ,C_VENDOR_NAME IN VARCHAR2
187                                 ,C_TRANSACTING_FROM_ORG IN VARCHAR2
188                                 ,C_TRANSACTING_TO_ORG IN VARCHAR2) RETURN VARCHAR2;
189 
190   FUNCTION CF_TRADER_TYPEFORMULA(C_DOCUMENT_SOURCE_TYPE IN VARCHAR2
191                                 ,C_CUSTOMER_NAME IN VARCHAR2
192                                 ,C_VENDOR_NAME IN VARCHAR2
193                                 ,C_TRANSACTING_FROM_ORG IN VARCHAR2
194                                 ,C_TRANSACTING_TO_ORG IN VARCHAR2) RETURN VARCHAR2;
195 
196   FUNCTION AFTERREPORT(CS_NO_COUNT IN NUMBER) RETURN BOOLEAN;
197 
198   FUNCTION CF_PARENT_MVT_QUANTITYFORMULA(CS_ALTERNATE_QUANTITY IN VARCHAR2
199                                         ,CS_TRANSACTION_QUANTITY IN VARCHAR2) RETURN NUMBER;
200 
201   FUNCTION CF_PARENT_MVT_UOMFORMULA(C_ALTERNATE_UOM_CODE IN VARCHAR2
202                                    ,C_TRANSACTION_UOM_CODE IN VARCHAR2) RETURN CHAR;
203 
204   FUNCTION CF_STATISTICAL_VALUE_RFORMUL(CS_STATISTICAL_VALUE IN VARCHAR2) RETURN NUMBER;
205 
206   FUNCTION CF_TRANSACTION_VALUE_RFORMUL(CS_TRANSACTION_VALUE IN VARCHAR2) RETURN NUMBER;
207 
208   FUNCTION CF_INVOICE_LINE_EXT_VAL_RFORMU(CS_INVOICE_VALUE IN VARCHAR2
209                                          ,CF_PRECISION_TRX IN NUMBER) RETURN NUMBER;
210 
211   FUNCTION CF_DOCUMENT_LINE_EXT_VAL_RFORM(CS_DOC_VALUE IN VARCHAR2
212                                          ,CF_PRECISION_TRX IN NUMBER) RETURN NUMBER;
213 
214   FUNCTION CF_REPORT_TRANSACTION_VAL_RFOR(CS_REPORT_TRANSACTION_VAL IN NUMBER) RETURN NUMBER;
215 
216   FUNCTION CF_REPORT_STATISTICAL_VAL_RFOR(CS_REPORT_STATISTICAL_VAL IN NUMBER) RETURN NUMBER;
217 
218   FUNCTION CF_OUTSIDE_VALUE_RFORMULA(CS_OUTSIDE_VALUE IN VARCHAR2
219                                     ,CF_PRECISION_TRX IN NUMBER) RETURN NUMBER;
220 
221   FUNCTION AFTERPFORM RETURN BOOLEAN;
222 
223   FUNCTION CF_PRECISION_TRXFORMULA(C_MOVEMENT_CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
224 
225   FUNCTION CF_RELEASE_NUMBERFORMULA(C_RCV_TRANSACTION_ID IN NUMBER) RETURN NUMBER;
226 
227   FUNCTION CP_REQUESTED_BY_P RETURN VARCHAR2;
228 
229   FUNCTION CP_APPLICATION_P RETURN VARCHAR2;
230 
231   FUNCTION CP_RESPONSIBILITY_P RETURN VARCHAR2;
232 
233   FUNCTION CP_REQUEST_TIME_P RETURN VARCHAR2;
234 
235   FUNCTION CP_LEGAL_ENTITY_NAME_P RETURN VARCHAR2;
236 
237   FUNCTION CP_ENTITY_ADDRESS_LINE_1_P RETURN VARCHAR2;
238 
239   FUNCTION CP_ENTITY_ADDRESS_LINE_2_P RETURN VARCHAR2;
240 
241   FUNCTION CP_ENTITY_ADDRESS_LINE_3_P RETURN VARCHAR2;
242 
243   FUNCTION CP_TELEPHONE_NUMBER_1_P RETURN VARCHAR2;
244 
245   FUNCTION CP_TELEPHONE_NUMBER_2_P RETURN VARCHAR2;
246 
247   FUNCTION CP_CONTACT_PERSON_NAME_P RETURN VARCHAR2;
248 
249   FUNCTION CP_VAT_REGISTRATION_NUMBER_P RETURN VARCHAR2;
250 
251   FUNCTION CP_SET_OF_BOOKS_NAME_P RETURN VARCHAR2;
252 
253   FUNCTION CP_TAX_OFFICE_NAME_P RETURN VARCHAR2;
254 
255   FUNCTION CP_TAX_OFFICE_ADDRESS_LINE_1_P RETURN VARCHAR2;
256 
257   FUNCTION CP_TAX_OFFICE_ADDRESS_LINE_2_P RETURN VARCHAR2;
258 
259   FUNCTION CP_TAX_OFFICE_ADDRESS_LINE_3_P RETURN VARCHAR2;
260 
261   FUNCTION CP_START_DATE_P RETURN DATE;
262 
263   FUNCTION CP_END_DATE_P RETURN DATE;
264 
265   FUNCTION CP_STANDARD_UOM_P RETURN VARCHAR2;
266 
267   FUNCTION CP_SYSDATE_P RETURN VARCHAR2;
268 
269   FUNCTION CP_EXT_PRECISION_FUNC_P RETURN NUMBER;
270 
271   FUNCTION CP_ZONE_NAME_COV_P RETURN VARCHAR2;
272 
273   FUNCTION CP_MV_TYPE_COV_P RETURN VARCHAR2;
274 
275   FUNCTION CP_REP_OPTION_COV_P RETURN VARCHAR2;
276 
277   FUNCTION CP_USAGE_TYPE_COV_P RETURN VARCHAR2;
278 
279   FUNCTION CP_STAT_TYPE_COV_P RETURN VARCHAR2;
280 
281   FUNCTION CP_PRECISION_FUNC_P RETURN NUMBER;
282 
283   FUNCTION CP_REPORT_TITLE_P RETURN VARCHAR2;
284 
285   FUNCTION BEFOREREPORT RETURN BOOLEAN;
286 
287 END INV_INVSTMVT_XMLP_PKG;
288