DBA Data[Home] [Help]

APPS.OKC_OC_INT_SALESCDT_PVT dependencies on OKX_ORDER_HEADERS_V

Line 68: FROM okx_order_headers_v

64: -- cursor to retrieve the order number against a given order id
65: -- this cursor is used to include the order number in error messages
66: CURSOR c_onumber (c_o_id NUMBER) IS
67: SELECT TO_CHAR(order_number)
68: FROM okx_order_headers_v
69: WHERE id1 = c_o_id;
70:
71: -- cursor to retrieve the quote number against a given quote id
72: -- this cursor is used to include the quote number in error messages

Line 1318: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE ,

1314: p_qhr_id IN OKX_QUOTE_HEADERS_V.id1%TYPE ,
1315: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type ,
1316: --
1317: p_o_flag IN VARCHAR2 ,
1318: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE ,
1319: p_ole_tab IN ASO_QUOTE_PUB.qte_line_tbl_type ,
1320: --
1321: x_hd_sales_credit_tab OUT NOCOPY ASO_QUOTE_PUB.sales_credit_tbl_type,
1322: x_ln_sales_credit_tab OUT NOCOPY ASO_QUOTE_PUB.sales_credit_tbl_type,