APPS.PV_PG_MMBR_TRANSITIONS_PKG dependencies on PV_PG_MMBR_TRANSITIONS

Line 1: PACKAGE BODY pv_pg_mmbr_transitions_PKG as

1: PACKAGE BODY pv_pg_mmbr_transitions_PKG as
2: /* $Header: pvxtmbtb.pls 115.1 2002/12/10 20:59:05 pukken ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- pv_pg_mmbr_transitions_PKG

2: /* $Header: pvxtmbtb.pls 115.1 2002/12/10 20:59:05 pukken ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- pv_pg_mmbr_transitions_PKG
7: -- Purpose
8: --
9: -- History
10: --

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

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

Line 63: INSERT INTO pv_pg_mmbr_transitions(

59:
60: px_object_version_number := nvl(px_object_version_number, 1);
61:
62:
63: INSERT INTO pv_pg_mmbr_transitions(
64: mmbr_transition_id,
65: from_membership_id,
66: to_membership_id,
67: object_version_number,

Line 112: Update pv_pg_mmbr_transitions

108: p_last_update_login NUMBER)
109:
110: IS
111: BEGIN
112: Update pv_pg_mmbr_transitions
113: SET
114: mmbr_transition_id = DECODE( p_mmbr_transition_id, null, mmbr_transition_id, FND_API.G_MISS_NUM, null, p_mmbr_transition_id),
115: from_membership_id = DECODE( p_from_membership_id, null, from_membership_id, FND_API.G_MISS_NUM, null, p_from_membership_id),
116: to_membership_id = DECODE( p_to_membership_id, null, to_membership_id, FND_API.G_MISS_NUM, null, p_to_membership_id),

Line 152: DELETE FROM pv_pg_mmbr_transitions

148: p_mmbr_transition_id NUMBER,
149: p_object_version_number NUMBER)
150: IS
151: BEGIN
152: DELETE FROM pv_pg_mmbr_transitions
153: WHERE mmbr_transition_id = p_mmbr_transition_id
154: AND object_version_number = p_object_version_number;
155: If (SQL%NOTFOUND) then
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 182: FROM pv_pg_mmbr_transitions

178: p_object_version_number NUMBER)
179: IS
180: CURSOR C IS
181: SELECT *
182: FROM pv_pg_mmbr_transitions
183: WHERE mmbr_transition_id = p_mmbr_transition_id
184: AND object_version_number = p_object_version_number
185: FOR UPDATE OF mmbr_transition_id NOWAIT;
186: Recinfo C%ROWTYPE;

Line 201: END pv_pg_mmbr_transitions_PKG;

197: END Lock_Row;
198:
199:
200:
201: END pv_pg_mmbr_transitions_PKG;