DBA Data[Home] [Help]

APPS.GMIVTDX dependencies on GMI_DISCRETE_TRANSFER_LINES

Line 81: l_line_row gmi_discrete_transfer_lines%ROWTYPE;

77: l_api_version CONSTANT NUMBER := 1.0 ;
78: l_txn_vars_rec txn_vars_type;
79: l_odm_txn_type_rec inv_validate.transaction;
80: l_hdr_row gmi_discrete_transfers%ROWTYPE;
81: l_line_row gmi_discrete_transfer_lines%ROWTYPE;
82: l_lot_row_tbl GMIVDX.lot_row_tbl;
83: l_lot_count pls_integer := 0;
84:
85: Cursor Cur_get_lot_records(Vtransfer_id NUMBER, Vline_id NUMBER) IS

Line 121: FROM gmi_discrete_transfer_lines

117: END IF;
118:
119: SELECT *
120: INTO l_line_row
121: FROM gmi_discrete_transfer_lines
122: WHERE transfer_id = p_transfer_id
123: AND line_id = p_line_id;
124:
125: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

Line 284: , p_line_row IN gmi_discrete_transfer_lines%ROWTYPE

280: , x_return_status OUT NOCOPY VARCHAR2
281: , x_msg_count OUT NOCOPY NUMBER
282: , x_msg_data OUT NOCOPY VARCHAR2
283: , p_hdr_row IN gmi_discrete_transfers%ROWTYPE
284: , p_line_row IN gmi_discrete_transfer_lines%ROWTYPE
285: , p_lot_row_tbl IN GMIVDX.lot_row_tbl
286: , p_txn_vars_rec IN txn_vars_type
287: )IS
288: l_api_name CONSTANT VARCHAR2(30) := 'create_txn_update_bal_in_opm' ;

Line 487: , p_line_row IN gmi_discrete_transfer_lines%ROWTYPE

483: , x_return_status OUT NOCOPY VARCHAR2
484: , x_msg_count OUT NOCOPY NUMBER
485: , x_msg_data OUT NOCOPY VARCHAR2
486: , p_hdr_row IN gmi_discrete_transfers%ROWTYPE
487: , p_line_row IN gmi_discrete_transfer_lines%ROWTYPE
488: , p_lot_row_tbl IN GMIVDX.lot_row_tbl
489: , p_txn_vars_rec IN txn_vars_type
490: , p_odm_txn_type_rec IN inv_validate.transaction
491: , x_transaction_header_id IN OUT NOCOPY NUMBER