DBA Data[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 928: p_txn_lots_interface_rec IN mtl_transaction_lots_interface%ROWTYPE,

924:
925:
926: PROCEDURE insert_transaction_lots
927: (
928: p_txn_lots_interface_rec IN mtl_transaction_lots_interface%ROWTYPE,
929: x_return_status OUT NOCOPY VARCHAR2
930: )
931: IS
932:

Line 970: INSERT INTO mtl_transaction_lots_interface

966:
967: --insert into table mtl_transactions_interface
968: BEGIN
969:
970: INSERT INTO mtl_transaction_lots_interface
971: (last_updated_by,
972: last_update_date,
973: last_update_login,
974: created_by,

Line 3501: l_txn_lots_interface_rec mtl_transaction_lots_interface%ROWTYPE;

3497: lc_inven_rct_srl_control CONSTANT NUMBER := 5;
3498:
3499: -- Records to hold mtl_transactions_interface data
3500: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
3501: l_txn_lots_interface_rec mtl_transaction_lots_interface%ROWTYPE;
3502: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
3503:
3504: CURSOR get_mtl_header_id IS
3505: SELECT mtl_material_transactions_s.nextval from dual;