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_CTL_UPD dependencies on HR_API

Line 89: When hr_api.check_integrity_violated Then

85: --
86: hr_utility.set_location(' Leaving:'||l_proc, 10);
87: --
88: Exception
89: When hr_api.check_integrity_violated Then
90: -- A check constraint has been violated
91: --
92: ota_ctl_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 94: When hr_api.parent_integrity_violated Then

90: -- A check constraint has been violated
91: --
92: ota_ctl_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: --
97: ota_ctl_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.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: --
97: ota_ctl_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.unique_integrity_violated Then
100: -- Unique integrity has been violated
101: --
102: ota_ctl_shd.constraint_error

Line 99: When hr_api.unique_integrity_violated Then

95: -- Parent integrity has been violated
96: --
97: ota_ctl_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.unique_integrity_violated Then
100: -- Unique integrity has been violated
101: --
102: ota_ctl_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.unique_integrity_violated Then
100: -- Unique integrity has been violated
101: --
102: ota_ctl_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When Others Then
105: --
106: Raise;
107: End update_dml;

Line 242: when hr_api.cannot_find_prog_unit then

238: );
239: --
240: exception
241: --
242: when hr_api.cannot_find_prog_unit then
243: --
244: hr_api.cannot_find_prog_unit_error
245: (p_module_name => 'OTA_CERTIFICATIONS_TL'
246: ,p_hook_type => 'AU');

Line 244: hr_api.cannot_find_prog_unit_error

240: exception
241: --
242: when hr_api.cannot_find_prog_unit then
243: --
244: hr_api.cannot_find_prog_unit_error
245: (p_module_name => 'OTA_CERTIFICATIONS_TL'
246: ,p_hook_type => 'AU');
247: --
248: end;

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

303: -- p_rec plsql record structure
304: -- to see if a system default is being used. If a system default
305: -- is being used then we must set to the 'current' argument value.
306: --
307: If (p_rec.name = hr_api.g_varchar2) then
308: p_rec.name :=
309: ota_ctl_shd.g_old_rec.name;
310: End If;
311: If (p_rec.description = hr_api.g_varchar2) then

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

307: If (p_rec.name = hr_api.g_varchar2) then
308: p_rec.name :=
309: ota_ctl_shd.g_old_rec.name;
310: End If;
311: If (p_rec.description = hr_api.g_varchar2) then
312: p_rec.description :=
313: ota_ctl_shd.g_old_rec.description;
314: End If;
315: If (p_rec.objectives = hr_api.g_varchar2) then

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

311: If (p_rec.description = hr_api.g_varchar2) then
312: p_rec.description :=
313: ota_ctl_shd.g_old_rec.description;
314: End If;
315: If (p_rec.objectives = hr_api.g_varchar2) then
316: p_rec.objectives :=
317: ota_ctl_shd.g_old_rec.objectives;
318: End If;
319: If (p_rec.purpose = hr_api.g_varchar2) then

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

315: If (p_rec.objectives = hr_api.g_varchar2) then
316: p_rec.objectives :=
317: ota_ctl_shd.g_old_rec.objectives;
318: End If;
319: If (p_rec.purpose = hr_api.g_varchar2) then
320: p_rec.purpose :=
321: ota_ctl_shd.g_old_rec.purpose;
322: End If;
323: If (p_rec.keywords = hr_api.g_varchar2) then

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

319: If (p_rec.purpose = hr_api.g_varchar2) then
320: p_rec.purpose :=
321: ota_ctl_shd.g_old_rec.purpose;
322: End If;
323: If (p_rec.keywords = hr_api.g_varchar2) then
324: p_rec.keywords :=
325: ota_ctl_shd.g_old_rec.keywords;
326: End If;
327: If (p_rec.end_date_comments = hr_api.g_varchar2) then

Line 327: If (p_rec.end_date_comments = hr_api.g_varchar2) then

323: If (p_rec.keywords = hr_api.g_varchar2) then
324: p_rec.keywords :=
325: ota_ctl_shd.g_old_rec.keywords;
326: End If;
327: If (p_rec.end_date_comments = hr_api.g_varchar2) then
328: p_rec.end_date_comments :=
329: ota_ctl_shd.g_old_rec.end_date_comments;
330: End If;
331: If (p_rec.initial_period_comments = hr_api.g_varchar2) then

Line 331: If (p_rec.initial_period_comments = hr_api.g_varchar2) then

327: If (p_rec.end_date_comments = hr_api.g_varchar2) then
328: p_rec.end_date_comments :=
329: ota_ctl_shd.g_old_rec.end_date_comments;
330: End If;
331: If (p_rec.initial_period_comments = hr_api.g_varchar2) then
332: p_rec.initial_period_comments :=
333: ota_ctl_shd.g_old_rec.initial_period_comments;
334: End If;
335: If (p_rec.renewal_period_comments = hr_api.g_varchar2) then

