1 PACKAGE AHL_UC_POS_NECES_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVNECS.pls 120.1 2007/12/21 13:30:26 sathapli ship $ */
3
4
5 -----------------------------------------------------------------------------
6 -- Start of Comments --
7 --
8 -- Procedure name : List_Extra_Nodes
9 -- Type : Private
10 -- Function : List all the nodes in the unit configuration which are extra.
11 -- i.e. with no corresponding position reference
12 -- Pre-reqs :
13 --
14 -- Standard IN Parameters :
15 -- p_api_version IN NUMBER Required
16 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
17 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
18 -- Standard OUT Parameters :
19 -- x_return_status OUT VARCHAR2 Required
20 -- x_msg_count OUT NUMBER Required
21 -- x_msg_data OUT VARCHAR2 Required
22 --
23 -- List_Extra_Nodes parameters :
24 -- p_uc_header_id IN NUMBER
25 -- The header id of the unit configuration
26 -- p_csi_instance_id IN NUMBER
27 -- If header id is null, then use p_csi_instance_id
28 -- x_evaluation_status OUT VARCHAR2
29 -- The flag which indicates whether the unit has extra nodes or not.
30 -- p_x_error_table IN OUT AHL_UC_POS_NECES_PVT.Error_Tbl_Type
31 -- An output table with the list of all the extra nodes.
32 -- History:
33 -- 05/19/03 SBethi CREATED
34 --
35 -- Version :
36 -- Initial Version 1.0
37 --
38 -- End of Comments.
39 --------------------------------------------------------------------------------------------
40
41 PROCEDURE List_Extra_Nodes(
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
44 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 p_uc_header_id IN NUMBER,
49 p_csi_instance_id IN NUMBER,
50 p_x_error_table IN OUT NOCOPY AHL_UC_VALIDATION_PUB.Error_Tbl_Type,
51 x_evaluation_status OUT NOCOPY VARCHAR2
52 );
53
54 --------------------------------------------------------------------------------------------
55 -- Start of Comments --
56 --
57 -- Procedure name : Check_Extra_Nodes
58 -- Type : Private
59 -- Function : Checks if there are any extra nodes in a unit configuration.
60 -- Pre-reqs :
61 --
62 -- Standard IN Parameters :
63 -- p_api_version IN NUMBER Required
64 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
65 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
66 -- Standard OUT Parameters :
67 -- x_return_status OUT VARCHAR2 Required
68 -- x_msg_count OUT NUMBER Required
69 -- x_msg_data OUT VARCHAR2 Required
70 --
71 -- check_extra_nodes parameters :
72 -- p_uc_header_id IN Required
73 -- The header id of the unit configuration
74 -- x_evaluation_status OUT VARCHAR2
75 -- The flag which indicates whether the unit configuration
76 -- has any extra nodes and returns 'T' ot 'F' accordingly.
77 -- History:
78 -- 05/19/03 SBethi CREATED
79 --
80 -- Version :
81 -- Initial Version 1.0
82 --
83 -- End of Comments.
84 --------------------------------------------------------------------------------------------
85
86 PROCEDURE Check_Extra_Nodes(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
89 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_uc_header_id IN NUMBER,
94 x_evaluation_status OUT NOCOPY VARCHAR2
95 );
96
97 --------------------------------------------------------------------------------------------
98 -- Start of Comments --
99 --
100 -- Procedure name : List_Missing_Positions
101 -- Type : Private
102 -- Function : List all the mandatory positions that dont have instances mapped to it.
103 -- Pre-reqs :
104 --
105 -- Standard IN Parameters :
106 -- p_api_version IN NUMBER Required
107 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
108 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
109 -- Standard OUT Parameters :
110 -- x_return_status OUT VARCHAR2 Required
111 -- x_msg_count OUT NUMBER Required
112 -- x_msg_data OUT VARCHAR2 Required
113 --
114 -- list_missing_positions parameters :
115 -- p_uc_header_id IN NUMBER
116 -- The header id of the unit configuration
117 -- p_csi_instance_id IN NUMBER
118 -- If header id is null, then use p_csi_instance_id
119 -- x_evaluation_status OUT VARCHAR2
120 -- The flag which indicates whether the unit has any
121 -- missing positions
122 -- p_x_error_table IN OUT lists all the error messages in a table.
123 --
124 -- History:
125 -- 05/19/03 SBethi CREATED
126 --
127 -- Version :
128 -- Initial Version 1.0
129 --
130 -- End of Comments.
131 --------------------------------------------------------------------------------------------
132
133 PROCEDURE List_Missing_Positions(
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
136 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_uc_header_id IN NUMBER,
141 p_csi_instance_id IN NUMBER,
142 p_x_error_table IN OUT NOCOPY AHL_UC_VALIDATION_PUB.Error_Tbl_Type,
143 x_evaluation_status OUT NOCOPY VARCHAR2
144 );
145
146
147 --------------------------------------------------------------------------------------------
148 -- Start of Comments --
149 --
150 -- Procedure name : Check_Missing_Positions
151 -- Type : Private
152 -- Function : checks if the unit config has any mandatory
153 -- positions with no instances installed.
154 -- Pre-reqs :
155 --
156 -- Standard IN Parameters :
157 -- p_api_version IN NUMBER Required
158 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
159 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
160 -- Standard OUT Parameters :
161 -- x_return_status OUT VARCHAR2 Required
162 -- x_msg_count OUT NUMBER Required
163 -- x_msg_data OUT VARCHAR2 Required
164 --
165 -- list_missing_positions parameters :
166 -- p_uc_header_id IN Required
167 -- The header id of the unit configuration
168 -- x_evaluation_status OUT VARCHAR2
169 -- The flag which indicates whether the unit configuration
170 -- has any missing positions and returns 'T' ot 'F' accordingly.
171 -- History:
172 -- 05/19/03 SBethi CREATED
173 --
174 -- Version :
175 -- Initial Version 1.0
176 --
177 -- End of Comments.
178 --------------------------------------------------------------------------------------------
179
180 PROCEDURE Check_Missing_Positions(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
183 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_uc_header_id IN NUMBER,
188 x_evaluation_status OUT NOCOPY VARCHAR2
189 );
190
191 --------------------------------------------------------------------------------------------
192 -- Start of Comments --
193 --
194 -- Procedure name : Validate_Position_Quantities
195 -- Type : Private
196 -- Function : This procedure was added for the FP OGMA Issue 105 to support Non Serialized Items.
197 -- It validates the instance quantity against the position/item group.
198 -- If there is a Quantity type rule at the Parent position, the floor validation
199 -- is not done (Only ceiling validation is done). Since in this case the Rule
200 -- overrides and obviates any need for Quantity validation and validating quantity
201 -- based on position may actually contradict the rule.
202 --
203 -- Pre-reqs
204 --
205 -- Standard IN Parameters :
206 -- p_api_version IN NUMBER Required
207 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
208 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
209 -- Standard OUT Parameters :
210 -- x_return_status OUT VARCHAR2 Required
211 -- x_msg_count OUT NUMBER Required
212 -- x_msg_data OUT VARCHAR2 Required
213 --
214 -- Validate_Position_Quantities Parameters :
215 -- p_uc_header_id IN NUMBER Conditionally Required
216 -- The header id of the unit configuration. Not required if p_csi_instance_id is given.
217 -- p_csi_instance_id IN NUMBER Conditionally Required
218 -- The instance where the Quantity needs to be checked. Not required if p_uc_header_id is given.
219 -- x_evaluation_status OUT VARCHAR2 The flag which indicates whether the unit has any Quantity mismatch.
220 -- p_x_error_table IN OUT AHL_UC_POS_NECES_PVT.Error_Tbl_Type
221 -- The output table with the list of Quantity based validation failures
222 --
223 -- History:
224 -- 05-Dec-2007 SATHAPLI Created
225 --
226 -- Version:
227 -- Initial Version 1.0
228 --
229 -- End of Comments.
230 --------------------------------------------------------------------------------------------
231
232 PROCEDURE Validate_Position_Quantities(
233 p_api_version IN NUMBER,
234 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
235 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 p_uc_header_id IN NUMBER,
240 p_csi_instance_id IN NUMBER,
241 p_x_error_table IN OUT NOCOPY AHL_UC_VALIDATION_PUB.Error_Tbl_Type,
242 x_evaluation_status OUT NOCOPY VARCHAR2);
243
244 --------------------------------------------------------------------------------------------
245 -- Start of Comments --
246 --
247 -- Procedure name : Check_Position_Quantities
248 -- Type : Private
249 -- Function : This procedure was added for the FP OGMA Issue 105 to support Non Serialized Items.
250 -- It checks the instance quantity against the position/item group.
251 -- If there is a Quantity type rule at the Parent position, the floor check
252 -- is not done (Only ceiling check is done). Since in this case the Rule
253 -- overrides and obviates any need for Quantity check and checking quantity
254 -- based on position may actually contradict the rule.
255 --
256 -- Pre-reqs
257 --
258 -- Standard IN Parameters :
259 -- p_api_version IN NUMBER Required
260 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
261 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
262 -- Standard OUT Parameters :
263 -- x_return_status OUT VARCHAR2 Required
264 -- x_msg_count OUT NUMBER Required
265 -- x_msg_data OUT VARCHAR2 Required
266 --
267 -- Check_Position_Quantities Parameters :
268 -- p_uc_header_id IN NUMBER Required
269 -- The header id of the unit configuration.
270 -- x_evaluation_status OUT VARCHAR2 The OUT flag which indicates whether the unit has any Quantity mismatch.
271 --
272 -- History:
273 -- 05-Dec-2007 SATHAPLI Created
274 --
275 -- Version:
276 -- Initial Version 1.0
277 --
278 -- End of Comments.
279 --------------------------------------------------------------------------------------------
280
281 PROCEDURE Check_Position_Quantities(
282 p_api_version IN NUMBER,
283 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
284 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285 x_return_status OUT NOCOPY VARCHAR2,
286 x_msg_count OUT NOCOPY NUMBER,
287 x_msg_data OUT NOCOPY VARCHAR2,
288 p_uc_header_id IN NUMBER,
289 x_evaluation_status OUT NOCOPY VARCHAR2);
290
291 END AHL_UC_POS_NECES_PVT; -- Package spec