eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_OC_INT_PRICING_PVT dependencies on ASO_QUOTE_PUB

Line 2385: x_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type) IS

2381: p_nqhr_id IN NUMBER,
2382: p_nqle_idx IN NUMBER,
2383: --
2384: x_k_price_adj_tab OUT NOCOPY k_price_adj_tab_type,
2385: x_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type) IS
2386:
2387: --
2388: -- Cursor to identify the price adjustments which have to be deleted taking into
2389: -- account those marked as to be updated or created.

Line 2600: l_price_adj_rec ASO_QUOTE_PUB.price_adj_rec_type;

2596: g_miss_price_adj_rec c_k_price_adj%ROWTYPE;
2597: l_prec_price_adj_rec c_k_price_adj%ROWTYPE := g_miss_price_adj_rec;
2598: l_price_adj_insert VARCHAR2(1) := OKC_API.G_TRUE;
2599:
2600: l_price_adj_rec ASO_QUOTE_PUB.price_adj_rec_type;
2601: l_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;
2602: l_k_tmp_price_adj_tab k_price_adj_tab_type;
2603:
2604: --

Line 2601: l_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;

2597: l_prec_price_adj_rec c_k_price_adj%ROWTYPE := g_miss_price_adj_rec;
2598: l_price_adj_insert VARCHAR2(1) := OKC_API.G_TRUE;
2599:
2600: l_price_adj_rec ASO_QUOTE_PUB.price_adj_rec_type;
2601: l_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;
2602: l_k_tmp_price_adj_tab k_price_adj_tab_type;
2603:
2604: --
2605: -- Variables to keep track of count for the l_price_adj_tab and

Line 3348: PROCEDURE get_price_adj_attr ( p_price_adj_tab IN ASO_QUOTE_PUB.price_adj_tbl_type,

3344: -- PROCEDURE get_price_adj_attr
3345: --
3346: ----------------------------------------------------------------------------
3347:
3348: PROCEDURE get_price_adj_attr ( p_price_adj_tab IN ASO_QUOTE_PUB.price_adj_tbl_type,
3349: p_k_price_adj_tab IN k_price_adj_tab_type,
3350: p_q_flag IN VARCHAR2,
3351: p_o_flag IN VARCHAR2,
3352: p_level IN VARCHAR2,

Line 3353: x_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type ) IS

3349: p_k_price_adj_tab IN k_price_adj_tab_type,
3350: p_q_flag IN VARCHAR2,
3351: p_o_flag IN VARCHAR2,
3352: p_level IN VARCHAR2,
3353: x_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type ) IS
3354:
3355: CURSOR c_k_price_adj_attr_c(b_kpat_id NUMBER) IS
3356: SELECT flex_title,
3357: pricing_context,

Line 3453: l_price_adj_attr_rec ASO_QUOTE_PUB.price_adj_attr_rec_type;

3449:
3450:
3451: -- variable declaration
3452: l_price_adj_insert VARCHAR2(1) := OKC_API.G_TRUE;
3453: l_price_adj_attr_rec ASO_QUOTE_PUB.price_adj_attr_rec_type;
3454: l_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;
3455:
3456: x binary_integer;
3457:

Line 3454: l_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;

3450:
3451: -- variable declaration
3452: l_price_adj_insert VARCHAR2(1) := OKC_API.G_TRUE;
3453: l_price_adj_attr_rec ASO_QUOTE_PUB.price_adj_attr_rec_type;
3454: l_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;
3455:
3456: x binary_integer;
3457:
3458: BEGIN

Line 3858: x_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type) IS

3854:
3855: p_nqhr_id IN NUMBER, -- Used only for new quote line to be created
3856: p_nqle_idx IN NUMBER,
3857: --
3858: x_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type) IS
3859:
3860:
3861: -- Cursors declaration
3862:

Line 4000: l_price_attr_rec ASO_QUOTE_PUB.price_attributes_rec_type;

3996: (b_kl_id IS NOT NULL AND kpattr.cle_id = b_kl_id));
3997:
3998: -- Variables declaration
3999:
4000: l_price_attr_rec ASO_QUOTE_PUB.price_attributes_rec_type;
4001: l_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;
4002: x Binary_integer;
4003:
4004: BEGIN

Line 4001: l_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;

3997:
3998: -- Variables declaration
3999:
4000: l_price_attr_rec ASO_QUOTE_PUB.price_attributes_rec_type;
4001: l_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;
4002: x Binary_integer;
4003:
4004: BEGIN
4005:

