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.HR_DTY_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: --
89: hr_dty_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: --
89: hr_dty_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: --
94: hr_dty_shd.constraint_error

Line 91: When hr_api.parent_integrity_violated Then

87: -- A check constraint has been violated
88: --
89: hr_dty_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: --
94: hr_dty_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --
94: hr_dty_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: --
99: hr_dty_shd.constraint_error

Line 96: When hr_api.unique_integrity_violated Then

92: -- Parent integrity has been violated
93: --
94: hr_dty_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: --
99: hr_dty_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 249: when hr_api.cannot_find_prog_unit then

245: );
246: --
247: exception
248: --
249: when hr_api.cannot_find_prog_unit then
250: --
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'HR_DOCUMENT_TYPES'
253: ,p_hook_type => 'AU');

Line 251: hr_api.cannot_find_prog_unit_error

247: exception
248: --
249: when hr_api.cannot_find_prog_unit then
250: --
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'HR_DOCUMENT_TYPES'
253: ,p_hook_type => 'AU');
254: --
255: end;

Line 314: If (p_rec.category_code = hr_api.g_varchar2) then

310: -- p_rec plsql record structure
311: -- to see if a system default is being used. If a system default
312: -- is being used then we must set to the 'current' argument value.
313: --
314: If (p_rec.category_code = hr_api.g_varchar2) then
315: p_rec.category_code :=
316: hr_dty_shd.g_old_rec.category_code;
317: End If;
318: If (p_rec.sub_category_code = hr_api.g_varchar2) then

Line 318: If (p_rec.sub_category_code = hr_api.g_varchar2) then

314: If (p_rec.category_code = hr_api.g_varchar2) then
315: p_rec.category_code :=
316: hr_dty_shd.g_old_rec.category_code;
317: End If;
318: If (p_rec.sub_category_code = hr_api.g_varchar2) then
319: p_rec.sub_category_code :=
320: hr_dty_shd.g_old_rec.sub_category_code;
321: End If;
322: If (p_rec.active_inactive_flag = hr_api.g_varchar2) then

Line 322: If (p_rec.active_inactive_flag = hr_api.g_varchar2) then

318: If (p_rec.sub_category_code = hr_api.g_varchar2) then
319: p_rec.sub_category_code :=
320: hr_dty_shd.g_old_rec.sub_category_code;
321: End If;
322: If (p_rec.active_inactive_flag = hr_api.g_varchar2) then
323: p_rec.active_inactive_flag :=
324: hr_dty_shd.g_old_rec.active_inactive_flag;
325: End If;
326: If (p_rec.multiple_occurences_flag = hr_api.g_varchar2) then

Line 326: If (p_rec.multiple_occurences_flag = hr_api.g_varchar2) then

322: If (p_rec.active_inactive_flag = hr_api.g_varchar2) then
323: p_rec.active_inactive_flag :=
324: hr_dty_shd.g_old_rec.active_inactive_flag;
325: End If;
326: If (p_rec.multiple_occurences_flag = hr_api.g_varchar2) then
327: p_rec.multiple_occurences_flag :=
328: hr_dty_shd.g_old_rec.multiple_occurences_flag;
329: End If;
330: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 330: If (p_rec.legislation_code = hr_api.g_varchar2) then

326: If (p_rec.multiple_occurences_flag = hr_api.g_varchar2) then
327: p_rec.multiple_occurences_flag :=
328: hr_dty_shd.g_old_rec.multiple_occurences_flag;
329: End If;
330: If (p_rec.legislation_code = hr_api.g_varchar2) then
331: p_rec.legislation_code :=
332: hr_dty_shd.g_old_rec.legislation_code;
333: End If;
334: If (p_rec.authorization_required = hr_api.g_varchar2) then

Line 334: If (p_rec.authorization_required = hr_api.g_varchar2) then

330: If (p_rec.legislation_code = hr_api.g_varchar2) then
331: p_rec.legislation_code :=
332: hr_dty_shd.g_old_rec.legislation_code;
333: End If;
334: If (p_rec.authorization_required = hr_api.g_varchar2) then
335: p_rec.authorization_required :=
336: hr_dty_shd.g_old_rec.authorization_required;
337: End If;
338: If (p_rec.warning_period = hr_api.g_number) then

Line 338: If (p_rec.warning_period = hr_api.g_number) then

334: If (p_rec.authorization_required = hr_api.g_varchar2) then
335: p_rec.authorization_required :=
336: hr_dty_shd.g_old_rec.authorization_required;
337: End If;
338: If (p_rec.warning_period = hr_api.g_number) then
339: p_rec.warning_period :=
340: hr_dty_shd.g_old_rec.warning_period;
341: End If;
342: If (p_rec.request_id = hr_api.g_number) then

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

338: If (p_rec.warning_period = hr_api.g_number) then
339: p_rec.warning_period :=
340: hr_dty_shd.g_old_rec.warning_period;
341: End If;
342: If (p_rec.request_id = hr_api.g_number) then
343: p_rec.request_id :=
344: hr_dty_shd.g_old_rec.request_id;
345: End If;
346: If (p_rec.program_application_id = hr_api.g_number) then

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

342: If (p_rec.request_id = hr_api.g_number) then
343: p_rec.request_id :=
344: hr_dty_shd.g_old_rec.request_id;
345: End If;
346: If (p_rec.program_application_id = hr_api.g_number) then
347: p_rec.program_application_id :=
348: hr_dty_shd.g_old_rec.program_application_id;
349: End If;
350: If (p_rec.program_id = hr_api.g_number) then

Line 350: If (p_rec.program_id = hr_api.g_number) then

346: If (p_rec.program_application_id = hr_api.g_number) then
347: p_rec.program_application_id :=
348: hr_dty_shd.g_old_rec.program_application_id;
349: End If;
350: If (p_rec.program_id = hr_api.g_number) then
351: p_rec.program_id :=
352: hr_dty_shd.g_old_rec.program_id;
353: End If;
354: If (p_rec.program_update_date = hr_api.g_date) then

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

350: If (p_rec.program_id = hr_api.g_number) then
351: p_rec.program_id :=
352: hr_dty_shd.g_old_rec.program_id;
353: End If;
354: If (p_rec.program_update_date = hr_api.g_date) then
355: p_rec.program_update_date :=
356: hr_dty_shd.g_old_rec.program_update_date;
357: End If;
358: --

Line 427: ,p_category_code in varchar2 default hr_api.g_varchar2

