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

Line 85: and dbms_lob.getlength(l_redirection_url)<=32767

81: and language = p_rec.language
82: returning redirection_url,posting_url into l_redirection_url,l_posting_url;
83: --
84: if (g_redirection_url
85: and dbms_lob.getlength(l_redirection_url)<=32767
86: and dbms_lob.instr(l_redirection_url,p_rec.redirection_url)<>1)
87: then
88: hr_utility.set_location(l_proc, 10);
89: dbms_lob.trim(l_redirection_url,0);

Line 86: and dbms_lob.instr(l_redirection_url,p_rec.redirection_url)<>1)

82: returning redirection_url,posting_url into l_redirection_url,l_posting_url;
83: --
84: if (g_redirection_url
85: and dbms_lob.getlength(l_redirection_url)<=32767
86: and dbms_lob.instr(l_redirection_url,p_rec.redirection_url)<>1)
87: then
88: hr_utility.set_location(l_proc, 10);
89: dbms_lob.trim(l_redirection_url,0);
90: dbms_lob.write(l_redirection_url

Line 89: dbms_lob.trim(l_redirection_url,0);

85: and dbms_lob.getlength(l_redirection_url)<=32767
86: and dbms_lob.instr(l_redirection_url,p_rec.redirection_url)<>1)
87: then
88: hr_utility.set_location(l_proc, 10);
89: dbms_lob.trim(l_redirection_url,0);
90: dbms_lob.write(l_redirection_url
91: ,length(p_rec.redirection_url)
92: ,1
93: ,p_rec.redirection_url);

Line 90: dbms_lob.write(l_redirection_url

86: and dbms_lob.instr(l_redirection_url,p_rec.redirection_url)<>1)
87: then
88: hr_utility.set_location(l_proc, 10);
89: dbms_lob.trim(l_redirection_url,0);
90: dbms_lob.write(l_redirection_url
91: ,length(p_rec.redirection_url)
92: ,1
93: ,p_rec.redirection_url);
94: end if;

Line 99: and dbms_lob.getlength(l_posting_url)<=32767

95: --
96: hr_utility.set_location(' Leaving:'||l_proc, 20);
97: --
98: if (g_posting_url
99: and dbms_lob.getlength(l_posting_url)<=32767
100: and dbms_lob.instr(l_posting_url,p_rec.posting_url)<>1)
101: then
102: hr_utility.set_location(l_proc, 30);
103: dbms_lob.trim(l_posting_url,0);

Line 100: and dbms_lob.instr(l_posting_url,p_rec.posting_url)<>1)

96: hr_utility.set_location(' Leaving:'||l_proc, 20);
97: --
98: if (g_posting_url
99: and dbms_lob.getlength(l_posting_url)<=32767
100: and dbms_lob.instr(l_posting_url,p_rec.posting_url)<>1)
101: then
102: hr_utility.set_location(l_proc, 30);
103: dbms_lob.trim(l_posting_url,0);
104: dbms_lob.write(l_posting_url

Line 103: dbms_lob.trim(l_posting_url,0);

99: and dbms_lob.getlength(l_posting_url)<=32767
100: and dbms_lob.instr(l_posting_url,p_rec.posting_url)<>1)
101: then
102: hr_utility.set_location(l_proc, 30);
103: dbms_lob.trim(l_posting_url,0);
104: dbms_lob.write(l_posting_url
105: ,length(p_rec.posting_url)
106: ,1
107: ,p_rec.posting_url);

Line 104: dbms_lob.write(l_posting_url

100: and dbms_lob.instr(l_posting_url,p_rec.posting_url)<>1)
101: then
102: hr_utility.set_location(l_proc, 30);
103: dbms_lob.trim(l_posting_url,0);
104: dbms_lob.write(l_posting_url
105: ,length(p_rec.posting_url)
106: ,1
107: ,p_rec.posting_url);
108: end if;