DBA Data[Home] [Help]

APPS.PO_POAPPROVAL_INIT1 dependencies on WF_USERS

Line 1464: l_approver_user_name WF_USERS.name%TYPE;

1460: l_document_subtype PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE;
1461: l_is_new_document VARCHAR2(1);
1462: l_contractor_or_job VARCHAR2(500);
1463: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;
1464: l_approver_user_name WF_USERS.name%TYPE;
1465: l_item_key WF_ITEMS.item_key%TYPE;
1466: l_item_key_seq NUMBER;
1467: BEGIN
1468: -- Do nothing if the Workflow mode is Cancel or Timeout.

Line 1607: l_requester_user_name WF_USERS.name%TYPE;

1603: p_approver_user_name IN VARCHAR2
1604: ) IS
1605: l_proc_name VARCHAR2(30) := 'start_po_line_wf_process';
1606: l_progress VARCHAR2(3) := '000';
1607: l_requester_user_name WF_USERS.name%TYPE;
1608: l_requester_disp_name WF_USERS.display_name%TYPE;
1609: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1610: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
1611: l_document_number PO_HEADERS_ALL.segment1%TYPE;

Line 1608: l_requester_disp_name WF_USERS.display_name%TYPE;

1604: ) IS
1605: l_proc_name VARCHAR2(30) := 'start_po_line_wf_process';
1606: l_progress VARCHAR2(3) := '000';
1607: l_requester_user_name WF_USERS.name%TYPE;
1608: l_requester_disp_name WF_USERS.display_name%TYPE;
1609: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1610: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
1611: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1612: l_create_cwk_url VARCHAR2(500);