[Home] [Help]
492: l_use_count number := 0;
493: l_condition_type varchar2(10);
494: l_attribute_id number;
495: l_action_rule_type ame_rules.rule_type%type;
496: l_item_class_id ame_item_classes.item_class_id%type;
497: --+
498: cursor getActionRuleType is
499: select atyu.rule_type
500: from ame_action_type_usages atyu
980: l_rul_object_version_number number;
981: l_rule_id number;
982: l_rule_type ame_rules.rule_type%type;
983: l_item_class_id number;
984: l_item_class_name ame_item_classes.name%type;
985: l_date_changed varchar2(10);
986: l_variable_value varchar2(200);
987: l_application_id number;
988: l_overlapping_usage number;
1124: if l_variable_value = ame_util.no then
1125: -- check that the rule item class is header
1126: select name
1127: into l_item_class_name
1128: from ame_item_classes
1129: where item_class_id = l_item_class_id
1130: and l_effective_date between start_date
1131: and nvl(end_date - ame_util.oneSecond, l_effective_date);
1132: if l_item_class_name not in (ame_util.headerItemClassName
1926: actionIdList ame_util.idList;
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);
1992: --+
1993: if l_aty_name = 'line-item job-level chains of authority' then
1994: select item_class_id
1995: into l_head_item_class_id
1996: from ame_item_classes
1997: where name = 'header'
1998: and sysdate between start_date and nvl(end_date - (1/84600),sysdate);
1999: if l_head_item_class_id <> l_item_class_id then
2000: fnd_message.set_name('PER','AME_400449_INV_ACT_TYP_CHOSEN');