4 /** PDF output format type */
1 PACKAGE qp_price_book_util AUTHID CURRENT_USER AS
2 /* $Header: QPXUPBKS.pls 120.19.12010000.3 2009/09/04 07:27:05 kdurgasi ship $ */
3
5 G_TYPE_PDF CONSTANT VARCHAR2(50) := 'PDF';
6 /** RTF output format type */
7 G_TYPE_RTF CONSTANT VARCHAR2(50) := 'RTF';
8 /** Excel output format type */
9 G_TYPE_EXCEL CONSTANT VARCHAR2(50) := 'EXCEL';
10 /** XML output format type */
11 G_TYPE_XML CONSTANT VARCHAR2(50) := 'XML';
12 /** HTML output format type */
13 G_TYPE_HTML CONSTANT VARCHAR2(50) := 'HTML';
14 /** UIX output format type */
15 G_TYPE_UIX CONSTANT VARCHAR2(50) := 'UIX';
16 /** AWT output format type - not supported in this version */
17 G_TYPE_AWT CONSTANT VARCHAR2(50) := 'AWT';
18 /** Text output format type */
19 G_TYPE_TEXT CONSTANT VARCHAR2(50) := 'TEXT';
20 /** XSL-FO Format Type**/
21 G_TYPE_XSL_FO CONSTANT VARCHAR2(50) := 'XSL-FO';
22 /** Text output format type */
23 G_DATA_FILE_NOT_FOUND CONSTANT VARCHAR2(50) := '0';
24
28 G_EXT_RTF CONSTANT VARCHAR2(50) := 'rtf';
25 G_EXT_PDF CONSTANT VARCHAR2(50) := 'pdf';
26 G_EXT_HTML CONSTANT VARCHAR2(50) := 'htm';
27 G_EXT_EXCEL CONSTANT VARCHAR2(50) := 'xls';
29
30 G_MIME_PDF CONSTANT VARCHAR2(50) := 'application/pdf';
31 G_MIME_HTML CONSTANT VARCHAR2(50) := 'text/html';
32 G_MIME_EXCEL CONSTANT VARCHAR2(50) := 'application/excel';
33 G_MIME_RTF CONSTANT VARCHAR2(50) := 'application/rtf';
34
35 G_FILE_NAME_PREFIX CONSTANT VARCHAR2(50) := 'pricebook';
36
37 TYPE NUMBER_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
38 TYPE VARCHAR30_TYPE IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
39 TYPE VARCHAR_TYPE IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
40 TYPE VARCHAR2000_TYPE IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
41 TYPE FLAG_TYPE IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
42
43 TYPE price_book_message_rec IS RECORD (message_type VARCHAR2(1) := 'E',
44 message_code VARCHAR2(30),
45 message_text VARCHAR2(2000),
46 pb_input_header_id NUMBER := NULL,
47 price_book_header_id NUMBER := NULL,
48 price_book_line_id NUMBER := NULL);
49
50 TYPE price_book_messages_tbl IS TABLE OF price_book_message_rec
51 INDEX BY BINARY_INTEGER;
52
53 TYPE pb_input_lines_tbl IS TABLE OF qp_pb_input_lines%ROWTYPE
54 INDEX BY BINARY_INTEGER;
55
56 PROCEDURE Insert_Price_Book_Messages(
57 p_price_book_messages_tbl IN price_book_messages_tbl);
58
59 PROCEDURE Convert_PB_Input_Value_to_Id (
60 p_pb_input_header_rec IN OUT NOCOPY QP_PRICE_BOOK_PUB.pb_input_header_rec);
61
62 PROCEDURE Default_PB_Input_Criteria (
63 p_pb_input_header_rec IN OUT NOCOPY QP_PRICE_BOOK_PUB.pb_input_header_rec);
64
65 PROCEDURE DEFAULT_CUST_ACCOUNT_ID
66 (
67 p_customer_attr_value IN VARCHAR2,
68 x_cust_account_id OUT NOCOPY VARCHAR2
69 );
70
71 PROCEDURE Validate_PB_Inp_Criteria_Wrap(
72 p_pb_input_header_id IN NUMBER,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_return_text IN OUT NOCOPY VARCHAR2);
75
76 PROCEDURE Insert_Price_Book_Header(
77 p_pb_input_header_rec IN qp_pb_input_headers_vl%ROWTYPE,
78 x_price_book_header_id OUT NOCOPY NUMBER);
79
80 FUNCTION value_to_meaning( p_code IN VARCHAR2,p_type IN VARCHAR2) RETURN VARCHAR2;
81
82 FUNCTION get_attribute_name(p_context_code in varchar2
83 ,p_attribute_code in varchar2
84 ,p_attribute_type in varchar2) return varchar2;
85
86 FUNCTION get_product_value(p_attribute_code in varchar2
87 ,p_attribute_value_code in varchar2
88 ,p_org_id in varchar2) return varchar2;
89
90 FUNCTION get_customer_value(p_attribute_code in varchar2,
91 p_attribute_value_code in varchar2) return varchar2;
92
93 FUNCTION get_customer_name(p_customer_id in varchar2) return varchar2;
94
95 FUNCTION get_operating_unit(p_orgid in number) return varchar2;
96
97 FUNCTION get_context_name (p_context in varchar2,p_attribute_type in varchar2) return varchar2;
98
99 FUNCTION get_item_description(p_item_number in number,p_pb_header_id in number) return varchar2;
100
101 FUNCTION get_item_category (p_item_category in number ) return varchar2;
102
103 FUNCTION get_item_cat_description (p_item_category in number) return varchar2;
104
105 FUNCTION get_item_number(p_item_number in number, p_pb_header_id in number) return varchar2;
106
107 FUNCTION get_customer_number (p_item_number in number,p_pb_header_id in number) return varchar2;
108
109 FUNCTION get_customer_item_desc (p_item_number in number,p_pb_header_id in number) return varchar2;
110
111 FUNCTION get_attribute_value_common(p_attribute_type in varchar2
112 ,p_context in varchar2
113 ,p_attribute in varchar2
114 ,p_attribute_value in varchar2
115 ,p_comparison_operator in varchar2 default '=') return varchar2;
116
117 FUNCTION get_list_name (p_list_header_id in number)return varchar2;
118
119 FUNCTION get_currency_name (p_currency_code in varchar2) return varchar2;
120 /** KDURGASI **/
121 FUNCTION get_content_type (p_document_type in varchar2) return varchar2;
122
123 FUNCTION get_document_name (p_pb_input_header_id in number, p_document_type in varchar2) return varchar2;
124 /** KDURGASI **/
125 PROCEDURE Delete_PriceBook_info(p_price_book_header_id in number) ;
126
127 PROCEDURE Delete_Input_Criteria(p_pb_input_header_id in number);
128
129 -- Added by SNIMMAGA
130 FUNCTION Get_Processing_BatchSize RETURN NATURAL;
131
132 PROCEDURE INSERT_PB_TL_RECORDS
133 (
134 p_pb_input_header_id IN VARCHAR2,
135 p_price_book_name IN VARCHAR2,
136 p_pl_agr_bsa_name IN VARCHAR2
137 );
138
139 PROCEDURE CATGI_HEADER_CONVERSIONS
140 (
141 p_org_id IN NUMBER,
142 p_pricing_effective_date IN DATE,
143 p_limit_products_by_code IN VARCHAR2,
144 p_price_based_on_code IN VARCHAR2,
145 p_customer_id IN VARCHAR2,
146 p_item_number IN VARCHAR2,
147 p_item_number_cust IN VARCHAR2,
148 p_item_id IN VARCHAR2,
152 p_price_list_id IN VARCHAR2,
149 p_item_category_name IN VARCHAR2,
150 p_item_category_id IN VARCHAR2,
151 p_price_list_name IN VARCHAR2,
153 p_agreement_name IN VARCHAR2,
154 p_agreement_id IN VARCHAR2,
155 p_bsa_name IN VARCHAR2,
156 p_bsa_id IN VARCHAR2,
157 x_prod_attr_value OUT NOCOPY VARCHAR2,
158 x_pl_agr_bsa_id OUT NOCOPY VARCHAR2,
159 x_pl_agr_bsa_name OUT NOCOPY VARCHAR2,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_return_text OUT NOCOPY VARCHAR2
162 );
163
164 PROCEDURE GET_CONTEXT_CODE
165 (
166 p_context_name IN VARCHAR2,
167 p_attribute_type IN VARCHAR2,
168 x_context_code OUT NOCOPY VARCHAR2,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_return_text OUT NOCOPY VARCHAR2
171 );
172
173 PROCEDURE GET_ATTRIBUTE_CODE
174 (
175 p_context_code IN VARCHAR2,
176 p_attribute_name IN VARCHAR2,
177 p_attribute_type IN VARCHAR2,
178 x_attribute_code OUT NOCOPY VARCHAR2,
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_return_text OUT NOCOPY VARCHAR2
181 );
182
183 PROCEDURE GET_ATTRIBUTE_VALUE_CODE
184 (
185 p_context_code IN VARCHAR2,
186 p_attribute_code IN VARCHAR2,
187 p_attribute_value_name IN VARCHAR2,
188 p_attribute_type IN VARCHAR2,
189 x_attribute_value_code OUT NOCOPY VARCHAR2,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_return_text OUT NOCOPY VARCHAR2
192 );
193
194 PROCEDURE PUBLISH_AND_DELIVER_CP
195 (
196 err_buff OUT NOCOPY VARCHAR2,
197 retcode OUT NOCOPY NUMBER,
198 p_pb_input_header_id NUMBER,
199 p_price_book_id NUMBER,
200 p_servlet_url IN VARCHAR2 DEFAULT NULL
201 );
202
203 PROCEDURE PUBLISH_AND_DELIVER
204 (
205 p_pb_input_header_id IN NUMBER,
206 p_price_book_header_id IN NUMBER,
207 p_servlet_url IN VARCHAR2 DEFAULT NULL,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_return_status_text OUT NOCOPY VARCHAR2
210 );
211
212 PROCEDURE SEND_SYNC_CATALOG
213 (
214 p_price_book_header_id IN NUMBER,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_return_status_text OUT NOCOPY VARCHAR2
217 );
218
219 PROCEDURE GENERATE_PUBLISH_PRICE_BOOK_WF
220 (
221 itemtype in VARCHAR2,
222 itemkey in VARCHAR2,
223 actid in NUMBER,
224 funcmode in VARCHAR2,
225 resultout in OUT NOCOPY VARCHAR2
226 );
227
228 PROCEDURE CATSO_SELECTOR
229 ( p_itemtype in varchar2,
230 p_itemkey in varchar2,
231 p_actid in number,
232 p_funcmode in varchar2,
233 p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
234 );
235
236 PROCEDURE SET_XML_CONTEXT
237 (
238 p_user_name IN VARCHAR2,
239 x_return_status OUT NOCOPY VARCHAR2,
240 x_return_text IN OUT NOCOPY VARCHAR2
241 );
242
243 PROCEDURE CATGI_UPDATE_PUBLISH_OPTIONS
244 (
245 p_price_book_name IN VARCHAR2,
246 p_customer_attr_value IN NUMBER,
247 p_effective_date IN DATE,
248 p_price_book_type_code IN VARCHAR2,
249 p_dlv_xml_site_id IN NUMBER,
250 p_generation_time_code IN VARCHAR2,
251 p_gen_schedule_date IN DATE,
252 x_pb_input_header_id OUT NOCOPY NUMBER,
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_return_text IN OUT NOCOPY VARCHAR2
255 );
256
257 PROCEDURE CATGI_POST_INSERT_PROCESSING
258 (
259 p_pb_input_header_id IN NUMBER,
260 x_return_status OUT NOCOPY VARCHAR2,
261 x_return_text IN OUT NOCOPY VARCHAR2
262 );
263
264 PROCEDURE CATGI_UPDATE_CUST_ACCOUNT_ID
265 (
266 p_pb_input_header_id IN NUMBER,
267 p_cust_account_id IN NUMBER,
268 x_return_status OUT NOCOPY VARCHAR2,
269 x_return_text IN OUT NOCOPY VARCHAR2
270 );
271
272 FUNCTION GET_PTE_CODE(p_request_type_code VARCHAR2) RETURN VARCHAR2;
273 /** KDURGASI **/
274 PROCEDURE GENERATE_PRICE_BOOK_XML
275 (
276 p_price_book_hdr_id IN NUMBER,
277 p_document_content_type IN VARCHAR2,
278 p_document_name IN VARCHAR2,
279 x_return_status OUT NOCOPY VARCHAR2,
280 x_return_text OUT NOCOPY VARCHAR2
281 );
282 /** KDURGASI **/
283 ---------------------------------------------------------
284
285 END QP_PRICE_BOOK_UTIL;