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_SHD dependencies on DBMS_LOB

Line 113: :=dbms_lob.substr(irc_idt_shd.g_old_rec.org_description_c);

109: End If;
110: Close C_Sel1;
111: --
112: irc_idt_shd.g_old_rec.org_description
113: :=dbms_lob.substr(irc_idt_shd.g_old_rec.org_description_c);
114: irc_idt_shd.g_old_rec.brief_description
115: :=dbms_lob.substr(irc_idt_shd.g_old_rec.brief_description_c);
116: irc_idt_shd.g_old_rec.detailed_description
117: :=dbms_lob.substr(irc_idt_shd.g_old_rec.detailed_description_c);

Line 115: :=dbms_lob.substr(irc_idt_shd.g_old_rec.brief_description_c);

111: --
112: irc_idt_shd.g_old_rec.org_description
113: :=dbms_lob.substr(irc_idt_shd.g_old_rec.org_description_c);
114: irc_idt_shd.g_old_rec.brief_description
115: :=dbms_lob.substr(irc_idt_shd.g_old_rec.brief_description_c);
116: irc_idt_shd.g_old_rec.detailed_description
117: :=dbms_lob.substr(irc_idt_shd.g_old_rec.detailed_description_c);
118: irc_idt_shd.g_old_rec.job_requirements
119: :=dbms_lob.substr(irc_idt_shd.g_old_rec.job_requirements_c);

Line 117: :=dbms_lob.substr(irc_idt_shd.g_old_rec.detailed_description_c);

113: :=dbms_lob.substr(irc_idt_shd.g_old_rec.org_description_c);
114: irc_idt_shd.g_old_rec.brief_description
115: :=dbms_lob.substr(irc_idt_shd.g_old_rec.brief_description_c);
116: irc_idt_shd.g_old_rec.detailed_description
117: :=dbms_lob.substr(irc_idt_shd.g_old_rec.detailed_description_c);
118: irc_idt_shd.g_old_rec.job_requirements
119: :=dbms_lob.substr(irc_idt_shd.g_old_rec.job_requirements_c);
120: irc_idt_shd.g_old_rec.additional_details
121: :=dbms_lob.substr(irc_idt_shd.g_old_rec.additional_details_c);

Line 119: :=dbms_lob.substr(irc_idt_shd.g_old_rec.job_requirements_c);

115: :=dbms_lob.substr(irc_idt_shd.g_old_rec.brief_description_c);
116: irc_idt_shd.g_old_rec.detailed_description
117: :=dbms_lob.substr(irc_idt_shd.g_old_rec.detailed_description_c);
118: irc_idt_shd.g_old_rec.job_requirements
119: :=dbms_lob.substr(irc_idt_shd.g_old_rec.job_requirements_c);
120: irc_idt_shd.g_old_rec.additional_details
121: :=dbms_lob.substr(irc_idt_shd.g_old_rec.additional_details_c);
122: irc_idt_shd.g_old_rec.how_to_apply
123: :=dbms_lob.substr(irc_idt_shd.g_old_rec.how_to_apply_c);

Line 121: :=dbms_lob.substr(irc_idt_shd.g_old_rec.additional_details_c);

117: :=dbms_lob.substr(irc_idt_shd.g_old_rec.detailed_description_c);
118: irc_idt_shd.g_old_rec.job_requirements
119: :=dbms_lob.substr(irc_idt_shd.g_old_rec.job_requirements_c);
120: irc_idt_shd.g_old_rec.additional_details
121: :=dbms_lob.substr(irc_idt_shd.g_old_rec.additional_details_c);
122: irc_idt_shd.g_old_rec.how_to_apply
123: :=dbms_lob.substr(irc_idt_shd.g_old_rec.how_to_apply_c);
124: irc_idt_shd.g_old_rec.image_url
125: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_c);

Line 123: :=dbms_lob.substr(irc_idt_shd.g_old_rec.how_to_apply_c);

