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_PRGM_APPROVAL_PVT dependencies on PV_PG_MEMBERSHIPS

Line 217: FROM pv_pg_memberships

213:
214: FUNCTION getGlobalenddate(p_partner_id in number,p_dependent_program_id in number,p_enrollment_type in VARCHAR,p_start_date in DATE) return DATE is
215: CURSOR enrtype_new_csr(g_ptr_id NUMBER,dependent_id NUMBER) IS
216: SELECT min(original_end_date)
217: FROM pv_pg_memberships
218: WHERE partner_id=g_ptr_id
219: AND membership_status_code='ACTIVE'
220: AND program_id IN
221: (

Line 240: FROM pv_pg_memberships

236: );
237:
238: CURSOR enrtype_renew_csr(g_ptr_id NUMBER,dependent_id NUMBER) IS
239: SELECT min(original_end_date)
240: FROM pv_pg_memberships
241: WHERE partner_id=g_ptr_id
242: AND membership_status_code='FUTURE'
243: AND program_id IN
244: (

Line 341: FROM pv_pg_memberships memb,pv_pg_enrq_init_sources eni

337:
338: l_memb_type VARCHAR2(30);
339: CURSOR prev_memb_date_cur(p_enrl_req_id number) IS
340: SELECT nvl(actual_end_date,original_end_date) prev_end_date
341: FROM pv_pg_memberships memb,pv_pg_enrq_init_sources eni
342: WHERE eni.prev_membership_id=memb.membership_id
343: AND eni.enrl_request_id=p_enrl_req_id;
344:
345: CURSOR enr_requests_dtl_cur (p_enrl_req_id number) IS

Line 361: FROM pv_pg_memberships memb

357:
358: CURSOR appr_enrl_req_csr( p_enrl_req_id number ) IS
359: SELECT start_date start_date
360: , nvl(actual_end_date,original_end_date) end_date
361: FROM pv_pg_memberships memb
362: WHERE enrl_request_id=p_enrl_req_id;
363:
364: BEGIN
365: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2478: PROCEDURE setmembershipdetails( pv_pg_memb_rec IN OUT NOCOPY PV_Pg_Memberships_PVT.memb_rec_type

2474: END StartProcess;
2475:
2476: --this procedure should be called only when u create new membership record by passing
2477: -- a valid enrollment_request_id with the record
2478: PROCEDURE setmembershipdetails( pv_pg_memb_rec IN OUT NOCOPY PV_Pg_Memberships_PVT.memb_rec_type
2479: ,x_return_status OUT NOCOPY VARCHAR2
2480: ,x_msg_count OUT NOCOPY NUMBER
2481: ,x_msg_data OUT NOCOPY VARCHAR2
2482: ) IS

Line 2557: FROM pv_pg_memberships

2553: AND enrq.program_id=prgm.program_id;
2554:
2555: CURSOR membership_dtl_cur(p_membership_id number) IS
2556: SELECT object_version_number
2557: FROM pv_pg_memberships
2558: WHERE membership_id=p_membership_id;
2559:
2560: CURSOR prev_memb_id_cur(p_enrl_req_id number) IS
2561: SELECT prev_membership_id

Line 2626: pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;

2622: AND APPROVAL_STATUS_CODE IN ('PENDING_APPROVAL','PENDING_DEFAULT');
2623:
2624: l_attr_id_tbl PV_ENTY_ATTR_VALUE_PUB.NUMBER_TABLE;
2625:
2626: pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
2627: pv_pg_prev_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
2628: l_approver_rec Pv_Ge_Temp_Approvers_PVT.APPROVER_REC_TYPE;
2629: l_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;
2630: l_mmbr_tran_rec pv_pg_mmbr_transitions_PVT.mmbr_tran_rec_type;

Line 2627: pv_pg_prev_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;

2623:
2624: l_attr_id_tbl PV_ENTY_ATTR_VALUE_PUB.NUMBER_TABLE;
2625:
2626: pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
2627: pv_pg_prev_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
2628: l_approver_rec Pv_Ge_Temp_Approvers_PVT.APPROVER_REC_TYPE;
2629: l_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;
2630: l_mmbr_tran_rec pv_pg_mmbr_transitions_PVT.mmbr_tran_rec_type;
2631: l_api_name CONSTANT VARCHAR2(30) := 'process_approved_requests';

Line 2727: PV_Pg_Memberships_PVT.Create_Pg_memberships(

2723:
2724: l_partner_id:=pv_pg_memb_rec.partner_id;
2725: l_program_id:=pv_pg_memb_rec.program_id;
2726:
2727: PV_Pg_Memberships_PVT.Create_Pg_memberships(
2728: p_api_version_number=>1.0
2729: ,p_init_msg_list => FND_API.g_false
2730: ,p_commit => FND_API.G_FALSE
2731: ,p_validation_level => FND_API.g_valid_level_full

Line 2834: PV_Pg_Memberships_PVT.Update_pg_memberships(

2830: pv_pg_prev_memb_rec.membership_id:=rec_cur.prev_membership_id;
2831: pv_pg_prev_memb_rec.actual_end_date:=sysdate;
2832: pv_pg_prev_memb_rec.membership_status_code:='UPGRADED';
2833:
2834: PV_Pg_Memberships_PVT.Update_pg_memberships(
2835: p_api_version_number => 1.0
2836: ,p_init_msg_list => FND_API.g_false
2837: ,p_commit => FND_API.G_FALSE
2838: ,p_validation_level => FND_API.g_valid_level_full

Line 2898: PV_Pg_Memberships_PVT.Update_Pg_memberships(

2894: FETCH membership_dtl_cur into pv_pg_prev_memb_rec.object_version_number;
2895: CLOSE membership_dtl_cur;
2896:
2897:
2898: PV_Pg_Memberships_PVT.Update_Pg_memberships(
2899: p_api_version_number => 1.0
2900: ,p_init_msg_list => FND_API.g_false
2901: ,p_commit => FND_API.G_FALSE
2902: ,p_validation_level => FND_API.g_valid_level_full

Line 3264: pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;

3260: AND res.category='PARTY';
3261:
3262: l_isPartnerFlag VARCHAR2(1);
3263: --nextApprover AME_UTIL.APPROVERRECORD;
3264: pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
3265: pv_pg_prev_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
3266: l_approver_rec Pv_Ge_Temp_Approvers_PVT.APPROVER_REC_TYPE;
3267: l_check_row_pa BOOLEAN :=FALSE;
3268: l_check_row BOOLEAN:=FALSE;

Line 3265: pv_pg_prev_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;

3261:
3262: l_isPartnerFlag VARCHAR2(1);
3263: --nextApprover AME_UTIL.APPROVERRECORD;
3264: pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
3265: pv_pg_prev_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
3266: l_approver_rec Pv_Ge_Temp_Approvers_PVT.APPROVER_REC_TYPE;
3267: l_check_row_pa BOOLEAN :=FALSE;
3268: l_check_row BOOLEAN:=FALSE;
3269: l_checkrow_pending BOOLEAN:=FALSE;

Line 4079: pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;

4075: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
4076: l_api_version_number CONSTANT NUMBER := 1.0;
4077: l_checkrow_pending boolean:=false;
4078: l_approver_rec Pv_Ge_Temp_Approvers_PVT.approver_rec_type;
4079: pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
4080: l_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;
4081: l_membership_id number;
4082: l_approvalStatus varchar2(50);
4083: l_approverPersonId number;

Line 4648: l_pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;

4644: ,x_return_status OUT NOCOPY VARCHAR2
4645: ,x_msg_count OUT NOCOPY NUMBER
4646: ,x_msg_data OUT NOCOPY VARCHAR2) IS
4647:
4648: l_pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
4649: l_pv_pg_new_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
4650: l_pv_pg_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;
4651: l_mmbr_tran_rec pv_pg_mmbr_transitions_PVT.mmbr_tran_rec_type;
4652: l_partner_id NUMBER;

Line 4649: l_pv_pg_new_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;

4645: ,x_msg_count OUT NOCOPY NUMBER
4646: ,x_msg_data OUT NOCOPY VARCHAR2) IS
4647:
4648: l_pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
4649: l_pv_pg_new_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
4650: l_pv_pg_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;
4651: l_mmbr_tran_rec pv_pg_mmbr_transitions_PVT.mmbr_tran_rec_type;
4652: l_partner_id NUMBER;
4653: l_enrl_request_id NUMBER;

Line 4667: FROM pv_pg_memberships memb,pv_pg_enrl_requests enrq

4663: l_custom_setup_id NUMBER;
4664:
4665: CURSOR membership_csr(p_memb_id NUMBER) IS
4666: SELECT memb.object_version_number,memb.partner_id,memb.original_end_date,enrq.custom_setup_id
4667: FROM pv_pg_memberships memb,pv_pg_enrl_requests enrq
4668: WHERE memb.membership_id=p_memb_id
4669: AND memb.enrl_request_id=enrq.enrl_request_id;
4670:
4671: CURSOR program_name_csr(p_prgm_id NUMBER) IS

Line 4729: PV_Pg_Memberships_PVT.Update_Pg_Memberships

4725: FETCH membership_csr INTO l_pv_pg_memb_rec.object_version_number,l_partner_id,l_original_end_date,l_custom_setup_id;
4726: CLOSE membership_csr;
4727:
4728:
4729: PV_Pg_Memberships_PVT.Update_Pg_Memberships
4730: ( p_api_version_number => 1.0
4731: ,p_init_msg_list => Fnd_Api.g_false
4732: ,p_commit => Fnd_Api.g_false
4733: ,x_return_status => x_return_status

Line 4811: PV_Pg_Memberships_PVT.Create_Pg_memberships

4807: l_pv_pg_new_memb_rec.membership_status_code:='ACTIVE';
4808: l_pv_pg_new_memb_rec.partner_id:=l_partner_id;
4809: l_pv_pg_new_memb_rec.program_id:=p_program_id_downgraded_to;
4810:
4811: PV_Pg_Memberships_PVT.Create_Pg_memberships
4812: ( p_api_version_number=>1.0
4813: ,p_init_msg_list => FND_API.g_false
4814: ,p_commit => FND_API.G_FALSE
4815: ,p_validation_level => FND_API.g_valid_level_full

Line 4983: pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;

4979: ,x_msg_count OUT NOCOPY NUMBER
4980: ,x_msg_data OUT NOCOPY VARCHAR2
4981: ) IS
4982:
4983: pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
4984: l_pv_pg_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;
4985: l_api_name CONSTANT VARCHAR2(30) := 'Create_Default_Membership';
4986: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
4987: l_api_version_number CONSTANT NUMBER := 1.0;

Line 5091: PV_Pg_Memberships_PVT.Create_Pg_memberships

5087: ,x_msg_count =>x_msg_count
5088: ,x_msg_data =>x_msg_data
5089: );
5090:
5091: PV_Pg_Memberships_PVT.Create_Pg_memberships
5092: (
5093: p_api_version_number=>1.0
5094: ,p_init_msg_list => FND_API.g_false
5095: ,p_commit => FND_API.G_FALSE