DBA Data[Home] [Help]

APPS.OKL_RPC_PVT SQL Statements

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

Line: 648

    DELETE FROM OKL_REPAIR_COSTS_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKL_REPAIR_COSTS_ALL_B B
         WHERE B.ID = T.ID
        );
Line: 655

    UPDATE OKL_REPAIR_COSTS_TL T SET (
        REPAIR_TYPE,
        DESCRIPTION) = (SELECT
                                  B.REPAIR_TYPE,
                                  B.DESCRIPTION
                                FROM OKL_REPAIR_COSTS_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_REPAIR_COSTS_TL SUBB, OKL_REPAIR_COSTS_TL SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.REPAIR_TYPE <> SUBT.REPAIR_TYPE
                      OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION
              ));
Line: 676

    INSERT INTO OKL_REPAIR_COSTS_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        REPAIR_TYPE,
        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.REPAIR_TYPE,
            B.DESCRIPTION,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN
        FROM OKL_REPAIR_COSTS_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS(
                    SELECT NULL
                      FROM OKL_REPAIR_COSTS_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );
Line: 721

    SELECT
            ID,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            REPAIR_TYPE,
            DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Repair_Costs_Tl
     WHERE okl_repair_costs_tl.id = p_id
       AND okl_repair_costs_tl.language = p_language;
Line: 752

              l_okl_repair_costs_tl_rec.LAST_UPDATED_BY,
              l_okl_repair_costs_tl_rec.LAST_UPDATE_DATE,
              l_okl_repair_costs_tl_rec.LAST_UPDATE_LOGIN;
Line: 785

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            ENABLED_YN,
            ORG_ID,
            COST,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
  -- SPILLAIP - 2667636 - Start
            CURRENCY_CODE,
            CURRENCY_CONVERSION_CODE,
            CURRENCY_CONVERSION_TYPE,
            CURRENCY_CONVERSION_RATE,
            CURRENCY_CONVERSION_DATE
  -- SPILLAIP - 2667636 - End
      FROM Okl_Repair_Costs_B
     WHERE okl_repair_costs_b.id = p_id;
Line: 819

              l_rpc_rec.LAST_UPDATED_BY,
              l_rpc_rec.LAST_UPDATE_DATE,
              l_rpc_rec.LAST_UPDATE_LOGIN,
  -- SPILLAIP - 2667636 - Start
              l_rpc_rec.CURRENCY_CODE,
              l_rpc_rec.CURRENCY_CONVERSION_CODE,
              l_rpc_rec.CURRENCY_CONVERSION_TYPE,
              l_rpc_rec.CURRENCY_CONVERSION_RATE,
              l_rpc_rec.CURRENCY_CONVERSION_DATE;
Line: 859

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            SFWT_FLAG,
            ENABLED_YN,
            ORG_ID,
            COST,
            REPAIR_TYPE,
            DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
 -- SPILLAIP - 2667636 - Start
            CURRENCY_CODE,
            CURRENCY_CONVERSION_CODE,
            CURRENCY_CONVERSION_TYPE,
            CURRENCY_CONVERSION_RATE,
            CURRENCY_CONVERSION_DATE
 -- SPILLAIP - 2667636 - End
      FROM Okl_Repair_Costs_V
     WHERE okl_repair_costs_v.id = p_id;
Line: 899

              l_rpcv_rec.LAST_UPDATED_BY,
              l_rpcv_rec.LAST_UPDATE_DATE,
              l_rpcv_rec.LAST_UPDATE_LOGIN,
  -- SPILLAIP - 2667636 -Start
              l_rpcv_rec.CURRENCY_CODE,
              l_rpcv_rec.CURRENCY_CONVERSION_CODE,
              l_rpcv_rec.CURRENCY_CONVERSION_TYPE,
              l_rpcv_rec.CURRENCY_CONVERSION_RATE,
              l_rpcv_rec.CURRENCY_CONVERSION_DATE;
