APPS.PV_STATUS_NOTIFICATIONS_PKG dependencies on PV_STATUS_NOTIFICATIONS

Line 1: package body PV_STATUS_NOTIFICATIONS_PKG as

1: package body PV_STATUS_NOTIFICATIONS_PKG as
2: /* $Header: pvxtsnfb.pls 120.1 2011/03/25 21:40:56 hekkiral ship $ */
3:
4: procedure INSERT_ROW (
5: px_status_notification_id in out nocopy NUMBER,

Line 23: insert into PV_STATUS_NOTIFICATIONS (

19:
20: begin
21: px_object_version_number := 1;
22:
23: insert into PV_STATUS_NOTIFICATIONS (
24: status_notification_id,
25: object_version_number,
26: status_type,
27: status_code,

Line 79: FROM pv_status_notifications

75: notify_pt_flag,
76: notify_cm_flag,
77: notify_am_flag,
78: notify_others_flag
79: FROM pv_status_notifications
80: WHERE status_notification_id = p_status_notification_id
81: FOR UPDATE OF status_notification_id NOWAIT;
82:
83: recinfo c%ROWTYPE;

Line 130: UPDATE pv_status_notifications

126: p_last_updated_by in NUMBER,
127: p_last_update_login in NUMBER
128: ) IS
129: BEGIN
130: UPDATE pv_status_notifications
131: SET
132: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ) ,
133: status_type = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
134: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),

Line 161: UPDATE pv_status_notifications

157: p_last_updated_by in NUMBER,
158: p_last_update_login in NUMBER
159: ) IS
160: BEGIN
161: UPDATE pv_status_notifications
162: SET
163: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
164: status_type = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
165: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),

Line 195: FROM pv_status_notifications

191:
192: CURSOR c_updated_by
193: IS
194: SELECT last_updated_by
195: FROM pv_status_notifications
196: WHERE status_notification_id = p_status_notification_id;
197:
198: l_last_updated_by NUMBER;
199:

Line 214: PV_STATUS_NOTIFICATIONS_PKG.UPDATE_ROW(

210: -- Else we will update enabled_flag
211:
212: IF ( l_last_updated_by = 1) THEN
213:
214: PV_STATUS_NOTIFICATIONS_PKG.UPDATE_ROW(
215: p_status_notification_id => p_status_notification_id,
216: p_object_version_number => p_object_version_number,
217: p_status_type => p_status_type,
218: p_status_code => p_status_code,

Line 231: PV_STATUS_NOTIFICATIONS_PKG.SEED_UPDATE_ROW(

227:
228:
229: ELSE
230:
231: PV_STATUS_NOTIFICATIONS_PKG.SEED_UPDATE_ROW(
232: p_status_notification_id => p_status_notification_id,
233: p_object_version_number => p_object_version_number,
234: p_status_type => p_status_type,
235: p_status_code => p_status_code,

Line 268: FROM pv_status_notifications

264: l_status_notification_id number := p_status_notification_id;
265:
266: cursor c_obj_verno is
267: SELECT object_version_number
268: FROM pv_status_notifications
269: WHERE status_notification_id = p_status_notification_id;
270:
271: cursor c_chk_status_exists is
272: SELECT 'x'

Line 273: FROM pv_status_notifications

269: WHERE status_notification_id = p_status_notification_id;
270:
271: cursor c_chk_status_exists is
272: SELECT 'x'
273: FROM pv_status_notifications
274: WHERE status_notification_id = p_status_notification_id;
275:
276:
277: BEGIN

Line 289: PV_STATUS_NOTIFICATIONS_PKG.INSERT_ROW(

285: FETCH c_chk_status_exists INTO l_dummy_char;
286: IF c_chk_status_exists%NOTFOUND THEN
287: CLOSE c_chk_status_exists;
288: l_obj_verno := 1;
289: PV_STATUS_NOTIFICATIONS_PKG.INSERT_ROW(
290: px_status_notification_id => l_status_notification_id,
291: px_object_version_number => l_obj_verno,
292: p_status_type => p_status_type,
293: p_status_code => p_status_code,

Line 310: PV_STATUS_NOTIFICATIONS_PKG.UPDATE_ROW_SEED(

306: open c_obj_verno;
307: fetch c_obj_verno into l_obj_verno;
308: close c_obj_verno;
309:
310: PV_STATUS_NOTIFICATIONS_PKG.UPDATE_ROW_SEED(
311: p_status_notification_id => p_status_notification_id,
312: p_object_version_number => l_obj_verno,
313: p_status_type => p_status_type,
314: p_status_code => p_status_code,

Line 334: DELETE FROM pv_status_notifications

330: )
331: IS
332: BEGIN
333:
334: DELETE FROM pv_status_notifications
335: WHERE status_notification_id = p_status_notification_id;
336:
337: IF (SQL%NOTFOUND) THEN
338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 344: end PV_STATUS_NOTIFICATIONS_PKG;

340:
341: END DELETE_ROW;
342:
343:
344: end PV_STATUS_NOTIFICATIONS_PKG;