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_WPR_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_wpr_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_wpr_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_wpr_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_wpr_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_wpr_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_wpr_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_wpr_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_wpr_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_wpr_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_wpr_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 230: when hr_api.cannot_find_prog_unit then

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

Line 232: hr_api.cannot_find_prog_unit_error

228: exception
229: --
230: when hr_api.cannot_find_prog_unit then
231: --
232: hr_api.cannot_find_prog_unit_error
233: (p_module_name => 'pqh_worksheet_periods'
234: ,p_hook_type => 'AU');
235: --
236: end;

Line 300: If (p_rec.end_time_period_id = hr_api.g_number) then

296: -- p_rec plsql record structure
297: -- to see if a system default is being used. If a system default
298: -- is being used then we must set to the 'current' argument value.
299: --
300: If (p_rec.end_time_period_id = hr_api.g_number) then
301: p_rec.end_time_period_id :=
302: pqh_wpr_shd.g_old_rec.end_time_period_id;
303: End If;
304: If (p_rec.worksheet_detail_id = hr_api.g_number) then

Line 304: If (p_rec.worksheet_detail_id = hr_api.g_number) then

300: If (p_rec.end_time_period_id = hr_api.g_number) then
301: p_rec.end_time_period_id :=
302: pqh_wpr_shd.g_old_rec.end_time_period_id;
303: End If;
304: If (p_rec.worksheet_detail_id = hr_api.g_number) then
305: p_rec.worksheet_detail_id :=
306: pqh_wpr_shd.g_old_rec.worksheet_detail_id;
307: End If;
308: If (p_rec.budget_unit1_percent = hr_api.g_number) then

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

304: If (p_rec.worksheet_detail_id = hr_api.g_number) then
305: p_rec.worksheet_detail_id :=
306: pqh_wpr_shd.g_old_rec.worksheet_detail_id;
307: End If;
308: If (p_rec.budget_unit1_percent = hr_api.g_number) then
309: p_rec.budget_unit1_percent :=
310: pqh_wpr_shd.g_old_rec.budget_unit1_percent;
311: End If;
312: If (p_rec.budget_unit2_percent = hr_api.g_number) then

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

308: If (p_rec.budget_unit1_percent = hr_api.g_number) then
309: p_rec.budget_unit1_percent :=
310: pqh_wpr_shd.g_old_rec.budget_unit1_percent;
311: End If;
312: If (p_rec.budget_unit2_percent = hr_api.g_number) then
313: p_rec.budget_unit2_percent :=
314: pqh_wpr_shd.g_old_rec.budget_unit2_percent;
315: End If;
316: If (p_rec.budget_unit3_percent = hr_api.g_number) then

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

312: If (p_rec.budget_unit2_percent = hr_api.g_number) then
313: p_rec.budget_unit2_percent :=
314: pqh_wpr_shd.g_old_rec.budget_unit2_percent;
315: End If;
316: If (p_rec.budget_unit3_percent = hr_api.g_number) then
317: p_rec.budget_unit3_percent :=
318: pqh_wpr_shd.g_old_rec.budget_unit3_percent;
319: End If;
320: If (p_rec.budget_unit1_value = hr_api.g_number) then

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

316: If (p_rec.budget_unit3_percent = hr_api.g_number) then
317: p_rec.budget_unit3_percent :=
318: pqh_wpr_shd.g_old_rec.budget_unit3_percent;
319: End If;
320: If (p_rec.budget_unit1_value = hr_api.g_number) then
321: p_rec.budget_unit1_value :=
322: pqh_wpr_shd.g_old_rec.budget_unit1_value;
323: End If;
324: If (p_rec.budget_unit2_value = hr_api.g_number) then

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

320: If (p_rec.budget_unit1_value = hr_api.g_number) then
321: p_rec.budget_unit1_value :=
322: pqh_wpr_shd.g_old_rec.budget_unit1_value;
323: End If;
324: If (p_rec.budget_unit2_value = hr_api.g_number) then
325: p_rec.budget_unit2_value :=
326: pqh_wpr_shd.g_old_rec.budget_unit2_value;
327: End If;
328: If (p_rec.budget_unit3_value = hr_api.g_number) then

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

324: If (p_rec.budget_unit2_value = hr_api.g_number) then
325: p_rec.budget_unit2_value :=
326: pqh_wpr_shd.g_old_rec.budget_unit2_value;
327: End If;
328: If (p_rec.budget_unit3_value = hr_api.g_number) then
329: p_rec.budget_unit3_value :=
330: pqh_wpr_shd.g_old_rec.budget_unit3_value;
331: End If;
332: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then

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

328: If (p_rec.budget_unit3_value = hr_api.g_number) then
329: p_rec.budget_unit3_value :=
330: pqh_wpr_shd.g_old_rec.budget_unit3_value;
331: End If;
332: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
333: p_rec.budget_unit1_value_type_cd :=
334: pqh_wpr_shd.g_old_rec.budget_unit1_value_type_cd;
335: End If;
336: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then

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

