APPS.HR_TASKFLOW_WORKFLOW dependencies on HR_NAVIGATION_PATHS_TL

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 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 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 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 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 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;