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_RESP_PVT dependencies on FND_USER

Line 37: -- 07-OCT-2005 Karen.Tsao Fixed for bug 4644887 - took out the reference to fnd_user_resp_groups in get_partner_users_2().

33: -- 13-AUG-2004 Karen.Tsao Fixed for bug 3830319. Created manage_merged_party_memb_resp() API for party merge routine.
34: -- 18-AUG-2004 Karen.Tsao Updated the logic in manage_merged_party_memb_resp() API based on contact merge happening after resp merge.
35: -- 14-APR-2004 Karen.Tsao Make update_resp_mapping into concurrent program call exec_cre_upd_del_resp_mapping (same as
36: -- create and delete). Therefore, change API name exec_cre_or_del_resp_mapping to exec_cre_upd_del_resp_mapping.
37: -- 07-OCT-2005 Karen.Tsao Fixed for bug 4644887 - took out the reference to fnd_user_resp_groups in get_partner_users_2().
38: --
39: --
40: -- NOTE
41: --

Line 233: FROM pv_partner_profiles pvpp, hz_relationships hzr, jtf_rs_resource_extns jtfre, fnd_user fndu

229: CURSOR c_primary_user_ids IS
230: SELECT user_id
231: FROM (
232: SELECT jtfre.user_id user_id, pvpp.partner_id partner_id
233: FROM pv_partner_profiles pvpp, hz_relationships hzr, jtf_rs_resource_extns jtfre, fnd_user fndu
234: WHERE pvpp.partner_party_id = hzr.object_id
235: AND hzr.relationship_code = 'EMPLOYEE_OF'
236: AND HZR.subject_table_name ='HZ_PARTIES'
237: AND HZR.object_table_name ='HZ_PARTIES'

Line 272: FROM pv_partner_profiles pvpp, hz_relationships hzr, jtf_rs_resource_extns jtfre, fnd_user fndu

268: CURSOR c_business_user_ids IS
269: SELECT user_id
270: FROM (
271: SELECT jtfre.user_id user_id, pvpp.partner_id partner_id
272: FROM pv_partner_profiles pvpp, hz_relationships hzr, jtf_rs_resource_extns jtfre, fnd_user fndu
273: WHERE pvpp.partner_party_id = hzr.object_id
274: AND hzr.relationship_code = 'EMPLOYEE_OF'
275: AND HZR.subject_table_name ='HZ_PARTIES'
276: AND HZR.object_table_name ='HZ_PARTIES'

Line 485: Fnd_User_Resp_Groups_Api.UPLOAD_ASSIGNMENT(

481: FND_MSG_PUB.ADD;
482: raise FND_API.G_EXC_ERROR;
483: END IF;
484:
485: Fnd_User_Resp_Groups_Api.UPLOAD_ASSIGNMENT(
486: user_id => p_user_id,
487: responsibility_id => p_resp_id,
488: responsibility_application_id => p_app_id,
489: start_date => SYSDATE,

Line 603: Fnd_User_Resp_Groups_Api.UPLOAD_ASSIGNMENT(

599:
600: -- Initialize API return status to SUCCESS
601: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
602:
603: Fnd_User_Resp_Groups_Api.UPLOAD_ASSIGNMENT(
604: user_id => p_user_id,
605: responsibility_id => p_resp_id,
606: responsibility_application_id => p_app_id,
607: security_group_id => p_security_group_id,

Line 684: FROM fnd_user_resp_groups

680:
681: IS
682: CURSOR c_get_user_resp_groups IS
683: SELECT user_id, responsibility_id, responsibility_application_id, security_group_id, start_date, description
684: FROM fnd_user_resp_groups
685: WHERE user_id in (
686: SELECT * FROM TABLE (CAST(p_user_id AS JTF_NUMBER_TABLE))
687: )
688: AND responsibility_id = p_resp_id;

Line 832: fnd_user fndu

828: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
829: jtf_auth_principals_b jtfp2,
830: jtf_auth_role_perms jtfrp,
831: jtf_auth_permissions_b jtfperm,
832: fnd_user fndu
833: WHERE fndu.user_id = p_user_id
834: AND jtfp1.principal_name = fndu.user_name
835: AND jtfp1.is_user_flag=1
836: AND jtfp1.jtf_auth_principal_id=jtfpm.jtf_auth_principal_id

Line 2373: from jtf_rs_resource_extns extn, fnd_user usr

2369: )
2370: IS
2371: CURSOR c_get_user_id IS
2372: select usr.user_id
2373: from jtf_rs_resource_extns extn, fnd_user usr
2374: where extn.user_id = usr.user_id
2375: and usr.user_name = p_user_name;
2376:
2377: l_api_name CONSTANT VARCHAR2(30) := 'assign_user_resps';

Line 2512: FROM pv_ge_ptnr_resps p, fnd_user_resp_groups f

2508: )
2509: IS
2510: CURSOR c_get_respid_and_action (cv_partner_id JTF_NUMBER_TABLE, cv_user_id NUMBER, cv_from_user_role_code VARCHAR2, cv_to_user_role_code VARCHAR2) IS
2511: (SELECT /*+LEADING(T) USE_NL(t p f)*/ p.responsibility_id, 'REVOKE' action, f.responsibility_application_id, f.security_group_id, f.start_date, f.description
2512: FROM pv_ge_ptnr_resps p, fnd_user_resp_groups f
2513: WHERE partner_id in (
2514: SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))
2515: )
2516: AND p.user_role_code = cv_from_user_role_code

Line 2522: FROM pv_ge_ptnr_resps p, fnd_user_resp_groups f

2518: AND f.user_id = cv_user_id
2519: AND p.resp_type_code = G_PROGRAM
2520: MINUS
2521: SELECT /*+LEADING(T) USE_NL(t p f)*/ p.responsibility_id, 'REVOKE' action, f.responsibility_application_id, f.security_group_id, f.start_date, f.description
2522: FROM pv_ge_ptnr_resps p, fnd_user_resp_groups f
2523: WHERE partner_id in (
2524: SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))
2525: )
2526: AND p.user_role_code = cv_to_user_role_code

Line 2533: FROM pv_ge_ptnr_resps p, fnd_user_resp_groups f

2529: AND p.resp_type_code = G_PROGRAM
2530: )
2531: UNION
2532: (SELECT /*+LEADING(T) USE_NL(t p f)*/ p.responsibility_id, 'ASSIGN' action, f.responsibility_application_id, f.security_group_id, f.start_date, f.description
2533: FROM pv_ge_ptnr_resps p, fnd_user_resp_groups f
2534: WHERE partner_id in (
2535: SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))
2536: )
2537: AND p.user_role_code = cv_to_user_role_code

