APPS.PV_USER_MGMT_PVT dependencies on DUAL

Line 84: and role_resource_type = 'RS_INDIVIDUAL'

80: cursor c_get_role_relate_id(cv_resource_id NUMBER) is
81: select role_relate_id
82: from jtf_rs_role_relations rr, jtf_rs_roles_b rrb
83: where role_resource_id = cv_resource_id
84: and role_resource_type = 'RS_INDIVIDUAL'
85: and rr.start_date_active <= sysdate
86: and (rr.end_date_active is null or rr.end_date_active >=sysdate)
87: and rrb.role_id = rr.role_id
88: and rrb.role_code= 'PARTNER_CONTACT_MEMBER'

Line 257: resourceRec.role_resource_type := 'RS_INDIVIDUAL';

253: IF (PV_DEBUG_HIGH_ON) THEN
254: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_role_exists := false');
255: END IF;
256: resourceRec.role_resource_id := l_resource_id;
257: resourceRec.role_resource_type := 'RS_INDIVIDUAL';
258: resourceRec.role_code := 'PARTNER_CONTACT_MEMBER';
259: --PVX_UTILITY_PVT.debug_message('admin role for individual');
260: PVX_Misc_PVT.Admin_Role
261: (

Line 259: --PVX_UTILITY_PVT.debug_message('admin role for individual');

255: END IF;
256: resourceRec.role_resource_id := l_resource_id;
257: resourceRec.role_resource_type := 'RS_INDIVIDUAL';
258: resourceRec.role_code := 'PARTNER_CONTACT_MEMBER';
259: --PVX_UTILITY_PVT.debug_message('admin role for individual');
260: PVX_Misc_PVT.Admin_Role
261: (
262: p_api_version => p_api_version_number
263: ,p_init_msg_list => FND_API.g_false

Line 1421: select 'X' from dual

1417: group by jtfperm.permission_name;
1418:
1419:
1420: cursor validate_partner_user(l_user_id NUMBER) IS
1421: select 'X' from dual
1422: where exists
1423: (select 'X' from jtf_rs_resource_extns
1424: where user_id = l_user_id and category='PARTY');
1425:

Line 1980: select 1 from dual where exists

1976:
1977: FUNCTION is_partner_user (p_rel_party_id IN NUMBER) RETURN VARCHAR2 IS
1978:
1979: cursor cv_is_partner_user(l_rel_party_id NUMBER) IS
1980: select 1 from dual where exists
1981: (
1982: select /*+ use_nl (hzr res) */ pvpp.partner_id, hzr.party_id, hzr.subject_id ,pvpp.partner_party_id
1983: from jtf_rs_resource_extns RES, hz_relationships hzr, pv_partner_profiles pvpp
1984: where RES.category = 'PARTY' and RES.source_id = 6310

Line 2070: select 1 from dual

2066: and usr.user_id = jureg.user_id;
2067:
2068: -- check if the person is a partner user
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

Line 2276: FROM dual

2272: AND rule.ACTIVE_FLAG = 'Y';
2273:
2274: CURSOR c_is_no_prereq_membership(c_program_id NUMBER, c_partner_id NUMBER) IS
2275: SELECT 1
2276: FROM dual
2277: WHERE not exists(
2278: SELECT 1
2279: FROM pv_pg_memberships memb
2280: WHERE memb.program_id = c_program_id

Line 2289: FROM dual;

2285: );
2286:
2287: CURSOR c_elig_program_id_seq IS
2288: SELECT PV_PG_ELIG_PROGRAMS_S.NEXTVAL
2289: FROM dual;
2290:
2291: l_api_name CONSTANT VARCHAR2(30) := 'update_elig_prgm_4_new_ptnr';
2292: l_cnt NUMBER;
2293: l_partner_id NUMBER;