DBA Data[Home] [Help]

APPS.PO_POXVDRVL_XMLP_PKG dependencies on PO_LOOKUP_CODES

Line 20: l_active_inactive po_lookup_codes.displayed_field%type ;

16: function BeforeReport return boolean is
17: begin
18:
19: declare
20: l_active_inactive po_lookup_codes.displayed_field%type ;
21: l_sort po_lookup_codes.displayed_field%type ;
22: l_vendor_type po_lookup_codes.displayed_field%type ;
23:
24: begin

Line 21: l_sort po_lookup_codes.displayed_field%type ;

17: begin
18:
19: declare
20: l_active_inactive po_lookup_codes.displayed_field%type ;
21: l_sort po_lookup_codes.displayed_field%type ;
22: l_vendor_type po_lookup_codes.displayed_field%type ;
23:
24: begin
25:

Line 22: l_vendor_type po_lookup_codes.displayed_field%type ;

18:
19: declare
20: l_active_inactive po_lookup_codes.displayed_field%type ;
21: l_sort po_lookup_codes.displayed_field%type ;
22: l_vendor_type po_lookup_codes.displayed_field%type ;
23:
24: begin
25:
26: begin

Line 35: from po_lookup_codes

31: if P_active_inactive is not null then
32:
33: select displayed_field
34: into l_active_inactive
35: from po_lookup_codes
36: where lookup_code = P_active_inactive
37: and lookup_type = 'ACTIVE_INACTIVE';
38:
39: P_active_inactive_disp := l_active_inactive ;

Line 51: from po_lookup_codes

47: if P_vendor_type is not null then
48:
49: select displayed_field
50: into l_vendor_type
51: from po_lookup_codes
52: where lookup_code = P_vendor_type
53: and lookup_type = 'VENDOR TYPE';
54:
55: P_vendor_type_displayed := l_vendor_type ;

Line 68: from po_lookup_codes

64: if P_orderby is not null then
65:
66: select displayed_field
67: into l_sort
68: from po_lookup_codes
69: where lookup_code = P_orderby
70: and lookup_type = 'SRS ORDER BY';
71:
72: P_orderby_displayed := l_sort ;