1 PACKAGE OZF_TASK_GROUP_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvttgs.pls 115.3 2003/11/19 08:44:21 upoluri noship $ */
3 TYPE task_group_rec_type IS RECORD
4 (
5 task_template_group_id NUMBER
6 ,last_update_date DATE
7 ,last_updated_by NUMBER
8 ,creation_date DATE
9 ,created_by NUMBER
10 ,last_update_login NUMBER
11 ,start_date_active DATE
12 ,end_date_active DATE
13 ,source_object_type_code VARCHAR2(30)
14 ,object_version_number NUMBER
15 ,attribute_category VARCHAR2(30)
16 ,attribute1 VARCHAR2(150)
17 ,attribute2 VARCHAR2(150)
18 ,attribute3 VARCHAR2(150)
19 ,attribute4 VARCHAR2(150)
20 ,attribute5 VARCHAR2(150)
21 ,attribute6 VARCHAR2(150)
22 ,attribute7 VARCHAR2(150)
23 ,attribute8 VARCHAR2(150)
24 ,attribute9 VARCHAR2(150)
25 ,attribute10 VARCHAR2(150)
26 ,attribute11 VARCHAR2(150)
27 ,attribute12 VARCHAR2(150)
28 ,attribute13 VARCHAR2(150)
29 ,attribute14 VARCHAR2(150)
30 ,attribute15 VARCHAR2(150)
31 ,reason_type VARCHAR2(30)
32 ,template_group_name VARCHAR2(80)
33 ,description VARCHAR2(4000)
34 );
35
36 TYPE task_group_tbl_type IS TABLE OF task_group_rec_type;
37
38 TYPE ozf_return_rec_type IS RECORD(
39 returned_record_count NUMBER,
40 next_record_position NUMBER,
41 total_record_count NUMBER
42 );
43
44 TYPE ozf_request_rec_type IS RECORD(
45 records_requested NUMBER,
46 start_record_position NUMBER,
47 return_total_count_flag VARCHAR2(1)
48 );
49
50 TYPE ozf_sort_rec IS RECORD
51 (
52 field_name varchar2(30),
53 asc_dsc_flag char(1) default 'A'
54 );
55
56 TYPE ozf_sort_data IS TABLE OF ozf_sort_rec;
57 ---------------------------------------------------------------------
58 -- PROCEDURE
59 -- Create_task_group
60 --
61 -- PURPOSE
62 -- Create a task group code.
63 --
64 -- PARAMETERS
65 -- p_task_group : the new record to be inserted
66 -- x_task_template_group_id : return the task_template_group_id
67 --
68 -- NOTES
69 -- 1. object_version_number will be set to 1.
70 -- 5. If a flag column is not passed in, default it to 'Y'.
71 -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
72 ---------------------------------------------------------------------
73 PROCEDURE Create_task_group (
74 p_api_version IN NUMBER
75 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
76 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
77 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
78
79 ,x_return_status OUT NOCOPY VARCHAR2
80 ,x_msg_data OUT NOCOPY VARCHAR2
81 ,x_msg_count OUT NOCOPY NUMBER
82
83 ,p_task_group IN task_group_rec_type
84 ,x_task_template_group_id OUT NOCOPY NUMBER
85 );
86 ---------------------------------------------------------------------
87 -- PROCEDURE
88 -- Update_task_group
89 --
90 -- PURPOSE
91 -- Update a task_group code.
92 --
93 -- PARAMETERS
94 -- p_task_group : the record with new items.
95 --
96 -- NOTES
97 -- 1. Raise exception if the object_version_number doesn't match.
98 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
99 -- that column won't be updated.
100 ----------------------------------------------------------------------
101 PROCEDURE Update_task_group (
102 p_api_version IN NUMBER
103 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
104 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
105 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
106
107 ,x_return_status OUT NOCOPY VARCHAR2
108 ,x_msg_data OUT NOCOPY VARCHAR2
109 ,x_msg_count OUT NOCOPY NUMBER
110
111 ,p_task_group IN task_group_rec_type
112 ,x_object_version_number OUT NOCOPY NUMBER
113 );
114 ---------------------------------------------------------------------
115 -- PROCEDURE
116 -- Delete_task_group
117 --
118 -- PURPOSE
119 -- Update a task_group code.
120 --
121 -- PARAMETERS
122 -- p_task_group : the record with new items.
123 -- p_object_version_number : object version number
124 --
125 -- NOTES
126 -- 1. Raise exception if the object_version_number doesn't match.
127 ----------------------------------------------------------------------
128 PROCEDURE Delete_task_group (
129 p_api_version IN NUMBER
130 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
131 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
132 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
133
134 ,x_return_status OUT NOCOPY VARCHAR2
135 ,x_msg_data OUT NOCOPY VARCHAR2
136 ,x_msg_count OUT NOCOPY NUMBER
137
138 ,p_task_template_group_id IN NUMBER
139 ,p_object_version_number IN NUMBER
140 );
141 ---------------------------------------------------------------------
142 -- PROCEDURE
143 -- Get_task_group
144 --
145 -- PURPOSE
146 -- Get task_group code.
147 --
148 -- PARAMETERS
149 -- p_task_group : the record with new items.
150 -- p_object_version_number : object version number
151 --
152 -- NOTES
153 -- 1. Raise exception if the object_version_number doesn't match.
154 ----------------------------------------------------------------------
155 PROCEDURE Get_task_group (
156 p_api_version IN NUMBER
157 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
159
160 ,x_return_status OUT NOCOPY VARCHAR2
161 ,x_msg_data OUT NOCOPY VARCHAR2
162 ,x_msg_count OUT NOCOPY NUMBER
163
164 ,p_task_template_group_id IN NUMBER
165 ,p_template_group_name IN VARCHAR2
166 ,p_source_object_type_code IN VARCHAR2
167 ,p_start_date_active IN DATE
168 ,p_end_date_active IN DATE
169 ,p_sort_data IN ozf_sort_data
170 ,p_request_rec IN ozf_request_rec_type
171 ,x_return_rec OUT NOCOPY ozf_return_rec_type
172 ,x_task_group OUT NOCOPY task_group_tbl_type
173 );
174 ---------------------------------------------------------------------
175 -- PROCEDURE
176 -- Validate_task_group
177 --
178 -- PURPOSE
179 -- Validate a task group code record.
180 --
181 -- PARAMETERS
182 -- p_task_group : the task group code record to be validated
183 --
184 -- NOTES
185 --
186 ----------------------------------------------------------------------
187 PROCEDURE Validate_task_group (
188 p_api_version IN NUMBER
189 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
190 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
191 ,x_return_status OUT NOCOPY VARCHAR2
192 ,x_msg_count OUT NOCOPY NUMBER
193 ,x_msg_data OUT NOCOPY VARCHAR2
194 ,p_task_group IN task_group_rec_type
195 );
196 ---------------------------------------------------------------------
197 -- PROCEDURE
198 -- Check_task_group_Items
199 --
200 -- PURPOSE
201 -- Perform the item level checking including unique keys,
202 -- required columns, foreign keys, , flag items, domain constraints.
203 --
204 -- PARAMETERS
205 -- p_task_group_rec : the record to be validated
206 ---------------------------------------------------------------------
207 PROCEDURE Check_task_group_Items(
208 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
209 ,x_return_status OUT NOCOPY VARCHAR2
210 ,p_task_group_rec IN task_group_rec_type
211 );
212 ---------------------------------------------------------------------
213 -- PROCEDURE
214 -- Check_task_group_Record
215 --
216 -- PURPOSE
217 -- Check the record level business rules.
218 --
219 -- PARAMETERS
220 -- p_task_group_rec : the record to be validated; may contain attributes
221 -- as FND_API.g_miss_char/num/date
222 -- p_complete_rec: the complete record after all "g_miss" items have
223 -- been replaced by current database values
224 ---------------------------------------------------------------------
225 PROCEDURE Check_task_group_Record(
226 p_task_group_rec IN task_group_rec_type
227 ,p_complete_rec IN task_group_rec_type := NULL
228 ,x_return_status OUT NOCOPY VARCHAR2
229 );
230 ---------------------------------------------------------------------
231 -- PROCEDURE
232 -- Init_task_group_Rec
233 --
234 -- PURPOSE
235 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
236 ---------------------------------------------------------------------
237 PROCEDURE Init_task_group_Rec (
238 x_task_group_rec OUT NOCOPY task_group_rec_type
239 );
240 ---------------------------------------------------------------------
241 -- PROCEDURE
242 -- Complete_task_group_Rec
243 --
244 -- PURPOSE
245 -- For Update_task_group, some attributes may be passed in as
246 -- FND_API.g_miss_char/num/date if the user doesn't want to
247 -- update those attributes. This procedure will replace the
248 -- "g_miss" attributes with current database values.
249 --
250 -- PARAMETERS
251 -- p_task_group_rec : the record which may contain attributes as
252 -- FND_API.g_miss_char/num/date
253 -- x_complete_rec: the complete record after all "g_miss" items
254 -- have been replaced by current database values
255 ---------------------------------------------------------------------
256 PROCEDURE Complete_task_group_Rec (
257 p_task_group_rec IN task_group_rec_type
258 ,x_complete_rec OUT NOCOPY task_group_rec_type
259 );
260
261 END OZF_TASK_GROUP_PVT;
262
[Home] [Help]