APPS.OKL_TRANS_PRICING_PARAMS_PVT SQL Statements

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

Line: 45

         l_update_yn                          okl_st_gen_prc_params.update_yn%TYPE;

Line: 51

         SELECT pp.id, pp.name, pp.display_yn,pp.update_yn,
         pp.default_value, pp.prc_eng_ident, pp.description
         FROM okl_st_gen_tmpt_sets temp_set,
         okl_st_gen_templates template,
         okl_st_gen_prc_params pp
         WHERE temp_set.id = template.gts_id
         AND   template.id = pp.gtt_id
         AND   temp_set.id = p_gts_id;

Line: 61

         SELECT TST.ID  GTS_ID
         FROM OKL_ST_GEN_TMPT_SETS TST,
         OKL_AE_TMPT_SETS_V AES,
         OKL_PRODUCTS_V PDT,
         OKL_K_HEADERS KHR
         WHERE TST.ID = AES.GTS_ID AND
         AES.ID = PDT.AES_ID AND
         PDT.ID = KHR.PDT_ID AND
         KHR.ID =p_chr_id;

Line: 75

  delete_pricing_params(l_chr_id,x_return_status);

Line: 110

      FETCH st_gen_prc_params INTO l_id, l_name,l_display_yn,l_update_yn,
                                   l_default_value,l_prc_eng_ident,l_description;

Line: 114

      IF (l_display_yn = 'Y' AND l_update_yn = 'Y')
      THEN
        l_found := 'N';

Line: 146

      l_spmv_tbl(j).update_yn := l_update_yn;

Line: 155

    OKL_SPM_PVT.insert_row(p_api_version      => l_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_spmv_tbl         =>l_spmv_tbl);

Line: 172

PROCEDURE delete_pricing_params(
                   p_chr_id                  IN NUMBER
                  ,x_return_status           OUT NOCOPY VARCHAR2)
IS
BEGIN
  DELETE FROM OKL_SIF_PRICING_PARAMS
  WHERE khr_ID = p_chr_id
  AND sif_id IS NULL;

Line: 187

END delete_pricing_params;