APPS.AME_UTILITY_PKG dependencies on AME_RULES

Line 976: from ame_rules ar

972: null CONDITION_USAGE_LUD,
973: null CONDITION_USAGE_LUB,
974: null ACTION_USAGE_LUD,
975: null ACTION_USAGE_LUB
976: from ame_rules ar
977: where ar.rule_id = c_rule_id
978: and ar.last_update_date in (select max(last_update_date)
979: from ame_rules art
980: where art.rule_id = c_rule_id)

Line 979: from ame_rules art

975: null ACTION_USAGE_LUB
976: from ame_rules ar
977: where ar.rule_id = c_rule_id
978: and ar.last_update_date in (select max(last_update_date)
979: from ame_rules art
980: where art.rule_id = c_rule_id)
981: and rownum < 2
982: union
983: select null RULE_LUD,

Line 1133: from ame_rules ar

1129: null CONDITION_USAGE_LUD,
1130: null CONDITION_USAGE_LUB,
1131: null ACTION_USAGE_LUD,
1132: null ACTION_USAGE_LUB
1133: from ame_rules ar
1134: where ar.rule_id = c_rule_id
1135: and ar.last_update_date in (select max(last_update_date)
1136: from ame_rules art
1137: where art.rule_id = c_rule_id)

Line 1136: from ame_rules art

1132: null ACTION_USAGE_LUB
1133: from ame_rules ar
1134: where ar.rule_id = c_rule_id
1135: and ar.last_update_date in (select max(last_update_date)
1136: from ame_rules art
1137: where art.rule_id = c_rule_id)
1138: and rownum < 2
1139: union
1140: select null RULE_LUD,

Line 1282: from ame_rules

1278: ) return varchar2 is
1279:
1280: cursor active_rule_cursor (ruleId integer) is
1281: select rule_id
1282: from ame_rules
1283: where rule_id = ruleId
1284: and (sysdate between start_date and nvl(end_date - (1/86400),sysdate) or
1285: (start_date > sysdate and start_date < nvl(end_date,start_date + (1/86400)))
1286: );

Line 1334: from ame_rules ar

1330: cursor c_row_count (c_rule_id integer,c_application_id integer,c_rule_usage_start_date date) is
1331: select count(ar.rule_id) RULE_COUNT,
1332: null CONDITION_USAGE_COUNT,
1333: null ACTION_USAGE_COUNT
1334: from ame_rules ar
1335: where ar.rule_id = c_rule_id
1336: and ar.last_update_date > (c_rule_usage_start_date + (1/86400))
1337: union
1338: select null RULE_COUNT,

Line 1485: from ame_rules ar

1481: begin
1482: begin
1483: select max(ar.end_date)
1484: into l_rule_end_date
1485: from ame_rules ar
1486: where rule_id = p_rule_id;
1487: return l_rule_end_date;
1488: exception
1489: when no_data_found then

Line 1510: from ame_rules;

1506: begin
1507: if fnd_global.resp_name = 'AME Developer' then
1508: select min(rule_id) - 1
1509: into l_rule_id
1510: from ame_rules;
1511: else
1512: select ame_rules_s.nextval
1513: into l_rule_id
1514: from sys.dual;

Line 1512: select ame_rules_s.nextval

1508: select min(rule_id) - 1
1509: into l_rule_id
1510: from ame_rules;
1511: else
1512: select ame_rules_s.nextval
1513: into l_rule_id
1514: from sys.dual;
1515: end if;
1516: return l_rule_id;