eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REQIMP_PKG dependencies on PO_REQUISITIONS_INTERFACE

Line 29: po_requisitions_interface.item_id%TYPE,

25: -- *
26:
27: PROCEDURE JA_AU_GET_CONV_RATES
28: (x_item_id IN
29: po_requisitions_interface.item_id%TYPE,
30: x_unit_of_purchase IN
31: po_requisitions_interface.unit_of_measure%TYPE,
32: x_unit_of_measure IN
33: po_requisitions_interface.unit_of_measure%TYPE,

Line 31: po_requisitions_interface.unit_of_measure%TYPE,

27: PROCEDURE JA_AU_GET_CONV_RATES
28: (x_item_id IN
29: po_requisitions_interface.item_id%TYPE,
30: x_unit_of_purchase IN
31: po_requisitions_interface.unit_of_measure%TYPE,
32: x_unit_of_measure IN
33: po_requisitions_interface.unit_of_measure%TYPE,
34: x_to_rate OUT NOCOPY
35: mtl_uom_conversions.conversion_rate%TYPE,

Line 33: po_requisitions_interface.unit_of_measure%TYPE,

29: po_requisitions_interface.item_id%TYPE,
30: x_unit_of_purchase IN
31: po_requisitions_interface.unit_of_measure%TYPE,
32: x_unit_of_measure IN
33: po_requisitions_interface.unit_of_measure%TYPE,
34: x_to_rate OUT NOCOPY
35: mtl_uom_conversions.conversion_rate%TYPE,
36: x_item_uom_class OUT NOCOPY
37: mtl_uom_conversions.uom_class%TYPE,

Line 86: po_requisitions_interface.unit_price%TYPE

82: mtl_uom_conversions.conversion_rate%TYPE,
83: x_class_rate IN
84: mtl_uom_class_conversions.conversion_rate%TYPE,
85: x_unit_price IN OUT NOCOPY
86: po_requisitions_interface.unit_price%TYPE
87: )
88: IS
89: BEGIN
90:

Line 117: po_requisitions_interface.item_id%TYPE,

113: -- *
114:
115: PROCEDURE JA_AU_GET_CLASS_RATE
116: (x_item_id IN
117: po_requisitions_interface.item_id%TYPE,
118: x_item_uom_class IN
119: mtl_uom_conversions.uom_class%TYPE,
120: x_from_class IN
121: mtl_uom_conversions.uom_class%TYPE,

Line 145: x_from_unit IN po_requisitions_interface.unit_of_measure%TYPE,

141: -- *
142:
143: PROCEDURE JA_AU_REORDER_UOM_CONVERT
144: (x_item_id IN number,
145: x_from_unit IN po_requisitions_interface.unit_of_measure%TYPE,
146: x_to_unit IN po_requisitions_interface.unit_of_measure%TYPE,
147: x_quantity IN OUT NOCOPY po_requisitions_interface.quantity%TYPE,
148: x_unit_price IN OUT NOCOPY po_requisitions_interface.unit_price%TYPE
149: )

Line 146: x_to_unit IN po_requisitions_interface.unit_of_measure%TYPE,

142:
143: PROCEDURE JA_AU_REORDER_UOM_CONVERT
144: (x_item_id IN number,
145: x_from_unit IN po_requisitions_interface.unit_of_measure%TYPE,
146: x_to_unit IN po_requisitions_interface.unit_of_measure%TYPE,
147: x_quantity IN OUT NOCOPY po_requisitions_interface.quantity%TYPE,
148: x_unit_price IN OUT NOCOPY po_requisitions_interface.unit_price%TYPE
149: )
150: IS

Line 147: x_quantity IN OUT NOCOPY po_requisitions_interface.quantity%TYPE,

143: PROCEDURE JA_AU_REORDER_UOM_CONVERT
144: (x_item_id IN number,
145: x_from_unit IN po_requisitions_interface.unit_of_measure%TYPE,
146: x_to_unit IN po_requisitions_interface.unit_of_measure%TYPE,
147: x_quantity IN OUT NOCOPY po_requisitions_interface.quantity%TYPE,
148: x_unit_price IN OUT NOCOPY po_requisitions_interface.unit_price%TYPE
149: )
150: IS
151:

Line 148: x_unit_price IN OUT NOCOPY po_requisitions_interface.unit_price%TYPE

144: (x_item_id IN number,
145: x_from_unit IN po_requisitions_interface.unit_of_measure%TYPE,
146: x_to_unit IN po_requisitions_interface.unit_of_measure%TYPE,
147: x_quantity IN OUT NOCOPY po_requisitions_interface.quantity%TYPE,
148: x_unit_price IN OUT NOCOPY po_requisitions_interface.unit_price%TYPE
149: )
150: IS
151:
152: l_quantity po_requisitions_interface.quantity%TYPE;

Line 152: l_quantity po_requisitions_interface.quantity%TYPE;

148: x_unit_price IN OUT NOCOPY po_requisitions_interface.unit_price%TYPE
149: )
150: IS
151:
152: l_quantity po_requisitions_interface.quantity%TYPE;
153: l_unit_price po_requisitions_interface.unit_price%TYPE;
154: l_from_rate mtl_uom_conversions.conversion_rate%TYPE;
155: l_to_rate mtl_uom_conversions.conversion_rate%TYPE;
156: l_class_rate mtl_uom_class_conversions.conversion_rate%TYPE;

Line 153: l_unit_price po_requisitions_interface.unit_price%TYPE;

149: )
150: IS
151:
152: l_quantity po_requisitions_interface.quantity%TYPE;
153: l_unit_price po_requisitions_interface.unit_price%TYPE;
154: l_from_rate mtl_uom_conversions.conversion_rate%TYPE;
155: l_to_rate mtl_uom_conversions.conversion_rate%TYPE;
156: l_class_rate mtl_uom_class_conversions.conversion_rate%TYPE;
157: l_from_class mtl_uom_conversions.uom_class%TYPE;

Line 316: (x_item_id IN po_requisitions_interface.item_id%TYPE,

312: -- ** Create JA_AU_SUGGESTED_DOCUMENT procedure
313: -- *
314:
315: PROCEDURE JA_AU_SUGGESTED_DOCUMENT
316: (x_item_id IN po_requisitions_interface.item_id%TYPE,
317: x_document_header_id OUT NOCOPY po_requisitions_interface.autosource_doc_header_id%TYPE,
318: x_document_line_num OUT NOCOPY po_requisitions_interface.autosource_doc_line_num%TYPE,
319: x_po_line_id OUT NOCOPY po_lines.po_line_id%TYPE,
320: x_vendor_product_number OUT NOCOPY po_requisitions_interface.suggested_vendor_item_num%TYPE ,

Line 317: x_document_header_id OUT NOCOPY po_requisitions_interface.autosource_doc_header_id%TYPE,

313: -- *
314:
315: PROCEDURE JA_AU_SUGGESTED_DOCUMENT
316: (x_item_id IN po_requisitions_interface.item_id%TYPE,
317: x_document_header_id OUT NOCOPY po_requisitions_interface.autosource_doc_header_id%TYPE,
318: x_document_line_num OUT NOCOPY po_requisitions_interface.autosource_doc_line_num%TYPE,
319: x_po_line_id OUT NOCOPY po_lines.po_line_id%TYPE,
320: x_vendor_product_number OUT NOCOPY po_requisitions_interface.suggested_vendor_item_num%TYPE ,
321: x_vendor_id OUT NOCOPY po_requisitions_interface.suggested_vendor_id%TYPE ,

Line 318: x_document_line_num OUT NOCOPY po_requisitions_interface.autosource_doc_line_num%TYPE,

314:
315: PROCEDURE JA_AU_SUGGESTED_DOCUMENT
316: (x_item_id IN po_requisitions_interface.item_id%TYPE,
317: x_document_header_id OUT NOCOPY po_requisitions_interface.autosource_doc_header_id%TYPE,
318: x_document_line_num OUT NOCOPY po_requisitions_interface.autosource_doc_line_num%TYPE,
319: x_po_line_id OUT NOCOPY po_lines.po_line_id%TYPE,
320: x_vendor_product_number OUT NOCOPY po_requisitions_interface.suggested_vendor_item_num%TYPE ,
321: x_vendor_id OUT NOCOPY po_requisitions_interface.suggested_vendor_id%TYPE ,
322: x_vendor_site_id OUT NOCOPY po_requisitions_interface.suggested_vendor_site_id%TYPE ,

Line 320: x_vendor_product_number OUT NOCOPY po_requisitions_interface.suggested_vendor_item_num%TYPE ,

316: (x_item_id IN po_requisitions_interface.item_id%TYPE,
317: x_document_header_id OUT NOCOPY po_requisitions_interface.autosource_doc_header_id%TYPE,
318: x_document_line_num OUT NOCOPY po_requisitions_interface.autosource_doc_line_num%TYPE,
319: x_po_line_id OUT NOCOPY po_lines.po_line_id%TYPE,
320: x_vendor_product_number OUT NOCOPY po_requisitions_interface.suggested_vendor_item_num%TYPE ,
321: x_vendor_id OUT NOCOPY po_requisitions_interface.suggested_vendor_id%TYPE ,
322: x_vendor_site_id OUT NOCOPY po_requisitions_interface.suggested_vendor_site_id%TYPE ,
323: x_vendor_contact_id OUT NOCOPY po_requisitions_interface.suggested_vendor_contact_id%TYPE ,
324: x_vendor_name OUT NOCOPY po_requisitions_interface.suggested_vendor_name%TYPE ,

Line 321: x_vendor_id OUT NOCOPY po_requisitions_interface.suggested_vendor_id%TYPE ,

317: x_document_header_id OUT NOCOPY po_requisitions_interface.autosource_doc_header_id%TYPE,
318: x_document_line_num OUT NOCOPY po_requisitions_interface.autosource_doc_line_num%TYPE,
319: x_po_line_id OUT NOCOPY po_lines.po_line_id%TYPE,
320: x_vendor_product_number OUT NOCOPY po_requisitions_interface.suggested_vendor_item_num%TYPE ,
321: x_vendor_id OUT NOCOPY po_requisitions_interface.suggested_vendor_id%TYPE ,
322: x_vendor_site_id OUT NOCOPY po_requisitions_interface.suggested_vendor_site_id%TYPE ,
323: x_vendor_contact_id OUT NOCOPY po_requisitions_interface.suggested_vendor_contact_id%TYPE ,
324: x_vendor_name OUT NOCOPY po_requisitions_interface.suggested_vendor_name%TYPE ,
325: x_vendor_site_code OUT NOCOPY po_requisitions_interface.suggested_vendor_site%TYPE ,

Line 322: x_vendor_site_id OUT NOCOPY po_requisitions_interface.suggested_vendor_site_id%TYPE ,

318: x_document_line_num OUT NOCOPY po_requisitions_interface.autosource_doc_line_num%TYPE,
319: x_po_line_id OUT NOCOPY po_lines.po_line_id%TYPE,
320: x_vendor_product_number OUT NOCOPY po_requisitions_interface.suggested_vendor_item_num%TYPE ,
321: x_vendor_id OUT NOCOPY po_requisitions_interface.suggested_vendor_id%TYPE ,
322: x_vendor_site_id OUT NOCOPY po_requisitions_interface.suggested_vendor_site_id%TYPE ,
323: x_vendor_contact_id OUT NOCOPY po_requisitions_interface.suggested_vendor_contact_id%TYPE ,
324: x_vendor_name OUT NOCOPY po_requisitions_interface.suggested_vendor_name%TYPE ,
325: x_vendor_site_code OUT NOCOPY po_requisitions_interface.suggested_vendor_site%TYPE ,
326: x_unit_price OUT NOCOPY po_requisitions_interface.unit_price%TYPE ,

Line 323: x_vendor_contact_id OUT NOCOPY po_requisitions_interface.suggested_vendor_contact_id%TYPE ,

319: x_po_line_id OUT NOCOPY po_lines.po_line_id%TYPE,
320: x_vendor_product_number OUT NOCOPY po_requisitions_interface.suggested_vendor_item_num%TYPE ,
321: x_vendor_id OUT NOCOPY po_requisitions_interface.suggested_vendor_id%TYPE ,
322: x_vendor_site_id OUT NOCOPY po_requisitions_interface.suggested_vendor_site_id%TYPE ,
323: x_vendor_contact_id OUT NOCOPY po_requisitions_interface.suggested_vendor_contact_id%TYPE ,
324: x_vendor_name OUT NOCOPY po_requisitions_interface.suggested_vendor_name%TYPE ,
325: x_vendor_site_code OUT NOCOPY po_requisitions_interface.suggested_vendor_site%TYPE ,
326: x_unit_price OUT NOCOPY po_requisitions_interface.unit_price%TYPE ,
327: x_unit_of_purchase OUT NOCOPY po_lines.unit_meas_lookup_code%TYPE ,

Line 324: x_vendor_name OUT NOCOPY po_requisitions_interface.suggested_vendor_name%TYPE ,

320: x_vendor_product_number OUT NOCOPY po_requisitions_interface.suggested_vendor_item_num%TYPE ,
321: x_vendor_id OUT NOCOPY po_requisitions_interface.suggested_vendor_id%TYPE ,
322: x_vendor_site_id OUT NOCOPY po_requisitions_interface.suggested_vendor_site_id%TYPE ,
323: x_vendor_contact_id OUT NOCOPY po_requisitions_interface.suggested_vendor_contact_id%TYPE ,
324: x_vendor_name OUT NOCOPY po_requisitions_interface.suggested_vendor_name%TYPE ,
325: x_vendor_site_code OUT NOCOPY po_requisitions_interface.suggested_vendor_site%TYPE ,
326: x_unit_price OUT NOCOPY po_requisitions_interface.unit_price%TYPE ,
327: x_unit_of_purchase OUT NOCOPY po_lines.unit_meas_lookup_code%TYPE ,
328: x_suggested_vendor_id IN po_requisitions_interface.suggested_vendor_id%TYPE ,

Line 325: x_vendor_site_code OUT NOCOPY po_requisitions_interface.suggested_vendor_site%TYPE ,

321: x_vendor_id OUT NOCOPY po_requisitions_interface.suggested_vendor_id%TYPE ,
322: x_vendor_site_id OUT NOCOPY po_requisitions_interface.suggested_vendor_site_id%TYPE ,
323: x_vendor_contact_id OUT NOCOPY po_requisitions_interface.suggested_vendor_contact_id%TYPE ,
324: x_vendor_name OUT NOCOPY po_requisitions_interface.suggested_vendor_name%TYPE ,
325: x_vendor_site_code OUT NOCOPY po_requisitions_interface.suggested_vendor_site%TYPE ,
326: x_unit_price OUT NOCOPY po_requisitions_interface.unit_price%TYPE ,
327: x_unit_of_purchase OUT NOCOPY po_lines.unit_meas_lookup_code%TYPE ,
328: x_suggested_vendor_id IN po_requisitions_interface.suggested_vendor_id%TYPE ,
329: x_suggested_vendor_site_id IN po_requisitions_interface.suggested_vendor_site_id%TYPE

Line 326: x_unit_price OUT NOCOPY po_requisitions_interface.unit_price%TYPE ,

322: x_vendor_site_id OUT NOCOPY po_requisitions_interface.suggested_vendor_site_id%TYPE ,
323: x_vendor_contact_id OUT NOCOPY po_requisitions_interface.suggested_vendor_contact_id%TYPE ,
324: x_vendor_name OUT NOCOPY po_requisitions_interface.suggested_vendor_name%TYPE ,
325: x_vendor_site_code OUT NOCOPY po_requisitions_interface.suggested_vendor_site%TYPE ,
326: x_unit_price OUT NOCOPY po_requisitions_interface.unit_price%TYPE ,
327: x_unit_of_purchase OUT NOCOPY po_lines.unit_meas_lookup_code%TYPE ,
328: x_suggested_vendor_id IN po_requisitions_interface.suggested_vendor_id%TYPE ,
329: x_suggested_vendor_site_id IN po_requisitions_interface.suggested_vendor_site_id%TYPE
330: )

Line 328: x_suggested_vendor_id IN po_requisitions_interface.suggested_vendor_id%TYPE ,

324: x_vendor_name OUT NOCOPY po_requisitions_interface.suggested_vendor_name%TYPE ,
325: x_vendor_site_code OUT NOCOPY po_requisitions_interface.suggested_vendor_site%TYPE ,
326: x_unit_price OUT NOCOPY po_requisitions_interface.unit_price%TYPE ,
327: x_unit_of_purchase OUT NOCOPY po_lines.unit_meas_lookup_code%TYPE ,
328: x_suggested_vendor_id IN po_requisitions_interface.suggested_vendor_id%TYPE ,
329: x_suggested_vendor_site_id IN po_requisitions_interface.suggested_vendor_site_id%TYPE
330: )
331: IS
332:

Line 329: x_suggested_vendor_site_id IN po_requisitions_interface.suggested_vendor_site_id%TYPE

325: x_vendor_site_code OUT NOCOPY po_requisitions_interface.suggested_vendor_site%TYPE ,
326: x_unit_price OUT NOCOPY po_requisitions_interface.unit_price%TYPE ,
327: x_unit_of_purchase OUT NOCOPY po_lines.unit_meas_lookup_code%TYPE ,
328: x_suggested_vendor_id IN po_requisitions_interface.suggested_vendor_id%TYPE ,
329: x_suggested_vendor_site_id IN po_requisitions_interface.suggested_vendor_site_id%TYPE
330: )
331: IS
332:
333: CURSOR l_suggested_document IS

Line 521: x_item_id IN po_requisitions_interface.item_id%TYPE,

517: -- *
518:
519: PROCEDURE JA_AU_AUTOSOURCE
520: (
521: x_item_id IN po_requisitions_interface.item_id%TYPE,
522: x_organization_id IN po_requisitions_interface.source_organization_id%TYPE,
523: x_quantity IN OUT NOCOPY po_requisitions_interface.quantity%TYPE,
524: x_uom_code IN OUT NOCOPY po_requisitions_interface.uom_code%TYPE,
525: x_unit_of_measure IN OUT NOCOPY po_requisitions_interface.unit_of_measure%TYPE,

Line 522: x_organization_id IN po_requisitions_interface.source_organization_id%TYPE,

518:
519: PROCEDURE JA_AU_AUTOSOURCE
520: (
521: x_item_id IN po_requisitions_interface.item_id%TYPE,
522: x_organization_id IN po_requisitions_interface.source_organization_id%TYPE,
523: x_quantity IN OUT NOCOPY po_requisitions_interface.quantity%TYPE,
524: x_uom_code IN OUT NOCOPY po_requisitions_interface.uom_code%TYPE,
525: x_unit_of_measure IN OUT NOCOPY po_requisitions_interface.unit_of_measure%TYPE,
526: x_rowid IN po_requisitions_interface.unit_of_measure%TYPE,

Line 523: x_quantity IN OUT NOCOPY po_requisitions_interface.quantity%TYPE,

519: PROCEDURE JA_AU_AUTOSOURCE
520: (
521: x_item_id IN po_requisitions_interface.item_id%TYPE,
522: x_organization_id IN po_requisitions_interface.source_organization_id%TYPE,
523: x_quantity IN OUT NOCOPY po_requisitions_interface.quantity%TYPE,
524: x_uom_code IN OUT NOCOPY po_requisitions_interface.uom_code%TYPE,
525: x_unit_of_measure IN OUT NOCOPY po_requisitions_interface.unit_of_measure%TYPE,
526: x_rowid IN po_requisitions_interface.unit_of_measure%TYPE,
527: x_autosource_doc_header_id IN po_requisitions_interface.autosource_doc_header_id%TYPE,

Line 524: x_uom_code IN OUT NOCOPY po_requisitions_interface.uom_code%TYPE,

520: (
521: x_item_id IN po_requisitions_interface.item_id%TYPE,
522: x_organization_id IN po_requisitions_interface.source_organization_id%TYPE,
523: x_quantity IN OUT NOCOPY po_requisitions_interface.quantity%TYPE,
524: x_uom_code IN OUT NOCOPY po_requisitions_interface.uom_code%TYPE,
525: x_unit_of_measure IN OUT NOCOPY po_requisitions_interface.unit_of_measure%TYPE,
526: x_rowid IN po_requisitions_interface.unit_of_measure%TYPE,
527: x_autosource_doc_header_id IN po_requisitions_interface.autosource_doc_header_id%TYPE,
528: x_autosource_doc_line_num IN po_requisitions_interface.autosource_doc_line_num%TYPE,

Line 525: x_unit_of_measure IN OUT NOCOPY po_requisitions_interface.unit_of_measure%TYPE,

521: x_item_id IN po_requisitions_interface.item_id%TYPE,
522: x_organization_id IN po_requisitions_interface.source_organization_id%TYPE,
523: x_quantity IN OUT NOCOPY po_requisitions_interface.quantity%TYPE,
524: x_uom_code IN OUT NOCOPY po_requisitions_interface.uom_code%TYPE,
525: x_unit_of_measure IN OUT NOCOPY po_requisitions_interface.unit_of_measure%TYPE,
526: x_rowid IN po_requisitions_interface.unit_of_measure%TYPE,
527: x_autosource_doc_header_id IN po_requisitions_interface.autosource_doc_header_id%TYPE,
528: x_autosource_doc_line_num IN po_requisitions_interface.autosource_doc_line_num%TYPE,
529: x_suggested_vendor_id IN po_requisitions_interface.suggested_vendor_id%TYPE,

Line 526: x_rowid IN po_requisitions_interface.unit_of_measure%TYPE,

522: x_organization_id IN po_requisitions_interface.source_organization_id%TYPE,
523: x_quantity IN OUT NOCOPY po_requisitions_interface.quantity%TYPE,
524: x_uom_code IN OUT NOCOPY po_requisitions_interface.uom_code%TYPE,
525: x_unit_of_measure IN OUT NOCOPY po_requisitions_interface.unit_of_measure%TYPE,
526: x_rowid IN po_requisitions_interface.unit_of_measure%TYPE,
527: x_autosource_doc_header_id IN po_requisitions_interface.autosource_doc_header_id%TYPE,
528: x_autosource_doc_line_num IN po_requisitions_interface.autosource_doc_line_num%TYPE,
529: x_suggested_vendor_id IN po_requisitions_interface.suggested_vendor_id%TYPE,
530: x_suggested_vendor_site_id IN po_requisitions_interface.suggested_vendor_site_id%TYPE

Line 527: x_autosource_doc_header_id IN po_requisitions_interface.autosource_doc_header_id%TYPE,

523: x_quantity IN OUT NOCOPY po_requisitions_interface.quantity%TYPE,
524: x_uom_code IN OUT NOCOPY po_requisitions_interface.uom_code%TYPE,
525: x_unit_of_measure IN OUT NOCOPY po_requisitions_interface.unit_of_measure%TYPE,
526: x_rowid IN po_requisitions_interface.unit_of_measure%TYPE,
527: x_autosource_doc_header_id IN po_requisitions_interface.autosource_doc_header_id%TYPE,
528: x_autosource_doc_line_num IN po_requisitions_interface.autosource_doc_line_num%TYPE,
529: x_suggested_vendor_id IN po_requisitions_interface.suggested_vendor_id%TYPE,
530: x_suggested_vendor_site_id IN po_requisitions_interface.suggested_vendor_site_id%TYPE
531: )

Line 528: x_autosource_doc_line_num IN po_requisitions_interface.autosource_doc_line_num%TYPE,

524: x_uom_code IN OUT NOCOPY po_requisitions_interface.uom_code%TYPE,
525: x_unit_of_measure IN OUT NOCOPY po_requisitions_interface.unit_of_measure%TYPE,
526: x_rowid IN po_requisitions_interface.unit_of_measure%TYPE,
527: x_autosource_doc_header_id IN po_requisitions_interface.autosource_doc_header_id%TYPE,
528: x_autosource_doc_line_num IN po_requisitions_interface.autosource_doc_line_num%TYPE,
529: x_suggested_vendor_id IN po_requisitions_interface.suggested_vendor_id%TYPE,
530: x_suggested_vendor_site_id IN po_requisitions_interface.suggested_vendor_site_id%TYPE
531: )
532: IS

Line 529: x_suggested_vendor_id IN po_requisitions_interface.suggested_vendor_id%TYPE,

525: x_unit_of_measure IN OUT NOCOPY po_requisitions_interface.unit_of_measure%TYPE,
526: x_rowid IN po_requisitions_interface.unit_of_measure%TYPE,
527: x_autosource_doc_header_id IN po_requisitions_interface.autosource_doc_header_id%TYPE,
528: x_autosource_doc_line_num IN po_requisitions_interface.autosource_doc_line_num%TYPE,
529: x_suggested_vendor_id IN po_requisitions_interface.suggested_vendor_id%TYPE,
530: x_suggested_vendor_site_id IN po_requisitions_interface.suggested_vendor_site_id%TYPE
531: )
532: IS
533: l_document_header_id po_requisitions_interface.autosource_doc_header_id%TYPE;

Line 530: x_suggested_vendor_site_id IN po_requisitions_interface.suggested_vendor_site_id%TYPE

526: x_rowid IN po_requisitions_interface.unit_of_measure%TYPE,
527: x_autosource_doc_header_id IN po_requisitions_interface.autosource_doc_header_id%TYPE,
528: x_autosource_doc_line_num IN po_requisitions_interface.autosource_doc_line_num%TYPE,
529: x_suggested_vendor_id IN po_requisitions_interface.suggested_vendor_id%TYPE,
530: x_suggested_vendor_site_id IN po_requisitions_interface.suggested_vendor_site_id%TYPE
531: )
532: IS
533: l_document_header_id po_requisitions_interface.autosource_doc_header_id%TYPE;
534: l_document_line_num po_requisitions_interface.autosource_doc_line_num%TYPE;

Line 533: l_document_header_id po_requisitions_interface.autosource_doc_header_id%TYPE;

529: x_suggested_vendor_id IN po_requisitions_interface.suggested_vendor_id%TYPE,
530: x_suggested_vendor_site_id IN po_requisitions_interface.suggested_vendor_site_id%TYPE
531: )
532: IS
533: l_document_header_id po_requisitions_interface.autosource_doc_header_id%TYPE;
534: l_document_line_num po_requisitions_interface.autosource_doc_line_num%TYPE;
535: l_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE ;
536: l_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE ;
537: l_vendor_contact_id po_requisitions_interface.suggested_vendor_contact_id%TYPE ;

Line 534: l_document_line_num po_requisitions_interface.autosource_doc_line_num%TYPE;

530: x_suggested_vendor_site_id IN po_requisitions_interface.suggested_vendor_site_id%TYPE
531: )
532: IS
533: l_document_header_id po_requisitions_interface.autosource_doc_header_id%TYPE;
534: l_document_line_num po_requisitions_interface.autosource_doc_line_num%TYPE;
535: l_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE ;
536: l_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE ;
537: l_vendor_contact_id po_requisitions_interface.suggested_vendor_contact_id%TYPE ;
538: l_vendor_product_number po_requisitions_interface.suggested_vendor_item_num%TYPE ;

Line 535: l_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE ;

531: )
532: IS
533: l_document_header_id po_requisitions_interface.autosource_doc_header_id%TYPE;
534: l_document_line_num po_requisitions_interface.autosource_doc_line_num%TYPE;
535: l_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE ;
536: l_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE ;
537: l_vendor_contact_id po_requisitions_interface.suggested_vendor_contact_id%TYPE ;
538: l_vendor_product_number po_requisitions_interface.suggested_vendor_item_num%TYPE ;
539: l_unit_of_purchase po_requisitions_interface.unit_of_measure%TYPE ;

Line 536: l_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE ;

532: IS
533: l_document_header_id po_requisitions_interface.autosource_doc_header_id%TYPE;
534: l_document_line_num po_requisitions_interface.autosource_doc_line_num%TYPE;
535: l_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE ;
536: l_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE ;
537: l_vendor_contact_id po_requisitions_interface.suggested_vendor_contact_id%TYPE ;
538: l_vendor_product_number po_requisitions_interface.suggested_vendor_item_num%TYPE ;
539: l_unit_of_purchase po_requisitions_interface.unit_of_measure%TYPE ;
540: l_unit_of_measure po_requisitions_interface.unit_of_measure%TYPE ;

Line 537: l_vendor_contact_id po_requisitions_interface.suggested_vendor_contact_id%TYPE ;

