APPS.OKL_SETUPOVDTEMPLATES_PVT SQL Statements

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

Line: 14

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
			OVD_ID,
            RUL_ID,
            SEQUENCE_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
     FROM Okl_Ovd_Rul_Tmls_V
     WHERE Okl_Ovd_Rul_Tmls_V.id    = p_id;

Line: 43

              l_ovtv_rec.LAST_UPDATED_BY,
              l_ovtv_rec.LAST_UPDATE_DATE,
              l_ovtv_rec.LAST_UPDATE_LOGIN;

Line: 125

    SELECT '1'
    FROM Okl_Opv_Rules_V ovd,
         Okl_Pdt_Opt_Vals_V pov,
         Okl_Slctd_Optns_V csp
    WHERE ovd.ID        = p_ovd_id
    AND   pov.OVE_ID    = ovd.OVE_ID
    AND   csp.POV_ID    = pov.ID;

Line: 135

	SELECT orl.RGR_RGD_CODE RGR_RGD_CODE,
           orl.RGR_RDF_CODE RGR_RDF_CODE,
           NVL(ovd.CONTEXT_INTENT, Okl_Api.G_MISS_CHAR) CONTEXT_INTENT,
           NVL(ovd.CONTEXT_ORG, Okl_Api.G_MISS_NUM) CONTEXT_ORG,
           NVL(ovd.CONTEXT_INV_ORG, Okl_Api.G_MISS_NUM) CONTEXT_INV_ORG,
           NVL(ovd.CONTEXT_ASSET_BOOK, Okl_Api.G_MISS_CHAR) CONTEXT_ASSET_BOOK,
           ove.FROM_DATE FROM_DATE,
           NVL(ove.TO_DATE, Okl_Api.G_MISS_DATE) TO_DATE
    FROM Okl_Opv_Rules_V ovd,
         Okl_Opt_Rules_V orl,
         Okl_Opt_Values_V ove
    WHERE ovd.ID     = p_ovd_id
    AND   orl.ID     = ovd.ORL_ID
    AND   ove.ID     = ovd.OVE_ID;

Line: 158

	SELECT '1'
    FROM Okc_Rule_Def_Sources_V  rds
    WHERE rds.RGR_RGD_CODE = p_rgd_code
    AND   rds.RGR_RDF_CODE = p_rdf_code
    AND   rds.OBJECT_ID_NUMBER = p_object_id_number
    AND   rds.JTOT_OBJECT_CODE = p_jtot_object_code
    AND   rds.BUY_OR_SELL = p_buy_or_sell
    AND (rds.START_DATE > p_from_date OR
         NVL(rds.END_DATE, Okl_Api.G_MISS_DATE) < p_to_date);

Line: 405

  PROCEDURE insert_ovdtemplates(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_optv_rec       IN  optv_rec_type,
                        	        p_ovev_rec       IN  ovev_rec_type,
                                    p_ovdv_rec       IN  ovdv_rec_type,
                                    p_ovtv_rec       IN  ovtv_rec_type,
                        	        x_ovtv_rec       OUT NOCOPY ovtv_rec_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 417

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

Line: 456

	/* public api to insert option value rule templates */
    Okl_Ovd_Rul_Tmls_Pub.insert_ovd_rul_tmls(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_ovtv_rec      => l_ovtv_rec,
                              		 	   	 x_ovtv_rec      => x_ovtv_rec);

Line: 496

  END insert_ovdtemplates;

Line: 502

  PROCEDURE delete_ovdtemplates(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_optv_rec             IN  optv_rec_type,
                                    p_ovev_rec             IN  ovev_rec_type,
                        	        p_ovdv_rec             IN  ovdv_rec_type,
                                    p_ovtv_tbl             IN  ovtv_tbl_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 517

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

Line: 571

                 Okl_Rule_Pub.delete_rule(p_api_version   => p_api_version
                                        ,p_init_msg_list  => p_init_msg_list
                                        ,x_return_status  => x_return_status
                                        ,x_msg_count      => x_msg_count
                                        ,x_msg_data       => x_msg_data
                                        ,p_rulv_rec       => l_rulv_tbl(i)
                                        );

Line: 603

	/* public api to delete option value rules */
    Okl_Ovd_Rul_Tmls_Pub.delete_ovd_rul_tmls(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_ovtv_tbl      => l_ovtv_tbl);

Line: 642

  END delete_ovdtemplates;