63:
64: END;
65:
66: FUNCTION get_nls_strings RETURN BOOLEAN IS
67: nls_void ap_lookup_codes.displayed_field%TYPE; nls_na ap_lookup_codes.displayed_field%TYPE; nls_all ap_lookup_codes.displayed_field%TYPE; nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;
68: BEGIN
69:
70: SELECT ly.meaning,
71: ln.meaning,
76: nls_no,
77: nls_all,
78: nls_void,
79: nls_na
80: FROM fnd_lookups ly,
81: fnd_lookups ln,
82: ap_lookup_codes l1,
83: ap_lookup_codes l2,
84: ap_lookup_codes l3
77: nls_all,
78: nls_void,
79: nls_na
80: FROM fnd_lookups ly,
81: fnd_lookups ln,
82: ap_lookup_codes l1,
83: ap_lookup_codes l2,
84: ap_lookup_codes l3
85: WHERE ly.lookup_type = 'YES_NO'