1 package IBE_QUOTE_SAVESHARE_V2_PVT AUTHID CURRENT_USER AS
2 /*$Header: IBEVSS2S.pls 115.13 2003/09/18 06:22:27 ajlee ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_QUOTE_SAVESHARE_V2_PVT';
5 --Operation codes in saveshare_control_rec are
6 OP_APPEND CONSTANT NUMBER := 0;
7 OP_ACTIVATE_QUOTE CONSTANT NUMBER := 1;
8 OP_DEACTIVATE CONSTANT NUMBER := 2;
9 OP_NAME_CART CONSTANT NUMBER := 3;
10 OP_SAVE_RECIPIENTS CONSTANT NUMBER := 4;
11 OP_STOP_SHARING CONSTANT NUMBER := 5;
12 OP_SAVE_CART_AND_RECIPIENTS CONSTANT NUMBER := 6;
13 OP_END_WORKING CONSTANT NUMBER := 7;
14 OP_DELETE_CART CONSTANT NUMBER := 8;
15
16
17 /*New saveshare control record type which includes ASO control record*/
18 TYPE SAVESHARE_CONTROL_REC_TYPE is record(
19 control_rec ASO_QUOTE_PUB.control_rec_type
20 := ASO_QUOTE_PUB.G_MISS_Control_Rec ,
21 delete_source_cart VARCHAR2(1) := FND_API.G_true ,
22 combinesameitem VARCHAR2(1) := FND_API.G_true ,
23 operation_code NUMBER ,
24 deactivate_cart VARCHAR2(1) := FND_API.G_false );
25
26
27 g_miss_saveshare_control_rec SAVESHARE_CONTROL_REC_TYPE;
28
29 TYPE ACTIVE_CARTS_REC_TYPE is record(
30 active_quote_id number :=FND_API.G_MISS_NUM ,
31 object_version_number number :=FND_API.G_MISS_NUM ,
32 quote_header_id number :=FND_API.G_MISS_NUM ,
33 party_id number :=FND_API.G_MISS_NUM ,
34 cust_account_id number :=FND_API.G_MISS_NUM ,
35 creation_date date := FND_API.G_MISS_DATE,
36 created_by number :=FND_API.G_MISS_NUM ,
37 last_update_date date := FND_API.G_MISS_DATE,
38 last_updated_by number :=FND_API.G_MISS_NUM ,
39 last_update_login number :=FND_API.G_MISS_NUM );
40
41 G_MISS_ACTIVE_CARTS_REC ACTIVE_CARTS_REC_TYPE;
42
43 PROCEDURE save_Contact_Point(
44 p_api_version_number IN NUMBER
45 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
46 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
47 ,P_URL IN VARCHAR2 := FND_API.G_MISS_char
48 ,P_EMAIL IN VARCHAR2 := FND_API.G_MISS_char
49 ,p_owner_table_id IN NUMBER
50 ,p_mode IN VARCHAR2
51 ,x_contact_point_id OUT NOCOPY number
52 ,X_Return_Status OUT NOCOPY VARCHAR2
53 ,X_Msg_Count OUT NOCOPY NUMBER
54 ,X_Msg_Data OUT NOCOPY VARCHAR2
55 );
56
57 Procedure SAVE_SHARE_V2 (
58 P_saveshare_control_rec IN SAVESHARE_CONTROL_REC_TYPE
59 := G_MISS_saveshare_control_rec ,
60 P_party_id IN NUMBER ,
61 P_cust_account_id IN NUMBER ,
62 P_retrieval_number IN NUMBER ,
63 P_Quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
64 P_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
65 := ibe_quote_saveshare_pvt.G_MISS_QUOTE_ACCESS_TBL,
66 P_source_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
67 P_source_last_update_date IN DATE := FND_API.G_MISS_DATE ,
68 p_minisite_id IN NUMBER ,
69 p_URL IN VARCHAR2 ,
70 p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
71 p_api_version IN NUMBER := 1 ,
72 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
73 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
74 x_return_status OUT NOCOPY VARCHAR2 ,
75 x_msg_count OUT NOCOPY NUMBER ,
76 x_msg_data OUT NOCOPY VARCHAR2 );
77
78 Procedure SAVE_RECIPIENTS (
79 P_Quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE
80 := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
81 P_Quote_header_id IN Number ,
82 P_Party_id IN Number := FND_API.G_MISS_NUM ,
83 P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
84 P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,
85 P_minisite_id IN Number := FND_API.G_MISS_NUM ,
86 p_send_notif IN Varchar2 := FND_API.G_TRUE ,
87 p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,
88 p_api_version IN NUMBER := 1 ,
89 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
90 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
91 x_return_status OUT NOCOPY VARCHAR2 ,
92 x_msg_count OUT NOCOPY NUMBER ,
93 x_msg_data OUT NOCOPY VARCHAR2 );
94
95 Procedure ACTIVATE_QUOTE (
96 P_Quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
97 P_Party_id IN Number := FND_API.G_MISS_NUM ,
98 P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
99 P_control_rec IN ASO_QUOTE_PUB.control_rec_type
100 := ASO_QUOTE_PUB.G_MISS_Control_Rec,
101 p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
102 p_api_version IN NUMBER := 1 ,
103 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
104 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
105 x_return_status OUT NOCOPY VARCHAR2 ,
106 x_msg_count OUT NOCOPY NUMBER ,
107 x_msg_data OUT NOCOPY VARCHAR2 );
108
109 Procedure DEACTIVATE_QUOTE (
110 P_Quote_header_id IN Number ,
111 P_Party_id IN Number := FND_API.G_MISS_NUM ,
112 P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
113 P_minisite_id IN Number := FND_API.G_MISS_NUM ,
114 p_api_version IN NUMBER := 1 ,
115 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
116 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
117 x_return_status OUT NOCOPY VARCHAR2 ,
118 x_msg_count OUT NOCOPY NUMBER ,
119 x_msg_data OUT NOCOPY VARCHAR2 );
120
121 Procedure APPEND_QUOTE(
122 P_source_quote_header_id IN Number ,
123 P_source_last_update_date IN Date ,
124 P_target_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
125 P_control_rec IN ASO_QUOTE_PUB.control_rec_type
126 := ASO_QUOTE_PUB.G_MISS_Control_Rec ,
127 P_delete_source_cart IN Varchar2 := FND_API.G_TRUE ,
128 P_combinesameitem IN Varchar2 := FND_API.G_TRUE ,
129 P_minisite_id IN Number := FND_API.G_MISS_NUM ,
130 p_api_version IN NUMBER := 1 ,
131 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
132 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
133 x_return_status OUT NOCOPY VARCHAR2 ,
134 x_msg_count OUT NOCOPY NUMBER ,
135 x_msg_data OUT NOCOPY VARCHAR2 );
136
137
138 Procedure STOP_SHARING (
139 p_quote_header_id IN NUMBER ,
140 p_delete_context IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
141 P_minisite_id IN Number := FND_API.G_MISS_NUM ,
142 p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,
143 p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
144 := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
145 p_api_version IN NUMBER := 1 ,
146 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
147 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
148 x_return_status OUT NOCOPY VARCHAR2 ,
149 x_msg_count OUT NOCOPY NUMBER ,
150 x_msg_data OUT NOCOPY VARCHAR2 );
151
152 Procedure END_WORKING (
153 p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
154 := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
155 P_Quote_header_id IN Number ,
156 P_Party_id IN Number := FND_API.G_MISS_NUM ,
157 P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
158 p_retrieval_number IN Number := FND_API.G_MISS_NUM ,
159 P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,
160 P_minisite_id IN Number := FND_API.G_MISS_NUM ,
161 p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
162 p_api_version IN NUMBER := 1 ,
163 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
164 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
165 x_return_status OUT NOCOPY VARCHAR2 ,
166 x_msg_count OUT NOCOPY NUMBER ,
167 x_msg_data OUT NOCOPY VARCHAR2 );
168
169 Procedure SHARE_READONLY (
170 p_quote_header_id IN Number ,
171 P_minisite_id IN Number := FND_API.G_MISS_NUM,
172 p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
173
174 p_api_version IN NUMBER := 1 ,
175 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
176 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
177 x_return_status OUT NOCOPY VARCHAR2 ,
178 x_msg_count OUT NOCOPY NUMBER ,
179 x_msg_data OUT NOCOPY VARCHAR2 );
180
181 Procedure DELETE_RECIPIENT (
182 P_Quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
183 := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC,
184 p_minisite_id IN NUMBER ,
185 p_delete_code IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
186 p_url IN VARCHAR2 := FND_API.G_MISS_CHAR ,
187 p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
188 p_api_version IN NUMBER := 1 ,
189 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
190 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
191 x_return_status OUT NOCOPY VARCHAR2 ,
192 x_msg_count OUT NOCOPY NUMBER ,
193 x_msg_data OUT NOCOPY VARCHAR2 );
194
195 PROCEDURE Validate_share_Update(
196 p_api_version_number IN NUMBER := 1.0
197 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
198 ,p_quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
199 ,p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
200 := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl
201 -- partyid and accountid cannot be gmiss coming in
202 ,p_party_id IN NUMBER
203 ,p_cust_account_id IN NUMBER
204 ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
205 ,p_operation_code IN VARCHAR2
206 ,x_return_status OUT NOCOPY VARCHAR2
207 ,x_msg_count OUT NOCOPY NUMBER
208 ,x_msg_data OUT NOCOPY VARCHAR2);
209
210
211 END IBE_QUOTE_SAVESHARE_V2_PVT;