DBA Data[Home] [Help]

APPS.IRC_IPT_UPD dependencies on HR_API

Line 95: When hr_api.check_integrity_violated Then

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));

Line 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

Line 100: When hr_api.parent_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
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 105: When hr_api.unique_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
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 262: when hr_api.cannot_find_prog_unit then

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

Line 264: hr_api.cannot_find_prog_unit_error

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;

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

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

Line 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

Line 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

Line 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;

Line 345: If (p_rec.job_title = hr_api.g_varchar2) then

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

Line 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;

Line 355: If (p_rec.detailed_description = hr_api.g_varchar2) then

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;

Line 361: If (p_rec.job_requirements = hr_api.g_varchar2) then

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;

Line 367: If (p_rec.additional_details = hr_api.g_varchar2) then

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;

Line 373: If (p_rec.how_to_apply = hr_api.g_varchar2) then

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;

Line 379: If (p_rec.benefit_info = hr_api.g_varchar2) then

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;

Line 385: If (p_rec.image_url = hr_api.g_varchar2) then

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;

Line 391: If (p_rec.image_url_alt = hr_api.g_varchar2) then

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;

Line 453: ,p_source_language in varchar2 default hr_api.g_varchar2

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

Line 454: ,p_name 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

Line 455: ,p_org_name 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

Line 456: ,p_org_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

Line 457: ,p_job_title 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

Line 458: ,p_brief_description 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

Line 459: ,p_detailed_description 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

Line 460: ,p_job_requirements 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

Line 461: ,p_additional_details 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

Line 462: ,p_how_to_apply 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

Line 463: ,p_benefit_info 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
467: --

Line 464: ,p_image_url 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: --
468: l_rec irc_ipt_shd.g_rec_type;

Line 465: ,p_image_url_alt 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;
469: l_proc varchar2(72) := g_package||'upd';

Line 514: ,p_name in varchar2 default hr_api.g_varchar2

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

Line 515: ,p_org_name 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

Line 516: ,p_org_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

Line 517: ,p_job_title 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

Line 518: ,p_brief_description 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

Line 519: ,p_detailed_description 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

Line 520: ,p_job_requirements 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

Line 521: ,p_additional_details 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

Line 522: ,p_how_to_apply 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

Line 523: ,p_benefit_info 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
527: --

Line 524: ,p_image_url 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: --
528: -- Cursor to obtain the translation rows where the language or

Line 525: ,p_image_url_alt 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
529: -- source_lang match the specified language.