DBA Data[Home] [Help]

APPS.PO_CONTERMS_WF_PVT dependencies on PO_DOCUMENT_TYPES_ALL_B

Line 314: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;

310: l_msg_data VARCHAR2(2000);
311: l_msg_count NUMBER;
312:
313: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
314: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
315: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
316: l_archived_conterms_flag PO_headers_all.conterms_exist_Flag%Type :='N';
317:
318: l_contracts_call_exception exception;

Line 315: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;

311: l_msg_count NUMBER;
312:
313: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
314: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
315: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
316: l_archived_conterms_flag PO_headers_all.conterms_exist_Flag%Type :='N';
317:
318: l_contracts_call_exception exception;
319: l_api_name VARCHAR2(100);

Line 804: l_po_doc_subtype PO_DOCUMENT_TYPES_ALL_B.DOCUMENT_SUBTYPE%TYPE;

800: x_msg_data OUT NOCOPY VARCHAR2,
801: x_msg_count OUT NOCOPY NUMBER) IS
802:
803: l_conterms_exist_flag PO_HEADERS_ALL.CONTERMS_EXIST_FLAG%TYPE;
804: l_po_doc_subtype PO_DOCUMENT_TYPES_ALL_B.DOCUMENT_SUBTYPE%TYPE;
805: l_po_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
806: l_event_tbl EVENT_TBL_TYPE;
807: l_k_api_name VARCHAR2(100);
808: l_cancel_flag PO_HEADERS_ALL.CANCEL_FLAG%TYPE;

Line 1245: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;

1241: result OUT NOCOPY VARCHAR2) IS
1242:
1243: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1244: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1245: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1246: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1247:
1248: l_return_status VARCHAR2(1);
1249: l_msg_data VARCHAR2(2000);

Line 1246: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;

1242:
1243: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1244: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1245: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1246: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1247:
1248: l_return_status VARCHAR2(1);
1249: l_msg_data VARCHAR2(2000);
1250: l_msg_count NUMBER;

Line 1395: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;

1391: result OUT NOCOPY VARCHAR2) IS
1392:
1393: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1394: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1395: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1396: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1397:
1398: l_return_status VARCHAR2(1);
1399: l_msg_data VARCHAR2(2000);

Line 1396: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;

1392:
1393: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1394: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1395: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1396: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1397:
1398: l_return_status VARCHAR2(1);
1399: l_msg_data VARCHAR2(2000);
1400: l_msg_count NUMBER;

Line 1546: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;

1542: result OUT NOCOPY VARCHAR2) IS
1543:
1544: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1545: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1546: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1547: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1548:
1549: l_return_status VARCHAR2(1);
1550: l_msg_data VARCHAR2(2000);

Line 1547: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;

1543:
1544: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1545: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1546: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1547: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1548:
1549: l_return_status VARCHAR2(1);
1550: l_msg_data VARCHAR2(2000);
1551: l_msg_count NUMBER;

Line 1698: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;

1694: result OUT NOCOPY VARCHAR2) IS
1695:
1696: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1697: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1698: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1699: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1700:
1701: l_return_status VARCHAR2(1);
1702: l_msg_data VARCHAR2(2000);

Line 1699: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;

1695:
1696: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1697: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1698: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1699: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1700:
1701: l_return_status VARCHAR2(1);
1702: l_msg_data VARCHAR2(2000);
1703: l_msg_count NUMBER;

Line 1853: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;

1849: result OUT NOCOPY VARCHAR2) IS
1850:
1851: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1852: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1853: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1854: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1855:
1856: l_return_status VARCHAR2(1);
1857: l_msg_data VARCHAR2(2000);

Line 1854: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;

1850:
1851: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1852: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1853: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1854: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1855:
1856: l_return_status VARCHAR2(1);
1857: l_msg_data VARCHAR2(2000);
1858: l_msg_count NUMBER;

Line 2009: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;

2005: result OUT NOCOPY VARCHAR2) IS
2006:
2007: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
2008: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
2009: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
2010: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
2011:
2012: l_return_status VARCHAR2(1);
2013: l_msg_data VARCHAR2(2000);

Line 2010: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;

2006:
2007: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
2008: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
2009: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
2010: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
2011:
2012: l_return_status VARCHAR2(1);
2013: l_msg_data VARCHAR2(2000);
2014: l_msg_count NUMBER;