eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CLOSEOUT_PVT dependencies on PO_TBL_NUMBER

Line 1666: p_selected_docs IN PO_TBL_NUMBER

1662: --End of Comments
1663: --------------------------------------------------------------------------------
1664:
1665: PROCEDURE mass_closeout_validate_set (
1666: p_selected_docs IN PO_TBL_NUMBER
1667: , x_failed_docs OUT NOCOPY VARCHAR2
1668: , x_result_type OUT NOCOPY VARCHAR2
1669: )
1670: AS

Line 1752: l_document_id_tbl PO_TBL_NUMBER;

1748: x_return_status VARCHAR2(20);
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);

Line 1754: l_mod_doc_id_tbl PO_TBL_NUMBER;

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);
1758: l_fail_count NUMBER := 0;

Line 1919: l_document_id_tbl := NEW po_tbl_number();

1915: fnd_file.put_line(FND_FILE.LOG,'Contract Deliverables validation is completed ' || l_module_status);
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

Line 1921: l_mod_doc_id_tbl := NEW po_tbl_number();

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
1925: FROM po_multi_mod_docs pmmd,

Line 1962: l_document_id_tbl := NEW po_tbl_number();

1958: fnd_file.put_line(FND_FILE.LOG,'Open modifications validation is completed ' || l_module_status);
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

Line 1964: l_mod_doc_id_tbl := NEW po_tbl_number();

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
1968: FROM po_multi_mod_docs pmmd,

Line 2002: l_document_id_tbl := NEW po_tbl_number();

1998: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Fully received validation is completed ' || l_module_status);
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

Line 2004: l_mod_doc_id_tbl := NEW po_tbl_number();

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
2008: FROM po_multi_mod_docs pmmd,

Line 2041: l_document_id_tbl := NEW po_tbl_number();

2037: fnd_file.put_line(FND_FILE.LOG,'Fully invoiced validation is completed ' || l_module_status);
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 := '';

Line 2043: l_mod_doc_id_tbl := NEW po_tbl_number();

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
2047: BULK COLLECT INTO l_document_id_tbl,l_document_num_tbl,l_mod_doc_id_tbl

Line 2080: l_document_id_tbl := NEW po_tbl_number();

2076: END IF;
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

Line 2082: l_mod_doc_id_tbl := NEW po_tbl_number();

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
2086: FROM po_headers_all pha,

Line 2182: l_tot_amt_tbl PO_TBL_NUMBER;

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;
2182: l_tot_amt_tbl PO_TBL_NUMBER;
2183: l_doc_curr_tbl PO_TBL_VARCHAR15;
2184: l_messages VARCHAR2(4000);
2185: p_orig_system VARCHAR2(100);
2186: l_username VARCHAR2(240);

Line 2226: l_tot_amt_tbl := NEW PO_TBL_NUMBER();

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();
2226: l_tot_amt_tbl := NEW PO_TBL_NUMBER();
2227: l_doc_curr_tbl := NEW PO_TBL_VARCHAR15();
2228:
2229: l_messages := ' ';
2230: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'processing started for admin ' || l_admin_id);