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

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

Line: 101


    SELECT
            ID,
            CLE_ID,
            BT_CLE_ID,
            DNZ_CHR_ID,
            START_HOUR,
            START_MINUTE,
            END_HOUR,
            END_MINUTE,
            MONDAY_FLAG,
            TUESDAY_FLAG,
            WEDNESDAY_FLAG,
            THURSDAY_FLAG,
            FRIDAY_FLAG,
            SATURDAY_FLAG,
            SUNDAY_FLAG,
            OBJECT1_ID1,
            OBJECT1_ID2,
            JTOT_OBJECT1_CODE,
            BILL_RATE_CODE,
            UOM,
            FLAT_RATE,
            HOLIDAY_YN,
            PERCENT_OVER_LIST_PRICE,
            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,
            SECURITY_GROUP_ID
      FROM Oks_Billrate_Schedules_V
     WHERE oks_billrate_schedules_v.id = p_id;

Line: 170


              l_oks_billrate_schedules_v_rec.program_update_date,
              l_oks_billrate_schedules_v_rec.request_id,
              l_oks_billrate_schedules_v_rec.created_by,
              l_oks_billrate_schedules_v_rec.creation_date,
              l_oks_billrate_schedules_v_rec.last_updated_by,
              l_oks_billrate_schedules_v_rec.last_update_date,
              l_oks_billrate_schedules_v_rec.last_update_login,
              l_oks_billrate_schedules_v_rec.object_version_number,
              l_oks_billrate_schedules_v_rec.security_group_id;

Line: 220


    SELECT
            ID,
            CLE_ID,
            BT_CLE_ID,
            DNZ_CHR_ID,
            START_HOUR,
            START_MINUTE,
            END_HOUR,
            END_MINUTE,
            MONDAY_FLAG,
            TUESDAY_FLAG,
            WEDNESDAY_FLAG,
            THURSDAY_FLAG,
            FRIDAY_FLAG,
            SATURDAY_FLAG,
            SUNDAY_FLAG,
            OBJECT1_ID1,
            OBJECT1_ID2,
            JTOT_OBJECT1_CODE,
            BILL_RATE_CODE,
            FLAT_RATE,
            UOM,
            HOLIDAY_YN,
            PERCENT_OVER_LIST_PRICE,
            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_Billrate_Schedules
     WHERE oks_billrate_schedules.id = p_id;

Line: 288


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

Line: 412


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

Line: 424


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

Line: 427


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

Line: 430


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

Line: 564


    p_to.program_update_date := p_from.program_update_date;

Line: 568


    p_to.last_updated_by := p_from.last_updated_by;

Line: 569


    p_to.last_update_date := p_from.last_update_date;

Line: 570


    p_to.last_update_login := p_from.last_update_login;

Line: 603


    p_to.program_update_date := p_from.program_update_date;

Line: 607


    p_to.last_updated_by := p_from.last_updated_by;

Line: 608


    p_to.last_update_date := p_from.last_update_date;

Line: 609


    p_to.last_update_login := p_from.last_update_login;

Line: 856


  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_billrate_schedules_rec   IN OksBillrateSchedulesRecType,
    x_oks_billrate_schedules_rec   OUT NOCOPY OksBillrateSchedulesRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 865


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

