137: AND LA.LOOKUP_CODE = 'ALL';
138: C_NLS_YES := NLS_YES;
139: C_NLS_NO := NLS_NO;
140: C_NLS_ALL := NLS_ALL;
141: FND_MESSAGE.SET_NAME('SQLAP'
142: ,'AP_APPRVL_NO_DATA');
143: NLS_NO_DATA := '*** ' || FND_MESSAGE.GET || ' ***';
144: FND_MESSAGE.SET_NAME('SQLAP'
145: ,'AP_ALL_END_OF_REPORT');
139: C_NLS_NO := NLS_NO;
140: C_NLS_ALL := NLS_ALL;
141: FND_MESSAGE.SET_NAME('SQLAP'
142: ,'AP_APPRVL_NO_DATA');
143: NLS_NO_DATA := '*** ' || FND_MESSAGE.GET || ' ***';
144: FND_MESSAGE.SET_NAME('SQLAP'
145: ,'AP_ALL_END_OF_REPORT');
146: NLS_END := '*** ' || FND_MESSAGE.GET || ' ***';
147: C_NLS_NO_DATA_EXISTS := NLS_NO_DATA;
140: C_NLS_ALL := NLS_ALL;
141: FND_MESSAGE.SET_NAME('SQLAP'
142: ,'AP_APPRVL_NO_DATA');
143: NLS_NO_DATA := '*** ' || FND_MESSAGE.GET || ' ***';
144: FND_MESSAGE.SET_NAME('SQLAP'
145: ,'AP_ALL_END_OF_REPORT');
146: NLS_END := '*** ' || FND_MESSAGE.GET || ' ***';
147: C_NLS_NO_DATA_EXISTS := NLS_NO_DATA;
148: C_NLS_END_OF_REPORT := NLS_END;
142: ,'AP_APPRVL_NO_DATA');
143: NLS_NO_DATA := '*** ' || FND_MESSAGE.GET || ' ***';
144: FND_MESSAGE.SET_NAME('SQLAP'
145: ,'AP_ALL_END_OF_REPORT');
146: NLS_END := '*** ' || FND_MESSAGE.GET || ' ***';
147: C_NLS_NO_DATA_EXISTS := NLS_NO_DATA;
148: C_NLS_END_OF_REPORT := NLS_END;
149: RETURN (TRUE);
150: RETURN NULL;