APPS.OKL_SETUPPSTYPES_PVT SQL Statements

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

Line: 14

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            STY_ID,
            PDT_ID,
            ACCRUAL_YN,
            FROM_DATE,
            TO_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
     FROM Okl_Prod_Strm_Types_V
     WHERE Okl_Prod_Strm_Types_V.id = p_id;

Line: 46

              l_psyv_rec.LAST_UPDATED_BY,
              l_psyv_rec.LAST_UPDATE_DATE,
              l_psyv_rec.LAST_UPDATE_LOGIN;

Line: 81

    SELECT  FROM_DATE,
            TO_DATE
     FROM Okl_products_V pdtv
     WHERE pdtv.id = p_pdt_id;

Line: 134

    SELECT '1' FROM okl_k_headers_v khdr
    WHERE khdr.pdt_id = p_pdt_id;

Line: 140

    SELECT '1'
    FROM Okl_products_V pdt
    WHERE pdt.ID    = p_pdt_id
    AND   NVL(pdt.TO_DATE, p_date) < p_date;

Line: 149

    SELECT '1'
    FROM Okl_Strm_Type_V sty
     WHERE sty.ID  = p_sty_id
	 AND   ((sty.START_DATE > p_from_date OR
            p_from_date > NVL(sty.END_DATE,p_from_date)) OR
	 	    NVL(sty.END_DATE, p_to_date) < p_to_date);

Line: 158

  SELECT '1'
  FROM okl_prod_strm_types_v
  WHERE  pdt_id = p_pdt_id
  AND    sty_id = p_sty_id
  AND id <> NVL(p_psyv_rec.id,-9999);

Line: 290

      SELECT  '1'
      FROM okl_strm_type_v
      WHERE okl_strm_type_v.id = p_id;

Line: 379

  PROCEDURE insert_pstypes(
    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_psyv_rec                     IN  psyv_rec_type,
    x_psyv_rec                     OUT NOCOPY psyv_rec_type
    ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 390

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

Line: 462

	/* public api to insert pstypes */

    Okl_Pdt_Stys_Pub.insert_pdt_stys(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_psyv_rec      => l_psyv_rec,
                              		 x_psyv_rec      => x_psyv_rec);

Line: 503

  END insert_pstypes;

Line: 508

  PROCEDURE update_pstypes(
    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_psyv_rec                     IN  psyv_rec_type,
    x_psyv_rec                     OUT NOCOPY psyv_rec_type
    ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 519

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

Line: 583

	/* public api to update pstypes */

    Okl_Pdt_Stys_Pub.update_pdt_stys(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_psyv_rec      => l_psyv_rec,
                              		 	   x_psyv_rec      => x_psyv_rec);

Line: 624

  END update_pstypes;