APPS.HR_TASKFLOW_WORKFLOW dependencies on HR_NAVIGATION_NODE_USAGES

Line 8: (nav_node_usage_id hr_navigation_node_usages.nav_node_usage_id%type

4: -- WF Used Private Globals
5: --
6: g_process_activity_rec wf_process_activities%rowtype;
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

Line 404: from hr_navigation_node_usages hnnu

400: where hw.workflow_name = p_process_name;
401: --
402: cursor l_csr_nav_usages(c_workflow_id number) is
403: select hnnu.nav_node_usage_id
404: from hr_navigation_node_usages hnnu
405: where hnnu.workflow_id = c_workflow_id;
406: --
407: l_proc varchar2(72) := g_package||'insert_workflow';
408: l_nav_path_id number;

Line 412: l_nav_node_usage_id hr_navigation_node_usages.nav_node_usage_id%type;

408: l_nav_path_id number;
409:
410: -- start of Bug 4506198
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

Line 413: cursor l_csr_nav_paths(p_nav_id hr_navigation_node_usages.nav_node_usage_id%type) is

409:
410: -- start of Bug 4506198
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;

Line 479: delete from hr_navigation_node_usages hnnu

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
480: where hnnu.nav_node_usage_id = csr_csr.nav_node_usage_id;
481: end loop;
482: end if;
483: hr_utility.set_location(l_proc, 30);

Line 1315: l_nav_node_usage_id hr_navigation_node_usages.nav_node_usage_id%type;

1311: ,p_sqlform in varchar2
1312: ,p_override_label in varchar2) is
1313: --
1314: l_top_node varchar2(1) := 'N';
1315: l_nav_node_usage_id hr_navigation_node_usages.nav_node_usage_id%type;
1316: l_proc varchar2(72) := g_package||'insert_navigation_node_usage';
1317: l_index binary_integer;
1318: --
1319: begin

Line 1328: select hr_navigation_node_usages_s.nextval

1324: l_top_node := 'Y';
1325: end if;
1326: -- select the sequence
1327: begin
1328: select hr_navigation_node_usages_s.nextval
1329: into l_nav_node_usage_id
1330: from sys.dual;
1331: exception
1332: when others then

Line 1340: insert into hr_navigation_node_usages

1336: fnd_message.raise_error;
1337: end;
1338: hr_utility.set_location(l_proc, 20);
1339: -- insert the node usage
1340: insert into hr_navigation_node_usages
1341: (nav_node_usage_id,
1342: workflow_id,
1343: nav_node_id,
1344: top_node)