[Home] [Help]
PACKAGE: APPS.IBE_SHOP_LIST_PVT
Source
1 PACKAGE IBE_Shop_List_PVT AS
2 /* $Header: IBEVQSLS.pls 120.1 2005/06/10 00:16:43 appldev $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_Shop_List_PVT';
5
6 /*
7 * Types declaration for Shopping List Header
8 */
9 TYPE SL_Header_Rec_Type IS RECORD(
10 shp_list_id NUMBER := FND_API.G_MISS_NUM ,
11 request_id NUMBER := FND_API.G_MISS_NUM ,
12 program_application_id NUMBER := FND_API.G_MISS_NUM ,
13 program_id NUMBER := FND_API.G_MISS_NUM ,
14 program_update_date DATE := FND_API.G_MISS_DATE,
15 object_version_number NUMBER := FND_API.G_MISS_NUM ,
16 created_by NUMBER := FND_API.G_MISS_NUM ,
17 creation_date DATE := FND_API.G_MISS_DATE,
18 last_updated_by NUMBER := FND_API.G_MISS_NUM ,
19 last_update_date DATE := FND_API.G_MISS_DATE,
20 last_update_login NUMBER := FND_API.G_MISS_NUM ,
21 party_id NUMBER := FND_API.G_MISS_NUM ,
22 cust_account_id NUMBER := FND_API.G_MISS_NUM ,
23 shopping_list_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
24 description VARCHAR2(240) := FND_API.G_MISS_CHAR,
25 attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
26 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41 org_id NUMBER := FND_API.G_MISS_NUM
42 );
43
44 G_MISS_SL_HEADER_REC SL_Header_Rec_Type;
45
46 TYPE SL_Header_Tbl_Type IS TABLE OF SL_Header_Rec_Type
47 INDEX BY BINARY_INTEGER;
48
49 G_MISS_SL_HEADER_TBL SL_Header_Tbl_Type;
50
51 /*
52 * Types declaration for Shopping List Line
53 */
54 TYPE SL_Line_Rec_Type IS RECORD(
55 operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56 shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
57 object_version_number NUMBER := FND_API.G_MISS_NUM ,
58 creation_date DATE := FND_API.G_MISS_DATE,
59 created_by NUMBER := FND_API.G_MISS_NUM ,
60 last_updated_by NUMBER := FND_API.G_MISS_NUM ,
61 last_update_date DATE := FND_API.G_MISS_DATE,
62 last_update_login NUMBER := FND_API.G_MISS_NUM ,
63 request_id NUMBER := FND_API.G_MISS_NUM ,
64 program_id NUMBER := FND_API.G_MISS_NUM ,
65 program_application_id NUMBER := FND_API.G_MISS_NUM ,
66 program_update_date DATE := FND_API.G_MISS_DATE,
67 shp_list_id NUMBER := FND_API.G_MISS_NUM ,
68 inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
69 organization_id NUMBER := FND_API.G_MISS_NUM ,
70 uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71 quantity NUMBER := FND_API.G_MISS_NUM ,
72 config_header_id NUMBER := FND_API.G_MISS_NUM ,
73 config_revision_num NUMBER := FND_API.G_MISS_NUM ,
74 complete_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
75 valid_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
76 item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
77 attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
78 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93 org_id NUMBER := FND_API.G_MISS_NUM
94 );
95
96 G_MISS_SL_LINE_REC SL_Line_Rec_Type;
97
98 TYPE SL_Line_Tbl_Type IS TABLE OF SL_Line_Rec_Type
99 INDEX BY BINARY_INTEGER;
100
101 G_MISS_SL_LINE_TBL SL_Line_Tbl_Type;
102
103
104 /*
105 * Types declaration for Shopping List Line Relationship
106 */
107 TYPE SL_Line_Rel_Rec_Type IS RECORD(
108 operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109 shlitem_rel_id NUMBER := FND_API.G_MISS_NUM ,
110 request_id NUMBER := FND_API.G_MISS_NUM ,
111 program_application_id NUMBER := FND_API.G_MISS_NUM ,
112 program_id NUMBER := FND_API.G_MISS_NUM ,
113 program_update_date DATE := FND_API.G_MISS_DATE,
114 object_version_number NUMBER := FND_API.G_MISS_NUM ,
115 created_by NUMBER := FND_API.G_MISS_NUM ,
116 creation_date DATE := FND_API.G_MISS_DATE,
117 last_updated_by NUMBER := FND_API.G_MISS_NUM ,
118 last_update_date DATE := FND_API.G_MISS_DATE,
119 last_update_login NUMBER := FND_API.G_MISS_NUM ,
120 shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
121 line_index NUMBER := FND_API.G_MISS_NUM ,
122 related_shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
123 related_line_index NUMBER := FND_API.G_MISS_NUM ,
124 relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
125 );
126
127 G_MISS_SL_LINE_REL_REC SL_Line_Rel_Rec_Type;
128
129 TYPE SL_Line_Rel_Tbl_Type IS TABLE OF SL_Line_Rel_Rec_Type
130 INDEX BY BINARY_INTEGER;
131
132 G_MISS_SL_LINE_REL_TBL SL_Line_Rel_Tbl_Type;
133
134
135 PROCEDURE Delete(
136 p_api_version IN NUMBER := 1 ,
137 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
138 p_commit IN VARCHAR2 := FND_API.G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2 ,
140 x_msg_count OUT NOCOPY NUMBER ,
141 x_msg_data OUT NOCOPY VARCHAR2 ,
142 p_shop_list_ids IN jtf_number_table ,
143 p_obj_ver_numbers IN jtf_number_table
144 );
145
146
147 PROCEDURE Delete_All_Lines(
148 p_api_version IN NUMBER := 1 ,
149 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
150 p_commit IN VARCHAR2 := FND_API.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2 ,
152 x_msg_count OUT NOCOPY NUMBER ,
153 x_msg_data OUT NOCOPY VARCHAR2 ,
154 p_shop_list_ids IN jtf_number_table ,
155 p_obj_ver_numbers IN jtf_number_table
156 );
157
158
159 PROCEDURE Delete_Lines(
160 p_api_version IN NUMBER := 1 ,
161 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
162 p_commit IN VARCHAR2 := FND_API.G_FALSE,
163 x_return_status OUT NOCOPY VARCHAR2 ,
164 x_msg_count OUT NOCOPY NUMBER ,
165 x_msg_data OUT NOCOPY VARCHAR2 ,
166 p_shop_list_line_ids IN jtf_number_table ,
167 p_obj_ver_numbers IN jtf_number_table
168 );
169
170
171 PROCEDURE Save(
172 p_api_version IN NUMBER := 1 ,
173 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
174 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
175 x_return_status OUT NOCOPY VARCHAR2 ,
176 x_msg_count OUT NOCOPY NUMBER ,
177 x_msg_data OUT NOCOPY VARCHAR2 ,
178 p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,
179 p_sl_header_rec IN SL_Header_Rec_Type ,
180 p_sl_line_tbl IN SL_Line_Tbl_Type := G_MISS_SL_LINE_TBL ,
181 p_sl_line_rel_tbl IN SL_Line_Rel_Tbl_Type := G_MISS_SL_LINE_REL_TBL,
182 x_sl_header_id OUT NOCOPY NUMBER
183 );
184
185
186 PROCEDURE Save_List_From_Items(
187 p_api_version IN NUMBER := 1 ,
188 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
189 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
190 x_return_status OUT NOCOPY VARCHAR2 ,
191 x_msg_count OUT NOCOPY NUMBER ,
192 x_msg_data OUT NOCOPY VARCHAR2 ,
193 p_sl_line_ids IN jtf_number_table ,
194 p_sl_line_ovns IN jtf_number_table := NULL ,
195 p_mode IN VARCHAR2 := 'MERGE' ,
196 p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
197 p_sl_header_rec IN SL_Header_Rec_Type ,
198 x_sl_header_id OUT NOCOPY NUMBER
199 );
200
201 PROCEDURE Save_List_From_Quote(
202 p_api_version IN NUMBER := 1 ,
203 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
204 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
205 x_return_status OUT NOCOPY VARCHAR2 ,
206 x_msg_count OUT NOCOPY NUMBER ,
207 x_msg_data OUT NOCOPY VARCHAR2 ,
208 p_quote_header_id IN NUMBER ,
209 p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
210 p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
211 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
212 p_mode IN VARCHAR2 := 'MERGE' ,
213 p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
214 p_sl_header_rec IN SL_Header_Rec_Type ,
215 x_sl_header_id OUT NOCOPY NUMBER
216 );
217
218
219 PROCEDURE Save_Quote_From_List_Items(
220 p_api_version IN NUMBER := 1 ,
221 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
222 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
223 x_return_status OUT NOCOPY VARCHAR2 ,
224 x_msg_count OUT NOCOPY NUMBER ,
225 x_msg_data OUT NOCOPY VARCHAR2 ,
226 p_sl_line_ids IN jtf_number_table ,
227 p_sl_line_ovns IN jtf_number_table := NULL ,
228 p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
229 p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
230 p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
231 p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
232 p_mode IN VARCHAR2 := 'MERGE' ,
233 p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,
234 p_control_rec IN ASO_Quote_Pub.control_rec_type ,
235 p_q_header_rec IN ASO_Quote_Pub.qte_header_rec_type,
236 p_password IN VARCHAR2 := FND_API.G_MISS_CHAR ,
237 p_email_address IN jtf_varchar2_table_2000 := NULL ,
238 p_privilege_type IN jtf_varchar2_table_100 := NULL ,
239 p_url IN VARCHAR2 ,
240 p_comments IN VARCHAR2 ,
241 p_promocode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
242 x_q_header_id OUT NOCOPY NUMBER
243 );
244
245 END IBE_Shop_List_PVT;
246