DBA Data[Home] [Help]

APPS.OE_CONFIG_PRICE_UTIL dependencies on CZ_PRC_CALLBACK_UTIL

Line 99: WHERE cz.item_key_type = cz_prc_callback_util.g_item_key_bom_node

95: ,item.pick_components_flag, item.inventory_item_id
96: ,cz.seq_nbr
97: FROM CZ_PRICING_STRUCTURES cz
98: , MTL_SYSTEM_ITEMS item
99: WHERE cz.item_key_type = cz_prc_callback_util.g_item_key_bom_node
100: AND cz.configurator_session_key = p_config_session_key
101: AND (cz.list_price is null
102: OR cz.selling_price is null)
103: AND item.inventory_item_id = to_number(SUBSTR((SUBSTR( cz.item_key,

Line 377: IF p_price_type = CZ_Prc_Callback_Util.G_PRC_TYPE_LIST THEN

373:
374: -- event PRICE to get only list price.
375: -- event LINE to get selling and list.
376:
377: IF p_price_type = CZ_Prc_Callback_Util.G_PRC_TYPE_LIST THEN
378: l_price_control_rec.pricing_event := 'PRICE';
379: ELSE
380: l_price_control_rec.pricing_event := 'LINE';
381: END IF;

Line 461: AND item_key_type = cz_prc_callback_util.g_item_key_bom_node;

457: WHERE SUBSTR( item_key, 1, INSTR(item_key, ':') - 1)
458: = l_line_tbl(l_index).component_code
459: AND seq_nbr = -1 - l_line_tbl(l_index).line_id --Bug#2832208
460: AND configurator_session_key = p_config_session_key
461: AND item_key_type = cz_prc_callback_util.g_item_key_bom_node;
462:
463:
464: IF l_debug_level > 0 THEN
465: oe_debug_pub.add('ITEM: '||L_LINE_TBL ( L_INDEX ).COMPONENT_CODE , 1);