eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BVR_UPD dependencies on HR_API

Line 88: When hr_api.check_integrity_violated Then

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

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

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

Line 92: When hr_api.parent_integrity_violated Then

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

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

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

Line 96: When hr_api.unique_integrity_violated Then

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

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

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

Line 272: when hr_api.cannot_find_prog_unit then

268: );
269: --
270: exception
271: --
272: when hr_api.cannot_find_prog_unit then
273: --
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'pqh_budget_versions'
276: ,p_hook_type => 'AU');

Line 274: hr_api.cannot_find_prog_unit_error

270: exception
271: --
272: when hr_api.cannot_find_prog_unit then
273: --
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'pqh_budget_versions'
276: ,p_hook_type => 'AU');
277: --
278: end;

Line 342: If (p_rec.budget_id = hr_api.g_number) then

338: -- p_rec plsql record structure
339: -- to see if a system default is being used. If a system default
340: -- is being used then we must set to the 'current' argument value.
341: --
342: If (p_rec.budget_id = hr_api.g_number) then
343: p_rec.budget_id :=
344: pqh_bvr_shd.g_old_rec.budget_id;
345: End If;
346: If (p_rec.version_number = hr_api.g_number) then

Line 346: If (p_rec.version_number = hr_api.g_number) then

342: If (p_rec.budget_id = hr_api.g_number) then
343: p_rec.budget_id :=
344: pqh_bvr_shd.g_old_rec.budget_id;
345: End If;
346: If (p_rec.version_number = hr_api.g_number) then
347: p_rec.version_number :=
348: pqh_bvr_shd.g_old_rec.version_number;
349: End If;
350: If (p_rec.date_from = hr_api.g_date) then

Line 350: If (p_rec.date_from = hr_api.g_date) then

346: If (p_rec.version_number = hr_api.g_number) then
347: p_rec.version_number :=
348: pqh_bvr_shd.g_old_rec.version_number;
349: End If;
350: If (p_rec.date_from = hr_api.g_date) then
351: p_rec.date_from :=
352: pqh_bvr_shd.g_old_rec.date_from;
353: End If;
354: If (p_rec.date_to = hr_api.g_date) then

Line 354: If (p_rec.date_to = hr_api.g_date) then

350: If (p_rec.date_from = hr_api.g_date) then
351: p_rec.date_from :=
352: pqh_bvr_shd.g_old_rec.date_from;
353: End If;
354: If (p_rec.date_to = hr_api.g_date) then
355: p_rec.date_to :=
356: pqh_bvr_shd.g_old_rec.date_to;
357: End If;
358: If (p_rec.transfered_to_gl_flag = hr_api.g_varchar2) then

Line 358: If (p_rec.transfered_to_gl_flag = hr_api.g_varchar2) then

354: If (p_rec.date_to = hr_api.g_date) then
355: p_rec.date_to :=
356: pqh_bvr_shd.g_old_rec.date_to;
357: End If;
358: If (p_rec.transfered_to_gl_flag = hr_api.g_varchar2) then
359: p_rec.transfered_to_gl_flag :=
360: pqh_bvr_shd.g_old_rec.transfered_to_gl_flag;
361: End If;
362: If (p_rec.gl_status = hr_api.g_varchar2) then

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

358: If (p_rec.transfered_to_gl_flag = hr_api.g_varchar2) then
359: p_rec.transfered_to_gl_flag :=
360: pqh_bvr_shd.g_old_rec.transfered_to_gl_flag;
361: End If;
362: If (p_rec.gl_status = hr_api.g_varchar2) then
363: p_rec.gl_status :=
364: pqh_bvr_shd.g_old_rec.gl_status;
365: End If;
366: If (p_rec.xfer_to_other_apps_cd = hr_api.g_varchar2) then

Line 366: If (p_rec.xfer_to_other_apps_cd = hr_api.g_varchar2) then

362: If (p_rec.gl_status = hr_api.g_varchar2) then
363: p_rec.gl_status :=
364: pqh_bvr_shd.g_old_rec.gl_status;
365: End If;
366: If (p_rec.xfer_to_other_apps_cd = hr_api.g_varchar2) then
367: p_rec.xfer_to_other_apps_cd :=
368: pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd;
369: End If;
370: If (p_rec.budget_unit1_value = hr_api.g_number) then

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

