DBA Data[Home] [Help]

APPS.HR_TEMPLATE_ITEMS_API dependencies on HR_TEMPLATE_ITEMS

Line 1: Package Body hr_template_items_api as

1: Package Body hr_template_items_api as
2: /* $Header: hrtimapi.pkb 120.1 2007/11/26 05:58:17 ktithy ship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: hrtimapi.pkb 120.1 2007/11/26 05:58:17 ktithy ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_template_items_api.';
7: --
8: PROCEDURE update_template_item_contexts
9: (p_effective_date IN DATE
10: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

Line 616: FROM hr_template_items tit

612: --
613: CURSOR cur_form_item
614: IS
615: SELECT tit.form_item_id
616: FROM hr_template_items tit
617: WHERE tit.template_item_id = p_template_item_id_from;
618: --
619: CURSOR cur_tab_page
620: IS

Line 688: hr_template_items_api_bk1.copy_template_item_b

684: --
685: -- Call Before Process User Hook
686: --
687: begin
688: hr_template_items_api_bk1.copy_template_item_b
689: (p_effective_date => TRUNC(p_effective_date)
690: ,p_language_code => l_language_code
691: ,p_template_item_id_from => p_template_item_id_from
692: ,p_form_template_id => p_form_template_id

Line 779: hr_template_items_api_bk1.copy_template_item_a

775: --
776: -- Call After Process User Hook
777: --
778: begin
779: hr_template_items_api_bk1.copy_template_item_a
780: (p_effective_date => TRUNC(p_effective_date)
781: ,p_language_code => l_language_code
782: ,p_template_item_id_from => p_template_item_id_from
783: ,p_form_template_id => p_form_template_id

Line 974: hr_template_items_api_bk2.create_template_item_b

970: --
971: -- Call Before Process User Hook
972: --
973: begin
974: hr_template_items_api_bk2.create_template_item_b
975: (p_effective_date => TRUNC(p_effective_date)
976: ,p_language_code => l_language_code
977: ,p_form_template_id => p_form_template_id
978: ,p_form_item_id => p_form_item_id

Line 1205: hr_template_items_api_bk2.create_template_item_a

1201: --
1202: -- Call After Process User Hook
1203: --
1204: begin
1205: hr_template_items_api_bk2.create_template_item_a
1206: (p_effective_date => TRUNC(p_effective_date)
1207: ,p_language_code => l_language_code
1208: ,p_form_template_id => p_form_template_id
1209: ,p_form_item_id => p_form_item_id

Line 1369: ,hr_template_items_b hti

1365: CURSOR cur_api_val
1366: IS
1367: SELECT source_form_template_id
1368: FROM hr_source_form_templates hsf
1369: ,hr_template_items_b hti
1370: WHERE hsf.form_template_id_to = hti.form_template_id
1371: AND hti.template_item_id = p_template_item_id;
1372:
1373: ---- Fix For Bug 6631115 Starts ------

Line 1379: FROM hr_template_items_b

1375: CURSOR cur_template_item
1376: IS
1377: SELECT template_item_id
1378: ,object_version_number
1379: FROM hr_template_items_b
1380: WHERE template_item_id = p_template_item_id;
1381:
1382: l_template_item_id number;
1383: l_object_version_number number;

Line 1399: hr_template_items_api_bk3.delete_template_item_b

1395: --
1396: -- Call Before Process User Hook
1397: --
1398: begin
1399: hr_template_items_api_bk3.delete_template_item_b
1400: (p_template_item_id => p_template_item_id
1401: ,p_object_version_number => p_object_version_number
1402: ,p_delete_children_flag => p_delete_children_flag
1403: );

Line 1477: hr_template_items_api_bk3.delete_template_item_a

1473: --
1474: -- Call After Process User Hook
1475: --
1476: begin
1477: hr_template_items_api_bk3.delete_template_item_a
1478: (p_template_item_id => p_template_item_id
1479: ,p_object_version_number => p_object_version_number
1480: ,p_delete_children_flag => p_delete_children_flag
1481: );

Line 1617: ,hr_template_items_b hti

1613: IS
1614: SELECT required_override
1615: ,visible_override
1616: FROM hr_form_items_b hfi
1617: ,hr_template_items_b hti
1618: WHERE hfi.form_item_id = hti.form_item_id
1619: AND hti.template_item_id = p_template_item_id;
1620:
1621: l_temp number;

Line 1627: ,hr_template_items_b hti

1623: CURSOR cur_api_val
1624: IS
1625: SELECT source_form_template_id
1626: FROM hr_source_form_templates hsf
1627: ,hr_template_items_b hti
1628: WHERE hsf.form_template_id_to = hti.form_template_id
1629: AND hti.template_item_id = p_template_item_id;
1630:
1631: l_proc varchar2(72) := g_package||'update_template_item';

Line 1659: hr_template_items_api_bk4.update_template_item_b

1655: --
1656: -- Call Before Process User Hook
1657: --
1658: begin
1659: hr_template_items_api_bk4.update_template_item_b
1660: (p_effective_date => TRUNC(p_effective_date)
1661: ,p_language_code => l_language_code
1662: ,p_template_item_id => p_template_item_id
1663: ,p_object_version_number => l_object_version_number

Line 1952: hr_template_items_api_bk4.update_template_item_a

1948: --
1949: -- Call After Process User Hook
1950: --
1951: begin
1952: hr_template_items_api_bk4.update_template_item_a
1953: (p_effective_date => TRUNC(p_effective_date)
1954: ,p_language_code => l_language_code
1955: ,p_template_item_id => p_template_item_id
1956: ,p_object_version_number => l_object_version_number

Line 2074: end hr_template_items_api;

2070: hr_utility.set_location(' Leaving:'||l_proc, 90);
2071: raise;
2072: end update_template_item;
2073: --
2074: end hr_template_items_api;