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

Source


1 PACKAGE ONT_OEXOEIOS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OEXOEIOSS.pls 120.1 2007/12/25 07:18:17 npannamp noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_SOB_ID NUMBER;
6 
7   P_ORDER_TYPE_LOW VARCHAR2(30);
8 
9   P_ORDER_TYPE_HIGH VARCHAR2(30);
10 
11   P_ORDER_BY VARCHAR2(100);
12 
13   P_ORDER_NUM_LOW VARCHAR2(32767);
14 
15   P_ORDER_NUM_HIGH VARCHAR2(32767);
16 
17   P_CUSTOMER_NAME_LOW VARCHAR2(360);
18 
19   P_CUSTOMER_NAME_HIGH VARCHAR2(360);
20 
21   P_ORG_ID VARCHAR2(32767);
22 
23   P_SALESREP_LOW VARCHAR2(240);
24 
25   P_SALESREP_HIGH VARCHAR2(240);
26 
27   P_OPEN_ORDERS_ONLY VARCHAR2(3);
28 
29   P_COUNTRY VARCHAR2(80);
30 
31   LP_COUNTRY VARCHAR2(1000);
32 
33   LP_SALESREP VARCHAR2(1000);
34 
35   LP_ORDER_NUM VARCHAR2(1000);
36 
37   LP_CUSTOMER_NAME VARCHAR2(1000);
38 
39   LP_ORDER_TYPE VARCHAR2(1000);
40 
41   P_INVOICE_LINE_CONTEXT VARCHAR2(50);
42 
43   LP_OPEN_ORDERS_ONLY VARCHAR2(240);
44 
45   P_USE_FUNCTIONAL_CURRENCY VARCHAR2(32767);
46 
47   L_ORDER_TYPE_LOW VARCHAR2(30);
48 
49   L_ORDER_TYPE_HIGH VARCHAR2(30);
50 
51   C_INV_ORDER_AMT NUMBER := 0;
52 
53   C_BALANCE_DUE NUMBER := 0;
54 
55   C_CREDIT_AMOUNT NUMBER := 0;
56 
57   C_AMOUNT NUMBER := 0;
58 
59   RP_REPORT_NAME VARCHAR2(240);
60 
61   RP_SUB_TITLE VARCHAR2(80);
62 
63   RP_COMPANY_NAME VARCHAR2(50);
64 
65   RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
66 
67   RP_DATA_FOUND VARCHAR2(300);
68 
69   RP_ORDER_NUMBER_RANGE VARCHAR2(500);
70 
71   RP_SALESREP_RANGE VARCHAR2(500);
72 
73   RP_CUSTOMER_NAME_RANGE VARCHAR2(500);
74 
75   RP_ORDER_TYPE_RANGE VARCHAR2(500);
76 
77   RP_OPEN_ORDERS_ONLY VARCHAR2(80);
78 
79   FUNCTION BEFOREREPORT RETURN BOOLEAN;
80 
81   FUNCTION AFTERREPORT RETURN BOOLEAN;
82 
83   FUNCTION AFTERPFORM RETURN BOOLEAN;
84 
85   FUNCTION C_DATA_NOT_FOUNDFORMULA(CURRENCY1 IN VARCHAR2) RETURN NUMBER;
86 
87   FUNCTION RP_CURR_LABELFORMULA RETURN VARCHAR2;
88 
89   FUNCTION C_ORDER_COUNTFORMULA RETURN NUMBER;
90 
91   FUNCTION C_LINE_COUNTFORMULA(HEADER_ID1 IN NUMBER) RETURN NUMBER;
92 
93   FUNCTION C_COMPUTE_AMOUNTSFORMULA(TRX_ID IN NUMBER
94                                    ,CURRENCY1 IN VARCHAR2
95                                    ,INV_ORDER_AMT IN NUMBER
96                                    ,CONVERSION_TYPE_CODE IN VARCHAR2
97                                    ,ORDER_DATE IN DATE
98                                    ,C_PRECISION IN NUMBER
99                                    ,CONVERSION_RATE IN NUMBER) RETURN NUMBER;
100 
101   FUNCTION RP_USE_FUNCTIONAL_CURRENCYFORM RETURN VARCHAR2;
102 
103   FUNCTION C_ORDER_AMOUNTFORMULA(CURRENCY1 IN VARCHAR2
104                                 ,ORDER_AMOUNT IN NUMBER
105                                 ,CONVERSION_TYPE_CODE IN VARCHAR2
106                                 ,ORDER_DATE IN DATE
107                                 ,C_PRECISION IN NUMBER
108                                 ,CONVERSION_RATE IN NUMBER) RETURN NUMBER;
109 
110   FUNCTION BEFOREPFORM RETURN BOOLEAN;
111 
112   FUNCTION C_PRECISIONFORMULA(CURRENCY1 IN VARCHAR2) RETURN NUMBER;
113 
114   FUNCTION C_INV_ORDER_AMT_P RETURN NUMBER;
115 
116   FUNCTION C_BALANCE_DUE_P RETURN NUMBER;
117 
118   FUNCTION C_CREDIT_AMOUNT_P RETURN NUMBER;
119 
120   FUNCTION C_AMOUNT_P RETURN NUMBER;
121 
122   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
123 
124   FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
125 
126   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
127 
128   FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
129 
130   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
131 
132   FUNCTION RP_ORDER_NUMBER_RANGE_P RETURN VARCHAR2;
133 
134   FUNCTION RP_SALESREP_RANGE_P RETURN VARCHAR2;
135 
136   FUNCTION RP_CUSTOMER_NAME_RANGE_P RETURN VARCHAR2;
137 
138   FUNCTION RP_ORDER_TYPE_RANGE_P RETURN VARCHAR2;
139 
140   FUNCTION RP_OPEN_ORDERS_ONLY_P RETURN VARCHAR2;
141 
142   FUNCTION IS_FIXED_RATE(X_FROM_CURRENCY IN VARCHAR2
143                         ,X_TO_CURRENCY IN VARCHAR2
144                         ,X_EFFECTIVE_DATE IN DATE) RETURN VARCHAR2;
145 
146   PROCEDURE GET_RELATION(X_FROM_CURRENCY IN VARCHAR2
147                         ,X_TO_CURRENCY IN VARCHAR2
148                         ,X_EFFECTIVE_DATE IN DATE
149                         ,X_FIXED_RATE IN OUT NOCOPY BOOLEAN
150                         ,X_RELATIONSHIP IN OUT NOCOPY VARCHAR2);
151 
152   FUNCTION GET_EURO_CODE RETURN VARCHAR2;
153 
154   FUNCTION GET_RATE(X_FROM_CURRENCY IN VARCHAR2
155                    ,X_TO_CURRENCY IN VARCHAR2
156                    ,X_CONVERSION_DATE IN DATE
157                    ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
158 
159   FUNCTION GET_RATE(X_SET_OF_BOOKS_ID IN NUMBER
160                    ,X_FROM_CURRENCY IN VARCHAR2
161                    ,X_CONVERSION_DATE IN DATE
162                    ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
163 
164   FUNCTION CONVERT_AMOUNT(X_FROM_CURRENCY IN VARCHAR2
165                          ,X_TO_CURRENCY IN VARCHAR2
166                          ,X_CONVERSION_DATE IN DATE
167                          ,X_CONVERSION_TYPE IN VARCHAR2
168                          ,X_AMOUNT IN NUMBER) RETURN NUMBER;
169 
170   FUNCTION CONVERT_AMOUNT(X_SET_OF_BOOKS_ID IN NUMBER
171                          ,X_FROM_CURRENCY IN VARCHAR2
172                          ,X_CONVERSION_DATE IN DATE
173                          ,X_CONVERSION_TYPE IN VARCHAR2
174                          ,X_AMOUNT IN NUMBER) RETURN NUMBER;
175 
176   FUNCTION GET_DERIVE_TYPE(SOB_ID IN NUMBER
177                           ,PERIOD IN VARCHAR2
178                           ,CURR_CODE IN VARCHAR2) RETURN VARCHAR2;
179 
180 END ONT_OEXOEIOS_XMLP_PKG;
181 
182