119: :=dbms_lob.substr(irc_idt_shd.g_old_rec.job_requirements_c);
120: irc_idt_shd.g_old_rec.additional_details
121: :=dbms_lob.substr(irc_idt_shd.g_old_rec.additional_details_c);
122: irc_idt_shd.g_old_rec.how_to_apply
123: :=dbms_lob.substr(irc_idt_shd.g_old_rec.how_to_apply_c);
124: irc_idt_shd.g_old_rec.image_url
125: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_c);
126: irc_idt_shd.g_old_rec.image_url_alt
127: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_alt_c);

Line 125: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_c);

121: :=dbms_lob.substr(irc_idt_shd.g_old_rec.additional_details_c);
122: irc_idt_shd.g_old_rec.how_to_apply
123: :=dbms_lob.substr(irc_idt_shd.g_old_rec.how_to_apply_c);
124: irc_idt_shd.g_old_rec.image_url
125: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_c);
126: irc_idt_shd.g_old_rec.image_url_alt
127: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_alt_c);
128: l_fct_ret := true;
129: End If;

Line 127: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_alt_c);

123: :=dbms_lob.substr(irc_idt_shd.g_old_rec.how_to_apply_c);
124: irc_idt_shd.g_old_rec.image_url
125: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_c);
126: irc_idt_shd.g_old_rec.image_url_alt
127: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_alt_c);
128: l_fct_ret := true;
129: End If;
130: End If;
131: Return (l_fct_ret);

Line 202: :=dbms_lob.substr(irc_idt_shd.g_old_rec.org_description_c);

198: fnd_message.raise_error;
199: End If;
200: Close C_Sel1;
201: irc_idt_shd.g_old_rec.org_description
202: :=dbms_lob.substr(irc_idt_shd.g_old_rec.org_description_c);
203: irc_idt_shd.g_old_rec.brief_description
204: :=dbms_lob.substr(irc_idt_shd.g_old_rec.brief_description_c);
205: irc_idt_shd.g_old_rec.detailed_description
206: :=dbms_lob.substr(irc_idt_shd.g_old_rec.detailed_description_c);

Line 204: :=dbms_lob.substr(irc_idt_shd.g_old_rec.brief_description_c);

200: Close C_Sel1;
201: irc_idt_shd.g_old_rec.org_description
202: :=dbms_lob.substr(irc_idt_shd.g_old_rec.org_description_c);
203: irc_idt_shd.g_old_rec.brief_description
204: :=dbms_lob.substr(irc_idt_shd.g_old_rec.brief_description_c);
205: irc_idt_shd.g_old_rec.detailed_description
206: :=dbms_lob.substr(irc_idt_shd.g_old_rec.detailed_description_c);
207: irc_idt_shd.g_old_rec.job_requirements
208: :=dbms_lob.substr(irc_idt_shd.g_old_rec.job_requirements_c);

Line 206: :=dbms_lob.substr(irc_idt_shd.g_old_rec.detailed_description_c);

202: :=dbms_lob.substr(irc_idt_shd.g_old_rec.org_description_c);
203: irc_idt_shd.g_old_rec.brief_description
204: :=dbms_lob.substr(irc_idt_shd.g_old_rec.brief_description_c);
205: irc_idt_shd.g_old_rec.detailed_description
206: :=dbms_lob.substr(irc_idt_shd.g_old_rec.detailed_description_c);
207: irc_idt_shd.g_old_rec.job_requirements
208: :=dbms_lob.substr(irc_idt_shd.g_old_rec.job_requirements_c);
209: irc_idt_shd.g_old_rec.additional_details
210: :=dbms_lob.substr(irc_idt_shd.g_old_rec.additional_details_c);

Line 208: :=dbms_lob.substr(irc_idt_shd.g_old_rec.job_requirements_c);

204: :=dbms_lob.substr(irc_idt_shd.g_old_rec.brief_description_c);
205: irc_idt_shd.g_old_rec.detailed_description
206: :=dbms_lob.substr(irc_idt_shd.g_old_rec.detailed_description_c);
207: irc_idt_shd.g_old_rec.job_requirements
208: :=dbms_lob.substr(irc_idt_shd.g_old_rec.job_requirements_c);
209: irc_idt_shd.g_old_rec.additional_details
210: :=dbms_lob.substr(irc_idt_shd.g_old_rec.additional_details_c);
211: irc_idt_shd.g_old_rec.how_to_apply
212: :=dbms_lob.substr(irc_idt_shd.g_old_rec.how_to_apply_c);

Line 210: :=dbms_lob.substr(irc_idt_shd.g_old_rec.additional_details_c);

206: :=dbms_lob.substr(irc_idt_shd.g_old_rec.detailed_description_c);
207: irc_idt_shd.g_old_rec.job_requirements
208: :=dbms_lob.substr(irc_idt_shd.g_old_rec.job_requirements_c);
209: irc_idt_shd.g_old_rec.additional_details
210: :=dbms_lob.substr(irc_idt_shd.g_old_rec.additional_details_c);
211: irc_idt_shd.g_old_rec.how_to_apply
212: :=dbms_lob.substr(irc_idt_shd.g_old_rec.how_to_apply_c);
213: irc_idt_shd.g_old_rec.image_url
214: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_c);

Line 212: :=dbms_lob.substr(irc_idt_shd.g_old_rec.how_to_apply_c);

208: :=dbms_lob.substr(irc_idt_shd.g_old_rec.job_requirements_c);
209: irc_idt_shd.g_old_rec.additional_details
210: :=dbms_lob.substr(irc_idt_shd.g_old_rec.additional_details_c);
211: irc_idt_shd.g_old_rec.how_to_apply
212: :=dbms_lob.substr(irc_idt_shd.g_old_rec.how_to_apply_c);
213: irc_idt_shd.g_old_rec.image_url
214: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_c);
215: irc_idt_shd.g_old_rec.image_url_alt
216: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_alt_c);

Line 214: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_c);

210: :=dbms_lob.substr(irc_idt_shd.g_old_rec.additional_details_c);
211: irc_idt_shd.g_old_rec.how_to_apply
212: :=dbms_lob.substr(irc_idt_shd.g_old_rec.how_to_apply_c);
213: irc_idt_shd.g_old_rec.image_url
214: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_c);
215: irc_idt_shd.g_old_rec.image_url_alt
216: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_alt_c);
217: --
218: --

Line 216: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_alt_c);

212: :=dbms_lob.substr(irc_idt_shd.g_old_rec.how_to_apply_c);
213: irc_idt_shd.g_old_rec.image_url
214: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_c);
215: irc_idt_shd.g_old_rec.image_url_alt
216: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_alt_c);
217: --
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 10);
220: --

Line 280: or dbms_lob.compare(SUBB.ORG_DESCRIPTION, SUBT.ORG_DESCRIPTION) = 0

