eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.QP_VALIDATE

Source


1 PACKAGE QP_Validate AUTHID CURRENT_USER AS
2 /* $Header: QPXSVATS.pls 120.4.12010000.1 2008/07/28 11:56:11 appldev 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 FUNCTION Desc_Flex ( p_flex_name IN VARCHAR2 )RETURN BOOLEAN;
20 FUNCTION Automatic(p_automatic_flag IN VARCHAR2)RETURN BOOLEAN;
21 FUNCTION Comments(p_comments IN VARCHAR2)RETURN BOOLEAN;
22 FUNCTION Created_By(p_created_by IN NUMBER)RETURN BOOLEAN;
23 FUNCTION Creation_Date(p_creation_date IN DATE)RETURN BOOLEAN;
24 FUNCTION Currency(p_currency_code IN VARCHAR2)RETURN BOOLEAN;
25 FUNCTION Discount_Lines(p_discount_lines_flag IN VARCHAR2)RETURN BOOLEAN;
26 FUNCTION End_Date_Active(p_end_date_active IN DATE, p_start_date_active IN DATE := NULL)RETURN BOOLEAN;
27 FUNCTION Freight_Terms(p_freight_terms_code IN VARCHAR2)RETURN BOOLEAN;
28 FUNCTION Gsa_Indicator(p_gsa_indicator IN VARCHAR2)RETURN BOOLEAN;
29 FUNCTION Last_Updated_By(p_last_updated_by IN NUMBER)RETURN BOOLEAN;
30 FUNCTION Last_Update_Date(p_last_update_date IN DATE)RETURN BOOLEAN;
31 FUNCTION Last_Update_Login(p_last_update_login IN NUMBER)RETURN BOOLEAN;
32 FUNCTION List_Header(p_list_header_id IN NUMBER)RETURN BOOLEAN;
33 FUNCTION List_Type(p_list_type_code IN VARCHAR2)RETURN BOOLEAN;
34 FUNCTION Program_Application(p_program_application_id IN NUMBER)RETURN BOOLEAN;
35 FUNCTION Program(p_program_id IN NUMBER)RETURN BOOLEAN;
36 FUNCTION Program_Update_Date(p_program_update_date IN DATE)RETURN BOOLEAN;
37 FUNCTION Prorate(p_prorate_flag IN VARCHAR2)RETURN BOOLEAN;
38 FUNCTION Request(p_request_id IN NUMBER)RETURN BOOLEAN;
39 FUNCTION Rounding_Factor(p_rounding_factor IN NUMBER,
40                          p_currency_code in varchar2 := NULL) RETURN BOOLEAN;
41 FUNCTION Ship_Method(p_ship_method_code IN VARCHAR2)RETURN BOOLEAN;
42 FUNCTION Start_Date_Active(p_start_date_active IN DATE, p_end_date_active IN DATE := NULL)RETURN BOOLEAN;
43 FUNCTION Terms(p_terms_id IN NUMBER)RETURN BOOLEAN;
44 FUNCTION Source_System(p_source_system_code IN VARCHAR2)RETURN BOOLEAN;
45 FUNCTION Pte_Code(p_pte_code IN VARCHAR2)RETURN BOOLEAN;
46 FUNCTION Active(p_active_flag IN VARCHAR2)RETURN BOOLEAN;
47 FUNCTION Parent_List_header(p_parent_list_header_id IN NUMBER)RETURN BOOLEAN;
48 FUNCTION Start_Date_Active_First(p_start_date_active_first IN DATE)RETURN BOOLEAN;
49 FUNCTION End_Date_Active_First(p_end_date_active_first IN DATE)RETURN BOOLEAN;
50 FUNCTION Active_Date_First_Type(p_active_date_first_type IN VARCHAR2)RETURN BOOLEAN;
51 FUNCTION Start_Date_Active_Second(p_start_date_active_second IN DATE)RETURN BOOLEAN;
52 FUNCTION Global_Flag(p_global_flag IN VARCHAR2)RETURN BOOLEAN;
53 FUNCTION End_Date_Active_Second(p_end_date_active_second IN DATE)RETURN BOOLEAN;
54 FUNCTION Active_Date_Second_Type(p_active_date_second_type IN VARCHAR2)RETURN BOOLEAN;
55 FUNCTION Ask_For(p_ask_for_flag IN VARCHAR2)RETURN BOOLEAN;
56 
57 FUNCTION Arithmetic_Operator(p_arithmetic_operator IN VARCHAR2)RETURN BOOLEAN;
58 --FUNCTION Base_Qty(p_base_qty IN NUMBER)RETURN BOOLEAN;
59 FUNCTION Pricing_Phase(p_pricing_phase_id IN NUMBER)RETURN BOOLEAN;
60 --FUNCTION Base_Uom(p_base_uom_code IN VARCHAR2)RETURN BOOLEAN;
61 FUNCTION Effective_Period_Uom(p_effective_period_uom IN VARCHAR2)RETURN BOOLEAN;
62 FUNCTION Estim_Accrual_Rate(p_estim_accrual_rate IN NUMBER)RETURN BOOLEAN;
63 FUNCTION Generate_Using_Formula(p_generate_using_formula_id IN NUMBER)RETURN BOOLEAN;
64 FUNCTION Gl_Class(p_gl_class_id IN NUMBER)RETURN BOOLEAN;
65 FUNCTION Inventory_Item(p_inventory_item_id IN NUMBER)RETURN BOOLEAN;
66 FUNCTION List_Line(p_list_line_id IN NUMBER)RETURN BOOLEAN;
67 FUNCTION List_Line_Type(p_list_line_type_code IN VARCHAR2)RETURN BOOLEAN;
68 FUNCTION List_Price(p_list_price IN NUMBER)RETURN BOOLEAN;
69 FUNCTION From_Rltd_Modifier ( p_from_rltd_modifier_id IN NUMBER ) RETURN BOOLEAN;
70 FUNCTION To_Rltd_Modifier ( p_to_rltd_modifier_id IN NUMBER ) RETURN BOOLEAN;
71 FUNCTION Rltd_Modifier_Grp_No ( p_rltd_modifier_grp_no IN NUMBER ) RETURN BOOLEAN;
72 FUNCTION Rltd_Modifier_Grp_type ( p_rltd_modifier_grp_type IN VARCHAR2 ) RETURN BOOLEAN;
73 FUNCTION List_Price_Uom(p_list_price_uom_code IN VARCHAR2)RETURN BOOLEAN;
74 FUNCTION Modifier_Level(p_modifier_level_code IN VARCHAR2)RETURN BOOLEAN;
75 FUNCTION New_Price(p_new_price IN NUMBER)RETURN BOOLEAN;
76 FUNCTION Number_Effective_Periods(p_number_effective_periods IN NUMBER)RETURN BOOLEAN;
77 FUNCTION Operand(p_operand IN NUMBER)RETURN BOOLEAN;
78 FUNCTION Organization(p_organization_id IN NUMBER)RETURN BOOLEAN;
79 FUNCTION Organization(p_organization_flag IN VARCHAR2)RETURN BOOLEAN;
80 FUNCTION Override(p_override_flag IN VARCHAR2)RETURN BOOLEAN;
81 FUNCTION Percent_Price(p_percent_price IN NUMBER)RETURN BOOLEAN;
82 FUNCTION Price_Break_Type(p_price_break_type_code IN VARCHAR2)RETURN BOOLEAN;
83 FUNCTION Price_By_Formula(p_price_by_formula_id IN NUMBER)RETURN BOOLEAN;
84 FUNCTION Primary_Uom(p_primary_uom_flag IN VARCHAR2)RETURN BOOLEAN;
85 FUNCTION Print_On_Invoice(p_print_on_invoice_flag IN VARCHAR2)RETURN BOOLEAN;
86 FUNCTION Rebate_Subtype(p_rebate_subtype_code IN VARCHAR2)RETURN BOOLEAN;
87 FUNCTION Rebate_Transaction_Type(p_rebate_trxn_type_code IN VARCHAR2)RETURN BOOLEAN;
88 FUNCTION Related_Item(p_related_item_id IN NUMBER)RETURN BOOLEAN;
89 FUNCTION Relationship_Type(p_relationship_type_id IN NUMBER)RETURN BOOLEAN;
90 FUNCTION Reprice(p_reprice_flag IN VARCHAR2)RETURN BOOLEAN;
91 FUNCTION Revision(p_revision IN VARCHAR2)RETURN BOOLEAN;
92 FUNCTION Revision_Date(p_revision_date IN DATE)RETURN BOOLEAN;
93 FUNCTION Revision_Reason(p_revision_reason_code IN VARCHAR2)RETURN BOOLEAN;
94 FUNCTION Substitution_Attribute(p_substitution_attribute IN VARCHAR2)RETURN BOOLEAN;
95 FUNCTION Substitution_Context(p_substitution_context IN VARCHAR2)RETURN BOOLEAN;
96 FUNCTION Substitution_Value(p_substitution_value IN VARCHAR2)RETURN BOOLEAN;
97 FUNCTION Accrual_Flag(p_accrual_flag IN VARCHAR2)RETURN BOOLEAN;
98 FUNCTION Pricing_Group_Sequence(p_pricing_group_sequence IN NUMBER)RETURN BOOLEAN;
99 FUNCTION Incompatibility_Grp_Code(p_incompatibility_grp_code IN VARCHAR2)RETURN BOOLEAN;
100 FUNCTION List_Line_No(p_list_line_no IN VARCHAR2)RETURN BOOLEAN;
101 FUNCTION Active_Flag(p_active_flag IN VARCHAR2)RETURN BOOLEAN;
102 FUNCTION Mobile_Download(p_mobile_download IN VARCHAR2)RETURN BOOLEAN; -- mkarya for bug 1944882
103 FUNCTION Product_Precedence(p_product_precedence IN NUMBER)RETURN BOOLEAN;
104 FUNCTION Exp_Period_Start_Date(p_expiration_period_start_date IN DATE)RETURN BOOLEAN;
105 FUNCTION Number_Expiration_Periods(p_number_expiration_periods IN NUMBER)RETURN BOOLEAN;
106 FUNCTION Expiration_Period_Uom(p_expiration_period_uom IN VARCHAR2)RETURN BOOLEAN;
107 FUNCTION Expiration_Date(p_expiration_date IN DATE)RETURN BOOLEAN;
108 FUNCTION Estim_Gl_Value(p_estim_gl_value IN NUMBER)RETURN BOOLEAN;
109 FUNCTION Ben_Price_List_Line(p_benefit_price_list_line_id IN NUMBER)RETURN BOOLEAN;
110 --FUNCTION Recurring(p_recurring_flag IN VARCHAR2)RETURN BOOLEAN;
111 FUNCTION Benefit_Limit(p_benefit_limit IN NUMBER)RETURN BOOLEAN;
112 FUNCTION Charge_Type(p_charge_type_code IN VARCHAR2)RETURN BOOLEAN;
113 FUNCTION Charge_Subtype(p_charge_subtype_code IN VARCHAR2)RETURN BOOLEAN;
114 FUNCTION Benefit_Qty(p_benefit_qty IN NUMBER)RETURN BOOLEAN;
115 FUNCTION Benefit_Uom(p_benefit_uom_code IN VARCHAR2)RETURN BOOLEAN;
116 FUNCTION Accrual_Conversion_Rate(p_accrual_conversion_rate IN NUMBER)RETURN BOOLEAN;
117 FUNCTION Proration_Type(p_proration_type_code IN VARCHAR2)RETURN BOOLEAN;
118 FUNCTION Include_On_Returns_Flag(p_include_on_returns_flag IN VARCHAR2)RETURN BOOLEAN;
119 FUNCTION Recurring_Value(p_recurring_value IN NUMBER) RETURN BOOLEAN; -- block pricing
120 
121 FUNCTION Comparison_Operator(p_comparison_operator_code IN VARCHAR2)RETURN BOOLEAN;
122 FUNCTION Created_From_Rule(p_created_from_rule_id IN NUMBER)RETURN BOOLEAN;
123 FUNCTION Excluder(p_excluder_flag IN VARCHAR2)RETURN BOOLEAN;
124 FUNCTION Qualifier_Attribute(p_qualifier_attribute IN VARCHAR2)RETURN BOOLEAN;
125 FUNCTION Qualifier_Attr_Value(p_qualifier_attr_value IN VARCHAR2)RETURN BOOLEAN;
126 FUNCTION Qualifier_Attr_Value_To(p_qualifier_attr_value_to IN VARCHAR2)RETURN BOOLEAN;
127 FUNCTION Qualifier_Context(p_qualifier_context IN VARCHAR2)RETURN BOOLEAN;
128 FUNCTION Qualifier_Grouping_No(p_qualifier_grouping_no IN NUMBER)RETURN BOOLEAN;
129 FUNCTION Qualifier(p_qualifier_id IN NUMBER)RETURN BOOLEAN;
130 FUNCTION Qualifier_Rule(p_qualifier_rule_id IN NUMBER)RETURN BOOLEAN;
131 
132 FUNCTION Accumulate(p_accumulate_flag IN VARCHAR2)RETURN BOOLEAN;
133 FUNCTION Attribute_Grouping_No(p_attribute_grouping_no IN NUMBER)RETURN BOOLEAN;
134 FUNCTION Pricing_Attribute(p_pricing_attribute IN VARCHAR2)RETURN BOOLEAN;
135 FUNCTION Pricing_Attribute_Context(p_pricing_attribute_context IN VARCHAR2)RETURN BOOLEAN;
136 FUNCTION Pricing_Attribute(p_pricing_attribute_id IN NUMBER)RETURN BOOLEAN;
137 FUNCTION Pricing_Attr_Value_From(p_pricing_attr_value_from IN VARCHAR2)RETURN BOOLEAN;
138 FUNCTION Pricing_Attr_Value_To(p_pricing_attr_value_to IN VARCHAR2)RETURN BOOLEAN;
139 FUNCTION Product_Attribute(p_product_attribute IN VARCHAR2)RETURN BOOLEAN;
140 FUNCTION Product_Attribute_Context(p_product_attribute_context IN VARCHAR2)RETURN BOOLEAN;
141 FUNCTION Product_Attr_Value(p_product_attr_value IN VARCHAR2)RETURN BOOLEAN;
142 FUNCTION Product_Uom ( p_product_uom_code IN VARCHAR2,
143                        p_category_id IN NUMBER,
144                        p_list_header_id IN NUMBER ) RETURN BOOLEAN; -- sfiresto bug 4753707
145 FUNCTION Product_Uom(p_product_uom_code IN VARCHAR2)RETURN BOOLEAN;
146 FUNCTION Product_Attribute_Datatype(p_product_attribute_datatype IN VARCHAR2)RETURN BOOLEAN;
147 FUNCTION Pricing_Attribute_Datatype(p_pricing_attribute_datatype IN VARCHAR2)RETURN BOOLEAN;
148 FUNCTION Comparison_Operator_Code(p_comparison_operator_code IN VARCHAR2)RETURN BOOLEAN;
149 
150 FUNCTION Description(p_description IN VARCHAR2)RETURN BOOLEAN;
151 FUNCTION Name(p_name IN VARCHAR2)RETURN BOOLEAN;
152 FUNCTION Version(p_version_no IN VARCHAR2)RETURN BOOLEAN;
153 
154 FUNCTION Qualifier_Datatype(p_qualifier_datatype IN VARCHAR2)RETURN BOOLEAN;
155 FUNCTION Qualifier_Date_Format(p_qualifier_date_format IN VARCHAR2)RETURN BOOLEAN;
156 FUNCTION Qualifier_Number_Format(p_qualifier_number_format IN VARCHAR2)RETURN BOOLEAN;
157 FUNCTION Qualifier_Precedence(p_qualifier_precedence IN NUMBER)RETURN BOOLEAN;
158 
159 FUNCTION Flex_Title(p_flex_title IN VARCHAR2)RETURN BOOLEAN;
160 FUNCTION Header(p_header_id IN NUMBER)RETURN BOOLEAN;
161 FUNCTION Line(p_line_id IN NUMBER)RETURN BOOLEAN;
162 FUNCTION Order_Price_Attrib(p_order_price_attrib_id IN NUMBER)RETURN BOOLEAN;
163 FUNCTION Pricing_Attribute100(p_pricing_attribute100 IN VARCHAR2)RETURN BOOLEAN;
164 FUNCTION Pricing_Attribute11(p_pricing_attribute11 IN VARCHAR2)RETURN BOOLEAN;
165 FUNCTION Pricing_Attribute12(p_pricing_attribute12 IN VARCHAR2)RETURN BOOLEAN;
166 FUNCTION Pricing_Attribute13(p_pricing_attribute13 IN VARCHAR2)RETURN BOOLEAN;
167 FUNCTION Pricing_Attribute14(p_pricing_attribute14 IN VARCHAR2)RETURN BOOLEAN;
168 FUNCTION Pricing_Attribute15(p_pricing_attribute15 IN VARCHAR2)RETURN BOOLEAN;
169 FUNCTION Pricing_Attribute16(p_pricing_attribute16 IN VARCHAR2)RETURN BOOLEAN;
170 FUNCTION Pricing_Attribute17(p_pricing_attribute17 IN VARCHAR2)RETURN BOOLEAN;
171 FUNCTION Pricing_Attribute18(p_pricing_attribute18 IN VARCHAR2)RETURN BOOLEAN;
172 FUNCTION Pricing_Attribute19(p_pricing_attribute19 IN VARCHAR2)RETURN BOOLEAN;
173 FUNCTION Pricing_Attribute20(p_pricing_attribute20 IN VARCHAR2)RETURN BOOLEAN;
174 FUNCTION Pricing_Attribute21(p_pricing_attribute21 IN VARCHAR2)RETURN BOOLEAN;
175 FUNCTION Pricing_Attribute22(p_pricing_attribute22 IN VARCHAR2)RETURN BOOLEAN;
176 FUNCTION Pricing_Attribute23(p_pricing_attribute23 IN VARCHAR2)RETURN BOOLEAN;
177 FUNCTION Pricing_Attribute24(p_pricing_attribute24 IN VARCHAR2)RETURN BOOLEAN;
178 FUNCTION Pricing_Attribute25(p_pricing_attribute25 IN VARCHAR2)RETURN BOOLEAN;
179 FUNCTION Pricing_Attribute26(p_pricing_attribute26 IN VARCHAR2)RETURN BOOLEAN;
180 FUNCTION Pricing_Attribute27(p_pricing_attribute27 IN VARCHAR2)RETURN BOOLEAN;
181 FUNCTION Pricing_Attribute28(p_pricing_attribute28 IN VARCHAR2)RETURN BOOLEAN;
182 FUNCTION Pricing_Attribute29(p_pricing_attribute29 IN VARCHAR2)RETURN BOOLEAN;
183 FUNCTION Pricing_Attribute30(p_pricing_attribute30 IN VARCHAR2)RETURN BOOLEAN;
184 FUNCTION Pricing_Attribute31(p_pricing_attribute31 IN VARCHAR2)RETURN BOOLEAN;
185 FUNCTION Pricing_Attribute32(p_pricing_attribute32 IN VARCHAR2)RETURN BOOLEAN;
186 FUNCTION Pricing_Attribute33(p_pricing_attribute33 IN VARCHAR2)RETURN BOOLEAN;
187 FUNCTION Pricing_Attribute34(p_pricing_attribute34 IN VARCHAR2)RETURN BOOLEAN;
188 FUNCTION Pricing_Attribute35(p_pricing_attribute35 IN VARCHAR2)RETURN BOOLEAN;
189 FUNCTION Pricing_Attribute36(p_pricing_attribute36 IN VARCHAR2)RETURN BOOLEAN;
190 FUNCTION Pricing_Attribute37(p_pricing_attribute37 IN VARCHAR2)RETURN BOOLEAN;
191 FUNCTION Pricing_Attribute38(p_pricing_attribute38 IN VARCHAR2)RETURN BOOLEAN;
192 FUNCTION Pricing_Attribute39(p_pricing_attribute39 IN VARCHAR2)RETURN BOOLEAN;
193 FUNCTION Pricing_Attribute40(p_pricing_attribute40 IN VARCHAR2)RETURN BOOLEAN;
194 FUNCTION Pricing_Attribute41(p_pricing_attribute41 IN VARCHAR2)RETURN BOOLEAN;
195 FUNCTION Pricing_Attribute42(p_pricing_attribute42 IN VARCHAR2)RETURN BOOLEAN;
196 FUNCTION Pricing_Attribute43(p_pricing_attribute43 IN VARCHAR2)RETURN BOOLEAN;
197 FUNCTION Pricing_Attribute44(p_pricing_attribute44 IN VARCHAR2)RETURN BOOLEAN;
198 FUNCTION Pricing_Attribute45(p_pricing_attribute45 IN VARCHAR2)RETURN BOOLEAN;
199 FUNCTION Pricing_Attribute46(p_pricing_attribute46 IN VARCHAR2)RETURN BOOLEAN;
200 FUNCTION Pricing_Attribute47(p_pricing_attribute47 IN VARCHAR2)RETURN BOOLEAN;
201 FUNCTION Pricing_Attribute48(p_pricing_attribute48 IN VARCHAR2)RETURN BOOLEAN;
202 FUNCTION Pricing_Attribute49(p_pricing_attribute49 IN VARCHAR2)RETURN BOOLEAN;
203 FUNCTION Pricing_Attribute50(p_pricing_attribute50 IN VARCHAR2)RETURN BOOLEAN;
204 FUNCTION Pricing_Attribute51(p_pricing_attribute51 IN VARCHAR2)RETURN BOOLEAN;
205 FUNCTION Pricing_Attribute52(p_pricing_attribute52 IN VARCHAR2)RETURN BOOLEAN;
206 FUNCTION Pricing_Attribute53(p_pricing_attribute53 IN VARCHAR2)RETURN BOOLEAN;
207 FUNCTION Pricing_Attribute54(p_pricing_attribute54 IN VARCHAR2)RETURN BOOLEAN;
208 FUNCTION Pricing_Attribute55(p_pricing_attribute55 IN VARCHAR2)RETURN BOOLEAN;
209 FUNCTION Pricing_Attribute56(p_pricing_attribute56 IN VARCHAR2)RETURN BOOLEAN;
210 FUNCTION Pricing_Attribute57(p_pricing_attribute57 IN VARCHAR2)RETURN BOOLEAN;
211 FUNCTION Pricing_Attribute58(p_pricing_attribute58 IN VARCHAR2)RETURN BOOLEAN;
212 FUNCTION Pricing_Attribute59(p_pricing_attribute59 IN VARCHAR2)RETURN BOOLEAN;
213 FUNCTION Pricing_Attribute60(p_pricing_attribute60 IN VARCHAR2)RETURN BOOLEAN;
214 FUNCTION Pricing_Attribute61(p_pricing_attribute61 IN VARCHAR2)RETURN BOOLEAN;
215 FUNCTION Pricing_Attribute62(p_pricing_attribute62 IN VARCHAR2)RETURN BOOLEAN;
216 FUNCTION Pricing_Attribute63(p_pricing_attribute63 IN VARCHAR2)RETURN BOOLEAN;
217 FUNCTION Pricing_Attribute64(p_pricing_attribute64 IN VARCHAR2)RETURN BOOLEAN;
218 FUNCTION Pricing_Attribute65(p_pricing_attribute65 IN VARCHAR2)RETURN BOOLEAN;
219 FUNCTION Pricing_Attribute66(p_pricing_attribute66 IN VARCHAR2)RETURN BOOLEAN;
220 FUNCTION Pricing_Attribute67(p_pricing_attribute67 IN VARCHAR2)RETURN BOOLEAN;
221 FUNCTION Pricing_Attribute68(p_pricing_attribute68 IN VARCHAR2)RETURN BOOLEAN;
222 FUNCTION Pricing_Attribute69(p_pricing_attribute69 IN VARCHAR2)RETURN BOOLEAN;
223 FUNCTION Pricing_Attribute70(p_pricing_attribute70 IN VARCHAR2)RETURN BOOLEAN;
224 FUNCTION Pricing_Attribute71(p_pricing_attribute71 IN VARCHAR2)RETURN BOOLEAN;
225 FUNCTION Pricing_Attribute72(p_pricing_attribute72 IN VARCHAR2)RETURN BOOLEAN;
226 FUNCTION Pricing_Attribute73(p_pricing_attribute73 IN VARCHAR2)RETURN BOOLEAN;
227 FUNCTION Pricing_Attribute74(p_pricing_attribute74 IN VARCHAR2)RETURN BOOLEAN;
228 FUNCTION Pricing_Attribute75(p_pricing_attribute75 IN VARCHAR2)RETURN BOOLEAN;
229 FUNCTION Pricing_Attribute76(p_pricing_attribute76 IN VARCHAR2)RETURN BOOLEAN;
230 FUNCTION Pricing_Attribute77(p_pricing_attribute77 IN VARCHAR2)RETURN BOOLEAN;
231 FUNCTION Pricing_Attribute78(p_pricing_attribute78 IN VARCHAR2)RETURN BOOLEAN;
232 FUNCTION Pricing_Attribute79(p_pricing_attribute79 IN VARCHAR2)RETURN BOOLEAN;
233 FUNCTION Pricing_Attribute80(p_pricing_attribute80 IN VARCHAR2)RETURN BOOLEAN;
234 FUNCTION Pricing_Attribute81(p_pricing_attribute81 IN VARCHAR2)RETURN BOOLEAN;
238 FUNCTION Pricing_Attribute85(p_pricing_attribute85 IN VARCHAR2)RETURN BOOLEAN;
235 FUNCTION Pricing_Attribute82(p_pricing_attribute82 IN VARCHAR2)RETURN BOOLEAN;
236 FUNCTION Pricing_Attribute83(p_pricing_attribute83 IN VARCHAR2)RETURN BOOLEAN;
237 FUNCTION Pricing_Attribute84(p_pricing_attribute84 IN VARCHAR2)RETURN BOOLEAN;
239 FUNCTION Pricing_Attribute86(p_pricing_attribute86 IN VARCHAR2)RETURN BOOLEAN;
240 FUNCTION Pricing_Attribute87(p_pricing_attribute87 IN VARCHAR2)RETURN BOOLEAN;
241 FUNCTION Pricing_Attribute88(p_pricing_attribute88 IN VARCHAR2)RETURN BOOLEAN;
242 FUNCTION Pricing_Attribute89(p_pricing_attribute89 IN VARCHAR2)RETURN BOOLEAN;
243 FUNCTION Pricing_Attribute90(p_pricing_attribute90 IN VARCHAR2)RETURN BOOLEAN;
244 FUNCTION Pricing_Attribute91(p_pricing_attribute91 IN VARCHAR2)RETURN BOOLEAN;
245 FUNCTION Pricing_Attribute92(p_pricing_attribute92 IN VARCHAR2)RETURN BOOLEAN;
246 FUNCTION Pricing_Attribute93(p_pricing_attribute93 IN VARCHAR2)RETURN BOOLEAN;
247 FUNCTION Pricing_Attribute94(p_pricing_attribute94 IN VARCHAR2)RETURN BOOLEAN;
248 FUNCTION Pricing_Attribute95(p_pricing_attribute95 IN VARCHAR2)RETURN BOOLEAN;
249 FUNCTION Pricing_Attribute96(p_pricing_attribute96 IN VARCHAR2)RETURN BOOLEAN;
250 FUNCTION Pricing_Attribute97(p_pricing_attribute97 IN VARCHAR2)RETURN BOOLEAN;
251 FUNCTION Pricing_Attribute98(p_pricing_attribute98 IN VARCHAR2)RETURN BOOLEAN;
252 FUNCTION Pricing_Attribute99(p_pricing_attribute99 IN VARCHAR2)RETURN BOOLEAN;
253 
254 
255 FUNCTION Formula(p_formula IN VARCHAR2)RETURN BOOLEAN;
256 FUNCTION Price_Formula(p_price_formula_id IN NUMBER)RETURN BOOLEAN;
257 
258 FUNCTION Numeric_Constant(p_numeric_constant IN NUMBER)RETURN BOOLEAN;
259 FUNCTION Reqd_Flag(p_reqd_flag IN VARCHAR2)RETURN BOOLEAN;
260 FUNCTION Price_Formula_Line(p_price_formula_line_id IN NUMBER)RETURN BOOLEAN;
261 FUNCTION Price_Formula_Line_Type(p_formula_line_type_code IN VARCHAR2)RETURN BOOLEAN;
262 FUNCTION Price_List_Line(p_price_list_line_id IN NUMBER)RETURN BOOLEAN;
263 FUNCTION Price_Modifier_List(p_price_modifier_list_id IN NUMBER)RETURN BOOLEAN;
264 FUNCTION Step_Number(p_step_number IN NUMBER)RETURN BOOLEAN;
265 FUNCTION Price_List_Name ( p_name IN VARCHAR2,
266                            p_list_header_id in number,
267                            p_version_no in varchar2 := NULL ) RETURN BOOLEAN;
268 
269 FUNCTION Amount(p_amount IN NUMBER)RETURN BOOLEAN;
270 FUNCTION Basis(p_basis IN VARCHAR2)RETURN BOOLEAN;
271 FUNCTION Limit_Exceed_Action(p_limit_exceed_action_code IN VARCHAR2)RETURN BOOLEAN;
272 FUNCTION Limit(p_limit_id IN NUMBER)RETURN BOOLEAN;
273 FUNCTION Limit_Level(p_limit_level_code IN VARCHAR2)RETURN BOOLEAN;
274 FUNCTION Limit_Number(p_limit_number IN NUMBER)RETURN BOOLEAN;
275 FUNCTION Limit_Hold(p_limit_hold_flag IN VARCHAR2)RETURN BOOLEAN;
276 FUNCTION Multival_Attr1_Type(p_multival_attr1_type IN VARCHAR2)RETURN BOOLEAN;
277 FUNCTION Multival_Attr1_Context(p_multival_attr1_context IN VARCHAR2)RETURN BOOLEAN;
278 FUNCTION Multival_Attribute1(p_multival_attribute1 IN VARCHAR2)RETURN BOOLEAN;
279 FUNCTION Multival_Attr1_Datatype(p_multival_attr1_datatype IN VARCHAR2)RETURN BOOLEAN;
280 FUNCTION Multival_Attr2_Type(p_multival_attr2_type IN VARCHAR2)RETURN BOOLEAN;
281 FUNCTION Multival_Attr2_Context(p_multival_attr2_context IN VARCHAR2)RETURN BOOLEAN;
282 FUNCTION Multival_Attribute2(p_multival_attribute2 IN VARCHAR2)RETURN BOOLEAN;
283 FUNCTION Multival_Attr2_Datatype(p_multival_attr2_datatype IN VARCHAR2)RETURN BOOLEAN;
284 
285 
286 FUNCTION Limit_Attribute(p_limit_attribute IN VARCHAR2)RETURN BOOLEAN;
287 FUNCTION Limit_Attribute_Context(p_limit_attribute_context IN VARCHAR2)RETURN BOOLEAN;
288 FUNCTION Limit_Attribute(p_limit_attribute_id IN NUMBER)RETURN BOOLEAN;
289 FUNCTION Limit_Attribute_Type(p_limit_attribute_type IN VARCHAR2)RETURN BOOLEAN;
290 FUNCTION Limit_Attr_Datatype(p_limit_attr_datatype IN VARCHAR2)RETURN BOOLEAN;
291 FUNCTION Limit_Attr_Value(p_limit_attr_value IN VARCHAR2)RETURN BOOLEAN;
292 
293 FUNCTION Limit_Balance(p_limit_balance_id IN NUMBER)RETURN BOOLEAN;
294 FUNCTION Available_Amount(p_available_amount IN NUMBER)RETURN BOOLEAN;
295 FUNCTION Consumed_Amount(p_consumed_amount IN NUMBER)RETURN BOOLEAN;
296 FUNCTION Reserved_Amount(p_reserved_amount IN NUMBER)RETURN BOOLEAN;
297 FUNCTION Multival_Attr1_Value(p_multival_attr1_value IN VARCHAR2)RETURN BOOLEAN;
298 FUNCTION Multival_Attr2_Value(p_multival_attr2_value IN VARCHAR2)RETURN BOOLEAN;
299 FUNCTION Organization_Attr_Context(p_organization_attr_context IN VARCHAR2)RETURN BOOLEAN;
300 FUNCTION Organization_Attribute(p_organization_attribute IN VARCHAR2)RETURN BOOLEAN;
301 FUNCTION Organization_Attr_Value(p_organization_attr_value IN VARCHAR2)RETURN BOOLEAN;
302 
303 
304 FUNCTION Base_Currency(p_base_currency_code IN VARCHAR2)RETURN BOOLEAN;
305 FUNCTION Currency_Header(p_currency_header_id IN NUMBER)RETURN BOOLEAN;
306 FUNCTION Row(p_row_id IN ROWID)RETURN BOOLEAN;
307 
308 FUNCTION Conversion_Date(p_conversion_date IN DATE)RETURN BOOLEAN;
309 FUNCTION Conversion_Date_Type(p_conversion_date_type IN VARCHAR2)RETURN BOOLEAN;
310 -- FUNCTION Conversion_Method(p_conversion_method IN VARCHAR2)RETURN BOOLEAN;
311 FUNCTION Conversion_Type(p_conversion_type IN VARCHAR2)RETURN BOOLEAN;
312 FUNCTION Currency_Detail(p_currency_detail_id IN NUMBER)RETURN BOOLEAN;
313 FUNCTION Fixed_Value(p_fixed_value IN NUMBER)RETURN BOOLEAN;
314 FUNCTION Markup_Formula(p_markup_formula_id IN NUMBER)RETURN BOOLEAN;
315 FUNCTION Markup_Operator(p_markup_operator IN VARCHAR2)RETURN BOOLEAN;
316 FUNCTION Markup_Value(p_markup_value IN NUMBER)RETURN BOOLEAN;
317 FUNCTION To_Currency(p_to_currency_code IN VARCHAR2)RETURN BOOLEAN;
318 -- Added by Sunil Pandey 10/01/01
319 FUNCTION base_rounding_factor(p_base_rounding_factor IN NUMBER) RETURN BOOLEAN;
320 FUNCTION base_markup_formula(p_base_markup_formula_id IN NUMBER) RETURN BOOLEAN;
324 
321 FUNCTION base_markup_operator(p_base_markup_operator IN VARCHAR2) RETURN BOOLEAN;
322 FUNCTION Base_Markup_Value(p_Base_markup_value IN NUMBER) RETURN BOOLEAN;
323 -- Added by Sunil Pandey 10/01/01
325 FUNCTION Enabled(p_enabled_flag IN VARCHAR2)RETURN BOOLEAN;
326 FUNCTION Prc_Context_Code(p_prc_context_code IN VARCHAR2)RETURN BOOLEAN;
327 FUNCTION Prc_Context(p_prc_context_id IN NUMBER)RETURN BOOLEAN;
328 FUNCTION Prc_Context_Type(p_prc_context_type IN VARCHAR2)RETURN BOOLEAN;
329 FUNCTION Seeded_Description(p_seeded_description IN VARCHAR2)RETURN BOOLEAN;
330 FUNCTION Seeded(p_seeded_flag IN VARCHAR2)RETURN BOOLEAN;
331 FUNCTION Seeded_Prc_Context_Name(p_seeded_prc_context_name IN VARCHAR2)RETURN BOOLEAN;
332 FUNCTION User_Description(p_user_description IN VARCHAR2)RETURN BOOLEAN;
333 FUNCTION User_Prc_Context_Name(p_user_prc_context_name IN VARCHAR2)RETURN BOOLEAN;
334 
335 FUNCTION Availability_In_Basic(p_availability_in_basic IN VARCHAR2)RETURN BOOLEAN;
336 FUNCTION Seeded_Format_Type(p_seeded_format_type IN VARCHAR2)RETURN BOOLEAN;
337 FUNCTION Seeded_Precedence(p_seeded_precedence IN NUMBER)RETURN BOOLEAN;
338 FUNCTION Seeded_Segment_Name(p_seeded_segment_name IN VARCHAR2)RETURN BOOLEAN;
339 FUNCTION Seeded_Valueset(p_seeded_valueset_id IN NUMBER)RETURN BOOLEAN;
340 FUNCTION Seeded_Description_Seg(p_seeded_description IN VARCHAR2)RETURN BOOLEAN;
341 FUNCTION Segment_Code(p_segment_code IN VARCHAR2)RETURN BOOLEAN;
342 FUNCTION Segment(p_segment_id IN NUMBER)RETURN BOOLEAN;
343 -- Added new Column : Abhijit
344 FUNCTION application_id(p_application_id IN number)RETURN BOOLEAN;
345 FUNCTION Segment_Mapping_Column(p_segment_mapping_column IN VARCHAR2)RETURN BOOLEAN;
346 FUNCTION User_Format_Type(p_user_format_type IN VARCHAR2)RETURN BOOLEAN;
347 FUNCTION User_Precedence(p_user_precedence IN NUMBER)RETURN BOOLEAN;
348 FUNCTION User_Segment_Name(p_user_segment_name IN VARCHAR2)RETURN BOOLEAN;
349 FUNCTION User_Valueset(p_user_valueset_id IN NUMBER)RETURN BOOLEAN;
350 FUNCTION User_Description_Seg(p_user_description IN VARCHAR2)RETURN BOOLEAN;
351 FUNCTION Lookup(p_lookup_code IN VARCHAR2)RETURN BOOLEAN;
352 FUNCTION Lookup_Type(p_lookup_type IN VARCHAR2)RETURN BOOLEAN;
353 FUNCTION Meaning(p_meaning IN VARCHAR2)RETURN BOOLEAN;
354 
355 FUNCTION Line_Level_Global_Struct(p_line_level_global_struct IN VARCHAR2)RETURN BOOLEAN;
356 FUNCTION Line_Level_View_Name(p_line_level_view_name IN VARCHAR2)RETURN BOOLEAN;
357 FUNCTION Order_Level_Global_Struct(p_order_level_global_struct IN VARCHAR2)RETURN BOOLEAN;
358 FUNCTION Order_Level_View_Name(p_order_level_view_name IN VARCHAR2)RETURN BOOLEAN;
359 FUNCTION Pte(p_pte_code IN VARCHAR2)RETURN BOOLEAN;
360 FUNCTION Request_Type(p_request_type_code IN VARCHAR2)RETURN BOOLEAN;
361 FUNCTION Request_Type_Desc(p_request_type_desc IN VARCHAR2)RETURN BOOLEAN;
362 
363 FUNCTION Application_Short_Name(p_application_short_name IN VARCHAR2)RETURN BOOLEAN;
364 FUNCTION Pte_Source_System(p_pte_source_system_id IN NUMBER)RETURN BOOLEAN;
365 
366 FUNCTION Limits_Enabled(p_limits_enabled IN VARCHAR2)RETURN BOOLEAN;
367 FUNCTION Lov_Enabled(p_lov_enabled IN VARCHAR2)RETURN BOOLEAN;
368 FUNCTION Seeded_Sourcing_Method(p_seeded_sourcing_method IN VARCHAR2)RETURN BOOLEAN;
369 FUNCTION Segment_Level(p_segment_level IN VARCHAR2)RETURN BOOLEAN;
370 FUNCTION Segment_Pte(p_segment_pte_id IN NUMBER)RETURN BOOLEAN;
371 FUNCTION Sourcing_Enabled(p_sourcing_enabled IN VARCHAR2)RETURN BOOLEAN;
372 FUNCTION Sourcing_Status(p_sourcing_status IN VARCHAR2)RETURN BOOLEAN;
373 FUNCTION User_Sourcing_Method(p_user_sourcing_method IN VARCHAR2)RETURN BOOLEAN;
374 
375 FUNCTION Attribute_Sourcing(p_attribute_sourcing_id IN NUMBER)RETURN BOOLEAN;
376 FUNCTION Attribute_Sourcing_Level(p_attribute_sourcing_level IN VARCHAR2)RETURN BOOLEAN;
377 --FUNCTION Application_Id(p_application_id IN NUMBER)RETURN BOOLEAN;
378 FUNCTION Seeded_Sourcing_Type(p_seeded_sourcing_type IN VARCHAR2)RETURN BOOLEAN;
379 FUNCTION Seeded_Value_String(p_seeded_value_string IN VARCHAR2)RETURN BOOLEAN;
380 FUNCTION User_Sourcing_Type(p_user_sourcing_type IN VARCHAR2)RETURN BOOLEAN;
381 FUNCTION User_Value_String(p_user_value_string IN VARCHAR2)RETURN BOOLEAN;
382 FUNCTION Required_Flag(p_required_flag IN VARCHAR2)RETURN BOOLEAN;
383 --
384 FUNCTION Curr_Attribute_Type(p_curr_attribute_type IN VARCHAR2) RETURN BOOLEAN;
385 FUNCTION Curr_Attribute_Context(p_curr_attribute_context IN VARCHAR2) RETURN BOOLEAN;
386 FUNCTION Curr_Attribute(p_curr_attribute IN VARCHAR2) RETURN BOOLEAN;
387 FUNCTION Curr_Attribute_Value(p_curr_attribute_value IN VARCHAR2) RETURN BOOLEAN;
388 FUNCTION Precedence(p_precedence IN NUMBER) RETURN BOOLEAN;
389 FUNCTION List_Source_Code(p_List_Source_Code IN VARCHAR2)RETURN BOOLEAN;
390 FUNCTION Net_Amount(p_net_amount_flag IN VARCHAR2)RETURN BOOLEAN;
391 FUNCTION Accum_Attribute(p_accum_attribute IN VARCHAR2) RETURN BOOLEAN;
392 FUNCTION Break_UOM_Code(p_break_uom_code IN VARCHAR2)RETURN BOOLEAN;
393 FUNCTION Break_UOM_Context(p_break_uom_context IN VARCHAR2)RETURN BOOLEAN;
394 FUNCTION Break_UOM_Attribute(p_break_uom_attribute IN VARCHAR2)RETURN BOOLEAN;
395 
396 FUNCTION Functional_Area(p_functional_area_id IN NUMBER)RETURN BOOLEAN;
397 FUNCTION Pte_Sourcesystem_Fnarea(p_pte_sourcesystem_fnarea_id IN NUMBER)RETURN BOOLEAN;
398 --  END GEN validate
399 
400 --Blanket Pricing
401 FUNCTION Orig_System_Header_Ref(p_Orig_System_Header_Ref IN VARCHAR2) RETURN BOOLEAN;
402 FUNCTION Shareable_Flag(p_Shareable_Flag IN VARCHAR2) RETURN BOOLEAN;
403 FUNCTION Sold_To_Org_Id(p_Sold_To_Org_Id IN NUMBER) RETURN BOOLEAN;
404 FUNCTION Customer_Item_Id(p_Customer_Item_Id IN NUMBER) RETURN BOOLEAN;
405 FUNCTION Locked_From_List_Header_Id(p_Locked_From_List_Header_Id IN NUMBER) RETURN BOOLEAN;
406 --added for MOAC
407 FUNCTION Org_Id(p_org_id IN NUMBER) RETURN BOOLEAN;
408 --added for TCA
409 FUNCTION Party_Hierarchy_Enabled_flag(p_party_hierarchy_enabled_flag IN VARCHAR2) RETURN BOOLEAN;
410 FUNCTION Qualify_Hier_Descendent_Flag(p_qualify_hier_descendent_flag IN VARCHAR2) RETURN BOOLEAN;
411 
412 END QP_Validate;