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_AUTOSOURCE_SV dependencies on PO_REQUISITIONS_INTERFACE

Line 2899: l_dummy_vendor_product_num PO_REQUISITIONS_INTERFACE_ALL.suggested_vendor_item_num%type := x_vendor_product_num;

2895: --source document related info.
2896: l_dummy_cons_from_sup_flag PO_ASL_ATTRIBUTES.consigned_from_supplier_flag%type := NULL;
2897: l_dummy_enable_vmi_flag PO_ASL_ATTRIBUTES.enable_vmi_flag%type := NULL;
2898: l_dummy_sequence_number PO_ASL_DOCUMENTS.sequence_num%type := NULL;
2899: l_dummy_vendor_product_num PO_REQUISITIONS_INTERFACE_ALL.suggested_vendor_item_num%type := x_vendor_product_num;
2900: l_dummy_asl_purchasing_uom PO_REQUISITIONS_INTERFACE_ALL.unit_of_measure%type := x_purchasing_uom;
2901: l_dummy_category_id PO_REQUISITIONS_INTERFACE_ALL.category_id%type := p_category_id;
2902: l_dummy_using_organization_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type := p_using_organization_id;
2903: --

Line 2900: l_dummy_asl_purchasing_uom PO_REQUISITIONS_INTERFACE_ALL.unit_of_measure%type := x_purchasing_uom;

2896: l_dummy_cons_from_sup_flag PO_ASL_ATTRIBUTES.consigned_from_supplier_flag%type := NULL;
2897: l_dummy_enable_vmi_flag PO_ASL_ATTRIBUTES.enable_vmi_flag%type := NULL;
2898: l_dummy_sequence_number PO_ASL_DOCUMENTS.sequence_num%type := NULL;
2899: l_dummy_vendor_product_num PO_REQUISITIONS_INTERFACE_ALL.suggested_vendor_item_num%type := x_vendor_product_num;
2900: l_dummy_asl_purchasing_uom PO_REQUISITIONS_INTERFACE_ALL.unit_of_measure%type := x_purchasing_uom;
2901: l_dummy_category_id PO_REQUISITIONS_INTERFACE_ALL.category_id%type := p_category_id;
2902: l_dummy_using_organization_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type := p_using_organization_id;
2903: --
2904: BEGIN

Line 2901: l_dummy_category_id PO_REQUISITIONS_INTERFACE_ALL.category_id%type := p_category_id;

2897: l_dummy_enable_vmi_flag PO_ASL_ATTRIBUTES.enable_vmi_flag%type := NULL;
2898: l_dummy_sequence_number PO_ASL_DOCUMENTS.sequence_num%type := NULL;
2899: l_dummy_vendor_product_num PO_REQUISITIONS_INTERFACE_ALL.suggested_vendor_item_num%type := x_vendor_product_num;
2900: l_dummy_asl_purchasing_uom PO_REQUISITIONS_INTERFACE_ALL.unit_of_measure%type := x_purchasing_uom;
2901: l_dummy_category_id PO_REQUISITIONS_INTERFACE_ALL.category_id%type := p_category_id;
2902: l_dummy_using_organization_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type := p_using_organization_id;
2903: --
2904: BEGIN
2905:

Line 4536: l_temp_quantity PO_REQUISITIONS_INTERFACE.quantity%type;

4532: p_rounding_factor IN NUMBER,
4533: p_enforce_full_lot_qty IN VARCHAR2,
4534: x_quantity IN OUT NOCOPY NUMBER)
4535: IS
4536: l_temp_quantity PO_REQUISITIONS_INTERFACE.quantity%type;
4537: l_remainder NUMBER;
4538: l_adjust NUMBER;
4539: l_progress VARCHAR2(3);
4540: l_log_head CONSTANT VARCHAR2(100) := g_log_head || 'PROCESS_REQ_QTY';

Line 4750: x_uom_code po_requisitions_interface.uom_code%type;

4746: x_rate NUMBER := NULL;
4747: x_return_code BOOLEAN := NULL;
4748: x_commodity_id NUMBER := NULL;
4749: x_purchasing_uom po_asl_attributes.purchasing_unit_of_measure%type;
4750: x_uom_code po_requisitions_interface.uom_code%type;
4751: x_unit_of_measure po_requisitions_interface.unit_of_measure%type;
4752: x_autosource_flag po_requisitions_interface.autosource_flag%type;
4753: x_organization_id NUMBER := NULL;
4754: x_conversion_rate NUMBER := 1;

Line 4751: x_unit_of_measure po_requisitions_interface.unit_of_measure%type;

4747: x_return_code BOOLEAN := NULL;
4748: x_commodity_id NUMBER := NULL;
4749: x_purchasing_uom po_asl_attributes.purchasing_unit_of_measure%type;
4750: x_uom_code po_requisitions_interface.uom_code%type;
4751: x_unit_of_measure po_requisitions_interface.unit_of_measure%type;
4752: x_autosource_flag po_requisitions_interface.autosource_flag%type;
4753: x_organization_id NUMBER := NULL;
4754: x_conversion_rate NUMBER := 1;
4755: x_item_buyer_id NUMBER;

Line 4752: x_autosource_flag po_requisitions_interface.autosource_flag%type;

4748: x_commodity_id NUMBER := NULL;
4749: x_purchasing_uom po_asl_attributes.purchasing_unit_of_measure%type;
4750: x_uom_code po_requisitions_interface.uom_code%type;
4751: x_unit_of_measure po_requisitions_interface.unit_of_measure%type;
4752: x_autosource_flag po_requisitions_interface.autosource_flag%type;
4753: x_organization_id NUMBER := NULL;
4754: x_conversion_rate NUMBER := 1;
4755: x_item_buyer_id NUMBER;
4756: x_ga_flag VARCHAR2(1) := '';

Line 4768: l_req_dist_sequence_id PO_REQUISITIONS_INTERFACE.req_dist_sequence_id%type;

4764: l_negotiated_by_preparer_flag PO_LINES_ALL.NEGOTIATED_BY_PREPARER_FLAG%TYPE; -- PO DBI FPJ
4765:
4766: --
4767: l_asl_id PO_ASL_DOCUMENTS.ASL_ID%type;
4768: l_req_dist_sequence_id PO_REQUISITIONS_INTERFACE.req_dist_sequence_id%type;
4769: l_primary_uom MTL_SYSTEM_ITEMS.primary_unit_of_measure%type;
4770: l_unit_of_issue MTL_SYSTEM_ITEMS.unit_of_issue%type;
4771: l_rounding_factor MTL_SYSTEM_ITEMS.rounding_factor%type;
4772: l_min_ord_qty PO_ASL_ATTRIBUTES.min_order_qty%type;

Line 4776: l_interface_source_code PO_REQUISITIONS_INTERFACE.interface_source_code%type;

4772: l_min_ord_qty PO_ASL_ATTRIBUTES.min_order_qty%type;
4773: l_fixed_lot_multiple PO_ASL_ATTRIBUTES.fixed_lot_multiple%type;
4774: l_uom_conversion_rate NUMBER;
4775: l_enforce_full_lot_qty PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%type;
4776: l_interface_source_code PO_REQUISITIONS_INTERFACE.interface_source_code%type;
4777: l_asl_purchasing_uom PO_ASL_ATTRIBUTES.purchasing_unit_of_measure%type; --
4778: --
4779:
4780: --

Line 4816: FROM po_requisitions_interface

4812: --
4813: ,line_type_id
4814: ,destination_type_code
4815: --
4816: FROM po_requisitions_interface
4817: WHERE autosource_flag in ('Y', 'P')
4818: AND source_type_code = 'VENDOR'
4819: AND item_id IS NOT NULL
4820: AND request_id = x_request_id;

Line 4848: FROM po_requisitions_interface

4844: --
4845: ,line_type_id
4846: ,destination_type_code
4847: --
4848: FROM po_requisitions_interface
4849: WHERE autosource_flag in ('Y', 'P')
4850: AND source_type_code = 'INVENTORY'
4851: AND destination_organization_id IS NOT NULL
4852: AND request_id = x_request_id;

Line 5211: -- Update the po_requisitions_interface table with the calculated quantity returned

5207: -- brought back a new vendor.
5208: -- Bug 3810029 : changed the uom update : see above
5209:
5210: --
5211: -- Update the po_requisitions_interface table with the calculated quantity returned
5212: -- by the above procedure instead of computing the new quantity in the update statement.
5213:
5214: UPDATE po_requisitions_interface
5215: SET suggested_vendor_id = nvl(x_vendor_id,suggested_vendor_id),

Line 5214: UPDATE po_requisitions_interface

5210: --
5211: -- Update the po_requisitions_interface table with the calculated quantity returned
5212: -- by the above procedure instead of computing the new quantity in the update statement.
5213:
5214: UPDATE po_requisitions_interface
5215: SET suggested_vendor_id = nvl(x_vendor_id,suggested_vendor_id),
5216: suggested_vendor_name = decode(x_vendor_id, null , suggested_vendor_name, x_vendor_name),
5217: suggested_vendor_site_id = nvl(x_vendor_site_id,suggested_vendor_site_id),
5218: suggested_buyer_id = nvl(suggested_buyer_id, x_buyer_id),

Line 5243: UPDATE po_Requisitions_InterFace po_Requisitions_InterFace

