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

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

Line: 101


    SELECT
            ID,
            DNZ_CHR_ID,
            COV_TZE_LINE_ID,
            START_HOUR,
            START_MINUTE,
            END_HOUR,
            END_MINUTE,
            MONDAY_YN,
            TUESDAY_YN,
            WEDNESDAY_YN,
            THURSDAY_YN,
            FRIDAY_YN,
            SATURDAY_YN,
            SUNDAY_YN,
            SECURITY_GROUP_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            REQUEST_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            OBJECT_VERSION_NUMBER
      FROM Oks_Coverage_Times_V
     WHERE oks_coverage_times_v.id = p_id;

Line: 153


              l_oks_coverage_times_v_rec.program_update_date,
              l_oks_coverage_times_v_rec.request_id,
              l_oks_coverage_times_v_rec.created_by,
              l_oks_coverage_times_v_rec.creation_date,
              l_oks_coverage_times_v_rec.last_updated_by,
              l_oks_coverage_times_v_rec.last_update_date,
              l_oks_coverage_times_v_rec.last_update_login,
              l_oks_coverage_times_v_rec.object_version_number;

Line: 202


    SELECT
            ID,
            DNZ_CHR_ID,
            COV_TZE_LINE_ID,
            START_HOUR,
            START_MINUTE,
            END_HOUR,
            END_MINUTE,
            MONDAY_YN,
            TUESDAY_YN,
            WEDNESDAY_YN,
            THURSDAY_YN,
            FRIDAY_YN,
            SATURDAY_YN,
            SUNDAY_YN,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            REQUEST_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            OBJECT_VERSION_NUMBER
      FROM Oks_Coverage_Times
     WHERE oks_coverage_times.id = p_id;

Line: 252


              l_oks_coverage_times_rec.program_update_date,
              l_oks_coverage_times_rec.request_id,
              l_oks_coverage_times_rec.created_by,
              l_oks_coverage_times_rec.creation_date,
              l_oks_coverage_times_rec.last_updated_by,
              l_oks_coverage_times_rec.last_update_date,
              l_oks_coverage_times_rec.last_update_login,
              l_oks_coverage_times_rec.object_version_number;

Line: 352


    IF (l_oks_coverage_times_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
      l_oks_coverage_times_v_rec.program_update_date := NULL;

Line: 364


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

Line: 367


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

Line: 370


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

Line: 528


    p_to.program_update_date := p_from.program_update_date;

Line: 532


    p_to.last_updated_by := p_from.last_updated_by;

Line: 533


    p_to.last_update_date := p_from.last_update_date;

Line: 534


    p_to.last_update_login := p_from.last_update_login;

Line: 558


    p_to.program_update_date := p_from.program_update_date;

Line: 562


    p_to.last_updated_by := p_from.last_updated_by;

Line: 563


    p_to.last_update_date := p_from.last_update_date;

Line: 564


    p_to.last_update_login := p_from.last_update_login;

Line: 811


  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_oks_coverage_times_rec       IN oks_coverage_times_rec_type,
    x_oks_coverage_times_rec       OUT NOCOPY oks_coverage_times_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 820


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

Line: 856


    INSERT INTO OKS_COVERAGE_TIMES(
      id,
      dnz_chr_id,
      cov_tze_line_id,
      start_hour,
      start_minute,
      end_hour,
      end_minute,
      monday_yn,
      tuesday_yn,
      wednesday_yn,
      thursday_yn,
      friday_yn,
      saturday_yn,
      sunday_yn,
      program_application_id,
      program_id,
      program_update_date,
      request_id,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      object_version_number)
    VALUES (
      l_oks_coverage_times_rec.id,
      l_oks_coverage_times_rec.dnz_chr_id,
      l_oks_coverage_times_rec.cov_tze_line_id,
      l_oks_coverage_times_rec.start_hour,
      l_oks_coverage_times_rec.start_minute,
      l_oks_coverage_times_rec.end_hour,
      l_oks_coverage_times_rec.end_minute,
      l_oks_coverage_times_rec.monday_yn,
      l_oks_coverage_times_rec.tuesday_yn,
      l_oks_coverage_times_rec.wednesday_yn,
      l_oks_coverage_times_rec.thursday_yn,
      l_oks_coverage_times_rec.friday_yn,
      l_oks_coverage_times_rec.saturday_yn,
      l_oks_coverage_times_rec.sunday_yn,
      l_oks_coverage_times_rec.program_application_id,
      l_oks_coverage_times_rec.program_id,
      l_oks_coverage_times_rec.program_update_date,
      l_oks_coverage_times_rec.request_id,
      l_oks_coverage_times_rec.created_by,
      l_oks_coverage_times_rec.creation_date,
      l_oks_coverage_times_rec.last_updated_by,
      l_oks_coverage_times_rec.last_update_date,
      l_oks_coverage_times_rec.last_update_login,
      l_oks_coverage_times_rec.object_version_number);

Line: 941


  END insert_row;

Line: 945


  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_oks_coverage_times_v_rec     IN oks_coverage_times_v_rec_type,
    x_oks_coverage_times_v_rec     OUT NOCOPY oks_coverage_times_v_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 955


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

Line: 971


      l_oks_coverage_times_v_rec.LAST_UPDATE_DATE := l_oks_coverage_times_v_rec.CREATION_DATE;

Line: 972


      l_oks_coverage_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 973


      l_oks_coverage_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1037


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_oks_coverage_times_rec,
      lx_oks_coverage_times_rec
    );

Line: 1086


  END insert_row;

Line: 1090


  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_oks_coverage_times_v_tbl     IN oks_coverage_times_v_tbl_type,
    x_oks_coverage_times_v_tbl     OUT NOCOPY oks_coverage_times_v_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1101


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

Line: 1115


          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_oks_coverage_times_v_rec     => p_oks_coverage_times_v_tbl(i),
            x_oks_coverage_times_v_rec     => x_oks_coverage_times_v_tbl(i));

Line: 1183


  END insert_row;

Line: 1190


  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_oks_coverage_times_v_tbl     IN oks_coverage_times_v_tbl_type,
    x_oks_coverage_times_v_tbl     OUT NOCOPY oks_coverage_times_v_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1200


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

Line: 1207


      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_oks_coverage_times_v_tbl     => p_oks_coverage_times_v_tbl,
        x_oks_coverage_times_v_tbl     => x_oks_coverage_times_v_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1249


  END insert_row;

Line: 1267


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_COVERAGE_TIMES
     WHERE ID = p_oks_coverage_times_rec.id
       AND OBJECT_VERSION_NUMBER = p_oks_coverage_times_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1274


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_COVERAGE_TIMES
     WHERE ID = p_oks_coverage_times_rec.id;

Line: 1315


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1324


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1604


  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_oks_coverage_times_rec       IN oks_coverage_times_rec_type,
    x_oks_coverage_times_rec       OUT NOCOPY oks_coverage_times_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1613


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

