DBA Data[Home] [Help]

APPS.OKC_CONTRACT_PUB SQL Statements

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

Line: 245

  PROCEDURE update_contract_header(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_restricted_update			IN VARCHAR2 ,
    p_chrv_rec                     IN chrv_rec_type,
    x_chrv_rec                     OUT NOCOPY chrv_rec_type) IS

    l_chrv_rec		chrv_rec_type;
Line: 256

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
Line: 300

    OKC_CONTRACT_PVT.update_contract_header(
	 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_restricted_update	=> p_restricted_update,
      p_chrv_rec			=> l_chrv_rec,
      x_chrv_rec			=> x_chrv_rec);
Line: 363

  END update_contract_header;
Line: 365

  PROCEDURE update_contract_header(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_restricted_update			IN VARCHAR2 ,
    p_chrv_tbl                     IN chrv_tbl_type,
    x_chrv_tbl                     OUT NOCOPY chrv_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
Line: 403

		OKC_CONTRACT_PUB.update_contract_header(
			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_restricted_update => p_restricted_update,
			p_chrv_rec		=> p_chrv_tbl(i),
			x_chrv_rec		=> x_chrv_tbl(i));
Line: 463

  END update_contract_header;
Line: 465

  PROCEDURE update_contract_header(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_restricted_update		   IN VARCHAR2 ,
    p_chrv_rec                     IN chrv_rec_type,
    p_control_rec                  IN control_rec_type,
    x_chrv_rec                     OUT NOCOPY chrv_rec_type) IS

    l_chrv_rec		chrv_rec_type;
Line: 477

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
Line: 521

    OKC_CONTRACT_PVT.update_contract_header(
      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_restricted_update	=> p_restricted_update,
      p_chrv_rec			=> l_chrv_rec,
      p_control_rec           => p_control_rec,
      x_chrv_rec			=> x_chrv_rec);
Line: 585

  END update_contract_header;
Line: 587

  PROCEDURE update_contract_header(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_restricted_update			IN VARCHAR2 ,
    p_chrv_tbl                     IN chrv_tbl_type,
    p_control_rec			     IN control_rec_type,
    x_chrv_tbl                     OUT NOCOPY chrv_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
Line: 626

		OKC_CONTRACT_PUB.update_contract_header(
			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_restricted_update => p_restricted_update,
			p_chrv_rec		=> p_chrv_tbl(i),
                  	p_control_rec	=> p_control_rec,
			x_chrv_rec		=> x_chrv_tbl(i));
Line: 687

  END update_contract_header;
Line: 689

  PROCEDURE delete_contract_header(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_chrv_rec                     IN chrv_rec_type) IS

    l_chrv_rec		chrv_rec_type;
Line: 698

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';
Line: 742

    OKC_CONTRACT_PVT.delete_contract_header(
	 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_chrv_rec		=> l_chrv_rec);
Line: 800

  END delete_contract_header;
Line: 802

  PROCEDURE delete_contract_header(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_chrv_tbl                     IN chrv_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';
Line: 838

		OKC_CONTRACT_PUB.delete_contract_header(
			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_chrv_rec		=> p_chrv_tbl(i));
Line: 896

  END delete_contract_header;
Line: 1322

    p_restricted_update			IN VARCHAR2 ,
    p_clev_rec                     IN  clev_rec_type,
    x_clev_rec                     OUT NOCOPY  clev_rec_type) IS

    l_clev_rec		clev_rec_type;
Line: 1377

      p_restricted_update=> p_restricted_update,
      p_clev_rec		=> l_clev_rec,
      x_clev_rec		=> x_clev_rec);
Line: 1439

    p_restricted_update			IN VARCHAR2 ,
    p_clev_tbl                     IN  clev_tbl_type,
    x_clev_tbl                     OUT NOCOPY  clev_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_LINE';
Line: 1477

               p_restricted_update	=> p_restricted_update,
			p_clev_rec		=> p_clev_tbl(i),
			x_clev_rec		=> x_clev_tbl(i));
Line: 1533

  PROCEDURE update_contract_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_restricted_update			IN VARCHAR2 ,
    p_clev_rec                     IN clev_rec_type,
    x_clev_rec                     OUT NOCOPY clev_rec_type) IS

    l_clev_rec		clev_rec_type;
