DBA Data[Home] [Help]

APPS.FII_AP_INV_B_C dependencies on FII_CHANGE_LOG

Line 236: FROM fii_change_log

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:

Line 260: UPDATE fii_change_log

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

Line 1940: UPDATE fii_change_log

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