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

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

Line: 107


    SELECT
            ID,
            REPORT_ID,
            TEMPLATE_SET_ID,
            TEMPLATE_SET_TYPE,
            START_DATE,
            END_DATE,
            REPORT_DURATION,
            REPORT_PERIOD,
            STS_CODE,
            PROCESS_CODE,
            APPLIES_TO,
            ATTACHMENT_NAME,
            MESSAGE_TEMPLATE_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            OBJECT_VERSION_NUMBER
      FROM Oks_Report_Templates_V
     WHERE oks_report_templates_v.id = p_id;

Line: 151


              l_rtmpv_rec.last_updated_by,
              l_rtmpv_rec.last_update_date,
              l_rtmpv_rec.last_update_login,
              l_rtmpv_rec.object_version_number;

Line: 196


    SELECT
            ID,
            REPORT_ID,
            TEMPLATE_SET_ID,
            TEMPLATE_SET_TYPE,
            START_DATE,
            END_DATE,
            REPORT_DURATION,
            REPORT_PERIOD,
            STS_CODE,
            PROCESS_CODE,
            APPLIES_TO,
            ATTACHMENT_NAME,
            MESSAGE_TEMPLATE_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            OBJECT_VERSION_NUMBER
      FROM Oks_Report_Templates
     WHERE oks_report_templates.id = p_id;

Line: 240


              l_rtmp_rec.last_updated_by,
              l_rtmp_rec.last_update_date,
              l_rtmp_rec.last_update_login,
              l_rtmp_rec.object_version_number;

Line: 330


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

Line: 333


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

Line: 336


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

Line: 506


SELECT start_date,
       NVL(end_date,sysdate+1)
  FROM oks_report_templates
 WHERE template_set_id = p_template_set_id
   AND template_set_type = p_document_type
   AND process_code = p_process_code
   AND applies_to = p_applies_to
   AND id  <> p_id;

Line: 522


SELECT start_date,
       NVL(end_date,sysdate+1)
  FROM oks_report_templates
 WHERE template_set_id = p_template_set_id
   AND template_set_type = p_document_type
   AND process_code = p_process_code
   AND applies_to = p_applies_to
   AND report_duration = p_report_duration
   AND report_period  = p_report_period
   AND id <> p_id;

Line: 539


SELECT start_date,
       NVL(end_date,sysdate+1)
  FROM oks_report_templates
 WHERE template_set_id = p_template_set_id
   AND template_set_type = p_document_type
   -- AND process_code = 'O' -- bug 5916645
   AND process_code IN ('O', 'M')
   AND applies_to IN (p_applies_to, DECODE(p_applies_to,'B','N',p_applies_to),DECODE(p_applies_to,'B','R',p_applies_to))
   AND NVL(report_duration,-999) = NVL(p_report_duration,-999)
   AND NVL(report_period,'X') = NVL(p_report_period,'X')
   AND id <> p_id;

Line: 557


SELECT start_date,
       NVL(end_date,sysdate+1)
  FROM oks_report_templates
 WHERE template_set_id = p_template_set_id
   AND template_set_type = p_document_type
   AND process_code = 'B'
   AND applies_to IN (p_applies_to, DECODE(p_applies_to,'B','N',p_applies_to),DECODE(p_applies_to,'B','R',p_applies_to))
   AND NVL(report_duration,-999) = NVL(p_report_duration,-999)
   AND NVL(report_period,'X') = NVL(p_report_period,'X')
   AND id <> p_id;

Line: 574


SELECT start_date,
       NVL(end_date,sysdate+1)
  FROM oks_report_templates
 WHERE template_set_id = p_template_set_id
   AND template_set_type = p_document_type
   AND applies_to IN ('N', 'R')
   AND process_code IN (p_process_code,'B')
   -- AND process_code <> 'M'
   AND NVL(report_duration,-999) = NVL(p_report_duration,-999)
   AND NVL(report_period,'X') = NVL(p_report_period,'X')
   AND id <> p_id;

Line: 592


