[Home] [Help]
PACKAGE: APPS.MRP_VALIDATE_SHIPPING_ORG
Source
1 PACKAGE MRP_Validate_Shipping_Org AUTHID CURRENT_USER AS
2 /* $Header: MRPLSHOS.pls 120.1 2005/06/16 11:16:54 ichoudhu noship $ */
3
4 -- Procedure Entity
5
6 PROCEDURE Entity
7 ( x_return_status OUT NOCOPY VARCHAR2
8 , p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
9 , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type :=
10 MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_REC
11 );
12
13 -- Procedure Attributes
14
15 PROCEDURE Attributes
16 ( x_return_status OUT NOCOPY VARCHAR2
17 , p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
18 , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type :=
19 MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_REC
20 );
21
22 -- Procedure Entity_Delete
23
24 PROCEDURE Entity_Delete
25 ( x_return_status OUT NOCOPY VARCHAR2
26 , p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
27 );
28
29 -- Entity attribute validation functions.
30
31
32 -- Function Val_Allocation_Percent
33
34 FUNCTION Val_Allocation_Percent
35 ( p_Allocation_Percent IN NUMBER
36 ) RETURN BOOLEAN;
37
38 -- Function Val_Attribute1
39
40 FUNCTION Val_Attribute1
41 ( p_Attribute1 IN VARCHAR2
42 ) RETURN BOOLEAN;
43
44 -- Function Val_Attribute10
45
46 FUNCTION Val_Attribute10
47 ( p_Attribute10 IN VARCHAR2
48 ) RETURN BOOLEAN;
49
50 -- Function Val_Attribute11
51
52 FUNCTION Val_Attribute11
53 ( p_Attribute11 IN VARCHAR2
54 ) RETURN BOOLEAN;
55
56 -- Function Val_Attribute12
57
58 FUNCTION Val_Attribute12
59 ( p_Attribute12 IN VARCHAR2
60 ) RETURN BOOLEAN;
61
62 -- Function Val_Attribute13
63
64 FUNCTION Val_Attribute13
65 ( p_Attribute13 IN VARCHAR2
66 ) RETURN BOOLEAN;
67
68 -- Function Val_Attribute14
69
70 FUNCTION Val_Attribute14
71 ( p_Attribute14 IN VARCHAR2
72 ) RETURN BOOLEAN;
73
74 -- Function Val_Attribute15
75
76 FUNCTION Val_Attribute15
77 ( p_Attribute15 IN VARCHAR2
78 ) RETURN BOOLEAN;
79
80 -- Function Val_Attribute2
81
82 FUNCTION Val_Attribute2
83 ( p_Attribute2 IN VARCHAR2
84 ) RETURN BOOLEAN;
85
86 -- Function Val_Attribute3
87
88 FUNCTION Val_Attribute3
89 ( p_Attribute3 IN VARCHAR2
90 ) RETURN BOOLEAN;
91
92 -- Function Val_Attribute4
93
94 FUNCTION Val_Attribute4
95 ( p_Attribute4 IN VARCHAR2
96 ) RETURN BOOLEAN;
97
98 -- Function Val_Attribute5
99
100 FUNCTION Val_Attribute5
101 ( p_Attribute5 IN VARCHAR2
102 ) RETURN BOOLEAN;
103
104 -- Function Val_Attribute6
105
106 FUNCTION Val_Attribute6
107 ( p_Attribute6 IN VARCHAR2
108 ) RETURN BOOLEAN;
109
110 -- Function Val_Attribute7
111
112 FUNCTION Val_Attribute7
113 ( p_Attribute7 IN VARCHAR2
114 ) RETURN BOOLEAN;
115
116 -- Function Val_Attribute8
117
118 FUNCTION Val_Attribute8
119 ( p_Attribute8 IN VARCHAR2
120 ) RETURN BOOLEAN;
121
122 -- Function Val_Attribute9
123
124 FUNCTION Val_Attribute9
125 ( p_Attribute9 IN VARCHAR2
126 ) RETURN BOOLEAN;
127
128 -- Function Val_Attribute_Category
129
130 FUNCTION Val_Attribute_Category
131 ( p_Attribute_Category IN VARCHAR2
132 ) RETURN BOOLEAN;
133
134 -- Function Val_Created_By
135
136 FUNCTION Val_Created_By
137 ( p_Created_By IN NUMBER
138 ) RETURN BOOLEAN;
139
140 -- Function Val_Creation_Date
141
142 FUNCTION Val_Creation_Date
143 ( p_Creation_Date IN DATE
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_Program_Application_Id
165
166 FUNCTION Val_Program_Application_Id
167 ( p_Program_Application_Id IN NUMBER
168 ) RETURN BOOLEAN;
169
170 -- Function Val_Program_Id
171
172 FUNCTION Val_Program_Id
173 ( p_Program_Id IN NUMBER
174 ) RETURN BOOLEAN;
175
176 -- Function Val_Program_Update_Date
177
178 FUNCTION Val_Program_Update_Date
179 ( p_Program_Update_Date IN DATE
180 ) RETURN BOOLEAN;
181
182 -- Function Val_Rank
183
184 FUNCTION Val_Rank
185 ( p_Rank IN NUMBER
186 ) RETURN BOOLEAN;
187
188 -- Function Val_Request_Id
189
190 FUNCTION Val_Request_Id
191 ( p_Request_Id IN NUMBER
192 ) RETURN BOOLEAN;
193
194 -- Function Val_Secondary_Inventory
195
196 FUNCTION Val_Secondary_Inventory
197 ( p_Secondary_Inventory IN VARCHAR2
198 ) RETURN BOOLEAN;
199
200 -- Function Val_Ship_Method
201
202 FUNCTION Val_Ship_Method
203 ( p_sr_receipt_id IN NUMBER
204 , p_source_organization_id IN NUMBER
205 , p_Ship_Method IN VARCHAR2
206 ) RETURN BOOLEAN;
207
208 -- Function Val_Source_Organization_Id
209
210 FUNCTION Val_Source_Organization_Id
211 ( p_Source_Organization_Id IN NUMBER
212 ) RETURN BOOLEAN;
213
214 -- Function Val_Source_Type
215
216 FUNCTION Val_Source_Type
217 ( p_Source_Type IN NUMBER
218 ) RETURN BOOLEAN;
219
220 -- Function Val_Sr_Receipt_Id
221
222 FUNCTION Val_Sr_Receipt_Id
223 ( p_Sr_Receipt_Id IN NUMBER
224 ) RETURN BOOLEAN;
225
226 -- Function Val_Vendor_Id
227
228 FUNCTION Val_Vendor_Id
229 ( p_Vendor_Id IN NUMBER
230 ) RETURN BOOLEAN;
231
232 -- Function Val_Vendor_Site_Id
233
234 FUNCTION Val_Vendor_Site_Id
235 ( p_Vendor_Id IN NUMBER
236 , p_Vendor_Site_Id IN NUMBER
237 ) RETURN BOOLEAN;
238
239 END MRP_Validate_Shipping_Org;