[Home] [Help]
PACKAGE BODY: APPS.GML_OM_MIG_VALIDATE_PKG
Source
1 PACKAGE BODY GML_OM_MIG_VALIDATE_PKG AS
2 /* $Header: GMLOMVAB.pls 120.1 2006/09/15 19:34:24 plowe noship $ */
3
4 /*===========================================================================
5 | Function Name: VALIDATE_ORDER_NO
6 |
7 | DESCRIPTION
8 | Order_no must be numeric or it will not be converted
9 |
10 | MODIFICATION HISTORY
11 |
12 ============================================================================*/
13 Function VALIDATE_ORDER_NO(p_order_no in varchar2, order_id in number) return boolean is
14 begin
15 null;
16 END validate_order_no;
17
18 /*===========================================================================
19 | Procedure Name: VALIDATE_CUSTOMER
20 |
21 | DESCRIPTION
22 | validation of the customer id ,check if present in opm and om
23 |
24 | MODIFICATION HISTORY
25 |
26 ============================================================================*/
27 PROCEDURE VALIDATE_CUSTOMER(p_cust_id in number,
28 v_cust_id out Nocopy number, -- GSCC b4403407 NCOPY
29 order_id in number) IS
30 begin
31 null;
32 End validate_customer;
33
34 /*===========================================================================
35 | Procedure Name: VALIDATE_SALESREP
36 |
37 | DESCRIPTION
38 | Validation of the salesrep id ,check if present in opm and om
39 |
40 | MODIFICATION HISTORY
41 |
42 ============================================================================*/
43 PROCEDURE validate_salesrep(slsrep_code IN VARCHAR2,
44 salesrep_number OUT NOCOPY NUMBER, -- GSCC b4403407 NCOPY
45 order_id IN NUMBER) IS
46 begin
47 null;
48 End validate_salesrep;
49
50 /*===========================================================================
51 | Procedure Name: VALIDATE_SHIPPER
52 |
53 | DESCRIPTION
54 | Validation of the shipper code ,check if present in opm and om
55 |
56 | MODIFICATION HISTORY
57 ============================================================================*/
58 PROCEDURE validate_shipper(p_shipper_code IN VARCHAR2,
59 p_organization_id IN NUMBER,
60 freight_carrier_code OUT NOCOPY VARCHAR2, -- GSCC b4403407 NCOPY
61 p_ship_method_code IN VARCHAR2,
62 shipping_method_code OUT NOCOPY VARCHAR2, -- GSCC b4403407 NCOPY
63 order_id IN NUMBER) IS
64
65 begin
66 null;
67 END validate_shipper;
68
69 /*===========================================================================
70 | Procedure Name: FETCH_FREIGHT_TERMS_CODE
71 |
72 | DESCRIPTION
73 | Validation of the frtbill_mthd
74 |
75 | MODIFICATION HISTORY
76 |
77 ============================================================================*/
78 PROCEDURE fetch_freight_terms_code(p_frtbill_mthd in varchar2,
79 p_freight_terms_code out Nocopy varchar2,
80 order_id in number) IS
81 begin
82 null;
83 END FETCH_FREIGHT_TERMS_CODE;
84
85
86
87 /*===========================================================================
88 | Function Name: VALIDATE_PAYMENT_TERM
89 |
90 | DESCRIPTION
91 | validation of terms code, check if present in opm and om
92 |
93 | MODIFICATION HISTORY
94 |
95 ============================================================================*/
96 FUNCTION validate_payment_term(p_terms_code in varchar2,
97 p_term_id out Nocopy number, -- GSCC b4403407 NCOPY
98 order_id in number) RETURN BOOLEAN IS
99 begin
100 null;
101
102 End validate_payment_term;
103
104
105 /*===========================================================================
106 | Function Name: VALIDATE_CURR_CODE
107 |
108 | DESCRIPTION
109 | Check that currency code is only 3 characters or it can not be converted
110 |
111 | MODIFICATION HISTORY
112 |
113 ============================================================================*/
114 FUNCTION validate_curr_code(currency in varchar2) RETURN BOOLEAN IS
115 begin
116 null;
117
118 End VALIDATE_CURR_CODE;
119
120 /*===========================================================================
121 | Function Name: ORGANIZATION_ID
122 |
123 | DESCRIPTION
124 | This function gets the organization_id and set of books id
125 | from gl_plcy_mst table
126 |
127 | MODIFICATION HISTORY
128 |
129 | 27-DEC-00 NC getting the org_id from gl_plcy_mst based on the co_code
130 | from sy_orgn_mst for the orgn_code passed. Modified the
131 | parameters.
132 |
133 ============================================================================*/
134 PROCEDURE get_org_id(p_orgn_code IN VARCHAR2,
135 p_order_id IN NUMBER,
136 p_sob_id OUT NOCOPY NUMBER, -- GSCC b4403407 NCOPY
137 p_org_id OUT NOCOPY NUMBER ) AS
138 begin
139 null;
140 End get_org_id;
141
142 /*===========================================================================
143 | Procedure Name: ORIG_SYS_DOCUMENT_REF
144 |
145 | DESCRIPTION
146 | This function sets the value to 'orgn_code'-'order_number'
147 |
148 | MODIFICATION HISTORY
149 |
150 ============================================================================*/
151 PROCEDURE orig_sys_document_ref(p_orgn_code in varchar,
152 p_orig_sys_document_ref out Nocopy varchar2, -- GSCC b4403407 NCOPY
153 p_order_no in varchar2) IS
154
155 begin
156 null;
157
158
159 End ORIG_SYS_DOCUMENT_REF;
160
161
162 /*===========================================================================
163 | Procedure Name: PRICE_LIST_ID
164 |
165 | DESCRIPTION
166 | This Procedure is just a shell for the header
167 |
168 | MODIFICATION HISTORY
169 |
170 ============================================================================*/
171 Procedure PRICE_LIST_ID (billing_currency in varchar2, order_id in number, price_list out Nocopy number) is -- GSCC b4403407 NOCOPY
172 begin
173 null;
174 End PRICE_LIST_ID;
175
176
177 /*===========================================================================
178 | Procedure Name: SHIP_FROM_ORG_ID
179 |
180 | DESCRIPTION
181 | this procedure gets the ship from org_id
182 |
183 | MODIFICATION HISTORY
184 |
185 ============================================================================*/
186 PROCEDURE ship_from_org_id(p_from_whse in varchar2,
187 ship_from_org_id out Nocopy number, -- GSCC b4403407 NCOPY
188 order_id in number) IS
189
190 begin
191 null;
192 END SHIP_FROM_ORG_ID;
193
194
195 /*===========================================================================
196 | Procedure Name: INVOICE_TO_ORG_ID
197 |
198 | DESCRIPTION
199 | This procedure gets the INVOICE_TO_ORG_ID
200 |
201 | MODIFICATION HISTORY
202 |
203 ============================================================================*/
204 PROCEDURE INVOICE_TO_ORG_ID(p_billcust_id in varchar2,
205 bill_to_org_id out Nocopy number, -- GSCC b4403407 NCOPY
206 order_id in number)
207 IS
208 begin
209 null;
210
211 End INVOICE_TO_ORG_ID;
212
213
214 /*===========================================================================
215 | Procedure Name: SHIP_TO_ORG_ID
216 |
217 | DESCRIPTION
218 | This procedure gets the ship_to_org_id
219 |
220 | MODIFICATION HISTORY
221 |
222 ============================================================================*/
223 PROCEDURE ship_to_org_id(p_shipcust_id in varchar2,
224 ship_to_org_id out Nocopy number, -- GSCC b4403407 NCOPY
225 order_id in number) IS
226 begin
227 null;
228
229 End SHIP_TO_ORG_ID;
230
231 /*===========================================================================
232 | Procedure Name: deliver_to_org_id
233 |
234 | DESCRIPTION
235 | This procedure gets the deliver_to_org_id
236 |
237 | MODIFICATION HISTORY
238 |
239 ============================================================================*/
240 PROCEDURE deliver_to_org_id(p_soldtocust_id IN VARCHAR2,
241 deliver_to_org_id OUT NOCOPY NUMBER, -- GSCC b4403407 NCOPY
242 order_id IN NUMBER) IS
243 begin
244 null;
245 END deliver_to_org_id;
246
247 /*===========================================================================
248 | Procedure Name: SHIP_TO_CONTACT_ID
249 |
250 | DESCRIPTION
251 |
252 | MODIFICATION HISTORY
253 |
254 ============================================================================*/
255 Procedure SHIP_TO_CONTACT_ID(p_contact_id in number,
256 p_org_id IN NUMBER,
257 ship_to_contact_id out Nocopy number, -- GSCC b4403407 NCOPY
258 order_id in number) IS
259 begin
260 null;
261
262 End SHIP_TO_CONTACT_ID;
263
264
265 /*===========================================================================
266 | Procedure Name: ORDER_TYPE_ID
267 |
268 | DESCRIPTION
269 |
270 | MODIFICATION HISTORY
271 |
272 ============================================================================*/
273 PROCEDURE order_type_id(p_order_type in number,
274 p_org_id in number,
275 p_order_type_id out Nocopy number,
276 p_price_list_id out Nocopy number, -- GSCC b4403407 NCOPY
277 order_id in number) IS
278 begin
279 null;
280
281 END ORDER_TYPE_ID;
282
283
284 /*===========================================================================
285 | Procedure Name: FOB_POINT_CODE
286 |
287 | DESCRIPTION
288 |
289 | MODIFICATION HISTORY
290 |
291 ============================================================================*/
292 PROCEDURE fob_point_code(p_fob_code in varchar2,
293 fob_code out Nocopy varchar2, -- GSCC b4403407 NCOPY
294 order_id in number) IS
295 begin
296 null;
297
298 End FOB_POINT_CODE;
299
300 /*===========================================================================
301 | Procedure Name: hold_reason_code
302 |
303 | DESCRIPTION
304 |
305 | MODIFICATION HISTORY
306 |
307 ============================================================================*/
308 PROCEDURE hold_reason_code(p_holdreas_code IN VARCHAR2,
309 order_id IN NUMBER,
310 line_id IN NUMBER,
311 hold_id OUT NOCOPY NUMBER) IS -- GSCC b4403407 NCOPY
312 begin
313 null;
314 END hold_reason_code;
315
316 /*===========================================================================
317 | Procedure Name: migrate_ship_methods
318 |
319 | DESCRIPTION
320 |
321 | MODIFICATION HISTORY
322 |
323 ============================================================================*/
324 PROCEDURE migrate_ship_methods IS
325 begin
326 null;
327 END migrate_ship_methods;
328
329 /*===========================================================================
330 | Procedure Name: get_rate_type_code
331 |
332 | DESCRIPTION
333 | This procedure gets the rate type code for currency conversions.
334 |
335 | MODIFICATION HISTORY
336 |
337 ============================================================================*/
338 PROCEDURE get_rate_type_code(p_order_id IN NUMBER,
339 p_orgn_code IN VARCHAR2,
340 p_billing_currency IN VARCHAR2,
341 x_rate_type OUT NOCOPY VARCHAR2) IS -- GSCC b4403407 NCOPY
342 begin
343 null;
344 END get_rate_type_code;
345
346 /*===========================================================================
347 | Procedure Name: ERROR_LOG
348 |
349 | DESCRIPTION
350 | This procedure stores the error messages in ERROR_LOG
351 |
352 | MODIFICATION HISTORY
353 |
354 ============================================================================*/
355 PROCEDURE error_log(p_header_id in NUMBER,
356 p_line_id in NUMBER,
357 p_column_name in varchar2,
358 p_error_text in varchar2,
359 p_sqlcode in number,
360 p_sqlerr_text in varchar2) IS
361 PRAGMA AUTONOMOUS_TRANSACTION;
362 begin
363 null;
364 end error_log;
365 END GML_OM_MIG_VALIDATE_PKG;