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_FTS_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: --
90: ota_fts_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 92: When hr_api.parent_integrity_violated Then

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

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

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

Line 97: When hr_api.unique_integrity_violated Then

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

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

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

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 => 'OTA_FORUM_THREADS'
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 => 'OTA_FORUM_THREADS'
234: ,p_hook_type => 'AU');
235: --
236: end;

Line 295: If (p_rec.forum_id = hr_api.g_number) then

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

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

295: If (p_rec.forum_id = hr_api.g_number) then
296: p_rec.forum_id :=
297: ota_fts_shd.g_old_rec.forum_id;
298: End If;
299: If (p_rec.business_group_id = hr_api.g_number) then
300: p_rec.business_group_id :=
301: ota_fts_shd.g_old_rec.business_group_id;
302: End If;
303: If (p_rec.subject = hr_api.g_varchar2) then

Line 303: If (p_rec.subject = hr_api.g_varchar2) then

299: If (p_rec.business_group_id = hr_api.g_number) then
300: p_rec.business_group_id :=
301: ota_fts_shd.g_old_rec.business_group_id;
302: End If;
303: If (p_rec.subject = hr_api.g_varchar2) then
304: p_rec.subject :=
305: ota_fts_shd.g_old_rec.subject;
306: End If;
307: If (p_rec.last_post_date = hr_api.g_date) then

Line 307: If (p_rec.last_post_date = hr_api.g_date) then

303: If (p_rec.subject = hr_api.g_varchar2) then
304: p_rec.subject :=
305: ota_fts_shd.g_old_rec.subject;
306: End If;
307: If (p_rec.last_post_date = hr_api.g_date) then
308: p_rec.last_post_date :=
309: ota_fts_shd.g_old_rec.last_post_date;
310: End If;
311: If (p_rec.reply_count = hr_api.g_number) then

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

307: If (p_rec.last_post_date = hr_api.g_date) then
308: p_rec.last_post_date :=
309: ota_fts_shd.g_old_rec.last_post_date;
310: End If;
311: If (p_rec.reply_count = hr_api.g_number) then
312: p_rec.reply_count :=
313: ota_fts_shd.g_old_rec.reply_count;
314: End If;
315: If (p_rec.private_thread_flag = hr_api.g_varchar2) then

Line 315: If (p_rec.private_thread_flag = hr_api.g_varchar2) then

311: If (p_rec.reply_count = hr_api.g_number) then
312: p_rec.reply_count :=
313: ota_fts_shd.g_old_rec.reply_count;
314: End If;
315: If (p_rec.private_thread_flag = hr_api.g_varchar2) then
316: p_rec.private_thread_flag :=
317: ota_fts_shd.g_old_rec.private_thread_flag;
318: End If;
319: --

Line 383: ,p_forum_id in number default hr_api.g_number

379: Procedure upd
380: (p_effective_date in date
381: ,p_forum_thread_id in number
382: ,p_object_version_number in out nocopy number
383: ,p_forum_id in number default hr_api.g_number
384: ,p_business_group_id in number default hr_api.g_number
385: ,p_subject in varchar2 default hr_api.g_varchar2
386: ,p_private_thread_flag in varchar2 default hr_api.g_varchar2
387: ,p_last_post_date in date default hr_api.g_date

Line 384: ,p_business_group_id in number default hr_api.g_number

380: (p_effective_date in date
381: ,p_forum_thread_id in number
382: ,p_object_version_number in out nocopy number
383: ,p_forum_id in number default hr_api.g_number
384: ,p_business_group_id in number default hr_api.g_number
385: ,p_subject in varchar2 default hr_api.g_varchar2
386: ,p_private_thread_flag in varchar2 default hr_api.g_varchar2
387: ,p_last_post_date in date default hr_api.g_date
388: ,p_reply_count in number default hr_api.g_number

Line 385: ,p_subject in varchar2 default hr_api.g_varchar2

381: ,p_forum_thread_id in number
382: ,p_object_version_number in out nocopy number
383: ,p_forum_id in number default hr_api.g_number
384: ,p_business_group_id in number default hr_api.g_number
385: ,p_subject in varchar2 default hr_api.g_varchar2
386: ,p_private_thread_flag in varchar2 default hr_api.g_varchar2
387: ,p_last_post_date in date default hr_api.g_date
388: ,p_reply_count in number default hr_api.g_number
389: ) is

Line 386: ,p_private_thread_flag in varchar2 default hr_api.g_varchar2

382: ,p_object_version_number in out nocopy number
383: ,p_forum_id in number default hr_api.g_number
384: ,p_business_group_id in number default hr_api.g_number
385: ,p_subject in varchar2 default hr_api.g_varchar2
386: ,p_private_thread_flag in varchar2 default hr_api.g_varchar2
387: ,p_last_post_date in date default hr_api.g_date
388: ,p_reply_count in number default hr_api.g_number
389: ) is
390: --

Line 387: ,p_last_post_date in date default hr_api.g_date

383: ,p_forum_id in number default hr_api.g_number
384: ,p_business_group_id in number default hr_api.g_number
385: ,p_subject in varchar2 default hr_api.g_varchar2
386: ,p_private_thread_flag in varchar2 default hr_api.g_varchar2
387: ,p_last_post_date in date default hr_api.g_date
388: ,p_reply_count in number default hr_api.g_number
389: ) is
390: --
391: l_rec ota_fts_shd.g_rec_type;

Line 388: ,p_reply_count in number default hr_api.g_number

384: ,p_business_group_id in number default hr_api.g_number
385: ,p_subject in varchar2 default hr_api.g_varchar2
386: ,p_private_thread_flag in varchar2 default hr_api.g_varchar2
387: ,p_last_post_date in date default hr_api.g_date
388: ,p_reply_count in number default hr_api.g_number
389: ) is
390: --
391: l_rec ota_fts_shd.g_rec_type;
392: l_proc varchar2(72) := g_package||'upd';