14: function BeforeReport return boolean is
15: begin
16:
17: declare
18: l_active_inactive po_lookup_codes.displayed_field%type ;
19: l_sort po_lookup_codes.displayed_field%type ;
20: begin
21:
22: /*SRW.USER_EXIT('FND SRWINIT');*/null;
15: begin
16:
17: declare
18: l_active_inactive po_lookup_codes.displayed_field%type ;
19: l_sort po_lookup_codes.displayed_field%type ;
20: begin
21:
22: /*SRW.USER_EXIT('FND SRWINIT');*/null;
23:
25: if P_active_inactive is not null then
26:
27: select displayed_field
28: into l_active_inactive
29: from po_lookup_codes
30: where lookup_code = P_active_inactive
31: and lookup_type = 'ACTIVE_INACTIVE';
32:
33: P_active_inactive_disp := l_active_inactive ;
41: if P_orderby is not null then
42:
43: select displayed_field
44: into l_sort
45: from po_lookup_codes
46: where lookup_code = P_orderby
47: and lookup_type = 'SRS ORDER BY';
48:
49: P_orderby_displayed := l_sort ;