[Home] [Help]
PACKAGE BODY: APPS.JAI_CMN_HOOK_PKG
Source
1 PACKAGE BODY jai_cmn_hook_pkg AS
2 /* $Header: jai_cmn_hook.plb 120.1 2005/07/20 12:57:07 avallabh ship $ */
3
4 /*------------------------------------------------------------------------------------------
5 CHANGE HISTORY for FILENAME: jai_cmn_hook_pkg.sql
6 S.No Date Author and Details
7 ------------------------------------------------------------------------------------------
8
9 1 20/02/2004 Nagaraj.s for bug 3438863 Version : 618.1
10
11 This Package is basically meant for any client customizations
12 for defaultation of Localization Taxes when Purchase Orders
13 are not created from PO-Localized screens.
14 Both the Functions
15 Ja_In_po_line_locations_all
16 Ja_In_po_lines_all
17 would return value as True.
18
19 In scenarios where the PO has not been entered from PO-Localized
20 screen, the customer would have an option of avoiding
21 tax defaultation by coding these functions to return
22 'FALSE'.
23
24 In any case, if the Purchase Orders are created from PO Localized
25 screen then Tax defaultation would not be affected.
26
27 2 14/04/2004 Vijay Shankar for bug# 3570189, Version : 619.1 (115.0)
28 PO Hook Functionality is made compatible with 11.5.3 Base Applications by removing last 11 from Ja_In_po_lines_all
29 procedure and 12 from Ja_In_po_line_locations_all procedure
30
31 3 07/02/2005 Vijay Shankar for bug# 4159557, Version : 115.1
32 Function allow_tax_change_on_receipt is added to give flexibility for client in deciding whether taxes can
33 be changed on receipt lines or not for Receipts that are created through Open Interface
34
35 4 22/02/2005 Vijay Shankar for bug# 4199929, Version : 115.2
36 Changes made in the previous version of this package are revoked with this version
37
38 5. 08-Jun-2005 Version 116.1 jai_cmn_hook -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
39 as required for CASE COMPLAINCE.
40
41 6 06-Jul-2005 rallamse for bug# PADDR Elimination
42 1. Added FUNCTION Po_Requisition_Lines_All in both spec and body
43
44 ---------------------------------------------------------------------------------------------*/
45
46 FUNCTION Ja_In_po_lines_all (
47 P_PO_LINE_ID NUMBER,
48 P_PO_HEADER_ID NUMBER,
49 P_LINE_TYPE_ID NUMBER,
50 P_LINE_NUM NUMBER,
51 P_ITEM_ID NUMBER,
52 P_ITEM_REVISION VARCHAR2,
53 P_CATEGORY_ID NUMBER,
54 P_ITEM_DESCRIPTION VARCHAR2,
55 P_UNIT_MEAS_LOOKUP_CODE VARCHAR2,
56 P_QUANTITY_COMMITTED NUMBER,
57 P_COMMITTED_AMOUNT NUMBER,
58 P_ALLOW_PRICE_OVERRIDE_FLAG VARCHAR2,
59 P_NOT_TO_EXCEED_PRICE NUMBER,
60 P_LIST_PRICE_PER_UNIT NUMBER,
61 P_UNIT_PRICE NUMBER,
62 P_QUANTITY NUMBER,
63 P_UN_NUMBER_ID NUMBER,
64 P_HAZARD_CLASS_ID NUMBER,
65 P_NOTE_TO_VENDOR VARCHAR2,
66 P_FROM_HEADER_ID NUMBER,
67 P_FROM_LINE_ID NUMBER,
68 P_MIN_ORDER_QUANTITY NUMBER,
69 P_MAX_ORDER_QUANTITY NUMBER,
70 P_QTY_RCV_TOLERANCE NUMBER,
71 P_OVER_TOLERANCE_ERROR_FLAG VARCHAR2,
72 P_MARKET_PRICE NUMBER,
73 P_UNORDERED_FLAG VARCHAR2,
74 P_CLOSED_FLAG VARCHAR2,
75 P_USER_HOLD_FLAG VARCHAR2,
76 P_CANCEL_FLAG VARCHAR2,
77 P_CANCELLED_BY NUMBER,
78 P_CANCEL_DATE DATE,
79 P_CANCEL_REASON VARCHAR2,
80 P_FIRM_STATUS_LOOKUP_CODE VARCHAR2,
81 P_FIRM_DATE DATE,
82 P_VENDOR_PRODUCT_NUM VARCHAR2,
83 P_CONTRACT_NUM VARCHAR2,
84 P_TAXABLE_FLAG VARCHAR2,
85 P_TAX_NAME VARCHAR2,
86 P_TYPE_1099 VARCHAR2,
87 P_CAPITAL_EXPENSE_FLAG VARCHAR2,
88 P_NEGOTIATED_BY_PREPARER_FLAG VARCHAR2,
89 P_ATTRIBUTE_CATEGORY VARCHAR2,
90 P_ATTRIBUTE1 VARCHAR2,
91 P_ATTRIBUTE2 VARCHAR2,
92 P_ATTRIBUTE3 VARCHAR2,
93 P_ATTRIBUTE4 VARCHAR2,
94 P_ATTRIBUTE5 VARCHAR2,
95 P_ATTRIBUTE6 VARCHAR2,
96 P_ATTRIBUTE7 VARCHAR2,
97 P_ATTRIBUTE8 VARCHAR2,
98 P_ATTRIBUTE9 VARCHAR2,
99 P_ATTRIBUTE10 VARCHAR2,
100 P_REFERENCE_NUM VARCHAR2,
101 P_ATTRIBUTE11 VARCHAR2,
102 P_ATTRIBUTE12 VARCHAR2,
103 P_ATTRIBUTE13 VARCHAR2,
104 P_ATTRIBUTE14 VARCHAR2,
105 P_ATTRIBUTE15 VARCHAR2,
106 P_MIN_RELEASE_AMOUNT NUMBER,
107 P_PRICE_TYPE_LOOKUP_CODE VARCHAR2,
108 P_CLOSED_CODE VARCHAR2,
109 P_PRICE_BREAK_LOOKUP_CODE VARCHAR2,
110 P_USSGL_TRANSACTION_CODE VARCHAR2,
111 P_GOVERNMENT_CONTEXT VARCHAR2,
112 P_REQUEST_ID NUMBER,
113 P_PROGRAM_APPLICATION_ID NUMBER,
114 P_PROGRAM_ID NUMBER,
115 P_PROGRAM_UPDATE_DATE DATE,
116 P_CLOSED_DATE DATE,
117 P_CLOSED_REASON VARCHAR2,
118 P_CLOSED_BY NUMBER,
119 P_TRANSACTION_REASON_CODE VARCHAR2,
120 P_ORG_ID NUMBER,
121 P_QC_GRADE VARCHAR2,
122 P_BASE_UOM VARCHAR2,
123 P_BASE_QTY NUMBER,
124 P_SECONDARY_UOM VARCHAR2,
125 P_SECONDARY_QTY NUMBER,
126 P_LINE_REFERENCE_NUM VARCHAR2,
127 P_PROJECT_ID NUMBER,
128 P_TASK_ID NUMBER,
129 P_EXPIRATION_DATE DATE,
130 P_TAX_CODE_ID NUMBER
131 ) RETURN VARCHAR2
132 IS
133 BEGIN
134
135 /* This function has be customized not to default location taxes*/
136 NULL;
137
138 -- RETURN ('FALSE');
139 RETURN ('TRUE');
140
141 END Ja_In_po_lines_all;
142
143 FUNCTION Ja_In_po_line_locations_all (
144 P_LINE_LOCATION_ID NUMBER,
145 P_PO_HEADER_ID NUMBER,
146 P_PO_LINE_ID NUMBER,
147 P_QUANTITY NUMBER,
148 P_QUANTITY_RECEIVED NUMBER,
149 P_QUANTITY_ACCEPTED NUMBER,
150 P_QUANTITY_REJECTED NUMBER,
151 P_QUANTITY_BILLED NUMBER,
152 P_QUANTITY_CANCELLED NUMBER,
153 P_UNIT_MEAS_LOOKUP_CODE VARCHAR2,
154 P_PO_RELEASE_ID NUMBER,
155 P_SHIP_TO_LOCATION_ID NUMBER,
156 P_SHIP_VIA_LOOKUP_CODE VARCHAR2,
157 P_NEED_BY_DATE DATE,
158 P_PROMISED_DATE DATE,
159 P_LAST_ACCEPT_DATE DATE,
160 P_PRICE_OVERRIDE NUMBER,
161 P_ENCUMBERED_FLAG VARCHAR2,
162 P_ENCUMBERED_DATE DATE,
163 P_UNENCUMBERED_QUANTITY NUMBER,
164 P_FOB_LOOKUP_CODE VARCHAR2,
165 P_FREIGHT_TERMS_LOOKUP_CODE VARCHAR2,
166 P_TAXABLE_FLAG VARCHAR2,
167 P_TAX_NAME VARCHAR2,
168 P_ESTIMATED_TAX_AMOUNT NUMBER,
169 P_FROM_HEADER_ID NUMBER,
170 P_FROM_LINE_ID NUMBER,
171 P_FROM_LINE_LOCATION_ID NUMBER,
172 P_START_DATE DATE,
173 P_END_DATE DATE,
174 P_LEAD_TIME NUMBER,
175 P_LEAD_TIME_UNIT VARCHAR2,
176 P_PRICE_DISCOUNT NUMBER,
177 P_TERMS_ID NUMBER,
178 P_APPROVED_FLAG VARCHAR2,
179 P_APPROVED_DATE DATE,
180 P_CLOSED_FLAG VARCHAR2,
181 P_CANCEL_FLAG VARCHAR2,
182 P_CANCELLED_BY NUMBER,
183 P_CANCEL_DATE DATE,
184 P_CANCEL_REASON VARCHAR2,
185 P_FIRM_STATUS_LOOKUP_CODE VARCHAR2,
186 P_FIRM_DATE DATE,
187 P_ATTRIBUTE_CATEGORY VARCHAR2,
188 P_ATTRIBUTE1 VARCHAR2,
189 P_ATTRIBUTE2 VARCHAR2,
190 P_ATTRIBUTE3 VARCHAR2,
191 P_ATTRIBUTE4 VARCHAR2,
192 P_ATTRIBUTE5 VARCHAR2,
193 P_ATTRIBUTE6 VARCHAR2,
194 P_ATTRIBUTE7 VARCHAR2,
195 P_ATTRIBUTE8 VARCHAR2,
196 P_ATTRIBUTE9 VARCHAR2,
197 P_ATTRIBUTE10 VARCHAR2,
198 P_UNIT_OF_MEASURE_CLASS VARCHAR2,
199 P_ENCUMBER_NOW VARCHAR2,
200 P_ATTRIBUTE11 VARCHAR2,
201 P_ATTRIBUTE12 VARCHAR2,
202 P_ATTRIBUTE13 VARCHAR2,
203 P_ATTRIBUTE14 VARCHAR2,
204 P_ATTRIBUTE15 VARCHAR2,
205 P_INSPECTION_REQUIRED_FLAG VARCHAR2,
206 P_RECEIPT_REQUIRED_FLAG VARCHAR2,
207 P_QTY_RCV_TOLERANCE NUMBER,
208 P_QTY_RCV_EXCEPTION_CODE VARCHAR2,
209 P_ENF_SHIP_TO_LOCATION_CODE VARCHAR2,
210 P_ALLOW_SUBST_RECEIPTS_FLAG VARCHAR2,
211 P_DAYS_EARLY_RECEIPT_ALLOWED NUMBER,
212 P_DAYS_LATE_RECEIPT_ALLOWED NUMBER,
213 P_RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2,
214 P_INVOICE_CLOSE_TOLERANCE NUMBER,
215 P_RECEIVE_CLOSE_TOLERANCE NUMBER,
216 P_SHIP_TO_ORGANIZATION_ID NUMBER,
217 P_SHIPMENT_NUM NUMBER,
218 P_SOURCE_SHIPMENT_ID NUMBER,
219 P_SHIPMENT_TYPE VARCHAR2,
220 P_CLOSED_CODE VARCHAR2,
221 P_REQUEST_ID NUMBER,
222 P_PROGRAM_APPLICATION_ID NUMBER,
223 P_PROGRAM_ID NUMBER,
224 P_PROGRAM_UPDATE_DATE DATE,
225 P_USSGL_TRANSACTION_CODE VARCHAR2,
226 P_GOVERNMENT_CONTEXT VARCHAR2,
227 P_RECEIVING_ROUTING_ID NUMBER,
228 P_ACCRUE_ON_RECEIPT_FLAG VARCHAR2,
229 P_CLOSED_REASON VARCHAR2,
230 P_CLOSED_DATE DATE,
231 P_CLOSED_BY NUMBER,
232 P_ORG_ID NUMBER ,
233 P_QUANTITY_SHIPPED NUMBER,
234 P_COUNTRY_OF_ORIGIN_CODE VARCHAR2,
235 P_TAX_USER_OVERRIDE_FLAG VARCHAR2,
236 P_MATCH_OPTION VARCHAR2,
237 P_TAX_CODE_ID NUMBER,
238 P_CALCULATE_TAX_FLAG VARCHAR2,
239 P_CHANGE_PROMISED_DATE_REASON VARCHAR2
240 ) RETURN VARCHAR2
241 IS
242 BEGIN
243
244 /* This function has be customized not to default location taxes*/
245 NULL;
246 -- RETURN ('FALSE');
247 RETURN ('TRUE');
248
249 END Ja_In_po_line_locations_all;
250
251 FUNCTION oe_lines_insert
252 (p_line_id NUMBER,
253 p_org_id NUMBER,
254 p_line_type_id NUMBER,
255 p_ship_from_org_id NUMBER,
256 p_ship_to_org_id NUMBER,
257 p_invoice_to_org_id NUMBER,
258 p_sold_to_org_id NUMBER,
259 p_sold_from_org_id NUMBER,
260 p_inventory_item_id NUMBER,
261 p_tax_code VARCHAR2,
262 p_price_list_id NUMBER,
263 p_source_document_type_id NUMBER,
264 p_source_document_line_id NUMBER,
265 p_reference_line_id NUMBER,
266 p_reference_header_id NUMBER,
267 p_salesrep_id NUMBER,
268 p_order_source_id NUMBER,
269 p_orig_sys_document_ref VARCHAR2,
270 p_orig_sys_line_ref VARCHAR2) RETURN VARCHAR2 IS
271
272 v_return VARCHAR2(1996);
273
274 BEGIN
275
276
277 /*------------------------------------------------------------------------------------------
278 FILENAME: jai_cmn_hook_pkg.oe_lines_insert.sql
279
280 CHANGE HISTORY:
281 S.No Date Author and Details
282 1 2002/06/13 Asshukla Function created
283 --------------------------------------------------------------------------------------------*/
284
285 /* this portion of the function is to be used for the customised component,
286 based on the return value the trigger JA_IN_OE_ORDER_LINES_AIU_TRG will function
287 the function should return "FALSE" so as not to execute procedure and "TRUE" to run the procedure.
288 Check for the impact on the trigger JA_IN_OE_ORDER_LINES_AIU_TRG before changing return value.
289 the functional currency of the operating unit has to be INR*/
290 NULL;
291 RETURN('TRUE');
292 END oe_lines_insert;
293
297 REQUISITION_LINE_ID NUMBER,
294 /* Added function Po_Requisition_Lines_All by rallamse bug#4479131 PADDR Elimination */
295 FUNCTION Po_Requisition_Lines_All
296 (
298 REQUISITION_HEADER_ID NUMBER,
299 LINE_NUM NUMBER,
300 LINE_TYPE_ID NUMBER,
301 CATEGORY_ID NUMBER,
302 ITEM_DESCRIPTION VARCHAR2,
303 UNIT_MEAS_LOOKUP_CODE VARCHAR2,
304 UNIT_PRICE NUMBER,
305 QUANTITY NUMBER,
306 DELIVER_TO_LOCATION_ID NUMBER,
307 TO_PERSON_ID NUMBER,
308 LAST_UPDATE_DATE DATE,
309 LAST_UPDATED_BY NUMBER,
310 SOURCE_TYPE_CODE VARCHAR2,
311 LAST_UPDATE_LOGIN NUMBER,
312 CREATION_DATE DATE,
313 CREATED_BY NUMBER,
314 ITEM_ID NUMBER,
315 ITEM_REVISION VARCHAR2,
316 QUANTITY_DELIVERED NUMBER,
317 SUGGESTED_BUYER_ID NUMBER,
318 ENCUMBERED_FLAG VARCHAR2,
319 RFQ_REQUIRED_FLAG VARCHAR2,
320 NEED_BY_DATE DATE,
321 LINE_LOCATION_ID NUMBER,
322 MODIFIED_BY_AGENT_FLAG VARCHAR2,
323 PARENT_REQ_LINE_ID NUMBER,
324 JUSTIFICATION VARCHAR2,
325 NOTE_TO_AGENT VARCHAR2,
326 NOTE_TO_RECEIVER VARCHAR2,
327 PURCHASING_AGENT_ID NUMBER,
328 DOCUMENT_TYPE_CODE VARCHAR2,
329 BLANKET_PO_HEADER_ID NUMBER,
330 BLANKET_PO_LINE_NUM NUMBER,
331 CURRENCY_CODE VARCHAR2,
332 RATE_TYPE VARCHAR2,
333 RATE_DATE DATE,
334 RATE NUMBER,
335 CURRENCY_UNIT_PRICE NUMBER,
336 SUGGESTED_VENDOR_NAME VARCHAR2,
337 SUGGESTED_VENDOR_LOCATION VARCHAR2,
338 SUGGESTED_VENDOR_CONTACT VARCHAR2,
339 SUGGESTED_VENDOR_PHONE VARCHAR2,
340 SUGGESTED_VENDOR_PRODUCT_CODE VARCHAR2,
341 UN_NUMBER_ID NUMBER,
342 HAZARD_CLASS_ID NUMBER,
343 MUST_USE_SUGG_VENDOR_FLAG VARCHAR2,
344 REFERENCE_NUM VARCHAR2,
345 ON_RFQ_FLAG VARCHAR2,
346 URGENT_FLAG VARCHAR2,
347 CANCEL_FLAG VARCHAR2,
348 SOURCE_ORGANIZATION_ID NUMBER,
349 SOURCE_SUBINVENTORY VARCHAR2,
350 DESTINATION_TYPE_CODE VARCHAR2,
351 DESTINATION_ORGANIZATION_ID NUMBER,
352 DESTINATION_SUBINVENTORY VARCHAR2,
353 QUANTITY_CANCELLED NUMBER,
354 CANCEL_DATE DATE,
355 CANCEL_REASON VARCHAR2,
356 CLOSED_CODE VARCHAR2,
357 AGENT_RETURN_NOTE VARCHAR2,
358 CHANGED_AFTER_RESEARCH_FLAG VARCHAR2,
359 VENDOR_ID NUMBER,
360 VENDOR_SITE_ID NUMBER,
361 VENDOR_CONTACT_ID NUMBER,
362 RESEARCH_AGENT_ID NUMBER,
363 ON_LINE_FLAG VARCHAR2,
364 WIP_ENTITY_ID NUMBER,
365 WIP_LINE_ID NUMBER,
366 WIP_REPETITIVE_SCHEDULE_ID NUMBER,
367 WIP_OPERATION_SEQ_NUM NUMBER,
368 WIP_RESOURCE_SEQ_NUM NUMBER,
369 ATTRIBUTE_CATEGORY VARCHAR2,
370 DESTINATION_CONTEXT VARCHAR2,
371 INVENTORY_SOURCE_CONTEXT VARCHAR2,
372 VENDOR_SOURCE_CONTEXT VARCHAR2,
373 ATTRIBUTE1 VARCHAR2,
374 ATTRIBUTE2 VARCHAR2,
375 ATTRIBUTE3 VARCHAR2,
376 ATTRIBUTE4 VARCHAR2,
377 ATTRIBUTE5 VARCHAR2,
378 ATTRIBUTE6 VARCHAR2,
379 ATTRIBUTE7 VARCHAR2,
380 ATTRIBUTE8 VARCHAR2,
381 ATTRIBUTE9 VARCHAR2,
382 ATTRIBUTE10 VARCHAR2,
383 ATTRIBUTE11 VARCHAR2,
384 ATTRIBUTE12 VARCHAR2,
385 ATTRIBUTE13 VARCHAR2,
386 ATTRIBUTE14 VARCHAR2,
387 ATTRIBUTE15 VARCHAR2,
388 BOM_RESOURCE_ID NUMBER,
389 CLOSED_REASON VARCHAR2,
390 CLOSED_DATE DATE,
391 TRANSACTION_REASON_CODE VARCHAR2,
392 QUANTITY_RECEIVED NUMBER,
393 SOURCE_REQ_LINE_ID NUMBER,
394 ORG_ID NUMBER,
395 KANBAN_CARD_ID NUMBER,
396 CATALOG_TYPE VARCHAR2,
397 CATALOG_SOURCE VARCHAR2,
398 MANUFACTURER_ID NUMBER,
399 MANUFACTURER_NAME VARCHAR2,
400 MANUFACTURER_PART_NUMBER VARCHAR2,
401 REQUESTER_EMAIL VARCHAR2,
402 REQUESTER_FAX VARCHAR2,
403 REQUESTER_PHONE VARCHAR2,
407 TAX_STATUS_INDICATOR VARCHAR2,
404 UNSPSC_CODE VARCHAR2,
405 OTHER_CATEGORY_CODE VARCHAR2,
406 SUPPLIER_DUNS VARCHAR2,
408 PCARD_FLAG VARCHAR2,
409 NEW_SUPPLIER_FLAG VARCHAR2,
410 AUTO_RECEIVE_FLAG VARCHAR2,
411 TAX_USER_OVERRIDE_FLAG VARCHAR2,
412 TAX_CODE_ID NUMBER,
413 NOTE_TO_VENDOR VARCHAR2,
414 OKE_CONTRACT_VERSION_ID NUMBER,
415 OKE_CONTRACT_HEADER_ID NUMBER,
416 ITEM_SOURCE_ID NUMBER,
417 SUPPLIER_REF_NUMBER VARCHAR2,
418 SECONDARY_UNIT_OF_MEASURE VARCHAR2,
419 SECONDARY_QUANTITY NUMBER,
420 PREFERRED_GRADE VARCHAR2,
421 SECONDARY_QUANTITY_RECEIVED NUMBER,
422 SECONDARY_QUANTITY_CANCELLED NUMBER,
423 VMI_FLAG VARCHAR2,
424 AUCTION_HEADER_ID NUMBER,
425 AUCTION_DISPLAY_NUMBER VARCHAR2,
426 AUCTION_LINE_NUMBER NUMBER,
427 REQS_IN_POOL_FLAG VARCHAR2,
428 BID_NUMBER NUMBER,
429 BID_LINE_NUMBER NUMBER,
430 NONCAT_TEMPLATE_ID NUMBER,
431 SUGGESTED_VENDOR_CONTACT_FAX VARCHAR2,
432 SUGGESTED_VENDOR_CONTACT_EMAIL VARCHAR2,
433 AMOUNT NUMBER,
434 CURRENCY_AMOUNT NUMBER,
435 LABOR_REQ_LINE_ID NUMBER,
436 JOB_ID NUMBER,
437 JOB_LONG_DESCRIPTION VARCHAR2,
438 CONTRACTOR_STATUS VARCHAR2,
439 CONTACT_INFORMATION VARCHAR2,
440 SUGGESTED_SUPPLIER_FLAG VARCHAR2,
441 CANDIDATE_SCREENING_REQD_FLAG VARCHAR2,
442 CANDIDATE_FIRST_NAME VARCHAR2,
443 CANDIDATE_LAST_NAME VARCHAR2,
444 ASSIGNMENT_END_DATE DATE,
445 OVERTIME_ALLOWED_FLAG VARCHAR2,
446 CONTRACTOR_REQUISITION_FLAG VARCHAR2,
447 DROP_SHIP_FLAG VARCHAR2,
448 ASSIGNMENT_START_DATE DATE,
449 ORDER_TYPE_LOOKUP_CODE VARCHAR2,
450 PURCHASE_BASIS VARCHAR2,
451 MATCHING_BASIS VARCHAR2,
452 NEGOTIATED_BY_PREPARER_FLAG VARCHAR2,
453 SHIP_METHOD VARCHAR2,
454 ESTIMATED_PICKUP_DATE DATE,
455 SUPPLIER_NOTIFIED_FOR_CANCEL VARCHAR2,
456 BASE_UNIT_PRICE NUMBER,
457 AT_SOURCING_FLAG VARCHAR2,
458 EVENT_ID NUMBER,
459 LINE_NUMBER NUMBER
460 ) RETURN VARCHAR2 IS
461 BEGIN
462
463 /* This function has be customized not to default location taxes*/
464 NULL;
465 -- RETURN ('FALSE');
466 RETURN ('TRUE');
467
468 END Po_Requisition_Lines_All ;
469
470 End jai_cmn_hook_pkg;