1 PACKAGE ENG_Validate AUTHID CURRENT_USER AS
2 /* $Header: ENGSVATS.pls 115.9 2002/11/22 10:13:55 akumar 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
21 FUNCTION Approval_Status_Type
22 ( p_approval_status_type IN NUMBER
23 , x_err_text OUT NOCOPY VARCHAR2
24 ) RETURN BOOLEAN;
25
26 FUNCTION Approval_Date
27 ( p_approval_date IN DATE
28 , x_err_text OUT NOCOPY VARCHAR2
29 ) RETURN BOOLEAN;
30
31 FUNCTION Approval_List
32 ( p_approval_list_id IN NUMBER
33 , x_err_text OUT NOCOPY VARCHAR2
34 )RETURN BOOLEAN;
35
36 FUNCTION Change_Order_Type
37 ( p_change_order_type_id IN NUMBER
38 , x_err_text OUT NOCOPY VARCHAR2
39 ) RETURN BOOLEAN;
40
41 FUNCTION Responsible_Org
42 ( p_responsible_org_id IN NUMBER
43 , p_current_org_id IN NUMBER
44 , x_err_text OUT NOCOPY VARCHAR2
45 ) RETURN BOOLEAN;
46
47 FUNCTION Approval_Request_Date
48 ( p_approval_request_date IN DATE
49 , x_err_text OUT NOCOPY VARCHAR2
50 ) RETURN BOOLEAN;
51
52 FUNCTION End_Item_Unit_Number
53 ( p_from_end_item_unit_number IN VARCHAR2
54 , p_revised_item_id IN NUMBER
55 , x_err_text OUT NOCOPY VARCHAR2
56 ) RETURN BOOLEAN;
57
58 FUNCTION Status_Type
59 ( p_status_type IN NUMBER
60 , x_err_text OUT NOCOPY VARCHAR2
61 ) RETURN BOOLEAN;
62 FUNCTION Initiation_Date
63 ( p_initiation_date IN DATE
64 , x_err_text OUT NOCOPY VARCHAR2
65 )RETURN BOOLEAN;
66
67 FUNCTION Implementation_Date
68 ( p_implementation_date IN DATE
69 , x_err_text OUT NOCOPY VARCHAR2
70 )RETURN BOOLEAN;
71
72 FUNCTION Cancellation_Date
73 ( p_cancellation_date IN DATE
74 , x_err_text OUT NOCOPY VARCHAR2
75 )RETURN BOOLEAN;
76
77 FUNCTION Priority ( p_priority_code IN VARCHAR2
78 , p_organization_id IN NUMBER
79 , x_disable_date OUT NOCOPY DATE
80 , x_err_text OUT NOCOPY VARCHAR2
81 )
82 RETURN BOOLEAN;
83
84 FUNCTION Reason ( p_reason_code IN VARCHAR2
85 , p_organization_id IN NUMBER
86 , x_disable_date OUT NOCOPY DATE
87 , x_err_text OUT NOCOPY VARCHAR2
88 )
89 RETURN BOOLEAN;
90
91 FUNCTION Disposition_Type
92 ( p_disposition_type IN NUMBER
93 , x_err_text OUT NOCOPY VARCHAR2
94 )RETURN BOOLEAN;
95
96 FUNCTION Mrp_Active
97 ( p_mrp_active IN NUMBER
98 , x_err_text OUT NOCOPY VARCHAR2
99 )RETURN BOOLEAN;
100
101 FUNCTION Update_Wip
102 ( p_update_wip IN NUMBER
103 , x_err_text OUT NOCOPY VARCHAR2
104 )RETURN BOOLEAN;
105
106 FUNCTION Use_Up
107 ( p_use_up IN NUMBER
108 , x_err_text OUT NOCOPY VARCHAR2
109 )RETURN BOOLEAN;
110
111 FUNCTION Use_Up_Plan_Name
112 ( p_use_up_plan_name IN VARCHAR2
113 , p_organization_id IN NUMBER
114 , x_err_text OUT NOCOPY VARCHAR2
115 )RETURN BOOLEAN;
116
117 FUNCTION Supply_Subinventory
118 ( p_supply_subinventory IN VARCHAR2
119 , p_organization_id IN NUMBER
120 , x_err_text OUT NOCOPY VARCHAR2
121 ) RETURN BOOLEAN;
122
123 FUNCTION Required_For_Revenue
124 ( p_required_for_revenue IN NUMBER
125 , x_err_text OUT NOCOPY VARCHAR2
126 )RETURN BOOLEAN;
127
128 FUNCTION Wip_Supply_Type( p_wip_supply_type IN NUMBER
129 , x_err_text OUT NOCOPY VARCHAR2
130 )RETURN BOOLEAN;
131
132 FUNCTION Item_Num( p_item_num IN NUMBER
133 , x_err_text OUT NOCOPY VARCHAR2
134 )RETURN BOOLEAN;
135
136 FUNCTION Component_Yield_Factor
137 ( p_component_yield_factor IN NUMBER
138 , x_err_text OUT NOCOPY VARCHAR2
139 ) RETURN BOOLEAN;
140
141 FUNCTION Effectivity_Date(p_effectivity_date IN DATE ,
142 p_revised_item_sequence_id IN NUMBER,
143 x_err_text OUT NOCOPY VARCHAR2 )RETURN BOOLEAN;
144
145 FUNCTION Disable_Date( p_disable_date IN DATE
146 , p_effectivity_date IN DATE
147 , x_err_text OUT NOCOPY VARCHAR2
148 )RETURN BOOLEAN;
149
150 FUNCTION Quantity_Related(p_quantity_related IN NUMBER ,
151 x_err_text OUT NOCOPY VARCHAR2 )RETURN BOOLEAN;
152
153 FUNCTION So_Basis(p_so_basis IN NUMBER
154 , x_err_text OUT NOCOPY VARCHAR2)RETURN BOOLEAN;
155
156 FUNCTION Optional(p_optional IN NUMBER ,
157 x_err_text OUT NOCOPY VARCHAR2 )RETURN BOOLEAN;
158
159 FUNCTION Mutually_Exclusive_Opt(p_mutually_exclusive_opt IN NUMBER ,
160 x_err_text OUT NOCOPY VARCHAR2
161 )RETURN BOOLEAN;
162
163 FUNCTION Include_In_Cost_Rollup(p_include_in_cost_rollup IN NUMBER ,
164 x_err_text OUT NOCOPY VARCHAR2
165 )RETURN BOOLEAN;
166
167 FUNCTION Check_Atp(p_check_atp IN NUMBER
168 , x_err_text OUT NOCOPY VARCHAR2
169 )RETURN BOOLEAN;
170
171 FUNCTION Shipping_Allowed(p_shipping_allowed IN NUMBER ,
172 x_err_text OUT NOCOPY VARCHAR2 )RETURN BOOLEAN;
173
174 FUNCTION Required_To_Ship(p_required_to_ship IN NUMBER ,
175 x_err_text OUT NOCOPY VARCHAR2 )RETURN BOOLEAN;
176
177 FUNCTION Include_On_Ship_Docs(p_include_on_ship_docs IN NUMBER ,
178 x_err_text OUT NOCOPY VARCHAR2
179 )RETURN BOOLEAN;
180 FUNCTION Acd_Type(p_acd_type IN NUMBER ,
181 x_err_text OUT NOCOPY VARCHAR2 )RETURN BOOLEAN;
182
183
184 /****************************************************************************
185 * Added by MK on 09/01/2000 for ECO New Effectivities
186 *****************************************************************************/
187 FUNCTION Check_RevCmp_In_ECO_By_WO
188 ( p_revised_item_sequence_id IN NUMBER
189 , p_rev_comp_item_id IN NUMBER
190 , p_operation_seq_num IN NUMBER)
191
192 RETURN BOOLEAN ;
193
194 -- Procedure Entity_Delete
195 PROCEDURE Check_Entity_Delete
196 ( x_return_status OUT NOCOPY VARCHAR2
197 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
198 , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
199 , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
200 );
201
202
203 END ENG_Validate;