5239: CLOSE L_GET_REQ_INFO_VENDOR_CSR;
5240:
5241: /* 7234465 - Imported Requisitions were getting Reserved Even when the Source BPA is Encumbered. */
5242: /* This sql will set the Prevent Encumbrance Flag to Y, if BPA is Encumbered. */
5243: UPDATE po_Requisitions_InterFace po_Requisitions_InterFace
5244: SET po_Requisitions_InterFace.Prevent_Encumbrance_Flag = 'Y'
5245: WHERE po_Requisitions_InterFace.AutoSource_Doc_Header_Id IS NOT NULL
5246: AND po_Requisitions_Interface.request_id = x_request_id
5247: AND EXISTS (SELECT 'BPA Encumbered'

Line 5244: SET po_Requisitions_InterFace.Prevent_Encumbrance_Flag = 'Y'

5240:
5241: /* 7234465 - Imported Requisitions were getting Reserved Even when the Source BPA is Encumbered. */
5242: /* This sql will set the Prevent Encumbrance Flag to Y, if BPA is Encumbered. */
5243: UPDATE po_Requisitions_InterFace po_Requisitions_InterFace
5244: SET po_Requisitions_InterFace.Prevent_Encumbrance_Flag = 'Y'
5245: WHERE po_Requisitions_InterFace.AutoSource_Doc_Header_Id IS NOT NULL
5246: AND po_Requisitions_Interface.request_id = x_request_id
5247: AND EXISTS (SELECT 'BPA Encumbered'
5248: FROM po_Distributions_All d,

Line 5245: WHERE po_Requisitions_InterFace.AutoSource_Doc_Header_Id IS NOT NULL

5241: /* 7234465 - Imported Requisitions were getting Reserved Even when the Source BPA is Encumbered. */
5242: /* This sql will set the Prevent Encumbrance Flag to Y, if BPA is Encumbered. */
5243: UPDATE po_Requisitions_InterFace po_Requisitions_InterFace
5244: SET po_Requisitions_InterFace.Prevent_Encumbrance_Flag = 'Y'
5245: WHERE po_Requisitions_InterFace.AutoSource_Doc_Header_Id IS NOT NULL
5246: AND po_Requisitions_Interface.request_id = x_request_id
5247: AND EXISTS (SELECT 'BPA Encumbered'
5248: FROM po_Distributions_All d,
5249: po_Headers_All h

Line 5246: AND po_Requisitions_Interface.request_id = x_request_id

5242: /* This sql will set the Prevent Encumbrance Flag to Y, if BPA is Encumbered. */
5243: UPDATE po_Requisitions_InterFace po_Requisitions_InterFace
5244: SET po_Requisitions_InterFace.Prevent_Encumbrance_Flag = 'Y'
5245: WHERE po_Requisitions_InterFace.AutoSource_Doc_Header_Id IS NOT NULL
5246: AND po_Requisitions_Interface.request_id = x_request_id
5247: AND EXISTS (SELECT 'BPA Encumbered'
5248: FROM po_Distributions_All d,
5249: po_Headers_All h
5250: WHERE h.po_Header_Id = po_Requisitions_InterFace.AutoSource_Doc_Header_Id

Line 5250: WHERE h.po_Header_Id = po_Requisitions_InterFace.AutoSource_Doc_Header_Id

5246: AND po_Requisitions_Interface.request_id = x_request_id
5247: AND EXISTS (SELECT 'BPA Encumbered'
5248: FROM po_Distributions_All d,
5249: po_Headers_All h
5250: WHERE h.po_Header_Id = po_Requisitions_InterFace.AutoSource_Doc_Header_Id
5251: AND h.po_Header_Id = d.po_Header_Id
5252: AND h.Type_LookUp_Code = 'BLANKET'
5253: AND d.Line_Location_Id IS NULL
5254: AND d.po_Release_Id IS NULL

Line 5440: -- Updating the quantity and the unit_of_measure in the po_requisitions_interface

5436: p_enforce_full_lot_qty => l_enforce_full_lot_qty,
5437: x_quantity => x_quantity);
5438:
5439: END IF;
5440: -- Updating the quantity and the unit_of_measure in the po_requisitions_interface
5441: -- after the quantity conversion.
5442:
5443: -- We need to put the l_enforce_full_lot_qty in the decode as there should be no
5444: -- UOM conversion if enforce_full_lot_quantities is set to 'NONE'

Line 5445: UPDATE po_requisitions_interface

5441: -- after the quantity conversion.
5442:
5443: -- We need to put the l_enforce_full_lot_qty in the decode as there should be no
5444: -- UOM conversion if enforce_full_lot_quantities is set to 'NONE'
5445: UPDATE po_requisitions_interface
5446: SET source_organization_id = x_source_organization_id,
5447: source_subinventory = x_source_subinventory,
5448: suggested_buyer_id = nvl(suggested_buyer_id, x_buyer_id),
5449: quantity = x_quantity,