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

Source


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