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

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

Line: 101


    SELECT
            ID,
            CLE_ID,
            DEFAULT_YN,
            TIMEZONE_ID,
            DNZ_CHR_ID,
            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,
-- R12 Data Model Changes 4485150 Start
            ORIG_SYSTEM_ID1,
            ORIG_SYSTEM_REFERENCE1,
            ORIG_SYSTEM_SOURCE_CODE
-- R12 Data Model Changes 4485150 End
      FROM Oks_Coverage_Timezones_V
     WHERE oks_coverage_timezones_v.id = p_id;

Line: 140


              l_oks_coverage_timezones_v_rec.program_update_date,
              l_oks_coverage_timezones_v_rec.request_id,
              l_oks_coverage_timezones_v_rec.created_by,
              l_oks_coverage_timezones_v_rec.creation_date,
              l_oks_coverage_timezones_v_rec.last_updated_by,
              l_oks_coverage_timezones_v_rec.last_update_date,
              l_oks_coverage_timezones_v_rec.last_update_login,
              l_oks_coverage_timezones_v_rec.object_version_number,
-- R12 Data Model Changes 4485150 Start
              l_oks_coverage_timezones_v_rec.orig_system_id1,
              l_oks_coverage_timezones_v_rec.orig_system_reference1,
              l_oks_coverage_timezones_v_rec.orig_system_source_code
-- R12 Data Model Changes 4485150 End
;

Line: 195


    SELECT
            ID,
            CLE_ID,
            DEFAULT_YN,
            TIMEZONE_ID,
            DNZ_CHR_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,
-- R12 Data Model Changes 4485150 Start
            ORIG_SYSTEM_ID1,
            ORIG_SYSTEM_REFERENCE1,
            ORIG_SYSTEM_SOURCE_CODE
-- R12 Data Model Changes 4485150 End
      FROM Oks_Coverage_Timezones
     WHERE oks_coverage_timezones.id = p_id;

Line: 232


              l_oks_coverage_timezones_rec.program_update_date,
              l_oks_coverage_timezones_rec.request_id,
              l_oks_coverage_timezones_rec.created_by,
              l_oks_coverage_timezones_rec.creation_date,
              l_oks_coverage_timezones_rec.last_updated_by,
              l_oks_coverage_timezones_rec.last_update_date,
              l_oks_coverage_timezones_rec.last_update_login,
              l_oks_coverage_timezones_rec.object_version_number,
-- R12 Data Model Changes 4485150 Start
              l_oks_coverage_timezones_rec.orig_system_id1,
              l_oks_coverage_timezones_rec.orig_system_reference1,
              l_oks_coverage_timezones_rec.orig_system_source_code
-- R12 Data Model Changes 4485150 End

;

Line: 312


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

Line: 324


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

Line: 327


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

Line: 330


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

Line: 490


    p_to.program_update_date := p_from.program_update_date;

Line: 494


    p_to.last_updated_by := p_from.last_updated_by;

Line: 495


    p_to.last_update_date := p_from.last_update_date;

Line: 496


    p_to.last_update_login := p_from.last_update_login;

Line: 516


    p_to.program_update_date := p_from.program_update_date;

Line: 520


    p_to.last_updated_by := p_from.last_updated_by;

Line: 521


    p_to.last_update_date := p_from.last_update_date;

Line: 522


    p_to.last_update_login := p_from.last_update_login;

Line: 774


  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_timezones_rec   IN OksCoverageTimezonesRecType,
    x_oks_coverage_timezones_rec   OUT NOCOPY OksCoverageTimezonesRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 783


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

Line: 819


    INSERT INTO OKS_COVERAGE_TIMEZONES(
      id,
      cle_id,
      default_yn,
      timezone_id,
      dnz_chr_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,
-- R12 Data Model Changes 4485150 Start
      orig_system_id1,
      orig_system_reference1,
      orig_system_source_code
-- R12 Data Model Changes 4485150 End
)
    VALUES (
      l_oks_coverage_timezones_rec.id,
      l_oks_coverage_timezones_rec.cle_id,
      l_oks_coverage_timezones_rec.default_yn,
      l_oks_coverage_timezones_rec.timezone_id,
      l_oks_coverage_timezones_rec.dnz_chr_id,
      l_oks_coverage_timezones_rec.program_application_id,
      l_oks_coverage_timezones_rec.program_id,
      l_oks_coverage_timezones_rec.program_update_date,
      l_oks_coverage_timezones_rec.request_id,
      l_oks_coverage_timezones_rec.created_by,
      l_oks_coverage_timezones_rec.creation_date,
      l_oks_coverage_timezones_rec.last_updated_by,
      l_oks_coverage_timezones_rec.last_update_date,
      l_oks_coverage_timezones_rec.last_update_login,
      l_oks_coverage_timezones_rec.object_version_number,
-- R12 Data Model Changes 4485150 Start
      l_oks_coverage_timezones_rec.orig_system_id1,
      l_oks_coverage_timezones_rec.orig_system_reference1,
      l_oks_coverage_timezones_rec.orig_system_source_code
-- R12 Data Model Changes 4485150 End
);