276: and SUBB.LANGUAGE = SUBT.SOURCE_LANGUAGE
277: and (SUBB.ORG_NAME <> SUBT.ORG_NAME
278: or (SUBB.ORG_NAME is null and SUBT.ORG_NAME is not null)
279: or (SUBB.ORG_NAME is not null and SUBT.ORG_NAME is null)
280: or dbms_lob.compare(SUBB.ORG_DESCRIPTION, SUBT.ORG_DESCRIPTION) = 0
281: or (SUBB.ORG_DESCRIPTION is null and SUBT.ORG_DESCRIPTION is not null)
282: or (SUBB.ORG_DESCRIPTION is not null and SUBT.ORG_DESCRIPTION is null)
283: or SUBB.JOB_TITLE <> SUBT.JOB_TITLE
284: or (SUBB.JOB_TITLE is null and SUBT.JOB_TITLE is not null)

Line 286: or dbms_lob.compare(SUBB.BRIEF_DESCRIPTION, SUBT.BRIEF_DESCRIPTION) = 0

282: or (SUBB.ORG_DESCRIPTION is not null and SUBT.ORG_DESCRIPTION is null)
283: or SUBB.JOB_TITLE <> SUBT.JOB_TITLE
284: or (SUBB.JOB_TITLE is null and SUBT.JOB_TITLE is not null)
285: or (SUBB.JOB_TITLE is not null and SUBT.JOB_TITLE is null)
286: or dbms_lob.compare(SUBB.BRIEF_DESCRIPTION, SUBT.BRIEF_DESCRIPTION) = 0
287: or (SUBB.BRIEF_DESCRIPTION is null and SUBT.BRIEF_DESCRIPTION is not null)
288: or (SUBB.BRIEF_DESCRIPTION is not null and SUBT.BRIEF_DESCRIPTION is null)
289: or dbms_lob.compare(SUBB.DETAILED_DESCRIPTION, SUBT.DETAILED_DESCRIPTION) = 0
290: or (SUBB.DETAILED_DESCRIPTION is null and SUBT.DETAILED_DESCRIPTION is not null)

Line 289: or dbms_lob.compare(SUBB.DETAILED_DESCRIPTION, SUBT.DETAILED_DESCRIPTION) = 0

285: or (SUBB.JOB_TITLE is not null and SUBT.JOB_TITLE is null)
286: or dbms_lob.compare(SUBB.BRIEF_DESCRIPTION, SUBT.BRIEF_DESCRIPTION) = 0
287: or (SUBB.BRIEF_DESCRIPTION is null and SUBT.BRIEF_DESCRIPTION is not null)
288: or (SUBB.BRIEF_DESCRIPTION is not null and SUBT.BRIEF_DESCRIPTION is null)
289: or dbms_lob.compare(SUBB.DETAILED_DESCRIPTION, SUBT.DETAILED_DESCRIPTION) = 0
290: or (SUBB.DETAILED_DESCRIPTION is null and SUBT.DETAILED_DESCRIPTION is not null)
291: or (SUBB.DETAILED_DESCRIPTION is not null and SUBT.DETAILED_DESCRIPTION is null)
292: or dbms_lob.compare(SUBB.JOB_REQUIREMENTS, SUBT.JOB_REQUIREMENTS) = 0
293: or (SUBB.JOB_REQUIREMENTS is null and SUBT.JOB_REQUIREMENTS is not null)

Line 292: or dbms_lob.compare(SUBB.JOB_REQUIREMENTS, SUBT.JOB_REQUIREMENTS) = 0

288: or (SUBB.BRIEF_DESCRIPTION is not null and SUBT.BRIEF_DESCRIPTION is null)
289: or dbms_lob.compare(SUBB.DETAILED_DESCRIPTION, SUBT.DETAILED_DESCRIPTION) = 0
290: or (SUBB.DETAILED_DESCRIPTION is null and SUBT.DETAILED_DESCRIPTION is not null)
291: or (SUBB.DETAILED_DESCRIPTION is not null and SUBT.DETAILED_DESCRIPTION is null)
292: or dbms_lob.compare(SUBB.JOB_REQUIREMENTS, SUBT.JOB_REQUIREMENTS) = 0
293: or (SUBB.JOB_REQUIREMENTS is null and SUBT.JOB_REQUIREMENTS is not null)
294: or (SUBB.JOB_REQUIREMENTS is not null and SUBT.JOB_REQUIREMENTS is null)
295: or dbms_lob.compare(SUBB.ADDITIONAL_DETAILS, SUBT.ADDITIONAL_DETAILS) = 0
296: or (SUBB.ADDITIONAL_DETAILS is null and SUBT.ADDITIONAL_DETAILS is not null)

Line 295: or dbms_lob.compare(SUBB.ADDITIONAL_DETAILS, SUBT.ADDITIONAL_DETAILS) = 0

291: or (SUBB.DETAILED_DESCRIPTION is not null and SUBT.DETAILED_DESCRIPTION is null)
292: or dbms_lob.compare(SUBB.JOB_REQUIREMENTS, SUBT.JOB_REQUIREMENTS) = 0
293: or (SUBB.JOB_REQUIREMENTS is null and SUBT.JOB_REQUIREMENTS is not null)
294: or (SUBB.JOB_REQUIREMENTS is not null and SUBT.JOB_REQUIREMENTS is null)
295: or dbms_lob.compare(SUBB.ADDITIONAL_DETAILS, SUBT.ADDITIONAL_DETAILS) = 0
296: or (SUBB.ADDITIONAL_DETAILS is null and SUBT.ADDITIONAL_DETAILS is not null)
297: or (SUBB.ADDITIONAL_DETAILS is not null and SUBT.ADDITIONAL_DETAILS is null)
298: or dbms_lob.compare(SUBB.HOW_TO_APPLY, SUBT.HOW_TO_APPLY) = 0
299: or (SUBB.HOW_TO_APPLY is null and SUBT.HOW_TO_APPLY is not null)

Line 298: or dbms_lob.compare(SUBB.HOW_TO_APPLY, SUBT.HOW_TO_APPLY) = 0

294: or (SUBB.JOB_REQUIREMENTS is not null and SUBT.JOB_REQUIREMENTS is null)
295: or dbms_lob.compare(SUBB.ADDITIONAL_DETAILS, SUBT.ADDITIONAL_DETAILS) = 0
296: or (SUBB.ADDITIONAL_DETAILS is null and SUBT.ADDITIONAL_DETAILS is not null)
297: or (SUBB.ADDITIONAL_DETAILS is not null and SUBT.ADDITIONAL_DETAILS is null)
298: or dbms_lob.compare(SUBB.HOW_TO_APPLY, SUBT.HOW_TO_APPLY) = 0
299: or (SUBB.HOW_TO_APPLY is null and SUBT.HOW_TO_APPLY is not null)
300: or (SUBB.HOW_TO_APPLY is not null and SUBT.HOW_TO_APPLY is null)
301: ));
302:

