1 PACKAGE AHL_UC_VALIDATION_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPUCVS.pls 120.0.12020000.2 2012/12/10 16:30:48 prakkum ship $ */
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 -- SATHAPLI::Service Bulletin Effectivity, 03-May-2011, accept visit id too
59 p_visit_id IN NUMBER := NULL,
60 x_error_tbl OUT NOCOPY Error_Tbl_Type);
61
62 --------------------------------
63 -- Start of Comments --
64 -- Procedure name : Check_Completeness
65 -- Type : Private
66 -- Function : Check the unit's completeness and update
67 -- Complete/Incomplete status if current status is complete or incomplete..
68 -- Pre-reqs :
69 -- Parameters :
70 --
71 -- Check_Completeness Parameters:
72 -- p_unit_header_id IN NUMBER Required.
73 --
74 -- End of Comments.
75 /*#
76 * This API is used to check the completeness of a Unit.
77 * It also updates the status if current status is complete or in-complete.
78 * @param p_api_version Api Version Number
79 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
80 * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
81 * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
82 * @param x_return_status return status
83 * @param x_msg_count return message count
84 * @param x_msg_data return message data
85 * @param p_unit_header_id Header ID for the record
86 * @param x_evaluation_status Contains the result of the evaluation
87 * @rep:scope public
88 * @rep:lifecycle active
89 * @rep:displayname Check Unit Configuration Completeness
90 */
91 PROCEDURE Check_Completeness (
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
94 p_commit IN VARCHAR2 := FND_API.G_FALSE,
95 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_unit_header_id IN NUMBER,
100 x_evaluation_status OUT NOCOPY VARCHAR2);
101
102 --------------------------------
103 -- Start of Comments --
104 -- Procedure name : Validate_Complete_For_Pos
105 -- Type : Private
106 -- Function : Validates the unit's completeness and checks for ALL validations.
107 -- Pre-reqs :
108 -- Parameters :
109 --
110 -- Validate_Complete_For_Pos Parameters:
111 -- p_unit_header_id IN NUMBER Required.
112 -- p_csi_instance_id IN NUMBER Required.
113 -- x_error_tbl OUT NOCOPY AHL_MC_VALIDATION_PUB.error_tbl_Type Required
114 --
115 -- End of Comments.
116 /*#
117 * This API is used to Validate the completeness of a Unit.
118 * It also does other validations.
119 * @param p_api_version Api Version Number
120 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
121 * @param p_commit to decide whether to commit the transaction , default value FND_API.G_FALSE
122 * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
123 * @param x_return_status return status
124 * @param x_msg_count return message count
125 * @param x_msg_data return message data
126 * @param p_csi_instance_id Instance id
127 * @param x_error_tbl results of the validation of type AHL_MC_VALIDATION_PUB.error_tbl_Type
128 * @rep:scope public
129 * @rep:lifecycle active
130 * @rep:displayname Validate Complete for Positions
131 */
132 PROCEDURE Validate_Complete_For_Pos (
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
135 p_commit IN VARCHAR2 := FND_API.G_FALSE,
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_csi_instance_id IN NUMBER,
141 x_error_tbl OUT NOCOPY Error_Tbl_Type);
142
143
144 End AHL_UC_VALIDATION_PUB;