APPS.PO_DOCUMENT_CHECKS_GRP dependencies on PO_LINES_ALL

Line 1298: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,

1294: -------------------------------------------------------------------------------
1295: PROCEDURE check_std_po_price_updateable (
1296: p_api_version IN NUMBER,
1297: x_return_status OUT NOCOPY VARCHAR2,
1298: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
1299: p_from_price_break IN VARCHAR2,
1300: p_add_reasons_to_msg_list IN VARCHAR2,
1301: x_price_updateable OUT NOCOPY VARCHAR2,
1302: x_retroactive_price_change OUT NOCOPY VARCHAR2

Line 1310: l_allow_price_override PO_LINES_ALL.allow_price_override_flag%TYPE;

1306: l_api_version CONSTANT NUMBER := 1.0;
1307: l_progress VARCHAR2(3) := '000';
1308:
1309: l_has_ga_ref PO_HEADERS_ALL.global_agreement_flag%TYPE;
1310: l_allow_price_override PO_LINES_ALL.allow_price_override_flag%TYPE;
1311: l_accrue_invoice_count NUMBER;
1312: l_pending_rcv_transactions NUMBER;
1313: l_archive_mode_std_po PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;
1314: l_current_org_id NUMBER;

Line 1345: FROM po_lines_all pol

1341:
1342: --
1343: SELECT pol.po_header_id
1344: INTO l_po_header_id
1345: FROM po_lines_all pol
1346: WHERE pol.po_line_id = p_po_line_id;
1347:
1348: l_is_complex_work_po := PO_COMPLEX_WORK_PVT.is_complex_work_po(
1349: p_po_header_id => l_po_header_id);

Line 1361: FROM po_lines_all POL,

1357: SELECT NVL(REFH.global_agreement_flag, 'N'),
1358: NVL(REFL.allow_price_override_flag, 'N')
1359: INTO l_has_ga_ref,
1360: l_allow_price_override
1361: FROM po_lines_all POL,
1362: po_headers_all REFH,
1363: po_lines_all REFL
1364: WHERE POL.po_line_id = p_po_line_id
1365: AND REFH.po_header_id (+) = POL.from_header_id -- JOIN

Line 1363: po_lines_all REFL

1359: INTO l_has_ga_ref,
1360: l_allow_price_override
1361: FROM po_lines_all POL,
1362: po_headers_all REFH,
1363: po_lines_all REFL
1364: WHERE POL.po_line_id = p_po_line_id
1365: AND REFH.po_header_id (+) = POL.from_header_id -- JOIN
1366: AND REFL.po_line_id (+) = POL.from_line_id; -- JOIN
1367:

Line 1582: l_allow_price_override PO_LINES_ALL.allow_price_override_flag%TYPE;

1578: l_log_head CONSTANT VARCHAR2(100):= g_log_head || l_api_name;
1579: l_api_version CONSTANT NUMBER := 1.0;
1580: l_progress VARCHAR2(3) := '000';
1581:
1582: l_allow_price_override PO_LINES_ALL.allow_price_override_flag%TYPE;
1583: l_qty_received PO_LINE_LOCATIONS.quantity_received%TYPE;
1584: l_accrue_flag PO_LINE_LOCATIONS.accrue_on_receipt_flag%TYPE;
1585: l_qty_billed PO_LINE_LOCATIONS.quantity_billed%TYPE;
1586: l_pending_rcv_transactions NUMBER;

Line 1624: po_lines_all POL

1620: l_accrue_flag,
1621: l_qty_billed,
1622: l_allow_price_override
1623: FROM po_line_locations_all PLL,
1624: po_lines_all POL
1625: WHERE PLL.line_location_id = p_line_location_id
1626: AND PLL.po_line_id = POL.po_line_id; -- JOIN
1627:
1628: -- Bug 3565522 : get the archive mode