DBA Data[Home] [Help]

APPS.GMIVTDX dependencies on GMI_DISCRETE_TRANSFERS

Line 80: l_hdr_row gmi_discrete_transfers%ROWTYPE;

76: l_api_name CONSTANT VARCHAR2(30) := 'create_txn_update_balances' ;
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:

Line 112: FROM gmi_discrete_transfers

108: END IF;
109:
110: SELECT *
111: INTO l_hdr_row
112: FROM gmi_discrete_transfers
113: WHERE transfer_id = p_transfer_id;
114:
115: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
116: log_msg('After selecting header row from database. transfer id is '||to_char(l_hdr_row.transfer_id));

Line 283: , p_hdr_row IN gmi_discrete_transfers%ROWTYPE

279: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
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

Line 486: , p_hdr_row IN gmi_discrete_transfers%ROWTYPE

482: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
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