APPS.PQH_FR_EMP_STAT_SITUATION_API dependencies on PQH_FR_UTILITY

Line 143: l_dt_mode := pqh_fr_utility.get_datetrack_mode(p_effective_date => l_eff_dt

139: l_eff_dt := p_start_date;
140: END IF;
141: l_affect_asg_id := lr_affectations.assignment_id;
142: l_affect_ovn := lr_affectations.object_version_number;
143: l_dt_mode := pqh_fr_utility.get_datetrack_mode(p_effective_date => l_eff_dt
144: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
145: ,p_base_key_column => 'ASSIGNMENT_ID'
146: ,p_base_key_value => l_affect_asg_id);
147: --

Line 170: l_dt_mode := pqh_fr_utility.get_datetrack_mode(p_effective_date => p_start_date

166: END IF;
167: --
168: END LOOP;
169: --
170: l_dt_mode := pqh_fr_utility.get_datetrack_mode(p_effective_date => p_start_date
171: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
172: ,p_base_key_column => 'ASSIGNMENT_ID'
173: ,p_base_key_value => lr_career_rec.assignment_id);
174: --

Line 211: l_dt_mode := pqh_fr_utility.get_datetrack_mode(p_effective_date => l_eff_dt

207: l_eff_dt := p_start_date;
208: END IF;
209: l_affect_asg_id := lr_affectations.assignment_id;
210: l_affect_ovn := lr_affectations.object_version_number;
211: l_dt_mode := pqh_fr_utility.get_datetrack_mode(p_effective_date => l_eff_dt
212: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
213: ,p_base_key_column => 'ASSIGNMENT_ID'
214: ,p_base_key_value => lr_affectations.assignment_id);
215: --

Line 291: l_dt_mode := pqh_fr_utility.get_datetrack_mode(p_effective_date => p_start_date

287: END IF;
288: --
289: END LOOP;
290: --
291: l_dt_mode := pqh_fr_utility.get_datetrack_mode(p_effective_date => p_start_date
292: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
293: ,p_base_key_column => 'ASSIGNMENT_ID'
294: ,p_base_key_value => lr_career_rec.assignment_id);
295: --