75:
76: END;
77:
78: FUNCTION get_nls_strings RETURN BOOLEAN IS
79: 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;
80: BEGIN
81:
82: SELECT ly.meaning,
83: ln.meaning,
90: nls_void,
91: nls_na
92: FROM fnd_lookups ly,
93: fnd_lookups ln,
94: ap_lookup_codes l1,
95: ap_lookup_codes l2,
96: ap_lookup_codes l3
97: WHERE ly.lookup_type = 'YES_NO'
98: AND ly.lookup_code = 'Y'
91: nls_na
92: FROM fnd_lookups ly,
93: fnd_lookups ln,
94: ap_lookup_codes l1,
95: ap_lookup_codes l2,
96: ap_lookup_codes l3
97: WHERE ly.lookup_type = 'YES_NO'
98: AND ly.lookup_code = 'Y'
99: AND ln.lookup_type = 'YES_NO'
92: FROM fnd_lookups ly,
93: fnd_lookups ln,
94: ap_lookup_codes l1,
95: ap_lookup_codes l2,
96: ap_lookup_codes l3
97: WHERE ly.lookup_type = 'YES_NO'
98: AND ly.lookup_code = 'Y'
99: AND ln.lookup_type = 'YES_NO'
100: AND ln.lookup_code = 'N'