1: PACKAGE BODY ASO_INPUT_PARAM_DEBUG as
2: /* $Header: asovinpb.pls 120.3 2006/06/13 21:39:04 skulkarn noship $ */
3: PROCEDURE Print_quote_input
4: (P_Quote_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
5: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
6: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
7: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
8: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
1: PACKAGE BODY ASO_INPUT_PARAM_DEBUG as
2: /* $Header: asovinpb.pls 120.3 2006/06/13 21:39:04 skulkarn noship $ */
3: PROCEDURE Print_quote_input
4: (P_Quote_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
5: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
6: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
7: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
8: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
9: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
2: /* $Header: asovinpb.pls 120.3 2006/06/13 21:39:04 skulkarn noship $ */
3: PROCEDURE Print_quote_input
4: (P_Quote_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
5: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
6: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
7: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
8: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
9: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
10: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
3: PROCEDURE Print_quote_input
4: (P_Quote_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
5: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
6: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
7: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
8: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
9: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
10: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
11: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
4: (P_Quote_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
5: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
6: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
7: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
8: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
9: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
10: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
11: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
12: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
5: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
6: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
7: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
8: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
9: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
10: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
11: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
12: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
13: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
6: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
7: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
8: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
9: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
10: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
11: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
12: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
13: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
14: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
7: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
8: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
9: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
10: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
11: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
12: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
13: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
14: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
15: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
8: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
9: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
10: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
11: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
12: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
13: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
14: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
15: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
16: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
9: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
10: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
11: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
12: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
13: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
14: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
15: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
16: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
17: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
10: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
11: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
12: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
13: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
14: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
15: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
16: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
17: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
18: P_Qte_Access_Tbl IN ASO_QUOTE_PUB.Qte_Access_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_TBL
11: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
12: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
13: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
14: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
15: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
16: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
17: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
18: P_Qte_Access_Tbl IN ASO_QUOTE_PUB.Qte_Access_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_TBL
19: )
12: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
13: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
14: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
15: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
16: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
17: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
18: P_Qte_Access_Tbl IN ASO_QUOTE_PUB.Qte_Access_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_TBL
19: )
20: IS
13: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
14: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
15: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
16: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
17: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
18: P_Qte_Access_Tbl IN ASO_QUOTE_PUB.Qte_Access_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_TBL
19: )
20: IS
21: i number;
14: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
15: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
16: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
17: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
18: P_Qte_Access_Tbl IN ASO_QUOTE_PUB.Qte_Access_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_TBL
19: )
20: IS
21: i number;
22: BEGIN