DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on WF_ROLES

Line 4098: l_requester_name wf_roles.name%type;

4094: l_document_id number;
4095: l_document_number po_change_requests.document_num%type;
4096: l_org_id number;
4097: l_requester_id number;
4098: l_requester_name wf_roles.name%type;
4099: l_requester_display_name wf_roles.display_name%type;
4100: x_progress varchar2(100);
4101: l_functional_currency varchar2(200);
4102: l_total_amount_dsp varchar2(100);

Line 4099: l_requester_display_name wf_roles.display_name%type;

4095: l_document_number po_change_requests.document_num%type;
4096: l_org_id number;
4097: l_requester_id number;
4098: l_requester_name wf_roles.name%type;
4099: l_requester_display_name wf_roles.display_name%type;
4100: x_progress varchar2(100);
4101: l_functional_currency varchar2(200);
4102: l_total_amount_dsp varchar2(100);
4103: cursor change_request(l_change_request_group_id number) is

Line 4849: l_preparer_user_name wf_roles.name%type;

4845: l_orgid NUMBER;
4846: x_progress varchar2(100);
4847:
4848: l_doc_string varchar2(200);
4849: l_preparer_user_name wf_roles.name%type;
4850:
4851: BEGIN
4852:
4853: x_progress := 'PO_ReqChangeRequestWF_PVT.Update_Req_Change_Flag: 01';

Line 8138: l_requester_name wf_roles.name%type;

8134: l_seq number;
8135: l_item_key varchar2(240);
8136: x_progress varchar2(3) := '000';
8137: l_requester_id number;
8138: l_requester_name wf_roles.name%type;
8139: l_requester_display_name wf_roles.display_name%type;
8140: l_po_chg_itemtype wf_items.item_type%type;
8141: l_po_chg_itemkey wf_items.item_key%type;
8142:

Line 8139: l_requester_display_name wf_roles.display_name%type;

8135: l_item_key varchar2(240);
8136: x_progress varchar2(3) := '000';
8137: l_requester_id number;
8138: l_requester_name wf_roles.name%type;
8139: l_requester_display_name wf_roles.display_name%type;
8140: l_po_chg_itemtype wf_items.item_type%type;
8141: l_po_chg_itemkey wf_items.item_key%type;
8142:
8143: cursor l_get_group_id_po_csr is