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.ASO_CFG_INT dependencies on CZ_PRICING_STRUCTURES

Line 1895: from cz_pricing_structures

1891: Cursor c_options is
1892: Select item_key, cz_atp_callback_util.inv_item_id_from_item_key(item_key) item_id,
1893: quantity, uom_code,substr(item_key, 1,instr( item_key, ':' ,1)-1) component_code,
1894: config_item_id
1895: from cz_pricing_structures
1896: Where configurator_session_key = p_config_session_key
1897: and item_key_type = 1;
1898:
1899: Cursor c_quote_hdr_id ( p_quote_line_id NUMBER ) is

Line 1928: from cz_pricing_structures

1924: and ref_line_id is not null;
1925:
1926: Cursor c_get_pricing_structure(p_session_key VARCHAR2) is
1927: select list_price,selling_price,config_item_id
1928: from cz_pricing_structures
1929: where configurator_session_key = p_session_key;
1930:
1931: Cursor c_charge_periodicity_code(p_inventory_item_id number, p_organization_id number) is
1932: select charge_periodicity_code

Line 2476: UPDATE CZ_PRICING_STRUCTURES

2472: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2473: aso_debug_pub.add('PRICING CALLBACK: Inside IF condition lx_return_status <> FND_API.G_RET_STS_SUCCESS');
2474: END IF;
2475:
2476: UPDATE CZ_PRICING_STRUCTURES
2477: SET MSG_DATA = l_mymsg
2478: WHERE configurator_session_key = p_config_session_key;
2479: --AND config_item_id = l_root_model_config_item_id;
2480:

Line 2503: UPDATE CZ_PRICING_STRUCTURES

2499: - l_count).config_item_id);
2500:
2501: END IF;
2502:
2503: UPDATE CZ_PRICING_STRUCTURES
2504: SET selling_price = lx_qte_line_tbl(i).LINE_QUOTE_PRICE,
2505: list_price = lx_qte_line_tbl(i).line_list_price
2506: WHERE configurator_session_key = p_config_session_key
2507: AND config_item_id = l_qte_line_dtl_tbl(i - l_count).config_item_id;

Line 2518: FROM CZ_PRICING_STRUCTURES

2514:
2515: BEGIN
2516:
2517: SELECT sum(selling_price) INTO x_total_price
2518: FROM CZ_PRICING_STRUCTURES
2519: WHERE configurator_session_key = p_config_session_key;
2520:
2521: EXCEPTION
2522:

Line 2540: aso_debug_pub.add('PRICING CALLBACK: Data in CZ_PRICING_STRUCTURES table after update to list and selling prices columns.');

2536: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2537:
2538: FOR row IN c_get_pricing_structure(p_config_session_key) LOOP
2539:
2540: aso_debug_pub.add('PRICING CALLBACK: Data in CZ_PRICING_STRUCTURES table after update to list and selling prices columns.');
2541: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: config_item_id: ' || row.config_item_id);
2542: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: list_price: ' || row.list_price);
2543: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: selling_price: ' || row.selling_price);
2544:

Line 2541: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: config_item_id: ' || row.config_item_id);

2537:
2538: FOR row IN c_get_pricing_structure(p_config_session_key) LOOP
2539:
2540: aso_debug_pub.add('PRICING CALLBACK: Data in CZ_PRICING_STRUCTURES table after update to list and selling prices columns.');
2541: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: config_item_id: ' || row.config_item_id);
2542: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: list_price: ' || row.list_price);
2543: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: selling_price: ' || row.selling_price);
2544:
2545: END LOOP;

Line 2542: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: list_price: ' || row.list_price);

2538: FOR row IN c_get_pricing_structure(p_config_session_key) LOOP
2539:
2540: aso_debug_pub.add('PRICING CALLBACK: Data in CZ_PRICING_STRUCTURES table after update to list and selling prices columns.');
2541: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: config_item_id: ' || row.config_item_id);
2542: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: list_price: ' || row.list_price);
2543: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: selling_price: ' || row.selling_price);
2544:
2545: END LOOP;
2546:

Line 2543: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: selling_price: ' || row.selling_price);

2539:
2540: aso_debug_pub.add('PRICING CALLBACK: Data in CZ_PRICING_STRUCTURES table after update to list and selling prices columns.');
2541: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: config_item_id: ' || row.config_item_id);
2542: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: list_price: ' || row.list_price);
2543: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: selling_price: ' || row.selling_price);
2544:
2545: END LOOP;
2546:
2547: END IF;

Line 2564: UPDATE CZ_PRICING_STRUCTURES

2560: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Inside When Others Exception');
2561: END IF;
2562:
2563: -- set the error message in the model line msg_data field of cz_pricing_structure
2564: UPDATE CZ_PRICING_STRUCTURES
2565: SET MSG_DATA = lx_msg_data
2566: WHERE configurator_session_key = p_config_session_key;
2567: --AND config_item_id = l_root_model_config_item_id;
2568: