1 PACKAGE Oe_Related_Items_Pvt AS
2 /* $Header: OEXFRELS.pls 120.0 2005/06/01 01:49:51 appldev noship $ */
3
4 PROCEDURE get_upgrade_item_details(l_inv_item_id in number,
5 out_inv_item_name out nocopy varchar2,
6 out_inv_desc out nocopy varchar2,
7 out_inv_item_type out nocopy varchar2
8 );
9
10 PROCEDURE defaulting(
11 p_org_id in varchar2
12 ,p_cust_account_id in number
13 ,p_related_item_id in number
14 ,p_ship_to_org_id in number
15 ,p_line_set_id in number
16 ,p_ship_set_id in number
17 ,p_line_type_id in number
18 ,p_deliver_to_org_id in number
19 ,p_accounting_rule_id in number
20 ,p_accounting_rule_duration in number
21 ,p_actual_arrival_date in date
22 ,p_actual_shipment_date in date
23 ,p_cancelled_flag in varchar2
24 ,p_fob_point_code in varchar2
25 ,p_invoicing_rule_id in number
26 ,p_item_type_code in varchar2
27 ,p_line_category_code in varchar2
28 ,p_open_flag in varchar2
29 ,p_promise_date in date
30 ,p_salesrep_id in number
31 ,p_schedule_ship_date in date
32 ,p_schedule_arrival_date in date
33 ,p_customer_shipment_number in number
34 ,p_agreement_id in number
35 ,p_header_id in number
36 ,p_invoice_to_org_id in number
37 ,p_price_list_id in number
38 ,p_request_date in date
39 ,p_arrival_set_id in number
40 ,x_wsh_id out nocopy number
41 ,x_uom out nocopy varchar2
42 );
43
44 Procedure Call_MRP_ATP(
45 p_global_orgs in varchar2,
46 p_ship_from_org_id in number,
47 p_related_item_id in number,
48 p_related_uom in VARCHAR2,
49 p_request_date in DATE,
50 p_ordered_qty in NUMBER,
51 p_cust_account_id in NUMBER,
52 p_ship_to_org_id in NUMBER,
53 x_available_qty out NOCOPY /* file.sql.39 change */ varchar2,
54 x_ship_from_org_id out NOCOPY /* file.sql.39 change */ number,
55 x_available_date out NOCOPY /* file.sql.39 change */ date,
56 x_qty_uom out NOCOPY /* file.sql.39 change */ varchar2,
57 x_out_message out NOCOPY /* file.sql.39 change */ varchar2,
58 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
59 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
60 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
61 x_error_message OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62 );
63
64 Procedure Check_Results_from_rec (
65 p_global_orgs in varchar2
66 ,p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
67 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
68 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
69 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
70 ,x_error_message out NOCOPY /* file.sql.39 change */ varchar2
71 );
72
73 Procedure Initialize_mrp_record(
74 p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ
75 ,l_count IN NUMBER);
76
77
78 PROCEDURE get_ship_from_org(in_org_id in number,
79 out_code out NOCOPY /* file.sql.39 change */ varchar2,
80 out_name out NOCOPY /* file.sql.39 change */ varchar2
81 );
82
83 PROCEDURE copy_Header_to_request(
84 p_request_type_code in varchar2
85 ,p_calculate_price_flag in varchar2
86 ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
87 );
88
89 PROCEDURE copy_Line_to_request(
90 px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
91 ,p_pricing_event in varchar2
92 ,p_Request_Type_Code in varchar2
93 ,p_honor_price_flag in VARCHAR2 Default 'Y'
94 );
95
96
97 PROCEDURE set_pricing_control_record (
98 l_Control_Rec in out nocopy QP_PREQ_GRP.CONTROL_RECORD_TYPE
99 ,in_pricing_event in varchar2);
100
101 PROCEDURE build_context_for_line(
102 p_req_line_tbl_count in number,
103 p_price_request_code in varchar2,
104 p_item_type_code in varchar2,
105 p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
106 p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
107 );
108
109 PROCEDURE copy_attribs_to_Req(
110 p_line_index number
111 ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
112 ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
113 ,p_pricing_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
114 ,p_qualifier_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
115 );
116
117 PROCEDURE Append_attributes(
118 p_header_id number default null
119 ,p_Line_id number default null
120 ,p_line_index number
121 ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
122 ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
123 );
124
125 PROCEDURE build_context_for_header(
126 p_req_line_tbl_count in number,
127 p_price_request_code in varchar2,
128 p_item_type_code in varchar2,
129 p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
130 p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
131 );
132
133 PROCEDURE price_item(
134 out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
135 out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
136 out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
137 out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
138 out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
139 out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
140 out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
141 out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,
142 in_related_item_id in number,
143 in_qty in number,
144 in_uom in varchar2,
145 in_request_date in date,
146 in_customer_id in number,
147 in_item_identifier_type in varchar2,
148 in_agreement_id in number,
149 in_price_list_id in number,
150 in_ship_to_org_id in number,
151 in_invoice_to_org_id in number,
152 in_ship_from_org_id in number,
153 in_pricing_date in date,
154 in_order_type_id in number,
155 in_currency in varchar2,
156 in_pricing_context in varchar2,
157 in_pricing_attribute1 in varchar2,
158 in_pricing_attribute2 in varchar2,
159 in_pricing_attribute3 in varchar2,
160 in_pricing_attribute4 in varchar2,
161 in_pricing_attribute5 in varchar2,
162 in_pricing_attribute6 in varchar2,
163 in_pricing_attribute7 in varchar2,
164 in_pricing_attribute8 in varchar2,
165 in_pricing_attribute9 in varchar2,
166 in_pricing_attribute10 in varchar2,
167 in_pricing_attribute11 in varchar2,
168 in_pricing_attribute12 in varchar2,
169 in_pricing_attribute13 in varchar2,
170 in_pricing_attribute14 in varchar2,
171 in_pricing_attribute15 in varchar2,
172 in_pricing_attribute16 in varchar2,
173 in_pricing_attribute17 in varchar2,
174 in_pricing_attribute18 in varchar2,
175 in_pricing_attribute19 in varchar2,
176 in_pricing_attribute20 in varchar2,
177 in_pricing_attribute21 in varchar2,
178 in_pricing_attribute22 in varchar2,
179 in_pricing_attribute23 in varchar2,
180 in_pricing_attribute24 in varchar2,
181 in_pricing_attribute25 in varchar2,
182 in_pricing_attribute26 in varchar2,
183 in_pricing_attribute27 in varchar2,
184 in_pricing_attribute28 in varchar2,
185 in_pricing_attribute29 in varchar2,
186 in_pricing_attribute30 in varchar2,
187 in_pricing_attribute31 in varchar2,
188 in_pricing_attribute32 in varchar2,
189 in_pricing_attribute33 in varchar2,
190 in_pricing_attribute34 in varchar2,
191 in_pricing_attribute35 in varchar2,
192 in_pricing_attribute36 in varchar2,
193 in_pricing_attribute37 in varchar2,
194 in_pricing_attribute38 in varchar2,
195 in_pricing_attribute39 in varchar2,
196 in_pricing_attribute40 in varchar2,
197 in_pricing_attribute41 in varchar2,
198 in_pricing_attribute42 in varchar2,
199 in_pricing_attribute43 in varchar2,
200 in_pricing_attribute44 in varchar2,
201 in_pricing_attribute45 in varchar2,
202 in_pricing_attribute46 in varchar2,
203 in_pricing_attribute47 in varchar2,
204 in_pricing_attribute48 in varchar2,
205 in_pricing_attribute49 in varchar2,
206 in_pricing_attribute50 in varchar2,
207 in_pricing_attribute51 in varchar2,
208 in_pricing_attribute52 in varchar2,
209 in_pricing_attribute53 in varchar2,
210 in_pricing_attribute54 in varchar2,
211 in_pricing_attribute55 in varchar2,
212 in_pricing_attribute56 in varchar2,
213 in_pricing_attribute57 in varchar2,
214 in_pricing_attribute58 in varchar2,
215 in_pricing_attribute59 in varchar2,
216 in_pricing_attribute60 in varchar2,
217 in_pricing_attribute61 in varchar2,
218 in_pricing_attribute62 in varchar2,
219 in_pricing_attribute63 in varchar2,
220 in_pricing_attribute64 in varchar2,
221 in_pricing_attribute65 in varchar2,
222 in_pricing_attribute66 in varchar2,
223 in_pricing_attribute67 in varchar2,
224 in_pricing_attribute68 in varchar2,
225 in_pricing_attribute69 in varchar2,
226 in_pricing_attribute70 in varchar2,
227 in_pricing_attribute71 in varchar2,
228 in_pricing_attribute72 in varchar2,
229 in_pricing_attribute73 in varchar2,
230 in_pricing_attribute74 in varchar2,
231 in_pricing_attribute75 in varchar2,
232 in_pricing_attribute76 in varchar2,
233 in_pricing_attribute77 in varchar2,
234 in_pricing_attribute78 in varchar2,
235 in_pricing_attribute79 in varchar2,
236 in_pricing_attribute80 in varchar2,
237 in_pricing_attribute81 in varchar2,
238 in_pricing_attribute82 in varchar2,
239 in_pricing_attribute83 in varchar2,
240 in_pricing_attribute84 in varchar2,
241 in_pricing_attribute85 in varchar2,
242 in_pricing_attribute86 in varchar2,
243 in_pricing_attribute87 in varchar2,
244 in_pricing_attribute88 in varchar2,
245 in_pricing_attribute89 in varchar2,
246 in_pricing_attribute90 in varchar2,
247 in_pricing_attribute91 in varchar2,
248 in_pricing_attribute92 in varchar2,
249 in_pricing_attribute93 in varchar2,
250 in_pricing_attribute94 in varchar2,
251 in_pricing_attribute95 in varchar2,
252 in_pricing_attribute96 in varchar2,
253 in_pricing_attribute97 in varchar2,
254 in_pricing_attribute98 in varchar2,
255 in_pricing_attribute99 in varchar2,
256 in_pricing_attribute100 in varchar2,
257 in_header_id in NUMBER
258 );
259
260 PROCEDURE process_pricing_errors(
261 in_line_type_code in varchar2,
262 in_status_code in varchar2,
263 in_status_text in varchar2,
264 in_ordered_item in varchar2,
265 in_uom in varchar2,
266 in_unit_price in number,
267 in_adjusted_unit_price in number,
268 in_process_code in varchar2 ,
269 in_price_flag in varchar2,
270 in_price_list_id in number,
271 l_return_status out NOCOPY /* file.sql.39 change */ varchar2,
272 l_msg_count out NOCOPY /* file.sql.39 change */ number,
273 l_msg_data out NOCOPY /* file.sql.39 change */ varchar2
274 );
275
276 Function Get_Rounding_factor(p_list_header_id number) return number;
277
278 PROCEDURE get_Price_List_info(
279 p_price_list_id IN NUMBER,
280 out_name out NOCOPY /* file.sql.39 change */ varchar2,
281 out_end_date out NOCOPY /* file.sql.39 change */ date,
282 out_start_date out NOCOPY /* file.sql.39 change */ date,
283 out_automatic_flag out NOCOPY /* file.sql.39 change */ varchar2,
284 out_rounding_factor out NOCOPY /* file.sql.39 change */ varchar2,
285 out_terms_id out NOCOPY /* file.sql.39 change */ number,
286 out_gsa_indicator out NOCOPY /* file.sql.39 change */ varchar2,
287 out_currency out NOCOPY /* file.sql.39 change */ varchar2,
288 out_freight_terms_code out NOCOPY /* file.sql.39 change */ varchar2);
289
290 PROCEDURE different_uom(
291 in_org_id in number
292 ,in_ordered_uom in varchar2
293 ,in_pricing_uom in varchar2
294 ,out_conversion_rate out NOCOPY /* file.sql.39 change */ number
295 );
296
297 FUNCTION get_conversion_rate(in_uom_code in varchar2,
298 in_base_uom in varchar2
299 ) RETURN number;
300
301 PROCEDURE print_time(in_place in varchar2);
302
303 PROCEDURE print_time2;
304 END Oe_Related_Items_Pvt;
305