234: AND LA.LOOKUP_CODE = 'ALL';
235: C_NLS_YES := NLS_YES;
236: C_NLS_NO := NLS_NO;
237: C_NLS_ALL := NLS_ALL;
238: FND_MESSAGE.SET_NAME('SQLAP'
239: ,'AP_APPRVL_NO_DATA');
240: C_NLS_NO_DATA_EXISTS := FND_MESSAGE.GET;
241: C_NLS_NO_DATA_EXISTS := C_NLS_NO_DATA_EXISTS;
242: FND_MESSAGE.SET_NAME('SQLAP'
236: C_NLS_NO := NLS_NO;
237: C_NLS_ALL := NLS_ALL;
238: FND_MESSAGE.SET_NAME('SQLAP'
239: ,'AP_APPRVL_NO_DATA');
240: C_NLS_NO_DATA_EXISTS := FND_MESSAGE.GET;
241: C_NLS_NO_DATA_EXISTS := C_NLS_NO_DATA_EXISTS;
242: FND_MESSAGE.SET_NAME('SQLAP'
243: ,'AP_ALL_END_OF_REPORT');
244: C_NLS_END_OF_REPORT := FND_MESSAGE.GET;
238: FND_MESSAGE.SET_NAME('SQLAP'
239: ,'AP_APPRVL_NO_DATA');
240: C_NLS_NO_DATA_EXISTS := FND_MESSAGE.GET;
241: C_NLS_NO_DATA_EXISTS := C_NLS_NO_DATA_EXISTS;
242: FND_MESSAGE.SET_NAME('SQLAP'
243: ,'AP_ALL_END_OF_REPORT');
244: C_NLS_END_OF_REPORT := FND_MESSAGE.GET;
245: C_NLS_END_OF_REPORT := C_NLS_END_OF_REPORT;
246: RETURN (TRUE);
240: C_NLS_NO_DATA_EXISTS := FND_MESSAGE.GET;
241: C_NLS_NO_DATA_EXISTS := C_NLS_NO_DATA_EXISTS;
242: FND_MESSAGE.SET_NAME('SQLAP'
243: ,'AP_ALL_END_OF_REPORT');
244: C_NLS_END_OF_REPORT := FND_MESSAGE.GET;
245: C_NLS_END_OF_REPORT := C_NLS_END_OF_REPORT;
246: RETURN (TRUE);
247: RETURN NULL;
248: EXCEPTION