[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ad.asset_id
from fa_distribution_history dh,
gl_code_combinations gc,
fa_additions ad,
fa_books bk,
fa_book_controls bc,
fa_maint_schedule_hdr msh
where msh.schedule_id = h_schedule_id
and bc.book_type_code = msh.book_type_code
and bc.book_class = 'CORPORATE'
and bk.book_type_code = msh.book_type_code
and bk.date_ineffective is null
and bk.period_counter_fully_retired is null
and bk.date_placed_in_service >=
nvl(msh.from_date_placed_in_service,bk.date_placed_in_service)
and bk.date_placed_in_service <=
nvl(msh.to_date_placed_in_service,bk.date_placed_in_service)
and bk.asset_id = ad.asset_id
and ad.asset_number >=
nvl(msh.from_asset_number, ad.asset_number)
and ad.asset_number <=
nvl(msh.to_asset_number, ad.asset_number)
and ad.asset_category_id =
nvl(msh.category_id, ad.asset_category_id)
and nvl(ad.asset_key_ccid,-9999) =
nvl(msh.asset_key_id, nvl(ad.asset_key_ccid,-9999))
and ad.asset_id = dh.asset_id
and dh.location_id = nvl(msh.location_id, dh.location_id)
and dh.date_ineffective is null
and dh.code_combination_id = gc.code_combination_id
group by ad.asset_id;
SELECT start_date,end_date,book_type_code
FROM fa_maint_schedule_hdr
WHERE schedule_id = h_schedule_id;
h_mesg_name := 'FA_SHARED_INSERT_FAILED';
insert_to_fa_maint_events(h_asset_id,
h_book_type_code,
events_table(i),
h_maint_date,
h_succeed);
h_mesg_name := 'FA_SHARED_INSERT_FAILED';
insert_to_fa_maint_events(h_asset_id,
h_book_type_code,
events_table(i),
h_maint_date,
h_succeed);
h_mesg_name := 'FA_SHARED_INSERT_FAILED';
h_mesg_name := 'FA_SHARED_INSERT_FAILED';
update fa_maint_schedule_hdr
set status = 'COMPLETED'
where schedule_id = h_schedule_id;
if (p_msg_name = 'FA_SHARED_INSERT_FAILED') then
fnd_message.set_token('TABLE','FA_MAINT_EVENTS',FALSE);
update fa_maint_schedule_hdr
set status = 'FAILED_RUN'
where schedule_id = p_sch_id;
select schedule_id,event_name,description,frequency_in_days,
maintenance_date,cost,employee_id,vendor_id,created_by,
creation_date,last_updated_by,last_update_login,last_update_date,
attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,
attribute7,attribute8,attribute9,attribute10,attribute11,attribute12,
attribute13,attribute14,attribute15,attribute_category
from fa_maint_schedule_dtl
where schedule_id = p_schedule_id;
p_events_tbl.delete;
procedure insert_to_fa_maint_events(
p_asset_id in number,
p_book_type_code in varchar2,
p_event_rec in event_rec_type,
p_maint_date in date,
p_succeed out nocopy boolean) is
h_status varchar2(10) := 'DUE';
insert into fa_maint_events
(asset_event_id,
asset_id,
event_name,
description,
frequency_in_days,
maintenance_date,
vendor_id,
employee_id,
cost,
book_type_code,
status,
schedule_id,
created_by,
creation_date,
last_updated_by,
last_update_login,
last_update_date,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute_category)
values
(fa_maint_events_s.nextval,
p_asset_id,
p_event_rec.event_name,
p_event_rec.description,
p_event_rec.frequency_in_days,
p_maint_date,
p_event_rec.vendor_id,
p_event_rec.employee_id,
p_event_rec.cost,
p_book_type_code,
h_status,
p_event_rec.schedule_id,
p_event_rec.created_by,
p_event_rec.creation_date,
p_event_rec.last_updated_by,
p_event_rec.last_update_login,
p_event_rec.last_update_date,
p_event_rec.attribute1,
p_event_rec.attribute2,
p_event_rec.attribute3,
p_event_rec.attribute4,
p_event_rec.attribute5,
p_event_rec.attribute6,
p_event_rec.attribute7,
p_event_rec.attribute8,
p_event_rec.attribute9,
p_event_rec.attribute10,
p_event_rec.attribute11,
p_event_rec.attribute12,
p_event_rec.attribute13,
p_event_rec.attribute14,
p_event_rec.attribute15,
p_event_rec.attribute_category);
end insert_to_fa_maint_events;