DBA Data[Home] [Help]

APPS.OKC_OC_INT_PRICING_PVT dependencies on OKX_ORDER_HEADERS_V

Line 148: FROM okx_order_headers_v

144: -- cursor to retrieve the order number against a given order id
145: -- this cursor is used to include the order number in error messages
146: CURSOR c_onumber (c_o_id NUMBER) IS
147: SELECT TO_CHAR(order_number)
148: FROM okx_order_headers_v
149: WHERE id1 = c_o_id;
150:
151: -- cursor to retrieve the quote number against a given quote id
152: -- this cursor is used to include the quote number in error messages

Line 4843: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE ,

4839: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type ,
4840: p_qle_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type ,
4841: --
4842: p_o_flag IN VARCHAR2 ,
4843: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE ,
4844: p_ole_tab IN ASO_QUOTE_PUB.qte_line_tbl_type ,
4845: p_ole_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type ,
4846: --
4847: x_hd_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,