APPS.HRDPP_CREATE_BUSINESS_GROUP 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_LANGUAGE_CODE in varchar2
,P_DATE_FROM in date
,P_NAME in varchar2
,P_TYPE in varchar2
,P_INTERNAL_EXTERNAL_FLAG in varchar2
,P_SHORT_NAME in varchar2
,P_EMP_GEN_METHOD in varchar2
,P_APP_GEN_METHOD in varchar2
,P_CWK_GEN_METHOD in varchar2
,P_LEGISLATION_CODE in varchar2
,P_CURRENCY_CODE in varchar2
,P_FISCAL_YEAR_START in varchar2
,P_MIN_WORK_AGE in varchar2
,P_MAX_WORK_AGE in varchar2
,P_ORG_USER_KEY in varchar2
,P_LOCATION_CODE in varchar2
,P_GRADE_FLEX_STRU_CODE in varchar2
,P_GROUP_FLEX_STRU_CODE in varchar2
,P_JOB_FLEX_STRU_CODE in varchar2
,P_COST_FLEX_STRU_CODE in varchar2
,P_POSITION_FLEX_STRU_CODE in varchar2
,P_SECURITY_GROUP_NAME in varchar2
,P_COMPETENCE_FLEX_STRU_CODE in varchar2) is
blid number := p_data_pump_batch_line_id;

Line: 109

delete from hr_pump_batch_lines where batch_line_id = blid;

Line: 110

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

Line: 113

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
,pval018
,pval019
,pval020
,pval021
,pval022
,pval023
,pval024
,pval025)
values
(p_batch_id
,nvl(blid,hr_pump_batch_lines_s.nextval)
,p_data_pump_business_grp_name
,3171
,'U'
,p_user_sequence
,p_link_value
,dc(P_EFFECTIVE_DATE)
,P_LANGUAGE_CODE
,dc(P_DATE_FROM)
,P_NAME
,P_TYPE
,P_INTERNAL_EXTERNAL_FLAG
,P_SHORT_NAME
,P_EMP_GEN_METHOD
,P_APP_GEN_METHOD
,P_CWK_GEN_METHOD
,P_LEGISLATION_CODE
,P_CURRENCY_CODE
,P_FISCAL_YEAR_START
,P_MIN_WORK_AGE
,P_MAX_WORK_AGE
,P_ORG_USER_KEY
,P_LOCATION_CODE
,P_GRADE_FLEX_STRU_CODE
,P_GROUP_FLEX_STRU_CODE
,P_JOB_FLEX_STRU_CODE
,P_COST_FLEX_STRU_CODE
,P_POSITION_FLEX_STRU_CODE
,P_SECURITY_GROUP_NAME
,P_COMPETENCE_FLEX_STRU_CODE);

Line: 177

end insert_batch_lines;

Line: 183

select l.rowid myrowid,
decode(l.pval001,cn,dn,d(l.pval001)) p1,
decode(l.pval002,cn,vn,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,
 hr_pump_get.gl(l.pval005,'ORG_TYPE',d(l.pval001),l.pval002)) p5,
decode(l.pval006,cn,vn,
 hr_pump_get.gl(l.pval006,'INTL_EXTL',d(l.pval001),l.pval002)) p6,
decode(l.pval007,cn,vn,l.pval007) p7,
decode(l.pval008,cn,vn,
 hr_pump_get.gl(l.pval008,'EMP_NUM_GEN_METHOD',d(l.pval001),l.pval002)) p8,
decode(l.pval009,cn,vn,l.pval009) p9,
decode(l.pval010,cn,vn,
 hr_pump_get.gl(l.pval010,'CWK_NUM_GEN_METHOD',d(l.pval001),l.pval002)) p10,
decode(l.pval011,cn,vn,l.pval011) p11,
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,
l.pval016 p16,
l.pval017 p17,
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,vn,l.pval022) p22,
decode(l.pval023,cn,vn,l.pval023) p23,
decode(l.pval024,cn,vn,l.pval024) p24,
decode(l.pval025,cn,vn,l.pval025) p25
from hr_pump_batch_lines l
where l.batch_line_id = p_batch_line_id;

Line: 318

update hr_pump_batch_lines l set
l.pval016 = decode(c.p16,null,cn,c.p16),
l.pval017 = decode(c.p17,null,cn,c.p17)
where l.rowid = c.myrowid;