1855:
1856: -- for maintaining cn_repositories.latest_processed_date
1857: SELECT nvl(latest_processed_date, to_date('01/01/1900', 'DD/MM/YYYY'))
1858: INTO l_current_processed_date
1859: FROM cn_repositories_all
1860: WHERE org_id = l_org_id;
1861:
1862: g_refresh_flag := 'Y';
1863:
2161: commit;
2162: END IF;
2163:
2164: -- for maintaining cn_repositories.latest_processed_date
2165: UPDATE cn_repositories_all
2166: SET latest_processed_date = l_current_processed_date
2167: WHERE latest_processed_date < l_current_processed_date
2168: AND org_id = l_org_id;
2169: