APPS.PO_WF_PO_NOTIFICATION dependencies on PO_HEADERS_ALL

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: