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 1264: l_po_doc_type PO_Document_Types_all_B.Document_type_code%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);

Line 1265: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;

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;

Line 1414: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;

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);

Line 1415: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;

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;

Line 1565: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;

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);

Line 1566: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;

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;

Line 1717: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;

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);

Line 1718: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;

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;

Line 1872: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;

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);

Line 1873: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;

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;

Line 2028: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;

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);

Line 2029: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;

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;