APPS.PV_PARTNER_ACCESSES_PKG dependencies on PV_PARTNER_ACCESSES

Line 1: PACKAGE BODY PV_Partner_Accesses_PKG as

1: PACKAGE BODY PV_Partner_Accesses_PKG as
2: /* $Header: pvxtprab.pls 115.0 2003/10/15 04:13:17 rdsharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- PV_Partner_Accesses_PKG

2: /* $Header: pvxtprab.pls 115.0 2003/10/15 04:13:17 rdsharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- PV_Partner_Accesses_PKG
7: -- Purpose
8: --
9: -- History
10: --

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

16: -- End of Comments
17: -- ===============================================================
18:
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Partner_Accesses_PKG';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxtprab.pls';
22:
23: -- ========================================================
24: --

Line 87: INSERT INTO pv_partner_accesses(

83:
84: -- Initialize API return status to SUCCESS
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87: INSERT INTO pv_partner_accesses(
88: partner_access_id,
89: partner_id,
90: resource_id,
91: keep_flag,

Line 223: Update pv_partner_accesses

219:
220: -- Initialize API return status to SUCCESS
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222:
223: Update pv_partner_accesses
224: SET
225: partner_access_id = DECODE( p_partner_access_id, null, partner_access_id, FND_API.G_MISS_NUM, null, p_partner_access_id),
226: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
227: resource_id = DECODE( p_resource_id, null, resource_id, FND_API.G_MISS_NUM, null, p_resource_id),

Line 312: DELETE FROM pv_partner_accesses

308:
309: -- Initialize API return status to SUCCESS
310: x_return_status := FND_API.G_RET_STS_SUCCESS;
311:
312: DELETE FROM pv_partner_accesses
313: WHERE partner_access_id = p_partner_access_id
314: AND object_version_number = p_object_version_number;
315: If (SQL%NOTFOUND) then
316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 359: FROM pv_partner_accesses

355: x_return_status IN OUT NOCOPY VARCHAR2)
356: IS
357: CURSOR C IS
358: SELECT *
359: FROM pv_partner_accesses
360: WHERE partner_access_id = p_partner_access_id
361: AND object_version_number = p_object_version_number
362: FOR UPDATE OF partner_access_id NOWAIT;
363: Recinfo C%ROWTYPE;

Line 401: END PV_Partner_Accesses_PKG;

397: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
398: END IF;
399: END Lock_Row;
400:
401: END PV_Partner_Accesses_PKG;