SELECT start_date,
       NVL(end_date,sysdate+1)
  FROM oks_report_templates
 WHERE template_set_id = p_template_set_id
   AND template_set_type = p_document_type
   AND applies_to = 'B'
   AND process_code IN(p_process_code,'B')
   AND NVL(report_duration,-999) = NVL(p_report_duration,-999)
   AND NVL(report_period,'X') = NVL(p_report_period,'X')
   AND id <> p_id;

Line: 1038


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1039


    p_to.last_update_date := p_from.last_update_date;

Line: 1040


    p_to.last_update_login := p_from.last_update_login;

Line: 1063


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1064


    p_to.last_update_date := p_from.last_update_date;

Line: 1065


    p_to.last_update_login := p_from.last_update_login;

Line: 1312


  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_rtmp_rec                     IN rtmp_rec_type,
    x_rtmp_rec                     OUT NOCOPY rtmp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1321


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

Line: 1357


    INSERT INTO OKS_REPORT_TEMPLATES(
      id,
      report_id,
      template_set_id,
      template_set_type,
      start_date,
      end_date,
      report_duration,
      report_period,
      sts_code,
      PROCESS_CODE,
      APPLIES_TO,
      ATTACHMENT_NAME,
      MESSAGE_TEMPLATE_ID,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      object_version_number)
    VALUES (
      l_rtmp_rec.id,
      l_rtmp_rec.report_id,
      l_rtmp_rec.template_set_id,
      l_rtmp_rec.template_set_type,
      l_rtmp_rec.start_date,
      l_rtmp_rec.end_date,
      l_rtmp_rec.report_duration,
      l_rtmp_rec.report_period,
      l_rtmp_rec.sts_code,
      l_rtmp_rec.process_code,
      l_rtmp_rec.applies_to,
      l_rtmp_rec.attachment_name,
      l_rtmp_rec.message_template_id,
      l_rtmp_rec.created_by,
      l_rtmp_rec.creation_date,
      l_rtmp_rec.last_updated_by,
      l_rtmp_rec.last_update_date,
      l_rtmp_rec.last_update_login,
      l_rtmp_rec.object_version_number);

Line: 1432


  END insert_row;

Line: 1436


  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_rtmpv_rec                    IN rtmpv_rec_type,
    x_rtmpv_rec                    OUT NOCOPY rtmpv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1446


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

Line: 1462


      l_rtmpv_rec.LAST_UPDATE_DATE := l_rtmpv_rec.CREATION_DATE;

Line: 1463


      l_rtmpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1464


      l_rtmpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1528


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_rtmp_rec,
      lx_rtmp_rec
    );

Line: 1577


  END insert_row;

Line: 1581


  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_rtmpv_tbl                    IN rtmpv_tbl_type,
    x_rtmpv_tbl                    OUT NOCOPY rtmpv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1592


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

Line: 1606


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_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_rtmpv_rec                    => p_rtmpv_tbl(i),
            x_rtmpv_rec                    => x_rtmpv_tbl(i));

Line: 1674


  END insert_row;

Line: 1681


  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_rtmpv_tbl                    IN rtmpv_tbl_type,
    x_rtmpv_tbl                    OUT NOCOPY rtmpv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1691


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

Line: 1698


      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_rtmpv_tbl                    => p_rtmpv_tbl,
        x_rtmpv_tbl                    => x_rtmpv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1740


  END insert_row;

Line: 1758


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_REPORT_TEMPLATES
     WHERE ID = p_rtmp_rec.id
       AND OBJECT_VERSION_NUMBER = p_rtmp_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1765


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_REPORT_TEMPLATES
     WHERE ID = p_rtmp_rec.id;

Line: 1806


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1815


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2095


  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_rtmp_rec                     IN rtmp_rec_type,
    x_rtmp_rec                     OUT NOCOPY rtmp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2104


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

