APPS.CN_IMPORT_CLIENT_PVT SQL Statements

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

Line: 17

  p_insert_flag                  IN      VARCHAR2 := FND_API.G_FALSE, --TRUE for insertion
  p_col_data                     IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000
);

Line: 35

  p_insert_flag                  IN      VARCHAR2 := FND_API.G_FALSE, --TRUE for insertion
  p_col1_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col2_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col3_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col4_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col5_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col6_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col7_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col8_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col9_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col10_data                   IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,

  p_col11_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col12_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col13_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col14_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col15_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col16_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col17_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col18_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col19_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col20_data                   IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,

  p_col21_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col22_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col23_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col24_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col25_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col26_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col27_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col28_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col29_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col30_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,

  p_col31_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col32_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col33_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col34_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col35_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col36_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col37_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col38_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col39_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col40_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,

  p_act_col_num                  OUT NOCOPY NUMBER

);

Line: 84

PROCEDURE Insert_To_DB (
  p_prim_keys                    IN      JTF_NUMBER_TABLE,
  p_col_count                    IN      NUMBER, --actual column count
  p_row_count                    IN      NUMBER,

  p_tab_name_clause              IN      VARCHAR2,
  p_col_clause                   IN      VARCHAR2,
  p_value_clause                 IN      VARCHAR2,
  p_col_names                    IN      CN_IMPORT_PVT.char_data_set_type,
  p_imp_header_id                IN    NUMBER,
  p_import_type_code             IN    VARCHAR2,

  p_col1_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col2_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col3_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col4_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col5_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col6_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col7_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col8_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col9_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col10_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col11_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col12_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col13_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col14_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col15_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col16_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col17_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col18_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col19_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col20_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col21_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col22_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col23_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col24_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col25_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col26_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col27_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col28_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col29_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col30_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col31_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col32_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col33_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col34_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col35_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col36_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col37_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col38_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col39_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col40_data                   IN      JTF_VARCHAR2_TABLE_2000,

  x_return_status              OUT NOCOPY       VARCHAR2,
  x_msg_count                  OUT NOCOPY       NUMBER,
  x_msg_data                   OUT NOCOPY       VARCHAR2
);

Line: 142

PROCEDURE Update_DB (
  p_prim_keys                    IN      JTF_NUMBER_TABLE,
  p_col_count                    IN      NUMBER,
  p_row_count                    IN      NUMBER,

  p_tab_name_name                IN      VARCHAR2,
  p_col_names                    IN      CN_IMPORT_PVT.char_data_set_type,
  p_col_start_count              IN      NUMBER,

  p_col1_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col2_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col3_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col4_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col5_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col6_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col7_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col8_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col9_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col10_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col11_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col12_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col13_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col14_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col15_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col16_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col17_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col18_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col19_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col20_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col21_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col22_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col23_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col24_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col25_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col26_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col27_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col28_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col29_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col30_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col31_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col32_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col33_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col34_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col35_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col36_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col37_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col38_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col39_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col40_data                   IN      JTF_VARCHAR2_TABLE_2000,

  x_return_status                OUT NOCOPY       VARCHAR2,
  x_msg_count                    OUT NOCOPY       NUMBER,
  x_msg_data                     OUT NOCOPY       VARCHAR2
);

Line: 226

PROCEDURE Insert_Data
  (p_api_version                 IN    NUMBER,
   p_init_msg_list               IN    VARCHAR2 := FND_API.G_TRUE,
   p_commit                      IN    VARCHAR2 := FND_API.G_FALSE,
   p_imp_header_id               IN    NUMBER,
   p_import_type_code            IN    VARCHAR2,
   p_table_name                  IN    VARCHAR2,
   p_col_names                   IN    CN_IMPORT_PVT.char_data_set_type,
   p_data                        IN    CN_IMPORT_PVT.char_data_set_type,
   p_row_count                   IN    NUMBER,
   x_return_status               OUT NOCOPY   VARCHAR2,
   x_msg_count                   OUT NOCOPY   NUMBER,
   x_msg_data                    OUT NOCOPY   VARCHAR2
   ) IS

  --
  -- Standard API information constants.
  --
  L_API_VERSION       CONSTANT NUMBER := 1.0;

Line: 245

  L_API_NAME          CONSTANT VARCHAR2(30) := 'Insert_Data';

Line: 253

                                            INSERT INTO ';

Line: 323

   SAVEPOINT Insert_Data;

Line: 337

   cn_message_pkg.debug('Insert Data : Start Inserting Data');

Line: 346

   cn_message_pkg.debug('Insert Data : Start Copy Data from p_data');

Line: 394

     p_insert_flag                  => FND_API.G_TRUE,
     p_act_col_num                  => l_act_col_count);

Line: 397

   cn_message_pkg.debug('Insert Data : Finish Copy Data from p_data');

Line: 407

   l_col_clause := l_col_clause || 'LAST_UPDATE_DATE,';

Line: 408

   l_value_clause := l_value_clause || ':l_last_update_date, ';

Line: 410

   l_col_clause := l_col_clause || 'LAST_UPDATED_BY,';

Line: 411

   l_value_clause := l_value_clause || ':l_last_updated_by, ';

Line: 419

   l_col_clause := l_col_clause || 'LAST_UPDATE_LOGIN,';

Line: 420

   l_value_clause := l_value_clause || ':l_last_update_login, ';

Line: 439

      SELECT CN_IMP_LINES_S.NEXTVAL
	INTO l_prim_keys(i) FROM dual;

Line: 443

   cn_message_pkg.debug('Insert Data : Start insert into DB');

Line: 446

   Insert_To_DB
     (p_prim_keys            => l_prim_keys,
      p_col_count            => l_act_col_count,
      p_row_count            => p_row_count,
      p_tab_name_clause      => l_tab_name_clause,
      p_col_clause           => l_col_clause,
      p_value_clause         => l_value_clause,
      p_col_names            => p_col_names,
      p_imp_header_id        => p_imp_header_id,
      p_import_type_code     => p_import_type_code,
      p_col1_data            => l_col1_data,
      p_col2_data            => l_col2_data,
      p_col3_data            => l_col3_data,
      p_col4_data            => l_col4_data,
      p_col5_data            => l_col5_data,
      p_col6_data            => l_col6_data,
      p_col7_data            => l_col7_data,
      p_col8_data            => l_col8_data,
      p_col9_data            => l_col9_data,
      p_col10_data           => l_col10_data,
      p_col11_data           => l_col11_data,
      p_col12_data           => l_col12_data,
      p_col13_data           => l_col13_data,
      p_col14_data           => l_col14_data,
      p_col15_data           => l_col15_data,
     p_col16_data           => l_col16_data,
     p_col17_data           => l_col17_data,
     p_col18_data           => l_col18_data,
     p_col19_data           => l_col19_data,
     p_col20_data           => l_col20_data,
     p_col21_data           => l_col21_data,
     p_col22_data           => l_col22_data,
     p_col23_data           => l_col23_data,
     p_col24_data           => l_col24_data,
     p_col25_data           => l_col25_data,
     p_col26_data           => l_col26_data,
     p_col27_data           => l_col27_data,
     p_col28_data           => l_col28_data,
     p_col29_data           => l_col29_data,
     p_col30_data           => l_col30_data,
     p_col31_data           => l_col31_data,
     p_col32_data           => l_col32_data,
     p_col33_data           => l_col33_data,
     p_col34_data           => l_col34_data,
     p_col35_data           => l_col35_data,
     p_col36_data           => l_col36_data,
     p_col37_data           => l_col37_data,
     p_col38_data           => l_col38_data,
     p_col39_data           => l_col39_data,
     p_col40_data           => l_col40_data,
     x_return_status        => x_return_status,
     x_msg_count            => x_msg_count,
     x_msg_data             => x_msg_data);

Line: 505

   cn_message_pkg.debug('Insert Data : Finish insert into DB');

