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.10.12000000.3 2007/07/09 08:56:28 vidsrini 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.10.12000000.3 2007/07/09 08:56:28 vidsrini 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 441: l_hd_price_adj_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Hdr_Rows(

437: count_rel := count_rel+1;
438: END LOOP;
439:
440:
441: l_hd_price_adj_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Hdr_Rows(
442: p_qte_header_id => p_qte_header_rec.quote_header_id,
443: p_qte_line_id => NULL);
444:
445: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 571: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Line_Dtl_Rows(

567: l_qte_line_tbl(i).accounting_rule_id := FND_API.G_MISS_NUM;
568: end if;
569: END IF;
570:
571: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Line_Dtl_Rows(
572: l_qte_line_id, i, l_qte_line_dtl_tbl);
573:
574: l_line_attr_Ext_Tbl := ASO_SUBMIT_QUOTE_PVT.Query_Line_Attribs_Ext_Rows(
575: l_qte_line_id, i, l_line_attr_ext_tbl);

Line 574: l_line_attr_Ext_Tbl := ASO_SUBMIT_QUOTE_PVT.Query_Line_Attribs_Ext_Rows(

570:
571: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Line_Dtl_Rows(
572: l_qte_line_id, i, l_qte_line_dtl_tbl);
573:
574: l_line_attr_Ext_Tbl := ASO_SUBMIT_QUOTE_PVT.Query_Line_Attribs_Ext_Rows(
575: l_qte_line_id, i, l_line_attr_ext_tbl);
576:
577: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rows(p_qte_header_rec.quote_header_id,
578: l_qte_line_tbl(i), i,

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

573:
574: l_line_attr_Ext_Tbl := ASO_SUBMIT_QUOTE_PVT.Query_Line_Attribs_Ext_Rows(
575: l_qte_line_id, i, l_line_attr_ext_tbl);
576:
577: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rows(p_qte_header_rec.quote_header_id,
578: l_qte_line_tbl(i), i,
579: l_ln_price_adj_rltship_tbl,
580: l_ln_price_adj_tbl );
581:

Line 589: := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rltship_Rows(

585: l_tmp_price_adj_tbl(j).operation_code := 'CREATE';
586:
587: -- pbh/prg
588: l_ln_price_adj_rltship_tbl
589: := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rltship_Rows(
590: l_tmp_price_adj_tbl(j).price_adjustment_id, i, l_ln_price_adj_rltship_tbl);
591: IF aso_debug_pub.g_debug_flag = 'Y' THEN
592: aso_debug_pub.add('Submit_Q: After l_ln_Price_Adj_Rltship_tbl.count: '||l_ln_Price_Adj_Rltship_tbl.count, 1, 'N');
593: END IF;

Line 606: l_ln_price_attr_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Attr_Rows(

602: l_ln_price_adj_tbl(l_index) := l_tmp_price_adj_tbl(j);
603: l_index := l_index+1;
604: END LOOP;
605: */
606: l_ln_price_attr_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Attr_Rows(
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;

Line 628: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Shipment_Rows(

624:
625: -- l_index := l_index+1;
626: END LOOP;
627:
628: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Shipment_Rows(
629: p_qte_header_rec.quote_header_id, L_QTE_LINE_ID,
630: i, l_ln_shipment_tbl);
631: /*
632: l_ln_freight_charge_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Freight_Charge_Rows(

Line 632: l_ln_freight_charge_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Freight_Charge_Rows(

628: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Shipment_Rows(
629: p_qte_header_rec.quote_header_id, L_QTE_LINE_ID,
630: i, l_ln_shipment_tbl);
631: /*
632: l_ln_freight_charge_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Freight_Charge_Rows(
633: l_ln_shipment_tbl, i, l_ln_freight_charge_tbl);
634: */
635: l_ln_tax_detail_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows(
636: p_qte_header_rec.quote_header_id,

Line 635: l_ln_tax_detail_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows(

631: /*
632: l_ln_freight_charge_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Freight_Charge_Rows(
633: l_ln_shipment_tbl, i, l_ln_freight_charge_tbl);
634: */
635: l_ln_tax_detail_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows(
636: p_qte_header_rec.quote_header_id,
637: L_QTE_LINE_ID, l_ln_shipment_tbl.count,
638: i, l_ln_tax_detail_tbl);
639:

Line 649: l_ln_sales_credit_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Sales_Credit_Row (

645: l_line_rltship_tbl(j).related_qte_line_index := i;
646: END IF;
647: END LOOP;
648:
649: l_ln_sales_credit_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Sales_Credit_Row (
650: p_qte_header_rec.quote_header_id, l_qte_line_id,
651: i, l_ln_sales_credit_tbl);
652:
653: l_ln_quote_party_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Quote_Party_Row(

Line 653: l_ln_quote_party_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Quote_Party_Row(

649: l_ln_sales_credit_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Sales_Credit_Row (
650: p_qte_header_rec.quote_header_id, l_qte_line_id,
651: i, l_ln_sales_credit_tbl);
652:
653: l_ln_quote_party_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Quote_Party_Row(
654: p_qte_header_rec.quote_header_id, l_qte_line_id,
655: i, l_ln_quote_party_tbl);
656:
657: END LOOP; -- Line_Tbl loop

Line 1087: ASO_SUBMIT_QUOTE_PVT.Raise_Quote_Event (

1083: aso_debug_pub.add('Submit_Q: In HA: X_Current_State: '||X_Current_State, 1, 'N');
1084: END IF;
1085: ROLLBACK TO SUBMIT_QUOTE_PVT;
1086:
1087: ASO_SUBMIT_QUOTE_PVT.Raise_Quote_Event (
1088: P_Quote_Header_Id => p_qte_header_rec.quote_header_id,
1089: P_Control_Rec => p_control_rec,
1090: X_Return_Status => x_return_status );
1091:

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

1319: --Fix for bug 5714535. Setting the output table structure directly instead of
1320: --setting it through the local record structure.
1321:
1322: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1323: aso_debug_pub.add('Begin ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows', 1, 'N');
1324: END IF;
1325:
1326: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
1327:

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

1421: END LOOP;
1422: END IF;
1423:
1424: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1425: aso_debug_pub.add('ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows - end', 1, 'N');
1426: END IF;
1427: RETURN lx_tax_detail_tbl;
1428: END Query_Tax_Detail_Rows;
1429:

Line 3099: lx_price_adj_rltship_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rltship_Rows(

3095: lx_price_adj_tbl(l_price_adj_count).Credit_Or_Charge_Flag := 'C';
3096: END IF;
3097: -- 2800749 vtariker
3098:
3099: lx_price_adj_rltship_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rltship_Rows(
3100: lx_price_adj_tbl(l_price_adj_count).price_adjustment_id,
3101: P_Line_Index,
3102: lx_price_adj_rltship_tbl);
3103:

Line 3206: lx_price_adj_rltship_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rltship_Rows(

3202: lx_price_adj_tbl(l_price_adj_count).Credit_Or_Charge_Flag := 'C';
3203: END IF;
3204: -- 2800749 vtariker
3205:
3206: lx_price_adj_rltship_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rltship_Rows(
3207: lx_price_adj_tbl(l_price_adj_count).price_adjustment_id,
3208: P_Line_Index,
3209: lx_price_adj_rltship_tbl);
3210:

Line 3506: ASO_SUBMIT_QUOTE_PVT.Submit_Quote(

3502: l_Control_Rec.Calculate_Price := P_Calculate_Flag;
3503: l_Control_Rec.Server_Id := P_Server_Id;
3504: l_Qte_Header_Rec.Quote_Header_Id := P_Quote_Header_Id;
3505:
3506: ASO_SUBMIT_QUOTE_PVT.Submit_Quote(
3507: P_Api_Version_Number => 1.0,
3508: P_Control_Rec => l_Control_Rec,
3509: P_Qte_Header_Rec => l_Qte_Header_Rec,
3510: X_Order_Header_Rec => lx_Order_Header_Rec,

Line 3518: End ASO_SUBMIT_QUOTE_PVT;

3514:
3515: END Quote_Order_High_Availability;
3516:
3517:
3518: End ASO_SUBMIT_QUOTE_PVT;