91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 10);
93: --
94: Exception
95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: --
98: irc_ipt_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: --
98: irc_ipt_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: --
103: irc_ipt_shd.constraint_error
96: -- A check constraint has been violated
97: --
98: irc_ipt_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: --
103: irc_ipt_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: --
103: irc_ipt_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: --
108: irc_ipt_shd.constraint_error
101: -- Parent integrity has been violated
102: --
103: irc_ipt_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: --
108: irc_ipt_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: --
108: irc_ipt_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: --
112: Raise;
113: End update_dml;
258: );
259: --
260: exception
261: --
262: when hr_api.cannot_find_prog_unit then
263: --
264: hr_api.cannot_find_prog_unit_error
265: (p_module_name => 'IRC_POSTING_CONTENTS_TL'
266: ,p_hook_type => 'AU');
260: exception
261: --
262: when hr_api.cannot_find_prog_unit then
263: --
264: hr_api.cannot_find_prog_unit_error
265: (p_module_name => 'IRC_POSTING_CONTENTS_TL'
266: ,p_hook_type => 'AU');
267: --
268: end;
323: -- p_rec plsql record structure
324: -- to see if a system default is being used. If a system default
325: -- is being used then we must set to the 'current' argument value.
326: --
327: If (p_rec.source_language = hr_api.g_varchar2) then
328: p_rec.source_language :=
329: irc_ipt_shd.g_old_rec.source_language;
330: End If;
331: If (p_rec.name = hr_api.g_varchar2) then
327: If (p_rec.source_language = hr_api.g_varchar2) then
328: p_rec.source_language :=
329: irc_ipt_shd.g_old_rec.source_language;
330: End If;
331: If (p_rec.name = hr_api.g_varchar2) then
332: p_rec.name :=
333: irc_ipt_shd.g_old_rec.name;
334: End If;
335: If (p_rec.org_name = hr_api.g_varchar2) then
331: If (p_rec.name = hr_api.g_varchar2) then
332: p_rec.name :=
333: irc_ipt_shd.g_old_rec.name;
334: End If;
335: If (p_rec.org_name = hr_api.g_varchar2) then
336: p_rec.org_name :=
337: irc_ipt_shd.g_old_rec.org_name;
338: End If;
339: If (p_rec.org_description = hr_api.g_varchar2) then
335: If (p_rec.org_name = hr_api.g_varchar2) then
336: p_rec.org_name :=
337: irc_ipt_shd.g_old_rec.org_name;
338: End If;
339: If (p_rec.org_description = hr_api.g_varchar2) then
340: p_rec.org_description :=
341: irc_ipt_shd.g_old_rec.org_description;
342: else
343: irc_ipt_shd.g_org_description_upd := true;
341: irc_ipt_shd.g_old_rec.org_description;
342: else
343: irc_ipt_shd.g_org_description_upd := true;
344: End If;
345: If (p_rec.job_title = hr_api.g_varchar2) then
346: p_rec.job_title :=
347: irc_ipt_shd.g_old_rec.job_title;
348: End If;
349: If (p_rec.brief_description = hr_api.g_varchar2) then
345: If (p_rec.job_title = hr_api.g_varchar2) then
346: p_rec.job_title :=
347: irc_ipt_shd.g_old_rec.job_title;
348: End If;
349: If (p_rec.brief_description = hr_api.g_varchar2) then
350: p_rec.brief_description :=
351: irc_ipt_shd.g_old_rec.brief_description;
352: else
353: irc_ipt_shd.g_brief_description_upd := true;
351: irc_ipt_shd.g_old_rec.brief_description;
352: else
353: irc_ipt_shd.g_brief_description_upd := true;
354: End If;
355: If (p_rec.detailed_description = hr_api.g_varchar2) then
356: p_rec.detailed_description :=
357: irc_ipt_shd.g_old_rec.detailed_description;
358: else
359: irc_ipt_shd.g_detailed_description_upd := true;
357: irc_ipt_shd.g_old_rec.detailed_description;
358: else
359: irc_ipt_shd.g_detailed_description_upd := true;
360: End If;
361: If (p_rec.job_requirements = hr_api.g_varchar2) then
362: p_rec.job_requirements :=
363: irc_ipt_shd.g_old_rec.job_requirements;
364: else
365: irc_ipt_shd.g_job_requirements_upd := true;
363: irc_ipt_shd.g_old_rec.job_requirements;
364: else
365: irc_ipt_shd.g_job_requirements_upd := true;
366: End If;
367: If (p_rec.additional_details = hr_api.g_varchar2) then
368: p_rec.additional_details :=
369: irc_ipt_shd.g_old_rec.additional_details;
370: else
371: irc_ipt_shd.g_additional_details_upd := true;
369: irc_ipt_shd.g_old_rec.additional_details;
370: else
371: irc_ipt_shd.g_additional_details_upd := true;
372: End If;
373: If (p_rec.how_to_apply = hr_api.g_varchar2) then
374: p_rec.how_to_apply :=
375: irc_ipt_shd.g_old_rec.how_to_apply;
376: else
377: irc_ipt_shd.g_how_to_apply_upd := true;
375: irc_ipt_shd.g_old_rec.how_to_apply;
376: else
377: irc_ipt_shd.g_how_to_apply_upd := true;
378: End If;
379: If (p_rec.benefit_info = hr_api.g_varchar2) then
380: p_rec.benefit_info :=
381: irc_ipt_shd.g_old_rec.benefit_info;
382: else
383: irc_ipt_shd.g_benefit_info_upd := true;
381: irc_ipt_shd.g_old_rec.benefit_info;
382: else
383: irc_ipt_shd.g_benefit_info_upd := true;
384: End If;
385: If (p_rec.image_url = hr_api.g_varchar2) then
386: p_rec.image_url :=
387: irc_ipt_shd.g_old_rec.image_url;
388: else
389: irc_ipt_shd.g_image_url_upd := true;
387: irc_ipt_shd.g_old_rec.image_url;
388: else
389: irc_ipt_shd.g_image_url_upd := true;
390: End If;
391: If (p_rec.image_url_alt = hr_api.g_varchar2) then
392: p_rec.image_url_alt :=
393: irc_ipt_shd.g_old_rec.image_url_alt;
394: else
395: irc_ipt_shd.g_image_url_alt_upd := true;
449: -- ----------------------------------------------------------------------------
450: Procedure upd
451: (p_posting_content_id in number
452: ,p_language in varchar2
453: ,p_source_language in varchar2 default hr_api.g_varchar2
454: ,p_name in varchar2 default hr_api.g_varchar2
455: ,p_org_name in varchar2 default hr_api.g_varchar2
456: ,p_org_description in varchar2 default hr_api.g_varchar2
457: ,p_job_title in varchar2 default hr_api.g_varchar2
450: Procedure upd
451: (p_posting_content_id in number
452: ,p_language in varchar2
453: ,p_source_language in varchar2 default hr_api.g_varchar2
454: ,p_name in varchar2 default hr_api.g_varchar2
455: ,p_org_name in varchar2 default hr_api.g_varchar2
456: ,p_org_description in varchar2 default hr_api.g_varchar2
457: ,p_job_title in varchar2 default hr_api.g_varchar2
458: ,p_brief_description in varchar2 default hr_api.g_varchar2
451: (p_posting_content_id in number
452: ,p_language in varchar2
453: ,p_source_language in varchar2 default hr_api.g_varchar2
454: ,p_name in varchar2 default hr_api.g_varchar2
455: ,p_org_name in varchar2 default hr_api.g_varchar2
456: ,p_org_description in varchar2 default hr_api.g_varchar2
457: ,p_job_title in varchar2 default hr_api.g_varchar2
458: ,p_brief_description in varchar2 default hr_api.g_varchar2
459: ,p_detailed_description in varchar2 default hr_api.g_varchar2
452: ,p_language in varchar2
453: ,p_source_language in varchar2 default hr_api.g_varchar2
454: ,p_name in varchar2 default hr_api.g_varchar2
455: ,p_org_name in varchar2 default hr_api.g_varchar2
456: ,p_org_description in varchar2 default hr_api.g_varchar2
457: ,p_job_title in varchar2 default hr_api.g_varchar2
458: ,p_brief_description in varchar2 default hr_api.g_varchar2
459: ,p_detailed_description in varchar2 default hr_api.g_varchar2
460: ,p_job_requirements in varchar2 default hr_api.g_varchar2
453: ,p_source_language in varchar2 default hr_api.g_varchar2
454: ,p_name in varchar2 default hr_api.g_varchar2
455: ,p_org_name in varchar2 default hr_api.g_varchar2
456: ,p_org_description in varchar2 default hr_api.g_varchar2
457: ,p_job_title in varchar2 default hr_api.g_varchar2
458: ,p_brief_description in varchar2 default hr_api.g_varchar2
459: ,p_detailed_description in varchar2 default hr_api.g_varchar2
460: ,p_job_requirements in varchar2 default hr_api.g_varchar2
461: ,p_additional_details in varchar2 default hr_api.g_varchar2
454: ,p_name in varchar2 default hr_api.g_varchar2
455: ,p_org_name in varchar2 default hr_api.g_varchar2
456: ,p_org_description in varchar2 default hr_api.g_varchar2
457: ,p_job_title in varchar2 default hr_api.g_varchar2
458: ,p_brief_description in varchar2 default hr_api.g_varchar2
459: ,p_detailed_description in varchar2 default hr_api.g_varchar2
460: ,p_job_requirements in varchar2 default hr_api.g_varchar2
461: ,p_additional_details in varchar2 default hr_api.g_varchar2
462: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
455: ,p_org_name in varchar2 default hr_api.g_varchar2
456: ,p_org_description in varchar2 default hr_api.g_varchar2
457: ,p_job_title in varchar2 default hr_api.g_varchar2
458: ,p_brief_description in varchar2 default hr_api.g_varchar2
459: ,p_detailed_description in varchar2 default hr_api.g_varchar2
460: ,p_job_requirements in varchar2 default hr_api.g_varchar2
461: ,p_additional_details in varchar2 default hr_api.g_varchar2
462: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
463: ,p_benefit_info in varchar2 default hr_api.g_varchar2
456: ,p_org_description in varchar2 default hr_api.g_varchar2
457: ,p_job_title in varchar2 default hr_api.g_varchar2
458: ,p_brief_description in varchar2 default hr_api.g_varchar2
459: ,p_detailed_description in varchar2 default hr_api.g_varchar2
460: ,p_job_requirements in varchar2 default hr_api.g_varchar2
461: ,p_additional_details in varchar2 default hr_api.g_varchar2
462: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
463: ,p_benefit_info in varchar2 default hr_api.g_varchar2
464: ,p_image_url in varchar2 default hr_api.g_varchar2
457: ,p_job_title in varchar2 default hr_api.g_varchar2
458: ,p_brief_description in varchar2 default hr_api.g_varchar2
459: ,p_detailed_description in varchar2 default hr_api.g_varchar2
460: ,p_job_requirements in varchar2 default hr_api.g_varchar2
461: ,p_additional_details in varchar2 default hr_api.g_varchar2
462: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
463: ,p_benefit_info in varchar2 default hr_api.g_varchar2
464: ,p_image_url in varchar2 default hr_api.g_varchar2
465: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
458: ,p_brief_description in varchar2 default hr_api.g_varchar2
459: ,p_detailed_description in varchar2 default hr_api.g_varchar2
460: ,p_job_requirements in varchar2 default hr_api.g_varchar2
461: ,p_additional_details in varchar2 default hr_api.g_varchar2
462: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
463: ,p_benefit_info in varchar2 default hr_api.g_varchar2
464: ,p_image_url in varchar2 default hr_api.g_varchar2
465: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
466: ) is
459: ,p_detailed_description in varchar2 default hr_api.g_varchar2
460: ,p_job_requirements in varchar2 default hr_api.g_varchar2
461: ,p_additional_details in varchar2 default hr_api.g_varchar2
462: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
463: ,p_benefit_info in varchar2 default hr_api.g_varchar2
464: ,p_image_url in varchar2 default hr_api.g_varchar2
465: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
466: ) is
467: --
460: ,p_job_requirements in varchar2 default hr_api.g_varchar2
461: ,p_additional_details in varchar2 default hr_api.g_varchar2
462: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
463: ,p_benefit_info in varchar2 default hr_api.g_varchar2
464: ,p_image_url in varchar2 default hr_api.g_varchar2
465: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
466: ) is
467: --
468: l_rec irc_ipt_shd.g_rec_type;
461: ,p_additional_details in varchar2 default hr_api.g_varchar2
462: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
463: ,p_benefit_info in varchar2 default hr_api.g_varchar2
464: ,p_image_url in varchar2 default hr_api.g_varchar2
465: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
466: ) is
467: --
468: l_rec irc_ipt_shd.g_rec_type;
469: l_proc varchar2(72) := g_package||'upd';
510: -- ----------------------------------------------------------------------------
511: Procedure upd_tl
512: (p_language_code in varchar2
513: ,p_posting_content_id in number
514: ,p_name in varchar2 default hr_api.g_varchar2
515: ,p_org_name in varchar2 default hr_api.g_varchar2
516: ,p_org_description in varchar2 default hr_api.g_varchar2
517: ,p_job_title in varchar2 default hr_api.g_varchar2
518: ,p_brief_description in varchar2 default hr_api.g_varchar2
511: Procedure upd_tl
512: (p_language_code in varchar2
513: ,p_posting_content_id in number
514: ,p_name in varchar2 default hr_api.g_varchar2
515: ,p_org_name in varchar2 default hr_api.g_varchar2
516: ,p_org_description in varchar2 default hr_api.g_varchar2
517: ,p_job_title in varchar2 default hr_api.g_varchar2
518: ,p_brief_description in varchar2 default hr_api.g_varchar2
519: ,p_detailed_description in varchar2 default hr_api.g_varchar2
512: (p_language_code in varchar2
513: ,p_posting_content_id in number
514: ,p_name in varchar2 default hr_api.g_varchar2
515: ,p_org_name in varchar2 default hr_api.g_varchar2
516: ,p_org_description in varchar2 default hr_api.g_varchar2
517: ,p_job_title in varchar2 default hr_api.g_varchar2
518: ,p_brief_description in varchar2 default hr_api.g_varchar2
519: ,p_detailed_description in varchar2 default hr_api.g_varchar2
520: ,p_job_requirements in varchar2 default hr_api.g_varchar2
513: ,p_posting_content_id in number
514: ,p_name in varchar2 default hr_api.g_varchar2
515: ,p_org_name in varchar2 default hr_api.g_varchar2
516: ,p_org_description in varchar2 default hr_api.g_varchar2
517: ,p_job_title in varchar2 default hr_api.g_varchar2
518: ,p_brief_description in varchar2 default hr_api.g_varchar2
519: ,p_detailed_description in varchar2 default hr_api.g_varchar2
520: ,p_job_requirements in varchar2 default hr_api.g_varchar2
521: ,p_additional_details in varchar2 default hr_api.g_varchar2
514: ,p_name in varchar2 default hr_api.g_varchar2
515: ,p_org_name in varchar2 default hr_api.g_varchar2
516: ,p_org_description in varchar2 default hr_api.g_varchar2
517: ,p_job_title in varchar2 default hr_api.g_varchar2
518: ,p_brief_description in varchar2 default hr_api.g_varchar2
519: ,p_detailed_description in varchar2 default hr_api.g_varchar2
520: ,p_job_requirements in varchar2 default hr_api.g_varchar2
521: ,p_additional_details in varchar2 default hr_api.g_varchar2
522: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
515: ,p_org_name in varchar2 default hr_api.g_varchar2
516: ,p_org_description in varchar2 default hr_api.g_varchar2
517: ,p_job_title in varchar2 default hr_api.g_varchar2
518: ,p_brief_description in varchar2 default hr_api.g_varchar2
519: ,p_detailed_description in varchar2 default hr_api.g_varchar2
520: ,p_job_requirements in varchar2 default hr_api.g_varchar2
521: ,p_additional_details in varchar2 default hr_api.g_varchar2
522: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
523: ,p_benefit_info in varchar2 default hr_api.g_varchar2
516: ,p_org_description in varchar2 default hr_api.g_varchar2
517: ,p_job_title in varchar2 default hr_api.g_varchar2
518: ,p_brief_description in varchar2 default hr_api.g_varchar2
519: ,p_detailed_description in varchar2 default hr_api.g_varchar2
520: ,p_job_requirements in varchar2 default hr_api.g_varchar2
521: ,p_additional_details in varchar2 default hr_api.g_varchar2
522: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
523: ,p_benefit_info in varchar2 default hr_api.g_varchar2
524: ,p_image_url in varchar2 default hr_api.g_varchar2
517: ,p_job_title in varchar2 default hr_api.g_varchar2
518: ,p_brief_description in varchar2 default hr_api.g_varchar2
519: ,p_detailed_description in varchar2 default hr_api.g_varchar2
520: ,p_job_requirements in varchar2 default hr_api.g_varchar2
521: ,p_additional_details in varchar2 default hr_api.g_varchar2
522: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
523: ,p_benefit_info in varchar2 default hr_api.g_varchar2
524: ,p_image_url in varchar2 default hr_api.g_varchar2
525: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
518: ,p_brief_description in varchar2 default hr_api.g_varchar2
519: ,p_detailed_description in varchar2 default hr_api.g_varchar2
520: ,p_job_requirements in varchar2 default hr_api.g_varchar2
521: ,p_additional_details in varchar2 default hr_api.g_varchar2
522: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
523: ,p_benefit_info in varchar2 default hr_api.g_varchar2
524: ,p_image_url in varchar2 default hr_api.g_varchar2
525: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
526: ) is
519: ,p_detailed_description in varchar2 default hr_api.g_varchar2
520: ,p_job_requirements in varchar2 default hr_api.g_varchar2
521: ,p_additional_details in varchar2 default hr_api.g_varchar2
522: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
523: ,p_benefit_info in varchar2 default hr_api.g_varchar2
524: ,p_image_url in varchar2 default hr_api.g_varchar2
525: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
526: ) is
527: --
520: ,p_job_requirements in varchar2 default hr_api.g_varchar2
521: ,p_additional_details in varchar2 default hr_api.g_varchar2
522: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
523: ,p_benefit_info in varchar2 default hr_api.g_varchar2
524: ,p_image_url in varchar2 default hr_api.g_varchar2
525: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
526: ) is
527: --
528: -- Cursor to obtain the translation rows where the language or
521: ,p_additional_details in varchar2 default hr_api.g_varchar2
522: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
523: ,p_benefit_info in varchar2 default hr_api.g_varchar2
524: ,p_image_url in varchar2 default hr_api.g_varchar2
525: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
526: ) is
527: --
528: -- Cursor to obtain the translation rows where the language or
529: -- source_lang match the specified language.