[Home] [Help]
PACKAGE: APPS.ASO_SUBMIT_QUOTE_PVT
Source
1 PACKAGE ASO_SUBMIT_QUOTE_PVT AUTHID CURRENT_USER as
2 /* $Header: asovsubs.pls 120.1.12000000.2 2007/02/01 20:48:32 gkeshava ship $ */
3 -- Package name : ASO_SUBMIT_QUOTE_PVT
4 -- Purpose :
5 -- History :
6 -- 02/01/2007 gkeshava - Fix for perf bug 5714535
7 -- NOTE :
8 -- End of Comments
9
10 -- *******************************************************
11 -- Start of Comments
12 -- *******************************************************
13 -- API Name: Submit_Quote
14 -- Type : Private
15 -- Pre-Req :
16 --
17 -- End of Comments
18 --
19
20 PROCEDURE Submit_Quote
21 (
22 P_Api_Version_Number IN NUMBER,
23 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
24 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
25 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26 p_control_rec IN ASO_QUOTE_PUB.SUBMIT_CONTROL_REC_TYPE
27 := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
28 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
29 X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,
30 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
31 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
32 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
33
34
35 FUNCTION Query_Tax_Detail_Rows (
36 P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
37 P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
38 P_Shipment_Tbl_Cnt IN NUMBER,
39 P_Line_Index IN NUMBER,
40 lx_tax_detail_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
41 ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
42
43
44 FUNCTION Query_Shipment_Rows (
45 P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
46 P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
47 P_Line_Index IN NUMBER,
48 lx_shipment_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type
49 ) RETURN VARCHAR2;
50
51
52 FUNCTION Query_Freight_Charge_Rows (
53 P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
54 P_Line_Index IN NUMBER,
55 lx_freight_charge_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
56 ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
57
58
59 FUNCTION Query_Sales_Credit_Row (
60 P_qte_header_Id IN NUMBER,
61 P_qte_line_id IN NUMBER,
62 P_Line_Index IN NUMBER,
63 lx_sales_credit_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_tbl_Type
64 ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
65
66
67 FUNCTION Query_Quote_Party_Row (
68 P_Qte_header_Id IN NUMBER,
69 P_Qte_line_Id IN NUMBER,
70 P_Line_Index IN NUMBER,
71 lx_quote_party_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
72 ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
73
74
75 FUNCTION Query_Line_Dtl_Rows (
76 P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
77 P_Line_Index IN NUMBER,
78 lx_Line_Dtl_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
79 ) RETURN VARCHAR2;
80
81
82 FUNCTION Query_Line_Attribs_Ext_Rows(
83 P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
84 P_Line_Index IN NUMBER,
85 lx_Line_Attr_Ext_Tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
86 ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
87
88
89 FUNCTION Query_Price_Attr_Rows (
90 P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
91 P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
92 P_Line_Index IN NUMBER,
93 lx_price_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
94 ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
95
96
97 FUNCTION Query_Price_Adj_Rltship_Rows (
98 P_Price_Adjustment_Id IN NUMBER,
99 P_Line_Index IN NUMBER,
100 lx_price_adj_rltd_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
101 ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
102
103
104 FUNCTION Query_Price_Adj_Rows (
105 P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
106 P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
107 P_Line_Index IN NUMBER,
108 Lx_price_adj_rltship_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
109 Lx_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type
110 ) RETURN VARCHAR2;
111
112
113 FUNCTION Query_Price_Adj_Hdr_Rows (
114 P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
115 P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
116 ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
117
118
119 PROCEDURE Raise_Quote_Event(
120 P_Quote_Header_id IN NUMBER,
121 P_Control_Rec IN ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
122 := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
123 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
124
125
126 PROCEDURE Quote_Order_High_Availability(
127 P_Quote_Header_Id IN NUMBER,
128 P_Book_Flag IN VARCHAR2,
129 P_Calculate_Flag IN VARCHAR2,
130 P_Server_Id IN NUMBER,
131 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
132 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
133 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
134
135
136 End ASO_SUBMIT_QUOTE_PVT;