[Home] [Help]
PACKAGE: APPS.ASO_COPY_QUOTE_PVT
Source
1 PACKAGE ASO_COPY_QUOTE_PVT AUTHID CURRENT_USER as
2 /* $Header: asovcpys.pls 120.4.12020000.1 2012/06/26 09:46:33 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_COPY_QUOTE_PVT
5 -- Purpose :
6 -- This package contains specification for pl/sql records and tables and the
7 -- Private API of Order Capture.
8 --
9 -- Procedures:
10 -- Copy_Quote
11 --
12 -- History :
13 -- NOTE :
14 --
15 -- End of Comments
16 --
17
18
19 PROCEDURE Copy_Quote(
20 P_Api_Version_Number IN NUMBER,
21 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23 P_Copy_Quote_Header_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Header_Rec_Type
24 := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec,
25 P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
26 := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
27 /* Code change for Quoting Usability Sun ER Start */
28 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
29 P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,
30 P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
31 P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
32 /* Code change for Quoting Usability Sun ER End */
33 X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
34 X_Qte_Number OUT NOCOPY /* file.sql.39 change */ NUMBER,
35 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
36 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
37 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
38
39
40 PROCEDURE Copy_Header_Rows(
41 P_Api_Version_Number IN NUMBER,
42 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
43 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
44 P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type,
45 /* Code change for Quoting Usability Sun ER Start */
46 P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,
47 P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
48 P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
49 /* Code change for Quoting Usability Sun ER End */
50 P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
51 X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
52 X_Price_Index_Link_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
53 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
54 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
55 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
56
57 PROCEDURE Copy_Line_Rows(
58 P_Api_Version_Number IN NUMBER,
59 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
60 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
61 P_Qte_Header_Id IN NUMBER,
62 P_New_Qte_Header_Id IN NUMBER,
63 P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
64 P_Price_Index_Link_Tbl IN ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
65 P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
66 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
67 P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
68 X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
69 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
70 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
71 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
72
73
74
75 PROCEDURE config_copy(
76 p_old_config_header_id IN NUMBER,
77 p_old_config_revision_num IN NUMBER,
78 p_config_header_id IN NUMBER,
79 p_config_revision_num IN NUMBER,
80 p_new_qte_header_id IN NUMBER,
81 p_qte_header_id IN NUMBER,
82 p_copy_quote_control_rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
83 := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
84 lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
85 lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
86 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
87 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
88 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
89 p_line_quantity IN NUMBER := FND_API.G_MISS_NUM );
90
91 PROCEDURE service_copy(
92 p_qte_line_id IN NUMBER,
93 p_copy_quote_control_rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
94 := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
95 p_new_qte_header_id IN NUMBER,
96 p_qte_header_id IN NUMBER,
97 lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
98 lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
99 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
100 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
101 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
102 p_line_quantity IN NUMBER := FND_API.G_MISS_NUM);
103
104 PROCEDURE Get_Quote_Exp_Date(
105 X_Quote_Exp_Date OUT NOCOPY /* file.sql.39 change */ DATE,
106 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
107 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
108 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
109
110 PROCEDURE COPY_SALES_SUPPLEMENT
111 (
112 P_Api_Version_Number IN NUMBER,
113 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
114 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
115 p_old_quote_header_id IN NUMBER,
116 p_new_quote_header_id IN NUMBER,
117 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
118 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
119 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
120
121
122 PROCEDURE Copy_Opp_Quote(
123 p_api_version_number IN NUMBER := 1.0,
124 p_qte_header_id IN NUMBER,
125 p_new_qte_header_id IN NUMBER,
126 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
127 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
128 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
129
130
131 PROCEDURE Split_Model_Line (
132 P_Api_Version_Number IN NUMBER,
133 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
134 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
135 P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
136 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
137 P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
138 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
139 X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
140 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
141 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
142 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
143
144
145 -- added for sales supp enhancements as per bug 2940126
146 PROCEDURE INSERT_SALES_SUPP_DATA
147 (
148 P_Api_Version_Number IN NUMBER,
149 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
150 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
151 P_OLD_QUOTE_LINE_ID IN NUMBER,
152 P_NEW_QUOTE_LINE_ID IN NUMBER,
153 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
154 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
155 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
156
157
158
159
160 PROCEDURE copy_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
161 x_return_status OUT NOCOPY varchar2,
162 x_msg_count OUT NOCOPY number,
163 x_msg_data OUT NOCOPY varchar2);
164 End ASO_COPY_QUOTE_PVT;