[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pps.set_id
from pay_parameter_sets pps,
pay_parameters pp,
pay_parameter_definitions ppd,
PER_BUSINESS_GROUPS pbg
where ppd.parameter_name = p_set_name
and ppd.parameter_def_id = pp.parameter_def_id
and pp.parameter_id = pps.set_name_id
AND pps.business_group_id = pbg.business_group_id(+)
and nvl(pbg.name,'CORE') = nvl(p_bg_name,'CORE')
and nvl(pps.legislation_code,'CORE') = nvl(p_leg_code,'CORE') ;
select pp.parameter_id
from PAY_PARAMETERS pp,
PAY_PARAMETER_DEFINITIONS ppd
where ppd.parameter_name = p_set_name
and ppd.parameter_def_id = pp.parameter_def_id;
select business_group_id
into l_business_group_id
from per_business_groups
where name = p_bg_name;
UPDATE PAY_PARAMETER_SETS SET
description = p_desc
, wrapper_pkg = p_wrap_pkg
, LAST_UPDATED_BY = decode(p_owner,'SEED',1,0)
, LAST_UPDATE_DATE = SYSDATE
, LAST_UPDATE_LOGIN = fnd_global.login_id
WHERE set_id = l_set_id ;
INSERT INTO PAY_PARAMETER_SETS (
set_id
, set_name_id
, description
, wrapper_pkg
, business_group_id
, legislation_code
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,CREATION_DATE
,CREATED_BY )
VALUES (
PAY_PARAMETER_SETS_S.nextval
, l_set_name_id
, p_desc
, p_wrap_pkg
, l_business_group_id
, p_leg_code
, decode(p_owner,'SEED',1,0)
, SYSDATE
, fnd_global.login_id
, SYSDATE
, decode(p_owner,'SEED',1,0) );
select psv.set_variable_id
from pay_para_set_variables psv,
pay_parameter_sets pps,
pay_parameters pp1,
pay_parameters pp2,
pay_parameter_definitions ppd1,
pay_parameter_definitions ppd2,
per_business_groups pbg
where ppd1.parameter_name = p_set_name
and ppd1.parameter_def_id = pp1.parameter_def_id
and pp1.parameter_id = pps.set_name_id
and pps.set_id = psv.set_id
and psv.parameter_id = pp2.parameter_id
and pp2.parameter_def_id = ppd2.parameter_def_id
and ppd2.parameter_name = p_param_name
and psv.group_id = p_group_id
AND psv.business_group_id = pbg.business_group_id(+)
and nvl(pbg.name,'CORE') = nvl(p_bg_name,'CORE')
and nvl(psv.legislation_code,'CORE') = nvl(p_leg_code,'CORE') ;
select pp.parameter_id
from pay_parameters pp,
pay_parameter_definitions ppd
where ppd.parameter_name = l_parameter_name
and ppd.parameter_def_id = pp.parameter_def_id;
select pps.set_id
from PAY_PARAMETERS pp,
PAY_PARAMETER_DEFINITIONS ppd,
pay_parameter_sets pps
where ppd.parameter_name = p_set_name
and ppd.parameter_def_id = pp.parameter_def_id
and pp.parameter_id = pps.set_name_id;
select business_group_id
into l_business_group_id
from per_business_groups
where name = p_bg_name;
UPDATE PAY_PARA_SET_VARIABLES SET
set_var_sequence = p_set_var_seq
, variable_type = p_var_type
, default_type = p_def_type
, default_value = p_def_value
, display_flag = p_disp_flag
, description = p_desc
,LAST_UPDATED_BY = decode(p_owner,'SEED',1,0)
,LAST_UPDATE_DATE = SYSDATE
,LAST_UPDATE_LOGIN = fnd_global.login_id
WHERE set_variable_id = l_set_variable_id ;
hr_utility.trace('Before inserting, l_set_id : '||l_set_id);
INSERT INTO PAY_PARA_SET_VARIABLES (
set_variable_id
, set_id
, parameter_id
, group_id
, variable_type
, default_type
, default_value
, display_flag
, set_var_sequence
, description
, business_group_id
, legislation_code
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,CREATION_DATE
,CREATED_BY )
VALUES (
PAY_PARA_SET_VARIABLES_S.nextval
, l_set_id
, l_parameter_id
, p_group_id
, p_var_type
, p_def_type
, p_def_value
, p_disp_flag
, p_set_var_seq
, p_desc
, l_business_group_id
, p_leg_code
, decode(p_owner,'SEED',1,0)
, SYSDATE
, fnd_global.login_id
, SYSDATE
, decode(p_owner,'SEED',1,0) );
select psov.shared_variable_id
from pay_para_set_override_vars psov,
pay_para_set_variables psv_flow,
pay_para_set_variables psv_set,
pay_parameter_sets pps_flow,
pay_parameter_sets pps_set,
pay_parameters pp_flow,
pay_parameters pp_flow_param,
pay_parameters pp_set,
pay_parameters pp_set_param,
pay_parameter_definitions ppd_flow,
pay_parameter_definitions ppd_flow_param,
pay_parameter_definitions ppd_set,
pay_parameter_definitions ppd_set_param,
per_business_groups pbg
where ppd_flow.parameter_name = p_flow_name
and ppd_flow.parameter_def_id = pp_flow.parameter_def_id
and pp_flow.parameter_id = pps_flow.set_name_id
and pps_flow.set_id = psv_flow.set_id
and psv_flow.set_variable_id = psov.source_set_var_id
and psov.destin_set_var_id = psv_set.set_variable_id
and psv_set.set_id = pps_set.set_id
and pps_set.set_name_id = pp_set.parameter_id
and pp_set.parameter_def_id = ppd_set.parameter_def_id
and ppd_set.parameter_name = p_set_name
and psv_flow.parameter_id = pp_flow_param.parameter_id
and pp_flow_param.parameter_def_id = ppd_flow_param.parameter_def_id
and ppd_flow_param.parameter_name = p_flow_param
and psv_set.parameter_id = pp_set_param.parameter_id
and pp_set_param.parameter_def_id = ppd_set_param.parameter_def_id
and ppd_set_param.parameter_name = p_set_param
AND psov.business_group_id = pbg.business_group_id(+)
and nvl(pbg.name,'CORE') = nvl(p_bg_name,'CORE')
and nvl(psov.legislation_code,'CORE') = nvl(p_leg_code,'CORE') ;
select psv.set_variable_id
from pay_parameters pp1,
pay_parameters pp2,
pay_parameter_definitions ppd1,
pay_parameter_definitions ppd2,
pay_parameter_sets pps,
pay_para_set_variables psv
where ppd1.parameter_name = p_flow_or_set_name
and ppd1.parameter_def_id = pp1.parameter_def_id
and pp1.parameter_id = pps.set_name_id
and pps.set_id = psv.set_id
and ppd2.parameter_name = p_param_name
and ppd2.parameter_def_id = pp2.parameter_def_id
and psv.parameter_id = pp2.parameter_id ;
select business_group_id
into l_business_group_id
from per_business_groups
where name = p_bg_name;
INSERT INTO PAY_PARA_SET_OVERRIDE_VARS (
shared_variable_id
, source_set_var_id
, destin_set_var_id
, business_group_id
, legislation_code
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,CREATION_DATE
,CREATED_BY )
VALUES (
PAY_PARA_SET_OVERRIDE_VARS_S.nextval
, l_source_set_var_id
, l_destin_set_var_id
, l_business_group_id
, p_leg_code
, decode(p_owner,'SEED',1,0)
, SYSDATE
, fnd_global.login_id
, SYSDATE
, decode(p_owner,'SEED',1,0) );
select ppf.process_flow_id
from pay_process_flows ppf,
pay_parameter_sets pps,
pay_parameters pp,
pay_parameter_definitions ppd,
per_business_groups pbg
where ppd.parameter_name = p_flow_name
and ppd.parameter_def_id = pp.parameter_def_id
and pp.parameter_id = pps.set_name_id
and pps.set_id = ppf.set_id
AND ppf.business_group_id = pbg.business_group_id(+)
and nvl(pbg.name,'CORE') = nvl(p_bg_name,'CORE')
and nvl(ppf.legislation_code,'CORE') = nvl(p_leg_code,'CORE');
select pps.set_id
from PAY_PARAMETERS pp,
PAY_PARAMETER_DEFINITIONS ppd,
pay_parameter_sets pps
where ppd.parameter_name = flow_name
and ppd.parameter_def_id = pp.parameter_def_id
and pp.parameter_id = pps.set_name_id;
select business_group_id
into l_business_group_id
from per_business_groups
where name = p_bg_name;
UPDATE PAY_PROCESS_FLOWS SET
initialization_procedure = p_init_proc
,description = p_desc
,LAST_UPDATED_BY = decode(p_owner,'SEED',1,0)
,LAST_UPDATE_DATE = SYSDATE
,LAST_UPDATE_LOGIN = fnd_global.login_id
WHERE process_flow_id = l_process_flow_id ;
INSERT INTO PAY_PROCESS_FLOWS (
process_flow_id
, set_id
, description
, initialization_procedure
, business_group_id
, legislation_code
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,CREATION_DATE
,CREATED_BY )
VALUES (
PAY_PROCESS_FLOWS_S.nextval
, l_set_id
, p_desc
, p_init_proc
, l_business_group_id
, p_leg_code
, decode(p_owner,'SEED',1,0)
, SYSDATE
, fnd_global.login_id
, SYSDATE
, decode(p_owner,'SEED',1,0));
select pfs.process_flow_set_id
from pay_process_flow_sets pfs,
pay_process_flows ppf,
pay_parameter_sets pps1,
pay_parameter_sets pps2,
pay_parameters pp1,
pay_parameters pp2,
pay_parameter_definitions ppd1,
pay_parameter_definitions ppd2,
per_business_groups pbg
where ppd1.parameter_name = p_flow_name
and ppd1.parameter_def_id = pp1.parameter_def_id
and pp1.parameter_id = pps1.set_name_id
and pps1.set_id = ppf.set_id
and ppf.process_flow_id = pfs.process_flow_id
and pfs.set_id = pps2.set_id
and pps2.set_name_id = pp2.parameter_id
and pp2.parameter_def_id = ppd2.parameter_def_id
and ppd2.parameter_name = p_set_name
AND pfs.business_group_id = pbg.business_group_id(+)
and nvl(pbg.name,'CORE') = nvl(p_bg_name,'CORE')
and nvl(pfs.legislation_code,'CORE') = nvl(p_leg_code,'CORE');
select ppf.process_flow_id
from pay_process_flows ppf,
pay_parameter_sets pps,
PAY_PARAMETERS pp,
PAY_PARAMETER_DEFINITIONS ppd
where ppd.parameter_name = p_flow_name
and ppd.parameter_def_id = pp.parameter_def_id
and pp.parameter_id = pps.set_name_id
and pps.set_id = ppf.set_id;
select pps.set_id
from PAY_PARAMETERS pp,
PAY_PARAMETER_DEFINITIONS ppd,
pay_parameter_sets pps
where ppd.parameter_name = p_set_name
and ppd.parameter_def_id = pp.parameter_def_id
and pp.parameter_id = pps.set_name_id;
select business_group_id
into l_business_group_id
from per_business_groups
where name = p_bg_name;
UPDATE PAY_PROCESS_FLOW_SETS SET
process_flow_seq = p_proc_flow_seq
,LAST_UPDATED_BY = decode(p_owner,'SEED',1,0)
,LAST_UPDATE_DATE = SYSDATE
,LAST_UPDATE_LOGIN = fnd_global.login_id
WHERE process_flow_set_id = l_process_flow_set_id ;
hr_utility.trace('Before inserting, l_set_id: '|| l_set_id);
hr_utility.trace('Before inserting, l_process_flow_id: '|| l_process_flow_id);
INSERT INTO PAY_PROCESS_FLOW_SETS (
process_flow_set_id
, process_flow_id
, set_id
, process_flow_seq
, business_group_id
, legislation_code
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,CREATION_DATE
,CREATED_BY )
VALUES (
PAY_PROCESS_FLOW_SETS_S.nextval
, l_process_flow_id
, l_set_id
, p_proc_flow_seq
, l_business_group_id
, p_leg_code
, decode(p_owner,'SEED',1,0)
, SYSDATE
, fnd_global.login_id
, SYSDATE
, decode(p_owner,'SEED',1,0) );