[Home] [Help]
PACKAGE: APPS.OZF_TASK_TEMPLATE_PVT
Source
1 PACKAGE OZF_TASK_TEMPLATE_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvttes.pls 115.3 2003/11/19 08:43:54 upoluri noship $ */
3 TYPE ozf_task_template_rec_type IS RECORD
4 (
5 task_template_id NUMBER
6 ,task_name VARCHAR2(80)
7 ,description VARCHAR2(4000)
8 ,reason_code_id NUMBER
9 ,reason_code VARCHAR2(80)
10 ,task_number VARCHAR2(30)
11 ,task_type_id NUMBER
12 ,task_type_name VARCHAR2(30)
13 ,task_status_id NUMBER
14 ,task_status_name VARCHAR2(30)
15 ,task_priority_id NUMBER
16 ,task_priority_name VARCHAR2(30)
17 ,duration NUMBER
18 ,duration_uom VARCHAR2(3)
19 ,object_version_number NUMBER
20 ,attribute_category VARCHAR2(30)
21 ,attribute1 VARCHAR2(150)
22 ,attribute2 VARCHAR2(150)
23 ,attribute3 VARCHAR2(150)
24 ,attribute4 VARCHAR2(150)
25 ,attribute5 VARCHAR2(150)
26 ,attribute6 VARCHAR2(150)
27 ,attribute7 VARCHAR2(150)
28 ,attribute8 VARCHAR2(150)
29 ,attribute9 VARCHAR2(150)
30 ,attribute10 VARCHAR2(150)
31 ,attribute11 VARCHAR2(150)
32 ,attribute12 VARCHAR2(150)
33 ,attribute13 VARCHAR2(150)
34 ,attribute14 VARCHAR2(150)
35 ,attribute15 VARCHAR2(150)
36 );
37
38 TYPE ozf_task_template_tbl_type IS TABLE OF ozf_task_template_rec_type;
39
40 TYPE ozf_number_tbl_type IS TABLE OF NUMBER;
41 ---------------------------------------------------------------------
42 -- PROCEDURE
43 -- Create_TaskTemplate
44 --
45 -- PURPOSE
46 -- Create a task template.
47 --
48 -- PARAMETERS
49 -- p_insert_reason : the new record to be inserted
50 -- x_reason_code_id : return the reason_code_id of the new reason code
51 --
52 -- NOTES
53 -- 1. object_version_number will be set to 1.
54 ---------------------------------------------------------------------
55 PROCEDURE Create_TaskTemplate (
56 p_api_version IN NUMBER
57 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
58 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
59 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
60
61 ,x_return_status OUT NOCOPY VARCHAR2
62 ,x_msg_data OUT NOCOPY VARCHAR2
63 ,x_msg_count OUT NOCOPY NUMBER
64
65 ,p_task_template IN ozf_task_template_tbl_type
66 ,x_task_template_id OUT NOCOPY ozf_number_tbl_type
67 );
68 ---------------------------------------------------------------------
69 -- PROCEDURE
70 -- Update_TaskTemplate
71 --
72 -- PURPOSE
73 -- Update task template.
74 --
75 -- PARAMETERS
76 -- p_task_template : the record with new items.
77 --
78 -- NOTES
79 -- 1. Raise exception if the object_version_number doesn't match.
80 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
81 -- that column won't be updated.
82 ----------------------------------------------------------------------
83 PROCEDURE Update_TaskTemplate (
84 p_api_version IN NUMBER
85 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
86 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
87 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
88
89 ,x_return_status OUT NOCOPY VARCHAR2
90 ,x_msg_data OUT NOCOPY VARCHAR2
91 ,x_msg_count OUT NOCOPY NUMBER
92
93 ,p_task_template IN ozf_task_template_tbl_type
94 ,x_object_version_number OUT NOCOPY ozf_number_tbl_type
95 );
96 ---------------------------------------------------------------------
97 -- PROCEDURE
98 -- Delete_TaskTemplate
99 --
100 -- PURPOSE
101 -- Delete a task template.
102 --
103 -- PARAMETERS
104 -- p_task_template_id : template to be deleted
105 -- p_object_version_number : object version number
106 --
107 -- NOTES
108 -- 1. Raise exception if the object_version_number doesn't match.
109 ----------------------------------------------------------------------
110 PROCEDURE Delete_TaskTemplate (
111 p_api_version IN NUMBER
112 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
113 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
114 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
115
116 ,x_return_status OUT NOCOPY VARCHAR2
117 ,x_msg_data OUT NOCOPY VARCHAR2
118 ,x_msg_count OUT NOCOPY NUMBER
119
120 ,p_task_template_id IN ozf_number_tbl_type
121 ,p_object_version_number IN ozf_number_tbl_type
122 );
123 ---------------------------------------------------------------------
124 -- PROCEDURE
125 -- Get_TaskTemplate
126 --
127 -- PURPOSE
128 -- Get task template.
129 --
130 -- PARAMETERS
131 -- p_task_group_id : template to be deleted
132 --
133 -- NOTES
134 -- 1. Raise exception if the task group id doesn't exist.
135 ----------------------------------------------------------------------
136 PROCEDURE Get_TaskTemplate (
137 p_api_version IN NUMBER
138 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
139 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
140 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
141
142 ,x_return_status OUT NOCOPY VARCHAR2
143 ,x_msg_data OUT NOCOPY VARCHAR2
144 ,x_msg_count OUT NOCOPY NUMBER
145
146 ,p_reason_code_id IN NUMBER
147 ,x_task_template OUT NOCOPY ozf_task_template_tbl_type
148 );
149 ---------------------------------------------------------------------
150 -- PROCEDURE
151 -- Validate_TaskTemplate
152 --
153 -- PURPOSE
154 -- Validate a reason code record.
155 --
156 -- PARAMETERS
157 -- p_validate_reason : the reason code record to be validated
158 --
159 -- NOTES
160 --
161 ----------------------------------------------------------------------
162 PROCEDURE Validate_TaskTemplate (
163 p_api_version IN NUMBER
164 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
165 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
166 ,x_return_status OUT NOCOPY VARCHAR2
167 ,x_msg_count OUT NOCOPY NUMBER
168 ,x_msg_data OUT NOCOPY VARCHAR2
169 ,p_task_template IN ozf_task_template_rec_type
170 );
171 ---------------------------------------------------------------------
172 -- PROCEDURE
173 -- Check_TaskTemplate_Items
174 --
175 -- PURPOSE
176 -- Perform the item level checking including unique keys,
177 -- required columns, foreign keys, , flag items, domain constraints.
178 --
179 -- PARAMETERS
180 -- p_task_template_rec : the record to be validated
181 ---------------------------------------------------------------------
182 PROCEDURE Check_TaskTemplate_Items(
183 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
184 ,x_return_status OUT NOCOPY VARCHAR2
185 ,p_task_template_rec IN ozf_task_template_rec_type
186 );
187 ---------------------------------------------------------------------
188 -- PROCEDURE
189 -- Check_TaskTemplate_Record
190 --
191 -- PURPOSE
192 -- Check the task template level business rules.
193 --
194 -- PARAMETERS
195 -- p_task_template_rec : the record to be validated; may contain attributes
196 -- as FND_API.g_miss_char/num/date
197 -- p_complete_rec: the complete record after all "g_miss" items have
198 -- been replaced by current database values
199 ---------------------------------------------------------------------
200 PROCEDURE Check_TaskTemplate_Record(
201 p_task_template_rec IN ozf_task_template_rec_type
202 ,p_complete_rec IN ozf_task_template_rec_type := NULL
203 ,x_return_status OUT NOCOPY VARCHAR2
204 );
205 ---------------------------------------------------------------------
206 -- PROCEDURE
207 -- Init_TaskTemplate_Rec
208 --
209 -- PURPOSE
210 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
211 ---------------------------------------------------------------------
212 PROCEDURE Init_Reason_Rec (
213 x_task_template_rec OUT NOCOPY ozf_task_template_rec_type
214 );
215 ---------------------------------------------------------------------
216 -- PROCEDURE
217 -- Complete_TaskTemplate_Rec
218 --
219 -- PURPOSE
220 -- For Update_Reason, some attributes may be passed in as
221 -- FND_API.g_miss_char/num/date if the user doesn't want to
222 -- update those attributes. This procedure will replace the
223 -- "g_miss" attributes with current database values.
224 --
225 -- PARAMETERS
226 -- p_task_template_rec : the record which may contain attributes as
227 -- FND_API.g_miss_char/num/date
228 -- x_complete_rec: the complete record after all "g_miss" items
229 -- have been replaced by current database values
230 ---------------------------------------------------------------------
231 PROCEDURE Complete_TaskTemplate_Rec (
232 p_task_template_rec IN ozf_task_template_rec_type
233 ,x_complete_rec OUT NOCOPY ozf_task_template_rec_type
234 );
235
236
237 END OZF_TASK_TEMPLATE_PVT;
238