[Home] [Help]
PACKAGE: APPS.WSH_WSHRDBDR_XMLP_PKG
Source
1 PACKAGE WSH_WSHRDBDR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHRDBDRS.pls 120.3.12020000.2 2012/07/04 10:20:22 suppal ship $ */
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_ORDER_BY VARCHAR2(500);
66
67 LP_COUNTRY_FROM VARCHAR2(200);
68
69 LP_CUSTOMER VARCHAR2(200);
70
71 LP_WAREHOUSE VARCHAR2(200);
72
73 LP_COUNTRY_WHERE VARCHAR2(200);
74
75 P_SORT_BY VARCHAR2(200);
76
77 P_CUSTOMER_ID NUMBER;
78
79 P_SHIP_TO_COUNTRY_CODE VARCHAR2(240);
80
81 LP_SORT_BY VARCHAR2(100);
82
83 RP_USER VARCHAR2(200);
84
85 RP_TERRITORY_CODE VARCHAR2(200);
86
87 LP_SOURCE_CODE VARCHAR2(100);
88
89 RP_CUSTOMER VARCHAR2(240);
90
91 RP_SORT_BY VARCHAR2(200);
92
93 P_SOURCE_SYSTEM VARCHAR2(32767);
94
95 DLATE NUMBER;
96
97 RP_REPORT_NAME VARCHAR2(240);
98
99 RP_SUB_TITLE VARCHAR2(80);
100
101 RP_DATA_FOUND VARCHAR2(300);
102
103 RP_ITEM_FLEX_ALL_SEG VARCHAR2(1000) := 'SI.SEGMENT1||SI.SEGMENT2||SI.SEGMENT3||SI.SEGMENT4||SI.SEGMENT5||SI.SEGMENT6||SI.SEGMENT7||SI.SEGMENT8||
104 SI.SEGMENT9||SI.SEGMENT10||SI.SEGMENT11||SI.SEGMENT12||SI.SEGMENT13||SI.SEGMENT14||SI.SEGMENT15||SI.SEGMENT16||SI.SEGMENT17||SI.SEGMENT18||
105 SI.SEGMENT19||SI.SEGMENT20';
106
107 RP_ITEM_FLEX_ALL_SEG_WHERE VARCHAR2(600);
108
109 RP_ORDER_BY VARCHAR2(80);
110
111 RP_FLEX_OR_DESC VARCHAR2(80);
112
113 RP_ORDER_RANGE VARCHAR2(60);
114
115 RP_CATEGORY_SET VARCHAR2(40);
116
117 RP_CATEGORY VARCHAR2(80);
118
119 RP_ORDER_NUM_HIGH NUMBER;
120
121 RP_ORDER_NUM_LOW NUMBER;
122
123 RP_WAREHOUSE VARCHAR2(240);
124
125 RP_ITEM VARCHAR2(2000);
126
127 RP_SOURCE_SYSTEM VARCHAR2(80);
128
129 FUNCTION BEFOREREPORT RETURN BOOLEAN;
130
131 FUNCTION AFTERREPORT RETURN BOOLEAN;
132
133 FUNCTION P_ORGANIZATION_IDVALIDTRIGGER RETURN BOOLEAN;
134
135 FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
136
137 FUNCTION AFTERPFORM RETURN BOOLEAN;
138
139 FUNCTION C_SET_LBLFORMULA RETURN VARCHAR2;
140
141 FUNCTION CF_ITEM_DISPLAYFORMULA(INVENTORY_ITEM_ID IN NUMBER
142 ,ORGANIZATION_ID IN NUMBER
143 ,ITEM_DESCRIPTION IN VARCHAR2) RETURN VARCHAR2;
144
145 FUNCTION CF_LINE_ITEM_DISPLAYFORMULA(LINE_ITEM IN NUMBER
146 ,ORGANIZATION_ID IN NUMBER
147 ,ITEM_DESCRIPTION IN VARCHAR2) RETURN VARCHAR2;
148
149 FUNCTION CF_LINE_SHIPPED_QTYFORMULA(SOURCE_LINE_SET_ID IN NUMBER
150 ,SOURCE_HEADER_ID IN NUMBER
151 ,REQUESTED_QUANTITY_UOM IN VARCHAR2
152 ,ORDER_UOM IN VARCHAR2
153 ,LINE_ITEM IN NUMBER) RETURN NUMBER;
154
155 FUNCTION CF_LINE_BO_QTYFORMULA(SOURCE_LINE_SET_ID IN NUMBER
156 ,SOURCE_HEADER_ID IN NUMBER
157 ,REQUESTED_QUANTITY_UOM IN VARCHAR2
158 ,ORDER_UOM IN VARCHAR2
159 ,LINE_ITEM IN NUMBER) RETURN NUMBER;
160
161 FUNCTION CF_LINE_ORDERED_AMTFORMULA(CF_LINE_ORDERED_QTY IN NUMBER
162 ,CF_selling_price IN NUMBER) RETURN NUMBER;
163
164 FUNCTION CF_LINE_BO_AMTFORMULA(CF_LINE_BO_QTY IN NUMBER
165 ,CF_selling_price IN NUMBER) RETURN NUMBER;
166
167 FUNCTION CF_LINE_ORDERED_QTYFORMULA(SOURCE_LINE_SET_ID IN NUMBER) RETURN NUMBER;
168
169 FUNCTION CF_PROMISE_DATEFORMULA(SOURCE_LINE_ID IN NUMBER) RETURN DATE;
170
171 FUNCTION CF_DAYS_LATEFORMULA(CF_PROMISE_DATE IN DATE) RETURN NUMBER;
172
173 FUNCTION CF_SOURCE_CODEFORMULA(SOURCE_CODE IN VARCHAR2) RETURN CHAR;
174
175 FUNCTION CF_DISTINCT_UOMFORMULA(ORDER_NUMBER IN VARCHAR2) RETURN NUMBER;
176
177 FUNCTION CF_SORT_ENABLEDFORMULA(CS_COUNT_DUOM IN NUMBER
178 ,CS_SUM_DUOM IN NUMBER) RETURN NUMBER;
179
180 FUNCTION CF_CURR_ENABLEDFORMULA(CS_COUNT_SORT_ENABLED IN NUMBER
181 ,CS_SUM_SORT_ENABLED IN NUMBER) RETURN NUMBER;
182
183 FUNCTION CF_SELLING_PRICEFORMULA(SOURCE_LINE_ID IN NUMBER) RETURN NUMBER;
184
185 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
186
187 FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
188
189 FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
190
191 FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
192
193 FUNCTION RP_ITEM_FLEX_ALL_SEG_WHERE_P RETURN VARCHAR2;
194
195 FUNCTION RP_ORDER_BY_P RETURN VARCHAR2;
196
197 FUNCTION RP_FLEX_OR_DESC_P RETURN VARCHAR2;
198
199 FUNCTION RP_ORDER_RANGE_P RETURN VARCHAR2;
200
201 FUNCTION RP_CATEGORY_SET_P RETURN VARCHAR2;
202
203 FUNCTION RP_CATEGORY_P RETURN VARCHAR2;
204
205 FUNCTION RP_ORDER_NUM_HIGH_P RETURN NUMBER;
206
207 FUNCTION RP_ORDER_NUM_LOW_P RETURN NUMBER;
208
209 FUNCTION RP_WAREHOUSE_P RETURN VARCHAR2;
210
211 FUNCTION RP_ITEM_P RETURN VARCHAR2;
212
213 FUNCTION RP_SOURCE_SYSTEM_P RETURN VARCHAR2;
214
215 PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
216 ,NAME IN VARCHAR2);
217
218 PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
219 ,VALUE IN VARCHAR2
220 ,TRANSLATE IN BOOLEAN);
221
222 PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
223
224 PROCEDURE CLEAR;
225
226 FUNCTION GET_STRING(APPIN IN VARCHAR2
227 ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
228
229 FUNCTION GET_NUMBER(APPIN IN VARCHAR2
230 ,NAMEIN IN VARCHAR2) RETURN NUMBER;
231
232 FUNCTION GET RETURN VARCHAR2;
233
234 FUNCTION GET_ENCODED RETURN VARCHAR2;
235
236 PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
237 ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
238 ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
239
240 PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
241
242 PROCEDURE RAISE_ERROR;
243
244 END WSH_WSHRDBDR_XMLP_PKG;
245
246