533: l_document_header_id po_requisitions_interface.autosource_doc_header_id%TYPE;
534: l_document_line_num po_requisitions_interface.autosource_doc_line_num%TYPE;
535: l_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE ;
536: l_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE ;
537: l_vendor_contact_id po_requisitions_interface.suggested_vendor_contact_id%TYPE ;
538: l_vendor_product_number po_requisitions_interface.suggested_vendor_item_num%TYPE ;
539: l_unit_of_purchase po_requisitions_interface.unit_of_measure%TYPE ;
540: l_unit_of_measure po_requisitions_interface.unit_of_measure%TYPE ;
541: l_uom_code po_requisitions_interface.uom_code%TYPE ;

Line 538: l_vendor_product_number po_requisitions_interface.suggested_vendor_item_num%TYPE ;

534: l_document_line_num po_requisitions_interface.autosource_doc_line_num%TYPE;
535: l_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE ;
536: l_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE ;
537: l_vendor_contact_id po_requisitions_interface.suggested_vendor_contact_id%TYPE ;
538: l_vendor_product_number po_requisitions_interface.suggested_vendor_item_num%TYPE ;
539: l_unit_of_purchase po_requisitions_interface.unit_of_measure%TYPE ;
540: l_unit_of_measure po_requisitions_interface.unit_of_measure%TYPE ;
541: l_uom_code po_requisitions_interface.uom_code%TYPE ;
542: l_unit_price po_requisitions_interface.unit_price%TYPE ;

Line 539: l_unit_of_purchase po_requisitions_interface.unit_of_measure%TYPE ;

535: l_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE ;
536: l_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE ;
537: l_vendor_contact_id po_requisitions_interface.suggested_vendor_contact_id%TYPE ;
538: l_vendor_product_number po_requisitions_interface.suggested_vendor_item_num%TYPE ;
539: l_unit_of_purchase po_requisitions_interface.unit_of_measure%TYPE ;
540: l_unit_of_measure po_requisitions_interface.unit_of_measure%TYPE ;
541: l_uom_code po_requisitions_interface.uom_code%TYPE ;
542: l_unit_price po_requisitions_interface.unit_price%TYPE ;
543: l_quote_line_price po_requisitions_interface.unit_price%TYPE ;

Line 540: l_unit_of_measure po_requisitions_interface.unit_of_measure%TYPE ;

536: l_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE ;
537: l_vendor_contact_id po_requisitions_interface.suggested_vendor_contact_id%TYPE ;
538: l_vendor_product_number po_requisitions_interface.suggested_vendor_item_num%TYPE ;
539: l_unit_of_purchase po_requisitions_interface.unit_of_measure%TYPE ;
540: l_unit_of_measure po_requisitions_interface.unit_of_measure%TYPE ;
541: l_uom_code po_requisitions_interface.uom_code%TYPE ;
542: l_unit_price po_requisitions_interface.unit_price%TYPE ;
543: l_quote_line_price po_requisitions_interface.unit_price%TYPE ;
544: l_vendor_name po_requisitions_interface.suggested_vendor_name%TYPE ;

Line 541: l_uom_code po_requisitions_interface.uom_code%TYPE ;

537: l_vendor_contact_id po_requisitions_interface.suggested_vendor_contact_id%TYPE ;
538: l_vendor_product_number po_requisitions_interface.suggested_vendor_item_num%TYPE ;
539: l_unit_of_purchase po_requisitions_interface.unit_of_measure%TYPE ;
540: l_unit_of_measure po_requisitions_interface.unit_of_measure%TYPE ;
541: l_uom_code po_requisitions_interface.uom_code%TYPE ;
542: l_unit_price po_requisitions_interface.unit_price%TYPE ;
543: l_quote_line_price po_requisitions_interface.unit_price%TYPE ;
544: l_vendor_name po_requisitions_interface.suggested_vendor_name%TYPE ;
545: l_vendor_site_code po_requisitions_interface.suggested_vendor_site%TYPE ;

Line 542: l_unit_price po_requisitions_interface.unit_price%TYPE ;

538: l_vendor_product_number po_requisitions_interface.suggested_vendor_item_num%TYPE ;
539: l_unit_of_purchase po_requisitions_interface.unit_of_measure%TYPE ;
540: l_unit_of_measure po_requisitions_interface.unit_of_measure%TYPE ;
541: l_uom_code po_requisitions_interface.uom_code%TYPE ;
542: l_unit_price po_requisitions_interface.unit_price%TYPE ;
543: l_quote_line_price po_requisitions_interface.unit_price%TYPE ;
544: l_vendor_name po_requisitions_interface.suggested_vendor_name%TYPE ;
545: l_vendor_site_code po_requisitions_interface.suggested_vendor_site%TYPE ;
546: l_po_line_id po_lines.po_line_id%TYPE;

Line 543: l_quote_line_price po_requisitions_interface.unit_price%TYPE ;

539: l_unit_of_purchase po_requisitions_interface.unit_of_measure%TYPE ;
540: l_unit_of_measure po_requisitions_interface.unit_of_measure%TYPE ;
541: l_uom_code po_requisitions_interface.uom_code%TYPE ;
542: l_unit_price po_requisitions_interface.unit_price%TYPE ;
543: l_quote_line_price po_requisitions_interface.unit_price%TYPE ;
544: l_vendor_name po_requisitions_interface.suggested_vendor_name%TYPE ;
545: l_vendor_site_code po_requisitions_interface.suggested_vendor_site%TYPE ;
546: l_po_line_id po_lines.po_line_id%TYPE;
547: l_dummy char(1);

Line 544: l_vendor_name po_requisitions_interface.suggested_vendor_name%TYPE ;

540: l_unit_of_measure po_requisitions_interface.unit_of_measure%TYPE ;
541: l_uom_code po_requisitions_interface.uom_code%TYPE ;
542: l_unit_price po_requisitions_interface.unit_price%TYPE ;
543: l_quote_line_price po_requisitions_interface.unit_price%TYPE ;
544: l_vendor_name po_requisitions_interface.suggested_vendor_name%TYPE ;
545: l_vendor_site_code po_requisitions_interface.suggested_vendor_site%TYPE ;
546: l_po_line_id po_lines.po_line_id%TYPE;
547: l_dummy char(1);
548: l_dummy2 po_requisitions_interface.unit_price%TYPE ;

Line 545: l_vendor_site_code po_requisitions_interface.suggested_vendor_site%TYPE ;

541: l_uom_code po_requisitions_interface.uom_code%TYPE ;
542: l_unit_price po_requisitions_interface.unit_price%TYPE ;
543: l_quote_line_price po_requisitions_interface.unit_price%TYPE ;
544: l_vendor_name po_requisitions_interface.suggested_vendor_name%TYPE ;
545: l_vendor_site_code po_requisitions_interface.suggested_vendor_site%TYPE ;
546: l_po_line_id po_lines.po_line_id%TYPE;
547: l_dummy char(1);
548: l_dummy2 po_requisitions_interface.unit_price%TYPE ;
549: l_uom_direct varchar2(30);

Line 548: l_dummy2 po_requisitions_interface.unit_price%TYPE ;

544: l_vendor_name po_requisitions_interface.suggested_vendor_name%TYPE ;
545: l_vendor_site_code po_requisitions_interface.suggested_vendor_site%TYPE ;
546: l_po_line_id po_lines.po_line_id%TYPE;
547: l_dummy char(1);
548: l_dummy2 po_requisitions_interface.unit_price%TYPE ;
549: l_uom_direct varchar2(30);
550:
551: BEGIN
552:

Line 635: UPDATE po_requisitions_interface

631: FROM mtl_system_items
632: WHERE inventory_item_id = x_item_id
633: AND organization_id = x_organization_id ;
634:
635: UPDATE po_requisitions_interface
636: SET unit_price = l_unit_price
637: WHERE rowid = x_rowid ;
638:
639: COMMIT WORK ;

Line 662: UPDATE po_requisitions_interface

658: END IF;
659:
660: -- Bug 3032472
661: IF g_count <> 0 THEN
662: UPDATE po_requisitions_interface
663: SET quantity = x_quantity
664: -- uom_code = l_uom_code,
665: -- unit_of_measure = l_unit_of_purchase
666: WHERE rowid = x_rowid;

Line 668: UPDATE po_requisitions_interface

664: -- uom_code = l_uom_code,
665: -- unit_of_measure = l_unit_of_purchase
666: WHERE rowid = x_rowid;
667: ELSE
668: UPDATE po_requisitions_interface
669: SET unit_of_measure = l_unit_of_purchase,
670: uom_code = l_uom_code,
671: unit_price = l_unit_price,
672: quantity = x_quantity,

Line 702: po_requisitions_interface.item_id%TYPE,

698: -- *
699:
700: PROCEDURE JA_AU_UOI_CONVERSION
701: (x_item_id IN
702: po_requisitions_interface.item_id%TYPE,
703: x_source_organization_id IN
704: po_requisitions_interface.source_organization_id%TYPE,
705: x_quantity IN
706: po_requisitions_interface.quantity%TYPE,

Line 704: po_requisitions_interface.source_organization_id%TYPE,

700: PROCEDURE JA_AU_UOI_CONVERSION
701: (x_item_id IN
702: po_requisitions_interface.item_id%TYPE,
703: x_source_organization_id IN
704: po_requisitions_interface.source_organization_id%TYPE,
705: x_quantity IN
706: po_requisitions_interface.quantity%TYPE,
707: x_unit_price IN
708: po_requisitions_interface.unit_price%TYPE,

Line 706: po_requisitions_interface.quantity%TYPE,

702: po_requisitions_interface.item_id%TYPE,
703: x_source_organization_id IN
704: po_requisitions_interface.source_organization_id%TYPE,
705: x_quantity IN
706: po_requisitions_interface.quantity%TYPE,
707: x_unit_price IN
708: po_requisitions_interface.unit_price%TYPE,
709: x_unit_of_measure IN
710: po_requisitions_interface.unit_of_measure%TYPE,

Line 708: po_requisitions_interface.unit_price%TYPE,

704: po_requisitions_interface.source_organization_id%TYPE,
705: x_quantity IN
706: po_requisitions_interface.quantity%TYPE,
707: x_unit_price IN
708: po_requisitions_interface.unit_price%TYPE,
709: x_unit_of_measure IN
710: po_requisitions_interface.unit_of_measure%TYPE,
711: x_rowid IN
712: po_requisitions_interface.unit_of_measure%TYPE

Line 710: po_requisitions_interface.unit_of_measure%TYPE,

706: po_requisitions_interface.quantity%TYPE,
707: x_unit_price IN
708: po_requisitions_interface.unit_price%TYPE,
709: x_unit_of_measure IN
710: po_requisitions_interface.unit_of_measure%TYPE,
711: x_rowid IN
712: po_requisitions_interface.unit_of_measure%TYPE
713: )
714: IS

Line 712: po_requisitions_interface.unit_of_measure%TYPE

708: po_requisitions_interface.unit_price%TYPE,
709: x_unit_of_measure IN
710: po_requisitions_interface.unit_of_measure%TYPE,
711: x_rowid IN
712: po_requisitions_interface.unit_of_measure%TYPE
713: )
714: IS
715:
716: l_quantity

