DBA Data[Home] [Help]

APPS.AME_MULTI_TENANCY_PKG dependencies on AME_CONDITION_USAGES

Line 1032: update ame_condition_usages

1028: set start_date = sysdate
1029: where rule_id = l_current_rule_id
1030: and rule_strt_date_chd = 'Y';
1031: --
1032: update ame_condition_usages
1033: set start_date = sysdate
1034: where rule_id = l_current_rule_id
1035: and rule_strt_date_chd = 'Y';
1036: --

Line 1049: update ame_condition_usages

1045: ,last_updated_by = getSeedUser
1046: where rule_id = l_current_rule_id
1047: and action_id = l_action_id;
1048: --
1049: update ame_condition_usages
1050: set created_by = getSeedUser
1051: ,last_updated_by = getSeedUser
1052: where rule_id = l_current_rule_id
1053: and condition_id = l_conditionid;

Line 1066: update ame_condition_usages

1062: ,p_start_date => l_rule_start_date
1063: ,p_end_date => l_rule_end_Date
1064: );
1065: --
1066: update ame_condition_usages
1067: set created_by = getSeedUser
1068: ,last_updated_by = getSeedUser
1069: where rule_id = l_current_rule_id
1070: and condition_id = l_cond_list(i)

Line 1426: ,ame_condition_usages acu

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