[Home] [Help]
PACKAGE: APPS.MRP_VALIDATE_RECEIVING_ORG
Source
1 PACKAGE MRP_Validate_Receiving_Org AUTHID CURRENT_USER AS
2 /* $Header: MRPLRCOS.pls 120.1 2005/06/16 10:17:39 ichoudhu noship $ */
3
4 -- Procedure Entity
5
6 PROCEDURE Entity
7 ( x_return_status OUT NOCOPY VARCHAR2
8 , p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
9 , p_old_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type :=
10 MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_REC
11 );
12
13 -- Procedure Attributes
14
15 PROCEDURE Attributes
16 ( x_return_status OUT NOCOPY VARCHAR2
17 , p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
18 , p_old_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type :=
19 MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_REC
20 );
21
22 -- Procedure Entity_Delete
23
24 PROCEDURE Entity_Delete
25 ( x_return_status OUT NOCOPY VARCHAR2
26 , p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_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_Disable_Date
141
142 FUNCTION Val_Disable_Date
143 ( p_Effective_Date IN DATE
144 , p_Disable_Date IN DATE
145 ) RETURN BOOLEAN;
146
147 -- Function Val_Effective_Date
148
149 FUNCTION Val_Effective_Date
150 ( p_Effective_Date IN DATE
151 ) RETURN BOOLEAN;
152
153 -- Function Val_Last_Updated_By
154
155 FUNCTION Val_Last_Updated_By
156 ( p_Last_Updated_By IN NUMBER
157 ) RETURN BOOLEAN;
158
159 -- Function Val_Last_Update_Date
160
161 FUNCTION Val_Last_Update_Date
162 ( p_Last_Update_Date IN DATE
163 ) RETURN BOOLEAN;
164
165 -- Function Val_Last_Update_Login
166
167 FUNCTION Val_Last_Update_Login
168 ( p_Last_Update_Login IN NUMBER
169 ) RETURN BOOLEAN;
170
171 -- Function Val_Program_Application_Id
172
173 FUNCTION Val_Program_Application_Id
174 ( p_Program_Application_Id IN NUMBER
175 ) RETURN BOOLEAN;
176
177 -- Function Val_Program_Id
178
179 FUNCTION Val_Program_Id
180 ( p_Program_Id IN NUMBER
181 ) RETURN BOOLEAN;
182
183 -- Function Val_Program_Update_Date
184
185 FUNCTION Val_Program_Update_Date
186 ( p_Program_Update_Date IN DATE
187 ) RETURN BOOLEAN;
188
189 -- Function Val_Receipt_Organization_Id
190
191 FUNCTION Val_Receipt_Organization_Id
192 ( p_Sourcing_Rule_Id IN NUMBER
193 , p_Receipt_Organization_Id IN NUMBER
194 ) RETURN BOOLEAN;
195
196 -- Function Val_Request_Id
197
198 FUNCTION Val_Request_Id
199 ( p_Request_Id IN NUMBER
200 ) RETURN BOOLEAN;
201
202 -- Function Val_Sourcing_Rule_Id
203
204 FUNCTION Val_Sourcing_Rule_Id
205 ( p_Sourcing_Rule_Id IN NUMBER
206 ) RETURN BOOLEAN;
207
208 END MRP_Validate_Receiving_Org;