eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_IDT_UPD dependencies on HR_API

Line 93: When hr_api.check_integrity_violated Then

89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);
91: --
92: Exception
93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: --
96: irc_idt_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: --
96: irc_idt_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: --
101: irc_idt_shd.constraint_error

Line 98: When hr_api.parent_integrity_violated Then

94: -- A check constraint has been violated
95: --
96: irc_idt_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: --
101: irc_idt_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: --
101: irc_idt_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: --
106: irc_idt_shd.constraint_error

Line 103: When hr_api.unique_integrity_violated Then

99: -- Parent integrity has been violated
100: --
101: irc_idt_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: --
106: irc_idt_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: --
106: irc_idt_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When Others Then
109: --
110: Raise;
111: End update_dml;

Line 252: when hr_api.cannot_find_prog_unit then

248: );
249: --
250: exception
251: --
252: when hr_api.cannot_find_prog_unit then
253: --
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'IRC_DEFAULT_POSTINGS_TL'
256: ,p_hook_type => 'AU');

Line 254: hr_api.cannot_find_prog_unit_error

250: exception
251: --
252: when hr_api.cannot_find_prog_unit then
253: --
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'IRC_DEFAULT_POSTINGS_TL'
256: ,p_hook_type => 'AU');
257: --
258: end;

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

313: -- p_rec plsql record structure
314: -- to see if a system default is being used. If a system default
315: -- is being used then we must set to the 'current' argument value.
316: --
317: If (p_rec.source_language = hr_api.g_varchar2) then
318: p_rec.source_language :=
319: irc_idt_shd.g_old_rec.source_language;
320: End If;
321: If (p_rec.org_name = hr_api.g_varchar2) then

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

317: If (p_rec.source_language = hr_api.g_varchar2) then
318: p_rec.source_language :=
319: irc_idt_shd.g_old_rec.source_language;
320: End If;
321: If (p_rec.org_name = hr_api.g_varchar2) then
322: p_rec.org_name :=
323: irc_idt_shd.g_old_rec.org_name;
324: End If;
325: If (p_rec.org_description = hr_api.g_varchar2) then

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

321: If (p_rec.org_name = hr_api.g_varchar2) then
322: p_rec.org_name :=
323: irc_idt_shd.g_old_rec.org_name;
324: End If;
325: If (p_rec.org_description = hr_api.g_varchar2) then
326: p_rec.org_description :=
327: irc_idt_shd.g_old_rec.org_description;
328: else
329: irc_idt_shd.g_org_description_upd:=true;

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

327: irc_idt_shd.g_old_rec.org_description;
328: else
329: irc_idt_shd.g_org_description_upd:=true;
330: End If;
331: If (p_rec.job_title = hr_api.g_varchar2) then
332: p_rec.job_title :=
333: irc_idt_shd.g_old_rec.job_title;
334: End If;
335: If (p_rec.brief_description = hr_api.g_varchar2) then

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

331: If (p_rec.job_title = hr_api.g_varchar2) then
332: p_rec.job_title :=
333: irc_idt_shd.g_old_rec.job_title;
334: End If;
335: If (p_rec.brief_description = hr_api.g_varchar2) then
336: p_rec.brief_description :=
337: irc_idt_shd.g_old_rec.brief_description;
338: else
339: irc_idt_shd.g_brief_description_upd:=true;

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

337: irc_idt_shd.g_old_rec.brief_description;
338: else
339: irc_idt_shd.g_brief_description_upd:=true;
340: End If;
341: If (p_rec.detailed_description = hr_api.g_varchar2) then
342: p_rec.detailed_description :=
343: irc_idt_shd.g_old_rec.detailed_description;
344: else
345: irc_idt_shd.g_detailed_description_upd:=true;

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

343: irc_idt_shd.g_old_rec.detailed_description;
344: else
345: irc_idt_shd.g_detailed_description_upd:=true;
346: End If;
347: If (p_rec.job_requirements = hr_api.g_varchar2) then
348: p_rec.job_requirements :=
349: irc_idt_shd.g_old_rec.job_requirements;
350: else
351: irc_idt_shd.g_job_requirements_upd:=true;

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

349: irc_idt_shd.g_old_rec.job_requirements;
350: else
351: irc_idt_shd.g_job_requirements_upd:=true;
352: End If;
353: If (p_rec.additional_details = hr_api.g_varchar2) then
354: p_rec.additional_details :=
355: irc_idt_shd.g_old_rec.additional_details;
356: else
357: irc_idt_shd.g_additional_details_upd:=true;

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

355: irc_idt_shd.g_old_rec.additional_details;
356: else
357: irc_idt_shd.g_additional_details_upd:=true;
358: End If;
359: If (p_rec.how_to_apply = hr_api.g_varchar2) then
360: p_rec.how_to_apply :=
361: irc_idt_shd.g_old_rec.how_to_apply;
362: else
363: irc_idt_shd.g_how_to_apply_upd:=true;

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

361: irc_idt_shd.g_old_rec.how_to_apply;
362: else
363: irc_idt_shd.g_how_to_apply_upd:=true;
364: End If;
365: If (p_rec.image_url = hr_api.g_varchar2) then
366: p_rec.image_url :=
367: irc_idt_shd.g_old_rec.image_url;
368: else
369: irc_idt_shd.g_image_url_upd:=true;

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

367: irc_idt_shd.g_old_rec.image_url;
368: else
369: irc_idt_shd.g_image_url_upd:=true;
370: End If;
371: If (p_rec.image_url_alt = hr_api.g_varchar2) then
372: p_rec.image_url_alt :=
373: irc_idt_shd.g_old_rec.image_url_alt;
374: else
375: irc_idt_shd.g_image_url_alt_upd:=true;

Line 431: ,p_source_language in varchar2 default hr_api.g_varchar2

427: -- ----------------------------------------------------------------------------
428: Procedure upd
429: (p_default_posting_id in number
430: ,p_language in varchar2
431: ,p_source_language in varchar2 default hr_api.g_varchar2
432: ,p_org_name in varchar2 default hr_api.g_varchar2
433: ,p_org_description in varchar2 default hr_api.g_varchar2
434: ,p_job_title in varchar2 default hr_api.g_varchar2
435: ,p_brief_description in varchar2 default hr_api.g_varchar2

Line 432: ,p_org_name in varchar2 default hr_api.g_varchar2

428: Procedure upd
429: (p_default_posting_id in number
430: ,p_language in varchar2
431: ,p_source_language in varchar2 default hr_api.g_varchar2
432: ,p_org_name in varchar2 default hr_api.g_varchar2
433: ,p_org_description in varchar2 default hr_api.g_varchar2
434: ,p_job_title in varchar2 default hr_api.g_varchar2
435: ,p_brief_description in varchar2 default hr_api.g_varchar2
436: ,p_detailed_description in varchar2 default hr_api.g_varchar2

Line 433: ,p_org_description in varchar2 default hr_api.g_varchar2

429: (p_default_posting_id in number
430: ,p_language in varchar2
431: ,p_source_language in varchar2 default hr_api.g_varchar2
432: ,p_org_name in varchar2 default hr_api.g_varchar2
433: ,p_org_description in varchar2 default hr_api.g_varchar2
434: ,p_job_title in varchar2 default hr_api.g_varchar2
435: ,p_brief_description in varchar2 default hr_api.g_varchar2
436: ,p_detailed_description in varchar2 default hr_api.g_varchar2
437: ,p_job_requirements in varchar2 default hr_api.g_varchar2

Line 434: ,p_job_title in varchar2 default hr_api.g_varchar2

430: ,p_language in varchar2
431: ,p_source_language in varchar2 default hr_api.g_varchar2
432: ,p_org_name in varchar2 default hr_api.g_varchar2
433: ,p_org_description in varchar2 default hr_api.g_varchar2
434: ,p_job_title in varchar2 default hr_api.g_varchar2
435: ,p_brief_description in varchar2 default hr_api.g_varchar2
436: ,p_detailed_description in varchar2 default hr_api.g_varchar2
437: ,p_job_requirements in varchar2 default hr_api.g_varchar2
438: ,p_additional_details in varchar2 default hr_api.g_varchar2

Line 435: ,p_brief_description in varchar2 default hr_api.g_varchar2

431: ,p_source_language in varchar2 default hr_api.g_varchar2
432: ,p_org_name in varchar2 default hr_api.g_varchar2
433: ,p_org_description in varchar2 default hr_api.g_varchar2
434: ,p_job_title in varchar2 default hr_api.g_varchar2
435: ,p_brief_description in varchar2 default hr_api.g_varchar2
436: ,p_detailed_description in varchar2 default hr_api.g_varchar2
437: ,p_job_requirements in varchar2 default hr_api.g_varchar2
438: ,p_additional_details in varchar2 default hr_api.g_varchar2
439: ,p_how_to_apply in varchar2 default hr_api.g_varchar2

Line 436: ,p_detailed_description in varchar2 default hr_api.g_varchar2

432: ,p_org_name in varchar2 default hr_api.g_varchar2
433: ,p_org_description in varchar2 default hr_api.g_varchar2
434: ,p_job_title in varchar2 default hr_api.g_varchar2
435: ,p_brief_description in varchar2 default hr_api.g_varchar2
436: ,p_detailed_description in varchar2 default hr_api.g_varchar2
437: ,p_job_requirements in varchar2 default hr_api.g_varchar2
438: ,p_additional_details in varchar2 default hr_api.g_varchar2
439: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
440: ,p_image_url in varchar2 default hr_api.g_varchar2

Line 437: ,p_job_requirements in varchar2 default hr_api.g_varchar2

433: ,p_org_description in varchar2 default hr_api.g_varchar2
434: ,p_job_title in varchar2 default hr_api.g_varchar2
435: ,p_brief_description in varchar2 default hr_api.g_varchar2
436: ,p_detailed_description in varchar2 default hr_api.g_varchar2
437: ,p_job_requirements in varchar2 default hr_api.g_varchar2
438: ,p_additional_details in varchar2 default hr_api.g_varchar2
439: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
440: ,p_image_url in varchar2 default hr_api.g_varchar2
441: ,p_image_url_alt in varchar2 default hr_api.g_varchar2

Line 438: ,p_additional_details in varchar2 default hr_api.g_varchar2

434: ,p_job_title in varchar2 default hr_api.g_varchar2
435: ,p_brief_description in varchar2 default hr_api.g_varchar2
436: ,p_detailed_description in varchar2 default hr_api.g_varchar2
437: ,p_job_requirements in varchar2 default hr_api.g_varchar2
438: ,p_additional_details in varchar2 default hr_api.g_varchar2
439: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
440: ,p_image_url in varchar2 default hr_api.g_varchar2
441: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
442: ) is

Line 439: ,p_how_to_apply in varchar2 default hr_api.g_varchar2

435: ,p_brief_description in varchar2 default hr_api.g_varchar2
436: ,p_detailed_description in varchar2 default hr_api.g_varchar2
437: ,p_job_requirements in varchar2 default hr_api.g_varchar2
438: ,p_additional_details in varchar2 default hr_api.g_varchar2
439: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
440: ,p_image_url in varchar2 default hr_api.g_varchar2
441: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
442: ) is
443: --

Line 440: ,p_image_url in varchar2 default hr_api.g_varchar2

436: ,p_detailed_description in varchar2 default hr_api.g_varchar2
437: ,p_job_requirements in varchar2 default hr_api.g_varchar2
438: ,p_additional_details in varchar2 default hr_api.g_varchar2
439: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
440: ,p_image_url in varchar2 default hr_api.g_varchar2
441: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
442: ) is
443: --
444: l_rec irc_idt_shd.g_rec_type;

Line 441: ,p_image_url_alt in varchar2 default hr_api.g_varchar2

437: ,p_job_requirements in varchar2 default hr_api.g_varchar2
438: ,p_additional_details in varchar2 default hr_api.g_varchar2
439: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
440: ,p_image_url in varchar2 default hr_api.g_varchar2
441: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
442: ) is
443: --
444: l_rec irc_idt_shd.g_rec_type;
445: l_proc varchar2(72) := g_package||'upd';

Line 488: ,p_org_name in varchar2 default hr_api.g_varchar2

484: -- ----------------------------------------------------------------------------
485: Procedure upd_tl
486: (p_language_code in varchar2
487: ,p_default_posting_id in number
488: ,p_org_name in varchar2 default hr_api.g_varchar2
489: ,p_org_description in varchar2 default hr_api.g_varchar2
490: ,p_job_title in varchar2 default hr_api.g_varchar2
491: ,p_brief_description in varchar2 default hr_api.g_varchar2
492: ,p_detailed_description in varchar2 default hr_api.g_varchar2

Line 489: ,p_org_description in varchar2 default hr_api.g_varchar2

485: Procedure upd_tl
486: (p_language_code in varchar2
487: ,p_default_posting_id in number
488: ,p_org_name in varchar2 default hr_api.g_varchar2
489: ,p_org_description in varchar2 default hr_api.g_varchar2
490: ,p_job_title in varchar2 default hr_api.g_varchar2
491: ,p_brief_description in varchar2 default hr_api.g_varchar2
492: ,p_detailed_description in varchar2 default hr_api.g_varchar2
493: ,p_job_requirements in varchar2 default hr_api.g_varchar2

Line 490: ,p_job_title in varchar2 default hr_api.g_varchar2

486: (p_language_code in varchar2
487: ,p_default_posting_id in number
488: ,p_org_name in varchar2 default hr_api.g_varchar2
489: ,p_org_description in varchar2 default hr_api.g_varchar2
490: ,p_job_title in varchar2 default hr_api.g_varchar2
491: ,p_brief_description in varchar2 default hr_api.g_varchar2
492: ,p_detailed_description in varchar2 default hr_api.g_varchar2
493: ,p_job_requirements in varchar2 default hr_api.g_varchar2
494: ,p_additional_details in varchar2 default hr_api.g_varchar2

Line 491: ,p_brief_description in varchar2 default hr_api.g_varchar2

487: ,p_default_posting_id in number
488: ,p_org_name in varchar2 default hr_api.g_varchar2
489: ,p_org_description in varchar2 default hr_api.g_varchar2
490: ,p_job_title in varchar2 default hr_api.g_varchar2
491: ,p_brief_description in varchar2 default hr_api.g_varchar2
492: ,p_detailed_description in varchar2 default hr_api.g_varchar2
493: ,p_job_requirements in varchar2 default hr_api.g_varchar2
494: ,p_additional_details in varchar2 default hr_api.g_varchar2
495: ,p_how_to_apply in varchar2 default hr_api.g_varchar2

Line 492: ,p_detailed_description in varchar2 default hr_api.g_varchar2

488: ,p_org_name in varchar2 default hr_api.g_varchar2
489: ,p_org_description in varchar2 default hr_api.g_varchar2
490: ,p_job_title in varchar2 default hr_api.g_varchar2
491: ,p_brief_description in varchar2 default hr_api.g_varchar2
492: ,p_detailed_description in varchar2 default hr_api.g_varchar2
493: ,p_job_requirements in varchar2 default hr_api.g_varchar2
494: ,p_additional_details in varchar2 default hr_api.g_varchar2
495: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
496: ,p_image_url in varchar2 default hr_api.g_varchar2

Line 493: ,p_job_requirements in varchar2 default hr_api.g_varchar2

489: ,p_org_description in varchar2 default hr_api.g_varchar2
490: ,p_job_title in varchar2 default hr_api.g_varchar2
491: ,p_brief_description in varchar2 default hr_api.g_varchar2
492: ,p_detailed_description in varchar2 default hr_api.g_varchar2
493: ,p_job_requirements in varchar2 default hr_api.g_varchar2
494: ,p_additional_details in varchar2 default hr_api.g_varchar2
495: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
496: ,p_image_url in varchar2 default hr_api.g_varchar2
497: ,p_image_url_alt in varchar2 default hr_api.g_varchar2

Line 494: ,p_additional_details in varchar2 default hr_api.g_varchar2

490: ,p_job_title in varchar2 default hr_api.g_varchar2
491: ,p_brief_description in varchar2 default hr_api.g_varchar2
492: ,p_detailed_description in varchar2 default hr_api.g_varchar2
493: ,p_job_requirements in varchar2 default hr_api.g_varchar2
494: ,p_additional_details in varchar2 default hr_api.g_varchar2
495: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
496: ,p_image_url in varchar2 default hr_api.g_varchar2
497: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
498: ) is

Line 495: ,p_how_to_apply in varchar2 default hr_api.g_varchar2

491: ,p_brief_description in varchar2 default hr_api.g_varchar2
492: ,p_detailed_description in varchar2 default hr_api.g_varchar2
493: ,p_job_requirements in varchar2 default hr_api.g_varchar2
494: ,p_additional_details in varchar2 default hr_api.g_varchar2
495: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
496: ,p_image_url in varchar2 default hr_api.g_varchar2
497: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
498: ) is
499: --

Line 496: ,p_image_url in varchar2 default hr_api.g_varchar2

492: ,p_detailed_description in varchar2 default hr_api.g_varchar2
493: ,p_job_requirements in varchar2 default hr_api.g_varchar2
494: ,p_additional_details in varchar2 default hr_api.g_varchar2
495: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
496: ,p_image_url in varchar2 default hr_api.g_varchar2
497: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
498: ) is
499: --
500: -- Cursor to obtain the translation rows where the language or

Line 497: ,p_image_url_alt in varchar2 default hr_api.g_varchar2

493: ,p_job_requirements in varchar2 default hr_api.g_varchar2
494: ,p_additional_details in varchar2 default hr_api.g_varchar2
495: ,p_how_to_apply in varchar2 default hr_api.g_varchar2
496: ,p_image_url in varchar2 default hr_api.g_varchar2
497: ,p_image_url_alt in varchar2 default hr_api.g_varchar2
498: ) is
499: --
500: -- Cursor to obtain the translation rows where the language or
501: -- source_lang match the specified language.