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 2922: l_dummy_vendor_product_num PO_REQUISITIONS_INTERFACE_ALL.suggested_vendor_item_num%type := x_vendor_product_num;

2918: --source document related info.
2919: l_dummy_cons_from_sup_flag PO_ASL_ATTRIBUTES.consigned_from_supplier_flag%type := NULL;
2920: l_dummy_enable_vmi_flag PO_ASL_ATTRIBUTES.enable_vmi_flag%type := NULL;
2921: l_dummy_sequence_number PO_ASL_DOCUMENTS.sequence_num%type := NULL;
2922: l_dummy_vendor_product_num PO_REQUISITIONS_INTERFACE_ALL.suggested_vendor_item_num%type := x_vendor_product_num;
2923: l_dummy_asl_purchasing_uom PO_REQUISITIONS_INTERFACE_ALL.unit_of_measure%type := x_purchasing_uom;
2924: l_dummy_category_id PO_REQUISITIONS_INTERFACE_ALL.category_id%type := p_category_id;
2925: l_dummy_using_organization_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type := p_using_organization_id;
2926: --

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

2919: l_dummy_cons_from_sup_flag PO_ASL_ATTRIBUTES.consigned_from_supplier_flag%type := NULL;
2920: l_dummy_enable_vmi_flag PO_ASL_ATTRIBUTES.enable_vmi_flag%type := NULL;
2921: l_dummy_sequence_number PO_ASL_DOCUMENTS.sequence_num%type := NULL;
2922: l_dummy_vendor_product_num PO_REQUISITIONS_INTERFACE_ALL.suggested_vendor_item_num%type := x_vendor_product_num;
2923: l_dummy_asl_purchasing_uom PO_REQUISITIONS_INTERFACE_ALL.unit_of_measure%type := x_purchasing_uom;
2924: l_dummy_category_id PO_REQUISITIONS_INTERFACE_ALL.category_id%type := p_category_id;
2925: l_dummy_using_organization_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type := p_using_organization_id;
2926: --
2927: BEGIN

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

2920: l_dummy_enable_vmi_flag PO_ASL_ATTRIBUTES.enable_vmi_flag%type := NULL;
2921: l_dummy_sequence_number PO_ASL_DOCUMENTS.sequence_num%type := NULL;
2922: l_dummy_vendor_product_num PO_REQUISITIONS_INTERFACE_ALL.suggested_vendor_item_num%type := x_vendor_product_num;
2923: l_dummy_asl_purchasing_uom PO_REQUISITIONS_INTERFACE_ALL.unit_of_measure%type := x_purchasing_uom;
2924: l_dummy_category_id PO_REQUISITIONS_INTERFACE_ALL.category_id%type := p_category_id;
2925: l_dummy_using_organization_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type := p_using_organization_id;
2926: --
2927: BEGIN
2928:

Line 4564: l_temp_quantity PO_REQUISITIONS_INTERFACE.quantity%type;

4560: p_rounding_factor IN NUMBER,
4561: p_enforce_full_lot_qty IN VARCHAR2,
4562: x_quantity IN OUT NOCOPY NUMBER)
4563: IS
4564: l_temp_quantity PO_REQUISITIONS_INTERFACE.quantity%type;
4565: l_remainder NUMBER;
4566: l_adjust NUMBER;
4567: l_progress VARCHAR2(3);
4568: l_log_head CONSTANT VARCHAR2(100) := g_log_head || 'PROCESS_REQ_QTY';

Line 4788: x_uom_code po_requisitions_interface.uom_code%type;

4784: x_rate NUMBER := NULL;
4785: x_return_code BOOLEAN := NULL;
4786: x_commodity_id NUMBER := NULL;
4787: x_purchasing_uom po_asl_attributes.purchasing_unit_of_measure%type;
4788: x_uom_code po_requisitions_interface.uom_code%type;
4789: x_unit_of_measure po_requisitions_interface.unit_of_measure%type;
4790: x_autosource_flag po_requisitions_interface.autosource_flag%type;
4791: x_organization_id NUMBER := NULL;
4792: x_conversion_rate NUMBER := 1;

Line 4789: x_unit_of_measure po_requisitions_interface.unit_of_measure%type;

4785: x_return_code BOOLEAN := NULL;
4786: x_commodity_id NUMBER := NULL;
4787: x_purchasing_uom po_asl_attributes.purchasing_unit_of_measure%type;
4788: x_uom_code po_requisitions_interface.uom_code%type;
4789: x_unit_of_measure po_requisitions_interface.unit_of_measure%type;
4790: x_autosource_flag po_requisitions_interface.autosource_flag%type;
4791: x_organization_id NUMBER := NULL;
4792: x_conversion_rate NUMBER := 1;
4793: x_item_buyer_id NUMBER;

