[Home] [Help]
1854:
1855: -- for maintaining cn_repositories.latest_processed_date
1856: SELECT nvl(latest_processed_date, to_date('01/01/1900', 'DD/MM/YYYY'))
1857: INTO l_current_processed_date
1858: FROM cn_repositories_all
1859: WHERE org_id = l_org_id;
1860:
1861: g_refresh_flag := 'Y';
1862:
2145: commit;
2146: END IF;
2147:
2148: -- for maintaining cn_repositories.latest_processed_date
2149: UPDATE cn_repositories_all
2150: SET latest_processed_date = l_current_processed_date
2151: WHERE latest_processed_date < l_current_processed_date
2152: AND org_id = l_org_id;
2153: