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.OTA_CHA_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: --
91: ota_cha_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 93: When hr_api.parent_integrity_violated Then

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

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

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

Line 98: When hr_api.unique_integrity_violated Then

94: -- Parent integrity has been violated
95: --
96: ota_cha_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --
101: ota_cha_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 235: when hr_api.cannot_find_prog_unit then

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

Line 237: hr_api.cannot_find_prog_unit_error

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

Line 300: If (p_rec.business_group_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.business_group_id = hr_api.g_number) then
301: p_rec.business_group_id :=
302: ota_cha_shd.g_old_rec.business_group_id;
303: End If;
304: If (p_rec.public_flag = hr_api.g_varchar2) then

Line 304: If (p_rec.public_flag = hr_api.g_varchar2) then

300: If (p_rec.business_group_id = hr_api.g_number) then
301: p_rec.business_group_id :=
302: ota_cha_shd.g_old_rec.business_group_id;
303: End If;
304: If (p_rec.public_flag = hr_api.g_varchar2) then
305: p_rec.public_flag :=
306: ota_cha_shd.g_old_rec.public_flag;
307: End If;
308: If (p_rec.start_date_active = hr_api.g_date) then

Line 308: If (p_rec.start_date_active = hr_api.g_date) then

304: If (p_rec.public_flag = hr_api.g_varchar2) then
305: p_rec.public_flag :=
306: ota_cha_shd.g_old_rec.public_flag;
307: End If;
308: If (p_rec.start_date_active = hr_api.g_date) then
309: p_rec.start_date_active :=
310: ota_cha_shd.g_old_rec.start_date_active;
311: End If;
312: If (p_rec.end_date_active = hr_api.g_date) then

Line 312: If (p_rec.end_date_active = hr_api.g_date) then

308: If (p_rec.start_date_active = hr_api.g_date) then
309: p_rec.start_date_active :=
310: ota_cha_shd.g_old_rec.start_date_active;
311: End If;
312: If (p_rec.end_date_active = hr_api.g_date) then
313: p_rec.end_date_active :=
314: ota_cha_shd.g_old_rec.end_date_active;
315: End If;
316: If (p_rec.start_time_active = hr_api.g_varchar2) then

Line 316: If (p_rec.start_time_active = hr_api.g_varchar2) then

312: If (p_rec.end_date_active = hr_api.g_date) then
313: p_rec.end_date_active :=
314: ota_cha_shd.g_old_rec.end_date_active;
315: End If;
316: If (p_rec.start_time_active = hr_api.g_varchar2) then
317: p_rec.start_time_active :=
318: ota_cha_shd.g_old_rec.start_time_active;
319: End If;
320: If (p_rec.end_time_active = hr_api.g_varchar2) then

Line 320: If (p_rec.end_time_active = hr_api.g_varchar2) then

316: If (p_rec.start_time_active = hr_api.g_varchar2) then
317: p_rec.start_time_active :=
318: ota_cha_shd.g_old_rec.start_time_active;
319: End If;
320: If (p_rec.end_time_active = hr_api.g_varchar2) then
321: p_rec.end_time_active :=
322: ota_cha_shd.g_old_rec.end_time_active;
323: End If;
324: If (p_rec.timezone_code = hr_api.g_varchar2) then

Line 324: If (p_rec.timezone_code = hr_api.g_varchar2) then

320: If (p_rec.end_time_active = hr_api.g_varchar2) then
321: p_rec.end_time_active :=
322: ota_cha_shd.g_old_rec.end_time_active;
323: End If;
324: If (p_rec.timezone_code = hr_api.g_varchar2) then
325: p_rec.timezone_code :=
326: ota_cha_shd.g_old_rec.timezone_code;
327: End If;
328: --

Line 392: ,p_business_group_id in number default hr_api.g_number

