DBA Data[Home] [Help]

APPS.CSTPAVCP dependencies on MTL_MATERIAL_TRANSACTIONS

Line 235: -- Update_MMT Updating denormalized data in mtl_material_transactions

231: O_Err_Msg OUT NOCOPY VARCHAR2
232: );
233:
234: -- PROCEDURE
235: -- Update_MMT Updating denormalized data in mtl_material_transactions
236: --
237:
238: procedure update_mmt(
239: I_ORG_ID IN NUMBER,

Line 613: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,

609: * the order so far.
610: * ------------------------------------------------------------------------*/
611: PROCEDURE CompEncumbrance_IntOrdersExp (
612: p_api_version IN NUMBER,
613: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
614: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,
615: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
616: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,
617: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,

Line 617: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,

613: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
614: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,
615: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
616: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,
617: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
618: p_total_primary_qty IN NUMBER,
619: x_encumbrance_amount OUT NOCOPY NUMBER,
620: x_encumbrance_account OUT NOCOPY NUMBER,
621: x_return_status OUT NOCOPY VARCHAR,

Line 637: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,

633: *
634: * ------------------------------------------------------------------------*/
635: PROCEDURE CompEncumbrance_IntOrdersExp (
636: p_api_version IN NUMBER,
637: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
638:
639: x_encumbrance_amount OUT NOCOPY NUMBER,
640: x_encumbrance_account OUT NOCOPY NUMBER,
641: x_return_status OUT NOCOPY VARCHAR,