APPS.AP_APXINMHD_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 243: l_nls_all ap_lookup_codes.displayed_field%TYPE;

239:
240: FUNCTION get_nls_strings RETURN BOOLEAN IS
241: l_nls_yes fnd_lookups.meaning%TYPE;
242: l_nls_no fnd_lookups.meaning%TYPE;
243: l_nls_all ap_lookup_codes.displayed_field%TYPE;
244: l_nls_na ap_lookup_codes.displayed_field%TYPE;
245:
246: BEGIN
247: SELECT ly.meaning,

Line 244: l_nls_na ap_lookup_codes.displayed_field%TYPE;

240: FUNCTION get_nls_strings RETURN BOOLEAN IS
241: l_nls_yes fnd_lookups.meaning%TYPE;
242: l_nls_no fnd_lookups.meaning%TYPE;
243: l_nls_all ap_lookup_codes.displayed_field%TYPE;
244: l_nls_na ap_lookup_codes.displayed_field%TYPE;
245:
246: BEGIN
247: SELECT ly.meaning,
248: ln.meaning,

Line 252: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la,

248: ln.meaning,
249: la.displayed_field,
250: la1.displayed_field
251: INTO l_nls_yes, l_nls_no, l_nls_all ,l_nls_na
252: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la,
253: ap_lookup_codes la1
254: WHERE ly.lookup_type = 'YES_NO'
255: AND ly.lookup_code = 'Y'
256: AND ln.lookup_type = 'YES_NO'

Line 253: ap_lookup_codes la1

249: la.displayed_field,
250: la1.displayed_field
251: INTO l_nls_yes, l_nls_no, l_nls_all ,l_nls_na
252: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la,
253: ap_lookup_codes la1
254: WHERE ly.lookup_type = 'YES_NO'
255: AND ly.lookup_code = 'Y'
256: AND ln.lookup_type = 'YES_NO'
257: AND ln.lookup_code = 'N'

Line 291: l_nls_released ap_lookup_codes.displayed_field%TYPE;

287: RETURN (FALSE);
288: END;
289:
290: FUNCTION get_nls_released_held RETURN BOOLEAN IS
291: l_nls_released ap_lookup_codes.displayed_field%TYPE;
292: l_nls_held ap_lookup_codes.displayed_field%TYPE;
293:
294: BEGIN
295:

Line 292: l_nls_held ap_lookup_codes.displayed_field%TYPE;

288: END;
289:
290: FUNCTION get_nls_released_held RETURN BOOLEAN IS
291: l_nls_released ap_lookup_codes.displayed_field%TYPE;
292: l_nls_held ap_lookup_codes.displayed_field%TYPE;
293:
294: BEGIN
295:
296: SELECT a1c1.displayed_field, a1c2.displayed_field

Line 298: FROM ap_lookup_codes a1c1, ap_lookup_codes a1c2

294: BEGIN
295:
296: SELECT a1c1.displayed_field, a1c2.displayed_field
297: INTO l_nls_released, l_nls_held
298: FROM ap_lookup_codes a1c1, ap_lookup_codes a1c2
299: WHERE a1c1.lookup_type = 'INVOICE HOLD STATUS'
300: AND a1c1.lookup_code = 'RELEASED'
301: AND a1c2.lookup_type = 'INVOICE HOLD STATUS'
302: AND a1c2.lookup_code = 'HELD';