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_HEADERS_ALL

Line 109: FROM PO_HEADERS_ALL

105:
106: IF g_CLOSEOUT_TYPE_INDIVIDUAL = p_closeout_type THEN
107: SELECT type_lookup_code,revision_num,clm_document_number,org_id,vendor_id, vendor_contact_id,vendor_site_id
108: INTO l_po_doc_type, l_rev_number, l_doc_num,l_org_id,l_vendor_id, l_vendor_contact_id,l_vendor_site_id
109: FROM PO_HEADERS_ALL
110: WHERE po_header_id = p_doc_id;
111:
112: l_progress := 10;
113: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_po_doc_type ' || l_po_doc_type);

Line 306: FROM PO_HEADERS_ALL

302:
303: IF g_CLOSEOUT_TYPE_INDIVIDUAL = p_closeout_type THEN
304: SELECT type_lookup_code,revision_num,clm_document_number
305: INTO l_po_doc_type, l_rev_number, l_doc_num
306: FROM PO_HEADERS_ALL
307: WHERE po_header_id = p_doc_id;
308:
309: l_progress := 10;
310: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_po_doc_type ' || l_po_doc_type);

Line 777: FROM PO_HEADERS_ALL

773: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);
774:
775: SELECT type_lookup_code,revision_num
776: INTO l_po_doc_type, l_rev_number
777: FROM PO_HEADERS_ALL
778: WHERE po_header_id = p_doc_id;
779:
780: l_progress := 10;
781:

Line 895: FROM po_headers_all

891: l_progress := 5;
892:
893: SELECT clm_document_number
894: INTO l_clm_doc_num
895: FROM po_headers_all
896: WHERE po_header_id = p_doc_id;
897:
898: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_clm_doc_num:' || l_clm_doc_num);
899:

Line 908: FROM PO_HEADERS_ALL

904: END IF;
905:
906: SELECT type_lookup_code
907: INTO l_type_lookup_code
908: FROM PO_HEADERS_ALL
909: WHERE po_header_id = p_doc_id;
910:
911: l_progress := 15;
912:

Line 1349: FROM PO_HEADERS_ALL

1345: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_doc_id ' || l_doc_id);
1346:
1347: SELECT type_lookup_code,revision_num,clm_document_number,org_id,vendor_id,vendor_contact_id,vendor_site_id
1348: INTO l_po_doc_type, l_rev_number, l_doc_num,l_org_id,l_vendor_id,l_vendor_contact_id,l_vendor_site_id
1349: FROM PO_HEADERS_ALL
1350: WHERE po_header_id = l_doc_id;
1351:
1352: l_progress := 5;
1353: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_po_doc_type ' || l_po_doc_type);

Line 1698: FROM po_headers_all

1694: x_result_type := c_result_type_SUCCESS;
1695: ELSE
1696: x_result_type := c_result_type_FAILURE;
1697: l_query := 'SELECT listagg(clm_document_number,'','') within GROUP (ORDER BY clm_document_number)
1698: FROM po_headers_all
1699: WHERE po_header_id IN (' || l_doc_ids || ')';
1700: EXECUTE IMMEDIATE l_query INTO x_failed_docs;
1701: END IF;
1702:

Line 1875: FROM po_headers_all

1871: l_progress := 32;
1872: begin
1873: SELECT clm_document_number
1874: INTO l_clm_doc_num
1875: FROM po_headers_all
1876: WHERE po_header_id = x_qa_result_tbl(i).Document_id;
1877: EXCEPTION
1878: WHEN No_Data_Found THEN
1879: l_clm_doc_num := '';

