The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_update_cln_event VARCHAR2(100);
l_update_cln_parameter_list wf_parameter_list_t;
select concatenated_segments
from cln_procat_catitem_v cpcv, ecx_tp_headers eth
where cpcv.list_header_id=p_list_header_id
and cpcv.party_id=eth.party_id
and eth.tp_header_id = p_tp_header_id
and cpcv.organization_id = l_inv_org_id
and (p_category_id is null or p_category_id in (select mcsvc.category_id from mtl_item_categories mic,
mtl_category_set_valid_cats mcsvc where mcsvc.category_id = mic.category_id
and mcsvc.category_set_id = mic.category_set_id and mic.inventory_item_id=cpcv.inventory_item_id
and mic.organization_id=cpcv.organization_id))
and ( p_from_items is null or cpcv.concatenated_segments>=p_from_items)
and ( p_to_items is null or cpcv.concatenated_segments<=p_to_items)
order by concatenated_segments;
l_update_cln_event := 'oracle.apps.cln.ch.collaboration.update';
l_update_cln_parameter_list := wf_parameter_list_t();
select eth.party_id, eth.party_site_id
into party_id, party_site_id
from ecx_tp_headers eth
where eth.tp_header_id = p_tp_header_id;
select FND_PROFILE.VALUE('ORG_ID')
into l_operating_unit_id
from dual;
select haou.name, hla.ece_tp_location_code
into l_publisher_name, l_publisher_partnridx
from hr_all_organization_units haou, hr_locations_all hla
where haou.location_id = hla.location_id
and haou.organization_id = l_operating_unit_id;
SELECT CLN_SYNCCTLG_S.nextval into l_syncctlg_seq from dual;
SELECT sysdate into l_date from dual;
l_update_cln_parameter_list := wf_parameter_list_t();
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
x_progress := 'CLN_SYNCITEM_PKG.Syncctlg_Raise_Event : Initialize update event parameters';
wf_event.raise(p_event_name => l_update_cln_event,
p_event_key => l_event_key,
p_parameters => l_update_cln_parameter_list);
x_progress := 'CLN_SYNCITEM_PKG.Syncctlg_Raise_Event : Update Event Raised';
SELECT CLN_SYNCCTLG_S.nextval into l_syncctlg_seq from dual;
SELECT sysdate into l_date from dual;
l_update_cln_parameter_list := wf_parameter_list_t();
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
p_parameterlist => l_update_cln_parameter_list);
x_progress := 'CLN_SYNCCTLG_PKG.Syncctlg_Raise_Event : Initialized update event parameters';
wf_event.raise(p_event_name => l_update_cln_event,
p_event_key => l_event_key,
p_parameters => l_update_cln_parameter_list);
x_progress := 'CLN_SYNCCTLG_PKG.Syncctlg_Raise_Event : Update Event Raised';