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.HR_GEN_PKG dependencies on HR_COMMENTS

Line 196: -- Inserts a comment into the HR comments table

192: end get_customized_restriction;
193: --------------------------------------------------------------------------------
194: procedure insert_comment (
195: --
196: -- Inserts a comment into the HR comments table
197: --
198: --
199: p_source_table_name varchar2,
200: p_comment_text varchar2,

Line 204: select hr_comments_s.nextval

200: p_comment_text varchar2,
201: p_comment_id in out nocopy number) is
202: --
203: cursor csr_next_comment_id is
204: select hr_comments_s.nextval
205: from sys.dual;
206: --
207: begin
208: --

Line 213: insert into hr_comments (

209: open csr_next_comment_id;
210: fetch csr_next_comment_id into p_comment_id;
211: close csr_next_comment_id;
212: --
213: insert into hr_comments (
214: --
215: comment_id,
216: source_table_name,
217: comment_text)

Line 227: -- Gets a comment from the HR comments table

223: end insert_comment;
224: --------------------------------------------------------------------------------
225: function comment_text (p_comment_id number) return varchar2 is
226: --
227: -- Gets a comment from the HR comments table
228: --
229: cursor csr_comment is
230: select comment_text
231: from hr_comments

Line 231: from hr_comments

227: -- Gets a comment from the HR comments table
228: --
229: cursor csr_comment is
230: select comment_text
231: from hr_comments
232: where comment_id = p_comment_id;
233: --
234: /* Expanded to 32000 for WWBUG 1382371 */
235: l_comment_text varchar2 (32000);