APPS.OKL_VP_COPY_CONTRACT_PVT SQL Statements

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

Line: 35

    SELECT 	id
    FROM 		okc_governances_v
    WHERE 	dnz_chr_id = p_from_chr_id
    AND		cle_id is null;

Line: 50

      SELECT DNZ_CHR_ID,
             ISA_AGREEMENT_ID,
             CHR_ID,
             CLE_ID,
             CHR_ID_REFERRED,
             CLE_ID_REFERRED,
             COPIED_ONLY_YN
        FROM OKC_GOVERNANCES
       WHERE ID = p_gve_id;

Line: 146

    SELECT template_yn
    FROM okc_k_headers_b
    WHERE id = p_chr_id;

Line: 151

    SELECT count(*)
    FROM okc_k_headers_b
    WHERE template_yn = 'Y'
	AND sysdate between start_date and nvl(end_date, sysdate)
	AND id = p_chr_id;

Line: 218

  SELECT contract_number,sts_code,authoring_org_id FROM okc_k_headers_v
  WHERE id=p_id;

Line: 223

  SELECT id
  FROM okc_governances_v
  WHERE dnz_chr_id = p_from_chr_id;

Line: 228

  SELECT 'x'
  FROM okc_k_headers_b
  WHERE contract_number = contract_no
  AND   contract_number_modifier = contract_no_modifier;

Line: 234

  SELECT id FROM okc_k_processes WHERE chr_id = p_chr_id;

Line: 240

  SELECT id
  FROM okl_vp_associations
  WHERE chr_id = p_chr_id
  AND crs_id IS NULL;

Line: 247

  SELECT rle.id,
         rle.rgp_id,
         rle.dnz_chr_id,
         rle.std_template_yn,
         rle.warn_yn,
         rle.rule_information_category,
         prl.id rule_information1,
         rle.rule_information2,
         rle.template_yn,
         rle.comments,
         rlg.rgd_code
  FROM okc_rules_b rle,
       okc_k_party_roles_b prl,
       okc_k_party_roles_b prl1,
       okc_rule_groups_b rlg
  WHERE rle.dnz_chr_id = cp_chr_id
  AND   prl.dnz_chr_id = cp_chr_id
  AND   prl.rle_code = prl1.rle_code
  AND   prl1.id = rle.rule_information1
  AND   rle.rule_information_category = 'VGLRSP'
  AND   rle.rgp_id = rlg.id;

Line: 272

  SELECT start_date
        ,end_date
  FROM okc_k_headers_b
  WHERE id = cp_chr_id;

Line: 279

   SELECT id FROM okc_k_party_roles_v
   WHERE chr_id = contract_id
   AND   rle_code = 'OKL_VENDOR';

Line: 389

	 OKL_KPL_PVT.insert_row(
	      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_kplv_rec        => l_kplv_rec,
	      x_kplv_rec        => x_kplv_rec);

Line: 561

         OKC_CONTRACT_PUB.update_contract_header(
                          p_api_version	=> l_api_version,
                          x_return_status	=> x_return_status,
                          p_init_msg_list     => OKL_API.G_TRUE,
                          x_msg_count		=> x_msg_count,
                          x_msg_data		=> x_msg_data,
                          p_restricted_update	=> OKL_API.G_FALSE,
                          p_chrv_rec		=> l1_header_rec,
                          x_chrv_rec		=> l2_header_rec);

Line: 586

             OKC_CONTRACT_PVT.delete_contract_process(
                            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_cpsv_rec		=> l_cpsv_rec);