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 PV_PG_MEMBERSHIPS

Line 1478: FROM pv_pg_memberships mem, (SELECT column_value FROM TABLE (CAST(p_partner_id AS JTF_NUMBER_TABLE))) t

1474: FROM pv_partner_program_b
1475: START WITH program_id in
1476: (
1477: SELECT /*+ leading(T) USE_NL(T MEM)*/ mem.program_id
1478: FROM pv_pg_memberships mem, (SELECT column_value FROM TABLE (CAST(p_partner_id AS JTF_NUMBER_TABLE))) t
1479: WHERE mem.partner_id = t.column_value
1480: AND mem.membership_status_code = 'ACTIVE'
1481: )
1482: CONNECT BY PRIOR program_parent_id = program_id

Line 2093: FROM pv_pg_memberships,

2089: AND resp_type_code = cv_resp_type_code;
2090:
2091: CURSOR c_get_program_id (cv_partner_id JTF_NUMBER_TABLE) IS
2092: SELECT /*+ CARDINALITY(t 10) */ program_id, partner_id
2093: FROM pv_pg_memberships,
2094: (SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))) t
2095: WHERE partner_id = t.column_value
2096: AND membership_status_code = 'ACTIVE';
2097:

Line 3247: * pv_pg_memberships table.

3243:
3244: /*
3245: * manage_active_memb_resp
3246: * This private API gets called when new 'ACTIVE' membership row is created in
3247: * pv_pg_memberships table.
3248: */
3249: PROCEDURE manage_active_memb_resp(
3250: p_api_version_number IN NUMBER
3251: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

Line 3271: FROM pv_pg_mmbr_transitions tran, pv_pg_memberships prev

3267: AND resp_type_code = G_PROGRAM;
3268:
3269: CURSOR c_get_prev_memberships (cv_membership_id NUMBER) IS
3270: SELECT prev.program_id
3271: FROM pv_pg_mmbr_transitions tran, pv_pg_memberships prev
3272: WHERE tran.to_membership_id = cv_membership_id
3273: AND prev.membership_id = tran.from_membership_id;
3274:
3275: l_api_name CONSTANT VARCHAR2(30) := 'manage_active_memb_resp';

Line 3762: * This should be called when a new row is created in pv_pg_memberships

3758: /*
3759: * manage_memb_resp
3760: * This public API will take care of managing user responsibilities when
3761: * membership is terminated, exprired, created, upgraded, and downgraded.
3762: * This should be called when a new row is created in pv_pg_memberships
3763: * table with the membership_id of the row that just got created, membership_id
3764: * of program that is being terminated or expireing.
3765: */
3766: PROCEDURE manage_memb_resp(

Line 3778: FROM pv_pg_memberships

3774: )
3775: IS
3776: CURSOR c_get_membership_status (cv_membership_id NUMBER) IS
3777: SELECT membership_status_code, partner_id, program_id
3778: FROM pv_pg_memberships
3779: WHERE membership_id = cv_membership_id;
3780:
3781: l_api_name CONSTANT VARCHAR2(30) := 'manage_memb_resp';
3782: l_api_version_number CONSTANT NUMBER := 1.0;

Line 4530: FROM pv_pg_memberships m, pv_ge_resp_map_rules mr

4526: )
4527: IS
4528: CURSOR c_get_resp_info_1 (cv_source_resp_map_rule_id NUMBER) IS
4529: SELECT m.partner_id, mr.user_role_code, mr.program_id
4530: FROM pv_pg_memberships m, pv_ge_resp_map_rules mr
4531: WHERE mr.program_id = m.program_id
4532: AND m.membership_status_code = 'ACTIVE'
4533: AND mr.resp_map_rule_id = cv_source_resp_map_rule_id;
4534:

Line 5245: FROM pv_pg_memberships

5241: )
5242: IS
5243: CURSOR c_get_partner_and_program IS
5244: SELECT partner_id, program_id
5245: FROM pv_pg_memberships
5246: WHERE program_id in (
5247: SELECT program_id
5248: FROM pv_partner_program_b
5249: WHERE program_level_code = 'MEMBERSHIP'

Line 5437: FROM pv_pg_memberships

5433: )
5434: IS
5435: CURSOR c_get_partner_id (cv_program_id NUMBER) IS
5436: SELECT partner_id
5437: FROM pv_pg_memberships
5438: WHERE program_id = cv_program_id
5439: AND membership_status_code = 'ACTIVE';
5440:
5441: CURSOR c_get_ptnr_resps_info IS

Line 6365: * after the call to PV_Pg_Memberships_PVT.Terminate_ptr_memberships

6361:
6362: /*
6363: * revoke_default_resp
6364: * This public API will be called when partner status changes from A to I
6365: * after the call to PV_Pg_Memberships_PVT.Terminate_ptr_memberships
6366: * Because after the the call PV_Pg_Memberships_PVT.Terminate_ptr_memberships
6367: * at least one responsibility will be assigned to the users, if the
6368: * partner is inactivated, we want to revoke all the responsibilities.
6369: */

Line 6366: * Because after the the call PV_Pg_Memberships_PVT.Terminate_ptr_memberships

6362: /*
6363: * revoke_default_resp
6364: * This public API will be called when partner status changes from A to I
6365: * after the call to PV_Pg_Memberships_PVT.Terminate_ptr_memberships
6366: * Because after the the call PV_Pg_Memberships_PVT.Terminate_ptr_memberships
6367: * at least one responsibility will be assigned to the users, if the
6368: * partner is inactivated, we want to revoke all the responsibilities.
6369: */
6370: PROCEDURE revoke_default_resp (

Line 7098: FROM pv_pg_memberships

7094: and user_role_code = 'BUSINESS';
7095:
7096: CURSOR c_get_program_id IS
7097: SELECT program_id, partner_id
7098: FROM pv_pg_memberships
7099: WHERE partner_id = p_to_partner_id
7100: AND membership_status_code = 'ACTIVE';
7101:
7102: CURSOR c_get_to_resp_info IS