Line: 1697


        IF (x_oks_coverage_times_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_coverage_times_rec.program_update_date := l_oks_coverage_times_rec.program_update_date;

Line: 1713


        IF (x_oks_coverage_times_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_oks_coverage_times_rec.last_updated_by := l_oks_coverage_times_rec.last_updated_by;

Line: 1717


        IF (x_oks_coverage_times_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_coverage_times_rec.last_update_date := l_oks_coverage_times_rec.last_update_date;

Line: 1721


        IF (x_oks_coverage_times_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_oks_coverage_times_rec.last_update_login := l_oks_coverage_times_rec.last_update_login;

Line: 1771


    UPDATE OKS_COVERAGE_TIMES
    SET DNZ_CHR_ID = l_def_oks_coverage_times_rec.dnz_chr_id,
        COV_TZE_LINE_ID = l_def_oks_coverage_times_rec.cov_tze_line_id,
        START_HOUR = l_def_oks_coverage_times_rec.start_hour,
        START_MINUTE = l_def_oks_coverage_times_rec.start_minute,
        END_HOUR = l_def_oks_coverage_times_rec.end_hour,
        END_MINUTE = l_def_oks_coverage_times_rec.end_minute,
        MONDAY_YN = l_def_oks_coverage_times_rec.monday_yn,
        TUESDAY_YN = l_def_oks_coverage_times_rec.tuesday_yn,
        WEDNESDAY_YN = l_def_oks_coverage_times_rec.wednesday_yn,
        THURSDAY_YN = l_def_oks_coverage_times_rec.thursday_yn,
        FRIDAY_YN = l_def_oks_coverage_times_rec.friday_yn,
        SATURDAY_YN = l_def_oks_coverage_times_rec.saturday_yn,
        SUNDAY_YN = l_def_oks_coverage_times_rec.sunday_yn,
        PROGRAM_APPLICATION_ID = l_def_oks_coverage_times_rec.program_application_id,
        PROGRAM_ID = l_def_oks_coverage_times_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_oks_coverage_times_rec.program_update_date,
        REQUEST_ID = l_def_oks_coverage_times_rec.request_id,
        CREATED_BY = l_def_oks_coverage_times_rec.created_by,
        CREATION_DATE = l_def_oks_coverage_times_rec.creation_date,
        LAST_UPDATED_BY = l_def_oks_coverage_times_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_oks_coverage_times_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_oks_coverage_times_rec.last_update_login,
        OBJECT_VERSION_NUMBER = l_def_oks_coverage_times_rec.object_version_number
    WHERE ID = l_def_oks_coverage_times_rec.id;

Line: 1831


  END update_row;

Line: 1835


  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_oks_coverage_times_v_rec     IN oks_coverage_times_v_rec_type,
    x_oks_coverage_times_v_rec     OUT NOCOPY oks_coverage_times_v_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1845


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

Line: 1860


      l_oks_coverage_times_v_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1861


      l_oks_coverage_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1862


      l_oks_coverage_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1949


        IF (x_oks_coverage_times_v_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_coverage_times_v_rec.program_update_date := l_db_oks_coverage_times_v_rec.program_update_date;

Line: 1965


        IF (x_oks_coverage_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_oks_coverage_times_v_rec.last_updated_by := l_db_oks_coverage_times_v_rec.last_updated_by;

Line: 1969


        IF (x_oks_coverage_times_v_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_coverage_times_v_rec.last_update_date := l_db_oks_coverage_times_v_rec.last_update_date;

Line: 1973


        IF (x_oks_coverage_times_v_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_oks_coverage_times_v_rec.last_update_login := l_db_oks_coverage_times_v_rec.last_update_login;

Line: 2058


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_oks_coverage_times_rec,
      lx_oks_coverage_times_rec
    );

Line: 2106


  END update_row;

Line: 2110


  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_oks_coverage_times_v_tbl     IN oks_coverage_times_v_tbl_type,
    x_oks_coverage_times_v_tbl     OUT NOCOPY oks_coverage_times_v_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2121


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

Line: 2135


          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_oks_coverage_times_v_rec     => p_oks_coverage_times_v_tbl(i),
            x_oks_coverage_times_v_rec     => x_oks_coverage_times_v_tbl(i));

Line: 2203


  END update_row;

Line: 2210


  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_oks_coverage_times_v_tbl     IN oks_coverage_times_v_tbl_type,
    x_oks_coverage_times_v_tbl     OUT NOCOPY oks_coverage_times_v_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2220


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

Line: 2227


      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_oks_coverage_times_v_tbl     => p_oks_coverage_times_v_tbl,
        x_oks_coverage_times_v_tbl     => x_oks_coverage_times_v_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2269


  END update_row;

Line: 2277


  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_oks_coverage_times_rec       IN oks_coverage_times_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2285


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

Line: 2300


    DELETE FROM OKS_COVERAGE_TIMES
     WHERE ID = p_oks_coverage_times_rec.id;

Line: 2336


  END delete_row;

Line: 2340


  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_oks_coverage_times_v_rec     IN oks_coverage_times_v_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2349


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

Line: 2373


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

Line: 2418


  END delete_row;

Line: 2422


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2432


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

Line: 2446


          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_oks_coverage_times_v_rec     => p_oks_coverage_times_v_tbl(i));

Line: 2513


  END delete_row;

Line: 2518


  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_oks_coverage_times_v_tbl     IN oks_coverage_times_v_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2527


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

Line: 2534


      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_oks_coverage_times_v_tbl     => p_oks_coverage_times_v_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2575


  END delete_row;

Line: 2590


INSERT INTO OKS_COVERAGE_TIMES_H(
						ID,
						DNZ_CHR_ID,
						COV_TZE_LINE_ID,
						START_HOUR,
						START_MINUTE,
						END_HOUR,
						END_MINUTE,
						MONDAY_YN,
						TUESDAY_YN,
						WEDNESDAY_YN,
						THURSDAY_YN,
						FRIDAY_YN,
						SATURDAY_YN,
						SUNDAY_YN,
						SECURITY_GROUP_ID,
						PROGRAM_APPLICATION_ID,
						PROGRAM_ID,
						PROGRAM_UPDATE_DATE,
						REQUEST_ID,
						CREATED_BY,
						CREATION_DATE,
						LAST_UPDATED_BY,
						LAST_UPDATE_DATE,
						LAST_UPDATE_LOGIN,
						OBJECT_VERSION_NUMBER,
						MAJOR_VERSION)
						SELECT
						ID,
						DNZ_CHR_ID,
						COV_TZE_LINE_ID,
						START_HOUR,
						START_MINUTE,
						END_HOUR,
						END_MINUTE,
						MONDAY_YN,
						TUESDAY_YN,
						WEDNESDAY_YN,
						THURSDAY_YN,
						FRIDAY_YN,
						SATURDAY_YN,
						SUNDAY_YN,
						SECURITY_GROUP_ID,
						PROGRAM_APPLICATION_ID,
						PROGRAM_ID,
						PROGRAM_UPDATE_DATE,
						REQUEST_ID,
						CREATED_BY,
						CREATION_DATE,
						LAST_UPDATED_BY,
						LAST_UPDATE_DATE,
						LAST_UPDATE_LOGIN,
						OBJECT_VERSION_NUMBER,
						p_major_version
						FROM OKS_COVERAGE_TIMES
						WHERE DNZ_CHR_ID = P_Id;

Line: 2689


DELETE OKS_COVERAGE_TIMES
WHERE DNZ_CHR_ID = p_id;

Line: 2693


INSERT INTO OKS_COVERAGE_TIMES(
						ID,
						DNZ_CHR_ID,
						COV_TZE_LINE_ID,
						START_HOUR,
						START_MINUTE,
						END_HOUR,
						END_MINUTE,
						MONDAY_YN,
						TUESDAY_YN,
						WEDNESDAY_YN,
						THURSDAY_YN,
						FRIDAY_YN,
						SATURDAY_YN,
						SUNDAY_YN,
						SECURITY_GROUP_ID,
						PROGRAM_APPLICATION_ID,
						PROGRAM_ID,
						PROGRAM_UPDATE_DATE,
						REQUEST_ID,
						CREATED_BY,
						CREATION_DATE,
						LAST_UPDATED_BY,
						LAST_UPDATE_DATE,
						LAST_UPDATE_LOGIN,
						OBJECT_VERSION_NUMBER)
						SELECT
						ID,
						DNZ_CHR_ID,
						COV_TZE_LINE_ID,
						START_HOUR,
						START_MINUTE,
						END_HOUR,
						END_MINUTE,
						MONDAY_YN,
						TUESDAY_YN,
						WEDNESDAY_YN,
						THURSDAY_YN,
						FRIDAY_YN,
						SATURDAY_YN,
						SUNDAY_YN,
						SECURITY_GROUP_ID,
						PROGRAM_APPLICATION_ID,
						PROGRAM_ID,
						PROGRAM_UPDATE_DATE,
						REQUEST_ID,
						CREATED_BY,
						CREATION_DATE,
						LAST_UPDATED_BY,
						LAST_UPDATE_DATE,
						LAST_UPDATE_LOGIN,
						OBJECT_VERSION_NUMBER
						FROM OKS_COVERAGE_TIMES_H
						WHERE DNZ_CHR_ID = P_Id
						AND major_version = p_major_version;