1 PACKAGE OE_CNCL_Validate AS
2 /* $Header: OEXVCATS.pls 120.1 2006/02/20 22:05:18 mbhoumik noship $ */
3
4 -- =======================================================================
5 FUNCTION Accounting_Rule(p_accounting_rule_id IN NUMBER)RETURN BOOLEAN;
6 FUNCTION Actual_Arrival_Date(p_actual_arrival_date IN DATE)RETURN BOOLEAN;
7 FUNCTION Actual_Shipment_Date(p_actual_shipment_date IN DATE)RETURN BOOLEAN;
8 FUNCTION Agreement(p_agreement_id IN NUMBER)RETURN BOOLEAN;
9 FUNCTION Ato_Line(p_ato_line_id IN NUMBER)RETURN BOOLEAN;
10 FUNCTION Auto_selected_Quantity(p_auto_selected_quantity IN NUMBER)RETURN BOOLEAN;
11 FUNCTION Booked(p_booked_flag IN VARCHAR2)RETURN BOOLEAN;
12 FUNCTION Cancelled(p_cancelled_flag IN VARCHAR2)RETURN BOOLEAN;
13 FUNCTION Cancelled_Quantity(p_cancelled_quantity IN NUMBER)RETURN BOOLEAN;
14 FUNCTION Component(p_component_code IN VARCHAR2)RETURN BOOLEAN;
15 FUNCTION Component_Number(p_component_number IN NUMBER)RETURN BOOLEAN;
16 FUNCTION Component_Sequence(p_component_sequence_id IN NUMBER)RETURN BOOLEAN;
17 FUNCTION Config_Header(p_config_header_id IN NUMBER)RETURN BOOLEAN;
18 FUNCTION Config_Rev_Nbr(p_config_rev_nbr IN NUMBER)RETURN BOOLEAN;
19 FUNCTION Config_Display_Sequence(p_config_display_sequence IN NUMBER)RETURN BOOLEAN;
20 FUNCTION Configuration(p_configuration_id IN NUMBER)RETURN BOOLEAN;
21 FUNCTION Conversion_Rate(p_conversion_rate IN NUMBER)RETURN BOOLEAN;
22 FUNCTION Conversion_Rate_Date ( p_conversion_rate_date IN DATE ) RETURN BOOLEAN;
23 FUNCTION Conversion_Type(p_conversion_type_code IN VARCHAR2)RETURN BOOLEAN;
24 FUNCTION CUSTOMER_PREFERENCE_SET(p_CUSTOMER_PREFERENCE_SET_CODE IN VARCHAR2)RETURN BOOLEAN;
25 FUNCTION Created_By(p_created_by IN NUMBER)RETURN BOOLEAN;
26 FUNCTION Creation_Date(p_creation_date IN DATE)RETURN BOOLEAN;
27 FUNCTION Credit_Invoice_Line(p_credit_invoice_line_id IN NUMBER) RETURN BOOLEAN;
28 FUNCTION Cust_Dock(p_cust_dock_code IN VARCHAR2)RETURN BOOLEAN;
29 FUNCTION Cust_Job(p_cust_job IN VARCHAR2)RETURN BOOLEAN;
30 FUNCTION Cust_Model_Serial_Number(p_cust_model_serial_number IN VARCHAR2)RETURN BOOLEAN;
31 FUNCTION Cust_Po_Number(p_cust_po_number IN VARCHAR2)RETURN BOOLEAN;
32 FUNCTION Cust_Production_Line(p_cust_production_line IN VARCHAR2)RETURN BOOLEAN;
33 FUNCTION Customer_Dock(p_customer_dock_code IN VARCHAR2)RETURN BOOLEAN;
34 FUNCTION Customer_Job(p_customer_job IN VARCHAR2)RETURN BOOLEAN;
35 FUNCTION Customer_Production_Line(p_customer_production_line IN VARCHAR2)RETURN BOOLEAN;
36 FUNCTION Customer_Trx_Line(p_customer_trx_line_id IN NUMBER)RETURN BOOLEAN;
37 FUNCTION Date_And_Time_Promised(p_date_and_time_promised IN DATE)RETURN BOOLEAN;
38 FUNCTION Date_And_Time_Requested(p_date_and_time_requested IN DATE)RETURN BOOLEAN;
39 FUNCTION Date_And_Time_Scheduled(p_date_and_time_scheduled IN DATE)RETURN BOOLEAN;
40 FUNCTION Date_Ordered(p_date_ordered IN DATE)RETURN BOOLEAN;
41 FUNCTION Date_Requested(p_date_requested IN DATE)RETURN BOOLEAN;
42 FUNCTION Deliver_To_Contact(p_deliver_to_contact_id IN NUMBER)RETURN BOOLEAN;
43 FUNCTION Deliver_To_Org(p_deliver_to_org_id IN NUMBER)RETURN BOOLEAN;
44 FUNCTION Delivery_Lead_Time(p_delivery_lead_time IN NUMBER)RETURN BOOLEAN;
45 FUNCTION Demand_Bucket_Type(p_demand_bucket_type IN VARCHAR2)RETURN BOOLEAN;
46 FUNCTION Demand_Class(p_demand_class_code IN VARCHAR2)RETURN BOOLEAN;
47 FUNCTION Demand_Stream(p_demand_stream_id IN NUMBER)RETURN BOOLEAN;
48 FUNCTION Dep_Plan_Required(p_dep_plan_required_flag IN VARCHAR2)RETURN BOOLEAN;
49 FUNCTION Desc_Flex ( p_flex_name IN VARCHAR2 )RETURN BOOLEAN;
50 FUNCTION Description(p_description IN VARCHAR2)RETURN BOOLEAN;
51 FUNCTION Dw_Update_Advice(p_dw_update_advice_flag IN VARCHAR2)RETURN BOOLEAN;
52 FUNCTION Earliest_Acceptable_Date(p_earliest_acceptable_date IN DATE)RETURN BOOLEAN;
53 FUNCTION Earliest_Schedule_Limit(p_earliest_schedule_limit IN NUMBER)RETURN BOOLEAN;
54 FUNCTION End_Date_Active(p_end_date_active IN DATE)RETURN BOOLEAN;
55 FUNCTION End_Item_Unit_Number(p_end_item_unit_number IN VARCHAR2)RETURN BOOLEAN;
56 FUNCTION Expiration_Date(p_expiration_date IN DATE)RETURN BOOLEAN;
57 FUNCTION Explosion_Date(p_explosion_date IN DATE)RETURN BOOLEAN;
58 FUNCTION First_Ack(p_first_ack_code IN VARCHAR2)RETURN BOOLEAN;
59 FUNCTION First_Ack_Date(p_first_ack_date IN DATE)RETURN BOOLEAN;
60 FUNCTION Fob_Point(p_fob_point_code IN VARCHAR2)RETURN BOOLEAN;
61 FUNCTION Freight_Carrier(p_freight_carrier_code IN VARCHAR2)RETURN BOOLEAN;
62 FUNCTION Freight_Terms(p_freight_terms_code IN VARCHAR2)RETURN BOOLEAN;
63 FUNCTION Fulfilled_Quantity(p_fulfilled_quantity IN NUMBER)RETURN BOOLEAN;
64 FUNCTION Fulfilled(p_fulfilled_flag IN VARCHAR2)RETURN BOOLEAN;
65 FUNCTION fulfillment_method(p_fulfillment_method_code IN VARCHAR2)RETURN BOOLEAN;
66 FUNCTION fulfillment_date(p_fulfillment_date IN DATE)RETURN BOOLEAN;
67 FUNCTION Global_Attribute1(p_global_attribute1 IN VARCHAR2)RETURN BOOLEAN;
68
69 FUNCTION Calculate_Price_Flag(p_calculate_price_flag IN VARCHAR2)RETURN BOOLEAN;
70
71 FUNCTION Header(p_header_id IN NUMBER)RETURN BOOLEAN;
72 FUNCTION Inventory_Item(p_inventory_item_id IN NUMBER)RETURN BOOLEAN;
73 FUNCTION Internal_Item(p_internal_item_id IN NUMBER)RETURN BOOLEAN;
74 FUNCTION Cust_Item_Setting(p_cust_item_setting_id IN NUMBER)RETURN BOOLEAN;
75 FUNCTION Invoice_Interface_Status(p_invoice_interface_status IN VARCHAR2)RETURN BOOLEAN;
76 FUNCTION Invoice_To_Contact(p_invoice_to_contact_id IN NUMBER)RETURN BOOLEAN;
77 FUNCTION Invoice_To_Org(p_invoice_to_org_id IN NUMBER)RETURN BOOLEAN;
78 FUNCTION Invoicing_Rule(p_invoicing_rule_id IN NUMBER)RETURN BOOLEAN;
79 FUNCTION Ordered_Item_Id(p_ordered_item_id IN NUMBER)RETURN BOOLEAN;
80 FUNCTION Item_Identifier_Type(p_item_identifier_type IN VARCHAR2)RETURN BOOLEAN;
81 FUNCTION Ordered_Item(p_ordered_item IN VARCHAR2)RETURN BOOLEAN;
82 FUNCTION Item_Revision(p_item_revision IN VARCHAR2)RETURN BOOLEAN;
83 FUNCTION Item_Type(p_item_type_code IN VARCHAR2)RETURN BOOLEAN;
84 FUNCTION Last_Ack(p_last_ack_code IN VARCHAR2)RETURN BOOLEAN;
85 FUNCTION Last_Ack_Date(p_last_ack_date IN DATE)RETURN BOOLEAN;
86 FUNCTION Last_Update_Date(p_last_update_date IN DATE)RETURN BOOLEAN;
87 FUNCTION Last_Update_Login(p_last_update_login IN NUMBER)RETURN BOOLEAN;
88 FUNCTION Last_Updated_By(p_last_updated_by IN NUMBER)RETURN BOOLEAN;
89 FUNCTION Latest_Acceptable_Date(p_latest_acceptable_date IN DATE)RETURN BOOLEAN;
90 FUNCTION Latest_Schedule_Limit(p_latest_schedule_limit IN NUMBER)RETURN BOOLEAN;
91 FUNCTION Line(p_line_id IN NUMBER)RETURN BOOLEAN;
92 FUNCTION Line_Category(p_line_category_code IN VARCHAR2)RETURN BOOLEAN;
93 FUNCTION Line_Category_Code(line_category_code IN VARCHAR2) RETURN BOOLEAN;
94 FUNCTION Line_Number(p_line_number IN NUMBER)RETURN BOOLEAN;
95 FUNCTION Line_Type(p_line_type_id IN NUMBER)RETURN BOOLEAN;
96 FUNCTION Link_To_Line(p_link_to_line_id IN NUMBER)RETURN BOOLEAN;
97 FUNCTION Model_Group_Number(p_model_group_number IN NUMBER)RETURN BOOLEAN;
98 FUNCTION Mfg_Component_Sequence(p_mfg_component_sequence_id IN NUMBER)RETURN BOOLEAN;
99 FUNCTION Name(p_name IN VARCHAR2)RETURN BOOLEAN;
100 FUNCTION Oe_Item_Type(p_oe_item_type IN VARCHAR2)RETURN BOOLEAN;
101 FUNCTION Open(p_open_flag IN VARCHAR2)RETURN BOOLEAN;
102 FUNCTION Option_Flag(p_option_flag IN VARCHAR2)RETURN BOOLEAN;
103 FUNCTION Option_Number(p_option_number IN NUMBER)RETURN BOOLEAN;
104 FUNCTION Order_Number(p_order_number IN NUMBER)
105 RETURN BOOLEAN;
106 FUNCTION Order_Quantity_Uom(p_order_quantity_uom IN VARCHAR2)RETURN BOOLEAN;
107 FUNCTION Ordered_Quantity_Uom2(p_ordered_quantity_uom2 IN VARCHAR2)RETURN BOOLEAN; -- OPM
108 FUNCTION Order_Source(p_order_source_id IN NUMBER)RETURN BOOLEAN;
109 FUNCTION Order_Type(p_order_type_id IN NUMBER)RETURN BOOLEAN;
110 FUNCTION Ordered_Date(p_ordered_date IN DATE)RETURN BOOLEAN;
111 FUNCTION Order_Date_Type_Code(p_order_date_type_code IN VARCHAR2)RETURN BOOLEAN;
112 FUNCTION Ordered_Quantity(p_ordered_quantity IN NUMBER)RETURN BOOLEAN;
113 FUNCTION Ordered_Quantity2(p_ordered_quantity2 IN NUMBER)RETURN BOOLEAN; -- OPM
114 FUNCTION Org(p_org_id IN NUMBER)RETURN BOOLEAN;
115 FUNCTION Orig_Sys_Document_Ref(p_orig_sys_document_ref IN VARCHAR2)RETURN BOOLEAN;
116 FUNCTION Orig_Sys_Line_Ref(p_orig_sys_line_ref IN VARCHAR2)RETURN BOOLEAN;
117 FUNCTION Partial_Shipments_Allowed(p_partial_shipments_allowed IN VARCHAR2)RETURN BOOLEAN;
118 FUNCTION Payment_Term(p_payment_term_id IN NUMBER)RETURN BOOLEAN;
119 FUNCTION Planning_Priority(p_planning_priority IN NUMBER)RETURN BOOLEAN;
120 FUNCTION Percent(p_percent IN NUMBER)RETURN BOOLEAN;
121 FUNCTION Planning_Prod_Seq_No(p_planning_prod_seq_no IN NUMBER)RETURN BOOLEAN;
122 FUNCTION Preferred_Grade(p_preferred_grade IN VARCHAR2)RETURN BOOLEAN; -- OPM
123 FUNCTION Price_List(p_price_list_id IN NUMBER)RETURN BOOLEAN;
124 FUNCTION Pricing_Date(p_pricing_date IN DATE)RETURN BOOLEAN;
125 FUNCTION Pricing_Quantity(p_pricing_quantity IN NUMBER)RETURN BOOLEAN;
126 FUNCTION Pricing_Quantity_Uom(p_pricing_quantity_uom IN VARCHAR2)RETURN BOOLEAN;
127 FUNCTION Program(p_program_id IN NUMBER)RETURN BOOLEAN;
128 FUNCTION Program_Application(p_program_application_id IN NUMBER)RETURN BOOLEAN;
129 FUNCTION Program_Update_Date(p_program_update_date IN DATE)RETURN BOOLEAN;
130 FUNCTION Project(p_project_id IN NUMBER)RETURN BOOLEAN;
131 FUNCTION Promise_Date(p_promise_date IN DATE)RETURN BOOLEAN;
132 FUNCTION Re_Source(p_re_source_flag IN VARCHAR2)RETURN BOOLEAN;
133 FUNCTION Quantity_Cancelled(p_quantity_cancelled IN NUMBER)RETURN BOOLEAN;
134 FUNCTION Quantity_Fulfilled(p_quantity_fulfilled IN NUMBER)RETURN BOOLEAN;
135 FUNCTION Quantity_Ordered(p_quantity_ordered IN NUMBER)RETURN BOOLEAN;
136 FUNCTION Quantity_Shipped(p_quantity_shipped IN NUMBER)RETURN BOOLEAN;
137 FUNCTION RMA_ATTRIBUTE1(rma_attribute1 IN VARCHAR2) RETURN BOOLEAN;
138 FUNCTION RMA_ATTRIBUTE10(rma_attribute10 IN VARCHAR2) RETURN BOOLEAN;
139 FUNCTION RMA_ATTRIBUTE2(rma_attribute2 IN VARCHAR2) RETURN BOOLEAN;
140 FUNCTION RMA_ATTRIBUTE3(rma_attribute3 IN VARCHAR2) RETURN BOOLEAN;
141 FUNCTION RMA_ATTRIBUTE4(rma_attribute4 IN VARCHAR2) RETURN BOOLEAN;
142 FUNCTION RMA_ATTRIBUTE5(rma_attribute5 IN VARCHAR2) RETURN BOOLEAN;
143 FUNCTION RMA_ATTRIBUTE6(rma_attribute6 IN VARCHAR2) RETURN BOOLEAN;
144 FUNCTION RMA_ATTRIBUTE7(rma_attribute7 IN VARCHAR2) RETURN BOOLEAN;
145 FUNCTION RMA_ATTRIBUTE8(rma_attribute8 IN VARCHAR2) RETURN BOOLEAN;
146 FUNCTION RMA_ATTRIBUTE9(rma_attribute9 IN VARCHAR2) RETURN BOOLEAN;
147 FUNCTION RMA_CONTEXT(rma_context IN VARCHAR2) RETURN BOOLEAN;
148 FUNCTION Reference_Cust_Trx_Line_Id(reference_cust_trx_line_id IN NUMBER) RETURN BOOLEAN;
149 FUNCTION Reference_Header(p_reference_header_id IN NUMBER)RETURN BOOLEAN;
150 FUNCTION Reference_Line(p_reference_line_id IN NUMBER)RETURN BOOLEAN;
151 FUNCTION Reference_Type(p_reference_type IN VARCHAR2)RETURN BOOLEAN;
152 FUNCTION Request(p_request_id IN NUMBER)RETURN BOOLEAN;
153 FUNCTION Request_Date(p_request_date IN DATE)RETURN BOOLEAN;
154 FUNCTION Reserved_Quantity(p_reserved_quantity IN NUMBER)RETURN BOOLEAN;
155 FUNCTION Revision(p_revision IN VARCHAR2)RETURN BOOLEAN;
156 FUNCTION Rla_Schedule_Type(p_rla_schedule_type_code IN VARCHAR2)RETURN BOOLEAN;
157 FUNCTION Sales_Credit(p_sales_credit_id IN NUMBER)RETURN BOOLEAN;
158 FUNCTION Salesrep(p_salesrep_id IN NUMBER)RETURN BOOLEAN;
159 FUNCTION Sales_credit_type(p_sales_credit_type_id IN NUMBER)RETURN BOOLEAN;
160 FUNCTION Schedule_Arrival_Date(p_schedule_arrival_date IN DATE)RETURN BOOLEAN;
161 FUNCTION Schedule_Ship_Date(p_schedule_ship_date IN DATE)RETURN BOOLEAN;
162 FUNCTION Schedule_Status(p_schedule_status_code IN VARCHAR2)RETURN BOOLEAN;
163 FUNCTION Schedule_Item_Detail(p_schedule_item_detail_id IN NUMBER)RETURN BOOLEAN;
164 FUNCTION Sequence_Starting_Point(p_sequence_starting_point IN NUMBER)RETURN BOOLEAN;
165 FUNCTION Ship_From_Org(p_ship_from_org_id IN NUMBER)RETURN BOOLEAN;
166 FUNCTION Inventory_Org(p_inventory_org_id IN NUMBER)RETURN BOOLEAN;
167 FUNCTION Ship_Model_Complete(p_ship_model_complete_flag IN VARCHAR2)RETURN BOOLEAN;
168 FUNCTION Ship_To_Contact(p_ship_to_contact_id IN NUMBER)RETURN BOOLEAN;
169 FUNCTION Ship_To_Org(p_ship_to_org_id IN NUMBER)RETURN BOOLEAN;
170 FUNCTION Site_Use(p_site_use_id IN NUMBER)RETURN BOOLEAN;
171 FUNCTION Ship_Tolerance_Above(p_ship_tolerance_above IN NUMBER)RETURN BOOLEAN;
172 FUNCTION Ship_Tolerance_Below(p_ship_tolerance_below IN NUMBER)RETURN BOOLEAN;
173 FUNCTION Shippable(p_shippable_flag IN VARCHAR2)RETURN BOOLEAN;
174 FUNCTION Shipping_Interfaced(p_shipping_interfaced_flag IN VARCHAR2)RETURN BOOLEAN;
175 FUNCTION Shipping_Instructions(p_shipping_instructions IN VARCHAR2)RETURN BOOLEAN;
176 FUNCTION Packing_Instructions(p_packing_instructions IN VARCHAR2)RETURN BOOLEAN;
177 FUNCTION Under_Shipment_Tolerance(p_under_shipment_tolerance IN NUMBER)RETURN BOOLEAN;
178 FUNCTION Over_Shipment_Tolerance(p_over_shipment_tolerance IN NUMBER)RETURN BOOLEAN;
179 FUNCTION Under_Return_Tolerance(p_under_return_tolerance IN NUMBER)RETURN BOOLEAN;
180 FUNCTION Over_Return_Tolerance(p_over_return_tolerance IN NUMBER)RETURN BOOLEAN;
181 FUNCTION Shipment_Number(p_shipment_number IN NUMBER)RETURN BOOLEAN;
182 FUNCTION Shipment_Priority(p_shipment_priority_code IN VARCHAR2)RETURN BOOLEAN;
183 FUNCTION Shipped_Quantity(p_shipped_quantity IN NUMBER)RETURN BOOLEAN;
184 FUNCTION Shipping_Method(p_shipping_method_code IN VARCHAR2)RETURN BOOLEAN;
185 FUNCTION Shipping_Quantity(p_shipping_quantity IN NUMBER)RETURN BOOLEAN;
186 FUNCTION Shipping_Quantity_Uom(p_shipping_quantity_uom IN VARCHAR2)RETURN BOOLEAN;
187 FUNCTION Sold_To_Contact(p_sold_to_contact_id IN NUMBER)RETURN BOOLEAN;
188 FUNCTION Sold_To_Org(p_sold_to_org_id IN NUMBER)RETURN BOOLEAN;
189 FUNCTION Subinventory(p_subinventory IN VARCHAR2)RETURN BOOLEAN;
190 FUNCTION Customer(p_customer_id IN NUMBER)RETURN BOOLEAN;
191 FUNCTION Intermed_Ship_To_Contact(p_intermed_ship_to_contact_id IN NUMBER)RETURN BOOLEAN;
192 FUNCTION Intermed_Ship_To_Org(p_intermed_ship_to_org_id IN NUMBER)RETURN BOOLEAN;
193 FUNCTION Sort_Order(p_sort_order IN VARCHAR2)RETURN BOOLEAN;
194 FUNCTION Source_Document(p_source_document_id IN NUMBER)RETURN BOOLEAN;
195 FUNCTION Source_Document_Line(p_source_document_line_id IN NUMBER)RETURN BOOLEAN;
196 FUNCTION Source_Document_Type(p_source_document_type_id IN NUMBER)RETURN BOOLEAN;
197 FUNCTION Source_Type(p_source_type_code IN VARCHAR2)RETURN BOOLEAN;
198 FUNCTION Task(p_task_id IN NUMBER)RETURN BOOLEAN;
199 FUNCTION Tax(p_tax_code IN VARCHAR2)RETURN BOOLEAN;
200 FUNCTION Tax_Date(p_tax_date IN DATE)RETURN BOOLEAN;
201 FUNCTION Tax_Exempt(p_tax_exempt_flag IN VARCHAR2)RETURN BOOLEAN;
202 FUNCTION Tax_Exempt_Number(p_tax_exempt_number IN VARCHAR2)RETURN BOOLEAN;
203 FUNCTION Tax_Exempt_Reason(p_tax_exempt_reason_code IN VARCHAR2)RETURN BOOLEAN;
204 FUNCTION Tax_Point(p_tax_point_code IN VARCHAR2)RETURN BOOLEAN;
205 FUNCTION Tax_Rate(p_tax_rate IN NUMBER)RETURN BOOLEAN;
206 FUNCTION Tax_Value(p_tax_value IN NUMBER)RETURN BOOLEAN;
207 FUNCTION Top_Model_Line(p_top_model_line_id IN NUMBER)RETURN BOOLEAN;
208 FUNCTION Transactional_Curr(p_transactional_curr_code IN VARCHAR2)RETURN BOOLEAN;
209 FUNCTION Unit_List_Price(p_unit_list_price IN NUMBER)RETURN BOOLEAN;
210 FUNCTION Unit_Selling_Price(p_unit_selling_price IN NUMBER)RETURN BOOLEAN;
211 FUNCTION Version_Number(p_version_number IN NUMBER)RETURN BOOLEAN;
212 FUNCTION Visible_Demand(p_visible_demand_flag IN VARCHAR2)RETURN BOOLEAN;
213 FUNCTION Wh_Update_Date(p_wh_update_date IN DATE)RETURN BOOLEAN;
214 Function SALES_CREDIT_PERCENT( p_percent IN Number) Return Boolean;
215
216 FUNCTION Applied_Flag(p_Applied_Flag IN VARCHAR2)RETURN BOOLEAN;
217 FUNCTION Automatic(p_automatic_flag IN VARCHAR2)RETURN BOOLEAN;
218 FUNCTION Change_Reason_Code(p_Change_Reason_Code IN VARCHAR2)RETURN BOOLEAN;
219 FUNCTION Change_Reason_Text(p_Change_Reason_Text IN VARCHAR2)RETURN BOOLEAN;
220 FUNCTION Discount(p_discount_id IN NUMBER)RETURN BOOLEAN;
221 FUNCTION Discount_Line(p_discount_line_id IN NUMBER)RETURN BOOLEAN;
222 FUNCTION List_Header_id(p_List_Header_id IN NUMBER)RETURN BOOLEAN;
223 FUNCTION List_Line_id(p_List_Line_id IN NUMBER)RETURN BOOLEAN;
224 FUNCTION List_Line_Type_code(p_List_Line_Type_code IN VARCHAR2)RETURN BOOLEAN;
225 FUNCTION Modified_From(p_Modified_From IN VARCHAR2)RETURN BOOLEAN;
226 FUNCTION Modified_To(p_Modified_To IN VARCHAR2)RETURN BOOLEAN;
227 FUNCTION Modifier_mechanism_type_code(p_Modifier_mechanism_type_code IN VARCHAR2)RETURN BOOLEAN;
228 FUNCTION Price_Adjustment(p_price_adjustment_id IN NUMBER)RETURN BOOLEAN;
229 FUNCTION Updated_Flag(p_Updated_Flag IN VARCHAR2)RETURN BOOLEAN;
230 FUNCTION Update_Allowed(p_Update_Allowed IN VARCHAR2)RETURN BOOLEAN;
231
232 FUNCTION From_Serial_Number(p_from_serial_number IN VARCHAR2)RETURN BOOLEAN;
233 FUNCTION Lot_Number(p_lot_number IN VARCHAR2)RETURN BOOLEAN;
234 FUNCTION Lot_Serial(p_lot_serial_id IN NUMBER)RETURN BOOLEAN;
235 FUNCTION Quantity(p_quantity IN NUMBER)RETURN BOOLEAN;
236 FUNCTION To_Serial_Number(p_to_serial_number IN VARCHAR2)RETURN BOOLEAN;
237 FUNCTION Line_Set(p_line_set_id IN NUMBER) RETURN BOOLEAN;
238
239 FUNCTION Amount(p_amount IN NUMBER)RETURN BOOLEAN;
240 FUNCTION Appear_On_Ack(p_appear_on_ack_flag IN VARCHAR2)RETURN BOOLEAN;
241 FUNCTION Appear_On_Invoice(p_appear_on_invoice_flag IN VARCHAR2)RETURN BOOLEAN;
242 FUNCTION Charge(p_charge_id IN NUMBER)RETURN BOOLEAN;
243 FUNCTION Conversion_Date(p_conversion_date IN DATE)RETURN BOOLEAN;
244 FUNCTION Cost_Or_Charge(p_cost_or_charge_flag IN VARCHAR2)RETURN BOOLEAN;
245 FUNCTION Currency(p_currency_code IN VARCHAR2)RETURN BOOLEAN;
246 FUNCTION Departure(p_departure_id IN NUMBER)RETURN BOOLEAN;
247 FUNCTION Estimated(p_estimated_flag IN VARCHAR2)RETURN BOOLEAN;
251 FUNCTION Parent_Charge(p_parent_charge_id IN NUMBER)RETURN BOOLEAN;
248 FUNCTION Inc_In_Sales_Performance(p_inc_in_sales_performance IN VARCHAR2)RETURN BOOLEAN;
249 FUNCTION Invoiced(p_invoiced_flag IN VARCHAR2)RETURN BOOLEAN;
250 FUNCTION Lpn(p_lpn IN NUMBER)RETURN BOOLEAN;
252 FUNCTION Returnable(p_returnable_flag IN VARCHAR2)RETURN BOOLEAN;
253 FUNCTION Tax_Group(p_tax_group_code IN VARCHAR2)RETURN BOOLEAN;
254 FUNCTION Flow_Status(p_flow_status_code IN VARCHAR2)RETURN BOOLEAN;
255 FUNCTION Line_Flow_Status(p_flow_status_code IN VARCHAR2)RETURN BOOLEAN;
256 -- added for bug 4240715
257 FUNCTION IB_OWNER(p_ib_owner IN VARCHAR2)RETURN BOOLEAN;
258 FUNCTION IB_INSTALLED_AT_LOCATION(p_ib_installed_at_location IN VARCHAR2)RETURN BOOLEAN;
259 FUNCTION IB_CURRENT_LOCATION(p_ib_current_location IN VARCHAR2)RETURN BOOLEAN;
260 FUNCTION END_CUSTOMER(p_end_customer_id IN NUMBER)RETURN BOOLEAN;
261 FUNCTION END_CUSTOMER_CONTACT(p_end_customer_contact_id IN NUMBER)RETURN BOOLEAN;
262 FUNCTION END_CUSTOMER_SITE_USE(p_end_customer_site_use_id IN NUMBER)RETURN BOOLEAN;
263 -- END GEN validate
264
265 FUNCTION Header_desc_flex (p_context IN VARCHAR2,
266 p_attribute1 IN VARCHAR2,
267 p_attribute2 IN VARCHAR2,
268 p_attribute3 IN VARCHAR2,
269 p_attribute4 IN VARCHAR2,
270 p_attribute5 IN VARCHAR2,
271 p_attribute6 IN VARCHAR2,
272 p_attribute7 IN VARCHAR2,
273 p_attribute8 IN VARCHAR2,
274 p_attribute9 IN VARCHAR2,
275 p_attribute10 IN VARCHAR2,
276 p_attribute11 IN VARCHAR2,
277 p_attribute12 IN VARCHAR2,
278 p_attribute13 IN VARCHAR2,
279 p_attribute14 IN VARCHAR2,
280 p_attribute15 IN VARCHAR2,
281 p_attribute16 IN VARCHAR2, -- for bug 2184255
282 p_attribute17 IN VARCHAR2,
283 p_attribute18 IN VARCHAR2,
284 p_attribute19 IN VARCHAR2,
285 p_attribute20 IN VARCHAR2)
286 RETURN BOOLEAN;
287 FUNCTION G_Header_desc_flex (p_context IN VARCHAR2,
288 p_attribute1 IN VARCHAR2,
289 p_attribute2 IN VARCHAR2,
290 p_attribute3 IN VARCHAR2,
291 p_attribute4 IN VARCHAR2,
292 p_attribute5 IN VARCHAR2,
293 p_attribute6 IN VARCHAR2,
294 p_attribute7 IN VARCHAR2,
295 p_attribute8 IN VARCHAR2,
296 p_attribute9 IN VARCHAR2,
297 p_attribute10 IN VARCHAR2,
298 p_attribute11 IN VARCHAR2,
299 p_attribute12 IN VARCHAR2,
300 p_attribute13 IN VARCHAR2,
301 p_attribute14 IN VARCHAR2,
302 p_attribute15 IN VARCHAR2,
303 p_attribute16 IN VARCHAR2,
304 p_attribute17 IN VARCHAR2,
305 p_attribute18 IN VARCHAR2,
306 p_attribute19 IN VARCHAR2,
307 p_attribute20 IN VARCHAR2)
308 RETURN BOOLEAN;
309
310 FUNCTION TP_Header_desc_flex (p_context IN VARCHAR2,
311 p_attribute1 IN VARCHAR2,
312 p_attribute2 IN VARCHAR2,
313 p_attribute3 IN VARCHAR2,
314 p_attribute4 IN VARCHAR2,
315 p_attribute5 IN VARCHAR2,
316 p_attribute6 IN VARCHAR2,
317 p_attribute7 IN VARCHAR2,
318 p_attribute8 IN VARCHAR2,
319 p_attribute9 IN VARCHAR2,
320 p_attribute10 IN VARCHAR2,
321 p_attribute11 IN VARCHAR2,
322 p_attribute12 IN VARCHAR2,
323 p_attribute13 IN VARCHAR2,
324 p_attribute14 IN VARCHAR2,
325 p_attribute15 IN VARCHAR2)
326 RETURN BOOLEAN;
327
328 FUNCTION Line_Desc_Flex (p_context IN VARCHAR2,
329 p_attribute1 IN VARCHAR2,
330 p_attribute2 IN VARCHAR2,
331 p_attribute3 IN VARCHAR2,
332 p_attribute4 IN VARCHAR2,
333 p_attribute5 IN VARCHAR2,
334 p_attribute6 IN VARCHAR2,
335 p_attribute7 IN VARCHAR2,
336 p_attribute8 IN VARCHAR2,
337 p_attribute9 IN VARCHAR2,
338 p_attribute10 IN VARCHAR2,
339 p_attribute11 IN VARCHAR2,
340 p_attribute12 IN VARCHAR2,
341 p_attribute13 IN VARCHAR2,
342 p_attribute14 IN VARCHAR2,
343 p_attribute15 IN VARCHAR2,
344 p_attribute16 IN VARCHAR2, -- for bug 2184255
345 p_attribute17 IN VARCHAR2,
346 p_attribute18 IN VARCHAR2,
347 p_attribute19 IN VARCHAR2,
348 p_attribute20 IN VARCHAR2)
349
350 RETURN BOOLEAN;
351 FUNCTION G_Line_Desc_Flex (p_context IN VARCHAR2,
355 p_attribute4 IN VARCHAR2,
352 p_attribute1 IN VARCHAR2,
353 p_attribute2 IN VARCHAR2,
354 p_attribute3 IN VARCHAR2,
356 p_attribute5 IN VARCHAR2,
357 p_attribute6 IN VARCHAR2,
358 p_attribute7 IN VARCHAR2,
359 p_attribute8 IN VARCHAR2,
360 p_attribute9 IN VARCHAR2,
361 p_attribute10 IN VARCHAR2,
362 p_attribute11 IN VARCHAR2,
363 p_attribute12 IN VARCHAR2,
364 p_attribute13 IN VARCHAR2,
365 p_attribute14 IN VARCHAR2,
366 p_attribute15 IN VARCHAR2,
367 p_attribute16 IN VARCHAR2,
368 p_attribute17 IN VARCHAR2,
369 p_attribute18 IN VARCHAR2,
370 p_attribute19 IN VARCHAR2,
371 p_attribute20 IN VARCHAR2)
372 RETURN BOOLEAN;
373 FUNCTION P_Line_Desc_Flex (p_context IN VARCHAR2,
374 p_attribute1 IN VARCHAR2,
375 p_attribute2 IN VARCHAR2,
376 p_attribute3 IN VARCHAR2,
377 p_attribute4 IN VARCHAR2,
378 p_attribute5 IN VARCHAR2,
379 p_attribute6 IN VARCHAR2,
380 p_attribute7 IN VARCHAR2,
381 p_attribute8 IN VARCHAR2,
382 p_attribute9 IN VARCHAR2,
383 p_attribute10 IN VARCHAR2)
384 RETURN BOOLEAN ;
385 FUNCTION I_Line_Desc_Flex (p_context IN VARCHAR2,
386 p_attribute1 IN VARCHAR2,
387 p_attribute2 IN VARCHAR2,
388 p_attribute3 IN VARCHAR2,
389 p_attribute4 IN VARCHAR2,
390 p_attribute5 IN VARCHAR2,
391 p_attribute6 IN VARCHAR2,
392 p_attribute7 IN VARCHAR2,
393 p_attribute8 IN VARCHAR2,
394 p_attribute9 IN VARCHAR2,
395 p_attribute10 IN VARCHAR2,
396 p_attribute11 IN VARCHAR2,
397 p_attribute12 IN VARCHAR2,
398 p_attribute13 IN VARCHAR2,
399 p_attribute14 IN VARCHAR2,
400 p_attribute15 IN VARCHAR2,
401 p_attribute16 IN VARCHAR2,
402 p_attribute17 IN VARCHAR2,
403 p_attribute18 IN VARCHAR2,
404 p_attribute19 IN VARCHAR2,
405 p_attribute20 IN VARCHAR2,
406 p_attribute21 IN VARCHAR2,
407 p_attribute22 IN VARCHAR2,
408 p_attribute23 IN VARCHAR2,
409 p_attribute24 IN VARCHAR2,
410 p_attribute25 IN VARCHAR2,
411 p_attribute26 IN VARCHAR2,
412 p_attribute27 IN VARCHAR2,
413 p_attribute28 IN VARCHAR2,
414 p_attribute29 IN VARCHAR2,
415 p_attribute30 IN VARCHAR2)
416 RETURN BOOLEAN;
417
418 FUNCTION TP_Line_Desc_Flex (p_context IN VARCHAR2,
419 p_attribute1 IN VARCHAR2,
420 p_attribute2 IN VARCHAR2,
421 p_attribute3 IN VARCHAR2,
422 p_attribute4 IN VARCHAR2,
423 p_attribute5 IN VARCHAR2,
424 p_attribute6 IN VARCHAR2,
425 p_attribute7 IN VARCHAR2,
426 p_attribute8 IN VARCHAR2,
427 p_attribute9 IN VARCHAR2,
428 p_attribute10 IN VARCHAR2,
429 p_attribute11 IN VARCHAR2,
430 p_attribute12 IN VARCHAR2,
431 p_attribute13 IN VARCHAR2,
432 p_attribute14 IN VARCHAR2,
433 p_attribute15 IN VARCHAR2)
434 RETURN BOOLEAN;
435
436 FUNCTION R_Line_Desc_Flex (p_context IN VARCHAR2,
437 p_attribute1 IN VARCHAR2,
438 p_attribute2 IN VARCHAR2,
439 p_attribute3 IN VARCHAR2,
440 p_attribute4 IN VARCHAR2,
441 p_attribute5 IN VARCHAR2,
442 p_attribute6 IN VARCHAR2,
443 p_attribute7 IN VARCHAR2,
444 p_attribute8 IN VARCHAR2,
445 p_attribute9 IN VARCHAR2,
446 p_attribute10 IN VARCHAR2,
447 p_attribute11 IN VARCHAR2,
448 p_attribute12 IN VARCHAR2,
449 p_attribute13 IN VARCHAR2,
450 p_attribute14 IN VARCHAR2,
451 p_attribute15 IN VARCHAR2)
452
453 RETURN BOOLEAN;
454
455
456 FUNCTION Price_Adj_Desc_Flex (p_context IN VARCHAR2,
457 p_attribute1 IN VARCHAR2,
458 p_attribute2 IN VARCHAR2,
459 p_attribute3 IN VARCHAR2,
460 p_attribute4 IN VARCHAR2,
461 p_attribute5 IN VARCHAR2,
465 p_attribute9 IN VARCHAR2,
462 p_attribute6 IN VARCHAR2,
463 p_attribute7 IN VARCHAR2,
464 p_attribute8 IN VARCHAR2,
466 p_attribute10 IN VARCHAR2,
467 p_attribute11 IN VARCHAR2,
468 p_attribute12 IN VARCHAR2,
469 p_attribute13 IN VARCHAR2,
470 p_attribute14 IN VARCHAR2,
471 p_attribute15 IN VARCHAR2)
472
473 RETURN BOOLEAN;
474 FUNCTION Sales_Credits_Desc_Flex (p_context IN VARCHAR2,
475 p_attribute1 IN VARCHAR2,
476 p_attribute2 IN VARCHAR2,
477 p_attribute3 IN VARCHAR2,
478 p_attribute4 IN VARCHAR2,
479 p_attribute5 IN VARCHAR2,
480 p_attribute6 IN VARCHAR2,
481 p_attribute7 IN VARCHAR2,
482 p_attribute8 IN VARCHAR2,
483 p_attribute9 IN VARCHAR2,
484 p_attribute10 IN VARCHAR2,
485 p_attribute11 IN VARCHAR2,
486 p_attribute12 IN VARCHAR2,
487 p_attribute13 IN VARCHAR2,
488 p_attribute14 IN VARCHAR2,
489 p_attribute15 IN VARCHAR2)
490
491 RETURN BOOLEAN;
492 FUNCTION Return_Reason(p_return_reason_code IN VARCHAR2)RETURN BOOLEAN;
493 FUNCTION Split_From_Line(p_split_from_line_id IN NUMBER)RETURN BOOLEAN;
494 FUNCTION Cust_Production_Seq_Num(p_cust_production_seq_num IN VARCHAR2)RETURN BOOLEAN;
495 FUNCTION Authorized_To_Ship(p_authorized_to_ship_flag IN VARCHAR2)RETURN BOOLEAN;
496 FUNCTION Veh_Cus_Item_Cum_key(p_veh_cus_item_cum_key_id IN NUMBER)RETURN BOOLEAN;
497 FUNCTION Arrival_Set(p_arrival_set_id IN NUMBER)RETURN BOOLEAN;
498 FUNCTION Ship_Set(p_ship_set_id IN NUMBER)RETURN BOOLEAN;
499 FUNCTION Over_Ship_Reason(p_over_ship_reason_code IN VARCHAR2)RETURN BOOLEAN;
500 FUNCTION Over_Ship_Resolved(p_over_ship_resolved_flag IN VARCHAR2)RETURN BOOLEAN;
501 FUNCTION Payment_Type(p_payment_type_code IN VARCHAR2)RETURN BOOLEAN;
502 FUNCTION Payment_Amount(p_payment_amount IN NUMBER)RETURN BOOLEAN;
503 FUNCTION Check_Number(p_check_number IN VARCHAR2)RETURN BOOLEAN;
504 FUNCTION Credit_Card(p_credit_card_code IN VARCHAR2)RETURN BOOLEAN;
505 FUNCTION Credit_Card_Holder_Name(p_credit_card_holder_name IN VARCHAR2)RETURN BOOLEAN;
506 FUNCTION Credit_Card_Number(p_credit_card_number IN VARCHAR2)RETURN BOOLEAN;
507 FUNCTION Credit_Card_Expiration_Date(p_credit_card_expiration_date IN DATE)RETURN BOOLEAN;
508 FUNCTION Credit_Card_Approval_Date(p_credit_card_approval_date IN DATE)RETURN BOOLEAN;
509 FUNCTION Credit_Card_Approval(p_credit_card_approval_code IN VARCHAR2)RETURN BOOLEAN;
510 FUNCTION Invoiced_Quantity(p_invoiced_quantity IN NUMBER)RETURN BOOLEAN;
511 FUNCTION Service_Txn_Reason(p_service_txn_reason IN VARCHAR2) RETURN BOOLEAN;
512 FUNCTION Service_Txn_Comments(p_service_txn_comments IN VARCHAR2) RETURN BOOLEAN;
513 FUNCTION Service_Duration(p_service_duration IN NUMBER) RETURN BOOLEAN;
514 FUNCTION Service_Period(p_service_period IN VARCHAR2) RETURN BOOLEAN;
515 FUNCTION Service_Start_Date(p_service_start_date IN DATE) RETURN BOOLEAN;
516 FUNCTION Service_End_Date(p_service_end_date IN DATE) RETURN BOOLEAN;
517 FUNCTION Service_Coterminate(p_service_coterminate_flag IN VARCHAR2) RETURN BOOLEAN;
518 FUNCTION Unit_List_Percent(p_unit_list_percent IN NUMBER) RETURN BOOLEAN;
519 FUNCTION Unit_Selling_Percent(p_unit_selling_percent IN NUMBER) RETURN BOOLEAN;
520 FUNCTION Unit_Percent_Base_Price(p_unit_percent_base_price IN NUMBER) RETURN BOOLEAN;
521 FUNCTION Service_Number(p_service_number IN NUMBER) RETURN BOOLEAN;
522 FUNCTION Service_Reference_Type(p_service_reference_type_code IN VARCHAR2) RETURN BOOLEAN;
523 FUNCTION Service_Reference_Line(p_service_reference_line_id IN NUMBER) RETURN BOOLEAN;
524 FUNCTION Service_Reference_System(p_service_reference_system_id IN NUMBER) RETURN BOOLEAN;
525 /* For new attributes in OE_PRICE_ADJUSTMENTS */
526 FUNCTION Split_action(p_split_action_code IN VARCHAR2) RETURN BOOLEAN;
527 FUNCTION Marketing_Source_Code(p_marketing_source_code_id IN NUMBER) RETURN BOOLEAN;
528 FUNCTION CHARGE_TYPE_CODE(p_charge_type_code IN VARCHAR2)RETURN BOOLEAN;
529 FUNCTION CHARGE_SUBTYPE_CODE(p_charge_subtype_code IN VARCHAR2)RETURN BOOLEAN;
530 FUNCTION COST_ID(p_cost_id IN NUMBER)RETURN BOOLEAN;
531 FUNCTION Commitment(p_commitment_id IN NUMBER) RETURN BOOLEAN;
532 FUNCTION CREDIT_OR_CHARGE_FLAG(p_credit_or_charge_flag IN VARCHAR2)RETURN BOOLEAN;
533 FUNCTION INCLUDE_ON_RETURNS_FLAG(p_include_on_returns_flag IN VARCHAR2)RETURN BOOLEAN;
534 FUNCTION IS_AUDIT_REASON_RQD RETURN BOOLEAN;
535 FUNCTION IS_AUDIT_HISTORY_RQD RETURN BOOLEAN;
536 FUNCTION Sales_Channel(p_sales_channel_code IN VARCHAR2) RETURN BOOLEAN;
537 FUNCTION Customer_Location(p_sold_to_site_use_id IN NUMBER)RETURN BOOLEAN;
538 -- FUNCTION Sublot_Number(p_sublot_number IN VARCHAR2)RETURN BOOLEAN; -- INVCONV
539 FUNCTION Quantity2(p_quantity2 IN NUMBER)RETURN BOOLEAN; -- OPM 3322359
540
541
542
543 -- INVCONV for OPM inventory convergence
544 FUNCTION Fulfilled_Quantity2(p_fulfilled_quantity2 IN NUMBER)RETURN BOOLEAN;
545 FUNCTION Shipping_Quantity2(p_shipping_quantity2 IN NUMBER)RETURN BOOLEAN;
546 FUNCTION Shipped_Quantity2(p_shipped_quantity2 IN NUMBER)RETURN BOOLEAN;
547 FUNCTION Shipping_Quantity_Uom2(p_shipping_quantity_uom2 IN VARCHAR2)RETURN BOOLEAN;
548
549 END OE_CNCL_Validate;
[Home] [Help]