APPS.PO_DOCUMENT_CHECKS_GRP dependencies on PO_LINES_ALL

Line 1308: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,

1304: -------------------------------------------------------------------------------
1305: PROCEDURE check_std_po_price_updateable (
1306: p_api_version IN NUMBER,
1307: x_return_status OUT NOCOPY VARCHAR2,
1308: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
1309: p_from_price_break IN VARCHAR2,
1310: p_add_reasons_to_msg_list IN VARCHAR2,
1311: x_price_updateable OUT NOCOPY VARCHAR2,
1312: x_retroactive_price_change OUT NOCOPY VARCHAR2

Line 1320: l_allow_price_override PO_LINES_ALL.allow_price_override_flag%TYPE;

1316: l_api_version CONSTANT NUMBER := 1.0;
1317: l_progress VARCHAR2(3) := '000';
1318:
1319: l_has_ga_ref PO_HEADERS_ALL.global_agreement_flag%TYPE;
1320: l_allow_price_override PO_LINES_ALL.allow_price_override_flag%TYPE;
1321: l_accrue_invoice_count NUMBER;
1322: l_pending_rcv_transactions NUMBER;
1323: l_archive_mode_std_po PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;
1324: l_current_org_id NUMBER;

Line 1355: FROM po_lines_all pol

1351:
1352: --
1353: SELECT pol.po_header_id
1354: INTO l_po_header_id
1355: FROM po_lines_all pol
1356: WHERE pol.po_line_id = p_po_line_id;
1357:
1358: l_is_complex_work_po := PO_COMPLEX_WORK_PVT.is_complex_work_po(
1359: p_po_header_id => l_po_header_id);

Line 1371: FROM po_lines_all POL,

1367: SELECT NVL(REFH.global_agreement_flag, 'N'),
1368: NVL(REFL.allow_price_override_flag, 'N')
1369: INTO l_has_ga_ref,
1370: l_allow_price_override
1371: FROM po_lines_all POL,
1372: po_headers_all REFH,
1373: po_lines_all REFL
1374: WHERE POL.po_line_id = p_po_line_id
1375: AND REFH.po_header_id (+) = POL.from_header_id -- JOIN

Line 1373: po_lines_all REFL

1369: INTO l_has_ga_ref,
1370: l_allow_price_override
1371: FROM po_lines_all POL,
1372: po_headers_all REFH,
1373: po_lines_all REFL
1374: WHERE POL.po_line_id = p_po_line_id
1375: AND REFH.po_header_id (+) = POL.from_header_id -- JOIN
1376: AND REFL.po_line_id (+) = POL.from_line_id; -- JOIN
1377:

Line 1592: l_allow_price_override PO_LINES_ALL.allow_price_override_flag%TYPE;

1588: l_log_head CONSTANT VARCHAR2(100):= g_log_head || l_api_name;
1589: l_api_version CONSTANT NUMBER := 1.0;
1590: l_progress VARCHAR2(3) := '000';
1591:
1592: l_allow_price_override PO_LINES_ALL.allow_price_override_flag%TYPE;
1593: l_qty_received PO_LINE_LOCATIONS.quantity_received%TYPE;
1594: l_accrue_flag PO_LINE_LOCATIONS.accrue_on_receipt_flag%TYPE;
1595: l_qty_billed PO_LINE_LOCATIONS.quantity_billed%TYPE;
1596: l_pending_rcv_transactions NUMBER;

Line 1634: po_lines_all POL

1630: l_accrue_flag,
1631: l_qty_billed,
1632: l_allow_price_override
1633: FROM po_line_locations_all PLL,
1634: po_lines_all POL
1635: WHERE PLL.line_location_id = p_line_location_id
1636: AND PLL.po_line_id = POL.po_line_id; -- JOIN
1637:
1638: -- Bug 3565522 : get the archive mode