Line 450: and dbms_lob.getlength(l_org_description)<=32767

446: hr_utility.set_location(l_proc, 10);
447: --
448: if (g_org_description_upd
449: and l_api_updating
450: and dbms_lob.getlength(l_org_description)<=32767
451: and dbms_lob.instr(l_org_description,p_rec.org_description)<>1)
452: or (not l_api_updating
453: and p_rec.org_description is not null) then
454: dbms_lob.trim(l_org_description,0);

Line 451: and dbms_lob.instr(l_org_description,p_rec.org_description)<>1)

447: --
448: if (g_org_description_upd
449: and l_api_updating
450: and dbms_lob.getlength(l_org_description)<=32767
451: and dbms_lob.instr(l_org_description,p_rec.org_description)<>1)
452: or (not l_api_updating
453: and p_rec.org_description is not null) then
454: dbms_lob.trim(l_org_description,0);
455: dbms_lob.write(l_org_description

Line 454: dbms_lob.trim(l_org_description,0);

450: and dbms_lob.getlength(l_org_description)<=32767
451: and dbms_lob.instr(l_org_description,p_rec.org_description)<>1)
452: or (not l_api_updating
453: and p_rec.org_description is not null) then
454: dbms_lob.trim(l_org_description,0);
455: dbms_lob.write(l_org_description
456: ,length(p_rec.org_description)
457: ,1
458: ,p_rec.org_description);

Line 455: dbms_lob.write(l_org_description

451: and dbms_lob.instr(l_org_description,p_rec.org_description)<>1)
452: or (not l_api_updating
453: and p_rec.org_description is not null) then
454: dbms_lob.trim(l_org_description,0);
455: dbms_lob.write(l_org_description
456: ,length(p_rec.org_description)
457: ,1
458: ,p_rec.org_description);
459: end if;

Line 465: and dbms_lob.getlength(l_brief_description)<=32767

461: hr_utility.set_location(l_proc, 20);
462: --
463: if (g_brief_description_upd
464: and l_api_updating
465: and dbms_lob.getlength(l_brief_description)<=32767
466: and dbms_lob.instr(l_brief_description,p_rec.brief_description)<>1)
467: or (not l_api_updating
468: and p_rec.brief_description is not null) then
469: dbms_lob.trim(l_brief_description,0);

Line 466: and dbms_lob.instr(l_brief_description,p_rec.brief_description)<>1)

462: --
463: if (g_brief_description_upd
464: and l_api_updating
465: and dbms_lob.getlength(l_brief_description)<=32767
466: and dbms_lob.instr(l_brief_description,p_rec.brief_description)<>1)
467: or (not l_api_updating
468: and p_rec.brief_description is not null) then
469: dbms_lob.trim(l_brief_description,0);
470: dbms_lob.write(l_brief_description

Line 469: dbms_lob.trim(l_brief_description,0);

465: and dbms_lob.getlength(l_brief_description)<=32767
466: and dbms_lob.instr(l_brief_description,p_rec.brief_description)<>1)
467: or (not l_api_updating
468: and p_rec.brief_description is not null) then
469: dbms_lob.trim(l_brief_description,0);
470: dbms_lob.write(l_brief_description
471: ,length(p_rec.brief_description)
472: ,1
473: ,p_rec.brief_description);

