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 9575: l_name wf_local_roles.NAME%TYPE;

9571: pragma AUTONOMOUS_TRANSACTION;
9572:
9573: l_emp_id NUMBER;
9574: l_rowid ROWID;
9575: l_name wf_local_roles.NAME%TYPE;
9576: l_display_name wf_local_roles.display_name%TYPE;
9577: l_email_address wf_local_roles.email_address%TYPE;
9578: l_notification_preference wf_local_roles.notification_preference%TYPE;
9579: l_language wf_local_roles.LANGUAGE%TYPE;

Line 9576: l_display_name wf_local_roles.display_name%TYPE;

9572:
9573: l_emp_id NUMBER;
9574: l_rowid ROWID;
9575: l_name wf_local_roles.NAME%TYPE;
9576: l_display_name wf_local_roles.display_name%TYPE;
9577: l_email_address wf_local_roles.email_address%TYPE;
9578: l_notification_preference wf_local_roles.notification_preference%TYPE;
9579: l_language wf_local_roles.LANGUAGE%TYPE;
9580: l_territory wf_local_roles.territory%TYPE;

Line 9577: l_email_address wf_local_roles.email_address%TYPE;

9573: l_emp_id NUMBER;
9574: l_rowid ROWID;
9575: l_name wf_local_roles.NAME%TYPE;
9576: l_display_name wf_local_roles.display_name%TYPE;
9577: l_email_address wf_local_roles.email_address%TYPE;
9578: l_notification_preference wf_local_roles.notification_preference%TYPE;
9579: l_language wf_local_roles.LANGUAGE%TYPE;
9580: l_territory wf_local_roles.territory%TYPE;
9581: l_note fnd_new_messages.message_text%TYPE;

Line 9578: l_notification_preference wf_local_roles.notification_preference%TYPE;

9574: l_rowid ROWID;
9575: l_name wf_local_roles.NAME%TYPE;
9576: l_display_name wf_local_roles.display_name%TYPE;
9577: l_email_address wf_local_roles.email_address%TYPE;
9578: l_notification_preference wf_local_roles.notification_preference%TYPE;
9579: l_language wf_local_roles.LANGUAGE%TYPE;
9580: l_territory wf_local_roles.territory%TYPE;
9581: l_note fnd_new_messages.message_text%TYPE;
9582:

Line 9579: l_language wf_local_roles.LANGUAGE%TYPE;

9575: l_name wf_local_roles.NAME%TYPE;
9576: l_display_name wf_local_roles.display_name%TYPE;
9577: l_email_address wf_local_roles.email_address%TYPE;
9578: l_notification_preference wf_local_roles.notification_preference%TYPE;
9579: l_language wf_local_roles.LANGUAGE%TYPE;
9580: l_territory wf_local_roles.territory%TYPE;
9581: l_note fnd_new_messages.message_text%TYPE;
9582:
9583: BEGIN

Line 9580: l_territory wf_local_roles.territory%TYPE;

9576: l_display_name wf_local_roles.display_name%TYPE;
9577: l_email_address wf_local_roles.email_address%TYPE;
9578: l_notification_preference wf_local_roles.notification_preference%TYPE;
9579: l_language wf_local_roles.LANGUAGE%TYPE;
9580: l_territory wf_local_roles.territory%TYPE;
9581: l_note fnd_new_messages.message_text%TYPE;
9582:
9583: BEGIN
9584: -- SQL What : Get the employee_id corresponding to the last NULL action record.