DBA Data[Home] [Help]

APPS.PO_POXACTPO_XMLP_PKG dependencies on PO_LOOKUP_CODES

Line 15: l_po_type po_lookup_codes.displayed_field%type ;

11:
12:
13: declare
14:
15: l_po_type po_lookup_codes.displayed_field%type ;
16: l_sort po_lookup_codes.displayed_field%type ;
17:
18:
19: begin

Line 16: l_sort po_lookup_codes.displayed_field%type ;

12:
13: declare
14:
15: l_po_type po_lookup_codes.displayed_field%type ;
16: l_sort po_lookup_codes.displayed_field%type ;
17:
18:
19: begin
20:

Line 25: from po_lookup_codes

21: if P_type is not null then
22:
23: select displayed_field
24: into l_po_type
25: from po_lookup_codes
26: where lookup_code = P_type
27: and lookup_type = 'PO TYPE';
28:
29: P_type_displayed := l_po_type ;

Line 41: from po_lookup_codes

37: if P_orderby is not null then
38:
39: select displayed_field
40: into l_sort
41: from po_lookup_codes
42: where lookup_code = P_orderby
43: and lookup_type = 'SRS ORDER BY';
44:
45: P_orderby_displayed := l_sort ;