APPS.OKL_SETUPPOVALUES_PVT SQL Statements

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

Line: 18

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            OVE_ID,
            PON_ID,
            FROM_DATE,
            CREATED_BY,
            TO_DATE,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Pdt_Opt_Vals_V
     WHERE okl_pdt_opt_vals_v.id = p_id;

Line: 48

              l_povv_rec.LAST_UPDATED_BY,
              l_povv_rec.LAST_UPDATE_DATE,
              l_povv_rec.LAST_UPDATE_LOGIN;

Line: 84

    SELECT  FROM_DATE,
            TO_DATE
     FROM Okl_pdt_opts_V ponv
     WHERE ponv.id = p_pon_id;

Line: 136

    SELECT '1' FROM okl_pdt_opts_v     ponv,
					okl_k_headers_v    khdr
    WHERE ponv.id = p_pon_id AND
	      khdr.pdt_id = ponv.pdt_id;

Line: 144

    SELECT '1'
    FROM Okl_products_V pdt,
     	 Okl_pdt_opts_V pon
    WHERE pdt.id = pon.pdt_id
	AND pon.ID    = p_pon_id
    AND   NVL(pdt.TO_DATE, p_date) < p_date;

Line: 155

    SELECT '1'
    FROM Okl_Opt_Values_V ove
     WHERE ove.ID        = p_ove_id
	 AND   ((ove.FROM_DATE > p_from_date OR
            p_from_date > NVL(ove.TO_DATE,p_from_date)) OR
	 	    NVL(ove.TO_DATE, p_to_date) < p_to_date);

Line: 163

    SELECT '1'
       FROM OKL_PDT_OPT_VALS_V
      WHERE OKL_PDT_OPT_VALS_V.OVE_ID =  p_unique1 AND
            OKL_PDT_OPT_VALS_V.PON_ID =  p_unique2 AND
            OKL_PDT_OPT_VALS_V.ID <> NVL(p_povv_rec.id,-9999);

Line: 333

    SELECT ID
       FROM OKL_OPT_VALUES_V
      WHERE OKL_OPT_VALUES_V.ID =  p_foreign;

Line: 440

 PROCEDURE insert_povalues(p_api_version       IN  NUMBER,
 		   			       p_init_msg_list     IN  VARCHAR2 DEFAULT Okl_Api.G_FALSE,
                           x_return_status     OUT NOCOPY VARCHAR2,
                           x_msg_count         OUT NOCOPY NUMBER,
                           x_msg_data          OUT NOCOPY VARCHAR2,
                           p_pdtv_rec          IN  pdtv_rec_type,
						   p_optv_rec          IN  optv_rec_type,
                           p_povv_rec          IN  povv_rec_type,
                           x_povv_rec          OUT NOCOPY povv_rec_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 451

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

Line: 525

    /* public api to insert povalues */

    Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_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_povv_rec      => l_povv_rec,
                       		 	             x_povv_rec      => x_povv_rec);

Line: 567

  END insert_povalues;

Line: 573

  PROCEDURE delete_povalues(
                         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_pdtv_rec                     IN  pdtv_rec_type
                        ,p_optv_rec                     IN  optv_rec_type
						,p_povv_tbl                     IN  povv_tbl_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 585

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

Line: 612

    /* check if the product asked to delete is used by contracts if yes halt the process*/

	IF (l_povv_tbl.COUNT > 0) THEN
      i := l_povv_tbl.FIRST;

Line: 642

    /* delete product option values */
    Okl_Pdt_Opt_Vals_Pub.delete_pdt_opt_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_povv_tbl      => l_povv_tbl);

Line: 682

  END delete_povalues;