APPS.IRC_INO_SHD dependencies on DBMS_LOB

Line 108: := dbms_lob.substr(irc_ino_shd.g_old_rec.note_text_c);

104: End If;
105: Close C_Sel1;
106: -- Convert note_text from clob to varchar
107: irc_ino_shd.g_old_rec.note_text
108: := dbms_lob.substr(irc_ino_shd.g_old_rec.note_text_c);
109: --
110: If (p_object_version_number
111: <> irc_ino_shd.g_old_rec.object_version_number) Then
112: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

Line 173: := dbms_lob.substr(irc_ino_shd.g_old_rec.note_text_c);

169: End If;
170: Close C_Sel1;
171: -- Convert note_text from clob to varchar
172: irc_ino_shd.g_old_rec.note_text
173: := dbms_lob.substr(irc_ino_shd.g_old_rec.note_text_c);
174: --
175: If (p_object_version_number
176: <> irc_ino_shd.g_old_rec.object_version_number) Then
177: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');