APPS.PQH_BPR_UPD dependencies on HR_API

Line 87: When hr_api.check_integrity_violated Then

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

Line 90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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));

Line 91: When hr_api.parent_integrity_violated Then

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

Line 94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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));

Line 95: When hr_api.unique_integrity_violated Then

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

Line 98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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: --

Line 228: when hr_api.cannot_find_prog_unit then

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');

Line 230: hr_api.cannot_find_prog_unit_error

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;

Line 298: If (p_rec.budget_detail_id = hr_api.g_number) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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:

Line 413: p_budget_detail_id in number default hr_api.g_number,

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,

Line 414: p_start_time_period_id 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,

Line 415: p_end_time_period_id 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,

Line 416: p_budget_unit1_percent 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,

Line 417: p_budget_unit2_percent 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,

Line 418: p_budget_unit3_percent 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,

Line 419: p_budget_unit1_value 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,
423: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,

Line 420: p_budget_unit2_value 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,
424: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,

Line 421: p_budget_unit3_value 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,
425: p_budget_unit1_available in number default hr_api.g_number,

Line 422: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,

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,

Line 423: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,

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,

Line 424: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,

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

Line 425: p_budget_unit1_available 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
429: ) is

Line 426: p_budget_unit2_available 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
430: --

Line 427: p_budget_unit3_available in number default hr_api.g_number,

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;