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_SUBMIT_QUOTE_PVT dependencies on ASO_UTILITY_PVT

Line 219: ASO_UTILITY_PVT.print_login_info;

215:
216: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
217: IF aso_debug_pub.g_debug_flag = 'Y' THEN
218: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
219: ASO_UTILITY_PVT.print_login_info;
220: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
221: END IF;
222:
223: -- Change Done By Girish

Line 333: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_rec.quote_header_id);

329: RAISE fnd_api.g_exc_error;
330: END IF;
331: -- vtariker
332:
333: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_rec.quote_header_id);
334:
335: -- hyang new okc
336: IF p_qte_header_rec.Customer_Name_And_Title <> FND_API.G_MISS_CHAR
337: THEN

Line 451: l_hd_Price_Adj_Attr_Tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(

447: aso_debug_pub.add('Submit_Q: After l_hd_price_adj_tbl.count: '||l_hd_price_adj_tbl.count, 1, 'N');
448: END IF;
449:
450: -- pbh/prg
451: l_hd_Price_Adj_Attr_Tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(
452: p_price_adj_tbl => l_hd_price_adj_tbl);
453:
454: IF aso_debug_pub.g_debug_flag = 'Y' THEN
455: aso_debug_pub.add('vtariker: After l_hd_Price_Adj_Attr_Tbl.count: '||l_hd_Price_Adj_Attr_Tbl.count, 1, 'N');

Line 459: l_hd_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(

455: aso_debug_pub.add('vtariker: After l_hd_Price_Adj_Attr_Tbl.count: '||l_hd_Price_Adj_Attr_Tbl.count, 1, 'N');
456: END IF;
457: -- pbh/prg
458:
459: l_hd_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(
460: p_qte_header_id => p_qte_header_rec.quote_header_id,
461: p_qte_line_id => NULL);
462:
463: l_Header_ATTRIBS_EXT_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_header_Rows(

Line 463: l_Header_ATTRIBS_EXT_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_header_Rows(

459: l_hd_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(
460: p_qte_header_id => p_qte_header_rec.quote_header_id,
461: p_qte_line_id => NULL);
462:
463: l_Header_ATTRIBS_EXT_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_header_Rows(
464: P_Qte_header_Id => p_qte_header_rec.quote_header_id);
465:
466: l_hd_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(
467: p_qte_header_id => p_qte_header_rec.quote_header_id,

Line 466: l_hd_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(

462:
463: l_Header_ATTRIBS_EXT_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_header_Rows(
464: P_Qte_header_Id => p_qte_header_rec.quote_header_id);
465:
466: l_hd_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(
467: p_qte_header_id => p_qte_header_rec.quote_header_id,
468: p_qte_line_id => NULL);
469:
470: FOR i in 1..l_hd_payment_tbl.count LOOP

Line 480: l_hd_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(

476: l_qte_header_rec.total_quote_price;
477: END IF;
478: END LOOP;
479:
480: l_hd_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(
481: p_qte_header_id => p_qte_header_rec.quote_header_id,
482: p_qte_line_id => NULL,
483: p_shipment_tbl => ASO_QUOTE_PUB.g_miss_shipment_tbl);
484:

Line 485: l_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(

481: p_qte_header_id => p_qte_header_rec.quote_header_id,
482: p_qte_line_id => NULL,
483: p_shipment_tbl => ASO_QUOTE_PUB.g_miss_shipment_tbl);
484:
485: l_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(
486: p_qte_header_id => p_qte_header_rec.quote_header_id,
487: p_qte_line_id => NULL);
488:
489: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 493: l_hd_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(

489: IF aso_debug_pub.g_debug_flag = 'Y' THEN
490: aso_debug_pub.add('Submit_Q: After hd_shipment_tbl init ', 1, 'N');
491: END IF;
492:
493: l_hd_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(
494: P_Shipment_Tbl => l_hd_shipment_tbl);
495:
496: l_hd_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row (
497: p_qte_header_id => p_qte_header_rec.quote_header_id,

Line 496: l_hd_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row (

492:
493: l_hd_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(
494: P_Shipment_Tbl => l_hd_shipment_tbl);
495:
496: l_hd_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row (
497: p_qte_header_id => p_qte_header_rec.quote_header_id,
498: p_qte_line_id => NULL);
499:
500: l_hd_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row (

Line 500: l_hd_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row (

496: l_hd_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row (
497: p_qte_header_id => p_qte_header_rec.quote_header_id,
498: p_qte_line_id => NULL);
499:
500: l_hd_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row (
501: P_Qte_header_Id => p_qte_header_rec.quote_header_id,
502: p_qte_line_id => NULL) ;
503:
504: ASO_LINE_NUM_INT.RESET_LINE_NUM;

Line 506: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_Submit (p_qte_header_rec.quote_header_id);

502: p_qte_line_id => NULL) ;
503:
504: ASO_LINE_NUM_INT.RESET_LINE_NUM;
505:
506: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_Submit (p_qte_header_rec.quote_header_id);
507:
508: IF aso_debug_pub.g_debug_flag = 'Y' THEN
509: aso_debug_pub.add('Submit_Quote - qte_line_tbl.count: '||to_char(l_qte_line_tbl.count), 1, 'N');
510: END IF;

Line 611: l_tmp_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_rec.quote_header_id, L_QTE_LINE_ID);

607: p_qte_header_rec.quote_header_id, l_qte_line_id,
608: i, l_ln_price_attr_tbl);
609:
610: l_index := l_ln_payment_tbl.count+1;
611: l_tmp_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_rec.quote_header_id, L_QTE_LINE_ID);
612: FOR j IN 1..l_tmp_payment_tbl.count LOOP
613: l_tmp_payment_tbl(j).qte_line_index := i;
614: IF (NVL(l_om_defaulting_prof, 'N') = 'Y') THEN
615: IF l_tmp_payment_tbl(j).payment_term_id is null then

Line 660: l_ln_Price_Adj_Attr_Tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(l_ln_price_adj_tbl);

656:
657: END LOOP; -- Line_Tbl loop
658:
659: -- pbh/prg
660: l_ln_Price_Adj_Attr_Tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(l_ln_price_adj_tbl);
661: aso_debug_pub.add('vtariker: l_ln_Price_Adj_Attr_Tbl.count: '||l_ln_Price_Adj_Attr_Tbl.count, 1, 'N');
662: -- pbh/prg
663:
664: /*** Will not be required after CC condolidation

Line 1001: l_shipment_rec := ASO_UTILITY_PVT.Query_shipment_Row(lx_order_line_tbl(i).quote_shipment_Line_id);

997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;
999: END IF;
1000:
1001: l_shipment_rec := ASO_UTILITY_PVT.Query_shipment_Row(lx_order_line_tbl(i).quote_shipment_Line_id);
1002: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(l_shipment_rec.quote_line_id);
1003:
1004: -- transfer reservation
1005: IF l_shipment_rec.reservation_id IS NOT NULL

Line 1002: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(l_shipment_rec.quote_line_id);

998: END IF;
999: END IF;
1000:
1001: l_shipment_rec := ASO_UTILITY_PVT.Query_shipment_Row(lx_order_line_tbl(i).quote_shipment_Line_id);
1002: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(l_shipment_rec.quote_line_id);
1003:
1004: -- transfer reservation
1005: IF l_shipment_rec.reservation_id IS NOT NULL
1006: AND l_shipment_rec.reservation_id <> FND_API.G_MISS_NUM THEN