APPS.AME_MULTI_TENANCY_PKG dependencies on AME_ACTION_USAGES

Line 1027: update ame_action_usages

1023: where rule_id = l_current_rule_id
1024: and item_id = g_ent_appl_id
1025: and rule_strt_date_chd = 'Y';
1026: --
1027: update ame_action_usages
1028: set start_date = sysdate
1029: where rule_id = l_current_rule_id
1030: and rule_strt_date_chd = 'Y';
1031: --

Line 1043: update ame_action_usages

1039: ,last_updated_by = getSeedUser
1040: where rule_id = l_current_rule_id
1041: and sysdate between start_date and nvl(end_Date,sysdate);
1042: --
1043: update ame_action_usages
1044: set created_by = getSeedUser
1045: ,last_updated_by = getSeedUser
1046: where rule_id = l_current_rule_id
1047: and action_id = l_action_id;

Line 1085: update ame_action_usages

1081: ,p_object_version_number => l_rule_ovn
1082: ,p_start_date => l_rule_start_date
1083: ,p_end_date => l_rule_end_Date
1084: );
1085: update ame_action_usages
1086: set created_by = getSeedUser
1087: ,last_updated_by = getSeedUser
1088: where rule_id = l_current_rule_id
1089: and action_id = l_action_id

Line 1403: ,ame_action_usages acu

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