DBA Data[Home] [Help]

APPS.OKC_CFG_PUB dependencies on OKX_CONFIG_PRICING_V

Line 1700: FROM okx_config_pricing_v

1696: CZ_ATP_CALLBACK_UTIL.inv_item_id_from_item_key(item_key) item_id,
1697: quantity quantity,
1698: uom_code uom_code,
1699: SUBSTR(item_key, 1,INSTR( item_key, ':' ,1)-1) comp_code
1700: FROM okx_config_pricing_v
1701: WHERE configurator_session_key = p_config_session_key
1702: AND list_price IS NULL
1703: AND selling_price IS NULL;
1704:

Line 1992: -- FROM okx_config_pricing_v

1988:
1989: -- BEGIN
1990: -- SELECT SUM( selling_price )
1991: -- INTO x_total_price
1992: -- FROM okx_config_pricing_v
1993: -- WHERE configurator_session_key = p_config_session_key ;
1994: -- EXCEPTION
1995: -- WHEN OTHERS THEN
1996: -- RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2018: UPDATE okx_config_pricing_v

2014: OKC_DEBUG.log('7996: Error Message: '||l_calc_price_error);
2015: END IF;
2016:
2017: -- Set the error message
2018: UPDATE okx_config_pricing_v
2019: SET msg_data = l_calc_price_error
2020: WHERE configurator_session_key = p_config_session_key;
2021:
2022: IF (l_debug = 'Y') THEN