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_LPT_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: ota_lpt_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: ota_lpt_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: ota_lpt_shd.constraint_error

Line 91: When hr_api.parent_integrity_violated Then

87: -- A check constraint has been violated
88: --
89: ota_lpt_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: ota_lpt_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: ota_lpt_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: ota_lpt_shd.constraint_error

Line 96: When hr_api.unique_integrity_violated Then

92: -- Parent integrity has been violated
93: --
94: ota_lpt_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: ota_lpt_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: ota_lpt_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 227: when hr_api.cannot_find_prog_unit then

223: );
224: --
225: exception
226: --
227: when hr_api.cannot_find_prog_unit then
228: --
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'OTA_LEARNING_PATHS_TL'
231: ,p_hook_type => 'AU');

Line 229: hr_api.cannot_find_prog_unit_error

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

Line 292: If (p_rec.name = hr_api.g_varchar2) then

288: -- p_rec plsql record structure
289: -- to see if a system default is being used. If a system default
290: -- is being used then we must set to the 'current' argument value.
291: --
292: If (p_rec.name = hr_api.g_varchar2) then
293: p_rec.name :=
294: ota_lpt_shd.g_old_rec.name;
295: End If;
296: If (p_rec.description = hr_api.g_varchar2) then

Line 296: If (p_rec.description = hr_api.g_varchar2) then

292: If (p_rec.name = hr_api.g_varchar2) then
293: p_rec.name :=
294: ota_lpt_shd.g_old_rec.name;
295: End If;
296: If (p_rec.description = hr_api.g_varchar2) then
297: p_rec.description :=
298: ota_lpt_shd.g_old_rec.description;
299: End If;
300: If (p_rec.objectives = hr_api.g_varchar2) then

Line 300: If (p_rec.objectives = hr_api.g_varchar2) then

296: If (p_rec.description = hr_api.g_varchar2) then
297: p_rec.description :=
298: ota_lpt_shd.g_old_rec.description;
299: End If;
300: If (p_rec.objectives = hr_api.g_varchar2) then
301: p_rec.objectives :=
302: ota_lpt_shd.g_old_rec.objectives;
303: End If;
304: If (p_rec.purpose = hr_api.g_varchar2) then

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

300: If (p_rec.objectives = hr_api.g_varchar2) then
301: p_rec.objectives :=
302: ota_lpt_shd.g_old_rec.objectives;
303: End If;
304: If (p_rec.purpose = hr_api.g_varchar2) then
305: p_rec.purpose :=
306: ota_lpt_shd.g_old_rec.purpose;
307: End If;
308: If (p_rec.keywords = hr_api.g_varchar2) then

Line 308: If (p_rec.keywords = hr_api.g_varchar2) then

304: If (p_rec.purpose = hr_api.g_varchar2) then
305: p_rec.purpose :=
306: ota_lpt_shd.g_old_rec.purpose;
307: End If;
308: If (p_rec.keywords = hr_api.g_varchar2) then
309: p_rec.keywords :=
310: ota_lpt_shd.g_old_rec.keywords;
311: End If;
312: If (p_rec.source_lang = hr_api.g_varchar2) then

Line 312: If (p_rec.source_lang = hr_api.g_varchar2) then

308: If (p_rec.keywords = hr_api.g_varchar2) then
309: p_rec.keywords :=
310: ota_lpt_shd.g_old_rec.keywords;
311: End If;
312: If (p_rec.source_lang = hr_api.g_varchar2) then
313: p_rec.source_lang :=
314: ota_lpt_shd.g_old_rec.source_lang;
315: End If;
316: --

Line 380: ,p_name in varchar2 default hr_api.g_varchar2

376: Procedure upd
377: (p_effective_date in date
378: ,p_learning_path_id in number
379: ,p_language in varchar2
380: ,p_name in varchar2 default hr_api.g_varchar2
381: ,p_description in varchar2 default hr_api.g_varchar2
382: ,p_objectives in varchar2 default hr_api.g_varchar2
383: ,p_purpose in varchar2 default hr_api.g_varchar2
384: ,p_keywords in varchar2 default hr_api.g_varchar2

Line 381: ,p_description in varchar2 default hr_api.g_varchar2

377: (p_effective_date in date
378: ,p_learning_path_id in number
379: ,p_language in varchar2
380: ,p_name in varchar2 default hr_api.g_varchar2
381: ,p_description in varchar2 default hr_api.g_varchar2
382: ,p_objectives in varchar2 default hr_api.g_varchar2
383: ,p_purpose in varchar2 default hr_api.g_varchar2
384: ,p_keywords in varchar2 default hr_api.g_varchar2
385: ,p_source_lang in varchar2 default hr_api.g_varchar2

Line 382: ,p_objectives in varchar2 default hr_api.g_varchar2

378: ,p_learning_path_id in number
379: ,p_language in varchar2
380: ,p_name in varchar2 default hr_api.g_varchar2
381: ,p_description in varchar2 default hr_api.g_varchar2
382: ,p_objectives in varchar2 default hr_api.g_varchar2
383: ,p_purpose in varchar2 default hr_api.g_varchar2
384: ,p_keywords in varchar2 default hr_api.g_varchar2
385: ,p_source_lang in varchar2 default hr_api.g_varchar2
386: ) is

Line 383: ,p_purpose in varchar2 default hr_api.g_varchar2

379: ,p_language in varchar2
380: ,p_name in varchar2 default hr_api.g_varchar2
381: ,p_description in varchar2 default hr_api.g_varchar2
382: ,p_objectives in varchar2 default hr_api.g_varchar2
383: ,p_purpose in varchar2 default hr_api.g_varchar2
384: ,p_keywords in varchar2 default hr_api.g_varchar2
385: ,p_source_lang in varchar2 default hr_api.g_varchar2
386: ) is
387: --

