APPS.PO_NEGOTIATIONS_SV1 dependencies on PO_HEADERS

Line 1794: l_po_num po_headers.segment1%type := NULL;

1790:
1791: l_api_name CONSTANT varchar2(30) := 'RENEGOTIATE_BLANKET';
1792: l_api_version CONSTANT NUMBER := 1.0;
1793:
1794: l_po_num po_headers.segment1%type := NULL;
1795: l_interface_id NUMBER;
1796:
1797: l_create_api_result varchar2(30) :=NULL;
1798: l_create_api_err_code varchar2(100) := NULL;

Line 1812: l_po_created_language PO_HEADERS_ALL.created_language%TYPE;

1808: l_error_code VARCHAR2(100);
1809: l_error_message VARCHAR2(1000);
1810:
1811: --
1812: l_po_created_language PO_HEADERS_ALL.created_language%TYPE;
1813:
1814: --
1815: BEGIN
1816: l_progress := '000';

Line 1907: from po_headers

1903: 'PO',
1904: style_id, -- BUG#5532470
1905: created_language, --Bug#4911361
1906: vendor_site_id --
1907: from po_headers
1908: where po_header_id=p_po_header_id;
1909:
1910: l_progress := '002';
1911:

Line 1921: from po_headers

1917: l_progress := '003';
1918: -- Get the segment1 from p_po_header_id
1919: select segment1
1920: into l_po_num
1921: from po_headers
1922: where po_header_id = p_po_header_id;
1923:
1924:
1925: l_progress := '004';

Line 2040: FROM po_headers_all

2036: --
2037: --call API to insert descriptor values for each PO line
2038:
2039: SELECT created_language into l_po_created_language
2040: FROM po_headers_all
2041: WHERE po_header_id = p_po_header_id;
2042:
2043: PO_ATTRIBUTE_VALUES_PVT.handle_attributes(p_interface_header_id => l_interface_id,
2044: p_po_header_id => p_po_header_id,

Line 2212: fad.entity_name = 'PO_HEADERS' AND

2208: fnd_documents_tl fdtl
2209: where fad.document_id = fd.document_id AND
2210: fd.document_id = fdtl.document_id AND
2211: fdtl.language = userenv('LANG') AND
2212: fad.entity_name = 'PO_HEADERS' AND
2213: fad.pk1_value = to_char(p_po_header_id) AND
2214: fd.category_id <> 39;
2215:
2216: l_progress := '008';