APPS.PO_POXPOCOM_XMLP_PKG dependencies on PO_LOOKUP_CODES

Line 11: l_sort po_lookup_codes.displayed_field%type ;

7: begin
8:
9: declare
10:
11: l_sort po_lookup_codes.displayed_field%type ;
12: begin
13: /*SRW.USER_EXIT('FND SRWINIT');*/null;
14:
15: P_SORT_1:=P_SORT;

Line 22: from po_lookup_codes

18: if P_SORT_1 is not null then
19:
20: select displayed_field
21: into l_sort
22: from po_lookup_codes
23: where lookup_code = P_SORT_1
24: and lookup_type = 'SRS ORDER BY';
25:
26: P_orderby_displayed := l_sort ;

Line 31: from po_lookup_codes

27:
28: else
29: select displayed_field
30: into l_sort
31: from po_lookup_codes
32: where lookup_code = 'VENDOR'
33: and lookup_type = 'SRS ORDER BY';
34:
35: P_orderby_displayed := l_sort ;

Line 44: from po_lookup_codes

40: if (UPPER(P_SORT_1) = 'VENDOR') THEN
41:
42: select displayed_field
43: into l_sort
44: from po_lookup_codes
45: where lookup_code = 'BUYER'
46: and lookup_type = 'SRS ORDER BY';
47:
48: P_ALT_orderby_displayed := l_sort ;

Line 54: from po_lookup_codes

50: elsif (UPPER(P_SORT_1) = 'BUYER') THEN
51:
52: select displayed_field
53: into l_sort
54: from po_lookup_codes
55: where lookup_code = 'VENDOR'
56: and lookup_type = 'SRS ORDER BY';
57:
58: P_ALT_orderby_displayed := l_sort ;

Line 155: l_sort po_lookup_codes.displayed_field%type ;

151:
152:
153: declare
154:
155: l_sort po_lookup_codes.displayed_field%type ;
156:
157: begin
158:
159: if P_SORT_1 is null then

Line 162: from po_lookup_codes

158:
159: if P_SORT_1 is null then
160: select displayed_field
161: into l_sort
162: from po_lookup_codes
163: where lookup_code = 'VENDOR'
164: and lookup_type = 'SRS ORDER BY';
165: return(l_sort);
166: elsif (UPPER(P_SORT_1) = 'VENDOR') then

Line 169: from po_lookup_codes

165: return(l_sort);
166: elsif (UPPER(P_SORT_1) = 'VENDOR') then
167: select displayed_field
168: into l_sort
169: from po_lookup_codes
170: where lookup_code = 'VENDOR'
171: and lookup_type = 'SRS ORDER BY';
172: return(l_sort);
173: else

Line 176: from po_lookup_codes

172: return(l_sort);
173: else
174: select displayed_field
175: into l_sort
176: from po_lookup_codes
177: where lookup_code = 'BUYER'
178: and lookup_type = 'SRS ORDER BY';
179: return(l_sort);
180: