1 PACKAGE OE_Validate AS
2 /* $Header: OEXSVATS.pls 120.1 2005/06/14 10:34:35 appldev $ */
3
4 -- Procedure Get_Attr_Tbl;
5 --
6 -- Used by generator to avoid overriding or duplicating existing
7 -- validation functions.
8 --
9 -- DO NOT MODIFY
10
11 PROCEDURE Get_Attr_Tbl;
12
13 -- Prototypes for validate functions.
14
15 -- START GEN validate
16
17 -- Generator will append new prototypes before end generate comment.
18
19 -- OPM 02/JUN/00 Add functions to support process features
20 -- (ordered_quantity2,ordered_quantity_uom2,preferred_grade)
21 -- =======================================================================
22
23 -- For bug 2511313
24 -- Global Variables to store the default values once
25 -- a call is made to FND_FLEX_DESCVAL.Validate_Desccols
26
27 g_context VARCHAR2(240);
28 g_attribute1 VARCHAR2(240);
29 g_attribute2 VARCHAR2(240);
30 g_attribute3 VARCHAR2(240);
31 g_attribute4 VARCHAR2(240);
32 g_attribute5 VARCHAR2(240);
33 g_attribute6 VARCHAR2(240);
34 g_attribute7 VARCHAR2(240);
35 g_attribute8 VARCHAR2(240);
36 g_attribute9 VARCHAR2(240);
37 g_attribute10 VARCHAR2(240);
38 g_attribute11 VARCHAR2(240);
39 g_attribute12 VARCHAR2(240);
40 g_attribute13 VARCHAR2(240);
41 g_attribute14 VARCHAR2(240);
42 g_attribute15 VARCHAR2(240);
43 g_attribute16 VARCHAR2(240);
44 g_attribute17 VARCHAR2(240);
45 g_attribute18 VARCHAR2(240);
46 g_attribute19 VARCHAR2(240);
47 g_attribute20 VARCHAR2(240);
48 g_attribute21 VARCHAR2(240);
49 g_attribute22 VARCHAR2(240);
50 g_attribute23 VARCHAR2(240);
51 g_attribute24 VARCHAR2(240);
52 g_attribute25 VARCHAR2(240);
53 g_attribute26 VARCHAR2(240);
54 g_attribute27 VARCHAR2(240);
55 g_attribute28 VARCHAR2(240);
56 g_attribute29 VARCHAR2(240);
57 g_attribute30 VARCHAR2(240);
58 g_attribute31 VARCHAR2(240);
59 g_attribute32 VARCHAR2(240);
60 g_attribute33 VARCHAR2(240);
61 g_attribute34 VARCHAR2(240);
62 g_attribute35 VARCHAR2(240);
63
64 -- Global Variables to hold the DFF segment names
65
66 g_context_name VARCHAR2(240);
67 g_attribute1_name VARCHAR2(240);
68 g_attribute2_name VARCHAR2(240);
69 g_attribute3_name VARCHAR2(240);
70 g_attribute4_name VARCHAR2(240);
71 g_attribute5_name VARCHAR2(240);
72 g_attribute6_name VARCHAR2(240);
73 g_attribute7_name VARCHAR2(240);
74 g_attribute8_name VARCHAR2(240);
75 g_attribute9_name VARCHAR2(240);
76 g_attribute10_name VARCHAR2(240);
77 g_attribute11_name VARCHAR2(240);
78 g_attribute12_name VARCHAR2(240);
79 g_attribute13_name VARCHAR2(240);
80 g_attribute14_name VARCHAR2(240);
81 g_attribute15_name VARCHAR2(240);
82 g_attribute16_name VARCHAR2(240);
83 g_attribute17_name VARCHAR2(240);
84 g_attribute18_name VARCHAR2(240);
85 g_attribute19_name VARCHAR2(240);
86 g_attribute20_name VARCHAR2(240);
87 g_attribute21_name VARCHAR2(240);
88 g_attribute22_name VARCHAR2(240);
89 g_attribute23_name VARCHAR2(240);
90 g_attribute24_name VARCHAR2(240);
91 g_attribute25_name VARCHAR2(240);
92 g_attribute26_name VARCHAR2(240);
93 g_attribute27_name VARCHAR2(240);
94 g_attribute28_name VARCHAR2(240);
95 g_attribute29_name VARCHAR2(240);
96 g_attribute30_name VARCHAR2(240);
97 g_attribute31_name VARCHAR2(240);
98 g_attribute32_name VARCHAR2(240);
99 g_attribute33_name VARCHAR2(240);
100 g_attribute34_name VARCHAR2(240);
101 g_attribute35_name VARCHAR2(240);
102
103
104
105 FUNCTION Accounting_Rule(p_accounting_rule_id IN NUMBER)RETURN BOOLEAN;
106 FUNCTION Accounting_Rule_Duration(p_accounting_rule_duration IN NUMBER)RETURN BOOLEAN;
107 FUNCTION Actual_Arrival_Date(p_actual_arrival_date IN DATE)RETURN BOOLEAN;
108 FUNCTION Actual_Shipment_Date(p_actual_shipment_date IN DATE)RETURN BOOLEAN;
109 FUNCTION Agreement(p_agreement_id IN NUMBER)RETURN BOOLEAN;
110 FUNCTION Ato_Line(p_ato_line_id IN NUMBER)RETURN BOOLEAN;
111 FUNCTION Auto_selected_Quantity(p_auto_selected_quantity IN NUMBER)RETURN BOOLEAN;
112 FUNCTION Blanket_Number(p_blanket_number IN NUMBER)RETURN BOOLEAN;
113 FUNCTION Booked(p_booked_flag IN VARCHAR2)RETURN BOOLEAN;
114 FUNCTION Cancelled(p_cancelled_flag IN VARCHAR2)RETURN BOOLEAN;
115 FUNCTION Cancelled_Quantity(p_cancelled_quantity IN NUMBER)RETURN BOOLEAN;
116 FUNCTION Component(p_component_code IN VARCHAR2)RETURN BOOLEAN;
117 FUNCTION Component_Number(p_component_number IN NUMBER)RETURN BOOLEAN;
118 FUNCTION Component_Sequence(p_component_sequence_id IN NUMBER)RETURN BOOLEAN;
119 FUNCTION Config_Header(p_config_header_id IN NUMBER)RETURN BOOLEAN;
120 FUNCTION Config_Rev_Nbr(p_config_rev_nbr IN NUMBER)RETURN BOOLEAN;
121 FUNCTION Config_Display_Sequence(p_config_display_sequence IN NUMBER)RETURN BOOLEAN;
122 FUNCTION Configuration(p_configuration_id IN NUMBER)RETURN BOOLEAN;
123 FUNCTION Conversion_Rate(p_conversion_rate IN NUMBER)RETURN BOOLEAN;
124 FUNCTION Conversion_Rate_Date ( p_conversion_rate_date IN DATE ) RETURN BOOLEAN;
125 FUNCTION Conversion_Type(p_conversion_type_code IN VARCHAR2)RETURN BOOLEAN;
126 FUNCTION CUSTOMER_PREFERENCE_SET(p_CUSTOMER_PREFERENCE_SET_CODE IN VARCHAR2)RETURN BOOLEAN;
127 FUNCTION Created_By(p_created_by IN NUMBER)RETURN BOOLEAN;
128 FUNCTION Creation_Date(p_creation_date IN DATE)RETURN BOOLEAN;
129 FUNCTION Credit_Invoice_Line(p_credit_invoice_line_id IN NUMBER) RETURN BOOLEAN;
130 FUNCTION Cust_Dock(p_cust_dock_code IN VARCHAR2)RETURN BOOLEAN;
131 FUNCTION Cust_Job(p_cust_job IN VARCHAR2)RETURN BOOLEAN;
132 FUNCTION Cust_Model_Serial_Number(p_cust_model_serial_number IN VARCHAR2)RETURN BOOLEAN;
133 FUNCTION Cust_Po_Number(p_cust_po_number IN VARCHAR2)RETURN BOOLEAN;
134 FUNCTION Cust_Production_Line(p_cust_production_line IN VARCHAR2)RETURN BOOLEAN;
135 FUNCTION Customer_Dock(p_customer_dock_code IN VARCHAR2)RETURN BOOLEAN;
136 FUNCTION Customer_Job(p_customer_job IN VARCHAR2)RETURN BOOLEAN;
137 FUNCTION Customer_Production_Line(p_customer_production_line IN VARCHAR2)RETURN BOOLEAN;
138 FUNCTION Customer_Trx_Line(p_customer_trx_line_id IN NUMBER)RETURN BOOLEAN;
139 FUNCTION Date_And_Time_Promised(p_date_and_time_promised IN DATE)RETURN BOOLEAN;
140 FUNCTION Date_And_Time_Requested(p_date_and_time_requested IN DATE)RETURN BOOLEAN;
141 FUNCTION Date_And_Time_Scheduled(p_date_and_time_scheduled IN DATE)RETURN BOOLEAN;
142 FUNCTION Date_Ordered(p_date_ordered IN DATE)RETURN BOOLEAN;
143 FUNCTION Date_Requested(p_date_requested IN DATE)RETURN BOOLEAN;
144 FUNCTION Deliver_To_Contact(p_deliver_to_contact_id IN NUMBER)RETURN BOOLEAN;
145 FUNCTION Deliver_To_Org(p_deliver_to_org_id IN NUMBER)RETURN BOOLEAN;
146 FUNCTION Delivery_Lead_Time(p_delivery_lead_time IN NUMBER)RETURN BOOLEAN;
147 FUNCTION Demand_Bucket_Type(p_demand_bucket_type IN VARCHAR2)RETURN BOOLEAN;
148 FUNCTION Demand_Class(p_demand_class_code IN VARCHAR2)RETURN BOOLEAN;
149 FUNCTION Demand_Stream(p_demand_stream_id IN NUMBER)RETURN BOOLEAN;
150 FUNCTION Dep_Plan_Required(p_dep_plan_required_flag IN VARCHAR2)RETURN BOOLEAN;
151 FUNCTION Desc_Flex ( p_flex_name IN VARCHAR2 )RETURN BOOLEAN;
152 FUNCTION Description(p_description IN VARCHAR2)RETURN BOOLEAN;
153 FUNCTION Dw_Update_Advice(p_dw_update_advice_flag IN VARCHAR2)RETURN BOOLEAN;
154 FUNCTION Earliest_Acceptable_Date(p_earliest_acceptable_date IN DATE)RETURN BOOLEAN;
155 FUNCTION Earliest_Schedule_Limit(p_earliest_schedule_limit IN NUMBER)RETURN BOOLEAN;
156 FUNCTION End_Date_Active(p_end_date_active IN DATE)RETURN BOOLEAN;
157 FUNCTION End_Item_Unit_Number(p_end_item_unit_number IN VARCHAR2)RETURN BOOLEAN;
158 FUNCTION Expiration_Date(p_expiration_date IN DATE)RETURN BOOLEAN;
159 FUNCTION Explosion_Date(p_explosion_date IN DATE)RETURN BOOLEAN;
160 FUNCTION First_Ack(p_first_ack_code IN VARCHAR2)RETURN BOOLEAN;
161 FUNCTION First_Ack_Date(p_first_ack_date IN DATE)RETURN BOOLEAN;
162 FUNCTION Fob_Point(p_fob_point_code IN VARCHAR2)RETURN BOOLEAN;
163 FUNCTION Freight_Carrier(p_freight_carrier_code IN VARCHAR2)RETURN BOOLEAN;
164 FUNCTION Freight_Terms(p_freight_terms_code IN VARCHAR2)RETURN BOOLEAN;
165 FUNCTION Fulfilled_Quantity(p_fulfilled_quantity IN NUMBER)RETURN BOOLEAN;
166 FUNCTION Fulfilled(p_fulfilled_flag IN VARCHAR2)RETURN BOOLEAN;
167 FUNCTION fulfillment_method(p_fulfillment_method_code IN VARCHAR2)RETURN BOOLEAN;
168 FUNCTION fulfillment_date(p_fulfillment_date IN DATE)RETURN BOOLEAN;
169 FUNCTION Global_Attribute1(p_global_attribute1 IN VARCHAR2)RETURN BOOLEAN;
170
171 FUNCTION Calculate_Price_Flag(p_calculate_price_flag IN VARCHAR2)RETURN BOOLEAN;
172
173 FUNCTION Header(p_header_id IN NUMBER)RETURN BOOLEAN;
174 FUNCTION Inventory_Item(p_inventory_item_id IN NUMBER)RETURN BOOLEAN;
175 FUNCTION Internal_Item(p_internal_item_id IN NUMBER)RETURN BOOLEAN;
176 FUNCTION Cust_Item_Setting(p_cust_item_setting_id IN NUMBER)RETURN BOOLEAN;
177 FUNCTION Invoice_Interface_Status(p_invoice_interface_status IN VARCHAR2)RETURN BOOLEAN;
178 FUNCTION Invoice_To_Contact(p_invoice_to_contact_id IN NUMBER)RETURN BOOLEAN;
179 FUNCTION Invoice_To_Org(p_invoice_to_org_id IN NUMBER)RETURN BOOLEAN;
180 FUNCTION Invoicing_Rule(p_invoicing_rule_id IN NUMBER)RETURN BOOLEAN;
181 FUNCTION Ordered_Item_Id(p_ordered_item_id IN NUMBER)RETURN BOOLEAN;
182 FUNCTION Item_Identifier_Type(p_item_identifier_type IN VARCHAR2)RETURN BOOLEAN;
183 FUNCTION Ordered_Item(p_ordered_item IN VARCHAR2)RETURN BOOLEAN;
184 FUNCTION Item_Revision(p_item_revision IN VARCHAR2)RETURN BOOLEAN;
185 FUNCTION Item_Type(p_item_type_code IN VARCHAR2)RETURN BOOLEAN;
186 FUNCTION Last_Ack(p_last_ack_code IN VARCHAR2)RETURN BOOLEAN;
187 FUNCTION Last_Ack_Date(p_last_ack_date IN DATE)RETURN BOOLEAN;
188 FUNCTION Last_Update_Date(p_last_update_date IN DATE)RETURN BOOLEAN;
189 FUNCTION Last_Update_Login(p_last_update_login IN NUMBER)RETURN BOOLEAN;
190 FUNCTION Last_Updated_By(p_last_updated_by IN NUMBER)RETURN BOOLEAN;
191 FUNCTION Latest_Acceptable_Date(p_latest_acceptable_date IN DATE)RETURN BOOLEAN;
192 FUNCTION Latest_Schedule_Limit(p_latest_schedule_limit IN NUMBER)RETURN BOOLEAN;
193 FUNCTION Line(p_line_id IN NUMBER)RETURN BOOLEAN;
194 FUNCTION Line_Category(p_line_category_code IN VARCHAR2)RETURN BOOLEAN;
195 FUNCTION Line_Category_Code(line_category_code IN VARCHAR2) RETURN BOOLEAN;
196 FUNCTION Line_Number(p_line_number IN NUMBER)RETURN BOOLEAN;
197 FUNCTION Line_Type(p_line_type_id IN NUMBER)RETURN BOOLEAN;
198 FUNCTION Link_To_Line(p_link_to_line_id IN NUMBER)RETURN BOOLEAN;
199 FUNCTION Model_Group_Number(p_model_group_number IN NUMBER)RETURN BOOLEAN;
200 FUNCTION Mfg_Component_Sequence(p_mfg_component_sequence_id IN NUMBER)RETURN BOOLEAN;
201 FUNCTION Name(p_name IN VARCHAR2)RETURN BOOLEAN;
202 FUNCTION Oe_Item_Type(p_oe_item_type IN VARCHAR2)RETURN BOOLEAN;
203 FUNCTION Open(p_open_flag IN VARCHAR2)RETURN BOOLEAN;
204 FUNCTION Option_Flag(p_option_flag IN VARCHAR2)RETURN BOOLEAN;
205 FUNCTION Option_Number(p_option_number IN NUMBER)RETURN BOOLEAN;
206 FUNCTION Order_Number(p_order_number IN NUMBER)
207 RETURN BOOLEAN;
208 FUNCTION Order_Quantity_Uom(p_order_quantity_uom IN VARCHAR2)RETURN BOOLEAN;
209 FUNCTION Ordered_Quantity_Uom2(p_ordered_quantity_uom2 IN VARCHAR2)RETURN BOOLEAN; -- OPM
210 FUNCTION Order_Source(p_order_source_id IN NUMBER)RETURN BOOLEAN;
211 FUNCTION Order_Type(p_order_type_id IN NUMBER)RETURN BOOLEAN;
212 FUNCTION Ordered_Date(p_ordered_date IN DATE)RETURN BOOLEAN;
213 FUNCTION Order_Date_Type_Code(p_order_date_type_code IN VARCHAR2)RETURN BOOLEAN;
214 FUNCTION Ordered_Quantity(p_ordered_quantity IN NUMBER)RETURN BOOLEAN;
215 FUNCTION Ordered_Quantity2(p_ordered_quantity2 IN NUMBER)RETURN BOOLEAN; -- OPM
216 FUNCTION Org(p_org_id IN NUMBER)RETURN BOOLEAN;
217 FUNCTION Orig_Sys_Document_Ref(p_orig_sys_document_ref IN VARCHAR2)RETURN BOOLEAN;
218 FUNCTION Orig_Sys_Line_Ref(p_orig_sys_line_ref IN VARCHAR2)RETURN BOOLEAN;
219 FUNCTION Partial_Shipments_Allowed(p_partial_shipments_allowed IN VARCHAR2)RETURN BOOLEAN;
220 FUNCTION Payment_Term(p_payment_term_id IN NUMBER)RETURN BOOLEAN;
221 FUNCTION Planning_Priority(p_planning_priority IN NUMBER)RETURN BOOLEAN;
222 FUNCTION Percent(p_percent IN NUMBER)RETURN BOOLEAN;
223 FUNCTION Planning_Prod_Seq_No(p_planning_prod_seq_no IN NUMBER)RETURN BOOLEAN;
224 FUNCTION Preferred_Grade(p_preferred_grade IN VARCHAR2)RETURN BOOLEAN; -- OPM
225 FUNCTION Price_List(p_price_list_id IN NUMBER)RETURN BOOLEAN;
226 FUNCTION Price_Request_Code(p_price_request_code IN VARCHAR2)RETURN BOOLEAN; -- PROMOTIONS SEP/01
227 FUNCTION Pricing_Date(p_pricing_date IN DATE)RETURN BOOLEAN;
228 FUNCTION Pricing_Quantity(p_pricing_quantity IN NUMBER)RETURN BOOLEAN;
229 FUNCTION Pricing_Quantity_Uom(p_pricing_quantity_uom IN VARCHAR2)RETURN BOOLEAN;
230 FUNCTION Program(p_program_id IN NUMBER)RETURN BOOLEAN;
231 FUNCTION Program_Application(p_program_application_id IN NUMBER)RETURN BOOLEAN;
232 FUNCTION Program_Update_Date(p_program_update_date IN DATE)RETURN BOOLEAN;
233 FUNCTION Project(p_project_id IN NUMBER)RETURN BOOLEAN;
234 FUNCTION Promise_Date(p_promise_date IN DATE)RETURN BOOLEAN;
235 FUNCTION Re_Source(p_re_source_flag IN VARCHAR2)RETURN BOOLEAN;
236 FUNCTION Quantity_Cancelled(p_quantity_cancelled IN NUMBER)RETURN BOOLEAN;
237 FUNCTION Quantity_Fulfilled(p_quantity_fulfilled IN NUMBER)RETURN BOOLEAN;
238 FUNCTION Quantity_Ordered(p_quantity_ordered IN NUMBER)RETURN BOOLEAN;
239 FUNCTION Quantity_Shipped(p_quantity_shipped IN NUMBER)RETURN BOOLEAN;
240 FUNCTION RMA_ATTRIBUTE1(rma_attribute1 IN VARCHAR2) RETURN BOOLEAN;
241 FUNCTION RMA_ATTRIBUTE10(rma_attribute10 IN VARCHAR2) RETURN BOOLEAN;
242 FUNCTION RMA_ATTRIBUTE2(rma_attribute2 IN VARCHAR2) RETURN BOOLEAN;
243 FUNCTION RMA_ATTRIBUTE3(rma_attribute3 IN VARCHAR2) RETURN BOOLEAN;
244 FUNCTION RMA_ATTRIBUTE4(rma_attribute4 IN VARCHAR2) RETURN BOOLEAN;
245 FUNCTION RMA_ATTRIBUTE5(rma_attribute5 IN VARCHAR2) RETURN BOOLEAN;
246 FUNCTION RMA_ATTRIBUTE6(rma_attribute6 IN VARCHAR2) RETURN BOOLEAN;
247 FUNCTION RMA_ATTRIBUTE7(rma_attribute7 IN VARCHAR2) RETURN BOOLEAN;
248 FUNCTION RMA_ATTRIBUTE8(rma_attribute8 IN VARCHAR2) RETURN BOOLEAN;
249 FUNCTION RMA_ATTRIBUTE9(rma_attribute9 IN VARCHAR2) RETURN BOOLEAN;
250 FUNCTION RMA_CONTEXT(rma_context IN VARCHAR2) RETURN BOOLEAN;
251 FUNCTION Reference_Cust_Trx_Line_Id(reference_cust_trx_line_id IN NUMBER) RETURN BOOLEAN;
252 FUNCTION Reference_Header(p_reference_header_id IN NUMBER)RETURN BOOLEAN;
253 FUNCTION Reference_Line(p_reference_line_id IN NUMBER)RETURN BOOLEAN;
254 FUNCTION Reference_Type(p_reference_type IN VARCHAR2)RETURN BOOLEAN;
255 FUNCTION Request(p_request_id IN NUMBER)RETURN BOOLEAN;
256 FUNCTION Request_Date(p_request_date IN DATE)RETURN BOOLEAN;
257 FUNCTION Reserved_Quantity(p_reserved_quantity IN NUMBER)RETURN BOOLEAN;
261 FUNCTION Salesrep(p_salesrep_id IN NUMBER)RETURN BOOLEAN;
258 FUNCTION Revision(p_revision IN VARCHAR2)RETURN BOOLEAN;
259 FUNCTION Rla_Schedule_Type(p_rla_schedule_type_code IN VARCHAR2)RETURN BOOLEAN;
260 FUNCTION Sales_Credit(p_sales_credit_id IN NUMBER)RETURN BOOLEAN;
262 FUNCTION Sales_credit_type(p_sales_credit_type_id IN NUMBER)RETURN BOOLEAN;
263 FUNCTION Schedule_Arrival_Date(p_schedule_arrival_date IN DATE)RETURN BOOLEAN;
264 FUNCTION Schedule_Ship_Date(p_schedule_ship_date IN DATE)RETURN BOOLEAN;
265 FUNCTION Late_Demand_Penalty_Factor(p_late_demand_penalty_factor IN NUMBER)RETURN BOOLEAN;
266 FUNCTION Schedule_Status(p_schedule_status_code IN VARCHAR2)RETURN BOOLEAN;
267 FUNCTION Schedule_Item_Detail(p_schedule_item_detail_id IN NUMBER)RETURN BOOLEAN;
268 FUNCTION Sequence_Starting_Point(p_sequence_starting_point IN NUMBER)RETURN BOOLEAN;
269 FUNCTION Ship_From_Org(p_ship_from_org_id IN NUMBER)RETURN BOOLEAN;
270 FUNCTION Inventory_Org(p_inventory_org_id IN NUMBER)RETURN BOOLEAN;
271 FUNCTION Ship_Model_Complete(p_ship_model_complete_flag IN VARCHAR2)RETURN BOOLEAN;
272 FUNCTION Ship_To_Contact(p_ship_to_contact_id IN NUMBER)RETURN BOOLEAN;
273 FUNCTION Ship_To_Org(p_ship_to_org_id IN NUMBER)RETURN BOOLEAN;
274 FUNCTION Site_Use(p_site_use_id IN NUMBER)RETURN BOOLEAN;
275 FUNCTION Ship_Tolerance_Above(p_ship_tolerance_above IN NUMBER)RETURN BOOLEAN;
276 FUNCTION Ship_Tolerance_Below(p_ship_tolerance_below IN NUMBER)RETURN BOOLEAN;
277 FUNCTION Shippable(p_shippable_flag IN VARCHAR2)RETURN BOOLEAN;
278 FUNCTION Shipping_Interfaced(p_shipping_interfaced_flag IN VARCHAR2)RETURN BOOLEAN;
279 FUNCTION Shipping_Instructions(p_shipping_instructions IN VARCHAR2)RETURN BOOLEAN;
280 FUNCTION Packing_Instructions(p_packing_instructions IN VARCHAR2)RETURN BOOLEAN;
281 FUNCTION Under_Shipment_Tolerance(p_under_shipment_tolerance IN NUMBER)RETURN BOOLEAN;
282 FUNCTION Over_Shipment_Tolerance(p_over_shipment_tolerance IN NUMBER)RETURN BOOLEAN;
283 FUNCTION Under_Return_Tolerance(p_under_return_tolerance IN NUMBER)RETURN BOOLEAN;
284 FUNCTION Over_Return_Tolerance(p_over_return_tolerance IN NUMBER)RETURN BOOLEAN;
285 FUNCTION Shipment_Number(p_shipment_number IN NUMBER)RETURN BOOLEAN;
286 FUNCTION Shipment_Priority(p_shipment_priority_code IN VARCHAR2)RETURN BOOLEAN;
287 FUNCTION Shipped_Quantity(p_shipped_quantity IN NUMBER)RETURN BOOLEAN;
288 FUNCTION Shipping_Method(p_shipping_method_code IN VARCHAR2)RETURN BOOLEAN;
289 FUNCTION Shipping_Quantity(p_shipping_quantity IN NUMBER)RETURN BOOLEAN;
290 FUNCTION Shipping_Quantity_Uom(p_shipping_quantity_uom IN VARCHAR2)RETURN BOOLEAN;
291 FUNCTION Sold_To_Contact(p_sold_to_contact_id IN NUMBER)RETURN BOOLEAN;
292 FUNCTION Sold_To_Org(p_sold_to_org_id IN NUMBER)RETURN BOOLEAN;
293 FUNCTION Sold_To_Phone(p_sold_to_phone_id IN NUMBER)RETURN BOOLEAN;
294 FUNCTION Subinventory(p_subinventory IN VARCHAR2)RETURN BOOLEAN;
295 FUNCTION Customer(p_customer_id IN NUMBER)RETURN BOOLEAN;
296 FUNCTION Intermed_Ship_To_Contact(p_intermed_ship_to_contact_id IN NUMBER)RETURN BOOLEAN;
297 FUNCTION Intermed_Ship_To_Org(p_intermed_ship_to_org_id IN NUMBER)RETURN BOOLEAN;
298 FUNCTION Sort_Order(p_sort_order IN VARCHAR2)RETURN BOOLEAN;
299 FUNCTION Source_Document(p_source_document_id IN NUMBER)RETURN BOOLEAN;
300 FUNCTION Source_Document_Line(p_source_document_line_id IN NUMBER)RETURN BOOLEAN;
301 FUNCTION Source_Document_Type(p_source_document_type_id IN NUMBER)RETURN BOOLEAN;
302 FUNCTION Source_Type(p_source_type_code IN VARCHAR2)RETURN BOOLEAN;
303 FUNCTION Task(p_task_id IN NUMBER)RETURN BOOLEAN;
304 FUNCTION Tax(p_tax_code IN VARCHAR2)RETURN BOOLEAN;
305 FUNCTION Tax_Date(p_tax_date IN DATE)RETURN BOOLEAN;
306 FUNCTION Tax_Exempt(p_tax_exempt_flag IN VARCHAR2)RETURN BOOLEAN;
307 FUNCTION Tax_Exempt_Number(p_tax_exempt_number IN VARCHAR2)RETURN BOOLEAN;
308 FUNCTION Tax_Exempt_Reason(p_tax_exempt_reason_code IN VARCHAR2)RETURN BOOLEAN;
309 FUNCTION Tax_Point(p_tax_point_code IN VARCHAR2)RETURN BOOLEAN;
310 FUNCTION Tax_Rate(p_tax_rate IN NUMBER)RETURN BOOLEAN;
311 FUNCTION Tax_Value(p_tax_value IN NUMBER)RETURN BOOLEAN;
312 FUNCTION Top_Model_Line(p_top_model_line_id IN NUMBER)RETURN BOOLEAN;
313 FUNCTION Transactional_Curr(p_transactional_curr_code IN VARCHAR2)RETURN BOOLEAN;
314 FUNCTION Unit_List_Price(p_unit_list_price IN NUMBER)RETURN BOOLEAN;
315 FUNCTION Unit_List_Price_Per_Pqty(p_unit_list_price_per_pqty IN NUMBER)RETURN BOOLEAN;
316 FUNCTION Unit_Selling_Price(p_unit_selling_price IN NUMBER)RETURN BOOLEAN;
317 FUNCTION Unit_Selling_Price_per_pqty(p_unit_selling_price_per_pqty IN NUMBER)RETURN BOOLEAN;
318 FUNCTION Version_Number(p_version_number IN NUMBER)RETURN BOOLEAN;
319 FUNCTION Visible_Demand(p_visible_demand_flag IN VARCHAR2)RETURN BOOLEAN;
320 FUNCTION Wh_Update_Date(p_wh_update_date IN DATE)RETURN BOOLEAN;
321 Function SALES_CREDIT_PERCENT( p_percent IN Number) Return Boolean;
322
323 FUNCTION Applied_Flag(p_Applied_Flag IN VARCHAR2)RETURN BOOLEAN;
324 FUNCTION Automatic(p_automatic_flag IN VARCHAR2)RETURN BOOLEAN;
325 FUNCTION Change_Reason_Code(p_Change_Reason_Code IN VARCHAR2)RETURN BOOLEAN;
326 FUNCTION Change_Reason_Text(p_Change_Reason_Text IN VARCHAR2)RETURN BOOLEAN;
327 FUNCTION Discount(p_discount_id IN NUMBER)RETURN BOOLEAN;
328 FUNCTION Discount_Line(p_discount_line_id IN NUMBER)RETURN BOOLEAN;
329 FUNCTION List_Header_id(p_List_Header_id IN NUMBER)RETURN BOOLEAN;
330 FUNCTION List_Line_id(p_List_Line_id IN NUMBER)RETURN BOOLEAN;
331 FUNCTION List_Line_Type_code(p_List_Line_Type_code IN VARCHAR2)RETURN BOOLEAN;
332 FUNCTION Modified_From(p_Modified_From IN VARCHAR2)RETURN BOOLEAN;
333 FUNCTION Modified_To(p_Modified_To IN VARCHAR2)RETURN BOOLEAN;
334 FUNCTION Modifier_mechanism_type_code(p_Modifier_mechanism_type_code IN VARCHAR2)RETURN BOOLEAN;
335 FUNCTION Price_Adjustment(p_price_adjustment_id IN NUMBER)RETURN BOOLEAN;
336 FUNCTION Updated_Flag(p_Updated_Flag IN VARCHAR2)RETURN BOOLEAN;
340 FUNCTION Lot_Number(p_lot_number IN VARCHAR2)RETURN BOOLEAN;
337 FUNCTION Update_Allowed(p_Update_Allowed IN VARCHAR2)RETURN BOOLEAN;
338
339 FUNCTION From_Serial_Number(p_from_serial_number IN VARCHAR2)RETURN BOOLEAN;
341 --FUNCTION Sublot_Number(p_sublot_number IN VARCHAR2)RETURN BOOLEAN; --OPM 2380194 INVCONV
342 FUNCTION Lot_Serial(p_lot_serial_id IN NUMBER)RETURN BOOLEAN;
343 FUNCTION Quantity(p_quantity IN NUMBER)RETURN BOOLEAN;
344 FUNCTION Quantity2(p_quantity2 IN NUMBER)RETURN BOOLEAN; --OPM 2380194
345 FUNCTION To_Serial_Number(p_to_serial_number IN VARCHAR2)RETURN BOOLEAN;
346 FUNCTION Line_Set(p_line_set_id IN NUMBER) RETURN BOOLEAN;
347
348 FUNCTION Amount(p_amount IN NUMBER)RETURN BOOLEAN;
349 FUNCTION Appear_On_Ack(p_appear_on_ack_flag IN VARCHAR2)RETURN BOOLEAN;
350 FUNCTION Appear_On_Invoice(p_appear_on_invoice_flag IN VARCHAR2)RETURN BOOLEAN;
351 FUNCTION Charge(p_charge_id IN NUMBER)RETURN BOOLEAN;
352 FUNCTION Conversion_Date(p_conversion_date IN DATE)RETURN BOOLEAN;
353 FUNCTION Cost_Or_Charge(p_cost_or_charge_flag IN VARCHAR2)RETURN BOOLEAN;
354 FUNCTION Currency(p_currency_code IN VARCHAR2)RETURN BOOLEAN;
355 FUNCTION Departure(p_departure_id IN NUMBER)RETURN BOOLEAN;
356 FUNCTION Estimated(p_estimated_flag IN VARCHAR2)RETURN BOOLEAN;
357 FUNCTION Inc_In_Sales_Performance(p_inc_in_sales_performance IN VARCHAR2)RETURN BOOLEAN;
358 FUNCTION Invoiced(p_invoiced_flag IN VARCHAR2)RETURN BOOLEAN;
359 FUNCTION Lpn(p_lpn IN NUMBER)RETURN BOOLEAN;
360 FUNCTION Parent_Charge(p_parent_charge_id IN NUMBER)RETURN BOOLEAN;
361 FUNCTION Returnable(p_returnable_flag IN VARCHAR2)RETURN BOOLEAN;
362 FUNCTION Tax_Group(p_tax_group_code IN VARCHAR2)RETURN BOOLEAN;
363 FUNCTION Flow_Status(p_flow_status_code IN VARCHAR2)RETURN BOOLEAN;
364 FUNCTION Line_Flow_Status(p_flow_status_code IN VARCHAR2)RETURN BOOLEAN;
365 -- END GEN validate
366
367 -- Changes for Line Set Enhancements
368 FUNCTION Default_Fulfillment_Set (p_default_fulfillment_set IN VARCHAR2) RETURN BOOLEAN;
369 FUNCTION Fulfillment_Set_Name (p_fulfillment_set_name IN VARCHAR2) RETURN BOOLEAN;
370 FUNCTION Line_Set_Name (p_line_set_name IN VARCHAR2) RETURN BOOLEAN;
371
372 FUNCTION Header_desc_flex (p_context IN VARCHAR2,
373 p_attribute1 IN VARCHAR2,
374 p_attribute2 IN VARCHAR2,
375 p_attribute3 IN VARCHAR2,
376 p_attribute4 IN VARCHAR2,
377 p_attribute5 IN VARCHAR2,
378 p_attribute6 IN VARCHAR2,
379 p_attribute7 IN VARCHAR2,
380 p_attribute8 IN VARCHAR2,
381 p_attribute9 IN VARCHAR2,
382 p_attribute10 IN VARCHAR2,
383 p_attribute11 IN VARCHAR2,
384 p_attribute12 IN VARCHAR2,
385 p_attribute13 IN VARCHAR2,
386 p_attribute14 IN VARCHAR2,
387 p_attribute15 IN VARCHAR2,
388 p_attribute16 IN VARCHAR2,
389 p_attribute17 IN VARCHAR2,
390 p_attribute18 IN VARCHAR2,
391 p_attribute19 IN VARCHAR2,
392 p_attribute20 IN VARCHAR2,
393 p_document_type IN VARCHAR2 := 'ORDER')
394 RETURN BOOLEAN;
395 FUNCTION G_Header_desc_flex (p_context IN VARCHAR2,
396 p_attribute1 IN VARCHAR2,
397 p_attribute2 IN VARCHAR2,
398 p_attribute3 IN VARCHAR2,
399 p_attribute4 IN VARCHAR2,
400 p_attribute5 IN VARCHAR2,
401 p_attribute6 IN VARCHAR2,
402 p_attribute7 IN VARCHAR2,
403 p_attribute8 IN VARCHAR2,
404 p_attribute9 IN VARCHAR2,
405 p_attribute10 IN VARCHAR2,
406 p_attribute11 IN VARCHAR2,
407 p_attribute12 IN VARCHAR2,
408 p_attribute13 IN VARCHAR2,
409 p_attribute14 IN VARCHAR2,
410 p_attribute15 IN VARCHAR2,
411 p_attribute16 IN VARCHAR2,
412 p_attribute17 IN VARCHAR2,
413 p_attribute18 IN VARCHAR2,
414 p_attribute19 IN VARCHAR2,
415 p_attribute20 IN VARCHAR2)
416 RETURN BOOLEAN;
417
418 FUNCTION TP_Header_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 Line_Desc_Flex (p_context IN VARCHAR2,
437 p_attribute1 IN VARCHAR2,
438 p_attribute2 IN VARCHAR2,
442 p_attribute6 IN VARCHAR2,
439 p_attribute3 IN VARCHAR2,
440 p_attribute4 IN VARCHAR2,
441 p_attribute5 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 p_attribute16 IN VARCHAR2,
453 p_attribute17 IN VARCHAR2,
454 p_attribute18 IN VARCHAR2,
455 p_attribute19 IN VARCHAR2,
456 p_attribute20 IN VARCHAR2,
457 p_document_type IN VARCHAR2 := 'ORDER')
458
459 RETURN BOOLEAN;
460 FUNCTION G_Line_Desc_Flex (p_context IN VARCHAR2,
461 p_attribute1 IN VARCHAR2,
462 p_attribute2 IN VARCHAR2,
463 p_attribute3 IN VARCHAR2,
464 p_attribute4 IN VARCHAR2,
465 p_attribute5 IN VARCHAR2,
466 p_attribute6 IN VARCHAR2,
467 p_attribute7 IN VARCHAR2,
468 p_attribute8 IN VARCHAR2,
469 p_attribute9 IN VARCHAR2,
470 p_attribute10 IN VARCHAR2,
471 p_attribute11 IN VARCHAR2,
472 p_attribute12 IN VARCHAR2,
473 p_attribute13 IN VARCHAR2,
474 p_attribute14 IN VARCHAR2,
475 p_attribute15 IN VARCHAR2,
476 p_attribute16 IN VARCHAR2,
477 p_attribute17 IN VARCHAR2,
478 p_attribute18 IN VARCHAR2,
479 p_attribute19 IN VARCHAR2,
480 p_attribute20 IN VARCHAR2)
481 RETURN BOOLEAN;
482 FUNCTION P_Line_Desc_Flex (p_context IN VARCHAR2,
483 p_attribute1 IN VARCHAR2,
484 p_attribute2 IN VARCHAR2,
485 p_attribute3 IN VARCHAR2,
486 p_attribute4 IN VARCHAR2,
487 p_attribute5 IN VARCHAR2,
488 p_attribute6 IN VARCHAR2,
489 p_attribute7 IN VARCHAR2,
490 p_attribute8 IN VARCHAR2,
491 p_attribute9 IN VARCHAR2,
492 p_attribute10 IN VARCHAR2)
493 RETURN BOOLEAN ;
494 FUNCTION I_Line_Desc_Flex (p_context IN VARCHAR2,
495 p_attribute1 IN VARCHAR2,
496 p_attribute2 IN VARCHAR2,
497 p_attribute3 IN VARCHAR2,
498 p_attribute4 IN VARCHAR2,
499 p_attribute5 IN VARCHAR2,
500 p_attribute6 IN VARCHAR2,
501 p_attribute7 IN VARCHAR2,
502 p_attribute8 IN VARCHAR2,
503 p_attribute9 IN VARCHAR2,
504 p_attribute10 IN VARCHAR2,
505 p_attribute11 IN VARCHAR2,
506 p_attribute12 IN VARCHAR2,
507 p_attribute13 IN VARCHAR2,
508 p_attribute14 IN VARCHAR2,
509 p_attribute15 IN VARCHAR2,
510 p_attribute16 IN VARCHAR2,
511 p_attribute17 IN VARCHAR2,
512 p_attribute18 IN VARCHAR2,
513 p_attribute19 IN VARCHAR2,
514 p_attribute20 IN VARCHAR2,
515 p_attribute21 IN VARCHAR2,
516 p_attribute22 IN VARCHAR2,
517 p_attribute23 IN VARCHAR2,
518 p_attribute24 IN VARCHAR2,
519 p_attribute25 IN VARCHAR2,
520 p_attribute26 IN VARCHAR2,
521 p_attribute27 IN VARCHAR2,
522 p_attribute28 IN VARCHAR2,
523 p_attribute29 IN VARCHAR2,
524 p_attribute30 IN VARCHAR2)
525 RETURN BOOLEAN;
526
527 FUNCTION TP_Line_Desc_Flex (p_context IN VARCHAR2,
528 p_attribute1 IN VARCHAR2,
529 p_attribute2 IN VARCHAR2,
530 p_attribute3 IN VARCHAR2,
531 p_attribute4 IN VARCHAR2,
532 p_attribute5 IN VARCHAR2,
533 p_attribute6 IN VARCHAR2,
534 p_attribute7 IN VARCHAR2,
535 p_attribute8 IN VARCHAR2,
536 p_attribute9 IN VARCHAR2,
537 p_attribute10 IN VARCHAR2,
538 p_attribute11 IN VARCHAR2,
539 p_attribute12 IN VARCHAR2,
540 p_attribute13 IN VARCHAR2,
541 p_attribute14 IN VARCHAR2,
542 p_attribute15 IN VARCHAR2)
543 RETURN BOOLEAN;
544
545 FUNCTION R_Line_Desc_Flex (p_context IN VARCHAR2,
546 p_attribute1 IN VARCHAR2,
550 p_attribute5 IN VARCHAR2,
547 p_attribute2 IN VARCHAR2,
548 p_attribute3 IN VARCHAR2,
549 p_attribute4 IN VARCHAR2,
551 p_attribute6 IN VARCHAR2,
552 p_attribute7 IN VARCHAR2,
553 p_attribute8 IN VARCHAR2,
554 p_attribute9 IN VARCHAR2,
555 p_attribute10 IN VARCHAR2,
556 p_attribute11 IN VARCHAR2,
557 p_attribute12 IN VARCHAR2,
558 p_attribute13 IN VARCHAR2,
559 p_attribute14 IN VARCHAR2,
560 p_attribute15 IN VARCHAR2)
561
562 RETURN BOOLEAN;
563
564
565 FUNCTION Price_Adj_Desc_Flex (p_context IN VARCHAR2,
566 p_attribute1 IN VARCHAR2,
567 p_attribute2 IN VARCHAR2,
568 p_attribute3 IN VARCHAR2,
569 p_attribute4 IN VARCHAR2,
570 p_attribute5 IN VARCHAR2,
571 p_attribute6 IN VARCHAR2,
572 p_attribute7 IN VARCHAR2,
573 p_attribute8 IN VARCHAR2,
574 p_attribute9 IN VARCHAR2,
575 p_attribute10 IN VARCHAR2,
576 p_attribute11 IN VARCHAR2,
577 p_attribute12 IN VARCHAR2,
578 p_attribute13 IN VARCHAR2,
579 p_attribute14 IN VARCHAR2,
580 p_attribute15 IN VARCHAR2)
581
582 RETURN BOOLEAN;
583 FUNCTION Sales_Credits_Desc_Flex (p_context IN VARCHAR2,
584 p_attribute1 IN VARCHAR2,
585 p_attribute2 IN VARCHAR2,
586 p_attribute3 IN VARCHAR2,
587 p_attribute4 IN VARCHAR2,
588 p_attribute5 IN VARCHAR2,
589 p_attribute6 IN VARCHAR2,
590 p_attribute7 IN VARCHAR2,
591 p_attribute8 IN VARCHAR2,
592 p_attribute9 IN VARCHAR2,
593 p_attribute10 IN VARCHAR2,
594 p_attribute11 IN VARCHAR2,
595 p_attribute12 IN VARCHAR2,
596 p_attribute13 IN VARCHAR2,
597 p_attribute14 IN VARCHAR2,
598 p_attribute15 IN VARCHAR2)
599
600 RETURN BOOLEAN;
601 FUNCTION Return_Reason(p_return_reason_code IN VARCHAR2)RETURN BOOLEAN;
602 FUNCTION Split_From_Line(p_split_from_line_id IN NUMBER)RETURN BOOLEAN;
603 FUNCTION Cust_Production_Seq_Num(p_cust_production_seq_num IN VARCHAR2)RETURN BOOLEAN;
604 FUNCTION Authorized_To_Ship(p_authorized_to_ship_flag IN VARCHAR2)RETURN BOOLEAN;
605 FUNCTION Veh_Cus_Item_Cum_key(p_veh_cus_item_cum_key_id IN NUMBER)RETURN BOOLEAN;
606 FUNCTION Arrival_Set(p_arrival_set_id IN NUMBER)RETURN BOOLEAN;
607 FUNCTION Ship_Set(p_ship_set_id IN NUMBER)RETURN BOOLEAN;
608 FUNCTION Over_Ship_Reason(p_over_ship_reason_code IN VARCHAR2)RETURN BOOLEAN;
609 FUNCTION Over_Ship_Resolved(p_over_ship_resolved_flag IN VARCHAR2)RETURN BOOLEAN;
610 FUNCTION Payment_Type(p_payment_type_code IN VARCHAR2)RETURN BOOLEAN;
611 FUNCTION Payment_Amount(p_payment_amount IN NUMBER)RETURN BOOLEAN;
612 FUNCTION Check_Number(p_check_number IN VARCHAR2)RETURN BOOLEAN;
613 FUNCTION Credit_Card(p_credit_card_code IN VARCHAR2)RETURN BOOLEAN;
614 FUNCTION Credit_Card_Holder_Name(p_credit_card_holder_name IN VARCHAR2)RETURN BOOLEAN;
615 FUNCTION Credit_Card_Number(p_credit_card_number IN VARCHAR2)RETURN BOOLEAN;
616 FUNCTION Credit_Card_Expiration_Date(p_credit_card_expiration_date IN DATE)RETURN BOOLEAN;
617 FUNCTION Credit_Card_Approval_Date(p_credit_card_approval_date IN DATE)RETURN BOOLEAN;
618 FUNCTION Credit_Card_Approval(p_credit_card_approval_code IN VARCHAR2)RETURN BOOLEAN;
619 FUNCTION Invoiced_Quantity(p_invoiced_quantity IN NUMBER)RETURN BOOLEAN;
620 FUNCTION Service_Txn_Reason(p_service_txn_reason IN VARCHAR2) RETURN BOOLEAN;
621 FUNCTION Service_Txn_Comments(p_service_txn_comments IN VARCHAR2) RETURN BOOLEAN;
622 FUNCTION Service_Duration(p_service_duration IN NUMBER) RETURN BOOLEAN;
623 FUNCTION Service_Period(p_service_period IN VARCHAR2) RETURN BOOLEAN;
624 FUNCTION Service_Start_Date(p_service_start_date IN DATE) RETURN BOOLEAN;
625 FUNCTION Service_End_Date(p_service_end_date IN DATE) RETURN BOOLEAN;
626 FUNCTION Service_Coterminate(p_service_coterminate_flag IN VARCHAR2) RETURN BOOLEAN;
627 FUNCTION Unit_List_Percent(p_unit_list_percent IN NUMBER) RETURN BOOLEAN;
628 FUNCTION Unit_Selling_Percent(p_unit_selling_percent IN NUMBER) RETURN BOOLEAN;
629 FUNCTION Unit_Percent_Base_Price(p_unit_percent_base_price IN NUMBER) RETURN BOOLEAN;
630 FUNCTION Service_Number(p_service_number IN NUMBER) RETURN BOOLEAN;
631 FUNCTION Service_Reference_Type(p_service_reference_type_code IN VARCHAR2) RETURN BOOLEAN;
632 FUNCTION Service_Reference_Line(p_service_reference_line_id IN NUMBER) RETURN BOOLEAN;
633 FUNCTION Service_Reference_System(p_service_reference_system_id IN NUMBER) RETURN BOOLEAN;
634 /* For new attributes in OE_PRICE_ADJUSTMENTS */
635 FUNCTION Split_action(p_split_action_code IN VARCHAR2) RETURN BOOLEAN;
636 FUNCTION Marketing_Source_Code(p_marketing_source_code_id IN NUMBER) RETURN BOOLEAN;
637 FUNCTION CHARGE_TYPE_CODE(p_charge_type_code IN VARCHAR2)RETURN BOOLEAN;
638 FUNCTION CHARGE_SUBTYPE_CODE(p_charge_subtype_code IN VARCHAR2)RETURN BOOLEAN;
639 FUNCTION COST_ID(p_cost_id IN NUMBER)RETURN BOOLEAN;
640 FUNCTION Commitment(p_commitment_id IN NUMBER) RETURN BOOLEAN;
644 FUNCTION IS_AUDIT_HISTORY_RQD RETURN BOOLEAN;
641 FUNCTION CREDIT_OR_CHARGE_FLAG(p_credit_or_charge_flag IN VARCHAR2)RETURN BOOLEAN;
642 FUNCTION INCLUDE_ON_RETURNS_FLAG(p_include_on_returns_flag IN VARCHAR2)RETURN BOOLEAN;
643 FUNCTION IS_AUDIT_REASON_RQD RETURN BOOLEAN;
645 FUNCTION Sales_Channel(p_sales_channel_code IN VARCHAR2) RETURN BOOLEAN;
646 FUNCTION User_Item_Description(p_user_item_description IN VARCHAR2) RETURN BOOLEAN;
647 FUNCTION Item_Relationship_Type(p_item_relationship_type IN NUMBER) RETURN BOOLEAN;
648 PROCEDURE RESET_AUDIT_REASON_FLAGS;
649 FUNCTION Customer_Shipment_Number(p_customer_Shipment_number IN VARCHAR2) RETURN BOOLEAN;
650 FUNCTION Transaction_Phase(p_transaction_phase_code IN VARCHAR2) RETURN BOOLEAN;
651 FUNCTION User_Status(p_user_status_code IN VARCHAR2) RETURN BOOLEAN;
652 FUNCTION Customer_Location(p_sold_to_site_use_id IN NUMBER)RETURN BOOLEAN;
653 FUNCTION Minisite(p_minisite_id IN NUMBER)RETURN BOOLEAN;
654 FUNCTION IB_OWNER(p_ib_owner IN VARCHAR2)RETURN BOOLEAN;
655 FUNCTION IB_INSTALLED_AT_LOCATION(p_ib_installed_at_location IN VARCHAR2)RETURN BOOLEAN;
656 FUNCTION IB_CURRENT_LOCATION(p_ib_current_location IN VARCHAR2)RETURN BOOLEAN;
657 FUNCTION END_CUSTOMER(p_end_customer_id IN NUMBER)RETURN BOOLEAN;
658 FUNCTION END_CUSTOMER_CONTACT(p_end_customer_contact_id IN NUMBER)RETURN BOOLEAN;
659 FUNCTION END_CUSTOMER_SITE_USE(p_end_customer_site_use_id IN NUMBER)RETURN BOOLEAN;
660 FUNCTION SUPPLIER_SIGNATURE(p_supplier_signature IN VARCHAR2)RETURN BOOLEAN;
661 FUNCTION SUPPLIER_SIGNATURE_DATE(p_supplier_signature_date IN DATE)RETURN BOOLEAN;
662 FUNCTION CUSTOMER_SIGNATURE(p_customer_signature IN VARCHAR2)RETURN BOOLEAN;
663 FUNCTION CUSTOMER_SIGNATURE_DATE(p_customer_signature_date IN DATE)RETURN BOOLEAN;
664 FUNCTION CONTRACT_TEMPLATE_ID(p_contract_template_id IN NUMBER)RETURN BOOLEAN;
665 FUNCTION CONTRACT_SOURCE_DOCUMENT_ID(p_contract_source_document_id IN NUMBER)RETURN BOOLEAN;
666 FUNCTION CONTRACT_SOURCE_DOC_TYPE_CODE(p_contract_source_doc_type IN NUMBER)RETURN BOOLEAN;
667 -- eBTax Changes
668 FUNCTION TAX_RATE_ID(p_tax_rate_id IN NUMBER)RETURN BOOLEAN;
669 -- end eBTax Changes
670 FUNCTION Payments_Desc_Flex (p_context IN VARCHAR2,
671 p_attribute1 IN VARCHAR2,
672 p_attribute2 IN VARCHAR2,
673 p_attribute3 IN VARCHAR2,
674 p_attribute4 IN VARCHAR2,
675 p_attribute5 IN VARCHAR2,
676 p_attribute6 IN VARCHAR2,
677 p_attribute7 IN VARCHAR2,
678 p_attribute8 IN VARCHAR2,
679 p_attribute9 IN VARCHAR2,
680 p_attribute10 IN VARCHAR2,
681 p_attribute11 IN VARCHAR2,
682 p_attribute12 IN VARCHAR2,
683 p_attribute13 IN VARCHAR2,
684 p_attribute14 IN VARCHAR2,
685 p_attribute15 IN VARCHAR2)
686
687 RETURN BOOLEAN;
688 FUNCTION Payment_Level(p_payment_level_code IN VARCHAR2) RETURN BOOLEAN;
689 FUNCTION commitment_applied_amount(p_commitment_applied_amount IN NUMBER) RETURN BOOLEAN;
690 FUNCTION commitment_interfaced_amount(p_commitment_interfaced_amount IN NUMBER) RETURN BOOLEAN;
691 FUNCTION Payment_Collection_Event(p_payment_collection_event IN VARCHAR2) RETURN
692 BOOLEAN;
693 FUNCTION Payment_Trx(p_payment_trx_id IN NUMBER) RETURN BOOLEAN;
694 FUNCTION Payment_Set(p_payment_set_id IN NUMBER) RETURN BOOLEAN;
695 FUNCTION Prepaid_Amount(p_prepaid_amount IN NUMBER)RETURN BOOLEAN;
696 FUNCTION Receipt_Method(p_receipt_method_id IN NUMBER)RETURN BOOLEAN;
697 FUNCTION Tangible(p_tangible_id IN VARCHAR2)RETURN BOOLEAN;
698 --recurring charges
699 FUNCTION Charge_Periodicity (p_charge_periodicity IN VARCHAR2) RETURN BOOLEAN;
700
701 -- INVCONV
702
703 FUNCTION Fulfilled_Quantity2(p_fulfilled_quantity2 IN NUMBER)RETURN BOOLEAN;
704 FUNCTION Shipping_Quantity2(p_shipping_quantity2 IN NUMBER)RETURN BOOLEAN;
705 FUNCTION Shipping_Quantity_Uom2(p_shipping_quantity_uom2 IN VARCHAR2)RETURN BOOLEAN;
706 FUNCTION Shipped_Quantity2(p_shipped_quantity2 IN NUMBER)RETURN BOOLEAN;
707 FUNCTION Payment_Trxn_Extension ( p_trxn_extension_id IN NUMBER ) RETURN BOOLEAN; -- R12 Process order api changes
708
709 --
710 END OE_Validate;