[Home] [Help]
PACKAGE: APPS.QP_PRICE_BOOK_PUB
Source
1 PACKAGE QP_PRICE_BOOK_PUB AUTHID CURRENT_USER AS
2 /*$Header: QPXPPRBS.pls 120.7 2006/04/27 15:11 rchellam noship $*/
3
4 TYPE pb_input_header_rec IS RECORD (
5 customer_context VARCHAR2(30),
6 customer_attribute VARCHAR2(30),
7 customer_attr_value VARCHAR2(240),
8 cust_account_id NUMBER,
9 currency_code VARCHAR2(30),
10 limit_products_by VARCHAR2(30),
11 product_context VARCHAR2(30),
12 product_attribute VARCHAR2(30),
13 product_attr_value VARCHAR2(240),
14 effective_date DATE,
15 item_quantity NUMBER,
16 pub_template_code VARCHAR2(80),
17 pub_language VARCHAR2(6),
18 pub_territory VARCHAR2(6),
19 pub_output_document_type VARCHAR2(30),
20 dlv_xml_flag VARCHAR2(1),
21 dlv_xml_site_id NUMBER,
22 dlv_email_flag VARCHAR2(1),
23 dlv_email_addresses VARCHAR2(240),
24 dlv_printer_flag VARCHAR2(1),
25 dlv_printer_name VARCHAR2(80),
26 generation_time_code VARCHAR2(30),
27 gen_schedule_date DATE,
28 org_id NUMBER,
29 price_book_type_code VARCHAR2(1),
30 price_based_on VARCHAR2(30),
31 pl_agr_bsa_id NUMBER,
32 pricing_perspective_code VARCHAR2(30),
33 publish_existing_pb_flag VARCHAR2(1),
34 overwrite_existing_pb_flag VARCHAR2(1),
35 request_origination_code VARCHAR2(3),
36 request_type_code VARCHAR2(30),--to be removed later
37 price_book_name VARCHAR2(240),
38 pl_agr_bsa_name VARCHAR2(240),
39 pub_template_name VARCHAR2(240));
40
41 TYPE pb_input_lines_rec IS RECORD (
42 context VARCHAR2(30),
43 attribute VARCHAR2(30),
44 attribute_value VARCHAR2(240),
45 attribute_type VARCHAR2(30));
46
47 TYPE pb_input_lines_tbl IS TABLE OF pb_input_lines_rec
48 INDEX BY BINARY_INTEGER;
49
50 TYPE price_book_header_rec IS RECORD (
51 price_book_header_id NUMBER,
52 price_book_type_code VARCHAR2(1),
53 currency_code VARCHAR2(30),
54 effective_date DATE,
55 org_id NUMBER,
56 customer_id NUMBER,
57 cust_account_id NUMBER,
58 document_id NUMBER,
59 item_category NUMBER,
60 price_based_on VARCHAR2(30),
61 pl_agr_bsa_id NUMBER,
62 pricing_perspective_code VARCHAR2(30),
63 item_quantity NUMBER,
64 request_id NUMBER,
65 request_type_code VARCHAR2(30),
66 pb_input_header_id NUMBER,
67 pub_status_code VARCHAR2(30),
68 price_book_name VARCHAR2(240),
69 pl_agr_bsa_name VARCHAR2(240),
70 creation_date DATE,
71 created_by NUMBER,
72 last_update_date DATE,
73 last_updated_by NUMBER,
74 last_update_login NUMBER,
75 price_book_type VARCHAR2(80),
76 currency VARCHAR2(240),
77 operating_unit VARCHAR2(240),
78 customer_name VARCHAR2(360));
79
80 TYPE price_book_lines_rec IS RECORD (
81 price_book_line_id NUMBER,
82 price_book_header_id NUMBER,
83 item_number NUMBER,
84 product_uom_code VARCHAR2(3),
85 list_price NUMBER,
86 net_price NUMBER,
87 sync_action_code VARCHAR2(1),
88 line_status_code VARCHAR2(1),
89 creation_date DATE,
90 created_by NUMBER,
91 last_update_date DATE,
92 last_updated_by NUMBER,
93 last_update_login NUMBER,
94 description VARCHAR2(240), --Item Description
95 customer_item_number VARCHAR2(50),
96 customer_item_desc VARCHAR2(240),
97 display_item_number VARCHAR2(40),
98 sync_action VARCHAR2(80));
99
100 TYPE price_book_lines_tbl IS TABLE OF price_book_lines_rec
101 INDEX BY BINARY_INTEGER;
102
103 TYPE price_book_line_details_rec IS RECORD (
104 price_book_line_det_id NUMBER,
105 price_book_line_id NUMBER,
106 price_book_header_id NUMBER,
107 list_header_id NUMBER,
108 list_line_id NUMBER,
109 list_line_no VARCHAR2(30),
110 list_price NUMBER,
111 modifier_operand NUMBER,
112 modifier_application_method VARCHAR2(30),
113 adjustment_amount NUMBER,
114 adjusted_net_price NUMBER,
115 list_line_type_code VARCHAR2(30),
116 price_break_type_code VARCHAR2(30),
117 creation_date DATE,
118 created_by NUMBER,
119 last_update_date DATE,
120 last_updated_by NUMBER,
121 last_update_login NUMBER,
122 list_name VARCHAR2(240),
123 list_line_type VARCHAR2(80),
124 price_break_type VARCHAR2(80),
125 application_method_name VARCHAR2(80));
126
127 TYPE price_book_line_details_tbl IS TABLE OF
128 price_book_line_details_rec INDEX BY BINARY_INTEGER;
129
130 TYPE price_book_attributes_rec IS RECORD (
131 price_book_attribute_id NUMBER,
132 price_book_line_det_id NUMBER,
133 price_book_line_id NUMBER,
134 price_book_header_id NUMBER,
135 pricing_prod_context VARCHAR2(30),
136 pricing_prod_attribute VARCHAR2(30),
137 comparison_operator_code VARCHAR2(30),
138 pricing_prod_attr_value_from VARCHAR2(240),
139 pricing_attr_value_to VARCHAR2(240),
140 pricing_prod_attr_datatype VARCHAR2(30),
141 attribute_type VARCHAR2(30),
142 creation_date DATE,
143 created_by NUMBER,
144 last_update_date DATE,
145 last_updated_by NUMBER,
146 last_update_login NUMBER,
147 context_name VARCHAR2(240),
148 attribute_name VARCHAR2(80),
149 attribute_value_name VARCHAR2(30),
150 attribute_value_to_name VARCHAR2(30),
151 comparison_operator_name VARCHAR2(80));
152
153 TYPE price_book_attributes_tbl IS TABLE OF price_book_attributes_rec
154 INDEX BY BINARY_INTEGER;
155
156 TYPE price_book_break_lines_rec IS RECORD (
157 price_book_break_line_id NUMBER,
158 price_book_header_id NUMBER,
159 price_book_line_id NUMBER,
160 price_book_line_det_id NUMBER,
161 pricing_context VARCHAR2(30),
162 pricing_attribute VARCHAR2(30),
163 comparison_operator_code VARCHAR2(30),
164 pricing_attr_value_from VARCHAR2(240),
165 pricing_attr_value_to VARCHAR2(240),
166 pricing_attribute_datatype VARCHAR2(30),
167 operand NUMBER,
168 application_method VARCHAR2(30),
169 recurring_value NUMBER,
170 creation_date DATE,
171 created_by NUMBER,
172 last_update_date DATE,
173 last_updated_by NUMBER,
174 last_update_login NUMBER,
175 context_name VARCHAR2(240),
176 attribute_name VARCHAR2(80),
177 attribute_value_name VARCHAR2(30),
178 attribute_value_to_name VARCHAR2(30),
179 comparison_operator_name VARCHAR2(80),
180 application_method_name VARCHAR2(80));
181
182 TYPE price_book_break_lines_tbl IS TABLE OF price_book_break_lines_rec
183 INDEX BY BINARY_INTEGER;
184
185 TYPE price_book_messages_tbl IS TABLE OF qp_price_book_messages%ROWTYPE
186 INDEX BY BINARY_INTEGER;
187
188 TYPE documents_rec IS RECORD (
189 document_id NUMBER,
190 document_content BLOB,
191 document_content_type VARCHAR2(240),
192 document_name VARCHAR2(240),
193 creation_date DATE,
194 created_by NUMBER,
195 last_update_date DATE,
196 last_updated_by NUMBER,
197 last_update_login NUMBER);
198
199 TYPE VARCHAR_TBL IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
200
201 /*****************************************************************************
202 Public API to Create and Publish Full/Delta Price Book
203 *****************************************************************************/
204 PROCEDURE Create_Publish_Price_Book(
205 p_pb_input_header_rec IN pb_input_header_rec,
206 p_pb_input_lines_tbl IN pb_input_lines_tbl,
207 x_request_id OUT NOCOPY NUMBER,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_retcode OUT NOCOPY NUMBER,
210 x_err_buf OUT NOCOPY VARCHAR2,
211 x_price_book_messages_tbl OUT NOCOPY price_book_messages_tbl);
212
213 /*****************************************************************************
214 Public API to Query an existing Full/Delta Price Book
215 *****************************************************************************/
216 PROCEDURE Get_Price_Book(
217 p_price_book_name IN VARCHAR2,
218 p_customer_id IN NUMBER,
219 p_price_book_type_code IN VARCHAR2,
220 x_price_book_header_rec OUT NOCOPY price_book_header_rec,
221 x_price_book_lines_tbl OUT NOCOPY price_book_lines_tbl,
222 x_price_book_line_details_tbl OUT NOCOPY price_book_line_details_tbl,
223 x_price_book_attributes_tbl OUT NOCOPY price_book_attributes_tbl,
224 x_price_book_break_lines_tbl OUT NOCOPY price_book_break_lines_tbl,
225 x_price_book_messages_tbl OUT NOCOPY price_book_messages_tbl,
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_query_messages OUT NOCOPY VARCHAR_TBL);
228
229 /*****************************************************************************
230 Overloaded Public API to Query an existing Full/Delta Price Book along with
231 the attached formatted (.pdf, etc.) document
232 *****************************************************************************/
233 PROCEDURE Get_Price_Book(
234 p_price_book_name IN VARCHAR2,
235 p_customer_id IN NUMBER,
236 p_price_book_type_code IN VARCHAR2,
237 x_price_book_header_rec OUT NOCOPY price_book_header_rec,
238 x_price_book_lines_tbl OUT NOCOPY price_book_lines_tbl,
239 x_price_book_line_details_tbl OUT NOCOPY price_book_line_details_tbl,
240 x_price_book_attributes_tbl OUT NOCOPY price_book_attributes_tbl,
241 x_price_book_break_lines_tbl OUT NOCOPY price_book_break_lines_tbl,
242 x_price_book_messages_tbl OUT NOCOPY price_book_messages_tbl,
243 x_documents_rec OUT NOCOPY documents_rec,
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_query_messages OUT NOCOPY VARCHAR_TBL);
246
247 END QP_PRICE_BOOK_PUB;