232: end if;
233:
234: SELECT DECODE(item_value, 'Y', 'TRUE', 'FALSE')
235: INTO l_result
236: FROM fii_change_log
237: WHERE log_item = 'AP_RESUMMARIZE';
238:
239: IF l_result = 'TRUE' THEN
240:
256: WHEN NO_DATA_FOUND THEN l_count2 := 0;
257: END;
258:
259: IF (l_count1 = 0 AND l_count2 = 0) then
260: UPDATE fii_change_log
261: SET item_value = 'N',
262: last_update_date = SYSDATE,
263: last_update_login = g_fii_login_id,
264: last_updated_by = g_fii_user_id
1936: -- is not necessary since everything is
1937: -- going to be freshly loaded
1938: ---------------------------------------------
1939: g_state := 'Updating change log';
1940: UPDATE fii_change_log
1941: SET item_value = 'N',
1942: last_update_date = SYSDATE,
1943: last_update_login = g_fii_login_id,
1944: last_updated_by = g_fii_user_id