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

Line 114: := dbms_lob.substr(g_clob_old_rec.org_description);

110: g_old_rec.org_name := g_clob_old_rec.org_name;
111: g_old_rec.job_title := g_clob_old_rec.job_title;
112: --
113: g_old_rec.org_description
114: := dbms_lob.substr(g_clob_old_rec.org_description);
115: g_old_rec.brief_description
116: := dbms_lob.substr(g_clob_old_rec.brief_description);
117: g_old_rec.detailed_description
118: := dbms_lob.substr(g_clob_old_rec.detailed_description);

Line 116: := dbms_lob.substr(g_clob_old_rec.brief_description);

112: --
113: g_old_rec.org_description
114: := dbms_lob.substr(g_clob_old_rec.org_description);
115: g_old_rec.brief_description
116: := dbms_lob.substr(g_clob_old_rec.brief_description);
117: g_old_rec.detailed_description
118: := dbms_lob.substr(g_clob_old_rec.detailed_description);
119: g_old_rec.job_requirements
120: := dbms_lob.substr(g_clob_old_rec.job_requirements);

Line 118: := dbms_lob.substr(g_clob_old_rec.detailed_description);

114: := dbms_lob.substr(g_clob_old_rec.org_description);
115: g_old_rec.brief_description
116: := dbms_lob.substr(g_clob_old_rec.brief_description);
117: g_old_rec.detailed_description
118: := dbms_lob.substr(g_clob_old_rec.detailed_description);
119: g_old_rec.job_requirements
120: := dbms_lob.substr(g_clob_old_rec.job_requirements);
121: g_old_rec.additional_details
122: := dbms_lob.substr(g_clob_old_rec.additional_details);

Line 120: := dbms_lob.substr(g_clob_old_rec.job_requirements);

116: := dbms_lob.substr(g_clob_old_rec.brief_description);
117: g_old_rec.detailed_description
118: := dbms_lob.substr(g_clob_old_rec.detailed_description);
119: g_old_rec.job_requirements
120: := dbms_lob.substr(g_clob_old_rec.job_requirements);
121: g_old_rec.additional_details
122: := dbms_lob.substr(g_clob_old_rec.additional_details);
123: g_old_rec.how_to_apply
124: := dbms_lob.substr(g_clob_old_rec.how_to_apply);

Line 122: := dbms_lob.substr(g_clob_old_rec.additional_details);

118: := dbms_lob.substr(g_clob_old_rec.detailed_description);
119: g_old_rec.job_requirements
120: := dbms_lob.substr(g_clob_old_rec.job_requirements);
121: g_old_rec.additional_details
122: := dbms_lob.substr(g_clob_old_rec.additional_details);
123: g_old_rec.how_to_apply
124: := dbms_lob.substr(g_clob_old_rec.how_to_apply);
125: g_old_rec.benefit_info
126: := dbms_lob.substr(g_clob_old_rec.benefit_info);

Line 124: := dbms_lob.substr(g_clob_old_rec.how_to_apply);

120: := dbms_lob.substr(g_clob_old_rec.job_requirements);
121: g_old_rec.additional_details
122: := dbms_lob.substr(g_clob_old_rec.additional_details);
123: g_old_rec.how_to_apply
124: := dbms_lob.substr(g_clob_old_rec.how_to_apply);
125: g_old_rec.benefit_info
126: := dbms_lob.substr(g_clob_old_rec.benefit_info);
127: g_old_rec.image_url
128: := dbms_lob.substr(g_clob_old_rec.image_url);

Line 126: := dbms_lob.substr(g_clob_old_rec.benefit_info);

122: := dbms_lob.substr(g_clob_old_rec.additional_details);
123: g_old_rec.how_to_apply
124: := dbms_lob.substr(g_clob_old_rec.how_to_apply);
125: g_old_rec.benefit_info
126: := dbms_lob.substr(g_clob_old_rec.benefit_info);
127: g_old_rec.image_url
128: := dbms_lob.substr(g_clob_old_rec.image_url);
129: g_old_rec.image_url_alt
130: := dbms_lob.substr(g_clob_old_rec.image_url_alt);

