APPS.HR_WORKFLOW_INSTALL_PKG dependencies on HR_NAVIGATION_UNITS

Line 62: hr_navigation_units NU,

58: ptl.override_label AS Button_label
59: FROM hr_navigation_node_usages NNU,
60: hr_navigation_node_usages NNU2,
61: hr_workflows W,
62: hr_navigation_units NU,
63: hr_navigation_nodes NN,
64: hr_navigation_units NU2,
65: hr_navigation_nodes NN2,
66: hr_navigation_paths P,

Line 64: hr_navigation_units NU2,

60: hr_navigation_node_usages NNU2,
61: hr_workflows W,
62: hr_navigation_units NU,
63: hr_navigation_nodes NN,
64: hr_navigation_units NU2,
65: hr_navigation_nodes NN2,
66: hr_navigation_paths P,
67: hr_navigation_paths_tl PTL
68: WHERE nn2.nav_node_id = nnu2.nav_node_id

Line 352: from hr_navigation_units

348: procedure get_nav_unit_id (p_form_name varchar2,
349: p_block_name varchar2 default null) is
350: cursor id is
351: select nav_unit_id
352: from hr_navigation_units
353: where form_name = p_form_name
354: and nvl(block_name,'-9999')=nvl(p_block_name,'-9999');
355: begin
356: open id;

Line 400: insert into hr_navigation_units (

396: l_current_language varchar2(3);
397: l_nav_unit_id number;
398: begin
399:
400: insert into hr_navigation_units (
401: nav_unit_id,
402: application_abbrev,
403: default_label,
404: form_name,

Line 408: hr_navigation_units_s.nextval,

404: form_name,
405: max_number_of_nav_buttons,
406: block_name)
407: values (
408: hr_navigation_units_s.nextval,
409: p_application_abbrev,
410: p_default_label,
411: p_form_name,
412: p_max_no_of_buttons,

Line 419: from hr_navigation_units

415: get_nav_unit_id (p_form_name,p_block_name);
416:
417: select nav_unit_id
418: into l_nav_unit_id
419: from hr_navigation_units
420: where form_name = p_form_name
421: and nvl(block_name,'-9999')=nvl(p_block_name,'-9999');
422:
423: select L.language_code

Line 429: from HR_NAVIGATION_UNITS_TL T

425: from FND_LANGUAGES L
426: where L.INSTALLED_FLAG in ('I', 'B')
427: and not exists
428: (select NULL
429: from HR_NAVIGATION_UNITS_TL T
430: where T.NAV_UNIT_ID = L_NAV_UNIT_ID
431: and T.LANGUAGE = L.LANGUAGE_CODE);
432:
433: insert into hr_navigation_units_tl (

Line 433: insert into hr_navigation_units_tl (

429: from HR_NAVIGATION_UNITS_TL T
430: where T.NAV_UNIT_ID = L_NAV_UNIT_ID
431: and T.LANGUAGE = L.LANGUAGE_CODE);
432:
433: insert into hr_navigation_units_tl (
434: nav_unit_id
435: ,language
436: ,source_lang
437: ,default_label

Line 443: from hr_navigation_units b

439: select b.nav_unit_id
440: ,l_current_language
441: ,userenv('LANG')
442: ,b.default_label
443: from hr_navigation_units b
444: where not exists
445: (select '1'
446: from hr_navigation_units_tl t
447: where t.nav_unit_id = b.nav_unit_id

Line 446: from hr_navigation_units_tl t

442: ,b.default_label
443: from hr_navigation_units b
444: where not exists
445: (select '1'
446: from hr_navigation_units_tl t
447: where t.nav_unit_id = b.nav_unit_id
448: and t.language = l_current_language);
449: end new_nav_unit;
450: