APPS.PO_ONLINE_AUTHORING_WF_ACTIONS dependencies on WF_USER_ROLES

Line 86: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;

82:
83: l_supplier_list DBMS_SQL.VARCHAR2_TABLE;
84: l_buyer_user_name fnd_user.user_name%type;
85: l_buyer_display_name per_people_f.full_name%type;
86: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;
87: d_mod CONSTANT VARCHAR2(100) := D_start_authoring_enabled_wf;
88:
89: BEGIN
90: l_progress := 10;

Line 251: l_forward_to_role WF_USER_ROLES.ROLE_NAME%TYPE;

247: l_buyer_display_name per_people_f.full_name%type;
248:
249: l_lock_owner_user_name fnd_user.user_name%type;
250:
251: l_forward_to_role WF_USER_ROLES.ROLE_NAME%TYPE;
252: l_forward_to_role_dsp VARCHAR2(500);
253: BEGIN
254: d_position := 0;
255:

Line 375: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE := NULL;

371: l_msg_count NUMBER := 0;
372: l_msg_data VARCHAR2(2000);
373:
374: -- local variables for role creation
375: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE := NULL;
376: l_role_display_name varchar2(100):=null;
377: d_mod CONSTANT VARCHAR2(100) := D_get_wf_role_for_suppliers;
378:
379:

Line 539: l_expected_wf_role_name WF_USER_ROLES.role_name%TYPE;

535:
536: l_vendor_name PO_VENDORS.vendor_name%TYPE;
537: l_emp_id FND_USER.employee_id%TYPE;
538: l_user_name FND_USER.user_name%TYPE;
539: l_expected_wf_role_name WF_USER_ROLES.role_name%TYPE;
540: l_user_table WF_DIRECTORY.UserTable; --Added as part of Bug 13059528 fix
541:
542: BEGIN
543:

Line 588: FROM WF_USER_ROLES

584: -- Check whether an existing ad hoc role for the supplier user has been
585: -- creatd already
586: SELECT MAX(role_name)
587: INTO x_wf_role_name
588: FROM WF_USER_ROLES
589: WHERE role_name = l_expected_wf_role_name;
590:
591: d_position := 40;
592: