APPS.PV_TAP_ACCESS_TERRS_PKG dependencies on PV_TAP_ACCESS_TERRS

Line 1: PACKAGE BODY PV_TAP_ACCESS_TERRS_PKG as

1: PACKAGE BODY PV_TAP_ACCESS_TERRS_PKG as
2: /* $Header: pvxttrab.pls 115.0 2003/10/15 04:20:26 rdsharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- PV_TAP_ACCESS_TERRS_PKG

2: /* $Header: pvxttrab.pls 115.0 2003/10/15 04:20:26 rdsharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- PV_TAP_ACCESS_TERRS_PKG
7: -- Purpose
8: --
9: -- History
10: --

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

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

Line 68: INSERT INTO pv_TAP_ACCESS_TERRS(

64:
65: -- Initialize API return status to SUCCESS
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67:
68: INSERT INTO pv_TAP_ACCESS_TERRS(
69: partner_access_id,
70: terr_id,
71: last_update_date,
72: last_updated_by,

Line 140: Update PV_TAP_ACCESS_TERRS

136:
137: -- Initialize API return status to SUCCESS
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: Update PV_TAP_ACCESS_TERRS
141: SET
142: partner_access_id = DECODE( p_partner_access_id, null, partner_access_id, FND_API.G_MISS_NUM, null, p_partner_access_id),
143: terr_id = DECODE( p_terr_id, null, terr_id, FND_API.G_MISS_NUM, null, p_terr_id),
144: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 213: DELETE FROM PV_TAP_ACCESS_TERRS

209:
210: -- Initialize API return status to SUCCESS
211: x_return_status := FND_API.G_RET_STS_SUCCESS;
212:
213: DELETE FROM PV_TAP_ACCESS_TERRS
214: WHERE partner_access_id = p_partner_access_id
215: AND terr_id = p_terr_id
216: AND object_version_number = p_object_version_number;
217: If (SQL%NOTFOUND) then

Line 261: FROM PV_TAP_ACCESS_TERRS

257: x_return_status IN OUT NOCOPY VARCHAR2)
258: IS
259: CURSOR C IS
260: SELECT *
261: FROM PV_TAP_ACCESS_TERRS
262: WHERE partner_access_id = p_partner_access_id
263: AND terr_id = p_terr_id
264: AND object_version_number = p_object_version_number
265: FOR UPDATE OF partner_access_id,terr_id NOWAIT;

Line 306: END PV_TAP_ACCESS_TERRS_PKG;

302: END IF;
303:
304: END Lock_Row;
305:
306: END PV_TAP_ACCESS_TERRS_PKG;