DBA Data[Home] [Help]

APPS.AMW_VIOLATION_PUB dependencies on JTF_VARCHAR2_TABLE_400

Line 696: l_new_func_table JTF_VARCHAR2_TABLE_400;

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

Line 1420: l_existing_role_table JTF_VARCHAR2_TABLE_400;

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:

Line 1514: l_existing_resp_table JTF_VARCHAR2_TABLE_400;

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:

Line 1625: l_existing_menu_table JTF_VARCHAR2_TABLE_400;

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: