36:
37: END Get_Product_Status;
38: PROCEDURE Create_quote_PRE(
39: P_Validation_Level IN OUT NOCOPY NUMBER ,
40: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
41: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
42: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
43: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
44: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
37: END Get_Product_Status;
38: PROCEDURE Create_quote_PRE(
39: P_Validation_Level IN OUT NOCOPY NUMBER ,
40: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
41: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
42: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
43: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
44: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
45: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
38: PROCEDURE Create_quote_PRE(
39: P_Validation_Level IN OUT NOCOPY NUMBER ,
40: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
41: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
42: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
43: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
44: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
45: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
46: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
39: P_Validation_Level IN OUT NOCOPY NUMBER ,
40: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
41: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
42: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
43: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
44: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
45: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
46: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
47: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
40: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
41: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
42: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
43: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
44: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
45: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
46: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
47: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
48: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
41: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
42: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
43: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
44: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
45: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
46: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
47: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
48: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
49: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
42: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
43: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
44: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
45: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
46: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
47: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
48: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
49: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
50: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
43: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
44: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
45: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
46: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
47: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
48: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
49: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
50: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
51: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
44: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
45: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
46: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
47: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
48: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
49: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
50: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
51: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
52: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
45: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
46: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
47: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
48: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
49: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
50: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
51: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
52: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
53: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
46: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
47: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
48: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
49: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
50: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
51: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
52: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
53: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
54: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
47: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
48: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
49: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
50: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
51: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
52: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
53: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
54: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
55: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
48: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
49: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
50: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
51: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
52: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
53: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
54: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
55: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
56: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
49: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
50: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
51: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
52: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
53: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
54: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
55: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
56: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
57: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
50: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
51: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
52: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
53: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
54: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
55: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
56: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
57: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
58: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
51: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
52: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
53: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
54: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
55: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
56: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
57: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
58: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
59: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
52: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
53: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
54: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
55: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
56: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
57: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
58: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
59: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
60: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
53: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
54: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
55: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
56: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
57: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
58: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
59: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
60: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
61: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
54: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
55: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
56: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
57: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
58: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
59: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
60: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
61: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
62: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
55: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
56: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
57: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
58: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
59: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
60: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
61: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
62: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
63: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
56: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
57: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
58: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
59: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
60: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
61: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
62: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
63: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
64: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
57: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
58: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
59: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
60: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
61: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
62: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
63: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
64: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
65: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
58: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
59: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
60: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
61: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
62: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
63: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
64: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
65: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
66: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
59: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
60: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
61: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
62: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
63: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
64: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
65: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
66: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67: )
77:
78:
79: PROCEDURE Create_quote_POST(
80: P_Validation_Level IN NUMBER ,
81: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
82: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
83: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
84: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
85: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
78:
79: PROCEDURE Create_quote_POST(
80: P_Validation_Level IN NUMBER ,
81: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
82: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
83: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
84: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
85: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
86: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
79: PROCEDURE Create_quote_POST(
80: P_Validation_Level IN NUMBER ,
81: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
82: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
83: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
84: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
85: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
86: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
87: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
80: P_Validation_Level IN NUMBER ,
81: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
82: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
83: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
84: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
85: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
86: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
87: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
88: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
81: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
82: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
83: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
84: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
85: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
86: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
87: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
88: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
82: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
83: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
84: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
85: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
86: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
87: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
88: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
90: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
83: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
84: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
85: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
86: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
87: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
88: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
90: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
91: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
84: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
85: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
86: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
87: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
88: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
90: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
91: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
92: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
85: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
86: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
87: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
88: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
90: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
91: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
92: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
93: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
86: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
87: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
88: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
90: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
91: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
92: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
93: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
94: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
87: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
88: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
90: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
91: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
92: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
93: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
94: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
95: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
88: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
90: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
91: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
92: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
93: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
94: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
95: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
96: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
89: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
90: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
91: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
92: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
93: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
94: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
95: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
96: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
97: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
90: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
91: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
92: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
93: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
94: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
95: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
96: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
97: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
98: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
91: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
92: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
93: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
94: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
95: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
96: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
97: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
98: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
99: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
92: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
93: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
94: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
95: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
96: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
97: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
98: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
99: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
100: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
93: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
94: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
95: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
96: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
97: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
98: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
99: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
100: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
101: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
94: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
95: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
96: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
97: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
98: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
99: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
100: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
101: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
102: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
95: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
96: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
97: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
98: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
99: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
100: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
101: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
102: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
103: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
96: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
97: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
98: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
99: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
100: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
101: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
102: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
103: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
104: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
97: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
98: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
99: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
100: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
101: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
102: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
103: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
104: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
105: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
98: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
99: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
100: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
101: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
102: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
103: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
104: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
105: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
106: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
99: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
100: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
101: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
102: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
103: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
104: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
105: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
106: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
107: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
100: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
101: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
102: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
103: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
104: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
105: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
106: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
107: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108: )
150: --
151: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
152: PROCEDURE Update_quote_PRE(
153: P_Validation_Level IN OUT NOCOPY NUMBER ,
154: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
155: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
156: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
157: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
158: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
151: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
152: PROCEDURE Update_quote_PRE(
153: P_Validation_Level IN OUT NOCOPY NUMBER ,
154: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
155: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
156: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
157: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
158: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
159: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
152: PROCEDURE Update_quote_PRE(
153: P_Validation_Level IN OUT NOCOPY NUMBER ,
154: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
155: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
156: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
157: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
158: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
159: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
160: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
153: P_Validation_Level IN OUT NOCOPY NUMBER ,
154: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
155: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
156: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
157: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
158: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
159: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
160: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
161: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
154: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
155: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
156: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
157: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
158: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
159: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
160: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
161: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
162: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
155: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
156: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
157: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
158: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
159: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
160: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
161: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
162: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
163: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
156: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
157: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
158: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
159: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
160: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
161: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
162: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
163: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
164: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
157: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
158: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
159: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
160: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
161: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
162: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
163: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
164: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
165: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
158: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
159: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
160: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
161: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
162: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
163: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
164: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
165: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
166: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
159: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
160: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
161: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
162: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
163: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
164: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
165: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
166: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
167: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
160: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
161: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
162: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
163: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
164: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
165: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
166: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
167: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
168: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
161: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
162: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
163: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
164: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
165: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
166: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
167: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
168: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
169: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
162: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
163: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
164: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
165: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
166: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
167: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
168: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
169: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
170: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
163: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
164: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
165: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
166: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
167: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
168: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
169: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
170: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
171: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
164: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
165: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
166: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
167: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
168: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
169: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
170: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
171: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
172: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
165: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
166: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
167: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
168: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
169: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
170: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
171: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
172: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
173: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
166: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
167: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
168: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
169: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
170: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
171: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
172: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
173: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
174: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
167: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
168: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
169: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
170: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
171: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
172: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
173: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
174: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
175: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
168: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
169: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
170: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
171: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
172: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
173: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
174: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
175: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
176: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
169: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
170: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
171: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
172: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
173: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
174: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
175: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
176: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
177: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
170: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
171: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
172: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
173: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
174: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
175: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
176: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
177: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
178: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
171: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
172: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
173: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
174: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
175: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
176: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
177: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
178: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
179: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
172: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
173: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
174: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
175: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
176: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
177: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
178: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
179: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
180: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
173: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
174: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
175: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
176: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
177: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
178: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
179: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
180: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
181: )
187:
188:
189: PROCEDURE UPdate_quote_POST(
190: P_Validation_Level IN NUMBER ,
191: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
192: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
193: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
194: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
195: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
188:
189: PROCEDURE UPdate_quote_POST(
190: P_Validation_Level IN NUMBER ,
191: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
192: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
193: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
194: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
195: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
196: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
189: PROCEDURE UPdate_quote_POST(
190: P_Validation_Level IN NUMBER ,
191: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
192: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
193: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
194: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
195: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
196: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
197: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
190: P_Validation_Level IN NUMBER ,
191: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
192: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
193: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
194: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
195: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
196: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
197: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
198: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
191: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
192: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
193: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
194: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
195: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
196: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
197: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
198: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
199: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
192: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
193: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
194: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
195: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
196: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
197: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
198: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
199: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
200: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
193: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
194: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
195: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
196: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
197: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
198: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
199: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
200: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
201: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
194: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
195: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
196: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
197: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
198: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
199: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
200: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
201: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
202: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
195: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
196: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
197: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
198: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
199: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
200: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
201: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
202: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
203: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
196: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
197: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
198: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
199: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
200: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
201: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
202: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
203: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
204: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
197: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
198: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
199: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
200: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
201: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
202: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
203: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
204: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
205: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
198: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
199: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
200: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
201: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
202: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
203: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
204: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
205: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
206: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
199: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
200: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
201: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
202: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
203: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
204: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
205: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
206: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
207: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
200: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
201: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
202: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
203: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
204: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
205: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
206: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
207: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
208: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
201: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
202: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
203: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
204: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
205: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
206: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
207: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
208: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
209: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
202: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
203: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
204: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
205: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
206: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
207: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
208: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
209: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
210: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
203: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
204: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
205: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
206: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
207: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
208: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
209: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
210: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
211: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
204: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
205: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
206: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
207: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
208: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
209: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
210: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
211: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
212: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
205: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
206: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
207: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
208: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
209: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
210: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
211: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
212: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
213: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
206: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
207: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
208: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
209: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
210: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
211: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
212: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
213: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
214: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
207: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
208: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
209: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
210: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
211: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
212: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
213: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
214: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
215: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
208: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
209: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
210: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
211: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
212: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
213: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
214: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
215: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
216: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
209: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
210: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
211: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
212: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
213: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
214: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
215: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
216: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
217: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
210: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
211: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
212: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
213: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
214: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
215: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
216: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
217: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
218: )
364: --
365: -- End of Comments
366: --
367: PROCEDURE Submit_quote_PRE(
368: p_control_rec IN OUT NOCOPY ASO_QUOTE_PUB.Submit_Control_Rec_Type,
369: P_Qte_Header_Id IN OUT NOCOPY NUMBER,
370: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
371: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
372: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
377: END;
378:
379:
380: PROCEDURE Submit_quote_POST(
381: p_control_rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type ,
382: P_Qte_Header_Id IN NUMBER,
383: p_order_header_rec IN ASO_QUOTE_PUB.Order_Header_Rec_Type,
384: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
385: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
379:
380: PROCEDURE Submit_quote_POST(
381: p_control_rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type ,
382: P_Qte_Header_Id IN NUMBER,
383: p_order_header_rec IN ASO_QUOTE_PUB.Order_Header_Rec_Type,
384: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
385: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
386: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
387: )IS
430: -- the public api
431: -- End of Comments
432: --
433: PROCEDURE Create_Quote_Line_PRE(
434: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
435: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
436: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
437: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
438: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
431: -- End of Comments
432: --
433: PROCEDURE Create_Quote_Line_PRE(
434: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
435: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
436: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
437: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
438: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
439: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
432: --
433: PROCEDURE Create_Quote_Line_PRE(
434: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
435: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
436: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
437: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
438: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
439: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
440: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
433: PROCEDURE Create_Quote_Line_PRE(
434: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
435: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
436: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
437: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
438: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
439: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
440: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
441: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
434: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
435: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
436: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
437: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
438: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
439: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
440: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
441: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
442: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
435: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
436: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
437: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
438: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
439: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
440: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
441: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
442: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
443: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
436: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
437: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
438: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
439: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
440: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
441: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
442: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
443: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
444: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
437: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
438: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
439: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
440: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
441: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
442: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
443: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
444: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
445: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
438: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
439: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
440: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
441: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
442: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
443: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
444: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
445: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
446: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
439: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
440: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
441: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
442: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
443: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
444: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
445: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
446: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
447: P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
440: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
441: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
442: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
443: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
444: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
445: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
446: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
447: P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
448: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
441: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
442: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
443: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
444: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
445: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
446: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
447: P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
448: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
449: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
442: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
443: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
444: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
445: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
446: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
447: P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
448: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
449: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
450: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
455:
456:
457:
458: PROCEDURE Create_Quote_Line_POST(
459: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
460: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
461: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
462: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
463: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
456:
457:
458: PROCEDURE Create_Quote_Line_POST(
459: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
460: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
461: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
462: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
463: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
464: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
457:
458: PROCEDURE Create_Quote_Line_POST(
459: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
460: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
461: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
462: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
463: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
464: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
465: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
458: PROCEDURE Create_Quote_Line_POST(
459: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
460: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
461: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
462: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
463: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
464: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
465: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
466: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
459: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
460: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
461: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
462: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
463: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
464: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
465: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
466: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
467: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
460: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
461: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
462: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
463: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
464: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
465: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
466: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
467: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
468: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
461: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
462: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
463: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
464: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
465: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
466: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
467: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
468: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
469: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
462: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
463: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
464: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
465: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
466: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
467: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
468: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
469: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
470: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
463: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
464: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
465: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
466: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
467: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
468: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
469: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
470: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
471: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
464: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
465: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
466: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
467: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
468: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
469: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
470: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
471: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
472: P_Update_Header_Flag IN VARCHAR2 ,
465: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
466: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
467: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
468: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
469: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
470: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
471: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
472: P_Update_Header_Flag IN VARCHAR2 ,
473: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
466: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
467: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
468: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
469: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
470: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
471: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
472: P_Update_Header_Flag IN VARCHAR2 ,
473: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
474: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
467: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
468: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
469: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
470: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
471: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
472: P_Update_Header_Flag IN VARCHAR2 ,
473: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
474: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
475: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
489: -- IN
490:
491:
492: PROCEDURE Update_Quote_Line_PRE(
493: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
494: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
495: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
496: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
497: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
490:
491:
492: PROCEDURE Update_Quote_Line_PRE(
493: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
494: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
495: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
496: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
497: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
498: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
491:
492: PROCEDURE Update_Quote_Line_PRE(
493: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
494: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
495: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
496: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
497: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
498: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
499: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
492: PROCEDURE Update_Quote_Line_PRE(
493: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
494: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
495: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
496: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
497: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
498: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
499: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
500: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
493: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
494: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
495: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
496: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
497: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
498: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
499: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
500: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
501: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
494: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
495: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
496: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
497: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
498: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
499: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
500: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
501: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
502: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
495: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
496: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
497: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
498: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
499: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
500: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
501: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
502: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
503: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
496: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
497: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
498: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
499: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
500: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
501: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
502: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
503: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
504: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
497: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
498: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
499: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
500: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
501: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
502: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
503: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
504: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
505: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
498: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
499: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
500: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
501: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
502: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
503: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
504: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
505: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
506: P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
499: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
500: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
501: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
502: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
503: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
504: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
505: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
506: P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
507: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
500: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
501: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
502: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
503: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
504: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
505: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
506: P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
507: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
508: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
501: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
502: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
503: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
504: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
505: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
506: P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
507: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
508: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
509: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
514:
515:
516:
517: PROCEDURE Update_Quote_Line_POST(
518: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
519: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
520: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
521: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
522: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
515:
516:
517: PROCEDURE Update_Quote_Line_POST(
518: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
519: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
520: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
521: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
522: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
523: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
516:
517: PROCEDURE Update_Quote_Line_POST(
518: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
519: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
520: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
521: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
522: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
523: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
524: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
517: PROCEDURE Update_Quote_Line_POST(
518: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
519: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
520: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
521: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
522: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
523: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
524: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
525: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
518: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
519: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
520: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
521: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
522: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
523: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
524: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
525: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
526: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
519: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
520: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
521: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
522: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
523: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
524: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
525: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
526: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
527: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
520: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
521: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
522: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
523: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
524: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
525: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
526: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
527: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
528: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
521: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
522: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
523: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
524: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
525: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
526: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
527: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
528: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
529: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
522: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
523: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
524: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
525: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
526: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
527: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
528: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
529: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
530: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
523: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
524: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
525: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
526: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
527: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
528: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
529: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
530: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
531: P_Update_Header_Flag IN VARCHAR2 ,
524: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
525: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
526: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
527: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
528: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
529: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
530: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
531: P_Update_Header_Flag IN VARCHAR2 ,
532: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
525: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
526: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
527: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
528: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
529: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
530: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
531: P_Update_Header_Flag IN VARCHAR2 ,
532: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
533: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
526: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
527: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
528: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
529: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
530: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
531: P_Update_Header_Flag IN VARCHAR2 ,
532: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
533: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
534: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
568: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
569: -- The Master delete procedure may not be needed depends on different business requirements.
570:
571: PROCEDURE Delete_Quote_Line_PRE(
572: P_qte_line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.qte_line_Rec_Type,
573: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
574: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
575: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
576: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
569: -- The Master delete procedure may not be needed depends on different business requirements.
570:
571: PROCEDURE Delete_Quote_Line_PRE(
572: P_qte_line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.qte_line_Rec_Type,
573: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
574: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
575: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
576: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
577: )IS
579: NULL;
580: END;
581:
582: PROCEDURE Delete_Quote_Line_POST(
583: P_qte_line_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type,
584: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
585: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
586: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
587: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
580: END;
581:
582: PROCEDURE Delete_Quote_Line_POST(
583: P_qte_line_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type,
584: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
585: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
586: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
587: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
588: )
592: END;
593:
594:
595: PROCEDURE Allocate_Sales_Credits_PRE(
596: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE,
597: P_Qte_Header_Id IN NUMBER,
598: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
599: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
600: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
606: END;
607:
608:
609: PROCEDURE Allocate_Sales_Credits_POST(
610: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE,
611: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
612: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
613: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
614: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
607:
608:
609: PROCEDURE Allocate_Sales_Credits_POST(
610: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE,
611: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
612: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
613: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
614: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
615: IS