APPS.CN_SCA_RULES_BATCH_GEN_PVT dependencies on CN_OBJECTS

Line 182: x_name cn_objects.name%TYPE,

178:
179:
180:
181: PROCEDURE check_create_object(
182: x_name cn_objects.name%TYPE,
183: x_object_type cn_objects.object_type%TYPE,
184: x_object_id IN OUT NOCOPY cn_objects.object_id%TYPE,
185: x_repository_id cn_repositories.repository_id%TYPE) IS
186: --

Line 183: x_object_type cn_objects.object_type%TYPE,

179:
180:
181: PROCEDURE check_create_object(
182: x_name cn_objects.name%TYPE,
183: x_object_type cn_objects.object_type%TYPE,
184: x_object_id IN OUT NOCOPY cn_objects.object_id%TYPE,
185: x_repository_id cn_repositories.repository_id%TYPE) IS
186: --
187: dummy NUMBER;

Line 184: x_object_id IN OUT NOCOPY cn_objects.object_id%TYPE,

180:
181: PROCEDURE check_create_object(
182: x_name cn_objects.name%TYPE,
183: x_object_type cn_objects.object_type%TYPE,
184: x_object_id IN OUT NOCOPY cn_objects.object_id%TYPE,
185: x_repository_id cn_repositories.repository_id%TYPE) IS
186: --
187: dummy NUMBER;
188: x_rowid ROWID;

Line 191: -- Check whether this package exists in the cn_objects or not.

187: dummy NUMBER;
188: x_rowid ROWID;
189: --
190: BEGIN
191: -- Check whether this package exists in the cn_objects or not.
192: SELECT COUNT(1)
193: INTO dummy
194: FROM cn_objects
195: WHERE name = x_name

Line 194: FROM cn_objects

190: BEGIN
191: -- Check whether this package exists in the cn_objects or not.
192: SELECT COUNT(1)
193: INTO dummy
194: FROM cn_objects
195: WHERE name = x_name
196: AND object_type = x_object_type;
197: --
198: IF (dummy = 0) THEN

Line 201: cn_objects_pkg.insert_row( x_rowid => x_rowid,

197: --
198: IF (dummy = 0) THEN
199: --
200: x_object_id := cn_utils.get_object_id;
201: cn_objects_pkg.insert_row( x_rowid => x_rowid,
202: x_object_id => x_object_id,
203: x_org_id => g_org_id,
204: x_dependency_map_complete => 'N',
205: x_name => x_name,

Line 217: FROM cn_objects

213: --
214: ELSIF (dummy = 1) THEN
215: SELECT object_id
216: INTO x_object_id
217: FROM cn_objects
218: WHERE name = x_name
219: AND object_type = x_object_type;
220: END IF;
221: --

Line 811: FROM cn_objects co

807:
808: IF l_status THEN /* created successfully. Continue to install it. */
809: SELECT co.object_id
810: INTO l_pkg_object_id
811: FROM cn_objects co
812: WHERE co.name = l_pkg_name
813: AND co.object_type = 'PKS'
814: AND co.org_id = g_org_id;
815:

Line 836: FROM cn_objects co

832: sqlstring := empty_sqlstring;
833:
834: SELECT co.object_id
835: INTO l_pkg_object_id
836: FROM cn_objects co
837: WHERE co.name = l_pkg_name
838: AND co.object_type = 'PKB'
839: AND co.org_id = g_org_id;
840: