DBA Data[Home] [Help]

APPS.PO_POXAGLST_XMLP_PKG dependencies on PO_LOOKUP_CODES

Line 10: l_active_inactive po_lookup_codes.displayed_field%type ;

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

Line 11: l_sort po_lookup_codes.displayed_field%type ;

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:

Line 18: from po_lookup_codes

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 ;

Line 35: from po_lookup_codes

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 ;