Line: 967

    IF (l_rpcv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_rpcv_rec.last_updated_by := NULL;
Line: 970

    IF (l_rpcv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_rpcv_rec.last_update_date := NULL;
Line: 973

    IF (l_rpcv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_rpcv_rec.last_update_login := NULL;
Line: 1204

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

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

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

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

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

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

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

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

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

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

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

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

  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okl_repair_costs_tl_rec      IN okl_repair_costs_tl_rec_type,
    x_okl_repair_costs_tl_rec      OUT NOCOPY okl_repair_costs_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1468

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

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

      INSERT INTO OKL_REPAIR_COSTS_TL(
          id,
          language,
          source_lang,
          sfwt_flag,
          repair_type,
          description,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login)
        VALUES (
          l_okl_repair_costs_tl_rec.id,
          l_okl_repair_costs_tl_rec.language,
          l_okl_repair_costs_tl_rec.source_lang,
          l_okl_repair_costs_tl_rec.sfwt_flag,
          l_okl_repair_costs_tl_rec.repair_type,
          l_okl_repair_costs_tl_rec.description,
          l_okl_repair_costs_tl_rec.created_by,
          l_okl_repair_costs_tl_rec.creation_date,
          l_okl_repair_costs_tl_rec.last_updated_by,
          l_okl_repair_costs_tl_rec.last_update_date,
          l_okl_repair_costs_tl_rec.last_update_login);
Line: 1571

  END insert_row;
Line: 1585

  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpc_rec                      IN rpc_rec_type,
    x_rpc_rec                      OUT NOCOPY rpc_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1594

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

    INSERT INTO OKL_REPAIR_COSTS_B(
        id,
        object_version_number,
        enabled_yn,
        org_id,
        cost,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
  -- SPILLAIP - 2667636 - Start
        currency_code,
        currency_conversion_code,
        currency_conversion_type,
        currency_conversion_rate,
        currency_conversion_date)
  -- SPILLAIP - 2667636 - End
      VALUES (
        l_rpc_rec.id,
        l_rpc_rec.object_version_number,
        l_rpc_rec.enabled_yn,
        l_rpc_rec.org_id,
        l_rpc_rec.cost,
        l_rpc_rec.created_by,
        l_rpc_rec.creation_date,
        l_rpc_rec.last_updated_by,
        l_rpc_rec.last_update_date,
        l_rpc_rec.last_update_login,
  -- SPILLAIP - 2667636 - Start
        l_rpc_rec.currency_code,
        l_rpc_rec.currency_conversion_code,
        l_rpc_rec.currency_conversion_type,
        l_rpc_rec.currency_conversion_rate,
        l_rpc_rec.currency_conversion_date);
Line: 1700

  END insert_row;
Line: 1714

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpcv_rec                     IN rpcv_rec_type,
    x_rpcv_rec                     OUT NOCOPY rpcv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1724

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

      l_rpcv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1743

      l_rpcv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1744

      l_rpcv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1835

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_repair_costs_tl_rec,
      lx_okl_repair_costs_tl_rec
    );
Line: 1849

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_rpc_rec,
      lx_rpc_rec
    );
Line: 1897

  END insert_row;
Line: 1901

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpcv_tbl                     IN rpcv_tbl_type,
    x_rpcv_tbl                     OUT NOCOPY rpcv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1911

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

        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_rpcv_rec                     => p_rpcv_tbl(i),
          x_rpcv_rec                     => x_rpcv_tbl(i));
Line: 1979

  END insert_row;
Line: 1997

    SELECT *
      FROM OKL_REPAIR_COSTS_TL
     WHERE ID = p_okl_repair_costs_tl_rec.id
    FOR UPDATE NOWAIT;
Line: 2033

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 2082

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_REPAIR_COSTS_B
     WHERE ID = p_rpc_rec.id
       AND OBJECT_VERSION_NUMBER = p_rpc_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 2089

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_REPAIR_COSTS_B
    WHERE ID = p_rpc_rec.id;
