DBA Data[Home] [Help]

APPS.AHL_OSP_PO_PVT dependencies on PO_HEADERS_INTERFACE_S

Line 1729: SELECT PO_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;

1725: -- Instead, hard code it to the OSP Order Id
1726: l_batch_id := p_po_header_rec.OSP_ORDER_ID;
1727:
1728: -- Generate PO Header Id
1729: SELECT PO_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;
1730:
1731: -- Description
1732: OPEN l_get_osp_order_dtls_csr(p_po_header_rec.OSP_ORDER_ID);
1733: FETCH l_get_osp_order_dtls_csr INTO l_temp_n, l_OSP_description;