The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DECODE(rollup_type,'RCAM','RCAM','CAMP') object_type,
user_status_id,
object_version_number,
status_code,
custom_setup_id,
null
FROM ams_campaigns_all_b
WHERE campaign_id = p_object_id;
SELECT 'CSCH',
user_status_id,
object_version_number,
status_code,
custom_setup_id,
null
FROM ams_campaign_schedules_vl
WHERE schedule_id = p_object_id;
SELECT 'EVEH',
user_status_id,
object_version_number,
system_status_code,
setup_type_id,
null
FROM ams_event_headers_vl
WHERE event_header_id = p_object_id;
SELECT event_object_type,
user_status_id,
object_version_number,
system_status_code,
setup_type_id,
null
FROM ams_event_offers_vl
WHERE event_offer_id = p_object_id
AND event_object_type = p_object_type;
SELECT 'DELV',
user_status_id,
object_version_number,
status_code,
custom_setup_id,
null
FROM ams_deliverables_vl
WHERE deliverable_id = p_object_id;
SELECT 'FUND',
user_status_id,
object_version_number,
status_code,
custom_setup_id,
null
FROM ozf_fund_details_v
WHERE fund_id = p_object_id;
SELECT 'FREQ',
user_status_id,
object_version_number,
status_code,
null,
null
FROM ozf_act_budgets
WHERE activity_budget_id = p_object_id;
SELECT 'PRIC',
user_status_id,
object_version_number,
status_code,
custom_setup_id,
null
FROM ozf_price_lists_v
WHERE list_header_id = p_object_id;
SELECT 'OFFR',
user_status_id,
object_version_number,
status_code,
custom_setup_id,
offer_type
FROM ozf_offers
WHERE qp_list_header_id = p_object_id;
SELECT 'CLAM',
user_status_id,
object_version_number,
status_code,
custom_setup_id,
null
FROM ozf_claims_all
WHERE claim_id = p_object_id;
ams_EventHeader_pvt.update_event_Header(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => p_validation_level,
p_evh_rec => l_eveh_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data ) ;
Ams_EventOffer_Pvt.update_event_offer(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => p_validation_level,
p_evo_rec => l_eveo_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data ) ;
Ams_Campaign_Pvt.update_campaign(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => p_validation_level,
p_camp_rec => l_camp_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data ) ;
Ams_Camp_Schedule_Pvt.update_camp_schedule(
p_api_version_number => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => p_validation_level,
p_schedule_rec => l_schedule_rec,
x_object_version_number => l_obj_ver_num,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data ) ;
Ams_Deliverable_Pvt.update_deliverable(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => p_validation_level,
p_deliv_rec => l_deliv_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data ) ;
Ozf_Funds_Pvt.update_fund(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => p_validation_level,
p_mode => jtf_plsql_api.g_update,
p_fund_rec => l_fund_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data ) ;
Ozf_ActBudgets_Pvt.update_act_budgets (
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => fnd_api.g_valid_level_full, -- full
p_act_budgets_rec => l_act_budgets_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data ) ;
l_pric_rec.operation := 'UPDATE';
l_modifier_list_rec.modifier_operation := 'UPDATE';
l_modifier_list_rec.offer_operation := 'UPDATE';
OZF_Claim_PVT.Update_Claim (
p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,p_commit => p_commit
,p_validation_level => p_validation_level
,x_return_status => x_return_status
,x_msg_data => x_msg_data
,x_msg_count => x_msg_count
,x_object_version_number => l_version
,p_claim => l_claim_rec
,p_event => 'UPDATE'
,p_mode => 'AUTO');