65: AND LA.LOOKUP_CODE = 'ALL';
66: C_NLS_YES := NLS_YES;
67: C_NLS_NO := NLS_NO;
68: C_NLS_ALL := NLS_ALL;
69: FND_MESSAGE.SET_NAME('SQLAP'
70: ,'AP_APPRVL_NO_DATA');
71: C_NLS_NO_DATA_EXISTS := FND_MESSAGE.GET;
72: C_NLS_NO_DATA_EXISTS := '*** ' || C_NLS_NO_DATA_EXISTS || ' ***';
73: FND_MESSAGE.SET_NAME('SQLAP'
67: C_NLS_NO := NLS_NO;
68: C_NLS_ALL := NLS_ALL;
69: FND_MESSAGE.SET_NAME('SQLAP'
70: ,'AP_APPRVL_NO_DATA');
71: C_NLS_NO_DATA_EXISTS := FND_MESSAGE.GET;
72: C_NLS_NO_DATA_EXISTS := '*** ' || C_NLS_NO_DATA_EXISTS || ' ***';
73: FND_MESSAGE.SET_NAME('SQLAP'
74: ,'AP_ALL_END_OF_REPORT');
75: C_NLS_END_OF_REPORT := FND_MESSAGE.GET;
69: FND_MESSAGE.SET_NAME('SQLAP'
70: ,'AP_APPRVL_NO_DATA');
71: C_NLS_NO_DATA_EXISTS := FND_MESSAGE.GET;
72: C_NLS_NO_DATA_EXISTS := '*** ' || C_NLS_NO_DATA_EXISTS || ' ***';
73: FND_MESSAGE.SET_NAME('SQLAP'
74: ,'AP_ALL_END_OF_REPORT');
75: C_NLS_END_OF_REPORT := FND_MESSAGE.GET;
76: C_NLS_END_OF_REPORT := '*** ' || C_NLS_END_OF_REPORT || ' ***';
77: RETURN (TRUE);
71: C_NLS_NO_DATA_EXISTS := FND_MESSAGE.GET;
72: C_NLS_NO_DATA_EXISTS := '*** ' || C_NLS_NO_DATA_EXISTS || ' ***';
73: FND_MESSAGE.SET_NAME('SQLAP'
74: ,'AP_ALL_END_OF_REPORT');
75: C_NLS_END_OF_REPORT := FND_MESSAGE.GET;
76: C_NLS_END_OF_REPORT := '*** ' || C_NLS_END_OF_REPORT || ' ***';
77: RETURN (TRUE);
78: RETURN NULL;
79: EXCEPTION