APPS.HR_TASKFLOW_WORKFLOW dependencies on HR_WORKFLOWS

Line 76: g_workflow_id hr_workflows.workflow_id%type;

72: -- global internal workflow item attribute names
73: g_root_form_name_attr varchar2(14) := 'ROOT_FORM_NAME';
74: g_workflow_duration_attr varchar2(17) := 'WORKFLOW_DURATION';
75: g_oracle_session_id_attr varchar2(17) := 'ORACLE_SESSION_ID';
76: g_workflow_id hr_workflows.workflow_id%type;
77: g_workflow_process_mode varchar2(10);
78: -- --------------------------------------------------------------------------
79: -- |--------------------< get_item_act_display_names >----------------------|
80: -- --------------------------------------------------------------------------

Line 399: from hr_workflows hw

395: (p_process_name in varchar2) is
396: --
397: cursor l_csr_workflow_id is
398: select hw.workflow_id
399: from hr_workflows hw
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

Line 430: select hr_workflows_s.nextval

426: if l_csr_workflow_id%notfound then
427: hr_utility.set_location(l_proc, 15);
428: -- select the sequence
429: begin
430: select hr_workflows_s.nextval
431: into g_workflow_id
432: from sys.dual;
433: exception
434: when others then

Line 442: insert into hr_workflows (workflow_id, workflow_name) values (g_workflow_id, p_process_name);

438: fnd_message.raise_error;
439: end;
440: hr_utility.set_location(l_proc, 20);
441: -- the workflow does not exist so create it
442: insert into hr_workflows (workflow_id, workflow_name) values (g_workflow_id, p_process_name);
443: g_workflow_process_mode := 'INSERT';
444: else
445: hr_utility.set_location(l_proc, 25);
446: -- set the workflow process mode to UPDATE