APPS.AMW_VIOLATION_PVT dependencies on AMW_CONSTRAINTS_B

Line 75: l_has_icm_sql varchar2(64) := 'select null from AMW_CONSTRAINTS_B where rownum = 1';

71: dummy varchar2(1);
72:
73: TYPE icmCurTyp IS REF CURSOR;
74: c_has_icm icmCurTyp;
75: l_has_icm_sql varchar2(64) := 'select null from AMW_CONSTRAINTS_B where rownum = 1';
76:
77: BEGIN
78:
79: is_icm_valid := 'N';

Line 253: FROM amw_constraints_b

249:
250: -- find all valid constraints
251: CURSOR c_all_valid_constraints IS
252: SELECT constraint_rev_id, type_code
253: FROM amw_constraints_b
254: WHERE start_date <= sysdate AND (end_date IS NULL OR end_date >= sysdate)
255: AND objective_code = 'PR';
256: l_all_valid_constraints c_all_valid_constraints%ROWTYPE;
257:

Line 1284: FROM amw_constraints_b

1280:
1281: -- find all valid constraints
1282: CURSOR c_all_valid_constraints IS
1283: SELECT constraint_rev_id, type_code, objective_code
1284: FROM amw_constraints_b
1285: WHERE start_date <= sysdate AND (end_date IS NULL OR end_date >= sysdate);
1286: l_all_valid_constraints c_all_valid_constraints%ROWTYPE;
1287:
1288: -- find the number of constraint entries(incompatible functions) by specified constraint_rev_id

Line 2026: FROM amw_constraints_b

2022:
2023: -- find all valid constraints
2024: CURSOR c_all_valid_constraints IS
2025: SELECT constraint_rev_id
2026: FROM amw_constraints_b
2027: WHERE start_date <= sysdate AND (end_date IS NULL OR end_date >= sysdate);
2028: l_all_valid_constraints c_all_valid_constraints%ROWTYPE;
2029:
2030: --09.20.2005 tsho Consider Exclusion

Line 2856: ||' from amw_constraints_b cst '

2852: 'select * from ( '
2853: -- ALL
2854: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:1,cst.constraint_rev_id,cst.type_code,:2) NEW_ROLE '
2855: ||' ,cst.constraint_rev_id '
2856: ||' from amw_constraints_b cst '
2857: ||' where cst.type_code = ''ALL'' '
2858: ||' and cst.start_date <= sysdate AND (cst.end_date IS NULL OR cst.end_date >= sysdate) '
2859: ||' and (select count(*) '
2860: ||' from amw_constraint_entries ce '

Line 2906: ||' from amw_constraints_b cst '

2902: ||' UNION ALL '
2903: -- ME
2904: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:7,cst.constraint_rev_id,cst.type_code,:8) NEW_ROLE '
2905: ||' , cst.constraint_rev_id '
2906: ||' from amw_constraints_b cst '
2907: ||' where cst.type_code = ''ME'' '
2908: ||' and cst.start_date <= sysdate AND (cst.end_date IS NULL OR cst.end_date >= sysdate) '
2909: ||' and (select count(distinct rcd.function_id) '
2910: ||' from amw_role_constraint_denorm rcd '

Line 2953: ||' from amw_constraints_b cst '

2949: ||' UNION ALL '
2950: -- SET
2951: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:13,cst.constraint_rev_id,cst.type_code,:14) NEW_ROLE '
2952: ||' ,cst.constraint_rev_id '
2953: ||' from amw_constraints_b cst '
2954: ||' where cst.type_code = ''SET'' '
2955: ||' and cst.start_date <= sysdate AND (cst.end_date IS NULL OR cst.end_date >= sysdate) '
2956: ||' and (select count(distinct rcd.group_code) '
2957: ||' from amw_role_constraint_denorm rcd '

Line 3000: ||' from amw_constraints_b cst '

2996: ||' UNION ALL '
2997: -- RESPALL
2998: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:19,cst.constraint_rev_id,cst.type_code,:20) NEW_ROLE '
2999: ||' ,cst.constraint_rev_id '
3000: ||' from amw_constraints_b cst '
3001: ||' where cst.type_code = ''RESPALL'' '
3002: ||' and cst.start_date <= sysdate AND (cst.end_date IS NULL OR cst.end_date >= sysdate) '
3003: ||' and (select count(*) '
3004: ||' from amw_constraint_entries ce '

Line 3028: ||' from amw_constraints_b cst '

3024: ||' UNION ALL '
3025: -- RESPME
3026: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:23,cst.constraint_rev_id,cst.type_code,:24) NEW_ROLE '
3027: ||' , cst.constraint_rev_id '
3028: ||' from amw_constraints_b cst '
3029: ||' where cst.type_code = ''RESPME'' '
3030: ||' and cst.start_date <= sysdate AND (cst.end_date IS NULL OR cst.end_date >= sysdate) '
3031: ||' and '
3032: || ' (select count(distinct ur.role_orig_system_id ) '

Line 3055: ||' from amw_constraints_b cst '

3051: ||' UNION ALL '
3052: -- RESPSET
3053: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:27,cst.constraint_rev_id,cst.type_code,:28) NEW_ROLE '
3054: ||' , cst.constraint_rev_id '
3055: ||' from amw_constraints_b cst '
3056: ||' where cst.type_code = ''RESPME'' '
3057: ||' and cst.start_date <= sysdate AND (cst.end_date IS NULL OR cst.end_date >= sysdate) '
3058: ||' and '
3059: || ' (select count(distinct ur.role_orig_system_id ) '