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

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 405: FROM pv_pg_memberships membership,

401: membership.original_end_date ,
402: enrl_req.requestor_resource_id,
403: enrl_req.partner_id,
404: lookup.meaning
405: FROM pv_pg_memberships membership,
406: pv_pg_enrl_requests enrl_req,
407: pv_partner_program_vl program,
408: fnd_lookups lookup
409: WHERE membership.membership_id = cv_membership_id

Line 841: -- from PV_PG_ENRL_REQUESTS table and PV_PG_MEMBERSHIPS_TABLE for a given enrl_requests_id

837: -- get_enrl_requests_details
838: --
839: -- PURPOSE
840: -- This procedure will return enrollment request and membership details
841: -- from PV_PG_ENRL_REQUESTS table and PV_PG_MEMBERSHIPS_TABLE for a given enrl_requests_id
842: -- Called By
843: -- NOTES
844: -- End of Comments
845: ============================================================================*/

Line 876: , pv_pg_memberships memb

872: FROM pv_pg_enrl_requests enrl_req
873: , pv_partner_program_vl prog
874: , fnd_lookups lookup1
875: , fnd_lookups lookup2
876: , pv_pg_memberships memb
877: WHERE enrl_req.enrl_request_id = cv_enrl_request_id
878: AND enrl_req.program_id = prog.program_id
879: AND lookup1.lookup_type='PV_PROGRAM_PMNT_UNIT'
880: AND lookup1.lookup_code = prog.membership_period_unit

Line 3855: FROM pv_pg_memberships mmbr

3851: /* Cursor declaration to check the remainder flag for a given membership_id,
3852: whether we have to send any reminder or not */
3853: CURSOR c_Check_Memexp_Rmdr_Flg (cv_membership_id NUMBER) IS
3854: SELECT 'Y'
3855: FROM pv_pg_memberships mmbr
3856: WHERE mmbr.membership_id = cv_membership_id
3857: AND NOT EXISTS
3858: ( SELECT 1
3859: FROM pv_pg_mmbr_transitions trans,

Line 3860: pv_pg_memberships mmbr_future

3856: WHERE mmbr.membership_id = cv_membership_id
3857: AND NOT EXISTS
3858: ( SELECT 1
3859: FROM pv_pg_mmbr_transitions trans,
3860: pv_pg_memberships mmbr_future
3861: WHERE trans.from_membership_id = mmbr.membership_id
3862: AND trans.to_membership_id = mmbr_future.membership_id
3863: AND mmbr_future.membership_status_code = 'FUTURE' );
3864:

Line 3988: FROM pv_pg_memberships mmbr,

3984: SELECT mmbr.membership_id,
3985: mmbr.enrl_request_id,
3986: mmbr.partner_id,
3987: (notif_rule.repeat_freq_value * DECODE(notif_rule.repeat_freq_unit, 'PV_DAYS',1,'PV_WEEK', 7,'PV_MONTH', 30)) wait_time_in_days
3988: FROM pv_pg_memberships mmbr,
3989: pv_ge_notif_rules_b notif_rule
3990: WHERE mmbr.membership_status_code = 'ACTIVE'
3991: AND trunc(mmbr.original_end_date - sysdate) < notif_rule.send_notif_before_value *
3992: DECODE(notif_rule.send_notif_before_unit, 'PV_DAYS',1,'PV_WEEK', 7,

Line 4001: pv_pg_memberships mmbr_future

3997: AND notif_rule.notif_type_code = 'PG_MEM_EXP'
3998: AND NOT EXISTS
3999: ( SELECT 1
4000: FROM pv_pg_mmbr_transitions trans,
4001: pv_pg_memberships mmbr_future
4002: WHERE trans.from_membership_id = mmbr.membership_id
4003: AND trans.to_membership_id = mmbr_future.membership_id
4004: AND mmbr_future.membership_status_code = 'FUTURE'
4005: )

Line 4196: FROM pv_pg_memberships mmbr

4192: CURSOR c_get_expired_memberships IS
4193: SELECT mmbr.membership_id membership_id
4194: , mmbr.partner_id
4195: , mmbr.object_version_number
4196: FROM pv_pg_memberships mmbr
4197: WHERE mmbr.membership_status_code = 'ACTIVE'
4198: AND trunc(SYSDATE - mmbr.original_end_date) >= 1
4199: AND NOT EXISTS
4200: ( SELECT 1

Line 4202: pv_pg_memberships mmbr_future

4198: AND trunc(SYSDATE - mmbr.original_end_date) >= 1
4199: AND NOT EXISTS
4200: ( SELECT 1
4201: FROM pv_pg_mmbr_transitions trans,
4202: pv_pg_memberships mmbr_future
4203: WHERE trans.from_membership_id = mmbr.membership_id
4204: AND trans.to_membership_id = mmbr_future.membership_id
4205: AND mmbr_future.membership_status_code = 'FUTURE' ) ;
4206:

Line 4210: FROM pv_pg_memberships

4206:
4207:
4208: CURSOR c_get_status(mmbr_id NUMBER) IS
4209: SELECT membership_status_code
4210: FROM pv_pg_memberships
4211: WHERE membership_id=mmbr_id;
4212:
4213: -- Get all the memberships to be renewed for early renewals cases.
4214: CURSOR c_get_renew_memberships IS

Line 4220: FROM pv_pg_memberships mmbr,

4216: mmbr_future.membership_id future_membership_id,
4217: mmbr.partner_id,
4218: mmbr.object_version_number,
4219: mmbr_future.object_version_number future_memb_obj_ver_no
4220: FROM pv_pg_memberships mmbr,
4221: pv_pg_memberships mmbr_future,
4222: pv_pg_mmbr_transitions trans
4223: WHERE mmbr.membership_status_code = 'ACTIVE'
4224: --AND trunc(SYSDATE - mmbr.original_end_date) >= 1

Line 4221: pv_pg_memberships mmbr_future,

4217: mmbr.partner_id,
4218: mmbr.object_version_number,
4219: mmbr_future.object_version_number future_memb_obj_ver_no
4220: FROM pv_pg_memberships mmbr,
4221: pv_pg_memberships mmbr_future,
4222: pv_pg_mmbr_transitions trans
4223: WHERE mmbr.membership_status_code = 'ACTIVE'
4224: --AND trunc(SYSDATE - mmbr.original_end_date) >= 1
4225: AND mmbr.original_end_date <= trunc(SYSDATE -1 )

Line 4234: , pv_pg_memberships memb

4230: CURSOR c_getptrprgm(memb_id NUMBER) IS
4231: SELECT distinct party.party_name, prgm.program_name
4232: FROM hz_parties party
4233: , pv_partner_profiles prof
4234: , pv_pg_memberships memb
4235: , pv_partner_program_vl prgm
4236: WHERE prof.status = 'A'
4237: AND prof.partner_party_id = party.party_id
4238: AND memb.partner_id = prof.partner_id

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 4268: /* call update table handler for pv_pg_memberships by passing

4264: /* Logic to update the membership status to EXPIRE for all the EXPIRED members */
4265: Write_log (1, 'Updating the Membership Status to EXPIRED -');
4266: FOR l_get_expire_memberships_rec IN c_get_expired_memberships
4267: LOOP
4268: /* call update table handler for pv_pg_memberships by passing
4269: membership_status_code = 'EXPIRED', actual_end_date as sysdate */
4270: /*l_memb_rec.membership_id := l_get_expire_memberships_rec.membership_id;
4271: l_memb_rec.membership_status_code := 'EXPIRED';
4272: l_memb_rec.actual_end_date := sysdate;

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 4346: -- call update API for pv_pg_memberships by passing

4342: /* Pick all the memberships to be renewed. */
4343: Write_log (1, 'Updating the Membership Status to RENEW for following members -');
4344:
4345: FOR l_get_renew_memberships_rec IN c_get_renew_memberships LOOP
4346: -- call update API for pv_pg_memberships by passing
4347: -- membership_status_code = 'RENEWED', actual_end_date as sysdate
4348: -- for membership_id = l_get_renew_memberships_rec.current_membership_id
4349: l_memb_rec.membership_id := l_get_renew_memberships_rec.current_membership_id;
4350: l_memb_rec.membership_status_code := 'RENEWED';

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 4390: -- call update API for pv_pg_memberships by passing

4386:
4387:
4388:
4389: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
4390: -- call update API for pv_pg_memberships by passing
4391: -- membership_status_code = 'ACTIVE',
4392: -- for membership_id = l_get_renew_memberships_rec.future_membership_id
4393: l_memb_rec.membership_id := l_get_renew_memberships_rec.future_membership_id;
4394: l_memb_rec.membership_status_code := 'ACTIVE';

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,