APPS.CN_COLLECTIONS_V_PKG dependencies on CN_REPOSITORIES

Line 32: INSERT INTO cn_repositories(

28:
29:
30: IF X_source_id IS NOT NULL THEN
31:
32: INSERT INTO cn_repositories(
33: repository_id,
34: version,
35: SCHEMA,
36: status,

Line 144: UPDATE cn_repositories

140:
141:
142: IF X_source_id IS NOT NULL THEN
143:
144: UPDATE cn_repositories
145: SET version = X_version,
146: SCHEMA = X_schema,
147: status = X_status,
148: application_type = X_type,

Line 182: FROM cn_repositories

178: IS
179:
180: CURSOR ovn_csr IS
181: SELECT object_version_number
182: FROM cn_repositories
183: WHERE repository_id = x_source_id
184: AND org_id = x_org_id;
185:
186: l_ovn_csr ovn_csr%ROWTYPE;

Line 199: UPDATE cn_repositories SET

195: CLOSE ovn_csr;
196:
197: IF X_source_id IS NOT NULL THEN
198:
199: UPDATE cn_repositories SET
200: version = X_version,
201: SCHEMA = X_schema,
202: status = X_status,
203: application_type = X_type,

Line 241: SELECT cn_repositories.repository_id

237: FROM cn_modules
238: WHERE module_id = x_module_id
239: FOR UPDATE ;
240:
241: SELECT cn_repositories.repository_id
242: INTO temp_id
243: FROM cn_repositories, cn_modules
244: WHERE cn_modules.source_repository_id = cn_repositories.repository_id (+)
245: AND cn_modules.module_id = x_module_id;

Line 243: FROM cn_repositories, cn_modules

239: FOR UPDATE ;
240:
241: SELECT cn_repositories.repository_id
242: INTO temp_id
243: FROM cn_repositories, cn_modules
244: WHERE cn_modules.source_repository_id = cn_repositories.repository_id (+)
245: AND cn_modules.module_id = x_module_id;
246:
247: IF temp_id IS NOT NULL THEN

Line 244: WHERE cn_modules.source_repository_id = cn_repositories.repository_id (+)

240:
241: SELECT cn_repositories.repository_id
242: INTO temp_id
243: FROM cn_repositories, cn_modules
244: WHERE cn_modules.source_repository_id = cn_repositories.repository_id (+)
245: AND cn_modules.module_id = x_module_id;
246:
247: IF temp_id IS NOT NULL THEN
248:

Line 251: FROM cn_repositories

247: IF temp_id IS NOT NULL THEN
248:
249: SELECT repository_id
250: INTO temp_id
251: FROM cn_repositories
252: WHERE repository_id = temp_ID
253: FOR UPDATE;
254:
255: END IF;