1 package IBE_WF_NOTIF_MSG_MAPS_PVT AUTHID CURRENT_USER as
2 /* $Header: IBEVWNMS.pls 120.1 2005/06/09 06:58:17 appldev $ */
3
4 -- HISTORY
5 -- 12/12/02 SCHAK Modified for NOCOPY (Bug # 2691704) Changes.
6 -- *********************************************************************************
7
8 g_pkg_name CONSTANT VARCHAR2(30) := 'IBE_WF_NOTIF_MSG_MAPS_PVT';
9 g_api_version CONSTANT NUMBER := 1.0;
10
11 procedure INSERT_ROW (
12 X_ROWID in out NOCOPY VARCHAR2,
13 P_NOTIF_MSG_MAP_ID in NUMBER,
14 P_NOTIF_SETUP_ID in NUMBER,
15 P_NOTIFICATION_NAME in VARCHAR2,
16 P_USER_TYPE in VARCHAR2,
17 P_ENABLED_FLAG in VARCHAR2,
18 P_DEFAULT_MSG_MAP_FLAG in VARCHAR2,
19 P_OBJECT_VERSION_NUMBER in NUMBER,
20 P_ALL_ORG_FLAG in VARCHAR2,
21 P_ALL_MSITE_FLAG in VARCHAR2,
22 P_ALL_USER_TYPE_FLAG in VARCHAR2,
23 P_MSITE_ID in NUMBER,
24 P_ORG_ID IN NUMBER,
25 P_MESSAGE_NAME in VARCHAR2,
26 P_CREATION_DATE in DATE,
27 P_CREATED_BY in NUMBER,
28 P_LAST_UPDATE_DATE in DATE,
29 P_LAST_UPDATED_BY in NUMBER,
30 P_LAST_UPDATE_LOGIN in NUMBER);
31
32 procedure LOCK_ROW (
33 P_NOTIF_MSG_MAP_ID in NUMBER,
34 P_NOTIF_SETUP_ID in NUMBER,
35 P_NOTIFICATION_NAME in VARCHAR2,
36 P_USER_TYPE in VARCHAR2,
37 P_ENABLED_FLAG in VARCHAR2,
38 P_DEFAULT_MSG_MAP_FLAG in VARCHAR2,
39 P_OBJECT_VERSION_NUMBER in NUMBER,
40 P_ALL_ORG_FLAG in VARCHAR2,
41 P_ALL_MSITE_FLAG in VARCHAR2,
42 P_ALL_USER_TYPE_FLAG in VARCHAR2,
43 P_MSITE_ID in NUMBER,
44 P_ORG_ID IN NUMBER,
45 P_MESSAGE_NAME in VARCHAR2
46 );
47
48 procedure UPDATE_ROW (
49 P_NOTIF_MSG_MAP_ID in NUMBER,
50 P_NOTIF_SETUP_ID in NUMBER,
51 P_NOTIFICATION_NAME in VARCHAR2,
52 P_USER_TYPE in VARCHAR2,
53 P_ENABLED_FLAG in VARCHAR2,
54 P_DEFAULT_MSG_MAP_FLAG in VARCHAR2,
55 P_OBJECT_VERSION_NUMBER in NUMBER,
56 P_ALL_ORG_FLAG in VARCHAR2,
57 P_ALL_MSITE_FLAG in VARCHAR2,
58 P_ALL_USER_TYPE_FLAG in VARCHAR2,
59 P_MSITE_ID in NUMBER,
60 P_ORG_ID IN NUMBER,
61 P_MESSAGE_NAME in VARCHAR2,
62 P_LAST_UPDATE_DATE in DATE,
63 P_LAST_UPDATED_BY in NUMBER,
64 P_LAST_UPDATE_LOGIN in NUMBER
65 );
66
67 procedure DELETE_ROW (
68 P_NOTIF_MSG_MAP_ID in NUMBER,
69 P_NOTIF_SETUP_ID in NUMBER
70 );
71
72 procedure LOAD_SEED_ROW (
73 P_NOTIF_MSG_MAP_ID in NUMBER,
74 P_NOTIF_SETUP_ID in NUMBER,
75 p_owner IN VARCHAR2,
76 P_NOTIFICATION_NAME in VARCHAR2,
77 P_USER_TYPE in VARCHAR2,
78 P_ENABLED_FLAG in VARCHAR2,
79 P_DEFAULT_MSG_MAP_FLAG in VARCHAR2,
80 P_OBJECT_VERSION_NUMBER in NUMBER,
81 P_ALL_ORG_FLAG in VARCHAR2,
82 P_ALL_MSITE_FLAG in VARCHAR2,
83 P_ALL_USER_TYPE_FLAG in VARCHAR2,
84 P_MSITE_ID in NUMBER,
85 P_ORG_ID IN NUMBER,
86 P_MESSAGE_NAME in VARCHAR2,
87 P_LAST_UPDATE_DATE in VARCHAR2,
88 P_CUSTOM_MODE in VARCHAR2,
89 P_UPLOAD_MODE in VARCHAR2
90 );
91
92
93 procedure LOAD_ROW (
94 P_NOTIF_MSG_MAP_ID in NUMBER,
95 P_NOTIF_SETUP_ID in NUMBER,
96 p_owner IN VARCHAR2,
97 P_NOTIFICATION_NAME in VARCHAR2,
98 P_USER_TYPE in VARCHAR2,
99 P_ENABLED_FLAG in VARCHAR2,
100 P_DEFAULT_MSG_MAP_FLAG in VARCHAR2,
101 P_OBJECT_VERSION_NUMBER in NUMBER,
102 P_ALL_ORG_FLAG in VARCHAR2,
103 P_ALL_MSITE_FLAG in VARCHAR2,
104 P_ALL_USER_TYPE_FLAG in VARCHAR2,
105 P_MSITE_ID in NUMBER,
106 P_ORG_ID IN NUMBER,
107 P_MESSAGE_NAME in VARCHAR2,
108 P_LAST_UPDATE_DATE in VARCHAR2,
109 P_CUSTOM_MODE in VARCHAR2
110 );
111
112 procedure save_wf_notif_msg_maps(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115 p_commit IN VARCHAR2 := FND_API.G_FALSE,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 P_NOTIF_MSG_MAP_ID in NUMBER,
120 P_NOTIF_SETUP_ID in NUMBER,
121 P_NOTIFICATION_NAME in VARCHAR2,
122 P_USER_TYPE in VARCHAR2,
123 P_ENABLED_FLAG in VARCHAR2,
124 P_DEFAULT_MSG_MAP_FLAG in VARCHAR2,
125 P_ALL_ORG_FLAG in VARCHAR2,
126 P_ALL_MSITE_FLAG in VARCHAR2,
127 P_ALL_USER_TYPE_FLAG in VARCHAR2,
128 P_MSITE_ID in NUMBER,
129 P_ORG_ID IN NUMBER,
130 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
131 P_MESSAGE_NAME in VARCHAR2);
132
133 procedure delete_wf_notif_msg_maps(
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
136 p_commit IN VARCHAR2 := FND_API.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 P_NOTIFICATION_NAME in VARCHAR2,
141 P_NOTIF_MSG_MAP_ID IN NUMBER,
142 P_MESSAGE_NAME in VARCHAR2
143 );
144
145 FUNCTION check_msg_map_exists(
146 p_notif_msg_map_id IN NUMBER,
147 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM) RETURN BOOLEAN;
148
149 FUNCTION check_msg_map_duplicate(
150 p_action IN VARCHAR2,
151 p_msg_map_id IN NUMBER,
152 p_notification_name IN VARCHAR2,
153 p_message_name IN VARCHAR2,
154 p_msite_id IN NUMBER,
155 p_org_id IN NUMBER,
156 p_user_type IN VARCHAR2,
157 p_all_org_flag IN VARCHAR2,
158 p_all_msite_flag IN VARCHAR2,
159 p_all_user_type_flag IN VARCHAR2) RETURN BOOLEAN;
160
161 end IBE_WF_NOTIF_MSG_MAPS_PVT;