APPS.CSTPAVCP dependencies on PO_REQUISITION_LINES_ALL

Line 9362: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,

9358:
9359: PROCEDURE CompEncumbrance_IntOrdersExp (
9360: p_api_version IN NUMBER,
9361: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
9362: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,
9363: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
9364: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,
9365: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
9366: p_total_primary_qty IN NUMBER,

Line 9373: l_doc_line_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;

9369: x_return_status OUT NOCOPY VARCHAR,
9370: x_return_message OUT NOCOPY VARCHAR2
9371: ) IS
9372:
9373: l_doc_line_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
9374: l_doc_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
9375: l_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
9376: l_conversion_rate NUMBER;
9377: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

Line 9374: l_doc_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;

9370: x_return_message OUT NOCOPY VARCHAR2
9371: ) IS
9372:
9373: l_doc_line_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
9374: l_doc_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
9375: l_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
9376: l_conversion_rate NUMBER;
9377: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
9378: l_doc_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

Line 9375: l_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;

9371: ) IS
9372:
9373: l_doc_line_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
9374: l_doc_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
9375: l_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
9376: l_conversion_rate NUMBER;
9377: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
9378: l_doc_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
9379: l_uom_rate NUMBER;

Line 9430: po_requisition_lines_all rl,

9426: l_unit_price,
9427: x_encumbrance_account,
9428: l_non_recoverable_tax /* Bug 6405593 */
9429: FROM po_req_distributions_all rd,
9430: po_requisition_lines_all rl,
9431: mtl_units_of_measure um
9432: WHERE rd.requisition_line_id = p_req_line_id
9433: and rd.requisition_line_id = rl.requisition_line_id
9434: and rl.UNIT_MEAS_LOOKUP_CODE = um.unit_of_measure;

Line 9572: l_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;

9568: l_total_primary_qty NUMBER;
9569: l_primary_qty MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE;
9570: l_organization_id MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID%TYPE;
9571: l_trx_source_line_id MTL_MATERIAL_TRANSACTIONS.TRX_SOURCE_LINE_ID%TYPE;
9572: l_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
9573: l_item_id MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE;
9574: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;
9575: l_txn_src_type_id
9576: MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;