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_TASKFLOW_WORKFLOW dependencies on HR_NAVIGATION_PATHS

Line 11: ,override_label hr_navigation_paths.override_label%type);

7: type g_usage_rec is record
8: (nav_node_usage_id hr_navigation_node_usages.nav_node_usage_id%type
9: ,instance_id wf_process_activities.instance_id%type
10: ,sqlform hr_navigation_units.form_name%type
11: ,override_label hr_navigation_paths.override_label%type);
12: type g_wf_transition_rec is record
13: (to_process_activity wf_activity_transitions.to_process_activity%type
14: ,result_code wf_activity_transitions.result_code%type);
15: type g_usage_tab is table of g_usage_rec index by binary_integer;

Line 152: l_override_label hr_navigation_paths.override_label%type := null;

148: -- --------------------------------------------------------------------------
149: -- |-------------------------< get_override_label >-------------------------|
150: -- --------------------------------------------------------------------------
151: function get_override_label(p_instance_id in number) return varchar2 is
152: l_override_label hr_navigation_paths.override_label%type := null;
153: l_proc varchar2(72) := g_package||'get_override_label';
154: begin
155: hr_utility.set_location('Entering:'||l_proc, 10);
156: for i in g_node_usage_tab.first..g_node_usage_tab.last loop

Line 415: from hr_navigation_paths hnp

411:
412: l_nav_node_usage_id hr_navigation_node_usages.nav_node_usage_id%type;
413: cursor l_csr_nav_paths(p_nav_id hr_navigation_node_usages.nav_node_usage_id%type) is
414: select nav_path_id
415: from hr_navigation_paths hnp
416: where hnp.from_nav_node_usage_id = p_nav_id
417: or hnp.to_nav_node_usage_id = p_nav_id;
418:
419: -- end of bug 4506198

Line 456: from hr_navigation_paths hnp

452:
453: -- start of bug 4506198
454: /*select nav_path_id
455: into l_nav_path_id
456: from hr_navigation_paths hnp
457: where hnp.from_nav_node_usage_id = csr_csr.nav_node_usage_id
458: or hnp.to_nav_node_usage_id = csr_csr.nav_node_usage_id; */
459:
460: l_nav_node_usage_id:=csr_csr.nav_node_usage_id;

Line 463: delete from hr_navigation_paths_tl hnp

459:
460: l_nav_node_usage_id:=csr_csr.nav_node_usage_id;
461: for csr_paths in l_csr_nav_paths(l_nav_node_usage_id) loop
462:
463: delete from hr_navigation_paths_tl hnp
464: where nav_path_id = csr_paths.nav_path_id;
465:
466: delete from hr_navigation_paths hnp
467: where hnp.from_nav_node_usage_id = csr_csr.nav_node_usage_id

Line 466: delete from hr_navigation_paths hnp

462:
463: delete from hr_navigation_paths_tl hnp
464: where nav_path_id = csr_paths.nav_path_id;
465:
466: delete from hr_navigation_paths hnp
467: where hnp.from_nav_node_usage_id = csr_csr.nav_node_usage_id
468: or hnp.to_nav_node_usage_id = csr_csr.nav_node_usage_id;
469:
470: end loop;

Line 472: delete from hr_navigation_paths_tl hnp

468: or hnp.to_nav_node_usage_id = csr_csr.nav_node_usage_id;
469:
470: end loop;
471:
472: delete from hr_navigation_paths_tl hnp
473: where nav_path_id = l_nav_path_id;
474:
475: delete from hr_navigation_paths hnp
476: where hnp.from_nav_node_usage_id = csr_csr.nav_node_usage_id

Line 475: delete from hr_navigation_paths hnp

471:
472: delete from hr_navigation_paths_tl hnp
473: where nav_path_id = l_nav_path_id;
474:
475: delete from hr_navigation_paths hnp
476: where hnp.from_nav_node_usage_id = csr_csr.nav_node_usage_id
477: or hnp.to_nav_node_usage_id = csr_csr.nav_node_usage_id;
478: -- delete the usage
479: delete from hr_navigation_node_usages hnnu

Line 572: from HR_NAVIGATION_PATHS_TL T

568: from FND_LANGUAGES L
569: where L.INSTALLED_FLAG in ('I', 'B')
570: and not exists
571: (select NULL
572: from HR_NAVIGATION_PATHS_TL T
573: where T.NAV_PATH_ID = T_NAV_PATH_ID
574: and T.LANGUAGE = L.LANGUAGE_CODE);
575: /*-- Chages End for the bug 5702720 ---*/
576: --

Line 597: (from_nav_node_usage_id hr_navigation_paths.from_nav_node_usage_id%type

593: (from_process_activity wf_activity_transitions.from_process_activity%type
594: ,to_process_activity wf_activity_transitions.to_process_activity%type
595: ,result_code wf_activity_transitions.result_code%type);
596: type l_insert_path_rec is record
597: (from_nav_node_usage_id hr_navigation_paths.from_nav_node_usage_id%type
598: ,to_nav_node_usage_id hr_navigation_paths.to_nav_node_usage_id%type
599: ,nav_button_required hr_navigation_paths.nav_button_required%type
600: ,sequence hr_navigation_paths.sequence%type
601: ,override_label hr_navigation_paths.override_label%type

Line 598: ,to_nav_node_usage_id hr_navigation_paths.to_nav_node_usage_id%type

594: ,to_process_activity wf_activity_transitions.to_process_activity%type
595: ,result_code wf_activity_transitions.result_code%type);
596: type l_insert_path_rec is record
597: (from_nav_node_usage_id hr_navigation_paths.from_nav_node_usage_id%type
598: ,to_nav_node_usage_id hr_navigation_paths.to_nav_node_usage_id%type
599: ,nav_button_required hr_navigation_paths.nav_button_required%type
600: ,sequence hr_navigation_paths.sequence%type
601: ,override_label hr_navigation_paths.override_label%type
602: ,result_code wf_activity_transitions.result_code%type

Line 599: ,nav_button_required hr_navigation_paths.nav_button_required%type

595: ,result_code wf_activity_transitions.result_code%type);
596: type l_insert_path_rec is record
597: (from_nav_node_usage_id hr_navigation_paths.from_nav_node_usage_id%type
598: ,to_nav_node_usage_id hr_navigation_paths.to_nav_node_usage_id%type
599: ,nav_button_required hr_navigation_paths.nav_button_required%type
600: ,sequence hr_navigation_paths.sequence%type
601: ,override_label hr_navigation_paths.override_label%type
602: ,result_code wf_activity_transitions.result_code%type
603: ,insert_path boolean

Line 600: ,sequence hr_navigation_paths.sequence%type

596: type l_insert_path_rec is record
597: (from_nav_node_usage_id hr_navigation_paths.from_nav_node_usage_id%type
598: ,to_nav_node_usage_id hr_navigation_paths.to_nav_node_usage_id%type
599: ,nav_button_required hr_navigation_paths.nav_button_required%type
600: ,sequence hr_navigation_paths.sequence%type
601: ,override_label hr_navigation_paths.override_label%type
602: ,result_code wf_activity_transitions.result_code%type
603: ,insert_path boolean
604: );

Line 601: ,override_label hr_navigation_paths.override_label%type

597: (from_nav_node_usage_id hr_navigation_paths.from_nav_node_usage_id%type
598: ,to_nav_node_usage_id hr_navigation_paths.to_nav_node_usage_id%type
599: ,nav_button_required hr_navigation_paths.nav_button_required%type
600: ,sequence hr_navigation_paths.sequence%type
601: ,override_label hr_navigation_paths.override_label%type
602: ,result_code wf_activity_transitions.result_code%type
603: ,insert_path boolean
604: );
605: type l_parent_rec is record

Line 606: (from_nav_node_usage_id hr_navigation_paths.from_nav_node_usage_id%type

602: ,result_code wf_activity_transitions.result_code%type
603: ,insert_path boolean
604: );
605: type l_parent_rec is record
606: (from_nav_node_usage_id hr_navigation_paths.from_nav_node_usage_id%type
607: ,to_nav_node_usage_id hr_navigation_paths.to_nav_node_usage_id%type
608: ,sequence hr_navigation_paths.sequence%type
609: ,parent_index number);
610: type l_visit_list_tab is table of

Line 607: ,to_nav_node_usage_id hr_navigation_paths.to_nav_node_usage_id%type

603: ,insert_path boolean
604: );
605: type l_parent_rec is record
606: (from_nav_node_usage_id hr_navigation_paths.from_nav_node_usage_id%type
607: ,to_nav_node_usage_id hr_navigation_paths.to_nav_node_usage_id%type
608: ,sequence hr_navigation_paths.sequence%type
609: ,parent_index number);
610: type l_visit_list_tab is table of
611: wf_activity_transitions.from_process_activity%type

Line 608: ,sequence hr_navigation_paths.sequence%type

604: );
605: type l_parent_rec is record
606: (from_nav_node_usage_id hr_navigation_paths.from_nav_node_usage_id%type
607: ,to_nav_node_usage_id hr_navigation_paths.to_nav_node_usage_id%type
608: ,sequence hr_navigation_paths.sequence%type
609: ,parent_index number);
610: type l_visit_list_tab is table of
611: wf_activity_transitions.from_process_activity%type
612: index by binary_integer;

Line 767: l_nav_button_required hr_navigation_paths.nav_button_required%type := 'N';

763: and waav.name like 'DISPLAY_BUTTON_'
764: and (waav.text_value = c_form_name
765: or waav.text_value = g_parent_transition);
766: --
767: l_nav_button_required hr_navigation_paths.nav_button_required%type := 'N';
768: l_name wf_activity_attr_values.name%type;
769: l_sqlform hr_navigation_units.form_name%type;
770: l_parent boolean := false;
771: l_index binary_integer;

