The following lines contain the word 'select', 'insert', 'update' or 'delete':
insert into hr_pump_batch_line_user_keys
(user_key_id, batch_line_id,user_key_value,unique_key_id)
values
(hr_pump_batch_line_user_keys_s.nextval,
p_batch_line_id,
p_user_key_value,
p_unique_key_id);
procedure insert_batch_lines
(p_batch_id in number
,p_data_pump_batch_line_id in number default null
,p_data_pump_business_grp_name in varchar2 default null
,p_user_sequence in number default null
,p_link_value in number default null
,P_EFFECTIVE_DATE in date
,P_DATETRACK_MODE in varchar2
,P_MULTI_ROW_ACTN in boolean default null
,P_CALLED_FROM in varchar2
,P_ELIG_CVRD_DPNT_USER_KEY in varchar2) is
blid number := p_data_pump_batch_line_id;
delete from hr_pump_batch_lines where batch_line_id = blid;
delete from hr_pump_batch_exceptions
where source_type = 'BATCH_LINE' and source_id = blid;
insert into hr_pump_batch_lines
(batch_id
,batch_line_id
,business_group_name
,api_module_id
,line_status
,user_sequence
,link_value
,pval003
,pval004
,pval005
,pval006
,pval007)
values
(p_batch_id
,nvl(blid,hr_pump_batch_lines_s.nextval)
,p_data_pump_business_grp_name
,608
,'U'
,p_user_sequence
,p_link_value
,dc(P_EFFECTIVE_DATE)
,P_DATETRACK_MODE
,L_MULTI_ROW_ACTN
,P_CALLED_FROM
,P_ELIG_CVRD_DPNT_USER_KEY);
end insert_batch_lines;
select l.rowid myrowid,
decode(l.pval001,cn,dn,d(l.pval001)) p1,
decode(l.pval002,cn,dn,d(l.pval002)) p2,
decode(l.pval003,cn,dn,d(l.pval003)) p3,
decode(l.pval004,cn,vn,l.pval004) p4,
decode(l.pval005,cn,vn,vn,null,l.pval005) p5,
l.pval005 d5,
decode(l.pval006,cn,vn,l.pval006) p6,
decode(l.pval007,cn,vn,l.pval007) p7
from hr_pump_batch_lines l
where l.batch_line_id = p_batch_line_id;
ben_elig_cvrd_dpnt_api.DELETE_ELIG_CVRD_DPNT
(p_validate => l_validate
,P_ELIG_CVRD_DPNT_ID => L_ELIG_CVRD_DPNT_ID
,P_EFFECTIVE_START_DATE => c.p1
,P_EFFECTIVE_END_DATE => c.p2
,P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER
,p_business_group_id => p_business_group_id
,P_EFFECTIVE_DATE => c.p3
,P_DATETRACK_MODE => c.p4
,P_MULTI_ROW_ACTN => L_MULTI_ROW_ACTN
,P_CALLED_FROM => c.p6);
update hr_pump_batch_lines l set
l.pval001 = decode(c.p1,null,cn,dc(c.p1)),
l.pval002 = decode(c.p2,null,cn,dc(c.p2))
where l.rowid = c.myrowid;