[Home] [Help]
PACKAGE: APPS.WSH_WSHRDBDR_XMLP_PKG
Source
1 PACKAGE WSH_WSHRDBDR_XMLP_PKG AS
2 /* $Header: WSHRDBDRS.pls 120.3 2008/02/12 13:12:54 dwkrishn noship $ */
3 P_CONC_REQUEST_ID NUMBER := 0;
4
5 P_HEADER_ID_LOW NUMBER;
6
7 P_HEADER_ID_HIGH NUMBER;
8
9 P_ITEM_FLEX_CODE VARCHAR2(32767);
10
11 P_ORGANIZATION_ID NUMBER;
12
13 P_ITEM_ID NUMBER;
14
15 P_ITEM_CATE_SET_ID NUMBER;
16
17 P_CREATED_BY_ID NUMBER;
18
19 LP_ITEM_FLEX_ALL_SEG VARCHAR2(1000);
20
21 LP_ITEM_FLEX_ALL_SEG_HIGH VARCHAR2(600);
22
23 P_ITEM_CATEGORY_ID NUMBER;
24
25 P_ITEM_DISPLAY VARCHAR2(32767);
26
27 LP_HEADER_NUMBER VARCHAR2(500);
28
29 LP_CREATED_BY VARCHAR2(200);
30
31 LP_ITEM_FROM VARCHAR2(100);
32
33 LP_ITEM_WHERE VARCHAR2(500);
34
35 RP_WAREHOUSE_ID NUMBER;
36
37 RP_USER_ID NUMBER;
38
39 LP_STRUCTURE_NUM NUMBER := 101;
40
41 LP_WAREHOUSE_GROUP VARCHAR2(240);
42
43 LP_WAREHOUSE_ID_SELECT VARCHAR2(240);
44
45 LP_WAREHOUSE_NAME_SELECT VARCHAR2(240);
46
47 LP_ORDER_CATEGORY VARCHAR2(500);
48
49 P_TRANSACTION_TYPE_ID NUMBER;
50
51 LP_ORDER_TYPE VARCHAR2(200);
52
53 P_ITEM_STRUCTURE_NUM NUMBER;
54
55 LP_INVENTORY VARCHAR2(100);
56
57 RP_ORDER_TYPE_NAME VARCHAR2(240);
58
59 LP_ITEM_ID VARCHAR2(100);
60
61 P_ORDER_NUM_LOW NUMBER;
62
63 P_ORDER_NUM_HIGH NUMBER;
64
65 LP_COUNTRY_FROM VARCHAR2(200);
66
67 LP_CUSTOMER VARCHAR2(200);
68
69 LP_WAREHOUSE VARCHAR2(200);
70
71 LP_COUNTRY_WHERE VARCHAR2(200);
72
73 P_SORT_BY VARCHAR2(200);
74
75 P_CUSTOMER_ID NUMBER;
76
77 P_SHIP_TO_COUNTRY_CODE VARCHAR2(240);
78
79 LP_SORT_BY VARCHAR2(100);
80
81 RP_USER VARCHAR2(200);
82
83 RP_TERRITORY_CODE VARCHAR2(200);
84
85 LP_SOURCE_CODE VARCHAR2(100);
86
87 RP_CUSTOMER VARCHAR2(240);
88
89 RP_SORT_BY VARCHAR2(200);
90
91 P_SOURCE_SYSTEM VARCHAR2(32767);
92
93 DLATE NUMBER;
94
95 RP_REPORT_NAME VARCHAR2(240);
96
97 RP_SUB_TITLE VARCHAR2(80);
98
99 RP_DATA_FOUND VARCHAR2(300);
100
101 RP_ITEM_FLEX_ALL_SEG VARCHAR2(1000) := 'SI.SEGMENT1||SI.SEGMENT2||SI.SEGMENT3||SI.SEGMENT4||SI.SEGMENT5||SI.SEGMENT6||SI.SEGMENT7||SI.SEGMENT8||
102 SI.SEGMENT9||SI.SEGMENT10||SI.SEGMENT11||SI.SEGMENT12||SI.SEGMENT13||SI.SEGMENT14||SI.SEGMENT15||SI.SEGMENT16||SI.SEGMENT17||SI.SEGMENT18||
103 SI.SEGMENT19||SI.SEGMENT20';
104
105 RP_ITEM_FLEX_ALL_SEG_WHERE VARCHAR2(600);
106
107 RP_ORDER_BY VARCHAR2(80);
108
109 RP_FLEX_OR_DESC VARCHAR2(80);
110
111 RP_ORDER_RANGE VARCHAR2(60);
112
113 RP_CATEGORY_SET VARCHAR2(40);
114
115 RP_CATEGORY VARCHAR2(80);
116
117 RP_ORDER_NUM_HIGH NUMBER;
118
119 RP_ORDER_NUM_LOW NUMBER;
120
121 RP_WAREHOUSE VARCHAR2(240);
122
123 RP_ITEM VARCHAR2(2000);
124
125 RP_SOURCE_SYSTEM VARCHAR2(80);
126
127 FUNCTION BEFOREREPORT RETURN BOOLEAN;
128
129 FUNCTION AFTERREPORT RETURN BOOLEAN;
130
131 FUNCTION P_ORGANIZATION_IDVALIDTRIGGER RETURN BOOLEAN;
132
133 FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
134
135 FUNCTION AFTERPFORM RETURN BOOLEAN;
136
137 FUNCTION C_SET_LBLFORMULA RETURN VARCHAR2;
138
139 FUNCTION CF_ITEM_DISPLAYFORMULA(INVENTORY_ITEM_ID IN NUMBER
140 ,ORGANIZATION_ID IN NUMBER
141 ,ITEM_DESCRIPTION IN VARCHAR2) RETURN VARCHAR2;
142
143 FUNCTION CF_LINE_ITEM_DISPLAYFORMULA(LINE_ITEM IN NUMBER
144 ,ORGANIZATION_ID IN NUMBER
145 ,ITEM_DESCRIPTION IN VARCHAR2) RETURN VARCHAR2;
146
147 FUNCTION CF_LINE_SHIPPED_QTYFORMULA(SOURCE_LINE_SET_ID IN NUMBER
148 ,SOURCE_HEADER_ID IN NUMBER
149 ,REQUESTED_QUANTITY_UOM IN VARCHAR2
150 ,ORDER_UOM IN VARCHAR2
151 ,LINE_ITEM IN NUMBER) RETURN NUMBER;
152
153 FUNCTION CF_LINE_BO_QTYFORMULA(SOURCE_LINE_SET_ID IN NUMBER
154 ,SOURCE_HEADER_ID IN NUMBER
155 ,REQUESTED_QUANTITY_UOM IN VARCHAR2
156 ,ORDER_UOM IN VARCHAR2
157 ,LINE_ITEM IN NUMBER) RETURN NUMBER;
158
159 FUNCTION CF_LINE_ORDERED_AMTFORMULA(CF_LINE_ORDERED_QTY IN NUMBER
160 ,CF_selling_price IN NUMBER) RETURN NUMBER;
161
162 FUNCTION CF_LINE_BO_AMTFORMULA(CF_LINE_BO_QTY IN NUMBER
163 ,CF_selling_price IN NUMBER) RETURN NUMBER;
164
165 FUNCTION CF_LINE_ORDERED_QTYFORMULA(SOURCE_LINE_SET_ID IN NUMBER) RETURN NUMBER;
166
167 FUNCTION CF_PROMISE_DATEFORMULA(SOURCE_LINE_ID IN NUMBER) RETURN DATE;
168
169 FUNCTION CF_DAYS_LATEFORMULA(CF_PROMISE_DATE IN DATE) RETURN NUMBER;
170
171 FUNCTION CF_SOURCE_CODEFORMULA(SOURCE_CODE IN VARCHAR2) RETURN CHAR;
172
173 FUNCTION CF_DISTINCT_UOMFORMULA(ORDER_NUMBER IN VARCHAR2) RETURN NUMBER;
174
175 FUNCTION CF_SORT_ENABLEDFORMULA(CS_COUNT_DUOM IN NUMBER
176 ,CS_SUM_DUOM IN NUMBER) RETURN NUMBER;
177
178 FUNCTION CF_CURR_ENABLEDFORMULA(CS_COUNT_SORT_ENABLED IN NUMBER
179 ,CS_SUM_SORT_ENABLED IN NUMBER) RETURN NUMBER;
180
181 FUNCTION CF_SELLING_PRICEFORMULA(SOURCE_LINE_ID IN NUMBER) RETURN NUMBER;
182
183 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
184
185 FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
186
187 FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
188
189 FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
190
191 FUNCTION RP_ITEM_FLEX_ALL_SEG_WHERE_P RETURN VARCHAR2;
192
193 FUNCTION RP_ORDER_BY_P RETURN VARCHAR2;
194
195 FUNCTION RP_FLEX_OR_DESC_P RETURN VARCHAR2;
196
197 FUNCTION RP_ORDER_RANGE_P RETURN VARCHAR2;
198
199 FUNCTION RP_CATEGORY_SET_P RETURN VARCHAR2;
200
201 FUNCTION RP_CATEGORY_P RETURN VARCHAR2;
202
203 FUNCTION RP_ORDER_NUM_HIGH_P RETURN NUMBER;
204
205 FUNCTION RP_ORDER_NUM_LOW_P RETURN NUMBER;
206
207 FUNCTION RP_WAREHOUSE_P RETURN VARCHAR2;
208
209 FUNCTION RP_ITEM_P RETURN VARCHAR2;
210
211 FUNCTION RP_SOURCE_SYSTEM_P RETURN VARCHAR2;
212
213 PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
214 ,NAME IN VARCHAR2);
215
216 PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
217 ,VALUE IN VARCHAR2
218 ,TRANSLATE IN BOOLEAN);
219
220 PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
221
222 PROCEDURE CLEAR;
223
224 FUNCTION GET_STRING(APPIN IN VARCHAR2
225 ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
226
227 FUNCTION GET_NUMBER(APPIN IN VARCHAR2
228 ,NAMEIN IN VARCHAR2) RETURN NUMBER;
229
230 FUNCTION GET RETURN VARCHAR2;
231
232 FUNCTION GET_ENCODED RETURN VARCHAR2;
233
234 PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
235 ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
236 ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
237
238 PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
239
240 PROCEDURE RAISE_ERROR;
241
242 END WSH_WSHRDBDR_XMLP_PKG;
243
244