1 PACKAGE CS_COUNTERS_EXT_PVT AS
2 /* $Header: csxvctes.pls 120.1 2005/07/25 14:03:12 appldev ship $ */
3
4 -- ---------------------------------------------------------
5 -- Declare Data Types
6 -- ---------------------------------------------------------
7 TYPE DFF_Rec_Type IS RECORD
8 (
9 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
10 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
11 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
25 );
26
27 -- *******************************************************
28 -- Start of Comments
29 -- *******************************************************
30 -- API Name: VALIDATE_FORMULA_CTR
31 -- Type : Private
32 -- Pre-Req : None
33 -- Parameters:
34 -- IN
35 -- p_api_version_number IN NUMBER Required
36 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
37 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
38 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
39 -- p_counter_id IN NUMBER Required
40 --
41 -- OUT:
42 -- x_return_status OUT VARCHAR2
43 -- x_msg_count OUT NUMBER
44 -- x_msg_data OUT VARCHAR2
45 -- x_valid_flag OUT VARCHAR2 Returns 'Y' or 'N'
46 --
47 -- Version : Current version 1.0
48 -- Description :
49 -- This API is used to check if counter formula is valid and has all the bind variable available.
50 -- This API tries to compute formula value with default value 100 for each bind variable
51 -- End of Comments
52 --
53 PROCEDURE VALIDATE_FORMULA_CTR
54 (
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
58 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_counter_id IN NUMBER,
63 x_valid_flag OUT NOCOPY VARCHAR2
64 );
65
66 -- *******************************************************
67 -- Start of Comments
68 -- *******************************************************
69 -- API Name: VALIDATE_GRPOP_CTR
70 -- Type : Private
71 -- Pre-Req : None
72 -- Parameters:
73 -- IN
74 -- p_api_version_number IN NUMBER Required
75 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
76 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
77 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
78 -- p_counter_id IN NUMBER Required
79 --
80 -- OUT:
81 -- x_return_status OUT VARCHAR2
82 -- x_msg_count OUT NUMBER
83 -- x_msg_data OUT VARCHAR2
84 -- x_valid_flag OUT VARCHAR2 Returns 'Y' or 'N'
85 --
86 -- Version : Current version 1.0
87 -- Description :
88 -- This API is used to check if group operation counter is valid and filters have correct syntex.
89 -- This API tries to compute group operation counter with dummy values if it successfully computes the
90 -- value then returns valid = 'Y' else returns 'N'.
91 -- End of Comments
92 --
93 PROCEDURE VALIDATE_GRPOP_CTR
94 (
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
97 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_counter_id IN NUMBER,
103 x_valid_flag OUT NOCOPY VARCHAR2
104 );
105
106 PROCEDURE Check_Reqd_Param
107 (
108 p_var1 IN NUMBER,
109 p_param_name IN VARCHAR2,
110 p_api_name IN VARCHAR2
111 );
112
113
114 PROCEDURE Check_Reqd_Param
115 (
116 p_var1 IN VARCHAR2,
117 p_param_name IN VARCHAR2,
118 p_api_name IN VARCHAR2
119 );
120
121
122 PROCEDURE Check_Reqd_Param
123 (
124 p_var1 IN DATE,
125 p_param_name IN VARCHAR2,
126 p_api_name IN VARCHAR2
127 );
128
129 FUNCTION Is_StartEndDate_Valid
130 (
131 p_st_dt IN DATE,
132 p_end_dt IN DATE,
133 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
134 ) RETURN BOOLEAN;
135
136 FUNCTION Is_Flag_YorNorNull
137 (
138 p_flag IN VARCHAR2,
139 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
140 ) RETURN BOOLEAN;
141
142 PROCEDURE Is_DescFlex_Valid
143 (
144 p_api_name IN VARCHAR2,
145 p_appl_short_name IN VARCHAR2 := 'CS',
146 p_desc_flex_name IN VARCHAR2,
147 p_seg_partial_name IN VARCHAR2,
148 p_num_of_attributes IN NUMBER,
149 p_seg_values IN DFF_Rec_Type,
150 p_stack_err_msg IN BOOLEAN := TRUE
151 );
152
153 -- Procedure : Validate_Desc_Flex
154 -- Description : Validate descriptive flexfield information. Verify that none
155 -- of the values are invalid, disabled, expired or not
156 -- available for the current user because of value security
157 -- rules.
158 -- Parameters :
159 -- IN : p_api_name IN VARCHAR2(30) Required
160 -- Name of the calling API (used for messages)
161 -- p_appl_short_name IN VARCHAR2(30) Optional
162 -- Application short name of the descriptive flexfield
163 -- p_desc_flex_name IN VARCHAR2(30) Required
164 -- Name of the descriptive flexfield
165 -- p_column_name1-15 IN VARCHAR2(30) Required
166 -- Names of the 15 descriptive flexfield columns
167 -- p_column_value1-15 IN VARCHAR2(150) Required
168 -- Values of the 15 descriptive flexfield segments
169 -- p_context_value IN VARCHAR2(30) Required
170 -- Value of the descriptive flexfield structure defining
171 -- column
172 -- p_resp_appl_id IN NUMBER Optional
173 -- Application identifier
174 -- p_resp_id IN NUMBER Optional
175 -- Responsibility identifier
176 -- OUT : x_return_status OUT VARCHAR2(1)
177 -- FND_API.G_RET_STS_SUCCESS => values are valid
178 -- FND_API.G_RET_STS_ERROR => values are invalid
179 ------------------------------------------------------------------------------
180
181 PROCEDURE Validate_Desc_Flex
182 ( p_api_name IN VARCHAR2,
183 p_appl_short_name IN VARCHAR2 DEFAULT 'CS',
184 p_desc_flex_name IN VARCHAR2,
185 p_column_name1 IN VARCHAR2,
186 p_column_name2 IN VARCHAR2,
187 p_column_name3 IN VARCHAR2,
188 p_column_name4 IN VARCHAR2,
189 p_column_name5 IN VARCHAR2,
190 p_column_name6 IN VARCHAR2,
191 p_column_name7 IN VARCHAR2,
192 p_column_name8 IN VARCHAR2,
193 p_column_name9 IN VARCHAR2,
194 p_column_name10 IN VARCHAR2,
195 p_column_name11 IN VARCHAR2,
196 p_column_name12 IN VARCHAR2,
197 p_column_name13 IN VARCHAR2,
198 p_column_name14 IN VARCHAR2,
199 p_column_name15 IN VARCHAR2,
200 p_column_value1 IN VARCHAR2,
201 p_column_value2 IN VARCHAR2,
202 p_column_value3 IN VARCHAR2,
203 p_column_value4 IN VARCHAR2,
204 p_column_value5 IN VARCHAR2,
205 p_column_value6 IN VARCHAR2,
206 p_column_value7 IN VARCHAR2,
207 p_column_value8 IN VARCHAR2,
208 p_column_value9 IN VARCHAR2,
209 p_column_value10 IN VARCHAR2,
210 p_column_value11 IN VARCHAR2,
211 p_column_value12 IN VARCHAR2,
212 p_column_value13 IN VARCHAR2,
213 p_column_value14 IN VARCHAR2,
214 p_column_value15 IN VARCHAR2,
215 p_context_value IN VARCHAR2,
216 p_resp_appl_id IN NUMBER := NULL,
217 p_resp_id IN NUMBER := NULL,
218 x_return_status OUT NOCOPY VARCHAR2 );
219
220 END CS_COUNTERS_EXT_PVT;