83: --
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: --
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: pqh_bpr_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: pqh_bpr_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: pqh_bpr_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: pqh_bpr_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: pqh_bpr_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: pqh_bpr_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: pqh_bpr_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: pqh_bpr_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: pqh_bpr_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: pqh_bpr_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: Raise;
101: End update_dml;
102: --
224: );
225: --
226: exception
227: --
228: when hr_api.cannot_find_prog_unit then
229: --
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'pqh_budget_periods'
232: ,p_hook_type => 'AU');
226: exception
227: --
228: when hr_api.cannot_find_prog_unit then
229: --
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'pqh_budget_periods'
232: ,p_hook_type => 'AU');
233: --
234: end;
294: -- p_rec plsql record structure
295: -- to see if a system default is being used. If a system default
296: -- is being used then we must set to the 'current' argument value.
297: --
298: If (p_rec.budget_detail_id = hr_api.g_number) then
299: p_rec.budget_detail_id :=
300: pqh_bpr_shd.g_old_rec.budget_detail_id;
301: End If;
302: If (p_rec.start_time_period_id = hr_api.g_number) then
298: If (p_rec.budget_detail_id = hr_api.g_number) then
299: p_rec.budget_detail_id :=
300: pqh_bpr_shd.g_old_rec.budget_detail_id;
301: End If;
302: If (p_rec.start_time_period_id = hr_api.g_number) then
303: p_rec.start_time_period_id :=
304: pqh_bpr_shd.g_old_rec.start_time_period_id;
305: End If;
306: If (p_rec.end_time_period_id = hr_api.g_number) then
302: If (p_rec.start_time_period_id = hr_api.g_number) then
303: p_rec.start_time_period_id :=
304: pqh_bpr_shd.g_old_rec.start_time_period_id;
305: End If;
306: If (p_rec.end_time_period_id = hr_api.g_number) then
307: p_rec.end_time_period_id :=
308: pqh_bpr_shd.g_old_rec.end_time_period_id;
309: End If;
310: If (p_rec.budget_unit1_percent = hr_api.g_number) then
306: If (p_rec.end_time_period_id = hr_api.g_number) then
307: p_rec.end_time_period_id :=
308: pqh_bpr_shd.g_old_rec.end_time_period_id;
309: End If;
310: If (p_rec.budget_unit1_percent = hr_api.g_number) then
311: p_rec.budget_unit1_percent :=
312: pqh_bpr_shd.g_old_rec.budget_unit1_percent;
313: End If;
314: If (p_rec.budget_unit2_percent = hr_api.g_number) then
310: If (p_rec.budget_unit1_percent = hr_api.g_number) then
311: p_rec.budget_unit1_percent :=
312: pqh_bpr_shd.g_old_rec.budget_unit1_percent;
313: End If;
314: If (p_rec.budget_unit2_percent = hr_api.g_number) then
315: p_rec.budget_unit2_percent :=
316: pqh_bpr_shd.g_old_rec.budget_unit2_percent;
317: End If;
318: If (p_rec.budget_unit3_percent = hr_api.g_number) then
314: If (p_rec.budget_unit2_percent = hr_api.g_number) then
315: p_rec.budget_unit2_percent :=
316: pqh_bpr_shd.g_old_rec.budget_unit2_percent;
317: End If;
318: If (p_rec.budget_unit3_percent = hr_api.g_number) then
319: p_rec.budget_unit3_percent :=
320: pqh_bpr_shd.g_old_rec.budget_unit3_percent;
321: End If;
322: If (p_rec.budget_unit1_value = hr_api.g_number) then
318: If (p_rec.budget_unit3_percent = hr_api.g_number) then
319: p_rec.budget_unit3_percent :=
320: pqh_bpr_shd.g_old_rec.budget_unit3_percent;
321: End If;
322: If (p_rec.budget_unit1_value = hr_api.g_number) then
323: p_rec.budget_unit1_value :=
324: pqh_bpr_shd.g_old_rec.budget_unit1_value;
325: End If;
326: If (p_rec.budget_unit2_value = hr_api.g_number) then
322: If (p_rec.budget_unit1_value = hr_api.g_number) then
323: p_rec.budget_unit1_value :=
324: pqh_bpr_shd.g_old_rec.budget_unit1_value;
325: End If;
326: If (p_rec.budget_unit2_value = hr_api.g_number) then
327: p_rec.budget_unit2_value :=
328: pqh_bpr_shd.g_old_rec.budget_unit2_value;
329: End If;
330: If (p_rec.budget_unit3_value = hr_api.g_number) then
326: If (p_rec.budget_unit2_value = hr_api.g_number) then
327: p_rec.budget_unit2_value :=
328: pqh_bpr_shd.g_old_rec.budget_unit2_value;
329: End If;
330: If (p_rec.budget_unit3_value = hr_api.g_number) then
331: p_rec.budget_unit3_value :=
332: pqh_bpr_shd.g_old_rec.budget_unit3_value;
333: End If;
334: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
330: If (p_rec.budget_unit3_value = hr_api.g_number) then
331: p_rec.budget_unit3_value :=
332: pqh_bpr_shd.g_old_rec.budget_unit3_value;
333: End If;
334: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
335: p_rec.budget_unit1_value_type_cd :=
336: pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd;
337: End If;
338: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
334: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
335: p_rec.budget_unit1_value_type_cd :=
336: pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd;
337: End If;
338: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
339: p_rec.budget_unit2_value_type_cd :=
340: pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd;
341: End If;
342: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
338: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
339: p_rec.budget_unit2_value_type_cd :=
340: pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd;
341: End If;
342: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
343: p_rec.budget_unit3_value_type_cd :=
344: pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd;
345: End If;
346: If (p_rec.budget_unit1_available = hr_api.g_number) then
342: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
343: p_rec.budget_unit3_value_type_cd :=
344: pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd;
345: End If;
346: If (p_rec.budget_unit1_available = hr_api.g_number) then
347: p_rec.budget_unit1_available :=
348: pqh_bpr_shd.g_old_rec.budget_unit1_available;
349: End If;
350: If (p_rec.budget_unit2_available = hr_api.g_number) then
346: If (p_rec.budget_unit1_available = hr_api.g_number) then
347: p_rec.budget_unit1_available :=
348: pqh_bpr_shd.g_old_rec.budget_unit1_available;
349: End If;
350: If (p_rec.budget_unit2_available = hr_api.g_number) then
351: p_rec.budget_unit2_available :=
352: pqh_bpr_shd.g_old_rec.budget_unit2_available;
353: End If;
354: If (p_rec.budget_unit3_available = hr_api.g_number) then
350: If (p_rec.budget_unit2_available = hr_api.g_number) then
351: p_rec.budget_unit2_available :=
352: pqh_bpr_shd.g_old_rec.budget_unit2_available;
353: End If;
354: If (p_rec.budget_unit3_available = hr_api.g_number) then
355: p_rec.budget_unit3_available :=
356: pqh_bpr_shd.g_old_rec.budget_unit3_available;
357: End If;
358:
409: -- ----------------------------------------------------------------------------
410: Procedure upd
411: (
412: p_budget_period_id in number,
413: p_budget_detail_id in number default hr_api.g_number,
414: p_start_time_period_id in number default hr_api.g_number,
415: p_end_time_period_id in number default hr_api.g_number,
416: p_budget_unit1_percent in number default hr_api.g_number,
417: p_budget_unit2_percent in number default hr_api.g_number,
410: Procedure upd
411: (
412: p_budget_period_id in number,
413: p_budget_detail_id in number default hr_api.g_number,
414: p_start_time_period_id in number default hr_api.g_number,
415: p_end_time_period_id in number default hr_api.g_number,
416: p_budget_unit1_percent in number default hr_api.g_number,
417: p_budget_unit2_percent in number default hr_api.g_number,
418: p_budget_unit3_percent in number default hr_api.g_number,
411: (
412: p_budget_period_id in number,
413: p_budget_detail_id in number default hr_api.g_number,
414: p_start_time_period_id in number default hr_api.g_number,
415: p_end_time_period_id in number default hr_api.g_number,
416: p_budget_unit1_percent in number default hr_api.g_number,
417: p_budget_unit2_percent in number default hr_api.g_number,
418: p_budget_unit3_percent in number default hr_api.g_number,
419: p_budget_unit1_value in number default hr_api.g_number,
412: p_budget_period_id in number,
413: p_budget_detail_id in number default hr_api.g_number,
414: p_start_time_period_id in number default hr_api.g_number,
415: p_end_time_period_id in number default hr_api.g_number,
416: p_budget_unit1_percent in number default hr_api.g_number,
417: p_budget_unit2_percent in number default hr_api.g_number,
418: p_budget_unit3_percent in number default hr_api.g_number,
419: p_budget_unit1_value in number default hr_api.g_number,
420: p_budget_unit2_value in number default hr_api.g_number,
413: p_budget_detail_id in number default hr_api.g_number,
414: p_start_time_period_id in number default hr_api.g_number,
415: p_end_time_period_id in number default hr_api.g_number,
416: p_budget_unit1_percent in number default hr_api.g_number,
417: p_budget_unit2_percent in number default hr_api.g_number,
418: p_budget_unit3_percent in number default hr_api.g_number,
419: p_budget_unit1_value in number default hr_api.g_number,
420: p_budget_unit2_value in number default hr_api.g_number,
421: p_budget_unit3_value in number default hr_api.g_number,
414: p_start_time_period_id in number default hr_api.g_number,
415: p_end_time_period_id in number default hr_api.g_number,
416: p_budget_unit1_percent in number default hr_api.g_number,
417: p_budget_unit2_percent in number default hr_api.g_number,
418: p_budget_unit3_percent in number default hr_api.g_number,
419: p_budget_unit1_value in number default hr_api.g_number,
420: p_budget_unit2_value in number default hr_api.g_number,
421: p_budget_unit3_value in number default hr_api.g_number,
422: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
415: p_end_time_period_id in number default hr_api.g_number,
416: p_budget_unit1_percent in number default hr_api.g_number,
417: p_budget_unit2_percent in number default hr_api.g_number,
418: p_budget_unit3_percent in number default hr_api.g_number,
419: p_budget_unit1_value in number default hr_api.g_number,
420: p_budget_unit2_value in number default hr_api.g_number,
421: p_budget_unit3_value in number default hr_api.g_number,
422: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
423: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
416: p_budget_unit1_percent in number default hr_api.g_number,
417: p_budget_unit2_percent in number default hr_api.g_number,
418: p_budget_unit3_percent in number default hr_api.g_number,
419: p_budget_unit1_value in number default hr_api.g_number,
420: p_budget_unit2_value in number default hr_api.g_number,
421: p_budget_unit3_value in number default hr_api.g_number,
422: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
423: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
424: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
417: p_budget_unit2_percent in number default hr_api.g_number,
418: p_budget_unit3_percent in number default hr_api.g_number,
419: p_budget_unit1_value in number default hr_api.g_number,
420: p_budget_unit2_value in number default hr_api.g_number,
421: p_budget_unit3_value in number default hr_api.g_number,
422: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
423: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
424: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
425: p_budget_unit1_available in number default hr_api.g_number,
418: p_budget_unit3_percent in number default hr_api.g_number,
419: p_budget_unit1_value in number default hr_api.g_number,
420: p_budget_unit2_value in number default hr_api.g_number,
421: p_budget_unit3_value in number default hr_api.g_number,
422: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
423: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
424: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
425: p_budget_unit1_available in number default hr_api.g_number,
426: p_budget_unit2_available in number default hr_api.g_number,
419: p_budget_unit1_value in number default hr_api.g_number,
420: p_budget_unit2_value in number default hr_api.g_number,
421: p_budget_unit3_value in number default hr_api.g_number,
422: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
423: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
424: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
425: p_budget_unit1_available in number default hr_api.g_number,
426: p_budget_unit2_available in number default hr_api.g_number,
427: p_budget_unit3_available in number default hr_api.g_number,
420: p_budget_unit2_value in number default hr_api.g_number,
421: p_budget_unit3_value in number default hr_api.g_number,
422: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
423: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
424: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
425: p_budget_unit1_available in number default hr_api.g_number,
426: p_budget_unit2_available in number default hr_api.g_number,
427: p_budget_unit3_available in number default hr_api.g_number,
428: p_object_version_number in out nocopy number
421: p_budget_unit3_value in number default hr_api.g_number,
422: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
423: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
424: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
425: p_budget_unit1_available in number default hr_api.g_number,
426: p_budget_unit2_available in number default hr_api.g_number,
427: p_budget_unit3_available in number default hr_api.g_number,
428: p_object_version_number in out nocopy number
429: ) is
422: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
423: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
424: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
425: p_budget_unit1_available in number default hr_api.g_number,
426: p_budget_unit2_available in number default hr_api.g_number,
427: p_budget_unit3_available in number default hr_api.g_number,
428: p_object_version_number in out nocopy number
429: ) is
430: --
423: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
424: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
425: p_budget_unit1_available in number default hr_api.g_number,
426: p_budget_unit2_available in number default hr_api.g_number,
427: p_budget_unit3_available in number default hr_api.g_number,
428: p_object_version_number in out nocopy number
429: ) is
430: --
431: l_rec pqh_bpr_shd.g_rec_type;