3: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
4: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
5: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
6: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
7: NLS_YES FND_LOOKUPS.MEANING%TYPE;
8: NLS_NO FND_LOOKUPS.MEANING%TYPE;
9: l_dummy number;
10: BEGIN
11: SELECT
4: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
5: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
6: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
7: NLS_YES FND_LOOKUPS.MEANING%TYPE;
8: NLS_NO FND_LOOKUPS.MEANING%TYPE;
9: l_dummy number;
10: BEGIN
11: SELECT
12: LY.MEANING,
15: L2.DISPLAYED_FIELD,
16: L3.DISPLAYED_FIELD
17: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_VOID,NLS_NA
18: FROM
19: FND_LOOKUPS LY,
20: FND_LOOKUPS LN,
21: AP_LOOKUP_CODES L1,
22: AP_LOOKUP_CODES L2,
23: AP_LOOKUP_CODES L3
16: L3.DISPLAYED_FIELD
17: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_VOID,NLS_NA
18: FROM
19: FND_LOOKUPS LY,
20: FND_LOOKUPS LN,
21: AP_LOOKUP_CODES L1,
22: AP_LOOKUP_CODES L2,
23: AP_LOOKUP_CODES L3
24: WHERE LY.LOOKUP_TYPE = 'YES_NO'