DBA Data[Home] [Help]

APPS.OKC_MRD_PVT SQL Statements

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

Line: 25

  	  select 'x'
	  from OKC_OPERATION_INSTANCES
  	  where id = p_mrdv_rec.oie_id;
Line: 89

  	  select 'x'
	  from OKC_OPERATION_LINES
  	  where id = p_mrdv_rec.ole_id;
Line: 260

    SELECT
            ID,
            OIE_ID,
            OLE_ID,
            ATTRIBUTE_NAME,
            OLD_VALUE,
            NEW_VALUE,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
		  LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Masschange_Req_Dtls
     WHERE okc_masschange_req_dtls.id = p_id;
Line: 291

		    l_mrd_rec.LAST_UPDATED_BY,
              l_mrd_rec.LAST_UPDATE_DATE,
              l_mrd_rec.LAST_UPDATE_LOGIN;
Line: 314

    SELECT
            ID,
            OIE_ID,
            OLE_ID,
            ATTRIBUTE_NAME,
            OLD_VALUE,
            NEW_VALUE,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
		  LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Masschange_Req_Dtls_V
     WHERE okc_masschange_req_dtls_v.id = p_id;
Line: 345

		    l_mrdv_rec.LAST_UPDATED_BY,
              l_mrdv_rec.LAST_UPDATE_DATE,
              l_mrdv_rec.LAST_UPDATE_LOGIN;
Line: 393

    IF (l_mrdv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_mrdv_rec.last_updated_by := NULL;
Line: 396

    IF (l_mrdv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_mrdv_rec.last_update_date := NULL;
Line: 399

    IF (l_mrdv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_mrdv_rec.last_update_login := NULL;
Line: 499

    p_to.last_updated_by := p_from.last_updated_by;
Line: 500

    p_to.last_update_date := p_from.last_update_date;
Line: 501

    p_to.last_update_login := p_from.last_update_login;
Line: 517

    p_to.last_updated_by := p_from.last_updated_by;
Line: 518

    p_to.last_update_date := p_from.last_update_date;
Line: 519

    p_to.last_update_login := p_from.last_update_login;
Line: 682

  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_mrd_rec                      IN mrd_rec_type,
    x_mrd_rec                      OUT NOCOPY mrd_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 691

    l_api_name                     CONSTANT VARCHAR2(30) := 'DTLS_insert_row';
Line: 727

    INSERT INTO OKC_MASSCHANGE_REQ_DTLS(
        id,
        oie_id,
        ole_id,
        attribute_name,
        old_value,
        new_value,
        object_version_number,
        created_by,
        creation_date,
	   last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_mrd_rec.id,
        l_mrd_rec.oie_id,
        l_mrd_rec.ole_id,
        l_mrd_rec.attribute_name,
        l_mrd_rec.old_value,
        l_mrd_rec.new_value,
        l_mrd_rec.object_version_number,
        l_mrd_rec.created_by,
        l_mrd_rec.creation_date,
	   l_mrd_rec.last_updated_by,
        l_mrd_rec.last_update_date,
        l_mrd_rec.last_update_login);
Line: 787

  END insert_row;
Line: 791

  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_mrdv_rec                     IN mrdv_rec_type,
    x_mrdv_rec                     OUT NOCOPY mrdv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 801

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

	 l_mrdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 818

      l_mrdv_rec.LAST_UPDATE_DATE := l_mrdv_rec.CREATION_DATE;
Line: 819

      l_mrdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 883

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_mrd_rec,
      lx_mrd_rec
    );
Line: 931

  END insert_row;
Line: 935

  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_mrdv_tbl                     IN mrdv_tbl_type,
    x_mrdv_tbl                     OUT NOCOPY mrdv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 945

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

        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_mrdv_rec                     => p_mrdv_tbl(i),
          x_mrdv_rec                     => x_mrdv_tbl(i));
Line: 1007

  END insert_row;
Line: 1025

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_MASSCHANGE_REQ_DTLS
     WHERE ID = p_mrd_rec.id
       AND OBJECT_VERSION_NUMBER = p_mrd_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1032

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_MASSCHANGE_REQ_DTLS
    WHERE ID = p_mrd_rec.id;
Line: 1073

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1082

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 1278

  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_mrd_rec                      IN mrd_rec_type,
    x_mrd_rec                      OUT NOCOPY mrd_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1287

    l_api_name                     CONSTANT VARCHAR2(30) := 'DTLS_update_row';
Line: 1345

      IF (x_mrd_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_mrd_rec.last_updated_by := l_mrd_rec.last_updated_by;
Line: 1349

      IF (x_mrd_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_mrd_rec.last_update_date := l_mrd_rec.last_update_date;
Line: 1353

      IF (x_mrd_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_mrd_rec.last_update_login := l_mrd_rec.last_update_login;
Line: 1397

    UPDATE  OKC_MASSCHANGE_REQ_DTLS
    SET OIE_ID = l_def_mrd_rec.oie_id,
        OLE_ID = l_def_mrd_rec.ole_id,
        ATTRIBUTE_NAME = l_def_mrd_rec.attribute_name,
        OLD_VALUE = l_def_mrd_rec.old_value,
        NEW_VALUE = l_def_mrd_rec.new_value,
        OBJECT_VERSION_NUMBER = l_def_mrd_rec.object_version_number,
        CREATED_BY = l_def_mrd_rec.created_by,
        CREATION_DATE = l_def_mrd_rec.creation_date,
	   LAST_UPDATED_BY = l_def_mrd_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_mrd_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_mrd_rec.last_update_login
    WHERE ID = l_def_mrd_rec.id;
Line: 1444

  END update_row;
Line: 1448

  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_mrdv_rec                     IN mrdv_rec_type,
    x_mrdv_rec                     OUT NOCOPY mrdv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1458

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

      l_mrdv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1473

      l_mrdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1529

      IF (x_mrdv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_mrdv_rec.last_updated_by := l_mrdv_rec.last_updated_by;
Line: 1533

      IF (x_mrdv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_mrdv_rec.last_update_date := l_mrdv_rec.last_update_date;
Line: 1537

      IF (x_mrdv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_mrdv_rec.last_update_login := l_mrdv_rec.last_update_login;
Line: 1608

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_mrd_rec,
      lx_mrd_rec
    );
Line: 1655

  END update_row;
Line: 1659

  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_mrdv_tbl                     IN mrdv_tbl_type,
    x_mrdv_tbl                     OUT NOCOPY mrdv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1669

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

        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_mrdv_rec                     => p_mrdv_tbl(i),
          x_mrdv_rec                     => x_mrdv_tbl(i));
Line: 1730

  END update_row;
Line: 1738

  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_mrd_rec                      IN mrd_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1746

    l_api_name                     CONSTANT VARCHAR2(30) := 'DTLS_delete_row';
Line: 1760

    DELETE FROM OKC_MASSCHANGE_REQ_DTLS
     WHERE ID = l_mrd_rec.id;
Line: 1795

  END delete_row;
Line: 1799

  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_mrdv_rec                     IN mrdv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1808

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_mrd_rec
    );
Line: 1876

  END delete_row;
Line: 1880

  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_mrdv_tbl                     IN mrdv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1889

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

        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_mrdv_rec                     => p_mrdv_tbl(i));
Line: 1949

  END delete_row;