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 IRC_IDT_SHD

Line 55: (p_rec in out nocopy irc_idt_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy irc_idt_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 86: irc_idt_shd.clob_dml(p_rec => p_rec

82: ,image_url_alt = empty_clob()
83: where default_posting_id = p_rec.default_posting_id
84: and language = p_rec.language;
85: --
86: irc_idt_shd.clob_dml(p_rec => p_rec
87: ,p_api_updating => true);
88: --
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 96: irc_idt_shd.constraint_error

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));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: --

Line 101: 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));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: --

Line 106: 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));
108: When Others Then
109: --
110: Raise;

Line 146: (p_rec in irc_idt_shd.g_rec_type

142: --
143: -- {End Of Comments}
144: -- ----------------------------------------------------------------------------
145: Procedure pre_update
146: (p_rec in irc_idt_shd.g_rec_type
147: ) is
148: --
149: l_proc varchar2(72) := g_package||'pre_update';
150: --

Line 190: (p_rec in irc_idt_shd.g_rec_type

186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure post_update
190: (p_rec in irc_idt_shd.g_rec_type
191: ) is
192: --
193: l_proc varchar2(72) := g_package||'post_update';
194: --

Line 227: => irc_idt_shd.g_old_rec.source_language

223: => p_rec.image_url
224: ,p_image_url_alt
225: => p_rec.image_url_alt
226: ,p_source_language_o
227: => irc_idt_shd.g_old_rec.source_language
228: ,p_org_name_o
229: => irc_idt_shd.g_old_rec.org_name
230: ,p_org_description_o
231: => irc_idt_shd.g_old_rec.org_description

Line 229: => irc_idt_shd.g_old_rec.org_name

225: => p_rec.image_url_alt
226: ,p_source_language_o
227: => irc_idt_shd.g_old_rec.source_language
228: ,p_org_name_o
229: => irc_idt_shd.g_old_rec.org_name
230: ,p_org_description_o
231: => irc_idt_shd.g_old_rec.org_description
232: ,p_job_title_o
233: => irc_idt_shd.g_old_rec.job_title

Line 231: => irc_idt_shd.g_old_rec.org_description

227: => irc_idt_shd.g_old_rec.source_language
228: ,p_org_name_o
229: => irc_idt_shd.g_old_rec.org_name
230: ,p_org_description_o
231: => irc_idt_shd.g_old_rec.org_description
232: ,p_job_title_o
233: => irc_idt_shd.g_old_rec.job_title
234: ,p_brief_description_o
235: => irc_idt_shd.g_old_rec.brief_description

Line 233: => irc_idt_shd.g_old_rec.job_title

229: => irc_idt_shd.g_old_rec.org_name
230: ,p_org_description_o
231: => irc_idt_shd.g_old_rec.org_description
232: ,p_job_title_o
233: => irc_idt_shd.g_old_rec.job_title
234: ,p_brief_description_o
235: => irc_idt_shd.g_old_rec.brief_description
236: ,p_detailed_description_o
237: => irc_idt_shd.g_old_rec.detailed_description

Line 235: => irc_idt_shd.g_old_rec.brief_description

231: => irc_idt_shd.g_old_rec.org_description
232: ,p_job_title_o
233: => irc_idt_shd.g_old_rec.job_title
234: ,p_brief_description_o
235: => irc_idt_shd.g_old_rec.brief_description
236: ,p_detailed_description_o
237: => irc_idt_shd.g_old_rec.detailed_description
238: ,p_job_requirements_o
239: => irc_idt_shd.g_old_rec.job_requirements

Line 237: => irc_idt_shd.g_old_rec.detailed_description

233: => irc_idt_shd.g_old_rec.job_title
234: ,p_brief_description_o
235: => irc_idt_shd.g_old_rec.brief_description
236: ,p_detailed_description_o
237: => irc_idt_shd.g_old_rec.detailed_description
238: ,p_job_requirements_o
239: => irc_idt_shd.g_old_rec.job_requirements
240: ,p_additional_details_o
241: => irc_idt_shd.g_old_rec.additional_details

Line 239: => irc_idt_shd.g_old_rec.job_requirements

235: => irc_idt_shd.g_old_rec.brief_description
236: ,p_detailed_description_o
237: => irc_idt_shd.g_old_rec.detailed_description
238: ,p_job_requirements_o
239: => irc_idt_shd.g_old_rec.job_requirements
240: ,p_additional_details_o
241: => irc_idt_shd.g_old_rec.additional_details
242: ,p_how_to_apply_o
243: => irc_idt_shd.g_old_rec.how_to_apply

Line 241: => irc_idt_shd.g_old_rec.additional_details

237: => irc_idt_shd.g_old_rec.detailed_description
238: ,p_job_requirements_o
239: => irc_idt_shd.g_old_rec.job_requirements
240: ,p_additional_details_o
241: => irc_idt_shd.g_old_rec.additional_details
242: ,p_how_to_apply_o
243: => irc_idt_shd.g_old_rec.how_to_apply
244: ,p_image_url_o
245: => irc_idt_shd.g_old_rec.image_url

Line 243: => irc_idt_shd.g_old_rec.how_to_apply

239: => irc_idt_shd.g_old_rec.job_requirements
240: ,p_additional_details_o
241: => irc_idt_shd.g_old_rec.additional_details
242: ,p_how_to_apply_o
243: => irc_idt_shd.g_old_rec.how_to_apply
244: ,p_image_url_o
245: => irc_idt_shd.g_old_rec.image_url
246: ,p_image_url_alt_o
247: => irc_idt_shd.g_old_rec.image_url_alt

Line 245: => irc_idt_shd.g_old_rec.image_url

241: => irc_idt_shd.g_old_rec.additional_details
242: ,p_how_to_apply_o
243: => irc_idt_shd.g_old_rec.how_to_apply
244: ,p_image_url_o
245: => irc_idt_shd.g_old_rec.image_url
246: ,p_image_url_alt_o
247: => irc_idt_shd.g_old_rec.image_url_alt
248: );
249: --

Line 247: => irc_idt_shd.g_old_rec.image_url_alt

243: => irc_idt_shd.g_old_rec.how_to_apply
244: ,p_image_url_o
245: => irc_idt_shd.g_old_rec.image_url
246: ,p_image_url_alt_o
247: => irc_idt_shd.g_old_rec.image_url_alt
248: );
249: --
250: exception
251: --