Line 128: := dbms_lob.substr(g_clob_old_rec.image_url);

124: := dbms_lob.substr(g_clob_old_rec.how_to_apply);
125: g_old_rec.benefit_info
126: := dbms_lob.substr(g_clob_old_rec.benefit_info);
127: g_old_rec.image_url
128: := dbms_lob.substr(g_clob_old_rec.image_url);
129: g_old_rec.image_url_alt
130: := dbms_lob.substr(g_clob_old_rec.image_url_alt);
131: --
132: l_fct_ret := true;

Line 130: := dbms_lob.substr(g_clob_old_rec.image_url_alt);

126: := dbms_lob.substr(g_clob_old_rec.benefit_info);
127: g_old_rec.image_url
128: := dbms_lob.substr(g_clob_old_rec.image_url);
129: g_old_rec.image_url_alt
130: := dbms_lob.substr(g_clob_old_rec.image_url_alt);
131: --
132: l_fct_ret := true;
133: End If;
134: End If;

Line 209: := dbms_lob.substr(g_clob_old_rec.org_description);

205: g_old_rec.org_name := g_clob_old_rec.org_name;
206: g_old_rec.job_title := g_clob_old_rec.job_title;
207: --
208: g_old_rec.org_description
209: := dbms_lob.substr(g_clob_old_rec.org_description);
210: g_old_rec.brief_description
211: := dbms_lob.substr(g_clob_old_rec.brief_description);
212: g_old_rec.detailed_description
213: := dbms_lob.substr(g_clob_old_rec.detailed_description);

Line 211: := dbms_lob.substr(g_clob_old_rec.brief_description);

207: --
208: g_old_rec.org_description
209: := dbms_lob.substr(g_clob_old_rec.org_description);
210: g_old_rec.brief_description
211: := dbms_lob.substr(g_clob_old_rec.brief_description);
212: g_old_rec.detailed_description
213: := dbms_lob.substr(g_clob_old_rec.detailed_description);
214: g_old_rec.job_requirements
215: := dbms_lob.substr(g_clob_old_rec.job_requirements);

Line 213: := dbms_lob.substr(g_clob_old_rec.detailed_description);

209: := dbms_lob.substr(g_clob_old_rec.org_description);
210: g_old_rec.brief_description
211: := dbms_lob.substr(g_clob_old_rec.brief_description);
212: g_old_rec.detailed_description
213: := dbms_lob.substr(g_clob_old_rec.detailed_description);
214: g_old_rec.job_requirements
215: := dbms_lob.substr(g_clob_old_rec.job_requirements);
216: g_old_rec.additional_details
217: := dbms_lob.substr(g_clob_old_rec.additional_details);

Line 215: := dbms_lob.substr(g_clob_old_rec.job_requirements);

211: := dbms_lob.substr(g_clob_old_rec.brief_description);
212: g_old_rec.detailed_description
213: := dbms_lob.substr(g_clob_old_rec.detailed_description);
214: g_old_rec.job_requirements
215: := dbms_lob.substr(g_clob_old_rec.job_requirements);
216: g_old_rec.additional_details
217: := dbms_lob.substr(g_clob_old_rec.additional_details);
218: g_old_rec.how_to_apply
219: := dbms_lob.substr(g_clob_old_rec.how_to_apply);

Line 217: := dbms_lob.substr(g_clob_old_rec.additional_details);

213: := dbms_lob.substr(g_clob_old_rec.detailed_description);
214: g_old_rec.job_requirements
215: := dbms_lob.substr(g_clob_old_rec.job_requirements);
216: g_old_rec.additional_details
217: := dbms_lob.substr(g_clob_old_rec.additional_details);
218: g_old_rec.how_to_apply
219: := dbms_lob.substr(g_clob_old_rec.how_to_apply);
220: g_old_rec.benefit_info
221: := dbms_lob.substr(g_clob_old_rec.benefit_info);

Line 219: := dbms_lob.substr(g_clob_old_rec.how_to_apply);

215: := dbms_lob.substr(g_clob_old_rec.job_requirements);
216: g_old_rec.additional_details
217: := dbms_lob.substr(g_clob_old_rec.additional_details);
218: g_old_rec.how_to_apply
219: := dbms_lob.substr(g_clob_old_rec.how_to_apply);
220: g_old_rec.benefit_info
221: := dbms_lob.substr(g_clob_old_rec.benefit_info);
222: g_old_rec.image_url
223: := dbms_lob.substr(g_clob_old_rec.image_url);

Line 221: := dbms_lob.substr(g_clob_old_rec.benefit_info);

217: := dbms_lob.substr(g_clob_old_rec.additional_details);
218: g_old_rec.how_to_apply
219: := dbms_lob.substr(g_clob_old_rec.how_to_apply);
220: g_old_rec.benefit_info
221: := dbms_lob.substr(g_clob_old_rec.benefit_info);
222: g_old_rec.image_url
223: := dbms_lob.substr(g_clob_old_rec.image_url);
224: g_old_rec.image_url_alt
225: := dbms_lob.substr(g_clob_old_rec.image_url_alt);

Line 223: := dbms_lob.substr(g_clob_old_rec.image_url);

219: := dbms_lob.substr(g_clob_old_rec.how_to_apply);
220: g_old_rec.benefit_info
221: := dbms_lob.substr(g_clob_old_rec.benefit_info);
222: g_old_rec.image_url
223: := dbms_lob.substr(g_clob_old_rec.image_url);
224: g_old_rec.image_url_alt
225: := dbms_lob.substr(g_clob_old_rec.image_url_alt);
226: --
227: --

Line 225: := dbms_lob.substr(g_clob_old_rec.image_url_alt);

221: := dbms_lob.substr(g_clob_old_rec.benefit_info);
222: g_old_rec.image_url
223: := dbms_lob.substr(g_clob_old_rec.image_url);
224: g_old_rec.image_url_alt
225: := dbms_lob.substr(g_clob_old_rec.image_url_alt);
226: --
227: --
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: --

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

