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.OKE_K_ACCESS_RULES_PKG2 dependencies on OKE_K_ACCESS_RULES

Line 1: package body OKE_K_ACCESS_RULES_PKG2 as

1: package body OKE_K_ACCESS_RULES_PKG2 as
2: /* $Header: OKEKAR2B.pls 115.10 2003/12/03 19:20:15 alaw ship $ */
3:
4: --
5: -- Name : Compile_Rules

Line 83: FROM oke_k_access_rules kar

79: 'EDIT'
80: )
81: , kar.access_rule_id
82: , oap.form_item_flag
83: FROM oke_k_access_rules kar
84: , oke_object_attributes_b oa
85: , oke_object_attributes_b oap
86: WHERE kar.role_id = X_Role_ID
87: AND kar.attribute_code is not null

Line 132: FROM oke_k_access_rules kar

128: )
129: )
130: , kar.access_rule_id
131: , oap.form_item_flag
132: FROM oke_k_access_rules kar
133: , oke_object_attributes_b oa
134: , oke_object_attributes_b oap
135: WHERE kar.role_id = X_Role_ID
136: AND kar.attribute_code is null

Line 186: FROM oke_k_access_rules kar

182: )
183: )
184: , kar.access_rule_id
185: , oap.form_item_flag
186: FROM oke_k_access_rules kar
187: , oke_object_attributes_b oa
188: , oke_object_attributes_b oap
189: WHERE kar.role_id = X_Role_ID
190: AND kar.secured_object_name = oa.database_object_name

Line 241: FROM oke_k_access_rules

237: AND oa.attribute_code = nvl( oap.parent_attribute_code
238: , oap.attribute_code )
239: AND NOT EXISTS (
240: SELECT null
241: FROM oke_k_access_rules
242: WHERE role_id = X_Role_ID
243: AND secured_object_name = oap.database_object_name
244: AND attribute_group_code IS NULL
245: AND attribute_code IS NULL

Line 284: FROM oke_k_access_rules kar

280: , L_user_id
281: , L_login_id
282: , kar.access_level
283: , kar.access_rule_id
284: FROM oke_k_access_rules kar
285: WHERE kar.role_id = X_Role_ID
286: AND kar.attribute_group_type = 'USER';
287:
288: --

Line 317: FROM oke_k_access_rules kar

313: , L_user_id
314: , L_login_id
315: , kar.access_level
316: , kar.access_rule_id
317: FROM oke_k_access_rules kar
318: , oke_attribute_groups_v ag
319: WHERE kar.role_id = X_Role_ID
320: AND kar.attribute_group_code IS NULL
321: AND kar.attribute_code IS NULL

Line 472: DELETE FROM oke_k_access_rules

468: IF ( X_Copy_Option = 'REPLICATE' ) THEN
469:
470: L_stage := 1;
471:
472: DELETE FROM oke_k_access_rules
473: WHERE role_id = X_Target_Role_ID;
474:
475: END IF;
476:

Line 484: UPDATE oke_k_access_rules kar

480: IF ( X_Copy_Option = 'MERGE' ) THEN
481:
482: L_stage := 2;
483:
484: UPDATE oke_k_access_rules kar
485: SET last_update_date = sysdate
486: , last_updated_by = L_user_id
487: , access_level = (
488: SELECT access_level

Line 489: FROM oke_k_access_rules

485: SET last_update_date = sysdate
486: , last_updated_by = L_user_id
487: , access_level = (
488: SELECT access_level
489: FROM oke_k_access_rules
490: WHERE role_id = X_Source_Role_ID
491: AND secured_object_name = kar.secured_object_name
492: AND nvl( attribute_group_code , '*NULL Attribute Group*' ) =
493: nvl( kar.attribute_group_code , '*NULL Attribute Group*' )

Line 500: FROM oke_k_access_rules

496: )
497: WHERE role_id = X_Target_Role_ID
498: AND EXISTS (
499: SELECT NULL
500: FROM oke_k_access_rules
501: WHERE role_id = X_Source_Role_ID
502: AND secured_object_name = kar.secured_object_name
503: AND nvl( attribute_group_code , '*NULL Attribute Group*' ) =
504: nvl( kar.attribute_group_code , '*NULL Attribute Group*' )

Line 513: INSERT INTO oke_k_access_rules

509: END IF;
510:
511: L_stage := 3;
512:
513: INSERT INTO oke_k_access_rules
514: ( access_rule_id
515: , creation_date
516: , created_by
517: , last_update_date

Line 525: SELECT oke_k_access_rules_s.nextval

521: , secured_object_name
522: , attribute_group_code
523: , attribute_code
524: , access_level )
525: SELECT oke_k_access_rules_s.nextval
526: , sysdate
527: , L_user_id
528: , sysdate
529: , L_user_id

Line 536: FROM oke_k_access_rules kar

532: , kar.secured_object_name
533: , kar.attribute_group_code
534: , kar.attribute_code
535: , kar.access_level
536: FROM oke_k_access_rules kar
537: WHERE role_id = X_Source_Role_ID
538: AND NOT EXISTS (
539: SELECT NULL
540: FROM oke_k_access_rules

Line 540: FROM oke_k_access_rules

536: FROM oke_k_access_rules kar
537: WHERE role_id = X_Source_Role_ID
538: AND NOT EXISTS (
539: SELECT NULL
540: FROM oke_k_access_rules
541: WHERE role_id = X_Target_Role_ID
542: AND secured_object_name = kar.secured_object_name
543: AND nvl( attribute_group_code , '*NULL Attribute Group*' ) =
544: nvl( kar.attribute_group_code , '*NULL Attribute Group*' )

Line 631: end OKE_K_ACCESS_RULES_PKG2;

627: RETCODE := 2;
628:
629: END Compile;
630:
631: end OKE_K_ACCESS_RULES_PKG2;