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_PVT

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 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 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