DBA Data[Home] [Help]

APPS.PV_PRGM_APPROVAL_PVT dependencies on PV_PG_MMBR_TRANSITIONS_PVT

Line 2630: l_mmbr_tran_rec pv_pg_mmbr_transitions_PVT.mmbr_tran_rec_type;

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;
2634: --This value for l_default_approver_id needs to be retrieved from profile

Line 2859: pv_pg_mmbr_transitions_PVT.Create_Mmbr_Trans

2855: l_mmbr_tran_rec.FROM_MEMBERSHIP_ID:=rec_cur.prev_membership_id;
2856: l_mmbr_tran_rec.TO_MEMBERSHIP_ID:=l_membership_id;
2857:
2858:
2859: pv_pg_mmbr_transitions_PVT.Create_Mmbr_Trans
2860: ( p_api_version_number =>1.0
2861: ,p_init_msg_list => FND_API.g_false
2862: ,p_commit => FND_API.G_FALSE
2863: ,p_validation_level => FND_API.g_valid_level_full

Line 2920: pv_pg_mmbr_transitions_PVT.Create_Mmbr_Trans(

2916: --call pv_pg_mmbr_transitions table api
2917: l_mmbr_tran_rec.FROM_MEMBERSHIP_ID:=l_previous_membership_id;
2918: l_mmbr_tran_rec.TO_MEMBERSHIP_ID:=l_membership_id;
2919:
2920: pv_pg_mmbr_transitions_PVT.Create_Mmbr_Trans(
2921: p_api_version_number => 1.0
2922: ,p_init_msg_list => FND_API.g_false
2923: ,p_commit => FND_API.G_FALSE
2924: ,p_validation_level => FND_API.g_valid_level_full

Line 4651: l_mmbr_tran_rec pv_pg_mmbr_transitions_PVT.mmbr_tran_rec_type;

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;
4655: l_original_end_date DATE;

Line 4833: pv_pg_mmbr_transitions_PVT.Create_Mmbr_Trans

4829: p_new_memb_id :=l_membership_id;
4830: --insert into member transitions table
4831: l_mmbr_tran_rec.from_membership_id:=p_membership_id;
4832: l_mmbr_tran_rec.to_membership_id:=l_membership_id;
4833: pv_pg_mmbr_transitions_PVT.Create_Mmbr_Trans
4834: ( p_api_version_number =>1.0
4835: ,p_init_msg_list => FND_API.g_false
4836: ,p_commit => FND_API.G_FALSE
4837: ,p_validation_level => FND_API.g_valid_level_full