DBA Data[Home] [Help]

APPS.IGI_IAC_CREATE_ASSETS dependencies on IGI_IAC_EXCEPTIONS

Line 162: INSERT INTO igi_iac_exceptions (revaluation_id,

158: l_str:=fnd_message.get;
159: fnd_file.put_line(FND_FILE.LOG,l_str);
160: END IF;
161:
162: INSERT INTO igi_iac_exceptions (revaluation_id,
163: asset_id,
164: category_id,
165: book_type_code,
166: exception_message,

Line 182: FROM igi_iac_exceptions

178: sysdate,
179: l_user_id
180: FROM sys.dual
181: WHERE NOT EXISTS(SELECT 'X'
182: FROM igi_iac_exceptions
183: WHERE revaluation_id = p_revaluation_id
184: AND book_type_code = p_book_type_code
185: AND category_id = p_category_id
186: AND asset_id = p_asset_id);