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;
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);
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;
1260: result OUT NOCOPY VARCHAR2) IS
1261:
1262: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1263: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1264: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1265: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1266:
1267: l_return_status VARCHAR2(1);
1268: l_msg_data VARCHAR2(2000);
1261:
1262: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1263: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1264: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1265: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1266:
1267: l_return_status VARCHAR2(1);
1268: l_msg_data VARCHAR2(2000);
1269: l_msg_count NUMBER;
1410: result OUT NOCOPY VARCHAR2) IS
1411:
1412: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1413: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1414: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1415: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1416:
1417: l_return_status VARCHAR2(1);
1418: l_msg_data VARCHAR2(2000);
1411:
1412: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1413: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1414: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1415: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1416:
1417: l_return_status VARCHAR2(1);
1418: l_msg_data VARCHAR2(2000);
1419: l_msg_count NUMBER;
1561: result OUT NOCOPY VARCHAR2) IS
1562:
1563: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1564: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1565: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1566: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1567:
1568: l_return_status VARCHAR2(1);
1569: l_msg_data VARCHAR2(2000);
1562:
1563: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1564: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1565: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1566: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1567:
1568: l_return_status VARCHAR2(1);
1569: l_msg_data VARCHAR2(2000);
1570: l_msg_count NUMBER;
1713: result OUT NOCOPY VARCHAR2) IS
1714:
1715: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1716: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1717: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1718: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1719:
1720: l_return_status VARCHAR2(1);
1721: l_msg_data VARCHAR2(2000);
1714:
1715: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1716: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1717: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1718: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1719:
1720: l_return_status VARCHAR2(1);
1721: l_msg_data VARCHAR2(2000);
1722: l_msg_count NUMBER;
1868: result OUT NOCOPY VARCHAR2) IS
1869:
1870: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1871: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1872: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1873: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1874:
1875: l_return_status VARCHAR2(1);
1876: l_msg_data VARCHAR2(2000);
1869:
1870: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1871: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1872: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1873: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1874:
1875: l_return_status VARCHAR2(1);
1876: l_msg_data VARCHAR2(2000);
1877: l_msg_count NUMBER;
2024: result OUT NOCOPY VARCHAR2) IS
2025:
2026: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
2027: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
2028: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
2029: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
2030:
2031: l_return_status VARCHAR2(1);
2032: l_msg_data VARCHAR2(2000);
2025:
2026: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
2027: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
2028: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
2029: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
2030:
2031: l_return_status VARCHAR2(1);
2032: l_msg_data VARCHAR2(2000);
2033: l_msg_count NUMBER;