63:
64: END;
65:
66: FUNCTION get_nls_strings RETURN BOOLEAN IS
67: nls_void ap_lookup_codes.displayed_field%TYPE;
68: nls_na ap_lookup_codes.displayed_field%TYPE;
69: nls_all ap_lookup_codes.displayed_field%TYPE;
70: nls_type po_lookup_codes.displayed_field%TYPE;
71: nls_yes fnd_lookups.meaning%TYPE;
64: END;
65:
66: FUNCTION get_nls_strings RETURN BOOLEAN IS
67: nls_void ap_lookup_codes.displayed_field%TYPE;
68: nls_na ap_lookup_codes.displayed_field%TYPE;
69: nls_all ap_lookup_codes.displayed_field%TYPE;
70: nls_type po_lookup_codes.displayed_field%TYPE;
71: nls_yes fnd_lookups.meaning%TYPE;
72: nls_no fnd_lookups.meaning%TYPE;
65:
66: FUNCTION get_nls_strings RETURN BOOLEAN IS
67: nls_void ap_lookup_codes.displayed_field%TYPE;
68: nls_na ap_lookup_codes.displayed_field%TYPE;
69: nls_all ap_lookup_codes.displayed_field%TYPE;
70: nls_type po_lookup_codes.displayed_field%TYPE;
71: nls_yes fnd_lookups.meaning%TYPE;
72: nls_no fnd_lookups.meaning%TYPE;
73: BEGIN
83: nls_void,
84: nls_na
85: FROM fnd_lookups ly,
86: fnd_lookups ln,
87: ap_lookup_codes l1,
88: ap_lookup_codes l2,
89: ap_lookup_codes l3
90: WHERE ly.lookup_type = 'YES_NO'
91: AND ly.lookup_code = 'Y'
84: nls_na
85: FROM fnd_lookups ly,
86: fnd_lookups ln,
87: ap_lookup_codes l1,
88: ap_lookup_codes l2,
89: ap_lookup_codes l3
90: WHERE ly.lookup_type = 'YES_NO'
91: AND ly.lookup_code = 'Y'
92: AND ln.lookup_type = 'YES_NO'
85: FROM fnd_lookups ly,
86: fnd_lookups ln,
87: ap_lookup_codes l1,
88: ap_lookup_codes l2,
89: ap_lookup_codes l3
90: WHERE ly.lookup_type = 'YES_NO'
91: AND ly.lookup_code = 'Y'
92: AND ln.lookup_type = 'YES_NO'
93: AND ln.lookup_code = 'N'