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.PV_USER_MGMT_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 865: ,p_role_name IN JTF_VARCHAR2_TABLE_1000

861: (
862: p_api_version_number IN NUMBER
863: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
864: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
865: ,p_role_name IN JTF_VARCHAR2_TABLE_1000
866: ,p_user_name IN VARCHAR2
867: ,x_return_status OUT NOCOPY VARCHAR2
868: ,x_msg_count OUT NOCOPY NUMBER
869: ,x_msg_data OUT NOCOPY VARCHAR2

Line 878: cursor check_curr_role_perms(l_role_name JTF_VARCHAR2_TABLE_1000) IS

874: l_api_name CONSTANT VARCHAR2(30) := 'revoke_role';
875: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
876:
877:
878: cursor check_curr_role_perms(l_role_name JTF_VARCHAR2_TABLE_1000) IS
879: select jtfperm.permission_name , jtfp1.jtf_auth_principal_id
880: from jtf_auth_principals_b jtfp1, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm
881: where jtfp1.is_user_flag = 0
882: and jtfp1.jtf_auth_principal_id = jtfrp.jtf_auth_principal_id

Line 886: and jtfp1.principal_name IN (Select * from table (CAST(l_role_name AS JTF_VARCHAR2_TABLE_1000)));

882: and jtfp1.jtf_auth_principal_id = jtfrp.jtf_auth_principal_id
883: and jtfrp.positive_flag = 1
884: and jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_id
885: and jtfperm.permission_name in (G_PRIMARY_PERMISSION, G_PARTNER_PERMISSION)
886: and jtfp1.principal_name IN (Select * from table (CAST(l_role_name AS JTF_VARCHAR2_TABLE_1000)));
887:
888:
889: cursor check_curr_user_perms(l_role_id JTF_NUMBER_TABLE, l_user_name varchar2) IS
890: Select jtfperm.permission_name

Line 1104: ,p_role_name IN JTF_VARCHAR2_TABLE_1000

1100: (
1101: p_api_version_number IN NUMBER
1102: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1103: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1104: ,p_role_name IN JTF_VARCHAR2_TABLE_1000
1105: ,x_return_status OUT NOCOPY VARCHAR2
1106: ,x_msg_count OUT NOCOPY NUMBER
1107: ,x_msg_data OUT NOCOPY VARCHAR2
1108: )

Line 1116: cursor check_curr_role_perms(cv_role_name JTF_VARCHAR2_TABLE_1000) IS

1112: l_api_name CONSTANT VARCHAR2(30) := 'delete_role';
1113: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1114:
1115:
1116: cursor check_curr_role_perms(cv_role_name JTF_VARCHAR2_TABLE_1000) IS
1117: select jtfperm.permission_name , jtfp1.jtf_auth_principal_id
1118: from jtf_auth_principals_b jtfp1, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm
1119: where jtfp1.is_user_flag = 0
1120: and jtfp1.jtf_auth_principal_id = jtfrp.jtf_auth_principal_id

Line 1124: and jtfp1.principal_name IN (Select * from table (CAST(cv_role_name AS JTF_VARCHAR2_TABLE_1000)));

1120: and jtfp1.jtf_auth_principal_id = jtfrp.jtf_auth_principal_id
1121: and jtfrp.positive_flag = 1
1122: and jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_id
1123: and jtfperm.permission_name in (G_PRIMARY_PERMISSION, G_PARTNER_PERMISSION)
1124: and jtfp1.principal_name IN (Select * from table (CAST(cv_role_name AS JTF_VARCHAR2_TABLE_1000)));
1125:
1126:
1127:
1128: cursor get_users_w_curr_role(cv_role_id JTF_NUMBER_TABLE) IS

Line 1144: cursor get_usrs_perm_wo_curr_role(cv_role_id JTF_NUMBER_TABLE, cv_user_name JTF_VARCHAR2_TABLE_1000) IS

1140: and jtfre.category = 'PARTY';
1141:
1142:
1143: /** ??? Does this query need to handle inactive resources or partner contacts **/
1144: cursor get_usrs_perm_wo_curr_role(cv_role_id JTF_NUMBER_TABLE, cv_user_name JTF_VARCHAR2_TABLE_1000) IS
1145: select /*+ cardinality( t 10 ) */ jtfperm.permission_name, jtfp3.principal_name
1146: from jtf_auth_principals_b jtfp3, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm, jtf_auth_principal_maps jtfpm2, (Select column_value from table (CAST(cv_user_name AS JTF_VARCHAR2_TABLE_1000))) t
1147: where jtfp3.principal_name = t.column_value
1148: and jtfp3.is_user_flag = 1 and jtfp3.jtf_auth_principal_id=jtfpm2.jtf_auth_principal_id

Line 1146: from jtf_auth_principals_b jtfp3, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm, jtf_auth_principal_maps jtfpm2, (Select column_value from table (CAST(cv_user_name AS JTF_VARCHAR2_TABLE_1000))) t

1142:
1143: /** ??? Does this query need to handle inactive resources or partner contacts **/
1144: cursor get_usrs_perm_wo_curr_role(cv_role_id JTF_NUMBER_TABLE, cv_user_name JTF_VARCHAR2_TABLE_1000) IS
1145: select /*+ cardinality( t 10 ) */ jtfperm.permission_name, jtfp3.principal_name
1146: from jtf_auth_principals_b jtfp3, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm, jtf_auth_principal_maps jtfpm2, (Select column_value from table (CAST(cv_user_name AS JTF_VARCHAR2_TABLE_1000))) t
1147: where jtfp3.principal_name = t.column_value
1148: and jtfp3.is_user_flag = 1 and jtfp3.jtf_auth_principal_id=jtfpm2.jtf_auth_principal_id
1149: and jtfpm2.jtf_auth_parent_principal_id = jtfrp.JTF_AUTH_PRINCIPAL_ID
1150: and jtfpm2.jtf_auth_parent_principal_id NOT IN (Select * from table (CAST(cv_role_id AS JTF_NUMBER_TABLE)))

Line 1165: l_user_names JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

1161: is_partner_user boolean := false;
1162:
1163: l_role_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1164: l_user_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1165: l_user_names JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
1166: l_user_perm_changed JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
1167:
1168: l_prev_user_name VARCHAR2(255) := null;
1169: l_role varchar2(10);

Line 1166: l_user_perm_changed JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

1162:
1163: l_role_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1164: l_user_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1165: l_user_names JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
1166: l_user_perm_changed JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
1167:
1168: l_prev_user_name VARCHAR2(255) := null;
1169: l_role varchar2(10);
1170:

Line 1382: ,p_role_name IN JTF_VARCHAR2_TABLE_1000

1378: (
1379: p_api_version_number IN NUMBER
1380: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1381: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1382: ,p_role_name IN JTF_VARCHAR2_TABLE_1000
1383: ,p_user_name IN VARCHAR2
1384: ,x_return_status OUT NOCOPY VARCHAR2
1385: ,x_msg_count OUT NOCOPY NUMBER
1386: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1394: cursor check_curr_role_perms(l_role_name JTF_VARCHAR2_TABLE_1000) IS

1390: l_api_name CONSTANT VARCHAR2(30) := 'assign_role';
1391: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1392:
1393:
1394: cursor check_curr_role_perms(l_role_name JTF_VARCHAR2_TABLE_1000) IS
1395: select jtfperm.permission_name
1396: from jtf_auth_principals_b jtfp1, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm
1397: where jtfp1.is_user_flag = 0 and jtfp1.jtf_auth_principal_id = jtfrp.jtf_auth_principal_id
1398: and jtfrp.positive_flag = 1 and jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_id

Line 1400: and jtfp1.principal_name in (Select * from table (CAST(l_role_name AS JTF_VARCHAR2_TABLE_1000)))

1396: from jtf_auth_principals_b jtfp1, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm
1397: where jtfp1.is_user_flag = 0 and jtfp1.jtf_auth_principal_id = jtfrp.jtf_auth_principal_id
1398: and jtfrp.positive_flag = 1 and jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_id
1399: and jtfperm.permission_name IN ( G_PRIMARY_PERMISSION, G_PARTNER_PERMISSION)
1400: and jtfp1.principal_name in (Select * from table (CAST(l_role_name AS JTF_VARCHAR2_TABLE_1000)))
1401: group by jtfperm.permission_name;
1402:
1403: cursor get_user_id(l_user_name VARCHAR2) IS
1404: select fndu.user_id

Line 1625: ,p_assigned_perms IN JTF_VARCHAR2_TABLE_1000

1621: (
1622: p_api_version_number IN NUMBER
1623: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1624: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1625: ,p_assigned_perms IN JTF_VARCHAR2_TABLE_1000
1626: ,p_unassigned_perms IN JTF_VARCHAR2_TABLE_1000
1627: ,p_role_name IN VARCHAR2
1628: ,x_return_status OUT NOCOPY VARCHAR2
1629: ,x_msg_count OUT NOCOPY NUMBER

Line 1626: ,p_unassigned_perms IN JTF_VARCHAR2_TABLE_1000

1622: p_api_version_number IN NUMBER
1623: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1624: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1625: ,p_assigned_perms IN JTF_VARCHAR2_TABLE_1000
1626: ,p_unassigned_perms IN JTF_VARCHAR2_TABLE_1000
1627: ,p_role_name IN VARCHAR2
1628: ,x_return_status OUT NOCOPY VARCHAR2
1629: ,x_msg_count OUT NOCOPY NUMBER
1630: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1638: cursor get_user_permissions(cv_role_id NUMBER, cv_user_name JTF_VARCHAR2_TABLE_1000) IS

1634: l_api_name CONSTANT VARCHAR2(30) := 'update_role';
1635: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1636:
1637:
1638: cursor get_user_permissions(cv_role_id NUMBER, cv_user_name JTF_VARCHAR2_TABLE_1000) IS
1639: select /*+ cardinality( t 10 ) */ jtfperm.permission_name, jtfp3.principal_name
1640: from jtf_auth_principals_b jtfp3, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm, jtf_auth_principal_maps jtfpm2, (Select column_value from table (CAST(cv_user_name AS JTF_VARCHAR2_TABLE_1000))) t
1641: where jtfp3.principal_name = t.column_value
1642: and jtfp3.is_user_flag = 1

Line 1640: from jtf_auth_principals_b jtfp3, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm, jtf_auth_principal_maps jtfpm2, (Select column_value from table (CAST(cv_user_name AS JTF_VARCHAR2_TABLE_1000))) t

1636:
1637:
1638: cursor get_user_permissions(cv_role_id NUMBER, cv_user_name JTF_VARCHAR2_TABLE_1000) IS
1639: select /*+ cardinality( t 10 ) */ jtfperm.permission_name, jtfp3.principal_name
1640: from jtf_auth_principals_b jtfp3, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm, jtf_auth_principal_maps jtfpm2, (Select column_value from table (CAST(cv_user_name AS JTF_VARCHAR2_TABLE_1000))) t
1641: where jtfp3.principal_name = t.column_value
1642: and jtfp3.is_user_flag = 1
1643: and jtfp3.jtf_auth_principal_id=jtfpm2.jtf_auth_principal_id
1644: and jtfpm2.jtf_auth_parent_principal_id = jtfrp.JTF_AUTH_PRINCIPAL_ID

Line 1685: l_user_names JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

1681: is_primary_user boolean := false;
1682: is_partner_user boolean := false;
1683:
1684: l_user_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1685: l_user_names JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
1686: l_user_perm_changed JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
1687:
1688: l_role varchar2(10);
1689: l_prev_user_name VARCHAR2(255);

Line 1686: l_user_perm_changed JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

1682: is_partner_user boolean := false;
1683:
1684: l_user_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1685: l_user_names JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
1686: l_user_perm_changed JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
1687:
1688: l_role varchar2(10);
1689: l_prev_user_name VARCHAR2(255);
1690: l_role_id NUMBER;

Line 2302: l_attr_evaluation_result_tbl JTF_VARCHAR2_TABLE_100;

2298: l_program_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2299: l_process_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2300: l_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2301: l_attr_id_tbl JTF_NUMBER_TABLE;
2302: l_attr_evaluation_result_tbl JTF_VARCHAR2_TABLE_100;
2303: l_partner_attr_value_tbl JTF_VARCHAR2_TABLE_4000;
2304: l_evaluation_criteria_tbl JTF_VARCHAR2_TABLE_4000;
2305: l_rule_pass_flag VARCHAR2(4);
2306: l_delimiter VARCHAR2(10);