Line 717: po_requisitions_interface.quantity%TYPE;

713: )
714: IS
715:
716: l_quantity
717: po_requisitions_interface.quantity%TYPE;
718: l_unit_price
719: po_requisitions_interface.unit_price%TYPE;
720: l_unit_of_issue
721: po_requisitions_interface.unit_of_measure%TYPE;

Line 719: po_requisitions_interface.unit_price%TYPE;

715:
716: l_quantity
717: po_requisitions_interface.quantity%TYPE;
718: l_unit_price
719: po_requisitions_interface.unit_price%TYPE;
720: l_unit_of_issue
721: po_requisitions_interface.unit_of_measure%TYPE;
722: l_uoi_code
723: po_requisitions_interface.uom_code%TYPE;

Line 721: po_requisitions_interface.unit_of_measure%TYPE;

717: po_requisitions_interface.quantity%TYPE;
718: l_unit_price
719: po_requisitions_interface.unit_price%TYPE;
720: l_unit_of_issue
721: po_requisitions_interface.unit_of_measure%TYPE;
722: l_uoi_code
723: po_requisitions_interface.uom_code%TYPE;
724:
725: BEGIN

Line 723: po_requisitions_interface.uom_code%TYPE;

719: po_requisitions_interface.unit_price%TYPE;
720: l_unit_of_issue
721: po_requisitions_interface.unit_of_measure%TYPE;
722: l_uoi_code
723: po_requisitions_interface.uom_code%TYPE;
724:
725: BEGIN
726:
727: SELECT nvl(unit_of_issue,primary_unit_of_measure)

Line 752: UPDATE po_requisitions_interface

748: INTO l_uoi_code
749: FROM mtl_units_of_measure
750: WHERE unit_of_measure = l_unit_of_issue ;
751:
752: UPDATE po_requisitions_interface
753: SET unit_of_measure = l_unit_of_issue,
754: uom_code = l_uoi_code,
755: quantity = l_quantity,
756: unit_price = l_unit_price

Line 778: po_requisitions_interface.transaction_id%TYPE)

774: PROCEDURE JA_AU_UPDATE_ERRORS
775: (x_rowid IN
776: varchar2,
777: x_transaction_id IN
778: po_requisitions_interface.transaction_id%TYPE)
779: IS
780: BEGIN
781:
782: UPDATE po_requisitions_interface

Line 782: UPDATE po_requisitions_interface

778: po_requisitions_interface.transaction_id%TYPE)
779: IS
780: BEGIN
781:
782: UPDATE po_requisitions_interface
783: SET charge_account_id = 0,
784: request_id = NULL,
785: process_flag = 'ERROR'
786: WHERE rowid = x_rowid;

Line 841: po_requisitions_interface.transaction_id%TYPE,

837: PROCEDURE JA_AU_GET_COA_SOB
838: (x_rowid IN
839: varchar2,
840: x_transaction_id IN
841: po_requisitions_interface.transaction_id%TYPE,
842: x_org_id IN
843: org_organization_definitions.organization_id%TYPE,
844: x_chart_of_accts_id OUT NOCOPY
845: org_organization_definitions.chart_of_accounts_id%TYPE,

Line 881: po_requisitions_interface.transaction_id%TYPE,

877: PROCEDURE JA_AU_GET_REPLN_EXP_ACCTS
878: (x_rowid IN
879: varchar2,
880: x_transaction_id IN
881: po_requisitions_interface.transaction_id%TYPE,
882: x_org_id IN
883: org_organization_definitions.organization_id%TYPE,
884: x_subinv IN
885: mtl_secondary_inventories.secondary_inventory_name%TYPE,

Line 949: po_requisitions_interface.transaction_id%TYPE,

945: FUNCTION JA_AU_GET_VALUE
946: (x_rowid IN
947: varchar2,
948: x_transaction_id IN
949: po_requisitions_interface.transaction_id%TYPE,
950: x_ccid IN
951: gl_code_combinations.code_combination_id%TYPE,
952: x_segment IN
953: gl_code_combinations.segment1%TYPE)

Line 1149: po_requisitions_interface.transaction_id%TYPE,

1145: FUNCTION JA_AU_GET_SEGMENT_VALUE
1146: (x_rowid IN
1147: varchar2,
1148: x_transaction_id IN
1149: po_requisitions_interface.transaction_id%TYPE,
1150: x_table_name IN
1151: JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE,
1152: x_constant IN
1153: JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE,

Line 1212: po_requisitions_interface.transaction_id%TYPE,

1208: PROCEDURE JA_AU_UPDATE_REQINTERFACE
1209: (x_rowid IN
1210: varchar2,
1211: x_transaction_id IN
1212: po_requisitions_interface.transaction_id%TYPE,
1213: x_ccid IN
1214: gl_code_combinations.code_combination_id%TYPE)
1215: IS
1216: BEGIN

Line 1218: UPDATE po_requisitions_interface

1214: gl_code_combinations.code_combination_id%TYPE)
1215: IS
1216: BEGIN
1217:
1218: UPDATE po_requisitions_interface
1219: SET charge_account_id = x_ccid
1220: WHERE rowid = x_rowid;
1221:
1222: IF SQL%NOTFOUND THEN

Line 1231: -- DBMS_OUTPUT.PUT('* Failed to update PO_REQUISITIONS_INTERFACE *');

1227:
1228: EXCEPTION
1229: WHEN l_no_rows_updated THEN
1230: -- DBMS_OUTPUT.NEW_LINE;
1231: -- DBMS_OUTPUT.PUT('*** Failed to update PO_REQUISITIONS_INTERFACE ***');
1232: -- DBMS_OUTPUT.NEW_LINE;
1233: -- DBMS_OUTPUT.PUT(SQLERRM);
1234: -- DBMS_OUTPUT.NEW_LINE;
1235: l_error_msg := 'AUTOGL ERROR - Update of charge_account_id in po_requisitions_interface failed.';

Line 1235: l_error_msg := 'AUTOGL ERROR - Update of charge_account_id in po_requisitions_interface failed.';

1231: -- DBMS_OUTPUT.PUT('*** Failed to update PO_REQUISITIONS_INTERFACE ***');
1232: -- DBMS_OUTPUT.NEW_LINE;
1233: -- DBMS_OUTPUT.PUT(SQLERRM);
1234: -- DBMS_OUTPUT.NEW_LINE;
1235: l_error_msg := 'AUTOGL ERROR - Update of charge_account_id in po_requisitions_interface failed.';
1236: JA_AU_update_errors(x_rowid,x_transaction_id);
1237: WHEN OTHERS THEN
1238: -- DBMS_OUTPUT.NEW_LINE;
1239: -- DBMS_OUTPUT.PUT('*** ERROR in JA_AU_UPDATE_REQINTERFACE ***');

Line 1255: -- | PO_REQUISITIONS_INTERFACE.

1251: -- +=======================================================================+
1252: -- | This procedure will obtain the code_combination_id from the table
1253: -- | GL_CODE_COMBINATIONS for the given item and subinventory. It will store
1254: -- | the code_combination_id in the charge_account_id column of the table
1255: -- | PO_REQUISITIONS_INTERFACE.
1256: -- | Any errors will be flagged by inserting a record in PO_INTERFACE_ERRORS
1257: -- | Possible errors are :
1258: -- | AUTOGL ERROR - Could not retrieve chart_of_accounts_id and/or
1259: -- | set_of_books_id.

Line 1268: -- | AUTOGL ERROR - Update of charge_account_id in po_requisitions_interface

1264: -- | AUTOGL ERROR - Incorrect AutoAccounting setup - Invalid Table.
1265: -- | AUTOGL ERROR - Segment value in GL_CODE_COMBINATIONS is null.
1266: -- | AUTOGL ERROR - Incorrect AutoAccounting setup - Invalid Segment
1267: -- | AUTOGL ERROR - Could not retrieve segment value from GL_CODE_COMBINATIONS.
1268: -- | AUTOGL ERROR - Update of charge_account_id in po_requisitions_interface
1269: -- | failed.
1270: -- | AUTOGL ERROR - Could not obtain or create CODE_COMBINATION_ID
1271: -- +=======================================================================+
1272:

Line 1277: po_requisitions_interface.destination_organization_id%TYPE,

1273: PROCEDURE JA_AU_AUTOACCOUNTING
1274: (x_rowid IN
1275: varchar2,
1276: x_org_id IN
1277: po_requisitions_interface.destination_organization_id%TYPE,
1278: x_subinv IN
1279: po_requisitions_interface.destination_subinventory%TYPE,
1280: x_item_id IN
1281: po_requisitions_interface.item_id%TYPE,

Line 1279: po_requisitions_interface.destination_subinventory%TYPE,

1275: varchar2,
1276: x_org_id IN
1277: po_requisitions_interface.destination_organization_id%TYPE,
1278: x_subinv IN
1279: po_requisitions_interface.destination_subinventory%TYPE,
1280: x_item_id IN
1281: po_requisitions_interface.item_id%TYPE,
1282: l_transaction_id IN
1283: po_requisitions_interface.transaction_id%TYPE)

Line 1281: po_requisitions_interface.item_id%TYPE,

1277: po_requisitions_interface.destination_organization_id%TYPE,
1278: x_subinv IN
1279: po_requisitions_interface.destination_subinventory%TYPE,
1280: x_item_id IN
1281: po_requisitions_interface.item_id%TYPE,
1282: l_transaction_id IN
1283: po_requisitions_interface.transaction_id%TYPE)
1284:
1285: IS

Line 1283: po_requisitions_interface.transaction_id%TYPE)

