APPS.OKC_CHANGE_CONTRACT_PVT SQL Statements

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

Line: 42

SELECT k.estimated_amount,k.scs_code,scs.cls_code,k.sts_code
 FROM OKC_K_HEADERS_B K,
	 OKC_SUBCLASSES_B SCS
WHERE k.id = p_contract_id
 AND  k.scs_code = scs.code;

Line: 64

Select datetime_request
FROM OKC_CHANGE_REQUESTS_B where
ID=chq_id;

Line: 93

  select
	K.ID 	CONTRACT_ID,
	K.CONTRACT_NUMBER,
	K.CONTRACT_NUMBER_MODIFIER,
	K.SHORT_DESCRIPTION K_SHORT_DESCRIPTION,
	C.NAME CRT_NAME,
	C.DATETIME_REQUEST,
	C.SHORT_DESCRIPTION CRT_SHORT_DESCRIPTION,
	substr(K.CONTRACT_NUMBER
		||K.CONTRACT_NUMBER_MODIFIER
		||C.NAME,1,240) KEY,
--	NVL(C.USER_ID,fnd_global.user_id) AUTH_USER_ID,
	NVL(C.USER_ID,OKC_API.G_MISS_NUM) AUTH_USER_ID,
	U.USER_NAME AUTH_USERNAME,
	C.AUTHORITY REQUESTOR,
	C.SIGNATURE_REQUIRED_YN
  from okc_change_requests_v C,
	  OKC_K_PROCESSES cpr,
	  OKC_K_HDR_AGREEDS_V K,
	  fnd_user_view U
  where C.ID = p_change_request_id
    and K.ID = C.CHR_ID
    and cpr.crt_id = C.ID
   -- and U.USER_ID = NVL(cpr.USER_ID,OKC_API.G_MISS_NUM);

Line: 126

  select PDF.ID, PDF.WF_NAME, PDF.WF_PROCESS_NAME, PDF.USAGE
  from okc_k_processes KP,
	OKC_PROCESS_DEFS_B PDF
     where KP.crt_id = p_change_request_id
	and PDF.ID = KP.PDF_ID
  and PDF.begin_date<=sysdate
  and (PDF.end_date is NULL or PDF.end_date>=sysdate)
  and PDF.PDF_TYPE = 'WPS';

Line: 139

  select '!'
  from WF_ITEMS
  where item_type = l_wf_name
   and item_key = l_key;

Line: 147

  select ID,OBJECT_VERSION_NUMBER
  from okc_k_processes
  where CRT_ID = p_change_request_id
	for update of process_id nowait;

Line: 158

  select
    NAME,
    DATA_TYPE,
    DEFAULT_VALUE
  from OKC_PROCESS_DEF_PARAMETERS_V
  where PDF_ID = l_process_id;

Line: 302

    OKC_CONTRACT_PUB.update_contract_process(
      p_api_version		=> l_api_version,
      x_return_status	=> l_return_status,
      x_msg_count		=> l_msg_count,
      x_msg_data		=> l_msg_data,
      p_cpsv_rec		=> L1_CPSV_REC,
      x_cpsv_rec		=> L2_CPSV_REC);

Line: 574

    select value into L_NLS_VALUE
    from NLS_SESSION_PARAMETERS
    where PARAMETER='NLS_LANGUAGE';

Line: 592

    select value into L_NLS_VALUE
    from NLS_SESSION_PARAMETERS
    where PARAMETER='NLS_DATE_FORMAT';

Line: 610

    select value into L_NLS_VALUE
    from NLS_SESSION_PARAMETERS
    where PARAMETER='NLS_DATE_LANGUAGE';

Line: 628

    select '"'||value||'"' into L_NLS_VALUE
    from NLS_SESSION_PARAMETERS
    where PARAMETER='NLS_NUMERIC_CHARACTERS';

Line: 733

  select WF_NAME
  from OKC_PROCESS_DEFS_V
     where ID = p_process_id and PDF_TYPE = 'WPS';

