APPS.PV_BATCH_CHG_PRTNR_PKG dependencies on PV_TAP_BATCH_CHG_PARTNERS

Line 6: -- PV_TAP_BATCH_CHG_PARTNERS_PKG

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

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

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

Line 67: INSERT INTO PV_TAP_BATCH_CHG_PARTNERS(

63: -- Initialize API return status to SUCCESS
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66:
67: INSERT INTO PV_TAP_BATCH_CHG_PARTNERS(
68: partner_id,
69: last_update_date,
70: last_update_by,
71: creation_date,

Line 147: Update PV_TAP_BATCH_CHG_PARTNERS

143:
144: -- Initialize API return status to SUCCESS
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146:
147: Update PV_TAP_BATCH_CHG_PARTNERS
148: SET
149: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
150: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
151: last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),

Line 218: DELETE FROM PV_TAP_BATCH_CHG_PARTNERS

214:
215: -- Initialize API return status to SUCCESS
216: x_return_status := FND_API.G_RET_STS_SUCCESS;
217:
218: DELETE FROM PV_TAP_BATCH_CHG_PARTNERS
219: WHERE partner_id = p_partner_id
220: AND object_version_number = p_object_version_number;
221: If (SQL%NOTFOUND) then
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 269: FROM PV_TAP_BATCH_CHG_PARTNERS

265: x_return_status IN OUT NOCOPY VARCHAR2)
266: IS
267: CURSOR C IS
268: SELECT *
269: FROM PV_TAP_BATCH_CHG_PARTNERS
270: WHERE partner_id = p_partner_id
271: AND object_version_number = p_object_version_number
272: FOR UPDATE OF partner_id NOWAIT;
273: Recinfo C%ROWTYPE;