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

Line 81: and dbms_lob.getlength(l_note_text)<=32767

77: where note_id = p_rec.note_id
78: returning note_text into l_note_text;
79: --
80: if (g_note_text
81: and dbms_lob.getlength(l_note_text)<=32767
82: and dbms_lob.instr(l_note_text,p_rec.note_text)<>1)
83: then
84: hr_utility.set_location(l_proc, 10);
85: dbms_lob.trim(l_note_text,0);

Line 82: and dbms_lob.instr(l_note_text,p_rec.note_text)<>1)

78: returning note_text into l_note_text;
79: --
80: if (g_note_text
81: and dbms_lob.getlength(l_note_text)<=32767
82: and dbms_lob.instr(l_note_text,p_rec.note_text)<>1)
83: then
84: hr_utility.set_location(l_proc, 10);
85: dbms_lob.trim(l_note_text,0);
86: dbms_lob.write(l_note_text

Line 85: dbms_lob.trim(l_note_text,0);

81: and dbms_lob.getlength(l_note_text)<=32767
82: and dbms_lob.instr(l_note_text,p_rec.note_text)<>1)
83: then
84: hr_utility.set_location(l_proc, 10);
85: dbms_lob.trim(l_note_text,0);
86: dbms_lob.write(l_note_text
87: ,length(p_rec.note_text)
88: ,1
89: ,p_rec.note_text);

Line 86: dbms_lob.write(l_note_text

82: and dbms_lob.instr(l_note_text,p_rec.note_text)<>1)
83: then
84: hr_utility.set_location(l_proc, 10);
85: dbms_lob.trim(l_note_text,0);
86: dbms_lob.write(l_note_text
87: ,length(p_rec.note_text)
88: ,1
89: ,p_rec.note_text);
90: end if;