[Home] [Help]
1: PACKAGE BODY hxc_proj_manager_approval_pkg AS
2: /* $Header: hxcpamgrapr.pkb 120.6.12000000.1 2007/01/18 17:54:43 appldev noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: cursor g_csr_get_approval_style
7: is
8: select approval_style_id from HXC_APPROVAL_STYLES where name ='SEEDED_APPL_PA_MGR';
99:
100: l_proc varchar2(100);
101: begin
102:
103: g_debug := hr_utility.debug_enabled;
104:
105: if g_debug then
106: l_proc := 'hxc_proj_manager_approval_pkg.create_tim_cat';
107: hr_utility.set_location(l_proc, 10);
103: g_debug := hr_utility.debug_enabled;
104:
105: if g_debug then
106: l_proc := 'hxc_proj_manager_approval_pkg.create_tim_cat';
107: hr_utility.set_location(l_proc, 10);
108: end if;
109:
110: l_project_id := p_project_id;
111: l_approval_style_id := p_approval_style_id;
132: THEN
133:
134: /*
135: if g_debug then
136: hr_utility.set_location(l_proc, 20);
137: end if;
138: l_manager_id := -1;
139: IF p_default_approval_mechanism IS NOT NULL
140: THEN
161:
162: if csr_get_time_category_name%NOTFOUND
163: then
164: if g_debug then
165: hr_utility.set_location(l_proc, 30);
166: end if;
167:
168: l_object_version_number := 0;
169:
213: -- approval mechanism then we need to update the approval component for the left out entries
214:
215:
216: if g_debug then
217: hr_utility.set_location(l_proc, 40);
218: end if;
219:
220:
221: IF l_time_category_name = 'PROJECT MANAGER :: -1 SYSTEM GENERATED DO NOT MODIFY' and p_default_approval_mechanism IS NOT NULL and g_update_flag = 0
220:
221: IF l_time_category_name = 'PROJECT MANAGER :: -1 SYSTEM GENERATED DO NOT MODIFY' and p_default_approval_mechanism IS NOT NULL and g_update_flag = 0
222: THEN
223: if g_debug then
224: hr_utility.set_location(l_proc, 50);
225: end if;
226:
227:
228: -- Getting the approval mechanism and approval mechanism id of the approval component for left out entries
259:
260: IF g_update_flag = 1
261: THEN
262: if g_debug then
263: hr_utility.set_location(l_proc, 60);
264: end if;
265:
266: hxc_approval_comps_api.update_approval_comps
267: (
281:
282: END IF;
283: CLOSE csr_get_approval_mechanism;
284: if g_debug then
285: hr_utility.set_location(l_proc, 70);
286: end if;
287: END IF;
288:
289: */
316:
317: IF l_time_category_id_old <> l_time_category_id OR csr_find_time_category_comp%NOTFOUND
318: THEN
319: if g_debug then
320: hr_utility.set_location(l_proc, 80);
321: end if;
322:
323: IF csr_find_time_category_comp%FOUND
324: THEN
322:
323: IF csr_find_time_category_comp%FOUND
324: THEN
325: if g_debug then
326: hr_utility.set_location(l_proc, 90);
327: end if;
328:
329: /* The project set-up has changed and so we need to delete previous time cat comp and then add new one */
330: -- dele
343: end if;
344:
345: END IF;
346: if g_debug then
347: hr_utility.set_location(l_proc, 100);
348: end if;
349:
350:
351:
412:
413: l_proc varchar2(100);
414: begin
415:
416: g_debug := hr_utility.debug_enabled;
417:
418: if g_debug then
419: l_proc := 'hxc_proj_manager_approval_pkg.replace_by_spl_ela';
420: hr_utility.set_location(l_proc, 10);
416: g_debug := hr_utility.debug_enabled;
417:
418: if g_debug then
419: l_proc := 'hxc_proj_manager_approval_pkg.replace_by_spl_ela';
420: hr_utility.set_location(l_proc, 10);
421: end if;
422:
423: open csr_get_recipient_id;
424: Fetch csr_get_recipient_id into l_time_recipient_id;
431:
432: IF g_csr_get_approval_style%NOTFOUND
433: THEN
434: if g_debug then
435: hr_utility.set_location(l_proc, 20);
436: end if;
437:
438:
439: hxc_approval_styles_api.create_approval_styles(
475: ELSE
476: /* If the special ELA approval style exists then get the ENTRY_LEVEL_APPROVAL approval component id associated with the special ELA approval style */
477:
478: if g_debug then
479: hr_utility.set_location(l_proc, 30);
480: end if;
481:
482:
483: OPEN csr_get_ela_approval_comp(l_approval_style_id);
509:
510: l_index := p_tab_project_id.next( l_index );
511: END LOOP;
512: if g_debug then
513: hr_utility.set_location(l_proc, 40);
514: end if;
515:
516: commit;
517: