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.PAY_RAN_UPD dependencies on HR_API

Line 94: When hr_api.check_integrity_violated Then

90: --
91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: --
93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: --
97: pay_ran_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: --
97: pay_ran_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: --
102: pay_ran_shd.constraint_error

Line 99: When hr_api.parent_integrity_violated Then

95: -- A check constraint has been violated
96: --
97: pay_ran_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: --
102: pay_ran_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: --
102: pay_ran_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: --
107: pay_ran_shd.constraint_error

Line 104: When hr_api.unique_integrity_violated Then

100: -- Parent integrity has been violated
101: --
102: pay_ran_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: --
107: pay_ran_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: --
107: pay_ran_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: --
111: Raise;
112: End update_dml;

Line 234: when hr_api.cannot_find_prog_unit then

230: );
231: --
232: exception
233: --
234: when hr_api.cannot_find_prog_unit then
235: --
236: hr_api.cannot_find_prog_unit_error
237: (p_module_name => 'PAY_RANGES_F'
238: ,p_hook_type => 'AU');

Line 236: hr_api.cannot_find_prog_unit_error

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

Line 299: If (p_rec.range_table_id = hr_api.g_number) then

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

Line 303: If (p_rec.low_band = hr_api.g_number) then

299: If (p_rec.range_table_id = hr_api.g_number) then
300: p_rec.range_table_id :=
301: pay_ran_shd.g_old_rec.range_table_id;
302: End If;
303: If (p_rec.low_band = hr_api.g_number) then
304: p_rec.low_band :=
305: pay_ran_shd.g_old_rec.low_band;
306: End If;
307: If (p_rec.high_band = hr_api.g_number) then

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

303: If (p_rec.low_band = hr_api.g_number) then
304: p_rec.low_band :=
305: pay_ran_shd.g_old_rec.low_band;
306: End If;
307: If (p_rec.high_band = hr_api.g_number) then
308: p_rec.high_band :=
309: pay_ran_shd.g_old_rec.high_band;
310: End If;
311: If (p_rec.amount1 = hr_api.g_number) then

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

307: If (p_rec.high_band = hr_api.g_number) then
308: p_rec.high_band :=
309: pay_ran_shd.g_old_rec.high_band;
310: End If;
311: If (p_rec.amount1 = hr_api.g_number) then
312: p_rec.amount1 := pay_ran_shd.g_old_rec.amount1;
313: End If;
314: If (p_rec.amount2 = hr_api.g_number) then
315: p_rec.amount2 := pay_ran_shd.g_old_rec.amount2;

Line 314: If (p_rec.amount2 = hr_api.g_number) then

310: End If;
311: If (p_rec.amount1 = hr_api.g_number) then
312: p_rec.amount1 := pay_ran_shd.g_old_rec.amount1;
313: End If;
314: If (p_rec.amount2 = hr_api.g_number) then
315: p_rec.amount2 := pay_ran_shd.g_old_rec.amount2;
316: End If;
317: If (p_rec.amount3 = hr_api.g_number) then
318: p_rec.amount3 := pay_ran_shd.g_old_rec.amount3;

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

313: End If;
314: If (p_rec.amount2 = hr_api.g_number) then
315: p_rec.amount2 := pay_ran_shd.g_old_rec.amount2;
316: End If;
317: If (p_rec.amount3 = hr_api.g_number) then
318: p_rec.amount3 := pay_ran_shd.g_old_rec.amount3;
319: End If;
320: If (p_rec.amount4 = hr_api.g_number) then
321: p_rec.amount4 := pay_ran_shd.g_old_rec.amount4;

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

316: End If;
317: If (p_rec.amount3 = hr_api.g_number) then
318: p_rec.amount3 := pay_ran_shd.g_old_rec.amount3;
319: End If;
320: If (p_rec.amount4 = hr_api.g_number) then
321: p_rec.amount4 := pay_ran_shd.g_old_rec.amount4;
322: End If;
323: If (p_rec.amount5 = hr_api.g_number) then
324: p_rec.amount5 := pay_ran_shd.g_old_rec.amount5;

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

319: End If;
320: If (p_rec.amount4 = hr_api.g_number) then
321: p_rec.amount4 := pay_ran_shd.g_old_rec.amount4;
322: End If;
323: If (p_rec.amount5 = hr_api.g_number) then
324: p_rec.amount5 := pay_ran_shd.g_old_rec.amount5;
325: End If;
326: If (p_rec.amount6 = hr_api.g_number) then
327: p_rec.amount6 := pay_ran_shd.g_old_rec.amount6;

Line 326: If (p_rec.amount6 = hr_api.g_number) then