Line 307: (p_rec in out nocopy irc_idt_shd.g_rec_type

303: --
304: -- {End Of Comments}
305: -- ----------------------------------------------------------------------------
306: Procedure convert_defs
307: (p_rec in out nocopy irc_idt_shd.g_rec_type
308: ) is
309: --
310: Begin
311: --

Line 319: irc_idt_shd.g_old_rec.source_language;

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
322: p_rec.org_name :=
323: irc_idt_shd.g_old_rec.org_name;

Line 323: irc_idt_shd.g_old_rec.org_name;

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
326: p_rec.org_description :=
327: irc_idt_shd.g_old_rec.org_description;

Line 327: irc_idt_shd.g_old_rec.org_description;

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;
330: End If;
331: If (p_rec.job_title = hr_api.g_varchar2) then

Line 329: irc_idt_shd.g_org_description_upd:=true;

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

Line 333: irc_idt_shd.g_old_rec.job_title;

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
336: p_rec.brief_description :=
337: irc_idt_shd.g_old_rec.brief_description;

Line 337: irc_idt_shd.g_old_rec.brief_description;

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;
340: End If;
341: If (p_rec.detailed_description = hr_api.g_varchar2) then

Line 339: irc_idt_shd.g_brief_description_upd:=true;

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

Line 343: irc_idt_shd.g_old_rec.detailed_description;

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;
346: End If;
347: If (p_rec.job_requirements = hr_api.g_varchar2) then

Line 345: irc_idt_shd.g_detailed_description_upd:=true;

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

Line 349: irc_idt_shd.g_old_rec.job_requirements;

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;
352: End If;
353: If (p_rec.additional_details = hr_api.g_varchar2) then

Line 351: irc_idt_shd.g_job_requirements_upd:=true;

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

Line 355: irc_idt_shd.g_old_rec.additional_details;

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;
358: End If;
359: If (p_rec.how_to_apply = hr_api.g_varchar2) then

Line 357: irc_idt_shd.g_additional_details_upd:=true;

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

Line 361: irc_idt_shd.g_old_rec.how_to_apply;

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;
364: End If;
365: If (p_rec.image_url = hr_api.g_varchar2) then

Line 363: irc_idt_shd.g_how_to_apply_upd:=true;

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

Line 367: irc_idt_shd.g_old_rec.image_url;

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;
370: End If;
371: If (p_rec.image_url_alt = hr_api.g_varchar2) then

Line 369: irc_idt_shd.g_image_url_upd:=true;

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

Line 373: irc_idt_shd.g_old_rec.image_url_alt;

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;
376: End If;
377: --

Line 375: irc_idt_shd.g_image_url_alt_upd:=true;

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;
376: End If;
377: --
378: End convert_defs;
379: --

Line 384: (p_rec in out nocopy irc_idt_shd.g_rec_type

380: -- ----------------------------------------------------------------------------
381: -- |---------------------------------< upd >----------------------------------|
382: -- ----------------------------------------------------------------------------
383: Procedure upd
384: (p_rec in out nocopy irc_idt_shd.g_rec_type
385: ) is
386: --
387: l_proc varchar2(72) := g_package||'upd';
388: --

Line 394: irc_idt_shd.lck

390: hr_utility.set_location('Entering:'||l_proc, 5);
391: --
392: -- We must lock the row which we need to update.
393: --
394: irc_idt_shd.lck
395: (p_rec.default_posting_id
396: ,p_rec.language
397: );
398: --

Line 444: l_rec irc_idt_shd.g_rec_type;

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';
446: --
447: Begin
448: hr_utility.set_location('Entering:'||l_proc, 5);

Line 454: irc_idt_shd.convert_args

450: -- Call conversion function to turn arguments into the
451: -- l_rec structure.
452: --
453: l_rec :=
454: irc_idt_shd.convert_args
455: (p_default_posting_id
456: ,p_language
457: ,p_source_language
458: ,p_org_name