APPS.HRDPP_PROCESS_BENEFICIARY 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_BNFT_VAL in number default null
,I_BNFT_VAL in varchar2 default 'N'
,P_LIFE_EVENT_DATE in date
,P_EFFECTIVE_DATE in date
,P_DSGN_STRT_DT in date default null
,I_DSGN_STRT_DT in varchar2 default 'N'
,P_DSGN_THRU_DT in date default null
,I_DSGN_THRU_DT in varchar2 default 'N'
,P_PRMRY_CNTNGNT_CD in varchar2
,P_PCT_DSGD_NUM in number
,P_AMT_DSGD_VAL in number default null
,I_AMT_DSGD_VAL in varchar2 default 'N'
,P_AMT_DSGD_UOM in varchar2 default null
,P_ADDL_INSTRN_TXT in varchar2 default null
,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
,P_ORGANIZATION_NAME in varchar2 default null
,P_LANGUAGE_CODE in varchar2 default null
,P_TTEE_PERSON_USER_KEY in varchar2 default null) is
blid number := p_data_pump_batch_line_id;

Line: 132

delete from hr_pump_batch_lines where batch_line_id = blid;

Line: 133

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

Line: 136

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
,pval024
,pval025
,pval026
,pval027
,pval028
,pval029
,pval030
,pval031
,pval032)
values
(p_batch_id
,nvl(blid,hr_pump_batch_lines_s.nextval)
,p_data_pump_business_grp_name
,3847
,'U'
,p_user_sequence
,p_link_value
,nd(P_BNFT_VAL,I_BNFT_VAL)
,dc(P_LIFE_EVENT_DATE)
,dc(P_EFFECTIVE_DATE)
,dd(P_DSGN_STRT_DT,I_DSGN_STRT_DT)
,dd(P_DSGN_THRU_DT,I_DSGN_THRU_DT)
,P_PRMRY_CNTNGNT_CD
,P_PCT_DSGD_NUM
,nd(P_AMT_DSGD_VAL,I_AMT_DSGD_VAL)
,P_AMT_DSGD_UOM
,P_ADDL_INSTRN_TXT
,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
,P_ORGANIZATION_NAME
,P_LANGUAGE_CODE
,P_TTEE_PERSON_USER_KEY);

Line: 216

end insert_batch_lines;

Line: 222

select l.rowid myrowid,
decode(l.pval001,cn,nn,vn,nh,n(l.pval001)) p1,
l.pval001 d1,
decode(l.pval002,cn,dn,d(l.pval002)) p2,
decode(l.pval003,cn,dn,d(l.pval003)) p3,
decode(l.pval004,cn,dn,vn,dh,d(l.pval004)) p4,
l.pval004 d4,
decode(l.pval005,cn,dn,vn,dh,d(l.pval005)) p5,
l.pval005 d5,
decode(l.pval006,cn,vn,
 hr_pump_get.gl(l.pval006,'BEN_PRMRY_CNTNGNT',d(l.pval003),l.pval031)) p6,
decode(l.pval007,cn,nn,n(l.pval007)) p7,
decode(l.pval008,cn,nn,vn,nh,n(l.pval008)) p8,
l.pval008 d8,
decode(l.pval009,cn,vn,vn,vh,l.pval009) p9,
l.pval009 d9,
decode(l.pval010,cn,vn,vn,vh,l.pval010) p10,
l.pval010 d10,
decode(l.pval011,cn,vn,vn,null,l.pval011) p11,
l.pval011 d11,
decode(l.pval012,cn,vn,l.pval012) p12,
decode(l.pval013,cn,vn,l.pval013) p13,
decode(l.pval014,cn,vn,l.pval014) p14,
decode(l.pval015,cn,vn,l.pval015) p15,
decode(l.pval016,cn,dn,d(l.pval016)) p16,
decode(l.pval017,cn,nn,n(l.pval017)) p17,
decode(l.pval018,cn,vn,vn,vh,l.pval018) p18,
l.pval018 d18,
decode(l.pval019,cn,nn,vn,nh,n(l.pval019)) p19,
l.pval019 d19,
decode(l.pval020,cn,vn,vn,vh,l.pval020) p20,
l.pval020 d20,
decode(l.pval021,cn,nn,vn,nh,n(l.pval021)) p21,
l.pval021 d21,
decode(l.pval022,cn,vn,vn,vh,l.pval022) p22,
l.pval022 d22,
decode(l.pval023,cn,nn,vn,nh,n(l.pval023)) p23,
l.pval023 d23,
decode(l.pval024,cn,vn,l.pval024) p24,
decode(l.pval025,cn,vn,l.pval025) p25,
decode(l.pval026,cn,vn,l.pval026) p26,
decode(l.pval027,cn,vn,l.pval027) p27,
decode(l.pval028,cn,dn,d(l.pval028)) p28,
decode(l.pval029,cn,nn,n(l.pval029)) p29,
decode(l.pval030,cn,vn,vn,vh,l.pval030) p30,
l.pval030 d30,
decode(l.pval031,cn,vn,vn,vh,l.pval031) p31,
l.pval031 d31,
decode(l.pval032,cn,vn,vn,vn,l.pval032) p32,
l.pval032 d32
from hr_pump_batch_lines l
where l.batch_line_id = p_batch_line_id;