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_AUTH_PERMISSIONS_B

Line 458: from jtf_auth_principals_b jtfp1, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm

454: l_partner_types_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;
455:
456: cursor get_user_role(l_user_type_id NUMBER) IS
457: select jtfperm.permission_name
458: from jtf_auth_principals_b jtfp1, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm
459: where jtfp1.is_user_flag = 0
460: and jtfp1.jtf_auth_principal_id = jtfrp.jtf_auth_principal_id
461: and jtfrp.positive_flag = 1
462: and jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_id

Line 676: from jtf_auth_principals_b jtfp1, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm

672:
673:
674: cursor get_user_role(l_user_type_id NUMBER) IS
675: select jtfperm.permission_name
676: from jtf_auth_principals_b jtfp1, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm
677: where jtfp1.is_user_flag = 0
678: and jtfp1.jtf_auth_principal_id = jtfrp.jtf_auth_principal_id
679: and jtfrp.positive_flag = 1
680: and jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_id

Line 878: from jtf_auth_principals_b jtfp1, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm

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
881: and jtfrp.positive_flag = 1
882: and jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_id

Line 890: jtf_auth_permissions_b jtfperm

886:
887: cursor check_curr_user_perms(l_role_id JTF_NUMBER_TABLE, l_user_name varchar2) IS
888: Select jtfperm.permission_name
889: FROM jtf_auth_principal_maps jtfpm, jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd, jtf_auth_role_perms jtfrp,
890: jtf_auth_permissions_b jtfperm
891: where jtfp1.principal_name = l_user_name
892: and jtfp1.is_user_flag=1
893: and jtfp1.jtf_auth_principal_id=jtfpm.jtf_auth_principal_id
894: and jtfrp.jtf_auth_principal_id = jtfpm.jtf_auth_parent_principal_id

Line 1116: from jtf_auth_principals_b jtfp1, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm

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
1119: and jtfrp.positive_flag = 1
1120: and jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_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 1394: from jtf_auth_principals_b jtfp1, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm

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
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)))

Line 1409: jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm

1405:
1406: cursor get_user_permissions(l_user_name VARCHAR2) IS
1407: select jtfperm.permission_name
1408: from jtf_auth_principals_b jtfp1, jtf_auth_principal_maps jtfpm,
1409: jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm
1410: where jtfp1.principal_name = l_user_name
1411: and jtfp1.is_user_flag = 1
1412: and jtfp1.jtf_auth_principal_id = jtfpm.jtf_auth_principal_id
1413: and jtfpm.JTF_AUTH_PARENT_PRINCIPAL_ID = jtfrp.jtf_auth_principal_id

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 1667: from jtf_auth_principals_b jtfp1, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm

1663:
1664:
1665: cursor check_curr_role_perms(l_role_name VARCHAR2) IS
1666: select jtfperm.permission_name, jtfp1.jtf_auth_principal_id
1667: from jtf_auth_principals_b jtfp1, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm
1668: where jtfp1.is_user_flag = 0 and jtfp1.jtf_auth_principal_id = jtfrp.jtf_auth_principal_id
1669: and jtfrp.positive_flag = 1 and jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_id
1670: and jtfperm.permission_name IN ( G_PRIMARY_PERMISSION, G_PARTNER_PERMISSION)
1671: and jtfp1.principal_name = l_role_name;

Line 1995: jtf_auth_principals_b jtfp2,jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm

1991: and hzr.object_id = pvpp.partner_party_id
1992: and pvpp.status = 'A' and exists
1993: (
1994: select 1 from jtf_auth_principal_maps jtfpm,jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
1995: jtf_auth_principals_b jtfp2,jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm
1996: where jtfp1.principal_name = RES.user_name and jtfp1.is_user_flag=1
1997: and jtfp1.jtf_auth_principal_id=jtfpm.jtf_auth_principal_id and jtfpm.jtf_auth_parent_principal_id = jtfp2.jtf_auth_principal_id
1998: and jtfp2.is_user_flag=0 and jtfp2.jtf_auth_principal_id = jtfrp.jtf_auth_principal_id
1999: and jtfrp.positive_flag = 1 and jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_id

Line 2073: from jtf_auth_principals_b jtfp1, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm

2069: Cursor c_is_partner_user(c_usertype_id NUMBER) is
2070: select 1 from dual
2071: where exists
2072: ( select jtfperm.permission_name
2073: from jtf_auth_principals_b jtfp1, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm
2074: where jtfp1.is_user_flag = 0
2075: and jtfp1.jtf_auth_principal_id = jtfrp.jtf_auth_principal_id
2076: and jtfrp.positive_flag = 1
2077: and jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_id