51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy irc_ipt_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
83: ,image_url_alt = empty_clob()
84: where posting_content_id = p_rec.posting_content_id
85: and language = p_rec.language;
86:
87: irc_ipt_shd.clob_dml(p_rec => p_rec
88: ,p_api_updating => true);
89: --
90: --
91: --
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));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: --
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));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: --
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));
110: When Others Then
111: --
112: Raise;
144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure pre_update
148: (p_rec in irc_ipt_shd.g_rec_type
149: ) is
150: --
151: l_proc varchar2(72) := g_package||'pre_update';
152: --
188: --
189: -- {End Of Comments}
190: -- ----------------------------------------------------------------------------
191: Procedure post_update
192: (p_rec in irc_ipt_shd.g_rec_type
193: ) is
194: --
195: l_proc varchar2(72) := g_package||'post_update';
196: --
229: => p_rec.image_url
230: ,p_image_url_alt
231: => p_rec.image_url_alt
232: ,p_source_language_o
233: => irc_ipt_shd.g_old_rec.source_language
234: ,p_name_o
235: => irc_ipt_shd.g_old_rec.name
236: ,p_org_name_o
237: => irc_ipt_shd.g_old_rec.org_name
231: => p_rec.image_url_alt
232: ,p_source_language_o
233: => irc_ipt_shd.g_old_rec.source_language
234: ,p_name_o
235: => irc_ipt_shd.g_old_rec.name
236: ,p_org_name_o
237: => irc_ipt_shd.g_old_rec.org_name
238: ,p_org_description_o
239: => irc_ipt_shd.g_old_rec.org_description
233: => irc_ipt_shd.g_old_rec.source_language
234: ,p_name_o
235: => irc_ipt_shd.g_old_rec.name
236: ,p_org_name_o
237: => irc_ipt_shd.g_old_rec.org_name
238: ,p_org_description_o
239: => irc_ipt_shd.g_old_rec.org_description
240: ,p_job_title_o
241: => irc_ipt_shd.g_old_rec.job_title
235: => irc_ipt_shd.g_old_rec.name
236: ,p_org_name_o
237: => irc_ipt_shd.g_old_rec.org_name
238: ,p_org_description_o
239: => irc_ipt_shd.g_old_rec.org_description
240: ,p_job_title_o
241: => irc_ipt_shd.g_old_rec.job_title
242: ,p_brief_description_o
243: => irc_ipt_shd.g_old_rec.brief_description
237: => irc_ipt_shd.g_old_rec.org_name
238: ,p_org_description_o
239: => irc_ipt_shd.g_old_rec.org_description
240: ,p_job_title_o
241: => irc_ipt_shd.g_old_rec.job_title
242: ,p_brief_description_o
243: => irc_ipt_shd.g_old_rec.brief_description
244: ,p_detailed_description_o
245: => irc_ipt_shd.g_old_rec.detailed_description
239: => irc_ipt_shd.g_old_rec.org_description
240: ,p_job_title_o
241: => irc_ipt_shd.g_old_rec.job_title
242: ,p_brief_description_o
243: => irc_ipt_shd.g_old_rec.brief_description
244: ,p_detailed_description_o
245: => irc_ipt_shd.g_old_rec.detailed_description
246: ,p_job_requirements_o
247: => irc_ipt_shd.g_old_rec.job_requirements
241: => irc_ipt_shd.g_old_rec.job_title
242: ,p_brief_description_o
243: => irc_ipt_shd.g_old_rec.brief_description
244: ,p_detailed_description_o
245: => irc_ipt_shd.g_old_rec.detailed_description
246: ,p_job_requirements_o
247: => irc_ipt_shd.g_old_rec.job_requirements
248: ,p_additional_details_o
249: => irc_ipt_shd.g_old_rec.additional_details
243: => irc_ipt_shd.g_old_rec.brief_description
244: ,p_detailed_description_o
245: => irc_ipt_shd.g_old_rec.detailed_description
246: ,p_job_requirements_o
247: => irc_ipt_shd.g_old_rec.job_requirements
248: ,p_additional_details_o
249: => irc_ipt_shd.g_old_rec.additional_details
250: ,p_how_to_apply_o
251: => irc_ipt_shd.g_old_rec.how_to_apply
245: => irc_ipt_shd.g_old_rec.detailed_description
246: ,p_job_requirements_o
247: => irc_ipt_shd.g_old_rec.job_requirements
248: ,p_additional_details_o
249: => irc_ipt_shd.g_old_rec.additional_details
250: ,p_how_to_apply_o
251: => irc_ipt_shd.g_old_rec.how_to_apply
252: ,p_benefit_info_o
253: => irc_ipt_shd.g_old_rec.benefit_info
247: => irc_ipt_shd.g_old_rec.job_requirements
248: ,p_additional_details_o
249: => irc_ipt_shd.g_old_rec.additional_details
250: ,p_how_to_apply_o
251: => irc_ipt_shd.g_old_rec.how_to_apply
252: ,p_benefit_info_o
253: => irc_ipt_shd.g_old_rec.benefit_info
254: ,p_image_url_o
255: => irc_ipt_shd.g_old_rec.image_url
249: => irc_ipt_shd.g_old_rec.additional_details
250: ,p_how_to_apply_o
251: => irc_ipt_shd.g_old_rec.how_to_apply
252: ,p_benefit_info_o
253: => irc_ipt_shd.g_old_rec.benefit_info
254: ,p_image_url_o
255: => irc_ipt_shd.g_old_rec.image_url
256: ,p_image_url_alt_o
257: => irc_ipt_shd.g_old_rec.image_url_alt
251: => irc_ipt_shd.g_old_rec.how_to_apply
252: ,p_benefit_info_o
253: => irc_ipt_shd.g_old_rec.benefit_info
254: ,p_image_url_o
255: => irc_ipt_shd.g_old_rec.image_url
256: ,p_image_url_alt_o
257: => irc_ipt_shd.g_old_rec.image_url_alt
258: );
259: --
253: => irc_ipt_shd.g_old_rec.benefit_info
254: ,p_image_url_o
255: => irc_ipt_shd.g_old_rec.image_url
256: ,p_image_url_alt_o
257: => irc_ipt_shd.g_old_rec.image_url_alt
258: );
259: --
260: exception
261: --
313: --
314: -- {End Of Comments}
315: -- ----------------------------------------------------------------------------
316: Procedure convert_defs
317: (p_rec in out nocopy irc_ipt_shd.g_rec_type
318: ) is
319: --
320: Begin
321: --
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
332: p_rec.name :=
333: irc_ipt_shd.g_old_rec.name;
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
336: p_rec.org_name :=
337: irc_ipt_shd.g_old_rec.org_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
340: p_rec.org_description :=
341: irc_ipt_shd.g_old_rec.org_description;
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;
344: End If;
345: If (p_rec.job_title = hr_api.g_varchar2) then
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;
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;
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
350: p_rec.brief_description :=
351: irc_ipt_shd.g_old_rec.brief_description;
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;
354: End If;
355: If (p_rec.detailed_description = hr_api.g_varchar2) then
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;
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;
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;
360: End If;
361: If (p_rec.job_requirements = hr_api.g_varchar2) then
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;
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;
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;
366: End If;
367: If (p_rec.additional_details = hr_api.g_varchar2) then
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;
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;
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;
372: End If;
373: If (p_rec.how_to_apply = hr_api.g_varchar2) then
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;
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;
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;
378: End If;
379: If (p_rec.benefit_info = hr_api.g_varchar2) then
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;
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;
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;
384: End If;
385: If (p_rec.image_url = hr_api.g_varchar2) then
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;
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;
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;
390: End If;
391: If (p_rec.image_url_alt = hr_api.g_varchar2) then
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;
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;
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;
396: End If;
397: --
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;
396: End If;
397: --
398: End convert_defs;
399: --
400: -- ----------------------------------------------------------------------------
401: -- |---------------------------------< upd >----------------------------------|
402: -- ----------------------------------------------------------------------------
403: Procedure upd
404: (p_rec in out nocopy irc_ipt_shd.g_rec_type
405: ) is
406: --
407: l_proc varchar2(72) := g_package||'upd';
408: --
410: hr_utility.set_location('Entering:'||l_proc, 5);
411: --
412: -- We must lock the row which we need to update.
413: --
414: irc_ipt_shd.lck
415: (p_rec.posting_content_id
416: ,p_rec.language
417: );
418: --
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';
470: --
471: Begin
472: hr_utility.set_location('Entering:'||l_proc, 5);
474: -- Call conversion function to turn arguments into the
475: -- l_rec structure.
476: --
477: l_rec :=
478: irc_ipt_shd.convert_args
479: (p_posting_content_id
480: ,p_language
481: ,p_source_language
482: ,p_name