[Home] [Help]
5: -- HISTORY
6: -- 20-SEP-2002 rdsharma Created
7: -- 11-NOV-2002 SVEERAVE Since the package pv_pgp_notif_pvt is changed to
8: -- pv_ge_party_notif_pvt, all the references are changed
9: -- accordingly. Since pv_ge_party_notifications table
10: -- is change to have partner_id column instead of partner_party_id
11: -- set_pgp_notif procedure is changed to capture partner_id
12: -- all call-outs to set_pgp_notif is changed to pass partner_id
13: -- intead of partner_party_id.
4004: AND mmbr_future.membership_status_code = 'FUTURE'
4005: )
4006: AND NOT EXISTS
4007: ( SELECT 1
4008: FROM pv_ge_party_notifications sent_notif
4009: WHERE sent_notif.ARC_NOTIF_FOR_ENTITY_CODE = 'ENRQ'
4010: AND sent_notif.NOTIF_FOR_ENTITY_ID = mmbr.enrl_request_id
4011: AND sent_notif.notif_type_code = notif_rule.notif_type_code
4012: AND sent_notif.partner_id = mmbr.partner_id
4035: AND notif_rule.active_flag = 'Y'
4036: AND notif_rule.notif_type_code = 'PG_CONTRCT_NRCVD'
4037: AND NOT EXISTS
4038: ( SELECT 1
4039: FROM pv_ge_party_notifications sent_notif
4040: WHERE sent_notif.ARC_NOTIF_FOR_ENTITY_CODE = 'ENRQ'
4041: AND sent_notif. NOTIF_FOR_ENTITY_ID = enrq.enrl_request_id
4042: AND sent_notif.notif_type_code = notif_rule.notif_type_code
4043: AND sent_notif.partner_id = enrq.partner_id);
4775: END IF;
4776: END IF;
4777:
4778:
4779: /* Call the Create_Ge_Party_Notif to insert a record in PV_GE_PARTY_NOTIFICATIONS */
4780: PV_GE_PARTY_NOTIF_PVT.Create_Ge_Party_Notif (
4781: p_api_version_number => 1.0,
4782: p_init_msg_list => FND_API.G_FALSE ,
4783: p_commit => FND_API.G_FALSE ,