403: end if;
404:
405: SELECT DECODE(item_value, 'Y', 'TRUE', 'FALSE')
406: INTO l_slg_chg
407: FROM fii_change_log
408: WHERE log_item = 'FA_RESUMMARIZE';
409:
410: IF l_slg_chg = 'TRUE' THEN
411:
433: end;
434:
435:
436: IF (l_count1 = 0 AND l_count2 = 0) then
437: g_phase := 'Updating fii_change_log for log_item FA_RESUMMARIZE';
438: UPDATE fii_change_log
439: SET item_value = 'N',
440: last_update_date = SYSDATE,
441: last_update_login = g_fii_login_id,
434:
435:
436: IF (l_count1 = 0 AND l_count2 = 0) then
437: g_phase := 'Updating fii_change_log for log_item FA_RESUMMARIZE';
438: UPDATE fii_change_log
439: SET item_value = 'N',
440: last_update_date = SYSDATE,
441: last_update_login = g_fii_login_id,
442: last_updated_by = g_fii_user_id
2210: -- FA will only be using the resummarize log
2211: -- item, not product change since we can handle
2212: -- new books, etc
2213: ---------------------------------------------
2214: g_phase := 'Update fii_change_log if we are running in Inital Load';
2215:
2216: UPDATE fii_change_log
2217: SET item_value = 'N',
2218: last_update_date = SYSDATE,
2212: -- new books, etc
2213: ---------------------------------------------
2214: g_phase := 'Update fii_change_log if we are running in Inital Load';
2215:
2216: UPDATE fii_change_log
2217: SET item_value = 'N',
2218: last_update_date = SYSDATE,
2219: last_update_login = g_fii_login_id,
2220: last_updated_by = g_fii_user_id