Line: 901


    INSERT INTO OKS_BILLRATE_SCHEDULES(
      id,
      cle_id,
      bt_cle_id,
      dnz_chr_id,
      start_hour,
      start_minute,
      end_hour,
      end_minute,
      monday_flag,
      tuesday_flag,
      wednesday_flag,
      thursday_flag,
      friday_flag,
      saturday_flag,
      sunday_flag,
      object1_id1,
      object1_id2,
      jtot_object1_code,
      bill_rate_code,
      flat_rate,
      uom,
      holiday_yn,
      percent_over_list_price,
      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_billrate_schedules_rec.id,
      l_oks_billrate_schedules_rec.cle_id,
      l_oks_billrate_schedules_rec.bt_cle_id,
      l_oks_billrate_schedules_rec.dnz_chr_id,
      l_oks_billrate_schedules_rec.start_hour,
      l_oks_billrate_schedules_rec.start_minute,
      l_oks_billrate_schedules_rec.end_hour,
      l_oks_billrate_schedules_rec.end_minute,
      l_oks_billrate_schedules_rec.monday_flag,
      l_oks_billrate_schedules_rec.tuesday_flag,
      l_oks_billrate_schedules_rec.wednesday_flag,
      l_oks_billrate_schedules_rec.thursday_flag,
      l_oks_billrate_schedules_rec.friday_flag,
      l_oks_billrate_schedules_rec.saturday_flag,
      l_oks_billrate_schedules_rec.sunday_flag,
      l_oks_billrate_schedules_rec.object1_id1,
      l_oks_billrate_schedules_rec.object1_id2,
      l_oks_billrate_schedules_rec.jtot_object1_code,
      l_oks_billrate_schedules_rec.bill_rate_code,
      l_oks_billrate_schedules_rec.flat_rate,
      l_oks_billrate_schedules_rec.uom,
      l_oks_billrate_schedules_rec.holiday_yn,
      l_oks_billrate_schedules_rec.percent_over_list_price,
      l_oks_billrate_schedules_rec.program_application_id,
      l_oks_billrate_schedules_rec.program_id,
      l_oks_billrate_schedules_rec.program_update_date,
      l_oks_billrate_schedules_rec.request_id,
      l_oks_billrate_schedules_rec.created_by,
      l_oks_billrate_schedules_rec.creation_date,
      l_oks_billrate_schedules_rec.last_updated_by,
      l_oks_billrate_schedules_rec.last_update_date,
      l_oks_billrate_schedules_rec.last_update_login,
      l_oks_billrate_schedules_rec.object_version_number);

Line: 1004


  END insert_row;

Line: 1008


  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_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
    x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1018


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

Line: 1034


      l_oks_billrate_schedules_v_rec.LAST_UPDATE_DATE := l_oks_billrate_schedules_v_rec.CREATION_DATE;

Line: 1035


      l_oks_billrate_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1036


      l_oks_billrate_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1100


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_oks_billrate_schedules_rec,
      lx_oks_billrate_schedules_rec
    );

Line: 1149


  END insert_row;

Line: 1153


  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_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
    x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1164


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

Line: 1178


          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_billrate_schedules_v_rec => p_oks_billrate_schedules_v_tbl(i),
            x_oks_billrate_schedules_v_rec => x_oks_billrate_schedules_v_tbl(i));

Line: 1246


  END insert_row;

Line: 1253


  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_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
    x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1263


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

Line: 1270


      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_billrate_schedules_v_tbl => p_oks_billrate_schedules_v_tbl,
        x_oks_billrate_schedules_v_tbl => x_oks_billrate_schedules_v_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1312


  END insert_row;

Line: 1330


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BILLRATE_SCHEDULES
     WHERE ID = p_oks_billrate_schedules_rec.id
       AND OBJECT_VERSION_NUMBER = p_oks_billrate_schedules_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1337


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BILLRATE_SCHEDULES
     WHERE ID = p_oks_billrate_schedules_rec.id;

Line: 1378


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1387


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1667


  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_billrate_schedules_rec   IN OksBillrateSchedulesRecType,
    x_oks_billrate_schedules_rec   OUT NOCOPY OksBillrateSchedulesRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1676


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

Line: 1796


        IF (x_oks_billrate_schedules_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_billrate_schedules_rec.program_update_date := l_oks_billrate_schedules_rec.program_update_date;

Line: 1812


        IF (x_oks_billrate_schedules_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_oks_billrate_schedules_rec.last_updated_by := l_oks_billrate_schedules_rec.last_updated_by;

Line: 1816


        IF (x_oks_billrate_schedules_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_billrate_schedules_rec.last_update_date := l_oks_billrate_schedules_rec.last_update_date;

Line: 1820


        IF (x_oks_billrate_schedules_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_oks_billrate_schedules_rec.last_update_login := l_oks_billrate_schedules_rec.last_update_login;

Line: 1870


    UPDATE OKS_BILLRATE_SCHEDULES
    SET CLE_ID = LDefOksBillrateSchedulesRec.cle_id,
        BT_CLE_ID = LDefOksBillrateSchedulesRec.bt_cle_id,
        DNZ_CHR_ID = LDefOksBillrateSchedulesRec.dnz_chr_id,
        START_HOUR = LDefOksBillrateSchedulesRec.start_hour,
        START_MINUTE = LDefOksBillrateSchedulesRec.start_minute,
        END_HOUR = LDefOksBillrateSchedulesRec.end_hour,
        END_MINUTE = LDefOksBillrateSchedulesRec.end_minute,
        MONDAY_FLAG = LDefOksBillrateSchedulesRec.monday_flag,
        TUESDAY_FLAG = LDefOksBillrateSchedulesRec.tuesday_flag,
        WEDNESDAY_FLAG = LDefOksBillrateSchedulesRec.wednesday_flag,
        THURSDAY_FLAG = LDefOksBillrateSchedulesRec.thursday_flag,
        FRIDAY_FLAG = LDefOksBillrateSchedulesRec.friday_flag,
        SATURDAY_FLAG = LDefOksBillrateSchedulesRec.saturday_flag,
        SUNDAY_FLAG = LDefOksBillrateSchedulesRec.sunday_flag,
        OBJECT1_ID1 = LDefOksBillrateSchedulesRec.object1_id1,
        OBJECT1_ID2 = LDefOksBillrateSchedulesRec.object1_id2,
        JTOT_OBJECT1_CODE = LDefOksBillrateSchedulesRec.jtot_object1_code,
        BILL_RATE_CODE = LDefOksBillrateSchedulesRec.bill_rate_code,
        FLAT_RATE = LDefOksBillrateSchedulesRec.flat_rate,
        UOM = LDefOksBillrateSchedulesRec.uom,
        HOLIDAY_YN = LDefOksBillrateSchedulesRec.holiday_yn,
        PERCENT_OVER_LIST_PRICE = LDefOksBillrateSchedulesRec.percent_over_list_price,
        PROGRAM_APPLICATION_ID = LDefOksBillrateSchedulesRec.program_application_id,
        PROGRAM_ID = LDefOksBillrateSchedulesRec.program_id,
        PROGRAM_UPDATE_DATE = LDefOksBillrateSchedulesRec.program_update_date,
        REQUEST_ID = LDefOksBillrateSchedulesRec.request_id,
        CREATED_BY = LDefOksBillrateSchedulesRec.created_by,
        CREATION_DATE = LDefOksBillrateSchedulesRec.creation_date,
        LAST_UPDATED_BY = LDefOksBillrateSchedulesRec.last_updated_by,
        LAST_UPDATE_DATE = LDefOksBillrateSchedulesRec.last_update_date,
        LAST_UPDATE_LOGIN = LDefOksBillrateSchedulesRec.last_update_login,
        OBJECT_VERSION_NUMBER = LDefOksBillrateSchedulesRec.object_version_number
    WHERE ID = LDefOksBillrateSchedulesRec.id;

Line: 1939


  END update_row;

Line: 1943


  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_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
    x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1953


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

Line: 1968


      l_oks_billrate_schedules_v_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1969


      l_oks_billrate_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1970


      l_oks_billrate_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2089


        IF (x_oks_billrate_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_billrate_schedules_v_rec.program_update_date := l_db_oks_billrate_sch1.program_update_date;

Line: 2105


        IF (x_oks_billrate_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_oks_billrate_schedules_v_rec.last_updated_by := l_db_oks_billrate_sch1.last_updated_by;

Line: 2109


        IF (x_oks_billrate_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oks_billrate_schedules_v_rec.last_update_date := l_db_oks_billrate_sch1.last_update_date;

Line: 2113


        IF (x_oks_billrate_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_oks_billrate_schedules_v_rec.last_update_login := l_db_oks_billrate_sch1.last_update_login;

Line: 2202


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_oks_billrate_schedules_rec,
      lx_oks_billrate_schedules_rec
    );

Line: 2250


  END update_row;

Line: 2254


  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_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
    x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2265


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

Line: 2279


          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_billrate_schedules_v_rec => p_oks_billrate_schedules_v_tbl(i),
            x_oks_billrate_schedules_v_rec => x_oks_billrate_schedules_v_tbl(i));

Line: 2347


  END update_row;

Line: 2354


  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_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
    x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2364


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

Line: 2371


      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_billrate_schedules_v_tbl => p_oks_billrate_schedules_v_tbl,
        x_oks_billrate_schedules_v_tbl => x_oks_billrate_schedules_v_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2413


  END update_row;

Line: 2421


  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_billrate_schedules_rec   IN OksBillrateSchedulesRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2429


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

Line: 2444


    DELETE FROM OKS_BILLRATE_SCHEDULES
     WHERE ID = p_oks_billrate_schedules_rec.id;

Line: 2480


  END delete_row;

Line: 2484


  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_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2493


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

Line: 2517


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

Line: 2562


  END delete_row;

Line: 2566


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2576


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

Line: 2590


          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_billrate_schedules_v_rec => p_oks_billrate_schedules_v_tbl(i));

Line: 2657


  END delete_row;

Line: 2662


  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_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2671


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

Line: 2678


      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_billrate_schedules_v_tbl => p_oks_billrate_schedules_v_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2719


  END delete_row;

Line: 2735


INSERT INTO OKS_BILLRATE_SCHEDULES_H(
						ID,
						CLE_ID,
						BT_CLE_ID,
						DNZ_CHR_ID,
						START_HOUR,
						START_MINUTE,
						END_HOUR,
						END_MINUTE,
						MONDAY_FLAG,
						TUESDAY_FLAG,
						WEDNESDAY_FLAG,
						THURSDAY_FLAG,
						FRIDAY_FLAG,
						SATURDAY_FLAG,
						SUNDAY_FLAG,
						OBJECT1_ID1,
						OBJECT1_ID2,
						JTOT_OBJECT1_CODE,
						BILL_RATE_CODE,
						FLAT_RATE,
						UOM,
						HOLIDAY_YN,
						PERCENT_OVER_LIST_PRICE,
						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,
						SECURITY_GROUP_ID,
						MAJOR_VERSION)
						SELECT
						ID,
						CLE_ID,
						BT_CLE_ID,
						DNZ_CHR_ID,
						START_HOUR,
						START_MINUTE,
						END_HOUR,
						END_MINUTE,
						MONDAY_FLAG,
						TUESDAY_FLAG,
						WEDNESDAY_FLAG,
						THURSDAY_FLAG,
						FRIDAY_FLAG,
						SATURDAY_FLAG,
						SUNDAY_FLAG,
						OBJECT1_ID1,
						OBJECT1_ID2,
						JTOT_OBJECT1_CODE,
						BILL_RATE_CODE,
						FLAT_RATE,
						UOM,
						HOLIDAY_YN,
						PERCENT_OVER_LIST_PRICE,
						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,
						SECURITY_GROUP_ID,
						p_major_version
						FROM OKS_BILLRATE_SCHEDULES
						WHERE DNZ_CHR_ID = P_Id;

Line: 2853


DELETE OKS_BILLRATE_SCHEDULES
WHERE DNZ_CHR_ID = p_id;

Line: 2857


INSERT INTO OKS_BILLRATE_SCHEDULES(
						ID,
						CLE_ID,
						BT_CLE_ID,
						DNZ_CHR_ID,
						START_HOUR,
						START_MINUTE,
						END_HOUR,
						END_MINUTE,
						MONDAY_FLAG,
						TUESDAY_FLAG,
						WEDNESDAY_FLAG,
						THURSDAY_FLAG,
						FRIDAY_FLAG,
						SATURDAY_FLAG,
						SUNDAY_FLAG,
						OBJECT1_ID1,
						OBJECT1_ID2,
						JTOT_OBJECT1_CODE,
						BILL_RATE_CODE,
						FLAT_RATE,
						UOM,
						HOLIDAY_YN,
						PERCENT_OVER_LIST_PRICE,
						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,
						SECURITY_GROUP_ID)
						SELECT
						ID,
						CLE_ID,
						BT_CLE_ID,
						DNZ_CHR_ID,
						START_HOUR,
						START_MINUTE,
						END_HOUR,
						END_MINUTE,
						MONDAY_FLAG,
						TUESDAY_FLAG,
						WEDNESDAY_FLAG,
						THURSDAY_FLAG,
						FRIDAY_FLAG,
						SATURDAY_FLAG,
						SUNDAY_FLAG,
						OBJECT1_ID1,
						OBJECT1_ID2,
						JTOT_OBJECT1_CODE,
						BILL_RATE_CODE,
						FLAT_RATE,
						UOM,
						HOLIDAY_YN,
						PERCENT_OVER_LIST_PRICE,
						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,
						SECURITY_GROUP_ID
						FROM OKS_BILLRATE_SCHEDULES_H
						WHERE DNZ_CHR_ID = P_Id
						AND major_version = p_major_version;