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_IPT_UPD dependencies on IRC_IPT_SHD

Line 55: (p_rec in out nocopy irc_ipt_shd.g_rec_type

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

Line 68: if irc_ipt_shd.g_org_description_upd then

64: --
65: --
66: -- Update the irc_posting_contents_tl Row
67: --
68: if irc_ipt_shd.g_org_description_upd then
69: update irc_posting_contents_tl
70: set org_description = empty_clob()
71: where posting_content_id = p_rec.posting_content_id
72: and language = p_rec.language;

Line 75: if irc_ipt_shd.g_brief_description_upd then

71: where posting_content_id = p_rec.posting_content_id
72: and language = p_rec.language;
73: end if;
74: --
75: if irc_ipt_shd.g_brief_description_upd then
76: update irc_posting_contents_tl
77: set brief_description = empty_clob()
78: where posting_content_id = p_rec.posting_content_id
79: and language = p_rec.language;

Line 82: if irc_ipt_shd.g_detailed_description_upd then

78: where posting_content_id = p_rec.posting_content_id
79: and language = p_rec.language;
80: end if;
81: --
82: if irc_ipt_shd.g_detailed_description_upd then
83: update irc_posting_contents_tl
84: set detailed_description = empty_clob()
85: where posting_content_id = p_rec.posting_content_id
86: and language = p_rec.language;

Line 89: if irc_ipt_shd.g_job_requirements_upd then

85: where posting_content_id = p_rec.posting_content_id
86: and language = p_rec.language;
87: end if;
88: --
89: if irc_ipt_shd.g_job_requirements_upd then
90: update irc_posting_contents_tl
91: set job_requirements = empty_clob()
92: where posting_content_id = p_rec.posting_content_id
93: and language = p_rec.language;

Line 96: if irc_ipt_shd.g_additional_details_upd then

92: where posting_content_id = p_rec.posting_content_id
93: and language = p_rec.language;
94: end if;
95: --
96: if irc_ipt_shd.g_additional_details_upd then
97: update irc_posting_contents_tl
98: set additional_details = empty_clob()
99: where posting_content_id = p_rec.posting_content_id
100: and language = p_rec.language;

Line 103: if irc_ipt_shd.g_how_to_apply_upd then

99: where posting_content_id = p_rec.posting_content_id
100: and language = p_rec.language;
101: end if;
102: --
103: if irc_ipt_shd.g_how_to_apply_upd then
104: update irc_posting_contents_tl
105: set how_to_apply = empty_clob()
106: where posting_content_id = p_rec.posting_content_id
107: and language = p_rec.language;

Line 110: if irc_ipt_shd.g_image_url_upd then

106: where posting_content_id = p_rec.posting_content_id
107: and language = p_rec.language;
108: end if;
109: --
110: if irc_ipt_shd.g_image_url_upd then
111: update irc_posting_contents_tl
112: set image_url = empty_clob()
113: where posting_content_id = p_rec.posting_content_id
114: and language = p_rec.language;

Line 117: if irc_ipt_shd.g_image_url_alt_upd then

113: where posting_content_id = p_rec.posting_content_id
114: and language = p_rec.language;
115: end if;
116: --
117: if irc_ipt_shd.g_image_url_alt_upd then
118: update irc_posting_contents_tl
119: set image_url_alt = empty_clob()
120: where posting_content_id = p_rec.posting_content_id
121: and language = p_rec.language;

Line 136: irc_ipt_shd.clob_dml(p_rec => p_rec

132: ,job_title = p_rec.job_title
133: where posting_content_id = p_rec.posting_content_id
134: and language = p_rec.language;
135:
136: irc_ipt_shd.clob_dml(p_rec => p_rec
137: ,p_api_updating => true);
138: --
139: --
140: --

Line 147: irc_ipt_shd.constraint_error

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));
149: When hr_api.parent_integrity_violated Then
150: -- Parent integrity has been violated
151: --

Line 152: 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));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
156: --

Line 157: 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));
159: When Others Then
160: --
161: Raise;

