DBA Data[Home] [Help]

APPS.OKL_SVF_PVT SQL Statements

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

Line: 40

    DELETE FROM OKL_SERVICE_FEES_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKL_SERVICE_FEES_ALL_B B --changed _TL to _B by rvaduri for MLS compliance.
         WHERE B.ID = T.ID
        );
Line: 47

    UPDATE OKL_SERVICE_FEES_TL T SET (
        NAME,
        DESCRIPTION) = (SELECT
                                  B.NAME,
                                  B.DESCRIPTION
                                FROM OKL_SERVICE_FEES_TL B
                               WHERE B.ID = T.ID
                                 AND B.LANGUAGE = T.SOURCE_LANG)
      WHERE (
              T.ID,
              T.LANGUAGE)
          IN (SELECT
                  SUBT.ID,
                  SUBT.LANGUAGE
                FROM OKL_SERVICE_FEES_TL SUBB, OKL_SERVICE_FEES_TL SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.NAME <> SUBT.NAME
                      OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION
                      OR (SUBB.NAME IS NULL AND SUBT.NAME IS NOT NULL)
                      OR (SUBB.NAME IS NOT NULL AND SUBT.NAME IS NULL)
                      OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
                      OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
              ));
Line: 72

    INSERT INTO OKL_SERVICE_FEES_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        NAME,
        DESCRIPTION,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN)
      SELECT
            B.ID,
            L.LANGUAGE_CODE,
            B.SOURCE_LANG,
            B.SFWT_FLAG,
            B.NAME,
            B.DESCRIPTION,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN
        FROM OKL_SERVICE_FEES_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS(
                    SELECT NULL
                      FROM OKL_SERVICE_FEES_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );
Line: 116

    SELECT
            ID,
            SRV_CODE,
            OBJECT_VERSION_NUMBER,
            AMOUNT,
            START_DATE,
            END_DATE,
            ORGANIZATION_ID,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            ORG_ID
      FROM Okl_Service_Fees_B
     WHERE okl_service_fees_b.id = p_id;
Line: 180

              l_svf_rec.LAST_UPDATED_BY,
              l_svf_rec.LAST_UPDATE_DATE,
              l_svf_rec.LAST_UPDATE_LOGIN,
              l_svf_rec.ORG_ID;
Line: 205

    SELECT
            ID,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            NAME,
            DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Service_Fees_Tl
     WHERE okl_service_fees_tl.id = p_id
       AND okl_service_fees_tl.LANGUAGE = p_language;
Line: 236

              l_okl_service_fees_tl_rec.LAST_UPDATED_BY,
              l_okl_service_fees_tl_rec.LAST_UPDATE_DATE,
              l_okl_service_fees_tl_rec.LAST_UPDATE_LOGIN;
Line: 259

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            SFWT_FLAG,
            SRV_CODE,
            NAME,
            DESCRIPTION,
            AMOUNT,
            START_DATE,
            END_DATE,
            ORGANIZATION_ID,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Service_Fees_V
     WHERE okl_service_fees_v.id = p_id;
Line: 328

              l_svfv_rec.LAST_UPDATED_BY,
              l_svfv_rec.LAST_UPDATE_DATE,
              l_svfv_rec.LAST_UPDATE_LOGIN;
Line: 433

    IF (l_svfv_rec.last_updated_by = OKL_API.G_MISS_NUM) THEN
      l_svfv_rec.last_updated_by := NULL;
Line: 436

    IF (l_svfv_rec.last_update_date = OKL_API.G_MISS_DATE) THEN
      l_svfv_rec.last_update_date := NULL;
Line: 439

    IF (l_svfv_rec.last_update_login = OKL_API.G_MISS_NUM) THEN
      l_svfv_rec.last_update_login := NULL;
Line: 713

            SELECT id, srv_code, organization_id, end_date, start_date
            FROM   okl_service_fees_b
            WHERE  id = p_svfv_rec.id
            OR     organization_id = p_svfv_rec.organization_id AND id <> p_svfv_rec.id;
Line: 808

    p_to.last_updated_by := p_from.last_updated_by;
Line: 809

    p_to.last_update_date := p_from.last_update_date;
Line: 810

    p_to.last_update_login := p_from.last_update_login;
Line: 842

    p_to.last_updated_by := p_from.last_updated_by;
Line: 843

    p_to.last_update_date := p_from.last_update_date;
Line: 844

    p_to.last_update_login := p_from.last_update_login;
Line: 857

    p_to.last_updated_by := p_from.last_updated_by;
Line: 858

    p_to.last_update_date := p_from.last_update_date;
Line: 859

    p_to.last_update_login := p_from.last_update_login;
Line: 872

    p_to.last_updated_by := p_from.last_updated_by;
Line: 873

    p_to.last_update_date := p_from.last_update_date;
Line: 874

    p_to.last_update_login := p_from.last_update_login;
Line: 1028

  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_svf_rec                      IN svf_rec_type,
    x_svf_rec                      OUT NOCOPY svf_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1037

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_insert_row';
Line: 1073

    INSERT INTO OKL_SERVICE_FEES_B(
        id,
        srv_code,
        object_version_number,
        amount,
        start_date,
        end_date,
        organization_id,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        org_id)
      VALUES (
        l_svf_rec.id,
        l_svf_rec.srv_code,
        l_svf_rec.object_version_number,
        l_svf_rec.amount,
        l_svf_rec.start_date,
        l_svf_rec.end_date,
        l_svf_rec.organization_id,
        l_svf_rec.attribute_category,
        l_svf_rec.attribute1,
        l_svf_rec.attribute2,
        l_svf_rec.attribute3,
        l_svf_rec.attribute4,
        l_svf_rec.attribute5,
        l_svf_rec.attribute6,
        l_svf_rec.attribute7,
        l_svf_rec.attribute8,
        l_svf_rec.attribute9,
        l_svf_rec.attribute10,
        l_svf_rec.attribute11,
        l_svf_rec.attribute12,
        l_svf_rec.attribute13,
        l_svf_rec.attribute14,
        l_svf_rec.attribute15,
        l_svf_rec.created_by,
        l_svf_rec.creation_date,
        l_svf_rec.last_updated_by,
        l_svf_rec.last_update_date,
        l_svf_rec.last_update_login,
        l_svf_rec.organization_id);
Line: 1167

  END insert_row;
Line: 1171

  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okl_service_fees_tl_rec      IN okl_service_fees_tl_rec_type,
    x_okl_service_fees_tl_rec      OUT NOCOPY okl_service_fees_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1180

    l_api_name                     CONSTANT VARCHAR2(30) := 'TL_insert_row';
Line: 1185

      SELECT *
        FROM FND_LANGUAGES
       WHERE INSTALLED_FLAG IN ('I', 'B');
Line: 1224

      INSERT INTO OKL_SERVICE_FEES_TL(
          id,
          LANGUAGE,
          source_lang,
          sfwt_flag,
          name,
          description,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login)
        VALUES (
          l_okl_service_fees_tl_rec.id,
          l_okl_service_fees_tl_rec.LANGUAGE,
          l_okl_service_fees_tl_rec.source_lang,
          l_okl_service_fees_tl_rec.sfwt_flag,
          l_okl_service_fees_tl_rec.name,
          l_okl_service_fees_tl_rec.description,
          l_okl_service_fees_tl_rec.created_by,
          l_okl_service_fees_tl_rec.creation_date,
          l_okl_service_fees_tl_rec.last_updated_by,
          l_okl_service_fees_tl_rec.last_update_date,
          l_okl_service_fees_tl_rec.last_update_login);
Line: 1283

  END insert_row;
Line: 1287

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_svfv_rec                     IN svfv_rec_type,
    x_svfv_rec                     OUT NOCOPY svfv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1297

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';
Line: 1315

      l_svfv_rec.LAST_UPDATE_DATE := l_svfv_rec.CREATION_DATE;
Line: 1316

      l_svfv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 1317

      l_svfv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 1431

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_svf_rec,
      lx_svf_rec
    );
Line: 1445

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_service_fees_tl_rec,
      lx_okl_service_fees_tl_rec
    );
Line: 1493

  END insert_row;
Line: 1497

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_svfv_tbl                     IN svfv_tbl_type,
    x_svfv_tbl                     OUT NOCOPY svfv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1507

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
Line: 1516

        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKL_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_svfv_rec                     => p_svfv_tbl(i),
          x_svfv_rec                     => x_svfv_tbl(i));
Line: 1559

  END insert_row;
Line: 1577

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SERVICE_FEES_B
     WHERE ID = p_svf_rec.id
       AND OBJECT_VERSION_NUMBER = p_svf_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1584

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SERVICE_FEES_B
    WHERE ID = p_svf_rec.id;
Line: 1625

      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1634

      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 1683

    SELECT *
      FROM OKL_SERVICE_FEES_TL
     WHERE ID = p_okl_service_fees_tl_rec.id
    FOR UPDATE NOWAIT;
Line: 1719

      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1920

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_svf_rec                      IN svf_rec_type,
    x_svf_rec                      OUT NOCOPY svf_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1929

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_update_row';
Line: 2051

      IF (x_svf_rec.last_updated_by = OKL_API.G_MISS_NUM)
      THEN
        x_svf_rec.last_updated_by := l_svf_rec.last_updated_by;
