APPS.PV_STATUS_NOTIFICATIONS_PKG dependencies on PV_STATUS_NOTIFICATIONS_PKG

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 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 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 344: end PV_STATUS_NOTIFICATIONS_PKG;

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