DBA Data[Home] [Help]

APPS.OKC_OC_INT_PRICING_PVT dependencies on ASO_QUOTE_PUB

Line 196: p_qle_tab ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl;

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;

Line 197: p_qle_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:

Line 199: p_ole_tab ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl;

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:

Line 200: p_ole_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl;

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;

Line 206: l_line_tab ASO_QUOTE_PUB.qte_line_tbl_type;

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:

Line 207: l_line_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;

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: -----------------------------------------------------------------------------------------

Line 240: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,

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,

Line 241: p_qle_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl,

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,

Line 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,

Line 246: p_ole_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,
250: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,

Line 248: x_hd_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_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,

Line 249: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_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,

Line 250: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_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,

Line 251: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_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,

Line 252: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_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: --

Line 253: x_ln_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_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: --
257: x_return_status OUT NOCOPY VARCHAR2);

Line 254: x_hd_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_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);
258:

Line 255: x_ln_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_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:
259: -- =========================================================================