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_PRICING_CORE_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 10578: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Cursor c_qte_sum opens and update of total for ASO_QUOTE_HEADERS_ALL Starts',1,'Y');

10574: END LOOP;
10575:
10576: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10577: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Update Shipment info and before calling get_line_freight_charges Ends', 1, 'Y');
10578: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Cursor c_qte_sum opens and update of total for ASO_QUOTE_HEADERS_ALL Starts',1,'Y');
10579: END IF;
10580:
10581: OPEN c_qte_sum;
10582: FETCH c_qte_sum INTO l_total_list_price, l_ln_total_discount;

Line 10584: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_QUOTE_HEADERS_ALL l_total_list_price:'||l_total_list_price, 1, 'Y');

10580:
10581: OPEN c_qte_sum;
10582: FETCH c_qte_sum INTO l_total_list_price, l_ln_total_discount;
10583: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10584: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_QUOTE_HEADERS_ALL l_total_list_price:'||l_total_list_price, 1, 'Y');
10585: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_QUOTE_HEADERS_ALL l_ln_total_discount:'||l_ln_total_discount,1,'Y');
10586: END IF;
10587: CLOSE c_qte_sum;
10588: UPDATE ASO_QUOTE_HEADERS_ALL

Line 10585: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_QUOTE_HEADERS_ALL l_ln_total_discount:'||l_ln_total_discount,1,'Y');

10581: OPEN c_qte_sum;
10582: FETCH c_qte_sum INTO l_total_list_price, l_ln_total_discount;
10583: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10584: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_QUOTE_HEADERS_ALL l_total_list_price:'||l_total_list_price, 1, 'Y');
10585: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_QUOTE_HEADERS_ALL l_ln_total_discount:'||l_ln_total_discount,1,'Y');
10586: END IF;
10587: CLOSE c_qte_sum;
10588: UPDATE ASO_QUOTE_HEADERS_ALL
10589: SET total_list_price = l_total_list_price,

Line 10588: UPDATE ASO_QUOTE_HEADERS_ALL

10584: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_QUOTE_HEADERS_ALL l_total_list_price:'||l_total_list_price, 1, 'Y');
10585: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_QUOTE_HEADERS_ALL l_ln_total_discount:'||l_ln_total_discount,1,'Y');
10586: END IF;
10587: CLOSE c_qte_sum;
10588: UPDATE ASO_QUOTE_HEADERS_ALL
10589: SET total_list_price = l_total_list_price,
10590: TOTAL_ADJUSTED_AMOUNT = l_ln_total_discount,
10591: total_adjusted_percent = decode(total_list_price, 0, NULL,
10592: (l_ln_total_discount/total_list_price)*100),

Line 11198: FROM ASO_QUOTE_HEADERS_ALL

11194: l_qte_header_rec.quote_header_id := p_qte_header_rec.quote_header_id;
11195:
11196: Begin
11197: SELECT last_update_date into l_last_update_date
11198: FROM ASO_QUOTE_HEADERS_ALL
11199: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
11200:
11201: l_qte_header_rec.last_update_date := l_last_update_date;
11202: