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.OE_VALIDATE_ATTR

Source


1 PACKAGE OE_Validate_Attr AS
2 /* $Header: OEXSVXTS.pls 120.2 2005/12/14 16:26:05 shulin noship $ */
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 Agreement(p_agreement_id IN NUMBER)RETURN BOOLEAN;
21 FUNCTION Created_By(p_created_by IN NUMBER)RETURN BOOLEAN;
22 FUNCTION Creation_Date(p_creation_date IN DATE)RETURN BOOLEAN;
23 FUNCTION Discount(p_discount_id IN NUMBER)RETURN BOOLEAN;
24 FUNCTION Last_Updated_By(p_last_updated_by IN NUMBER)RETURN BOOLEAN;
25 FUNCTION Last_Update_Date(p_last_update_date IN DATE)RETURN BOOLEAN;
26 FUNCTION Last_Update_Login(p_last_update_login IN NUMBER)RETURN BOOLEAN;
27 FUNCTION Price_List(p_price_list_id IN NUMBER)RETURN BOOLEAN;
28 FUNCTION Pricing_Contract(p_pricing_contract_id IN NUMBER)RETURN BOOLEAN;
29 
30 FUNCTION Accounting_Rule(p_accounting_rule_id IN NUMBER)RETURN BOOLEAN;
31 FUNCTION Agreement_Contact(p_agreement_contact_id IN NUMBER)RETURN BOOLEAN;
32 FUNCTION Agreement_Num(p_agreement_num IN VARCHAR2)RETURN BOOLEAN;
33 FUNCTION Agreement_Type(p_agreement_type_code IN VARCHAR2)RETURN BOOLEAN;
34 /* FUNCTION Customer(p_customer_id IN NUMBER)RETURN BOOLEAN; */
35 FUNCTION Customer(p_sold_to_org_id IN NUMBER)RETURN BOOLEAN;
36 FUNCTION End_Date_Active(p_end_date_active IN DATE)RETURN BOOLEAN;
37 FUNCTION Start_Date_End_Date(p_start_date_active	IN DATE,
38                              p_end_date_active		IN DATE)RETURN BOOLEAN;
39 FUNCTION Freight_Terms(p_freight_terms_code IN VARCHAR2)RETURN BOOLEAN;
40 FUNCTION Invoice_Contact(p_invoice_contact_id IN NUMBER)RETURN BOOLEAN;
41 /* FUNCTION Invoice_To_Site_Use(p_invoice_to_site_use_id IN NUMBER)RETURN BOOLEAN;  */
42 FUNCTION Invoice_To_Site_Use(p_invoice_to_org_id IN NUMBER)RETURN BOOLEAN;
43 FUNCTION Invoicing_Rule(p_invoicing_rule_id IN NUMBER)RETURN BOOLEAN;
44 FUNCTION Name(p_name IN VARCHAR2)RETURN BOOLEAN;
45 FUNCTION Override_Arule(p_override_arule_flag IN VARCHAR2)RETURN BOOLEAN;
46 FUNCTION Override_Irule(p_override_irule_flag IN VARCHAR2)RETURN BOOLEAN;
47 FUNCTION Purchase_Order_Num(p_purchase_order_num IN VARCHAR2)RETURN BOOLEAN;
48 FUNCTION Revision(p_revision IN VARCHAR2)RETURN BOOLEAN;
49 FUNCTION Revision_Date(p_revision_date IN DATE)RETURN BOOLEAN;
50 FUNCTION Revision_Reason(p_revision_reason_code IN VARCHAR2)RETURN BOOLEAN;
51 FUNCTION Salesrep(p_salesrep_id IN NUMBER)RETURN BOOLEAN;
52 FUNCTION Ship_Method(p_ship_method_code IN VARCHAR2)RETURN BOOLEAN;
53 FUNCTION Signature_Date(p_signature_date IN DATE)RETURN BOOLEAN;
54 FUNCTION Start_Date_Active(p_start_date_active IN DATE)RETURN BOOLEAN;
55 FUNCTION Term(p_term_id IN NUMBER)RETURN BOOLEAN;
56 
57 --Begin code added by rchellam for OKC
58 FUNCTION Agreement_Source(p_agreement_source_code IN VARCHAR2)RETURN BOOLEAN;
59 FUNCTION Orig_System_Agr(p_orig_system_agr_id IN NUMBER)RETURN BOOLEAN;
60 --End code added by rchellam for OKC
61 
62 -- Added for bug#4029589
63 FUNCTION Invoice_To_Customer_Id(p_invoice_to_customer_id IN NUMBER)RETURN BOOLEAN;
64 
65 FUNCTION Comments(p_comments IN VARCHAR2)RETURN BOOLEAN;
66 FUNCTION Currency(p_currency_code IN VARCHAR2)RETURN BOOLEAN;
67 FUNCTION Currency ( p_currency_code IN VARCHAR2,
68                     x_fmt_mask OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
69                     x_fmt_mask_ext OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
70 RETURN BOOLEAN;
71 FUNCTION Description(p_description IN VARCHAR2)RETURN BOOLEAN;
72 FUNCTION Program_Application(p_program_application_id IN NUMBER)RETURN BOOLEAN;
73 FUNCTION Program(p_program_id IN NUMBER)RETURN BOOLEAN;
74 FUNCTION Program_Update_Date(p_program_update_date IN DATE)RETURN BOOLEAN;
75 FUNCTION Request(p_request_id IN NUMBER)RETURN BOOLEAN;
76 FUNCTION Rounding_Factor(p_rounding_factor IN NUMBER)RETURN BOOLEAN;
77 FUNCTION Secondary_Price_List(p_secondary_price_list_id IN NUMBER)RETURN BOOLEAN;
78 FUNCTION Terms(p_terms_id IN NUMBER)RETURN BOOLEAN;
79 
80 FUNCTION Amount(p_amount IN NUMBER)RETURN BOOLEAN;
81 FUNCTION Automatic_Discount(p_automatic_discount_flag IN VARCHAR2)RETURN BOOLEAN;
82 FUNCTION Discount_Lines(p_discount_lines_flag IN VARCHAR2)RETURN BOOLEAN;
83 FUNCTION Discount_Type(p_discount_type_code IN VARCHAR2)RETURN BOOLEAN;
84 FUNCTION Gsa_Indicator(p_gsa_indicator IN VARCHAR2)RETURN BOOLEAN;
85 FUNCTION Manual_Discount(p_manual_discount_flag IN VARCHAR2)RETURN BOOLEAN;
86 FUNCTION Override_Allowed(p_override_allowed_flag IN VARCHAR2)RETURN BOOLEAN;
87 FUNCTION Percent(p_percent IN NUMBER)RETURN BOOLEAN;
88 FUNCTION Prorate(p_prorate_flag IN VARCHAR2)RETURN BOOLEAN;
89 
90 FUNCTION Customer_Item(p_customer_item_id IN NUMBER)RETURN BOOLEAN;
91 FUNCTION Inventory_Item(p_inventory_item_id IN NUMBER,
92                         p_organization_id IN NUMBER DEFAULT FND_API.G_MISS_NUM )RETURN BOOLEAN;
93 FUNCTION List_Price(p_list_price IN NUMBER)RETURN BOOLEAN;
94 FUNCTION Method(p_method_code IN VARCHAR2)RETURN BOOLEAN;
95 FUNCTION Price_List_Line(p_price_list_line_id IN NUMBER)RETURN BOOLEAN;
96 FUNCTION Pricing_Attribute1(p_pricing_attribute1 IN VARCHAR2)RETURN BOOLEAN;
97 FUNCTION Pricing_Attribute10(p_pricing_attribute10 IN VARCHAR2)RETURN BOOLEAN;
98 FUNCTION Pricing_Attribute11(p_pricing_attribute11 IN VARCHAR2)RETURN BOOLEAN;
99 FUNCTION Pricing_Attribute12(p_pricing_attribute12 IN VARCHAR2)RETURN BOOLEAN;
100 FUNCTION Pricing_Attribute13(p_pricing_attribute13 IN VARCHAR2)RETURN BOOLEAN;
101 FUNCTION Pricing_Attribute14(p_pricing_attribute14 IN VARCHAR2)RETURN BOOLEAN;
102 FUNCTION Pricing_Attribute15(p_pricing_attribute15 IN VARCHAR2)RETURN BOOLEAN;
103 FUNCTION Pricing_Attribute2(p_pricing_attribute2 IN VARCHAR2)RETURN BOOLEAN;
104 FUNCTION Pricing_Attribute3(p_pricing_attribute3 IN VARCHAR2)RETURN BOOLEAN;
105 FUNCTION Pricing_Attribute4(p_pricing_attribute4 IN VARCHAR2)RETURN BOOLEAN;
106 FUNCTION Pricing_Attribute5(p_pricing_attribute5 IN VARCHAR2)RETURN BOOLEAN;
107 FUNCTION Pricing_Attribute6(p_pricing_attribute6 IN VARCHAR2)RETURN BOOLEAN;
108 FUNCTION Pricing_Attribute7(p_pricing_attribute7 IN VARCHAR2)RETURN BOOLEAN;
109 FUNCTION Pricing_Attribute8(p_pricing_attribute8 IN VARCHAR2)RETURN BOOLEAN;
110 FUNCTION Pricing_Attribute9(p_pricing_attribute9 IN VARCHAR2)RETURN BOOLEAN;
111 FUNCTION Pricing_Context(p_pricing_context IN VARCHAR2)RETURN BOOLEAN;
112 FUNCTION Pricing_Rule(p_pricing_rule_id IN NUMBER)RETURN BOOLEAN;
113 FUNCTION Reprice(p_reprice_flag IN VARCHAR2)RETURN BOOLEAN;
114 FUNCTION Unit(p_unit_code IN VARCHAR2)RETURN BOOLEAN;
115 
116 FUNCTION Customer_Class(p_customer_class_code IN VARCHAR2)RETURN BOOLEAN;
117 FUNCTION Discount_Customer(p_discount_customer_id IN NUMBER)RETURN BOOLEAN;
118 /* FUNCTION Site_Use(p_site_use_id IN NUMBER)RETURN BOOLEAN; */
119 FUNCTION Site_Use(p_site_org_id IN NUMBER)RETURN BOOLEAN;
120 
121 FUNCTION Discount_Line(p_discount_line_id IN NUMBER)RETURN BOOLEAN;
122 FUNCTION Entity(p_entity_id IN NUMBER)RETURN BOOLEAN;
123 FUNCTION Entity_Value(p_entity_value IN VARCHAR2)RETURN BOOLEAN;
124 FUNCTION Price(p_price IN NUMBER)RETURN BOOLEAN;
125 
126 FUNCTION Method_Type(p_method_type_code IN VARCHAR2)RETURN BOOLEAN;
127 FUNCTION Price_Break_High(p_price_break_high IN NUMBER)RETURN BOOLEAN;
128 FUNCTION Price_Break_Low(p_price_break_low IN NUMBER)RETURN BOOLEAN;
129 
130 PROCEDURE getservitemflag(p_inventory_item_id IN NUMBER,
131                           p_organization_id IN NUMBER,
132                           x_unit_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
133                           x_service_item_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
134 
135 FUNCTION PRIMARY_EXISTS( p_price_list_id IN number,
136                          p_inventory_item_id IN number,
137                          p_customer_item_id IN number,
138                          p_pricing_attribute1 IN VARCHAR2,
139                          p_pricing_attribute2 IN VARCHAR2,
140                          p_pricing_attribute3 IN VARCHAR2,
141                          p_pricing_attribute4 IN VARCHAR2,
142                          p_pricing_attribute5 IN VARCHAR2,
143                          p_pricing_attribute6 IN VARCHAR2,
144                          p_pricing_attribute7 IN VARCHAR2,
145                          p_pricing_attribute8 IN VARCHAR2,
146                          p_pricing_attribute9 IN VARCHAR2,
147                          p_pricing_attribute10 IN VARCHAR2,
148                          p_pricing_attribute11 IN VARCHAR2,
149                          p_pricing_attribute12 IN VARCHAR2,
150                          p_pricing_attribute13 IN VARCHAR2,
151                          p_pricing_attribute14 IN VARCHAR2,
152                          p_pricing_attribute15 IN VARCHAR2,
153 			 p_start_date_active IN DATE,
154 			 p_end_date_active IN DATE
155                         ) RETURN BOOLEAN;
156 FUNCTION PRIMARY(p_primary IN VARCHAR2) RETURN BOOLEAN;
157 FUNCTION LIST_LINE_TYPE(p_list_line_type_code in VARCHAR2) RETURN BOOLEAN;
158 --  END GEN validate
159 
160 END OE_Validate_Attr;