DBA Data[Home] [Help]

APPS.PQH_SIT_ENGINE dependencies on FND_DATE

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);