Line 1226: insert into hr_navigation_paths

1222: -- insert all the paths
1223: for i in l_insert_path_struct.first..l_insert_path_struct.last loop
1224: -- only insert paths where the boolean insert_path is true
1225: if l_insert_path_struct(i).insert_path then
1226: insert into hr_navigation_paths
1227: (nav_path_id
1228: ,from_nav_node_usage_id
1229: ,to_nav_node_usage_id
1230: ,nav_button_required

Line 1234: (hr_navigation_paths_s.nextval

1230: ,nav_button_required
1231: ,sequence
1232: ,override_label)
1233: values
1234: (hr_navigation_paths_s.nextval
1235: ,l_insert_path_struct(i).from_nav_node_usage_id
1236: ,l_insert_path_struct(i).to_nav_node_usage_id
1237: ,l_insert_path_struct(i).nav_button_required
1238: ,l_insert_path_struct(i).sequence

Line 1244: from hr_navigation_paths

1240: );
1241:
1242: select nav_path_id
1243: into l_nav_path_id
1244: from hr_navigation_paths
1245: where from_nav_node_usage_id = l_insert_path_struct(i).from_nav_node_usage_id
1246: and to_nav_node_usage_id = l_insert_path_struct(i).to_nav_node_usage_id;
1247:
1248: /*-- Chages start for the bug 5702720 ---*/

Line 1254: insert into hr_navigation_paths_tl (

1250:
1251: for I in csr_language_code(l_nav_path_id)
1252: loop
1253: hr_utility.set_location('In the Cursor csr_language_code= '||i.l_language_code, 6254);
1254: insert into hr_navigation_paths_tl (
1255: nav_path_id
1256: ,language
1257: ,source_lang
1258: ,override_label)

Line 1263: from hr_navigation_paths b

1259: select b.nav_path_id
1260: ,i.l_language_code
1261: ,userenv('LANG')
1262: ,b.override_label
1263: from hr_navigation_paths b
1264: where not exists
1265: (select '1'
1266: from hr_navigation_paths_tl t
1267: where t.nav_path_id = b.nav_path_id

Line 1266: from hr_navigation_paths_tl t

1262: ,b.override_label
1263: from hr_navigation_paths b
1264: where not exists
1265: (select '1'
1266: from hr_navigation_paths_tl t
1267: where t.nav_path_id = b.nav_path_id
1268: and t.language = i.l_language_code);
1269: end loop;
1270: hr_utility.set_location(l_proc, 6255);

Line 1280: from HR_NAVIGATION_PATHS_TL T

1276: from FND_LANGUAGES L
1277: where L.INSTALLED_FLAG in ('I', 'B')
1278: and not exists
1279: (select NULL
1280: from HR_NAVIGATION_PATHS_TL T
1281: where T.NAV_PATH_ID = L_NAV_PATH_ID
1282: and T.LANGUAGE = L.LANGUAGE_CODE);
1283:
1284: insert into hr_navigation_paths_tl (

Line 1284: insert into hr_navigation_paths_tl (

1280: from HR_NAVIGATION_PATHS_TL T
1281: where T.NAV_PATH_ID = L_NAV_PATH_ID
1282: and T.LANGUAGE = L.LANGUAGE_CODE);
1283:
1284: insert into hr_navigation_paths_tl (
1285: nav_path_id
1286: ,language
1287: ,source_lang
1288: ,override_label)

Line 1293: from hr_navigation_paths b

1289: select b.nav_path_id
1290: ,l_current_language
1291: ,userenv('LANG')
1292: ,b.override_label
1293: from hr_navigation_paths b
1294: where not exists
1295: (select '1'
1296: from hr_navigation_paths_tl t
1297: where t.nav_path_id = b.nav_path_id

Line 1296: from hr_navigation_paths_tl t

1292: ,b.override_label
1293: from hr_navigation_paths b
1294: where not exists
1295: (select '1'
1296: from hr_navigation_paths_tl t
1297: where t.nav_path_id = b.nav_path_id
1298: and t.language = l_current_language);
1299: -- End Original code before fix 5702720 -- */
1300: end if;

Line 1483: l_override_label hr_navigation_paths.override_label%type;

1479: l_nextval number;
1480: l_nav_node_id hr_navigation_nodes.nav_node_id%type;
1481: l_root_nav_node_id hr_navigation_nodes.nav_node_id%type;
1482: l_proc varchar2(72) := g_package||'insert_navigation_nodes';
1483: l_override_label hr_navigation_paths.override_label%type;
1484: l_default_label hr_navigation_units.default_label%type;
1485: l_found_nav_node boolean;
1486: --
1487: type l_process_stack_tab is table of