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_ITEM_CONTEXTS_API dependencies on HR_TEMPLATE_ITEM_CONTEXTS

Line 1: Package Body hr_template_item_contexts_api as

1: Package Body hr_template_item_contexts_api as
2: /* $Header: hrticapi.pkb 115.7 2003/10/31 06:55:09 bsubrama noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: hrticapi.pkb 115.7 2003/10/31 06:55:09 bsubrama noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_template_item_contexts_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------< copy_template_item_context >--------------------------|
10: -- ----------------------------------------------------------------------------

Line 27: context_type hr_template_item_contexts.context_type%TYPE

23: --
24: -- Declare cursors and local variables
25: --
26: Type l_rec_type Is Record (
27: context_type hr_template_item_contexts.context_type%TYPE
28: ,segment1 hr_item_contexts.segment1%TYPE
29: ,segment2 hr_item_contexts.segment2%TYPE
30: ,segment3 hr_item_contexts.segment3%TYPE
31: ,segment4 hr_item_contexts.segment4%TYPE

Line 95: ,hr_template_item_contexts tic

91: ,icx.segment28
92: ,icx.segment29
93: ,icx.segment30
94: FROM hr_item_contexts icx
95: ,hr_template_item_contexts tic
96: WHERE icx.item_context_id = tic.item_context_id
97: AND tic.template_item_context_id = p_template_item_context_id_frm;
98:
99: CURSOR cur_tmplt_tab

Line 161: hr_template_item_contexts_bk1.copy_template_item_context_b

157: --
158: -- Call Before Process User Hook
159: --
160: begin
161: hr_template_item_contexts_bk1.copy_template_item_context_b
162: (p_effective_date => TRUNC(p_effective_date)
163: ,p_language_code => l_language_code
164: ,p_template_item_context_id_frm => p_template_item_context_id_frm
165: ,p_template_item_id => p_template_item_id

Line 274: hr_template_item_contexts_bk1.copy_template_item_context_a

270: --
271: -- Call After Process User Hook
272: --
273: begin
274: hr_template_item_contexts_bk1.copy_template_item_context_a
275: (p_effective_date => TRUNC(p_effective_date)
276: ,p_language_code => l_language_code
277: ,p_template_item_context_id_frm => p_template_item_context_id_frm
278: ,p_template_item_id => p_template_item_id

Line 518: hr_template_item_contexts_bk2.create_template_item_context_b

514: --
515: -- Call Before Process User Hook
516: --
517: begin
518: hr_template_item_contexts_bk2.create_template_item_context_b
519: (p_effective_date => TRUNC(p_effective_date)
520: ,p_language_code => l_language_code
521: ,p_template_item_id => p_template_item_id
522: ,p_context_type => p_context_type

Line 817: hr_template_item_contexts_bk2.create_template_item_context_a

813: --
814: -- Call After Process User Hook
815: --
816: begin
817: hr_template_item_contexts_bk2.create_template_item_context_a
818: (p_effective_date => TRUNC(p_effective_date)
819: ,p_language_code => l_language_code
820: ,p_template_item_id => p_template_item_id
821: ,p_context_type => p_context_type

Line 1013: ,hr_template_item_contexts_b tic

1009: IS
1010: SELECT source_form_template_id
1011: FROM hr_source_form_templates hsf
1012: ,hr_template_items_b hti
1013: ,hr_template_item_contexts_b tic
1014: WHERE hsf.form_template_id_to = hti.form_template_id
1015: AND hti.template_item_id = tic.template_item_id
1016: AND tic.template_item_context_id = p_template_item_context_id;
1017:

Line 1029: hr_template_item_contexts_bk3.delete_template_item_context_b

1025: --
1026: -- Call Before Process User Hook
1027: --
1028: begin
1029: hr_template_item_contexts_bk3.delete_template_item_context_b
1030: (p_template_item_context_id => p_template_item_context_id
1031: ,p_object_version_number => p_object_version_number
1032: --,p_delete_children_flag => p_delete_children_flag
1033: );

Line 1090: hr_template_item_contexts_bk3.delete_template_item_context_a

1086: --
1087: hr_utility.set_location('At:'|| l_proc, 40);
1088:
1089: begin
1090: hr_template_item_contexts_bk3.delete_template_item_context_a
1091: (p_template_item_context_id => p_template_item_context_id
1092: ,p_object_version_number => p_object_version_number
1093: --,p_delete_children_flag => p_delete_children_flag
1094: );

Line 1265: ,hr_template_item_contexts_b tic

1261: SELECT required_override
1262: ,visible_override
1263: FROM hr_form_items_b hfi
1264: ,hr_template_items_b hti
1265: ,hr_template_item_contexts_b tic
1266: WHERE hfi.form_item_id = hti.form_item_id
1267: AND hti.template_item_id = tic.template_item_id
1268: AND tic.template_item_context_id = p_template_item_context_id;
1269:

Line 1277: ,hr_template_item_contexts_b tic

1273: IS
1274: SELECT source_form_template_id
1275: FROM hr_source_form_templates hsf
1276: ,hr_template_items_b hti
1277: ,hr_template_item_contexts_b tic
1278: WHERE hsf.form_template_id_to = hti.form_template_id
1279: AND hti.template_item_id = tic.template_item_id
1280: AND tic.template_item_context_id = p_template_item_context_id;
1281:

Line 1285: --FROM hr_template_item_contexts_b

1281:
1282: --CURSOR cur_context
1283: --IS
1284: --SELECT DECODE(context_type,hr_api.g_varchar2,context_type,p_context_type)
1285: --FROM hr_template_item_contexts_b
1286: --WHERE template_item_context_id = p_template_item_context_id;
1287:
1288: --l_context_type varchar2(30);
1289: l_object_version_number number;

Line 1322: hr_template_item_contexts_bk4.update_template_item_context_b

1318: --
1319: -- Call Before Process User Hook
1320: --
1321: begin
1322: hr_template_item_contexts_bk4.update_template_item_context_b
1323: (p_effective_date => TRUNC(p_effective_date)
1324: ,p_language_code => l_language_code
1325: --,p_context_type => p_context_type
1326: ,p_template_item_context_id => p_template_item_context_id

Line 1614: hr_template_item_contexts_bk4.update_template_item_context_a

1610: --
1611: -- Call After Process User Hook
1612: --
1613: begin
1614: hr_template_item_contexts_bk4.update_template_item_context_a
1615: (p_effective_date => TRUNC(p_effective_date)
1616: ,p_language_code => l_language_code
1617: --,p_context_type => p_context_type
1618: ,p_template_item_context_id => p_template_item_context_id

Line 1775: end hr_template_item_contexts_api;

1771: hr_utility.set_location(' Leaving:'||l_proc, 90);
1772: raise;
1773: end update_template_item_context;
1774: --
1775: end hr_template_item_contexts_api;