55: RETURN (FALSE);
56: END GET_COVER_PAGE_VALUES;
57:
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;
56: END GET_COVER_PAGE_VALUES;
57:
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
57:
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
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'
79: AND LY.LOOKUP_CODE = 'Y'
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'
79: AND LY.LOOKUP_CODE = 'Y'
80: AND LN.LOOKUP_TYPE = 'YES_NO'
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'
79: AND LY.LOOKUP_CODE = 'Y'
80: AND LN.LOOKUP_TYPE = 'YES_NO'
81: AND LN.LOOKUP_CODE = 'N'
459: SELECT
460: DISPLAYED_FIELD
461: INTO L_SOURCES
462: FROM
463: AP_LOOKUP_CODES
464: WHERE LOOKUP_TYPE = 'SOURCE'
465: AND LOOKUP_CODE = p_source_t;
466: RETURN L_SOURCES;
467: END;