APPS.OKL_SETUPPQYVALUES_PVT SQL Statements

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

Line: 14

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            PQY_ID,
            VALUE,
            DESCRIPTION,
            FROM_DATE,
            TO_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Pqy_Values_V
     WHERE okl_pqy_values_v.id  = p_id;

Line: 46

              l_qvev_rec.LAST_UPDATED_BY,
              l_qvev_rec.LAST_UPDATE_DATE,
              l_qvev_rec.LAST_UPDATE_LOGIN;

Line: 82

    SELECT  FROM_DATE,
            TO_DATE
     FROM Okl_pdt_qualitys_V pqy
     WHERE pqy.id = p_pqy_id;

Line: 133

    SELECT '1'
    FROM   okl_pdt_qualitys_v pqyv
    WHERE  pqyv.ID = p_pqy_id
	AND   ((pqyv.FROM_DATE > p_from_date OR
		    p_from_date > NVL(pqyv.TO_DATE,p_from_date))
		   OR
	 	    NVL(pqyv.TO_DATE, p_to_date) < p_to_date);

Line: 145

    SELECT '1'
    FROM okl_pdt_pqy_vals_v pqvv
    WHERE  pqvv.qve_id = p_qve_id
		AND   (pqvv.FROM_DATE < p_from_date OR
	 	    NVL(pqvv.TO_DATE, pqvv.FROM_DATE) > p_to_date);

Line: 154

    SELECT '1'
       FROM OKL_PQY_VALUES_V
      WHERE OKL_PQY_VALUES_V.VALUE =  p_unique1 AND
            OKL_PQY_VALUES_V.PQY_ID =  p_unique2;

Line: 504

  PROCEDURE check_updates (
    p_upd_qvev_rec                 IN qvev_rec_type,
	p_db_qvev_rec				   IN qvev_rec_type,
	p_qvev_rec					   IN qvev_rec_type,
	x_return_status				   OUT NOCOPY VARCHAR2,
	x_msg_data					   OUT NOCOPY VARCHAR2
  ) IS
  l_qvev_rec	  qvev_rec_type;

Line: 586

  END check_updates;

Line: 615

  PROCEDURE insert_pqyvalues(
    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_pqyv_rec                     IN  pqyv_rec_type,
    p_qvev_rec                     IN  qvev_rec_type,
    x_qvev_rec                     OUT NOCOPY qvev_rec_type
    ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 626

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

Line: 700

     /* public api to insert PQYVALUES */

     Okl_Pdt_Qualitys_Pub.create_pdt_quality_vals(p_api_version   => p_api_version,
                        		                  p_init_msg_list => p_init_msg_list,
                               		              x_return_status => l_return_status,
                          		                  x_msg_count     => x_msg_count,
                              		              x_msg_data      => x_msg_data,
                             		              p_qvev_rec      => l_qvev_rec,
                              		              x_qvev_rec      => x_qvev_rec);

Line: 741

  END insert_pqyvalues;

Line: 746

  PROCEDURE update_pqyvalues(
     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_pqyv_rec                     IN  pqyv_rec_type,
     p_qvev_rec                     IN  qvev_rec_type,
     x_qvev_rec                     OUT NOCOPY qvev_rec_type
    ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 757

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

Line: 867

    /* public api to update pqyvalues */
    Okl_Pdt_Qualitys_Pub.update_pdt_quality_vals(p_api_version => p_api_version,
                              		 	   p_init_msg_list => p_init_msg_list,
                              		 	   x_return_status => l_return_status,
                              		 	   x_msg_count     => x_msg_count,
                              		 	   x_msg_data      => x_msg_data,
                              		 	   p_qvev_rec      => l_upd_qvev_rec,
                              		 	   x_qvev_rec      => x_qvev_rec);

Line: 887

    check_updates(p_upd_qvev_rec	 => l_upd_qvev_rec,
	   			     p_db_qvev_rec	 => l_db_qvev_rec,
					 p_qvev_rec		 => l_qvev_rec,
					 x_return_status => l_return_status,
					 x_msg_data		 => x_msg_data);

Line: 899

   /* public api to update pqyvalues */
    Okl_Pdt_Qualitys_Pub.update_pdt_quality_vals(p_api_version => p_api_version,
                              		 	   p_init_msg_list => p_init_msg_list,
                              		 	   x_return_status => l_return_status,
                              		 	   x_msg_count     => x_msg_count,
                              		 	   x_msg_data      => x_msg_data,
                              		 	   p_qvev_rec      => l_upd_qvev_rec,
                              		 	   x_qvev_rec      => x_qvev_rec);

Line: 942

  END update_pqyvalues;