Line 470: dbms_lob.write(l_brief_description

466: and dbms_lob.instr(l_brief_description,p_rec.brief_description)<>1)
467: or (not l_api_updating
468: and p_rec.brief_description is not null) then
469: dbms_lob.trim(l_brief_description,0);
470: dbms_lob.write(l_brief_description
471: ,length(p_rec.brief_description)
472: ,1
473: ,p_rec.brief_description);
474: end if;

Line 480: and dbms_lob.getlength(l_detailed_description)<=32767

476: hr_utility.set_location(l_proc, 30);
477: --
478: if (g_detailed_description_upd
479: and l_api_updating
480: and dbms_lob.getlength(l_detailed_description)<=32767
481: and dbms_lob.instr(l_detailed_description,p_rec.detailed_description)<>1)
482: or (not l_api_updating
483: and p_rec.detailed_description is not null) then
484: dbms_lob.trim(l_detailed_description,0);

Line 481: and dbms_lob.instr(l_detailed_description,p_rec.detailed_description)<>1)

477: --
478: if (g_detailed_description_upd
479: and l_api_updating
480: and dbms_lob.getlength(l_detailed_description)<=32767
481: and dbms_lob.instr(l_detailed_description,p_rec.detailed_description)<>1)
482: or (not l_api_updating
483: and p_rec.detailed_description is not null) then
484: dbms_lob.trim(l_detailed_description,0);
485: dbms_lob.write(l_detailed_description

Line 484: dbms_lob.trim(l_detailed_description,0);

480: and dbms_lob.getlength(l_detailed_description)<=32767
481: and dbms_lob.instr(l_detailed_description,p_rec.detailed_description)<>1)
482: or (not l_api_updating
483: and p_rec.detailed_description is not null) then
484: dbms_lob.trim(l_detailed_description,0);
485: dbms_lob.write(l_detailed_description
486: ,length(p_rec.detailed_description)
487: ,1
488: ,p_rec.detailed_description);

Line 485: dbms_lob.write(l_detailed_description

481: and dbms_lob.instr(l_detailed_description,p_rec.detailed_description)<>1)
482: or (not l_api_updating
483: and p_rec.detailed_description is not null) then
484: dbms_lob.trim(l_detailed_description,0);
485: dbms_lob.write(l_detailed_description
486: ,length(p_rec.detailed_description)
487: ,1
488: ,p_rec.detailed_description);
489: end if;

Line 495: and dbms_lob.getlength(l_job_requirements)<=32767

491: hr_utility.set_location(l_proc, 40);
492: --
493: if (g_job_requirements_upd
494: and l_api_updating
495: and dbms_lob.getlength(l_job_requirements)<=32767
496: and dbms_lob.instr(l_job_requirements,p_rec.job_requirements)<>1)
497: or (not l_api_updating
498: and p_rec.job_requirements is not null) then
499: dbms_lob.trim(l_job_requirements,0);

Line 496: and dbms_lob.instr(l_job_requirements,p_rec.job_requirements)<>1)

492: --
493: if (g_job_requirements_upd
494: and l_api_updating
495: and dbms_lob.getlength(l_job_requirements)<=32767
496: and dbms_lob.instr(l_job_requirements,p_rec.job_requirements)<>1)
497: or (not l_api_updating
498: and p_rec.job_requirements is not null) then
499: dbms_lob.trim(l_job_requirements,0);
500: dbms_lob.write(l_job_requirements

Line 499: dbms_lob.trim(l_job_requirements,0);

495: and dbms_lob.getlength(l_job_requirements)<=32767
496: and dbms_lob.instr(l_job_requirements,p_rec.job_requirements)<>1)
497: or (not l_api_updating
498: and p_rec.job_requirements is not null) then
499: dbms_lob.trim(l_job_requirements,0);
500: dbms_lob.write(l_job_requirements
501: ,length(p_rec.job_requirements)
502: ,1
503: ,p_rec.job_requirements);

