16: function BeforeReport return boolean is
17: begin
18: declare
19: init_error exception;
20: Sort_By_Name pa_lookups.meaning%TYPE;
21: begin
22: /*srw.user_exit('FND SRWINIT');*/null;
23: if P_SORT_BY is not null then
24: select meaning into Sort_By_Name from pa_lookups
20: Sort_By_Name pa_lookups.meaning%TYPE;
21: begin
22: /*srw.user_exit('FND SRWINIT');*/null;
23: if P_SORT_BY is not null then
24: select meaning into Sort_By_Name from pa_lookups
25: where lookup_code = P_SORT_BY
26: and lookup_type = 'JOB SORT BY';
27: end if;
28: C_Sort_By_Name := Sort_By_Name;