Line: 2130

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 2139

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 2356

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okl_repair_costs_tl_rec      IN okl_repair_costs_tl_rec_type,
    x_okl_repair_costs_tl_rec      OUT NOCOPY okl_repair_costs_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2365

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

      IF (x_okl_repair_costs_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_okl_repair_costs_tl_rec.last_updated_by := l_okl_repair_costs_tl_rec.last_updated_by;
Line: 2423

      IF (x_okl_repair_costs_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_okl_repair_costs_tl_rec.last_update_date := l_okl_repair_costs_tl_rec.last_update_date;
Line: 2427

      IF (x_okl_repair_costs_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_okl_repair_costs_tl_rec.last_update_login := l_okl_repair_costs_tl_rec.last_update_login;
Line: 2473

    UPDATE  OKL_REPAIR_COSTS_TL
    SET REPAIR_TYPE = ldefoklrepaircoststlrec.repair_type,
        DESCRIPTION = ldefoklrepaircoststlrec.description,
        SOURCE_LANG = ldefoklrepaircoststlrec.source_lang, --Fix fro bug 3637102
        CREATED_BY = ldefoklrepaircoststlrec.created_by,
        CREATION_DATE = ldefoklrepaircoststlrec.creation_date,
        LAST_UPDATED_BY = ldefoklrepaircoststlrec.last_updated_by,
        LAST_UPDATE_DATE = ldefoklrepaircoststlrec.last_update_date,
        LAST_UPDATE_LOGIN = ldefoklrepaircoststlrec.last_update_login
    WHERE ID = ldefoklrepaircoststlrec.id
        AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);--Fix for bug 3637102
Line: 2486

    UPDATE  OKL_REPAIR_COSTS_TL
    SET SFWT_FLAG = 'Y'
    WHERE ID = ldefoklrepaircoststlrec.id
      AND SOURCE_LANG <> USERENV('LANG');
Line: 2524

  END update_row;
Line: 2538

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpc_rec                      IN rpc_rec_type,
    x_rpc_rec                      OUT NOCOPY rpc_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2547

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

      IF (x_rpc_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_rpc_rec.last_updated_by := l_rpc_rec.last_updated_by;
Line: 2601

      IF (x_rpc_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_rpc_rec.last_update_date := l_rpc_rec.last_update_date;
Line: 2605

      IF (x_rpc_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_rpc_rec.last_update_login := l_rpc_rec.last_update_login;
Line: 2671

    UPDATE  OKL_REPAIR_COSTS_B
    SET OBJECT_VERSION_NUMBER = l_def_rpc_rec.object_version_number,
        ENABLED_YN = l_def_rpc_rec.enabled_yn,
        ORG_ID = l_def_rpc_rec.org_id,
        COST = l_def_rpc_rec.cost,
        CREATED_BY = l_def_rpc_rec.created_by,
        CREATION_DATE = l_def_rpc_rec.creation_date,
        LAST_UPDATED_BY = l_def_rpc_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_rpc_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_rpc_rec.last_update_login,
  -- SPILLAIP - 2667636 - Start
        CURRENCY_CODE = l_def_rpc_rec.currency_code,
        CURRENCY_CONVERSION_CODE = l_def_rpc_rec.currency_conversion_code,
        CURRENCY_CONVERSION_TYPE = l_def_rpc_rec.currency_conversion_type,
        CURRENCY_CONVERSION_RATE = l_def_rpc_rec.currency_conversion_rate,
        CURRENCY_CONVERSION_DATE = l_def_rpc_rec.currency_conversion_date
  -- SPILLAIP - 2667636 - End

    WHERE ID = l_def_rpc_rec.id;
Line: 2724

  END update_row;
Line: 2738

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpcv_rec                     IN rpcv_rec_type,
    x_rpcv_rec                     OUT NOCOPY rpcv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2748

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

      l_rpcv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2765

      l_rpcv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2766

      l_rpcv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2826

      IF (x_rpcv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_rpcv_rec.last_updated_by := l_rpcv_rec.last_updated_by;
Line: 2830

      IF (x_rpcv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_rpcv_rec.last_update_date := l_rpcv_rec.last_update_date;
Line: 2834

      IF (x_rpcv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_rpcv_rec.last_update_login := l_rpcv_rec.last_update_login;
Line: 2933

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_rpc_rec,
      lx_rpc_rec
    );
Line: 2947

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_repair_costs_tl_rec,
      lx_okl_repair_costs_tl_rec
    );
Line: 2994

  END update_row;
Line: 2998

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpcv_tbl                     IN rpcv_tbl_type,
    x_rpcv_tbl                     OUT NOCOPY rpcv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3008

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

        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_rpcv_rec                     => p_rpcv_tbl(i),
          x_rpcv_rec                     => x_rpcv_tbl(i));
Line: 3076

  END update_row;
Line: 3084

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okl_repair_costs_tl_rec      IN okl_repair_costs_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3092

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

    DELETE FROM OKL_REPAIR_COSTS_TL
     WHERE ID = l_okl_repair_costs_tl_rec.id;
Line: 3164

  END delete_row;
Line: 3168

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpc_rec                      IN rpc_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3176

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

    DELETE FROM OKL_REPAIR_COSTS_B
     WHERE ID = l_rpc_rec.id;
Line: 3225

  END delete_row;
Line: 3229

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpcv_rec                     IN rpcv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3238

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_rpc_rec
    );
Line: 3276

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_repair_costs_tl_rec
    );
Line: 3320

  END delete_row;
Line: 3324

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rpcv_tbl                     IN rpcv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3333

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

        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_rpcv_rec                     => p_rpcv_tbl(i));
Line: 3399

  END delete_row;