eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_WF_NOTIF_SETUP_PVT dependencies on IBE_WF_NOTIF_SETUP

Line 1: package body IBE_WF_NOTIF_SETUP_PVT as

1: package body IBE_WF_NOTIF_SETUP_PVT as
2: /* $Header: IBEVWFNB.pls 120.2 2005/07/25 12:35:02 appldev ship $ */
3:
4:
5: g_debug boolean := TRUE;

Line 37: from IBE_WF_NOTIF_SETUP

33: P_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is
36: select ROWID
37: from IBE_WF_NOTIF_SETUP
38: where NOTIF_SETUP_ID = p_NOTIF_SETUP_ID;
39: begin
40: insert into IBE_WF_NOTIF_SETUP (
41: NOTIF_SETUP_ID,

Line 40: insert into IBE_WF_NOTIF_SETUP (

36: select ROWID
37: from IBE_WF_NOTIF_SETUP
38: where NOTIF_SETUP_ID = p_NOTIF_SETUP_ID;
39: begin
40: insert into IBE_WF_NOTIF_SETUP (
41: NOTIF_SETUP_ID,
42: NOTIFICATION_NAME,
43: ORG_ID_FLAG,
44: MSITE_ID_FLAG,

Line 75: from IBE_WF_NOTIF_SETUP T

71: P_OBJECT_VERSION_NUMBER
72: FROM DUAL
73: WHERE not exists
74: (select NULL
75: from IBE_WF_NOTIF_SETUP T
76: where T.NOTIF_SETUP_ID = P_NOTIF_SETUP_ID);
77:
78: open c;
79: fetch c into X_ROWID;

Line 109: from IBE_WF_NOTIF_SETUP

105: UPDATE_ENABLED_FLAG,
106: OBJECT_VERSION_NUMBER,
107: NOTIFICATION_NAME,
108: CUSTOMIZED_FLAG
109: from IBE_WF_NOTIF_SETUP
110: where NOTIF_SETUP_ID = p_NOTIF_SETUP_ID
111: for update of NOTIF_SETUP_ID nowait;
112: begin
113: for tlinfo in c1 loop

Line 153: update IBE_WF_NOTIF_SETUP set

149: begin
150: --debug('update_row 1');
151: --debug('p_notif_setup_id is ' || p_notif_setup_id);
152: --debug('p_notification_name is ' || p_notification_name);
153: update IBE_WF_NOTIF_SETUP set
154: ORG_ID_FLAG = P_ORG_ID_FLAG,
155: MSITE_ID_FLAG = P_MSITE_ID_FLAG,
156: USER_TYPE_FLAG = p_USER_TYPE_FLAG,
157: ENABLED_FLAG = P_ENABLED_FLAG,

Line 183: delete from IBE_WF_NOTIF_SETUP

179: procedure DELETE_ROW (
180: P_NOTIF_SETUP_ID in NUMBER
181: ) is
182: begin
183: delete from IBE_WF_NOTIF_SETUP
184: where NOTIF_SETUP_ID = p_NOTIF_SETUP_ID;
185:
186: if (sql%notfound) then
187: raise no_data_found;

Line 228: from IBE_WF_NOTIF_SETUP

224: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
225:
226: select LAST_UPDATED_BY, LAST_UPDATE_DATE
227: into db_luby, db_ludate
228: from IBE_WF_NOTIF_SETUP
229: where notif_setup_id = P_NOTIF_SETUP_ID;
230:
231: --Invoke standard merge comparison routine UPLOAD_TEST to determine whether to upload or not
232: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, P_CUSTOM_MODE)) then

Line 238: from ibe_wf_notif_setup

234: if( p_customized_flag = 'Y' ) then
235: BEGIN
236: select enabled_flag
237: into l_enabled_flag
238: from ibe_wf_notif_setup
239: where notif_setup_id = p_notif_setup_id;
240: EXCEPTION
241: when no_data_found then
242: raise no_data_found;

Line 310: from ibe_wf_notif_setup

306: into l_exists
307: from dual
308: where exists(
309: select distinct notification_name
310: from ibe_wf_notif_setup
311: where notification_name = p_notification_name);
312:
313: if( l_exists = '1' ) then
314: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_DUP_NOTIF_SETUP');

Line 339: from ibe_wf_notif_setup

335: into l_exists
336: From Dual
337: where exists(
338: select notif_setup_id, object_version_number, notification_name
339: from ibe_wf_notif_setup
340: where notif_setup_id = p_notif_setup_id);
341:
342: if( l_exists = '1' ) then
343: return TRUE;

Line 356: from ibe_wf_notif_setup

352: into l_exists
353: From Dual
354: where exists(
355: select notif_setup_id, object_version_number, notification_name
356: from ibe_wf_notif_setup
357: where notif_setup_id = p_notif_setup_id
358: And object_version_number = p_object_version_number);
359:
360: if( l_exists = '1' ) then

Line 408: select ibe_wf_notif_setup_s1.nextval

404: l_notification_name VARCHAR2(30);
405: l_exists VARCHAr2(1);
406: l_object_version_number NUMBER;
407: cursor wf_setup_seq IS
408: select ibe_wf_notif_setup_s1.nextval
409: From dual;
410: l_rowid ROWID;
411: BEGIN
412: --debug('Save_wf_notif_setup 1');

Line 435: from ibe_wf_notif_setup

431: l_operation_type :='UPDATE';
432: if( p_object_version_number = FND_API.G_MISS_NUM ) then
433: select object_version_number
434: into l_object_version_number
435: from ibe_wf_notif_setup
436: where notif_setup_id = p_notif_setup_id;
437: else
438: l_object_version_number := p_object_version_number;
439: end if;

Line 504: from ibe_wf_notif_setup;

500: elsif( p_customized_flag = 'N' ) then
501: BEGIN
502: select nvl(max(notif_setup_id) , 0)
503: into l_notif_setup_id
504: from ibe_wf_notif_setup;
505: EXCEPTION
506: when no_data_found THEN
507: l_notif_setup_id := 0;
508: END;

Line 606: From IBE_WF_NOTIF_SETUP

602: p_notification_name IN VARCHAR2
603: ) IS
604: cursor wf_notif_setup(p_notification_name in VARCHAR2) is
605: select notif_setup_id
606: From IBE_WF_NOTIF_SETUP
607: where notification_name = p_notification_name;
608:
609: cursor wf_notif_msg_maps(p_notif_setup_id IN NUMBER) IS
610: select notif_msg_map_id, notification_name, message_name

Line 734: update ibe_wf_notif_setup

730: x_msg_data.extend(1);
731: x_msg_data(1) := FND_MESSAGE.GET_STRING('IBE', 'IBE_WF_NOTIF_UPDATE_ERROR');
732: x_msg_count := 1;
733: else
734: update ibe_wf_notif_setup
735: set enabled_flag = 'Y'
736: where enabled_flag <> 'Y';
737:
738: x_return_status.extend(p_notif_name_tbl.COUNT);

Line 750: from ibe_Wf_notif_setup

746: select msite_id_flag, org_id_flag, user_type_flag, default_message_name, update_enabled_flag,
747: customized_flag, notif_setup_id, object_version_number
748: into l_msite_flag, l_org_flag, l_user_type_flag, l_default_message_name, l_update_enabled_flag,
749: l_customized_Flag, l_notif_setup_id, l_object_version_number
750: from ibe_Wf_notif_setup
751: where notification_name = p_notif_name_tbl(i);
752: EXCEPTION
753: when no_data_found THEN
754: x_return_status(i) := FND_API.G_RET_STS_ERROR;

Line 763: IBE_WF_NOTIF_SETUP_PVT.save_wf_notif_setup(

759: end;
760: --debug('l_notif_setup_id is ' || l_notif_setup_id);
761: --debug('l_object_version_number is ' || l_object_version_number);
762: if( x_return_status(i) = FND_API.G_RET_STS_SUCCESS ) then
763: IBE_WF_NOTIF_SETUP_PVT.save_wf_notif_setup(
764: p_api_version => 1.0,
765: p_init_msg_list => FND_API.G_TRUE,
766: p_commit => FND_API.G_TRUE,
767: x_return_Status => l_return_status,

Line 800: from ibe_wf_notif_setup

796: l_enabled_flag VARCHAR2(1);
797: BEGIN
798: select enabled_flag
799: into l_enabled_flag
800: from ibe_wf_notif_setup
801: where notification_name = p_notification_name;
802: return l_enabled_flag;
803: EXCEPTION
804: when NO_DATA_FOUND Then

Line 828: IBE_WF_NOTIF_SETUP_PVT.LOAD_ROW(

824: Begin
825: if ( p_upload_mode = 'NLS') then
826: null;
827: else
828: IBE_WF_NOTIF_SETUP_PVT.LOAD_ROW(
829: P_NOTIF_SETUP_ID,
830: P_OWNER,
831: P_ORG_ID_FLAG,
832: P_MSITE_ID_FLAG,

Line 845: end IBE_WF_NOTIF_SETUP_PVT;

841: P_CUSTOM_MODE);
842: end if;
843: end LOAD_SEED_ROW;
844:
845: end IBE_WF_NOTIF_SETUP_PVT;