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_NUMBER_TABLE

Line 887: cursor check_curr_user_perms(l_role_id JTF_NUMBER_TABLE, l_user_name varchar2) IS

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

Line 900: and jtfpm.jtf_auth_parent_principal_id NOT IN (Select * from table (CAST(l_role_id AS JTF_NUMBER_TABLE)))

896: and jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_id
897: and jtfperm.permission_name in ( G_PRIMARY_PERMISSION, G_PARTNER_PERMISSION)
898: and jtfd.jtf_auth_domain_id=jtfpm.jtf_auth_domain_id
899: and jtfd.domain_name='CRM_DOMAIN'
900: and jtfpm.jtf_auth_parent_principal_id NOT IN (Select * from table (CAST(l_role_id AS JTF_NUMBER_TABLE)))
901: group by jtfperm.permission_name;
902:
903: cursor get_user_id(l_user_name varchar2) IS
904: Select fndu.user_id

Line 912: l_role_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

908:
909:
910: is_prtnr_perm_revoked boolean := false;
911: is_primary_perm_revoked boolean := false;
912: l_role_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
913: is_primary_user boolean := false;
914: is_partner_user boolean := false;
915: l_user_id NUMBER;
916: l_role varchar2(10);

Line 1126: cursor get_users_w_curr_role(cv_role_id JTF_NUMBER_TABLE) IS

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
1127: select /*+ cardinality( t 10 ) */ jtfp2.principal_name, fndu.user_id
1128: from jtf_auth_principal_maps jtfpm, jtf_auth_principals_b jtfp2,jtf_auth_principals_b jtfp1,
1129: fnd_user fndu, jtf_rs_resource_extns jtfre, (Select column_value from table
1130: (CAST(cv_role_id AS JTF_NUMBER_TABLE))) t

Line 1130: (CAST(cv_role_id AS JTF_NUMBER_TABLE))) t

1126: cursor get_users_w_curr_role(cv_role_id JTF_NUMBER_TABLE) IS
1127: select /*+ cardinality( t 10 ) */ jtfp2.principal_name, fndu.user_id
1128: from jtf_auth_principal_maps jtfpm, jtf_auth_principals_b jtfp2,jtf_auth_principals_b jtfp1,
1129: fnd_user fndu, jtf_rs_resource_extns jtfre, (Select column_value from table
1130: (CAST(cv_role_id AS JTF_NUMBER_TABLE))) t
1131: where jtfp1.jtf_auth_principal_id = t.column_value
1132: and jtfp1.is_user_flag = 0
1133: and jtfp1.jtf_auth_principal_id = jtfpm.jtf_auth_parent_principal_id
1134: and jtfpm.jtf_auth_principal_id = jtfp2.jtf_auth_principal_id

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 1148: and jtfpm2.jtf_auth_parent_principal_id NOT IN (Select * from table (CAST(cv_role_id AS JTF_NUMBER_TABLE)))

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)))
1149: and jtfrp.JTF_AUTH_PERMISSION_ID = jtfperm.jtf_auth_permission_id
1150: and jtfperm.permission_name IN (G_PRIMARY_PERMISSION, G_PARTNER_PERMISSION)
1151: and jtfrp.positive_flag = 1
1152: group by jtfperm.permission_name, jtfp3.principal_name

Line 1161: l_role_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1157: is_primary_perm_revoked boolean := false;
1158: is_primary_user boolean := false;
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:

Line 1162: l_user_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1158: is_primary_user boolean := false;
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;

Line 1428: l_role_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1424: where user_id = l_user_id and category='PARTY');
1425:
1426: is_prtnr_perm_assigned boolean := false;
1427: is_primary_perm_assigned boolean := false;
1428: l_role_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1429: is_primary_user boolean := false;
1430: is_partner_user boolean := false;
1431: l_user_id NUMBER;
1432: is_user_changed boolean := true;

Line 1682: l_user_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1678:
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);

Line 2295: l_program_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2291: l_api_name CONSTANT VARCHAR2(30) := 'update_elig_prgm_4_new_ptnr';
2292: l_cnt NUMBER;
2293: l_partner_id NUMBER;
2294: l_member_type VARCHAR2(500);
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;

Line 2296: l_process_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2292: l_cnt NUMBER;
2293: l_partner_id NUMBER;
2294: l_member_type VARCHAR2(500);
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;

Line 2297: l_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2293: l_partner_id NUMBER;
2294: l_member_type VARCHAR2(500);
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;

Line 2298: l_attr_id_tbl JTF_NUMBER_TABLE;

2294: l_member_type VARCHAR2(500);
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);