APPS.CN_IMP_MAPS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 100

	 SELECT imp_map_id,object_version_number
	   INTO l_imp_map.imp_map_id,
	   l_imp_map.object_version_number
	   FROM cn_imp_maps
	   WHERE imp_map_id = p_imp_map.imp_map_id
	   ;

Line: 125

      UPDATE cn_imp_maps
	SET object_version_number = l_imp_map.object_version_number + 1
	WHERE imp_map_id = p_imp_map.imp_map_id
	;

Line: 131

      DELETE FROM cn_imp_map_fields
	WHERE imp_map_id = p_imp_map.imp_map_id;

Line: 140

   SELECT t.table_id,t.view_name
     INTO l_imp_map_field.target_table_id,l_imp_map_field.target_table_name
     FROM cn_imp_maps m, cn_import_types t
     WHERE m.imp_map_id = l_imp_map.imp_map_id
     AND m.import_type_code = t.import_type_code
     ;

Line: 149

      SELECT cn_imp_map_fields_s.nextval
	INTO l_imp_map_field.imp_map_field_id
	FROM sys.dual ;

Line: 154

      SELECT object_id,name
	INTO l_imp_map_field.target_object_id,
	l_imp_map_field.target_column_name
	FROM cn_objects
	WHERE table_id = l_imp_map_field.target_table_id
	AND object_id = p_target_fields(i)
	AND object_type = 'COL' AND ORG_ID = p_org_id
	;

Line: 177

      cn_imp_map_fields_pkg.insert_row
	(p_imp_map_fields_rec  => l_imp_map_field);

Line: 186

      SELECT COUNT(1)
	INTO l_temp
	FROM cn_objects o
	WHERE o.table_id = l_imp_map_field.target_table_id
	AND o.nullable = l_nullable
	AND object_type = l_obj_type
	AND o.name  NOT IN ('IMP_LINE_ID','LAST_UPDATE_DATE','LAST_UPDATED_BY','CREATION_DATE','CREATED_BY','LAST_UPDATE_LOGIN','OBJECT_VERSION_NUMBER','IMP_HEADER_ID','STATUS_CODE','ERROR_CODE','ERROR_MSG','RECORD_NUM','IMPORT_TYPE_CODE')
	AND NOT exists (SELECT  'X' FROM cn_imp_map_fields i
			WHERE i.imp_map_id = l_imp_map.imp_map_id
			AND i.target_object_id = o.object_id
			)
	AND o.ORG_ID = p_org_id
	;

Line: 213

   UPDATE cn_imp_headers
     SET imp_map_id = l_imp_map.imp_map_id,
     source_column_num = p_src_column_num
     WHERE imp_header_id = p_imp_header_id
     ;

Line: 320

	 SELECT object_id value,name colname,nullable,
	   Decode(Nvl(nullable,'Y'),'N','* ','') || user_name text
	   FROM cn_objects
	   WHERE table_id = c_table_id
	   AND object_type = 'COL'
	   AND name NOT IN ('IMP_LINE_ID','LAST_UPDATE_DATE','LAST_UPDATED_BY','CREATION_DATE','CREATED_BY','LAST_UPDATE_LOGIN','OBJECT_VERSION_NUMBER','IMP_HEADER_ID','STATUS_CODE','ERROR_CODE','ERROR_MSG','RECORD_NUM','IMPORT_TYPE_CODE')
	   AND ORG_ID = p_org_id
	   ORDER BY nullable,user_name
	   ;

Line: 332

	 SELECT i.source_column || ' : ' || o.object_id m_value,
	   i.source_column || ' : ' || o.name m_colname,
	   i.source_user_column || ' : ' ||
	   Decode(Nvl(o.nullable,'Y'),'N','* ','') || o.user_name m_text,
	   i.source_user_column s_text, i.source_column s_value
	   FROM cn_imp_map_fields i, cn_objects o
	   WHERE i.imp_map_id = c_imp_map_id
	   AND i.target_object_id = o.object_id
	   AND o.ORG_ID = p_org_id
	   ;

Line: 345

 	 SELECT o.object_id value,o.name colname,o.nullable,
	   Decode(Nvl(o.nullable,'Y'),'N','* ','') || o.user_name text
	   FROM cn_objects o
	   WHERE o.table_id = c_table_id
	   AND o.object_type = 'COL'
	   AND o.name NOT IN ('IMP_LINE_ID','LAST_UPDATE_DATE','LAST_UPDATED_BY','CREATION_DATE','CREATED_BY','LAST_UPDATE_LOGIN','OBJECT_VERSION_NUMBER','IMP_HEADER_ID','STATUS_CODE','ERROR_CODE','ERROR_MSG','RECORD_NUM','IMPORT_TYPE_CODE')
	   AND NOT exists
	   (SELECT 'X' FROM cn_imp_map_fields i
	    WHERE i.imp_map_id = c_imp_map_id
	    AND i.target_object_id = o.object_id)
	    AND o.ORG_ID = p_org_id
	   ORDER BY o.nullable, o.user_name
	   ;

Line: 380

   SELECT table_id INTO l_table_id
     FROM cn_import_types
     WHERE import_type_code = p_import_type_code
     ;

Line: 447

	 SELECT object_version_number INTO x_map_obj_num
	   FROM cn_imp_maps
	   WHERE imp_map_id = p_imp_map_id;

Line: 564

      SELECT 1
        INTO l_temp
        FROM cn_imp_maps
        WHERE name = p_imp_map.name
        ;

Line: 585

   SELECT cn_imp_maps_s.nextval
     INTO x_imp_map_id
     FROM sys.dual ;

Line: 590

   cn_imp_maps_pkg.insert_row
   (p_imp_maps_rec  => l_imp_map);

Line: 666

PROCEDURE Delete_Imp_Map
 ( p_api_version             IN     NUMBER  ,
   p_init_msg_list           IN     VARCHAR2 := FND_API.G_FALSE     ,
   p_commit                  IN     VARCHAR2 := FND_API.G_FALSE     ,
   p_validation_level        IN     NUMBER   := FND_API.G_VALID_LEVEL_FULL,
   x_return_status           OUT NOCOPY    VARCHAR2 ,
   x_msg_count               OUT NOCOPY    NUMBER ,
   x_msg_data                OUT NOCOPY    VARCHAR2 ,
   p_imp_map              IN     imp_maps_rec_type
   ) IS

      l_api_name     CONSTANT VARCHAR2(30) := 'Delete_Imp_map';

Line: 685

   SAVEPOINT   Delete_Imp_map;

Line: 702

      SELECT imp_map_id,object_version_number
        INTO l_imp_map.imp_map_id,
        l_imp_map.object_version_number
        FROM cn_imp_maps
        WHERE imp_map_id = p_imp_map.imp_map_id
        ;

Line: 729

   DELETE FROM cn_imp_map_fields
     WHERE imp_map_id = l_imp_map.imp_map_id;

Line: 737

   cn_imp_maps_pkg.delete_row
   (p_imp_map_id  => l_imp_map.imp_map_id);

Line: 754

      ROLLBACK TO Delete_Imp_map  ;

Line: 763

      ROLLBACK TO Delete_Imp_map ;

Line: 772

      ROLLBACK TO Delete_Imp_map ;

Line: 784

END Delete_Imp_map;