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

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

Line: 101


    SELECT
            ID,
            CLE_ID,
            DNZ_CHR_ID,
            ACTION_TYPE_CODE,
            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_Action_Time_Types_V
     WHERE oks_action_time_types_v.id = p_id;

Line: 138


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

Line: 194


    SELECT
            ID,
            CLE_ID,
            DNZ_CHR_ID,
            ACTION_TYPE_CODE,
            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_Action_Time_Types
     WHERE oks_action_time_types.id = p_id;

Line: 229


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

Line: 305


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

Line: 317


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

Line: 320


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

Line: 323


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

Line: 483


    p_to.program_update_date := p_from.program_update_date;

Line: 487


    p_to.last_updated_by := p_from.last_updated_by;

Line: 488


    p_to.last_update_date := p_from.last_update_date;

Line: 489


    p_to.last_update_login := p_from.last_update_login;

Line: 508


    p_to.program_update_date := p_from.program_update_date;

Line: 512


    p_to.last_updated_by := p_from.last_updated_by;

Line: 513


    p_to.last_update_date := p_from.last_update_date;

Line: 514


    p_to.last_update_login := p_from.last_update_login;

Line: 766


  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_action_time_types_rec    IN oks_action_time_types_rec_type,
    x_oks_action_time_types_rec    OUT NOCOPY oks_action_time_types_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 775


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

Line: 811


    INSERT INTO OKS_ACTION_TIME_TYPES(
      id,
      cle_id,
      dnz_chr_id,
      action_type_code,
      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_action_time_types_rec.id,
      l_oks_action_time_types_rec.cle_id,
      l_oks_action_time_types_rec.dnz_chr_id,
      l_oks_action_time_types_rec.action_type_code,
      l_oks_action_time_types_rec.program_application_id,
      l_oks_action_time_types_rec.program_id,
      l_oks_action_time_types_rec.program_update_date,
      l_oks_action_time_types_rec.request_id,
      l_oks_action_time_types_rec.created_by,
      l_oks_action_time_types_rec.creation_date,
      l_oks_action_time_types_rec.last_updated_by,
      l_oks_action_time_types_rec.last_update_date,
      l_oks_action_time_types_rec.last_update_login,
      l_oks_action_time_types_rec.object_version_number,
-- R12 Data Model Changes 4485150 Start
      l_oks_action_time_types_rec.orig_system_id1,
      l_oks_action_time_types_rec.orig_system_reference1,
      l_oks_action_time_types_rec.orig_system_source_code
-- R12 Data Model Changes 4485150 End
);

Line: 888


  END insert_row;

Line: 892


  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_action_time_types_v_rec  IN OksActionTimeTypesVRecType,
    x_oks_action_time_types_v_rec  OUT NOCOPY OksActionTimeTypesVRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 902


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

Line: 918


      l_oks_action_time_types_v_rec.LAST_UPDATE_DATE := l_oks_action_time_types_v_rec.CREATION_DATE;

Line: 919


      l_oks_action_time_types_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 920


      l_oks_action_time_types_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 984


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_oks_action_time_types_rec,
      lx_oks_action_time_types_rec
    );

Line: 1033


  END insert_row;

Line: 1037


  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_action_time_types_v_tbl  IN OksActionTimeTypesVTblType,
    x_oks_action_time_types_v_tbl  OUT NOCOPY OksActionTimeTypesVTblType,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1048


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

Line: 1062


          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_action_time_types_v_rec  => p_oks_action_time_types_v_tbl(i),
            x_oks_action_time_types_v_rec  => x_oks_action_time_types_v_tbl(i));

Line: 1130


  END insert_row;

Line: 1137


  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_action_time_types_v_tbl  IN OksActionTimeTypesVTblType,
    x_oks_action_time_types_v_tbl  OUT NOCOPY OksActionTimeTypesVTblType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1147


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

Line: 1154


      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_action_time_types_v_tbl  => p_oks_action_time_types_v_tbl,
        x_oks_action_time_types_v_tbl  => x_oks_action_time_types_v_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1196


  END insert_row;

Line: 1214


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_ACTION_TIME_TYPES
     WHERE ID = p_oks_action_time_types_rec.id
       AND OBJECT_VERSION_NUMBER = p_oks_action_time_types_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1221


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_ACTION_TIME_TYPES
     WHERE ID = p_oks_action_time_types_rec.id;

Line: 1262


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1271


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1551


  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_action_time_types_rec    IN oks_action_time_types_rec_type,
    x_oks_action_time_types_rec    OUT NOCOPY oks_action_time_types_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1560


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

Line: 1604


        IF (x_oks_action_time_types_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_action_time_types_rec.program_update_date := l_oks_action_time_types_rec.program_update_date;

Line: 1620


        IF (x_oks_action_time_types_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_oks_action_time_types_rec.last_updated_by := l_oks_action_time_types_rec.last_updated_by;

Line: 1624


        IF (x_oks_action_time_types_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_action_time_types_rec.last_update_date := l_oks_action_time_types_rec.last_update_date;

Line: 1628


        IF (x_oks_action_time_types_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_oks_action_time_types_rec.last_update_login := l_oks_action_time_types_rec.last_update_login;

Line: 1692


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

Line: 1747


  END update_row;

Line: 1751


  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_action_time_types_v_rec  IN OksActionTimeTypesVRecType,
    x_oks_action_time_types_v_rec  OUT NOCOPY OksActionTimeTypesVRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1761


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

Line: 1776


      l_oks_action_time_types_v_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1777


      l_oks_action_time_types_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1778


      l_oks_action_time_types_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1825


        IF (x_oks_action_time_types_v_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_action_time_types_v_rec.program_update_date := l_db_oks_action_tim2.program_update_date;

Line: 1841


        IF (x_oks_action_time_types_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_oks_action_time_types_v_rec.last_updated_by := l_db_oks_action_tim2.last_updated_by;

Line: 1845


        IF (x_oks_action_time_types_v_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_action_time_types_v_rec.last_update_date := l_db_oks_action_tim2.last_update_date;

Line: 1849


        IF (x_oks_action_time_types_v_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_oks_action_time_types_v_rec.last_update_login := l_db_oks_action_tim2.last_update_login;

Line: 1948


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_oks_action_time_types_rec,
      lx_oks_action_time_types_rec
    );

Line: 1996


  END update_row;

Line: 2000


  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_action_time_types_v_tbl  IN OksActionTimeTypesVTblType,
    x_oks_action_time_types_v_tbl  OUT NOCOPY OksActionTimeTypesVTblType,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2011


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

Line: 2025


          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_action_time_types_v_rec  => p_oks_action_time_types_v_tbl(i),
            x_oks_action_time_types_v_rec  => x_oks_action_time_types_v_tbl(i));

Line: 2093


  END update_row;

Line: 2100


  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_action_time_types_v_tbl  IN OksActionTimeTypesVTblType,
    x_oks_action_time_types_v_tbl  OUT NOCOPY OksActionTimeTypesVTblType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2110


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

Line: 2117


      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_action_time_types_v_tbl  => p_oks_action_time_types_v_tbl,
        x_oks_action_time_types_v_tbl  => x_oks_action_time_types_v_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2159


  END update_row;

Line: 2167


  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_action_time_types_rec    IN oks_action_time_types_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2175


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

Line: 2190


    DELETE FROM OKS_ACTION_TIME_TYPES
     WHERE ID = p_oks_action_time_types_rec.id;

Line: 2226


  END delete_row;

Line: 2230


  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_action_time_types_v_rec  IN OksActionTimeTypesVRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2239


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

Line: 2263


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

Line: 2308


  END delete_row;

Line: 2312


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2322


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

Line: 2336


          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_action_time_types_v_rec  => p_oks_action_time_types_v_tbl(i));

Line: 2403


  END delete_row;

Line: 2408


  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_action_time_types_v_tbl  IN OksActionTimeTypesVTblType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2417


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

Line: 2424


      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_action_time_types_v_tbl  => p_oks_action_time_types_v_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2465


  END delete_row;

Line: 2482


INSERT INTO OKS_ACTION_TIME_TYPES_H(
				MAJOR_VERSION,
				ID,
				CLE_ID ,
				DNZ_CHR_ID,
				ACTION_TYPE_CODE ,
				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
				p_major_version,
				ID,
				CLE_ID ,
				DNZ_CHR_ID,
				ACTION_TYPE_CODE ,
				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_ACTION_TIME_TYPES
				WHERE DNZ_CHR_ID = P_Id;

Line: 2578


DELETE OKS_ACTION_TIME_TYPES
WHERE DNZ_CHR_ID = p_id;

Line: 2581


INSERT INTO OKS_ACTION_TIME_TYPES(
				ID,
				CLE_ID ,
				DNZ_CHR_ID,
				ACTION_TYPE_CODE ,
				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 ,
				DNZ_CHR_ID,
				ACTION_TYPE_CODE ,
				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_ACTION_TIME_TYPES_H
				WHERE DNZ_CHR_ID = p_id
				AND major_version = p_major_version;