APPS.AME_MULTI_TENANCY_PKG dependencies on AME_RULES

Line 1005: update ame_rules

1001: ,p_acu_start_date => l_acu_start_date
1002: ,p_acu_end_date => l_acu_end_date
1003: );
1004: --
1005: update ame_rules
1006: set created_by = getSeedUser
1007: ,last_updated_by = getSeedUser
1008: where rule_id = l_current_rule_id;
1009: --

Line 1010: update ame_rules_tl

1006: set created_by = getSeedUser
1007: ,last_updated_by = getSeedUser
1008: where rule_id = l_current_rule_id;
1009: --
1010: update ame_rules_tl
1011: set created_by = getSeedUser
1012: ,last_updated_by = getSeedUser
1013: where rule_id = l_current_rule_id;
1014: --

Line 1016: update ame_rules

1012: ,last_updated_by = getSeedUser
1013: where rule_id = l_current_rule_id;
1014: --
1015: --update the rule start date to correct value
1016: update ame_rules
1017: set start_date = sysdate
1018: where rule_id = l_current_rule_id
1019: and rule_strt_date_chd = 'Y';
1020: --

Line 1114: from ame_rules ar

1110: l_current_rul_id number;
1111: l_proc_name varchar2(100);
1112: cursor chkRule(c_rule_name in varchar2) is
1113: select count(*)
1114: from ame_rules ar
1115: ,ame_rule_usages aru
1116: where ar.rule_id = aru.rule_id
1117: and ar.description = c_rule_name
1118: and aru.item_id = g_ent_appl_id

Line 1130: from ame_rules ar

1126: aru.start_date < nvl(aru.end_date, aru.start_date + 1/86400)));
1127: --+
1128: cursor chkCustRule(c_rule_name in varchar2) is
1129: select count(*)
1130: from ame_rules ar
1131: ,ame_rule_usages aru
1132: where ar.rule_id = aru.rule_id
1133: and ar.description = c_rule_name
1134: and aru.item_id = g_ent_appl_id

Line 1170: from ame_rules ar

1166: l_proc_name varchar2(100);
1167: cursor getSeedRules is
1168: select ar.rule_id
1169: ,ar.description
1170: from ame_rules ar
1171: ,ame_rule_usages aru
1172: where ar.rule_id = aru.rule_id
1173: and aru.item_id = g_seed_appl_id
1174: and ((sysdate between ar.start_date

Line 1185: from ame_rule_usages aru, ame_rules ar

1181: aru.start_date < nvl(aru.end_date, aru.start_date + 1/86400)));
1182: --
1183: cursor chkRulUsg(c_rule_name in varchar2) is
1184: select count(*)
1185: from ame_rule_usages aru, ame_rules ar
1186: where ar.description = c_rule_name
1187: and aru.rule_id = ar.rule_id
1188: and aru.item_id = g_ent_appl_id
1189: and ((sysdate between ar.start_date

Line 1382: from ame_rules ar

1378: ,aru.end_date usage_end_date
1379: ,aru.approver_category
1380: ,aru.priority
1381: ,ar.item_class_id
1382: from ame_rules ar
1383: ,ame_rule_usages aru
1384: where aru.item_id = g_seed_appl_id
1385: and ar.rule_id = aru.rule_id
1386: and ((sysdate between ar.start_date

Line 1401: from ame_rules ar

1397: --
1398: logMessage(l_proc_name,'Reading Rule actions data');
1399: open seed_row for
1400: select acu.*
1401: from ame_rules ar
1402: ,ame_rule_usages aru
1403: ,ame_action_usages acu
1404: where aru.item_id = g_seed_appl_id
1405: and acu.rule_id = ar.rule_id

Line 1424: from ame_rules ar

1420: --
1421: logMessage(l_proc_name,'Reading Rule conditions data');
1422: open seed_row for
1423: select acu.*
1424: from ame_rules ar
1425: ,ame_rule_usages aru
1426: ,ame_condition_usages acu
1427: where aru.item_id = g_seed_appl_id
1428: and acu.rule_id = ar.rule_id