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