APPS.OKL_SPLIT_ASSET_COMP_PVT SQL Statements

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

Line: 43

  SELECT a.id,
         a.SPLIT_PERCENT
  FROM okl_txd_assets_v a
  WHERE TAL_ID = p_tal_id
  ;

Line: 51

  SELECT ORIGINAL_COST,
         CURRENT_UNITS
  FROM okl_txl_assets_b
  WHERE id = p_tal_id
  ;

Line: 104

      Okl_Asd_Pvt.update_row(p_api_version,
                            p_init_msg_list,
                            x_return_status,
                            x_msg_count,
                            x_msg_data,
                            l_asdv_rec,
                            x_asdv_rec);

Line: 415

  SELECT NVL(SUM(SPLIT_PERCENT),0)
  FROM okl_txd_assets_v
  WHERE TAL_ID = p_tal_id
  ;

Line: 466

  SELECT asset_number
  FROM okl_txd_assets_v
  WHERE TAL_ID = p_tal_id
  GROUP BY asset_number
  HAVING COUNT(1) > 1
  ;

Line: 475

  SELECT asset_number
  FROM   okl_txd_assets_v
  WHERE  id = p_asd_id;

Line: 481

    SELECT 'Y'
    FROM   okx_assets_v okx
    WHERE  okx.asset_number = p_asset_number;

Line: 487

    SELECT 'Y'
    FROM   okl_k_lines_full_v kle,
           okc_line_styles_b  lse
    WHERE  kle.name = p_asset_number
    AND    kle.lse_id = lse.id
    AND    lse.lty_code = 'FIXED_ASSET';

Line: 498

   SELECT 'Y'
   FROM   okl_txl_assets_b txl
   WHERE  txl.asset_number = p_asset_number
   AND    txl.tal_type IN ('ALI','CRB'); --only transactions apart from split which create a new line

Line: 632

  SELECT inventory_item_id
  FROM okl_txd_assets_v
  WHERE TAL_ID = p_tal_id
  GROUP BY inventory_item_id
  HAVING COUNT(1) > 1
  ;

Line: 642

  SELECT i.name
  FROM okx_system_items_v i
  WHERE i.ID1 = p_inventory_item_id
  --group by i.name
  ;

Line: 778

		SELECT cleb.dnz_chr_id
		      ,cleb.id cle_id
              ,trxa.date_trans_occurred
		FROM okl_trx_assets trxa
		    ,okl_txl_assets_b txla
		    ,okc_k_lines_b cleb
			,okc_line_styles_b lseb
		WHERE txla.kle_id = cleb.id
		AND cleb.lse_id = lseb.id
		AND lseb.lty_code = 'FIXED_ASSET'
		AND txla.tal_type = 'ALI'
		AND txla.tas_id = trxa.id
		AND trxa.tsu_code = 'ENTERED'
		AND txla.id = p_tal_id;

Line: 868

        Okl_Asd_Pvt.insert_row(p_api_version,
                           p_init_msg_list,
                           x_return_status,
                           x_msg_count,
                           x_msg_data,
                           l_asdv_rec,
                           --p_asdv_tbl(i),
                           x_asdv_tbl(i));

Line: 961

   PROCEDURE update_split_asset_comp(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_asdv_tbl                     IN advv_tbl_type,
     x_asdv_tbl                     OUT NOCOPY advv_tbl_type)
     IS

     l_api_version     CONSTANT NUMBER       := 1.0;

Line: 972

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

Line: 981

  SAVEPOINT update_split_asset_comp_pvt;

Line: 1020

        Okl_Asd_Pvt.update_row(p_api_version,
                            p_init_msg_list,
                            x_return_status,
                            x_msg_count,
                            x_msg_data,
                            l_asdv_rec,
                            --p_asdv_tbl(i),
                            x_asdv_tbl(i));

Line: 1067

    ROLLBACK TO update_split_asset_comp_pvt;

Line: 1074

    ROLLBACK TO update_split_asset_comp_pvt;

Line: 1081

	ROLLBACK TO update_split_asset_comp_pvt;

Line: 1093

   END update_split_asset_comp;

Line: 1097

   PROCEDURE delete_split_asset_comp(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_asdv_tbl                     IN advv_tbl_type)
     IS

     l_api_version     CONSTANT NUMBER       := 1.0;

Line: 1107

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

Line: 1111

  SAVEPOINT delete_split_asset_comp_pvt;

Line: 1132

     Okl_Asd_Pvt.delete_row(p_api_version,
                            p_init_msg_list,
                            x_return_status,
                            x_msg_count,
                            x_msg_data,
                            p_asdv_tbl);

Line: 1154

    ROLLBACK TO delete_split_asset_comp_pvt;

Line: 1161

    ROLLBACK TO delete_split_asset_comp_pvt;

Line: 1168

	ROLLBACK TO delete_split_asset_comp_pvt;

Line: 1180

   END delete_split_asset_comp;

Line: 1195

  SELECT NVL(SUM(SPLIT_PERCENT),0)
  FROM okl_txd_assets_v
  WHERE TAL_ID = p_tal_id
  ;

Line: 1249

     SELECT cle.cle_id
     FROM   okc_k_lines_b cle,
            okl_txl_assets_b tal
     WHERE  cle.id = tal.kle_id
     AND    tal.id = p_tal_id;

Line: 1266

      SELECT cleb.dnz_chr_id
            ,cleb.cle_id cle_id
            ,trxa.date_trans_occurred
      FROM okl_trx_assets trxa
          ,okl_txl_assets_b txla
          ,okc_k_lines_b cleb
          ,okc_line_styles_b lseb
      WHERE txla.kle_id = cleb.id
      AND cleb.lse_id = lseb.id
      AND lseb.lty_code = 'FIXED_ASSET'
      AND txla.tal_type = 'ALI'
      AND txla.tas_id = trxa.id
      AND trxa.tsu_code = 'ENTERED'
      AND txla.id = p_tal_id;