71: AND LA.LOOKUP_CODE = 'ALL';
72: C_NLS_YES := NLS_YES;
73: C_NLS_NO := NLS_NO;
74: C_NLS_ALL := NLS_ALL;
75: FND_MESSAGE.SET_NAME('SQLAP'
76: ,'AP_APPRVL_NO_DATA');
77: C_NLS_NO_DATA_EXISTS := FND_MESSAGE.GET;
78: C_NLS_NO_DATA_EXISTS := '*** ' || C_NLS_NO_DATA_EXISTS || ' ***';
79: FND_MESSAGE.SET_NAME('SQLAP'
73: C_NLS_NO := NLS_NO;
74: C_NLS_ALL := NLS_ALL;
75: FND_MESSAGE.SET_NAME('SQLAP'
76: ,'AP_APPRVL_NO_DATA');
77: C_NLS_NO_DATA_EXISTS := FND_MESSAGE.GET;
78: C_NLS_NO_DATA_EXISTS := '*** ' || C_NLS_NO_DATA_EXISTS || ' ***';
79: FND_MESSAGE.SET_NAME('SQLAP'
80: ,'AP_ALL_END_OF_REPORT');
81: C_NLS_END_OF_REPORT := FND_MESSAGE.GET;
75: FND_MESSAGE.SET_NAME('SQLAP'
76: ,'AP_APPRVL_NO_DATA');
77: C_NLS_NO_DATA_EXISTS := FND_MESSAGE.GET;
78: C_NLS_NO_DATA_EXISTS := '*** ' || C_NLS_NO_DATA_EXISTS || ' ***';
79: FND_MESSAGE.SET_NAME('SQLAP'
80: ,'AP_ALL_END_OF_REPORT');
81: C_NLS_END_OF_REPORT := FND_MESSAGE.GET;
82: C_NLS_END_OF_REPORT := '*** ' || C_NLS_END_OF_REPORT || ' ***';
83: RETURN (TRUE);
77: C_NLS_NO_DATA_EXISTS := FND_MESSAGE.GET;
78: C_NLS_NO_DATA_EXISTS := '*** ' || C_NLS_NO_DATA_EXISTS || ' ***';
79: FND_MESSAGE.SET_NAME('SQLAP'
80: ,'AP_ALL_END_OF_REPORT');
81: C_NLS_END_OF_REPORT := FND_MESSAGE.GET;
82: C_NLS_END_OF_REPORT := '*** ' || C_NLS_END_OF_REPORT || ' ***';
83: RETURN (TRUE);
84: EXCEPTION
85: WHEN OTHERS THEN