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_PG_MEMBERSHIPS_PVT dependencies on PV_PG_ENRL_REQUESTS

Line 1553: l_enrl_request_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type ;

1549:
1550: )
1551: IS
1552:
1553: l_enrl_request_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type ;
1554: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;
1555: l_object_version_number NUMBER;
1556: l_partner_id NUMBER;
1557: l_enrl_request_id NUMBER;

Line 1566: FROM pv_pg_enrl_requests enrq

1562: SELECT enrq.enrl_request_id
1563: , enrq.partner_id
1564: , enrq.object_version_number
1565: , prgm.program_name
1566: FROM pv_pg_enrl_requests enrq
1567: , pv_partner_program_vl prgm
1568: WHERE enrq.enrl_request_id=enrl_id
1569: AND enrq.program_id=prgm.program_id;
1570:

Line 1585: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests

1581: l_enrl_request_rec.enrl_request_id:= l_enrl_request_id;
1582: l_enrl_request_rec.object_version_number:=l_object_version_number;
1583: l_enrl_request_rec.request_status_code:='CANCELLED';
1584:
1585: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests
1586: ( p_api_version_number => 1.0
1587: ,p_init_msg_list => Fnd_Api.g_false
1588: ,p_commit => Fnd_Api.g_false
1589: ,x_return_status => x_return_status

Line 1705: FROM pv_pg_enrl_requests enrq, pv_pg_memberships memb

1701: WHERE partner_id=p_ptr_id;
1702:
1703: CURSOR contract_cur(mmbr_id NUMBER) IS
1704: SELECT contract_id
1705: FROM pv_pg_enrl_requests enrq, pv_pg_memberships memb
1706: WHERE memb.membership_id=mmbr_id
1707: AND memb.enrl_request_id=enrq.enrl_request_id;
1708:
1709: CURSOR memb_cur (mmbr_id NUMBER ) IS

Line 1958: FROM pv_pg_enrl_requests

1954: AND membership_status_code IN ('ACTIVE','FUTURE');
1955:
1956: CURSOR enrq_csr( p_ptr_id NUMBER) IS
1957: SELECT enrl_request_id
1958: FROM pv_pg_enrl_requests
1959: WHERE partner_id=p_ptr_id
1960: AND request_status_code in ('INCOMPLETE','AWAITING_APPROVAL');
1961:
1962:

Line 2005: FROM pv_pg_enrl_requests enrq

2001:
2002:
2003: CURSOR c_get_enrls_csr(l_sub_str_table JTF_NUMBER_TABLE ) IS
2004: SELECT /*+ CARDINALITY(sptr 10) */ enrq.enrl_request_id enrl_request_id
2005: FROM pv_pg_enrl_requests enrq
2006: , (SELECT column_value FROM TABLE (CAST(l_sub_str_table AS JTF_NUMBER_TABLE))) sptr
2007: WHERE enrq.partner_id=sptr.column_value
2008: AND request_status_code IN ('INCOMPLETE','AWAITING_APPROVAL');
2009:

Line 2476: FROM pv_pg_enrl_requests enr

2472: SELECT enr.enrl_request_id
2473: , enr.request_status_code
2474: , memb.membership_status_code
2475: , memb.membership_id
2476: FROM pv_pg_enrl_requests enr
2477: , pv_pg_memberships memb
2478: WHERE enr.partner_id = ptr_id
2479: AND enr.program_id
2480: IN ( SELECT * FROM TABLE ( CAST( prgm_id_tbl AS JTF_NUMBER_TABLE ) ) )

Line 2490: FROM pv_pg_enrl_requests enr

2486: enr.enrl_request_id
2487: , enr.request_status_code
2488: , memb.membership_status_code
2489: , memb.membership_id
2490: FROM pv_pg_enrl_requests enr
2491: , pv_pg_memberships memb
2492: , ( SELECT column_value FROM TABLE ( CAST( ptr_id_tbl AS JTF_NUMBER_TABLE ) ) ) ptr
2493: , ( SELECT column_value FROM TABLE ( CAST( prgm_id_tbl AS JTF_NUMBER_TABLE ) ) ) prg
2494: WHERE enr.partner_id =ptr.column_value

Line 2503: FROM pv_pg_enrl_requests enr

2499: SELECT enr.enrl_request_id
2500: , enr.request_status_code
2501: , memb.membership_status_code
2502: , memb.membership_id
2503: FROM pv_pg_enrl_requests enr
2504: , pv_pg_memberships memb
2505: WHERE enr.partner_id
2506: IN ( SELECT * FROM TABLE ( CAST( ptr_id_tbl AS JTF_NUMBER_TABLE ) ) )
2507: AND enr.program_id

Line 2524: , pv_pg_enrl_requests enrq

2520: , pv_enty_attr_values subs_enty_val
2521:
2522: , hz_relationships rel
2523: , pv_pg_memberships memb
2524: , pv_pg_enrl_requests enrq
2525: WHERE global_prof.partner_id = global_partner_id
2526: AND global_prof.partner_party_id = rel.subject_id
2527: AND rel.relationship_type = 'PARTNER_HIERARCHY'
2528: AND rel.object_id = subs_prof.partner_party_id

Line 3128: l_pv_pg_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;

3124:
3125: l_api_name CONSTANT VARCHAR2(30) := 'downgrade_membership';
3126: l_api_version_number CONSTANT NUMBER := 1.0;
3127: l_pv_pg_new_memb_rec memb_rec_type;
3128: l_pv_pg_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;
3129: l_mmbr_tran_rec pv_pg_mmbr_transitions_PVT.mmbr_tran_rec_type;
3130: l_partner_id NUMBER;
3131: l_enrl_request_id NUMBER;
3132: l_membership_id NUMBER;

Line 3205: PV_Pg_Enrl_Requests_PVT.Create_Pg_Enrl_Requests

3201: l_pv_pg_enrq_rec.request_submission_date := sysdate;
3202: l_pv_pg_enrq_rec.request_initiated_by_code := 'VENDOR';
3203: l_pv_pg_enrq_rec.contract_status_code := 'NOT_SIGNED';
3204:
3205: PV_Pg_Enrl_Requests_PVT.Create_Pg_Enrl_Requests
3206: (
3207: p_api_version_number =>1.0
3208: , p_init_msg_list => FND_API.G_FALSE
3209: , p_commit => FND_API.G_FALSE

Line 3483: , pv_pg_enrl_requests enrl

3479: , pv_partner_profiles global_prof
3480: , pv_enty_attr_values subs_enty_val
3481: , hz_relationships rel
3482: , pv_pg_memberships memb
3483: , pv_pg_enrl_requests enrl
3484: WHERE global_prof.partner_id = global_partner_id
3485: AND global_prof.partner_party_id = rel.subject_id
3486: AND rel.relationship_type = 'PARTNER_HIERARCHY'
3487: AND rel.object_id = subs_prof.partner_party_id