APPS.PER_RAA_UPD dependencies on DBMS_LOB

Line 127: and dbms_lob.getlength(l_recruiting_site_response)<=32767

123: returning recruiting_site_response into l_recruiting_site_response;
124: --
125: --
126: if (g_recruiting_site_response
127: and dbms_lob.getlength(l_recruiting_site_response)<=32767
128: and dbms_lob.instr(l_recruiting_site_response,p_rec.recruiting_site_response)<>1)
129: then
130: hr_utility.set_location(l_proc, 10);
131: dbms_lob.trim(l_recruiting_site_response,0);

Line 128: and dbms_lob.instr(l_recruiting_site_response,p_rec.recruiting_site_response)<>1)

124: --
125: --
126: if (g_recruiting_site_response
127: and dbms_lob.getlength(l_recruiting_site_response)<=32767
128: and dbms_lob.instr(l_recruiting_site_response,p_rec.recruiting_site_response)<>1)
129: then
130: hr_utility.set_location(l_proc, 10);
131: dbms_lob.trim(l_recruiting_site_response,0);
132: dbms_lob.write(l_recruiting_site_response

Line 131: dbms_lob.trim(l_recruiting_site_response,0);

127: and dbms_lob.getlength(l_recruiting_site_response)<=32767
128: and dbms_lob.instr(l_recruiting_site_response,p_rec.recruiting_site_response)<>1)
129: then
130: hr_utility.set_location(l_proc, 10);
131: dbms_lob.trim(l_recruiting_site_response,0);
132: dbms_lob.write(l_recruiting_site_response
133: ,length(p_rec.recruiting_site_response)
134: ,1
135: ,p_rec.recruiting_site_response);

Line 132: dbms_lob.write(l_recruiting_site_response

128: and dbms_lob.instr(l_recruiting_site_response,p_rec.recruiting_site_response)<>1)
129: then
130: hr_utility.set_location(l_proc, 10);
131: dbms_lob.trim(l_recruiting_site_response,0);
132: dbms_lob.write(l_recruiting_site_response
133: ,length(p_rec.recruiting_site_response)
134: ,1
135: ,p_rec.recruiting_site_response);
136: end if;