eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CMG_PVT SQL Statements

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

Line: 60


    SELECT
            ID,
            IMS_ID,
            IVM_ID,
            OBJECT_VERSION_NUMBER,
            SEQUENCE_NUMBER,
            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_Condition_Mssgs
     WHERE okl_condition_mssgs.id = p_id;

Line: 119


              l_cmg_rec.LAST_UPDATED_BY,
              l_cmg_rec.LAST_UPDATE_DATE,
              l_cmg_rec.LAST_UPDATE_LOGIN;

Line: 142


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            IMS_ID,
            IVM_ID,
            SEQUENCE_NUMBER,
            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_Condition_Mssgs_V
     WHERE okl_condition_mssgs_v.id = p_id;

Line: 201


              l_cmgv_rec.LAST_UPDATED_BY,
              l_cmgv_rec.LAST_UPDATE_DATE,
              l_cmgv_rec.LAST_UPDATE_LOGIN;

Line: 291


    IF (l_cmgv_rec.last_updated_by = OKL_API.G_MISS_NUM) THEN
      l_cmgv_rec.last_updated_by := NULL;

Line: 294


    IF (l_cmgv_rec.last_update_date = OKL_API.G_MISS_DATE) THEN
      l_cmgv_rec.last_update_date := NULL;

Line: 297


    IF (l_cmgv_rec.last_update_login = OKL_API.G_MISS_NUM) THEN
      l_cmgv_rec.last_update_login := NULL;

Line: 424


		  SELECT 'x'
		  FROM   okl_invoice_mssgs_v
		  WHERE  id = p_cmgv_rec.ims_id;

Line: 513


		  SELECT 'x'
		  FROM   okl_invc_mss_prcdrs_v
		  WHERE  id = p_cmgv_rec.ivm_id;

Line: 599


		  SELECT 'x'
		  FROM   okl_condition_mssgs_v
		  WHERE  ims_id   = p_cmgv_rec.ims_id
		  AND    ivm_id   = p_cmgv_rec.ivm_id
		  AND    id       <> nvl (p_cmgv_rec.id, -99999);

Line: 812


    p_to.last_updated_by := p_from.last_updated_by;

Line: 813


    p_to.last_update_date := p_from.last_update_date;

Line: 814


    p_to.last_update_login := p_from.last_update_login;

Line: 844


    p_to.last_updated_by := p_from.last_updated_by;

Line: 845


    p_to.last_update_date := p_from.last_update_date;

Line: 846


    p_to.last_update_login := p_from.last_update_login;

Line: 1018


  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_cmg_rec                      IN cmg_rec_type,
    x_cmg_rec                      OUT NOCOPY cmg_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1027


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

Line: 1063


    INSERT INTO OKL_CONDITION_MSSGS(
        id,
        ims_id,
        ivm_id,
        object_version_number,
        sequence_number,
        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)
      VALUES (
        l_cmg_rec.id,
        l_cmg_rec.ims_id,
        l_cmg_rec.ivm_id,
        l_cmg_rec.object_version_number,
        l_cmg_rec.sequence_number,
        l_cmg_rec.attribute_category,
        l_cmg_rec.attribute1,
        l_cmg_rec.attribute2,
        l_cmg_rec.attribute3,
        l_cmg_rec.attribute4,
        l_cmg_rec.attribute5,
        l_cmg_rec.attribute6,
        l_cmg_rec.attribute7,
        l_cmg_rec.attribute8,
        l_cmg_rec.attribute9,
        l_cmg_rec.attribute10,
        l_cmg_rec.attribute11,
        l_cmg_rec.attribute12,
        l_cmg_rec.attribute13,
        l_cmg_rec.attribute14,
        l_cmg_rec.attribute15,
        l_cmg_rec.created_by,
        l_cmg_rec.creation_date,
        l_cmg_rec.last_updated_by,
        l_cmg_rec.last_update_date,
        l_cmg_rec.last_update_login);

Line: 1151


  END insert_row;

Line: 1155


  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_cmgv_rec        IN              cmgv_rec_type,
      x_cmgv_rec        OUT NOCOPY      cmgv_rec_type
   ) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1166


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

Line: 1182


      l_cmgv_rec.LAST_UPDATE_DATE := l_cmgv_rec.CREATION_DATE;

Line: 1183


      l_cmgv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1184


      l_cmgv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1248


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cmg_rec,
      lx_cmg_rec
    );

Line: 1296


  END insert_row;

Line: 1300


  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_cmgv_tbl        IN              cmgv_tbl_type,
      x_cmgv_tbl        OUT NOCOPY      cmgv_tbl_type
) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1311


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

Line: 1325


        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_cmgv_rec                     => p_cmgv_tbl(i),
          x_cmgv_rec                     => x_cmgv_tbl(i));

Line: 1380


  END insert_row;

Line: 1398


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CONDITION_MSSGS
     WHERE ID = p_cmg_rec.id
       AND OBJECT_VERSION_NUMBER = p_cmg_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1405


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CONDITION_MSSGS
    WHERE ID = p_cmg_rec.id;

Line: 1446


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1455


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1661


  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_cmg_rec                      IN cmg_rec_type,
    x_cmg_rec                      OUT NOCOPY cmg_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1670


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

Line: 1784


      IF (x_cmg_rec.last_updated_by = OKL_API.G_MISS_NUM)
      THEN
        x_cmg_rec.last_updated_by := l_cmg_rec.last_updated_by;

Line: 1788


      IF (x_cmg_rec.last_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_cmg_rec.last_update_date := l_cmg_rec.last_update_date;

Line: 1792


      IF (x_cmg_rec.last_update_login = OKL_API.G_MISS_NUM)
      THEN
        x_cmg_rec.last_update_login := l_cmg_rec.last_update_login;

Line: 1836


    UPDATE  OKL_CONDITION_MSSGS
    SET IMS_ID = l_def_cmg_rec.ims_id,
        IVM_ID = l_def_cmg_rec.ivm_id,
        OBJECT_VERSION_NUMBER = l_def_cmg_rec.object_version_number,
        SEQUENCE_NUMBER = l_def_cmg_rec.sequence_number,
        ATTRIBUTE_CATEGORY = l_def_cmg_rec.attribute_category,
        ATTRIBUTE1 = l_def_cmg_rec.attribute1,
        ATTRIBUTE2 = l_def_cmg_rec.attribute2,
        ATTRIBUTE3 = l_def_cmg_rec.attribute3,
        ATTRIBUTE4 = l_def_cmg_rec.attribute4,
        ATTRIBUTE5 = l_def_cmg_rec.attribute5,
        ATTRIBUTE6 = l_def_cmg_rec.attribute6,
        ATTRIBUTE7 = l_def_cmg_rec.attribute7,
        ATTRIBUTE8 = l_def_cmg_rec.attribute8,
        ATTRIBUTE9 = l_def_cmg_rec.attribute9,
        ATTRIBUTE10 = l_def_cmg_rec.attribute10,
        ATTRIBUTE11 = l_def_cmg_rec.attribute11,
        ATTRIBUTE12 = l_def_cmg_rec.attribute12,
        ATTRIBUTE13 = l_def_cmg_rec.attribute13,
        ATTRIBUTE14 = l_def_cmg_rec.attribute14,
        ATTRIBUTE15 = l_def_cmg_rec.attribute15,
        CREATED_BY = l_def_cmg_rec.created_by,
        CREATION_DATE = l_def_cmg_rec.creation_date,
        LAST_UPDATED_BY = l_def_cmg_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cmg_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_cmg_rec.last_update_login
    WHERE ID = l_def_cmg_rec.id;

Line: 1897


  END update_row;

Line: 1901


  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_cmgv_rec        IN              cmgv_rec_type,
      x_cmgv_rec        OUT NOCOPY      cmgv_rec_type
) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1912


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

Line: 1926


      l_cmgv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1927


      l_cmgv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1928


      l_cmgv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2040


      IF (x_cmgv_rec.last_updated_by = OKL_API.G_MISS_NUM)
      THEN
        x_cmgv_rec.last_updated_by := l_cmgv_rec.last_updated_by;

Line: 2044


      IF (x_cmgv_rec.last_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_cmgv_rec.last_update_date := l_cmgv_rec.last_update_date;

Line: 2048


      IF (x_cmgv_rec.last_update_login = OKL_API.G_MISS_NUM)
      THEN
        x_cmgv_rec.last_update_login := l_cmgv_rec.last_update_login;

Line: 2119


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cmg_rec,
      lx_cmg_rec
    );

Line: 2166


  END update_row;

Line: 2170


  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_cmgv_tbl        IN              cmgv_tbl_type,
      x_cmgv_tbl        OUT NOCOPY      cmgv_tbl_type
) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2181


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

Line: 2195


        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_cmgv_rec                     => p_cmgv_tbl(i),
          x_cmgv_rec                     => x_cmgv_tbl(i));

Line: 2250


  END update_row;

Line: 2258


  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_cmg_rec                      IN cmg_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2266


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

Line: 2280


    DELETE FROM OKL_CONDITION_MSSGS
     WHERE ID = l_cmg_rec.id;

Line: 2315


  END delete_row;

Line: 2319


  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_cmgv_rec        IN              cmgv_rec_type
) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2329


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

Line: 2353


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cmg_rec
    );

Line: 2397


  END delete_row;

Line: 2401


  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_cmgv_tbl        IN              cmgv_tbl_type
) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2411


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

Line: 2425


        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_cmgv_rec                     => p_cmgv_tbl(i));

Line: 2479


  END delete_row;