Line: 898


  END insert_row;

Line: 902


  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_timezones_v_rec IN OksCoverageTimezonesVRecType,
    x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 912


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

Line: 928


      l_oks_coverage_timezones_v_rec.LAST_UPDATE_DATE := l_oks_coverage_timezones_v_rec.CREATION_DATE;

Line: 929


      l_oks_coverage_timezones_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 930


      l_oks_coverage_timezones_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 994


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_oks_coverage_timezones_rec,
      lx_oks_coverage_timezones_rec
    );

Line: 1043


  END insert_row;

Line: 1047


  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_timezones_v_tbl IN OksCoverageTimezonesVTblType,
    x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1058


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

Line: 1072


          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_timezones_v_rec => p_oks_coverage_timezones_v_tbl(i),
            x_oks_coverage_timezones_v_rec => x_oks_coverage_timezones_v_tbl(i));

Line: 1140


  END insert_row;

Line: 1147


  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_timezones_v_tbl IN OksCoverageTimezonesVTblType,
    x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1157


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

Line: 1164


      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_timezones_v_tbl => p_oks_coverage_timezones_v_tbl,
        x_oks_coverage_timezones_v_tbl => x_oks_coverage_timezones_v_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1206


  END insert_row;

Line: 1224


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_COVERAGE_TIMEZONES
     WHERE ID = p_oks_coverage_timezones_rec.id
       AND OBJECT_VERSION_NUMBER = p_oks_coverage_timezones_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1231


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_COVERAGE_TIMEZONES
     WHERE ID = p_oks_coverage_timezones_rec.id;

Line: 1272


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1281


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1561


  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_timezones_rec   IN OksCoverageTimezonesRecType,
    x_oks_coverage_timezones_rec   OUT NOCOPY OksCoverageTimezonesRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1570


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

