112: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
113:
114: CURSOR l_repository_csr IS
115: SELECT repository_id
116: FROM cn_repositories
117: WHERE repository_id > 0
118: AND org_id=p_table_rec.org_id
119: AND application_type = 'CN';
120:
289: and org_id=p_table_rec.ORG_ID;
290:
291: CURSOR l_repository_csr IS
292: SELECT repository_id
293: FROM cn_repositories
294: WHERE repository_id > 0
295: and org_id=p_table_rec.ORG_ID
296: AND application_type = 'CN';
297: BEGIN