1 PACKAGE AHL_UC_VALIDATION_PUB AS
2 /* $Header: AHLPUCVS.pls 120.0 2005/05/26 01:26:10 appldev noship $ */
3 /*#
4 * This package provides the APIs for validating a Unit Configuration.
5 * @rep:scope public
6 * @rep:product AHL
7 * @rep:displayname Unit Configuration Validation
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY AHL_UNIT_CONFIG
10 */
11
12 ---------------------------------
13 -- Define Table Type for Node --
14 ---------------------------------
15 TYPE Error_Tbl_Type IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
16
17 ------------------------
18 -- Declare Procedures --
19 ------------------------
20 --------------------------------
21 -- Start of Comments --
22 -- Procedure name : Validate_Completeness
23 -- Type : Private
24 -- Function : Validates the unit's completeness and checks for ALL validations.
25 -- Pre-reqs :
26 -- Parameters :
27 --
28 -- Validate_Completeness Parameters:
29 -- p_unit_header_id IN NUMBER Required.
30 -- x_error_tbl OUT NOCOPY AHL_MC_VALIDATION_PUB.error_tbl_Type Required
31 --
32 -- End of Comments.
33 /*#
34 * This API is used to validate the Unit's completeness.
35 * Does perform other validations also.
36 * @param p_api_version Api Version Number
37 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
38 * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
39 * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
40 * @param x_return_status return status
41 * @param x_msg_count return message count
42 * @param x_msg_data return message data
43 * @param p_unit_header_id Header ID for the record
44 * @param x_error_tbl Record of the type AHL_MC_VALIDATION_PUB.error_tbl_Type Required
45 * @rep:scope public
46 * @rep:lifecycle active
47 * @rep:displayname Validate Unit Configuration Completeness
48 */
49 PROCEDURE Validate_Completeness (
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52 p_commit IN VARCHAR2 := FND_API.G_FALSE,
53 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 p_unit_header_id IN NUMBER,
58 x_error_tbl OUT NOCOPY Error_Tbl_Type);
59
60 --------------------------------
61 -- Start of Comments --
62 -- Procedure name : Check_Completeness
63 -- Type : Private
64 -- Function : Check the unit's completeness and update
65 -- Complete/Incomplete status if current status is complete or incomplete..
66 -- Pre-reqs :
67 -- Parameters :
68 --
69 -- Check_Completeness Parameters:
70 -- p_unit_header_id IN NUMBER Required.
71 --
72 -- End of Comments.
73 /*#
74 * This API is used to check the completeness of a Unit.
75 * It also updates the status if current status is complete or in-complete.
76 * @param p_api_version Api Version Number
77 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
78 * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
79 * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
80 * @param x_return_status return status
81 * @param x_msg_count return message count
82 * @param x_msg_data return message data
83 * @param p_unit_header_id Header ID for the record
84 * @param x_evaluation_status Contains the result of the evaluation
85 * @rep:scope public
86 * @rep:lifecycle active
87 * @rep:displayname Check Unit Configuration Completeness
88 */
89 PROCEDURE Check_Completeness (
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92 p_commit IN VARCHAR2 := FND_API.G_FALSE,
93 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 p_unit_header_id IN NUMBER,
98 x_evaluation_status OUT NOCOPY VARCHAR2);
99
100 --------------------------------
101 -- Start of Comments --
102 -- Procedure name : Validate_Complete_For_Pos
103 -- Type : Private
104 -- Function : Validates the unit's completeness and checks for ALL validations.
105 -- Pre-reqs :
106 -- Parameters :
107 --
108 -- Validate_Complete_For_Pos Parameters:
109 -- p_unit_header_id IN NUMBER Required.
110 -- p_csi_instance_id IN NUMBER Required.
111 -- x_error_tbl OUT NOCOPY AHL_MC_VALIDATION_PUB.error_tbl_Type Required
112 --
113 -- End of Comments.
114 /*#
115 * This API is used to Validate the completeness of a Unit.
116 * It also does other validations.
117 * @param p_api_version Api Version Number
118 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
119 * @param p_commit to decide whether to commit the transaction , default value FND_API.G_FALSE
120 * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
121 * @param x_return_status return status
122 * @param x_msg_count return message count
123 * @param x_msg_data return message data
124 * @param p_csi_instance_id Instance id
125 * @param x_error_tbl results of the validation of type AHL_MC_VALIDATION_PUB.error_tbl_Type
126 * @rep:scope public
127 * @rep:lifecycle active
128 * @rep:displayname Validate Complete for Positions
129 */
130 PROCEDURE Validate_Complete_For_Pos (
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133 p_commit IN VARCHAR2 := FND_API.G_FALSE,
134 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_csi_instance_id IN NUMBER,
139 x_error_tbl OUT NOCOPY Error_Tbl_Type);
140
141
142 End AHL_UC_VALIDATION_PUB;