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));
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
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));
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
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));
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;
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');
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;
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
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
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
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
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
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
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
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
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: --
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
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
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
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
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
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
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: --
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;
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';
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
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
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
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
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
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: --
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
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.