APPS.CN_SF_PARAMS_PVT SQL Statements

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

Line: 48

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

Line: 84

   SELECT REPOSITORY_ID,CONTRACT_TITLE ,TERMS_AND_CONDITIONS ,
          CLUB_QUAL_TEXT ,APPROVER_NAME ,APPROVER_TITLE ,
          APPROVER_ORG_NAME ,FILE_ID,FORMU_ACTIVATED_FLAG,
          TRANSACTION_CALENDAR_ID,OBJECT_VERSION_NUMBER
   INTO   p_sf_param_rec.REPOSITORY_ID, p_sf_param_rec.CONTRACT_TITLE ,
          p_sf_param_rec.TERMS_AND_CONDITIONS ,p_sf_param_rec.CLUB_QUAL_TEXT ,
          p_sf_param_rec.APPROVER_NAME , p_sf_param_rec.APPROVER_TITLE ,
          p_sf_param_rec.APPROVER_ORG_NAME , p_sf_param_rec.FILE_ID,
          p_sf_param_rec.FORMU_ACTIVATED_FLAG, p_sf_param_rec.TRANSACTION_CALENDAR_ID,
          p_sf_param_rec.OBJECT_VERSION_NUMBER
   FROM CN_SF_REPOSITORIES;

Line: 191

PROCEDURE Update_SF_Parameters
(
   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_sf_repositories_rec     IN  cn_sf_repositories_rec_type,
   x_return_status           OUT NOCOPY    VARCHAR2,
   x_msg_count               OUT NOCOPY    NUMBER,
   x_msg_data                OUT NOCOPY    VARCHAR2
) IS

-- local variables
    l_api_name CONSTANT VARCHAR2(30) := 'Update_Repository' ;

Line: 217

   SAVEPOINT Update_SF_Parameters_svp ;

Line: 235

   SELECT Count(*)
   INTO l_count
   FROM CN_SF_REPOSITORIES ;

Line: 252

   CN_SF_PARAMS_pkg.update_row
    (
        P_REPOSITORY_ID          =>  p_sf_repositories_rec.REPOSITORY_ID,
        P_CONTRACT_TITLE         =>  p_sf_repositories_rec.CONTRACT_TITLE,
        P_TERMS_AND_CONDITIONS   =>  p_sf_repositories_rec.TERMS_AND_CONDITIONS,
        P_CLUB_QUAL_TEXT         =>  p_sf_repositories_rec.CLUB_QUAL_TEXT,
        P_APPROVER_NAME          =>  p_sf_repositories_rec.APPROVER_NAME,
        P_APPROVER_TITLE         =>  p_sf_repositories_rec.APPROVER_TITLE,
        P_APPROVER_ORG_NAME      =>  p_sf_repositories_rec.APPROVER_ORG_NAME,
        P_FILE_ID                =>  p_sf_repositories_rec.FILE_ID,
        P_FORMU_ACTIVATED_FLAG   =>  p_sf_repositories_rec.FORMU_ACTIVATED_FLAG,
        P_TRANSACTION_CALENDAR_ID => p_sf_repositories_rec.TRANSACTION_CALENDAR_ID,
        P_OBJECT_VERSION_NUMBER => p_sf_repositories_rec.OBJECT_VERSION_NUMBER
    );

Line: 270

   << end_Update_SF_Parameters >>
   NULL;

Line: 288

      ROLLBACK TO Update_SF_Parameters_svp ;

Line: 298

      ROLLBACK TO Update_SF_Parameters_svp ;

Line: 309

      ROLLBACK TO Update_SF_Parameters_svp ;

Line: 334

END Update_SF_Parameters ;

Line: 369

PROCEDURE Insert_SF_Parameters
(
   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_sf_repositories_rec     IN  cn_sf_repositories_rec_type,
   x_return_status           OUT NOCOPY    VARCHAR2,
   x_msg_count               OUT NOCOPY    NUMBER,
   x_msg_data                OUT NOCOPY    VARCHAR2
) IS

-- local variables
    l_api_name CONSTANT VARCHAR2(30) := 'Insert_SF_Parameters' ;

Line: 393

   SAVEPOINT Insert_SF_Parameters_svp ;

Line: 415

   SELECT Count(*)
   INTO l_count
   FROM CN_SF_REPOSITORIES ;

Line: 428

   CN_SF_PARAMS_pkg.insert_row
    (
        P_REPOSITORY_ID          =>  p_sf_repositories_rec.REPOSITORY_ID,
        P_CONTRACT_TITLE         =>  p_sf_repositories_rec.CONTRACT_TITLE,
        P_TERMS_AND_CONDITIONS   =>  p_sf_repositories_rec.TERMS_AND_CONDITIONS,
        P_CLUB_QUAL_TEXT         =>  p_sf_repositories_rec.CLUB_QUAL_TEXT,
        P_APPROVER_NAME          =>  p_sf_repositories_rec.APPROVER_NAME,
        P_APPROVER_TITLE         =>  p_sf_repositories_rec.APPROVER_TITLE,
        P_APPROVER_ORG_NAME      =>  p_sf_repositories_rec.APPROVER_ORG_NAME,
        P_FILE_ID                =>  p_sf_repositories_rec.FILE_ID,
        P_FORMU_ACTIVATED_FLAG   =>  p_sf_repositories_rec.FORMU_ACTIVATED_FLAG,
        P_TRANSACTION_CALENDAR_ID => p_sf_repositories_rec.TRANSACTION_CALENDAR_ID
    );

Line: 445

   << end_Insert_SF_Parameters >>
   NULL;

Line: 463

      ROLLBACK TO Insert_SF_Parameters_svp ;

Line: 473

      ROLLBACK TO Insert_SF_Parameters_svp ;

Line: 483

      ROLLBACK TO Insert_SF_Parameters_svp ;

Line: 506

END Insert_SF_Parameters ;