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

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 171: SELECT pv_pg_memberships_s.NEXTVAL

167: l_org_id NUMBER ;
168: l_membership_id NUMBER;
169: l_dummy NUMBER;
170: CURSOR c_id IS
171: SELECT pv_pg_memberships_s.NEXTVAL
172: FROM dual;
173:
174: CURSOR c_id_exists (l_id IN NUMBER) IS
175: SELECT 1

Line 176: FROM PV_PG_MEMBERSHIPS

172: FROM dual;
173:
174: CURSOR c_id_exists (l_id IN NUMBER) IS
175: SELECT 1
176: FROM PV_PG_MEMBERSHIPS
177: WHERE membership_id = l_id;
178: BEGIN
179: -- Standard Start of API savepoint
180: SAVEPOINT create_pg_memberships_pvt;

Line 270: -- Invoke table handler(Pv_Pg_Memberships_Pkg.Insert_Row)

266: -- Debug Message
267: IF (PV_DEBUG_HIGH_ON) THEN
268: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
269: END IF;
270: -- Invoke table handler(Pv_Pg_Memberships_Pkg.Insert_Row)
271: Pv_Pg_Memberships_Pkg.Insert_Row(
272: px_membership_id => l_membership_id,
273: px_object_version_number => l_object_version_number,
274: p_partner_id => p_memb_rec.partner_id,

Line 271: Pv_Pg_Memberships_Pkg.Insert_Row(

267: IF (PV_DEBUG_HIGH_ON) THEN
268: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
269: END IF;
270: -- Invoke table handler(Pv_Pg_Memberships_Pkg.Insert_Row)
271: Pv_Pg_Memberships_Pkg.Insert_Row(
272: px_membership_id => l_membership_id,
273: px_object_version_number => l_object_version_number,
274: p_partner_id => p_memb_rec.partner_id,
275: p_program_id => p_memb_rec.program_id,

Line 424: FROM PV_PG_MEMBERSHIPS

420:
421:
422: CURSOR c_get_pg_memberships(membership_id NUMBER) IS
423: SELECT *
424: FROM PV_PG_MEMBERSHIPS
425: WHERE membership_id = p_memb_rec.membership_id;
426: -- Hint: Developer need to provide Where clause
427:
428:

Line 508: -- Invoke table handler(Pv_Pg_Memberships_Pkg.Update_Row)

504: p_token_value => 'Pg_Memberships') ;
505: raise FND_API.G_EXC_ERROR;
506: End if;
507:
508: -- Invoke table handler(Pv_Pg_Memberships_Pkg.Update_Row)
509: IF p_memb_rec.original_end_date < l_ref_memb_rec.start_date THEN
510:
511: FND_MESSAGE.set_name('PV', 'PV_END_DATE_SMALL_START_DATE');
512: FND_MSG_PUB.add;

Line 551: Pv_Pg_Memberships_Pkg.Update_Row(

547:
548:
549:
550:
551: Pv_Pg_Memberships_Pkg.Update_Row(
552: p_membership_id => p_memb_rec.membership_id,
553: p_object_version_number => p_memb_rec.object_version_number,
554: p_partner_id => p_memb_rec.partner_id,
555: p_program_id => p_memb_rec.program_id,

Line 736: -- Invoke table handler(Pv_Pg_Memberships_Pkg.Delete_Row)

732: --
733: -- Api body
734: --
735:
736: -- Invoke table handler(Pv_Pg_Memberships_Pkg.Delete_Row)
737: Pv_Pg_Memberships_Pkg.Delete_Row(
738: p_membership_id => p_membership_id,
739: p_object_version_number => p_object_version_number );
740: --

Line 737: Pv_Pg_Memberships_Pkg.Delete_Row(

733: -- Api body
734: --
735:
736: -- Invoke table handler(Pv_Pg_Memberships_Pkg.Delete_Row)
737: Pv_Pg_Memberships_Pkg.Delete_Row(
738: p_membership_id => p_membership_id,
739: p_object_version_number => p_object_version_number );
740: --
741: -- End of API body

Line 895: Pv_Pg_Memberships_Pkg.Lock_Row(l_membership_id,p_object_version);

891: x_return_status := FND_API.G_RET_STS_SUCCESS;
892:
893:
894: ------------------------ lock -------------------------
895: Pv_Pg_Memberships_Pkg.Lock_Row(l_membership_id,p_object_version);
896:
897:
898: -------------------- finish --------------------------
899: FND_MSG_PUB.count_and_get(

Line 965: 'pv_pg_memberships',

961: IF p_validation_mode = JTF_PLSQL_API.g_create
962: AND p_memb_rec.membership_id IS NOT NULL
963: THEN
964: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
965: 'pv_pg_memberships',
966: 'membership_id = ''' || p_memb_rec.membership_id ||''''
967: );
968: END IF;
969:

Line 1190: FROM pv_pg_memberships

1186: l_return_status VARCHAR2(1);
1187:
1188: CURSOR c_complete IS
1189: SELECT *
1190: FROM pv_pg_memberships
1191: WHERE membership_id = p_memb_rec.membership_id;
1192: l_memb_rec c_complete%ROWTYPE;
1193: BEGIN
1194: x_complete_rec := p_memb_rec;

Line 1705: FROM pv_pg_enrl_requests enrq, pv_pg_memberships memb

1701: WHERE partner_id=p_ptr_id;
1702:
1703: CURSOR contract_cur(mmbr_id NUMBER) IS
1704: SELECT contract_id
1705: FROM pv_pg_enrl_requests enrq, pv_pg_memberships memb
1706: WHERE memb.membership_id=mmbr_id
1707: AND memb.enrl_request_id=enrq.enrl_request_id;
1708:
1709: CURSOR memb_cur (mmbr_id NUMBER ) IS

Line 1715: FROM pv_pg_memberships memb

1711: , memb.program_id
1712: , memb.object_version_number
1713: , memb.enrl_request_id
1714: , prgm.program_name
1715: FROM pv_pg_memberships memb
1716: , pv_partner_program_vl prgm
1717: WHERE memb.membership_id=mmbr_id
1718: AND memb.program_id=prgm.program_id;
1719:

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 1952: FROM pv_pg_memberships

1948:
1949:
1950: CURSOR memb_csr( p_ptr_id NUMBER) IS
1951: SELECT membership_id,program_id
1952: FROM pv_pg_memberships
1953: WHERE partner_id=p_ptr_id
1954: AND membership_status_code IN ('ACTIVE','FUTURE');
1955:
1956: CURSOR enrq_csr( p_ptr_id NUMBER) IS

Line 1997: FROM pv_pg_memberships memb

1993: CURSOR c_get_membs_csr(l_sub_str_table JTF_NUMBER_TABLE ) IS
1994: SELECT /*+ CARDINALITY(sptr 10) */
1995: memb.membership_id membership_id
1996: , memb.program_id program_id
1997: FROM pv_pg_memberships memb
1998: , (SELECT column_value FROM TABLE (CAST(l_sub_str_table AS JTF_NUMBER_TABLE))) sptr
1999: WHERE memb.partner_id=sptr.column_value
2000: AND memb.membership_status_code IN ('ACTIVE','FUTURE');
2001:

Line 2358: FROM pv_pg_memberships memb

2354:
2355:
2356: CURSOR mmbr_transitions_csr(to_mmbr_id NUMBER) IS
2357: SELECT memb.program_id program_id,trn.lvl actlevel
2358: FROM pv_pg_memberships memb
2359: ,pv_partner_program_b pvpp,
2360: (
2361:
2362: SELECT from_membership_id,min(level) lvl

Line 2375: FROM pv_pg_memberships memb

2371: ORDER by actlevel;
2372:
2373: CURSOR prg_csr ( to_mmbr_id NUMBER ) IS
2374: SELECT memb.program_id
2375: FROM pv_pg_memberships memb
2376: ,pv_partner_program_b pvpp
2377: WHERE GLOBAL_MMBR_REQD_FLAG = 'Y'
2378: AND pvpp.program_id=memb.program_id
2379: AND memb.membership_id=to_mmbr_id;

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 2477: , pv_pg_memberships memb

2473: , enr.request_status_code
2474: , memb.membership_status_code
2475: , memb.membership_id
2476: FROM pv_pg_enrl_requests enr
2477: , pv_pg_memberships memb
2478: WHERE enr.partner_id = ptr_id
2479: AND enr.program_id
2480: IN ( SELECT * FROM TABLE ( CAST( prgm_id_tbl AS JTF_NUMBER_TABLE ) ) )
2481: AND enr.enrl_request_id = memb.enrl_request_id(+);

Line 2491: , pv_pg_memberships memb

2487: , enr.request_status_code
2488: , memb.membership_status_code
2489: , memb.membership_id
2490: FROM pv_pg_enrl_requests enr
2491: , pv_pg_memberships memb
2492: , ( SELECT column_value FROM TABLE ( CAST( ptr_id_tbl AS JTF_NUMBER_TABLE ) ) ) ptr
2493: , ( SELECT column_value FROM TABLE ( CAST( prgm_id_tbl AS JTF_NUMBER_TABLE ) ) ) prg
2494: WHERE enr.partner_id =ptr.column_value
2495: AND enr.program_id =prg.column_value

Line 2504: , pv_pg_memberships memb

2500: , enr.request_status_code
2501: , memb.membership_status_code
2502: , memb.membership_id
2503: FROM pv_pg_enrl_requests enr
2504: , pv_pg_memberships memb
2505: WHERE enr.partner_id
2506: IN ( SELECT * FROM TABLE ( CAST( ptr_id_tbl AS JTF_NUMBER_TABLE ) ) )
2507: AND enr.program_id
2508: IN ( SELECT * FROM TABLE ( CAST( prgm_id_tbl AS JTF_NUMBER_TABLE ) ) )

Line 2523: , pv_pg_memberships memb

2519: , pv_partner_profiles global_prof
2520: , pv_enty_attr_values subs_enty_val
2521:
2522: , hz_relationships rel
2523: , pv_pg_memberships memb
2524: , pv_pg_enrl_requests enrq
2525: WHERE global_prof.partner_id = global_partner_id
2526: AND global_prof.partner_party_id = rel.subject_id
2527: AND rel.relationship_type = 'PARTNER_HIERARCHY'

Line 2545: FROM pv_pg_memberships memb

2541: IN ( SELECT * FROM TABLE ( CAST( p_depentent_id_tbl AS JTF_NUMBER_TABLE ) ) );
2542:
2543: CURSOR prereq_sub_csr( memb_id_tbl JTF_NUMBER_TABLE ) IS
2544: SELECT /*+ LEADING(t) */ DISTINCT( program_id )
2545: FROM pv_pg_memberships memb
2546: , (SELECT column_value FROM TABLE (CAST(memb_id_tbl AS JTF_NUMBER_TABLE))) t
2547: WHERE t.column_value=memb.membership_id;
2548: /*
2549: -- added new SQL above to fix this SQL reported in 11.5.10 CU1 in sql repositiry 12267161

Line 2551: FROM pv_pg_memberships

2547: WHERE t.column_value=memb.membership_id;
2548: /*
2549: -- added new SQL above to fix this SQL reported in 11.5.10 CU1 in sql repositiry 12267161
2550: SELECT DISTINCT( program_id )
2551: FROM pv_pg_memberships
2552: WHERE membership_id
2553: IN ( SELECT * FROM TABLE ( CAST( memb_id_tbl AS JTF_NUMBER_TABLE ) ) );
2554: */
2555: CURSOR memb_type_csr( memb_id NUMBER ) IS

Line 2559: FROM pv_pg_memberships memb

2555: CURSOR memb_type_csr( memb_id NUMBER ) IS
2556: SELECT enty.attr_value
2557: , memb.program_id
2558: , memb.partner_id
2559: FROM pv_pg_memberships memb
2560: , pv_enty_attr_values enty
2561: WHERE memb.membership_id = memb_id
2562: AND memb.partner_id = enty.entity_id
2563: AND enty.entity = 'PARTNER'

Line 2571: FROM pv_pg_memberships

2567:
2568: CURSOR memb_csr ( memb_id NUMBER ) IS
2569: SELECT program_id
2570: , partner_id
2571: FROM pv_pg_memberships
2572: WHERE membership_id = memb_id;
2573:
2574: l_isTerminatable boolean := true;
2575: l_program_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 3112: FROM pv_pg_memberships memb

3108: SELECT partner_id
3109: , original_end_date
3110: , enrl_request_id
3111: , program_name
3112: FROM pv_pg_memberships memb
3113: , pv_partner_program_vl prgm
3114: WHERE membership_id = p_memb_id
3115: AND memb.program_id=prgm.program_id;
3116:

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 3460: FROM pv_pg_memberships memb

3456: SELECT memb.partner_id
3457: , memb.object_version_number
3458: , enty.attr_value
3459: , memb.original_end_date
3460: FROM pv_pg_memberships memb
3461: , pv_enty_attr_values enty
3462: WHERE memb.membership_id=memb_id
3463: AND memb.partner_id=enty.entity_id
3464: AND enty.entity = 'PARTNER'

Line 3482: , pv_pg_memberships memb

3478: FROM pv_partner_profiles subs_prof
3479: , pv_partner_profiles global_prof
3480: , pv_enty_attr_values subs_enty_val
3481: , hz_relationships rel
3482: , pv_pg_memberships memb
3483: , pv_pg_enrl_requests enrl
3484: WHERE global_prof.partner_id = global_partner_id
3485: AND global_prof.partner_party_id = rel.subject_id
3486: AND rel.relationship_type = 'PARTNER_HIERARCHY'

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;