DBA Data[Home] [Help]

APPS.IRC_IPT_UPD dependencies on HR_API

Line 144: When hr_api.check_integrity_violated Then

140: --
141: hr_utility.set_location(' Leaving:'||l_proc, 10);
142: --
143: Exception
144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: --
147: irc_ipt_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: --
147: irc_ipt_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.parent_integrity_violated Then
150: -- Parent integrity has been violated
151: --
152: irc_ipt_shd.constraint_error

Line 149: When hr_api.parent_integrity_violated Then

145: -- A check constraint has been violated
146: --
147: irc_ipt_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.parent_integrity_violated Then
150: -- Parent integrity has been violated
151: --
152: irc_ipt_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

149: When hr_api.parent_integrity_violated Then
150: -- Parent integrity has been violated
151: --
152: irc_ipt_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
156: --
157: irc_ipt_shd.constraint_error

Line 154: When hr_api.unique_integrity_violated Then

150: -- Parent integrity has been violated
151: --
152: irc_ipt_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
156: --
157: irc_ipt_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
156: --
157: irc_ipt_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When Others Then
160: --
161: Raise;
162: End update_dml;

Line 311: when hr_api.cannot_find_prog_unit then

307: );
308: --
309: exception
310: --
311: when hr_api.cannot_find_prog_unit then
312: --
313: hr_api.cannot_find_prog_unit_error
314: (p_module_name => 'IRC_POSTING_CONTENTS_TL'
315: ,p_hook_type => 'AU');

Line 313: hr_api.cannot_find_prog_unit_error

309: exception
310: --
311: when hr_api.cannot_find_prog_unit then
312: --
313: hr_api.cannot_find_prog_unit_error
314: (p_module_name => 'IRC_POSTING_CONTENTS_TL'
315: ,p_hook_type => 'AU');
316: --
317: end;

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

372: -- p_rec plsql record structure
373: -- to see if a system default is being used. If a system default
374: -- is being used then we must set to the 'current' argument value.
375: --
376: If (p_rec.source_language = hr_api.g_varchar2) then
377: p_rec.source_language :=
378: irc_ipt_shd.g_old_rec.source_language;
379: End If;
380: If (p_rec.name = hr_api.g_varchar2) then

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

376: If (p_rec.source_language = hr_api.g_varchar2) then
377: p_rec.source_language :=
378: irc_ipt_shd.g_old_rec.source_language;
379: End If;
380: If (p_rec.name = hr_api.g_varchar2) then
381: p_rec.name :=
382: irc_ipt_shd.g_old_rec.name;
383: End If;
384: If (p_rec.org_name = hr_api.g_varchar2) then

Line 384: If (p_rec.org_name = hr_api.g_varchar2) then

380: If (p_rec.name = hr_api.g_varchar2) then
381: p_rec.name :=
382: irc_ipt_shd.g_old_rec.name;
383: End If;
384: If (p_rec.org_name = hr_api.g_varchar2) then
385: p_rec.org_name :=
386: irc_ipt_shd.g_old_rec.org_name;
387: End If;
388: If (p_rec.org_description = hr_api.g_varchar2) then

Line 388: If (p_rec.org_description = hr_api.g_varchar2) then

384: If (p_rec.org_name = hr_api.g_varchar2) then
385: p_rec.org_name :=
386: irc_ipt_shd.g_old_rec.org_name;
387: End If;
388: If (p_rec.org_description = hr_api.g_varchar2) then
389: p_rec.org_description :=
390: irc_ipt_shd.g_old_rec.org_description;
391: else
392: irc_ipt_shd.g_org_description_upd := true;

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

390: irc_ipt_shd.g_old_rec.org_description;
391: else
392: irc_ipt_shd.g_org_description_upd := true;
393: End If;
394: If (p_rec.job_title = hr_api.g_varchar2) then
395: p_rec.job_title :=
396: irc_ipt_shd.g_old_rec.job_title;
397: End If;
398: If (p_rec.brief_description = hr_api.g_varchar2) then

Line 398: If (p_rec.brief_description = hr_api.g_varchar2) then

394: If (p_rec.job_title = hr_api.g_varchar2) then
395: p_rec.job_title :=
396: irc_ipt_shd.g_old_rec.job_title;
397: End If;
398: If (p_rec.brief_description = hr_api.g_varchar2) then
399: p_rec.brief_description :=
400: irc_ipt_shd.g_old_rec.brief_description;
401: else
402: irc_ipt_shd.g_brief_description_upd := true;

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

