174: where search_criteria_id = p_rec.search_criteria_id
175: returning description into l_description;
176: --
177: if (g_description
178: and dbms_lob.getlength(l_description)<=32767
179: and dbms_lob.instr(l_description,p_rec.description)<>1)
180: then
181: hr_utility.set_location(l_proc, 10);
182: dbms_lob.trim(l_description,0);
175: returning description into l_description;
176: --
177: if (g_description
178: and dbms_lob.getlength(l_description)<=32767
179: and dbms_lob.instr(l_description,p_rec.description)<>1)
180: then
181: hr_utility.set_location(l_proc, 10);
182: dbms_lob.trim(l_description,0);
183: dbms_lob.write(l_description
178: and dbms_lob.getlength(l_description)<=32767
179: and dbms_lob.instr(l_description,p_rec.description)<>1)
180: then
181: hr_utility.set_location(l_proc, 10);
182: dbms_lob.trim(l_description,0);
183: dbms_lob.write(l_description
184: ,length(p_rec.description)
185: ,1
186: ,p_rec.description);
179: and dbms_lob.instr(l_description,p_rec.description)<>1)
180: then
181: hr_utility.set_location(l_proc, 10);
182: dbms_lob.trim(l_description,0);
183: dbms_lob.write(l_description
184: ,length(p_rec.description)
185: ,1
186: ,p_rec.description);
187: end if;