[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 'P'
into param.mrcsobtype
from fa_book_controls
where book_type_code = book
and set_of_books_id = param.sob_id;
'farx_dp.bind(:CURSOR_SELECT);',
if mesg_name in ('FA_SHARED_DELETE_FAILED', 'FA_SHARED_INSERT_FAILED') then
fnd_message.set_token('TABLE', 'FA_DEPRN_REP_ITF', FALSE);
maj_select_statement varchar2(50);
min_select_statement varchar2(50);
spec_select_statement varchar2(50);
select category_flex_structure, location_flex_structure,
asset_key_flex_structure
into var.cat_flex_struct, var.loc_flex_struct, var.assetkey_flex_struct
from fa_system_controls;
select
bc.book_class,
bc.accounting_flex_structure,
bc.distribution_source_book,
substrb(sob.currency_code, 1, 15),
cur.precision,
bc.fiscal_year_name,
sob.chart_of_accounts_id,
substrb(sob.name, 1, 80),
decode(param.mrcsobtype, 'P', sob.set_of_books_id, param.sob_id) -- MRC
into var.book_class,
var.acct_flex_struct,
var.dist_source_book,
var.currency_code,
var.precision,
var.fy_name,
var.chart_of_accounts_id,
var.organization_name,
var.set_of_books_id
from fa_book_controls bc, gl_sets_of_books sob, fnd_currencies cur
WHERE bc.book_type_code = var.book
AND sob.set_of_books_id = decode(param.mrcsobtype, 'P', bc.set_of_books_id,
param.sob_id) -- MRC
AND sob.currency_code = cur.currency_code;
select period_counter, period_open_date,
nvl(period_close_date, sysdate),
decode(period_close_date, null, 'NO','YES'),
fiscal_year,
trunc(calendar_period_open_date), -- Bug3499862
trunc(calendar_period_close_date) -- Bug3499862
into var.period_counter, var.period_open_date, var.period_close_date,
period_closed, var.period_fy,
var.calendar_period_open_date,var.calendar_period_close_date -- Bug3499862
from fa_deprn_periods
where book_type_code = var.book
and period_name = var.period;
'SELECT', 'GL_BALANCING')||' between :from_bal and :to_bal)';
'SELECT', 'GL_ACCOUNT') || ' between :from_acct and :to_acct)';
'SELECT', 'FA_COST_CTR') ||' between :from_cc and :to_cc)';
'SELECT', 'BASED_CATEGORY') ||' between :from_maj_cat and :to_maj_cat)';
'SELECT', 'MINOR_CATEGORY') ||' between :from_min_cat and :to_min_cat)';
'SELECT', 'MINOR_CATEGORY') ||'>= :from_min_cat)';
'SELECT', 'MINOR_CATEGORY') ||'<= :to_min_cat )';
'SELECT',param.cat_seg_num) ||' between from_cat_seg_val and :to_cat_seg_val)';
maj_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', 'BASED_CATEGORY');
min_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', 'MINOR_CATEGORY');
min_select_statement := 'null';
spec_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', param.cat_seg_num);
spec_select_statement := 'null';
spec_select_statement := 'null';
fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
and exists (select 1
from fa_books oldbk
, fa_transaction_headers oldth
, fa_deprn_periods dp
where oldbk.transaction_header_id_out = books.transaction_header_id_in
and oldbk.transaction_header_id_out = oldth.transaction_header_id
and dp.book_type_code = :b_book
and dp.period_counter = dd.period_counter
and oldth.date_effective between dp.period_open_date
and nvl(dp.period_close_date, oldth.date_effective)
and oldbk.group_asset_id is null)
)
or (nvl(:b_report_style,''S'') = ''D'')
)
and dd.period_counter = rsv.period_counter ' || l_param_where ;
and exists (select 1
from fa_mc_books oldbk
, fa_transaction_headers oldth
, fa_mc_deprn_periods dp
where oldbk.transaction_header_id_out = books.transaction_header_id_in
and oldbk.transaction_header_id_out = oldth.transaction_header_id
and dp.book_type_code = :b_book
and dp.period_counter = dd.period_counter
and oldth.date_effective between dp.period_open_date
and nvl(dp.period_close_date, oldth.date_effective)
and oldbk.group_asset_id is null
and oldbk.set_of_books_id = :b_set_of_books_id
and dp.set_of_books_id = :b_set_of_books_id
)
)
or (nvl(:b_report_style,''S'') = ''D'')
)
and ds.set_of_books_id = :b_set_of_books_id
and dd.set_of_books_id = :b_set_of_books_id
and books.set_of_books_id = :b_set_of_books_id
and dd.period_counter = rsv.period_counter ' || l_param_where ;
mesg_name := 'FA_SHARED_INSERT_FAILED';