400: irc_ipt_shd.g_old_rec.brief_description;
401: else
402: irc_ipt_shd.g_brief_description_upd := true;
403: End If;
404: If (p_rec.detailed_description = hr_api.g_varchar2) then
405: p_rec.detailed_description :=
406: irc_ipt_shd.g_old_rec.detailed_description;
407: else
408: irc_ipt_shd.g_detailed_description_upd := true;

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

406: irc_ipt_shd.g_old_rec.detailed_description;
407: else
408: irc_ipt_shd.g_detailed_description_upd := true;
409: End If;
410: If (p_rec.job_requirements = hr_api.g_varchar2) then
411: p_rec.job_requirements :=
412: irc_ipt_shd.g_old_rec.job_requirements;
413: else
414: irc_ipt_shd.g_job_requirements_upd := true;

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

412: irc_ipt_shd.g_old_rec.job_requirements;
413: else
414: irc_ipt_shd.g_job_requirements_upd := true;
415: End If;
416: If (p_rec.additional_details = hr_api.g_varchar2) then
417: p_rec.additional_details :=
418: irc_ipt_shd.g_old_rec.additional_details;
419: else
420: irc_ipt_shd.g_additional_details_upd := true;

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

418: irc_ipt_shd.g_old_rec.additional_details;
419: else
420: irc_ipt_shd.g_additional_details_upd := true;
421: End If;
422: If (p_rec.how_to_apply = hr_api.g_varchar2) then
423: p_rec.how_to_apply :=
424: irc_ipt_shd.g_old_rec.how_to_apply;
425: else
426: irc_ipt_shd.g_how_to_apply_upd := true;

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

424: irc_ipt_shd.g_old_rec.how_to_apply;
425: else
426: irc_ipt_shd.g_how_to_apply_upd := true;
427: End If;
428: If (p_rec.benefit_info = hr_api.g_varchar2) then
429: p_rec.benefit_info :=
430: irc_ipt_shd.g_old_rec.benefit_info;
431: else
432: irc_ipt_shd.g_benefit_info_upd := true;

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

430: irc_ipt_shd.g_old_rec.benefit_info;
431: else
432: irc_ipt_shd.g_benefit_info_upd := true;
433: End If;
434: If (p_rec.image_url = hr_api.g_varchar2) then
435: p_rec.image_url :=
436: irc_ipt_shd.g_old_rec.image_url;
437: else
438: irc_ipt_shd.g_image_url_upd := true;

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

436: irc_ipt_shd.g_old_rec.image_url;
437: else
438: irc_ipt_shd.g_image_url_upd := true;
439: End If;
440: If (p_rec.image_url_alt = hr_api.g_varchar2) then
441: p_rec.image_url_alt :=
442: irc_ipt_shd.g_old_rec.image_url_alt;
443: else
444: irc_ipt_shd.g_image_url_alt_upd := true;

Line 502: ,p_source_language in varchar2 default hr_api.g_varchar2

