APPS.OKL_SETUPOVERULES_PVT SQL Statements

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

Line: 15

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
			ORL_ID,
            OVE_ID,
            COPY_OR_ENTER_FLAG,
            CONTEXT_INTENT,
            CONTEXT_ORG,
            CONTEXT_INV_ORG,
            CONTEXT_ASSET_BOOK,
			NVL(INDIVIDUAL_INSTRUCTIONS,Okl_Api.G_MISS_CHAR) INDIVIDUAL_INSTRUCTIONS,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
     FROM Okl_Opv_Rules_V
     WHERE Okl_Opv_Rules_V.id    = p_id;

Line: 54

              l_ovdv_rec.LAST_UPDATED_BY,
              l_ovdv_rec.LAST_UPDATE_DATE,
              l_ovdv_rec.LAST_UPDATE_LOGIN;

Line: 91

	SELECT '1'
    FROM Okl_Opt_Values_V ove,
         Okl_Opt_Rules_V orl,
         Okl_Lse_Scs_Rules_V lsr
    WHERE orl.ID     = p_orl_id
    AND   ove.ID     = p_ove_id
    AND ((orl.LRG_LSE_ID IS NOT NULL
         AND lsr.LSE_ID = orl.LRG_LSE_ID
         AND lsr.SRD_ID = orl.LRG_SRD_ID)
         OR
         (orl.LRG_LSE_ID IS NULL
         AND lsr.LSE_ID IS NULL
         AND lsr.SRD_ID = orl.SRD_ID_FOR))
    AND lsr.RULE_GROUP = orl.RGR_RGD_CODE
    AND lsr.RULE = orl.RGR_RDF_CODE
    AND (lsr.START_DATE > ove.FROM_DATE OR
	     NVL(lsr.END_DATE, NVL(ove.TO_DATE, Okl_Api.G_MISS_DATE)) < NVL(ove.TO_DATE, Okl_Api.G_MISS_DATE));

Line: 111

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

Line: 120

    SELECT '1'
    FROM Okl_opt_values_V ove
    WHERE ove.ID    = p_ove_id
    AND   NVL(ove.TO_DATE, p_date) < p_date;

Line: 128

    SELECT '1'
    FROM Okl_Ovd_Rul_Tmls_V ovt
    WHERE ovt.OVD_ID    = p_ovd_id;

Line: 138

    SELECT '1'
    FROM okl_opv_rules_v
    WHERE  orl_id = p_orl_id
    AND    ove_id = p_ove_id
    AND    context_intent = p_context_intent
    AND    (context_org IS NULL OR context_org = p_context_org)
    AND    (context_inv_org IS NULL OR context_inv_org = p_context_inv_org)
    AND    (context_asset_book IS NULL OR context_asset_book = p_context_asset_book);

Line: 351

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

Line: 616

  PROCEDURE insert_overules(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,
                        	x_ovdv_rec       OUT NOCOPY ovdv_rec_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 627

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

Line: 671

	/* public api to insert option value rules */
    Okl_Option_Rules_Pub.create_option_val_rules(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_ovdv_rec      => l_ovdv_rec,
                              		 	   	     x_ovdv_rec      => x_ovdv_rec);

Line: 710

  END insert_overules;

Line: 716

  PROCEDURE delete_overules(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_tbl             IN  ovdv_tbl_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 727

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

Line: 772

	/* public api to delete option value rules */
    Okl_Option_Rules_Pub.delete_option_val_rules(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_ovdv_tbl      => l_ovdv_tbl);

Line: 811

  END delete_overules;