Line: 512

       cn_message_pkg.debug('Insert Data : Copy more data from p_data.');

Line: 559

	 p_insert_flag                  => FND_API.G_FALSE,
	 p_act_col_num                  => l_act_col_count);

Line: 562

       cn_message_pkg.debug('Insert Data : Update more data from p_data.');

Line: 564

       Update_DB
	 (p_prim_keys                    => l_prim_keys,
	  p_col_count                    => l_act_col_count,
	  p_row_count                    => p_row_count,

	  p_tab_name_name                => p_table_name,
	  p_col_names                    => p_col_names,
	  p_col_start_count              => l_col_count,

	  p_col1_data                    => l_col1_data,
	  p_col2_data                    => l_col2_data,
	  p_col3_data                    => l_col3_data,
	  p_col4_data                    => l_col4_data,
	  p_col5_data                    => l_col5_data,
	  p_col6_data                    => l_col6_data,
	  p_col7_data                    => l_col7_data,
	  p_col8_data                    => l_col8_data,
	  p_col9_data                    => l_col9_data,
	  p_col10_data                   => l_col10_data,
	  p_col11_data                   => l_col11_data,
	  p_col12_data                   => l_col12_data,
	  p_col13_data                   => l_col13_data,
	 p_col14_data                   => l_col14_data,
	 p_col15_data                   => l_col15_data,
	 p_col16_data                   => l_col16_data,
	 p_col17_data                   => l_col17_data,
	 p_col18_data                   => l_col18_data,
	 p_col19_data                   => l_col19_data,
	 p_col20_data                   => l_col20_data,
	 p_col21_data                   => l_col21_data,
	 p_col22_data                   => l_col22_data,
	 p_col23_data                   => l_col23_data,
	 p_col24_data                   => l_col24_data,
	 p_col25_data                   => l_col25_data,
	 p_col26_data                   => l_col26_data,
	 p_col27_data                   => l_col27_data,
	 p_col28_data                   => l_col28_data,
	 p_col29_data                   => l_col29_data,
	 p_col30_data                   => l_col30_data,
	 p_col31_data                   => l_col31_data,
	 p_col32_data                   => l_col32_data,
	 p_col33_data                   => l_col33_data,
	 p_col34_data                   => l_col34_data,
	 p_col35_data                   => l_col35_data,
	 p_col36_data                   => l_col36_data,
	 p_col37_data                   => l_col37_data,
	 p_col38_data                   => l_col38_data,
	 p_col39_data                   => l_col39_data,
	 p_col40_data                   => l_col40_data,

	 x_return_status                => x_return_status,
	 x_msg_count                    => x_msg_count,
	 x_msg_data                     => x_msg_data
	 );

Line: 626

      cn_message_pkg.debug('Insert Data : Finish update to DB.');

Line: 645

      ROLLBACK TO Insert_Data;

Line: 652

      ROLLBACK TO Insert_Data;

Line: 659

      ROLLBACK TO Insert_Data;

Line: 670

END Insert_Data;

Line: 718

  p_insert_flag                  IN      VARCHAR2 := FND_API.G_FALSE, --TRUE for insertion
  p_col_data                     IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000
)
IS
   l_count NUMBER := 1;

Line: 724

   IF p_insert_flag = FND_API.G_TRUE THEN
      p_col_data := JTF_VARCHAR2_TABLE_2000 ('t');

Line: 748

   p_insert_flag                  IN      VARCHAR2 := FND_API.G_FALSE, --TRUE for insertion
   p_col1_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
   p_col2_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
   p_col3_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
   p_col4_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
   p_col5_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
   p_col6_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
   p_col7_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
   p_col8_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
   p_col9_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
   p_col10_data                   IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,

   p_col11_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col12_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col13_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col14_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col15_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col16_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col17_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col18_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col19_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col20_data                   IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,

  p_col21_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col22_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col23_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col24_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col25_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col26_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col27_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col28_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col29_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col30_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,

  p_col31_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col32_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col33_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col34_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col35_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col36_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col37_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col38_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col39_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,
  p_col40_data                    IN OUT NOCOPY  JTF_VARCHAR2_TABLE_2000,

  p_act_col_num                  OUT NOCOPY NUMBER

  )
  IS
     l_start_index NUMBER;

Line: 814

	 p_insert_flag                  => p_insert_flag);

Line: 823

      p_insert_flag                  => p_insert_flag);

Line: 832

      p_insert_flag                  => p_insert_flag);

Line: 841

      p_insert_flag                  => p_insert_flag);

Line: 850

      p_insert_flag                  => p_insert_flag);

Line: 859

      p_insert_flag                  => p_insert_flag);

Line: 868

      p_insert_flag                  => p_insert_flag);

Line: 877

      p_insert_flag                  => p_insert_flag);

Line: 886

      p_insert_flag                  => p_insert_flag);

Line: 895

      p_insert_flag                  => p_insert_flag);

Line: 905

      p_insert_flag                  => p_insert_flag);

Line: 914

      p_insert_flag                  => p_insert_flag);

Line: 923

      p_insert_flag                  => p_insert_flag);

Line: 932

      p_insert_flag                  => p_insert_flag);

Line: 941

      p_insert_flag                  => p_insert_flag);

Line: 950

      p_insert_flag                  => p_insert_flag);

Line: 959

      p_insert_flag                  => p_insert_flag);

Line: 968

      p_insert_flag                  => p_insert_flag);

Line: 977

      p_insert_flag                  => p_insert_flag);

Line: 986

      p_insert_flag                  => p_insert_flag);

Line: 996

      p_insert_flag                  => p_insert_flag);

Line: 1005

      p_insert_flag                  => p_insert_flag);

Line: 1014

      p_insert_flag                  => p_insert_flag);

Line: 1023

      p_insert_flag                  => p_insert_flag);

Line: 1032

      p_insert_flag                  => p_insert_flag);

Line: 1041

      p_insert_flag                  => p_insert_flag);

Line: 1050

      p_insert_flag                  => p_insert_flag);

Line: 1059

      p_insert_flag                  => p_insert_flag);

Line: 1068

      p_insert_flag                  => p_insert_flag);

Line: 1077

      p_insert_flag                  => p_insert_flag);

Line: 1087

      p_insert_flag                  => p_insert_flag);

Line: 1096

      p_insert_flag                  => p_insert_flag);

Line: 1105

      p_insert_flag                  => p_insert_flag);

Line: 1114

      p_insert_flag                  => p_insert_flag);

Line: 1123

      p_insert_flag                  => p_insert_flag);

Line: 1132

      p_insert_flag                  => p_insert_flag);

Line: 1141

      p_insert_flag                  => p_insert_flag);

Line: 1150

      p_insert_flag                  => p_insert_flag);

Line: 1159

      p_insert_flag                  => p_insert_flag);

Line: 1168

      p_insert_flag                  => p_insert_flag);

Line: 1182

PROCEDURE Insert_To_DB (
  p_prim_keys                    IN      JTF_NUMBER_TABLE,
  p_col_count                    IN      NUMBER, --actual column count
  p_row_count                    IN      NUMBER,

  p_tab_name_clause              IN      VARCHAR2,
  p_col_clause                   IN      VARCHAR2,
  p_value_clause                 IN      VARCHAR2,
  p_col_names                    IN      CN_IMPORT_PVT.char_data_set_type,
  p_imp_header_id                IN    NUMBER,
  p_import_type_code             IN    VARCHAR2,

  p_col1_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col2_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col3_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col4_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col5_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col6_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col7_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col8_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col9_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col10_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col11_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col12_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col13_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col14_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col15_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col16_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col17_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col18_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col19_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col20_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col21_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col22_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col23_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col24_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col25_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col26_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col27_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col28_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col29_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col30_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col31_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col32_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col33_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col34_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col35_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col36_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col37_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col38_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col39_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col40_data                   IN      JTF_VARCHAR2_TABLE_2000,
  x_return_status              OUT NOCOPY       VARCHAR2,
  x_msg_count                  OUT NOCOPY       NUMBER,
  x_msg_data                   OUT NOCOPY       VARCHAR2
)
IS

  --
  -- Standard API information constants.
  --
  L_API_VERSION        CONSTANT NUMBER := 1.0;