Line 2543: FROM pv_ge_ptnr_resps p, fnd_user_resp_groups f

2539: AND f.user_id = cv_user_id
2540: AND p.resp_type_code = G_PROGRAM
2541: MINUS
2542: SELECT /*+LEADING(T) USE_NL(t p f)*/ p.responsibility_id, 'ASSIGN' action, f.responsibility_application_id, f.security_group_id, f.start_date, f.description
2543: FROM pv_ge_ptnr_resps p, fnd_user_resp_groups f
2544: WHERE partner_id in (
2545: SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))
2546: )
2547: AND p.user_role_code = cv_from_user_role_code

Line 4950: fnd_user_resp_groups f

4946: p.responsibility_id, f.responsibility_application_id, f.security_group_id,
4947: f.start_date, f.description, f.user_id
4948: FROM pv_ge_ptnr_resps p,
4949: (SELECT column_value FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))) t ,
4950: fnd_user_resp_groups f
4951: WHERE p.partner_id = t.column_value
4952: AND nvl(end_date, sysdate) >= sysdate
4953: AND f.user_id = p_user_id
4954: AND f.responsibility_id = p.responsibility_id

Line 4962: FROM fnd_user_resp_groups,

4958: CURSOR c_get_user_resp_groups (cv_responsibility_id_tbl JTF_NUMBER_TABLE) IS
4959: SELECT
4960: user_id, responsibility_id, responsibility_application_id, security_group_id,
4961: start_date, description
4962: FROM fnd_user_resp_groups,
4963: (SELECT column_value FROM TABLE (CAST(cv_responsibility_id_tbl AS JTF_NUMBER_TABLE))) t
4964: WHERE responsibility_id = t.column_value
4965: AND user_id = p_user_id;
4966:

Line 5113: from jtf_rs_resource_extns extn, fnd_user usr

5109: IS
5110:
5111: CURSOR c_get_user_id IS
5112: select usr.user_id
5113: from jtf_rs_resource_extns extn, fnd_user usr
5114: where extn.user_id = usr.user_id
5115: and usr.user_name = p_user_name;
5116:
5117: l_api_name CONSTANT VARCHAR2(30) := 'revoke_user_resps';

Line 5662: FROM hz_relationships hzr, jtf_rs_resource_extns jtfre, pv_partner_profiles pvpp, fnd_user fndu

5658: )
5659: IS
5660: CURSOR c_get_primary_users IS
5661: SELECT jtfre.user_id user_id
5662: FROM hz_relationships hzr, jtf_rs_resource_extns jtfre, pv_partner_profiles pvpp, fnd_user fndu
5663: WHERE pvpp.partner_id = p_partner_id
5664: AND pvpp.status = 'A'
5665: AND pvpp.partner_party_id = hzr.object_id
5666: AND hzr.directional_flag = 'F'

Line 5706: pv_partner_profiles pvpp, fnd_user fndu

5702: CURSOR c_get_business_users IS
5703: SELECT jtfre.user_id user_id
5704: FROM hz_relationships hzr,
5705: jtf_rs_resource_extns jtfre,
5706: pv_partner_profiles pvpp, fnd_user fndu
5707: WHERE pvpp.partner_id = p_partner_id
5708: AND pvpp.status = 'A'
5709: AND pvpp.partner_party_id = hzr.object_id
5710: AND hzr.directional_flag = 'F'

Line 6580: FROM fnd_user_resp_groups

6576: AND resp_type_code = G_PROGRAM;
6577:
6578: CURSOR c_get_user_resp_groups IS
6579: SELECT user_id, responsibility_id, responsibility_application_id, security_group_id, start_date, description
6580: FROM fnd_user_resp_groups
6581: WHERE user_id = p_user_id
6582: AND responsibility_id = p_def_resp_id;
6583:
6584: l_api_name CONSTANT VARCHAR2(30) := 'adjust_user_resps';