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 1722: from cz_pricing_structures

1718: Cursor c_options is
1719: Select item_key, cz_atp_callback_util.inv_item_id_from_item_key(item_key) item_id,
1720: quantity, uom_code,substr(item_key, 1,instr( item_key, ':' ,1)-1) component_code,
1721: config_item_id
1722: from cz_pricing_structures
1723: Where configurator_session_key = p_config_session_key
1724: and item_key_type = 1;
1725:
1726: Cursor c_quote_hdr_id ( p_quote_line_id NUMBER ) is

Line 1755: from cz_pricing_structures

1751: and ref_line_id is not null;
1752:
1753: Cursor c_get_pricing_structure(p_session_key VARCHAR2) is
1754: select list_price,selling_price,config_item_id
1755: from cz_pricing_structures
1756: where configurator_session_key = p_session_key;
1757:
1758: Cursor c_charge_periodicity_code(p_inventory_item_id number, p_organization_id number) is
1759: select charge_periodicity_code

Line 2221: UPDATE CZ_PRICING_STRUCTURES

2217: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2218: aso_debug_pub.add('PRICING CALLBACK: Inside IF condition lx_return_status <> FND_API.G_RET_STS_SUCCESS');
2219: END IF;
2220:
2221: UPDATE CZ_PRICING_STRUCTURES
2222: SET MSG_DATA = l_mymsg
2223: WHERE configurator_session_key = p_config_session_key;
2224: --AND config_item_id = l_root_model_config_item_id;
2225:

Line 2248: UPDATE CZ_PRICING_STRUCTURES

2244: - l_count).config_item_id);
2245:
2246: END IF;
2247:
2248: UPDATE CZ_PRICING_STRUCTURES
2249: SET selling_price = lx_qte_line_tbl(i).LINE_QUOTE_PRICE,
2250: list_price = lx_qte_line_tbl(i).line_list_price
2251: WHERE configurator_session_key = p_config_session_key
2252: AND config_item_id = l_qte_line_dtl_tbl(i - l_count).config_item_id;

Line 2263: FROM CZ_PRICING_STRUCTURES

2259:
2260: BEGIN
2261:
2262: SELECT sum(selling_price) INTO x_total_price
2263: FROM CZ_PRICING_STRUCTURES
2264: WHERE configurator_session_key = p_config_session_key;
2265:
2266: EXCEPTION
2267:

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

2281: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2282:
2283: FOR row IN c_get_pricing_structure(p_config_session_key) LOOP
2284:
2285: aso_debug_pub.add('PRICING CALLBACK: Data in CZ_PRICING_STRUCTURES table after update to list and selling prices columns.');
2286: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: config_item_id: ' || row.config_item_id);
2287: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: list_price: ' || row.list_price);
2288: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: selling_price: ' || row.selling_price);
2289:

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

2282:
2283: FOR row IN c_get_pricing_structure(p_config_session_key) LOOP
2284:
2285: aso_debug_pub.add('PRICING CALLBACK: Data in CZ_PRICING_STRUCTURES table after update to list and selling prices columns.');
2286: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: config_item_id: ' || row.config_item_id);
2287: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: list_price: ' || row.list_price);
2288: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: selling_price: ' || row.selling_price);
2289:
2290: END LOOP;

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

2283: FOR row IN c_get_pricing_structure(p_config_session_key) LOOP
2284:
2285: aso_debug_pub.add('PRICING CALLBACK: Data in CZ_PRICING_STRUCTURES table after update to list and selling prices columns.');
2286: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: config_item_id: ' || row.config_item_id);
2287: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: list_price: ' || row.list_price);
2288: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: selling_price: ' || row.selling_price);
2289:
2290: END LOOP;
2291:

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

2284:
2285: aso_debug_pub.add('PRICING CALLBACK: Data in CZ_PRICING_STRUCTURES table after update to list and selling prices columns.');
2286: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: config_item_id: ' || row.config_item_id);
2287: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: list_price: ' || row.list_price);
2288: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: selling_price: ' || row.selling_price);
2289:
2290: END LOOP;
2291:
2292: END IF;

Line 2309: UPDATE CZ_PRICING_STRUCTURES

2305: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Inside When Others Exception');
2306: END IF;
2307:
2308: -- set the error message in the model line msg_data field of cz_pricing_structure
2309: UPDATE CZ_PRICING_STRUCTURES
2310: SET MSG_DATA = lx_msg_data
2311: WHERE configurator_session_key = p_config_session_key;
2312: --AND config_item_id = l_root_model_config_item_id;
2313: