[Home] [Help]
1: package body IBE_WF_NOTIF_MSG_MAPS_PVT as
2: /* $Header: IBEVWNMB.pls 120.2 2005/06/15 03:46:56 appldev $ */
3:
4: --g_debug boolean := TRUE;
5: g_debug boolean := FALSE;
36: P_LAST_UPDATE_DATE in DATE,
37: P_LAST_UPDATED_BY in NUMBER,
38: P_LAST_UPDATE_LOGIN in NUMBER
39: ) is
40: cursor C is select ROWID from IBE_WF_NOTIF_MSG_MAPS
41: where NOTIF_MSG_MAP_ID = P_NOTIF_MSG_MAP_ID
42: and NOTIF_SETUP_ID = P_NOTIF_SETUP_ID
43: ;
44: begin
41: where NOTIF_MSG_MAP_ID = P_NOTIF_MSG_MAP_ID
42: and NOTIF_SETUP_ID = P_NOTIF_SETUP_ID
43: ;
44: begin
45: insert into IBE_WF_NOTIF_MSG_MAPS (
46: NOTIFICATION_NAME,
47: USER_TYPE,
48: MESSAGE_NAME,
49: ENABLED_FLAG,
82: P_CREATED_BY
83: from DUAL
84: where not exists
85: (select NULL
86: from IBE_WF_NOTIF_MSG_MAPS T
87: where T.NOTIF_MSG_MAP_ID = P_NOTIF_MSG_MAP_ID
88: and T.NOTIF_SETUP_ID = P_NOTIF_SETUP_ID);
89:
90: open c;
123: ALL_USER_TYPE_FLAG,
124: MSITE_ID,
125: ORG_ID,
126: MESSAGE_NAME
127: from IBE_WF_NOTIF_MSG_MAPS
128: where NOTIF_MSG_MAP_ID = P_NOTIF_MSG_MAP_ID
129: and NOTIF_SETUP_ID = P_NOTIF_SETUP_ID
130: for update of NOTIF_MSG_MAP_ID nowait;
131: begin
180: debug('update_row 1');
181: debug('update_row 2 ' || p_notification_name);
182: debug('update_row 3 ' || p_notif_setup_id);
183: debug('update_row 4 ' || p_notif_msg_map_id);
184: update IBE_WF_NOTIF_MSG_MAPS set
185: NOTIF_SETUP_ID = P_NOTIF_SETUP_ID,
186: NOTIFICATION_NAME = P_NOTIFICATION_NAME,
187: USER_TYPE = P_USER_TYPE,
188: ENABLED_FLAG = P_ENABLED_FLAG,
225: P_NOTIF_MSG_MAP_ID in NUMBER,
226: P_NOTIF_SETUP_ID in NUMBER
227: ) is
228: begin
229: delete from IBE_WF_NOTIF_MSG_MAPS
230: where NOTIF_MSG_MAP_ID = P_NOTIF_MSG_MAP_ID
231: and NOTIF_SETUP_ID = P_NOTIF_SETUP_ID;
232:
233: if (sql%notfound) then
267: if (P_UPLOAD_MODE = 'NLS')
268: then --{
269: null;
270: else
271: ibe_wf_notif_msg_maps_pvt.load_row(
272: p_notif_msg_map_id => P_NOTIF_MSG_MAP_ID,
273: p_notif_setup_id => P_NOTIF_SETUP_ID,
274: p_owner => P_OWNER,
275: p_notification_name => P_NOTIFICATION_NAME,
330:
331: BEGIN
332: select last_updated_by, last_update_date, message_name, enabled_flag
333: into l_last_updated_by, l_last_update_date,l_message_name, l_enabled_flag
334: from ibe_wf_notif_msg_maps
335: where notif_msg_map_id = p_notif_msg_map_id;
336: EXCEPTION
337: when no_data_found THEN
338: raise no_data_found;
415: into l_exists
416: from dual
417: where exists (
418: select notif_msg_map_id, object_version_number
419: From ibe_wf_notif_msg_maps
420: where notif_msg_map_id = p_notif_msg_map_id
421: );
422: if( l_exists <> '1' ) then
423: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_MAP_NOT_FOUND');
432: into l_exists
433: from dual
434: where exists (
435: select notif_msg_map_id, object_version_number
436: From ibe_wf_notif_msg_maps
437: where notif_msg_map_id = p_notif_msg_map_id
438: and object_version_number = p_object_version_number
439: );
440: if( l_exists <> '1' ) then
480: debug('p_all_user_type_flag is ' || p_all_user_type_flag);
481:
482: select min(notif_msg_map_id)
483: into l_notif_msg_map_id
484: from ibe_wf_notif_msg_maps
485: where notification_name = p_notification_name
486: and nvl(msite_id, -99999) = nvl(p_msite_id, -99999)
487: and nvl(org_id, -99999) = nvl(p_org_id, -99999)
488: and nvl(user_type, '@#$%') = nvl(p_user_type, '@#$%')
570: l_operation_type := 'UPDATE';
571: if( p_object_version_number = FND_API.G_MISS_NUM ) then
572: select object_version_number
573: into l_object_version_number
574: from ibe_wf_notif_msg_maps
575: where notif_msg_map_id = p_notif_msg_map_id
576: and notif_setup_id = p_notif_setup_id;
577: else
578: l_object_version_number := p_object_version_number;
608: end if;
609:
610: if( l_operation_type = 'INSERT' ) then
611: debug('save_notif_msg_maps 7');
612: select ibe_wf_notif_msg_maps_s1.nextval
613: into l_notif_msg_map_id
614: from dual;
615:
616: debug('save_notif_msg_maps 8');
800: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
801: end if;
802: ENd delete_wf_notif_msg_maps;
803:
804: end IBE_WF_NOTIF_MSG_MAPS_PVT;