Line: 1544

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';
Line: 1588

    OKC_CONTRACT_PVT.update_contract_line(
	 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_restricted_update	=> p_restricted_update,
      p_clev_rec			=> l_clev_rec,
      x_clev_rec			=> x_clev_rec);
Line: 1648

  END update_contract_line;
Line: 1650

  PROCEDURE update_contract_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_restricted_update			IN VARCHAR2 ,
    p_clev_tbl                     IN clev_tbl_type,
    x_clev_tbl                     OUT NOCOPY clev_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';
Line: 1688

		OKC_CONTRACT_PUB.update_contract_line(
			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_restricted_update => p_restricted_update,
			p_clev_rec		=> p_clev_tbl(i),
			x_clev_rec		=> x_clev_tbl(i));
Line: 1748

  END update_contract_line;
Line: 1750

  PROCEDURE delete_contract_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_clev_rec                     IN clev_rec_type) IS

    l_clev_rec		clev_rec_type;
Line: 1759

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';
Line: 1803

    OKC_CONTRACT_PVT.delete_contract_line(
	 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_clev_rec		=> l_clev_rec);
Line: 1861

  END delete_contract_line;
Line: 1863

  PROCEDURE delete_contract_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_clev_tbl                     IN clev_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';
Line: 1899

		OKC_CONTRACT_PVT.delete_contract_line(
			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_clev_rec		=> p_clev_tbl(i));
Line: 1957

  END delete_contract_line;
Line: 1959

  PROCEDURE delete_contract_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_line_id                      IN NUMBER) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';
Line: 1970

	OKC_CONTRACT_PVT.delete_contract_line(
		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_line_id		     => p_line_id);
Line: 1988

  END delete_contract_line;
Line: 2621

  PROCEDURE update_governance(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_gvev_rec                     IN gvev_rec_type,
    x_gvev_rec                     OUT NOCOPY gvev_rec_type) IS

    l_gvev_rec		gvev_rec_type;
Line: 2631

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_GOVERNANCE';
Line: 2675

    OKC_CONTRACT_PVT.update_governance(
	 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_gvev_rec		=> l_gvev_rec,
      x_gvev_rec		=> x_gvev_rec);
Line: 2734

  END update_governance;
Line: 2736

  PROCEDURE update_governance(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_gvev_tbl                     IN gvev_tbl_type,
    x_gvev_tbl                     OUT NOCOPY gvev_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_GOVERNANCE';
Line: 2773

		OKC_CONTRACT_PUB.update_governance(
			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_gvev_rec		=> p_gvev_tbl(i),
			x_gvev_rec		=> x_gvev_tbl(i));
Line: 2832

  END update_governance;
Line: 2834

  PROCEDURE delete_governance(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_gvev_rec                     IN gvev_rec_type) IS

    l_gvev_rec		gvev_rec_type;
Line: 2843

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_GOVERNANCE';
Line: 2887

    OKC_CONTRACT_PVT.delete_governance(
	 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_gvev_rec		=> l_gvev_rec);
Line: 2945

  END delete_governance;
Line: 2947

  PROCEDURE delete_governance(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_gvev_tbl                     IN gvev_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_GOVERNANCE';
Line: 2983

		OKC_CONTRACT_PUB.delete_governance(
			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_gvev_rec		=> p_gvev_tbl(i));
Line: 3041

  END delete_governance;
Line: 3674

  PROCEDURE update_contract_process(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cpsv_rec                     IN cpsv_rec_type,
    x_cpsv_rec                     OUT NOCOPY cpsv_rec_type) IS

    l_cpsv_rec		cpsv_rec_type;
Line: 3728

    OKC_CONTRACT_PVT.update_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,
      x_cpsv_rec		=> x_cpsv_rec);
Line: 3787

  END update_contract_process;
Line: 3789

  PROCEDURE update_contract_process(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cpsv_tbl                     IN cpsv_tbl_type,
    x_cpsv_tbl                     OUT NOCOPY cpsv_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_PROCESS';
Line: 3826

		OKC_CONTRACT_PUB.update_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		=> p_cpsv_tbl(i),
			x_cpsv_rec		=> x_cpsv_tbl(i));
Line: 3885

  END update_contract_process;
Line: 3887

  PROCEDURE delete_contract_process(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cpsv_rec                     IN cpsv_rec_type) IS

    l_cpsv_rec		cpsv_rec_type;
Line: 3896

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_PROCESS';
Line: 3940

    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);
