APPS.PO_POXSURLC_XMLP_PKG dependencies on PO_LOOKUP_CODES

Line 16: l_active_inactive po_lookup_codes.displayed_field%type ;

12: RETURN 'location_code'; end;
13: function BeforeReport return boolean is
14: begin
15: declare
16: l_active_inactive po_lookup_codes.displayed_field%type ;
17: l_sort po_lookup_codes.displayed_field%type ;
18: l_site po_lookup_codes.displayed_field%type ;
19: begin
20: /*SRW.USER_EXIT('FND SRWINIT');*/null;

Line 17: l_sort po_lookup_codes.displayed_field%type ;

13: function BeforeReport return boolean is
14: begin
15: declare
16: l_active_inactive po_lookup_codes.displayed_field%type ;
17: l_sort po_lookup_codes.displayed_field%type ;
18: l_site po_lookup_codes.displayed_field%type ;
19: begin
20: /*SRW.USER_EXIT('FND SRWINIT');*/null;
21: if P_active_inactive is not null then

Line 18: l_site po_lookup_codes.displayed_field%type ;

14: begin
15: declare
16: l_active_inactive po_lookup_codes.displayed_field%type ;
17: l_sort po_lookup_codes.displayed_field%type ;
18: l_site po_lookup_codes.displayed_field%type ;
19: begin
20: /*SRW.USER_EXIT('FND SRWINIT');*/null;
21: if P_active_inactive is not null then
22: select displayed_field

Line 24: from po_lookup_codes

20: /*SRW.USER_EXIT('FND SRWINIT');*/null;
21: if P_active_inactive is not null then
22: select displayed_field
23: into l_active_inactive
24: from po_lookup_codes
25: where lookup_code = P_active_inactive
26: and lookup_type = 'ACTIVE_INACTIVE';
27: P_active_inactive_disp := l_active_inactive ;
28: else

Line 34: from po_lookup_codes

30: end if;
31: if P_sort is not null then
32: select displayed_field
33: into l_sort
34: from po_lookup_codes
35: where lookup_code = P_sort
36: and lookup_type = 'SRS ORDER BY';
37: P_sort_disp := l_sort ;
38: else

Line 44: from po_lookup_codes

40: end if;
41: if P_site is not null then
42: select displayed_field
43: into l_site
44: from po_lookup_codes
45: where lookup_code = P_site
46: and lookup_type = 'SITE_TYPE';
47: P_site_disp := l_site ;
48: else