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.AP_WORKFLOW_PKG dependencies on WF_ROLES

Line 7892: l_orig_system WF_ROLES.ORIG_SYSTEM%TYPE;

7888: l_response VARCHAR2(50);
7889: l_nid number;
7890: l_forward_to_person_id number;
7891: l_result varchar2(100);
7892: l_orig_system WF_ROLES.ORIG_SYSTEM%TYPE;
7893: l_orig_sys_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
7894: l_role VARCHAR2(50);
7895: l_role_display VARCHAR2(150);
7896: l_org_id NUMBER(15);

Line 7893: l_orig_sys_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;

7889: l_nid number;
7890: l_forward_to_person_id number;
7891: l_result varchar2(100);
7892: l_orig_system WF_ROLES.ORIG_SYSTEM%TYPE;
7893: l_orig_sys_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
7894: l_role VARCHAR2(50);
7895: l_role_display VARCHAR2(150);
7896: l_org_id NUMBER(15);
7897: l_name wf_users.name%TYPE; --bug 8620671

Line 7899: l_forward_to_user_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;

7895: l_role_display VARCHAR2(150);
7896: l_org_id NUMBER(15);
7897: l_name wf_users.name%TYPE; --bug 8620671
7898: l_display_name VARCHAR2(150);
7899: l_forward_to_user_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
7900: l_esc_approver AME_UTIL.approverRecord;
7901: l_rec_role VARCHAR2(50);
7902: l_comments VARCHAR2(240);
7903: l_hist_id NUMBER(15);

Line 8268: l_orig_system WF_ROLES.ORIG_SYSTEM%TYPE;

8264: l_response VARCHAR2(50);
8265: l_nid number;
8266: l_forward_to_person_id number;
8267: l_result varchar2(100);
8268: l_orig_system WF_ROLES.ORIG_SYSTEM%TYPE;
8269: l_orig_sys_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
8270: l_role VARCHAR2(50);
8271: l_role_display VARCHAR2(150);
8272: l_org_id NUMBER(15);

Line 8269: l_orig_sys_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;

8265: l_nid number;
8266: l_forward_to_person_id number;
8267: l_result varchar2(100);
8268: l_orig_system WF_ROLES.ORIG_SYSTEM%TYPE;
8269: l_orig_sys_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
8270: l_role VARCHAR2(50);
8271: l_role_display VARCHAR2(150);
8272: l_org_id NUMBER(15);
8273: l_name wf_users.name%TYPE; --bug 8620671

Line 8275: l_forward_to_user_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;

8271: l_role_display VARCHAR2(150);
8272: l_org_id NUMBER(15);
8273: l_name wf_users.name%TYPE; --bug 8620671
8274: l_display_name VARCHAR2(150);
8275: l_forward_to_user_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
8276: l_esc_approver AME_UTIL.approverRecord;
8277: l_rec_role VARCHAR2(50);
8278: l_comments VARCHAR2(240);
8279: l_hist_id NUMBER(15);

Line 8642: * wf_roles

8638: * if user is taking the RESPOND action through e-mail on his or
8639: * her own behalf. The code has been written based on this to :
8640: * 1) Check whether WF_ENGINE.context_user is set to 'email:...'
8641: * 2) If yes, check how many times the email address exists in
8642: * wf_roles
8643: * 3) If it does not exist or exists more than once, then do nothing.
8644: * This will let the context to be set as per WF Engine ( which
8645: * works under SYSADMIN context ). If the role does not exist then
8646: * we have no way of setting the context and if it exists multiple

Line 8693: FROM wf_roles

8689: THEN
8690: BEGIN
8691: SELECT COUNT( name )
8692: INTO l_user_role_count
8693: FROM wf_roles
8694: WHERE UPPER( email_address ) = UPPER( SUBSTR( WF_ENGINE.context_user, 7 ) )
8695: AND orig_system = 'PER'
8696: AND status = 'ACTIVE' ;
8697: EXCEPTION

Line 8712: FROM wf_roles

8708: IF l_user_role_count = 1
8709: THEN
8710: SELECT name
8711: INTO l_user_name
8712: FROM wf_roles
8713: WHERE UPPER( email_address ) = UPPER( SUBSTR( WF_ENGINE.context_user, 7 ) )
8714: AND orig_system = 'PER'
8715: AND status = 'ACTIVE' ;
8716:

Line 8822: l_forward_to_user_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;

8818: l_fwd_role VARCHAR2(50); -- Variable stored to use the forward role
8819: l_doc_approver VARCHAR2(50); --the variable used to store the doc approver
8820: l_line_approver VARCHAR2(50); -- the variable used to store the lines approver.
8821: l_role_actual VARCHAR2(50); -- the variable used to store the role actual
8822: l_forward_to_user_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
8823: l_rec_role VARCHAR2(50);
8824: l_forward_to_person_id number;
8825: l_orig_system WF_ROLES.ORIG_SYSTEM%TYPE;
8826: l_orig_sys_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;

Line 8825: l_orig_system WF_ROLES.ORIG_SYSTEM%TYPE;

8821: l_role_actual VARCHAR2(50); -- the variable used to store the role actual
8822: l_forward_to_user_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
8823: l_rec_role VARCHAR2(50);
8824: l_forward_to_person_id number;
8825: l_orig_system WF_ROLES.ORIG_SYSTEM%TYPE;
8826: l_orig_sys_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
8827: l_notification_cxt VARCHAR2(50);
8828: l_notification_key VARCHAR2(50);
8829: l_forward_role_lines VARCHAR2(50);

Line 8826: l_orig_sys_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;

8822: l_forward_to_user_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
8823: l_rec_role VARCHAR2(50);
8824: l_forward_to_person_id number;
8825: l_orig_system WF_ROLES.ORIG_SYSTEM%TYPE;
8826: l_orig_sys_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
8827: l_notification_cxt VARCHAR2(50);
8828: l_notification_key VARCHAR2(50);
8829: l_forward_role_lines VARCHAR2(50);
8830: l_approver_name VARCHAR2(50);