DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_DOCUMENT_TYPES

Line 12463: l_access_level PO_DOCUMENT_TYPES.access_level_code%TYPE;

12459:
12460: l_api_name CONSTANT varchar2(30) := 'PO_SECURITY_CHECK';
12461: l_api_version CONSTANT NUMBER := 1.0;
12462: l_progress VARCHAR2(3);
12463: l_access_level PO_DOCUMENT_TYPES.access_level_code%TYPE;
12464: l_security_level PO_DOCUMENT_TYPES.security_level_code%TYPE;
12465: l_security_hierarchy NUMBER;
12466: l_id_column varchar2(30);
12467: l_doctype_column varchar2(30); /*Bug 7229262/7239696*/

Line 12464: l_security_level PO_DOCUMENT_TYPES.security_level_code%TYPE;

12460: l_api_name CONSTANT varchar2(30) := 'PO_SECURITY_CHECK';
12461: l_api_version CONSTANT NUMBER := 1.0;
12462: l_progress VARCHAR2(3);
12463: l_access_level PO_DOCUMENT_TYPES.access_level_code%TYPE;
12464: l_security_level PO_DOCUMENT_TYPES.security_level_code%TYPE;
12465: l_security_hierarchy NUMBER;
12466: l_id_column varchar2(30);
12467: l_doctype_column varchar2(30); /*Bug 7229262/7239696*/
12468:

Line 12691: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

12687:
12688: l_api_name CONSTANT VARCHAR(30) := 'CHECK_UPDATABLE';
12689: l_progress VARCHAR2(3) := '000';
12690: l_document_id PO_HEADERS.po_header_id%TYPE;
12691: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
12692:
12693: -- bug3592160 START
12694: l_header_id PO_TBL_NUMBER;
12695: l_procedure_id PO_SESSION_GT.key%TYPE;

Line 12925: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

12921:
12922: l_api_name CONSTANT VARCHAR(30) := 'check_reservable';
12923: l_progress VARCHAR2(3) := '000';
12924: l_document_id PO_HEADERS.po_header_id%TYPE;
12925: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
12926:
12927: -- bug3592160 START
12928: l_header_id PO_TBL_NUMBER;
12929: l_procedure_id PO_SESSION_GT.key%TYPE;

Line 13098: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

13094:
13095: l_api_name CONSTANT VARCHAR(30) := 'check_unreservable';
13096: l_progress VARCHAR2(3) := '000';
13097: l_document_id PO_HEADERS.po_header_id%TYPE;
13098: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
13099:
13100: -- bug3592160 START
13101: l_header_id PO_TBL_NUMBER;
13102: l_procedure_id PO_SESSION_GT.key%TYPE;