APPS.CN_SCA_INTERFACE_MAP_PVT dependencies on CN_REPOSITORIES

Line 227: p_repository_id IN cn_repositories.repository_id%TYPE,

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,
231: x_msg_data OUT NOCOPY VARCHAR2)

Line 228: p_org_id IN cn_repositories.org_id%TYPE, -- MOAC Change

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,
231: x_msg_data OUT NOCOPY VARCHAR2)
232: IS

Line 524: l_repository_id cn_repositories.repository_id%TYPE;

520: l_pkg_body_desc cn_obj_packages_v.description%TYPE;
521: l_pkg_name cn_obj_packages_v.NAME%TYPE;
522: l_creation_status BOOLEAN;
523: l_user VARCHAR2(15);
524: l_repository_id cn_repositories.repository_id%TYPE;
525:
526: l_api_name CONSTANT VARCHAR2(10) := 'MAP';
527: l_api_version CONSTANT NUMBER := 1.0;
528: l_user_id NUMBER(15) := fnd_global.user_id;

Line 623: FROM cn_repositories

619: -- Get Values for repository_id and org_id
620: ------++
621: SELECT repository_id, org_id
622: INTO l_repository_id, l_org_id
623: FROM cn_repositories
624: WHERE org_id = p_org_id; -- MOAC Change
625: ------++
626: -- Get Value For module_id
627: ------++