APPS.OKL_OKC_MIGRATION_A_PVT dependencies on OKC_ASSENTS

Line 877: l_sts_code OKC_ASSENTS.STS_CODE%TYPE;

873: -- returns OKC_API.G_RET_STS_ERROR or OKC_API.G_RET_STS_UNEXP_ERROR
874: -- in case of error
875: --
876: FUNCTION Update_Allowed(p_chr_id IN NUMBER) RETURN VARCHAR2 Is
877: l_sts_code OKC_ASSENTS.STS_CODE%TYPE;
878: l_scs_code OKC_ASSENTS.SCS_CODE%TYPE;
879: l_return_value VARCHAR2(1) := 'N';
880:
881: Cursor l_chrv_csr Is

Line 878: l_scs_code OKC_ASSENTS.SCS_CODE%TYPE;

874: -- in case of error
875: --
876: FUNCTION Update_Allowed(p_chr_id IN NUMBER) RETURN VARCHAR2 Is
877: l_sts_code OKC_ASSENTS.STS_CODE%TYPE;
878: l_scs_code OKC_ASSENTS.SCS_CODE%TYPE;
879: l_return_value VARCHAR2(1) := 'N';
880:
881: Cursor l_chrv_csr Is
882: SELECT sts_code, scs_code

Line 888: FROM okc_assents

884: WHERE id = p_chr_id;
885:
886: Cursor l_astv_csr Is
887: SELECT upper(substr(allowed_yn,1,1))
888: FROM okc_assents
889: WHERE sts_code = l_sts_code
890: AND scs_code = l_scs_code
891: AND opn_code = 'UPDATE';
892: BEGIN