DBA Data[Home] [Help]

APPS.MTL_CC_TRANSACT_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 213: SELECT mtl_material_transactions_s.NEXTVAL

209: --inv_Debug.message('ssia', 'Transaction temp id is ' || TxnTempId);
210: --inv_Debug.message('ssia', 'Item id is ' || item_id);
211: --inv_Debug.message('ssia', 'Sub is ' ||sub);
212: IF (TxnTempId IS NULL) THEN
213: SELECT mtl_material_transactions_s.NEXTVAL
214: INTO l_transaction_temp_id
215: FROM dual;
216: ELSE
217: l_transaction_temp_id := TxnTempId;

Line 424: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

420:
421: -- If item is also serial controlled,
422: -- generate a serial transaction temp ID
423: IF (SerialNum IS NOT NULL) THEN
424: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
425: INTO l_serial_temp_id
426: FROM DUAL;
427: ELSE
428: l_serial_temp_id := NULL;