APPS.PO_SIGNATURE_PVT dependencies on FND_USER

Line 90: l_username FND_USER.user_name%TYPE;

86: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;
87: l_revision PO_HEADERS_ALL.revision_num%TYPE;
88: l_orgid PO_HEADERS_ALL.org_id%TYPE;
89: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;
90: l_username FND_USER.user_name%TYPE;
91: l_user_display_name FND_USER.description%TYPE;
92: l_progress VARCHAR2(300);
93: l_vendor_name PO_VENDORS.vendor_name%TYPE;
94: l_doc_string VARCHAR2(200);

Line 91: l_user_display_name FND_USER.description%TYPE;

87: l_revision PO_HEADERS_ALL.revision_num%TYPE;
88: l_orgid PO_HEADERS_ALL.org_id%TYPE;
89: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;
90: l_username FND_USER.user_name%TYPE;
91: l_user_display_name FND_USER.description%TYPE;
92: l_progress VARCHAR2(300);
93: l_vendor_name PO_VENDORS.vendor_name%TYPE;
94: l_doc_string VARCHAR2(200);
95: l_preparer_user_name WF_USERS.name%TYPE;

Line 300: l_buyer_name FND_USER.user_name%TYPE;

296: document_type IN OUT NOCOPY VARCHAR2) IS
297:
298: l_msgbody VARCHAR2(32000);
299: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
300: l_buyer_name FND_USER.user_name%TYPE;
301: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
302: l_supplier_response VARCHAR2(20);
303: l_item_type WF_ITEMS.item_type%TYPE;
304: l_item_key WF_ITEMS.item_key%TYPE;

Line 508: l_user_name FND_USER.user_name%TYPE;

504: l_erecord_id NUMBER;
505: l_doc_parameters PO_ERECORDS_PVT.Params_tbl_type;
506: l_sig_parameters PO_ERECORDS_PVT.Params_tbl_type;
507: l_po_header_id PO_HEADERS.po_header_id%TYPE;
508: l_user_name FND_USER.user_name%TYPE;
509: l_requester FND_USER.user_name%TYPE;
510: l_buyer_response VARCHAR2(20);
511: l_response VARCHAR2(20);
512: l_supplier_response VARCHAR2(20);

Line 509: l_requester FND_USER.user_name%TYPE;

505: l_doc_parameters PO_ERECORDS_PVT.Params_tbl_type;
506: l_sig_parameters PO_ERECORDS_PVT.Params_tbl_type;
507: l_po_header_id PO_HEADERS.po_header_id%TYPE;
508: l_user_name FND_USER.user_name%TYPE;
509: l_requester FND_USER.user_name%TYPE;
510: l_buyer_response VARCHAR2(20);
511: l_response VARCHAR2(20);
512: l_supplier_response VARCHAR2(20);
513: l_event_name VARCHAR2(50);

Line 859: FROM FND_USER FU,

855:
856: BEGIN
857: SELECT HP.person_title
858: INTO l_role
859: FROM FND_USER FU,
860: HZ_PARTIES HP
861: WHERE HP.party_id = FU.customer_id
862: AND FU.user_id = fnd_global.user_id;
863: EXCEPTION

Line 1326: l_buyer_name FND_USER.user_name%TYPE;

1322: document_type IN OUT NOCOPY VARCHAR2) IS
1323:
1324: l_msgbody VARCHAR2(32000);
1325: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1326: l_buyer_name FND_USER.user_name%TYPE;
1327: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
1328: l_item_type WF_ITEMS.item_type%TYPE;
1329: l_item_key WF_ITEMS.item_key%TYPE;
1330: l_firstcolon NUMBER;

Line 1682: l_buyer_name FND_USER.user_name%TYPE;

1678: document_type IN OUT NOCOPY VARCHAR2) IS
1679:
1680: l_msgbody VARCHAR2(32000);
1681: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1682: l_buyer_name FND_USER.user_name%TYPE;
1683: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
1684: l_buyer_response VARCHAR2(20);
1685: l_item_type WF_ITEMS.item_type%TYPE;
1686: l_item_key WF_ITEMS.item_key%TYPE;

Line 1693: l_supplier_name FND_USER.user_name%TYPE;

1689: l_amount NUMBER;
1690: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1691: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1692: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1693: l_supplier_name FND_USER.user_name%TYPE;
1694: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
1695: l_orgid PO_HEADERS_ALL.org_id%TYPE;
1696: l_doc_string VARCHAR2(200);
1697: l_preparer_user_name WF_USERS.name%TYPE;

Line 2990: l_employee_id FND_USER.employee_id%TYPE; -- bug3738420

2986: l_msg_data VARCHAR2(2000);
2987: l_msg_count NUMBER;
2988: --
2989:
2990: l_employee_id FND_USER.employee_id%TYPE; -- bug3738420
2991:
2992: l_binding_exception EXCEPTION;
2993: BEGIN
2994: BEGIN