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 WF_ACTIVITY_TRANSITIONS

Line 13: (to_process_activity wf_activity_transitions.to_process_activity%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;
16: type g_trans_tab is table of g_wf_transition_rec index by binary_integer;
17: g_node_usage_tab g_usage_tab;

Line 14: ,result_code wf_activity_transitions.result_code%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;
16: type g_trans_tab is table of g_wf_transition_rec index by binary_integer;
17: g_node_usage_tab g_usage_tab;
18: g_stack_tab g_trans_tab;

Line 244: from wf_activity_transitions wat

240: -- transition is not a default value
241: cursor l_get_root_instance_id(c_instance_id number) is
242: select wat.to_process_activity
243: ,wat.result_code
244: from wf_activity_transitions wat
245: where wat.result_code <> g_default_transition_value
246: and wat.from_process_activity = c_instance_id;
247: --
248: l_proc varchar2(72) := g_package||'set_root_form_activity_id';

Line 251: l_result_code wf_activity_transitions.result_code%type;

247: --
248: l_proc varchar2(72) := g_package||'set_root_form_activity_id';
249: l_instance_id number;
250: l_index number := 0;
251: l_result_code wf_activity_transitions.result_code%type;
252: --
253: begin
254: hr_utility.set_location('Entering:'||l_proc, 10);
255: -- get the instance_id of the ROOT_TASKFLOW_FORM_SELECTOR

Line 502: ,wf_activity_transitions wat

498: ,wat.to_process_activity
499: ,wat.result_code
500: from wf_process_activities wpa1
501: ,wf_process_activities wpa2
502: ,wf_activity_transitions wat
503: where wpa1.instance_id = c_instance_id
504: and wpa2.process_name = wpa1.activity_name
505: and wpa2.process_item_type = wpa1.activity_item_type
506: and wpa2.start_end = g_activity_type_start

Line 516: ,c_result_code wf_activity_transitions.result_code%type) is

512: and wat.from_process_activity = wpa2.instance_id;
513: --
514: cursor csr_process_end_transitions
515: (c_instance_id wf_process_activities.instance_id%type
516: ,c_result_code wf_activity_transitions.result_code%type) is
517: -- select the END result codes
518: select wat.from_process_activity
519: ,wat.to_process_activity
520: ,wat.result_code

Line 523: ,wf_activity_transitions wat

519: ,wat.to_process_activity
520: ,wat.result_code
521: from wf_process_activities wpa1
522: ,wf_process_activities wpa2
523: ,wf_activity_transitions wat
524: where wpa1.instance_id = c_instance_id
525: and wpa1.start_end = g_activity_type_end
526: and wpa2.activity_name = wpa1.process_name
527: and wpa2.activity_item_type = wpa1.process_item_type

Line 542: from wf_activity_transitions wat

538: -- instance
539: select wat.from_process_activity
540: ,wat.to_process_activity
541: ,wat.result_code
542: from wf_activity_transitions wat
543: where wat.from_process_activity = c_instance_id;
544: --
545: cursor csr_transitions1(c_instance_id number) is
546: -- selects the transition information for the specified activity

Line 551: from wf_activity_transitions wat

547: -- instance
548: select wat.from_process_activity
549: ,wat.to_process_activity
550: ,wat.result_code
551: from wf_activity_transitions wat
552: where wat.from_process_activity = c_instance_id;
553: -- selects an activity type and start_end value for a specified
554: -- activity instance
555: cursor csr_attivity_type(c_instance_id number) is

Line 588: l_pop_from_process_activity wf_activity_transitions.from_process_activity%type;

584: l_return_to_root boolean;
585: l_dummy boolean;
586: l_current_language varchar2(3);
587: l_nav_path_id number;
588: l_pop_from_process_activity wf_activity_transitions.from_process_activity%type;
589: l_pop_to_process_activity wf_activity_transitions.to_process_activity%type;
590: l_pop_result_code wf_activity_transitions.result_code%type;
591: -- define structure types
592: type l_result_stack_rec is record

Line 589: l_pop_to_process_activity wf_activity_transitions.to_process_activity%type;

585: l_dummy boolean;
586: l_current_language varchar2(3);
587: l_nav_path_id number;
588: l_pop_from_process_activity wf_activity_transitions.from_process_activity%type;
589: l_pop_to_process_activity wf_activity_transitions.to_process_activity%type;
590: l_pop_result_code wf_activity_transitions.result_code%type;
591: -- define structure types
592: type l_result_stack_rec is record
593: (from_process_activity wf_activity_transitions.from_process_activity%type

Line 590: l_pop_result_code wf_activity_transitions.result_code%type;

586: l_current_language varchar2(3);
587: l_nav_path_id number;
588: l_pop_from_process_activity wf_activity_transitions.from_process_activity%type;
589: l_pop_to_process_activity wf_activity_transitions.to_process_activity%type;
590: l_pop_result_code wf_activity_transitions.result_code%type;
591: -- define structure types
592: type l_result_stack_rec is record
593: (from_process_activity wf_activity_transitions.from_process_activity%type
594: ,to_process_activity wf_activity_transitions.to_process_activity%type

Line 593: (from_process_activity wf_activity_transitions.from_process_activity%type

589: l_pop_to_process_activity wf_activity_transitions.to_process_activity%type;
590: l_pop_result_code wf_activity_transitions.result_code%type;
591: -- define structure types
592: type l_result_stack_rec is record
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

Line 594: ,to_process_activity wf_activity_transitions.to_process_activity%type

590: l_pop_result_code wf_activity_transitions.result_code%type;
591: -- define structure types
592: type l_result_stack_rec is record
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

Line 595: ,result_code wf_activity_transitions.result_code%type);

591: -- define structure types
592: type l_result_stack_rec is record
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

Line 602: ,result_code wf_activity_transitions.result_code%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
606: (from_nav_node_usage_id hr_navigation_paths.from_nav_node_usage_id%type

Line 611: wf_activity_transitions.from_process_activity%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;
613: type l_result_stack_tab is table of l_result_stack_rec
614: index by binary_integer;
615: type l_insert_path_tab is table of l_insert_path_rec

Line 631: (p_from_process_activity in wf_activity_transitions.from_process_activity%type

627: -- --------------------------------------------------------------------------
628: -- |-----------------------< push_result_stack >----------------------------|
629: -- --------------------------------------------------------------------------
630: procedure push_result_stack
631: (p_from_process_activity in wf_activity_transitions.from_process_activity%type
632: ,p_to_process_activity in wf_activity_transitions.to_process_activity%type
633: ,p_result_code in wf_activity_transitions.result_code%type) is
634: --
635: l_index binary_integer := l_result_stack_struct.count + 1;

Line 632: ,p_to_process_activity in wf_activity_transitions.to_process_activity%type

628: -- |-----------------------< push_result_stack >----------------------------|
629: -- --------------------------------------------------------------------------
630: procedure push_result_stack
631: (p_from_process_activity in wf_activity_transitions.from_process_activity%type
632: ,p_to_process_activity in wf_activity_transitions.to_process_activity%type
633: ,p_result_code in wf_activity_transitions.result_code%type) is
634: --
635: l_index binary_integer := l_result_stack_struct.count + 1;
636: l_proc varchar2(72) := g_package||'push_result_stack';

Line 633: ,p_result_code in wf_activity_transitions.result_code%type) is

629: -- --------------------------------------------------------------------------
630: procedure push_result_stack
631: (p_from_process_activity in wf_activity_transitions.from_process_activity%type
632: ,p_to_process_activity in wf_activity_transitions.to_process_activity%type
633: ,p_result_code in wf_activity_transitions.result_code%type) is
634: --
635: l_index binary_integer := l_result_stack_struct.count + 1;
636: l_proc varchar2(72) := g_package||'push_result_stack';
637: --

Line 649: (p_from_process_activity out nocopy wf_activity_transitions.from_process_activity%type

645: -- --------------------------------------------------------------------------
646: -- |--------------------------< pop_result_stack >--------------------------|
647: -- --------------------------------------------------------------------------
648: procedure pop_result_stack
649: (p_from_process_activity out nocopy wf_activity_transitions.from_process_activity%type
650: ,p_to_process_activity out nocopy wf_activity_transitions.to_process_activity%type
651: ,p_result_code out nocopy wf_activity_transitions.result_code%type) is
652: --
653: l_proc varchar2(72) := g_package||'pop_result_stack';

Line 650: ,p_to_process_activity out nocopy wf_activity_transitions.to_process_activity%type

646: -- |--------------------------< pop_result_stack >--------------------------|
647: -- --------------------------------------------------------------------------
648: procedure pop_result_stack
649: (p_from_process_activity out nocopy wf_activity_transitions.from_process_activity%type
650: ,p_to_process_activity out nocopy wf_activity_transitions.to_process_activity%type
651: ,p_result_code out nocopy wf_activity_transitions.result_code%type) is
652: --
653: l_proc varchar2(72) := g_package||'pop_result_stack';
654: --

Line 651: ,p_result_code out nocopy wf_activity_transitions.result_code%type) is

647: -- --------------------------------------------------------------------------
648: procedure pop_result_stack
649: (p_from_process_activity out nocopy wf_activity_transitions.from_process_activity%type
650: ,p_to_process_activity out nocopy wf_activity_transitions.to_process_activity%type
651: ,p_result_code out nocopy wf_activity_transitions.result_code%type) is
652: --
653: l_proc varchar2(72) := g_package||'pop_result_stack';
654: --
655: begin

Line 691: (p_from_process_activity in wf_activity_transitions.from_process_activity%type)

687: -- --------------------------------------------------------------------------
688: -- |---------------------------< exist_in_visit_list >----------------------|
689: -- --------------------------------------------------------------------------
690: function exist_in_visit_list
691: (p_from_process_activity in wf_activity_transitions.from_process_activity%type)
692: return boolean is
693: l_proc varchar2(72) := g_package||'exist_in_visit_list';
694: l_return boolean := false;
695: begin

Line 714: (p_from_process_activity in wf_activity_transitions.from_process_activity%type)

710: -- --------------------------------------------------------------------------
711: -- |---------------------------< set_visit_activity >----------------------|
712: -- --------------------------------------------------------------------------
713: function set_visit_activity
714: (p_from_process_activity in wf_activity_transitions.from_process_activity%type)
715: return boolean is
716: l_proc varchar2(72) := g_package||'set_visit_activity';
717: l_return boolean := false;
718: begin