DBA Data[Home] [Help]

APPS.PO_SIGNATURE_PVT dependencies on WF_USERS

Line 95: l_preparer_user_name WF_USERS.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;
96: l_binding_exception EXCEPTION;
97: -- Forward port of bug 3897526. Display PDF attachment even when PO
98: -- has no terms
99: l_conterms_exist PO_HEADERS_ALL.conterms_exist_flag%type;

Line 384: l_preparer_user_name WF_USERS.name%TYPE;

380: l_amount NUMBER;
381: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
382: l_orgid PO_HEADERS_ALL.org_id%TYPE;
383: l_doc_string VARCHAR2(200);
384: l_preparer_user_name WF_USERS.name%TYPE;
385: l_progress VARCHAR2(300);
386: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;
387: l_binding_exception EXCEPTION;
388: /* Added for the bug 6358219 to fetch the legal_entity name */

Line 611: l_preparer_user_name WF_USERS.name%TYPE;

607: l_msg_count NUMBER;
608: l_msg_data VARCHAR2(2000);
609: l_progress VARCHAR2(300);
610: l_doc_string VARCHAR2(200);
611: l_preparer_user_name WF_USERS.name%TYPE;
612: l_trans_status VARCHAR2(10);
613: l_response_code FND_LOOKUP_VALUES.meaning%TYPE;
614: l_reason_code FND_LOOKUP_VALUES.meaning%TYPE;
615: l_signer_type FND_LOOKUP_VALUES.meaning%TYPE;

Line 944: l_preparer_user_name WF_USERS.name%TYPE;

940: l_last_update_login PO_ACCEPTANCES.last_update_login%TYPE;
941: l_rowid ROWID;
942: l_progress VARCHAR2(300);
943: l_doc_string VARCHAR2(200);
944: l_preparer_user_name WF_USERS.name%TYPE;
945: l_result VARCHAR2(1);
946: l_po_itemtype WF_ITEMS.item_type%TYPE;
947: l_po_itemkey WF_ITEMS.item_key%TYPE;
948: l_response_code FND_LOOKUP_VALUES.meaning%TYPE;

Line 1421: l_preparer_user_name WF_USERS.name%TYPE;

1417: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1418: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE; -- for clm documents l_document_number should be of clm_document_number types
1419: l_progress VARCHAR2(300);
1420: l_doc_string VARCHAR2(200);
1421: l_preparer_user_name WF_USERS.name%TYPE;
1422: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1423: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1424: l_po_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;
1425: BEGIN

Line 1548: l_preparer_user_name WF_USERS.name%TYPE;

1544: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1545: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
1546: l_progress VARCHAR2(300);
1547: l_doc_string VARCHAR2(200);
1548: l_preparer_user_name WF_USERS.name%TYPE;
1549: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1550: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1551: l_po_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;
1552:

Line 1686: l_preparer_user_name WF_USERS.name%TYPE;

1682: l_supplier_userid WF_LOCAL_ROLES.orig_system_id%TYPE;
1683: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
1684: l_orgid PO_HEADERS_ALL.org_id%TYPE;
1685: l_doc_string VARCHAR2(200);
1686: l_preparer_user_name WF_USERS.name%TYPE;
1687: l_progress VARCHAR2(300);
1688: l_binding_exception EXCEPTION;
1689: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
1690: l_notif_id NUMBER;

Line 1922: l_preparer_user_name WF_USERS.name%TYPE;

1918: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1919: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
1920: l_progress VARCHAR2(300);
1921: l_doc_string VARCHAR2(200);
1922: l_preparer_user_name WF_USERS.name%TYPE;
1923: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1924: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1925:
1926: BEGIN

Line 2048: l_preparer_user_name WF_USERS.name%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;
2049: l_progress VARCHAR2(300);
2050: l_binding_exception EXCEPTION;
2051: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
2052: l_notif_id NUMBER;

Line 2277: l_preparer_user_name WF_USERS.name%TYPE;

2273: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2274: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
2275: l_progress VARCHAR2(300);
2276: l_doc_string VARCHAR2(200);
2277: l_preparer_user_name WF_USERS.name%TYPE;
2278: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
2279: l_revision PO_HEADERS_ALL.revision_num%TYPE;
2280:
2281: BEGIN

Line 2390: l_preparer_user_name WF_USERS.name%TYPE;

2386: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2387: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2388: l_progress VARCHAR2(300);
2389: l_doc_string VARCHAR2(200);
2390: l_preparer_user_name WF_USERS.name%TYPE;
2391:
2392: BEGIN
2393:
2394: IF (g_po_wf_debug = 'Y') THEN

Line 2649: l_preparer_user_name WF_USERS.name%TYPE;

2645: resultout OUT NOCOPY VARCHAR2) IS
2646: l_notification_id NUMBER;
2647: l_progress VARCHAR2(300);
2648: l_doc_string VARCHAR2(200);
2649: l_preparer_user_name WF_USERS.name%TYPE;
2650:
2651: BEGIN
2652: IF (funcmode = 'RESPOND') THEN
2653: l_notification_id := WF_ENGINE.context_nid;

Line 2709: l_preparer_user_name WF_USERS.name%TYPE;

2705:
2706: l_notification_id NUMBER;
2707: l_progress VARCHAR2(300);
2708: l_doc_string VARCHAR2(200);
2709: l_preparer_user_name WF_USERS.name%TYPE;
2710: l_original_recipient WF_NOTIFICATIONS.original_recipient%type;
2711: l_contracting_officer po_headers_all.clm_contract_officer%TYPE;
2712: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2713: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;

Line 2821: l_preparer_user_name WF_USERS.name%TYPE;

2817:
2818: l_notification_id NUMBER;
2819: l_progress VARCHAR2(300);
2820: l_doc_string VARCHAR2(200);
2821: l_preparer_user_name WF_USERS.name%TYPE;
2822: l_original_recipient WF_NOTIFICATIONS.original_recipient%type;
2823: l_contracting_officer po_headers_all.clm_contract_officer%TYPE;
2824: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2825: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;

Line 4272: l_preparer_user_name WF_USERS.name%TYPE;

4268: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
4269: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;
4270: l_progress VARCHAR2(300);
4271: l_doc_string VARCHAR2(200);
4272: l_preparer_user_name WF_USERS.name%TYPE;
4273: l_is_doc_signed VARCHAR2(1);
4274:
4275: BEGIN
4276:

Line 4627: l_preparer_user_name WF_USERS.name%TYPE;

4623: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
4624: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
4625: l_progress VARCHAR2(300);
4626: l_doc_string VARCHAR2(200);
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;

Line 4792: l_preparer_user_name WF_USERS.name%TYPE;

4788: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
4789: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
4790: l_progress VARCHAR2(300);
4791: l_doc_string VARCHAR2(200);
4792: l_preparer_user_name WF_USERS.name%TYPE;
4793: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
4794: l_revision PO_HEADERS_ALL.revision_num%TYPE;
4795:
4796: BEGIN