64:
65: END;
66:
67: FUNCTION get_nls_strings RETURN BOOLEAN IS
68: 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;
69: BEGIN
70:
71: SELECT ly.meaning,
72: ln.meaning,
79: nls_void,
80: nls_na
81: FROM fnd_lookups ly,
82: fnd_lookups ln,
83: ap_lookup_codes l1,
84: ap_lookup_codes l2,
85: ap_lookup_codes l3
86: WHERE ly.lookup_type = 'YES_NO'
87: AND ly.lookup_code = 'Y'
80: nls_na
81: FROM fnd_lookups ly,
82: fnd_lookups ln,
83: ap_lookup_codes l1,
84: ap_lookup_codes l2,
85: ap_lookup_codes l3
86: WHERE ly.lookup_type = 'YES_NO'
87: AND ly.lookup_code = 'Y'
88: AND ln.lookup_type = 'YES_NO'
81: FROM fnd_lookups ly,
82: fnd_lookups ln,
83: ap_lookup_codes l1,
84: ap_lookup_codes l2,
85: ap_lookup_codes l3
86: WHERE ly.lookup_type = 'YES_NO'
87: AND ly.lookup_code = 'Y'
88: AND ln.lookup_type = 'YES_NO'
89: AND ln.lookup_code = 'N'