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 311: l_preparer_user_name WF_USERS.name%TYPE;

307: l_amount NUMBER;
308: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
309: l_orgid PO_HEADERS_ALL.org_id%TYPE;
310: l_doc_string VARCHAR2(200);
311: l_preparer_user_name WF_USERS.name%TYPE;
312: l_progress VARCHAR2(300);
313: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;
314: l_binding_exception EXCEPTION;
315: /* Added for the bug 6358219 to fetch the legal_entity name */

Line 523: l_preparer_user_name WF_USERS.name%TYPE;

519: l_msg_count NUMBER;
520: l_msg_data VARCHAR2(2000);
521: l_progress VARCHAR2(300);
522: l_doc_string VARCHAR2(200);
523: l_preparer_user_name WF_USERS.name%TYPE;
524: l_trans_status VARCHAR2(10);
525: l_response_code FND_LOOKUP_VALUES.meaning%TYPE;
526: l_reason_code FND_LOOKUP_VALUES.meaning%TYPE;
527: l_signer_type FND_LOOKUP_VALUES.meaning%TYPE;

Line 814: l_preparer_user_name WF_USERS.name%TYPE;

810: l_last_update_login PO_ACCEPTANCES.last_update_login%TYPE;
811: l_rowid ROWID;
812: l_progress VARCHAR2(300);
813: l_doc_string VARCHAR2(200);
814: l_preparer_user_name WF_USERS.name%TYPE;
815: l_result VARCHAR2(1);
816: l_po_itemtype WF_ITEMS.item_type%TYPE;
817: l_po_itemkey WF_ITEMS.item_key%TYPE;
818: l_response_code FND_LOOKUP_VALUES.meaning%TYPE;

Line 1117: l_preparer_user_name WF_USERS.name%TYPE;

1113: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1114: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1115: l_progress VARCHAR2(300);
1116: l_doc_string VARCHAR2(200);
1117: l_preparer_user_name WF_USERS.name%TYPE;
1118: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1119: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1120:
1121: BEGIN

Line 1224: l_preparer_user_name WF_USERS.name%TYPE;

1220: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1221: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1222: l_progress VARCHAR2(300);
1223: l_doc_string VARCHAR2(200);
1224: l_preparer_user_name WF_USERS.name%TYPE;
1225: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1226: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1227:
1228: BEGIN

Line 1343: l_preparer_user_name WF_USERS.name%TYPE;

1339: l_supplier_userid WF_LOCAL_ROLES.orig_system_id%TYPE;
1340: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
1341: l_orgid PO_HEADERS_ALL.org_id%TYPE;
1342: l_doc_string VARCHAR2(200);
1343: l_preparer_user_name WF_USERS.name%TYPE;
1344: l_progress VARCHAR2(300);
1345: l_binding_exception EXCEPTION;
1346: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
1347: l_notif_id NUMBER;

Line 1578: l_preparer_user_name WF_USERS.name%TYPE;

1574: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1575: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1576: l_progress VARCHAR2(300);
1577: l_doc_string VARCHAR2(200);
1578: l_preparer_user_name WF_USERS.name%TYPE;
1579: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1580: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1581:
1582: BEGIN

Line 1697: l_preparer_user_name WF_USERS.name%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;
1698: l_progress VARCHAR2(300);
1699: l_binding_exception EXCEPTION;
1700: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
1701: l_notif_id NUMBER;

Line 1926: l_preparer_user_name WF_USERS.name%TYPE;

1922: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1923: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1924: l_progress VARCHAR2(300);
1925: l_doc_string VARCHAR2(200);
1926: l_preparer_user_name WF_USERS.name%TYPE;
1927: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1928: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1929:
1930: BEGIN

Line 2032: l_preparer_user_name WF_USERS.name%TYPE;

2028: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2029: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2030: l_progress VARCHAR2(300);
2031: l_doc_string VARCHAR2(200);
2032: l_preparer_user_name WF_USERS.name%TYPE;
2033:
2034: BEGIN
2035:
2036: IF (g_po_wf_debug = 'Y') THEN

Line 2262: l_preparer_user_name WF_USERS.name%TYPE;

2258: resultout OUT NOCOPY VARCHAR2) IS
2259: l_notification_id NUMBER;
2260: l_progress VARCHAR2(300);
2261: l_doc_string VARCHAR2(200);
2262: l_preparer_user_name WF_USERS.name%TYPE;
2263:
2264: BEGIN
2265: IF (funcmode = 'RESPOND') THEN
2266: l_notification_id := WF_ENGINE.context_nid;

Line 2322: l_preparer_user_name WF_USERS.name%TYPE;

2318:
2319: l_notification_id NUMBER;
2320: l_progress VARCHAR2(300);
2321: l_doc_string VARCHAR2(200);
2322: l_preparer_user_name WF_USERS.name%TYPE;
2323:
2324: BEGIN
2325:
2326: IF (funcmode = 'RESPOND') THEN