Line: 1244

  L_API_NAME           CONSTANT VARCHAR2(30) := 'INSERT_TO_DB';

Line: 1278

  cn_message_pkg.debug('Insert TO DB : ' || p_tab_name_clause );

Line: 1279

  cn_message_pkg.debug('Insert TO DB : ' || l_col_clause);

Line: 1280

  cn_message_pkg.debug('Insert TO DB : ' || l_value_clause);

Line: 1702

END Insert_To_DB;

Line: 1713

PROCEDURE Update_DB (
  p_prim_keys                    IN      JTF_NUMBER_TABLE,
  p_col_count                    IN      NUMBER,
  p_row_count                    IN      NUMBER,

  p_tab_name_name                IN      VARCHAR2,
  p_col_names                    IN      CN_IMPORT_PVT.char_data_set_type,
  p_col_start_count              IN      NUMBER,

  p_col1_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col2_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col3_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col4_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col5_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col6_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col7_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col8_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col9_data                    IN      JTF_VARCHAR2_TABLE_2000,
  p_col10_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col11_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col12_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col13_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col14_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col15_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col16_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col17_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col18_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col19_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col20_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col21_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col22_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col23_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col24_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col25_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col26_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col27_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col28_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col29_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col30_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col31_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col32_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col33_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col34_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col35_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col36_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col37_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col38_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col39_data                   IN      JTF_VARCHAR2_TABLE_2000,
  p_col40_data                   IN      JTF_VARCHAR2_TABLE_2000,

  x_return_status                OUT NOCOPY     VARCHAR2,
  x_msg_count                    OUT NOCOPY     NUMBER,
  x_msg_data                     OUT NOCOPY     VARCHAR2
)
IS

   --
   -- Standard API information constants.
   --
   L_API_VERSION        CONSTANT NUMBER := 1.0;

Line: 1773

   L_API_NAME           CONSTANT VARCHAR2(30) := 'UPDATE_DB';

Line: 1776

   l_update_sql         VARCHAR2(8000) := 'BEGIN FORALL i IN 1 .. :row_count UPDATE ';

Line: 1781

  l_update_sql := l_update_sql || p_tab_name_name || ' SET ';

Line: 1793

     l_update_sql := l_update_sql || p_col_names (p_col_start_count + l_index)
       || '=:val' || l_index || '(i), ';

Line: 1798

  l_update_sql := l_update_sql || p_col_names (p_col_start_count + l_index)
    || '= :val' || l_index || '(i) ';

Line: 1801

  l_update_sql := l_update_sql || ' WHERE IMP_LINE_ID = :p_keys(i); END;';

Line: 1803

  cn_message_pkg.debug('Update TO DB : ' || l_update_sql );

Line: 1810

      l_update_sql
    USING p_row_count, p_col1_data, p_prim_keys;

Line: 1814

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_prim_keys;

Line: 1818

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_prim_keys;

Line: 1822

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
        p_prim_keys;

Line: 1827

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_prim_keys;

Line: 1832

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
        p_col5_data, p_col6_data, p_prim_keys;

Line: 1837

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
        p_col5_data, p_col6_data, p_col7_data, p_prim_keys;

Line: 1842

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
        p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_prim_keys;

Line: 1847

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
        p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
        p_prim_keys;

Line: 1853

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_prim_keys;

Line: 1859

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_prim_keys;

Line: 1865

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_prim_keys;

Line: 1871

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data,p_prim_keys;

Line: 1877

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_prim_keys;

Line: 1884

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_prim_keys;

Line: 1891

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_prim_keys;

Line: 1898

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_prim_keys;

