320: WHEN OTHERS THEN
321: RETURN (FALSE);
322: END GET_COMPANY_NAME;
323: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
324: NLS_YES FND_LOOKUPS.MEANING%TYPE;
325: NLS_NO FND_LOOKUPS.MEANING%TYPE;
326: L_NLS_ACTIVE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
327: L_NLS_INACTIVE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
328: NLS_ACTIVE FND_LOOKUPS.MEANING%TYPE;
321: RETURN (FALSE);
322: END GET_COMPANY_NAME;
323: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
324: NLS_YES FND_LOOKUPS.MEANING%TYPE;
325: NLS_NO FND_LOOKUPS.MEANING%TYPE;
326: L_NLS_ACTIVE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
327: L_NLS_INACTIVE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
328: NLS_ACTIVE FND_LOOKUPS.MEANING%TYPE;
329: NLS_ALL FND_LOOKUPS.MEANING%TYPE;
324: NLS_YES FND_LOOKUPS.MEANING%TYPE;
325: NLS_NO FND_LOOKUPS.MEANING%TYPE;
326: L_NLS_ACTIVE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
327: L_NLS_INACTIVE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
328: NLS_ACTIVE FND_LOOKUPS.MEANING%TYPE;
329: NLS_ALL FND_LOOKUPS.MEANING%TYPE;
330: BEGIN
331: NLS_YES := '';
332: NLS_NO := '';
325: NLS_NO FND_LOOKUPS.MEANING%TYPE;
326: L_NLS_ACTIVE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
327: L_NLS_INACTIVE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
328: NLS_ACTIVE FND_LOOKUPS.MEANING%TYPE;
329: NLS_ALL FND_LOOKUPS.MEANING%TYPE;
330: BEGIN
331: NLS_YES := '';
332: NLS_NO := '';
333: SELECT
340: AP_UTILITIES_PKG.AP_GET_DISPLAYED_FIELD('ALL OR ACTIVE'
341: ,'All')
342: INTO NLS_YES,NLS_NO,L_NLS_ACTIVE,L_NLS_INACTIVE,NLS_ACTIVE,NLS_ALL
343: FROM
344: FND_LOOKUPS LY,
345: FND_LOOKUPS LN,
346: AP_LOOKUP_CODES LA,
347: AP_LOOKUP_CODES LI
348: WHERE LY.LOOKUP_TYPE = 'YES_NO'
341: ,'All')
342: INTO NLS_YES,NLS_NO,L_NLS_ACTIVE,L_NLS_INACTIVE,NLS_ACTIVE,NLS_ALL
343: FROM
344: FND_LOOKUPS LY,
345: FND_LOOKUPS LN,
346: AP_LOOKUP_CODES LA,
347: AP_LOOKUP_CODES LI
348: WHERE LY.LOOKUP_TYPE = 'YES_NO'
349: AND LY.LOOKUP_CODE = 'Y'