[Home] [Help]
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;
378: l_firstcolon NUMBER;
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
1426:
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:
1553: BEGIN
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;
1674: l_secondcolon NUMBER;
1673: l_firstcolon NUMBER;
1674: l_secondcolon NUMBER;
1675: l_amount NUMBER;
1676: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
1677: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1678: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1679: l_supplier_displayname WF_LOCAL_ROLES.display_name%TYPE;
1680: l_supplier_username WF_LOCAL_ROLES.name%TYPE;
1681: l_supplier_org PO_VENDORS.vendor_name%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
1927:
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;
2038: l_firstcolon NUMBER;
2038: l_firstcolon NUMBER;
2039: l_secondcolon NUMBER;
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;
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
2282:
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;
4632: l_return_status VARCHAR2(1);
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
4797: