APPS.CN_SCA_INTERFACE_MAP_PVT dependencies on CN_OBJECTS

Line 224: p_name IN cn_objects.name%TYPE,

220: PROCEDURE check_create_object(
221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224: p_name IN cn_objects.name%TYPE,
225: p_object_type IN cn_objects.object_type%TYPE,
226: p_object_id IN OUT NOCOPY cn_objects.object_id%TYPE,
227: p_repository_id IN cn_repositories.repository_id%TYPE,
228: p_org_id IN cn_repositories.org_id%TYPE, -- MOAC Change

Line 225: p_object_type IN cn_objects.object_type%TYPE,

221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224: p_name IN cn_objects.name%TYPE,
225: p_object_type IN cn_objects.object_type%TYPE,
226: p_object_id IN OUT NOCOPY cn_objects.object_id%TYPE,
227: p_repository_id IN cn_repositories.repository_id%TYPE,
228: p_org_id IN cn_repositories.org_id%TYPE, -- MOAC Change
229: x_return_status OUT NOCOPY VARCHAR2,

Line 226: p_object_id IN OUT NOCOPY cn_objects.object_id%TYPE,

222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224: p_name IN cn_objects.name%TYPE,
225: p_object_type IN cn_objects.object_type%TYPE,
226: p_object_id IN OUT NOCOPY cn_objects.object_id%TYPE,
227: p_repository_id IN cn_repositories.repository_id%TYPE,
228: p_org_id IN cn_repositories.org_id%TYPE, -- MOAC Change
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,

Line 248: -- check whether Mapping Package exist in cn_objects

244:
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246:
247: ------+
248: -- check whether Mapping Package exist in cn_objects
249: ------+
250:
251: SELECT COUNT(*)
252: INTO dummy

Line 253: FROM cn_objects

249: ------+
250:
251: SELECT COUNT(*)
252: INTO dummy
253: FROM cn_objects
254: WHERE name = P_NAME
255: AND object_type = P_OBJECT_TYPE
256: AND org_id = p_org_id; -- MOAC Change
257:

Line 262: cn_objects_pkg.insert_row(

258: IF dummy = 0
259: THEN
260: P_OBJECT_ID := cn_utils.get_object_id;
261:
262: cn_objects_pkg.insert_row(
263: x_org_id => p_org_id, -- MOAC Change
264: x_rowid => x_rowid,
265: x_object_id => p_object_id,
266: x_dependency_map_complete => 'n',

Line 280: FROM cn_objects

276: ELSIF dummy = 1
277: THEN
278: SELECT object_id
279: INTO P_OBJECT_ID
280: FROM cn_objects
281: WHERE name = P_NAME
282: AND object_type = P_OBJECT_TYPE
283: AND org_id = p_org_id; -- MOAC Change
284: END IF;

Line 367: p_org_id IN cn_objects.org_id%TYPE, -- MOAC Change

363: END pkg_init;
364:
365: PROCEDURE install_package_object(
366: p_object_name IN VARCHAR2,
367: p_org_id IN cn_objects.org_id%TYPE, -- MOAC Change
368: x_compile_status OUT NOCOPY VARCHAR2,
369: x_return_status OUT NOCOPY VARCHAR2,
370: x_msg_count OUT NOCOPY NUMBER,
371: x_msg_data OUT NOCOPY VARCHAR2)

Line 398: FROM cn_objects

394: -- Get Object id of the package Body
395: ----+
396: SELECT object_id
397: INTO l_pkg_object_id
398: FROM cn_objects
399: WHERE UPPER(name) = UPPER(p_object_name)
400: AND object_type = 'PKS'
401: AND org_id = p_org_id; -- MOAC Change
402: ----+

Line 432: FROM cn_objects

428: -- Get Object id of the package Body
429: ------+
430: SELECT object_id
431: INTO l_pkg_object_id
432: FROM cn_objects
433: WHERE UPPER(name) = UPPER(p_object_name)
434: AND object_type = 'PKB'
435: AND org_id = p_org_id; -- MOAC Change
436: ------+

Line 513: l_object_id cn_objects.object_id%TYPE;

509: x_msg_count OUT NOCOPY NUMBER,
510: x_msg_data OUT NOCOPY VARCHAR2)
511: AS
512: l_module_id cn_modules.module_id%TYPE;
513: l_object_id cn_objects.object_id%TYPE;
514: l_org_id VARCHAR2(5);
515: l_pkg_spec_id cn_obj_packages_v.package_id%TYPE;
516: l_pkg_body_id cn_obj_packages_v.package_id%TYPE;
517: l_spec_code cn_utils.code_type;