DBA Data[Home] [Help]

APPS.AP_APXWTGNR_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 186: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

182: RETURN (FALSE);
183: END GET_COVER_PAGE_VALUES;
184:
185: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
186: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
187: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
188: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
189: NLS_YES FND_LOOKUPS.MEANING%TYPE;
190: NLS_NO FND_LOOKUPS.MEANING%TYPE;

Line 187: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

183: END GET_COVER_PAGE_VALUES;
184:
185: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
186: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
187: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
188: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
189: NLS_YES FND_LOOKUPS.MEANING%TYPE;
190: NLS_NO FND_LOOKUPS.MEANING%TYPE;
191: BEGIN

Line 188: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

184:
185: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
186: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
187: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
188: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
189: NLS_YES FND_LOOKUPS.MEANING%TYPE;
190: NLS_NO FND_LOOKUPS.MEANING%TYPE;
191: BEGIN
192: SELECT

Line 202: AP_LOOKUP_CODES L1,

198: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_VOID,NLS_NA
199: FROM
200: FND_LOOKUPS LY,
201: FND_LOOKUPS LN,
202: AP_LOOKUP_CODES L1,
203: AP_LOOKUP_CODES L2,
204: AP_LOOKUP_CODES L3
205: WHERE LY.LOOKUP_TYPE = 'YES_NO'
206: AND LY.LOOKUP_CODE = 'Y'

Line 203: AP_LOOKUP_CODES L2,

199: FROM
200: FND_LOOKUPS LY,
201: FND_LOOKUPS LN,
202: AP_LOOKUP_CODES L1,
203: AP_LOOKUP_CODES L2,
204: AP_LOOKUP_CODES L3
205: WHERE LY.LOOKUP_TYPE = 'YES_NO'
206: AND LY.LOOKUP_CODE = 'Y'
207: AND LN.LOOKUP_TYPE = 'YES_NO'

Line 204: AP_LOOKUP_CODES L3

200: FND_LOOKUPS LY,
201: FND_LOOKUPS LN,
202: AP_LOOKUP_CODES L1,
203: AP_LOOKUP_CODES L2,
204: AP_LOOKUP_CODES L3
205: WHERE LY.LOOKUP_TYPE = 'YES_NO'
206: AND LY.LOOKUP_CODE = 'Y'
207: AND LN.LOOKUP_TYPE = 'YES_NO'
208: AND LN.LOOKUP_CODE = 'N'