Line 500: dbms_lob.write(l_job_requirements

496: and dbms_lob.instr(l_job_requirements,p_rec.job_requirements)<>1)
497: or (not l_api_updating
498: and p_rec.job_requirements is not null) then
499: dbms_lob.trim(l_job_requirements,0);
500: dbms_lob.write(l_job_requirements
501: ,length(p_rec.job_requirements)
502: ,1
503: ,p_rec.job_requirements);
504: end if;

Line 510: and dbms_lob.getlength(l_additional_details)<=32767

506: hr_utility.set_location(l_proc, 50);
507: --
508: if (g_additional_details_upd
509: and l_api_updating
510: and dbms_lob.getlength(l_additional_details)<=32767
511: and dbms_lob.instr(l_additional_details,p_rec.additional_details)<>1)
512: or (not l_api_updating
513: and p_rec.additional_details is not null) then
514: dbms_lob.trim(l_additional_details,0);

Line 511: and dbms_lob.instr(l_additional_details,p_rec.additional_details)<>1)

507: --
508: if (g_additional_details_upd
509: and l_api_updating
510: and dbms_lob.getlength(l_additional_details)<=32767
511: and dbms_lob.instr(l_additional_details,p_rec.additional_details)<>1)
512: or (not l_api_updating
513: and p_rec.additional_details is not null) then
514: dbms_lob.trim(l_additional_details,0);
515: dbms_lob.write(l_additional_details

Line 514: dbms_lob.trim(l_additional_details,0);

510: and dbms_lob.getlength(l_additional_details)<=32767
511: and dbms_lob.instr(l_additional_details,p_rec.additional_details)<>1)
512: or (not l_api_updating
513: and p_rec.additional_details is not null) then
514: dbms_lob.trim(l_additional_details,0);
515: dbms_lob.write(l_additional_details
516: ,length(p_rec.additional_details)
517: ,1
518: ,p_rec.additional_details);

Line 515: dbms_lob.write(l_additional_details

511: and dbms_lob.instr(l_additional_details,p_rec.additional_details)<>1)
512: or (not l_api_updating
513: and p_rec.additional_details is not null) then
514: dbms_lob.trim(l_additional_details,0);
515: dbms_lob.write(l_additional_details
516: ,length(p_rec.additional_details)
517: ,1
518: ,p_rec.additional_details);
519: end if;

Line 525: and dbms_lob.getlength(l_how_to_apply)<=32767

521: hr_utility.set_location(l_proc, 60);
522: --
523: if (g_how_to_apply_upd
524: and l_api_updating
525: and dbms_lob.getlength(l_how_to_apply)<=32767
526: and dbms_lob.instr(l_how_to_apply,p_rec.how_to_apply)<>1)
527: or (not l_api_updating
528: and p_rec.how_to_apply is not null) then
529: dbms_lob.trim(l_how_to_apply,0);

Line 526: and dbms_lob.instr(l_how_to_apply,p_rec.how_to_apply)<>1)

522: --
523: if (g_how_to_apply_upd
524: and l_api_updating
525: and dbms_lob.getlength(l_how_to_apply)<=32767
526: and dbms_lob.instr(l_how_to_apply,p_rec.how_to_apply)<>1)
527: or (not l_api_updating
528: and p_rec.how_to_apply is not null) then
529: dbms_lob.trim(l_how_to_apply,0);
530: dbms_lob.write(l_how_to_apply

Line 529: dbms_lob.trim(l_how_to_apply,0);

525: and dbms_lob.getlength(l_how_to_apply)<=32767
526: and dbms_lob.instr(l_how_to_apply,p_rec.how_to_apply)<>1)
527: or (not l_api_updating
528: and p_rec.how_to_apply is not null) then
529: dbms_lob.trim(l_how_to_apply,0);
530: dbms_lob.write(l_how_to_apply
531: ,length(p_rec.how_to_apply)
532: ,1
533: ,p_rec.how_to_apply);

