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 241: ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

237: PROCEDURE log_transaction_rec(
238: p_mtli_lot_rec IN MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE
239: ,p_mti_trx_rec IN MTL_TRANSACTIONS_INTERFACE%ROWTYPE
240: ,p_mtlt_lot_rec IN MTL_TRANSACTION_LOTS_TEMP%ROWTYPE
241: ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
242: ,p_table IN NUMBER
243: );
244:
245: PROCEDURE get_lot_expiration_date

Line 249: ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

245: PROCEDURE get_lot_expiration_date
246: ( p_mtli_lot_rec IN MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE
247: ,p_mti_trx_rec IN MTL_TRANSACTIONS_INTERFACE%ROWTYPE
248: ,p_mtlt_lot_rec IN MTL_TRANSACTION_LOTS_TEMP%ROWTYPE
249: ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
250: ,p_table IN NUMBER
251: ,x_lot_expiration_date OUT NOCOPY DATE
252: ,x_return_status OUT NOCOPY VARCHAR2
253: );