eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_QUOTE_VUHK dependencies on ASO_QUOTE_PUB

Line 40: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,

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,

Line 41: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_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,

Line 42: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_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,

Line 43: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_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,

Line 44: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_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,

Line 45: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_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,

Line 46: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_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 ,

Line 47: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_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,

Line 48: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_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,

Line 49: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_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,

Line 50: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_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,

Line 51: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_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,

Line 52: P_Line_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,
56: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

Line 53: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_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,

Line 54: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_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 ,

Line 55: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_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,

Line 56: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_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,

Line 57: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_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,

Line 58: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_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,

Line 59: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_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,

Line 60: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_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,

Line 61: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_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,
65: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 62: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_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,
66: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 63: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_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
67: )

Line 81: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,

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,

Line 82: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_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,

Line 83: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_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,

Line 84: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_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,

Line 85: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_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,

Line 86: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_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,

Line 87: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_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 ,

Line 88: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_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,

Line 89: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_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,

Line 90: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_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,

Line 91: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_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,

Line 92: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_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,

Line 93: P_Line_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,
97: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

Line 94: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_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,

Line 95: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_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 ,

Line 96: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_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,

Line 97: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_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,

Line 98: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_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,

Line 99: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_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,

Line 100: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_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,

Line 101: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_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,

Line 102: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_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,
106: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 103: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_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,
107: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 104: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_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
108: )

Line 154: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,

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,

Line 155: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_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,

Line 156: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_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,

Line 157: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_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,

Line 158: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_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,

Line 159: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_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,

Line 160: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_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 ,

Line 161: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_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,

Line 162: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_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,

Line 163: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_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,

Line 164: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_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,

Line 165: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_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,

Line 166: P_Line_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,
170: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

Line 167: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_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,

Line 168: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_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 ,

Line 169: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_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,

Line 170: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_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,

Line 171: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_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,

Line 172: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_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,

Line 173: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_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,

Line 174: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_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,

Line 175: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_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,
179: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 176: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_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,
180: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 177: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_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
181: )

Line 191: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,

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,

Line 192: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_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,

Line 193: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_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,

Line 194: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_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,

Line 195: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_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,

Line 196: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_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,

Line 197: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_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 ,

Line 198: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_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,

Line 199: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_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,

Line 200: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_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,

Line 201: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_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,

Line 202: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_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,

Line 203: P_Line_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,
207: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

Line 204: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_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,

Line 205: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_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 ,

Line 206: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_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,

Line 207: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_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,

Line 208: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_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,

Line 209: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_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,

Line 210: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_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,

Line 211: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_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,

Line 212: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_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,
216: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 213: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_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,
217: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 214: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_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
218: )

Line 368: p_control_rec IN OUT NOCOPY ASO_QUOTE_PUB.Submit_Control_Rec_Type,

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

Line 381: p_control_rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type ,

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,

Line 383: p_order_header_rec IN ASO_QUOTE_PUB.Order_Header_Rec_Type,

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

Line 434: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,

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,

Line 435: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_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 ,

Line 436: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_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,

Line 437: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_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,

Line 438: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_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,

Line 439: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_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,

Line 440: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_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,

Line 441: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_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 ,

Line 442: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_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,

Line 443: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_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,

Line 444: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_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,
448: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 445: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_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,
449: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 446: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_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,
450: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 459: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

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,

Line 460: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_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,

Line 461: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_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 ,

Line 462: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_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,

Line 463: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_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,

Line 464: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_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,

Line 465: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_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 ,

Line 466: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_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 ,

Line 467: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_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,

Line 468: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_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 ,

Line 469: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_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 ,
473: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 470: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_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,
474: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 471: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_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,
475: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 493: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,

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,

Line 494: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_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 ,

Line 495: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_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,

Line 496: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_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,

Line 497: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_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,

Line 498: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_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,

Line 499: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_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,

Line 500: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_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 ,

Line 501: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_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,

Line 502: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_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,

Line 503: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_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,
507: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 504: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_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,
508: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 505: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_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,
509: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 518: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

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,

Line 519: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_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,

Line 520: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_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 ,

Line 521: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_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,

Line 522: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_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,

Line 523: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_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,

Line 524: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_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 ,

Line 525: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_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 ,

Line 526: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_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,

Line 527: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_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 ,

Line 528: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_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 ,
532: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 529: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_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,
533: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 530: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_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,
534: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 572: P_qte_line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.qte_line_Rec_Type,

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

Line 573: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,

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

Line 583: P_qte_line_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type,

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

Line 584: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,

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: )

Line 596: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE,

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 )

Line 610: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE,

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 )

Line 611: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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