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_BST_UPD dependencies on HR_API

Line 86: When hr_api.check_integrity_violated Then

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

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

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

Line 90: When hr_api.parent_integrity_violated Then

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

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

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

Line 94: When hr_api.unique_integrity_violated Then

90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: pqh_bst_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: pqh_bst_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When Others 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.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: pqh_bst_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When Others Then
99: Raise;
100: End update_dml;
101: --

Line 227: when hr_api.cannot_find_prog_unit then

223: );
224: --
225: exception
226: --
227: when hr_api.cannot_find_prog_unit then
228: --
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'pqh_budget_sets'
231: ,p_hook_type => 'AU');

Line 229: hr_api.cannot_find_prog_unit_error

225: exception
226: --
227: when hr_api.cannot_find_prog_unit then
228: --
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'pqh_budget_sets'
231: ,p_hook_type => 'AU');
232: --
233: end;

Line 297: If (p_rec.dflt_budget_set_id = hr_api.g_number) then

293: -- p_rec plsql record structure
294: -- to see if a system default is being used. If a system default
295: -- is being used then we must set to the 'current' argument value.
296: --
297: If (p_rec.dflt_budget_set_id = hr_api.g_number) then
298: p_rec.dflt_budget_set_id :=
299: pqh_bst_shd.g_old_rec.dflt_budget_set_id;
300: End If;
301: If (p_rec.budget_period_id = hr_api.g_number) then

Line 301: If (p_rec.budget_period_id = hr_api.g_number) then

297: If (p_rec.dflt_budget_set_id = hr_api.g_number) then
298: p_rec.dflt_budget_set_id :=
299: pqh_bst_shd.g_old_rec.dflt_budget_set_id;
300: End If;
301: If (p_rec.budget_period_id = hr_api.g_number) then
302: p_rec.budget_period_id :=
303: pqh_bst_shd.g_old_rec.budget_period_id;
304: End If;
305: If (p_rec.budget_unit1_percent = hr_api.g_number) then

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

301: If (p_rec.budget_period_id = hr_api.g_number) then
302: p_rec.budget_period_id :=
303: pqh_bst_shd.g_old_rec.budget_period_id;
304: End If;
305: If (p_rec.budget_unit1_percent = hr_api.g_number) then
306: p_rec.budget_unit1_percent :=
307: pqh_bst_shd.g_old_rec.budget_unit1_percent;
308: End If;
309: If (p_rec.budget_unit2_percent = hr_api.g_number) then

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

305: If (p_rec.budget_unit1_percent = hr_api.g_number) then
306: p_rec.budget_unit1_percent :=
307: pqh_bst_shd.g_old_rec.budget_unit1_percent;
308: End If;
309: If (p_rec.budget_unit2_percent = hr_api.g_number) then
310: p_rec.budget_unit2_percent :=
311: pqh_bst_shd.g_old_rec.budget_unit2_percent;
312: End If;
313: If (p_rec.budget_unit3_percent = hr_api.g_number) then

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

309: If (p_rec.budget_unit2_percent = hr_api.g_number) then
310: p_rec.budget_unit2_percent :=
311: pqh_bst_shd.g_old_rec.budget_unit2_percent;
312: End If;
313: If (p_rec.budget_unit3_percent = hr_api.g_number) then
314: p_rec.budget_unit3_percent :=
315: pqh_bst_shd.g_old_rec.budget_unit3_percent;
316: End If;
317: If (p_rec.budget_unit1_value = hr_api.g_number) then

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

313: If (p_rec.budget_unit3_percent = hr_api.g_number) then
314: p_rec.budget_unit3_percent :=
315: pqh_bst_shd.g_old_rec.budget_unit3_percent;
316: End If;
317: If (p_rec.budget_unit1_value = hr_api.g_number) then
318: p_rec.budget_unit1_value :=
319: pqh_bst_shd.g_old_rec.budget_unit1_value;
320: End If;
321: If (p_rec.budget_unit2_value = hr_api.g_number) then

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

317: If (p_rec.budget_unit1_value = hr_api.g_number) then
318: p_rec.budget_unit1_value :=
319: pqh_bst_shd.g_old_rec.budget_unit1_value;
320: End If;
321: If (p_rec.budget_unit2_value = hr_api.g_number) then
322: p_rec.budget_unit2_value :=
323: pqh_bst_shd.g_old_rec.budget_unit2_value;
324: End If;
325: If (p_rec.budget_unit3_value = hr_api.g_number) then

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

321: If (p_rec.budget_unit2_value = hr_api.g_number) then
322: p_rec.budget_unit2_value :=
323: pqh_bst_shd.g_old_rec.budget_unit2_value;
324: End If;
325: If (p_rec.budget_unit3_value = hr_api.g_number) then
326: p_rec.budget_unit3_value :=
327: pqh_bst_shd.g_old_rec.budget_unit3_value;
328: End If;
329: If (p_rec.budget_unit1_available = hr_api.g_number) then

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

