APPS.PO_CLOSEOUT_PVT dependencies on PO_TBL_VARCHAR100

Line 1753: l_document_num_tbl PO_TBL_VARCHAR100;

1749: x_qa_return_status VARCHAR2(20);
1750: x_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
1751: l_clm_doc_num VARCHAR2(100);
1752: l_document_id_tbl PO_TBL_NUMBER;
1753: l_document_num_tbl PO_TBL_VARCHAR100;
1754: l_mod_doc_id_tbl PO_TBL_NUMBER;
1755: l_doc_id NUMBER;
1756: l_excep_type VARCHAR2(50);
1757: l_result_type VARCHAR2(100);

Line 1920: l_document_num_tbl := NEW po_tbl_varchar100();

1916: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Contract Deliverables validation is completed ' || l_module_status);
1917:
1918:
1919: l_document_id_tbl := NEW po_tbl_number();
1920: l_document_num_tbl := NEW po_tbl_varchar100();
1921: l_mod_doc_id_tbl := NEW po_tbl_number();
1922:
1923: SELECT pha.po_header_id,pha.clm_document_number, pmmd.multi_mod_doc_id
1924: BULK COLLECT INTO l_document_id_tbl,l_document_num_tbl,l_mod_doc_id_tbl

Line 1963: l_document_num_tbl := NEW po_tbl_varchar100();

1959: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Open modifications validation is completed ' || l_module_status);
1960: l_progress := 45;
1961:
1962: l_document_id_tbl := NEW po_tbl_number();
1963: l_document_num_tbl := NEW po_tbl_varchar100();
1964: l_mod_doc_id_tbl := NEW po_tbl_number();
1965:
1966: SELECT DISTINCT pha.po_header_id,pha.clm_document_number,pmmd.multi_mod_doc_id
1967: BULK COLLECT INTO l_document_id_tbl,l_document_num_tbl,l_mod_doc_id_tbl

Line 2003: l_document_num_tbl := NEW po_tbl_varchar100();

1999:
2000: l_progress := 60;
2001:
2002: l_document_id_tbl := NEW po_tbl_number();
2003: l_document_num_tbl := NEW po_tbl_varchar100();
2004: l_mod_doc_id_tbl := NEW po_tbl_number();
2005:
2006: SELECT DISTINCT pha.po_header_id,pha.clm_document_number,pmmd.multi_mod_doc_id
2007: BULK COLLECT INTO l_document_id_tbl,l_document_num_tbl,l_mod_doc_id_tbl

Line 2042: l_document_num_tbl := NEW po_tbl_varchar100();

2038: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Fully invoiced validation is completed ' || l_module_status);
2039: l_progress := 80;
2040:
2041: l_document_id_tbl := NEW po_tbl_number();
2042: l_document_num_tbl := NEW po_tbl_varchar100();
2043: l_mod_doc_id_tbl := NEW po_tbl_number();
2044:
2045: l_module_status := '';
2046: SELECT DISTINCT pha.po_header_id,pha.clm_document_number,pmmd.multi_mod_doc_id

Line 2081: l_document_num_tbl := NEW po_tbl_varchar100();

2077:
2078: l_progress := 85;
2079:
2080: l_document_id_tbl := NEW po_tbl_number();
2081: l_document_num_tbl := NEW po_tbl_varchar100();
2082: l_mod_doc_id_tbl := NEW po_tbl_number();
2083:
2084: SELECT DISTINCT pha.po_header_id,pha.clm_document_number,pmmd.multi_mod_doc_id
2085: BULK COLLECT INTO l_document_id_tbl,l_document_num_tbl,l_mod_doc_id_tbl

Line 2177: l_doc_num_tbl PO_TBL_VARCHAR100;

2173: )
2174: AS
2175: l_progress NUMBER := 0;
2176: l_admin_id NUMBER;
2177: l_doc_num_tbl PO_TBL_VARCHAR100;
2178: l_comments_tbl PO_TBL_VARCHAR240;
2179: l_doc_type_tbl PO_TBL_VARCHAR25;
2180: l_doc_status_tbl PO_TBL_VARCHAR25;
2181: l_supplier_tbl PO_TBL_VARCHAR240;

Line 2221: l_doc_num_tbl := NEW po_tbl_varchar100();

2217: LOOP
2218: FETCH clmAwardAdmins INTO l_admin_id;
2219: EXIT WHEN clmAwardAdmins%NOTFOUND;
2220:
2221: l_doc_num_tbl := NEW po_tbl_varchar100();
2222: l_comments_tbl := NEW PO_TBL_VARCHAR240();
2223: l_doc_type_tbl := NEW PO_TBL_VARCHAR25();
2224: l_doc_status_tbl := NEW PO_TBL_VARCHAR25();
2225: l_supplier_tbl := NEW PO_TBL_VARCHAR240();