[Home] [Help]
1818: -- Declare cursors and local variables
1819: --
1820: l_proc varchar2(72) := g_package||'create_ame_action_to_rule';
1821: l_dummy varchar2(10);
1822: l_action_type_id ame_action_types.action_type_id%type;
1823: l_attribute_id number;
1824: l_effective_date date;
1825: --+
1826: cursor getActionDetails is
1907: );
1908: l_action_found boolean;
1909: l_allowAllApproverTypes varchar2(30);
1910: l_allowProduction varchar2(30);
1911: l_action_type_name ame_action_types.name%type;
1912: l_atu_object_version_number integer;
1913: l_count number;
1914: l_action_rule_type number;
1915: l_item_class_id number;
1927: conditionIdList ame_util.idList;
1928: appIdList ame_util.idList;
1929: l_result number(2);
1930: l_head_item_class_id ame_item_classes.item_class_id%type;
1931: l_aty_name ame_action_types.name%type;
1932: l_swi_call boolean;
1933: begin
1934: hr_utility.set_location('Entering:'|| l_proc, 10);
1935: --
1985: --+ Check if the action is of line-item job-level chains of authority action type.
1986: --+
1987: select name
1988: into l_aty_name
1989: from ame_action_types
1990: where action_type_id = l_action_type_id
1991: and sysdate between start_date and nvl(end_date - (1/84600),sysdate);
1992: --+
1993: if l_aty_name = 'line-item job-level chains of authority' then
3353: -- Declare cursors and local variables
3354: --
3355: l_proc varchar2(72) := g_package||'delete_ame_rule_action ';
3356: l_dummy varchar2(10);
3357: l_action_type_id ame_action_types.action_type_id%type;
3358: l_attribute_id number;
3359: l_effective_date date;
3360: --+
3361: cursor getActionCount is