APPS.PVX_PARTY_MERGE_PKG dependencies on PV_PG_MEMBERSHIPS

Line 985: FROM PV_PG_MEMBERSHIPS

981: IF p_from_fk_id <> p_to_fk_id THEN
982:
983: BEGIN
984: SELECT DISTINCT partner_id INTO l_ppf_id
985: FROM PV_PG_MEMBERSHIPS
986: WHERE partner_id = p_to_fk_id;
987: EXCEPTION
988: WHEN NO_DATA_FOUND THEN
989: l_ppf_id := Null;

Line 994: update PV_PG_MEMBERSHIPS

990: END;
991:
992:
993: /*
994: update PV_PG_MEMBERSHIPS
995: set partner_id = p_to_fk_id,
996: last_update_date = SYSDATE,
997: last_updated_by = G_USER_ID,
998: last_update_login = G_LOGIN_ID

Line 1004: PV_PG_MEMBERSHIPS_PVT.Terminate_ptr_memberships does the following

1000: */
1001:
1002: /*
1003:
1004: PV_PG_MEMBERSHIPS_PVT.Terminate_ptr_memberships does the following
1005: 1. Terminate all Active/future Program Memberships of partner and cancel incomplete and awaiting approvals enrollment requests
1006: 2. also if partner is global,t will terminate subsidiary memberships and cancel the subsidiary incompelete and awaiting approvals enrollment requests
1007: */
1008:

Line 1013: PV_PG_MEMBERSHIPS_PVT.Terminate_ptr_memberships

1009: OPEN memb_type_cur( p_from_fk_id );
1010: FETCH memb_type_cur INTO l_current_memb_type;
1011: CLOSE memb_type_cur;
1012:
1013: PV_PG_MEMBERSHIPS_PVT.Terminate_ptr_memberships
1014: (
1015: p_api_version_number => 1.0
1016: ,p_init_msg_list => FND_API.G_FALSE
1017: ,p_commit => FND_API.G_FALSE