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