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

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

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

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

Line 892: jtf_auth_permissions_b jtfperm

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

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

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

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

Line 1411: jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm

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

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

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

Line 1997: jtf_auth_principals_b jtfp2,jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm

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

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

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