58: BEGIN
59: IF (P_SUMMARY_OPTION is not NULL) then
60: SELECT Meaning
61: INTO C_HEAD_SUMMARY_OPTION
62: FROM FND_LOOKUPS
63: WHERE lookup_code = P_SUMMARY_OPTION
64: AND lookup_type = 'YES_NO';
65: END IF;
66:
68: BEGIN
69: IF (P_FORMAT_OPTION is not NULL) then
70: SELECT Meaning
71: INTO C_HEAD_FORMAT_OPTION
72: FROM FND_LOOKUPS
73: WHERE lookup_code = P_FORMAT_OPTION
74: AND lookup_type = 'YES_NO';
75: END IF;
76: END;
152:
153: END;
154:
155: FUNCTION get_nls_strings RETURN BOOLEAN IS
156: nls_all ap_lookup_codes.displayed_field%TYPE; nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;
157: BEGIN
158:
159: nls_all := '';
160: nls_yes := '';
163: SELECT ly.meaning,
164: ln.meaning,
165: la.displayed_field
166: INTO nls_yes, nls_no, nls_all
167: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la
168: WHERE ly.lookup_type = 'YES_NO'
169: AND ly.lookup_code = 'Y'
170: AND ln.lookup_type = 'YES_NO'
171: AND ln.lookup_code = 'N'