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.OKC_SPN_PVT SQL Statements

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

Line: 45


    SELECT
            ID,
            TVE_ID,
            uom_code,
            SPN_ID,
            DURATION,
            ACTIVE_YN,
            NAME,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15
      FROM Okc_Span
     WHERE okc_span.id          = p_id;

Line: 94


              l_spn_rec.LAST_UPDATED_BY,
              l_spn_rec.LAST_UPDATE_DATE,
              l_spn_rec.LAST_UPDATE_LOGIN,
              l_spn_rec.ATTRIBUTE_CATEGORY,
              l_spn_rec.ATTRIBUTE1,
              l_spn_rec.ATTRIBUTE2,
              l_spn_rec.ATTRIBUTE3,
              l_spn_rec.ATTRIBUTE4,
              l_spn_rec.ATTRIBUTE5,
              l_spn_rec.ATTRIBUTE6,
              l_spn_rec.ATTRIBUTE7,
              l_spn_rec.ATTRIBUTE8,
              l_spn_rec.ATTRIBUTE9,
              l_spn_rec.ATTRIBUTE10,
              l_spn_rec.ATTRIBUTE11,
              l_spn_rec.ATTRIBUTE12,
              l_spn_rec.ATTRIBUTE13,
              l_spn_rec.ATTRIBUTE14,
              l_spn_rec.ATTRIBUTE15;

Line: 133


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            TVE_ID,
            uom_code,
            SPN_ID,
            NAME,
            DURATION,
            ACTIVE_YN,
            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 Okc_Span_V
     WHERE okc_span_v.id        = p_id;

Line: 198


              l_spnv_rec.LAST_UPDATED_BY,
              l_spnv_rec.LAST_UPDATE_DATE,
              l_spnv_rec.LAST_UPDATE_LOGIN;

Line: 297


    IF (l_spnv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_spnv_rec.last_updated_by := NULL;

Line: 300


    IF (l_spnv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_spnv_rec.last_update_date := NULL;

Line: 303


    IF (l_spnv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_spnv_rec.last_update_login := NULL;

Line: 326


      SELECT  '1'
        FROM OKC_Timeunit_v
       WHERE uom_code        = p_uom_code
         and nvl(inactive_date,trunc(sysdate)) >= trunc(sysdate);

Line: 370


      SELECT  '1'
        FROM Okc_Span
       WHERE id        = p_id;

Line: 375


	    SELECT id FROM OKC_SPAN_V
	    WHERE  spn_id = p_spn_id;

Line: 433


      SELECT  '1'
        FROM Okc_Timevalues
       WHERE id  = p_id
        and tve_type = 'CYL';

Line: 680


    p_to.last_updated_by := p_from.last_updated_by;

Line: 681


    p_to.last_update_date := p_from.last_update_date;

Line: 682


    p_to.last_update_login := p_from.last_update_login;

Line: 715


    p_to.last_updated_by := p_from.last_updated_by;

Line: 716


    p_to.last_update_date := p_from.last_update_date;

Line: 717


    p_to.last_update_login := p_from.last_update_login;

Line: 886


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_spn_rec                      IN spn_rec_type,
    x_spn_rec                      OUT NOCOPY spn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 895


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

Line: 931


    INSERT INTO OKC_SPAN(
        id,
        tve_id,
        uom_code,
        spn_id,
        duration,
        active_yn,
        name,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15)
      VALUES (
        l_spn_rec.id,
        l_spn_rec.tve_id,
        l_spn_rec.uom_code,
        l_spn_rec.spn_id,
        l_spn_rec.duration,
        l_spn_rec.active_yn,
        l_spn_rec.name,
        l_spn_rec.object_version_number,
        l_spn_rec.created_by,
        l_spn_rec.creation_date,
        l_spn_rec.last_updated_by,
        l_spn_rec.last_update_date,
        l_spn_rec.last_update_login,
        l_spn_rec.attribute_category,
        l_spn_rec.attribute1,
        l_spn_rec.attribute2,
        l_spn_rec.attribute3,
        l_spn_rec.attribute4,
        l_spn_rec.attribute5,
        l_spn_rec.attribute6,
        l_spn_rec.attribute7,
        l_spn_rec.attribute8,
        l_spn_rec.attribute9,
        l_spn_rec.attribute10,
        l_spn_rec.attribute11,
        l_spn_rec.attribute12,
        l_spn_rec.attribute13,
        l_spn_rec.attribute14,
        l_spn_rec.attribute15);

Line: 1025


  END insert_row;

Line: 1029


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_spnv_rec                     IN spnv_rec_type,
    x_spnv_rec                     OUT NOCOPY spnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1039


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

Line: 1055


      l_spnv_rec.LAST_UPDATE_DATE := l_spnv_rec.CREATION_DATE;

Line: 1056


      l_spnv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1057


      l_spnv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1124


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_spn_rec,
      lx_spn_rec
    );

Line: 1172


  END insert_row;

Line: 1176


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_spnv_tbl                     IN spnv_tbl_type,
    x_spnv_tbl                     OUT NOCOPY spnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1186


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

Line: 1195


        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_spnv_rec                     => p_spnv_tbl(i),
          x_spnv_rec                     => x_spnv_tbl(i));

Line: 1238


  END insert_row;

Line: 1256


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_SPAN
     WHERE ID = p_spn_rec.id
       AND OBJECT_VERSION_NUMBER = p_spn_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1263


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_SPAN
    WHERE ID = p_spn_rec.id;

Line: 1304


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1313


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1500


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_spn_rec                      IN spn_rec_type,
    x_spn_rec                      OUT NOCOPY spn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1509


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

Line: 1571


      IF (x_spn_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_spn_rec.last_updated_by := l_spn_rec.last_updated_by;

Line: 1575


      IF (x_spn_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_spn_rec.last_update_date := l_spn_rec.last_update_date;

Line: 1579


      IF (x_spn_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_spn_rec.last_update_login := l_spn_rec.last_update_login;

Line: 1687


    UPDATE  OKC_SPAN
    SET TVE_ID = l_def_spn_rec.tve_id,
        uom_code = l_def_spn_rec.uom_code,
        SPN_ID = l_def_spn_rec.spn_id,
        DURATION = l_def_spn_rec.duration,
        ACTIVE_YN = l_def_spn_rec.active_yn,
        NAME = l_def_spn_rec.name,
        OBJECT_VERSION_NUMBER = l_def_spn_rec.object_version_number,
        CREATED_BY = l_def_spn_rec.created_by,
        CREATION_DATE = l_def_spn_rec.creation_date,
        LAST_UPDATED_BY = l_def_spn_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_spn_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_spn_rec.last_update_login,
        ATTRIBUTE_CATEGORY = l_def_spn_rec.attribute_category,
        ATTRIBUTE1 = l_def_spn_rec.attribute1,
        ATTRIBUTE2 = l_def_spn_rec.attribute2,
        ATTRIBUTE3 = l_def_spn_rec.attribute3,
        ATTRIBUTE4 = l_def_spn_rec.attribute4,
        ATTRIBUTE5 = l_def_spn_rec.attribute5,
        ATTRIBUTE6 = l_def_spn_rec.attribute6,
        ATTRIBUTE7 = l_def_spn_rec.attribute7,
        ATTRIBUTE8 = l_def_spn_rec.attribute8,
        ATTRIBUTE9 = l_def_spn_rec.attribute9,
        ATTRIBUTE10 = l_def_spn_rec.attribute10,
        ATTRIBUTE11 = l_def_spn_rec.attribute11,
        ATTRIBUTE12 = l_def_spn_rec.attribute12,
        ATTRIBUTE13 = l_def_spn_rec.attribute13,
        ATTRIBUTE14 = l_def_spn_rec.attribute14,
        ATTRIBUTE15 = l_def_spn_rec.attribute15
    WHERE ID = l_def_spn_rec.id;

Line: 1751


  END update_row;

Line: 1755


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_spnv_rec                     IN spnv_rec_type,
    x_spnv_rec                     OUT NOCOPY spnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1765


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

Line: 1779


      l_spnv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1780


      l_spnv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1781


      l_spnv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1905


      IF (x_spnv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_spnv_rec.last_updated_by := l_spnv_rec.last_updated_by;

Line: 1909


      IF (x_spnv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_spnv_rec.last_update_date := l_spnv_rec.last_update_date;

Line: 1913


      IF (x_spnv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_spnv_rec.last_update_login := l_spnv_rec.last_update_login;

Line: 1987


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_spn_rec,
      lx_spn_rec
    );

Line: 2034


  END update_row;

Line: 2038


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_spnv_tbl                     IN spnv_tbl_type,
    x_spnv_tbl                     OUT NOCOPY spnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2048


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

Line: 2057


        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_spnv_rec                     => p_spnv_tbl(i),
          x_spnv_rec                     => x_spnv_tbl(i));

Line: 2100


  END update_row;

Line: 2108


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_spn_rec                      IN spn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2116


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

Line: 2130


    DELETE FROM OKC_SPAN
     WHERE ID = l_spn_rec.id;

Line: 2165


  END delete_row;

Line: 2169


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_spnv_rec                     IN spnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2178


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

Line: 2202


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

Line: 2246


  END delete_row;

Line: 2250


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_spnv_tbl                     IN spnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2259


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

Line: 2268


        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_spnv_rec                     => p_spnv_tbl(i));

Line: 2310


  END delete_row;