APPS.HRDPP_CREATE_USER_COLUMN_INSTA SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 66

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);

Line: 76

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_VALUE in varchar2 default null
,P_LEGISLATION_CODE in varchar2 default null
,P_USER_ROW_USER_KEY in varchar2
,P_USER_COLUMN_USER_KEY in varchar2) is
blid number := p_data_pump_batch_line_id;

Line: 90

delete from hr_pump_batch_lines where batch_line_id = blid;

Line: 91

delete from hr_pump_batch_exceptions
where source_type = 'BATCH_LINE' and source_id = blid;

Line: 94

insert into hr_pump_batch_lines
(batch_id
,batch_line_id
,business_group_name
,api_module_id
,line_status
,user_sequence
,link_value
,pval001
,pval002
,pval003
,pval008
,pval009)
values
(p_batch_id
,nvl(blid,hr_pump_batch_lines_s.nextval)
,p_data_pump_business_grp_name
,3047
,'U'
,p_user_sequence
,p_link_value
,dc(P_EFFECTIVE_DATE)
,P_VALUE
,P_LEGISLATION_CODE
,P_USER_ROW_USER_KEY
,P_USER_COLUMN_USER_KEY);

Line: 120

end insert_batch_lines;

Line: 126

select l.rowid myrowid,
decode(l.pval001,cn,dn,d(l.pval001)) p1,
decode(l.pval002,cn,vn,vn,vn,l.pval002) p2,
l.pval002 d2,
decode(l.pval003,cn,vn,vn,vn,l.pval003) p3,
l.pval003 d3,
l.pval004 p4,
l.pval005 p5,
decode(l.pval006,cn,dn,d(l.pval006)) p6,
decode(l.pval007,cn,dn,d(l.pval007)) p7,
decode(l.pval008,cn,vn,l.pval008) p8,
decode(l.pval009,cn,vn,l.pval009) p9
from hr_pump_batch_lines l
where l.batch_line_id = p_batch_line_id;

Line: 190

update hr_pump_batch_lines l set
l.pval004 = decode(c.p4,null,cn,c.p4),
l.pval005 = decode(c.p5,null,cn,c.p5),
l.pval006 = decode(c.p6,null,cn,dc(c.p6)),
l.pval007 = decode(c.p7,null,cn,dc(c.p7))
where l.rowid = c.myrowid;