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_CONTRACT_PVT dependencies on OKC_ASSENTS

Line 4177: l_sts_code OKC_ASSENTS.STS_CODE%TYPE;

4173: -- returns OKC_API.G_RET_STS_ERROR or OKC_API.G_RET_STS_UNEXP_ERROR
4174: -- in case of error
4175: --
4176: FUNCTION Update_Allowed(p_chr_id IN NUMBER) RETURN VARCHAR2 Is
4177: l_sts_code OKC_ASSENTS.STS_CODE%TYPE;
4178: l_scs_code OKC_ASSENTS.SCS_CODE%TYPE;
4179: l_return_value VARCHAR2(1) := 'Y';
4180:
4181: Cursor l_chrv_csr Is

Line 4178: l_scs_code OKC_ASSENTS.SCS_CODE%TYPE;

4174: -- in case of error
4175: --
4176: FUNCTION Update_Allowed(p_chr_id IN NUMBER) RETURN VARCHAR2 Is
4177: l_sts_code OKC_ASSENTS.STS_CODE%TYPE;
4178: l_scs_code OKC_ASSENTS.SCS_CODE%TYPE;
4179: l_return_value VARCHAR2(1) := 'Y';
4180:
4181: Cursor l_chrv_csr Is
4182: SELECT sts_code, scs_code

Line 4192: FROM okc_assents

4188: WHERE id = p_chr_id;
4189:
4190: Cursor l_astv_csr Is
4191: SELECT upper(substr(allowed_yn,1,1))
4192: FROM okc_assents
4193: WHERE sts_code = l_sts_code
4194: AND scs_code = l_scs_code
4195: AND opn_code = 'UPDATE';
4196: BEGIN