325: If (p_rec.budget_unit3_value = hr_api.g_number) then
326: p_rec.budget_unit3_value :=
327: pqh_bst_shd.g_old_rec.budget_unit3_value;
328: End If;
329: If (p_rec.budget_unit1_available = hr_api.g_number) then
330: p_rec.budget_unit1_available :=
331: pqh_bst_shd.g_old_rec.budget_unit1_available;
332: End If;
333: If (p_rec.budget_unit2_available = hr_api.g_number) then

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

329: If (p_rec.budget_unit1_available = hr_api.g_number) then
330: p_rec.budget_unit1_available :=
331: pqh_bst_shd.g_old_rec.budget_unit1_available;
332: End If;
333: If (p_rec.budget_unit2_available = hr_api.g_number) then
334: p_rec.budget_unit2_available :=
335: pqh_bst_shd.g_old_rec.budget_unit2_available;
336: End If;
337: If (p_rec.budget_unit3_available = hr_api.g_number) then

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

333: If (p_rec.budget_unit2_available = hr_api.g_number) then
334: p_rec.budget_unit2_available :=
335: pqh_bst_shd.g_old_rec.budget_unit2_available;
336: End If;
337: If (p_rec.budget_unit3_available = hr_api.g_number) then
338: p_rec.budget_unit3_available :=
339: pqh_bst_shd.g_old_rec.budget_unit3_available;
340: End If;
341: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then

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

337: If (p_rec.budget_unit3_available = hr_api.g_number) then
338: p_rec.budget_unit3_available :=
339: pqh_bst_shd.g_old_rec.budget_unit3_available;
340: End If;
341: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
342: p_rec.budget_unit1_value_type_cd :=
343: pqh_bst_shd.g_old_rec.budget_unit1_value_type_cd;
344: End If;
345: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then

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

341: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
342: p_rec.budget_unit1_value_type_cd :=
343: pqh_bst_shd.g_old_rec.budget_unit1_value_type_cd;
344: End If;
345: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
346: p_rec.budget_unit2_value_type_cd :=
347: pqh_bst_shd.g_old_rec.budget_unit2_value_type_cd;
348: End If;
349: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then

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

345: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
346: p_rec.budget_unit2_value_type_cd :=
347: pqh_bst_shd.g_old_rec.budget_unit2_value_type_cd;
348: End If;
349: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
350: p_rec.budget_unit3_value_type_cd :=
351: pqh_bst_shd.g_old_rec.budget_unit3_value_type_cd;
352: End If;
353: --

Line 411: p_dflt_budget_set_id in number default hr_api.g_number,

