APPS.HRDPP_PROCESS_DEPENDENT 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_LIFE_EVENT_DATE in date
,P_EFFECTIVE_DATE in date
,P_CVG_STRT_DT in date default null
,I_CVG_STRT_DT in varchar2 default 'N'
,P_CVG_THRU_DT in date default null
,I_CVG_THRU_DT in varchar2 default 'N'
,P_MULTI_ROW_ACTN in boolean default null
,P_RECORD_TYP_CD in varchar2
,P_EMPLOYEE_NUMBER in varchar2
,P_NATIONAL_IDENTIFIER in varchar2
,P_FULL_NAME in varchar2
,P_DATE_OF_BIRTH in date
,P_PERSON_NUM in number
,P_PROGRAM in varchar2 default null
,P_PROGRAM_NUM in number default null
,I_PROGRAM_NUM in varchar2 default 'N'
,P_PLAN in varchar2 default null
,P_PLAN_NUM in number default null
,I_PLAN_NUM in varchar2 default 'N'
,P_OPTION in varchar2 default null
,P_OPTION_NUM in number default null
,I_OPTION_NUM in varchar2 default 'N'
,P_LIFE_EVENT_REASON in varchar2
,P_CON_EMPLOYEE_NUMBER in varchar2
,P_CON_NATIONAL_IDENTIFIER in varchar2
,P_CON_FULL_NAME in varchar2
,P_CON_DATE_OF_BIRTH in date
,P_CON_PERSON_NUM in number) is
blid number := p_data_pump_batch_line_id;

Line: 121

delete from hr_pump_batch_lines where batch_line_id = blid;

Line: 122

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

Line: 125

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
,pval004
,pval005
,pval006
,pval007
,pval008
,pval009
,pval010
,pval011
,pval012
,pval013
,pval014
,pval015
,pval016
,pval017
,pval018
,pval019
,pval020
,pval021
,pval022
,pval023)
values
(p_batch_id
,nvl(blid,hr_pump_batch_lines_s.nextval)
,p_data_pump_business_grp_name
,3846
,'U'
,p_user_sequence
,p_link_value
,dc(P_LIFE_EVENT_DATE)
,dc(P_EFFECTIVE_DATE)
,dd(P_CVG_STRT_DT,I_CVG_STRT_DT)
,dd(P_CVG_THRU_DT,I_CVG_THRU_DT)
,L_MULTI_ROW_ACTN
,P_RECORD_TYP_CD
,P_EMPLOYEE_NUMBER
,P_NATIONAL_IDENTIFIER
,P_FULL_NAME
,dc(P_DATE_OF_BIRTH)
,P_PERSON_NUM
,P_PROGRAM
,nd(P_PROGRAM_NUM,I_PROGRAM_NUM)
,P_PLAN
,nd(P_PLAN_NUM,I_PLAN_NUM)
,P_OPTION
,nd(P_OPTION_NUM,I_OPTION_NUM)
,P_LIFE_EVENT_REASON
,P_CON_EMPLOYEE_NUMBER
,P_CON_NATIONAL_IDENTIFIER
,P_CON_FULL_NAME
,dc(P_CON_DATE_OF_BIRTH)
,P_CON_PERSON_NUM);

Line: 187

end insert_batch_lines;

Line: 193

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,vn,dh,d(l.pval003)) p3,
l.pval003 d3,
decode(l.pval004,cn,dn,vn,dh,d(l.pval004)) p4,
l.pval004 d4,
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,
decode(l.pval008,cn,vn,l.pval008) p8,
decode(l.pval009,cn,vn,l.pval009) p9,
decode(l.pval010,cn,dn,d(l.pval010)) p10,
decode(l.pval011,cn,nn,n(l.pval011)) p11,
decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,
l.pval012 d12,
decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
l.pval013 d13,
decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
l.pval014 d14,
decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
l.pval015 d15,
decode(l.pval016,cn,vn,vn,vh,l.pval016) p16,
l.pval016 d16,
decode(l.pval017,cn,nn,vn,nh,n(l.pval017)) p17,
l.pval017 d17,
decode(l.pval018,cn,vn,l.pval018) p18,
decode(l.pval019,cn,vn,l.pval019) p19,
decode(l.pval020,cn,vn,l.pval020) p20,
decode(l.pval021,cn,vn,l.pval021) p21,
decode(l.pval022,cn,dn,d(l.pval022)) p22,
decode(l.pval023,cn,nn,n(l.pval023)) p23
from hr_pump_batch_lines l
where l.batch_line_id = p_batch_line_id;