Line: 1618


        IF (x_oks_coverage_timezones_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_coverage_timezones_rec.program_update_date := l_oks_coverage_timezones_rec.program_update_date;

Line: 1634


        IF (x_oks_coverage_timezones_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_oks_coverage_timezones_rec.last_updated_by := l_oks_coverage_timezones_rec.last_updated_by;

Line: 1638


        IF (x_oks_coverage_timezones_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_coverage_timezones_rec.last_update_date := l_oks_coverage_timezones_rec.last_update_date;

Line: 1642


        IF (x_oks_coverage_timezones_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_oks_coverage_timezones_rec.last_update_login := l_oks_coverage_timezones_rec.last_update_login;

Line: 1706


    UPDATE OKS_COVERAGE_TIMEZONES
    SET CLE_ID = LDefOksCoverageTimezonesRec.cle_id,
        DEFAULT_YN = LDefOksCoverageTimezonesRec.default_yn,
        TIMEZONE_ID = LDefOksCoverageTimezonesRec.timezone_id,
        DNZ_CHR_ID = LDefOksCoverageTimezonesRec.dnz_chr_id,
        PROGRAM_APPLICATION_ID = LDefOksCoverageTimezonesRec.program_application_id,
        PROGRAM_ID = LDefOksCoverageTimezonesRec.program_id,
        PROGRAM_UPDATE_DATE = LDefOksCoverageTimezonesRec.program_update_date,
        REQUEST_ID = LDefOksCoverageTimezonesRec.request_id,
        CREATED_BY = LDefOksCoverageTimezonesRec.created_by,
        CREATION_DATE = LDefOksCoverageTimezonesRec.creation_date,
        LAST_UPDATED_BY = LDefOksCoverageTimezonesRec.last_updated_by,
        LAST_UPDATE_DATE = LDefOksCoverageTimezonesRec.last_update_date,
        LAST_UPDATE_LOGIN = LDefOksCoverageTimezonesRec.last_update_login,
        OBJECT_VERSION_NUMBER = LDefOksCoverageTimezonesRec.object_version_number,
-- R12 Data Model Changes 4485150 Start
        ORIG_SYSTEM_ID1	= LDefOksCoverageTimezonesRec.orig_system_id1,
        ORIG_SYSTEM_REFERENCE1 = LDefOksCoverageTimezonesRec.orig_system_reference1,
        ORIG_SYSTEM_SOURCE_CODE = LDefOksCoverageTimezonesRec.orig_system_source_code
-- R12 Data Model Changes 4485150 End
    WHERE ID = LDefOksCoverageTimezonesRec.id;

Line: 1762


  END update_row;

Line: 1766


  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_timezones_v_rec IN OksCoverageTimezonesVRecType,
    x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1776


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

Line: 1791


      l_oks_coverage_timezones_v_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1792


      l_oks_coverage_timezones_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1793


      l_oks_coverage_timezones_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1844


        IF (x_oks_coverage_timezones_v_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_coverage_timezones_v_rec.program_update_date := l_db_oks_coverage_tim44.program_update_date;

Line: 1860


        IF (x_oks_coverage_timezones_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_oks_coverage_timezones_v_rec.last_updated_by := l_db_oks_coverage_tim44.last_updated_by;

Line: 1864


        IF (x_oks_coverage_timezones_v_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_coverage_timezones_v_rec.last_update_date := l_db_oks_coverage_tim44.last_update_date;

Line: 1868


        IF (x_oks_coverage_timezones_v_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_oks_coverage_timezones_v_rec.last_update_login := l_db_oks_coverage_tim44.last_update_login;

Line: 1967


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_oks_coverage_timezones_rec,
      lx_oks_coverage_timezones_rec
    );

Line: 2015


  END update_row;

Line: 2019


  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_timezones_v_tbl IN OksCoverageTimezonesVTblType,
    x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2030


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

Line: 2044


          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_timezones_v_rec => p_oks_coverage_timezones_v_tbl(i),
            x_oks_coverage_timezones_v_rec => x_oks_coverage_timezones_v_tbl(i));

Line: 2112


  END update_row;

Line: 2119


  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_timezones_v_tbl IN OksCoverageTimezonesVTblType,
    x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2129


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

Line: 2136


      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_timezones_v_tbl => p_oks_coverage_timezones_v_tbl,
        x_oks_coverage_timezones_v_tbl => x_oks_coverage_timezones_v_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2178


  END update_row;

Line: 2186


  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_timezones_rec   IN OksCoverageTimezonesRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2194


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

Line: 2209


    DELETE FROM OKS_COVERAGE_TIMEZONES
     WHERE ID = p_oks_coverage_timezones_rec.id;

Line: 2245


  END delete_row;

Line: 2249


  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_timezones_v_rec IN OksCoverageTimezonesVRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2258


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

Line: 2282


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

Line: 2327


  END delete_row;

Line: 2331


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2341


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

Line: 2355


          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_timezones_v_rec => p_oks_coverage_timezones_v_tbl(i));

Line: 2422


  END delete_row;

Line: 2427


  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_timezones_v_tbl IN OksCoverageTimezonesVTblType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2436


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

Line: 2443


      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_timezones_v_tbl => p_oks_coverage_timezones_v_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2484


  END delete_row;

Line: 2501


INSERT INTO OKS_COVERAGE_TIMEZONES_H(
						ID,
						CLE_ID,
						DEFAULT_YN,
						TIMEZONE_ID,
						DNZ_CHR_ID,
						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-- ,
-- R12 Data Model Changes 4485150 Start
                                     /*           ORIG_SYSTEM_ID1,
                                                ORIG_SYSTEM_REFERENCE1,
                                                ORIG_SYSTEM_SOURCE_CODE */
-- R12 Data Model Changes 4485150 End
)
						SELECT
						ID,
						CLE_ID,
						DEFAULT_YN,
						TIMEZONE_ID,
						DNZ_CHR_ID,
						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-- ,
-- R12 Data Model Changes 4485150 Start
                                      /*          ORIG_SYSTEM_ID1,
                                                ORIG_SYSTEM_REFERENCE1,
                                                ORIG_SYSTEM_SOURCE_CODE */
-- R12 Data Model Changes 4485150 End
						FROM OKS_COVERAGE_TIMEZONES
						WHERE DNZ_CHR_ID = P_Id;

Line: 2594


DELETE OKS_COVERAGE_TIMEZONES
WHERE DNZ_CHR_ID = p_id;

Line: 2601


INSERT INTO OKS_COVERAGE_TIMEZONES(
				ID,
				CLE_ID,
				DEFAULT_YN,
				TIMEZONE_ID,
				DNZ_CHR_ID,
				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--,
-- R12 Data Model Changes 4485150 Start
                           /*                     ORIG_SYSTEM_ID1,
                                                ORIG_SYSTEM_REFERENCE1,
                                                ORIG_SYSTEM_SOURCE_CODE */
-- R12 Data Model Changes 4485150 End
)
				SELECT
				ID,
				CLE_ID,
				DEFAULT_YN,
				TIMEZONE_ID,
				DNZ_CHR_ID,
				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--,
-- R12 Data Model Changes 4485150 Start
                                           /*     ORIG_SYSTEM_ID1,
                                                ORIG_SYSTEM_REFERENCE1,
                                                ORIG_SYSTEM_SOURCE_CODE */
-- R12 Data Model Changes 4485150 End
				FROM OKS_COVERAGE_TIMEZONES_H
				WHERE DNZ_CHR_ID = P_Id
				AND major_version = p_major_version;