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 863: ,p_role_name IN JTF_VARCHAR2_TABLE_1000

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

Line 876: cursor check_curr_role_perms(l_role_name JTF_VARCHAR2_TABLE_1000) IS

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

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

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

Line 1102: ,p_role_name IN JTF_VARCHAR2_TABLE_1000

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

Line 1114: cursor check_curr_role_perms(cv_role_name JTF_VARCHAR2_TABLE_1000) IS

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

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

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

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

1138: and jtfre.category = 'PARTY';
1139:
1140:
1141: /** ??? Does this query need to handle inactive resources or partner contacts **/
1142: cursor get_usrs_perm_wo_curr_role(cv_role_id JTF_NUMBER_TABLE, cv_user_name JTF_VARCHAR2_TABLE_1000) IS
1143: select /*+ cardinality( t 10 ) */ jtfperm.permission_name, jtfp3.principal_name
1144: 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
1145: where jtfp3.principal_name = t.column_value
1146: and jtfp3.is_user_flag = 1 and jtfp3.jtf_auth_principal_id=jtfpm2.jtf_auth_principal_id

Line 1144: 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

1140:
1141: /** ??? Does this query need to handle inactive resources or partner contacts **/
1142: cursor get_usrs_perm_wo_curr_role(cv_role_id JTF_NUMBER_TABLE, cv_user_name JTF_VARCHAR2_TABLE_1000) IS
1143: select /*+ cardinality( t 10 ) */ jtfperm.permission_name, jtfp3.principal_name
1144: 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
1145: where jtfp3.principal_name = t.column_value
1146: and jtfp3.is_user_flag = 1 and jtfp3.jtf_auth_principal_id=jtfpm2.jtf_auth_principal_id
1147: and jtfpm2.jtf_auth_parent_principal_id = jtfrp.JTF_AUTH_PRINCIPAL_ID
1148: and jtfpm2.jtf_auth_parent_principal_id NOT IN (Select * from table (CAST(cv_role_id AS JTF_NUMBER_TABLE)))

Line 1163: l_user_names JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

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

Line 1164: l_user_perm_changed JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

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

Line 1380: ,p_role_name IN JTF_VARCHAR2_TABLE_1000

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

Line 1392: cursor check_curr_role_perms(l_role_name JTF_VARCHAR2_TABLE_1000) IS

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

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

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

Line 1623: ,p_assigned_perms IN JTF_VARCHAR2_TABLE_1000

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

Line 1624: ,p_unassigned_perms IN JTF_VARCHAR2_TABLE_1000

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

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

1632: l_api_name CONSTANT VARCHAR2(30) := 'update_role';
1633: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1634:
1635:
1636: cursor get_user_permissions(cv_role_id NUMBER, cv_user_name JTF_VARCHAR2_TABLE_1000) IS
1637: select /*+ cardinality( t 10 ) */ jtfperm.permission_name, jtfp3.principal_name
1638: 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
1639: where jtfp3.principal_name = t.column_value
1640: and jtfp3.is_user_flag = 1

Line 1638: 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

1634:
1635:
1636: cursor get_user_permissions(cv_role_id NUMBER, cv_user_name JTF_VARCHAR2_TABLE_1000) IS
1637: select /*+ cardinality( t 10 ) */ jtfperm.permission_name, jtfp3.principal_name
1638: 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
1639: where jtfp3.principal_name = t.column_value
1640: and jtfp3.is_user_flag = 1
1641: and jtfp3.jtf_auth_principal_id=jtfpm2.jtf_auth_principal_id
1642: and jtfpm2.jtf_auth_parent_principal_id = jtfrp.JTF_AUTH_PRINCIPAL_ID

Line 1683: l_user_names JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

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

Line 1684: l_user_perm_changed JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

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

Line 2299: l_attr_evaluation_result_tbl JTF_VARCHAR2_TABLE_100;

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