692: l_violat_new_func VARCHAR2(10000);
693:
694: l_resp_access_count NUMBER;
695:
696: l_new_func_table JTF_VARCHAR2_TABLE_400;
697:
698: -- 05.23.2006 dliao: consider only Prevent Constraint Objective
699: CURSOR c_all_valid_constraints IS
700: SELECT constraint_rev_id, type_code, constraint_name
1416: -- store the return value
1417: l_existing_role_string VARCHAR2(32767);
1418:
1419: -- store the existing role this user has against this constraint
1420: l_existing_role_table JTF_VARCHAR2_TABLE_400;
1421:
1422: TYPE refCurTyp IS REF CURSOR;
1423: existing_role_c refCurTyp;
1424:
1510: -- store the return value
1511: l_existing_resp_string VARCHAR2(32767);
1512:
1513: -- store the existing responsibilities this user has against this constraint
1514: l_existing_resp_table JTF_VARCHAR2_TABLE_400;
1515:
1516: TYPE refCurTyp IS REF CURSOR;
1517: existing_resp_c refCurTyp;
1518:
1621: -- store the return value
1622: l_existing_menu_string VARCHAR2(32767);
1623:
1624: -- store the existing menus this user has against this constraint
1625: l_existing_menu_table JTF_VARCHAR2_TABLE_400;
1626:
1627: TYPE refCurTyp IS REF CURSOR;
1628: existing_menu_c refCurTyp;
1629: