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.PO_REQAPPROVAL_INIT1 dependencies on WF_LOCAL_ROLES

Line 8343: l_name wf_local_roles.NAME%TYPE;

8339: IS
8340: pragma AUTONOMOUS_TRANSACTION;
8341: l_emp_id NUMBER;
8342: l_rowid ROWID;
8343: l_name wf_local_roles.NAME%TYPE;
8344: l_display_name wf_local_roles.display_name%TYPE;
8345: l_email_address wf_local_roles.email_address%TYPE;
8346: l_notification_preference wf_local_roles.notification_preference%TYPE;
8347: l_language wf_local_roles.LANGUAGE%TYPE;

Line 8344: l_display_name wf_local_roles.display_name%TYPE;

8340: pragma AUTONOMOUS_TRANSACTION;
8341: l_emp_id NUMBER;
8342: l_rowid ROWID;
8343: l_name wf_local_roles.NAME%TYPE;
8344: l_display_name wf_local_roles.display_name%TYPE;
8345: l_email_address wf_local_roles.email_address%TYPE;
8346: l_notification_preference wf_local_roles.notification_preference%TYPE;
8347: l_language wf_local_roles.LANGUAGE%TYPE;
8348: l_territory wf_local_roles.territory%TYPE;

Line 8345: l_email_address wf_local_roles.email_address%TYPE;

8341: l_emp_id NUMBER;
8342: l_rowid ROWID;
8343: l_name wf_local_roles.NAME%TYPE;
8344: l_display_name wf_local_roles.display_name%TYPE;
8345: l_email_address wf_local_roles.email_address%TYPE;
8346: l_notification_preference wf_local_roles.notification_preference%TYPE;
8347: l_language wf_local_roles.LANGUAGE%TYPE;
8348: l_territory wf_local_roles.territory%TYPE;
8349: l_note fnd_new_messages.message_text%TYPE;

Line 8346: l_notification_preference wf_local_roles.notification_preference%TYPE;

8342: l_rowid ROWID;
8343: l_name wf_local_roles.NAME%TYPE;
8344: l_display_name wf_local_roles.display_name%TYPE;
8345: l_email_address wf_local_roles.email_address%TYPE;
8346: l_notification_preference wf_local_roles.notification_preference%TYPE;
8347: l_language wf_local_roles.LANGUAGE%TYPE;
8348: l_territory wf_local_roles.territory%TYPE;
8349: l_note fnd_new_messages.message_text%TYPE;
8350: BEGIN

Line 8347: l_language wf_local_roles.LANGUAGE%TYPE;

8343: l_name wf_local_roles.NAME%TYPE;
8344: l_display_name wf_local_roles.display_name%TYPE;
8345: l_email_address wf_local_roles.email_address%TYPE;
8346: l_notification_preference wf_local_roles.notification_preference%TYPE;
8347: l_language wf_local_roles.LANGUAGE%TYPE;
8348: l_territory wf_local_roles.territory%TYPE;
8349: l_note fnd_new_messages.message_text%TYPE;
8350: BEGIN
8351: -- SQL What : Get the employee_id corresponding to the last NULL action record.

Line 8348: l_territory wf_local_roles.territory%TYPE;

8344: l_display_name wf_local_roles.display_name%TYPE;
8345: l_email_address wf_local_roles.email_address%TYPE;
8346: l_notification_preference wf_local_roles.notification_preference%TYPE;
8347: l_language wf_local_roles.LANGUAGE%TYPE;
8348: l_territory wf_local_roles.territory%TYPE;
8349: l_note fnd_new_messages.message_text%TYPE;
8350: BEGIN
8351: -- SQL What : Get the employee_id corresponding to the last NULL action record.
8352: -- Sql Why : To get hold the language of the employee.