322: End If;
323: If (p_rec.amount5 = hr_api.g_number) then
324: p_rec.amount5 := pay_ran_shd.g_old_rec.amount5;
325: End If;
326: If (p_rec.amount6 = hr_api.g_number) then
327: p_rec.amount6 := pay_ran_shd.g_old_rec.amount6;
328: End If;
329: If (p_rec.amount7 = hr_api.g_number) then
330: p_rec.amount7 := pay_ran_shd.g_old_rec.amount7;

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

325: End If;
326: If (p_rec.amount6 = hr_api.g_number) then
327: p_rec.amount6 := pay_ran_shd.g_old_rec.amount6;
328: End If;
329: If (p_rec.amount7 = hr_api.g_number) then
330: p_rec.amount7 := pay_ran_shd.g_old_rec.amount7;
331: End If;
332: If (p_rec.amount8 = hr_api.g_number) then
333: p_rec.amount8 := pay_ran_shd.g_old_rec.amount8;

Line 332: If (p_rec.amount8 = hr_api.g_number) then

328: End If;
329: If (p_rec.amount7 = hr_api.g_number) then
330: p_rec.amount7 := pay_ran_shd.g_old_rec.amount7;
331: End If;
332: If (p_rec.amount8 = hr_api.g_number) then
333: p_rec.amount8 := pay_ran_shd.g_old_rec.amount8;
334: End If;
335:
336: If (p_rec.effective_start_date = hr_api.g_date) then

Line 336: If (p_rec.effective_start_date = hr_api.g_date) then

332: If (p_rec.amount8 = hr_api.g_number) then
333: p_rec.amount8 := pay_ran_shd.g_old_rec.amount8;
334: End If;
335:
336: If (p_rec.effective_start_date = hr_api.g_date) then
337: p_rec.effective_start_date :=
338: pay_ran_shd.g_old_rec.effective_start_date;
339: End If;
340: If (p_rec.effective_end_date = hr_api.g_date) then

Line 340: If (p_rec.effective_end_date = hr_api.g_date) then

336: If (p_rec.effective_start_date = hr_api.g_date) then
337: p_rec.effective_start_date :=
338: pay_ran_shd.g_old_rec.effective_start_date;
339: End If;
340: If (p_rec.effective_end_date = hr_api.g_date) then
341: p_rec.effective_end_date :=
342: pay_ran_shd.g_old_rec.effective_end_date;
343: End If;
344: --

Line 408: ,p_range_table_id in number default hr_api.g_number

