DBA Data[Home] [Help]

APPS.OKL_XHR_PVT SQL Statements

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

Line: 40

    DELETE FROM OKL_EXT_FUND_RQNS_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKL_EXT_FUND_RQNS_ALL_B B  --fixed bug 3321017 by kmotepal
         WHERE B.ID = T.ID
        );
Line: 53

       UPDATE statement is not complete.
     Please comment out WHERE condition if
       UPDATE statement is not present
     If new release has some columns in the table,
       this modification is not needed

    WHERE (
            T.ID,
            T.LANGUAGE)
        IN (SELECT
                SUBT.ID,
                SUBT.LANGUAGE
              FROM OKL_EXT_FUND_RQNS_TL SUBB, OKL_EXT_FUND_RQNS_TL SUBT
             WHERE SUBB.ID = SUBT.ID
               AND SUBB.LANGUAGE = SUBT.SOURCE_LANG

  */

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

  SELECT
          ID,
          IRQ_ID,
          OBJECT_VERSION_NUMBER,
          CREATED_BY,
          CREATION_DATE,
          LAST_UPDATED_BY,
          LAST_UPDATE_DATE,
          ORG_ID,
          REQUEST_ID,
          PROGRAM_APPLICATION_ID,
          PROGRAM_ID,
          PROGRAM_UPDATE_DATE,
          ATTRIBUTE_CATEGORY,
          ATTRIBUTE1,
          ATTRIBUTE2,
          ATTRIBUTE3,
          ATTRIBUTE4,
          ATTRIBUTE5,
          ATTRIBUTE6,
          ATTRIBUTE7,
          ATTRIBUTE8,
          ATTRIBUTE9,
          ATTRIBUTE10,
          ATTRIBUTE11,
          ATTRIBUTE12,
          ATTRIBUTE13,
          ATTRIBUTE14,
          ATTRIBUTE15,
          LAST_UPDATE_LOGIN
    FROM Okl_Ext_Fund_Rqns_B
   WHERE okl_ext_fund_rqns_b.id = p_id;
Line: 155

            l_xhr_rec.LAST_UPDATED_BY,
            l_xhr_rec.LAST_UPDATE_DATE,
            l_xhr_rec.ORG_ID,
            l_xhr_rec.REQUEST_ID,
            l_xhr_rec.PROGRAM_APPLICATION_ID,
            l_xhr_rec.PROGRAM_ID,
            l_xhr_rec.PROGRAM_UPDATE_DATE,
            l_xhr_rec.ATTRIBUTE_CATEGORY,
            l_xhr_rec.ATTRIBUTE1,
            l_xhr_rec.ATTRIBUTE2,
            l_xhr_rec.ATTRIBUTE3,
            l_xhr_rec.ATTRIBUTE4,
            l_xhr_rec.ATTRIBUTE5,
            l_xhr_rec.ATTRIBUTE6,
            l_xhr_rec.ATTRIBUTE7,
            l_xhr_rec.ATTRIBUTE8,
            l_xhr_rec.ATTRIBUTE9,
            l_xhr_rec.ATTRIBUTE10,
            l_xhr_rec.ATTRIBUTE11,
            l_xhr_rec.ATTRIBUTE12,
            l_xhr_rec.ATTRIBUTE13,
            l_xhr_rec.ATTRIBUTE14,
            l_xhr_rec.ATTRIBUTE15,
            l_xhr_rec.LAST_UPDATE_LOGIN;
Line: 200

  SELECT
          ID,
          LANGUAGE,
          SOURCE_LANG,
          SFWT_FLAG,
          CREATED_BY,
          CREATION_DATE,
          LAST_UPDATED_BY,
          LAST_UPDATE_DATE,
          LAST_UPDATE_LOGIN
    FROM Okl_Ext_Fund_Rqns_Tl
   WHERE okl_ext_fund_rqns_tl.id = p_id
     AND okl_ext_fund_rqns_tl.language = p_language;
Line: 227

            l_okl_ext_fund_rqns_tl_rec.LAST_UPDATED_BY,
            l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_DATE,
            l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_LOGIN;
Line: 250

  SELECT
          ID,
          OBJECT_VERSION_NUMBER,
          SFWT_FLAG,
          IRQ_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,
          ORG_ID,
          REQUEST_ID,
          PROGRAM_APPLICATION_ID,
          PROGRAM_ID,
          PROGRAM_UPDATE_DATE,
          LAST_UPDATE_LOGIN
    FROM Okl_Ext_Fund_Rqns_V
   WHERE okl_ext_fund_rqns_v.id = p_id;
Line: 312

            l_xhrv_rec.LAST_UPDATED_BY,
            l_xhrv_rec.LAST_UPDATE_DATE,
            l_xhrv_rec.ORG_ID,
            l_xhrv_rec.REQUEST_ID,
            l_xhrv_rec.PROGRAM_APPLICATION_ID,
            l_xhrv_rec.PROGRAM_ID,
            l_xhrv_rec.PROGRAM_UPDATE_DATE,
            l_xhrv_rec.LAST_UPDATE_LOGIN;
Line: 404

  IF (l_xhrv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
    l_xhrv_rec.last_updated_by := NULL;
Line: 407

  IF (l_xhrv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
    l_xhrv_rec.last_update_date := NULL;
Line: 422

  IF (l_xhrv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
    l_xhrv_rec.program_update_date := NULL;
Line: 425

  IF (l_xhrv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
    l_xhrv_rec.last_update_login := NULL;
Line: 482

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

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

  p_to.program_update_date := p_from.program_update_date;
Line: 505

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

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

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

  p_to.program_update_date := p_from.program_update_date;
Line: 540

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

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

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

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

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

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

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

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_xhr_rec                      IN xhr_rec_type,
  x_xhr_rec                      OUT NOCOPY xhr_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 729

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

  INSERT INTO OKL_EXT_FUND_RQNS_B(
      id,
      irq_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      org_id,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      last_update_login)
    VALUES (
      l_xhr_rec.id,
      l_xhr_rec.irq_id,
      l_xhr_rec.object_version_number,
      l_xhr_rec.created_by,
      l_xhr_rec.creation_date,
      l_xhr_rec.last_updated_by,
      l_xhr_rec.last_update_date,
      l_xhr_rec.org_id,
      l_xhr_rec.request_id,
      l_xhr_rec.program_application_id,
      l_xhr_rec.program_id,
      l_xhr_rec.program_update_date,
      l_xhr_rec.attribute_category,
      l_xhr_rec.attribute1,
      l_xhr_rec.attribute2,
      l_xhr_rec.attribute3,
      l_xhr_rec.attribute4,
      l_xhr_rec.attribute5,
      l_xhr_rec.attribute6,
      l_xhr_rec.attribute7,
      l_xhr_rec.attribute8,
      l_xhr_rec.attribute9,
      l_xhr_rec.attribute10,
      l_xhr_rec.attribute11,
      l_xhr_rec.attribute12,
      l_xhr_rec.attribute13,
      l_xhr_rec.attribute14,
      l_xhr_rec.attribute15,
      l_xhr_rec.last_update_login);
Line: 859

END insert_row;
Line: 863

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_ext_fund_rqns_tl_rec     IN okl_ext_fund_rqns_tl_rec_type,
  x_okl_ext_fund_rqns_tl_rec     OUT NOCOPY okl_ext_fund_rqns_tl_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 872

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

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

    INSERT INTO OKL_EXT_FUND_RQNS_TL(
        id,
        language,
        source_lang,
        sfwt_flag,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_okl_ext_fund_rqns_tl_rec.id,
        l_okl_ext_fund_rqns_tl_rec.language,
        l_okl_ext_fund_rqns_tl_rec.source_lang,
        l_okl_ext_fund_rqns_tl_rec.sfwt_flag,
        l_okl_ext_fund_rqns_tl_rec.created_by,
        l_okl_ext_fund_rqns_tl_rec.creation_date,
        l_okl_ext_fund_rqns_tl_rec.last_updated_by,
        l_okl_ext_fund_rqns_tl_rec.last_update_date,
        l_okl_ext_fund_rqns_tl_rec.last_update_login);
Line: 971

END insert_row;
Line: 975

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_xhrv_rec                     IN xhrv_rec_type,
  x_xhrv_rec                     OUT NOCOPY xhrv_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 985

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

    l_xhrv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1004

    l_xhrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1005

    l_xhrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1071

  insert_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_xhr_rec,
    lx_xhr_rec
  );
Line: 1085

  insert_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_okl_ext_fund_rqns_tl_rec,
    lx_okl_ext_fund_rqns_tl_rec
  );
Line: 1133

END insert_row;
Line: 1137

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_xhrv_tbl                     IN xhrv_tbl_type,
  x_xhrv_tbl                     OUT NOCOPY xhrv_tbl_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 1147

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

      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_xhrv_rec                     => p_xhrv_tbl(i),
        x_xhrv_rec                     => x_xhrv_tbl(i));
Line: 1199

END insert_row;
Line: 1217

  SELECT OBJECT_VERSION_NUMBER
    FROM OKL_EXT_FUND_RQNS_B
   WHERE ID = p_xhr_rec.id
     AND OBJECT_VERSION_NUMBER = p_xhr_rec.object_version_number
  FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1224

  SELECT OBJECT_VERSION_NUMBER
    FROM OKL_EXT_FUND_RQNS_B
  WHERE ID = p_xhr_rec.id;
Line: 1265

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

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

  SELECT *
    FROM OKL_EXT_FUND_RQNS_TL
   WHERE ID = p_okl_ext_fund_rqns_tl_rec.id
  FOR UPDATE NOWAIT;
Line: 1359

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

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_xhr_rec                      IN xhr_rec_type,
  x_xhr_rec                      OUT NOCOPY xhr_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 1569

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

    IF (x_xhr_rec.last_updated_by = OKC_API.G_MISS_NUM)
    THEN
      x_xhr_rec.last_updated_by := l_xhr_rec.last_updated_by;
Line: 1615

    IF (x_xhr_rec.last_update_date = OKC_API.G_MISS_DATE)
    THEN
      x_xhr_rec.last_update_date := l_xhr_rec.last_update_date;
Line: 1635

    IF (x_xhr_rec.program_update_date = OKC_API.G_MISS_DATE)
    THEN
      x_xhr_rec.program_update_date := l_xhr_rec.program_update_date;
Line: 1703

    IF (x_xhr_rec.last_update_login = OKC_API.G_MISS_NUM)
    THEN
      x_xhr_rec.last_update_login := l_xhr_rec.last_update_login;
Line: 1747

  UPDATE  OKL_EXT_FUND_RQNS_B
  SET IRQ_ID = l_def_xhr_rec.irq_id,
      OBJECT_VERSION_NUMBER = l_def_xhr_rec.object_version_number,
      CREATED_BY = l_def_xhr_rec.created_by,
      CREATION_DATE = l_def_xhr_rec.creation_date,
      LAST_UPDATED_BY = l_def_xhr_rec.last_updated_by,
      LAST_UPDATE_DATE = l_def_xhr_rec.last_update_date,
      ORG_ID = l_def_xhr_rec.org_id,
      REQUEST_ID = l_def_xhr_rec.request_id,
      PROGRAM_APPLICATION_ID = l_def_xhr_rec.program_application_id,
      PROGRAM_ID = l_def_xhr_rec.program_id,
      PROGRAM_UPDATE_DATE = l_def_xhr_rec.program_update_date,
      ATTRIBUTE_CATEGORY = l_def_xhr_rec.attribute_category,
      ATTRIBUTE1 = l_def_xhr_rec.attribute1,
      ATTRIBUTE2 = l_def_xhr_rec.attribute2,
      ATTRIBUTE3 = l_def_xhr_rec.attribute3,
      ATTRIBUTE4 = l_def_xhr_rec.attribute4,
      ATTRIBUTE5 = l_def_xhr_rec.attribute5,
      ATTRIBUTE6 = l_def_xhr_rec.attribute6,
      ATTRIBUTE7 = l_def_xhr_rec.attribute7,
      ATTRIBUTE8 = l_def_xhr_rec.attribute8,
      ATTRIBUTE9 = l_def_xhr_rec.attribute9,
      ATTRIBUTE10 = l_def_xhr_rec.attribute10,
      ATTRIBUTE11 = l_def_xhr_rec.attribute11,
      ATTRIBUTE12 = l_def_xhr_rec.attribute12,
      ATTRIBUTE13 = l_def_xhr_rec.attribute13,
      ATTRIBUTE14 = l_def_xhr_rec.attribute14,
      ATTRIBUTE15 = l_def_xhr_rec.attribute15,
      LAST_UPDATE_LOGIN = l_def_xhr_rec.last_update_login
  WHERE ID = l_def_xhr_rec.id;
Line: 1811

END update_row;
Line: 1815

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_ext_fund_rqns_tl_rec     IN okl_ext_fund_rqns_tl_rec_type,
  x_okl_ext_fund_rqns_tl_rec     OUT NOCOPY okl_ext_fund_rqns_tl_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 1824

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

    IF (x_okl_ext_fund_rqns_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
    THEN
      x_okl_ext_fund_rqns_tl_rec.last_updated_by := l_okl_ext_fund_rqns_tl_rec.last_updated_by;
Line: 1874

    IF (x_okl_ext_fund_rqns_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
    THEN
      x_okl_ext_fund_rqns_tl_rec.last_update_date := l_okl_ext_fund_rqns_tl_rec.last_update_date;
Line: 1878

    IF (x_okl_ext_fund_rqns_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
    THEN
      x_okl_ext_fund_rqns_tl_rec.last_update_login := l_okl_ext_fund_rqns_tl_rec.last_update_login;
Line: 1924

  UPDATE  OKL_EXT_FUND_RQNS_TL
  SET SOURCE_LANG = ldefoklextfundrqnstlrec.source_lang,
      CREATED_BY = ldefoklextfundrqnstlrec.created_by,
      CREATION_DATE = ldefoklextfundrqnstlrec.creation_date,
      LAST_UPDATED_BY = ldefoklextfundrqnstlrec.last_updated_by,
      LAST_UPDATE_DATE = ldefoklextfundrqnstlrec.last_update_date,
      LAST_UPDATE_LOGIN = ldefoklextfundrqnstlrec.last_update_login
  WHERE ID = ldefoklextfundrqnstlrec.id
  AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
Line: 1934

  UPDATE  OKL_EXT_FUND_RQNS_TL
  SET SFWT_FLAG = 'Y'
  WHERE ID = ldefoklextfundrqnstlrec.id
    AND SOURCE_LANG <> USERENV('LANG');
Line: 1972

END update_row;
Line: 1976

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_xhrv_rec                     IN xhrv_rec_type,
  x_xhrv_rec                     OUT NOCOPY xhrv_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 1986

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

    l_xhrv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2003

    l_xhrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2004

    l_xhrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2112

    IF (x_xhrv_rec.last_updated_by = OKC_API.G_MISS_NUM)
    THEN
      x_xhrv_rec.last_updated_by := l_xhrv_rec.last_updated_by;
Line: 2116

    IF (x_xhrv_rec.last_update_date = OKC_API.G_MISS_DATE)
    THEN
      x_xhrv_rec.last_update_date := l_xhrv_rec.last_update_date;
Line: 2136

    IF (x_xhrv_rec.program_update_date = OKC_API.G_MISS_DATE)
    THEN
      x_xhrv_rec.program_update_date := l_xhrv_rec.program_update_date;
Line: 2140

    IF (x_xhrv_rec.last_update_login = OKC_API.G_MISS_NUM)
    THEN
      x_xhrv_rec.last_update_login := l_xhrv_rec.last_update_login;
Line: 2212

  update_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_okl_ext_fund_rqns_tl_rec,
    lx_okl_ext_fund_rqns_tl_rec
  );
Line: 2226

  update_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_xhr_rec,
    lx_xhr_rec
  );
Line: 2273

END update_row;
Line: 2277

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_xhrv_tbl                     IN xhrv_tbl_type,
  x_xhrv_tbl                     OUT NOCOPY xhrv_tbl_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2287

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

      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_xhrv_rec                     => p_xhrv_tbl(i),
        x_xhrv_rec                     => x_xhrv_tbl(i));
Line: 2339

END update_row;
Line: 2347

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_xhr_rec                      IN xhr_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2355

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

  DELETE FROM OKL_EXT_FUND_RQNS_B
   WHERE ID = l_xhr_rec.id;
Line: 2404

END delete_row;
Line: 2408

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_ext_fund_rqns_tl_rec     IN okl_ext_fund_rqns_tl_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2416

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

  DELETE FROM OKL_EXT_FUND_RQNS_TL
   WHERE ID = l_okl_ext_fund_rqns_tl_rec.id;
Line: 2488

END delete_row;
Line: 2492

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_xhrv_rec                     IN xhrv_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2501

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

  delete_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_okl_ext_fund_rqns_tl_rec
  );
Line: 2539

  delete_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_xhr_rec
  );
Line: 2583

END delete_row;
Line: 2587

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_xhrv_tbl                     IN xhrv_tbl_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2596

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

      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_xhrv_rec                     => p_xhrv_tbl(i));
Line: 2647

END delete_row;