DBA Data[Home] [Help]

APPS.PO_SIGNATURE_PVT dependencies on FND_NEW_MESSAGES

Line 301: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;

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;
305: l_firstcolon NUMBER;

Line 1118: l_doc_display_name FND_NEW_MESSAGES.message_text%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
1122:

Line 1225: l_doc_display_name FND_NEW_MESSAGES.message_text%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
1229:

Line 1327: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;

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;
1331: l_secondcolon NUMBER;

Line 1334: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;

1330: l_firstcolon NUMBER;
1331: l_secondcolon NUMBER;
1332: l_amount NUMBER;
1333: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1334: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1335: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1336: l_supplier_displayname WF_LOCAL_ROLES.display_name%TYPE;
1337: l_supplier_username WF_LOCAL_ROLES.name%TYPE;
1338: l_supplier_org PO_VENDORS.vendor_name%TYPE;

Line 1579: l_doc_display_name FND_NEW_MESSAGES.message_text%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
1583:

Line 1683: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;

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;
1687: l_firstcolon NUMBER;

Line 1691: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;

1687: l_firstcolon NUMBER;
1688: l_secondcolon NUMBER;
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;

Line 1927: l_doc_display_name FND_NEW_MESSAGES.message_text%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
1931: