[Home] [Help]
PACKAGE: APPS.ONT_OEXOEIOD_XMLP_PKG
Source
1 PACKAGE ONT_OEXOEIOD_XMLP_PKG AS
2 /* $Header: OEXOEIODS.pls 120.2 2008/05/05 09:03:55 dwkrishn noship $ */
3 DSP_COUNT VARCHAR2(2000);
4
5 P_CONC_REQUEST_ID NUMBER;
6
7 P_SOB_ID NUMBER;
8
9 P_ORDER_TYPE_LOW VARCHAR2(30);
10
11 P_ORDER_TYPE_HIGH VARCHAR2(30);
12
13 P_ORDER_BY VARCHAR2(30);
14
15 P_ORDER_NUM_LOW VARCHAR2(32767);
16
17 P_ORDER_NUM_HIGH VARCHAR2(32767);
18
19 P_CUSTOMER_NAME_LOW VARCHAR2(360);
20
21 P_CUSTOMER_NAME_HIGH VARCHAR2(360);
22
23 P_ITEM_FLEX_CODE VARCHAR2(32767);
24
25 P_ORG_ID VARCHAR2(32767);
26
27 LP_ORG_ID VARCHAR2(32767);
28
29 P_SALESREP_LOW VARCHAR2(240);
30
31 P_SALESREP_HIGH VARCHAR2(240);
32
33 P_PRINT_DESCRIPTION VARCHAR2(3);
34
35 P_OPEN_ORDERS_ONLY VARCHAR2(3);
36
37 P_COUNTRY_LOW VARCHAR2(80);
38
39 LP_COUNTRY VARCHAR2(1000):=' ';
40
41 LP_SALESREP VARCHAR2(1000):=' ';
42
43 LP_ORDER_NUM VARCHAR2(1000):=' ';
44
45 LP_CUSTOMER_NAME VARCHAR2(1000):=' ';
46
47 LP_ORDER_TYPE VARCHAR2(1000):=' ';
48
49 P_INVOICE_LINE_CONTEXT VARCHAR2(50);
50
51 LP_OPEN_ORDERS_ONLY VARCHAR2(800);
52
53 P_DUMMY_PRINT_DESCRIPTION VARCHAR2(32767);
54
55 P_ITEM_STRUCTURE_NUM NUMBER;
56
57 P_USE_FUNCTIONAL_CURRENCY VARCHAR2(32767);
58
59 LP_ORDER_CATEGORY VARCHAR2(500);
60
61 LP_LINE_CATEGORY VARCHAR2(500);
62
63 P_ORDER_CATEGORY VARCHAR2(30);
64
65 P_LINE_CATEGORY VARCHAR2(30);
66
67 L_ORDER_TYPE_LOW VARCHAR2(30);
68
69 L_ORDER_TYPE_HIGH VARCHAR2(30);
70
71 C_AMOUNT NUMBER := 0;
72
73 C_SVC_AMOUNT NUMBER := 0;
74
75 RP_SVC_DUMMY_ITEM DATE;
76
77 RP_REPORT_NAME VARCHAR2(240);
78
79 RP_SUB_TITLE VARCHAR2(100);
80
81 RP_COMPANY_NAME VARCHAR2(100);
82
83 RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
84
85 RP_DATA_FOUND VARCHAR2(300);
86
87 RP_ITEM_FLEX_ALL_SEG VARCHAR2(500) := 'SI.SEGMENT1';
88
89 RP_ORDER_NUMBER_RANGE VARCHAR2(500);
90
91 RP_SALESREP_RANGE VARCHAR2(500);
92
93 RP_CUSTOMER_NAME_RANGE VARCHAR2(500);
94
95 RP_ORDER_TYPE_RANGE VARCHAR2(500);
96
97 RP_OPEN_ORDERS_ONLY VARCHAR2(80);
98
99 RP_PRINT_DESCRIPTION VARCHAR2(240);
100
101 RP_DUMMY_ITEM VARCHAR2(2000);
102
103 FUNCTION AFTERREPORT RETURN BOOLEAN;
104
105 FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
106
107 FUNCTION AFTERPFORM RETURN BOOLEAN;
108
109 FUNCTION C_DATA_NOT_FOUNDFORMULA(CURRENCY1 IN VARCHAR2) RETURN NUMBER;
110
111 FUNCTION RP_CURR_LABELFORMULA RETURN VARCHAR2;
112
113 FUNCTION C_ORDER_COUNTFORMULA RETURN NUMBER;
114
115 FUNCTION RP_ORDER_BYFORMULA RETURN VARCHAR2;
116
117 FUNCTION C_LINE_COUNTFORMULA(HEADER_ID1 IN NUMBER) RETURN NUMBER;
118
119 FUNCTION C_CONVERT_AMOUNTFORMULA(CURRENCY1 IN VARCHAR2
120 ,AMOUNT IN NUMBER
121 ,CONVERSION_TYPE_CODE IN VARCHAR2
122 ,ORDER_DATE IN DATE
123 ,CONVERSION_RATE IN NUMBER) RETURN NUMBER;
124
125 FUNCTION RP_USE_FUNCTIONAL_CURRENCYFORM RETURN VARCHAR2;
126
127 FUNCTION C_CONVERT_SVC_AMOUNTFORMULA(CURRENCY1 IN VARCHAR2
128 ,SVC_AMOUNT IN NUMBER
129 ,CONVERSION_TYPE_CODE IN VARCHAR2
130 ,ORDER_DATE IN DATE
131 ,CONVERSION_RATE IN NUMBER) RETURN NUMBER;
132
133 FUNCTION S_AMOUNT_ONFORMULA(C_AMT_INV1 IN NUMBER
134 ,C_SVC_AMT1 IN NUMBER) RETURN NUMBER;
135
136 FUNCTION S_AMOUNT_CUFORMULA(C_AMT_INV_CU IN NUMBER
137 ,C_SVC_AMT_INV_CU IN NUMBER) RETURN NUMBER;
138
139 FUNCTION S_AMOUNT_CURFORMULA(C_AMT_INV_CUR IN NUMBER
140 ,C_SVC_AMT_INV_CUR IN NUMBER) RETURN NUMBER;
141
142 FUNCTION S_AMOUNT_CPBFORMULA(C_AMT_INV_CPB IN NUMBER
143 ,C_SVC_AMT_INV_CPB IN NUMBER) RETURN NUMBER;
144
145 FUNCTION S_AMOUNT_OTFORMULA(C_AMT_INV_OT IN NUMBER
146 ,C_SVC_AMT_OT IN NUMBER) RETURN NUMBER;
147
148 FUNCTION S_AMOUNT_SPFORMULA(C_AMT_INV_SP IN NUMBER
149 ,C_SVC_AMT_INV_SP IN NUMBER) RETURN NUMBER;
150
151 FUNCTION BEFOREPFORM RETURN BOOLEAN;
152
153 FUNCTION RP_ORDER_CATEGORYFORMULA RETURN CHAR;
154
155 FUNCTION RP_LINE_CATEGORYFORMULA RETURN CHAR;
156
157 FUNCTION C_MASTER_ORGFORMULA RETURN CHAR;
158
159 FUNCTION C_QUANTITY_CURFORMULA(S_QUANTITY_CUR IN NUMBER
160 ,S_SVC_QUANTITY_CUR IN NUMBER) RETURN NUMBER;
161
162 FUNCTION C_QUANTITY_SPFORMULA(S_QUANTITY_SP IN NUMBER
163 ,S_SVC_QUANTITY_SP IN NUMBER) RETURN NUMBER;
164
165 FUNCTION CF_1FORMULA(S_QUANTITY_OT IN NUMBER
166 ,S_SVC_QUANTITY_OT IN NUMBER) RETURN NUMBER;
167
168 FUNCTION CF_1FORMULA0009(S_QUANTITY_CPB IN NUMBER
169 ,S_SVC_QUANTITY_CPB IN NUMBER) RETURN NUMBER;
170
171 FUNCTION CF_1FORMULA0011(S_QUANTITY_CU IN NUMBER
172 ,S_SVC_QUANTITY_CU IN NUMBER) RETURN NUMBER;
173
174 FUNCTION C_QUANTITY_ONFORMULA(S_QUANTITY_ON IN NUMBER
175 ,S_SVC_QUANTITY_ON IN NUMBER) RETURN NUMBER;
176
177 FUNCTION C_PRECISIONFORMULA(CURRENCY1 IN VARCHAR2) RETURN NUMBER;
178
179 FUNCTION C_CURRENCYFORMULA(CURRENCY1 IN VARCHAR2) RETURN CHAR;
180
181 FUNCTION C_AMOUNT_P RETURN NUMBER;
182
183 FUNCTION C_SVC_AMOUNT_P RETURN NUMBER;
184
185 FUNCTION RP_SVC_DUMMY_ITEM_P RETURN DATE;
186
187 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
188
189 FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
190
191 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
192
193 FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
194
195 FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
196
197 FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
198
199 FUNCTION RP_ORDER_NUMBER_RANGE_P RETURN VARCHAR2;
200
201 FUNCTION RP_SALESREP_RANGE_P RETURN VARCHAR2;
202
203 FUNCTION RP_CUSTOMER_NAME_RANGE_P RETURN VARCHAR2;
204
205 FUNCTION RP_ORDER_TYPE_RANGE_P RETURN VARCHAR2;
206
207 FUNCTION RP_OPEN_ORDERS_ONLY_P RETURN VARCHAR2;
208
209 FUNCTION RP_PRINT_DESCRIPTION_P RETURN VARCHAR2;
210
211 FUNCTION RP_DUMMY_ITEM_P RETURN VARCHAR2;
212
213 FUNCTION IS_FIXED_RATE(X_FROM_CURRENCY IN VARCHAR2
214 ,X_TO_CURRENCY IN VARCHAR2
215 ,X_EFFECTIVE_DATE IN DATE) RETURN VARCHAR2;
216
217 PROCEDURE GET_RELATION(X_FROM_CURRENCY IN VARCHAR2
218 ,X_TO_CURRENCY IN VARCHAR2
219 ,X_EFFECTIVE_DATE IN DATE
220 ,X_FIXED_RATE IN OUT NOCOPY BOOLEAN
221 ,X_RELATIONSHIP IN OUT NOCOPY VARCHAR2);
222
223 FUNCTION GET_EURO_CODE RETURN VARCHAR2;
224
225 FUNCTION GET_RATE(X_FROM_CURRENCY IN VARCHAR2
226 ,X_TO_CURRENCY IN VARCHAR2
227 ,X_CONVERSION_DATE IN DATE
228 ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
229
230 FUNCTION GET_RATE(X_SET_OF_BOOKS_ID IN NUMBER
231 ,X_FROM_CURRENCY IN VARCHAR2
232 ,X_CONVERSION_DATE IN DATE
233 ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
234
235 FUNCTION CONVERT_AMOUNT(X_FROM_CURRENCY IN VARCHAR2
236 ,X_TO_CURRENCY IN VARCHAR2
237 ,X_CONVERSION_DATE IN DATE
238 ,X_CONVERSION_TYPE IN VARCHAR2
239 ,X_AMOUNT IN NUMBER) RETURN NUMBER;
240
241 FUNCTION CONVERT_AMOUNT(X_SET_OF_BOOKS_ID IN NUMBER
242 ,X_FROM_CURRENCY IN VARCHAR2
243 ,X_CONVERSION_DATE IN DATE
244 ,X_CONVERSION_TYPE IN VARCHAR2
245 ,X_AMOUNT IN NUMBER) RETURN NUMBER;
246
247 FUNCTION GET_DERIVE_TYPE(SOB_ID IN NUMBER
248 ,PERIOD IN VARCHAR2
249 ,CURR_CODE IN VARCHAR2) RETURN VARCHAR2;
250
251 FUNCTION RATE_EXISTS(X_FROM_CURRENCY IN VARCHAR2
252 ,X_TO_CURRENCY IN VARCHAR2
253 ,X_CONVERSION_DATE IN DATE
254 ,X_CONVERSION_TYPE IN VARCHAR2) RETURN VARCHAR2;
255 FUNCTION BEFOREREPORT RETURN BOOLEAN;
256
257 FUNCTION ITEM_DSPFORMULA(ITEM_IDENTIFIER_TYPE IN VARCHAR2,INVENTORY_ITEM_ID IN NUMBER, C_MASTER_ORG IN VARCHAR2,
258 ORDERED_ITEM_ID IN NUMBER,ORDERED_ITEM VARCHAR2,SI_ORGANIZATION_ID IN NUMBER, SI_INVENTORY_ITEM_ID IN NUMBER) RETURN VARCHAR2;
259
260 END ONT_OEXOEIOD_XMLP_PKG;
261