APPS.AP_APXKIRKI_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 130: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

126: RETURN (FALSE);
127: END GET_COVER_PAGE_VALUES;
128:
129: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
130: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
131: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
132: NLS_YES FND_LOOKUPS.MEANING%TYPE;
133: NLS_NO FND_LOOKUPS.MEANING%TYPE;
134: BEGIN

Line 131: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

127: END GET_COVER_PAGE_VALUES;
128:
129: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
130: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
131: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
132: NLS_YES FND_LOOKUPS.MEANING%TYPE;
133: NLS_NO FND_LOOKUPS.MEANING%TYPE;
134: BEGIN
135: NLS_ALL := '';

Line 148: AP_LOOKUP_CODES LA,

144: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_NA
145: FROM
146: FND_LOOKUPS LY,
147: FND_LOOKUPS LN,
148: AP_LOOKUP_CODES LA,
149: AP_LOOKUP_CODES LNA
150: WHERE LY.LOOKUP_TYPE = 'YES_NO'
151: AND LY.LOOKUP_CODE = 'Y'
152: AND LN.LOOKUP_TYPE = 'YES_NO'

Line 149: AP_LOOKUP_CODES LNA

145: FROM
146: FND_LOOKUPS LY,
147: FND_LOOKUPS LN,
148: AP_LOOKUP_CODES LA,
149: AP_LOOKUP_CODES LNA
150: WHERE LY.LOOKUP_TYPE = 'YES_NO'
151: AND LY.LOOKUP_CODE = 'Y'
152: AND LN.LOOKUP_TYPE = 'YES_NO'
153: AND LN.LOOKUP_CODE = 'N'

Line 2202: AP_LOOKUP_CODES

2198: SELECT
2199: DISPLAYED_FIELD
2200: INTO L_DISPLAY_FIELD
2201: FROM
2202: AP_LOOKUP_CODES
2203: WHERE LOOKUP_TYPE = 'SOURCE'
2204: AND LOOKUP_CODE = C_INVOICE_SOURCE;
2205: RETURN L_DISPLAY_FIELD;
2206: EXCEPTION