407: Procedure upd
408: (
409: p_effective_date in date,
410: p_budget_set_id in number,
411: p_dflt_budget_set_id in number default hr_api.g_number,
412: p_budget_period_id in number default hr_api.g_number,
413: p_budget_unit1_percent in number default hr_api.g_number,
414: p_budget_unit2_percent in number default hr_api.g_number,
415: p_budget_unit3_percent in number default hr_api.g_number,

Line 412: p_budget_period_id in number default hr_api.g_number,

408: (
409: p_effective_date in date,
410: p_budget_set_id in number,
411: p_dflt_budget_set_id in number default hr_api.g_number,
412: p_budget_period_id in number default hr_api.g_number,
413: p_budget_unit1_percent in number default hr_api.g_number,
414: p_budget_unit2_percent in number default hr_api.g_number,
415: p_budget_unit3_percent in number default hr_api.g_number,
416: p_budget_unit1_value in number default hr_api.g_number,

Line 413: p_budget_unit1_percent in number default hr_api.g_number,

409: p_effective_date in date,
410: p_budget_set_id in number,
411: p_dflt_budget_set_id in number default hr_api.g_number,
412: p_budget_period_id in number default hr_api.g_number,
413: p_budget_unit1_percent in number default hr_api.g_number,
414: p_budget_unit2_percent in number default hr_api.g_number,
415: p_budget_unit3_percent in number default hr_api.g_number,
416: p_budget_unit1_value in number default hr_api.g_number,
417: p_budget_unit2_value in number default hr_api.g_number,

Line 414: p_budget_unit2_percent in number default hr_api.g_number,

410: p_budget_set_id in number,
411: p_dflt_budget_set_id in number default hr_api.g_number,
412: p_budget_period_id in number default hr_api.g_number,
413: p_budget_unit1_percent in number default hr_api.g_number,
414: p_budget_unit2_percent in number default hr_api.g_number,
415: p_budget_unit3_percent in number default hr_api.g_number,
416: p_budget_unit1_value in number default hr_api.g_number,
417: p_budget_unit2_value in number default hr_api.g_number,
418: p_budget_unit3_value in number default hr_api.g_number,

Line 415: p_budget_unit3_percent in number default hr_api.g_number,

411: p_dflt_budget_set_id in number default hr_api.g_number,
412: p_budget_period_id in number default hr_api.g_number,
413: p_budget_unit1_percent in number default hr_api.g_number,
414: p_budget_unit2_percent in number default hr_api.g_number,
415: p_budget_unit3_percent in number default hr_api.g_number,
416: p_budget_unit1_value in number default hr_api.g_number,
417: p_budget_unit2_value in number default hr_api.g_number,
418: p_budget_unit3_value in number default hr_api.g_number,
419: p_budget_unit1_available in number default hr_api.g_number,

Line 416: p_budget_unit1_value in number default hr_api.g_number,

412: p_budget_period_id in number default hr_api.g_number,
413: p_budget_unit1_percent in number default hr_api.g_number,
414: p_budget_unit2_percent in number default hr_api.g_number,
415: p_budget_unit3_percent in number default hr_api.g_number,
416: p_budget_unit1_value in number default hr_api.g_number,
417: p_budget_unit2_value in number default hr_api.g_number,
418: p_budget_unit3_value in number default hr_api.g_number,
419: p_budget_unit1_available in number default hr_api.g_number,
420: p_budget_unit2_available in number default hr_api.g_number,

Line 417: p_budget_unit2_value in number default hr_api.g_number,

413: p_budget_unit1_percent in number default hr_api.g_number,
414: p_budget_unit2_percent in number default hr_api.g_number,
415: p_budget_unit3_percent in number default hr_api.g_number,
416: p_budget_unit1_value in number default hr_api.g_number,
417: p_budget_unit2_value in number default hr_api.g_number,
418: p_budget_unit3_value in number default hr_api.g_number,
419: p_budget_unit1_available in number default hr_api.g_number,
420: p_budget_unit2_available in number default hr_api.g_number,
421: p_budget_unit3_available in number default hr_api.g_number,

Line 418: p_budget_unit3_value in number default hr_api.g_number,

414: p_budget_unit2_percent in number default hr_api.g_number,
415: p_budget_unit3_percent in number default hr_api.g_number,
416: p_budget_unit1_value in number default hr_api.g_number,
417: p_budget_unit2_value in number default hr_api.g_number,
418: p_budget_unit3_value in number default hr_api.g_number,
419: p_budget_unit1_available in number default hr_api.g_number,
420: p_budget_unit2_available in number default hr_api.g_number,
421: p_budget_unit3_available in number default hr_api.g_number,
422: p_object_version_number in out nocopy number,

Line 419: p_budget_unit1_available in number default hr_api.g_number,

415: p_budget_unit3_percent in number default hr_api.g_number,
416: p_budget_unit1_value in number default hr_api.g_number,
417: p_budget_unit2_value in number default hr_api.g_number,
418: p_budget_unit3_value in number default hr_api.g_number,
419: p_budget_unit1_available in number default hr_api.g_number,
420: p_budget_unit2_available in number default hr_api.g_number,
421: p_budget_unit3_available in number default hr_api.g_number,
422: p_object_version_number in out nocopy number,
423: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,

Line 420: p_budget_unit2_available in number default hr_api.g_number,

416: p_budget_unit1_value in number default hr_api.g_number,
417: p_budget_unit2_value in number default hr_api.g_number,
418: p_budget_unit3_value in number default hr_api.g_number,
419: p_budget_unit1_available in number default hr_api.g_number,
420: p_budget_unit2_available in number default hr_api.g_number,
421: p_budget_unit3_available in number default hr_api.g_number,
422: p_object_version_number in out nocopy number,
423: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
424: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,

Line 421: p_budget_unit3_available in number default hr_api.g_number,

417: p_budget_unit2_value in number default hr_api.g_number,
418: p_budget_unit3_value in number default hr_api.g_number,
419: p_budget_unit1_available in number default hr_api.g_number,
420: p_budget_unit2_available in number default hr_api.g_number,
421: p_budget_unit3_available in number default hr_api.g_number,
422: p_object_version_number in out nocopy number,
423: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
424: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
425: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

Line 423: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,

419: p_budget_unit1_available in number default hr_api.g_number,
420: p_budget_unit2_available in number default hr_api.g_number,
421: p_budget_unit3_available in number default hr_api.g_number,
422: p_object_version_number in out nocopy number,
423: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
424: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
425: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
426: ) is
427: --

Line 424: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,

420: p_budget_unit2_available in number default hr_api.g_number,
421: p_budget_unit3_available in number default hr_api.g_number,
422: p_object_version_number in out nocopy number,
423: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
424: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
425: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
426: ) is
427: --
428: l_rec pqh_bst_shd.g_rec_type;

Line 425: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

421: p_budget_unit3_available in number default hr_api.g_number,
422: p_object_version_number in out nocopy number,
423: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
424: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
425: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
426: ) is
427: --
428: l_rec pqh_bst_shd.g_rec_type;
429: l_proc varchar2(72) := g_package||'upd';