Line 197: (p_rec in irc_ipt_shd.g_rec_type

193: --
194: -- {End Of Comments}
195: -- ----------------------------------------------------------------------------
196: Procedure pre_update
197: (p_rec in irc_ipt_shd.g_rec_type
198: ) is
199: --
200: l_proc varchar2(72) := g_package||'pre_update';
201: --

Line 241: (p_rec in irc_ipt_shd.g_rec_type

237: --
238: -- {End Of Comments}
239: -- ----------------------------------------------------------------------------
240: Procedure post_update
241: (p_rec in irc_ipt_shd.g_rec_type
242: ) is
243: --
244: l_proc varchar2(72) := g_package||'post_update';
245: --

Line 282: => irc_ipt_shd.g_old_rec.source_language

278: => p_rec.image_url
279: ,p_image_url_alt
280: => p_rec.image_url_alt
281: ,p_source_language_o
282: => irc_ipt_shd.g_old_rec.source_language
283: ,p_name_o
284: => irc_ipt_shd.g_old_rec.name
285: ,p_org_name_o
286: => irc_ipt_shd.g_old_rec.org_name

Line 284: => irc_ipt_shd.g_old_rec.name

280: => p_rec.image_url_alt
281: ,p_source_language_o
282: => irc_ipt_shd.g_old_rec.source_language
283: ,p_name_o
284: => irc_ipt_shd.g_old_rec.name
285: ,p_org_name_o
286: => irc_ipt_shd.g_old_rec.org_name
287: ,p_org_description_o
288: => irc_ipt_shd.g_old_rec.org_description

Line 286: => irc_ipt_shd.g_old_rec.org_name

282: => irc_ipt_shd.g_old_rec.source_language
283: ,p_name_o
284: => irc_ipt_shd.g_old_rec.name
285: ,p_org_name_o
286: => irc_ipt_shd.g_old_rec.org_name
287: ,p_org_description_o
288: => irc_ipt_shd.g_old_rec.org_description
289: ,p_job_title_o
290: => irc_ipt_shd.g_old_rec.job_title

Line 288: => irc_ipt_shd.g_old_rec.org_description

284: => irc_ipt_shd.g_old_rec.name
285: ,p_org_name_o
286: => irc_ipt_shd.g_old_rec.org_name
287: ,p_org_description_o
288: => irc_ipt_shd.g_old_rec.org_description
289: ,p_job_title_o
290: => irc_ipt_shd.g_old_rec.job_title
291: ,p_brief_description_o
292: => irc_ipt_shd.g_old_rec.brief_description

Line 290: => irc_ipt_shd.g_old_rec.job_title

286: => irc_ipt_shd.g_old_rec.org_name
287: ,p_org_description_o
288: => irc_ipt_shd.g_old_rec.org_description
289: ,p_job_title_o
290: => irc_ipt_shd.g_old_rec.job_title
291: ,p_brief_description_o
292: => irc_ipt_shd.g_old_rec.brief_description
293: ,p_detailed_description_o
294: => irc_ipt_shd.g_old_rec.detailed_description

Line 292: => irc_ipt_shd.g_old_rec.brief_description

288: => irc_ipt_shd.g_old_rec.org_description
289: ,p_job_title_o
290: => irc_ipt_shd.g_old_rec.job_title
291: ,p_brief_description_o
292: => irc_ipt_shd.g_old_rec.brief_description
293: ,p_detailed_description_o
294: => irc_ipt_shd.g_old_rec.detailed_description
295: ,p_job_requirements_o
296: => irc_ipt_shd.g_old_rec.job_requirements

Line 294: => irc_ipt_shd.g_old_rec.detailed_description

290: => irc_ipt_shd.g_old_rec.job_title
291: ,p_brief_description_o
292: => irc_ipt_shd.g_old_rec.brief_description
293: ,p_detailed_description_o
294: => irc_ipt_shd.g_old_rec.detailed_description
295: ,p_job_requirements_o
296: => irc_ipt_shd.g_old_rec.job_requirements
297: ,p_additional_details_o
298: => irc_ipt_shd.g_old_rec.additional_details

Line 296: => irc_ipt_shd.g_old_rec.job_requirements

292: => irc_ipt_shd.g_old_rec.brief_description
293: ,p_detailed_description_o
294: => irc_ipt_shd.g_old_rec.detailed_description
295: ,p_job_requirements_o
296: => irc_ipt_shd.g_old_rec.job_requirements
297: ,p_additional_details_o
298: => irc_ipt_shd.g_old_rec.additional_details
299: ,p_how_to_apply_o
300: => irc_ipt_shd.g_old_rec.how_to_apply

Line 298: => irc_ipt_shd.g_old_rec.additional_details

294: => irc_ipt_shd.g_old_rec.detailed_description
295: ,p_job_requirements_o
296: => irc_ipt_shd.g_old_rec.job_requirements
297: ,p_additional_details_o
298: => irc_ipt_shd.g_old_rec.additional_details
299: ,p_how_to_apply_o
300: => irc_ipt_shd.g_old_rec.how_to_apply
301: ,p_benefit_info_o
302: => irc_ipt_shd.g_old_rec.benefit_info

Line 300: => irc_ipt_shd.g_old_rec.how_to_apply

296: => irc_ipt_shd.g_old_rec.job_requirements
297: ,p_additional_details_o
298: => irc_ipt_shd.g_old_rec.additional_details
299: ,p_how_to_apply_o
300: => irc_ipt_shd.g_old_rec.how_to_apply
301: ,p_benefit_info_o
302: => irc_ipt_shd.g_old_rec.benefit_info
303: ,p_image_url_o
304: => irc_ipt_shd.g_old_rec.image_url

Line 302: => irc_ipt_shd.g_old_rec.benefit_info

298: => irc_ipt_shd.g_old_rec.additional_details
299: ,p_how_to_apply_o
300: => irc_ipt_shd.g_old_rec.how_to_apply
301: ,p_benefit_info_o
302: => irc_ipt_shd.g_old_rec.benefit_info
303: ,p_image_url_o
304: => irc_ipt_shd.g_old_rec.image_url
305: ,p_image_url_alt_o
306: => irc_ipt_shd.g_old_rec.image_url_alt

Line 304: => irc_ipt_shd.g_old_rec.image_url

300: => irc_ipt_shd.g_old_rec.how_to_apply
301: ,p_benefit_info_o
302: => irc_ipt_shd.g_old_rec.benefit_info
303: ,p_image_url_o
304: => irc_ipt_shd.g_old_rec.image_url
305: ,p_image_url_alt_o
306: => irc_ipt_shd.g_old_rec.image_url_alt
307: );
308: --

Line 306: => irc_ipt_shd.g_old_rec.image_url_alt

302: => irc_ipt_shd.g_old_rec.benefit_info
303: ,p_image_url_o
304: => irc_ipt_shd.g_old_rec.image_url
305: ,p_image_url_alt_o
306: => irc_ipt_shd.g_old_rec.image_url_alt
307: );
308: --
309: exception
310: --

