APPS.CN_CREDIT_TYPE_CONV_PVT SQL Statements

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

Line: 48

   G_LAST_UPDATE_DATE          DATE := Sysdate;

Line: 49

   G_LAST_UPDATED_BY           NUMBER := fnd_global.user_id;

Line: 52

   G_LAST_UPDATE_LOGIN         NUMBER := fnd_global.login_id;

Line: 59

     SELECT from_credit_type_id, to_credit_type_id, start_date, end_date
       FROM cn_credit_conv_fcts
       WHERE from_credit_type_id = p_from_credit_type
       AND to_credit_type_id = p_to_credit_type;

Line: 109

   SELECT cn_credit_conv_fcts_s.nextval
     INTO l_conv_id
     FROM dual;

Line: 113

   CN_CREDIT_CONV_FCTS_PKG.Insert_Row(
     x_credit_conv_fct_id  =>  l_conv_id,
     x_from_credit_type_id =>  p_from_credit_type,
     x_to_credit_type_id   =>  p_to_credit_type,
     x_conversion_factor   =>  p_conv_factor,
     x_start_date          =>  p_start_date,
     x_end_date            =>  p_end_date,
     x_created_by          =>  g_created_by,
     x_creation_date       =>  g_creation_date,
     x_last_update_login   =>  g_last_update_login,
     x_last_update_date    =>  g_last_update_date,
     x_last_updated_by     =>  g_last_updated_by);

Line: 207

PROCEDURE Update_Conversion
(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,
p_object_version      IN  number,
p_conv_id             IN  number,
p_from_credit_type    IN  number,
p_to_credit_type      IN  number,
p_conv_factor         IN  number,
p_start_date          IN  date,
p_end_date            IN  date,
x_return_status       OUT varchar2,
x_msg_count           OUT number,
x_msg_data            OUT varchar2) is
   G_LAST_UPDATE_DATE          DATE := Sysdate;

Line: 223

   G_LAST_UPDATED_BY           NUMBER := fnd_global.user_id;

Line: 226

   G_LAST_UPDATE_LOGIN         NUMBER := fnd_global.login_id;

Line: 228

     := 'Update_Conversion';

Line: 234

     SELECT object_version_number
       FROM cn_credit_conv_fcts
       WHERE credit_conv_fct_id = p_conv_id;

Line: 239

     SELECT from_credit_type_id, to_credit_type_id, start_date, end_date
       FROM cn_credit_conv_fcts
       WHERE from_credit_type_id = p_from_credit_type
       AND to_credit_type_id = p_to_credit_type
       AND credit_conv_fct_id <> p_conv_id;

Line: 246

   SAVEPOINT   update_conversion_pvt;

Line: 300

   CN_CREDIT_CONV_FCTS_PKG.Update_Row(
     x_credit_conv_fct_id  =>  p_conv_id,
     x_object_version       =>  p_object_version,
     x_from_credit_type_id =>  p_from_credit_type,
     x_to_credit_type_id   =>  p_to_credit_type,
     x_conversion_factor   =>  p_conv_factor,
     x_start_date          =>  p_start_date,
     x_end_date            =>  p_end_date,
     x_created_by          =>  g_created_by,
     x_creation_date       =>  g_creation_date,
     x_last_update_login   =>  g_last_update_login,
     x_last_update_date    =>  g_last_update_date,
     x_last_updated_by     =>  g_last_updated_by);

Line: 325

     ROLLBACK TO update_conversion_pvt;

Line: 332

     ROLLBACK TO update_conversion_pvt;

Line: 339

     ROLLBACK TO update_conversion_pvt;

Line: 352

END Update_Conversion;

Line: 389

PROCEDURE Delete_Conversion
(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,
p_object_version      IN  number,
p_conv_id             IN  number,
x_return_status       OUT varchar2,
x_msg_count           OUT number,
x_msg_data            OUT varchar2) is
   G_LAST_UPDATE_DATE          DATE := Sysdate;

Line: 400

   G_LAST_UPDATED_BY           NUMBER := fnd_global.user_id;

Line: 403

   G_LAST_UPDATE_LOGIN         NUMBER := fnd_global.login_id;

Line: 405

     := 'Delete_Conversion';

Line: 409

     SELECT object_version_number
       FROM cn_credit_conv_fcts
       WHERE credit_conv_fct_id = p_conv_id;

Line: 414

   SAVEPOINT   delete_conversion_pvt;

Line: 441

   CN_CREDIT_CONV_FCTS_PKG.Delete_Row(x_credit_conv_fct_id  =>  p_conv_id);

Line: 455

     ROLLBACK TO delete_conversion_pvt;

Line: 462

     ROLLBACK TO delete_conversion_pvt;

Line: 469

     ROLLBACK TO delete_conversion_pvt;

Line: 482

END Delete_Conversion;