[Home] [Help]
PACKAGE: APPS.ONT_OEXPRPRD_XMLP_PKG
Source
1 PACKAGE ONT_OEXPRPRD_XMLP_PKG AS
2 /* $Header: OEXPRPRDS.pls 120.3 2008/05/05 06:38:29 dwkrishn noship $ */
3 P_CONC_REQUEST_ID NUMBER := 0;
4
5 P_SOB_ID NUMBER;
6
7 P_ORDER_TYPE_LOW VARCHAR2(100);
8
9 P_ORDER_TYPE_HIGH VARCHAR2(100);
10
11 P_SORT_BY VARCHAR2(25);
12
13 P_ORDER_NUM_LOW VARCHAR2(100);
14
15 P_ORDER_NUM_HIGH VARCHAR2(100);
16
17 P_CUSTOMER_NAME_LOW VARCHAR2(360);
18
19 P_CUSTOMER_NAME_HIGH VARCHAR2(360);
20
21 P_ORGANIZATION_ID VARCHAR2(32767);
22
23 CP_ORGANIZATION_ID VARCHAR2(32767);
24
25 P_ORDER_DATE_LOW DATE;
26
27 P_ORDER_DATE_HIGH DATE;
28
29 P_SALESREP_LOW VARCHAR2(240);
30
31 P_SALESREP_HIGH VARCHAR2(240);
32
33 P_MIN_PRECISION NUMBER;
34
35 P_OPEN_FLAG VARCHAR2(5);
36
37 LP_ORDER_NUM VARCHAR2(500);
38
39 LP_ORDER_TYPE VARCHAR2(500);
40
41 LP_ORDER_DATE VARCHAR2(500);
42
43 LP_SALESREP VARCHAR2(500);
44
45 LP_CUSTOMER_NAME VARCHAR2(500);
46
47 SORT_BY_MEANING VARCHAR2(25);
48
49 ORDER_TYPE_PARMS VARCHAR2(100);
50
51 ORDER_NUMBER_PARMS VARCHAR2(100);
52
53 SALESREP_PARMS VARCHAR2(100);
54
55 CUSTOMER_PARMS VARCHAR2(500);
56
57 ORDER_DATE_PARMS VARCHAR2(100);
58
59 OPEN_FLAG_MEANING VARCHAR2(5);
60
61 LP_OPEN_FLAG VARCHAR2(128);
62
63 LP_SORT_BY VARCHAR2(128);
64
65 P_ITEM_FLEX_CODE VARCHAR2(32767);
66
67 P_PRINT_DESCRIPTION VARCHAR2(3);
68
69 ITEM_FLEX_DESC_MEANING VARCHAR2(50);
70
71 P_ITEM_STRUCTURE_NUM NUMBER;
72
73 P_ORDER_CATEGORY VARCHAR2(100);
74
75 LP_LINE_TYPE VARCHAR2(500);
76
77 P_LINE_TYPE_LOW VARCHAR2(100);
78
79 P_LINE_TYPE_HIGH VARCHAR2(100);
80
81 LINE_TYPE_PARMS VARCHAR2(500);
82
83 P_LINE_CATEGORY VARCHAR2(100);
84
85 LP_ORDER_CATEGORY VARCHAR2(500):=' ';
86
87 LP_LINE_CATEGORY VARCHAR2(500);
88
89 P_CUSTOMER_NUM_HIGH VARCHAR2(100);
90
91 P_CUSTOMER_NUM_LOW VARCHAR2(100);
92
93 CUSTOMER_NUM_PARMS VARCHAR2(500);
94
95 LP_CUSTOMER_NUM VARCHAR2(500);
96
97 P_ORAGANIZATION_ID VARCHAR2(40);
98
99 LP_ITEM VARCHAR2(20000);
100
101 P_ITEM_HI VARCHAR2(200);
102
103 P_ITEM_LOW VARCHAR2(200);
104
105 L_ITEM_STRING VARCHAR2(2000);
106
107 P_ITEM_FLEX_CODE1 VARCHAR2(200);
108
109 CUSTOMER_PARMS_LOW VARCHAR2(500);
110
111 CUSTOMER_PARMS_HIGH VARCHAR2(500);
112
113 ORDER_NUMBER_PARMS_LOW VARCHAR2(32767);
114
115 ORDER_NUMBER_PARMS_HIGH VARCHAR2(100);
116
117 ORDER_DATE_PARMS_HIGH VARCHAR2(100);
118
119 ORDER_DATE_PARMS_LOW VARCHAR2(100);
120
121 ORDER_TYPE_PARMS_HIGH VARCHAR2(100);
122
123 ORDER_TYPE_PARMS_LOW VARCHAR2(100);
124
125 SALESREP_PARMS_LOW VARCHAR2(200);
126
127 SALESREP_PARMS_HIGH VARCHAR2(100);
128
129 LINE_TYPE_PARMS_LOW VARCHAR2(200);
130
131 LINE_TYPE_PARMS_HIGH VARCHAR2(200);
132
133 CUSTOMER_NUM_PARMS_HIGH VARCHAR2(200);
134
135 CUSTOMER_NUM_PARMS_LOW VARCHAR2(200);
136
137 P_ONE_TIME VARCHAR2(32767);
138
139 L_ORDER_TYPE_LOW VARCHAR2(30);
140
141 L_ORDER_TYPE_HIGH VARCHAR2(30);
142
143 L_LINE_TYPE_LOW VARCHAR2(30);
144
145 L_LINE_TYPE_HIGH VARCHAR2(30);
146
147 RP_DUMMY_ITEM VARCHAR2(20);
148
149 RP_REPORT_NAME VARCHAR2(240);
150
151 RP_SUB_TITLE VARCHAR2(80);
152
153 RP_COMPANY_NAME VARCHAR2(50);
154
155 RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
156
157 RP_DATA_FOUND VARCHAR2(300);
158
159 RP_ITEM_FLEX_ALL_SEG VARCHAR2(500) := 'SI.SEGMENT1';
160
161 RP_CURR_PROFILE VARCHAR2(20);
162
163 RP_LIST_PRICE NUMBER;
164
165 RP_SELL_PRICE NUMBER;
166
167 FUNCTION BEFOREREPORT RETURN BOOLEAN;
168
169 FUNCTION AFTERREPORT RETURN BOOLEAN;
170
171 FUNCTION AFTERPFORM RETURN BOOLEAN;
172
173 FUNCTION TOTAL_SELL_PRICEFORMULA(SELL_PRICE IN NUMBER
174 ,QUANTITY IN NUMBER) RETURN NUMBER;
175
176 FUNCTION ORDER_DISCOUNTFORMULA(ORDER_LIST_AMT IN NUMBER
177 ,ORDER_SELL_AMT IN NUMBER) RETURN NUMBER;
178
179 FUNCTION TOTAL_LIST_PRICEFORMULA(LIST_PRICE IN NUMBER
180 ,QUANTITY IN NUMBER) RETURN NUMBER;
181
182 FUNCTION SORT_BY_MEANINGVALIDTRIGGER RETURN BOOLEAN;
183
184 FUNCTION ORDER_TYPE_PARMSVALIDTRIGGER RETURN BOOLEAN;
185
186 FUNCTION ORDER_NUMBER_PARMSVALIDTRIGGER RETURN BOOLEAN;
187
188 FUNCTION SALESREP_PARMSVALIDTRIGGER RETURN BOOLEAN;
189
190 FUNCTION CUSTOMER_PARMSVALIDTRIGGER RETURN BOOLEAN;
191
192 FUNCTION ORDER_DATE_PARMSVALIDTRIGGER RETURN BOOLEAN;
193
194 FUNCTION P_SORT_BYVALIDTRIGGER RETURN BOOLEAN;
195
196 FUNCTION P_OPEN_FLAGVALIDTRIGGER RETURN BOOLEAN;
197
198 FUNCTION P_PRINT_DESCVALIDTRIGGER RETURN BOOLEAN;
199
200 FUNCTION RP_ORDER_CATEGORYFORMULA RETURN VARCHAR2;
201
202 FUNCTION TOTAL_ORDER_LIST_PRICEFORMULA(LINE_LIST_PRICE IN NUMBER
203 ,QUANTITY IN NUMBER) RETURN NUMBER;
204
205 FUNCTION TOTAL_LINE_SELL_PRICEFORMULA(LINE_SELL_PRICE IN NUMBER
206 ,QUANTITY IN NUMBER) RETURN NUMBER;
207
208 FUNCTION BEFOREPFORM RETURN BOOLEAN;
209
210 FUNCTION BETWEENPAGE RETURN BOOLEAN;
211
212 FUNCTION RP_LINE_CATEGORYFORMULA RETURN VARCHAR2;
213
214 FUNCTION DISCOUNT_AMOUNTFORMULA(DISCOUNT_AMT IN NUMBER) RETURN NUMBER;
215
216 FUNCTION CF_CHARGE_PERIODICITYFORMULA(CHARGE_PERIODICITY_CODE IN VARCHAR2) RETURN CHAR;
217
218 FUNCTION RP_DUMMY_ITEM_P RETURN VARCHAR2;
219
220 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
221
222 FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
223
224 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
225
226 FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
227
228 FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
229
230 FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
231
232 FUNCTION RP_CURR_PROFILE_P RETURN VARCHAR2;
233
234 FUNCTION RP_LIST_PRICE_P RETURN NUMBER;
235
236 FUNCTION RP_SELL_PRICE_P RETURN NUMBER;
237
238 FUNCTION LIST_PRICE_DISPLAYFORMULA(LIST_PRICE IN NUMBER) RETURN VARCHAR2;
239
240 FUNCTION SELL_PRICE_DISPLAYFORMULA (SELL_PRICE IN NUMBER) RETURN VARCHAR2;
241 function Item_dspFormula(item_identifier_type_L varchar2,
242 iid_L number ,
243 oid_L number,
244 oi_L varchar2,
245 INVENTORY_ITEM_ID_L number,
246 ORGANIZATION_ID_L number) return Char;
247
248 FUNCTION F_1FORMATTRIGGER RETURN VARCHAR2;
249 END ONT_OEXPRPRD_XMLP_PKG;
250