APPS.OKL_VP_STS_PVT SQL Statements

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

Line: 19

SELECT
S.meaning STATUS,
S.code STATUS_CODE,
decode(S.DEFAULT_YN,'Y','*',' ') DEF,
ST.meaning STATUS_TYPE,
S.ste_code STE_CODE1
FROM
okc_statuses_v S, fnd_lookups ST
WHERE
S.ste_code IN (NVL(p_ste_code,'ENTERED'),decode(p_ste_code,NULL, 'CANCELLED','ENTERED','CANCELLED',
               'ACTIVE','HOLD', 'SIGNED','HOLD', 'HOLD',DECODE(NVL(sign(months_between
              (p_start_date,SYSDATE+1)),1), -1,
              DECODE( NVL(sign(months_between(p_end_date,SYSDATE-1)),
              1),1,'ACTIVE' ,'EXPIRED'),'SIGNED')))
AND SYSDATE BETWEEN S.start_date AND NVL(S.end_date,SYSDATE)
AND ST.lookup_type='OKC_STATUS_TYPE'
AND ST.lookup_code=s.ste_code
AND SYSDATE BETWEEN ST.start_date_active AND
	NVL(ST.end_date_active,SYSDATE)
AND ST.enabled_flag='Y'
AND S.code<>NVL(p_sts_code,'ENTERED')
AND p_sts_code NOT LIKE 'QA%HOLD'
AND S.code NOT LIKE 'QA%HOLD'
AND p_ste_code <> 'CANCELLED'
UNION ALL
SELECT  S.meaning STATUS
       ,S.code STATUS_CODE
       ,DECODE(S.DEFAULT_YN, 'Y', '*', '') DEF
       ,ST.meaning STATUS_TYPE
       ,S.ste_code STE_CODE1
FROM   okc_statuses_v S
       ,fnd_lookups ST
WHERE  S.ste_code IN ('ENTERED', 'CANCELLED')
  AND  SYSDATE BETWEEN S.start_date AND NVL(S.end_date, SYSDATE)
  AND  ST.lookup_type = 'OKC_STATUS_TYPE'
  AND  ST.lookup_code=S.ste_code
  AND  SYSDATE BETWEEN ST.start_date_active AND NVL(ST.end_date_active, SYSDATE)
  AND  ST.enabled_flag = 'Y'
  AND  S.code <> p_sts_code
  AND  p_ste_code ='CANCELLED';

Line: 109

SELECT sts_code , authoring_org_id FROM okc_k_headers_v --CDUBEY authoring_org_id added for MOAC
WHERE id=p_id;

Line: 140

  IF (OKL_OKC_MIGRATION_A_PVT.update_allowed(p_chr_id) <> 'Y') THEN

    l1_return_status :=OKL_API.G_RET_STS_ERROR;

Line: 145

                        p_msg_name      => 'OKL_VP_UPDATE_NOT_ALLOWED'
                       );

Line: 205

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