APPS.PO_NEGOTIATIONS_SV1 dependencies on PO_HEADERS

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

1252:
1253: l_api_name CONSTANT varchar2(30) := 'RENEGOTIATE_BLANKET';
1254: l_api_version CONSTANT NUMBER := 1.0;
1255:
1256: l_po_num po_headers.segment1%type := NULL;
1257: l_interface_id NUMBER;
1258:
1259: l_create_api_result varchar2(30) :=NULL;
1260: l_create_api_err_code varchar2(100) := NULL;

Line 1270: l_po_created_language PO_HEADERS_ALL.created_language%TYPE;

1266: l_progress varchar2(3);
1267: l_user_id NUMBER := -1;
1268:
1269: --
1270: l_po_created_language PO_HEADERS_ALL.created_language%TYPE;
1271:
1272: --
1273: BEGIN
1274: l_progress := '000';

Line 1365: from po_headers

1361: 'PO',
1362: style_id, -- BUG#5532470
1363: created_language, --Bug#4911361
1364: vendor_site_id --
1365: from po_headers
1366: where po_header_id=p_po_header_id;
1367:
1368: l_progress := '002';
1369:

Line 1379: from po_headers

1375: l_progress := '003';
1376: -- Get the segment1 from p_po_header_id
1377: select segment1
1378: into l_po_num
1379: from po_headers
1380: where po_header_id = p_po_header_id;
1381:
1382:
1383: l_progress := '004';

Line 1469: FROM po_headers_all

1465: --
1466: --call API to insert descriptor values for each PO line
1467:
1468: SELECT created_language into l_po_created_language
1469: FROM po_headers_all
1470: WHERE po_header_id = p_po_header_id;
1471:
1472: PO_ATTRIBUTE_VALUES_PVT.handle_attributes(p_interface_header_id => l_interface_id,
1473: p_po_header_id => p_po_header_id,

Line 1630: fad.entity_name = 'PO_HEADERS' AND

1626: fnd_documents_tl fdtl
1627: where fad.document_id = fd.document_id AND
1628: fd.document_id = fdtl.document_id AND
1629: fdtl.language = userenv('LANG') AND
1630: fad.entity_name = 'PO_HEADERS' AND
1631: fad.pk1_value = p_po_header_id AND
1632: fd.category_id <> 39;
1633:
1634: l_progress := '008';