Line 366: (p_rec in out nocopy irc_ipt_shd.g_rec_type

362: --
363: -- {End Of Comments}
364: -- ----------------------------------------------------------------------------
365: Procedure convert_defs
366: (p_rec in out nocopy irc_ipt_shd.g_rec_type
367: ) is
368: --
369: Begin
370: --

Line 378: irc_ipt_shd.g_old_rec.source_language;

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
381: p_rec.name :=
382: irc_ipt_shd.g_old_rec.name;

Line 382: irc_ipt_shd.g_old_rec.name;

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
385: p_rec.org_name :=
386: irc_ipt_shd.g_old_rec.org_name;

Line 386: irc_ipt_shd.g_old_rec.org_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
389: p_rec.org_description :=
390: irc_ipt_shd.g_old_rec.org_description;

Line 390: irc_ipt_shd.g_old_rec.org_description;

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

Line 392: irc_ipt_shd.g_org_description_upd := true;

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

Line 396: irc_ipt_shd.g_old_rec.job_title;

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
399: p_rec.brief_description :=
400: irc_ipt_shd.g_old_rec.brief_description;

Line 400: irc_ipt_shd.g_old_rec.brief_description;

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

Line 402: irc_ipt_shd.g_brief_description_upd := true;

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

Line 406: irc_ipt_shd.g_old_rec.detailed_description;

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

Line 408: irc_ipt_shd.g_detailed_description_upd := true;

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

Line 412: irc_ipt_shd.g_old_rec.job_requirements;

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

Line 414: irc_ipt_shd.g_job_requirements_upd := true;

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

Line 418: irc_ipt_shd.g_old_rec.additional_details;

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

Line 420: irc_ipt_shd.g_additional_details_upd := true;

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

Line 424: irc_ipt_shd.g_old_rec.how_to_apply;

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;
427: End If;
428: If (p_rec.benefit_info = hr_api.g_varchar2) then

Line 426: irc_ipt_shd.g_how_to_apply_upd := true;

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

Line 430: irc_ipt_shd.g_old_rec.benefit_info;

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

Line 432: irc_ipt_shd.g_benefit_info_upd := true;

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

Line 436: irc_ipt_shd.g_old_rec.image_url;

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

Line 438: irc_ipt_shd.g_image_url_upd := true;

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

Line 442: irc_ipt_shd.g_old_rec.image_url_alt;

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;
445: End If;
446: --

Line 444: irc_ipt_shd.g_image_url_alt_upd := true;

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;
445: End If;
446: --
447: End convert_defs;
448: --

Line 453: (p_rec in out nocopy irc_ipt_shd.g_rec_type

449: -- ----------------------------------------------------------------------------
450: -- |---------------------------------< upd >----------------------------------|
451: -- ----------------------------------------------------------------------------
452: Procedure upd
453: (p_rec in out nocopy irc_ipt_shd.g_rec_type
454: ) is
455: --
456: l_proc varchar2(72) := g_package||'upd';
457: --

Line 463: irc_ipt_shd.lck

459: hr_utility.set_location('Entering:'||l_proc, 5);
460: --
461: -- We must lock the row which we need to update.
462: --
463: irc_ipt_shd.lck
464: (p_rec.posting_content_id
465: ,p_rec.language
466: );
467: --

Line 517: l_rec irc_ipt_shd.g_rec_type;

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';
519: --
520: Begin
521: hr_utility.set_location('Entering:'||l_proc, 5);

Line 527: irc_ipt_shd.convert_args

523: -- Call conversion function to turn arguments into the
524: -- l_rec structure.
525: --
526: l_rec :=
527: irc_ipt_shd.convert_args
528: (p_posting_content_id
529: ,p_language
530: ,p_source_language
531: ,p_name