1279: po_requisitions_interface.destination_subinventory%TYPE,
1280: x_item_id IN
1281: po_requisitions_interface.item_id%TYPE,
1282: l_transaction_id IN
1283: po_requisitions_interface.transaction_id%TYPE)
1284:
1285: IS
1286:
1287: l_chart_of_accts_id org_organization_definitions.organization_id%TYPE;

Line 1440: -- | all the logic that accesses the PO_REQUISITIONS_INTERFACE table

1436: -- + ============================================================================+
1437: -- | NAME: POST_VALIDATE_USER_EXTENSIONS
1438: -- | DESC: Top level procedure that you can use to add logic to ReqImport to
1439: -- | implement any extra functionality that you need. Make sure that
1440: -- | all the logic that accesses the PO_REQUISITIONS_INTERFACE table
1441: -- | restricts by the X_REQUEST_ID parameter.
1442: -- | ARGS: request_id
1443: -- | ALGR: None
1444: -- +=============================================================================+

Line 1476: FROM po_requisitions_interface pri

1472: ,pri.autosource_doc_header_id
1473: ,pri.autosource_doc_line_num
1474: ,pri.suggested_vendor_id
1475: ,pri.suggested_vendor_site_id
1476: FROM po_requisitions_interface pri
1477: WHERE request_id = x_request_id ;
1478:
1479:
1480: l_source_type_code

Line 1481: po_requisitions_interface.source_type_code%TYPE;

1477: WHERE request_id = x_request_id ;
1478:
1479:
1480: l_source_type_code
1481: po_requisitions_interface.source_type_code%TYPE;
1482: l_requisition_header_id
1483: po_requisitions_interface.requisition_header_id%TYPE;
1484: l_requisition_line_id
1485: po_requisitions_interface.requisition_line_id%TYPE;

Line 1483: po_requisitions_interface.requisition_header_id%TYPE;

1479:
1480: l_source_type_code
1481: po_requisitions_interface.source_type_code%TYPE;
1482: l_requisition_header_id
1483: po_requisitions_interface.requisition_header_id%TYPE;
1484: l_requisition_line_id
1485: po_requisitions_interface.requisition_line_id%TYPE;
1486: l_req_distribution_id
1487: po_requisitions_interface.req_distribution_id%TYPE;

Line 1485: po_requisitions_interface.requisition_line_id%TYPE;

1481: po_requisitions_interface.source_type_code%TYPE;
1482: l_requisition_header_id
1483: po_requisitions_interface.requisition_header_id%TYPE;
1484: l_requisition_line_id
1485: po_requisitions_interface.requisition_line_id%TYPE;
1486: l_req_distribution_id
1487: po_requisitions_interface.req_distribution_id%TYPE;
1488: l_requisition_type
1489: po_requisitions_interface.requisition_type%TYPE;

Line 1487: po_requisitions_interface.req_distribution_id%TYPE;

1483: po_requisitions_interface.requisition_header_id%TYPE;
1484: l_requisition_line_id
1485: po_requisitions_interface.requisition_line_id%TYPE;
1486: l_req_distribution_id
1487: po_requisitions_interface.req_distribution_id%TYPE;
1488: l_requisition_type
1489: po_requisitions_interface.requisition_type%TYPE;
1490: l_unit_price
1491: po_requisitions_interface.unit_price%TYPE;

Line 1489: po_requisitions_interface.requisition_type%TYPE;

1485: po_requisitions_interface.requisition_line_id%TYPE;
1486: l_req_distribution_id
1487: po_requisitions_interface.req_distribution_id%TYPE;
1488: l_requisition_type
1489: po_requisitions_interface.requisition_type%TYPE;
1490: l_unit_price
1491: po_requisitions_interface.unit_price%TYPE;
1492: --Bug 3032472 : Move it to global variable
1493: --l_autosource_flag

Line 1491: po_requisitions_interface.unit_price%TYPE;

1487: po_requisitions_interface.req_distribution_id%TYPE;
1488: l_requisition_type
1489: po_requisitions_interface.requisition_type%TYPE;
1490: l_unit_price
1491: po_requisitions_interface.unit_price%TYPE;
1492: --Bug 3032472 : Move it to global variable
1493: --l_autosource_flag
1494: -- po_requisitions_interface.autosource_flag%TYPE;
1495: l_item_id

Line 1494: -- po_requisitions_interface.autosource_flag%TYPE;

1490: l_unit_price
1491: po_requisitions_interface.unit_price%TYPE;
1492: --Bug 3032472 : Move it to global variable
1493: --l_autosource_flag
1494: -- po_requisitions_interface.autosource_flag%TYPE;
1495: l_item_id
1496: po_requisitions_interface.item_id%TYPE;
1497: l_charge_account_id
1498: po_requisitions_interface.charge_account_id%TYPE;

Line 1496: po_requisitions_interface.item_id%TYPE;

1492: --Bug 3032472 : Move it to global variable
1493: --l_autosource_flag
1494: -- po_requisitions_interface.autosource_flag%TYPE;
1495: l_item_id
1496: po_requisitions_interface.item_id%TYPE;
1497: l_charge_account_id
1498: po_requisitions_interface.charge_account_id%TYPE;
1499: l_unit_of_measure
1500: po_requisitions_interface.unit_of_measure%TYPE;

Line 1498: po_requisitions_interface.charge_account_id%TYPE;

1494: -- po_requisitions_interface.autosource_flag%TYPE;
1495: l_item_id
1496: po_requisitions_interface.item_id%TYPE;
1497: l_charge_account_id
1498: po_requisitions_interface.charge_account_id%TYPE;
1499: l_unit_of_measure
1500: po_requisitions_interface.unit_of_measure%TYPE;
1501: l_uom_code
1502: po_requisitions_interface.uom_code%TYPE;

