[Home] [Help]
PACKAGE: APPS.JAI_CMN_HOOK_PKG
Source
1 PACKAGE jai_cmn_hook_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_cmn_hook.pls 120.1 2005/07/20 12:57:08 avallabh ship $ */
3
4 Function Ja_In_po_lines_all(
5 P_PO_LINE_ID NUMBER,
6 P_PO_HEADER_ID NUMBER,
7 P_LINE_TYPE_ID NUMBER,
8 P_LINE_NUM NUMBER,
9 P_ITEM_ID NUMBER,
10 P_ITEM_REVISION VARCHAR2,
11 P_CATEGORY_ID NUMBER,
12 P_ITEM_DESCRIPTION VARCHAR2,
13 P_UNIT_MEAS_LOOKUP_CODE VARCHAR2,
14 P_QUANTITY_COMMITTED NUMBER,
15 P_COMMITTED_AMOUNT NUMBER,
16 P_ALLOW_PRICE_OVERRIDE_FLAG VARCHAR2,
17 P_NOT_TO_EXCEED_PRICE NUMBER,
18 P_LIST_PRICE_PER_UNIT NUMBER,
19 P_UNIT_PRICE NUMBER,
20 P_QUANTITY NUMBER,
21 P_UN_NUMBER_ID NUMBER,
22 P_HAZARD_CLASS_ID NUMBER,
23 P_NOTE_TO_VENDOR VARCHAR2,
24 P_FROM_HEADER_ID NUMBER,
25 P_FROM_LINE_ID NUMBER,
26 P_MIN_ORDER_QUANTITY NUMBER,
27 P_MAX_ORDER_QUANTITY NUMBER,
28 P_QTY_RCV_TOLERANCE NUMBER,
29 P_OVER_TOLERANCE_ERROR_FLAG VARCHAR2,
30 P_MARKET_PRICE NUMBER,
31 P_UNORDERED_FLAG VARCHAR2,
32 P_CLOSED_FLAG VARCHAR2,
33 P_USER_HOLD_FLAG VARCHAR2,
34 P_CANCEL_FLAG VARCHAR2,
35 P_CANCELLED_BY NUMBER,
36 P_CANCEL_DATE DATE,
37 P_CANCEL_REASON VARCHAR2,
38 P_FIRM_STATUS_LOOKUP_CODE VARCHAR2,
39 P_FIRM_DATE DATE,
40 P_VENDOR_PRODUCT_NUM VARCHAR2,
41 P_CONTRACT_NUM VARCHAR2,
42 P_TAXABLE_FLAG VARCHAR2,
43 P_TAX_NAME VARCHAR2,
44 P_TYPE_1099 VARCHAR2,
45 P_CAPITAL_EXPENSE_FLAG VARCHAR2,
46 P_NEGOTIATED_BY_PREPARER_FLAG VARCHAR2,
47 P_ATTRIBUTE_CATEGORY VARCHAR2,
48 P_ATTRIBUTE1 VARCHAR2,
49 P_ATTRIBUTE2 VARCHAR2,
50 P_ATTRIBUTE3 VARCHAR2,
51 P_ATTRIBUTE4 VARCHAR2,
52 P_ATTRIBUTE5 VARCHAR2,
53 P_ATTRIBUTE6 VARCHAR2,
54 P_ATTRIBUTE7 VARCHAR2,
55 P_ATTRIBUTE8 VARCHAR2,
56 P_ATTRIBUTE9 VARCHAR2,
57 P_ATTRIBUTE10 VARCHAR2,
58 P_REFERENCE_NUM VARCHAR2,
59 P_ATTRIBUTE11 VARCHAR2,
60 P_ATTRIBUTE12 VARCHAR2,
61 P_ATTRIBUTE13 VARCHAR2,
62 P_ATTRIBUTE14 VARCHAR2,
63 P_ATTRIBUTE15 VARCHAR2,
64 P_MIN_RELEASE_AMOUNT NUMBER,
65 P_PRICE_TYPE_LOOKUP_CODE VARCHAR2,
66 P_CLOSED_CODE VARCHAR2,
67 P_PRICE_BREAK_LOOKUP_CODE VARCHAR2,
68 P_USSGL_TRANSACTION_CODE VARCHAR2,
69 P_GOVERNMENT_CONTEXT VARCHAR2,
70 P_REQUEST_ID NUMBER,
71 P_PROGRAM_APPLICATION_ID NUMBER,
72 P_PROGRAM_ID NUMBER,
73 P_PROGRAM_UPDATE_DATE DATE,
74 P_CLOSED_DATE DATE,
75 P_CLOSED_REASON VARCHAR2,
76 P_CLOSED_BY NUMBER,
77 P_TRANSACTION_REASON_CODE VARCHAR2,
78 P_ORG_ID NUMBER,
79 P_QC_GRADE VARCHAR2,
80 P_BASE_UOM VARCHAR2,
81 P_BASE_QTY NUMBER,
82 P_SECONDARY_UOM VARCHAR2,
83 P_SECONDARY_QTY NUMBER,
84 P_LINE_REFERENCE_NUM VARCHAR2,
85 P_PROJECT_ID NUMBER,
86 P_TASK_ID NUMBER,
87 P_EXPIRATION_DATE DATE,
88 P_TAX_CODE_ID NUMBER
89 ) RETURN VARCHAR2;
90
91 Function Ja_In_po_line_locations_all(
92 P_LINE_LOCATION_ID NUMBER,
93 P_PO_HEADER_ID NUMBER,
94 P_PO_LINE_ID NUMBER,
95 P_QUANTITY NUMBER,
96 P_QUANTITY_RECEIVED NUMBER,
97 P_QUANTITY_ACCEPTED NUMBER,
98 P_QUANTITY_REJECTED NUMBER,
99 P_QUANTITY_BILLED NUMBER,
100 P_QUANTITY_CANCELLED NUMBER,
101 P_UNIT_MEAS_LOOKUP_CODE VARCHAR2,
102 P_PO_RELEASE_ID NUMBER,
103 P_SHIP_TO_LOCATION_ID NUMBER,
104 P_SHIP_VIA_LOOKUP_CODE VARCHAR2,
105 P_NEED_BY_DATE DATE,
106 P_PROMISED_DATE DATE,
107 P_LAST_ACCEPT_DATE DATE,
108 P_PRICE_OVERRIDE NUMBER,
109 P_ENCUMBERED_FLAG VARCHAR2,
110 P_ENCUMBERED_DATE DATE,
111 P_UNENCUMBERED_QUANTITY NUMBER,
112 P_FOB_LOOKUP_CODE VARCHAR2,
113 P_FREIGHT_TERMS_LOOKUP_CODE VARCHAR2,
114 P_TAXABLE_FLAG VARCHAR2,
115 P_TAX_NAME VARCHAR2,
116 P_ESTIMATED_TAX_AMOUNT NUMBER,
117 P_FROM_HEADER_ID NUMBER,
118 P_FROM_LINE_ID NUMBER,
119 P_FROM_LINE_LOCATION_ID NUMBER,
120 P_START_DATE DATE,
121 P_END_DATE DATE,
122 P_LEAD_TIME NUMBER,
123 P_LEAD_TIME_UNIT VARCHAR2,
124 P_PRICE_DISCOUNT NUMBER,
125 P_TERMS_ID NUMBER,
126 P_APPROVED_FLAG VARCHAR2,
127 P_APPROVED_DATE DATE,
128 P_CLOSED_FLAG VARCHAR2,
129 P_CANCEL_FLAG VARCHAR2,
130 P_CANCELLED_BY NUMBER,
131 P_CANCEL_DATE DATE,
132 P_CANCEL_REASON VARCHAR2,
133 P_FIRM_STATUS_LOOKUP_CODE VARCHAR2,
134 P_FIRM_DATE DATE,
135 P_ATTRIBUTE_CATEGORY VARCHAR2,
136 P_ATTRIBUTE1 VARCHAR2,
137 P_ATTRIBUTE2 VARCHAR2,
138 P_ATTRIBUTE3 VARCHAR2,
139 P_ATTRIBUTE4 VARCHAR2,
140 P_ATTRIBUTE5 VARCHAR2,
141 P_ATTRIBUTE6 VARCHAR2,
142 P_ATTRIBUTE7 VARCHAR2,
143 P_ATTRIBUTE8 VARCHAR2,
144 P_ATTRIBUTE9 VARCHAR2,
145 P_ATTRIBUTE10 VARCHAR2,
146 P_UNIT_OF_MEASURE_CLASS VARCHAR2,
147 P_ENCUMBER_NOW VARCHAR2,
148 P_ATTRIBUTE11 VARCHAR2,
149 P_ATTRIBUTE12 VARCHAR2,
150 P_ATTRIBUTE13 VARCHAR2,
151 P_ATTRIBUTE14 VARCHAR2,
152 P_ATTRIBUTE15 VARCHAR2,
153 P_INSPECTION_REQUIRED_FLAG VARCHAR2,
154 P_RECEIPT_REQUIRED_FLAG VARCHAR2,
155 P_QTY_RCV_TOLERANCE NUMBER,
156 P_QTY_RCV_EXCEPTION_CODE VARCHAR2,
157 P_ENF_SHIP_TO_LOCATION_CODE VARCHAR2,
158 P_ALLOW_SUBST_RECEIPTS_FLAG VARCHAR2,
159 P_DAYS_EARLY_RECEIPT_ALLOWED NUMBER,
160 P_DAYS_LATE_RECEIPT_ALLOWED NUMBER,
161 P_RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2,
162 P_INVOICE_CLOSE_TOLERANCE NUMBER,
163 P_RECEIVE_CLOSE_TOLERANCE NUMBER,
164 P_SHIP_TO_ORGANIZATION_ID NUMBER,
165 P_SHIPMENT_NUM NUMBER,
166 P_SOURCE_SHIPMENT_ID NUMBER,
167 P_SHIPMENT_TYPE VARCHAR2,
168 P_CLOSED_CODE VARCHAR2,
169 P_REQUEST_ID NUMBER,
170 P_PROGRAM_APPLICATION_ID NUMBER,
171 P_PROGRAM_ID NUMBER,
172 P_PROGRAM_UPDATE_DATE DATE,
173 P_USSGL_TRANSACTION_CODE VARCHAR2,
174 P_GOVERNMENT_CONTEXT VARCHAR2,
175 P_RECEIVING_ROUTING_ID NUMBER,
176 P_ACCRUE_ON_RECEIPT_FLAG VARCHAR2,
177 P_CLOSED_REASON VARCHAR2,
178 P_CLOSED_DATE DATE,
179 P_CLOSED_BY NUMBER,
180 P_ORG_ID NUMBER ,
181 P_QUANTITY_SHIPPED NUMBER,
182 P_COUNTRY_OF_ORIGIN_CODE VARCHAR2,
183 P_TAX_USER_OVERRIDE_FLAG VARCHAR2,
184 P_MATCH_OPTION VARCHAR2,
185 P_TAX_CODE_ID NUMBER,
186 P_CALCULATE_TAX_FLAG VARCHAR2,
187 P_CHANGE_PROMISED_DATE_REASON VARCHAR2
188 ) return VARCHAR2;
189
190 FUNCTION oe_lines_insert
191 (p_line_id NUMBER,
192 p_org_id NUMBER,
193 p_line_type_id NUMBER,
194 p_ship_from_org_id NUMBER,
195 p_ship_to_org_id NUMBER,
196 p_invoice_to_org_id NUMBER,
197 p_sold_to_org_id NUMBER,
198 p_sold_from_org_id NUMBER,
199 p_inventory_item_id NUMBER,
200 p_tax_code VARCHAR2,
201 p_price_list_id NUMBER,
202 p_source_document_type_id NUMBER,
203 p_source_document_line_id NUMBER,
204 p_reference_line_id NUMBER,
205 p_reference_header_id NUMBER,
206 p_salesrep_id NUMBER,
207 p_order_source_id NUMBER,
208 p_orig_sys_document_ref VARCHAR2,
209 p_orig_sys_line_ref VARCHAR2) RETURN VARCHAR2;
210
211 /* Added function Po_Requisition_Lines_All by rallamse bug#4479131 PADDR Elimination */
212 FUNCTION Po_Requisition_Lines_All
213 (
214 REQUISITION_LINE_ID NUMBER,
215 REQUISITION_HEADER_ID NUMBER,
216 LINE_NUM NUMBER,
217 LINE_TYPE_ID NUMBER,
218 CATEGORY_ID NUMBER,
219 ITEM_DESCRIPTION VARCHAR2,
220 UNIT_MEAS_LOOKUP_CODE VARCHAR2,
221 UNIT_PRICE NUMBER,
222 QUANTITY NUMBER,
223 DELIVER_TO_LOCATION_ID NUMBER,
224 TO_PERSON_ID NUMBER,
225 LAST_UPDATE_DATE DATE,
226 LAST_UPDATED_BY NUMBER,
227 SOURCE_TYPE_CODE VARCHAR2,
228 LAST_UPDATE_LOGIN NUMBER,
229 CREATION_DATE DATE,
230 CREATED_BY NUMBER,
231 ITEM_ID NUMBER,
232 ITEM_REVISION VARCHAR2,
233 QUANTITY_DELIVERED NUMBER,
234 SUGGESTED_BUYER_ID NUMBER,
235 ENCUMBERED_FLAG VARCHAR2,
236 RFQ_REQUIRED_FLAG VARCHAR2,
237 NEED_BY_DATE DATE,
238 LINE_LOCATION_ID NUMBER,
239 MODIFIED_BY_AGENT_FLAG VARCHAR2,
240 PARENT_REQ_LINE_ID NUMBER,
241 JUSTIFICATION VARCHAR2,
242 NOTE_TO_AGENT VARCHAR2,
243 NOTE_TO_RECEIVER VARCHAR2,
244 PURCHASING_AGENT_ID NUMBER,
245 DOCUMENT_TYPE_CODE VARCHAR2,
246 BLANKET_PO_HEADER_ID NUMBER,
247 BLANKET_PO_LINE_NUM NUMBER,
248 CURRENCY_CODE VARCHAR2,
249 RATE_TYPE VARCHAR2,
250 RATE_DATE DATE,
251 RATE NUMBER,
255 SUGGESTED_VENDOR_CONTACT VARCHAR2,
252 CURRENCY_UNIT_PRICE NUMBER,
253 SUGGESTED_VENDOR_NAME VARCHAR2,
254 SUGGESTED_VENDOR_LOCATION VARCHAR2,
256 SUGGESTED_VENDOR_PHONE VARCHAR2,
257 SUGGESTED_VENDOR_PRODUCT_CODE VARCHAR2,
258 UN_NUMBER_ID NUMBER,
262 ON_RFQ_FLAG VARCHAR2,
259 HAZARD_CLASS_ID NUMBER,
260 MUST_USE_SUGG_VENDOR_FLAG VARCHAR2,
261 REFERENCE_NUM VARCHAR2,
263 URGENT_FLAG VARCHAR2,
264 CANCEL_FLAG VARCHAR2,
268 DESTINATION_ORGANIZATION_ID NUMBER,
265 SOURCE_ORGANIZATION_ID NUMBER,
266 SOURCE_SUBINVENTORY VARCHAR2,
267 DESTINATION_TYPE_CODE VARCHAR2,
269 DESTINATION_SUBINVENTORY VARCHAR2,
270 QUANTITY_CANCELLED NUMBER,
271 CANCEL_DATE DATE,
272 CANCEL_REASON VARCHAR2,
273 CLOSED_CODE VARCHAR2,
274 AGENT_RETURN_NOTE VARCHAR2,
275 CHANGED_AFTER_RESEARCH_FLAG VARCHAR2,
276 VENDOR_ID NUMBER,
277 VENDOR_SITE_ID NUMBER,
278 VENDOR_CONTACT_ID NUMBER,
279 RESEARCH_AGENT_ID NUMBER,
280 ON_LINE_FLAG VARCHAR2,
281 WIP_ENTITY_ID NUMBER,
282 WIP_LINE_ID NUMBER,
283 WIP_REPETITIVE_SCHEDULE_ID NUMBER,
284 WIP_OPERATION_SEQ_NUM NUMBER,
285 WIP_RESOURCE_SEQ_NUM NUMBER,
286 ATTRIBUTE_CATEGORY VARCHAR2,
287 DESTINATION_CONTEXT VARCHAR2,
288 INVENTORY_SOURCE_CONTEXT VARCHAR2,
289 VENDOR_SOURCE_CONTEXT VARCHAR2,
290 ATTRIBUTE1 VARCHAR2,
291 ATTRIBUTE2 VARCHAR2,
292 ATTRIBUTE3 VARCHAR2,
296 ATTRIBUTE7 VARCHAR2,
293 ATTRIBUTE4 VARCHAR2,
294 ATTRIBUTE5 VARCHAR2,
295 ATTRIBUTE6 VARCHAR2,
297 ATTRIBUTE8 VARCHAR2,
298 ATTRIBUTE9 VARCHAR2,
299 ATTRIBUTE10 VARCHAR2,
300 ATTRIBUTE11 VARCHAR2,
301 ATTRIBUTE12 VARCHAR2,
302 ATTRIBUTE13 VARCHAR2,
303 ATTRIBUTE14 VARCHAR2,
304 ATTRIBUTE15 VARCHAR2,
308 TRANSACTION_REASON_CODE VARCHAR2,
305 BOM_RESOURCE_ID NUMBER,
306 CLOSED_REASON VARCHAR2,
307 CLOSED_DATE DATE,
309 QUANTITY_RECEIVED NUMBER,
310 SOURCE_REQ_LINE_ID NUMBER,
311 ORG_ID NUMBER,
312 KANBAN_CARD_ID NUMBER,
313 CATALOG_TYPE VARCHAR2,
314 CATALOG_SOURCE VARCHAR2,
315 MANUFACTURER_ID NUMBER,
316 MANUFACTURER_NAME VARCHAR2,
320 REQUESTER_PHONE VARCHAR2,
317 MANUFACTURER_PART_NUMBER VARCHAR2,
318 REQUESTER_EMAIL VARCHAR2,
319 REQUESTER_FAX VARCHAR2,
321 UNSPSC_CODE VARCHAR2,
322 OTHER_CATEGORY_CODE VARCHAR2,
323 SUPPLIER_DUNS VARCHAR2,
324 TAX_STATUS_INDICATOR VARCHAR2,
325 PCARD_FLAG VARCHAR2,
326 NEW_SUPPLIER_FLAG VARCHAR2,
327 AUTO_RECEIVE_FLAG VARCHAR2,
328 TAX_USER_OVERRIDE_FLAG VARCHAR2,
329 TAX_CODE_ID NUMBER,
330 NOTE_TO_VENDOR VARCHAR2,
331 OKE_CONTRACT_VERSION_ID NUMBER,
332 OKE_CONTRACT_HEADER_ID NUMBER,
333 ITEM_SOURCE_ID NUMBER,
334 SUPPLIER_REF_NUMBER VARCHAR2,
335 SECONDARY_UNIT_OF_MEASURE VARCHAR2,
336 SECONDARY_QUANTITY NUMBER,
337 PREFERRED_GRADE VARCHAR2,
338 SECONDARY_QUANTITY_RECEIVED NUMBER,
339 SECONDARY_QUANTITY_CANCELLED NUMBER,
340 VMI_FLAG VARCHAR2,
341 AUCTION_HEADER_ID NUMBER,
342 AUCTION_DISPLAY_NUMBER VARCHAR2,
343 AUCTION_LINE_NUMBER NUMBER,
344 REQS_IN_POOL_FLAG VARCHAR2,
345 BID_NUMBER NUMBER,
346 BID_LINE_NUMBER NUMBER,
347 NONCAT_TEMPLATE_ID NUMBER,
348 SUGGESTED_VENDOR_CONTACT_FAX VARCHAR2,
349 SUGGESTED_VENDOR_CONTACT_EMAIL VARCHAR2,
350 AMOUNT NUMBER,
351 CURRENCY_AMOUNT NUMBER,
352 LABOR_REQ_LINE_ID NUMBER,
353 JOB_ID NUMBER,
357 SUGGESTED_SUPPLIER_FLAG VARCHAR2,
354 JOB_LONG_DESCRIPTION VARCHAR2,
355 CONTRACTOR_STATUS VARCHAR2,
356 CONTACT_INFORMATION VARCHAR2,
358 CANDIDATE_SCREENING_REQD_FLAG VARCHAR2,
359 CANDIDATE_FIRST_NAME VARCHAR2,
360 CANDIDATE_LAST_NAME VARCHAR2,
361 ASSIGNMENT_END_DATE DATE,
362 OVERTIME_ALLOWED_FLAG VARCHAR2,
363 CONTRACTOR_REQUISITION_FLAG VARCHAR2,
364 DROP_SHIP_FLAG VARCHAR2,
365 ASSIGNMENT_START_DATE DATE,
366 ORDER_TYPE_LOOKUP_CODE VARCHAR2,
367 PURCHASE_BASIS VARCHAR2,
368 MATCHING_BASIS VARCHAR2,
369 NEGOTIATED_BY_PREPARER_FLAG VARCHAR2,
370 SHIP_METHOD VARCHAR2,
371 ESTIMATED_PICKUP_DATE DATE,
372 SUPPLIER_NOTIFIED_FOR_CANCEL VARCHAR2,
373 BASE_UNIT_PRICE NUMBER,
374 AT_SOURCING_FLAG VARCHAR2,
375 EVENT_ID NUMBER,
376 LINE_NUMBER NUMBER
377 ) RETURN VARCHAR2 ;
378
379 END jai_cmn_hook_pkg ;