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_SUBMIT_QUOTE_PVT

Line 1: PACKAGE BODY ASO_SUBMIT_QUOTE_PVT as

1: PACKAGE BODY ASO_SUBMIT_QUOTE_PVT as
2: /* $Header: asovsubb.pls 120.15 2012/01/20 04:47:18 akushwah ship $ */
3: -- Start of Comments
4: -- Package name : ASO_SUBMIT_QUOTE_PVT
5: -- Purpose :

Line 4: -- Package name : ASO_SUBMIT_QUOTE_PVT

1: PACKAGE BODY ASO_SUBMIT_QUOTE_PVT as
2: /* $Header: asovsubb.pls 120.15 2012/01/20 04:47:18 akushwah ship $ */
3: -- Start of Comments
4: -- Package name : ASO_SUBMIT_QUOTE_PVT
5: -- Purpose :
6: -- History :
7: -- 09/07/2007 vidsrini --Fix for bug 5847316
8: -- 02/01/2007 gkeshava - Fix for perf bug 5714535

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_SUBMIT_QUOTE_PVT';

8: -- 02/01/2007 gkeshava - Fix for perf bug 5714535
9: -- NOTE :
10: -- End of Comments
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_SUBMIT_QUOTE_PVT';
13:
14:
15: -- NAME
16: -- Submit_Quote

Line 450: l_hd_price_adj_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Hdr_Rows(

446: count_rel := count_rel+1;
447: END LOOP;
448:
449:
450: l_hd_price_adj_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Hdr_Rows(
451: p_qte_header_id => p_qte_header_rec.quote_header_id,
452: p_qte_line_id => NULL);
453:
454: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 687: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Line_Dtl_Rows(

683: l_qte_line_tbl(i).accounting_rule_id := FND_API.G_MISS_NUM;
684: end if;
685: END IF;
686:
687: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Line_Dtl_Rows(
688: l_qte_line_id, i, l_qte_line_dtl_tbl);
689:
690: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
691: FOR j IN 1..l_qte_line_dtl_tbl.count LOOP

Line 703: l_line_attr_Ext_Tbl := ASO_SUBMIT_QUOTE_PVT.Query_Line_Attribs_Ext_Rows(

699: end if;
700: end loop;
701: /*** End: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
702:
703: l_line_attr_Ext_Tbl := ASO_SUBMIT_QUOTE_PVT.Query_Line_Attribs_Ext_Rows(
704: l_qte_line_id, i, l_line_attr_ext_tbl);
705:
706: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rows(p_qte_header_rec.quote_header_id,
707: l_qte_line_tbl(i), i,

Line 706: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rows(p_qte_header_rec.quote_header_id,

702:
703: l_line_attr_Ext_Tbl := ASO_SUBMIT_QUOTE_PVT.Query_Line_Attribs_Ext_Rows(
704: l_qte_line_id, i, l_line_attr_ext_tbl);
705:
706: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rows(p_qte_header_rec.quote_header_id,
707: l_qte_line_tbl(i), i,
708: l_ln_price_adj_rltship_tbl,
709: l_ln_price_adj_tbl );
710:

Line 718: := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rltship_Rows(

714: l_tmp_price_adj_tbl(j).operation_code := 'CREATE';
715:
716: -- pbh/prg
717: l_ln_price_adj_rltship_tbl
718: := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rltship_Rows(
719: l_tmp_price_adj_tbl(j).price_adjustment_id, i, l_ln_price_adj_rltship_tbl);
720: IF aso_debug_pub.g_debug_flag = 'Y' THEN
721: aso_debug_pub.add('Submit_Q: After l_ln_Price_Adj_Rltship_tbl.count: '||l_ln_Price_Adj_Rltship_tbl.count, 1, 'N');
722: END IF;

Line 735: l_ln_price_attr_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Attr_Rows(

731: l_ln_price_adj_tbl(l_index) := l_tmp_price_adj_tbl(j);
732: l_index := l_index+1;
733: END LOOP;
734: */
735: l_ln_price_attr_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Attr_Rows(
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;

Line 757: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Shipment_Rows(

753:
754: -- l_index := l_index+1;
755: END LOOP;
756:
757: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Shipment_Rows(
758: p_qte_header_rec.quote_header_id, L_QTE_LINE_ID,
759: i, l_ln_shipment_tbl);
760: /*
761: l_ln_freight_charge_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Freight_Charge_Rows(

Line 761: l_ln_freight_charge_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Freight_Charge_Rows(

757: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Shipment_Rows(
758: p_qte_header_rec.quote_header_id, L_QTE_LINE_ID,
759: i, l_ln_shipment_tbl);
760: /*
761: l_ln_freight_charge_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Freight_Charge_Rows(
762: l_ln_shipment_tbl, i, l_ln_freight_charge_tbl);
763: */
764: l_ln_tax_detail_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows(
765: p_qte_header_rec.quote_header_id,

Line 764: l_ln_tax_detail_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows(

760: /*
761: l_ln_freight_charge_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Freight_Charge_Rows(
762: l_ln_shipment_tbl, i, l_ln_freight_charge_tbl);
763: */
764: l_ln_tax_detail_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows(
765: p_qte_header_rec.quote_header_id,
766: L_QTE_LINE_ID, l_ln_shipment_tbl.count,
767: i, l_ln_tax_detail_tbl);
768:

Line 778: l_ln_sales_credit_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Sales_Credit_Row (

774: l_line_rltship_tbl(j).related_qte_line_index := i;
775: END IF;
776: END LOOP;
777:
778: l_ln_sales_credit_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Sales_Credit_Row (
779: p_qte_header_rec.quote_header_id, l_qte_line_id,
780: i, l_ln_sales_credit_tbl);
781:
782: l_ln_quote_party_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Quote_Party_Row(

Line 782: l_ln_quote_party_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Quote_Party_Row(

778: l_ln_sales_credit_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Sales_Credit_Row (
779: p_qte_header_rec.quote_header_id, l_qte_line_id,
780: i, l_ln_sales_credit_tbl);
781:
782: l_ln_quote_party_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Quote_Party_Row(
783: p_qte_header_rec.quote_header_id, l_qte_line_id,
784: i, l_ln_quote_party_tbl);
785:
786: END LOOP; -- Line_Tbl loop

Line 1216: ASO_SUBMIT_QUOTE_PVT.Raise_Quote_Event (

1212: aso_debug_pub.add('Submit_Q: In HA: X_Current_State: '||X_Current_State, 1, 'N');
1213: END IF;
1214: ROLLBACK TO SUBMIT_QUOTE_PVT;
1215:
1216: ASO_SUBMIT_QUOTE_PVT.Raise_Quote_Event (
1217: P_Quote_Header_Id => p_qte_header_rec.quote_header_id,
1218: P_Control_Rec => p_control_rec,
1219: X_Return_Status => x_return_status );
1220:

Line 1476: aso_debug_pub.add('Begin ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows', 1, 'N');

1472: --Fix for bug 5714535. Setting the output table structure directly instead of
1473: --setting it through the local record structure.
1474:
1475: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1476: aso_debug_pub.add('Begin ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows', 1, 'N');
1477: END IF;
1478:
1479: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
1480:

Line 1578: aso_debug_pub.add('ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows - end', 1, 'N');

1574: END LOOP;
1575: END IF;
1576:
1577: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1578: aso_debug_pub.add('ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows - end', 1, 'N');
1579: END IF;
1580: RETURN lx_tax_detail_tbl;
1581: END Query_Tax_Detail_Rows;
1582:

Line 3252: lx_price_adj_rltship_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rltship_Rows(

3248: lx_price_adj_tbl(l_price_adj_count).Credit_Or_Charge_Flag := 'C';
3249: END IF;
3250: -- 2800749 vtariker
3251:
3252: lx_price_adj_rltship_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rltship_Rows(
3253: lx_price_adj_tbl(l_price_adj_count).price_adjustment_id,
3254: P_Line_Index,
3255: lx_price_adj_rltship_tbl);
3256:

Line 3359: lx_price_adj_rltship_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rltship_Rows(

3355: lx_price_adj_tbl(l_price_adj_count).Credit_Or_Charge_Flag := 'C';
3356: END IF;
3357: -- 2800749 vtariker
3358:
3359: lx_price_adj_rltship_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rltship_Rows(
3360: lx_price_adj_tbl(l_price_adj_count).price_adjustment_id,
3361: P_Line_Index,
3362: lx_price_adj_rltship_tbl);
3363:

Line 3659: ASO_SUBMIT_QUOTE_PVT.Submit_Quote(

3655: l_Control_Rec.Calculate_Price := P_Calculate_Flag;
3656: l_Control_Rec.Server_Id := P_Server_Id;
3657: l_Qte_Header_Rec.Quote_Header_Id := P_Quote_Header_Id;
3658:
3659: ASO_SUBMIT_QUOTE_PVT.Submit_Quote(
3660: P_Api_Version_Number => 1.0,
3661: P_Control_Rec => l_Control_Rec,
3662: P_Qte_Header_Rec => l_Qte_Header_Rec,
3663: X_Order_Header_Rec => lx_Order_Header_Rec,

Line 3671: End ASO_SUBMIT_QUOTE_PVT;

3667:
3668: END Quote_Order_High_Availability;
3669:
3670:
3671: End ASO_SUBMIT_QUOTE_PVT;