APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_PLIP_F

Line 2016: update ben_plip_f

2012: hr_utility.set_location('inside '||l_proc,10);
2013: hr_utility.set_location('bus_area is '||p_business_area,10);
2014: for r_upd_cpp in c_updated_cpp loop
2015: -- api is not called as we don't want to update ovn
2016: update ben_plip_f
2017: set ordr_num = null
2018: where plip_id = r_upd_cpp.information1;
2019: end loop;
2020: for r_cpp in c_cpp loop

Line 2060: hr_utility.set_location(' BEN_PLIP_F CREATE_PLAN_IN_PROGRAM ',20);

2056: l_effective_date := r_cpp.information2;
2057: begin
2058: if l_plip_id is null and r_cpp.dml_operation = 'INSERT'
2059: and l_pgm_id is not null and l_pl_id is not null then
2060: hr_utility.set_location(' BEN_PLIP_F CREATE_PLAN_IN_PROGRAM ',20);
2061: BEN_PLAN_IN_PROGRAM_API.CREATE_PLAN_IN_PROGRAM(
2062: P_EFFECTIVE_DATE => l_effective_date
2063: ,P_BUSINESS_GROUP_ID => p_business_group_id
2064: ,P_ALWS_UNRSTRCTD_ENRT_FLAG => nvl(r_CPP.INFORMATION15,'N')

Line 2145: hr_utility.set_location(' BEN_PLIP_F UPDATE_PLAN_IN_PROGRAM ',30);

2141: end if;
2142: elsif l_plip_id is not null and r_cpp.dml_operation = 'UPDATE'
2143: and l_ovn is not null and l_pgm_id is not null
2144: and l_pl_id is not null then
2145: hr_utility.set_location(' BEN_PLIP_F UPDATE_PLAN_IN_PROGRAM ',30);
2146: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
2147: if p_datetrack_mode <> 'CORRECTION' then
2148: l_dt_mode := get_update_mode(p_table_name => 'BEN_PLIP_F',
2149: p_key_column_name => 'PLIP_ID',

Line 2148: l_dt_mode := get_update_mode(p_table_name => 'BEN_PLIP_F',

2144: and l_pl_id is not null then
2145: hr_utility.set_location(' BEN_PLIP_F UPDATE_PLAN_IN_PROGRAM ',30);
2146: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
2147: if p_datetrack_mode <> 'CORRECTION' then
2148: l_dt_mode := get_update_mode(p_table_name => 'BEN_PLIP_F',
2149: p_key_column_name => 'PLIP_ID',
2150: p_key_column_value => l_plip_id,
2151: p_effective_date => l_effective_date);
2152: hr_utility.set_location(' dt mode is '||l_dt_mode,30);

Line 2156: l_db_ovn := get_ovn(p_table_name => 'BEN_PLIP_F',

2152: hr_utility.set_location(' dt mode is '||l_dt_mode,30);
2153: else
2154: l_dt_mode := p_datetrack_mode;
2155: end if;
2156: l_db_ovn := get_ovn(p_table_name => 'BEN_PLIP_F',
2157: p_key_column_name => 'PLIP_ID',
2158: p_key_column_value => l_plip_id,
2159: p_effective_date => l_effective_date);
2160: hr_utility.set_location(' ovn is '||l_db_ovn,30);