Line 530: dbms_lob.write(l_how_to_apply

526: and dbms_lob.instr(l_how_to_apply,p_rec.how_to_apply)<>1)
527: or (not l_api_updating
528: and p_rec.how_to_apply is not null) then
529: dbms_lob.trim(l_how_to_apply,0);
530: dbms_lob.write(l_how_to_apply
531: ,length(p_rec.how_to_apply)
532: ,1
533: ,p_rec.how_to_apply);
534: end if;

Line 540: and dbms_lob.getlength(l_image_url)<=32767

536: hr_utility.set_location(l_proc, 70);
537: --
538: if (g_image_url_upd
539: and l_api_updating
540: and dbms_lob.getlength(l_image_url)<=32767
541: and dbms_lob.instr(l_image_url,p_rec.image_url)<>1)
542: or (not l_api_updating
543: and p_rec.image_url is not null) then
544: dbms_lob.trim(l_image_url,0);

Line 541: and dbms_lob.instr(l_image_url,p_rec.image_url)<>1)

537: --
538: if (g_image_url_upd
539: and l_api_updating
540: and dbms_lob.getlength(l_image_url)<=32767
541: and dbms_lob.instr(l_image_url,p_rec.image_url)<>1)
542: or (not l_api_updating
543: and p_rec.image_url is not null) then
544: dbms_lob.trim(l_image_url,0);
545: dbms_lob.write(l_image_url

Line 544: dbms_lob.trim(l_image_url,0);

540: and dbms_lob.getlength(l_image_url)<=32767
541: and dbms_lob.instr(l_image_url,p_rec.image_url)<>1)
542: or (not l_api_updating
543: and p_rec.image_url is not null) then
544: dbms_lob.trim(l_image_url,0);
545: dbms_lob.write(l_image_url
546: ,length(p_rec.image_url)
547: ,1
548: ,p_rec.image_url);

Line 545: dbms_lob.write(l_image_url

541: and dbms_lob.instr(l_image_url,p_rec.image_url)<>1)
542: or (not l_api_updating
543: and p_rec.image_url is not null) then
544: dbms_lob.trim(l_image_url,0);
545: dbms_lob.write(l_image_url
546: ,length(p_rec.image_url)
547: ,1
548: ,p_rec.image_url);
549: end if;

Line 555: and dbms_lob.getlength(l_image_url_alt)<=32767

551: hr_utility.set_location(l_proc, 80);
552: --
553: if (g_image_url_alt_upd
554: and l_api_updating
555: and dbms_lob.getlength(l_image_url_alt)<=32767
556: and dbms_lob.instr(l_image_url_alt,p_rec.image_url_alt)<>1)
557: or (not l_api_updating
558: and p_rec.image_url_alt is not null) then
559: dbms_lob.trim(l_image_url_alt,0);

Line 556: and dbms_lob.instr(l_image_url_alt,p_rec.image_url_alt)<>1)

552: --
553: if (g_image_url_alt_upd
554: and l_api_updating
555: and dbms_lob.getlength(l_image_url_alt)<=32767
556: and dbms_lob.instr(l_image_url_alt,p_rec.image_url_alt)<>1)
557: or (not l_api_updating
558: and p_rec.image_url_alt is not null) then
559: dbms_lob.trim(l_image_url_alt,0);
560: dbms_lob.write(l_image_url_alt

Line 559: dbms_lob.trim(l_image_url_alt,0);

555: and dbms_lob.getlength(l_image_url_alt)<=32767
556: and dbms_lob.instr(l_image_url_alt,p_rec.image_url_alt)<>1)
557: or (not l_api_updating
558: and p_rec.image_url_alt is not null) then
559: dbms_lob.trim(l_image_url_alt,0);
560: dbms_lob.write(l_image_url_alt
561: ,length(p_rec.image_url_alt)
562: ,1
563: ,p_rec.image_url_alt);

Line 560: dbms_lob.write(l_image_url_alt

556: and dbms_lob.instr(l_image_url_alt,p_rec.image_url_alt)<>1)
557: or (not l_api_updating
558: and p_rec.image_url_alt is not null) then
559: dbms_lob.trim(l_image_url_alt,0);
560: dbms_lob.write(l_image_url_alt
561: ,length(p_rec.image_url_alt)
562: ,1
563: ,p_rec.image_url_alt);
564: end if;