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 228: ASO_UTILITY_PVT.print_login_info;

224:
225: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
226: IF aso_debug_pub.g_debug_flag = 'Y' THEN
227: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
228: ASO_UTILITY_PVT.print_login_info;
229: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
230: END IF;
231:
232: -- Change Done By Girish

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

338: RAISE fnd_api.g_exc_error;
339: END IF;
340: -- vtariker
341:
342: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_rec.quote_header_id);
343:
344: -- hyang new okc
345: IF p_qte_header_rec.Customer_Name_And_Title <> FND_API.G_MISS_CHAR
346: THEN

Line 460: l_hd_Price_Adj_Attr_Tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(

456: aso_debug_pub.add('Submit_Q: After l_hd_price_adj_tbl.count: '||l_hd_price_adj_tbl.count, 1, 'N');
457: END IF;
458:
459: -- pbh/prg
460: l_hd_Price_Adj_Attr_Tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(
461: p_price_adj_tbl => l_hd_price_adj_tbl);
462:
463: IF aso_debug_pub.g_debug_flag = 'Y' THEN
464: aso_debug_pub.add('vtariker: After l_hd_Price_Adj_Attr_Tbl.count: '||l_hd_Price_Adj_Attr_Tbl.count, 1, 'N');

Line 468: l_hd_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(

464: aso_debug_pub.add('vtariker: After l_hd_Price_Adj_Attr_Tbl.count: '||l_hd_Price_Adj_Attr_Tbl.count, 1, 'N');
465: END IF;
466: -- pbh/prg
467:
468: l_hd_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(
469: p_qte_header_id => p_qte_header_rec.quote_header_id,
470: p_qte_line_id => NULL);
471:
472: l_Header_ATTRIBS_EXT_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_header_Rows(

Line 472: l_Header_ATTRIBS_EXT_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_header_Rows(

468: l_hd_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(
469: p_qte_header_id => p_qte_header_rec.quote_header_id,
470: p_qte_line_id => NULL);
471:
472: l_Header_ATTRIBS_EXT_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_header_Rows(
473: P_Qte_header_Id => p_qte_header_rec.quote_header_id);
474:
475: l_hd_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(
476: p_qte_header_id => p_qte_header_rec.quote_header_id,

Line 475: l_hd_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(

471:
472: l_Header_ATTRIBS_EXT_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_header_Rows(
473: P_Qte_header_Id => p_qte_header_rec.quote_header_id);
474:
475: l_hd_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(
476: p_qte_header_id => p_qte_header_rec.quote_header_id,
477: p_qte_line_id => NULL);
478:
479: FOR i in 1..l_hd_payment_tbl.count LOOP

Line 489: l_hd_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(

485: l_qte_header_rec.total_quote_price;
486: END IF;
487: END LOOP;
488:
489: l_hd_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(
490: p_qte_header_id => p_qte_header_rec.quote_header_id,
491: p_qte_line_id => NULL,
492: p_shipment_tbl => ASO_QUOTE_PUB.g_miss_shipment_tbl);
493:

Line 494: l_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(

490: p_qte_header_id => p_qte_header_rec.quote_header_id,
491: p_qte_line_id => NULL,
492: p_shipment_tbl => ASO_QUOTE_PUB.g_miss_shipment_tbl);
493:
494: l_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(
495: p_qte_header_id => p_qte_header_rec.quote_header_id,
496: p_qte_line_id => NULL);
497:
498: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 502: l_hd_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(

498: IF aso_debug_pub.g_debug_flag = 'Y' THEN
499: aso_debug_pub.add('Submit_Q: After hd_shipment_tbl init ', 1, 'N');
500: END IF;
501:
502: l_hd_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(
503: P_Shipment_Tbl => l_hd_shipment_tbl);
504:
505: l_hd_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row (
506: p_qte_header_id => p_qte_header_rec.quote_header_id,

Line 505: l_hd_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row (

501:
502: l_hd_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(
503: P_Shipment_Tbl => l_hd_shipment_tbl);
504:
505: l_hd_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row (
506: p_qte_header_id => p_qte_header_rec.quote_header_id,
507: p_qte_line_id => NULL);
508:
509: l_hd_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row (

Line 509: l_hd_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row (

505: l_hd_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row (
506: p_qte_header_id => p_qte_header_rec.quote_header_id,
507: p_qte_line_id => NULL);
508:
509: l_hd_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row (
510: P_Qte_header_Id => p_qte_header_rec.quote_header_id,
511: p_qte_line_id => NULL) ;
512:
513:

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

618: End If; -- application_type_code
619:
620: ASO_LINE_NUM_INT.RESET_LINE_NUM;
621:
622: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_Submit (p_qte_header_rec.quote_header_id);
623:
624: IF aso_debug_pub.g_debug_flag = 'Y' THEN
625: aso_debug_pub.add('Submit_Quote - qte_line_tbl.count: '||to_char(l_qte_line_tbl.count), 1, 'N');
626: END IF;

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

736: p_qte_header_rec.quote_header_id, l_qte_line_id,
737: i, l_ln_price_attr_tbl);
738:
739: l_index := l_ln_payment_tbl.count+1;
740: l_tmp_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_rec.quote_header_id, L_QTE_LINE_ID);
741: FOR j IN 1..l_tmp_payment_tbl.count LOOP
742: l_tmp_payment_tbl(j).qte_line_index := i;
743: IF (NVL(l_om_defaulting_prof, 'N') = 'Y') THEN
744: IF l_tmp_payment_tbl(j).payment_term_id is null then

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

785:
786: END LOOP; -- Line_Tbl loop
787:
788: -- pbh/prg
789: l_ln_Price_Adj_Attr_Tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(l_ln_price_adj_tbl);
790: aso_debug_pub.add('vtariker: l_ln_Price_Adj_Attr_Tbl.count: '||l_ln_Price_Adj_Attr_Tbl.count, 1, 'N');
791: -- pbh/prg
792:
793: /*** Will not be required after CC condolidation

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

1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1127: END IF;
1128: END IF;
1129:
1130: l_shipment_rec := ASO_UTILITY_PVT.Query_shipment_Row(lx_order_line_tbl(i).quote_shipment_Line_id);
1131: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(l_shipment_rec.quote_line_id);
1132:
1133: -- transfer reservation
1134: IF l_shipment_rec.reservation_id IS NOT NULL

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

1127: END IF;
1128: END IF;
1129:
1130: l_shipment_rec := ASO_UTILITY_PVT.Query_shipment_Row(lx_order_line_tbl(i).quote_shipment_Line_id);
1131: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(l_shipment_rec.quote_line_id);
1132:
1133: -- transfer reservation
1134: IF l_shipment_rec.reservation_id IS NOT NULL
1135: AND l_shipment_rec.reservation_id <> FND_API.G_MISS_NUM THEN