Line 4244: PROCEDURE get_price_adj_rltship ( p_price_adj_tab IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

4240: -- PROCEDURE get_price_adj_rltship
4241: --
4242: ----------------------------------------------------------------------------
4243:
4244: PROCEDURE get_price_adj_rltship ( p_price_adj_tab IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
4245: p_k_price_adj_tab IN k_price_adj_tab_type,
4246: --
4247: p_line_tab IN ASO_QUOTE_PUB.qte_line_tbl_type,
4248: p_kl_rel_tab IN okc_oc_int_config_pvt.line_rel_tab_type,

Line 4247: p_line_tab IN ASO_QUOTE_PUB.qte_line_tbl_type,

4243:
4244: PROCEDURE get_price_adj_rltship ( p_price_adj_tab IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
4245: p_k_price_adj_tab IN k_price_adj_tab_type,
4246: --
4247: p_line_tab IN ASO_QUOTE_PUB.qte_line_tbl_type,
4248: p_kl_rel_tab IN okc_oc_int_config_pvt.line_rel_tab_type,
4249: p_line_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type,
4250: --
4251: p_q_flag IN VARCHAR2,

Line 4249: p_line_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type,

4245: p_k_price_adj_tab IN k_price_adj_tab_type,
4246: --
4247: p_line_tab IN ASO_QUOTE_PUB.qte_line_tbl_type,
4248: p_kl_rel_tab IN okc_oc_int_config_pvt.line_rel_tab_type,
4249: p_line_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type,
4250: --
4251: p_q_flag IN VARCHAR2,
4252: p_o_flag IN VARCHAR2,
4253: p_level IN VARCHAR2,

Line 4255: x_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type) IS

4251: p_q_flag IN VARCHAR2,
4252: p_o_flag IN VARCHAR2,
4253: p_level IN VARCHAR2,
4254: --
4255: x_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type) IS
4256: --
4257: -- Cursors declaration
4258: --
4259:

Line 4333: l_price_adj_rltship_rec ASO_QUOTE_PUB.price_adj_rltship_rec_type;

4329: v_price_adj_rltship c_price_adj_rltship%ROWTYPE;
4330: l_price_adj_rltship c_price_adj_rltship%ROWTYPE;
4331: l_price_adj_insert VARCHAR2(1) := OKC_API.G_TRUE;
4332:
4333: l_price_adj_rltship_rec ASO_QUOTE_PUB.price_adj_rltship_rec_type;
4334: l_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
4335:
4336: x binary_integer;
4337:

Line 4334: l_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;

4330: l_price_adj_rltship c_price_adj_rltship%ROWTYPE;
4331: l_price_adj_insert VARCHAR2(1) := OKC_API.G_TRUE;
4332:
4333: l_price_adj_rltship_rec ASO_QUOTE_PUB.price_adj_rltship_rec_type;
4334: l_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
4335:
4336: x binary_integer;
4337:
4338: BEGIN

Line 4839: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type ,

4835: p_kl_rel_tab IN okc_oc_int_config_pvt.line_rel_tab_type ,
4836: --
4837: p_q_flag IN VARCHAR2 ,
4838: p_qhr_id IN OKX_QUOTE_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 ,

Line 4840: p_qle_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type ,

4836: --
4837: p_q_flag IN VARCHAR2 ,
4838: p_qhr_id IN OKX_QUOTE_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 ,

Line 4844: p_ole_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,
4848: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,

Line 4845: p_ole_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,
4848: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
4849: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,

Line 4847: x_hd_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,

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,
4848: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
4849: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
4850: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
4851: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,

Line 4848: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_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,
4848: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
4849: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
4850: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
4851: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
4852: x_ln_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,

Line 4849: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_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,
4848: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
4849: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
4850: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
4851: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
4852: x_ln_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
4853: x_hd_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,

Line 4850: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,

4846: --
4847: x_hd_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
4848: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
4849: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
4850: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
4851: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
4852: x_ln_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
4853: x_hd_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
4854: x_ln_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,

Line 4851: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,

4847: x_hd_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
4848: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
4849: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
4850: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
4851: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
4852: x_ln_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
4853: x_hd_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
4854: x_ln_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
4855: --

Line 4852: x_ln_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,

4848: x_ln_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,
4849: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
4850: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
4851: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
4852: x_ln_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
4853: x_hd_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
4854: x_ln_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
4855: --
4856: x_return_status OUT NOCOPY VARCHAR2 ) IS

Line 4853: x_hd_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,

4849: x_hd_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
4850: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
4851: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
4852: x_ln_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
4853: x_hd_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
4854: x_ln_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
4855: --
4856: x_return_status OUT NOCOPY VARCHAR2 ) IS
4857:

Line 4854: x_ln_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,

4850: x_ln_price_adj_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_attr_tbl_type,
4851: x_hd_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
4852: x_ln_price_attr_tab OUT NOCOPY ASO_QUOTE_PUB.price_attributes_tbl_type,
4853: x_hd_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
4854: x_ln_price_adj_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_rltship_tbl_type,
4855: --
4856: x_return_status OUT NOCOPY VARCHAR2 ) IS
4857:
4858: k BINARY_INTEGER;

Line 4859: x_ln_tmp_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;

4855: --
4856: x_return_status OUT NOCOPY VARCHAR2 ) IS
4857:
4858: k BINARY_INTEGER;
4859: x_ln_tmp_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;
4860: x_ln_tmp_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;
4861: l_k_temp_price_adj_tab k_price_adj_tab_type;
4862:
4863: BEGIN

Line 4860: x_ln_tmp_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;

4856: x_return_status OUT NOCOPY VARCHAR2 ) IS
4857:
4858: k BINARY_INTEGER;
4859: x_ln_tmp_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;
4860: x_ln_tmp_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;
4861: l_k_temp_price_adj_tab k_price_adj_tab_type;
4862:
4863: BEGIN
4864: --