498: -- ----------------------------------------------------------------------------
499: Procedure upd
500: (p_posting_content_id in number
501: ,p_language in varchar2
502: ,p_source_language in varchar2 default hr_api.g_varchar2
503: ,p_name in varchar2 default hr_api.g_varchar2
504: ,p_org_name in varchar2 default hr_api.g_varchar2
505: ,p_org_description in varchar2 default hr_api.g_varchar2
506: ,p_job_title in varchar2 default hr_api.g_varchar2

Line 503: ,p_name in varchar2 default hr_api.g_varchar2

499: Procedure upd
500: (p_posting_content_id in number
501: ,p_language in varchar2
502: ,p_source_language in varchar2 default hr_api.g_varchar2
503: ,p_name in varchar2 default hr_api.g_varchar2
504: ,p_org_name in varchar2 default hr_api.g_varchar2
505: ,p_org_description in varchar2 default hr_api.g_varchar2
506: ,p_job_title in varchar2 default hr_api.g_varchar2
507: ,p_brief_description in varchar2 default hr_api.g_varchar2

Line 504: ,p_org_name in varchar2 default hr_api.g_varchar2

500: (p_posting_content_id in number
501: ,p_language in varchar2
502: ,p_source_language in varchar2 default hr_api.g_varchar2
503: ,p_name in varchar2 default hr_api.g_varchar2
504: ,p_org_name in varchar2 default hr_api.g_varchar2
505: ,p_org_description in varchar2 default hr_api.g_varchar2
506: ,p_job_title in varchar2 default hr_api.g_varchar2
507: ,p_brief_description in varchar2 default hr_api.g_varchar2
508: ,p_detailed_description in varchar2 default hr_api.g_varchar2

Line 505: ,p_org_description in varchar2 default hr_api.g_varchar2

501: ,p_language in varchar2
502: ,p_source_language in varchar2 default hr_api.g_varchar2
503: ,p_name in varchar2 default hr_api.g_varchar2
504: ,p_org_name in varchar2 default hr_api.g_varchar2
505: ,p_org_description in varchar2 default hr_api.g_varchar2
506: ,p_job_title in varchar2 default hr_api.g_varchar2
507: ,p_brief_description in varchar2 default hr_api.g_varchar2
508: ,p_detailed_description in varchar2 default hr_api.g_varchar2
509: ,p_job_requirements in varchar2 default hr_api.g_varchar2

Line 506: ,p_job_title in varchar2 default hr_api.g_varchar2

502: ,p_source_language in varchar2 default hr_api.g_varchar2
503: ,p_name in varchar2 default hr_api.g_varchar2
504: ,p_org_name in varchar2 default hr_api.g_varchar2
505: ,p_org_description in varchar2 default hr_api.g_varchar2
506: ,p_job_title in varchar2 default hr_api.g_varchar2
507: ,p_brief_description in varchar2 default hr_api.g_varchar2
508: ,p_detailed_description in varchar2 default hr_api.g_varchar2
509: ,p_job_requirements in varchar2 default hr_api.g_varchar2
510: ,p_additional_details in varchar2 default hr_api.g_varchar2

Line 507: ,p_brief_description in varchar2 default hr_api.g_varchar2

503: ,p_name in varchar2 default hr_api.g_varchar2
504: ,p_org_name in varchar2 default hr_api.g_varchar2
505: ,p_org_description in varchar2 default hr_api.g_varchar2
506: ,p_job_title in varchar2 default hr_api.g_varchar2
507: ,p_brief_description in varchar2 default hr_api.g_varchar2
508: ,p_detailed_description in varchar2 default hr_api.g_varchar2
509: ,p_job_requirements in varchar2 default hr_api.g_varchar2
510: ,p_additional_details in varchar2 default hr_api.g_varchar2
511: ,p_how_to_apply in varchar2 default hr_api.g_varchar2

Line 508: ,p_detailed_description in varchar2 default hr_api.g_varchar2

504: ,p_org_name in varchar2 default hr_api.g_varchar2
505: ,p_org_description in varchar2 default hr_api.g_varchar2
506: ,p_job_title in varchar2 default hr_api.g_varchar2
507: ,p_brief_description in varchar2 default hr_api.g_varchar2
508: ,p_detailed_description in varchar2 default hr_api.g_varchar2
509: ,p_job_requirements in varchar2 default hr_api.g_varchar2
510: ,p_additional_details in varchar2 default hr_api.g_varchar2
511: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
512: ,p_benefit_info in varchar2 default hr_api.g_varchar2

Line 509: ,p_job_requirements in varchar2 default hr_api.g_varchar2

505: ,p_org_description in varchar2 default hr_api.g_varchar2
506: ,p_job_title in varchar2 default hr_api.g_varchar2
507: ,p_brief_description in varchar2 default hr_api.g_varchar2
508: ,p_detailed_description in varchar2 default hr_api.g_varchar2
509: ,p_job_requirements in varchar2 default hr_api.g_varchar2
510: ,p_additional_details in varchar2 default hr_api.g_varchar2
511: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
512: ,p_benefit_info in varchar2 default hr_api.g_varchar2
513: ,p_image_url in varchar2 default hr_api.g_varchar2

Line 510: ,p_additional_details in varchar2 default hr_api.g_varchar2

506: ,p_job_title in varchar2 default hr_api.g_varchar2
507: ,p_brief_description in varchar2 default hr_api.g_varchar2
508: ,p_detailed_description in varchar2 default hr_api.g_varchar2
509: ,p_job_requirements in varchar2 default hr_api.g_varchar2
510: ,p_additional_details in varchar2 default hr_api.g_varchar2
511: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
512: ,p_benefit_info in varchar2 default hr_api.g_varchar2
513: ,p_image_url in varchar2 default hr_api.g_varchar2
514: ,p_image_url_alt in varchar2 default hr_api.g_varchar2

Line 511: ,p_how_to_apply in varchar2 default hr_api.g_varchar2

507: ,p_brief_description in varchar2 default hr_api.g_varchar2
508: ,p_detailed_description in varchar2 default hr_api.g_varchar2
509: ,p_job_requirements in varchar2 default hr_api.g_varchar2
510: ,p_additional_details in varchar2 default hr_api.g_varchar2
511: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
512: ,p_benefit_info in varchar2 default hr_api.g_varchar2
513: ,p_image_url in varchar2 default hr_api.g_varchar2
514: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
515: ) is

Line 512: ,p_benefit_info in varchar2 default hr_api.g_varchar2

508: ,p_detailed_description in varchar2 default hr_api.g_varchar2
509: ,p_job_requirements in varchar2 default hr_api.g_varchar2
510: ,p_additional_details in varchar2 default hr_api.g_varchar2
511: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
512: ,p_benefit_info in varchar2 default hr_api.g_varchar2
513: ,p_image_url in varchar2 default hr_api.g_varchar2
514: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
515: ) is
516: --

Line 513: ,p_image_url in varchar2 default hr_api.g_varchar2

509: ,p_job_requirements in varchar2 default hr_api.g_varchar2
510: ,p_additional_details in varchar2 default hr_api.g_varchar2
511: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
512: ,p_benefit_info in varchar2 default hr_api.g_varchar2
513: ,p_image_url in varchar2 default hr_api.g_varchar2
514: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
515: ) is
516: --
517: l_rec irc_ipt_shd.g_rec_type;

