eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CHANGE_REQUEST_PVT SQL Statements

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

Line: 53


select '!' from okc_change_requests_v
where chr_id = p_crtv_rec.chr_id
and  name = p_crtv_rec.name
and datetime_applied is null;

Line: 78


  okc_crt_pvt.insert_row(p_api_version   => p_api_version,
                         p_init_msg_list => p_init_msg_list,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         x_return_status => x_return_status,
                         p_crtv_rec      => p_crtv_rec,
                         x_crtv_rec      => x_crtv_rec);

Line: 95


procedure update_change_request(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_crtv_rec	IN	crtv_rec_type,
                              x_crtv_rec	OUT NOCOPY	crtv_rec_type) is
begin
  okc_crt_pvt.update_row(p_api_version   => p_api_version,
                         p_init_msg_list => p_init_msg_list,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         x_return_status => x_return_status,
                         p_crtv_rec      => p_crtv_rec,
                         x_crtv_rec      => x_crtv_rec);

Line: 110


end update_change_request;

Line: 120


procedure delete_change_request(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_crtv_rec	 IN	crtv_rec_type) is
l_dummy varchar2(1);

Line: 128


  select '!'
  from OKC_CHANGES_B
  where crt_id = p_crtv_rec.id;

Line: 132


  select '!'
  from OKC_CHANGE_PARTY_ROLE
  where crt_id = p_crtv_rec.id;

Line: 167


  okc_crt_pvt.delete_row(p_api_version   => p_api_version,
                         p_init_msg_list => p_init_msg_list,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         x_return_status => x_return_status,
                         p_crtv_rec      => p_crtv_rec);

Line: 173


end delete_change_request;

Line: 197


select id,name,chr_id,crs_code,datetime_applied,object_version_number
from okc_change_requests_v
where id = p_crtv_rec.id;

Line: 202


  select substr(CONTRACT_NUMBER||CONTRACT_NUMBER_MODIFIER||l_crtv_rec.NAME,1,240) key
  from OKC_K_HDR_AGREEDS_V
  where ID = l_crtv_rec.chr_id;

Line: 207


  select item_type
  from WF_ITEMS
  where item_type in
   ( select wf_name
     from OKC_PROCESS_DEFS_B
     where USAGE='CHG_REQ_APPROVE' and PDF_TYPE='WPS')
   and item_key = l_key
   and end_date is NULL;

Line: 305


  okc_cor_pvt.insert_row(p_api_version   => p_api_version,
                         p_init_msg_list => p_init_msg_list,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         x_return_status => x_return_status,
                         p_corv_rec      => p_corv_rec,
                         x_corv_rec      => x_corv_rec);

Line: 322


procedure update_change(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_corv_rec	IN	corv_rec_type,
                              x_corv_rec	OUT NOCOPY	corv_rec_type) is
begin
  okc_cor_pvt.update_row(p_api_version   => p_api_version,
                         p_init_msg_list => p_init_msg_list,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         x_return_status => x_return_status,
                         p_corv_rec      => p_corv_rec,
                         x_corv_rec      => x_corv_rec);

Line: 337


end update_change;

Line: 347


procedure delete_change(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_corv_rec	IN	corv_rec_type) is
begin
  okc_cor_pvt.delete_row(p_api_version   => p_api_version,
                         p_init_msg_list => p_init_msg_list,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         x_return_status => x_return_status,
                         p_corv_rec      => p_corv_rec);

Line: 360


end delete_change;

Line: 382


  select C.crs_code,
	substr(K.CONTRACT_NUMBER||K.CONTRACT_NUMBER_MODIFIER||C.NAME,1,240) key
  from
	OKC_CHANGE_REQUESTS_V C,
	OKC_K_HDR_AGREEDS_V K
  where C.ID = p_corv_rec.CRT_ID
    and K.ID = C.chr_id;

Line: 391


  select item_type
  from WF_ITEMS
  where item_type in
   ( select wf_name
     from OKC_PROCESS_DEFS_B
     where USAGE='CHG_REQ_APPROVE' and PDF_TYPE='WPS')
   and item_key = l_key
   and end_date is NULL;

Line: 470


  okc_cpr_pvt.insert_row(p_api_version   => p_api_version,
                         p_init_msg_list => p_init_msg_list,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         x_return_status => x_return_status,
                         p_cprv_rec      => p_cprv_rec,
                         x_cprv_rec      => x_cprv_rec);

Line: 487


procedure update_change_party_role(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_cprv_rec	IN	cprv_rec_type,
                              x_cprv_rec	OUT NOCOPY	cprv_rec_type) is
begin
  okc_cpr_pvt.update_row(p_api_version   => p_api_version,
                         p_init_msg_list => p_init_msg_list,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         x_return_status => x_return_status,
                         p_cprv_rec      => p_cprv_rec,
                         x_cprv_rec      => x_cprv_rec);

Line: 502


end update_change_party_role;

Line: 512


procedure delete_change_party_role(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_cprv_rec	IN	cprv_rec_type) is
begin
  okc_cpr_pvt.delete_row(p_api_version   => p_api_version,
                         p_init_msg_list => p_init_msg_list,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         x_return_status => x_return_status,
                         p_cprv_rec      => p_cprv_rec);

Line: 525


end delete_change_party_role;