APPS.CN_IMP_HEADERS_PVT SQL Statements

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

Line: 69

      SELECT 1
        INTO l_temp
        FROM cn_imp_headers
        WHERE name = p_imp_header.name
        ;

Line: 91

   SELECT cn_imp_headers_s.nextval
     INTO x_imp_header_id
     FROM sys.dual ;

Line: 96

   cn_imp_headers_pkg.insert_row
   (p_imp_headers_rec  => l_imp_header);

Line: 171

PROCEDURE Update_Imp_header
 ( 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_header           IN     imp_headers_rec_type
   ) IS

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

Line: 190

   SAVEPOINT   Update_Imp_header;

Line: 208

      SELECT 1
        INTO l_temp
        FROM cn_imp_headers
        WHERE imp_header_id <> p_imp_header.imp_header_id
	AND name = p_imp_header.name
        ;

Line: 229

      SELECT imp_header_id,object_version_number
        INTO l_imp_header.imp_header_id, l_imp_header.object_version_number
        FROM cn_imp_headers
        WHERE imp_header_id = p_imp_header.imp_header_id
        FOR UPDATE OF imp_header_id NOWAIT ;

Line: 256

   cn_imp_headers_pkg.update_row
   (p_imp_headers_rec  => l_imp_header);

Line: 274

      ROLLBACK TO Update_Imp_header  ;

Line: 283

      ROLLBACK TO Update_Imp_header ;

Line: 292

      ROLLBACK TO Update_Imp_header ;

Line: 304

END Update_Imp_header;

Line: 332

PROCEDURE Delete_Imp_header
 ( 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_map_obj_num             IN     NUMBER,
   p_imp_header              IN     imp_headers_rec_type
   ) IS

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

Line: 353

	 SELECT process_audit_id
	   FROM cn_process_audits
	   WHERE parent_process_audit_id = c_imp_header_id
	   ;

Line: 360

   SAVEPOINT   Delete_Imp_header;

Line: 377

      SELECT imp_header_id,status_code,object_version_number,imp_map_id
        INTO l_imp_header.imp_header_id,l_imp_header.status_code,
	l_imp_header.object_version_number,l_imp_header.imp_map_id
        FROM cn_imp_headers
        WHERE imp_header_id = p_imp_header.imp_header_id
        ;

Line: 410

      SELECT Decode(p_map_obj_num,NULL,object_version_number,p_map_obj_num)
	INTO l_imp_map.object_version_number
	FROM cn_imp_maps
	WHERE imp_map_id = l_imp_header.imp_map_id;

Line: 417

	 SELECT COUNT(1) INTO l_temp
	   FROM cn_imp_headers
	   WHERE imp_map_id = l_imp_header.imp_map_id
	   AND imp_header_id <> l_imp_header.imp_header_id
	   ;

Line: 429

	 cn_imp_maps_pvt.Delete_Imp_Map
	   ( p_api_version    => 1.0,
	     x_return_status  => x_return_status,
	     x_msg_count      => x_msg_count,
	     x_msg_data       => x_msg_data,
	     p_imp_map        => l_imp_map);

Line: 451

      DELETE FROM cn_imp_lines
	WHERE imp_header_id = l_imp_header.imp_header_id;

Line: 460

   cn_imp_headers_pkg.delete_row
   (p_imp_header_id  => l_imp_header.imp_header_id);

Line: 478

      ROLLBACK TO Delete_Imp_header  ;

Line: 487

      ROLLBACK TO Delete_Imp_header ;

Line: 496

      ROLLBACK TO Delete_Imp_header ;

Line: 508

END Delete_Imp_header;