[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT *
FROM ams_act_products
WHERE act_product_used_by_id = p_src_act_id
AND arc_act_product_used_by = p_src_act_type;
SELECT *
FROM ams_act_messages
WHERE message_used_by_id = p_src_act_id
AND message_used_by = p_src_act_type;
SELECT *
FROM ams_object_associations
WHERE master_object_id = p_src_act_id
AND master_object_type = p_src_act_type ;
SELECT actual_exec_start_date
FROM ams_campaigns_v
WHERE campaign_id = p_src_act_id;
SELECT actual_exec_start_date
FROM ams_campaigns_v
WHERE campaign_id = p_new_act_id;
SELECT *
FROM ams_act_geo_areas
WHERE act_geo_area_used_by_id = p_src_act_id
AND arc_act_geo_area_used_by = p_src_act_type;
SELECT substr(location_name||','||location,1,240)
FROM ams_geoarea_scr_v
WHERE location_hierarchy_id = l_location_id
AND location_type_code = l_location_type;
SELECT *
FROM ams_act_resources
WHERE act_resource_used_by_id = p_src_act_id
AND arc_act_resource_used_by = p_src_act_type;
SELECT * FROM fnd_attached_documents
WHERE entity_name = p_src_act_type
AND pk1_value = p_src_act_id ;
SELECT b.datatype_id ,b.category_id ,b.security_type ,
b.publish_flag ,tl.description ,b.file_name ,
b.media_id ,tl.doc_attribute2 ,tl.language,tl.short_text,
DECODE(b.datatype_id,1,'TEXT',5,'URL',6,'FILE',3,'IMAGE') att_type
FROM fnd_documents b, fnd_documents_tl tl
WHERE b.document_id = tl.document_id
AND tl.language = USERENV('LANG')
AND b.document_id = l_doc_id ;
select short_text
from fnd_documents_short_text
where media_id = p_media_id;
SELECT *
FROM jtf_amv_attachments
WHERE attachment_used_by_id = p_src_act_id
AND attachment_used_by = p_src_act_type
AND document_id = p_doc_id
-- added by soagrawa on 25-jan-2002 to copy content
-- bug# 2175580
AND (attachment_type IN ('TEXT' , 'URL', 'FILE' ,'IMAGE'));
SELECT *
FROM ams_act_access a
WHERE act_access_to_object_id = p_src_act_id
AND arc_act_access_to_object = p_src_act_type
AND a.delete_flag = 'N'
AND NOT EXISTS (select 1 from ams_act_access b
WHERE b.act_access_to_object_id = p_new_act_id
AND b.arc_act_access_to_object = p_new_act_type
AND a.user_or_role_id = b.user_or_role_id
AND a.arc_user_or_role_type = b.arc_user_or_role_type
AND b.delete_flag = 'N'
) ;
SELECT *
FROM ams_act_market_segments
WHERE act_market_segment_used_by_id = p_src_act_id
AND arc_act_market_segment_used_by = p_src_act_type;
SELECT cell_name
from ams_cells_vl
where cell_id = l_segment_id ;
SELECT *
FROM ams_act_categories
WHERE act_category_used_by_id = p_src_act_id
AND arc_act_category_used_by = p_src_act_type;
SELECT *
FROM ams_act_delivery_methods
WHERE act_delivery_method_used_by_id = p_src_act_id
AND arc_act_delivery_used_by = p_src_act_type;
SELECT *
FROM ams_deliv_kit_items
WHERE deliverable_kit_id = p_src_deli_id;
SELECT *
INTO l_camp_sch_rec
FROM ams_campaign_schedules
WHERE campaign_schedule_id = p_src_camp_schedule_id;
SELECT *
FROM jtf_tasks_vl -- changed from _v for perf fixes
WHERE task_id = p_task_id;
SELECT *
FROM jtf_task_assignments
WHERE task_id = p_task_id;
SELECT *
FROM AMS_ACT_PARTNERS
WHERE act_partner_used_by_id = p_old_camp_id
AND arc_act_partner_used_by = 'CAMP';
PROCEDURE copy_list_select_actions (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_object_type IN VARCHAR2,
p_src_object_id IN NUMBER,
p_tar_object_id IN NUMBER
)
IS
L_API_NAME CONSTANT VARCHAR2(30) := 'copy_list_select_actions';
l_select_action_rec AMS_ListAction_PVT.action_rec_type;
l_select_action_id NUMBER;
SELECT *
FROM ams_list_select_actions
WHERE arc_action_used_by = p_object_type
AND action_used_by_id = p_object_id
ORDER BY order_number
;
SAVEPOINT copy_list_select_actions_pvt;
l_select_action_rec.arc_action_used_by := p_object_type;
l_select_action_rec.action_used_by_id := p_tar_object_id;
l_select_action_rec.order_number := l_source_rec.order_number;
l_select_action_rec.list_action_type := l_source_rec.list_action_type;
l_select_action_rec.arc_incl_object_from := l_source_rec.arc_incl_object_from;
l_select_action_rec.incl_object_id := l_source_rec.incl_object_id;
l_select_action_rec.rank := l_source_rec.rank;
p_action_rec => l_select_action_rec,
x_action_id => l_select_action_id
);
ROLLBACK TO copy_list_select_actions_pvt;
ROLLBACK TO copy_list_select_actions_pvt;
ROLLBACK TO copy_list_select_actions_pvt;
END copy_list_select_actions;
SELECT *
FROM AMS_ACT_PARTNERS
WHERE act_partner_used_by_id = p_old_id
AND arc_act_partner_used_by = p_type;
SELECT * FROM ams_campaign_Schedules_vl
WHERE campaign_id = p_old_camp_id ;
PROCEDURE copy_selected_schedule(
p_old_camp_id IN NUMBER,
p_new_camp_id IN NUMBER,
p_old_schedule_id IN NUMBER,
p_new_start_date IN DATE,
p_new_end_date IN DATE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
L_API_NAME CONSTANT VARCHAR2(30) := 'copy_act_schedules';
SELECT * FROM ams_campaign_Schedules_vl
WHERE campaign_id = p_old_camp_id
and schedule_id = p_old_schedule_id;
SELECT owner_user_id
FROM ams_campaigns_all_b
WHERE campaign_id = p_new_camp_id;
SELECT * FROM ams_event_offers_vl
WHERE event_offer_id = event_id ;
SELECT delivery_media_type_code
FROM ams_act_delivery_methods
WHERE activity_delivery_method_id = delv_id;
SELECT source_code
FROM ams_event_offers_all_b
WHERE event_offer_id = event_id;
END copy_selected_schedule ;
SELECT *
FROM jtf_amv_attachments
WHERE attachment_used_by_id = p_src_act_id
AND attachment_used_by = p_src_act_type
AND (attachment_type IN ('WEB_TEXT' ,'WEB_IMAGE'));
SELECT content_item_id
FROM ibc_associations
WHERE association_type_code = p_src_act_type
AND ASSOCIATED_OBJECT_VAL1 = to_char(p_src_act_id); -- fix for bug # 4145845
SELECT *
FROM jtf_tasks_vl
WHERE source_object_id = p_src_act_id
AND source_object_type_code = p_src_act_type;
select jtf_tasks_s.nextval into l_task_id from dual;
p_date_selected => task_rec.date_selected,
p_customer_id => task_rec.customer_id,
p_cust_account_id => task_rec.cust_account_id,
p_address_id => task_rec.address_id,
p_escalation_level => task_rec.escalation_level,
p_reference_flag => null,
p_location_id => task_rec.location_id,
p_enable_workflow => null,
p_abort_workflow => null,
p_task_split_flag => null);