366: If (p_rec.xfer_to_other_apps_cd = hr_api.g_varchar2) then
367: p_rec.xfer_to_other_apps_cd :=
368: pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd;
369: End If;
370: If (p_rec.budget_unit1_value = hr_api.g_number) then
371: p_rec.budget_unit1_value :=
372: pqh_bvr_shd.g_old_rec.budget_unit1_value;
373: End If;
374: If (p_rec.budget_unit2_value = hr_api.g_number) then

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

370: If (p_rec.budget_unit1_value = hr_api.g_number) then
371: p_rec.budget_unit1_value :=
372: pqh_bvr_shd.g_old_rec.budget_unit1_value;
373: End If;
374: If (p_rec.budget_unit2_value = hr_api.g_number) then
375: p_rec.budget_unit2_value :=
376: pqh_bvr_shd.g_old_rec.budget_unit2_value;
377: End If;
378: If (p_rec.budget_unit3_value = hr_api.g_number) then

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

374: If (p_rec.budget_unit2_value = hr_api.g_number) then
375: p_rec.budget_unit2_value :=
376: pqh_bvr_shd.g_old_rec.budget_unit2_value;
377: End If;
378: If (p_rec.budget_unit3_value = hr_api.g_number) then
379: p_rec.budget_unit3_value :=
380: pqh_bvr_shd.g_old_rec.budget_unit3_value;
381: End If;
382: If (p_rec.budget_unit1_available = hr_api.g_number) then

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

378: If (p_rec.budget_unit3_value = hr_api.g_number) then
379: p_rec.budget_unit3_value :=
380: pqh_bvr_shd.g_old_rec.budget_unit3_value;
381: End If;
382: If (p_rec.budget_unit1_available = hr_api.g_number) then
383: p_rec.budget_unit1_available :=
384: pqh_bvr_shd.g_old_rec.budget_unit1_available;
385: End If;
386: If (p_rec.budget_unit2_available = hr_api.g_number) then

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

382: If (p_rec.budget_unit1_available = hr_api.g_number) then
383: p_rec.budget_unit1_available :=
384: pqh_bvr_shd.g_old_rec.budget_unit1_available;
385: End If;
386: If (p_rec.budget_unit2_available = hr_api.g_number) then
387: p_rec.budget_unit2_available :=
388: pqh_bvr_shd.g_old_rec.budget_unit2_available;
389: End If;
390: If (p_rec.budget_unit3_available = hr_api.g_number) then

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

386: If (p_rec.budget_unit2_available = hr_api.g_number) then
387: p_rec.budget_unit2_available :=
388: pqh_bvr_shd.g_old_rec.budget_unit2_available;
389: End If;
390: If (p_rec.budget_unit3_available = hr_api.g_number) then
391: p_rec.budget_unit3_available :=
392: pqh_bvr_shd.g_old_rec.budget_unit3_available;
393: End If;
394: --

Line 452: p_budget_id in number default hr_api.g_number,

