58: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
59: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
60: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
61: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
62: NLS_YES FND_LOOKUPS.MEANING%TYPE;
63: NLS_NO FND_LOOKUPS.MEANING%TYPE;
64: BEGIN
65: SELECT
66: LY.MEANING,
59: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
60: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
61: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
62: NLS_YES FND_LOOKUPS.MEANING%TYPE;
63: NLS_NO FND_LOOKUPS.MEANING%TYPE;
64: BEGIN
65: SELECT
66: LY.MEANING,
67: LN.MEANING,
69: L2.DISPLAYED_FIELD,
70: L3.DISPLAYED_FIELD
71: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_VOID,NLS_NA
72: FROM
73: FND_LOOKUPS LY,
74: FND_LOOKUPS LN,
75: AP_LOOKUP_CODES L1,
76: AP_LOOKUP_CODES L2,
77: AP_LOOKUP_CODES L3
70: L3.DISPLAYED_FIELD
71: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_VOID,NLS_NA
72: FROM
73: FND_LOOKUPS LY,
74: FND_LOOKUPS LN,
75: AP_LOOKUP_CODES L1,
76: AP_LOOKUP_CODES L2,
77: AP_LOOKUP_CODES L3
78: WHERE LY.LOOKUP_TYPE = 'YES_NO'
493: SELECT
494: MEANING
495: INTO L_PURGE_FLAG
496: FROM
497: FND_LOOKUPS
498: WHERE LOOKUP_CODE = p_purge_flag_t
499: AND LOOKUP_TYPE = 'YES_NO';
500: CP_PURGE_FLAG := L_PURGE_FLAG;
501: ELSE