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.0 2005/07/11 23:13:09 appldev noship $ */
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 292: PV_STATUS_NOTIFICATIONS_PKG.INSERT_ROW(

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

Line 313: PV_STATUS_NOTIFICATIONS_PKG.UPDATE_ROW_SEED(

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

Line 347: end PV_STATUS_NOTIFICATIONS_PKG;

343:
344: END DELETE_ROW;
345:
346:
347: end PV_STATUS_NOTIFICATIONS_PKG;