1 package IBE_WF_NOTIF_SETUP_PVT as
2 /* $Header: IBEVWFNS.pls 120.1 2005/06/03 16:44:10 appldev $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_WF_NOTIF_SETUP_PVT';
5 G_API_VERSION CONSTANT NUMBER := 1.0;
6 procedure INSERT_ROW (
7 X_ROWID in out NOCOPY VARCHAR2,
8 P_NOTIF_SETUP_ID in NUMBER,
9 P_ORG_ID_FLAG in VARCHAR2,
10 P_MSITE_ID_FLAG in VARCHAR2,
11 P_USER_TYPE_FLAG in VARCHAR2,
12 P_ENABLED_FLAG in VARCHAR2,
13 P_DEFAULT_MESSAGE_NAME in VARCHAR2,
14 P_UPDATE_ENABLED_FLAG in VARCHAR2,
15 P_OBJECT_VERSION_NUMBER in NUMBER,
16 P_NOTIFICATION_NAME in VARCHAR2,
17 p_customized_flag IN VARCHAR2,
18 P_CREATION_DATE in DATE,
19 P_CREATED_BY in NUMBER,
20 P_LAST_UPDATE_DATE in DATE,
21 P_LAST_UPDATED_BY in NUMBER,
22 P_LAST_UPDATE_LOGIN in NUMBER);
23
24 procedure LOCK_ROW (
25 P_NOTIF_SETUP_ID in NUMBER,
26 P_ORG_ID_FLAG in VARCHAR2,
27 P_MSITE_ID_FLAG in VARCHAR2,
28 P_USER_TYPE_FLAG in VARCHAR2,
29 P_ENABLED_FLAG in VARCHAR2,
30 P_DEFAULT_MESSAGE_NAME in VARCHAR2,
31 P_UPDATE_ENABLED_FLAG in VARCHAR2,
32 P_OBJECT_VERSION_NUMBER in NUMBER,
33 P_NOTIFICATION_NAME in VARCHAR2,
34 P_CUSTOMIZED_FLAG IN VARCHAR2
35 );
36
37 procedure UPDATE_ROW (
38 P_NOTIF_SETUP_ID in NUMBER,
39 P_ORG_ID_FLAG in VARCHAR2,
40 P_MSITE_ID_FLAG in VARCHAR2,
41 P_USER_TYPE_FLAG in VARCHAR2,
42 P_ENABLED_FLAG in VARCHAR2,
43 P_DEFAULT_MESSAGE_NAME in VARCHAR2,
44 P_UPDATE_ENABLED_FLAG in VARCHAR2,
45 P_OBJECT_VERSION_NUMBER in NUMBER,
46 P_NOTIFICATION_NAME in VARCHAR2,
47 p_customized_flag IN VARCHAR2,
48 P_LAST_UPDATE_DATE in DATE,
49 P_LAST_UPDATED_BY in NUMBER,
50 P_LAST_UPDATE_LOGIN in NUMBER
51 );
52
53 procedure DELETE_ROW (
54 p_NOTIF_SETUP_ID in NUMBER
55 );
56
57 procedure LOAD_ROW(
58 P_NOTIF_SETUP_ID in NUMBER,
59 P_OWNER IN VARCHAR2,
60 P_ORG_ID_FLAG in VARCHAR2,
61 P_MSITE_ID_FLAG in VARCHAR2,
62 P_USER_TYPE_FLAG in VARCHAR2,
63 P_ENABLED_FLAG in VARCHAR2,
64 P_DEFAULT_MESSAGE_NAME in VARCHAR2,
65 P_UPDATE_ENABLED_FLAG in VARCHAR2,
66 P_OBJECT_VERSION_NUMBER in NUMBER,
67 p_customized_flag IN VARCHAR2,
68 P_NOTIFICATION_NAME in VARCHAR2,
69 P_LAST_UPDATE_DATE in varchar2,
70 P_CUSTOM_MODE in varchar2);
71
72 procedure Save_WF_Notif_Setup(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75 p_commit IN VARCHAR2 := FND_API.G_FALSE,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 P_NOTIF_SETUP_ID in NUMBER,
80 P_ORG_ID_FLAG in VARCHAR2,
81 P_MSITE_ID_FLAG in VARCHAR2,
82 P_USER_TYPE_FLAG in VARCHAR2,
83 P_ENABLED_FLAG in VARCHAR2,
84 P_DEFAULT_MESSAGE_NAME in VARCHAR2,
85 P_UPDATE_ENABLED_FLAG in VARCHAR2,
86 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
87 P_NOTIFICATION_NAME in VARCHAR2,
88 p_customized_flag IN VARCHAR2
89 );
90
91 procedure update_wf_notif_setup(
92 x_return_status OUT NOCOPY JTF_VARCHAR2_TABLE_100,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
95 p_notif_name_tbl IN JTF_VARCHAR2_TABLE_100,
96 p_enabled_flag_tbl IN JTF_VARCHAR2_TABLE_100);
97
98 PROCEDURE delete_wf_notif_setup
99 (
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102 p_commit IN VARCHAR2 := FND_API.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_notification_name IN VARCHAR2
107 );
108
109 FUNCTION check_notif_exists(p_notif_setup_id IN NUMBER,
110 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)
111 RETURN BOOLEAN;
112
113 FUNCTION Check_Notif_Duplicate(p_notification_name IN VARCHAR2) RETURN BOOLEAN;
114
115 FUNCTION Check_Notif_Enabled(p_notification_name IN VARCHAR2) RETURN VARCHAR2;
116
117 Procedure LOAD_SEED_ROW(
118 P_NOTIF_SETUP_ID in NUMBER,
119 P_OWNER IN VARCHAR2,
120 P_ORG_ID_FLAG in VARCHAR2,
121 P_MSITE_ID_FLAG in VARCHAR2,
122 P_USER_TYPE_FLAG in VARCHAR2,
123 P_ENABLED_FLAG in VARCHAR2,
124 P_DEFAULT_MESSAGE_NAME in VARCHAR2,
125 P_UPDATE_ENABLED_FLAG in VARCHAR2,
126 P_OBJECT_VERSION_NUMBER in NUMBER,
127 p_customized_flag IN VARCHAR2,
128 P_NOTIFICATION_NAME in VARCHAR2,
129 P_LAST_UPDATE_DATE in varchar2,
130 P_CUSTOM_MODE in VARCHAR2,
131 P_UPLOAD_MODE in VARCHAR2);
132
133 end IBE_WF_NOTIF_SETUP_PVT;