Line 1926: po_headers_all pha

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,
1926: po_headers_all pha
1927: WHERE pmmd.multi_mod_request_id = p_req_id
1928: AND pmmd.document_id = pha.po_header_id
1929: AND EXISTS (SELECT 'Open Mod Exists'
1930: FROM po_drafts dft

Line 1969: po_headers_all pha

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,
1969: po_headers_all pha
1970: WHERE pmmd.multi_mod_request_id = p_req_id
1971: AND pmmd.document_id = pha.po_header_id
1972: AND pha.type_lookup_code = 'STANDARD'
1973: AND EXISTS ( SELECT 1

Line 2009: po_headers_all pha

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,
2009: po_headers_all pha
2010: WHERE pmmd.multi_mod_request_id = p_req_id
2011: AND pmmd.document_id = pha.po_header_id
2012: AND pha.type_lookup_code = 'STANDARD'
2013: AND EXISTS (SELECT 1

Line 2048: FROM po_headers_all pha,

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
2048: FROM po_headers_all pha,
2049: po_multi_mod_docs pmmd
2050: WHERE pmmd.multi_mod_request_id = p_req_id
2051: AND pmmd.document_id = pha.po_header_id
2052: AND pha.type_lookup_code = 'STANDARD'

Line 2086: FROM po_headers_all pha,

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,
2087: po_multi_mod_docs pmmd
2088: WHERE pmmd.multi_mod_request_id = p_req_id
2089: AND pmmd.document_id = pha.po_header_id
2090: AND pha.type_lookup_code = 'STANDARD'

Line 2630: FROM PO_HEADERS_ALL

2626: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Contract exists ');
2627: IF g_CLOSEOUT_TYPE_INDIVIDUAL = p_closeout_type THEN
2628: SELECT type_lookup_code, clm_document_number
2629: INTO l_po_doc_type, l_doc_num
2630: FROM PO_HEADERS_ALL
2631: WHERE po_header_id = p_doc_id;
2632:
2633: l_progress := 30;
2634: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_po_doc_type ' || l_po_doc_type);

Line 2759: UPDATE po_headers_all

2755: aname => 'CLOSEOUT_STATUS');
2756:
2757: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_closeout_status ' || l_closeout_status);
2758:
2759: UPDATE po_headers_all
2760: SET clm_closeout_status = l_closeout_status
2761: WHERE po_header_id = l_document_id;
2762:
2763: l_progress := 11;

Line 2822: from po_headers_all

2818: l_progress := 15;
2819:
2820: select clm_document_number,type_lookup_code, Decode(type_lookup_code, 'STANDARD', 'PO', 'PA')
2821: into l_doc_num,l_doc_subtype,l_doc_type
2822: from po_headers_all
2823: where po_header_id = l_document_id;
2824:
2825: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_doc_num ' || l_doc_num);
2826: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_doc_subtype ' || l_doc_subtype);

Line 2854: FROM PO_HEADERS_ALL

2850: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'update query count ' || SQL%ROWCOUNT);
2851:
2852: SELECT type_lookup_code,revision_num, agent_id
2853: INTO l_po_doc_type, l_rev_number , l_agent_id
2854: FROM PO_HEADERS_ALL
2855: WHERE po_header_id = l_document_id;
2856: l_progress := 30;
2857:
2858: SELECT Max(sequence_num)

Line 3313: FROM PO_HEADERS_ALL

3309: aname => 'DOCUMENT_ID');
3310:
3311: SELECT type_lookup_code,revision_num,clm_document_number
3312: INTO l_po_doc_type, l_rev_number, l_doc_num
3313: FROM PO_HEADERS_ALL
3314: WHERE po_header_id = l_document_id;
3315:
3316: IF l_po_doc_type = 'STANDARD' THEN
3317: l_contr_type := 'PO_STANDARD';

Line 3508: FROM po_headers_all ph

3504: BEGIN
3505:
3506: SELECT 'Y'
3507: INTO l_is_physical_complete
3508: FROM po_headers_all ph
3509: WHERE ph.po_header_id = l_document_id
3510: AND ph.clm_closeout_status = 'PHYSICAL_COMPLETE';
3511:
3512: EXCEPTION WHEN No_Data_Found THEN

Line 3739: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

3735:
3736: l_msgbody VARCHAR2(32000);
3737: l_progress VARCHAR2(300);
3738:
3739: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
3740: l_item_type WF_ITEMS.item_type%TYPE;
3741: l_item_key WF_ITEMS.item_key%TYPE;
3742: l_firstcolon NUMBER;
3743: l_secondcolon NUMBER;

Line 3777: FROM PO_HEADERS_ALL PHA,

3773: l_vendor_name,
3774: l_buyer_id,
3775: l_admin_id
3776:
3777: FROM PO_HEADERS_ALL PHA,
3778: PO_VENDORS VO
3779: WHERE PHA.po_header_id = l_document_id
3780: AND PHA.vendor_id = VO.vendor_id;
3781:

Line 3872: l_clm_document_number PO_HEADERS_ALL.clm_document_number%TYPE;

3868: l_user_id NUMBER;
3869: l_resp_id NUMBER;
3870: l_appl_id NUMBER;
3871:
3872: l_clm_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
3873: l_doc_type_disp VARCHAR2(50);
3874: l_clm_closeout_status PO_HEADERS_ALL.clm_closeout_status%type;
3875:
3876: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'start_closeout_wf_process';

Line 3874: l_clm_closeout_status PO_HEADERS_ALL.clm_closeout_status%type;

3870: l_appl_id NUMBER;
3871:
3872: l_clm_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
3873: l_doc_type_disp VARCHAR2(50);
3874: l_clm_closeout_status PO_HEADERS_ALL.clm_closeout_status%type;
3875:
3876: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'start_closeout_wf_process';
3877: d_position NUMBER;
3878:

Line 3933: FROM PO_HEADERS_ALL PHA

3929: l_clm_document_number,
3930: l_admin_id,
3931: l_clm_closeout_status
3932:
3933: FROM PO_HEADERS_ALL PHA
3934: WHERE PHA.po_header_id = p_doc_id;
3935:
3936: l_doc_type_disp:= PO_DOC_STYLE_PVT.get_style_display_name(p_doc_id);
3937: