DBA Data[Home] [Help]

APPS.AME_MULTI_TENANCY_PKG dependencies on AME_RULE_USAGES

Line 1021: update ame_rule_usages

1017: set start_date = sysdate
1018: where rule_id = l_current_rule_id
1019: and rule_strt_date_chd = 'Y';
1020: --
1021: update ame_rule_usages
1022: set start_date = sysdate
1023: where rule_id = l_current_rule_id
1024: and item_id = g_ent_appl_id
1025: and rule_strt_date_chd = 'Y';

Line 1037: update ame_rule_usages

1033: set start_date = sysdate
1034: where rule_id = l_current_rule_id
1035: and rule_strt_date_chd = 'Y';
1036: --
1037: update ame_rule_usages
1038: set created_by = getSeedUser
1039: ,last_updated_by = getSeedUser
1040: where rule_id = l_current_rule_id
1041: and sysdate between start_date and nvl(end_Date,sysdate);

Line 1115: ,ame_rule_usages aru

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
1119: and ((sysdate between ar.start_date

Line 1131: ,ame_rule_usages aru

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
1135: and (sysdate > aru.end_Date or sysdate > ar.end_Date);

Line 1171: ,ame_rule_usages aru

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
1175: and nvl(ar.end_date + 1/86400,sysdate)) or

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 1383: ,ame_rule_usages aru

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
1387: and nvl(ar.end_date + 1/86400,sysdate)) or

Line 1402: ,ame_rule_usages aru

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
1406: and ar.rule_id = aru.rule_id

Line 1425: ,ame_rule_usages aru

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
1429: and ar.rule_id = aru.rule_id