155: l_fnd_date := to_date(to_char(fnd_api.g_miss_date, 'DD-MM-RRRR'), 'DD-MM-RRRR');
156: end_date_active := to_date(to_char(p_end_date_active, 'DD-MM-RRRR'), 'DD-MM-RRRR');
157: l_updated_by := jtf_resource_utl.updated_by;
158:
159: --Standard Start of API SAVEPOINT
160: SAVEPOINT res_save;
161:
162: l_return_status := fnd_api.g_ret_sts_success;
163: l_count := 0;
817:
818: l_fnd_date := to_date(to_char(fnd_api.g_miss_date, 'DD-MM-RRRR'), 'DD-MM-RRRR');
819: end_date_active := to_date(to_char(p_end_date_active, 'DD-MM-RRRR'), 'DD-MM-RRRR');
820:
821: --Standard Start of API SAVEPOINT
822: SAVEPOINT group_mem_roles_save;
823:
824: l_return_status := fnd_api.g_ret_sts_success;
825: