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_SGT_PVT SQL Statements

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

Line: 104


    SELECT
            ID,
            JTOT_OBJECT1_CODE,
            OBJECT1_ID1,
            OBJECT1_ID2,
            SGN_CODE,
            VALUE,
            OBJECT_VERSION_NUMBER,
            DEFAULT_VALUE,
            ACTIVE_YN,
            START_DATE,
            END_DATE,
            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_Sgn_Translations_V
     WHERE okl_sgn_translations_v.id = p_id;

Line: 173


              l_sgnv_rec.last_updated_by,
              l_sgnv_rec.last_update_date,
              l_sgnv_rec.last_update_login;

Line: 217


    SELECT
            ID,
            JTOT_OBJECT1_CODE,
            OBJECT1_ID1,
            OBJECT1_ID2,
            SGN_CODE,
            VALUE,
            OBJECT_VERSION_NUMBER,
            DEFAULT_VALUE,
            ACTIVE_YN,
            START_DATE,
            END_DATE,
            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_Sgn_Translations
     WHERE okl_sgn_translations.id = p_id;

Line: 286


              l_sgt_rec.last_updated_by,
              l_sgt_rec.last_update_date,
              l_sgt_rec.last_update_login;

Line: 414


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

Line: 417


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

Line: 420


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

Line: 464


    SELECT '1'
    FROM jtf_objects_b
    WHERE object_code = p_jtot_obj_code;

Line: 508


    SELECT select_id
    FROM jtf_objects_b
    WHERE object_code = p_jtot_obj_code;

Line: 513


    SELECT stream_type_class
    FROM okl_strm_type_b
    WHERE id = p_stream_type_id;

Line: 518


	l_select_id VARCHAR2(200);

Line: 567


    FETCH jtot_object_csr INTO l_select_id;

Line: 575


	  IF (is_number(l_select_id)) THEN
  	    DBMS_SQL.PARSE(l_cursor, 'select '|| l_select_id ||' from '|| p_jtot_object1_code || ' where ' || l_select_id || ' = ' || to_number(p_object1_id1), DBMS_SQL.V7);

