[Home] [Help]
757: -- and where the form_name is the same or is a form_name does not
758: -- exist check to see if a parent has been specified
759: select waav.name
760: ,waav.text_value
761: from wf_activity_attr_values waav
762: where waav.process_activity_id = p_from_process_activity
763: and waav.name like 'DISPLAY_BUTTON_'
764: and (waav.text_value = c_form_name
765: or waav.text_value = g_parent_transition);
764: and (waav.text_value = c_form_name
765: or waav.text_value = g_parent_transition);
766: --
767: l_nav_button_required hr_navigation_paths.nav_button_required%type := 'N';
768: l_name wf_activity_attr_values.name%type;
769: l_sqlform hr_navigation_units.form_name%type;
770: l_parent boolean := false;
771: l_index binary_integer;
772: --
1386: select wpa1.instance_id
1387: from wf_activities wa
1388: ,wf_process_activities wpa1
1389: ,wf_process_activities wpa2
1390: ,wf_activity_attr_values waav
1391: ,wf_activity_attributes waa
1392: where wpa2.instance_id = c_instance_id
1393: and wpa1.process_name = wpa2.activity_name
1394: and wpa1.process_item_type = wpa2.activity_item_type
1414: select waa.name
1415: ,waav.text_value
1416: from wf_activities wa
1417: ,wf_process_activities wpa1
1418: ,wf_activity_attr_values waav
1419: ,wf_activity_attributes waa
1420: where wpa1.instance_id = c_instance_id
1421: and wa.name = wpa1.activity_name
1422: and wa.item_type = wpa1.activity_item_type
1432: and waa.activity_name = wa.name
1433: and waa.activity_version = wa.version
1434: and exists
1435: (select 1
1436: from wf_activity_attr_values waav1
1437: where waav1.name = g_taskflow_activity_type
1438: and waav1.text_value = g_hrms_sqlform
1439: and waav1.process_activity_id = waav.process_activity_id);
1440: --
1469: where hnn.nav_unit_id = c_nav_unit_id
1470: and nvl(hnn.customized_restriction_id, hr_api.g_number) =
1471: nvl(c_customized_restriction_id, hr_api.g_number);
1472: --
1473: l_taskflow_actvity_name wf_activity_attr_values.text_value%type;
1474: l_customization_name wf_activity_attr_values.text_value%type;
1475: l_taskflow_block_name wf_activity_attr_values.text_value%type;
1476: l_nav_unit_id hr_navigation_units.nav_unit_id%type;
1477: l_customized_restriction_id pay_customized_restrictions.customized_restriction_id%type;
1470: and nvl(hnn.customized_restriction_id, hr_api.g_number) =
1471: nvl(c_customized_restriction_id, hr_api.g_number);
1472: --
1473: l_taskflow_actvity_name wf_activity_attr_values.text_value%type;
1474: l_customization_name wf_activity_attr_values.text_value%type;
1475: l_taskflow_block_name wf_activity_attr_values.text_value%type;
1476: l_nav_unit_id hr_navigation_units.nav_unit_id%type;
1477: l_customized_restriction_id pay_customized_restrictions.customized_restriction_id%type;
1478: l_navigation_node_name hr_navigation_nodes.name%type;
1471: nvl(c_customized_restriction_id, hr_api.g_number);
1472: --
1473: l_taskflow_actvity_name wf_activity_attr_values.text_value%type;
1474: l_customization_name wf_activity_attr_values.text_value%type;
1475: l_taskflow_block_name wf_activity_attr_values.text_value%type;
1476: l_nav_unit_id hr_navigation_units.nav_unit_id%type;
1477: l_customized_restriction_id pay_customized_restrictions.customized_restriction_id%type;
1478: l_navigation_node_name hr_navigation_nodes.name%type;
1479: l_nextval number;
1767: --
1768: cursor l_csr_tf_form is
1769: select 1
1770: from wf_process_activities wpa
1771: ,wf_activity_attr_values waav
1772: where wpa.instance_id = actid
1773: and waav.process_activity_id = wpa.instance_id
1774: and waav.name = g_taskflow_activity_type
1775: and waav.text_value = g_hrms_sqlform;