423: Procedure upd
424: (p_effective_date in date
425: ,p_document_type_id in number
426: ,p_object_version_number in out nocopy number
427: ,p_category_code in varchar2 default hr_api.g_varchar2
428: ,p_active_inactive_flag in varchar2 default hr_api.g_varchar2
429: ,p_multiple_occurences_flag in varchar2 default hr_api.g_varchar2
430: ,p_legislation_code in varchar2 default hr_api.g_varchar2
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2

Line 428: ,p_active_inactive_flag in varchar2 default hr_api.g_varchar2

424: (p_effective_date in date
425: ,p_document_type_id in number
426: ,p_object_version_number in out nocopy number
427: ,p_category_code in varchar2 default hr_api.g_varchar2
428: ,p_active_inactive_flag in varchar2 default hr_api.g_varchar2
429: ,p_multiple_occurences_flag in varchar2 default hr_api.g_varchar2
430: ,p_legislation_code in varchar2 default hr_api.g_varchar2
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2

Line 429: ,p_multiple_occurences_flag in varchar2 default hr_api.g_varchar2

425: ,p_document_type_id in number
426: ,p_object_version_number in out nocopy number
427: ,p_category_code in varchar2 default hr_api.g_varchar2
428: ,p_active_inactive_flag in varchar2 default hr_api.g_varchar2
429: ,p_multiple_occurences_flag in varchar2 default hr_api.g_varchar2
430: ,p_legislation_code in varchar2 default hr_api.g_varchar2
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
433: ,p_warning_period in number default hr_api.g_number

Line 430: ,p_legislation_code in varchar2 default hr_api.g_varchar2

426: ,p_object_version_number in out nocopy number
427: ,p_category_code in varchar2 default hr_api.g_varchar2
428: ,p_active_inactive_flag in varchar2 default hr_api.g_varchar2
429: ,p_multiple_occurences_flag in varchar2 default hr_api.g_varchar2
430: ,p_legislation_code in varchar2 default hr_api.g_varchar2
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
433: ,p_warning_period in number default hr_api.g_number
434: ,p_request_id in number default hr_api.g_number

Line 431: ,p_authorization_required in varchar2 default hr_api.g_varchar2

427: ,p_category_code in varchar2 default hr_api.g_varchar2
428: ,p_active_inactive_flag in varchar2 default hr_api.g_varchar2
429: ,p_multiple_occurences_flag in varchar2 default hr_api.g_varchar2
430: ,p_legislation_code in varchar2 default hr_api.g_varchar2
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
433: ,p_warning_period in number default hr_api.g_number
434: ,p_request_id in number default hr_api.g_number
435: ,p_program_application_id in number default hr_api.g_number

Line 432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2

428: ,p_active_inactive_flag in varchar2 default hr_api.g_varchar2
429: ,p_multiple_occurences_flag in varchar2 default hr_api.g_varchar2
430: ,p_legislation_code in varchar2 default hr_api.g_varchar2
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
433: ,p_warning_period in number default hr_api.g_number
434: ,p_request_id in number default hr_api.g_number
435: ,p_program_application_id in number default hr_api.g_number
436: ,p_program_id in number default hr_api.g_number

Line 433: ,p_warning_period in number default hr_api.g_number

429: ,p_multiple_occurences_flag in varchar2 default hr_api.g_varchar2
430: ,p_legislation_code in varchar2 default hr_api.g_varchar2
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
433: ,p_warning_period in number default hr_api.g_number
434: ,p_request_id in number default hr_api.g_number
435: ,p_program_application_id in number default hr_api.g_number
436: ,p_program_id in number default hr_api.g_number
437: ,p_program_update_date in date default hr_api.g_date

Line 434: ,p_request_id in number default hr_api.g_number

430: ,p_legislation_code in varchar2 default hr_api.g_varchar2
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
433: ,p_warning_period in number default hr_api.g_number
434: ,p_request_id in number default hr_api.g_number
435: ,p_program_application_id in number default hr_api.g_number
436: ,p_program_id in number default hr_api.g_number
437: ,p_program_update_date in date default hr_api.g_date
438: ) is

Line 435: ,p_program_application_id in number default hr_api.g_number

431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
433: ,p_warning_period in number default hr_api.g_number
434: ,p_request_id in number default hr_api.g_number
435: ,p_program_application_id in number default hr_api.g_number
436: ,p_program_id in number default hr_api.g_number
437: ,p_program_update_date in date default hr_api.g_date
438: ) is
439: --

Line 436: ,p_program_id in number default hr_api.g_number

432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
433: ,p_warning_period in number default hr_api.g_number
434: ,p_request_id in number default hr_api.g_number
435: ,p_program_application_id in number default hr_api.g_number
436: ,p_program_id in number default hr_api.g_number
437: ,p_program_update_date in date default hr_api.g_date
438: ) is
439: --
440: l_rec hr_dty_shd.g_rec_type;

Line 437: ,p_program_update_date in date default hr_api.g_date

433: ,p_warning_period in number default hr_api.g_number
434: ,p_request_id in number default hr_api.g_number
435: ,p_program_application_id in number default hr_api.g_number
436: ,p_program_id in number default hr_api.g_number
437: ,p_program_update_date in date default hr_api.g_date
438: ) is
439: --
440: l_rec hr_dty_shd.g_rec_type;
441: l_proc varchar2(72) := g_package||'upd';