293: and (SUBB.NAME <> SUBT.NAME
294: or SUBB.ORG_NAME <> SUBT.ORG_NAME
295: or (SUBB.ORG_NAME is null and SUBT.ORG_NAME is not null)
296: or (SUBB.ORG_NAME is not null and SUBT.ORG_NAME is null)
297: or dbms_lob.compare(SUBB.ORG_DESCRIPTION ,SUBT.ORG_DESCRIPTION) = 0
298: or (SUBB.ORG_DESCRIPTION is null and SUBT.ORG_DESCRIPTION is not null)
299: or (SUBB.ORG_DESCRIPTION is not null and SUBT.ORG_DESCRIPTION is null)
300: or SUBB.JOB_TITLE <> SUBT.JOB_TITLE
301: or (SUBB.JOB_TITLE is null and SUBT.JOB_TITLE is not null)

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

299: or (SUBB.ORG_DESCRIPTION is not null and SUBT.ORG_DESCRIPTION is null)
300: or SUBB.JOB_TITLE <> SUBT.JOB_TITLE
301: or (SUBB.JOB_TITLE is null and SUBT.JOB_TITLE is not null)
302: or (SUBB.JOB_TITLE is not null and SUBT.JOB_TITLE is null)
303: or dbms_lob.compare(SUBB.BRIEF_DESCRIPTION , SUBT.BRIEF_DESCRIPTION) = 0
304: or (SUBB.BRIEF_DESCRIPTION is null and SUBT.BRIEF_DESCRIPTION is not
305: null)
306: or (SUBB.BRIEF_DESCRIPTION is not null and SUBT.BRIEF_DESCRIPTION
307: is null)

Line 308: or dbms_lob.compare(SUBB.DETAILED_DESCRIPTION

304: or (SUBB.BRIEF_DESCRIPTION is null and SUBT.BRIEF_DESCRIPTION is not
305: null)
306: or (SUBB.BRIEF_DESCRIPTION is not null and SUBT.BRIEF_DESCRIPTION
307: is null)
308: or dbms_lob.compare(SUBB.DETAILED_DESCRIPTION
309: , SUBT.DETAILED_DESCRIPTION) = 0
310: or (SUBB.DETAILED_DESCRIPTION is null and SUBT.DETAILED_DESCRIPTION
311: is not null)
312: or (SUBB.DETAILED_DESCRIPTION is not null and SUBT.DETAILED_DESCRIPTION

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

310: or (SUBB.DETAILED_DESCRIPTION is null and SUBT.DETAILED_DESCRIPTION
311: is not null)
312: or (SUBB.DETAILED_DESCRIPTION is not null and SUBT.DETAILED_DESCRIPTION
313: is null)
314: or dbms_lob.compare(SUBB.JOB_REQUIREMENTS , SUBT.JOB_REQUIREMENTS) = 0
315: or (SUBB.JOB_REQUIREMENTS is null and SUBT.JOB_REQUIREMENTS
316: is not null)
317: or (SUBB.JOB_REQUIREMENTS is not null and SUBT.JOB_REQUIREMENTS
318: is null)

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

315: or (SUBB.JOB_REQUIREMENTS is null and SUBT.JOB_REQUIREMENTS
316: is not null)
317: or (SUBB.JOB_REQUIREMENTS is not null and SUBT.JOB_REQUIREMENTS
318: is null)
319: or dbms_lob.compare(SUBB.ADDITIONAL_DETAILS,SUBT.ADDITIONAL_DETAILS) = 0
320: or (SUBB.ADDITIONAL_DETAILS is null and SUBT.ADDITIONAL_DETAILS
321: is not null)
322: or (SUBB.ADDITIONAL_DETAILS is not null and SUBT.ADDITIONAL_DETAILS
323: is null)

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

320: or (SUBB.ADDITIONAL_DETAILS is null and SUBT.ADDITIONAL_DETAILS
321: is not null)
322: or (SUBB.ADDITIONAL_DETAILS is not null and SUBT.ADDITIONAL_DETAILS
323: is null)
324: or dbms_lob.compare(SUBB.HOW_TO_APPLY,SUBT.HOW_TO_APPLY) = 0
325: or (SUBB.HOW_TO_APPLY is null and SUBT.HOW_TO_APPLY
326: is not null)
327: or (SUBB.HOW_TO_APPLY is not null and SUBT.HOW_TO_APPLY is null)
328: or dbms_lob.compare(SUBB.BENEFIT_INFO,SUBT.BENEFIT_INFO) = 0

Line 328: or dbms_lob.compare(SUBB.BENEFIT_INFO,SUBT.BENEFIT_INFO) = 0

324: or dbms_lob.compare(SUBB.HOW_TO_APPLY,SUBT.HOW_TO_APPLY) = 0
325: or (SUBB.HOW_TO_APPLY is null and SUBT.HOW_TO_APPLY
326: is not null)
327: or (SUBB.HOW_TO_APPLY is not null and SUBT.HOW_TO_APPLY is null)
328: or dbms_lob.compare(SUBB.BENEFIT_INFO,SUBT.BENEFIT_INFO) = 0
329: or (SUBB.BENEFIT_INFO is null and SUBT.BENEFIT_INFO is not null)
330: or (SUBB.BENEFIT_INFO is not null and SUBT.BENEFIT_INFO is null)
331: or dbms_lob.compare(SUBB.IMAGE_URL,SUBT.IMAGE_URL) = 0
332: or (SUBB.IMAGE_URL is null and SUBT.IMAGE_URL is not null)

Line 331: or dbms_lob.compare(SUBB.IMAGE_URL,SUBT.IMAGE_URL) = 0

327: or (SUBB.HOW_TO_APPLY is not null and SUBT.HOW_TO_APPLY is null)
328: or dbms_lob.compare(SUBB.BENEFIT_INFO,SUBT.BENEFIT_INFO) = 0
329: or (SUBB.BENEFIT_INFO is null and SUBT.BENEFIT_INFO is not null)
330: or (SUBB.BENEFIT_INFO is not null and SUBT.BENEFIT_INFO is null)
331: or dbms_lob.compare(SUBB.IMAGE_URL,SUBT.IMAGE_URL) = 0
332: or (SUBB.IMAGE_URL is null and SUBT.IMAGE_URL is not null)
333: or (SUBB.IMAGE_URL is not null and SUBT.IMAGE_URL is null)
334: or dbms_lob.compare(SUBB.IMAGE_URL_ALT , SUBT.IMAGE_URL_ALT) = 0
335: or (SUBB.IMAGE_URL_ALT is null and SUBT.IMAGE_URL_ALT is not null)

Line 334: or dbms_lob.compare(SUBB.IMAGE_URL_ALT , SUBT.IMAGE_URL_ALT) = 0

330: or (SUBB.BENEFIT_INFO is not null and SUBT.BENEFIT_INFO is null)
331: or dbms_lob.compare(SUBB.IMAGE_URL,SUBT.IMAGE_URL) = 0
332: or (SUBB.IMAGE_URL is null and SUBT.IMAGE_URL is not null)
333: or (SUBB.IMAGE_URL is not null and SUBT.IMAGE_URL is null)
334: or dbms_lob.compare(SUBB.IMAGE_URL_ALT , SUBT.IMAGE_URL_ALT) = 0
335: or (SUBB.IMAGE_URL_ALT is null and SUBT.IMAGE_URL_ALT is not null)
336: or (SUBB.IMAGE_URL_ALT is not null and SUBT.IMAGE_URL_ALT is null)
337: ));
338: insert into IRC_POSTING_CONTENTS_TL (

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

488: hr_utility.set_location(l_proc, 10);
489: --
490: if (g_org_description_upd
491: and l_api_updating
492: and dbms_lob.getlength(l_org_description)<=32767
493: and dbms_lob.instr(l_org_description,p_rec.org_description)<>1)
494: or (not l_api_updating
495: and p_rec.org_description is not null) then
496: dbms_lob.trim(l_org_description,0);

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

489: --
490: if (g_org_description_upd
491: and l_api_updating
492: and dbms_lob.getlength(l_org_description)<=32767
493: and dbms_lob.instr(l_org_description,p_rec.org_description)<>1)
494: or (not l_api_updating
495: and p_rec.org_description is not null) then
496: dbms_lob.trim(l_org_description,0);
497: dbms_lob.write(l_org_description

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

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

Line 497: dbms_lob.write(l_org_description

493: and dbms_lob.instr(l_org_description,p_rec.org_description)<>1)
494: or (not l_api_updating
495: and p_rec.org_description is not null) then
496: dbms_lob.trim(l_org_description,0);
497: dbms_lob.write(l_org_description
498: ,length(p_rec.org_description)
499: ,1
500: ,p_rec.org_description);
501: end if;

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

503: hr_utility.set_location(l_proc, 20);
504: --
505: if (g_brief_description_upd
506: and l_api_updating
507: and dbms_lob.getlength(l_brief_description)<=32767
508: and dbms_lob.instr(l_brief_description,p_rec.brief_description)<>1)
509: or (not l_api_updating
510: and p_rec.brief_description is not null) then
511: dbms_lob.trim(l_brief_description,0);

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

504: --
505: if (g_brief_description_upd
506: and l_api_updating
507: and dbms_lob.getlength(l_brief_description)<=32767
508: and dbms_lob.instr(l_brief_description,p_rec.brief_description)<>1)
509: or (not l_api_updating
510: and p_rec.brief_description is not null) then
511: dbms_lob.trim(l_brief_description,0);
512: dbms_lob.write(l_brief_description

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

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

Line 512: dbms_lob.write(l_brief_description

508: and dbms_lob.instr(l_brief_description,p_rec.brief_description)<>1)
509: or (not l_api_updating
510: and p_rec.brief_description is not null) then
511: dbms_lob.trim(l_brief_description,0);
512: dbms_lob.write(l_brief_description
513: ,length(p_rec.brief_description)
514: ,1
515: ,p_rec.brief_description);
516: end if;

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

518: hr_utility.set_location(l_proc, 30);
519: --
520: if (g_detailed_description_upd
521: and l_api_updating
522: and dbms_lob.getlength(l_detailed_description)<=32767
523: and dbms_lob.instr(l_detailed_description,p_rec.detailed_description)<>1)
524: or (not l_api_updating
525: and p_rec.detailed_description is not null) then
526: dbms_lob.trim(l_detailed_description,0);

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

519: --
520: if (g_detailed_description_upd
521: and l_api_updating
522: and dbms_lob.getlength(l_detailed_description)<=32767
523: and dbms_lob.instr(l_detailed_description,p_rec.detailed_description)<>1)
524: or (not l_api_updating
525: and p_rec.detailed_description is not null) then
526: dbms_lob.trim(l_detailed_description,0);
527: dbms_lob.write(l_detailed_description

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

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

Line 527: dbms_lob.write(l_detailed_description

523: and dbms_lob.instr(l_detailed_description,p_rec.detailed_description)<>1)
524: or (not l_api_updating
525: and p_rec.detailed_description is not null) then
526: dbms_lob.trim(l_detailed_description,0);
527: dbms_lob.write(l_detailed_description
528: ,length(p_rec.detailed_description)
529: ,1
530: ,p_rec.detailed_description);
531: end if;

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

533: hr_utility.set_location(l_proc, 40);
534: --
535: if (g_job_requirements_upd
536: and l_api_updating
537: and dbms_lob.getlength(l_job_requirements)<=32767
538: and dbms_lob.instr(l_job_requirements,p_rec.job_requirements)<>1)
539: or (not l_api_updating
540: and p_rec.job_requirements is not null) then
541: dbms_lob.trim(l_job_requirements,0);

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

534: --
535: if (g_job_requirements_upd
536: and l_api_updating
537: and dbms_lob.getlength(l_job_requirements)<=32767
538: and dbms_lob.instr(l_job_requirements,p_rec.job_requirements)<>1)
539: or (not l_api_updating
540: and p_rec.job_requirements is not null) then
541: dbms_lob.trim(l_job_requirements,0);
542: dbms_lob.write(l_job_requirements

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

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

Line 542: dbms_lob.write(l_job_requirements

538: and dbms_lob.instr(l_job_requirements,p_rec.job_requirements)<>1)
539: or (not l_api_updating
540: and p_rec.job_requirements is not null) then
541: dbms_lob.trim(l_job_requirements,0);
542: dbms_lob.write(l_job_requirements
543: ,length(p_rec.job_requirements)
544: ,1
545: ,p_rec.job_requirements);
546: end if;

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

548: hr_utility.set_location(l_proc, 50);
549: --
550: if (g_additional_details_upd
551: and l_api_updating
552: and dbms_lob.getlength(l_additional_details)<=32767
553: and dbms_lob.instr(l_additional_details,p_rec.additional_details)<>1)
554: or (not l_api_updating
555: and p_rec.additional_details is not null) then
556: dbms_lob.trim(l_additional_details,0);

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

549: --
550: if (g_additional_details_upd
551: and l_api_updating
552: and dbms_lob.getlength(l_additional_details)<=32767
553: and dbms_lob.instr(l_additional_details,p_rec.additional_details)<>1)
554: or (not l_api_updating
555: and p_rec.additional_details is not null) then
556: dbms_lob.trim(l_additional_details,0);
557: dbms_lob.write(l_additional_details

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

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

Line 557: dbms_lob.write(l_additional_details

553: and dbms_lob.instr(l_additional_details,p_rec.additional_details)<>1)
554: or (not l_api_updating
555: and p_rec.additional_details is not null) then
556: dbms_lob.trim(l_additional_details,0);
557: dbms_lob.write(l_additional_details
558: ,length(p_rec.additional_details)
559: ,1
560: ,p_rec.additional_details);
561: end if;

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

563: hr_utility.set_location(l_proc, 60);
564: --
565: if (g_how_to_apply_upd
566: and l_api_updating
567: and dbms_lob.getlength(l_how_to_apply)<=32767
568: and dbms_lob.instr(l_how_to_apply,p_rec.how_to_apply)<>1)
569: or (not l_api_updating
570: and p_rec.how_to_apply is not null) then
571: dbms_lob.trim(l_how_to_apply,0);

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

564: --
565: if (g_how_to_apply_upd
566: and l_api_updating
567: and dbms_lob.getlength(l_how_to_apply)<=32767
568: and dbms_lob.instr(l_how_to_apply,p_rec.how_to_apply)<>1)
569: or (not l_api_updating
570: and p_rec.how_to_apply is not null) then
571: dbms_lob.trim(l_how_to_apply,0);
572: dbms_lob.write(l_how_to_apply

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

567: and dbms_lob.getlength(l_how_to_apply)<=32767
568: and dbms_lob.instr(l_how_to_apply,p_rec.how_to_apply)<>1)
569: or (not l_api_updating
570: and p_rec.how_to_apply is not null) then
571: dbms_lob.trim(l_how_to_apply,0);
572: dbms_lob.write(l_how_to_apply
573: ,length(p_rec.how_to_apply)
574: ,1
575: ,p_rec.how_to_apply);

Line 572: dbms_lob.write(l_how_to_apply

568: and dbms_lob.instr(l_how_to_apply,p_rec.how_to_apply)<>1)
569: or (not l_api_updating
570: and p_rec.how_to_apply is not null) then
571: dbms_lob.trim(l_how_to_apply,0);
572: dbms_lob.write(l_how_to_apply
573: ,length(p_rec.how_to_apply)
574: ,1
575: ,p_rec.how_to_apply);
576: end if;

Line 582: and dbms_lob.getlength(l_benefit_info)<=32767

578: hr_utility.set_location(l_proc, 70);
579: --
580: if (g_benefit_info_upd
581: and l_api_updating
582: and dbms_lob.getlength(l_benefit_info)<=32767
583: and dbms_lob.instr(l_benefit_info,p_rec.benefit_info)<>1)
584: or (not l_api_updating
585: and p_rec.benefit_info is not null) then
586: dbms_lob.trim(l_benefit_info,0);

Line 583: and dbms_lob.instr(l_benefit_info,p_rec.benefit_info)<>1)

579: --
580: if (g_benefit_info_upd
581: and l_api_updating
582: and dbms_lob.getlength(l_benefit_info)<=32767
583: and dbms_lob.instr(l_benefit_info,p_rec.benefit_info)<>1)
584: or (not l_api_updating
585: and p_rec.benefit_info is not null) then
586: dbms_lob.trim(l_benefit_info,0);
587: dbms_lob.write(l_benefit_info

Line 586: dbms_lob.trim(l_benefit_info,0);

582: and dbms_lob.getlength(l_benefit_info)<=32767
583: and dbms_lob.instr(l_benefit_info,p_rec.benefit_info)<>1)
584: or (not l_api_updating
585: and p_rec.benefit_info is not null) then
586: dbms_lob.trim(l_benefit_info,0);
587: dbms_lob.write(l_benefit_info
588: ,length(p_rec.benefit_info)
589: ,1
590: ,p_rec.benefit_info);

Line 587: dbms_lob.write(l_benefit_info

583: and dbms_lob.instr(l_benefit_info,p_rec.benefit_info)<>1)
584: or (not l_api_updating
585: and p_rec.benefit_info is not null) then
586: dbms_lob.trim(l_benefit_info,0);
587: dbms_lob.write(l_benefit_info
588: ,length(p_rec.benefit_info)
589: ,1
590: ,p_rec.benefit_info);
591: end if;

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

593: hr_utility.set_location(l_proc, 80);
594: --
595: if (g_image_url_upd
596: and l_api_updating
597: and dbms_lob.getlength(l_image_url)<=32767
598: and dbms_lob.instr(l_image_url,p_rec.image_url)<>1)
599: or (not l_api_updating
600: and p_rec.image_url is not null) then
601: dbms_lob.trim(l_image_url,0);

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

594: --
595: if (g_image_url_upd
596: and l_api_updating
597: and dbms_lob.getlength(l_image_url)<=32767
598: and dbms_lob.instr(l_image_url,p_rec.image_url)<>1)
599: or (not l_api_updating
600: and p_rec.image_url is not null) then
601: dbms_lob.trim(l_image_url,0);
602: dbms_lob.write(l_image_url

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

597: and dbms_lob.getlength(l_image_url)<=32767
598: and dbms_lob.instr(l_image_url,p_rec.image_url)<>1)
599: or (not l_api_updating
600: and p_rec.image_url is not null) then
601: dbms_lob.trim(l_image_url,0);
602: dbms_lob.write(l_image_url
603: ,length(p_rec.image_url)
604: ,1
605: ,p_rec.image_url);

Line 602: dbms_lob.write(l_image_url

598: and dbms_lob.instr(l_image_url,p_rec.image_url)<>1)
599: or (not l_api_updating
600: and p_rec.image_url is not null) then
601: dbms_lob.trim(l_image_url,0);
602: dbms_lob.write(l_image_url
603: ,length(p_rec.image_url)
604: ,1
605: ,p_rec.image_url);
606: end if;

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

608: hr_utility.set_location(l_proc, 90);
609: --
610: if (g_image_url_alt_upd
611: and l_api_updating
612: and dbms_lob.getlength(l_image_url_alt)<=32767
613: and dbms_lob.instr(l_image_url_alt,p_rec.image_url_alt)<>1)
614: or (not l_api_updating
615: and p_rec.image_url_alt is not null) then
616: dbms_lob.trim(l_image_url_alt,0);

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

609: --
610: if (g_image_url_alt_upd
611: and l_api_updating
612: and dbms_lob.getlength(l_image_url_alt)<=32767
613: and dbms_lob.instr(l_image_url_alt,p_rec.image_url_alt)<>1)
614: or (not l_api_updating
615: and p_rec.image_url_alt is not null) then
616: dbms_lob.trim(l_image_url_alt,0);
617: dbms_lob.write(l_image_url_alt

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

612: and dbms_lob.getlength(l_image_url_alt)<=32767
613: and dbms_lob.instr(l_image_url_alt,p_rec.image_url_alt)<>1)
614: or (not l_api_updating
615: and p_rec.image_url_alt is not null) then
616: dbms_lob.trim(l_image_url_alt,0);
617: dbms_lob.write(l_image_url_alt
618: ,length(p_rec.image_url_alt)
619: ,1
620: ,p_rec.image_url_alt);

Line 617: dbms_lob.write(l_image_url_alt

613: and dbms_lob.instr(l_image_url_alt,p_rec.image_url_alt)<>1)
614: or (not l_api_updating
615: and p_rec.image_url_alt is not null) then
616: dbms_lob.trim(l_image_url_alt,0);
617: dbms_lob.write(l_image_url_alt
618: ,length(p_rec.image_url_alt)
619: ,1
620: ,p_rec.image_url_alt);
621: end if;