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_MMBR_TRANSITIONS_PVT dependencies on PV_PG_MMBR_TRANSITIONS

Line 1: PACKAGE BODY pv_pg_mmbr_transitions_PVT as

1: PACKAGE BODY pv_pg_mmbr_transitions_PVT as
2: /* $Header: pvxvmbtb.pls 120.1 2005/08/26 10:21:16 appldev ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- pv_pg_mmbr_transitions_PVT

2: /* $Header: pvxvmbtb.pls 120.1 2005/08/26 10:21:16 appldev ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- pv_pg_mmbr_transitions_PVT
7: -- Purpose
8: --
9: -- History
10: --

Line 20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'pv_pg_mmbr_transitions_PVT';

16: -- End of Comments
17: -- ===============================================================
18:
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'pv_pg_mmbr_transitions_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvmbtb.pls';
22:
23: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
24: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 97: SELECT pv_pg_mmbr_transitions_s.NEXTVAL

93: l_org_id NUMBER := FND_API.G_MISS_NUM;
94: l_mmbr_transition_id NUMBER;
95: l_dummy NUMBER;
96: CURSOR c_id IS
97: SELECT pv_pg_mmbr_transitions_s.NEXTVAL
98: FROM dual;
99:
100: CURSOR c_id_exists (l_id IN NUMBER) IS
101: SELECT 1

Line 102: FROM PV_PG_MMBR_TRANSITIONS

98: FROM dual;
99:
100: CURSOR c_id_exists (l_id IN NUMBER) IS
101: SELECT 1
102: FROM PV_PG_MMBR_TRANSITIONS
103: WHERE mmbr_transition_id = l_id;
104: BEGIN
105: -- Standard Start of API savepoint
106: SAVEPOINT create_mmbr_trans_pvt;

Line 197: -- Invoke table handler(pv_pg_mmbr_transitions_Pkg.Insert_Row)

193:
194: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
195: END IF;
196:
197: -- Invoke table handler(pv_pg_mmbr_transitions_Pkg.Insert_Row)
198: pv_pg_mmbr_transitions_Pkg.Insert_Row(
199: px_mmbr_transition_id => l_mmbr_transition_id,
200: p_from_membership_id => p_mmbr_tran_rec.from_membership_id,
201: p_to_membership_id => p_mmbr_tran_rec.to_membership_id,

Line 198: pv_pg_mmbr_transitions_Pkg.Insert_Row(

194: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
195: END IF;
196:
197: -- Invoke table handler(pv_pg_mmbr_transitions_Pkg.Insert_Row)
198: pv_pg_mmbr_transitions_Pkg.Insert_Row(
199: px_mmbr_transition_id => l_mmbr_transition_id,
200: p_from_membership_id => p_mmbr_tran_rec.from_membership_id,
201: p_to_membership_id => p_mmbr_tran_rec.to_membership_id,
202: px_object_version_number => l_object_version_number,

Line 330: FROM PV_PG_MMBR_TRANSITIONS

326:
327:
328: CURSOR c_get_mmbr_trans(mmbr_transition_id NUMBER) IS
329: SELECT *
330: FROM PV_PG_MMBR_TRANSITIONS
331: WHERE mmbr_transition_id = p_mmbr_tran_rec.mmbr_transition_id;
332: -- Hint: Developer need to provide Where clause
333:
334:

Line 448: -- Invoke table handler(pv_pg_mmbr_transitions_Pkg.Update_Row)

444:
445: PVX_UTILITY_PVT.debug_message( 'Private API: Calling update table handler');
446: END IF;
447:
448: -- Invoke table handler(pv_pg_mmbr_transitions_Pkg.Update_Row)
449: pv_pg_mmbr_transitions_Pkg.Update_Row(
450: p_mmbr_transition_id => p_mmbr_tran_rec.mmbr_transition_id,
451: p_from_membership_id => p_mmbr_tran_rec.from_membership_id,
452: p_to_membership_id => p_mmbr_tran_rec.to_membership_id,

Line 449: pv_pg_mmbr_transitions_Pkg.Update_Row(

445: PVX_UTILITY_PVT.debug_message( 'Private API: Calling update table handler');
446: END IF;
447:
448: -- Invoke table handler(pv_pg_mmbr_transitions_Pkg.Update_Row)
449: pv_pg_mmbr_transitions_Pkg.Update_Row(
450: p_mmbr_transition_id => p_mmbr_tran_rec.mmbr_transition_id,
451: p_from_membership_id => p_mmbr_tran_rec.from_membership_id,
452: p_to_membership_id => p_mmbr_tran_rec.to_membership_id,
453: p_object_version_number => p_mmbr_tran_rec.object_version_number,

Line 616: -- Invoke table handler(pv_pg_mmbr_transitions_Pkg.Delete_Row)

612:
613: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
614: END IF;
615:
616: -- Invoke table handler(pv_pg_mmbr_transitions_Pkg.Delete_Row)
617: pv_pg_mmbr_transitions_Pkg.Delete_Row(
618: p_mmbr_transition_id => p_mmbr_transition_id,
619: p_object_version_number => p_object_version_number );
620: --

Line 617: pv_pg_mmbr_transitions_Pkg.Delete_Row(

613: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
614: END IF;
615:
616: -- Invoke table handler(pv_pg_mmbr_transitions_Pkg.Delete_Row)
617: pv_pg_mmbr_transitions_Pkg.Delete_Row(
618: p_mmbr_transition_id => p_mmbr_transition_id,
619: p_object_version_number => p_object_version_number );
620: --
621: -- End of API body

Line 771: pv_pg_mmbr_transitions_Pkg.Lock_Row(l_mmbr_transition_id,p_object_version);

767: x_return_status := FND_API.G_RET_STS_SUCCESS;
768:
769:
770: ------------------------ lock -------------------------
771: pv_pg_mmbr_transitions_Pkg.Lock_Row(l_mmbr_transition_id,p_object_version);
772:
773:
774: -------------------- finish --------------------------
775: FND_MSG_PUB.count_and_get(

Line 840: 'pv_pg_mmbr_transitions',

836: IF p_validation_mode = JTF_PLSQL_API.g_create
837: AND p_mmbr_tran_rec.mmbr_transition_id IS NOT NULL
838: THEN
839: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
840: 'pv_pg_mmbr_transitions',
841: 'mmbr_transition_id = ''' || p_mmbr_tran_rec.mmbr_transition_id ||''''
842: );
843: END IF;
844:

Line 846: PVX_UTILITY_PVT.Error_Message(p_message_name => 'pv_pg_mmbr_transitionsition_id_DUPLICATE');

842: );
843: END IF;
844:
845: IF l_valid_flag = FND_API.g_false THEN
846: PVX_UTILITY_PVT.Error_Message(p_message_name => 'pv_pg_mmbr_transitionsition_id_DUPLICATE');
847: x_return_status := FND_API.g_ret_sts_error;
848: END IF;
849:
850: END check_Mmbr_Tran_Uk_Items;

Line 1011: FROM pv_pg_mmbr_transitions

1007: l_return_status VARCHAR2(1);
1008:
1009: CURSOR c_complete IS
1010: SELECT *
1011: FROM pv_pg_mmbr_transitions
1012: WHERE mmbr_transition_id = p_mmbr_tran_rec.mmbr_transition_id;
1013: l_mmbr_tran_rec c_complete%ROWTYPE;
1014: BEGIN
1015: x_complete_rec := p_mmbr_tran_rec;

Line 1276: END pv_pg_mmbr_transitions_PVT;

1272: p_data => x_msg_data
1273: );
1274: END Validate_mmbr_tran_Rec;
1275:
1276: END pv_pg_mmbr_transitions_PVT;