Line: 2055

      IF (x_svf_rec.last_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_svf_rec.last_update_date := l_svf_rec.last_update_date;
Line: 2059

      IF (x_svf_rec.last_update_login = OKL_API.G_MISS_NUM)
      THEN
        x_svf_rec.last_update_login := l_svf_rec.last_update_login;
Line: 2108

    UPDATE  OKL_SERVICE_FEES_B
    SET SRV_CODE = l_def_svf_rec.srv_code,
        OBJECT_VERSION_NUMBER = l_def_svf_rec.object_version_number,
        AMOUNT = l_def_svf_rec.amount,
        START_DATE = l_def_svf_rec.start_date,
        END_DATE = l_def_svf_rec.end_date,
        ORGANIZATION_ID = l_def_svf_rec.organization_id,
        ATTRIBUTE_CATEGORY = l_def_svf_rec.attribute_category,
        ATTRIBUTE1 = l_def_svf_rec.attribute1,
        ATTRIBUTE2 = l_def_svf_rec.attribute2,
        ATTRIBUTE3 = l_def_svf_rec.attribute3,
        ATTRIBUTE4 = l_def_svf_rec.attribute4,
        ATTRIBUTE5 = l_def_svf_rec.attribute5,
        ATTRIBUTE6 = l_def_svf_rec.attribute6,
        ATTRIBUTE7 = l_def_svf_rec.attribute7,
        ATTRIBUTE8 = l_def_svf_rec.attribute8,
        ATTRIBUTE9 = l_def_svf_rec.attribute9,
        ATTRIBUTE10 = l_def_svf_rec.attribute10,
        ATTRIBUTE11 = l_def_svf_rec.attribute11,
        ATTRIBUTE12 = l_def_svf_rec.attribute12,
        ATTRIBUTE13 = l_def_svf_rec.attribute13,
        ATTRIBUTE14 = l_def_svf_rec.attribute14,
        ATTRIBUTE15 = l_def_svf_rec.attribute15,
        CREATED_BY = l_def_svf_rec.created_by,
        CREATION_DATE = l_def_svf_rec.creation_date,
        LAST_UPDATED_BY = l_def_svf_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_svf_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_svf_rec.last_update_login,
        ORG_ID=l_def_svf_rec.organization_id

    WHERE ID = l_def_svf_rec.id;
Line: 2173

  END update_row;
Line: 2177

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okl_service_fees_tl_rec      IN okl_service_fees_tl_rec_type,
    x_okl_service_fees_tl_rec      OUT NOCOPY okl_service_fees_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2186

    l_api_name                     CONSTANT VARCHAR2(30) := 'TL_update_row';
Line: 2240

      IF (x_okl_service_fees_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
      THEN
        x_okl_service_fees_tl_rec.last_updated_by := l_okl_service_fees_tl_rec.last_updated_by;
Line: 2244

      IF (x_okl_service_fees_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_okl_service_fees_tl_rec.last_update_date := l_okl_service_fees_tl_rec.last_update_date;
Line: 2248

      IF (x_okl_service_fees_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
      THEN
        x_okl_service_fees_tl_rec.last_update_login := l_okl_service_fees_tl_rec.last_update_login;
Line: 2294

    UPDATE  OKL_SERVICE_FEES_TL
    SET NAME = ldefoklservicefeestlrec.name,
        DESCRIPTION = ldefoklservicefeestlrec.description,
        SOURCE_LANG = ldefoklservicefeestlrec.source_lang,--Fix for 3637102
        CREATED_BY = ldefoklservicefeestlrec.created_by,
        CREATION_DATE = ldefoklservicefeestlrec.creation_date,
        LAST_UPDATED_BY = ldefoklservicefeestlrec.last_updated_by,
        LAST_UPDATE_DATE = ldefoklservicefeestlrec.last_update_date,
        LAST_UPDATE_LOGIN = ldefoklservicefeestlrec.last_update_login
    WHERE ID = ldefoklservicefeestlrec.id
        AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);--Fix for bug 3637102
Line: 2307

    UPDATE  OKL_SERVICE_FEES_TL
    SET SFWT_FLAG = 'Y'
    WHERE ID = ldefoklservicefeestlrec.id
      AND SOURCE_LANG <> USERENV('LANG');
Line: 2345

  END update_row;
Line: 2349

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_svfv_rec                     IN svfv_rec_type,
    x_svfv_rec                     OUT NOCOPY svfv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2359

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';
Line: 2375

      l_svfv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2376

      l_svfv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 2377

      l_svfv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 2509

      IF (x_svfv_rec.last_updated_by = OKL_API.G_MISS_NUM)
      THEN
        x_svfv_rec.last_updated_by := l_svfv_rec.last_updated_by;
Line: 2513

      IF (x_svfv_rec.last_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_svfv_rec.last_update_date := l_svfv_rec.last_update_date;
Line: 2517

      IF (x_svfv_rec.last_update_login = OKL_API.G_MISS_NUM)
      THEN
        x_svfv_rec.last_update_login := l_svfv_rec.last_update_login;
Line: 2592

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_service_fees_tl_rec,
      lx_okl_service_fees_tl_rec
    );
Line: 2606

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_svf_rec,
      lx_svf_rec
    );
Line: 2653

  END update_row;
Line: 2657

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_svfv_tbl                     IN svfv_tbl_type,
    x_svfv_tbl                     OUT NOCOPY svfv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2667

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
Line: 2676

        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKL_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_svfv_rec                     => p_svfv_tbl(i),
          x_svfv_rec                     => x_svfv_tbl(i));
Line: 2719

  END update_row;
Line: 2727

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_svf_rec                      IN svf_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2735

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_delete_row';
Line: 2749

    DELETE FROM OKL_SERVICE_FEES_B
     WHERE ID = l_svf_rec.id;
Line: 2784

  END delete_row;
Line: 2788

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okl_service_fees_tl_rec      IN okl_service_fees_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2796

    l_api_name                     CONSTANT VARCHAR2(30) := 'TL_delete_row';
Line: 2833

    DELETE FROM OKL_SERVICE_FEES_TL
     WHERE ID = l_okl_service_fees_tl_rec.id;
Line: 2868

  END delete_row;
Line: 2872

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_svfv_rec                     IN svfv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2881

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';
Line: 2907

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_service_fees_tl_rec
    );
Line: 2919

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_svf_rec
    );
Line: 2963

  END delete_row;
Line: 2967

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_svfv_tbl                     IN svfv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2976

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
Line: 2985

        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKL_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_svfv_rec                     => p_svfv_tbl(i));
Line: 3027

  END delete_row;