1 package PV_STATUS_NOTIFICATIONS_PKG as
2 /* $Header: pvxtsnfs.pls 120.0 2005/07/11 23:13:08 appldev noship $ */
3
4 procedure INSERT_ROW (
5 px_status_notification_id in out nocopy NUMBER,
6 px_object_version_number in out nocopy NUMBER,
7 p_status_type in VARCHAR2,
8 p_status_code in VARCHAR2,
9 p_enabled_flag in VARCHAR2,
10 p_notify_pt_flag in VARCHAR2,
11 p_notify_cm_flag in VARCHAR2,
12 p_notify_am_flag in VARCHAR2,
13 p_notify_others_flag in VARCHAR2,
14 p_creation_date in DATE,
15 p_created_by in NUMBER,
16 p_last_update_date in DATE,
17 p_last_updated_by in NUMBER,
18 p_last_update_login in NUMBER);
19
20 procedure LOCK_ROW (
21 p_status_notification_id in NUMBER,
22 p_object_version_number in NUMBER,
23 p_status_type in VARCHAR2,
24 p_status_code in VARCHAR2,
25 p_enabled_flag in VARCHAR2,
26 p_notify_pt_flag in VARCHAR2,
27 p_notify_cm_flag in VARCHAR2,
28 p_notify_am_flag in VARCHAR2,
29 p_notify_others_flag in VARCHAR2
30 );
31
32 procedure UPDATE_ROW (
33 p_status_notification_id in NUMBER,
34 p_object_version_number in NUMBER,
35 p_status_type in VARCHAR2,
36 p_status_code in VARCHAR2,
37 p_enabled_flag in VARCHAR2,
38 p_notify_pt_flag in VARCHAR2,
39 p_notify_cm_flag in VARCHAR2,
40 p_notify_am_flag in VARCHAR2,
41 p_notify_others_flag in VARCHAR2,
42 p_last_update_date in DATE,
43 p_last_updated_by in NUMBER,
44 p_last_update_login in NUMBER
45 );
46
47 procedure UPDATE_ROW_SEED (
48 p_status_notification_id in NUMBER,
49 p_object_version_number in NUMBER,
50 p_status_type in VARCHAR2,
51 p_status_code in VARCHAR2,
52 p_enabled_flag in VARCHAR2,
53 p_notify_pt_flag in VARCHAR2,
54 p_notify_cm_flag in VARCHAR2,
55 p_notify_am_flag in VARCHAR2,
56 p_notify_others_flag in VARCHAR2,
57 p_last_update_date in DATE,
58 p_last_updated_by in NUMBER,
59 p_last_update_login in NUMBER
60 );
61
62 procedure SEED_UPDATE_ROW (
63 p_status_notification_id in NUMBER,
64 p_object_version_number in NUMBER,
65 p_status_type in VARCHAR2,
66 p_status_code in VARCHAR2,
67 p_last_update_date in DATE,
68 p_last_updated_by in NUMBER,
69 p_last_update_login in NUMBER
70 );
71
72 procedure LOAD_ROW (
73 p_upload_mode in VARCHAR2,
74 p_status_notification_id in NUMBER,
75 p_object_version_number in NUMBER,
76 p_status_type in VARCHAR2,
77 p_status_code in VARCHAR2,
78 p_enabled_flag in VARCHAR2,
79 p_notify_pt_flag in VARCHAR2,
80 p_notify_cm_flag in VARCHAR2,
81 p_notify_am_flag in VARCHAR2,
82 p_notify_others_flag in VARCHAR2,
83 p_owner in VARCHAR2
84 );
85 procedure DELETE_ROW (
86 p_STATUS_NOTIFICATION_ID in NUMBER
87 );
88 end PV_STATUS_NOTIFICATIONS_PKG;