404: -- ----------------------------------------------------------------------------
405: Procedure upd
406: (p_range_id in number
407: ,p_object_version_number in out nocopy number
408: ,p_range_table_id in number default hr_api.g_number
409: ,p_low_band in number default hr_api.g_number
410: ,p_high_band in number default hr_api.g_number
411: ,p_amount1 in number default hr_api.g_number
412: ,p_amount2 in number default hr_api.g_number

Line 409: ,p_low_band in number default hr_api.g_number

405: Procedure upd
406: (p_range_id in number
407: ,p_object_version_number in out nocopy number
408: ,p_range_table_id in number default hr_api.g_number
409: ,p_low_band in number default hr_api.g_number
410: ,p_high_band in number default hr_api.g_number
411: ,p_amount1 in number default hr_api.g_number
412: ,p_amount2 in number default hr_api.g_number
413: ,p_amount3 in number default hr_api.g_number

Line 410: ,p_high_band in number default hr_api.g_number

406: (p_range_id in number
407: ,p_object_version_number in out nocopy number
408: ,p_range_table_id in number default hr_api.g_number
409: ,p_low_band in number default hr_api.g_number
410: ,p_high_band in number default hr_api.g_number
411: ,p_amount1 in number default hr_api.g_number
412: ,p_amount2 in number default hr_api.g_number
413: ,p_amount3 in number default hr_api.g_number
414: ,p_amount4 in number default hr_api.g_number

Line 411: ,p_amount1 in number default hr_api.g_number

407: ,p_object_version_number in out nocopy number
408: ,p_range_table_id in number default hr_api.g_number
409: ,p_low_band in number default hr_api.g_number
410: ,p_high_band in number default hr_api.g_number
411: ,p_amount1 in number default hr_api.g_number
412: ,p_amount2 in number default hr_api.g_number
413: ,p_amount3 in number default hr_api.g_number
414: ,p_amount4 in number default hr_api.g_number
415: ,p_amount5 in number default hr_api.g_number

Line 412: ,p_amount2 in number default hr_api.g_number

408: ,p_range_table_id in number default hr_api.g_number
409: ,p_low_band in number default hr_api.g_number
410: ,p_high_band in number default hr_api.g_number
411: ,p_amount1 in number default hr_api.g_number
412: ,p_amount2 in number default hr_api.g_number
413: ,p_amount3 in number default hr_api.g_number
414: ,p_amount4 in number default hr_api.g_number
415: ,p_amount5 in number default hr_api.g_number
416: ,p_amount6 in number default hr_api.g_number

Line 413: ,p_amount3 in number default hr_api.g_number

409: ,p_low_band in number default hr_api.g_number
410: ,p_high_band in number default hr_api.g_number
411: ,p_amount1 in number default hr_api.g_number
412: ,p_amount2 in number default hr_api.g_number
413: ,p_amount3 in number default hr_api.g_number
414: ,p_amount4 in number default hr_api.g_number
415: ,p_amount5 in number default hr_api.g_number
416: ,p_amount6 in number default hr_api.g_number
417: ,p_amount7 in number default hr_api.g_number

Line 414: ,p_amount4 in number default hr_api.g_number

410: ,p_high_band in number default hr_api.g_number
411: ,p_amount1 in number default hr_api.g_number
412: ,p_amount2 in number default hr_api.g_number
413: ,p_amount3 in number default hr_api.g_number
414: ,p_amount4 in number default hr_api.g_number
415: ,p_amount5 in number default hr_api.g_number
416: ,p_amount6 in number default hr_api.g_number
417: ,p_amount7 in number default hr_api.g_number
418: ,p_amount8 in number default hr_api.g_number

Line 415: ,p_amount5 in number default hr_api.g_number

411: ,p_amount1 in number default hr_api.g_number
412: ,p_amount2 in number default hr_api.g_number
413: ,p_amount3 in number default hr_api.g_number
414: ,p_amount4 in number default hr_api.g_number
415: ,p_amount5 in number default hr_api.g_number
416: ,p_amount6 in number default hr_api.g_number
417: ,p_amount7 in number default hr_api.g_number
418: ,p_amount8 in number default hr_api.g_number
419: ,p_effective_start_date in date default hr_api.g_date

Line 416: ,p_amount6 in number default hr_api.g_number

412: ,p_amount2 in number default hr_api.g_number
413: ,p_amount3 in number default hr_api.g_number
414: ,p_amount4 in number default hr_api.g_number
415: ,p_amount5 in number default hr_api.g_number
416: ,p_amount6 in number default hr_api.g_number
417: ,p_amount7 in number default hr_api.g_number
418: ,p_amount8 in number default hr_api.g_number
419: ,p_effective_start_date in date default hr_api.g_date
420: ,p_effective_end_date in date default hr_api.g_date

Line 417: ,p_amount7 in number default hr_api.g_number

413: ,p_amount3 in number default hr_api.g_number
414: ,p_amount4 in number default hr_api.g_number
415: ,p_amount5 in number default hr_api.g_number
416: ,p_amount6 in number default hr_api.g_number
417: ,p_amount7 in number default hr_api.g_number
418: ,p_amount8 in number default hr_api.g_number
419: ,p_effective_start_date in date default hr_api.g_date
420: ,p_effective_end_date in date default hr_api.g_date
421: ) is

Line 418: ,p_amount8 in number default hr_api.g_number

414: ,p_amount4 in number default hr_api.g_number
415: ,p_amount5 in number default hr_api.g_number
416: ,p_amount6 in number default hr_api.g_number
417: ,p_amount7 in number default hr_api.g_number
418: ,p_amount8 in number default hr_api.g_number
419: ,p_effective_start_date in date default hr_api.g_date
420: ,p_effective_end_date in date default hr_api.g_date
421: ) is
422: --

Line 419: ,p_effective_start_date in date default hr_api.g_date

415: ,p_amount5 in number default hr_api.g_number
416: ,p_amount6 in number default hr_api.g_number
417: ,p_amount7 in number default hr_api.g_number
418: ,p_amount8 in number default hr_api.g_number
419: ,p_effective_start_date in date default hr_api.g_date
420: ,p_effective_end_date in date default hr_api.g_date
421: ) is
422: --
423: l_rec pay_ran_shd.g_rec_type;

Line 420: ,p_effective_end_date in date default hr_api.g_date

416: ,p_amount6 in number default hr_api.g_number
417: ,p_amount7 in number default hr_api.g_number
418: ,p_amount8 in number default hr_api.g_number
419: ,p_effective_start_date in date default hr_api.g_date
420: ,p_effective_end_date in date default hr_api.g_date
421: ) is
422: --
423: l_rec pay_ran_shd.g_rec_type;
424: l_proc varchar2(72) := g_package||'upd';