DBA Data[Home] [Help]

APPS.PO_POXPOEDR_XMLP_PKG dependencies on PO_LOOKUP_CODES

Line 8: l_po_type po_lookup_codes.displayed_field%type ;

4: function BeforeReport return boolean is
5: begin
6:
7: declare
8: l_po_type po_lookup_codes.displayed_field%type ;
9: begin
10: execute immediate 'Alter session set sql_trace TRUE';
11: QTY_PRECISION:= po_common_xmlp_pkg.get_precision(P_qty_precision);
12: if P_type is not null then

Line 16: from po_lookup_codes

12: if P_type is not null then
13:
14: select displayed_field
15: into l_po_type
16: from po_lookup_codes
17: where lookup_code = P_type
18: and lookup_type = 'DOCUMENT TYPE';
19:
20: P_type_displayed := l_po_type ;