Line 96: l_selected_value_v := fnd_date.date_to_canonical(l_selected_value_d);
92: if l_column_type ='D' then
93: hr_utility.set_location('date being fetched ',60);
94: execute immediate l_sel_stmt into l_selected_value_d;
95: -- converting the date to character format 96: l_selected_value_v := fnd_date.date_to_canonical(l_selected_value_d); 97: elsif l_column_type ='N' then
98: hr_utility.set_location('number being fetched ',60);
99: execute immediate l_sel_stmt into l_selected_value_n;
100: l_selected_value_v := to_char(l_selected_value_n);