APPS.PV_PG_NOTIF_UTILITY_PVT dependencies on PV_PG_MEMBERSHIPS_PVT

Line 38: -- 10/08/2003 pukken Modified Expire_Membership to procedure. called PV_Pg_Memberships_PVT.Terminate_membership

34: -- DOC_MESSAGE in send_mbrship_exp_notif method.
35: -- 09/15/2003 sveerave Added partner_id for create_history_log API call out
36: -- Changed ENRQ object to GENERAL, and entity_object_id to
37: -- partner_id instead of enrl_request_id in this call out
38: -- 10/08/2003 pukken Modified Expire_Membership to procedure. called PV_Pg_Memberships_PVT.Terminate_membership
39: -- with event code as expired.
40: -- 10/18/2003 pukken Added new procedure Send_Workflow_Notification to send the notifications
41: -- 30-MAR-2004 pukken fix bug 3428446
42: -- 15-APR-2005 pukken to fix bug 4301902 to modify Expire_Memberships conc program so that even if

Line 4253: l_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;

4249: l_future_mbrship_id NUMBER;
4250: x_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
4251: x_msg_count NUMBER;
4252: x_msg_data VARCHAR2(4000);
4253: l_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
4254: l_membership_status VARCHAR2(30);
4255: l_partner_name VARCHAR2(360);
4256: l_program_name VARCHAR2(60);
4257: l_index number;

Line 4275: PV_Pg_Memberships_PVT.Update_Pg_Memberships(

4271: l_memb_rec.membership_status_code := 'EXPIRED';
4272: l_memb_rec.actual_end_date := sysdate;
4273: l_memb_rec.object_version_number := l_get_expire_memberships_rec.object_version_number;
4274: Write_log (1,'Membership Id :'||l_memb_rec.membership_id);
4275: PV_Pg_Memberships_PVT.Update_Pg_Memberships(
4276: p_api_version_number => 1.0,
4277: p_init_msg_list => FND_API.G_FALSE,
4278: p_commit => FND_API.G_FALSE,
4279: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 4298: PV_Pg_Memberships_PVT.Terminate_membership

4294: CLOSE c_get_status;
4295: IF l_membership_status='ACTIVE' THEN
4296: Write_log (1,'Before calling expire api for Membership Id :'|| l_get_expire_memberships_rec.membership_id);
4297: SAVEPOINT Terminate_membership;
4298: PV_Pg_Memberships_PVT.Terminate_membership
4299: (
4300: p_api_version_number =>1.0
4301: , p_init_msg_list => FND_API.g_true
4302: , p_commit => FND_API.G_FALSE

Line 4357: PV_Pg_Memberships_PVT.Update_Pg_Memberships(

4353:
4354: Write_log (1,'Before Changing to Renewed status for Membership Id :'||l_memb_rec.membership_id);
4355: SAVEPOINT renew_membership;
4356:
4357: PV_Pg_Memberships_PVT.Update_Pg_Memberships(
4358: p_api_version_number => 1.0,
4359: p_init_msg_list => FND_API.G_TRUE,
4360: p_commit => FND_API.G_FALSE,
4361: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 4397: PV_Pg_Memberships_PVT.Update_Pg_Memberships(

4393: l_memb_rec.membership_id := l_get_renew_memberships_rec.future_membership_id;
4394: l_memb_rec.membership_status_code := 'ACTIVE';
4395: l_memb_rec.object_version_number := l_get_renew_memberships_rec.future_memb_obj_ver_no;
4396: Write_log (1,'Before Changing to Active status for Membership Id :'||l_memb_rec.membership_id);
4397: PV_Pg_Memberships_PVT.Update_Pg_Memberships(
4398: p_api_version_number => 1.0,
4399: p_init_msg_list => FND_API.G_FALSE,
4400: p_commit => FND_API.G_FALSE,
4401: p_validation_level => FND_API.G_VALID_LEVEL_FULL,