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 10595: 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');

10591: END LOOP;
10592:
10593: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10594: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Update Shipment info and before calling get_line_freight_charges Ends', 1, 'Y');
10595: 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');
10596: END IF;
10597:
10598: OPEN c_qte_sum;
10599: FETCH c_qte_sum INTO l_total_list_price, l_ln_total_discount;

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

10597:
10598: OPEN c_qte_sum;
10599: FETCH c_qte_sum INTO l_total_list_price, l_ln_total_discount;
10600: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10601: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_QUOTE_HEADERS_ALL l_total_list_price:'||l_total_list_price, 1, 'Y');
10602: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_QUOTE_HEADERS_ALL l_ln_total_discount:'||l_ln_total_discount,1,'Y');
10603: END IF;
10604: CLOSE c_qte_sum;
10605: UPDATE ASO_QUOTE_HEADERS_ALL

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

10598: OPEN c_qte_sum;
10599: FETCH c_qte_sum INTO l_total_list_price, l_ln_total_discount;
10600: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10601: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_QUOTE_HEADERS_ALL l_total_list_price:'||l_total_list_price, 1, 'Y');
10602: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_QUOTE_HEADERS_ALL l_ln_total_discount:'||l_ln_total_discount,1,'Y');
10603: END IF;
10604: CLOSE c_qte_sum;
10605: UPDATE ASO_QUOTE_HEADERS_ALL
10606: SET total_list_price = l_total_list_price,

Line 10605: UPDATE ASO_QUOTE_HEADERS_ALL

10601: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_QUOTE_HEADERS_ALL l_total_list_price:'||l_total_list_price, 1, 'Y');
10602: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_QUOTE_HEADERS_ALL l_ln_total_discount:'||l_ln_total_discount,1,'Y');
10603: END IF;
10604: CLOSE c_qte_sum;
10605: UPDATE ASO_QUOTE_HEADERS_ALL
10606: SET total_list_price = l_total_list_price,
10607: TOTAL_ADJUSTED_AMOUNT = l_ln_total_discount,
10608: total_adjusted_percent = decode(total_list_price, 0, NULL,
10609: (l_ln_total_discount/total_list_price)*100),

Line 11215: FROM ASO_QUOTE_HEADERS_ALL

11211: l_qte_header_rec.quote_header_id := p_qte_header_rec.quote_header_id;
11212:
11213: Begin
11214: SELECT last_update_date into l_last_update_date
11215: FROM ASO_QUOTE_HEADERS_ALL
11216: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
11217:
11218: l_qte_header_rec.last_update_date := l_last_update_date;
11219: