The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 1
from wf_item_attribute_values wiav
where wiav.item_type = p_item_type
and wiav.item_key = p_item_key
and wiav.name = p_name;
select transaction_ref_table into l_trans_ref_table
from hr_api_transactions
where item_type=itemtype and item_key=itemkey;
select t.item_type
into c_item_type
from hr_api_transactions t
where transaction_id=get_item_type.p_transaction_id;
select ts.item_type
into get_item_type.c_item_type
from hr_api_transaction_steps ts
where ts.transaction_id=get_item_type.p_transaction_id
and ts.item_type is not null and rownum <=1;
select t.item_key
into get_item_key.c_item_key
from hr_api_transactions t
where transaction_id=get_item_key.p_transaction_id;
select ts.item_key
into get_item_key.c_item_key
from hr_api_transaction_steps ts
where ts.transaction_id=get_item_key.p_transaction_id
and ts.item_type is not null and rownum <=1;
procedure update_approval_status ( itemtype in varchar2,
itemkey in varchar2,
actid in number,
funmode in varchar2,
result out nocopy varchar2 )
as
l_forward_to_person_id per_people_f.person_id%type;
ame_api.updateApprovalStatus2(applicationIdIn =>c_application_id,
transactionIdIn =>c_transaction_id,
approvalStatusIn =>ame_util.approvedStatus,
approverPersonIdIn =>l_forward_to_person_id,
approverUserIdIn =>null,
transactionTypeIn =>c_transaction_type,
forwardeeIn =>null);
WF_CORE.CONTEXT(g_package,'.update_approval_status',itemtype,itemkey,funmode);
end update_approval_status;
select start_date, end_date
from per_time_periods
where p_eff_date_csr > start_date
and p_eff_date_csr <= end_date
and payroll_id = p_payroll_id_csr;
select trs.transaction_step_id
,trs.api_name
,trs.item_type
,trs.item_key
,trs.activity_id
,trs.creator_person_id
from hr_api_transaction_steps trs
where trs.item_type = p_item_type
and trs.item_key = p_item_key
order by trs.processing_order
,trs.transaction_step_id ; --#2313279
SELECT pay_basis_id
FROM per_all_assignments_f
WHERE assignment_id = l_assignment_id
AND l_effective_date between effective_start_date
and effective_end_date
AND assignment_type = 'E';
-- HR_DEFER_UPDATE
-- Oracle Human Resources
-- HR:Defer Update After Approval
fnd_profile.get(name=>'HR_DEFER_UPDATE',val=>l_defer_commit);
SELECT process_activity
into ln_activityId
from
(select process_activity
FROM WF_ITEM_ACTIVITY_STATUSES IAS
WHERE ias.item_type = p_item_type
and ias.item_key = p_item_key
and ias.activity_status = 'NOTIFIED'
and ias.process_activity in (
select wpa.instance_id
FROM WF_PROCESS_ACTIVITIES WPA,
WF_ACTIVITY_ATTRIBUTES WAA,
WF_ACTIVITIES WA,
WF_ITEMS WI
WHERE wpa.process_item_type = ias.item_type
and wa.item_type = wpa.process_item_type
and wa.name = wpa.activity_name
and wi.item_type = ias.item_type
and wi.item_key = ias.item_key
and wi.begin_date >= wa.begin_date
and wi.begin_date < nvl(wa.end_date,wi.begin_date+1)
and waa.activity_item_type = wa.item_type
and waa.activity_name = wa.name
and waa.activity_version = wa.version
and waa.type = 'FORM'
)
order by begin_date desc)
where rownum<=1;
select item_type, item_key, process_activity
into lv_item_type, lv_item_key,lv_activity_id
from wf_item_activity_statuses
where notification_id = p_ntfid;
select substr(context,1,instr(context,':',1)-1)
,substr(context,instr(context,':')+1, ( instr(context,':',instr(context,':')+1 ) - instr(context,':')-1) )
into lv_item_type, lv_item_key
from wf_notifications
where notification_id = p_ntfid;
select nvl(status,'N'), nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N')
into lv_status, lv_profileValue
from hr_api_transactions
where item_type = lv_item_type
and item_key = lv_item_key;
select wma.display_name
into lv_link_label
from wf_notifications wn, wf_message_attributes_vl wma
where wn.notification_id = document_id
and wn.message_name = wma.message_name
and wma.message_type = lv_item_type
and wma.name = 'EDIT_TXN_URL';
select web_html_call,parameters
into lv_web_html_call,lv_params
from fnd_form_functions_vl
where function_name=lv_pageFunc;
select WNA.NUMBER_VALUE
into lvalue
from WF_NOTIFICATION_ATTRIBUTES WNA
where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
select WNA.TEXT_VALUE
into lvalue
from WF_NOTIFICATION_ATTRIBUTES WNA
where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
select hr_api_transactions.creator_person_id
into c_creator_person_id
from hr_api_transactions
where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
select hr_api_transactions.transaction_ref_table,hr_api_transactions.transaction_ref_id
into lv_transaction_ref_table,lv_transaction_ref_id
from hr_api_transactions
where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
select per_appraisals.main_appraiser_id
into c_creator_person_id
from per_appraisals
where per_appraisals.appraisal_id=getApprStartingPointPersonId.lv_transaction_ref_id;
procedure updateSFLTransaction (itemtype in varchar2,
itemkey in varchar2,
actid in number,
funmode in varchar2,
result out nocopy varchar2 )
as
-- -------------------------------------------------------------------------
-- local variables
-- -------------------------------------------------------------------------
c_proc varchar2(30) default 'updateSFLTransaction';
hr_utility.set_location(g_package ||'.updateSFLTransaction called in funmode:'||funmode, 50);
WF_CORE.CONTEXT(g_package,'.updateSFLTransaction',itemtype,itemkey,funmode);
end updateSFLTransaction;
SELECT wrpv.display_name displayName
into getProcessDisplayName.lv_display_name
FROM wf_runnable_processes_v wrpv
WHERE wrpv.item_type = itemtype
AND wrpv.process_name = wf_engine.GetItemAttrText (itemtype,itemkey,'PROCESS_NAME')
AND rownum <=1;
IF lv_exists <>'N' AND lv_isvalid <>'DELETED' THEN
ln_nextApprover_person_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type,
itemkey => p_item_key,
aname => lv_item_name
);
select RECIPIENT_ROLE, ORIGINAL_RECIPIENT, FROM_ROLE, MORE_INFO_ROLE
into recipient, orig_recipient, from_role, more_info_role
from WF_NOTIFICATIONS WN
where WN.NOTIFICATION_ID = p_nid;