Line: 1905

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_prim_keys;

Line: 1912

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_prim_keys;

Line: 1920

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_prim_keys;

Line: 1928

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_prim_keys;

Line: 1936

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_prim_keys;

Line: 1944

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_prim_keys;

Line: 1952

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_prim_keys;

Line: 1961

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_col25_data, p_prim_keys;

Line: 1970

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_col25_data, p_col26_data, p_prim_keys;

Line: 1979

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_col25_data, p_col26_data, p_col27_data, p_prim_keys;

Line: 1988

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_col25_data, p_col26_data, p_col27_data, p_col28_data, p_prim_keys;

Line: 1997

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_col25_data, p_col26_data, p_col27_data, p_col28_data, p_col29_data,
          p_prim_keys;

Line: 2007

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_col25_data, p_col26_data, p_col27_data, p_col28_data, p_col29_data,
          p_col30_data, p_prim_keys;

Line: 2017

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_col25_data, p_col26_data, p_col27_data, p_col28_data, p_col29_data,
          p_col30_data, p_col31_data, p_prim_keys;

Line: 2027

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_col25_data, p_col26_data, p_col27_data, p_col28_data, p_col29_data,
          p_col30_data, p_col31_data, p_col32_data, p_prim_keys;

Line: 2037

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_col25_data, p_col26_data, p_col27_data, p_col28_data, p_col29_data,
          p_col30_data, p_col31_data, p_col32_data, p_col33_data, p_prim_keys;

Line: 2047

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_col25_data, p_col26_data, p_col27_data, p_col28_data, p_col29_data,
          p_col30_data, p_col31_data, p_col32_data, p_col33_data, p_col34_data,
          p_prim_keys;

Line: 2058

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_col25_data, p_col26_data, p_col27_data, p_col28_data, p_col29_data,
          p_col30_data, p_col31_data, p_col32_data, p_col33_data, p_col34_data,
          p_col35_data, p_prim_keys;

Line: 2069

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_col25_data, p_col26_data, p_col27_data, p_col28_data, p_col29_data,
          p_col30_data, p_col31_data, p_col32_data, p_col33_data, p_col34_data,
          p_col35_data, p_col36_data, p_prim_keys;

Line: 2080

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_col25_data, p_col26_data, p_col27_data, p_col28_data, p_col29_data,
          p_col30_data, p_col31_data, p_col32_data, p_col33_data, p_col34_data,
          p_col35_data, p_col36_data, p_col37_data, p_prim_keys;

Line: 2091

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_col25_data, p_col26_data, p_col27_data, p_col28_data, p_col29_data,
          p_col30_data, p_col31_data, p_col32_data, p_col33_data, p_col34_data,
          p_col35_data, p_col36_data, p_col37_data, p_col38_data, p_prim_keys;

Line: 2102

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_col25_data, p_col26_data, p_col27_data, p_col28_data, p_col29_data,
          p_col30_data, p_col31_data, p_col32_data, p_col33_data, p_col34_data,
          p_col35_data, p_col36_data, p_col37_data, p_col38_data, p_col39_data,
          p_prim_keys;

Line: 2114

        l_update_sql
    USING p_row_count, p_col1_data, p_col2_data, p_col3_data, p_col4_data,
          p_col5_data, p_col6_data, p_col7_data, p_col8_data, p_col9_data,
          p_col10_data, p_col11_data, p_col12_data, p_col13_data, p_col14_data,
          p_col15_data, p_col16_data, p_col17_data, p_col18_data, p_col19_data,
          p_col20_data, p_col21_data, p_col22_data, p_col23_data, p_col24_data,
          p_col25_data, p_col26_data, p_col27_data, p_col28_data, p_col29_data,
          p_col30_data, p_col31_data, p_col32_data, p_col33_data, p_col34_data,
          p_col35_data, p_col36_data, p_col37_data, p_col38_data, p_col39_data,
          p_col40_data, p_prim_keys;

Line: 2144

END Update_DB;