APPS.PO_DOCUMENT_UTIL_PVT dependencies on PO_LOOKUP_CODES

Line 160: FROM po_lookup_codes

156:
157: l_progress := 2;
158: SELECT displayed_field
159: INTO disp_field_sta
160: FROM po_lookup_codes
161: WHERE lookup_code = DECODE(l_approved_flag,
162: 'R', l_approved_flag,
163: NVL(l_authorization_status, 'INCOMPLETE'))
164: AND lookup_type IN ( 'PO APPROVAL', 'DOCUMENT STATE' );

Line 172: FROM po_lookup_codes

168: IF l_cancel_flag = 'Y'
169: THEN
170: SELECT displayed_field
171: INTO l_temp
172: FROM po_lookup_codes
173: WHERE lookup_code = 'CANCELLED'
174: AND lookup_type = 'DOCUMENT STATE';
175: ELSE
176: l_temp := NULL;

Line 189: FROM po_lookup_codes

185: IF NVL(l_closed_code, 'OPEN') <> 'OPEN'
186: THEN
187: SELECT displayed_field
188: INTO l_temp
189: FROM po_lookup_codes
190: WHERE lookup_code = NVL(l_closed_code, 'OPEN')
191: AND lookup_type = 'DOCUMENT STATE';
192: ELSE
193: l_temp := NULL;

Line 206: FROM po_lookup_codes

202: IF l_frozen_flag= 'Y'
203: THEN
204: SELECT displayed_field
205: INTO l_temp
206: FROM po_lookup_codes
207: WHERE lookup_type = 'DOCUMENT STATE'
208: AND lookup_code = 'FROZEN';
209: ELSE
210: l_temp := NULL;

Line 223: FROM po_lookup_codes

219: IF l_user_hold_flag = 'Y'
220: THEN
221: SELECT displayed_field
222: INTO l_temp
223: FROM po_lookup_codes
224: WHERE lookup_type = 'DOCUMENT STATE'
225: AND lookup_code = 'ON HOLD';
226: ELSE
227: l_temp := NULL;