Line: 2184


        IF (x_rtmp_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_rtmp_rec.last_updated_by := l_rtmp_rec.last_updated_by;

Line: 2188


        IF (x_rtmp_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_rtmp_rec.last_update_date := l_rtmp_rec.last_update_date;

Line: 2192


        IF (x_rtmp_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_rtmp_rec.last_update_login := l_rtmp_rec.last_update_login;

Line: 2242


    UPDATE OKS_REPORT_TEMPLATES
    SET REPORT_ID = l_def_rtmp_rec.report_id,
        TEMPLATE_SET_ID = l_def_rtmp_rec.template_set_id,
        TEMPLATE_SET_TYPE = l_def_rtmp_rec.template_set_type,
        START_DATE = l_def_rtmp_rec.start_date,
        END_DATE = l_def_rtmp_rec.end_date,
        REPORT_DURATION = l_def_rtmp_rec.report_duration,
        REPORT_PERIOD = l_def_rtmp_rec.report_period,
        STS_CODE = l_def_rtmp_rec.sts_code,
        PROCESS_CODE = l_def_rtmp_rec.PROCESS_CODE,
        APPLIES_TO = l_def_rtmp_rec.APPLIES_TO,
        ATTACHMENT_NAME = l_def_rtmp_rec.ATTACHMENT_NAME,
        MESSAGE_TEMPLATE_ID = l_def_rtmp_rec.MESSAGE_TEMPLATE_ID,
        CREATED_BY = l_def_rtmp_rec.created_by,
        CREATION_DATE = l_def_rtmp_rec.creation_date,
        LAST_UPDATED_BY = l_def_rtmp_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_rtmp_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_rtmp_rec.last_update_login,
        OBJECT_VERSION_NUMBER = l_def_rtmp_rec.object_version_number
    WHERE ID = l_def_rtmp_rec.id;

Line: 2297


  END update_row;

Line: 2301


  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_rtmpv_rec                    IN rtmpv_rec_type,
    x_rtmpv_rec                    OUT NOCOPY rtmpv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2311


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

Line: 2326


      l_rtmpv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2327


      l_rtmpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2328


      l_rtmpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2407


        IF (x_rtmpv_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_rtmpv_rec.last_updated_by := l_db_rtmpv_rec.last_updated_by;

Line: 2411


        IF (x_rtmpv_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_rtmpv_rec.last_update_date := l_db_rtmpv_rec.last_update_date;

Line: 2415


        IF (x_rtmpv_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_rtmpv_rec.last_update_login := l_db_rtmpv_rec.last_update_login;

Line: 2500


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_rtmp_rec,
      lx_rtmp_rec
    );

Line: 2548


  END update_row;

Line: 2552


  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_rtmpv_tbl                    IN rtmpv_tbl_type,
    x_rtmpv_tbl                    OUT NOCOPY rtmpv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2563


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

Line: 2577


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_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_rtmpv_rec                    => p_rtmpv_tbl(i),
            x_rtmpv_rec                    => x_rtmpv_tbl(i));

Line: 2645


  END update_row;

Line: 2652


  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_rtmpv_tbl                    IN rtmpv_tbl_type,
    x_rtmpv_tbl                    OUT NOCOPY rtmpv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2662


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

Line: 2669


      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_rtmpv_tbl                    => p_rtmpv_tbl,
        x_rtmpv_tbl                    => x_rtmpv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2711


  END update_row;

Line: 2719


  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_rtmp_rec                     IN rtmp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2727


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

Line: 2742


    DELETE FROM OKS_REPORT_TEMPLATES
     WHERE ID = p_rtmp_rec.id;

Line: 2778


  END delete_row;

Line: 2782


  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_rtmpv_rec                    IN rtmpv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2791


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

Line: 2815


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

Line: 2860


  END delete_row;

Line: 2864


  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_rtmpv_tbl                    IN rtmpv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2874


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

Line: 2888


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_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_rtmpv_rec                    => p_rtmpv_tbl(i));

Line: 2955


  END delete_row;

Line: 2960


  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_rtmpv_tbl                    IN rtmpv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2969


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

Line: 2976


      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_rtmpv_tbl                    => p_rtmpv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3017


  END delete_row;