[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select sob.chart_of_accounts_id
into h_chart_of_accounts_id
From fa_book_controls bc, gl_sets_of_books sob
Where sob.set_of_books_id = bc.set_of_books_id
And bc.book_type_code = p_book_type_code;
select *
from fa_distribution_history
where book_type_code = c_book_type_code
and asset_id = c_asset_id
and date_ineffective is null;
select CALENDAR_PERIOD_OPEN_DATE
into l_CALENDAR_PERIOD_OPEN_DATE
from fa_deprn_periods
where period_close_date is null
and book_type_code = l_book_type_code;
FA_ASSET_DESC_PUB.update_desc(p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
x_return_status => l_return_status,
x_msg_count => l_mesg_count,
x_msg_data => l_mesg,
p_calling_fn => 'process_capitalize',
px_trans_rec => l_trans_rec,
px_asset_hdr_rec => l_asset_hdr_rec,
px_asset_desc_rec_new => l_asset_desc_rec,
px_asset_cat_rec_new => l_asset_cat_rec);
select ACCOUNTING_FLEX_STRUCTURE
into l_ACCOUNTING_FLEX_STRUCTURE
from fa_book_controls
where book_type_code = l_book_type_code;
select Segment1,
Segment2,
Segment3,
Segment4,
Segment5,
Segment6,
Segment7,
Segment8,
Segment9,
Segment10,
Segment11,
Segment12,
Segment13,
Segment14,
Segment15,
Segment16,
Segment17,
Segment18,
Segment19,
Segment20,
Segment21,
Segment22,
Segment23,
Segment24,
Segment25,
Segment26,
Segment27,
Segment28,
Segment29,
Segment30,
enabled_flag
into l_segment(1),
l_segment(2),
l_segment(3),
l_segment(4),
l_segment(5),
l_segment(6),
l_segment(7),
l_segment(8),
l_segment(9),
l_segment(10),
l_segment(11),
l_segment(12),
l_segment(13),
l_segment(14),
l_segment(15),
l_segment(16),
l_segment(17),
l_segment(18),
l_segment(19),
l_segment(20),
l_segment(21),
l_segment(22),
l_segment(23),
l_segment(24),
l_segment(25),
l_segment(26),
l_segment(27),
l_segment(28),
l_segment(29),
l_segment(30),
l_gl_ccid_enabled_flag
from gl_code_combinations
where code_combination_id = dist_rec.code_combination_id;
l_asset_dist_tbl.delete;
select *
from fa_distribution_history
where book_type_code = c_book_type_code
and asset_id = c_asset_id
and date_ineffective is null;
select CALENDAR_PERIOD_OPEN_DATE
into l_CALENDAR_PERIOD_OPEN_DATE
from fa_deprn_periods
where period_close_date is null
and book_type_code = l_book_type_code;
FA_ASSET_DESC_PUB.update_desc(p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
x_return_status => l_return_status,
x_msg_count => l_mesg_count,
x_msg_data => l_mesg,
p_calling_fn => 'process_capitalize',
px_trans_rec => l_trans_rec,
px_asset_hdr_rec => l_asset_hdr_rec,
px_asset_desc_rec_new => l_asset_desc_rec,
px_asset_cat_rec_new => l_asset_cat_rec);
select ACCOUNTING_FLEX_STRUCTURE
into l_ACCOUNTING_FLEX_STRUCTURE
from fa_book_controls
where book_type_code = l_book_type_code;
select Segment1,
Segment2,
Segment3,
Segment4,
Segment5,
Segment6,
Segment7,
Segment8,
Segment9,
Segment10,
Segment11,
Segment12,
Segment13,
Segment14,
Segment15,
Segment16,
Segment17,
Segment18,
Segment19,
Segment20,
Segment21,
Segment22,
Segment23,
Segment24,
Segment25,
Segment26,
Segment27,
Segment28,
Segment29,
Segment30,
enabled_flag
into l_segment(1),
l_segment(2),
l_segment(3),
l_segment(4),
l_segment(5),
l_segment(6),
l_segment(7),
l_segment(8),
l_segment(9),
l_segment(10),
l_segment(11),
l_segment(12),
l_segment(13),
l_segment(14),
l_segment(15),
l_segment(16),
l_segment(17),
l_segment(18),
l_segment(19),
l_segment(20),
l_segment(21),
l_segment(22),
l_segment(23),
l_segment(24),
l_segment(25),
l_segment(26),
l_segment(27),
l_segment(28),
l_segment(29),
l_segment(30),
l_gl_ccid_enabled_flag
from gl_code_combinations
where code_combination_id = dist_rec.code_combination_id;
l_asset_dist_tbl.delete;
select cost
into l_asset_retire_rec.cost_retired
from fa_books
where book_type_code = l_book_type_code
and asset_id = p_asset_id
and transaction_header_id_out is null;