52: l_object_version_number number;
53: l_template_item_Tab_page_id number;
54: l_proc varchar2(72) := g_package||'create_template_item_tab_page';
55: begin
56: hr_utility.set_location('Entering:'|| l_proc, 10);
57: --
58: -- Issue a savepoint
59: --
60: savepoint create_template_item_tab_page;
82: --
83: -- Validation in addition to Row Handlers
84: --
85:
86: hr_utility.set_location('At:'|| l_proc, 15);
87:
88: OPEN cur_api_val;
89: FETCH cur_api_val INTO l_temp;
90: IF (cur_api_val%NOTFOUND AND
116: );
117: end loop;
118: end if;
119:
120: hr_utility.set_location('At:'|| l_proc, 20);
121:
122: hr_tip_ins.ins( p_template_item_id => p_template_item_id
123: ,p_template_tab_page_id => p_template_tab_page_id
124: ,p_template_item_tab_page_id => l_template_item_tab_page_id
125: ,p_object_version_number => l_object_version_number);
126: --
127: -- Call After Process User Hook
128: --
129: hr_utility.set_location('At:'|| l_proc, 25);
130:
131: begin
132: hr_template_item_tab_pages_bk1.create_tip_a
133: (p_effective_date => TRUNC(p_effective_date)
155: --
156: p_template_item_tab_page_id := l_template_item_tab_page_id;
157: p_object_version_number := l_object_version_number;
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 70);
160: exception
161: when hr_api.validate_enabled then
162: --
163: -- As the Validate_Enabled exception has been raised
170: -- when validation only mode is being used.)
171: --
172: p_template_item_tab_page_id := null;
173: p_object_version_number := null;
174: hr_utility.set_location(' Leaving:'||l_proc, 80);
175: when others then
176: --
177: -- A validation or unexpected error has occured
178: --
179: p_template_item_tab_page_id := null;
180: p_object_version_number := null;
181:
182: rollback to create_template_item_tab_page;
183: hr_utility.set_location(' Leaving:'||l_proc, 90);
184: raise;
185: end create_template_item_tab_page;
186: --
187: -- ----------------------------------------------------------------------------
225: l_template_item_context_page csr_template_item_context_page%ROWTYPE;
226:
227: l_proc varchar2(72) := g_package||'delete_template_item_tab_page';
228: begin
229: hr_utility.set_location('Entering:'|| l_proc, 10);
230: --
231: -- Issue a savepoint
232: --
233: savepoint delete_template_item_tab_page;
250: end;
251: --
252: -- Validation in addition to Row Handlers
253: --
254: hr_utility.set_location('At:'|| l_proc, 15);
255:
256: OPEN cur_api_val;
257: FETCH cur_api_val INTO l_temp;
258: IF (cur_api_val%NOTFOUND AND
281: );
282: end loop;
283: end if;
284:
285: hr_utility.set_location('At:'|| l_proc, 20);
286:
287: hr_tip_del.del( p_template_item_tab_page_id => p_template_item_tab_page_id
288: ,p_object_version_number => p_object_version_number);
289:
286:
287: hr_tip_del.del( p_template_item_tab_page_id => p_template_item_tab_page_id
288: ,p_object_version_number => p_object_version_number);
289:
290: hr_utility.set_location('At:'|| l_proc, 30);
291:
292: --
293: -- Call After Process User Hook
294: --
311: if p_validate then
312: raise hr_api.validate_enabled;
313: end if;
314: --
315: hr_utility.set_location(' Leaving:'||l_proc, 70);
316: exception
317: when hr_api.validate_enabled then
318: --
319: -- As the Validate_Enabled exception has been raised
324: -- Only set output warning arguments
325: -- (Any key or derived arguments must be set to null
326: -- when validation only mode is being used.)
327: --
328: hr_utility.set_location(' Leaving:'||l_proc, 80);
329: when others then
330: --
331: -- A validation or unexpected error has occured
332: --
330: --
331: -- A validation or unexpected error has occured
332: --
333: rollback to delete_template_item_tab_page;
334: hr_utility.set_location(' Leaving:'||l_proc, 90);
335: raise;
336: end delete_template_item_tab_page;
337: --
338: end hr_template_item_tab_pages_api;