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_CUHK dependencies on ASO_QUOTE_PUB

Line 42: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,

38:
39:
40: PROCEDURE Create_quote_PRE(
41: P_Validation_Level IN OUT NOCOPY NUMBER ,
42: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
43: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
44: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
45: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
46: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,

Line 43: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,

39:
40: PROCEDURE Create_quote_PRE(
41: P_Validation_Level IN OUT NOCOPY NUMBER ,
42: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
43: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
44: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
45: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
46: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
47: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

Line 44: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,

40: PROCEDURE Create_quote_PRE(
41: P_Validation_Level IN OUT NOCOPY NUMBER ,
42: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
43: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
44: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
45: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
46: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
47: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
48: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

Line 45: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,

41: P_Validation_Level IN OUT NOCOPY NUMBER ,
42: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
43: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
44: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
45: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
46: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
47: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
48: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
49: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,

Line 46: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,

42: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
43: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
44: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
45: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
46: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
47: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
48: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
49: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
50: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,

Line 47: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

43: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
44: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
45: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
46: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
47: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
48: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
49: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
50: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
51: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

Line 48: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

44: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
45: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
46: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
47: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
48: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
49: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
50: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
51: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
52: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,

Line 49: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,

45: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
46: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
47: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
48: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
49: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
50: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
51: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
52: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
53: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

Line 50: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,

46: P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
47: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
48: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
49: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
50: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
51: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
52: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
53: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
54: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,

Line 51: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

47: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
48: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
49: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
50: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
51: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
52: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
53: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
54: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
55: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,

Line 52: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,

48: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
49: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
50: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
51: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
52: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
53: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
54: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
55: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
56: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

Line 53: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

49: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
50: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
51: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
52: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
53: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
54: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
55: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
56: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
57: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

Line 54: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,

50: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
51: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
52: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
53: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
54: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
55: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
56: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
57: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
58: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

Line 55: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,

51: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
52: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
53: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
54: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
55: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
56: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
57: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
58: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
59: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

Line 56: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

52: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
53: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
54: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
55: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
56: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
57: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
58: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
59: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
60: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,

Line 57: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

53: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
54: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
55: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
56: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
57: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
58: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
59: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
60: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
61: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,

Line 58: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

54: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
55: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
56: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
57: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
58: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
59: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
60: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
61: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
62: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

Line 59: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

55: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
56: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
57: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
58: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
59: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
60: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
61: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
62: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
63: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

Line 60: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,

56: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
57: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
58: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
59: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
60: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
61: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
62: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
63: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
64: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,

Line 61: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,

57: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
58: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
59: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
60: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
61: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
62: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
63: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
64: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
65: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

Line 62: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

58: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
59: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
60: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
61: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
62: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
63: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
64: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
65: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
66: P_Related_Obj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type,

Line 63: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

59: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
60: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
61: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
62: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
63: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
64: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
65: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
66: P_Related_Obj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type,
67: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 64: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,

60: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
61: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
62: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
63: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
64: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
65: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
66: P_Related_Obj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type,
67: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
68: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 65: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

61: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
62: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
63: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
64: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
65: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
66: P_Related_Obj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type,
67: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
68: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
69: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 66: P_Related_Obj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type,

62: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
63: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
64: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
65: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
66: P_Related_Obj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type,
67: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
68: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
69: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
70: );

Line 76: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,

72:
73:
74: PROCEDURE Create_quote_POST(
75: P_Validation_Level IN NUMBER ,
76: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
77: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
78: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
79: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
80: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,

Line 77: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,

73:
74: PROCEDURE Create_quote_POST(
75: P_Validation_Level IN NUMBER ,
76: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
77: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
78: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
79: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
80: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
81: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

Line 78: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,

74: PROCEDURE Create_quote_POST(
75: P_Validation_Level IN NUMBER ,
76: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
77: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
78: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
79: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
80: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
81: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
82: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

Line 79: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,

75: P_Validation_Level IN NUMBER ,
76: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
77: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
78: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
79: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
80: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
81: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
82: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
83: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,

Line 80: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,

76: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
77: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
78: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
79: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
80: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
81: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
82: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
83: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
84: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,

Line 81: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

77: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
78: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
79: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
80: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
81: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
82: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
83: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
84: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
85: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

Line 82: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

78: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
79: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
80: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
81: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
82: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
83: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
84: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
85: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
86: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,

Line 83: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,

79: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
80: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
81: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
82: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
83: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
84: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
85: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
86: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
87: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

Line 84: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,

80: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
81: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
82: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
83: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
84: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
85: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
86: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
87: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
88: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,

Line 85: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

81: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
82: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
83: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
84: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
85: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
86: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
87: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
88: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,

Line 86: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,

82: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
83: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
84: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
85: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
86: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
87: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
88: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
90: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

Line 87: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

83: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
84: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
85: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
86: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
87: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
88: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
90: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
91: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

Line 88: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,

84: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
85: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
86: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
87: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
88: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
90: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
91: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
92: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

Line 89: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,

85: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
86: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
87: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
88: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
90: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
91: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
92: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
93: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

Line 90: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

86: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
87: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
88: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
90: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
91: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
92: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
93: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
94: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,

Line 91: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

87: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
88: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
90: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
91: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
92: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
93: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
94: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
95: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,

Line 92: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

88: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
90: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
91: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
92: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
93: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
94: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
95: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
96: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

Line 93: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

89: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
90: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
91: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
92: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
93: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
94: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
95: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
96: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
97: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

Line 94: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,

90: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
91: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
92: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
93: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
94: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
95: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
96: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
97: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
98: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,

Line 95: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,

91: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
92: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
93: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
94: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
95: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
96: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
97: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
98: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
99: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

Line 96: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

92: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
93: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
94: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
95: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
96: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
97: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
98: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
99: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
100: P_Related_Obj_Tbl IN ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type, -- bug 13533957

Line 97: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

93: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
94: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
95: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
96: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
97: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
98: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
99: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
100: P_Related_Obj_Tbl IN ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type, -- bug 13533957
101: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 98: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,

94: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
95: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
96: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
97: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
98: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
99: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
100: P_Related_Obj_Tbl IN ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type, -- bug 13533957
101: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
102: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 99: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

95: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
96: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
97: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
98: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
99: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
100: P_Related_Obj_Tbl IN ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type, -- bug 13533957
101: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
102: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
103: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 100: P_Related_Obj_Tbl IN ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type, -- bug 13533957

96: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
97: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
98: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
99: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
100: P_Related_Obj_Tbl IN ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type, -- bug 13533957
101: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
102: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
103: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104: );

Line 136: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,

132: --
133: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
134: PROCEDURE Update_quote_PRE(
135: P_Validation_Level IN OUT NOCOPY /* file.sql.39 change */ NUMBER ,
136: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
137: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
138: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
139: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
140: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,

Line 137: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,

133: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
134: PROCEDURE Update_quote_PRE(
135: P_Validation_Level IN OUT NOCOPY /* file.sql.39 change */ NUMBER ,
136: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
137: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
138: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
139: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
140: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
141: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

Line 138: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,

134: PROCEDURE Update_quote_PRE(
135: P_Validation_Level IN OUT NOCOPY /* file.sql.39 change */ NUMBER ,
136: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
137: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
138: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
139: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
140: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
141: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
142: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

Line 139: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,

135: P_Validation_Level IN OUT NOCOPY /* file.sql.39 change */ NUMBER ,
136: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
137: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
138: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
139: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
140: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
141: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
142: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
143: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,

Line 140: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,

136: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
137: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
138: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
139: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
140: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
141: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
142: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
143: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
144: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,

Line 141: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

137: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
138: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
139: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
140: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
141: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
142: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
143: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
144: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
145: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

Line 142: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

138: P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
139: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
140: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
141: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
142: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
143: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
144: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
145: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
146: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,

Line 143: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,

139: P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
140: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
141: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
142: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
143: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
144: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
145: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
146: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
147: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

Line 144: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,

140: P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
141: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
142: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
143: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
144: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
145: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
146: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
147: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
148: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,

Line 145: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

141: P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
142: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
143: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
144: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
145: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
146: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
147: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
148: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
149: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,

Line 146: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,

142: P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
143: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
144: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
145: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
146: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
147: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
148: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
149: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
150: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

Line 147: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

143: P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
144: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
145: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
146: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
147: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
148: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
149: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
150: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
151: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

Line 148: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,

144: P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
145: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
146: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
147: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
148: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
149: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
150: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
151: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
152: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

Line 149: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,

145: P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
146: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
147: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
148: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
149: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
150: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
151: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
152: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
153: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

Line 150: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

146: P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
147: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
148: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
149: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
150: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
151: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
152: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
153: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
154: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,

Line 151: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

147: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
148: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
149: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
150: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
151: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
152: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
153: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
154: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
155: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,

Line 152: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

148: P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
149: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
150: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
151: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
152: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
153: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
154: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
155: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
156: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

Line 153: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

149: P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
150: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
151: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
152: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
153: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
154: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
155: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
156: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
157: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

Line 154: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,

150: P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
151: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
152: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
153: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
154: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
155: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
156: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
157: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
158: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,

Line 155: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,

151: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
152: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
153: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
154: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
155: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
156: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
157: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
158: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
159: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,

Line 156: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

152: P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
153: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
154: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
155: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
156: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
157: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
158: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
159: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
160: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 157: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

153: P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
154: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
155: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
156: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
157: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
158: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
159: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
160: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
161: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 158: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,

154: P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
155: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
156: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
157: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
158: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
159: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
160: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
161: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
162: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 159: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,

155: P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
156: P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
157: P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
158: P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
159: P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
160: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
161: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
162: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
163: );

Line 169: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,

165:
166:
167: PROCEDURE UPdate_quote_POST(
168: P_Validation_Level IN NUMBER ,
169: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
170: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
171: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
172: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
173: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,

Line 170: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,

166:
167: PROCEDURE UPdate_quote_POST(
168: P_Validation_Level IN NUMBER ,
169: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
170: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
171: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
172: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
173: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
174: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

Line 171: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,

167: PROCEDURE UPdate_quote_POST(
168: P_Validation_Level IN NUMBER ,
169: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
170: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
171: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
172: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
173: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
174: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
175: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

Line 172: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,

168: P_Validation_Level IN NUMBER ,
169: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
170: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
171: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
172: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
173: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
174: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
175: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
176: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,

Line 173: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,

169: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
170: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
171: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
172: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
173: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
174: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
175: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
176: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
177: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,

Line 174: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

170: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
171: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
172: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
173: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
174: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
175: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
176: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
177: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
178: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

Line 175: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

171: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
172: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
173: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
174: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
175: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
176: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
177: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
178: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
179: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,

Line 176: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,

172: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
173: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
174: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
175: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
176: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
177: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
178: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
179: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
180: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

Line 177: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,

173: P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
174: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
175: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
176: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
177: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
178: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
179: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
180: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
181: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,

Line 178: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

174: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
175: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
176: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
177: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
178: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
179: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
180: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
181: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
182: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,

Line 179: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,

175: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
176: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
177: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
178: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
179: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
180: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
181: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
182: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
183: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

Line 180: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

176: P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
177: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
178: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
179: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
180: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
181: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
182: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
183: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
184: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

Line 181: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,

177: P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
178: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
179: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
180: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
181: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
182: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
183: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
184: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
185: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

Line 182: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,

178: P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
179: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
180: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
181: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
182: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
183: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
184: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
185: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
186: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

Line 183: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

179: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
180: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
181: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
182: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
183: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
184: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
185: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
186: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
187: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,

Line 184: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

180: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
181: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
182: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
183: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
184: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
185: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
186: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
187: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
188: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,

Line 185: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

181: P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
182: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
183: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
184: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
185: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
186: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
187: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
188: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
189: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

Line 186: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

182: P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
183: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
184: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
185: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
186: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
187: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
188: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
189: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
190: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

Line 187: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,

183: P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
184: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
185: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
186: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
187: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
188: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
189: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
190: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
191: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,

Line 188: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,

184: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
185: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
186: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
187: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
188: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
189: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
190: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
191: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
192: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,

Line 189: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

185: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
186: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
187: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
188: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
189: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
190: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
191: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
192: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
193: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 190: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

186: P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
187: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
188: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
189: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
190: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
191: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
192: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
193: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
194: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 191: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,

187: P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
188: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
189: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
190: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
191: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
192: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
193: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
194: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
195: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 192: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,

188: P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
189: P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
190: P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
191: P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
192: P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
193: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
194: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
195: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
196: );

Line 318: p_control_rec IN OUT NOCOPY ASO_QUOTE_PUB.Submit_Control_Rec_Type,

314: --
315: -- End of Comments
316: --
317: PROCEDURE Submit_quote_PRE(
318: p_control_rec IN OUT NOCOPY ASO_QUOTE_PUB.Submit_Control_Rec_Type,
319: P_Qte_Header_Id IN OUT NOCOPY NUMBER,
320: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
321: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
322: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 327: p_control_rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type ,

323: );
324:
325:
326: PROCEDURE Submit_quote_POST(
327: p_control_rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type ,
328: P_Qte_Header_Id IN NUMBER,
329: p_order_header_rec IN ASO_QUOTE_PUB.Order_Header_Rec_Type,
330: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
331: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 329: p_order_header_rec IN ASO_QUOTE_PUB.Order_Header_Rec_Type,

325:
326: PROCEDURE Submit_quote_POST(
327: p_control_rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type ,
328: P_Qte_Header_Id IN NUMBER,
329: p_order_header_rec IN ASO_QUOTE_PUB.Order_Header_Rec_Type,
330: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
331: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
332: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
333: );

Line 380: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,

376: -- the public api
377: -- End of Comments
378: --
379: PROCEDURE Create_Quote_Line_PRE(
380: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
381: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
382: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
383: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
384: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,

Line 381: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,

377: -- End of Comments
378: --
379: PROCEDURE Create_Quote_Line_PRE(
380: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
381: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
382: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
383: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
384: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
385: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,

Line 382: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

378: --
379: PROCEDURE Create_Quote_Line_PRE(
380: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
381: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
382: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
383: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
384: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
385: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
386: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

Line 383: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,

379: PROCEDURE Create_Quote_Line_PRE(
380: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
381: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
382: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
383: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
384: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
385: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
386: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
387: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

Line 384: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,

380: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
381: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
382: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
383: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
384: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
385: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
386: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
387: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
388: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,

Line 385: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,

381: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
382: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
383: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
384: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
385: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
386: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
387: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
388: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
389: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

Line 386: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

382: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
383: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
384: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
385: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
386: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
387: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
388: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
389: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
390: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

Line 387: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

383: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
384: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
385: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
386: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
387: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
388: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
389: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
390: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
391: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,

Line 388: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,

384: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
385: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
386: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
387: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
388: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
389: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
390: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
391: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
392: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

Line 389: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

385: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
386: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
387: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
388: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
389: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
390: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
391: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
392: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
393: P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,

Line 390: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

386: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
387: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
388: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
389: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
390: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
391: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
392: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
393: P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
394: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 391: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,

387: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
388: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
389: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
390: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
391: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
392: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
393: P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
394: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
395: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 392: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

388: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
389: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
390: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
391: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
392: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
393: P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
394: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
395: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
396: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 402: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

398:
399:
400:
401: PROCEDURE Create_Quote_Line_POST(
402: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
403: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
404: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
405: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
406: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,

Line 403: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,

399:
400:
401: PROCEDURE Create_Quote_Line_POST(
402: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
403: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
404: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
405: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
406: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
407: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

Line 404: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

400:
401: PROCEDURE Create_Quote_Line_POST(
402: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
403: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
404: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
405: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
406: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
407: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
408: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,

Line 405: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,

401: PROCEDURE Create_Quote_Line_POST(
402: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
403: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
404: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
405: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
406: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
407: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
408: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
409: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

Line 406: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,

402: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
403: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
404: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
405: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
406: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
407: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
408: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
409: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
410: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,

Line 407: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

403: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
404: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
405: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
406: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
407: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
408: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
409: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
410: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
411: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

Line 408: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,

404: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
405: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
406: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
407: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
408: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
409: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
410: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
411: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
412: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,

Line 409: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

405: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
406: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
407: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
408: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
409: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
410: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
411: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
412: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
413: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,

Line 410: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,

406: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
407: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
408: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
409: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
410: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
411: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
412: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
413: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
414: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

Line 411: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

407: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
408: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
409: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
410: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
411: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
412: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
413: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
414: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
415: P_Update_Header_Flag IN VARCHAR2 ,

Line 412: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,

408: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
409: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
410: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
411: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
412: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
413: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
414: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
415: P_Update_Header_Flag IN VARCHAR2 ,
416: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 413: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,

409: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
410: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
411: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
412: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
413: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
414: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
415: P_Update_Header_Flag IN VARCHAR2 ,
416: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
417: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 414: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

410: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
411: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
412: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
413: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
414: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
415: P_Update_Header_Flag IN VARCHAR2 ,
416: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
417: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
418: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 433: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,

429: -- IN
430:
431:
432: PROCEDURE Update_Quote_Line_PRE(
433: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
434: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
435: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
436: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
437: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,

Line 434: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,

430:
431:
432: PROCEDURE Update_Quote_Line_PRE(
433: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
434: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
435: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
436: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
437: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
438: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,

Line 435: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

431:
432: PROCEDURE Update_Quote_Line_PRE(
433: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
434: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
435: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
436: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
437: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
438: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
439: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

Line 436: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,

432: PROCEDURE Update_Quote_Line_PRE(
433: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
434: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
435: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
436: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
437: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
438: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
439: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
440: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

Line 437: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,

433: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
434: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
435: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
436: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
437: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
438: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
439: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
440: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
441: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,

Line 438: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,

434: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
435: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
436: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
437: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
438: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
439: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
440: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
441: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
442: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

Line 439: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

435: P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
436: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
437: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
438: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
439: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
440: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
441: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
442: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
443: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

Line 440: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

436: P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
437: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
438: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
439: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
440: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
441: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
442: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
443: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
444: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,

Line 441: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,

437: P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
438: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
439: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
440: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
441: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
442: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
443: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
444: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
445: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

Line 442: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

438: P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
439: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
440: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
441: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
442: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
443: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
444: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
445: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
446: P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,

Line 443: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,

439: P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
440: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
441: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
442: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
443: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
444: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
445: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
446: P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
447: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 444: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,

440: P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
441: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
442: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
443: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
444: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
445: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
446: P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
447: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
448: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 445: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

441: P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
442: P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
443: P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
444: P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
445: P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
446: P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
447: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
448: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
449: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 455: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

451:
452:
453:
454: PROCEDURE Update_Quote_Line_POST(
455: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
456: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
457: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
458: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
459: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,

Line 456: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,

452:
453:
454: PROCEDURE Update_Quote_Line_POST(
455: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
456: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
457: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
458: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
459: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
460: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

Line 457: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

453:
454: PROCEDURE Update_Quote_Line_POST(
455: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
456: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
457: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
458: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
459: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
460: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
461: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,

Line 458: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,

454: PROCEDURE Update_Quote_Line_POST(
455: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
456: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
457: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
458: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
459: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
460: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
461: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
462: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

Line 459: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,

455: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
456: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
457: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
458: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
459: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
460: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
461: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
462: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
463: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,

Line 460: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

456: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
457: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
458: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
459: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
460: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
461: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
462: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
463: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
464: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

Line 461: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,

457: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
458: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
459: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
460: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
461: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
462: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
463: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
464: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
465: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,

Line 462: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

458: P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
459: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
460: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
461: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
462: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
463: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
464: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
465: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
466: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,

Line 463: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,

459: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
460: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
461: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
462: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
463: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
464: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
465: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
466: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
467: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

Line 464: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

460: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
461: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
462: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
463: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
464: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
465: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
466: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
467: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
468: P_Update_Header_Flag IN VARCHAR2 ,

Line 465: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,

461: P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
462: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
463: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
464: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
465: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
466: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
467: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
468: P_Update_Header_Flag IN VARCHAR2 ,
469: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 466: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,

462: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
463: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
464: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
465: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
466: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
467: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
468: P_Update_Header_Flag IN VARCHAR2 ,
469: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
470: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 467: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,

463: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
464: P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
465: P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
466: P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
467: P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
468: P_Update_Header_Flag IN VARCHAR2 ,
469: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
470: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
471: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 506: P_qte_line_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_Rec_Type,

502: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
503: -- The Master delete procedure may not be needed depends on different business requirements.
504:
505: PROCEDURE Delete_Quote_Line_PRE(
506: P_qte_line_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_Rec_Type,
507: P_Control_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Control_rec_Type,
508: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
509: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
510: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 507: P_Control_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Control_rec_Type,

503: -- The Master delete procedure may not be needed depends on different business requirements.
504:
505: PROCEDURE Delete_Quote_Line_PRE(
506: P_qte_line_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_Rec_Type,
507: P_Control_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Control_rec_Type,
508: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
509: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
510: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
511: );

Line 514: P_qte_line_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type,

510: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
511: );
512:
513: PROCEDURE Delete_Quote_Line_POST(
514: P_qte_line_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type,
515: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
516: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
517: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
518: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 515: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,

511: );
512:
513: PROCEDURE Delete_Quote_Line_POST(
514: P_qte_line_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type,
515: P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
516: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
517: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
518: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
519: );

Line 522: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE,

518: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
519: );
520:
521: PROCEDURE Allocate_Sales_Credits_PRE(
522: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE,
523: P_Qte_Header_Id IN NUMBER,
524: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
525: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
526: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);

Line 529: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE,

525: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
526: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
527:
528: PROCEDURE Allocate_Sales_Credits_POST(
529: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE,
530: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
531: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
532: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
533: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);

Line 530: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

526: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
527:
528: PROCEDURE Allocate_Sales_Credits_POST(
529: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE,
530: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
531: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
532: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
533: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
534: