APPS.OKC_NUMBER_SCHEME_DTL_GRP SQL Statements

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

Line: 167

  PROCEDURE Insert_Number_Scheme_Dtl(
    p_api_version           IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    p_validation_level	    IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
    p_commit                IN VARCHAR2 := FND_API.G_FALSE,

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

    p_num_scheme_id         IN NUMBER,
    p_num_sequence_code     IN VARCHAR2,
    p_sequence_level        IN NUMBER,
    p_concatenation_yn      IN VARCHAR2,
    p_end_character         IN VARCHAR2,



    x_num_scheme_id         OUT NOCOPY NUMBER,
    x_num_sequence_code     OUT NOCOPY VARCHAR2,
    x_sequence_level        OUT NOCOPY NUMBER

  ) IS

    l_api_version           CONSTANT NUMBER := 1;

Line: 196

    l_last_updated_by       OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;

Line: 197

    l_last_update_login     OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;

Line: 198

    l_last_update_date      OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;

Line: 202

       okc_debug.log('600: Entered Insert_Number_Scheme_Dtl', 2);

Line: 207

            G_PKG_NAME, '600: Entered Insert_Number_Scheme_Dtl' );

Line: 211

    SAVEPOINT g_Insert_Number_Scheme_Dtl_GRP;

Line: 226

    OKC_NUMBER_SCHEME_DTL_PVT.Insert_Row(
      p_validation_level      =>   p_validation_level,
      x_return_status         =>   x_return_status,
      p_num_scheme_id         => p_num_scheme_id,
      p_num_sequence_code     => p_num_sequence_code,
      p_sequence_level        => p_sequence_level,
      p_concatenation_yn      => p_concatenation_yn,
      p_end_character         => p_end_character,
      x_num_scheme_id         => x_num_scheme_id,
      x_num_sequence_code     => x_num_sequence_code,
      x_sequence_level        => x_sequence_level
    );

Line: 254

       okc_debug.log('700: Leaving Insert_Number_Scheme_Dtl', 2);

Line: 259

            G_PKG_NAME, '700: Leaving Insert_Number_Scheme_Dtl' );

Line: 265

         okc_debug.log('800: Leaving Insert_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 270

   	      G_PKG_NAME, '800: Leaving Insert_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception' );

Line: 272

      ROLLBACK TO g_Insert_Number_Scheme_Dtl_GRP;

Line: 278

         okc_debug.log('900: Leaving Insert_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 283

   	      G_PKG_NAME, '900: Leaving Insert_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

Line: 285

      ROLLBACK TO g_Insert_Number_Scheme_Dtl_GRP;

Line: 291

        okc_debug.log('1000: Leaving Insert_Number_Scheme_Dtl because of EXCEPTION: '||sqlerrm, 2);

Line: 296

   	      G_PKG_NAME, '1000: Leaving Insert_Number_Scheme_Dtl because of EXCEPTION: '||sqlerrm );

Line: 298

      ROLLBACK TO g_Insert_Number_Scheme_Dtl_GRP;

Line: 305

  END Insert_Number_Scheme_Dtl;

Line: 425

  PROCEDURE Update_Number_Scheme_Dtl(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
    p_commit                       IN VARCHAR2 := FND_API.G_FALSE,

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

    p_num_scheme_id         IN NUMBER,
    p_num_sequence_code     IN VARCHAR2,
    p_sequence_level        IN NUMBER,
    p_concatenation_yn      IN VARCHAR2,
    p_end_character         IN VARCHAR2,



    p_object_version_number IN NUMBER

   ) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 448

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

Line: 453

       okc_debug.log('1600: Entered Update_Number_Scheme_Dtl', 2);

Line: 459

            G_PKG_NAME, '1600: Entered Update_Number_Scheme_Dtl');

Line: 465

    SAVEPOINT g_Update_Number_Scheme_Dtl_GRP;

Line: 480

    OKC_NUMBER_SCHEME_DTL_PVT.Update_Row(
      p_validation_level           => p_validation_level,
      x_return_status              => x_return_status,
      p_num_scheme_id         => p_num_scheme_id,
      p_num_sequence_code     => p_num_sequence_code,
      p_sequence_level        => p_sequence_level,
      p_concatenation_yn      => p_concatenation_yn,
      p_end_character         => p_end_character,
      p_object_version_number => p_object_version_number
    );

Line: 506

      okc_debug.log('1800: Leaving Update_Number_Scheme_Dtl', 2);

Line: 511

            G_PKG_NAME, '1800: Leaving Update_Number_Scheme_Dtl' );

Line: 517

         okc_debug.log('1900: Leaving Update_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 522

   	      G_PKG_NAME, '1900: Leaving Update_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception' );

Line: 524

      ROLLBACK TO g_Update_Number_Scheme_Dtl_GRP;

Line: 530

         okc_debug.log('2000: Leaving Update_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 535

   	      G_PKG_NAME, '2000: Leaving Update_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

Line: 537

      ROLLBACK TO g_Update_Number_Scheme_Dtl_GRP;

Line: 543

        okc_debug.log('2100: Leaving Update_Number_Scheme_Dtl because of EXCEPTION: '||sqlerrm, 2);

Line: 548

   	      G_PKG_NAME, '2100: Leaving Update_Number_Scheme_Dtl because of EXCEPTION: '||sqlerrm );

Line: 550

      ROLLBACK TO g_Update_Number_Scheme_Dtl_GRP;

Line: 557

  END Update_Number_Scheme_Dtl;

Line: 562

  PROCEDURE Delete_Number_Scheme_Dtl(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    p_commit                       IN VARCHAR2 := FND_API.G_FALSE,

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

    p_num_scheme_id         IN NUMBER,
    p_num_sequence_code     IN VARCHAR2,
    p_sequence_level        IN NUMBER,
    p_object_version_number IN NUMBER
  ) IS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 577

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

Line: 581

       okc_debug.log('2200: Entered Delete_Number_Scheme_Dtl', 2);

Line: 586

            G_PKG_NAME, '2200: Entered Delete_Number_Scheme_Dtl' );

Line: 590

    SAVEPOINT g_Delete_Number_Scheme_Dtl_GRP;

Line: 605

    OKC_NUMBER_SCHEME_DTL_PVT.Delete_Row(
      x_return_status              =>   x_return_status,
      p_num_scheme_id         => p_num_scheme_id,
      p_num_sequence_code     => p_num_sequence_code,
      p_sequence_level        => p_sequence_level,
      p_object_version_number => p_object_version_number
    );

Line: 628

       okc_debug.log('2300: Leaving Delete_Number_Scheme_Dtl', 2);

Line: 633

            G_PKG_NAME, '2300: Leaving Delete_Number_Scheme_Dtl' );

Line: 639

         okc_debug.log('2400: Leaving Delete_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 644

   	      G_PKG_NAME, '2400: Leaving Delete_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception' );

Line: 646

      ROLLBACK TO g_Delete_Number_Scheme_Dtl_GRP;

Line: 652

         okc_debug.log('2500: Leaving Delete_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 657

   	      G_PKG_NAME, '2500: Leaving Delete_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

Line: 659

      ROLLBACK TO g_Delete_Number_Scheme_Dtl_GRP;

Line: 665

        okc_debug.log('2600: Leaving Delete_Number_Scheme_Dtl because of EXCEPTION: '||sqlerrm, 2);

Line: 670

   	      G_PKG_NAME, '2600: Leaving Delete_Number_Scheme_Dtl because of EXCEPTION: '||sqlerrm );

Line: 672

      ROLLBACK TO g_Delete_Number_Scheme_Dtl_GRP;

Line: 679

  END Delete_Number_Scheme_Dtl;