eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_TEMPLATE_DATA_GROUPS_API dependencies on HR_TEMPLATE_DATA_GROUPS

Line 1: Package Body hr_template_data_groups_api as

1: Package Body hr_template_data_groups_api as
2: /* $Header: hrtdgapi.pkb 115.4 2004/06/21 09:20:50 njaladi noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' hr_template_data_groups_api.';

2: /* $Header: hrtdgapi.pkb 115.4 2004/06/21 09:20:50 njaladi noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_template_data_groups_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< copy_template_data_group >--------------------------|
10: -- ----------------------------------------------------------------------------

Line 27: FROM hr_template_data_groups tdg

23: --
24: CURSOR cur_data_group
25: IS
26: SELECT tdg.form_data_group_id
27: FROM hr_template_data_groups tdg
28: WHERE tdg.template_data_group_id = p_template_data_group_id_from;
29:
30: -- Bug # 3648566. Modified the cursor text to use base table hr_template_items_b
31: -- instead of view hr_template_items.

Line 37: ,hr_template_data_groups tdg

33: IS
34: SELECT tit1.template_item_id
35: FROM hr_template_items_b tit2
36: ,hr_template_items_b tit1
37: ,hr_template_data_groups tdg
38: WHERE tit2.template_item_id IS NULL
39: AND tit2.form_template_id (+) = p_form_template_id
40: AND tit2.form_item_id (+) = tit1.form_item_id
41: AND tit1.form_template_id = tdg.form_template_id

Line 86: hr_template_data_groups_bk1.copy_template_data_group_b

82: --
83: -- Call Before Process User Hook
84: --
85: begin
86: hr_template_data_groups_bk1.copy_template_data_group_b
87: (p_effective_date => TRUNC(p_effective_date)
88: ,p_language_code => l_language_code
89: ,p_template_data_group_id_from => p_template_data_group_id_from
90: ,p_form_template_id => p_form_template_id

Line 151: hr_template_data_groups_bk1.copy_template_data_group_a

147: --
148: hr_utility.set_location('At:'|| l_proc, 35);
149:
150: begin
151: hr_template_data_groups_bk1.copy_template_data_group_a
152: (p_effective_date => TRUNC(p_effective_date)
153: ,p_language_code => l_language_code
154: ,p_template_data_group_id_from => p_template_data_group_id_from
155: ,p_form_template_id => p_form_template_id

Line 264: hr_template_data_groups_bk2.create_template_data_group_b

260: --
261: -- Call Before Process User Hook
262: --
263: begin
264: hr_template_data_groups_bk2.create_template_data_group_b
265: (p_effective_date => TRUNC(p_effective_date)
266: ,p_form_data_group_id => p_form_data_group_id
267: ,p_form_template_id => p_form_template_id
268: );

Line 323: hr_template_data_groups_bk2.create_template_data_group_a

319: --
320: -- Call After Process User Hook
321: --
322: begin
323: hr_template_data_groups_bk2.create_template_data_group_a
324: (p_effective_date => TRUNC(p_effective_date)
325: ,p_form_data_group_id => p_form_data_group_id
326: ,p_form_template_id => p_form_template_id
327: ,p_template_data_group_id => l_template_data_group_id

Line 398: ,hr_template_data_groups tdg

394: SELECT tit.template_item_id
395: ,tit.object_version_number
396: FROM hr_template_items tit
397: ,hr_form_data_group_items fgi
398: ,hr_template_data_groups tdg
399: WHERE tit.form_template_id = tdg.form_template_id
400: AND tit.form_item_id = fgi.form_item_id
401: AND fgi.form_data_group_id = tdg.form_data_group_id
402: AND tdg.template_data_group_id = p_template_data_group_id

Line 408: ,hr_template_data_groups tdg2

404: SELECT tit.template_item_id
405: ,tit.object_version_number
406: FROM hr_template_items tit
407: ,hr_form_data_group_items fgi
408: ,hr_template_data_groups tdg2
409: ,hr_template_data_groups tdg1
410: WHERE tit.form_template_id = tdg2.form_template_id
411: AND tit.form_item_id = fgi.form_item_id
412: AND fgi.form_data_group_id = tdg2.form_data_group_id

Line 409: ,hr_template_data_groups tdg1

405: ,tit.object_version_number
406: FROM hr_template_items tit
407: ,hr_form_data_group_items fgi
408: ,hr_template_data_groups tdg2
409: ,hr_template_data_groups tdg1
410: WHERE tit.form_template_id = tdg2.form_template_id
411: AND tit.form_item_id = fgi.form_item_id
412: AND fgi.form_data_group_id = tdg2.form_data_group_id
413: AND tdg2.template_data_group_id <> tdg1.template_data_group_id

Line 423: ,hr_template_data_groups tdg

419: CURSOR cur_api_val
420: IS
421: SELECT source_form_template_id
422: FROM hr_source_form_templates hsf
423: ,hr_template_data_groups tdg
424: WHERE hsf.form_template_id_to = tdg.form_template_id
425: AND tdg.template_data_group_id = p_template_data_group_id;
426:
427: l_proc varchar2(72) := g_package||'delete_template_data_group';

Line 438: hr_template_data_groups_bk3.delete_template_data_group_b

434: --
435: -- Call Before Process User Hook
436: --
437: begin
438: hr_template_data_groups_bk3.delete_template_data_group_b
439: (p_template_data_group_id => p_template_data_group_id
440: ,p_object_version_number => p_object_version_number);
441: exception
442: when hr_api.cannot_find_prog_unit then

Line 493: hr_template_data_groups_bk3.delete_template_data_group_a

489: --
490: -- Call After Process User Hook
491: --
492: begin
493: hr_template_data_groups_bk3.delete_template_data_group_a
494: (p_template_data_group_id => p_template_data_group_id
495: ,p_object_version_number => p_object_version_number);
496: exception
497: when hr_api.cannot_find_prog_unit then

Line 535: end hr_template_data_groups_api;

531: hr_utility.set_location(' Leaving:'||l_proc, 90);
532: raise;
533: end delete_template_data_group;
534: --
535: end hr_template_data_groups_api;