Line: 578


 	    DBMS_SQL.PARSE(l_cursor, 'select '|| l_select_id ||' from '|| p_jtot_object1_code || ' where ' || l_select_id || ' = ''' || p_object1_id1 || '''', DBMS_SQL.V7);

Line: 842


      SELECT 'x'
        FROM Fnd_Lookup_Values
       WHERE fnd_lookup_values.lookup_type = p_lookup_type;

Line: 924


    p_to.last_updated_by := p_from.last_updated_by;

Line: 925


    p_to.last_update_date := p_from.last_update_date;

Line: 926


    p_to.last_update_login := p_from.last_update_login;

Line: 961


    p_to.last_updated_by := p_from.last_updated_by;

Line: 962


    p_to.last_update_date := p_from.last_update_date;

Line: 963


    p_to.last_update_login := p_from.last_update_login;

Line: 1209


  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_sgt_rec                      IN sgt_rec_type,
    x_sgt_rec                      OUT NOCOPY sgt_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1218


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

Line: 1254


    INSERT INTO OKL_SGN_TRANSLATIONS(
      id,
      jtot_object1_code,
      object1_id1,
      object1_id2,
      sgn_code,
      value,
      object_version_number,
      default_value,
      active_yn,
      start_date,
      end_date,
      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_sgt_rec.id,
      l_sgt_rec.jtot_object1_code,
      l_sgt_rec.object1_id1,
      l_sgt_rec.object1_id2,
      l_sgt_rec.sgn_code,
      l_sgt_rec.value,
      l_sgt_rec.object_version_number,
      l_sgt_rec.default_value,
      l_sgt_rec.active_yn,
      l_sgt_rec.start_date,
      l_sgt_rec.end_date,
      l_sgt_rec.attribute1,
      l_sgt_rec.attribute2,
      l_sgt_rec.attribute3,
      l_sgt_rec.attribute4,
      l_sgt_rec.attribute5,
      l_sgt_rec.attribute6,
      l_sgt_rec.attribute7,
      l_sgt_rec.attribute8,
      l_sgt_rec.attribute9,
      l_sgt_rec.attribute10,
      l_sgt_rec.attribute11,
      l_sgt_rec.attribute12,
      l_sgt_rec.attribute13,
      l_sgt_rec.attribute14,
      l_sgt_rec.attribute15,
      l_sgt_rec.created_by,
      l_sgt_rec.creation_date,
      l_sgt_rec.last_updated_by,
      l_sgt_rec.last_update_date,
      l_sgt_rec.last_update_login);

Line: 1353


  END insert_row;

Line: 1357


  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_sgnv_rec                     IN sgnv_rec_type,
    x_sgnv_rec                     OUT NOCOPY sgnv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1367


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

Line: 1377


    SELECT '1'
    FROM okl_sgn_translations_v
    WHERE jtot_object1_code = p_jtot_object1_code
	      AND sgn_code = p_sgn_code
		  AND object1_id1 = p_object1_id1;

Line: 1387


    SELECT '1'
    FROM okl_sgn_translations_v
    WHERE jtot_object1_code = p_jtot_object1_code
	      AND sgn_code = p_sgn_code
		  AND object1_id1 = p_object1_id1
		  AND value = p_value;

Line: 1397


    SELECT '1'
    FROM okl_sgn_translations_v
    WHERE jtot_object1_code = p_jtot_object1_code
	      AND sgn_code = p_sgn_code
		  AND object1_id1 = p_object1_id1;

Line: 1421


      l_sgnv_rec.LAST_UPDATE_DATE := l_sgnv_rec.CREATION_DATE;

Line: 1422


      l_sgnv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1423


      l_sgnv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1488


        l_sql_stmnt := 'SELECT NAME FROM ' || l_uv_name || ' WHERE jtot_object1_code = '''||p_sgnv_rec.jtot_object1_code||''' AND sgn_code = '''||p_sgnv_rec.sgn_code||''' AND object1_id1 = '''||p_sgnv_rec.object1_id1||'''';

Line: 1542


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_sgt_rec,
      lx_sgt_rec
    );

Line: 1592


  END insert_row;

Line: 1596


  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_sgnv_tbl                     IN sgnv_tbl_type,
    x_sgnv_tbl                     OUT NOCOPY sgnv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1607


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

Line: 1621


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_sgnv_rec                     => p_sgnv_tbl(i),
            x_sgnv_rec                     => x_sgnv_tbl(i));

Line: 1689


  END insert_row;

Line: 1694


  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_sgnv_tbl                     IN sgnv_tbl_type,
    x_sgnv_tbl                     OUT NOCOPY sgnv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1704


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

Line: 1713


      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_sgnv_tbl                     => p_sgnv_tbl,
        x_sgnv_tbl                     => x_sgnv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1755


  END insert_row;

Line: 1773


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SGN_TRANSLATIONS
     WHERE ID = p_sgt_rec.id
       AND OBJECT_VERSION_NUMBER = p_sgt_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1780


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SGN_TRANSLATIONS
     WHERE ID = p_sgt_rec.id;

Line: 1821


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1830


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2110


  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_sgt_rec                      IN sgt_rec_type,
    x_sgt_rec                      OUT NOCOPY sgt_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2119


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

Line: 2251


        IF (x_sgt_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_sgt_rec.last_updated_by := l_sgt_rec.last_updated_by;

Line: 2255


        IF (x_sgt_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_sgt_rec.last_update_date := l_sgt_rec.last_update_date;

Line: 2259


        IF (x_sgt_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_sgt_rec.last_update_login := l_sgt_rec.last_update_login;

Line: 2306


    UPDATE OKL_SGN_TRANSLATIONS
    SET JTOT_OBJECT1_CODE = l_def_sgt_rec.jtot_object1_code,
        OBJECT1_ID1 = l_def_sgt_rec.object1_id1,
        OBJECT1_ID2 = l_def_sgt_rec.object1_id2,
        SGN_CODE = l_def_sgt_rec.sgn_code,
        VALUE = l_def_sgt_rec.value,
        OBJECT_VERSION_NUMBER = l_def_sgt_rec.object_version_number,
        DEFAULT_VALUE = l_def_sgt_rec.default_value,
        ACTIVE_YN = l_def_sgt_rec.active_yn,
        START_DATE = l_def_sgt_rec.start_date,
        END_DATE = l_def_sgt_rec.end_date,
        ATTRIBUTE1 = l_def_sgt_rec.attribute1,
        ATTRIBUTE2 = l_def_sgt_rec.attribute2,
        ATTRIBUTE3 = l_def_sgt_rec.attribute3,
        ATTRIBUTE4 = l_def_sgt_rec.attribute4,
        ATTRIBUTE5 = l_def_sgt_rec.attribute5,
        ATTRIBUTE6 = l_def_sgt_rec.attribute6,
        ATTRIBUTE7 = l_def_sgt_rec.attribute7,
        ATTRIBUTE8 = l_def_sgt_rec.attribute8,
        ATTRIBUTE9 = l_def_sgt_rec.attribute9,
        ATTRIBUTE10 = l_def_sgt_rec.attribute10,
        ATTRIBUTE11 = l_def_sgt_rec.attribute11,
        ATTRIBUTE12 = l_def_sgt_rec.attribute12,
        ATTRIBUTE13 = l_def_sgt_rec.attribute13,
        ATTRIBUTE14 = l_def_sgt_rec.attribute14,
        ATTRIBUTE15 = l_def_sgt_rec.attribute15,
        CREATED_BY = l_def_sgt_rec.created_by,
        CREATION_DATE = l_def_sgt_rec.creation_date,
        LAST_UPDATED_BY = l_def_sgt_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_sgt_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_sgt_rec.last_update_login
    WHERE ID = l_def_sgt_rec.id;

Line: 2376


  END update_row;

Line: 2380


  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_sgnv_rec                     IN sgnv_rec_type,
    x_sgnv_rec                     OUT NOCOPY sgnv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2390


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

Line: 2407


      l_sgnv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2408


      l_sgnv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2409


      l_sgnv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2536


        IF (x_sgnv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_sgnv_rec.last_updated_by := l_db_sgnv_rec.last_updated_by;

Line: 2540


        IF (x_sgnv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_sgnv_rec.last_update_date := l_db_sgnv_rec.last_update_date;

Line: 2544


        IF (x_sgnv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_sgnv_rec.last_update_login := l_db_sgnv_rec.last_update_login;

Line: 2636


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_sgt_rec,
      lx_sgt_rec
    );

Line: 2685


  END update_row;

Line: 2689


  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_sgnv_tbl                     IN sgnv_tbl_type,
    x_sgnv_tbl                     OUT NOCOPY sgnv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2700


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

Line: 2714


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_sgnv_rec                     => p_sgnv_tbl(i),
            x_sgnv_rec                     => x_sgnv_tbl(i));

Line: 2782


  END update_row;

Line: 2787


  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_sgnv_tbl                     IN sgnv_tbl_type,
    x_sgnv_tbl                     OUT NOCOPY sgnv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2797


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

Line: 2804


      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_sgnv_tbl                     => p_sgnv_tbl,
        x_sgnv_tbl                     => x_sgnv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2846


  END update_row;

Line: 2854


  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_sgt_rec                      IN sgt_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2862


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

Line: 2877


    DELETE FROM OKL_SGN_TRANSLATIONS
     WHERE ID = p_sgt_rec.id;

Line: 2913


  END delete_row;

Line: 2917


  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_sgnv_rec                     IN sgnv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2926


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

Line: 2950


    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_sgt_rec
    );

Line: 2995


  END delete_row;

Line: 2999


  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_sgnv_tbl                     IN sgnv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3009


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

Line: 3023


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_sgnv_rec                     => p_sgnv_tbl(i));

Line: 3090


  END delete_row;

Line: 3095


  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_sgnv_tbl                     IN sgnv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3104


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

Line: 3111


      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_sgnv_tbl                     => p_sgnv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3152


  END delete_row;