Line 335: If (p_rec.renewal_period_comments = hr_api.g_varchar2) then

331: If (p_rec.initial_period_comments = hr_api.g_varchar2) then
332: p_rec.initial_period_comments :=
333: ota_ctl_shd.g_old_rec.initial_period_comments;
334: End If;
335: If (p_rec.renewal_period_comments = hr_api.g_varchar2) then
336: p_rec.renewal_period_comments :=
337: ota_ctl_shd.g_old_rec.renewal_period_comments;
338: End If;
339: If (p_rec.source_lang = hr_api.g_varchar2) then

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

335: If (p_rec.renewal_period_comments = hr_api.g_varchar2) then
336: p_rec.renewal_period_comments :=
337: ota_ctl_shd.g_old_rec.renewal_period_comments;
338: End If;
339: If (p_rec.source_lang = hr_api.g_varchar2) then
340: p_rec.source_lang :=
341: ota_ctl_shd.g_old_rec.source_lang;
342: End If;
343: --

Line 407: ,p_name in varchar2 default hr_api.g_varchar2

403: Procedure upd
404: (p_effective_date in date
405: ,p_certification_id in number
406: ,p_language in varchar2
407: ,p_name in varchar2 default hr_api.g_varchar2
408: ,p_source_lang in varchar2 default hr_api.g_varchar2
409: ,p_description in varchar2 default hr_api.g_varchar2
410: ,p_objectives in varchar2 default hr_api.g_varchar2
411: ,p_purpose in varchar2 default hr_api.g_varchar2

Line 408: ,p_source_lang in varchar2 default hr_api.g_varchar2

404: (p_effective_date in date
405: ,p_certification_id in number
406: ,p_language in varchar2
407: ,p_name in varchar2 default hr_api.g_varchar2
408: ,p_source_lang in varchar2 default hr_api.g_varchar2
409: ,p_description in varchar2 default hr_api.g_varchar2
410: ,p_objectives in varchar2 default hr_api.g_varchar2
411: ,p_purpose in varchar2 default hr_api.g_varchar2
412: ,p_keywords in varchar2 default hr_api.g_varchar2

Line 409: ,p_description in varchar2 default hr_api.g_varchar2

405: ,p_certification_id in number
406: ,p_language in varchar2
407: ,p_name in varchar2 default hr_api.g_varchar2
408: ,p_source_lang in varchar2 default hr_api.g_varchar2
409: ,p_description in varchar2 default hr_api.g_varchar2
410: ,p_objectives in varchar2 default hr_api.g_varchar2
411: ,p_purpose in varchar2 default hr_api.g_varchar2
412: ,p_keywords in varchar2 default hr_api.g_varchar2
413: ,p_end_date_comments in varchar2 default hr_api.g_varchar2

Line 410: ,p_objectives in varchar2 default hr_api.g_varchar2

406: ,p_language in varchar2
407: ,p_name in varchar2 default hr_api.g_varchar2
408: ,p_source_lang in varchar2 default hr_api.g_varchar2
409: ,p_description in varchar2 default hr_api.g_varchar2
410: ,p_objectives in varchar2 default hr_api.g_varchar2
411: ,p_purpose in varchar2 default hr_api.g_varchar2
412: ,p_keywords in varchar2 default hr_api.g_varchar2
413: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
414: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2

Line 411: ,p_purpose in varchar2 default hr_api.g_varchar2

407: ,p_name in varchar2 default hr_api.g_varchar2
408: ,p_source_lang in varchar2 default hr_api.g_varchar2
409: ,p_description in varchar2 default hr_api.g_varchar2
410: ,p_objectives in varchar2 default hr_api.g_varchar2
411: ,p_purpose in varchar2 default hr_api.g_varchar2
412: ,p_keywords in varchar2 default hr_api.g_varchar2
413: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
414: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
415: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2

Line 412: ,p_keywords in varchar2 default hr_api.g_varchar2

408: ,p_source_lang in varchar2 default hr_api.g_varchar2
409: ,p_description in varchar2 default hr_api.g_varchar2
410: ,p_objectives in varchar2 default hr_api.g_varchar2
411: ,p_purpose in varchar2 default hr_api.g_varchar2
412: ,p_keywords in varchar2 default hr_api.g_varchar2
413: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
414: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
415: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
416: ) is

Line 413: ,p_end_date_comments in varchar2 default hr_api.g_varchar2

409: ,p_description in varchar2 default hr_api.g_varchar2
410: ,p_objectives in varchar2 default hr_api.g_varchar2
411: ,p_purpose in varchar2 default hr_api.g_varchar2
412: ,p_keywords in varchar2 default hr_api.g_varchar2
413: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
414: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
415: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
416: ) is
417: --

Line 414: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2

410: ,p_objectives in varchar2 default hr_api.g_varchar2
411: ,p_purpose in varchar2 default hr_api.g_varchar2
412: ,p_keywords in varchar2 default hr_api.g_varchar2
413: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
414: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
415: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
416: ) is
417: --
418: l_rec ota_ctl_shd.g_rec_type;

Line 415: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2

411: ,p_purpose in varchar2 default hr_api.g_varchar2
412: ,p_keywords in varchar2 default hr_api.g_varchar2
413: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
414: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
415: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
416: ) is
417: --
418: l_rec ota_ctl_shd.g_rec_type;
419: l_proc varchar2(72) := g_package||'upd';

Line 462: ,p_name in varchar2 default hr_api.g_varchar2

458: Procedure upd_tl
459: (p_effective_date in date
460: ,p_language_code in varchar2
461: ,p_certification_id in number
462: ,p_name in varchar2 default hr_api.g_varchar2
463: ,p_description in varchar2 default hr_api.g_varchar2
464: ,p_objectives in varchar2 default hr_api.g_varchar2
465: ,p_purpose in varchar2 default hr_api.g_varchar2
466: ,p_keywords in varchar2 default hr_api.g_varchar2

Line 463: ,p_description in varchar2 default hr_api.g_varchar2

459: (p_effective_date in date
460: ,p_language_code in varchar2
461: ,p_certification_id in number
462: ,p_name in varchar2 default hr_api.g_varchar2
463: ,p_description in varchar2 default hr_api.g_varchar2
464: ,p_objectives in varchar2 default hr_api.g_varchar2
465: ,p_purpose in varchar2 default hr_api.g_varchar2
466: ,p_keywords in varchar2 default hr_api.g_varchar2
467: ,p_end_date_comments in varchar2 default hr_api.g_varchar2

Line 464: ,p_objectives in varchar2 default hr_api.g_varchar2

460: ,p_language_code in varchar2
461: ,p_certification_id in number
462: ,p_name in varchar2 default hr_api.g_varchar2
463: ,p_description in varchar2 default hr_api.g_varchar2
464: ,p_objectives in varchar2 default hr_api.g_varchar2
465: ,p_purpose in varchar2 default hr_api.g_varchar2
466: ,p_keywords in varchar2 default hr_api.g_varchar2
467: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
468: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2

Line 465: ,p_purpose in varchar2 default hr_api.g_varchar2

461: ,p_certification_id in number
462: ,p_name in varchar2 default hr_api.g_varchar2
463: ,p_description in varchar2 default hr_api.g_varchar2
464: ,p_objectives in varchar2 default hr_api.g_varchar2
465: ,p_purpose in varchar2 default hr_api.g_varchar2
466: ,p_keywords in varchar2 default hr_api.g_varchar2
467: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
468: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
469: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2

Line 466: ,p_keywords in varchar2 default hr_api.g_varchar2

462: ,p_name in varchar2 default hr_api.g_varchar2
463: ,p_description in varchar2 default hr_api.g_varchar2
464: ,p_objectives in varchar2 default hr_api.g_varchar2
465: ,p_purpose in varchar2 default hr_api.g_varchar2
466: ,p_keywords in varchar2 default hr_api.g_varchar2
467: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
468: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
469: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
470: ) is

Line 467: ,p_end_date_comments in varchar2 default hr_api.g_varchar2

463: ,p_description in varchar2 default hr_api.g_varchar2
464: ,p_objectives in varchar2 default hr_api.g_varchar2
465: ,p_purpose in varchar2 default hr_api.g_varchar2
466: ,p_keywords in varchar2 default hr_api.g_varchar2
467: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
468: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
469: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
470: ) is
471: --

Line 468: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2

464: ,p_objectives in varchar2 default hr_api.g_varchar2
465: ,p_purpose in varchar2 default hr_api.g_varchar2
466: ,p_keywords in varchar2 default hr_api.g_varchar2
467: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
468: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
469: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
470: ) is
471: --
472: -- Cursor to obtain the translation rows where the language or

Line 469: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2

465: ,p_purpose in varchar2 default hr_api.g_varchar2
466: ,p_keywords in varchar2 default hr_api.g_varchar2
467: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
468: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
469: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
470: ) is
471: --
472: -- Cursor to obtain the translation rows where the language or
473: -- source_lang match the specified language.