448: Procedure upd
449: (
450: p_effective_date in date,
451: p_budget_version_id in number,
452: p_budget_id in number default hr_api.g_number,
453: p_version_number in number default hr_api.g_number,
454: p_date_from in date default hr_api.g_date,
455: p_date_to in date default hr_api.g_date,
456: p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2,

Line 453: p_version_number in number default hr_api.g_number,

449: (
450: p_effective_date in date,
451: p_budget_version_id in number,
452: p_budget_id in number default hr_api.g_number,
453: p_version_number in number default hr_api.g_number,
454: p_date_from in date default hr_api.g_date,
455: p_date_to in date default hr_api.g_date,
456: p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2,
457: p_gl_status in varchar2 default hr_api.g_varchar2,

Line 454: p_date_from in date default hr_api.g_date,

450: p_effective_date in date,
451: p_budget_version_id in number,
452: p_budget_id in number default hr_api.g_number,
453: p_version_number in number default hr_api.g_number,
454: p_date_from in date default hr_api.g_date,
455: p_date_to in date default hr_api.g_date,
456: p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2,
457: p_gl_status in varchar2 default hr_api.g_varchar2,
458: p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2,

Line 455: p_date_to in date default hr_api.g_date,

451: p_budget_version_id in number,
452: p_budget_id in number default hr_api.g_number,
453: p_version_number in number default hr_api.g_number,
454: p_date_from in date default hr_api.g_date,
455: p_date_to in date default hr_api.g_date,
456: p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2,
457: p_gl_status in varchar2 default hr_api.g_varchar2,
458: p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2,
459: p_object_version_number in out nocopy number,

Line 456: p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2,

452: p_budget_id in number default hr_api.g_number,
453: p_version_number in number default hr_api.g_number,
454: p_date_from in date default hr_api.g_date,
455: p_date_to in date default hr_api.g_date,
456: p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2,
457: p_gl_status in varchar2 default hr_api.g_varchar2,
458: p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2,
459: p_object_version_number in out nocopy number,
460: p_budget_unit1_value in number default hr_api.g_number,

Line 457: p_gl_status in varchar2 default hr_api.g_varchar2,

453: p_version_number in number default hr_api.g_number,
454: p_date_from in date default hr_api.g_date,
455: p_date_to in date default hr_api.g_date,
456: p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2,
457: p_gl_status in varchar2 default hr_api.g_varchar2,
458: p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2,
459: p_object_version_number in out nocopy number,
460: p_budget_unit1_value in number default hr_api.g_number,
461: p_budget_unit2_value in number default hr_api.g_number,

Line 458: p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2,

454: p_date_from in date default hr_api.g_date,
455: p_date_to in date default hr_api.g_date,
456: p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2,
457: p_gl_status in varchar2 default hr_api.g_varchar2,
458: p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2,
459: p_object_version_number in out nocopy number,
460: p_budget_unit1_value in number default hr_api.g_number,
461: p_budget_unit2_value in number default hr_api.g_number,
462: p_budget_unit3_value in number default hr_api.g_number,

Line 460: p_budget_unit1_value in number default hr_api.g_number,

456: p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2,
457: p_gl_status in varchar2 default hr_api.g_varchar2,
458: p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2,
459: p_object_version_number in out nocopy number,
460: p_budget_unit1_value in number default hr_api.g_number,
461: p_budget_unit2_value in number default hr_api.g_number,
462: p_budget_unit3_value in number default hr_api.g_number,
463: p_budget_unit1_available in number default hr_api.g_number,
464: p_budget_unit2_available in number default hr_api.g_number,

Line 461: p_budget_unit2_value in number default hr_api.g_number,

457: p_gl_status in varchar2 default hr_api.g_varchar2,
458: p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2,
459: p_object_version_number in out nocopy number,
460: p_budget_unit1_value in number default hr_api.g_number,
461: p_budget_unit2_value in number default hr_api.g_number,
462: p_budget_unit3_value in number default hr_api.g_number,
463: p_budget_unit1_available in number default hr_api.g_number,
464: p_budget_unit2_available in number default hr_api.g_number,
465: p_budget_unit3_available in number default hr_api.g_number

Line 462: p_budget_unit3_value in number default hr_api.g_number,

458: p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2,
459: p_object_version_number in out nocopy number,
460: p_budget_unit1_value in number default hr_api.g_number,
461: p_budget_unit2_value in number default hr_api.g_number,
462: p_budget_unit3_value in number default hr_api.g_number,
463: p_budget_unit1_available in number default hr_api.g_number,
464: p_budget_unit2_available in number default hr_api.g_number,
465: p_budget_unit3_available in number default hr_api.g_number
466: ) is

Line 463: p_budget_unit1_available in number default hr_api.g_number,

459: p_object_version_number in out nocopy number,
460: p_budget_unit1_value in number default hr_api.g_number,
461: p_budget_unit2_value in number default hr_api.g_number,
462: p_budget_unit3_value in number default hr_api.g_number,
463: p_budget_unit1_available in number default hr_api.g_number,
464: p_budget_unit2_available in number default hr_api.g_number,
465: p_budget_unit3_available in number default hr_api.g_number
466: ) is
467: --

Line 464: p_budget_unit2_available in number default hr_api.g_number,

460: p_budget_unit1_value in number default hr_api.g_number,
461: p_budget_unit2_value in number default hr_api.g_number,
462: p_budget_unit3_value in number default hr_api.g_number,
463: p_budget_unit1_available in number default hr_api.g_number,
464: p_budget_unit2_available in number default hr_api.g_number,
465: p_budget_unit3_available in number default hr_api.g_number
466: ) is
467: --
468: l_rec pqh_bvr_shd.g_rec_type;

Line 465: p_budget_unit3_available in number default hr_api.g_number

461: p_budget_unit2_value in number default hr_api.g_number,
462: p_budget_unit3_value in number default hr_api.g_number,
463: p_budget_unit1_available in number default hr_api.g_number,
464: p_budget_unit2_available in number default hr_api.g_number,
465: p_budget_unit3_available in number default hr_api.g_number
466: ) is
467: --
468: l_rec pqh_bvr_shd.g_rec_type;
469: l_proc varchar2(72) := g_package||'upd';