APPS.OKE_K_SECURED_VIEWS_PKG dependencies on OKE_K_SECURITY_PKG

Line 80: AND access_level = OKE_K_SECURITY_PKG.G_NO_ACCESS

76: SELECT Role_ID
77: FROM oke_compiled_access_rules
78: WHERE secured_object_name = C_Object_Name
79: AND attribute_code = C_attribute_code
80: AND access_level = OKE_K_SECURITY_PKG.G_NO_ACCESS
81: ORDER BY Role_ID;
82:
83: BEGIN
84:

Line 140: ' , DECODE( OKE_K_SECURITY_PKG.GET_K_ROLE( K.' || X_Header_ID_Col ||

136:
137: IF ( DecodePair IS NOT NULL ) THEN
138:
139: SelectList := SelectList ||
140: ' , DECODE( OKE_K_SECURITY_PKG.GET_K_ROLE( K.' || X_Header_ID_Col ||
141: ' ) , ' || DecodePair || 'K.' || ObjAttrRec.Attribute_Code || ' ) ';
142:
143: ELSE
144:

Line 161: ' OKE_K_SECURITY_PKG.GET_K_ACCESS( ID ) K_ACCESS ' ||

157: 'CREATE OR REPLACE FORCE VIEW ' || SecViewName || ' ( ' ||
158: ColumnList || ' ) AS SELECT /* ' || RCSHeader || ' */ ' || SelectList ||
159: ' FROM ' || UnsecViewName || ' K ,' ||
160: ' ( SELECT ID K_HDR_ID ,' ||
161: ' OKE_K_SECURITY_PKG.GET_K_ACCESS( ID ) K_ACCESS ' ||
162: ' FROM OKC_K_HEADERS_B ) ACC' ||
163: ' WHERE ACC.K_HDR_ID = K.' || X_Header_ID_Col ||
164: ' AND ACC.K_ACCESS IN ( ''EDIT'' , ''VIEW'' )' ;
165:

Line 193: ' OKE_K_SECURITY_PKG.GET_K_ACCESS( ID ) K_ACCESS ' ||

189: 'CREATE OR REPLACE FORCE VIEW ' || SecViewName || ' ( ' ||
190: ColumnList || ' ) AS SELECT /* ' || RCSHeader || ' */ ' || SelectList ||
191: ' FROM ' || UnsecViewName || ' K ,' ||
192: ' ( SELECT ID K_HDR_ID ,' ||
193: ' OKE_K_SECURITY_PKG.GET_K_ACCESS( ID ) K_ACCESS ' ||
194: ' FROM OKC_K_HEADERS_B ) ACC' ||
195: ' WHERE ACC.K_HDR_ID = K.' || X_Header_ID_Col ||
196: ' AND ACC.K_ACCESS IN ( ''EDIT'' , ''VIEW'' )';
197: