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

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

Line: 43


    SELECT
            ID,
            SAV_ID,
            OBJECT1_ID1,
            OBJECT1_ID2,
            JTOT_OBJECT1_CODE,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            MANUFACTURING_ORG_ID,
            REVISION_LOW,
            REVISION_HIGH,
            START_DATE_ACTIVE,
            END_DATE_ACTIVE,
            LAST_UPDATE_LOGIN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15
      FROM Oks_Serv_Avail_Excepts
     WHERE oks_serv_avail_excepts.id = p_id;

Line: 93


              l_sax_rec.LAST_UPDATED_BY,
              l_sax_rec.LAST_UPDATE_DATE,
              l_sax_rec.MANUFACTURING_ORG_ID,
              l_sax_rec.REVISION_LOW,
              l_sax_rec.REVISION_HIGH,
              l_sax_rec.START_DATE_ACTIVE,
              l_sax_rec.END_DATE_ACTIVE,
              l_sax_rec.LAST_UPDATE_LOGIN,
              l_sax_rec.ATTRIBUTE_CATEGORY,
              l_sax_rec.ATTRIBUTE1,
              l_sax_rec.ATTRIBUTE2,
              l_sax_rec.ATTRIBUTE3,
              l_sax_rec.ATTRIBUTE4,
              l_sax_rec.ATTRIBUTE5,
              l_sax_rec.ATTRIBUTE6,
              l_sax_rec.ATTRIBUTE7,
              l_sax_rec.ATTRIBUTE8,
              l_sax_rec.ATTRIBUTE9,
              l_sax_rec.ATTRIBUTE10,
              l_sax_rec.ATTRIBUTE11,
              l_sax_rec.ATTRIBUTE12,
              l_sax_rec.ATTRIBUTE13,
              l_sax_rec.ATTRIBUTE14,
              l_sax_rec.ATTRIBUTE15;

Line: 137


    SELECT
            ID,
            SAV_ID,
            OBJECT1_ID1,
            OBJECT1_ID2,
            JTOT_OBJECT1_CODE,
            OBJECT_VERSION_NUMBER,
            MANUFACTURING_ORG_ID,
            REVISION_LOW,
            REVISION_HIGH,
            START_DATE_ACTIVE,
            END_DATE_ACTIVE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Oks_Serv_Avail_Excepts_V
     WHERE oks_serv_avail_excepts_v.id = p_id;

Line: 208


              l_saxv_rec.LAST_UPDATED_BY,
              l_saxv_rec.LAST_UPDATE_DATE,
              l_saxv_rec.LAST_UPDATE_LOGIN;

Line: 316


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

Line: 319


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

Line: 322


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

Line: 365


  	  select 'x'
	  from OKS_SERV_AVAILS_V
  	  where id = P_sav_id;

Line: 2103


      SELECT
              ID,
              OBJECT1_ID1,
              OBJECT1_ID2,
              JTOT_OBJECT1_CODE,
              OBJECT_VERSION_NUMBER,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_DATE,
              GENERAL_YN,
              EXCEPT_OBJECT_TYPE,
              START_DATE_ACTIVE,
              END_DATE_ACTIVE,
              LAST_UPDATE_LOGIN,
              ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15
        FROM Oks_Serv_Avails_V
       WHERE oks_serv_avails_v.id = p_id;

Line: 2178


    p_to.last_updated_by := p_from.last_updated_by;

Line: 2179


    p_to.last_update_date := p_from.last_update_date;

Line: 2185


    p_to.last_update_login := p_from.last_update_login;

Line: 2216


    p_to.last_updated_by := p_from.last_updated_by;

Line: 2217


    p_to.last_update_date := p_from.last_update_date;

Line: 2223


    p_to.last_update_login := p_from.last_update_login;

Line: 2392


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sax_rec                      IN sax_rec_type,
    x_sax_rec                      OUT NOCOPY sax_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2401


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

Line: 2437


    INSERT INTO OKS_SERV_AVAIL_EXCEPTS(
        id,
        sav_id,
        object1_id1,
        object1_id2,
        JTOT_OBJECT1_CODE,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        manufacturing_org_id,
        revision_low,
        revision_high,
        start_date_active,
        end_date_active,
        last_update_login,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15)
      VALUES (
        l_sax_rec.id,
        l_sax_rec.sav_id,
        l_sax_rec.object1_id1,
        l_sax_rec.object1_id2,
        l_sax_rec.JTOT_OBJECT1_CODE,
        l_sax_rec.object_version_number,
        l_sax_rec.created_by,
        l_sax_rec.creation_date,
        l_sax_rec.last_updated_by,
        l_sax_rec.last_update_date,
        l_sax_rec.manufacturing_org_id,
        l_sax_rec.revision_low,
        l_sax_rec.revision_high,
        l_sax_rec.start_date_active,
        l_sax_rec.end_date_active,
        l_sax_rec.last_update_login,
        l_sax_rec.attribute_category,
        l_sax_rec.attribute1,
        l_sax_rec.attribute2,
        l_sax_rec.attribute3,
        l_sax_rec.attribute4,
        l_sax_rec.attribute5,
        l_sax_rec.attribute6,
        l_sax_rec.attribute7,
        l_sax_rec.attribute8,
        l_sax_rec.attribute9,
        l_sax_rec.attribute10,
        l_sax_rec.attribute11,
        l_sax_rec.attribute12,
        l_sax_rec.attribute13,
        l_sax_rec.attribute14,
        l_sax_rec.attribute15);

Line: 2537


  END insert_row;

Line: 2541


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_saxv_rec                     IN saxv_rec_type,
    x_saxv_rec                     OUT NOCOPY saxv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2551


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

Line: 2567


      l_saxv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2568


      l_saxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2569


      l_saxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2633


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sax_rec,
      lx_sax_rec
    );

Line: 2681


  END insert_row;

Line: 2685


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_saxv_tbl                     IN saxv_tbl_type,
    x_saxv_tbl                     OUT NOCOPY saxv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2695


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

Line: 2704


        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_saxv_rec                     => p_saxv_tbl(i),
          x_saxv_rec                     => x_saxv_tbl(i));

Line: 2747


  END insert_row;

Line: 2765


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_SERV_AVAIL_EXCEPTS
     WHERE ID = p_sax_rec.id
       AND OBJECT_VERSION_NUMBER = p_sax_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2772


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_SERV_AVAIL_EXCEPTS
    WHERE ID = p_sax_rec.id;

Line: 2813


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2822


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 3009


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sax_rec                      IN sax_rec_type,
    x_sax_rec                      OUT NOCOPY sax_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3018


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

Line: 3072


      IF (x_sax_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_sax_rec.last_updated_by := l_sax_rec.last_updated_by;

Line: 3076


      IF (x_sax_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_sax_rec.last_update_date := l_sax_rec.last_update_date;

Line: 3100


      IF (x_sax_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_sax_rec.last_update_login := l_sax_rec.last_update_login;

Line: 3208


    UPDATE  OKS_SERV_AVAIL_EXCEPTS
    SET SAV_ID = l_def_sax_rec.sav_id,
        OBJECT1_ID1 = l_def_sax_rec.object1_id1,
        OBJECT1_ID2 = l_def_sax_rec.object1_id2,
        JTOT_OBJECT1_CODE = l_def_sax_rec.JTOT_OBJECT1_CODE,
        OBJECT_VERSION_NUMBER = l_def_sax_rec.object_version_number,
        CREATED_BY = l_def_sax_rec.created_by,
        CREATION_DATE = l_def_sax_rec.creation_date,
        LAST_UPDATED_BY = l_def_sax_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_sax_rec.last_update_date,
        MANUFACTURING_ORG_ID = l_def_sax_rec.manufacturing_org_id,
        REVISION_LOW = l_def_sax_rec.revision_low,
        REVISION_HIGH = l_def_sax_rec.revision_high,
        START_DATE_ACTIVE = l_def_sax_rec.start_date_active,
        END_DATE_ACTIVE = l_def_sax_rec.end_date_active,
        LAST_UPDATE_LOGIN = l_def_sax_rec.last_update_login,
        ATTRIBUTE_CATEGORY = l_def_sax_rec.attribute_category,
        ATTRIBUTE1 = l_def_sax_rec.attribute1,
        ATTRIBUTE2 = l_def_sax_rec.attribute2,
        ATTRIBUTE3 = l_def_sax_rec.attribute3,
        ATTRIBUTE4 = l_def_sax_rec.attribute4,
        ATTRIBUTE5 = l_def_sax_rec.attribute5,
        ATTRIBUTE6 = l_def_sax_rec.attribute6,
        ATTRIBUTE7 = l_def_sax_rec.attribute7,
        ATTRIBUTE8 = l_def_sax_rec.attribute8,
        ATTRIBUTE9 = l_def_sax_rec.attribute9,
        ATTRIBUTE10 = l_def_sax_rec.attribute10,
        ATTRIBUTE11 = l_def_sax_rec.attribute11,
        ATTRIBUTE12 = l_def_sax_rec.attribute12,
        ATTRIBUTE13 = l_def_sax_rec.attribute13,
        ATTRIBUTE14 = l_def_sax_rec.attribute14,
        ATTRIBUTE15 = l_def_sax_rec.attribute15
    WHERE ID = l_def_sax_rec.id;

Line: 3275


  END update_row;

Line: 3279


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_saxv_rec                     IN saxv_rec_type,
    x_saxv_rec                     OUT NOCOPY saxv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3289


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

Line: 3303


      l_saxv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3304


      l_saxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3305


      l_saxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3441


      IF (x_saxv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_saxv_rec.last_updated_by := l_saxv_rec.last_updated_by;

Line: 3445


      IF (x_saxv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_saxv_rec.last_update_date := l_saxv_rec.last_update_date;

Line: 3449


      IF (x_saxv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_saxv_rec.last_update_login := l_saxv_rec.last_update_login;

Line: 3520


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sax_rec,
      lx_sax_rec
    );

Line: 3567


  END update_row;

Line: 3571


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_saxv_tbl                     IN saxv_tbl_type,
    x_saxv_tbl                     OUT NOCOPY saxv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3581


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

Line: 3590


        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_saxv_rec                     => p_saxv_tbl(i),
          x_saxv_rec                     => x_saxv_tbl(i));

Line: 3633


  END update_row;

Line: 3641


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sax_rec                      IN sax_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3649


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

Line: 3663


    DELETE FROM OKS_SERV_AVAIL_EXCEPTS
     WHERE ID = l_sax_rec.id;

Line: 3698


  END delete_row;

Line: 3702


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_saxv_rec                     IN saxv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3711


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

Line: 3735


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sax_rec
    );

Line: 3779


  END delete_row;

Line: 3783


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_saxv_tbl                     IN saxv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3792


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

Line: 3801


        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_saxv_rec                     => p_saxv_tbl(i));

Line: 3843


  END delete_row;

Line: 3844


PROCEDURE INSERT_ROW_UPG(p_saxv_tbl saxv_tbl_type ) IS

TYPE Var45TabTyp IS TABLE OF Varchar2(45)
     INDEX BY BINARY_INTEGER;

Line: 3882


  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;

Line: 3883


  in_last_update_date              OKC_DATATYPES.DateTabTyp;

Line: 3884


  in_last_update_login             OKC_DATATYPES.NumberTabTyp;

Line: 3923


    in_last_updated_by               (j) := p_saxv_tbl(i).last_updated_by;

Line: 3924


    in_last_update_date              (j) := p_saxv_tbl(i).last_update_date;

Line: 3925


    in_last_update_login             (j) := p_saxv_tbl(i).last_update_login;

Line: 3932


              Insert into
              OKS_SERV_AVAIL_EXCEPTS
              (
                id
               , sav_id
               , object1_id1
               , object1_id2
               , jtot_object1_code
               , manufacturing_org_id
               , revision_low
               , revision_high
               , start_date_active
               , end_date_active
               , object_version_number
               , attribute_category
               , attribute1
               , attribute2
               , attribute3
               , attribute4
               , attribute5
               , attribute6
               , attribute7
               , attribute8
               , attribute9
               , attribute10
               , attribute11
               , attribute12
               , attribute13
               , attribute14
               , attribute15
               , created_by
               , creation_date
               , last_updated_by
               , last_update_date
               , last_update_login
              )
              Values
              (
                 in_id(i),
                 in_sav_id(i),
                 in_object1_id1(i),
                 in_object1_id2(i),
                 in_jtot_object1_code(i),
                 in_manufacturing_org_id(i),
                 in_revision_low(i),
                 in_revision_high(i),
                 in_start_date_active(i),
                 in_end_date_active(i),
                 in_object_version_number(i),
                 in_attribute_category(i),
                 in_attribute1(i),
                 in_attribute2(i),
                 in_attribute3(i),
                 in_attribute4(i),
                 in_attribute5(i),
                 in_attribute6(i),
                 in_attribute7(i),
                 in_attribute8(i),
                 in_attribute9(i),
                 in_attribute10(i),
                 in_attribute11(i),
                 in_attribute12(i),
                 in_attribute13(i),
                 in_attribute14(i),
                 in_attribute15(i),
                 in_created_by(i),
                 in_creation_date(i),
                 in_last_updated_by(i),
                 in_last_update_date(i),
                 in_last_update_login(i)
              );

Line: 4006


END INSERT_ROW_UPG;