eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 282: fnd_user fu

278: SELECT fu.user_name
279: INTO l_supplier_user_name
280: FROM po_supplier_contacts_val_v pscv,
281: po_headers_merge_v phm,
282: fnd_user fu
283: WHERE pscv.vendor_contact_id = phm.vendor_contact_id
284: AND pscv.vendor_site_id = phm.vendor_site_id
285: AND fu.user_name = pscv.user_name
286: AND phm.po_header_id = l_document_id

Line 373: l_buyer_name FND_USER.user_name%TYPE;

369: document_type IN OUT NOCOPY VARCHAR2) IS
370:
371: l_msgbody VARCHAR2(32000);
372: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
373: l_buyer_name FND_USER.user_name%TYPE;
374: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
375: l_supplier_response VARCHAR2(20);
376: l_item_type WF_ITEMS.item_type%TYPE;
377: l_item_key WF_ITEMS.item_key%TYPE;

Line 595: l_user_name FND_USER.user_name%TYPE;

591: l_erecord_id NUMBER;
592: l_doc_parameters PO_ERECORDS_PVT.Params_tbl_type;
593: l_sig_parameters PO_ERECORDS_PVT.Params_tbl_type;
594: l_po_header_id PO_HEADERS.po_header_id%TYPE;
595: l_user_name FND_USER.user_name%TYPE;
596: l_requester FND_USER.user_name%TYPE;
597: l_buyer_response VARCHAR2(20);
598: l_response VARCHAR2(20);
599: l_supplier_response VARCHAR2(20);

Line 596: l_requester FND_USER.user_name%TYPE;

592: l_doc_parameters PO_ERECORDS_PVT.Params_tbl_type;
593: l_sig_parameters PO_ERECORDS_PVT.Params_tbl_type;
594: l_po_header_id PO_HEADERS.po_header_id%TYPE;
595: l_user_name FND_USER.user_name%TYPE;
596: l_requester FND_USER.user_name%TYPE;
597: l_buyer_response VARCHAR2(20);
598: l_response VARCHAR2(20);
599: l_supplier_response VARCHAR2(20);
600: l_ko_response VARCHAR2(20);

Line 931: l_ko_user_name FND_USER.user_name%TYPE;

927: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
928: l_role PO_ACCEPTANCES.role%TYPE;
929: l_supplier_response VARCHAR2(20);
930: l_ko_response VARCHAR2(20);
931: l_ko_user_name FND_USER.user_name%TYPE;
932: l_buyer_response VARCHAR2(20);
933: l_action_code VARCHAR2(20);
934: l_response VARCHAR2(20);
935: l_accepted_flag PO_ACCEPTANCES.accepted_flag%TYPE;

Line 1021: FROM FND_USER FU,

1017:
1018: BEGIN
1019: SELECT HP.person_title
1020: INTO l_role
1021: FROM FND_USER FU,
1022: HZ_PARTIES HP
1023: WHERE HP.party_id = FU.customer_id
1024: AND FU.user_id = fnd_global.user_id;
1025: EXCEPTION

Line 1080: from fnd_user

1076: --Logic to derive the contracting Officer's ID
1077: BEGIN
1078: select employee_id
1079: into l_employee_id
1080: from fnd_user
1081: where user_name = l_ko_user_name;
1082: EXCEPTION
1083: when no_data_found then
1084: l_employee_id := null;

Line 1669: l_buyer_name FND_USER.user_name%TYPE;

1665: document_type IN OUT NOCOPY VARCHAR2) IS
1666:
1667: l_msgbody VARCHAR2(32000);
1668: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1669: l_buyer_name FND_USER.user_name%TYPE;
1670: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
1671: l_item_type WF_ITEMS.item_type%TYPE;
1672: l_item_key WF_ITEMS.item_key%TYPE;
1673: l_firstcolon NUMBER;

Line 2033: l_buyer_name FND_USER.user_name%TYPE;

2029: document_type IN OUT NOCOPY VARCHAR2) IS
2030:
2031: l_msgbody VARCHAR2(32000);
2032: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2033: l_buyer_name FND_USER.user_name%TYPE;
2034: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
2035: l_buyer_response VARCHAR2(20);
2036: l_item_type WF_ITEMS.item_type%TYPE;
2037: l_item_key WF_ITEMS.item_key%TYPE;

Line 2044: l_supplier_name FND_USER.user_name%TYPE;

2040: l_amount NUMBER;
2041: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
2042: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
2043: l_revision PO_HEADERS_ALL.revision_num%TYPE;
2044: l_supplier_name FND_USER.user_name%TYPE;
2045: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
2046: l_orgid PO_HEADERS_ALL.org_id%TYPE;
2047: l_doc_string VARCHAR2(200);
2048: l_preparer_user_name WF_USERS.name%TYPE;

Line 2749: FROM fnd_user

2745: --Logic to derive the contracting Officer's ID
2746: BEGIN
2747: SELECT employee_id
2748: INTO l_contracting_officer
2749: FROM fnd_user
2750: WHERE user_name = WF_ENGINE.context_new_role;
2751: EXCEPTION
2752: when no_data_found then
2753: l_contracting_officer := null;

Line 2861: FROM fnd_user

2857: --Logic to derive the contracting Officer's ID
2858: BEGIN
2859: SELECT employee_id
2860: INTO l_contracting_officer
2861: FROM fnd_user
2862: WHERE user_name = WF_ENGINE.context_new_role;
2863: EXCEPTION
2864: when no_data_found then
2865: l_contracting_officer := null;

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

3729: l_msg_data VARCHAR2(2000);
3730: l_msg_count NUMBER;
3731: --
3732:
3733: l_employee_id FND_USER.employee_id%TYPE; -- bug3738420
3734:
3735: l_binding_exception EXCEPTION;
3736: BEGIN
3737: BEGIN

Line 4631: l_ko_user_name FND_USER.user_name%TYPE;

4627: l_preparer_user_name WF_USERS.name%TYPE;
4628: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
4629: l_revision PO_HEADERS_ALL.revision_num%TYPE;
4630: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;
4631: l_ko_user_name FND_USER.user_name%TYPE;
4632: l_return_status VARCHAR2(1);
4633: l_online_report_id NUMBER;
4634: l_user_id po_lines.last_updated_by%TYPE := -1;
4635: l_login_id po_lines.last_update_login%TYPE := -1;

Line 4669: from fnd_user

4665: --Logic to derive the contracting Officer's ID
4666: BEGIN
4667: select employee_id
4668: into l_contracting_officer
4669: from fnd_user
4670: where user_name = l_ko_user_name;
4671: EXCEPTION
4672: when no_data_found then
4673: l_contracting_officer := null;

Line 4901: l_ko_user_name FND_USER.user_name%TYPE;

4897: l_log_head VARCHAR2(100) := g_pkg_name || '.' || l_api_name;
4898: l_warning varchar2(2000) := null;
4899: l_forward_to_username varchar2(25) := null;
4900: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;
4901: l_ko_user_name FND_USER.user_name%TYPE;
4902: l_document_id PO_HEADERs_ALL.po_header_id%TYPE;
4903: l_return_status VARCHAR2(1);
4904: l_online_report_id NUMBER;
4905: l_user_id po_lines.last_updated_by%TYPE := -1;

Line 4963: from fnd_user

4959: --Logic to derive the contracting Officer's ID
4960: BEGIN
4961: select employee_id
4962: into l_contracting_officer
4963: from fnd_user
4964: where user_name = l_ko_user_name;
4965: EXCEPTION
4966: when no_data_found then
4967: l_contracting_officer := null;