Line: 741

  select
	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_change_request_id
    and K.ID = C.CHR_ID;

Line: 754

  select '!'
  from WF_ITEMS
  where item_type = l_wf_name
   and item_key = l_key;

Line: 813

  select
	K.ID 	CONTRACT_ID,
	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_change_request_id
    and K.ID = C.CHR_ID;

Line: 826

  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: 941

  select '!'
  from
	OKC_CHANGE_REQUESTS_B 	C,
	OKC_K_PROCESSES 		P
  where C.chr_id = (select chr_id from OKC_CHANGE_REQUESTS_B
			where id = p_change_request_id)
    and C.ID <> p_change_request_id
    and C.datetime_applied is NULL
    and P.crt_id = C.id
    and P.in_process_yn = 'Y';

Line: 953

  select id,object_version_number from OKC_K_PROCESSES
  where crt_id = p_change_request_id;

Line: 1005

  OKC_CONTRACT_PUB.update_contract_process(
				p_api_version	=> p_api_version,
                       	x_return_status	=> l_return_status,
                       	x_msg_count		=> x_msg_count,
                       	x_msg_data		=> x_msg_data,
    				p_cpsv_rec		=> l_cpsv_rec,
    				x_cpsv_rec		=> l1_cpsv_rec);

Line: 1078

  select id,object_version_number from OKC_K_PROCESSES
  where crt_id = p_change_request_id;

Line: 1124

  OKC_CONTRACT_PUB.update_contract_process(
				p_api_version	=> p_api_version,
                       	x_return_status	=> l_return_status,
                       	x_msg_count		=> x_msg_count,
                       	x_msg_data		=> x_msg_data,
    				p_cpsv_rec		=> l_cpsv_rec,
    				x_cpsv_rec		=> l1_cpsv_rec);

Line: 1138

  OKC_CHANGE_REQUEST_PUB.update_change_request(
				p_api_version	=> p_api_version,
                       	x_return_status	=> l_return_status,
                       	x_msg_count		=> x_msg_count,
                       	x_msg_data		=> x_msg_data,
    				p_crtv_rec		=> l_crtv_rec,
    				x_crtv_rec		=> l1_crtv_rec);

Line: 1218

  select ID
  from okc_change_requests_B
  where ID = p_change_request_id
  for update of crs_code, datetime_approved, datetime_rejected
  nowait;

Line: 1224

  select k.id,k.contract_number,k.contract_number_modifier,k.scs_code,
		 scs.cls_code,k.estimated_amount,k.sts_code
  from okc_k_headers_b k,
	  okc_subclasses_b scs,
	  okc_change_requests_b crt
 where crt.chr_id = k.id
   and k.scs_code = scs.code
   and crt.id = p_change_request_id;

Line: 1245

  OKC_CHANGE_REQUEST_PUB.update_change_request(
				p_api_version	=> l_api_version,
                       	x_return_status	=> x_return_status,
                       	x_msg_count		=> l_msg_count,
                       	x_msg_data		=> l_msg_data,
    				p_crtv_rec		=> l_crtv_rec,
    				x_crtv_rec		=> l1_crtv_rec);

Line: 1313

  select ID
  from okc_change_requests_b
  where ID = p_change_request_id
  for update of crs_code, datetime_approved, datetime_rejected
  nowait;

Line: 1319

  select k.id,k.contract_number,k.contract_number_modifier,k.scs_code,scs.cls_code,
  k.estimated_amount,k.sts_code
  from okc_k_headers_b k,
	  okc_subclasses_b scs,
	  okc_change_requests_b crt
 where crt.chr_id = k.id
   and k.scs_code = scs.code
   and crt.id = p_change_request_id;

Line: 1341

  OKC_CHANGE_REQUEST_PUB.update_change_request(
				p_api_version	=> l_api_version,
                       	x_return_status	=> x_return_status,
                       	x_msg_count		=> l_msg_count,
                       	x_msg_data		=> l_msg_data,
    				p_crtv_rec		=> l_crtv_rec,
    				x_crtv_rec		=> l1_crtv_rec);