APPS.PQH_BDT_UPD dependencies on HR_API

Line 90: When hr_api.check_integrity_violated Then

86: --
87: hr_utility.set_location(' Leaving:'||l_proc, 10);
88: --
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: pqh_bdt_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then

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

89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: pqh_bdt_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: pqh_bdt_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 94: When hr_api.parent_integrity_violated Then

90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: pqh_bdt_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: pqh_bdt_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then

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

93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: pqh_bdt_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: pqh_bdt_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 98: When hr_api.unique_integrity_violated Then

94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: pqh_bdt_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: pqh_bdt_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When Others Then

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

97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: pqh_bdt_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When Others Then
103: Raise;
104: End update_dml;
105: --

Line 237: when hr_api.cannot_find_prog_unit then

233: );
234: --
235: exception
236: --
237: when hr_api.cannot_find_prog_unit then
238: --
239: hr_api.cannot_find_prog_unit_error
240: (p_module_name => 'pqh_budget_details'
241: ,p_hook_type => 'AU');

Line 239: hr_api.cannot_find_prog_unit_error

235: exception
236: --
237: when hr_api.cannot_find_prog_unit then
238: --
239: hr_api.cannot_find_prog_unit_error
240: (p_module_name => 'pqh_budget_details'
241: ,p_hook_type => 'AU');
242: --
243: end;

Line 307: If (p_rec.organization_id = hr_api.g_number) then

303: -- p_rec plsql record structure
304: -- to see if a system default is being used. If a system default
305: -- is being used then we must set to the 'current' argument value.
306: --
307: If (p_rec.organization_id = hr_api.g_number) then
308: p_rec.organization_id :=
309: pqh_bdt_shd.g_old_rec.organization_id;
310: End If;
311: If (p_rec.job_id = hr_api.g_number) then

Line 311: If (p_rec.job_id = hr_api.g_number) then

307: If (p_rec.organization_id = hr_api.g_number) then
308: p_rec.organization_id :=
309: pqh_bdt_shd.g_old_rec.organization_id;
310: End If;
311: If (p_rec.job_id = hr_api.g_number) then
312: p_rec.job_id :=
313: pqh_bdt_shd.g_old_rec.job_id;
314: End If;
315: If (p_rec.position_id = hr_api.g_number) then

Line 315: If (p_rec.position_id = hr_api.g_number) then

311: If (p_rec.job_id = hr_api.g_number) then
312: p_rec.job_id :=
313: pqh_bdt_shd.g_old_rec.job_id;
314: End If;
315: If (p_rec.position_id = hr_api.g_number) then
316: p_rec.position_id :=
317: pqh_bdt_shd.g_old_rec.position_id;
318: End If;
319: If (p_rec.grade_id = hr_api.g_number) then

Line 319: If (p_rec.grade_id = hr_api.g_number) then

315: If (p_rec.position_id = hr_api.g_number) then
316: p_rec.position_id :=
317: pqh_bdt_shd.g_old_rec.position_id;
318: End If;
319: If (p_rec.grade_id = hr_api.g_number) then
320: p_rec.grade_id :=
321: pqh_bdt_shd.g_old_rec.grade_id;
322: End If;
323: If (p_rec.budget_version_id = hr_api.g_number) then

Line 323: If (p_rec.budget_version_id = hr_api.g_number) then

319: If (p_rec.grade_id = hr_api.g_number) then
320: p_rec.grade_id :=
321: pqh_bdt_shd.g_old_rec.grade_id;
322: End If;
323: If (p_rec.budget_version_id = hr_api.g_number) then
324: p_rec.budget_version_id :=
325: pqh_bdt_shd.g_old_rec.budget_version_id;
326: End If;
327: If (p_rec.budget_unit1_percent = hr_api.g_number) then

Line 327: If (p_rec.budget_unit1_percent = hr_api.g_number) then

323: If (p_rec.budget_version_id = hr_api.g_number) then
324: p_rec.budget_version_id :=
325: pqh_bdt_shd.g_old_rec.budget_version_id;
326: End If;
327: If (p_rec.budget_unit1_percent = hr_api.g_number) then
328: p_rec.budget_unit1_percent :=
329: pqh_bdt_shd.g_old_rec.budget_unit1_percent;
330: End If;
331: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then

Line 331: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then

327: If (p_rec.budget_unit1_percent = hr_api.g_number) then
328: p_rec.budget_unit1_percent :=
329: pqh_bdt_shd.g_old_rec.budget_unit1_percent;
330: End If;
331: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
332: p_rec.budget_unit1_value_type_cd :=
333: pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd;
334: End If;
335: If (p_rec.budget_unit1_value = hr_api.g_number) then

Line 335: If (p_rec.budget_unit1_value = hr_api.g_number) then

331: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
332: p_rec.budget_unit1_value_type_cd :=
333: pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd;
334: End If;
335: If (p_rec.budget_unit1_value = hr_api.g_number) then
336: p_rec.budget_unit1_value :=
337: pqh_bdt_shd.g_old_rec.budget_unit1_value;
338: End If;
339: If (p_rec.budget_unit1_available = hr_api.g_number) then

Line 339: If (p_rec.budget_unit1_available = hr_api.g_number) then

335: If (p_rec.budget_unit1_value = hr_api.g_number) then
336: p_rec.budget_unit1_value :=
337: pqh_bdt_shd.g_old_rec.budget_unit1_value;
338: End If;
339: If (p_rec.budget_unit1_available = hr_api.g_number) then
340: p_rec.budget_unit1_available :=
341: pqh_bdt_shd.g_old_rec.budget_unit1_available;
342: End If;
343: If (p_rec.budget_unit2_percent = hr_api.g_number) then

Line 343: If (p_rec.budget_unit2_percent = hr_api.g_number) then

339: If (p_rec.budget_unit1_available = hr_api.g_number) then
340: p_rec.budget_unit1_available :=
341: pqh_bdt_shd.g_old_rec.budget_unit1_available;
342: End If;
343: If (p_rec.budget_unit2_percent = hr_api.g_number) then
344: p_rec.budget_unit2_percent :=
345: pqh_bdt_shd.g_old_rec.budget_unit2_percent;
346: End If;
347: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then

Line 347: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then

343: If (p_rec.budget_unit2_percent = hr_api.g_number) then
344: p_rec.budget_unit2_percent :=
345: pqh_bdt_shd.g_old_rec.budget_unit2_percent;
346: End If;
347: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
348: p_rec.budget_unit2_value_type_cd :=
349: pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd;
350: End If;
351: If (p_rec.budget_unit2_value = hr_api.g_number) then

Line 351: If (p_rec.budget_unit2_value = hr_api.g_number) then

347: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
348: p_rec.budget_unit2_value_type_cd :=
349: pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd;
350: End If;
351: If (p_rec.budget_unit2_value = hr_api.g_number) then
352: p_rec.budget_unit2_value :=
353: pqh_bdt_shd.g_old_rec.budget_unit2_value;
354: End If;
355: If (p_rec.budget_unit2_available = hr_api.g_number) then

Line 355: If (p_rec.budget_unit2_available = hr_api.g_number) then

351: If (p_rec.budget_unit2_value = hr_api.g_number) then
352: p_rec.budget_unit2_value :=
353: pqh_bdt_shd.g_old_rec.budget_unit2_value;
354: End If;
355: If (p_rec.budget_unit2_available = hr_api.g_number) then
356: p_rec.budget_unit2_available :=
357: pqh_bdt_shd.g_old_rec.budget_unit2_available;
358: End If;
359: If (p_rec.budget_unit3_percent = hr_api.g_number) then

Line 359: If (p_rec.budget_unit3_percent = hr_api.g_number) then

355: If (p_rec.budget_unit2_available = hr_api.g_number) then
356: p_rec.budget_unit2_available :=
357: pqh_bdt_shd.g_old_rec.budget_unit2_available;
358: End If;
359: If (p_rec.budget_unit3_percent = hr_api.g_number) then
360: p_rec.budget_unit3_percent :=
361: pqh_bdt_shd.g_old_rec.budget_unit3_percent;
362: End If;
363: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then

Line 363: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then

359: If (p_rec.budget_unit3_percent = hr_api.g_number) then
360: p_rec.budget_unit3_percent :=
361: pqh_bdt_shd.g_old_rec.budget_unit3_percent;
362: End If;
363: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
364: p_rec.budget_unit3_value_type_cd :=
365: pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd;
366: End If;
367: If (p_rec.budget_unit3_value = hr_api.g_number) then

Line 367: If (p_rec.budget_unit3_value = hr_api.g_number) then

363: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
364: p_rec.budget_unit3_value_type_cd :=
365: pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd;
366: End If;
367: If (p_rec.budget_unit3_value = hr_api.g_number) then
368: p_rec.budget_unit3_value :=
369: pqh_bdt_shd.g_old_rec.budget_unit3_value;
370: End If;
371: If (p_rec.budget_unit3_available = hr_api.g_number) then

Line 371: If (p_rec.budget_unit3_available = hr_api.g_number) then

367: If (p_rec.budget_unit3_value = hr_api.g_number) then
368: p_rec.budget_unit3_value :=
369: pqh_bdt_shd.g_old_rec.budget_unit3_value;
370: End If;
371: If (p_rec.budget_unit3_available = hr_api.g_number) then
372: p_rec.budget_unit3_available :=
373: pqh_bdt_shd.g_old_rec.budget_unit3_available;
374: End If;
375: If (p_rec.gl_status = hr_api.g_varchar2) then

