DBA Data[Home] [Help]

APPS.AME_RULE_API dependencies on AME_CNU_DEL

Line 2903: ame_cnu_del.del(p_effective_date => l_effective_date

2899: for tempConditions in getConditions loop
2900: l_cnu_object_version_number := tempConditions.object_version_number;
2901: l_cnu_start_date := tempConditions.start_date;
2902: l_cnu_end_date := tempConditions.end_date;
2903: ame_cnu_del.del(p_effective_date => l_effective_date
2904: ,p_datetrack_mode => hr_api.g_delete
2905: ,p_rule_id => p_rule_id
2906: ,p_condition_id => tempConditions.condition_id
2907: ,p_object_version_number => l_cnu_object_version_number

Line 3239: ame_cnu_del.del(p_effective_date => l_effective_date

3235: close getConditionType;
3236: --
3237: -- delete the row in ame_condition_usages
3238: --
3239: ame_cnu_del.del(p_effective_date => l_effective_date
3240: ,p_datetrack_mode => hr_api.g_delete
3241: ,p_rule_id => p_rule_id
3242: ,p_condition_id => p_condition_id
3243: ,p_object_version_number => l_cnu_object_version_number

Line 3819: ame_cnu_del.del(p_effective_date => l_effective_date

3815: and ((sysdate between start_date and nvl(end_date - (1/86400),sysdate))
3816: or
3817: (sysdate < start_date and start_date < nvl(end_date, start_date + (1/86400)))
3818: );
3819: ame_cnu_del.del(p_effective_date => l_effective_date
3820: ,p_datetrack_mode => hr_api.g_delete
3821: ,p_rule_id => p_rule_id
3822: ,p_condition_id => l_old_condition_id
3823: ,p_object_version_number => l_cnu_object_version_number