Line 4790: x_autosource_flag po_requisitions_interface.autosource_flag%type;

4786: x_commodity_id NUMBER := NULL;
4787: x_purchasing_uom po_asl_attributes.purchasing_unit_of_measure%type;
4788: x_uom_code po_requisitions_interface.uom_code%type;
4789: x_unit_of_measure po_requisitions_interface.unit_of_measure%type;
4790: x_autosource_flag po_requisitions_interface.autosource_flag%type;
4791: x_organization_id NUMBER := NULL;
4792: x_conversion_rate NUMBER := 1;
4793: x_item_buyer_id NUMBER;
4794: x_ga_flag VARCHAR2(1) := '';

Line 4806: l_req_dist_sequence_id PO_REQUISITIONS_INTERFACE.req_dist_sequence_id%type;

4802: l_negotiated_by_preparer_flag PO_LINES_ALL.NEGOTIATED_BY_PREPARER_FLAG%TYPE; -- PO DBI FPJ
4803:
4804: --
4805: l_asl_id PO_ASL_DOCUMENTS.ASL_ID%type;
4806: l_req_dist_sequence_id PO_REQUISITIONS_INTERFACE.req_dist_sequence_id%type;
4807: l_primary_uom MTL_SYSTEM_ITEMS.primary_unit_of_measure%type;
4808: l_unit_of_issue MTL_SYSTEM_ITEMS.unit_of_issue%type;
4809: l_rounding_factor MTL_SYSTEM_ITEMS.rounding_factor%type;
4810: l_min_ord_qty PO_ASL_ATTRIBUTES.min_order_qty%type;

Line 4814: l_interface_source_code PO_REQUISITIONS_INTERFACE.interface_source_code%type;

4810: l_min_ord_qty PO_ASL_ATTRIBUTES.min_order_qty%type;
4811: l_fixed_lot_multiple PO_ASL_ATTRIBUTES.fixed_lot_multiple%type;
4812: l_uom_conversion_rate NUMBER;
4813: l_enforce_full_lot_qty PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%type;
4814: l_interface_source_code PO_REQUISITIONS_INTERFACE.interface_source_code%type;
4815: l_asl_purchasing_uom PO_ASL_ATTRIBUTES.purchasing_unit_of_measure%type; --
4816: --
4817:
4818: --

Line 4855: FROM po_requisitions_interface

4851: --
4852: ,line_type_id
4853: ,destination_type_code
4854: --
4855: FROM po_requisitions_interface
4856: WHERE autosource_flag in ('Y', 'P')
4857: AND source_type_code = 'VENDOR'
4858: AND item_id IS NOT NULL
4859: AND request_id = x_request_id;

Line 4887: FROM po_requisitions_interface

4883: --
4884: ,line_type_id
4885: ,destination_type_code
4886: --
4887: FROM po_requisitions_interface
4888: WHERE autosource_flag in ('Y', 'P')
4889: AND source_type_code = 'INVENTORY'
4890: AND destination_organization_id IS NOT NULL
4891: AND request_id = x_request_id;

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

5279: -- brought back a new vendor.
5280: -- Bug 3810029 : changed the uom update : see above
5281:
5282: --
5283: -- Update the po_requisitions_interface table with the calculated quantity returned
5284: -- by the above procedure instead of computing the new quantity in the update statement.
5285:
5286: UPDATE po_requisitions_interface
5287: SET suggested_vendor_id = nvl(x_vendor_id,suggested_vendor_id),

Line 5286: UPDATE po_requisitions_interface

5282: --
5283: -- Update the po_requisitions_interface table with the calculated quantity returned
5284: -- by the above procedure instead of computing the new quantity in the update statement.
5285:
5286: UPDATE po_requisitions_interface
5287: SET suggested_vendor_id = nvl(x_vendor_id,suggested_vendor_id),
5288: suggested_vendor_name = decode(x_vendor_id, null , suggested_vendor_name, x_vendor_name),
5289: suggested_vendor_site_id = nvl(x_vendor_site_id,suggested_vendor_site_id),
5290: suggested_buyer_id = nvl(suggested_buyer_id, x_buyer_id),

Line 5320: UPDATE po_Requisitions_InterFace po_Requisitions_InterFace

