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_PARTNER_ACCESSES_PVT dependencies on PV_PARTNER_ACCESSES

Line 1: PACKAGE BODY PV_Partner_Accesses_PVT as

1: PACKAGE BODY PV_Partner_Accesses_PVT as
2: /* $Header: pvxvprab.pls 120.1 2005/09/05 23:50:35 appldev ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- PV_Partner_Accesses_PVT

2: /* $Header: pvxvprab.pls 120.1 2005/09/05 23:50:35 appldev ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- PV_Partner_Accesses_PVT
7: -- Purpose
8: --
9: -- History
10: --

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

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

Line 91: SELECT pv_partner_accesses_s.NEXTVAL

87: l_err_msg VARCHAR2(2000);
88: l_return_status VARCHAR2(1);
89:
90: CURSOR c_id IS
91: SELECT pv_partner_accesses_s.NEXTVAL
92: FROM dual;
93:
94: CURSOR c_id_exists (l_id IN NUMBER) IS
95: SELECT 1

Line 96: FROM PV_PARTNER_ACCESSES

92: FROM dual;
93:
94: CURSOR c_id_exists (l_id IN NUMBER) IS
95: SELECT 1
96: FROM PV_PARTNER_ACCESSES
97: WHERE partner_access_id = l_id;
98: BEGIN
99: -- Standard Start of API savepoint
100: SAVEPOINT create_partner_accesses_pvt;

Line 181: -- Invoke table handler(Pv_Partner_Accesses_Pkg.Insert_Row)

177: IF (PV_DEBUG_HIGH_ON) THEN
178: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler.');
179: END IF;
180:
181: -- Invoke table handler(Pv_Partner_Accesses_Pkg.Insert_Row)
182: Pv_Partner_Accesses_Pkg.Insert_Row(
183: px_partner_access_id => l_partner_access_id,
184: p_partner_id => p_partner_access_rec.partner_id,
185: p_resource_id => p_partner_access_rec.resource_id,

Line 182: Pv_Partner_Accesses_Pkg.Insert_Row(

178: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler.');
179: END IF;
180:
181: -- Invoke table handler(Pv_Partner_Accesses_Pkg.Insert_Row)
182: Pv_Partner_Accesses_Pkg.Insert_Row(
183: px_partner_access_id => l_partner_access_id,
184: p_partner_id => p_partner_access_rec.partner_id,
185: p_resource_id => p_partner_access_rec.resource_id,
186: p_keep_flag => p_partner_access_rec.keep_flag,

Line 340: FROM PV_PARTNER_ACCESSES

336: IS
337:
338: CURSOR c_get_partner_accesses(cv_partner_access_id NUMBER) IS
339: SELECT *
340: FROM PV_PARTNER_ACCESSES
341: WHERE partner_access_id = cv_partner_access_id;
342:
343: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Partner_Accesses';
344: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 451: -- Invoke table handler(Pv_Partner_Accesses_Pkg.Update_Row)

447: IF (PV_DEBUG_HIGH_ON) THEN
448: PVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
449: END IF;
450:
451: -- Invoke table handler(Pv_Partner_Accesses_Pkg.Update_Row)
452: Pv_Partner_Accesses_Pkg.Update_Row(
453: p_partner_access_id => p_partner_access_rec.partner_access_id,
454: p_partner_id => p_partner_access_rec.partner_id,
455: p_resource_id => p_partner_access_rec.resource_id,

Line 452: Pv_Partner_Accesses_Pkg.Update_Row(

448: PVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
449: END IF;
450:
451: -- Invoke table handler(Pv_Partner_Accesses_Pkg.Update_Row)
452: Pv_Partner_Accesses_Pkg.Update_Row(
453: p_partner_access_id => p_partner_access_rec.partner_access_id,
454: p_partner_id => p_partner_access_rec.partner_id,
455: p_resource_id => p_partner_access_rec.resource_id,
456: p_keep_flag => p_partner_access_rec.keep_flag,

Line 649: -- Invoke table handler(Pv_Partner_Accesses_Pkg.Delete_Row)

645: IF (PV_DEBUG_HIGH_ON) THEN
646: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
647: END IF;
648:
649: -- Invoke table handler(Pv_Partner_Accesses_Pkg.Delete_Row)
650: Pv_Partner_Accesses_Pkg.Delete_Row(
651: p_partner_access_id => p_partner_access_id,
652: p_object_version_number => p_object_version_number ,
653: x_return_status => x_return_status);

Line 650: Pv_Partner_Accesses_Pkg.Delete_Row(

646: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
647: END IF;
648:
649: -- Invoke table handler(Pv_Partner_Accesses_Pkg.Delete_Row)
650: Pv_Partner_Accesses_Pkg.Delete_Row(
651: p_partner_access_id => p_partner_access_id,
652: p_object_version_number => p_object_version_number ,
653: x_return_status => x_return_status);
654:

Line 811: Pv_Partner_Accesses_Pkg.Lock_Row(

807: -- Initialize API return status to SUCCESS
808: x_return_status := FND_API.G_RET_STS_SUCCESS;
809:
810: ------------------------ lock -------------------------
811: Pv_Partner_Accesses_Pkg.Lock_Row(
812: p_partner_access_id,
813: p_object_version_number,
814: x_return_status);
815:

Line 887: 'pv_partner_accesses',

883: x_return_status := FND_API.g_ret_sts_success;
884: IF p_validation_mode = JTF_PLSQL_API.g_create AND
885: p_partner_access_rec.partner_access_id IS NOT NULL THEN
886: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
887: 'pv_partner_accesses',
888: 'partner_access_id = ''' || p_partner_access_rec.partner_access_id ||''''
889: );
890: END IF;
891:

Line 1084: FROM pv_partner_accesses

1080: l_return_status VARCHAR2(1);
1081:
1082: CURSOR c_complete IS
1083: SELECT *
1084: FROM pv_partner_accesses
1085: WHERE partner_access_id = p_partner_access_rec.partner_access_id;
1086: l_partner_access_rec c_complete%ROWTYPE;
1087: BEGIN
1088: x_complete_rec := p_partner_access_rec;

Line 1462: END PV_Partner_Accesses_PVT;

1458: p_data => x_msg_data
1459: );
1460: END Validate_partner_access_Rec;
1461:
1462: END PV_Partner_Accesses_PVT;