APPS.FA_TERMINAL_GAIN_LOSS_PVT dependencies on FA_TRANSACTION_HEADERS

Line 58: from fa_transaction_headers th, fa_deprn_periods dp

54:
55: /*Bug# - 9018861 - To Check whether transaction has been created or not.*/
56: CURSOR c_get_trx_id IS
57: select transaction_header_id
58: from fa_transaction_headers th, fa_deprn_periods dp
59: where th.asset_id = l_asset_hdr_rec.asset_id
60: and th.book_type_code = l_asset_hdr_rec.book_type_code
61: and th.transaction_key = 'TG'
62: and th.calling_interface = 'FADEPR'

Line 163: fa_debug_pkg.add(l_db_title, 'INSERT', 'FA_TRANSACTION_HEADERS',

159:
160: l_date_effective := l_date_effective - (1/24/60/60);
161:
162: if (g_log_level_rec.statement_level) then
163: fa_debug_pkg.add(l_db_title, 'INSERT', 'FA_TRANSACTION_HEADERS',
164: p_log_level_rec => g_log_level_rec);
165: end if;
166:
167: /*Bug# - 9018861 - Since Deprn code calls this function for reporting book first,

Line 177: -- Proceed to process FA_TRANSACTION_HEADERS if this is primary book');

173:
174: l_trans_rec.who_info.last_update_date := l_date_effective;
175: l_trans_rec.who_info.creation_date := l_date_effective;
176: --
177: -- Proceed to process FA_TRANSACTION_HEADERS if this is primary book');
178: --
179: if l_trans_rec.transaction_header_id is null then
180: if (g_log_level_rec.statement_level) then
181: fa_debug_pkg.add(l_db_title, 'INSERT', 'FA_TRANSACTION_HEADERS',

Line 181: fa_debug_pkg.add(l_db_title, 'INSERT', 'FA_TRANSACTION_HEADERS',

177: -- Proceed to process FA_TRANSACTION_HEADERS if this is primary book');
178: --
179: if l_trans_rec.transaction_header_id is null then
180: if (g_log_level_rec.statement_level) then
181: fa_debug_pkg.add(l_db_title, 'INSERT', 'FA_TRANSACTION_HEADERS',
182: p_log_level_rec => g_log_level_rec);
183: end if;
184:
185: SELECT fa_transaction_headers_s.nextval

Line 185: SELECT fa_transaction_headers_s.nextval

181: fa_debug_pkg.add(l_db_title, 'INSERT', 'FA_TRANSACTION_HEADERS',
182: p_log_level_rec => g_log_level_rec);
183: end if;
184:
185: SELECT fa_transaction_headers_s.nextval
186: INTO l_trans_rec.transaction_header_id
187: FROM DUAL;
188:
189: l_trans_rec.transaction_subtype := 'AMORTIZED';

Line 226: FA_TRANSACTION_HEADERS_PKG.Insert_Row

222: raise tgl_err;
223: end if;
224:
225:
226: FA_TRANSACTION_HEADERS_PKG.Insert_Row
227: (X_Rowid => l_th_rowid,
228: X_Transaction_Header_Id => l_trans_rec.transaction_header_id,
229: X_Book_Type_Code => l_asset_hdr_rec.book_type_code,
230: X_Asset_Id => l_asset_hdr_rec.asset_id,

Line 270: fa_debug_pkg.add(l_db_title, 'Failed to insert ', 'FA_TRANSACTION_HEADERS',

266: X_Calling_Fn => l_calling_fn
267: ,p_log_level_rec => g_log_level_rec);
268: if not l_status then
269: if (g_log_level_rec.statement_level) then
270: fa_debug_pkg.add(l_db_title, 'Failed to insert ', 'FA_TRANSACTION_HEADERS',
271: p_log_level_rec => g_log_level_rec);
272: end if;
273: raise tgl_err;
274: end if;