Line 514: ,p_image_url_alt in varchar2 default hr_api.g_varchar2

510: ,p_additional_details in varchar2 default hr_api.g_varchar2
511: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
512: ,p_benefit_info in varchar2 default hr_api.g_varchar2
513: ,p_image_url in varchar2 default hr_api.g_varchar2
514: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
515: ) is
516: --
517: l_rec irc_ipt_shd.g_rec_type;
518: l_proc varchar2(72) := g_package||'upd';

Line 563: ,p_name in varchar2 default hr_api.g_varchar2

559: -- ----------------------------------------------------------------------------
560: Procedure upd_tl
561: (p_language_code in varchar2
562: ,p_posting_content_id in number
563: ,p_name in varchar2 default hr_api.g_varchar2
564: ,p_org_name in varchar2 default hr_api.g_varchar2
565: ,p_org_description in varchar2 default hr_api.g_varchar2
566: ,p_job_title in varchar2 default hr_api.g_varchar2
567: ,p_brief_description in varchar2 default hr_api.g_varchar2

Line 564: ,p_org_name in varchar2 default hr_api.g_varchar2

560: Procedure upd_tl
561: (p_language_code in varchar2
562: ,p_posting_content_id in number
563: ,p_name in varchar2 default hr_api.g_varchar2
564: ,p_org_name in varchar2 default hr_api.g_varchar2
565: ,p_org_description in varchar2 default hr_api.g_varchar2
566: ,p_job_title in varchar2 default hr_api.g_varchar2
567: ,p_brief_description in varchar2 default hr_api.g_varchar2
568: ,p_detailed_description in varchar2 default hr_api.g_varchar2

Line 565: ,p_org_description in varchar2 default hr_api.g_varchar2

561: (p_language_code in varchar2
562: ,p_posting_content_id in number
563: ,p_name in varchar2 default hr_api.g_varchar2
564: ,p_org_name in varchar2 default hr_api.g_varchar2
565: ,p_org_description in varchar2 default hr_api.g_varchar2
566: ,p_job_title in varchar2 default hr_api.g_varchar2
567: ,p_brief_description in varchar2 default hr_api.g_varchar2
568: ,p_detailed_description in varchar2 default hr_api.g_varchar2
569: ,p_job_requirements in varchar2 default hr_api.g_varchar2

Line 566: ,p_job_title in varchar2 default hr_api.g_varchar2

562: ,p_posting_content_id in number
563: ,p_name in varchar2 default hr_api.g_varchar2
564: ,p_org_name in varchar2 default hr_api.g_varchar2
565: ,p_org_description in varchar2 default hr_api.g_varchar2
566: ,p_job_title in varchar2 default hr_api.g_varchar2
567: ,p_brief_description in varchar2 default hr_api.g_varchar2
568: ,p_detailed_description in varchar2 default hr_api.g_varchar2
569: ,p_job_requirements in varchar2 default hr_api.g_varchar2
570: ,p_additional_details in varchar2 default hr_api.g_varchar2

Line 567: ,p_brief_description in varchar2 default hr_api.g_varchar2

563: ,p_name in varchar2 default hr_api.g_varchar2
564: ,p_org_name in varchar2 default hr_api.g_varchar2
565: ,p_org_description in varchar2 default hr_api.g_varchar2
566: ,p_job_title in varchar2 default hr_api.g_varchar2
567: ,p_brief_description in varchar2 default hr_api.g_varchar2
568: ,p_detailed_description in varchar2 default hr_api.g_varchar2
569: ,p_job_requirements in varchar2 default hr_api.g_varchar2
570: ,p_additional_details in varchar2 default hr_api.g_varchar2
571: ,p_how_to_apply in varchar2 default hr_api.g_varchar2

Line 568: ,p_detailed_description in varchar2 default hr_api.g_varchar2

564: ,p_org_name in varchar2 default hr_api.g_varchar2
565: ,p_org_description in varchar2 default hr_api.g_varchar2
566: ,p_job_title in varchar2 default hr_api.g_varchar2
567: ,p_brief_description in varchar2 default hr_api.g_varchar2
568: ,p_detailed_description in varchar2 default hr_api.g_varchar2
569: ,p_job_requirements in varchar2 default hr_api.g_varchar2
570: ,p_additional_details in varchar2 default hr_api.g_varchar2
571: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
572: ,p_benefit_info in varchar2 default hr_api.g_varchar2

Line 569: ,p_job_requirements in varchar2 default hr_api.g_varchar2

565: ,p_org_description in varchar2 default hr_api.g_varchar2
566: ,p_job_title in varchar2 default hr_api.g_varchar2
567: ,p_brief_description in varchar2 default hr_api.g_varchar2
568: ,p_detailed_description in varchar2 default hr_api.g_varchar2
569: ,p_job_requirements in varchar2 default hr_api.g_varchar2
570: ,p_additional_details in varchar2 default hr_api.g_varchar2
571: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
572: ,p_benefit_info in varchar2 default hr_api.g_varchar2
573: ,p_image_url in varchar2 default hr_api.g_varchar2

Line 570: ,p_additional_details in varchar2 default hr_api.g_varchar2

566: ,p_job_title in varchar2 default hr_api.g_varchar2
567: ,p_brief_description in varchar2 default hr_api.g_varchar2
568: ,p_detailed_description in varchar2 default hr_api.g_varchar2
569: ,p_job_requirements in varchar2 default hr_api.g_varchar2
570: ,p_additional_details in varchar2 default hr_api.g_varchar2
571: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
572: ,p_benefit_info in varchar2 default hr_api.g_varchar2
573: ,p_image_url in varchar2 default hr_api.g_varchar2
574: ,p_image_url_alt in varchar2 default hr_api.g_varchar2

Line 571: ,p_how_to_apply in varchar2 default hr_api.g_varchar2

567: ,p_brief_description in varchar2 default hr_api.g_varchar2
568: ,p_detailed_description in varchar2 default hr_api.g_varchar2
569: ,p_job_requirements in varchar2 default hr_api.g_varchar2
570: ,p_additional_details in varchar2 default hr_api.g_varchar2
571: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
572: ,p_benefit_info in varchar2 default hr_api.g_varchar2
573: ,p_image_url in varchar2 default hr_api.g_varchar2
574: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
575: ) is

Line 572: ,p_benefit_info in varchar2 default hr_api.g_varchar2

568: ,p_detailed_description in varchar2 default hr_api.g_varchar2
569: ,p_job_requirements in varchar2 default hr_api.g_varchar2
570: ,p_additional_details in varchar2 default hr_api.g_varchar2
571: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
572: ,p_benefit_info in varchar2 default hr_api.g_varchar2
573: ,p_image_url in varchar2 default hr_api.g_varchar2
574: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
575: ) is
576: --

Line 573: ,p_image_url in varchar2 default hr_api.g_varchar2

569: ,p_job_requirements in varchar2 default hr_api.g_varchar2
570: ,p_additional_details in varchar2 default hr_api.g_varchar2
571: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
572: ,p_benefit_info in varchar2 default hr_api.g_varchar2
573: ,p_image_url in varchar2 default hr_api.g_varchar2
574: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
575: ) is
576: --
577: -- Cursor to obtain the translation rows where the language or

Line 574: ,p_image_url_alt in varchar2 default hr_api.g_varchar2

570: ,p_additional_details in varchar2 default hr_api.g_varchar2
571: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
572: ,p_benefit_info in varchar2 default hr_api.g_varchar2
573: ,p_image_url in varchar2 default hr_api.g_varchar2
574: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
575: ) is
576: --
577: -- Cursor to obtain the translation rows where the language or
578: -- source_lang match the specified language.