6: function BeforeReport return boolean is
7: begin
8:
9: declare
10: l_active_inactive po_lookup_codes.displayed_field%type ;
11: l_sort po_lookup_codes.displayed_field%type ;
12: begin
13:
14: if P_active_inactive is not null then
7: begin
8:
9: declare
10: l_active_inactive po_lookup_codes.displayed_field%type ;
11: l_sort po_lookup_codes.displayed_field%type ;
12: begin
13:
14: if P_active_inactive is not null then
15:
14: if P_active_inactive is not null then
15:
16: select displayed_field
17: into l_active_inactive
18: from po_lookup_codes
19: where lookup_code = P_active_inactive
20: and lookup_type = 'ACTIVE_INACTIVE';
21:
22: P_active_inactive_disp := l_active_inactive ;
31: if P_orderby is not null then
32:
33: select displayed_field
34: into l_sort
35: from po_lookup_codes
36: where lookup_code = P_orderby
37: and lookup_type = 'SRS ORDER BY';
38:
39: P_orderby_displayed := l_sort ;