APPS.PO_ONLINE_AUTHORING_WF_ACTIONS dependencies on FND_USER

Line 70: l_supplier_user_name fnd_user.user_name%type;

66: IS
67: l_seq_for_item_key varchar2(10) := null;
68: l_item_type po_headers_all.wf_item_type%type := 'POAUTH';
69: l_item_key po_headers_all.wf_item_key%type := null;
70: l_supplier_user_name fnd_user.user_name%type;
71: l_progress NUMBER := 0;
72: -- bug 4733423: Modified the link to access edit blanket page
73: l_edit_agreement_url varchar2(1000) :=
74: 'JSP:/OA_HTML/OA.jsp?OAFunc=PO_BLANKET' ||'&' ||

Line 84: l_buyer_user_name fnd_user.user_name%type;

80: 'addBreadCrumb=Y' || '&' ||
81: 'role=SUPPLIER';
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:

Line 246: l_buyer_user_name fnd_user.user_name%type;

242:
243: l_seq_for_item_key NUMBER := NULL;
244: l_item_key po_headers_all.wf_item_key%type := null;
245:
246: l_buyer_user_name fnd_user.user_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:

Line 249: l_lock_owner_user_name fnd_user.user_name%type;

245:
246: l_buyer_user_name fnd_user.user_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

Line 537: l_emp_id FND_USER.employee_id%TYPE;

533: d_mod CONSTANT VARCHAR2(100) := D_get_wf_role_for_lock_owner;
534: d_position NUMBER;
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:

Line 538: l_user_name FND_USER.user_name%TYPE;

534: d_position NUMBER;
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

Line 555: FROM fnd_user

551: d_position := 10;
552:
553: SELECT employee_id
554: INTO l_emp_id
555: FROM fnd_user
556: WHERE user_id = p_lock_owner_user_id;
557:
558: d_position := 20;
559:

Line 571: FROM fnd_user

567: d_position := 30;
568:
569: SELECT user_name
570: INTO l_user_name
571: FROM fnd_user
572: WHERE user_id = p_lock_owner_user_id;
573:
574: SELECT PV.vendor_name
575: INTO x_wf_role_name_dsp