5316: CLOSE L_GET_REQ_INFO_VENDOR_CSR;
5317:
5318: /* 7234465 - Imported Requisitions were getting Reserved Even when the Source BPA is Encumbered. */
5319: /* This sql will set the Prevent Encumbrance Flag to Y, if BPA is Encumbered. */
5320: UPDATE po_Requisitions_InterFace po_Requisitions_InterFace
5321: SET po_Requisitions_InterFace.Prevent_Encumbrance_Flag = 'Y'
5322: WHERE po_Requisitions_InterFace.AutoSource_Doc_Header_Id IS NOT NULL
5323: AND po_Requisitions_Interface.request_id = x_request_id
5324: AND EXISTS (SELECT 'BPA Encumbered'

Line 5321: SET po_Requisitions_InterFace.Prevent_Encumbrance_Flag = 'Y'

5317:
5318: /* 7234465 - Imported Requisitions were getting Reserved Even when the Source BPA is Encumbered. */
5319: /* This sql will set the Prevent Encumbrance Flag to Y, if BPA is Encumbered. */
5320: UPDATE po_Requisitions_InterFace po_Requisitions_InterFace
5321: SET po_Requisitions_InterFace.Prevent_Encumbrance_Flag = 'Y'
5322: WHERE po_Requisitions_InterFace.AutoSource_Doc_Header_Id IS NOT NULL
5323: AND po_Requisitions_Interface.request_id = x_request_id
5324: AND EXISTS (SELECT 'BPA Encumbered'
5325: FROM po_Distributions_All d,

Line 5322: WHERE po_Requisitions_InterFace.AutoSource_Doc_Header_Id IS NOT NULL

5318: /* 7234465 - Imported Requisitions were getting Reserved Even when the Source BPA is Encumbered. */
5319: /* This sql will set the Prevent Encumbrance Flag to Y, if BPA is Encumbered. */
5320: UPDATE po_Requisitions_InterFace po_Requisitions_InterFace
5321: SET po_Requisitions_InterFace.Prevent_Encumbrance_Flag = 'Y'
5322: WHERE po_Requisitions_InterFace.AutoSource_Doc_Header_Id IS NOT NULL
5323: AND po_Requisitions_Interface.request_id = x_request_id
5324: AND EXISTS (SELECT 'BPA Encumbered'
5325: FROM po_Distributions_All d,
5326: po_Headers_All h

Line 5323: AND po_Requisitions_Interface.request_id = x_request_id

5319: /* This sql will set the Prevent Encumbrance Flag to Y, if BPA is Encumbered. */
5320: UPDATE po_Requisitions_InterFace po_Requisitions_InterFace
5321: SET po_Requisitions_InterFace.Prevent_Encumbrance_Flag = 'Y'
5322: WHERE po_Requisitions_InterFace.AutoSource_Doc_Header_Id IS NOT NULL
5323: AND po_Requisitions_Interface.request_id = x_request_id
5324: AND EXISTS (SELECT 'BPA Encumbered'
5325: FROM po_Distributions_All d,
5326: po_Headers_All h
5327: WHERE h.po_Header_Id = po_Requisitions_InterFace.AutoSource_Doc_Header_Id

Line 5327: WHERE h.po_Header_Id = po_Requisitions_InterFace.AutoSource_Doc_Header_Id

5323: AND po_Requisitions_Interface.request_id = x_request_id
5324: AND EXISTS (SELECT 'BPA Encumbered'
5325: FROM po_Distributions_All d,
5326: po_Headers_All h
5327: WHERE h.po_Header_Id = po_Requisitions_InterFace.AutoSource_Doc_Header_Id
5328: AND h.po_Header_Id = d.po_Header_Id
5329: AND h.Type_LookUp_Code = 'BLANKET'
5330: AND d.Line_Location_Id IS NULL
5331: AND d.po_Release_Id IS NULL

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

5513: p_enforce_full_lot_qty => l_enforce_full_lot_qty,
5514: x_quantity => x_quantity);
5515:
5516: END IF;
5517: -- Updating the quantity and the unit_of_measure in the po_requisitions_interface
5518: -- after the quantity conversion.
5519:
5520: -- We need to put the l_enforce_full_lot_qty in the decode as there should be no
5521: -- UOM conversion if enforce_full_lot_quantities is set to 'NONE'

Line 5522: UPDATE po_requisitions_interface

5518: -- after the quantity conversion.
5519:
5520: -- We need to put the l_enforce_full_lot_qty in the decode as there should be no
5521: -- UOM conversion if enforce_full_lot_quantities is set to 'NONE'
5522: UPDATE po_requisitions_interface
5523: SET source_organization_id = x_source_organization_id,
5524: source_subinventory = x_source_subinventory,
5525: suggested_buyer_id = nvl(suggested_buyer_id, x_buyer_id),
5526: quantity = x_quantity,