DBA Data[Home] [Help]

APPS.INV_CALCULATE_EXP_DATE dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 9: TYPE mmtt_tab IS TABLE OF MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

5: g_mmtt_txn_id NUMBER := -1; -- stores the transaction_header_id to identify row in MMTT
6: g_mtli_txn_id ROWID := '-1'; -- stores the rowid to identify row in MTLI
7: g_mtlt_txn_id ROWID := '-1'; -- stores the rowid to identify row in MTLT
8:
9: TYPE mmtt_tab IS TABLE OF MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
10: INDEX BY BINARY_INTEGER;
11: g_mmtt_tbl mmtt_tab;
12:
13: TYPE mtlt_tab IS TABLE OF MTL_TRANSACTION_LOTS_TEMP%ROWTYPE

Line 250: ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

246: PROCEDURE log_transaction_rec(
247: p_mtli_lot_rec IN MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE
248: ,p_mti_trx_rec IN MTL_TRANSACTIONS_INTERFACE%ROWTYPE
249: ,p_mtlt_lot_rec IN MTL_TRANSACTION_LOTS_TEMP%ROWTYPE
250: ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
251: ,p_table IN NUMBER
252: );
253:
254: PROCEDURE get_lot_expiration_date

Line 258: ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

254: PROCEDURE get_lot_expiration_date
255: ( p_mtli_lot_rec IN MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE
256: ,p_mti_trx_rec IN MTL_TRANSACTIONS_INTERFACE%ROWTYPE
257: ,p_mtlt_lot_rec IN MTL_TRANSACTION_LOTS_TEMP%ROWTYPE
258: ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
259: ,p_table IN NUMBER
260: ,x_lot_expiration_date OUT NOCOPY DATE
261: ,x_return_status OUT NOCOPY VARCHAR2
262: );