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:
541: BEGIN
542:
543: d_position := 0;

Line 587: FROM WF_USER_ROLES

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