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 1423: select 'X' from dual

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

Line 1982: select 1 from dual where exists

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

Line 2072: select 1 from dual

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

Line 2279: FROM dual

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

Line 2292: FROM dual;

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