APPS.PV_GE_PARTY_NOTIF_PKG dependencies on PV_GE_PARTY_NOTIFICATIONS

Line 67: INSERT INTO pv_ge_party_notifications(

63:
64: px_object_version_number := nvl(px_object_version_number, 1);
65:
66:
67: INSERT INTO pv_ge_party_notifications(
68: party_notification_id,
69: notification_id,
70: object_version_number,
71: partner_id,

Line 128: Update pv_ge_party_notifications

124: p_last_update_login NUMBER)
125:
126: IS
127: BEGIN
128: Update pv_ge_party_notifications
129: SET
130: party_notification_id = DECODE( p_party_notification_id, null, party_notification_id, FND_API.G_MISS_NUM, null, p_party_notification_id),
131: notification_id = DECODE( p_notification_id, null, notification_id, FND_API.G_MISS_NUM, null, p_notification_id),
132: object_version_number = nvl(p_object_version_number,0) + 1 ,

Line 172: DELETE FROM pv_ge_party_notifications

168: p_party_notification_id NUMBER,
169: p_object_version_number NUMBER)
170: IS
171: BEGIN
172: DELETE FROM pv_ge_party_notifications
173: WHERE party_notification_id = p_party_notification_id
174: AND object_version_number = p_object_version_number;
175: If (SQL%NOTFOUND) then
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 202: FROM pv_ge_party_notifications

198: p_object_version_number NUMBER)
199: IS
200: CURSOR C IS
201: SELECT *
202: FROM pv_ge_party_notifications
203: WHERE party_notification_id = p_party_notification_id
204: AND object_version_number = p_object_version_number
205: FOR UPDATE OF party_notification_id NOWAIT;
206: Recinfo C%ROWTYPE;