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:
541: BEGIN

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:
541: BEGIN
542:

Line 554: FROM fnd_user

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

Line 570: FROM fnd_user

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