APPS.OKL_SETUPOPTRULES_PVT SQL Statements

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

Line: 15

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
			OPT_ID,
            NVL(LRG_LSE_ID, Okl_Api.G_MISS_NUM) LRG_LSE_ID,
            NVL(LRG_SRD_ID, Okl_Api.G_MISS_NUM) LRG_SRD_ID,
			NVL(SRD_ID_FOR, Okl_Api.G_MISS_NUM) SRD_ID_FOR,
            RGR_RGD_CODE,
            RGR_RDF_CODE,
			NVL(OVERALL_INSTRUCTIONS,Okl_Api.G_MISS_CHAR) OVERALL_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_Opt_Rules_V
     WHERE okl_Opt_Rules_V.id    = p_id;

Line: 52

              l_orlv_rec.LAST_UPDATED_BY,
              l_orlv_rec.LAST_UPDATE_DATE,
              l_orlv_rec.LAST_UPDATE_LOGIN;

Line: 89

    SELECT '1'
    FROM Okl_Pdt_Opts_V pon
    WHERE pon.OPT_ID    = p_opt_id;

Line: 95

    SELECT '1'
    FROM Okl_Opv_Rules_V ovd
    WHERE ovd.ORL_ID    = p_orl_id;

Line: 102

    SELECT '1'
    FROM Okl_Options_V opt
    WHERE opt.ID    = p_opt_id
    AND   NVL(opt.TO_DATE, p_date) < p_date;

Line: 114

	SELECT '1'
    FROM Okl_Lse_Scs_Rules_V lsr,
         Okl_Options_V       opt
    WHERE opt.ID = p_opt_id
    AND  ((p_lrg_lse_id <> Okl_Api.G_MISS_NUM
         AND lsr.LSE_ID = p_lrg_lse_id
         AND lsr.SRD_ID = p_lrg_srd_id)
         OR
         (p_lrg_lse_id = Okl_Api.G_MISS_NUM
         AND lsr.LSE_ID IS NULL
         AND lsr.SRD_ID = p_srd_id_for))
    AND lsr.RULE_GROUP = p_rgr_rgd_code
    AND lsr.RULE = p_rgr_rdf_code
    AND (lsr.START_DATE > opt.FROM_DATE OR
	     NVL(lsr.END_DATE, NVL(opt.TO_DATE, Okl_Api.G_MISS_DATE)) < NVL(opt.TO_DATE, Okl_Api.G_MISS_DATE));

Line: 134

  SELECT '1'
  FROM okl_opt_rules_v
  WHERE  opt_id = p_opt_id
  AND    rgr_rgd_code = p_rgr_rgd_code
  AND	   rgr_rdf_code = rgr_rdf_code
  AND    srd_id_for = p_srd_id_for
  AND id <> NVL(p_orlv_rec.id,-9999);

Line: 147

  SELECT '1'
  FROM okl_opt_rules_v
  WHERE  opt_id = p_opt_id
  AND    rgr_rgd_code = p_rgr_rgd_code
  AND	   rgr_rdf_code = rgr_rdf_code
  AND    lrg_lse_id = p_lrg_lse_id
  AND    lrg_srd_id = p_lrg_srd_id
  AND id <> NVL(p_orlv_rec.id,-9999);

Line: 461

  PROCEDURE insert_optrules(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_orlv_rec       IN  orlv_rec_type,
                        	x_orlv_rec       OUT NOCOPY orlv_rec_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 471

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

Line: 514

	/* public api to insert option rules */
    Okl_Option_Rules_Pub.create_option_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_orlv_rec      => l_orlv_rec,
                              		 	   	 x_orlv_rec      => x_orlv_rec);

Line: 554

  END insert_optrules;

Line: 560

  PROCEDURE delete_optrules(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_orlv_tbl             IN  orlv_tbl_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 570

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

Line: 615

	/* delete option rules */
    Okl_Option_Rules_Pub.delete_option_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_orlv_tbl      => l_orlv_tbl);

Line: 654

  END delete_optrules;