388: Procedure upd
389: (p_effective_date in date
390: ,p_chat_id in number
391: ,p_object_version_number in out nocopy number
392: ,p_business_group_id in number default hr_api.g_number
393: ,p_public_flag in varchar2 default hr_api.g_varchar2
394: ,p_start_date_active in date default hr_api.g_date
395: ,p_end_date_active in date default hr_api.g_date
396: ,p_start_time_active in varchar2 default hr_api.g_varchar2

Line 393: ,p_public_flag in varchar2 default hr_api.g_varchar2

389: (p_effective_date in date
390: ,p_chat_id in number
391: ,p_object_version_number in out nocopy number
392: ,p_business_group_id in number default hr_api.g_number
393: ,p_public_flag in varchar2 default hr_api.g_varchar2
394: ,p_start_date_active in date default hr_api.g_date
395: ,p_end_date_active in date default hr_api.g_date
396: ,p_start_time_active in varchar2 default hr_api.g_varchar2
397: ,p_end_time_active in varchar2 default hr_api.g_varchar2

Line 394: ,p_start_date_active in date default hr_api.g_date

390: ,p_chat_id in number
391: ,p_object_version_number in out nocopy number
392: ,p_business_group_id in number default hr_api.g_number
393: ,p_public_flag in varchar2 default hr_api.g_varchar2
394: ,p_start_date_active in date default hr_api.g_date
395: ,p_end_date_active in date default hr_api.g_date
396: ,p_start_time_active in varchar2 default hr_api.g_varchar2
397: ,p_end_time_active in varchar2 default hr_api.g_varchar2
398: ,p_timezone_code in varchar2 default hr_api.g_varchar2

Line 395: ,p_end_date_active in date default hr_api.g_date

391: ,p_object_version_number in out nocopy number
392: ,p_business_group_id in number default hr_api.g_number
393: ,p_public_flag in varchar2 default hr_api.g_varchar2
394: ,p_start_date_active in date default hr_api.g_date
395: ,p_end_date_active in date default hr_api.g_date
396: ,p_start_time_active in varchar2 default hr_api.g_varchar2
397: ,p_end_time_active in varchar2 default hr_api.g_varchar2
398: ,p_timezone_code in varchar2 default hr_api.g_varchar2
399: ) is

Line 396: ,p_start_time_active in varchar2 default hr_api.g_varchar2

392: ,p_business_group_id in number default hr_api.g_number
393: ,p_public_flag in varchar2 default hr_api.g_varchar2
394: ,p_start_date_active in date default hr_api.g_date
395: ,p_end_date_active in date default hr_api.g_date
396: ,p_start_time_active in varchar2 default hr_api.g_varchar2
397: ,p_end_time_active in varchar2 default hr_api.g_varchar2
398: ,p_timezone_code in varchar2 default hr_api.g_varchar2
399: ) is
400: --

Line 397: ,p_end_time_active in varchar2 default hr_api.g_varchar2

393: ,p_public_flag in varchar2 default hr_api.g_varchar2
394: ,p_start_date_active in date default hr_api.g_date
395: ,p_end_date_active in date default hr_api.g_date
396: ,p_start_time_active in varchar2 default hr_api.g_varchar2
397: ,p_end_time_active in varchar2 default hr_api.g_varchar2
398: ,p_timezone_code in varchar2 default hr_api.g_varchar2
399: ) is
400: --
401: l_rec ota_cha_shd.g_rec_type;

Line 398: ,p_timezone_code in varchar2 default hr_api.g_varchar2

394: ,p_start_date_active in date default hr_api.g_date
395: ,p_end_date_active in date default hr_api.g_date
396: ,p_start_time_active in varchar2 default hr_api.g_varchar2
397: ,p_end_time_active in varchar2 default hr_api.g_varchar2
398: ,p_timezone_code in varchar2 default hr_api.g_varchar2
399: ) is
400: --
401: l_rec ota_cha_shd.g_rec_type;
402: l_proc varchar2(72) := g_package||'upd';