332: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
333: p_rec.budget_unit1_value_type_cd :=
334: pqh_wpr_shd.g_old_rec.budget_unit1_value_type_cd;
335: End If;
336: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
337: p_rec.budget_unit2_value_type_cd :=
338: pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd;
339: End If;
340: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then

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

336: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
337: p_rec.budget_unit2_value_type_cd :=
338: pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd;
339: End If;
340: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
341: p_rec.budget_unit3_value_type_cd :=
342: pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd;
343: End If;
344: If (p_rec.start_time_period_id = hr_api.g_number) then

Line 344: If (p_rec.start_time_period_id = hr_api.g_number) then

340: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
341: p_rec.budget_unit3_value_type_cd :=
342: pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd;
343: End If;
344: If (p_rec.start_time_period_id = hr_api.g_number) then
345: p_rec.start_time_period_id :=
346: pqh_wpr_shd.g_old_rec.start_time_period_id;
347: End If;
348: If (p_rec.budget_unit3_available = hr_api.g_number) then

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

344: If (p_rec.start_time_period_id = hr_api.g_number) then
345: p_rec.start_time_period_id :=
346: pqh_wpr_shd.g_old_rec.start_time_period_id;
347: End If;
348: If (p_rec.budget_unit3_available = hr_api.g_number) then
349: p_rec.budget_unit3_available :=
350: pqh_wpr_shd.g_old_rec.budget_unit3_available;
351: End If;
352: If (p_rec.budget_unit2_available = hr_api.g_number) then

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

348: If (p_rec.budget_unit3_available = hr_api.g_number) then
349: p_rec.budget_unit3_available :=
350: pqh_wpr_shd.g_old_rec.budget_unit3_available;
351: End If;
352: If (p_rec.budget_unit2_available = hr_api.g_number) then
353: p_rec.budget_unit2_available :=
354: pqh_wpr_shd.g_old_rec.budget_unit2_available;
355: End If;
356: If (p_rec.budget_unit1_available = hr_api.g_number) then

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

352: If (p_rec.budget_unit2_available = hr_api.g_number) then
353: p_rec.budget_unit2_available :=
354: pqh_wpr_shd.g_old_rec.budget_unit2_available;
355: End If;
356: If (p_rec.budget_unit1_available = hr_api.g_number) then
357: p_rec.budget_unit1_available :=
358: pqh_wpr_shd.g_old_rec.budget_unit1_available;
359: End If;
360: --

Line 418: p_end_time_period_id in number default hr_api.g_number,

414: Procedure upd
415: (
416: p_effective_date in date,
417: p_worksheet_period_id in number,
418: p_end_time_period_id in number default hr_api.g_number,
419: p_worksheet_detail_id in number default hr_api.g_number,
420: p_budget_unit1_percent in number default hr_api.g_number,
421: p_budget_unit2_percent in number default hr_api.g_number,
422: p_budget_unit3_percent in number default hr_api.g_number,

Line 419: p_worksheet_detail_id in number default hr_api.g_number,

415: (
416: p_effective_date in date,
417: p_worksheet_period_id in number,
418: p_end_time_period_id in number default hr_api.g_number,
419: p_worksheet_detail_id in number default hr_api.g_number,
420: p_budget_unit1_percent in number default hr_api.g_number,
421: p_budget_unit2_percent in number default hr_api.g_number,
422: p_budget_unit3_percent in number default hr_api.g_number,
423: p_budget_unit1_value in number default hr_api.g_number,

Line 420: p_budget_unit1_percent in number default hr_api.g_number,

416: p_effective_date in date,
417: p_worksheet_period_id in number,
418: p_end_time_period_id in number default hr_api.g_number,
419: p_worksheet_detail_id in number default hr_api.g_number,
420: p_budget_unit1_percent in number default hr_api.g_number,
421: p_budget_unit2_percent in number default hr_api.g_number,
422: p_budget_unit3_percent in number default hr_api.g_number,
423: p_budget_unit1_value in number default hr_api.g_number,
424: p_budget_unit2_value in number default hr_api.g_number,

Line 421: p_budget_unit2_percent in number default hr_api.g_number,

417: p_worksheet_period_id in number,
418: p_end_time_period_id in number default hr_api.g_number,
419: p_worksheet_detail_id in number default hr_api.g_number,
420: p_budget_unit1_percent in number default hr_api.g_number,
421: p_budget_unit2_percent in number default hr_api.g_number,
422: p_budget_unit3_percent in number default hr_api.g_number,
423: p_budget_unit1_value in number default hr_api.g_number,
424: p_budget_unit2_value in number default hr_api.g_number,
425: p_budget_unit3_value in number default hr_api.g_number,

Line 422: p_budget_unit3_percent in number default hr_api.g_number,

418: p_end_time_period_id in number default hr_api.g_number,
419: p_worksheet_detail_id in number default hr_api.g_number,
420: p_budget_unit1_percent in number default hr_api.g_number,
421: p_budget_unit2_percent in number default hr_api.g_number,
422: p_budget_unit3_percent in number default hr_api.g_number,
423: p_budget_unit1_value in number default hr_api.g_number,
424: p_budget_unit2_value in number default hr_api.g_number,
425: p_budget_unit3_value in number default hr_api.g_number,
426: p_object_version_number in out nocopy number,

Line 423: p_budget_unit1_value in number default hr_api.g_number,

419: p_worksheet_detail_id in number default hr_api.g_number,
420: p_budget_unit1_percent in number default hr_api.g_number,
421: p_budget_unit2_percent in number default hr_api.g_number,
422: p_budget_unit3_percent in number default hr_api.g_number,
423: p_budget_unit1_value in number default hr_api.g_number,
424: p_budget_unit2_value in number default hr_api.g_number,
425: p_budget_unit3_value in number default hr_api.g_number,
426: p_object_version_number in out nocopy number,
427: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,

Line 424: p_budget_unit2_value in number default hr_api.g_number,

420: p_budget_unit1_percent in number default hr_api.g_number,
421: p_budget_unit2_percent in number default hr_api.g_number,
422: p_budget_unit3_percent in number default hr_api.g_number,
423: p_budget_unit1_value in number default hr_api.g_number,
424: p_budget_unit2_value in number default hr_api.g_number,
425: p_budget_unit3_value in number default hr_api.g_number,
426: p_object_version_number in out nocopy number,
427: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
428: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,

Line 425: p_budget_unit3_value in number default hr_api.g_number,

421: p_budget_unit2_percent in number default hr_api.g_number,
422: p_budget_unit3_percent in number default hr_api.g_number,
423: p_budget_unit1_value in number default hr_api.g_number,
424: p_budget_unit2_value in number default hr_api.g_number,
425: p_budget_unit3_value in number default hr_api.g_number,
426: p_object_version_number in out nocopy number,
427: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
428: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
429: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,

Line 427: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,

423: p_budget_unit1_value in number default hr_api.g_number,
424: p_budget_unit2_value in number default hr_api.g_number,
425: p_budget_unit3_value in number default hr_api.g_number,
426: p_object_version_number in out nocopy number,
427: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
428: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
429: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
430: p_start_time_period_id in number default hr_api.g_number,
431: p_budget_unit3_available in number default hr_api.g_number,

Line 428: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,

424: p_budget_unit2_value in number default hr_api.g_number,
425: p_budget_unit3_value in number default hr_api.g_number,
426: p_object_version_number in out nocopy number,
427: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
428: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
429: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
430: p_start_time_period_id in number default hr_api.g_number,
431: p_budget_unit3_available in number default hr_api.g_number,
432: p_budget_unit2_available in number default hr_api.g_number,

Line 429: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,

425: p_budget_unit3_value in number default hr_api.g_number,
426: p_object_version_number in out nocopy number,
427: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
428: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
429: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
430: p_start_time_period_id in number default hr_api.g_number,
431: p_budget_unit3_available in number default hr_api.g_number,
432: p_budget_unit2_available in number default hr_api.g_number,
433: p_budget_unit1_available in number default hr_api.g_number

Line 430: p_start_time_period_id in number default hr_api.g_number,

426: p_object_version_number in out nocopy number,
427: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
428: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
429: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
430: p_start_time_period_id in number default hr_api.g_number,
431: p_budget_unit3_available in number default hr_api.g_number,
432: p_budget_unit2_available in number default hr_api.g_number,
433: p_budget_unit1_available in number default hr_api.g_number
434: ) is

Line 431: p_budget_unit3_available in number default hr_api.g_number,

427: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
428: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
429: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
430: p_start_time_period_id in number default hr_api.g_number,
431: p_budget_unit3_available in number default hr_api.g_number,
432: p_budget_unit2_available in number default hr_api.g_number,
433: p_budget_unit1_available in number default hr_api.g_number
434: ) is
435: --

Line 432: p_budget_unit2_available in number default hr_api.g_number,

428: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
429: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
430: p_start_time_period_id in number default hr_api.g_number,
431: p_budget_unit3_available in number default hr_api.g_number,
432: p_budget_unit2_available in number default hr_api.g_number,
433: p_budget_unit1_available in number default hr_api.g_number
434: ) is
435: --
436: l_rec pqh_wpr_shd.g_rec_type;

Line 433: p_budget_unit1_available in number default hr_api.g_number

429: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
430: p_start_time_period_id in number default hr_api.g_number,
431: p_budget_unit3_available in number default hr_api.g_number,
432: p_budget_unit2_available in number default hr_api.g_number,
433: p_budget_unit1_available in number default hr_api.g_number
434: ) is
435: --
436: l_rec pqh_wpr_shd.g_rec_type;
437: l_proc varchar2(72) := g_package||'upd';