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,
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,
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,
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,
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,
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,