DBA Data[Home] [Help]

APPS.PV_PG_MEMBERSHIPS_PVT dependencies on PV_PG_MEMBERSHIPS_PVT

Line 1: PACKAGE BODY PV_Pg_Memberships_PVT as

1: PACKAGE BODY PV_Pg_Memberships_PVT as
2: /* $Header: pvxvmemb.pls 120.6 2006/05/04 13:14:03 dgottlie ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- PV_Pg_Memberships_PVT

2: /* $Header: pvxvmemb.pls 120.6 2006/05/04 13:14:03 dgottlie ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- PV_Pg_Memberships_PVT
7: -- Purpose
8: --
9: -- History
10: -- 13-SEP-2005 Karen.Tsao Removed call to Terminate_Contract API.

Line 21: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Pg_Memberships_PVT';

17: -- End of Comments
18: -- ===============================================================
19:
20:
21: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Pg_Memberships_PVT';
22: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvmemb.pls';
23:
24: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
25: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 1918: -- PV_PG_MEMBERSHIPS_PVT.Terminate_ptr_memberships

1914:
1915:
1916: --------------------------------------------------------------------------
1917: -- PROCEDURE
1918: -- PV_PG_MEMBERSHIPS_PVT.Terminate_ptr_memberships
1919: --
1920: -- PURPOSE
1921: -- Terminate all memberships for a given partner. If the partner is
1922: -- a global partner, terminate its appropraite subsidiary memberships also

Line 2435: -- PV_PG_MEMBERSHIPS_PVT.Terminate__membership

2431:
2432:
2433: --------------------------------------------------------------------------
2434: -- PROCEDURE
2435: -- PV_PG_MEMBERSHIPS_PVT.Terminate__membership
2436: --
2437: -- PURPOSE
2438: -- Terminate a membership for a given partner. If the partner is
2439: -- a global partner, terminate its appropraite subsidiary memberships also

Line 3231: PV_Pg_Memberships_PVT.Create_Pg_memberships

3227: l_pv_pg_new_memb_rec.membership_status_code := 'ACTIVE';
3228: l_pv_pg_new_memb_rec.partner_id := l_partner_id;
3229: l_pv_pg_new_memb_rec.program_id := p_program_id_downgraded_to;
3230:
3231: PV_Pg_Memberships_PVT.Create_Pg_memberships
3232: ( p_api_version_number=>1.0
3233: , p_init_msg_list => FND_API.G_FALSE
3234: , p_commit => FND_API.G_FALSE
3235: , p_validation_level => FND_API.g_valid_level_full

Line 3551: PV_Pg_Memberships_PVT.Update_Pg_Memberships

3547:
3548: l_pv_pg_memb_rec.membership_id := p_membership_id;
3549: l_pv_pg_memb_rec.original_end_date := p_new_date;
3550: l_pv_pg_memb_rec.object_version_number := l_object_version_number;
3551: PV_Pg_Memberships_PVT.Update_Pg_Memberships
3552: ( p_api_version_number => 1.0
3553: , p_init_msg_list => Fnd_Api.g_false
3554: , p_commit => Fnd_Api.g_false
3555: , x_return_status => x_return_status

Line 3573: PV_Pg_Memberships_PVT.Update_Pg_Memberships

3569: END IF;
3570: l_pv_pg_memb_rec.membership_id := subsidiary.membership_id;
3571: l_pv_pg_memb_rec.original_end_date := l_subs_end_date;
3572: l_pv_pg_memb_rec.object_version_number := subsidiary.object_version_number;
3573: PV_Pg_Memberships_PVT.Update_Pg_Memberships
3574: ( p_api_version_number => 1.0
3575: ,p_init_msg_list => Fnd_Api.g_false
3576: ,p_commit => Fnd_Api.g_false
3577: ,x_return_status => x_return_status

Line 3717: PV_Pg_Memberships_PVT.Terminate_ptr_memberships (

3713: IF (l_old_status = 'A' and l_new_status = 'I') THEN
3714: IF (PV_DEBUG_HIGH_ON) THEN
3715: WRITE_LOG(l_api_name, 'before calling Terminate_ptr_memberships');
3716: END IF;
3717: PV_Pg_Memberships_PVT.Terminate_ptr_memberships (
3718: p_api_version_number => 1.0
3719: ,p_init_msg_list => FND_API.G_FALSE
3720: ,p_commit => FND_API.G_FALSE
3721: ,p_partner_id => l_partner_id

Line 3799: WF_CORE.CONTEXT('PV_PG_MEMBERSHIPS_PVT', 'TERMINATE_PTR_MEMBERSHIPS', p_event.getEventName(), p_subscription_guid);

3795: END IF;
3796: RETURN 'SUCCESS';
3797: EXCEPTION
3798: WHEN FND_API.G_EXC_ERROR THEN
3799: WF_CORE.CONTEXT('PV_PG_MEMBERSHIPS_PVT', 'TERMINATE_PTR_MEMBERSHIPS', p_event.getEventName(), p_subscription_guid);
3800: WF_EVENT.setErrorInfo(p_event, 'Error from Terminate_ptr_memberships');
3801: RETURN 'ERROR';
3802: WHEN OTHERS THEN
3803: WF_CORE.CONTEXT('PV_PG_MEMBERSHIPS_PVT', 'TERMINATE_PTR_MEMBERSHIPS', p_event.getEventName(), p_subscription_guid);

Line 3803: WF_CORE.CONTEXT('PV_PG_MEMBERSHIPS_PVT', 'TERMINATE_PTR_MEMBERSHIPS', p_event.getEventName(), p_subscription_guid);

3799: WF_CORE.CONTEXT('PV_PG_MEMBERSHIPS_PVT', 'TERMINATE_PTR_MEMBERSHIPS', p_event.getEventName(), p_subscription_guid);
3800: WF_EVENT.setErrorInfo(p_event, 'Error from Terminate_ptr_memberships');
3801: RETURN 'ERROR';
3802: WHEN OTHERS THEN
3803: WF_CORE.CONTEXT('PV_PG_MEMBERSHIPS_PVT', 'TERMINATE_PTR_MEMBERSHIPS', p_event.getEventName(), p_subscription_guid);
3804: WF_EVENT.setErrorInfo(p_event, 'ERROR');
3805: RETURN 'ERROR';
3806: END;
3807:

Line 3809: END PV_Pg_Memberships_PVT;

3805: RETURN 'ERROR';
3806: END;
3807:
3808:
3809: END PV_Pg_Memberships_PVT;