Line 375: If (p_rec.gl_status = hr_api.g_varchar2) then

371: If (p_rec.budget_unit3_available = hr_api.g_number) then
372: p_rec.budget_unit3_available :=
373: pqh_bdt_shd.g_old_rec.budget_unit3_available;
374: End If;
375: If (p_rec.gl_status = hr_api.g_varchar2) then
376: p_rec.gl_status :=
377: pqh_bdt_shd.g_old_rec.gl_status;
378: End If;
379:

Line 434: p_organization_id in number default hr_api.g_number,

430: -- ----------------------------------------------------------------------------
431: Procedure upd
432: (
433: p_budget_detail_id in number,
434: p_organization_id in number default hr_api.g_number,
435: p_job_id in number default hr_api.g_number,
436: p_position_id in number default hr_api.g_number,
437: p_grade_id in number default hr_api.g_number,
438: p_budget_version_id in number default hr_api.g_number,

Line 435: p_job_id in number default hr_api.g_number,

431: Procedure upd
432: (
433: p_budget_detail_id in number,
434: p_organization_id in number default hr_api.g_number,
435: p_job_id in number default hr_api.g_number,
436: p_position_id in number default hr_api.g_number,
437: p_grade_id in number default hr_api.g_number,
438: p_budget_version_id in number default hr_api.g_number,
439: p_budget_unit1_percent in number default hr_api.g_number,

Line 436: p_position_id in number default hr_api.g_number,

432: (
433: p_budget_detail_id in number,
434: p_organization_id in number default hr_api.g_number,
435: p_job_id in number default hr_api.g_number,
436: p_position_id in number default hr_api.g_number,
437: p_grade_id in number default hr_api.g_number,
438: p_budget_version_id in number default hr_api.g_number,
439: p_budget_unit1_percent in number default hr_api.g_number,
440: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,

Line 437: p_grade_id in number default hr_api.g_number,

433: p_budget_detail_id in number,
434: p_organization_id in number default hr_api.g_number,
435: p_job_id in number default hr_api.g_number,
436: p_position_id in number default hr_api.g_number,
437: p_grade_id in number default hr_api.g_number,
438: p_budget_version_id in number default hr_api.g_number,
439: p_budget_unit1_percent in number default hr_api.g_number,
440: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
441: p_budget_unit1_value in number default hr_api.g_number,

Line 438: p_budget_version_id in number default hr_api.g_number,

434: p_organization_id in number default hr_api.g_number,
435: p_job_id in number default hr_api.g_number,
436: p_position_id in number default hr_api.g_number,
437: p_grade_id in number default hr_api.g_number,
438: p_budget_version_id in number default hr_api.g_number,
439: p_budget_unit1_percent in number default hr_api.g_number,
440: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
441: p_budget_unit1_value in number default hr_api.g_number,
442: p_budget_unit1_available in number default hr_api.g_number,

Line 439: p_budget_unit1_percent in number default hr_api.g_number,

435: p_job_id in number default hr_api.g_number,
436: p_position_id in number default hr_api.g_number,
437: p_grade_id in number default hr_api.g_number,
438: p_budget_version_id in number default hr_api.g_number,
439: p_budget_unit1_percent in number default hr_api.g_number,
440: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
441: p_budget_unit1_value in number default hr_api.g_number,
442: p_budget_unit1_available in number default hr_api.g_number,
443: p_budget_unit2_percent in number default hr_api.g_number,

Line 440: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,

436: p_position_id in number default hr_api.g_number,
437: p_grade_id in number default hr_api.g_number,
438: p_budget_version_id in number default hr_api.g_number,
439: p_budget_unit1_percent in number default hr_api.g_number,
440: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
441: p_budget_unit1_value in number default hr_api.g_number,
442: p_budget_unit1_available in number default hr_api.g_number,
443: p_budget_unit2_percent in number default hr_api.g_number,
444: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,

Line 441: p_budget_unit1_value in number default hr_api.g_number,

437: p_grade_id in number default hr_api.g_number,
438: p_budget_version_id in number default hr_api.g_number,
439: p_budget_unit1_percent in number default hr_api.g_number,
440: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
441: p_budget_unit1_value in number default hr_api.g_number,
442: p_budget_unit1_available in number default hr_api.g_number,
443: p_budget_unit2_percent in number default hr_api.g_number,
444: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
445: p_budget_unit2_value in number default hr_api.g_number,

Line 442: p_budget_unit1_available in number default hr_api.g_number,

438: p_budget_version_id in number default hr_api.g_number,
439: p_budget_unit1_percent in number default hr_api.g_number,
440: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
441: p_budget_unit1_value in number default hr_api.g_number,
442: p_budget_unit1_available in number default hr_api.g_number,
443: p_budget_unit2_percent in number default hr_api.g_number,
444: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
445: p_budget_unit2_value in number default hr_api.g_number,
446: p_budget_unit2_available in number default hr_api.g_number,

Line 443: p_budget_unit2_percent in number default hr_api.g_number,

439: p_budget_unit1_percent in number default hr_api.g_number,
440: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
441: p_budget_unit1_value in number default hr_api.g_number,
442: p_budget_unit1_available in number default hr_api.g_number,
443: p_budget_unit2_percent in number default hr_api.g_number,
444: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
445: p_budget_unit2_value in number default hr_api.g_number,
446: p_budget_unit2_available in number default hr_api.g_number,
447: p_budget_unit3_percent in number default hr_api.g_number,

Line 444: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,

440: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
441: p_budget_unit1_value in number default hr_api.g_number,
442: p_budget_unit1_available in number default hr_api.g_number,
443: p_budget_unit2_percent in number default hr_api.g_number,
444: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
445: p_budget_unit2_value in number default hr_api.g_number,
446: p_budget_unit2_available in number default hr_api.g_number,
447: p_budget_unit3_percent in number default hr_api.g_number,
448: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,

Line 445: p_budget_unit2_value in number default hr_api.g_number,

441: p_budget_unit1_value in number default hr_api.g_number,
442: p_budget_unit1_available in number default hr_api.g_number,
443: p_budget_unit2_percent in number default hr_api.g_number,
444: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
445: p_budget_unit2_value in number default hr_api.g_number,
446: p_budget_unit2_available in number default hr_api.g_number,
447: p_budget_unit3_percent in number default hr_api.g_number,
448: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
449: p_budget_unit3_value in number default hr_api.g_number,

Line 446: p_budget_unit2_available in number default hr_api.g_number,

442: p_budget_unit1_available in number default hr_api.g_number,
443: p_budget_unit2_percent in number default hr_api.g_number,
444: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
445: p_budget_unit2_value in number default hr_api.g_number,
446: p_budget_unit2_available in number default hr_api.g_number,
447: p_budget_unit3_percent in number default hr_api.g_number,
448: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
449: p_budget_unit3_value in number default hr_api.g_number,
450: p_budget_unit3_available in number default hr_api.g_number,

Line 447: p_budget_unit3_percent in number default hr_api.g_number,

443: p_budget_unit2_percent in number default hr_api.g_number,
444: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
445: p_budget_unit2_value in number default hr_api.g_number,
446: p_budget_unit2_available in number default hr_api.g_number,
447: p_budget_unit3_percent in number default hr_api.g_number,
448: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
449: p_budget_unit3_value in number default hr_api.g_number,
450: p_budget_unit3_available in number default hr_api.g_number,
451: p_gl_status in varchar2 default hr_api.g_varchar2,

Line 448: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,

444: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
445: p_budget_unit2_value in number default hr_api.g_number,
446: p_budget_unit2_available in number default hr_api.g_number,
447: p_budget_unit3_percent in number default hr_api.g_number,
448: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
449: p_budget_unit3_value in number default hr_api.g_number,
450: p_budget_unit3_available in number default hr_api.g_number,
451: p_gl_status in varchar2 default hr_api.g_varchar2,
452: p_object_version_number in out nocopy number

Line 449: p_budget_unit3_value in number default hr_api.g_number,

445: p_budget_unit2_value in number default hr_api.g_number,
446: p_budget_unit2_available in number default hr_api.g_number,
447: p_budget_unit3_percent in number default hr_api.g_number,
448: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
449: p_budget_unit3_value in number default hr_api.g_number,
450: p_budget_unit3_available in number default hr_api.g_number,
451: p_gl_status in varchar2 default hr_api.g_varchar2,
452: p_object_version_number in out nocopy number
453: ) is

Line 450: p_budget_unit3_available in number default hr_api.g_number,

446: p_budget_unit2_available in number default hr_api.g_number,
447: p_budget_unit3_percent in number default hr_api.g_number,
448: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
449: p_budget_unit3_value in number default hr_api.g_number,
450: p_budget_unit3_available in number default hr_api.g_number,
451: p_gl_status in varchar2 default hr_api.g_varchar2,
452: p_object_version_number in out nocopy number
453: ) is
454: --

Line 451: p_gl_status in varchar2 default hr_api.g_varchar2,

447: p_budget_unit3_percent in number default hr_api.g_number,
448: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
449: p_budget_unit3_value in number default hr_api.g_number,
450: p_budget_unit3_available in number default hr_api.g_number,
451: p_gl_status in varchar2 default hr_api.g_varchar2,
452: p_object_version_number in out nocopy number
453: ) is
454: --
455: l_rec pqh_bdt_shd.g_rec_type;