Line 384: ,p_keywords in varchar2 default hr_api.g_varchar2

380: ,p_name in varchar2 default hr_api.g_varchar2
381: ,p_description in varchar2 default hr_api.g_varchar2
382: ,p_objectives in varchar2 default hr_api.g_varchar2
383: ,p_purpose in varchar2 default hr_api.g_varchar2
384: ,p_keywords in varchar2 default hr_api.g_varchar2
385: ,p_source_lang in varchar2 default hr_api.g_varchar2
386: ) is
387: --
388: l_rec ota_lpt_shd.g_rec_type;

Line 385: ,p_source_lang in varchar2 default hr_api.g_varchar2

381: ,p_description in varchar2 default hr_api.g_varchar2
382: ,p_objectives in varchar2 default hr_api.g_varchar2
383: ,p_purpose in varchar2 default hr_api.g_varchar2
384: ,p_keywords in varchar2 default hr_api.g_varchar2
385: ,p_source_lang in varchar2 default hr_api.g_varchar2
386: ) is
387: --
388: l_rec ota_lpt_shd.g_rec_type;
389: l_proc varchar2(72) := g_package||'upd';

Line 429: ,p_name in varchar2 default hr_api.g_varchar2

425: Procedure upd_tl
426: (p_effective_date in date
427: ,p_language_code in varchar2
428: ,p_learning_path_id in number
429: ,p_name in varchar2 default hr_api.g_varchar2
430: ,p_description in varchar2 default hr_api.g_varchar2
431: ,p_objectives in varchar2 default hr_api.g_varchar2
432: ,p_purpose in varchar2 default hr_api.g_varchar2
433: ,p_keywords in varchar2 default hr_api.g_varchar2

Line 430: ,p_description in varchar2 default hr_api.g_varchar2

426: (p_effective_date in date
427: ,p_language_code in varchar2
428: ,p_learning_path_id in number
429: ,p_name in varchar2 default hr_api.g_varchar2
430: ,p_description in varchar2 default hr_api.g_varchar2
431: ,p_objectives in varchar2 default hr_api.g_varchar2
432: ,p_purpose in varchar2 default hr_api.g_varchar2
433: ,p_keywords in varchar2 default hr_api.g_varchar2
434: ) is

Line 431: ,p_objectives in varchar2 default hr_api.g_varchar2

427: ,p_language_code in varchar2
428: ,p_learning_path_id in number
429: ,p_name in varchar2 default hr_api.g_varchar2
430: ,p_description in varchar2 default hr_api.g_varchar2
431: ,p_objectives in varchar2 default hr_api.g_varchar2
432: ,p_purpose in varchar2 default hr_api.g_varchar2
433: ,p_keywords in varchar2 default hr_api.g_varchar2
434: ) is
435: --

Line 432: ,p_purpose in varchar2 default hr_api.g_varchar2

428: ,p_learning_path_id in number
429: ,p_name in varchar2 default hr_api.g_varchar2
430: ,p_description in varchar2 default hr_api.g_varchar2
431: ,p_objectives in varchar2 default hr_api.g_varchar2
432: ,p_purpose in varchar2 default hr_api.g_varchar2
433: ,p_keywords in varchar2 default hr_api.g_varchar2
434: ) is
435: --
436: -- Cursor to obtain the translation rows where the language or

Line 433: ,p_keywords in varchar2 default hr_api.g_varchar2

429: ,p_name in varchar2 default hr_api.g_varchar2
430: ,p_description in varchar2 default hr_api.g_varchar2
431: ,p_objectives in varchar2 default hr_api.g_varchar2
432: ,p_purpose in varchar2 default hr_api.g_varchar2
433: ,p_keywords in varchar2 default hr_api.g_varchar2
434: ) is
435: --
436: -- Cursor to obtain the translation rows where the language or
437: -- source_lang match the specified language.