47: END GET_COVER_PAGE_VALUES;
48:
49: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
50: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
51: NLS_YES FND_LOOKUPS.MEANING%TYPE;
52: NLS_NO FND_LOOKUPS.MEANING%TYPE;
53: BEGIN
54: NLS_ALL := '';
55: NLS_YES := '';
48:
49: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
50: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
51: NLS_YES FND_LOOKUPS.MEANING%TYPE;
52: NLS_NO FND_LOOKUPS.MEANING%TYPE;
53: BEGIN
54: NLS_ALL := '';
55: NLS_YES := '';
56: NLS_NO := '';
59: LN.MEANING,
60: LA.DISPLAYED_FIELD
61: INTO NLS_YES,NLS_NO,NLS_ALL
62: FROM
63: FND_LOOKUPS LY,
64: FND_LOOKUPS LN,
65: AP_LOOKUP_CODES LA
66: WHERE LY.LOOKUP_TYPE = 'YES_NO'
67: AND LY.LOOKUP_CODE = 'Y'
60: LA.DISPLAYED_FIELD
61: INTO NLS_YES,NLS_NO,NLS_ALL
62: FROM
63: FND_LOOKUPS LY,
64: FND_LOOKUPS LN,
65: AP_LOOKUP_CODES LA
66: WHERE LY.LOOKUP_TYPE = 'YES_NO'
67: AND LY.LOOKUP_CODE = 'Y'
68: AND LN.LOOKUP_TYPE = 'YES_NO'