APPS.OKC_CONTRACT_APPROVAL_PVT SQL Statements

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

Line: 51

 SELECT wf_item_key
 FROM oks_k_headers_b
 WHERE chr_id = p_chr_id;

Line: 149

       UPDATE oks_k_headers_b
       SET object_version_number = object_version_number + 1,
           renewal_status = 'ACT',
           last_update_date = SYSDATE,
           last_update_login = FND_GLOBAL.LOGIN_ID,
           Last_updated_by = FND_GLOBAL.USER_ID
       WHERE chr_id = p_contract_id;

Line: 190

       UPDATE oks_k_headers_b
       SET object_version_number = object_version_number + 1,
           renewal_status = 'REJ',
           last_update_date = SYSDATE,
           last_update_login = FND_GLOBAL.LOGIN_ID,
           Last_updated_by = FND_GLOBAL.USER_ID
       WHERE chr_id = p_contract_id;

Line: 211

      UPDATE oks_k_headers_b
      SET renewal_status       = 'COMPLETE',
         object_version_number = object_version_number + 1,
         last_update_date      = SYSDATE,
         last_updated_by       = FND_GLOBAL.USER_ID,
         last_update_login     = FND_GLOBAL.LOGIN_ID
     WHERE chr_id              = p_contract_id;

Line: 255

      UPDATE oks_k_headers_b
     SET object_version_number = object_version_number + 1,
         wf_item_key = l_wf_attributes.ITEM_KEY,
         renewal_status = l_wf_attributes.NEGOTIATION_STATUS,
         last_update_date = SYSDATE,
         last_update_login = FND_GLOBAL.LOGIN_ID,
         Last_updated_by = FND_GLOBAL.USER_ID
     WHERE chr_id = l_wf_attributes.contract_id;

Line: 265

                       ' Updated negotiation status to REJECTED');

Line: 359

  select ID
  from okc_k_processes_v
  where CHR_ID = p_contract_id
    and PDF_ID = p_process_id
--because of bug in lock API
	for update of process_id nowait;

Line: 367

  select H.CONTRACT_NUMBER,
    H.CONTRACT_NUMBER_MODIFIER,
    H.DATE_APPROVED,
	S.MEANING,
	S.STE_CODE
  from okc_k_headers_all_b H, okc_statuses_v S
  where H.ID = p_contract_id
	and H.STS_CODE=S.CODE;

Line: 379

  select WF_NAME, WF_PROCESS_NAME, USAGE
  from OKC_PROCESS_DEFS_B
     where ID = p_process_id
  and begin_date<=sysdate
  and (end_date is NULL or end_date>=sysdate) and PDF_TYPE='WPS';

Line: 386

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

Line: 397

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

Line: 403

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

Line: 574

                   ' OKC_CONTRACT_PUB.update_contract_process L1_CPSV_REC.PROCESS_ID=>'||L1_CPSV_REC.PROCESS_ID);

Line: 576

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

                   ' OKC_CONTRACT_PUB.update_contract_process x_return_status=>'||l_return_status);

Line: 730

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

Line: 748

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

Line: 766

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

Line: 784

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

Line: 861

  UPDATE okc_k_headers_all_b
  SET OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
  WHERE ID=p_contract_id;

Line: 926

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

Line: 931

  select CONTRACT_NUMBER||CONTRACT_NUMBER_MODIFIER wf_key
  from okc_k_headers_all_b
  where ID = p_contract_id;

Line: 936

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

Line: 999

  select CONTRACT_NUMBER||CONTRACT_NUMBER_MODIFIER wf_key,
	CONTRACT_NUMBER, CONTRACT_NUMBER_MODIFIER,
	short_description, scs_code
  from OKC_K_HDR_AGREEDS_V
  where ID = p_contract_id;

Line: 1006

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

Line: 1016

  select '!'
  from wf_activities
  where item_type=l_wf_name_active
  and TYPE='PROCESS' and NAME='ABORT_PROCESS'
;

Line: 1024

  select display_name
  from wf_roles
  where orig_system = 'FND_USR'
  and orig_system_id=fnd_global.user_id
-- changed to boost perf
*/
  select user_name display_name from fnd_user where user_id=fnd_global.user_id and EMPLOYEE_ID is null
  	union all
  select
       PER.FULL_NAME display_name
  from
       PER_PEOPLE_F PER,
       FND_USER USR
  where  trunc(SYSDATE)
      between PER.EFFECTIVE_START_DATE and PER.EFFECTIVE_END_DATE
    and    PER.PERSON_ID       = USR.EMPLOYEE_ID
    and USR.USER_ID = fnd_global.user_id
;

Line: 1044

SELECT wf_item_key FROM OKS_K_HEADERS_B
WHERE chr_id = p_contract_id;

Line: 1359

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

Line: 1377

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

Line: 1395

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

Line: 1413

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

Line: 1489

       UPDATE oks_k_headers_b
       SET object_version_number = object_version_number + 1,
           wf_item_key = l_wf_attributes.ITEM_KEY,
           renewal_status = l_wf_attributes.NEGOTIATION_STATUS,
           last_update_date = SYSDATE,
           last_update_login = FND_GLOBAL.LOGIN_ID,
           Last_updated_by = FND_GLOBAL.USER_ID
       WHERE chr_id = l_wf_attributes.contract_id;

Line: 1581

  select value
  from NLS_SESSION_PARAMETERS
  where PARAMETER=p;

Line: 1642

(select '!'
 from OKC_K_ACCESSES
 where chr_id = p_contract_id
 and user_id = p_user_id
 and (p_level='R' or access_level='U')
)
  UNION ALL
(select '!' from dual
 where exists
 (select agp_code
  from OKC_K_ACCESSES
  where chr_id = P_CONTRACT_ID
  and (p_level='R' or access_level='U')
    INTERSECT
  SELECT AGP_CODE
  FROM okc_acc_group_members
  where begin_date<=sysdate
   and (end_date is null or end_date>=sysdate)
  start with user_id = p_user_id
  CONNECT BY PRIOR AGP_CODE = AGP_CODE_COMPOSED_OF
 )
);

Line: 1718

  	select object_version_number , org_id --mmadhavi added org_id for MOAC project
  	from okc_k_headers_all_b
  	where ID = p
;

Line: 1778

  OKC_CONTRACT_PUB.update_contract_header(
    p_api_version		=> l_api_version,
    x_return_status	=> x_return_status,
    p_init_msg_list     => OKC_API.G_TRUE,
    x_msg_count		=> l_msg_count,
    x_msg_data		=> l_msg_data,
    p_restricted_update	=> OKC_API.G_TRUE,
    p_chrv_rec		=> L1_header_rec,
    x_chrv_rec		=> L2_header_rec);

Line: 1842

  select '!'
  from okc_k_headers_all_b
  where ID = p_contract_id and date_approved is not null;

Line: 1847

  	select object_version_number
  	from okc_k_headers_all_b
  	where ID = p
;

Line: 1899

  OKC_CONTRACT_PUB.update_contract_header(
    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_restricted_update	=> OKC_API.G_TRUE,
    p_chrv_rec		=> L1_header_rec,
    x_chrv_rec		=> L2_header_rec);

Line: 1969

  	select object_version_number, START_DATE, END_DATE, sts_code, scs_code
  	from okc_k_headers_all_b
  	where ID = p
;

Line: 1982

  select code from okc_statuses_b
  where ste_code='SIGNED'
    and default_yn='Y';

Line: 1986

  select code from okc_statuses_b
  where ste_code='ACTIVE'
    and default_yn='Y';

Line: 1990

  select code from okc_statuses_b
  where ste_code='EXPIRED'
    and default_yn='Y';

Line: 1995

  	select L.ID ID, L.object_version_number
,decode(sign(months_between(sysdate-1, NVL(L.end_date,sysdate))),-1,
  decode(sign(months_between(p_date_signed-1,sysdate)),-1,
    decode(sign(months_between(L.start_date-1,sysdate)),-1,
	l_active_status,l_signed_status),l_signed_status),l_expired_status) STS_CODE
from okc_k_lines_b L
	, okc_statuses_b S
  	where L.dnz_chr_id = p_contract_id
	and S.code = L.sts_code
	and S.ste_code='ENTERED'
;

Line: 2096

  select ste_code
  into L1_header_rec.old_ste_code
  from okc_statuses_b
  where code = L1_header_rec.old_sts_code;

Line: 2102

  select ste_code
  into L1_header_rec.new_ste_code
  from okc_statuses_b
  where code = l_new_status;

Line: 2114

                    'OKC_CONTRACT_PUB.update_contract_header');

Line: 2116

  OKC_CONTRACT_PUB.update_contract_header(
    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_restricted_update	=> OKC_API.G_TRUE,
    p_chrv_rec		=> L1_header_rec,
    x_chrv_rec		=> L2_header_rec);

Line: 2131

                     'OKC_CONTRACT_PUB.update_contract_header(x_return_status=>'||x_return_status||')');

Line: 2161

            UPDATE (SELECT l.sts_code, l.start_date, l.end_date
                    FROM okc_k_lines_b l, okc_statuses_b s
                    WHERE l.dnz_chr_id = p_contract_id
                    AND s.code = l.sts_code
                    AND s.ste_code = 'ENTERED') oks
            SET
                oks.sts_code =
                    decode( sign(months_between(l_sysdate - 1, NVL(oks.end_date, l_sysdate))),
                        -1, decode(sign(months_between(p_date_signed - 1, l_sysdate)),
                            -1, decode(sign(months_between(oks.start_date - 1, l_sysdate)),
                                -1, l_active_status, l_signed_status), l_signed_status), l_expired_status);

Line: 2175

                               'done line status update');

Line: 2207

                     'OKC_CONTRACT_PUB.update_contract_line');

Line: 2210

           OKC_CONTRACT_PUB.update_contract_line(
               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_restricted_update	=> OKC_API.G_TRUE,
               p_clev_tbl => l2_lines,
               x_clev_tbl => l3_lines);

Line: 2220

                                'OKC_CONTRACT_PUB.update_contract_line(x_return_status=>'||x_return_status||')');

Line: 2265

                                   ,p_operation_code  => 'UPDATE'
							,p_termination_date => Null
                                   ,x_return_status   => x_return_status
                                   ,x_msg_count       => l_msg_count
                                   ,x_msg_data        => l_msg_data);

Line: 2392

  	select object_version_number
  	from okc_k_headers_all_b
  	where ID = p_contract_id;

Line: 2436

  OKC_CONTRACT_PUB.update_contract_header(
    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_restricted_update	=> OKC_API.G_TRUE,
    p_chrv_rec		      => L1_header_rec,
    x_chrv_rec		      => L2_header_rec);