DBA Data[Home] [Help]

APPS.PV_PRGM_APPROVAL_PVT dependencies on PV_PG_ENRL_REQUESTS_PVT

Line 2629: l_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;

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';
2632: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2633: l_api_version_number CONSTANT NUMBER := 1.0;

Line 2754: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests(

2750:
2751: l_enrq_rec.tentative_start_date:= pv_pg_memb_rec.start_date;
2752: l_enrq_rec.tentative_end_date:= pv_pg_memb_rec.original_end_date;
2753:
2754: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests(
2755: p_api_version_number => 1.0
2756: ,p_init_msg_list => FND_API.g_false
2757: ,p_commit => FND_API.G_FALSE
2758: ,p_validation_level => FND_API.g_valid_level_full

Line 3053: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests(

3049:
3050: ELSE --end of approved code
3051: --the code below is for enrollments that are rejected by any appprover.
3052: --update the enrollment requests table with the approvalstatus
3053: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests(
3054: p_api_version_number => 1.0
3055: ,p_init_msg_list => FND_API.g_false
3056: ,p_commit => FND_API.G_FALSE
3057: ,p_validation_level => FND_API.g_valid_level_full

Line 4080: l_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;

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;
4084: l_approverUserId number;

Line 4205: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests

4201: l_enrq_rec.enrl_request_id:=enrl_request_id;
4202: l_enrq_rec.tentative_start_date:=start_date;
4203: l_enrq_rec.tentative_end_date:=end_date;
4204:
4205: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests
4206: ( p_api_version_number => 1.0
4207: , p_init_msg_list => FND_API.g_false
4208: , p_commit => FND_API.G_FALSE
4209: , p_validation_level => FND_API.g_valid_level_full

Line 4650: l_pv_pg_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;

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;
4654: l_membership_id NUMBER;

Line 4783: PV_Pg_Enrl_Requests_PVT.Create_Pg_Enrl_Requests

4779: l_pv_pg_enrq_rec.request_initiated_by_code:='VENDOR';
4780: l_pv_pg_enrq_rec.contract_status_code:='NOT_SIGNED';
4781: l_pv_pg_enrq_rec.custom_setup_id:=getCustomSetupID(p_program_id_downgraded_to);
4782:
4783: PV_Pg_Enrl_Requests_PVT.Create_Pg_Enrl_Requests
4784: ( p_api_version_number =>1.0
4785: ,p_init_msg_list => FND_API.g_false
4786: ,p_commit => FND_API.G_FALSE
4787: ,p_validation_level => FND_API.g_valid_level_full

Line 4984: l_pv_pg_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;

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;
4988: l_membership_id NUMBER;

Line 5063: PV_Pg_Enrl_Requests_PVT.Create_Pg_Enrl_Requests

5059: l_pv_pg_enrq_rec.contract_status_code:='NOT_SIGNED';
5060: l_pv_pg_enrq_rec.payment_status_code:='NOT_SUBMITTED';
5061: l_pv_pg_enrq_rec.custom_setup_id:= getCustomSetupID(l_default_program_id);
5062:
5063: PV_Pg_Enrl_Requests_PVT.Create_Pg_Enrl_Requests
5064: ( p_api_version_number =>1.0
5065: ,p_init_msg_list => FND_API.g_false
5066: ,p_commit => FND_API.G_FALSE
5067: ,p_validation_level => FND_API.g_valid_level_full