APPS.PV_PG_MEMBERSHIPS_PKG dependencies on PV_PG_MEMBERSHIPS

Line 1: PACKAGE BODY PV_Pg_Memberships_PKG as

1: PACKAGE BODY PV_Pg_Memberships_PKG as
2: /* $Header: pvxtmemb.pls 120.1 2005/10/24 09:36:12 dgottlie noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- PV_Pg_Memberships_PKG

2: /* $Header: pvxtmemb.pls 120.1 2005/10/24 09:36:12 dgottlie noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- PV_Pg_Memberships_PKG
7: -- Purpose
8: --
9: -- History
10: --

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

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

Line 80: INSERT INTO pv_pg_memberships(

76:
77: px_object_version_number := nvl(px_object_version_number, 1);
78:
79:
80: INSERT INTO pv_pg_memberships(
81: membership_id,
82: object_version_number,
83: partner_id,
84: program_id,

Line 192: Update pv_pg_memberships

188: p_attribute15 VARCHAR2)
189:
190: IS
191: BEGIN
192: Update pv_pg_memberships
193: SET
194: membership_id = DECODE( p_membership_id, null, membership_id, FND_API.G_MISS_NUM, null, p_membership_id),
195: object_version_number = nvl(p_object_version_number,0) + 1 ,
196: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),

Line 253: DELETE FROM pv_pg_memberships

249: p_membership_id NUMBER,
250: p_object_version_number NUMBER)
251: IS
252: BEGIN
253: DELETE FROM pv_pg_memberships
254: WHERE membership_id = p_membership_id
255: AND object_version_number = p_object_version_number;
256: If (SQL%NOTFOUND) then
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 283: FROM pv_pg_memberships

279: p_object_version_number NUMBER)
280: IS
281: CURSOR C IS
282: SELECT *
283: FROM pv_pg_memberships
284: WHERE membership_id = p_membership_id
285: AND object_version_number = p_object_version_number
286: FOR UPDATE OF membership_id NOWAIT;
287: Recinfo C%ROWTYPE;

Line 302: END PV_Pg_Memberships_PKG;

298: END Lock_Row;
299:
300:
301:
302: END PV_Pg_Memberships_PKG;