APPS.CN_CALC_EXT_TABLES_PVT SQL Statements

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

Line: 7

G_LAST_UPDATE_DATE     DATE 		     := Sysdate;

Line: 8

G_LAST_UPDATED_BY      NUMBER 		     := fnd_global.user_id;

Line: 11

G_LAST_UPDATE_LOGIN    NUMBER		     := fnd_global.login_id;

Line: 69

    Select count(*)
      from cn_calc_ext_tables
    Where external_table_id = p_calc_ext_table_rec.external_table_id
     and  calc_ext_table_id <> nvl( p_calc_ext_table_rec.calc_ext_table_id, -99);

Line: 78

    select name from cn_objects
    where  object_id =  p_object_id
      and  object_type = 'TBL';

Line: 105

   x_loading_status := 'CN_INSERTED';

Line: 201

  CN_CALC_EXT_TABLE_PKG.insert_row
   (x_calc_ext_table_id     => x_calc_ext_table_id
    ,p_name                 => p_calc_ext_table_rec.name
    ,p_description          => p_calc_ext_table_rec.description
    ,p_internal_table_id    => p_calc_ext_table_rec.internal_table_id
    ,p_external_table_id    => p_calc_ext_table_rec.external_table_id
    ,p_used_flag	    => p_calc_ext_table_rec.used_flag
    ,p_schema 		    => p_calc_ext_table_rec.schema
    ,p_external_table_name  => l_external_table_name
    ,p_alias		    => l_alias
    ,p_creation_date        => sysdate
    ,p_created_by           => g_created_by
    ,p_last_update_date     => sysdate
    ,p_last_updated_by      => g_last_updated_by
    ,p_last_update_login    => g_last_update_login);

Line: 297

PROCEDURE Update_calc_ext_table
( 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,
  x_loading_status              OUT NOCOPY     VARCHAR2,
  p_old_calc_ext_table_rec	IN OUT NOCOPY  CN_CALC_EXT_TABLES_PVT.calc_ext_table_rec_type,
  p_calc_ext_table_rec		IN OUT NOCOPY  CN_CALC_EXT_TABLES_PVT.calc_ext_table_rec_type
) IS

/*   CURSOR l_ovn_csr IS
    SELECT nvl(object_version_number,1)
      FROM cn_calc_ext_tables
      WHERE calc_ext_table_id = p_old_calc_ext_table_rec.calc_ext_table_id;

Line: 317

    Select count(*)
      from cn_calc_ext_tables
    Where external_table_id = p_calc_ext_table_rec.external_table_id
     and  calc_ext_table_id <> nvl( p_calc_ext_table_rec.calc_ext_table_id, -99);

Line: 322

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

Line: 335

    select name from cn_objects
    where  object_id =  p_object_id
      and  object_type = 'TBL';

Line: 343

   Select external_table_id, internal_table_id
    from cn_calc_ext_tables
   where calc_ext_table_id = p_calc_ext_table_id;

Line: 349

   Select count(1)
    from cn_calc_ext_tbl_dtls
   where calc_ext_table_id = p_calc_ext_table_id;

Line: 362

   SAVEPOINT Update_CALC_EXT_TABLES;

Line: 380

   x_loading_status := 'CN_UPDATED';

Line: 491

         fnd_message.set_name('CN', 'CN_EXT_UPDATE_NOT_ALLOWED');

Line: 494

      x_loading_status := 'CN_EXT_UPDATE_NOT_ALLOWED';

Line: 500

  CN_CALC_EXT_TABLE_PKG.update_row
   (p_calc_ext_table_id     =>  p_calc_ext_table_rec.calc_ext_table_id
    ,p_name                 => p_calc_ext_table_rec.name
    ,p_description          => p_calc_ext_table_rec.description
    ,p_internal_table_id    => p_calc_ext_table_rec.internal_table_id
    ,p_external_table_id    => p_calc_ext_table_rec.external_table_id
    ,p_used_flag	    => p_calc_ext_table_rec.used_flag
    ,p_schema 		    => p_calc_ext_table_rec.schema
    ,p_external_table_name  => l_external_table_name
    ,p_alias		    => l_alias
    ,p_last_update_date     => sysdate
    ,p_last_updated_by      => g_last_updated_by
    ,p_last_update_login    => g_last_update_login);

Line: 533

      ROLLBACK TO Update_CALC_EXT_TABLES;

Line: 544

      ROLLBACK TO Update_CALC_EXT_TABLES;

Line: 554

      ROLLBACK TO Update_CALC_EXT_TABLES;

Line: 601

PROCEDURE Delete_Calc_Ext_Table
( 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,
  x_loading_status              OUT NOCOPY     VARCHAR2,
  p_calc_ext_table_id		IN      NUMBER
) IS


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

Line: 623

   select count(*)
     from cn_calc_ext_tbl_dtls
    where CALC_EXT_TABLE_ID = p_calc_ext_table_id ;

Line: 632

  SAVEPOINT Delete_CALC_EXT_TABLES;

Line: 670

  CN_CALC_EXT_TABLE_PKG.Delete_row(p_calc_ext_table_id);

Line: 690

		ROLLBACK TO Delete_CALC_EXT_TABLES;

Line: 700

		ROLLBACK TO Delete_CALC_EXT_TABLES;

Line: 711

		ROLLBACK TO Delete_CALC_EXT_TABLES;