DBA Data[Home] [Help]

APPS.PER_PQH_SHR dependencies on PQH_PSF_BUS

Line 93: l_open_state := pqh_psf_bus.open_status(p_position_id, p_effective_date);

89: hr_utility.set_location('Entering:'||l_proc, 5);
90: --
91: -- fetch open state
92: --
93: l_open_state := pqh_psf_bus.open_status(p_position_id, p_effective_date);
94: --
95: hr_utility.set_location(' Leaving:'||l_proc, 10);
96: --
97: return l_open_state;

Line 115: l_pending_action_flag := pqh_psf_bus.future_approved_actions(p_position_id);

111: hr_utility.set_location('Entering:'||l_proc, 5);
112: --
113: -- fetch future approved actions flag
114: --
115: l_pending_action_flag := pqh_psf_bus.future_approved_actions(p_position_id);
116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 10);
118: --
119: return l_pending_action_flag;

Line 138: pqh_psf_bus.per_abv_insert_validate(

134: --
135: begin
136: hr_utility.set_location('Entering:'||l_proc, 5);
137: --
138: pqh_psf_bus.per_abv_insert_validate(
139: p_assignment_id =>p_assignment_id,
140: p_value =>p_value,
141: p_unit =>p_unit,
142: p_effective_date =>p_effective_date);

Line 166: pqh_psf_bus.per_abv_update_validate(

162: --
163: begin
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: pqh_psf_bus.per_abv_update_validate(
167: p_abv_id =>p_abv_id,
168: p_assignment_id =>p_assignment_id,
169: p_value =>p_value,
170: p_unit =>p_unit,

Line 195: pqh_psf_bus.hr_psf_bus_insert_validate(p_rec, p_effective_date);

191: begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: --
194: if p_event = 'INSERT_VALIDATE' then
195: pqh_psf_bus.hr_psf_bus_insert_validate(p_rec, p_effective_date);
196: elsif p_event = 'UPDATE_VALIDATE' then
197: pqh_psf_bus.hr_psf_bus_update_validate(p_rec, p_effective_date, p_validation_start_date,p_validation_end_date, p_datetrack_mode );
198: end if;
199: --

Line 197: pqh_psf_bus.hr_psf_bus_update_validate(p_rec, p_effective_date, p_validation_start_date,p_validation_end_date, p_datetrack_mode );

193: --
194: if p_event = 'INSERT_VALIDATE' then
195: pqh_psf_bus.hr_psf_bus_insert_validate(p_rec, p_effective_date);
196: elsif p_event = 'UPDATE_VALIDATE' then
197: pqh_psf_bus.hr_psf_bus_update_validate(p_rec, p_effective_date, p_validation_start_date,p_validation_end_date, p_datetrack_mode );
198: end if;
199: --
200: hr_utility.set_location(' Leaving:'||l_proc, 10);
201: end;

Line 220: pqh_psf_bus.per_asg_bus_insert_validate(p_rec, p_effective_date);

216: begin
217: hr_utility.set_location('Entering:'||l_proc, 5);
218: --
219: if p_event = 'INSERT_VALIDATE' then
220: pqh_psf_bus.per_asg_bus_insert_validate(p_rec, p_effective_date);
221: elsif p_event = 'UPDATE_VALIDATE' then
222: pqh_psf_bus.per_asg_bus_update_validate(p_rec,
223: p_effective_date,
224: p_validation_start_date,

Line 222: pqh_psf_bus.per_asg_bus_update_validate(p_rec,

218: --
219: if p_event = 'INSERT_VALIDATE' then
220: pqh_psf_bus.per_asg_bus_insert_validate(p_rec, p_effective_date);
221: elsif p_event = 'UPDATE_VALIDATE' then
222: pqh_psf_bus.per_asg_bus_update_validate(p_rec,
223: p_effective_date,
224: p_validation_start_date,
225: p_validation_end_date,
226: p_datetrack_mode );

Line 228: pqh_psf_bus.per_asg_bus_delete_validate(

224: p_validation_start_date,
225: p_validation_end_date,
226: p_datetrack_mode );
227: elsif p_event = 'DELETE_VALIDATE' then
228: pqh_psf_bus.per_asg_bus_delete_validate(
229: p_rec => p_rec
230: ,p_effective_date => p_effective_date
231: ,p_validation_start_date => p_validation_start_date
232: ,p_validation_end_date => p_validation_end_date

Line 794: pqh_psf_bus.chk_position_budget(

790: --
791: if (p_event in ('POST_INSERT', 'POST_UPDATE')) then
792: if (p_rec.assignment_type = 'E') then
793: if (l_position_id <> nvl(l_old_position_id,-1)) then
794: pqh_psf_bus.chk_position_budget(
795: p_assignment_id => l_assignment_id,
796: p_effective_date => p_effective_date,
797: p_called_from => 'ASG',
798: p_old_position_id => l_old_position_id,