192: x_return_status VARCHAR2(1);
193: p_o_flag VARCHAR2(1);
194: p_q_flag VARCHAR2(1);
195:
196: p_qle_tab ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl;
197: p_qle_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl;
198:
199: p_ole_tab ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl;
200: p_ole_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl;
193: p_o_flag VARCHAR2(1);
194: p_q_flag VARCHAR2(1);
195:
196: p_qle_tab ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl;
197: p_qle_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl;
198:
199: p_ole_tab ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl;
200: p_ole_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl;
201:
195:
196: p_qle_tab ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl;
197: p_qle_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl;
198:
199: p_ole_tab ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl;
200: p_ole_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl;
201:
202:
203:
196: p_qle_tab ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl;
197: p_qle_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl;
198:
199: p_ole_tab ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl;
200: p_ole_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl;
201:
202:
203:
204: e_exit EXCEPTION;
202:
203:
204: e_exit EXCEPTION;
205:
206: l_line_tab ASO_QUOTE_PUB.qte_line_tbl_type;
207: l_line_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
208: l_k_price_adj_tab k_price_adj_tab_type;
209:
210:
203:
204: e_exit EXCEPTION;
205:
206: l_line_tab ASO_QUOTE_PUB.qte_line_tbl_type;
207: l_line_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
208: l_k_price_adj_tab k_price_adj_tab_type;
209:
210:
211: -----------------------------------------------------------------------------------------
236: p_kl_rel_tab IN okc_oc_int_config_pvt.line_rel_tab_type DEFAULT okc_oc_int_config_pvt.g_miss_kl_rel_tab,
237: --
238: p_q_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,
239: p_qhr_id IN OKX_QUOTE_HEADERS_V.id1%TYPE DEFAULT OKC_API.g_miss_num,
240: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,
241: p_qle_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl,
242: --
243: p_o_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,
244: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE DEFAULT OKC_API.g_miss_num,
237: --
238: p_q_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,
239: p_qhr_id IN OKX_QUOTE_HEADERS_V.id1%TYPE DEFAULT OKC_API.g_miss_num,
240: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,
241: p_qle_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl,
242: --
243: p_o_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,
244: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE DEFAULT OKC_API.g_miss_num,
245: p_ole_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,
241: p_qle_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl,
242: --
243: p_o_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,
244: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE DEFAULT OKC_API.g_miss_num,
245: p_ole_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,
246: p_ole_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl,
247: --
248: x_hd_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
249: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
242: --
243: p_o_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,
244: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE DEFAULT OKC_API.g_miss_num,
245: p_ole_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,
246: p_ole_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl,
247: --
248: x_hd_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
249: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
250: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
244: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE DEFAULT OKC_API.g_miss_num,
245: p_ole_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,
246: p_ole_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl,
247: --
248: x_hd_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
249: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
250: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
251: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
252: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
245: p_ole_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,
246: p_ole_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl,
247: --
248: x_hd_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
249: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
250: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
251: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
252: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
253: x_ln_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
246: p_ole_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl,
247: --
248: x_hd_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
249: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
250: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
251: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
252: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
253: x_ln_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
254: x_hd_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
247: --
248: x_hd_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
249: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
250: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
251: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
252: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
253: x_ln_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
254: x_hd_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
255: x_ln_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
248: x_hd_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
249: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
250: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
251: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
252: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
253: x_ln_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
254: x_hd_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
255: x_ln_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
256: --
249: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
250: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
251: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
252: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
253: x_ln_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
254: x_hd_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
255: x_ln_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
256: --
257: x_return_status OUT NOCOPY VARCHAR2);
250: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
251: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
252: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
253: x_ln_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
254: x_hd_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
255: x_ln_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
256: --
257: x_return_status OUT NOCOPY VARCHAR2);
258:
251: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
252: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
253: x_ln_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
254: x_hd_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
255: x_ln_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
256: --
257: x_return_status OUT NOCOPY VARCHAR2);
258:
259: -- =========================================================================