Line: 3998

  END delete_contract_process;
Line: 4000

  PROCEDURE delete_contract_process(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cpsv_tbl                     IN cpsv_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_PROCESS';
Line: 4036

		OKC_CONTRACT_PUB.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		=> p_cpsv_tbl(i));
Line: 4094

  END delete_contract_process;
Line: 4727

  PROCEDURE update_contract_access(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cacv_rec                     IN cacv_rec_type,
    x_cacv_rec                     OUT NOCOPY cacv_rec_type) IS

    l_cacv_rec		cacv_rec_type;
Line: 4737

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_ACCESS';
Line: 4781

    OKC_CONTRACT_PVT.update_contract_access(
	 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_cacv_rec		=> l_cacv_rec,
      x_cacv_rec		=> x_cacv_rec);
Line: 4840

  END update_contract_access;
Line: 4842

  PROCEDURE update_contract_access(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cacv_tbl                     IN cacv_tbl_type,
    x_cacv_tbl                     OUT NOCOPY cacv_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_ACCESS';
Line: 4879

		OKC_CONTRACT_PUB.update_contract_access(
			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_cacv_rec		=> p_cacv_tbl(i),
			x_cacv_rec		=> x_cacv_tbl(i));
Line: 4938

  END update_contract_access;
Line: 4940

  PROCEDURE delete_contract_access(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cacv_rec                     IN cacv_rec_type) IS

    l_cacv_rec		cacv_rec_type;
Line: 4949

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_ACCESS';
Line: 4993

    OKC_CONTRACT_PVT.delete_contract_access(
	 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_cacv_rec		=> l_cacv_rec);
Line: 5051

  END delete_contract_access;
Line: 5053

  PROCEDURE delete_contract_access(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cacv_tbl                     IN cacv_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_ACCESS';
Line: 5089

		OKC_CONTRACT_PUB.delete_contract_access(
			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_cacv_rec		=> p_cacv_tbl(i));
Line: 5147

  END delete_contract_access;
Line: 5608

  FUNCTION Update_Allowed(p_chr_id IN NUMBER) RETURN VARCHAR2 Is
  BEGIN
     return (OKC_CONTRACT_PVT.Update_Allowed(p_chr_id));
Line: 5611

  END Update_Allowed;
Line: 5661

Procedure  update_lines(p_id in number,
p_sts_code in varchar2,
p_new_ste_code in VARCHAR2,
p_old_ste_code in VARCHAR2,
p_ste_code in VARCHAR2,
x_return_status OUT NOCOPY BOOLEAN)  IS

 x_num          number;
Line: 5676

 l_line_update  varchar2(1) := 'Y';
Line: 5685

   select ste_code
     from okc_statuses_v
    where code=p_sts_code;
Line: 5692

   select code
     from okc_statuses_v
    where ste_code='SIGNED'
      and default_yn='Y';
Line: 5700

   select code
     from okc_statuses_v
    where ste_code='EXPIRED'
      and default_yn='Y';
Line: 5706

    select L.id, decode(l_type,'ACTIVE',
                 decode(sign(months_between(sysdate-1,NVL(L.end_date,sysdate))),-1,
                      decode(sign(months_between(L.start_date-1,sysdate)),-1,p_sts_code,l_signed)
          ,l_expired)
         ,p_sts_code) code
    from okc_k_headers_v H, okc_k_lines_v L, okc_statuses_v S
   where H.id= p_id
     and L.dnz_chr_id = p_id
     and S.code = L.sts_code
     and S.ste_code in ('ENTERED','CANCELLED','ACTIVE','SIGNED','HOLD');
Line: 5774

  OKC_CONTRACT_PUB.update_contract_line(
        p_api_version                => 1,
        P_INIT_MSG_LIST         => 'T',
        p_restricted_update        => 'T',
        x_return_status                => l_return_status,
        x_msg_count                => l_msg_count,
        x_msg_data                => l_msg_data,
        p_clev_tbl                => l_clev_tbl,
        x_clev_tbl                => l1_clev_tbl);
Line: 5785

      l_line_update := 'N';
Line: 5789

   If l_line_update = 'Y' then
       x_return_status :=TRUE;
Line: 5798

 END update_lines;