APPS.PO_WF_PO_NOTIFICATION dependencies on PO_HEADERS

Line 15: l_document_id po_headers.po_header_id%TYPE;

11:
12: l_item_type wf_items.item_type%TYPE;
13: l_item_key wf_items.item_key%TYPE;
14:
15: l_document_id po_headers.po_header_id%TYPE;
16: l_org_id po_headers.org_id%TYPE;
17: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
18: l_header_msg VARCHAR2(500);
19: l_po_amount VARCHAR2(30);

Line 16: l_org_id po_headers.org_id%TYPE;

12: l_item_type wf_items.item_type%TYPE;
13: l_item_key wf_items.item_key%TYPE;
14:
15: l_document_id po_headers.po_header_id%TYPE;
16: l_org_id po_headers.org_id%TYPE;
17: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
18: l_header_msg VARCHAR2(500);
19: l_po_amount VARCHAR2(30);
20: l_tax_amount VARCHAR2(30);

Line 21: l_description po_headers.comments%TYPE;

17: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
18: l_header_msg VARCHAR2(500);
19: l_po_amount VARCHAR2(30);
20: l_tax_amount VARCHAR2(30);
21: l_description po_headers.comments%TYPE;
22: l_forwarded_from per_all_people_f.full_name%TYPE;
23: l_preparer per_all_people_f.full_name%TYPE;
24: --
25: -- l_note VARCHAR2(480); /* < UTF8 FPI - changed from VARCHAR2(240) > */

Line 1568: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;

1564: l_notification_type varchar2(15); --bug 3668188
1565:
1566: --
1567: l_okc_doc_type varchar2(20);
1568: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
1569: l_document_id NUMBER;
1570: l_document_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
1571: --
1572:

Line 1570: l_document_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

1566: --
1567: l_okc_doc_type varchar2(20);
1568: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
1569: l_document_id NUMBER;
1570: l_document_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
1571: --
1572:
1573: BEGIN
1574:

Line 1774: l_document_id PO_HEADERS_ALL.po_header_id%TYPE; --

1770: from po_document_types
1771: where document_type_code = p_doc_type
1772: and document_subtype = p_doc_subtype;
1773:
1774: l_document_id PO_HEADERS_ALL.po_header_id%TYPE; --
1775:
1776: BEGIN
1777: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 001, user name: '
1778: || username;

Line 1937: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;

1933: l_api_name VARCHAR2(30) := 'is_open_document_allowed';
1934: l_log_head VARCHAR2(100) := g_pkg_name||'.'||l_api_name;
1935: l_progress VARCHAR2(3);
1936:
1937: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;
1938: l_result BOOLEAN := TRUE;
1939:
1940: BEGIN
1941: