PACKAGE: APPS.MRP_VALIDATE_SOURCING_RULE

Source

1 PACKAGE MRP_Validate_Sourcing_Rule AUTHID CURRENT_USER AS
2 /* $Header: MRPLSRLS.pls 120.1 2005/06/16 11:41:37 ichoudhu noship $ */
3 
4 --  Procedure Entity
5 
6 PROCEDURE Entity
7 (   x_return_status                 OUT NOCOPY VARCHAR2
8 ,   p_Sourcing_Rule_rec             IN  MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
9 ,   p_old_Sourcing_Rule_rec         IN  MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
10                                         MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
11 );
12 
13 --  Procedure Attributes
14 
15 PROCEDURE Attributes
16 (   x_return_status                 OUT NOCOPY VARCHAR2
17 ,   p_Sourcing_Rule_rec             IN  MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
18 ,   p_old_Sourcing_Rule_rec         IN  MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
19                                         MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
20 );
21 
22 --  Procedure Entity_Delete
23 
24 PROCEDURE Entity_Delete
25 (   x_return_status                 OUT NOCOPY VARCHAR2
26 ,   p_Sourcing_Rule_rec             IN  MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
27 );
28 
29 --  Entity attribute validation functions.
30 
31 
32 --  Function Val_Attribute1
33 
34 FUNCTION Val_Attribute1
35 (   p_Attribute1                    IN  VARCHAR2
36 )   RETURN BOOLEAN;
37 
38 --  Function Val_Attribute10
39 
40 FUNCTION Val_Attribute10
41 (   p_Attribute10                   IN  VARCHAR2
42 )   RETURN BOOLEAN;
43 
44 --  Function Val_Attribute11
45 
46 FUNCTION Val_Attribute11
47 (   p_Attribute11                   IN  VARCHAR2
48 )   RETURN BOOLEAN;
49 
50 --  Function Val_Attribute12
51 
52 FUNCTION Val_Attribute12
53 (   p_Attribute12                   IN  VARCHAR2
54 )   RETURN BOOLEAN;
55 
56 --  Function Val_Attribute13
57 
58 FUNCTION Val_Attribute13
59 (   p_Attribute13                   IN  VARCHAR2
60 )   RETURN BOOLEAN;
61 
62 --  Function Val_Attribute14
63 
64 FUNCTION Val_Attribute14
65 (   p_Attribute14                   IN  VARCHAR2
66 )   RETURN BOOLEAN;
67 
68 --  Function Val_Attribute15
69 
70 FUNCTION Val_Attribute15
71 (   p_Attribute15                   IN  VARCHAR2
72 )   RETURN BOOLEAN;
73 
74 --  Function Val_Attribute2
75 
76 FUNCTION Val_Attribute2
77 (   p_Attribute2                    IN  VARCHAR2
78 )   RETURN BOOLEAN;
79 
80 --  Function Val_Attribute3
81 
82 FUNCTION Val_Attribute3
83 (   p_Attribute3                    IN  VARCHAR2
84 )   RETURN BOOLEAN;
85 
86 --  Function Val_Attribute4
87 
88 FUNCTION Val_Attribute4
89 (   p_Attribute4                    IN  VARCHAR2
90 )   RETURN BOOLEAN;
91 
92 --  Function Val_Attribute5
93 
94 FUNCTION Val_Attribute5
95 (   p_Attribute5                    IN  VARCHAR2
96 )   RETURN BOOLEAN;
97 
98 --  Function Val_Attribute6
99 
100 FUNCTION Val_Attribute6
101 (   p_Attribute6                    IN  VARCHAR2
102 )   RETURN BOOLEAN;
103 
104 --  Function Val_Attribute7
105 
106 FUNCTION Val_Attribute7
107 (   p_Attribute7                    IN  VARCHAR2
108 )   RETURN BOOLEAN;
109 
110 --  Function Val_Attribute8
111 
112 FUNCTION Val_Attribute8
113 (   p_Attribute8                    IN  VARCHAR2
114 )   RETURN BOOLEAN;
115 
116 --  Function Val_Attribute9
117 
118 FUNCTION Val_Attribute9
119 (   p_Attribute9                    IN  VARCHAR2
120 )   RETURN BOOLEAN;
121 
122 --  Function Val_Attribute_Category
123 
124 FUNCTION Val_Attribute_Category
125 (   p_Attribute_Category            IN  VARCHAR2
126 )   RETURN BOOLEAN;
127 
128 --  Function Val_Created_By
129 
130 FUNCTION Val_Created_By
131 (   p_Created_By                    IN  NUMBER
132 )   RETURN BOOLEAN;
133 
134 --  Function Val_Creation_Date
135 
136 FUNCTION Val_Creation_Date
137 (   p_Creation_Date                 IN  DATE
138 )   RETURN BOOLEAN;
139 
140 --  Function Val_Description
141 
142 FUNCTION Val_Description
143 (   p_Description                   IN  VARCHAR2
144 )   RETURN BOOLEAN;
145 
146 --  Function Val_Last_Updated_By
147 
148 FUNCTION Val_Last_Updated_By
149 (   p_Last_Updated_By               IN  NUMBER
150 )   RETURN BOOLEAN;
151 
152 --  Function Val_Last_Update_Date
153 
154 FUNCTION Val_Last_Update_Date
155 (   p_Last_Update_Date              IN  DATE
156 )   RETURN BOOLEAN;
157 
158 --  Function Val_Last_Update_Login
159 
160 FUNCTION Val_Last_Update_Login
161 (   p_Last_Update_Login             IN  NUMBER
162 )   RETURN BOOLEAN;
163 
164 --  Function Val_Organization_Id
165 
166 FUNCTION Val_Organization_Id
167 (   p_Organization_Id               IN  NUMBER
168 )   RETURN BOOLEAN;
169 
170 --  Function Val_Planning_Active
171 
172 FUNCTION Val_Planning_Active
173 (   p_Planning_Active               IN  NUMBER
174 )   RETURN BOOLEAN;
175 
176 --  Function Val_Program_Application_Id
177 
178 FUNCTION Val_Program_Application_Id
179 (   p_Program_Application_Id        IN  NUMBER
180 )   RETURN BOOLEAN;
181 
182 --  Function Val_Program_Id
183 
184 FUNCTION Val_Program_Id
185 (   p_Program_Id                    IN  NUMBER
186 )   RETURN BOOLEAN;
187 
188 --  Function Val_Program_Update_Date
189 
190 FUNCTION Val_Program_Update_Date
191 (   p_Program_Update_Date           IN  DATE
192 )   RETURN BOOLEAN;
193 
194 --  Function Val_Request_Id
195 
196 FUNCTION Val_Request_Id
197 (   p_Request_Id                    IN  NUMBER
198 )   RETURN BOOLEAN;
199 
200 --  Function Val_Sourcing_Rule_Name
201 
202 FUNCTION Val_Sourcing_Rule_Name
203 (   p_Sourcing_Rule_Name            IN  VARCHAR2
204 , p_organization_id                 IN  NUMBER
205 )   RETURN BOOLEAN;
206 
207 --  Function Val_Sourcing_Rule_Type
208 
209 FUNCTION Val_Sourcing_Rule_Type
210 (   p_Sourcing_Rule_Type            IN  NUMBER
211 )   RETURN BOOLEAN;
212 
213 --  Function Val_Status
214 
215 FUNCTION Val_Status
216 (   p_Status                        IN  NUMBER
217 )   RETURN BOOLEAN;
218 
219 END MRP_Validate_Sourcing_Rule;