Line 1500: po_requisitions_interface.unit_of_measure%TYPE;

1496: po_requisitions_interface.item_id%TYPE;
1497: l_charge_account_id
1498: po_requisitions_interface.charge_account_id%TYPE;
1499: l_unit_of_measure
1500: po_requisitions_interface.unit_of_measure%TYPE;
1501: l_uom_code
1502: po_requisitions_interface.uom_code%TYPE;
1503: l_source_organization_id
1504: po_requisitions_interface.source_organization_id%TYPE;

Line 1502: po_requisitions_interface.uom_code%TYPE;

1498: po_requisitions_interface.charge_account_id%TYPE;
1499: l_unit_of_measure
1500: po_requisitions_interface.unit_of_measure%TYPE;
1501: l_uom_code
1502: po_requisitions_interface.uom_code%TYPE;
1503: l_source_organization_id
1504: po_requisitions_interface.source_organization_id%TYPE;
1505: l_destination_organization_id
1506: po_requisitions_interface.source_organization_id%TYPE;

Line 1504: po_requisitions_interface.source_organization_id%TYPE;

1500: po_requisitions_interface.unit_of_measure%TYPE;
1501: l_uom_code
1502: po_requisitions_interface.uom_code%TYPE;
1503: l_source_organization_id
1504: po_requisitions_interface.source_organization_id%TYPE;
1505: l_destination_organization_id
1506: po_requisitions_interface.source_organization_id%TYPE;
1507: l_source_subinventory
1508: po_requisitions_interface.source_subinventory%TYPE;

Line 1506: po_requisitions_interface.source_organization_id%TYPE;

1502: po_requisitions_interface.uom_code%TYPE;
1503: l_source_organization_id
1504: po_requisitions_interface.source_organization_id%TYPE;
1505: l_destination_organization_id
1506: po_requisitions_interface.source_organization_id%TYPE;
1507: l_source_subinventory
1508: po_requisitions_interface.source_subinventory%TYPE;
1509: l_dest_org_id
1510: po_requisitions_interface.destination_organization_id%TYPE;

Line 1508: po_requisitions_interface.source_subinventory%TYPE;

1504: po_requisitions_interface.source_organization_id%TYPE;
1505: l_destination_organization_id
1506: po_requisitions_interface.source_organization_id%TYPE;
1507: l_source_subinventory
1508: po_requisitions_interface.source_subinventory%TYPE;
1509: l_dest_org_id
1510: po_requisitions_interface.destination_organization_id%TYPE;
1511: l_dest_subinventory
1512: po_requisitions_interface.destination_subinventory%TYPE;

Line 1510: po_requisitions_interface.destination_organization_id%TYPE;

1506: po_requisitions_interface.source_organization_id%TYPE;
1507: l_source_subinventory
1508: po_requisitions_interface.source_subinventory%TYPE;
1509: l_dest_org_id
1510: po_requisitions_interface.destination_organization_id%TYPE;
1511: l_dest_subinventory
1512: po_requisitions_interface.destination_subinventory%TYPE;
1513: l_destination_type_code
1514: po_requisitions_interface.destination_type_code%TYPE;

Line 1512: po_requisitions_interface.destination_subinventory%TYPE;

1508: po_requisitions_interface.source_subinventory%TYPE;
1509: l_dest_org_id
1510: po_requisitions_interface.destination_organization_id%TYPE;
1511: l_dest_subinventory
1512: po_requisitions_interface.destination_subinventory%TYPE;
1513: l_destination_type_code
1514: po_requisitions_interface.destination_type_code%TYPE;
1515: l_deliver_to_location_id
1516: po_requisitions_interface.deliver_to_location_id%TYPE;

Line 1514: po_requisitions_interface.destination_type_code%TYPE;

1510: po_requisitions_interface.destination_organization_id%TYPE;
1511: l_dest_subinventory
1512: po_requisitions_interface.destination_subinventory%TYPE;
1513: l_destination_type_code
1514: po_requisitions_interface.destination_type_code%TYPE;
1515: l_deliver_to_location_id
1516: po_requisitions_interface.deliver_to_location_id%TYPE;
1517: l_transaction_id
1518: po_requisitions_interface.transaction_id%TYPE;

Line 1516: po_requisitions_interface.deliver_to_location_id%TYPE;

1512: po_requisitions_interface.destination_subinventory%TYPE;
1513: l_destination_type_code
1514: po_requisitions_interface.destination_type_code%TYPE;
1515: l_deliver_to_location_id
1516: po_requisitions_interface.deliver_to_location_id%TYPE;
1517: l_transaction_id
1518: po_requisitions_interface.transaction_id%TYPE;
1519: l_quantity
1520: po_requisitions_interface.quantity%TYPE;

Line 1518: po_requisitions_interface.transaction_id%TYPE;

1514: po_requisitions_interface.destination_type_code%TYPE;
1515: l_deliver_to_location_id
1516: po_requisitions_interface.deliver_to_location_id%TYPE;
1517: l_transaction_id
1518: po_requisitions_interface.transaction_id%TYPE;
1519: l_quantity
1520: po_requisitions_interface.quantity%TYPE;
1521: l_rowid varchar2(25) ;
1522: l_autosource_doc_header_id

Line 1520: po_requisitions_interface.quantity%TYPE;

1516: po_requisitions_interface.deliver_to_location_id%TYPE;
1517: l_transaction_id
1518: po_requisitions_interface.transaction_id%TYPE;
1519: l_quantity
1520: po_requisitions_interface.quantity%TYPE;
1521: l_rowid varchar2(25) ;
1522: l_autosource_doc_header_id
1523: po_requisitions_interface.autosource_doc_header_id%TYPE;
1524: l_autosource_doc_line_num

Line 1523: po_requisitions_interface.autosource_doc_header_id%TYPE;

1519: l_quantity
1520: po_requisitions_interface.quantity%TYPE;
1521: l_rowid varchar2(25) ;
1522: l_autosource_doc_header_id
1523: po_requisitions_interface.autosource_doc_header_id%TYPE;
1524: l_autosource_doc_line_num
1525: po_requisitions_interface.autosource_doc_line_num%TYPE;
1526: l_suggested_vendor_id
1527: po_requisitions_interface.suggested_vendor_id%TYPE;

Line 1525: po_requisitions_interface.autosource_doc_line_num%TYPE;

1521: l_rowid varchar2(25) ;
1522: l_autosource_doc_header_id
1523: po_requisitions_interface.autosource_doc_header_id%TYPE;
1524: l_autosource_doc_line_num
1525: po_requisitions_interface.autosource_doc_line_num%TYPE;
1526: l_suggested_vendor_id
1527: po_requisitions_interface.suggested_vendor_id%TYPE;
1528: l_suggested_vendor_site_id
1529: po_requisitions_interface.suggested_vendor_site_id%TYPE;

Line 1527: po_requisitions_interface.suggested_vendor_id%TYPE;

1523: po_requisitions_interface.autosource_doc_header_id%TYPE;
1524: l_autosource_doc_line_num
1525: po_requisitions_interface.autosource_doc_line_num%TYPE;
1526: l_suggested_vendor_id
1527: po_requisitions_interface.suggested_vendor_id%TYPE;
1528: l_suggested_vendor_site_id
1529: po_requisitions_interface.suggested_vendor_site_id%TYPE;
1530:
1531: l_call_autoacct varchar2(1); -- execution control for auto accounting procedure.

Line 1529: po_requisitions_interface.suggested_vendor_site_id%TYPE;

1525: po_requisitions_interface.autosource_doc_line_num%TYPE;
1526: l_suggested_vendor_id
1527: po_requisitions_interface.suggested_vendor_id%TYPE;
1528: l_suggested_vendor_site_id
1529: po_requisitions_interface.suggested_vendor_site_id%TYPE;
1530:
1531: l_call_autoacct varchar2(1); -- execution control for auto accounting procedure.
1532: l_po_imp_req_flag VARCHAR2(1); -- pkg execution control profile variable
1533: