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.WF_NOTIFICATION dependencies on WF_EVENT

Line 1226: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);

1222: end if;
1223:
1224: -- Bug 2437347 raising event after DML operation on WF_NOTIFICATION_ATTRIBUTES
1225: if (aname = 'SENDER') then
1226: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
1227: wf_event.AddParameterToList(aname, avalue, l_parameterlist);
1228:
1229:
1230:

Line 1227: wf_event.AddParameterToList(aname, avalue, l_parameterlist);

1223:
1224: -- Bug 2437347 raising event after DML operation on WF_NOTIFICATION_ATTRIBUTES
1225: if (aname = 'SENDER') then
1226: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
1227: wf_event.AddParameterToList(aname, avalue, l_parameterlist);
1228:
1229:
1230:
1231:

Line 1243: wf_event.AddParameterToList('OBJECT_NAME',

1239:
1240: select code into l_language from wf_languages where nls_language = l_language;
1241:
1242: -- AppSearch
1243: wf_event.AddParameterToList('OBJECT_NAME',
1244: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
1245: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
1246: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
1247: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

Line 1245: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);

1241:
1242: -- AppSearch
1243: wf_event.AddParameterToList('OBJECT_NAME',
1244: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
1245: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
1246: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
1247: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
1248: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
1249: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

Line 1246: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);

1242: -- AppSearch
1243: wf_event.AddParameterToList('OBJECT_NAME',
1244: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
1245: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
1246: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
1247: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
1248: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
1249: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
1250: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

Line 1247: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

1243: wf_event.AddParameterToList('OBJECT_NAME',
1244: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
1245: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
1246: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
1247: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
1248: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
1249: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
1250: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
1251: -- Raise the event

Line 1248: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);

1244: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
1245: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
1246: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
1247: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
1248: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
1249: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
1250: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
1251: -- Raise the event
1252: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.setattrtext',

Line 1249: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

1245: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
1246: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
1247: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
1248: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
1249: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
1250: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
1251: -- Raise the event
1252: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.setattrtext',
1253: p_event_key => to_char(nid),

Line 1250: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

1246: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
1247: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
1248: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
1249: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
1250: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
1251: -- Raise the event
1252: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.setattrtext',
1253: p_event_key => to_char(nid),
1254: p_parameters => l_parameterlist);

Line 1252: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.setattrtext',

1248: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
1249: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
1250: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
1251: -- Raise the event
1252: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.setattrtext',
1253: p_event_key => to_char(nid),
1254: p_parameters => l_parameterlist);
1255: end if;
1256:

Line 3587: attr_evalue wf_event_t;

3583: attr_tvalue varchar2(4000);
3584: attr_nvalue number;
3585: attr_dvalue date;
3586: -- Bug 2376033
3587: attr_evalue wf_event_t;
3588: -- Bug 2283697
3589: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
3590: -- the following variables for Dynamic SQL
3591: sqlbuf varchar2(2000);

Line 3699: wf_event_t.initialize(attr_evalue);

3695: end if;
3696:
3697: -- Bug 2376033 initialize event to fetch value using cb
3698: if (attr_type = 'EVENT') then
3699: wf_event_t.initialize(attr_evalue);
3700: end if;
3701:
3702: -- If there is a cb defined and the default vtype is ITEMATTR
3703: -- then call the cb to fetch possible item attribute value.

Line 3856: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);

3852:
3853: --Bug 2283697
3854: --To raise an EVENT whenever DML operation is performed on
3855: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
3856: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
3857: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
3858: wf_event.AddParameterToList('GROUP_ID',nvl(group_id,nid),l_parameterlist);
3859:
3860: wf_event.addParameterToList('Q_CORRELATION_ID', sendsingle.msg_type||':'||

Line 3857: wf_event.AddParameterToList('ROLE',role,l_parameterlist);

3853: --Bug 2283697
3854: --To raise an EVENT whenever DML operation is performed on
3855: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
3856: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
3857: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
3858: wf_event.AddParameterToList('GROUP_ID',nvl(group_id,nid),l_parameterlist);
3859:
3860: wf_event.addParameterToList('Q_CORRELATION_ID', sendsingle.msg_type||':'||
3861: sendsingle.msg_name, l_parameterlist);

Line 3858: wf_event.AddParameterToList('GROUP_ID',nvl(group_id,nid),l_parameterlist);

3854: --To raise an EVENT whenever DML operation is performed on
3855: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
3856: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
3857: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
3858: wf_event.AddParameterToList('GROUP_ID',nvl(group_id,nid),l_parameterlist);
3859:
3860: wf_event.addParameterToList('Q_CORRELATION_ID', sendsingle.msg_type||':'||
3861: sendsingle.msg_name, l_parameterlist);
3862:

Line 3860: wf_event.addParameterToList('Q_CORRELATION_ID', sendsingle.msg_type||':'||

3856: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
3857: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
3858: wf_event.AddParameterToList('GROUP_ID',nvl(group_id,nid),l_parameterlist);
3859:
3860: wf_event.addParameterToList('Q_CORRELATION_ID', sendsingle.msg_type||':'||
3861: sendsingle.msg_name, l_parameterlist);
3862:
3863: Wf_Directory.GetRoleInfo2(sendsingle.role, role_info_tbl);
3864: l_language := role_info_tbl(1).language;

Line 3869: wf_event.AddParameterToList('OBJECT_NAME',

3865:
3866: select code into l_language from wf_languages where nls_language = l_language;
3867:
3868: -- AppSearch
3869: wf_event.AddParameterToList('OBJECT_NAME',
3870: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
3871: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
3872: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
3873: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

Line 3871: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);

3867:
3868: -- AppSearch
3869: wf_event.AddParameterToList('OBJECT_NAME',
3870: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
3871: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
3872: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
3873: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
3874: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
3875: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

Line 3872: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);

3868: -- AppSearch
3869: wf_event.AddParameterToList('OBJECT_NAME',
3870: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
3871: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
3872: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
3873: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
3874: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
3875: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
3876: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

Line 3873: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

3869: wf_event.AddParameterToList('OBJECT_NAME',
3870: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
3871: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
3872: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
3873: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
3874: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
3875: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
3876: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
3877:

Line 3874: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);

3870: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
3871: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
3872: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
3873: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
3874: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
3875: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
3876: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
3877:
3878:

Line 3875: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

3871: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
3872: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
3873: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
3874: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
3875: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
3876: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
3877:
3878:
3879:

Line 3876: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

3872: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
3873: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
3874: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
3875: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
3876: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
3877:
3878:
3879:
3880: --Raise the event

Line 3881: if wf_event.phase_maxthreshold is null then

3877:
3878:
3879:
3880: --Raise the event
3881: if wf_event.phase_maxthreshold is null then
3882: -- means deferred mode , avoid synchronous processing of Send event
3883: wf_event.SetDispatchMode('ASYNC');
3884:
3885: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

Line 3883: wf_event.SetDispatchMode('ASYNC');

3879:
3880: --Raise the event
3881: if wf_event.phase_maxthreshold is null then
3882: -- means deferred mode , avoid synchronous processing of Send event
3883: wf_event.SetDispatchMode('ASYNC');
3884:
3885: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
3886: p_event_key => to_char(nid),
3887: p_parameters => l_parameterlist);

Line 3885: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

3881: if wf_event.phase_maxthreshold is null then
3882: -- means deferred mode , avoid synchronous processing of Send event
3883: wf_event.SetDispatchMode('ASYNC');
3884:
3885: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
3886: p_event_key => to_char(nid),
3887: p_parameters => l_parameterlist);
3888:
3889: wf_event.phase_maxthreshold := null;

Line 3889: wf_event.phase_maxthreshold := null;

3885: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
3886: p_event_key => to_char(nid),
3887: p_parameters => l_parameterlist);
3888:
3889: wf_event.phase_maxthreshold := null;
3890: else
3891: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
3892: p_event_key => to_char(nid),
3893: p_parameters => l_parameterlist);

Line 3891: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

3887: p_parameters => l_parameterlist);
3888:
3889: wf_event.phase_maxthreshold := null;
3890: else
3891: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
3892: p_event_key => to_char(nid),
3893: p_parameters => l_parameterlist);
3894:
3895: end if;

Line 4385: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);

4381:
4382: --Bug 2283697
4383: --To raise an EVENT whenever DML operation is performed on
4384: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4385: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4386: wf_event.AddParameterToList('NEW_ROLE',new_role,l_parameterlist);
4387: wf_event.AddParameterToList('MODE',fmode,l_parameterlist);
4388: if (user is not null) then
4389: wf_event.AddParameterToList('USER',user,l_parameterlist);

Line 4386: wf_event.AddParameterToList('NEW_ROLE',new_role,l_parameterlist);

4382: --Bug 2283697
4383: --To raise an EVENT whenever DML operation is performed on
4384: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4385: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4386: wf_event.AddParameterToList('NEW_ROLE',new_role,l_parameterlist);
4387: wf_event.AddParameterToList('MODE',fmode,l_parameterlist);
4388: if (user is not null) then
4389: wf_event.AddParameterToList('USER',user,l_parameterlist);
4390: elsif (fmode = 'FORWARD') then

Line 4387: wf_event.AddParameterToList('MODE',fmode,l_parameterlist);

4383: --To raise an EVENT whenever DML operation is performed on
4384: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4385: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4386: wf_event.AddParameterToList('NEW_ROLE',new_role,l_parameterlist);
4387: wf_event.AddParameterToList('MODE',fmode,l_parameterlist);
4388: if (user is not null) then
4389: wf_event.AddParameterToList('USER',user,l_parameterlist);
4390: elsif (fmode = 'FORWARD') then
4391: wf_event.AddParameterToList('USER',old_role,l_parameterlist);

Line 4389: wf_event.AddParameterToList('USER',user,l_parameterlist);

4385: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4386: wf_event.AddParameterToList('NEW_ROLE',new_role,l_parameterlist);
4387: wf_event.AddParameterToList('MODE',fmode,l_parameterlist);
4388: if (user is not null) then
4389: wf_event.AddParameterToList('USER',user,l_parameterlist);
4390: elsif (fmode = 'FORWARD') then
4391: wf_event.AddParameterToList('USER',old_role,l_parameterlist);
4392: else
4393: wf_event.AddParameterToList('USER',old_origrole,l_parameterlist);

Line 4391: wf_event.AddParameterToList('USER',old_role,l_parameterlist);

4387: wf_event.AddParameterToList('MODE',fmode,l_parameterlist);
4388: if (user is not null) then
4389: wf_event.AddParameterToList('USER',user,l_parameterlist);
4390: elsif (fmode = 'FORWARD') then
4391: wf_event.AddParameterToList('USER',old_role,l_parameterlist);
4392: else
4393: wf_event.AddParameterToList('USER',old_origrole,l_parameterlist);
4394: end if;
4395:

Line 4393: wf_event.AddParameterToList('USER',old_origrole,l_parameterlist);

4389: wf_event.AddParameterToList('USER',user,l_parameterlist);
4390: elsif (fmode = 'FORWARD') then
4391: wf_event.AddParameterToList('USER',old_role,l_parameterlist);
4392: else
4393: wf_event.AddParameterToList('USER',old_origrole,l_parameterlist);
4394: end if;
4395:
4396: -- <7641725> we need to include Q_CORRELATION_ID parameter
4397: wf_event.addParameterToList('Q_CORRELATION_ID'

Line 4397: wf_event.addParameterToList('Q_CORRELATION_ID'

4393: wf_event.AddParameterToList('USER',old_origrole,l_parameterlist);
4394: end if;
4395:
4396: -- <7641725> we need to include Q_CORRELATION_ID parameter
4397: wf_event.addParameterToList('Q_CORRELATION_ID'
4398: , l_msgType||':'||l_msgName, l_parameterlist);
4399:
4400: select WN.RECIPIENT_ROLE
4401: into l_recipient_role

Line 4411: wf_event.AddParameterToList('OBJECT_NAME',

4407:
4408: select code into l_language from wf_languages where nls_language = l_language;
4409:
4410: -- AppSearch
4411: wf_event.AddParameterToList('OBJECT_NAME',
4412: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4413: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4414: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4415: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

Line 4413: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);

4409:
4410: -- AppSearch
4411: wf_event.AddParameterToList('OBJECT_NAME',
4412: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4413: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4414: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4415: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4416: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4417: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

Line 4414: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);

4410: -- AppSearch
4411: wf_event.AddParameterToList('OBJECT_NAME',
4412: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4413: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4414: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4415: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4416: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4417: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4418: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

Line 4415: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

4411: wf_event.AddParameterToList('OBJECT_NAME',
4412: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4413: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4414: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4415: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4416: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4417: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4418: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4419:

Line 4416: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);

4412: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4413: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4414: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4415: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4416: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4417: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4418: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4419:
4420:

Line 4417: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

4413: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4414: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4415: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4416: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4417: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4418: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4419:
4420:
4421: --Raise the event

Line 4418: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

4414: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4415: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4416: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4417: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4418: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4419:
4420:
4421: --Raise the event
4422: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.reassign',

Line 4422: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.reassign',

4418: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4419:
4420:
4421: --Raise the event
4422: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.reassign',
4423: p_event_key => to_char(nid),
4424: p_parameters => l_parameterlist);
4425:
4426: exception

Line 4618: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);

4614:
4615: --Bug 2283697
4616: --To raise an EVENT whenever DML operation is performed on
4617: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4618: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4619: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
4620: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type || ':'||
4621: l_msg_name, l_parameterlist);
4622:

Line 4619: wf_event.AddParameterToList('ROLE',role,l_parameterlist);

4615: --Bug 2283697
4616: --To raise an EVENT whenever DML operation is performed on
4617: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4618: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4619: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
4620: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type || ':'||
4621: l_msg_name, l_parameterlist);
4622:
4623:

Line 4620: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type || ':'||

4616: --To raise an EVENT whenever DML operation is performed on
4617: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4618: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4619: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
4620: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type || ':'||
4621: l_msg_name, l_parameterlist);
4622:
4623:
4624: -- AppSearch

Line 4625: wf_event.AddParameterToList('OBJECT_NAME',

4621: l_msg_name, l_parameterlist);
4622:
4623:
4624: -- AppSearch
4625: wf_event.AddParameterToList('OBJECT_NAME',
4626: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4627: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4628: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4629: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

Line 4627: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);

4623:
4624: -- AppSearch
4625: wf_event.AddParameterToList('OBJECT_NAME',
4626: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4627: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4628: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4629: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4630: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4631: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

Line 4628: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);

4624: -- AppSearch
4625: wf_event.AddParameterToList('OBJECT_NAME',
4626: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4627: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4628: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4629: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4630: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4631: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4632: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

Line 4629: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

4625: wf_event.AddParameterToList('OBJECT_NAME',
4626: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4627: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4628: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4629: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4630: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4631: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4632: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4633:

Line 4630: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);

4626: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4627: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4628: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4629: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4630: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4631: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4632: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4633:
4634: --Raise the event

Line 4631: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

4627: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4628: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4629: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4630: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4631: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4632: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4633:
4634: --Raise the event
4635: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.cancel',

Line 4632: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

4628: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4629: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4630: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4631: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4632: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4633:
4634: --Raise the event
4635: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.cancel',
4636: p_event_key => to_char(nid),

Line 4635: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.cancel',

4631: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4632: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4633:
4634: --Raise the event
4635: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.cancel',
4636: p_event_key => to_char(nid),
4637: p_parameters => l_parameterlist);
4638:
4639:

Line 4971: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);

4967:
4968: --Bug 2283697
4969: --To raise an EVENT whenever DML operation is performed on
4970: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4971: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4972: wf_event.AddParameterToList('RESPONDER',respond.responder,l_parameterlist);
4973:
4974: -- AppSearch
4975: wf_event.AddParameterToList('OBJECT_NAME',

Line 4972: wf_event.AddParameterToList('RESPONDER',respond.responder,l_parameterlist);

4968: --Bug 2283697
4969: --To raise an EVENT whenever DML operation is performed on
4970: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4971: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4972: wf_event.AddParameterToList('RESPONDER',respond.responder,l_parameterlist);
4973:
4974: -- AppSearch
4975: wf_event.AddParameterToList('OBJECT_NAME',
4976: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);

Line 4975: wf_event.AddParameterToList('OBJECT_NAME',

4971: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4972: wf_event.AddParameterToList('RESPONDER',respond.responder,l_parameterlist);
4973:
4974: -- AppSearch
4975: wf_event.AddParameterToList('OBJECT_NAME',
4976: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4977: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4978: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4979: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

Line 4977: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);

4973:
4974: -- AppSearch
4975: wf_event.AddParameterToList('OBJECT_NAME',
4976: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4977: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4978: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4979: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4980: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4981: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

Line 4978: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);

4974: -- AppSearch
4975: wf_event.AddParameterToList('OBJECT_NAME',
4976: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4977: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4978: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4979: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4980: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4981: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4982: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

Line 4979: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

4975: wf_event.AddParameterToList('OBJECT_NAME',
4976: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4977: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4978: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4979: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4980: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4981: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4982: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4983:

Line 4980: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);

4976: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4977: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4978: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4979: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4980: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4981: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4982: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4983:
4984: --Raise the event

Line 4981: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

4977: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4978: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4979: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4980: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4981: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4982: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4983:
4984: --Raise the event
4985: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.respond',

Line 4982: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

4978: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4979: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4980: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4981: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4982: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4983:
4984: --Raise the event
4985: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.respond',
4986: p_event_key => to_char(nid),

Line 4985: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.respond',

4981: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4982: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4983:
4984: --Raise the event
4985: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.respond',
4986: p_event_key => to_char(nid),
4987: p_parameters => l_parameterlist);
4988:
4989: -- If no callback, there is nothing else to do.

Line 5419: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);

5415:
5416: --Bug 2283697
5417: --To raise an EVENT whenever DML operation is performed on
5418: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
5419: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
5420: wf_event.AddParameterToList('RESPONDER',close.responder,l_parameterlist);
5421:
5422: -- AppSearch
5423: wf_event.AddParameterToList('OBJECT_NAME',

Line 5420: wf_event.AddParameterToList('RESPONDER',close.responder,l_parameterlist);

5416: --Bug 2283697
5417: --To raise an EVENT whenever DML operation is performed on
5418: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
5419: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
5420: wf_event.AddParameterToList('RESPONDER',close.responder,l_parameterlist);
5421:
5422: -- AppSearch
5423: wf_event.AddParameterToList('OBJECT_NAME',
5424: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);

Line 5423: wf_event.AddParameterToList('OBJECT_NAME',

5419: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
5420: wf_event.AddParameterToList('RESPONDER',close.responder,l_parameterlist);
5421:
5422: -- AppSearch
5423: wf_event.AddParameterToList('OBJECT_NAME',
5424: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
5425: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
5426: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
5427: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

Line 5425: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);

5421:
5422: -- AppSearch
5423: wf_event.AddParameterToList('OBJECT_NAME',
5424: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
5425: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
5426: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
5427: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
5428: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
5429: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

Line 5426: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);

5422: -- AppSearch
5423: wf_event.AddParameterToList('OBJECT_NAME',
5424: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
5425: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
5426: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
5427: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
5428: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
5429: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
5430: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

Line 5427: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

5423: wf_event.AddParameterToList('OBJECT_NAME',
5424: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
5425: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
5426: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
5427: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
5428: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
5429: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
5430: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
5431:

Line 5428: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);

5424: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
5425: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
5426: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
5427: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
5428: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
5429: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
5430: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
5431:
5432: --Raise the event

Line 5429: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

5425: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
5426: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
5427: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
5428: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
5429: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
5430: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
5431:
5432: --Raise the event
5433: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.close',

Line 5430: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

5426: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
5427: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
5428: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
5429: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
5430: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
5431:
5432: --Raise the event
5433: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.close',
5434: p_event_key => to_char(nid),

Line 5433: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.close',

5429: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
5430: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
5431:
5432: --Raise the event
5433: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.close',
5434: p_event_key => to_char(nid),
5435: p_parameters => l_parameterlist);
5436:
5437: exception

Line 6424: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);

6420:
6421: if (l_defer_denormalize) then
6422:
6423: -- To raise an EVENT when l_defer_denormalize is set true
6424: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
6425: wf_event.AddParameterToList('ROLE',l_user,l_parameterlist);
6426: wf_event.AddParameterToList('LANGUAGE',l_language,l_parameterlist);
6427: wf_event.AddParameterToList('TERRITORY',l_territory,l_parameterlist);
6428:

Line 6425: wf_event.AddParameterToList('ROLE',l_user,l_parameterlist);

6421: if (l_defer_denormalize) then
6422:
6423: -- To raise an EVENT when l_defer_denormalize is set true
6424: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
6425: wf_event.AddParameterToList('ROLE',l_user,l_parameterlist);
6426: wf_event.AddParameterToList('LANGUAGE',l_language,l_parameterlist);
6427: wf_event.AddParameterToList('TERRITORY',l_territory,l_parameterlist);
6428:
6429: -- <7514495>

Line 6426: wf_event.AddParameterToList('LANGUAGE',l_language,l_parameterlist);

6422:
6423: -- To raise an EVENT when l_defer_denormalize is set true
6424: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
6425: wf_event.AddParameterToList('ROLE',l_user,l_parameterlist);
6426: wf_event.AddParameterToList('LANGUAGE',l_language,l_parameterlist);
6427: wf_event.AddParameterToList('TERRITORY',l_territory,l_parameterlist);
6428:
6429: -- <7514495>
6430: wf_event.AddParameterToList('NLS_DATE_FORMAT', l_nls_date_format,l_parameterlist);

Line 6427: wf_event.AddParameterToList('TERRITORY',l_territory,l_parameterlist);

6423: -- To raise an EVENT when l_defer_denormalize is set true
6424: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
6425: wf_event.AddParameterToList('ROLE',l_user,l_parameterlist);
6426: wf_event.AddParameterToList('LANGUAGE',l_language,l_parameterlist);
6427: wf_event.AddParameterToList('TERRITORY',l_territory,l_parameterlist);
6428:
6429: -- <7514495>
6430: wf_event.AddParameterToList('NLS_DATE_FORMAT', l_nls_date_format,l_parameterlist);
6431: wf_event.AddParameterToList('NLS_DATE_LANGUAGE', l_nls_date_language,l_parameterlist);

Line 6430: wf_event.AddParameterToList('NLS_DATE_FORMAT', l_nls_date_format,l_parameterlist);

6426: wf_event.AddParameterToList('LANGUAGE',l_language,l_parameterlist);
6427: wf_event.AddParameterToList('TERRITORY',l_territory,l_parameterlist);
6428:
6429: -- <7514495>
6430: wf_event.AddParameterToList('NLS_DATE_FORMAT', l_nls_date_format,l_parameterlist);
6431: wf_event.AddParameterToList('NLS_DATE_LANGUAGE', l_nls_date_language,l_parameterlist);
6432: wf_event.AddParameterToList('NLS_CALENDAR', l_nls_calendar,l_parameterlist);
6433: wf_event.AddParameterToList('NLS_NUMERIC_CHARACTERS', l_nls_numeric_characters,l_parameterlist);
6434: wf_event.AddParameterToList('NLS_SORT', l_nls_sort,l_parameterlist);

Line 6431: wf_event.AddParameterToList('NLS_DATE_LANGUAGE', l_nls_date_language,l_parameterlist);

6427: wf_event.AddParameterToList('TERRITORY',l_territory,l_parameterlist);
6428:
6429: -- <7514495>
6430: wf_event.AddParameterToList('NLS_DATE_FORMAT', l_nls_date_format,l_parameterlist);
6431: wf_event.AddParameterToList('NLS_DATE_LANGUAGE', l_nls_date_language,l_parameterlist);
6432: wf_event.AddParameterToList('NLS_CALENDAR', l_nls_calendar,l_parameterlist);
6433: wf_event.AddParameterToList('NLS_NUMERIC_CHARACTERS', l_nls_numeric_characters,l_parameterlist);
6434: wf_event.AddParameterToList('NLS_SORT', l_nls_sort,l_parameterlist);
6435: wf_event.AddParameterToList('NLS_CURRENCY', l_nls_currency,l_parameterlist);

Line 6432: wf_event.AddParameterToList('NLS_CALENDAR', l_nls_calendar,l_parameterlist);

6428:
6429: -- <7514495>
6430: wf_event.AddParameterToList('NLS_DATE_FORMAT', l_nls_date_format,l_parameterlist);
6431: wf_event.AddParameterToList('NLS_DATE_LANGUAGE', l_nls_date_language,l_parameterlist);
6432: wf_event.AddParameterToList('NLS_CALENDAR', l_nls_calendar,l_parameterlist);
6433: wf_event.AddParameterToList('NLS_NUMERIC_CHARACTERS', l_nls_numeric_characters,l_parameterlist);
6434: wf_event.AddParameterToList('NLS_SORT', l_nls_sort,l_parameterlist);
6435: wf_event.AddParameterToList('NLS_CURRENCY', l_nls_currency,l_parameterlist);
6436: --

Line 6433: wf_event.AddParameterToList('NLS_NUMERIC_CHARACTERS', l_nls_numeric_characters,l_parameterlist);

6429: -- <7514495>
6430: wf_event.AddParameterToList('NLS_DATE_FORMAT', l_nls_date_format,l_parameterlist);
6431: wf_event.AddParameterToList('NLS_DATE_LANGUAGE', l_nls_date_language,l_parameterlist);
6432: wf_event.AddParameterToList('NLS_CALENDAR', l_nls_calendar,l_parameterlist);
6433: wf_event.AddParameterToList('NLS_NUMERIC_CHARACTERS', l_nls_numeric_characters,l_parameterlist);
6434: wf_event.AddParameterToList('NLS_SORT', l_nls_sort,l_parameterlist);
6435: wf_event.AddParameterToList('NLS_CURRENCY', l_nls_currency,l_parameterlist);
6436: --
6437:

Line 6434: wf_event.AddParameterToList('NLS_SORT', l_nls_sort,l_parameterlist);

6430: wf_event.AddParameterToList('NLS_DATE_FORMAT', l_nls_date_format,l_parameterlist);
6431: wf_event.AddParameterToList('NLS_DATE_LANGUAGE', l_nls_date_language,l_parameterlist);
6432: wf_event.AddParameterToList('NLS_CALENDAR', l_nls_calendar,l_parameterlist);
6433: wf_event.AddParameterToList('NLS_NUMERIC_CHARACTERS', l_nls_numeric_characters,l_parameterlist);
6434: wf_event.AddParameterToList('NLS_SORT', l_nls_sort,l_parameterlist);
6435: wf_event.AddParameterToList('NLS_CURRENCY', l_nls_currency,l_parameterlist);
6436: --
6437:
6438: if ( l_logSTMT ) then

Line 6435: wf_event.AddParameterToList('NLS_CURRENCY', l_nls_currency,l_parameterlist);

6431: wf_event.AddParameterToList('NLS_DATE_LANGUAGE', l_nls_date_language,l_parameterlist);
6432: wf_event.AddParameterToList('NLS_CALENDAR', l_nls_calendar,l_parameterlist);
6433: wf_event.AddParameterToList('NLS_NUMERIC_CHARACTERS', l_nls_numeric_characters,l_parameterlist);
6434: wf_event.AddParameterToList('NLS_SORT', l_nls_sort,l_parameterlist);
6435: wf_event.AddParameterToList('NLS_CURRENCY', l_nls_currency,l_parameterlist);
6436: --
6437:
6438: if ( l_logSTMT ) then
6439: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'defer parameters: '||

Line 6453: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.denormalize',

6449: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module, 'END - deferring denormalization');
6450: end if;
6451:
6452: -- Raise the event
6453: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.denormalize',
6454: p_event_key => to_char(nid),
6455: p_parameters => l_parameterlist);
6456:
6457: return;

Line 7068: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);

7064:
7065: -- Bug 2283697
7066: -- To raise an EVENT whenever DML operation is performed on
7067: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7068: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7069: wf_event.AddParameterToList('ROLE', username, l_parameterlist);
7070: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7071: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7072: l_messageName, l_parameterlist);

Line 7069: wf_event.AddParameterToList('ROLE', username, l_parameterlist);

7065: -- Bug 2283697
7066: -- To raise an EVENT whenever DML operation is performed on
7067: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7068: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7069: wf_event.AddParameterToList('ROLE', username, l_parameterlist);
7070: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7071: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7072: l_messageName, l_parameterlist);
7073:

Line 7070: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);

7066: -- To raise an EVENT whenever DML operation is performed on
7067: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7068: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7069: wf_event.AddParameterToList('ROLE', username, l_parameterlist);
7070: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7071: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7072: l_messageName, l_parameterlist);
7073:
7074:

Line 7071: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||

7067: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7068: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7069: wf_event.AddParameterToList('ROLE', username, l_parameterlist);
7070: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7071: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7072: l_messageName, l_parameterlist);
7073:
7074:
7075: Wf_Directory.GetRoleInfo2(l_recip_role, role_info_tbl);

Line 7081: wf_event.AddParameterToList('OBJECT_NAME',

7077:
7078: select code into l_language from wf_languages where nls_language = l_language;
7079:
7080: -- AppSearch
7081: wf_event.AddParameterToList('OBJECT_NAME',
7082: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7083: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7084: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7085: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

Line 7083: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);

7079:
7080: -- AppSearch
7081: wf_event.AddParameterToList('OBJECT_NAME',
7082: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7083: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7084: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7085: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7086: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7087: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

Line 7084: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);

7080: -- AppSearch
7081: wf_event.AddParameterToList('OBJECT_NAME',
7082: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7083: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7084: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7085: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7086: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7087: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7088: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

Line 7085: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

7081: wf_event.AddParameterToList('OBJECT_NAME',
7082: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7083: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7084: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7085: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7086: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7087: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7088: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7089:

Line 7086: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);

7082: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7083: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7084: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7085: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7086: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7087: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7088: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7089:
7090:

Line 7087: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

7083: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7084: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7085: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7086: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7087: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7088: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7089:
7090:
7091: -- Raise the event

Line 7088: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

7084: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7085: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7086: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7087: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7088: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7089:
7090:
7091: -- Raise the event
7092: -- wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

Line 7092: -- wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

7088: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7089:
7090:
7091: -- Raise the event
7092: -- wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
7093: -- p_event_key => to_char(nid),
7094: -- p_parameters => l_parameterlist);
7095:
7096: -- <>

Line 7097: wf_event.Raise(p_event_name => l_event_name,

7093: -- p_event_key => to_char(nid),
7094: -- p_parameters => l_parameterlist);
7095:
7096: -- <>
7097: wf_event.Raise(p_event_name => l_event_name,
7098: p_event_key => to_char(nid),
7099: p_parameters => l_parameterlist);
7100:
7101: exception

Line 7546: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);

7542:
7543: -- Bug 2283697
7544: -- To raise an EVENT whenever DML operation is performed on
7545: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7546: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7547:
7548: -- username MAY be a display name
7549: wf_event.AddParameterToList('ROLE', nvl(l_username, username), l_parameterlist);
7550: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);

Line 7549: wf_event.AddParameterToList('ROLE', nvl(l_username, username), l_parameterlist);

7545: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7546: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7547:
7548: -- username MAY be a display name
7549: wf_event.AddParameterToList('ROLE', nvl(l_username, username), l_parameterlist);
7550: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7551: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7552: l_messageName, l_parameterlist);
7553:

Line 7550: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);

7546: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7547:
7548: -- username MAY be a display name
7549: wf_event.AddParameterToList('ROLE', nvl(l_username, username), l_parameterlist);
7550: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7551: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7552: l_messageName, l_parameterlist);
7553:
7554: Wf_Directory.GetRoleInfo2(l_recip_role, role_info_tbl);

Line 7551: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||

7547:
7548: -- username MAY be a display name
7549: wf_event.AddParameterToList('ROLE', nvl(l_username, username), l_parameterlist);
7550: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7551: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7552: l_messageName, l_parameterlist);
7553:
7554: Wf_Directory.GetRoleInfo2(l_recip_role, role_info_tbl);
7555: l_language := role_info_tbl(1).language;

Line 7561: wf_event.AddParameterToList('OBJECT_NAME',

7557: select code into l_language from wf_languages where nls_language = l_language;
7558:
7559:
7560: -- AppSearch
7561: wf_event.AddParameterToList('OBJECT_NAME',
7562: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7563: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7564: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7565: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

Line 7563: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);

7559:
7560: -- AppSearch
7561: wf_event.AddParameterToList('OBJECT_NAME',
7562: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7563: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7564: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7565: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7566: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7567: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

Line 7564: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);

7560: -- AppSearch
7561: wf_event.AddParameterToList('OBJECT_NAME',
7562: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7563: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7564: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7565: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7566: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7567: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7568: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

Line 7565: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

7561: wf_event.AddParameterToList('OBJECT_NAME',
7562: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7563: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7564: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7565: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7566: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7567: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7568: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7569:

Line 7566: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);

7562: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7563: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7564: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7565: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7566: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7567: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7568: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7569:
7570:

Line 7567: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

7563: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7564: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7565: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7566: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7567: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7568: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7569:
7570:
7571: -- Raise the event

Line 7568: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

7564: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7565: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7566: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7567: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7568: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7569:
7570:
7571: -- Raise the event
7572: -- wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

Line 7572: -- wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

7568: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7569:
7570:
7571: -- Raise the event
7572: -- wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
7573: -- p_event_key => to_char(nid),
7574: -- p_parameters => l_parameterlist);
7575:
7576: -- <>

Line 7577: wf_event.Raise(p_event_name => l_event_name,

7573: -- p_event_key => to_char(nid),
7574: -- p_parameters => l_parameterlist);
7575:
7576: -- <>
7577: wf_event.Raise(p_event_name => l_event_name,
7578: p_event_key => to_char(nid),
7579: p_parameters => l_parameterlist);
7580:
7581: exception

Line 7705: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);

7701:
7702: -- Bug 2283697
7703: -- To raise an EVENT whenever DML operation is performed on
7704: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7705: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7706: -- skilaru 12-MAR-04 In UpdateInfo2 username would be null in Answer mode
7707: -- to keep the behaviour same just pass null as ROLE..
7708: wf_event.AddParameterToList('ROLE', null, l_parameterlist);
7709: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);

Line 7708: wf_event.AddParameterToList('ROLE', null, l_parameterlist);

7704: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7705: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7706: -- skilaru 12-MAR-04 In UpdateInfo2 username would be null in Answer mode
7707: -- to keep the behaviour same just pass null as ROLE..
7708: wf_event.AddParameterToList('ROLE', null, l_parameterlist);
7709: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7710: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7711: l_messageName, l_parameterlist);
7712:

Line 7709: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);

7705: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7706: -- skilaru 12-MAR-04 In UpdateInfo2 username would be null in Answer mode
7707: -- to keep the behaviour same just pass null as ROLE..
7708: wf_event.AddParameterToList('ROLE', null, l_parameterlist);
7709: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7710: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7711: l_messageName, l_parameterlist);
7712:
7713: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);

Line 7710: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||

7706: -- skilaru 12-MAR-04 In UpdateInfo2 username would be null in Answer mode
7707: -- to keep the behaviour same just pass null as ROLE..
7708: wf_event.AddParameterToList('ROLE', null, l_parameterlist);
7709: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7710: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7711: l_messageName, l_parameterlist);
7712:
7713: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);
7714: l_language := role_info_tbl(1).language;

Line 7719: wf_event.AddParameterToList('OBJECT_NAME',

7715:
7716: select code into l_language from wf_languages where nls_language = l_language;
7717:
7718: -- AppSearch
7719: wf_event.AddParameterToList('OBJECT_NAME',
7720: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7721: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7722: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7723: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

Line 7721: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);

7717:
7718: -- AppSearch
7719: wf_event.AddParameterToList('OBJECT_NAME',
7720: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7721: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7722: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7723: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7724: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7725: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

Line 7722: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);

7718: -- AppSearch
7719: wf_event.AddParameterToList('OBJECT_NAME',
7720: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7721: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7722: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7723: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7724: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7725: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7726: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

Line 7723: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

7719: wf_event.AddParameterToList('OBJECT_NAME',
7720: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7721: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7722: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7723: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7724: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7725: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7726: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7727:

Line 7724: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);

7720: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7721: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7722: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7723: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7724: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7725: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7726: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7727:
7728:

Line 7725: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

7721: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7722: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7723: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7724: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7725: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7726: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7727:
7728:
7729: -- Raise the event

Line 7726: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

7722: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7723: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7724: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7725: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7726: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7727:
7728:
7729: -- Raise the event
7730: -- wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

Line 7730: -- wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

7726: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7727:
7728:
7729: -- Raise the event
7730: -- wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
7731: -- p_event_key => to_char(nid),
7732: -- p_parameters => l_parameterlist);
7733:
7734: -- <>

Line 7735: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.answer',

7731: -- p_event_key => to_char(nid),
7732: -- p_parameters => l_parameterlist);
7733:
7734: -- <>
7735: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.answer',
7736: p_event_key => to_char(nid),
7737: p_parameters => l_parameterlist);
7738:
7739: exception

Line 9276: Wf_Event.AddParameterToList('NOTIFICATION_ID', p_nid, l_paramlist);

9272: UPDATE wf_notifications
9273: SET mail_status = 'MAIL'
9274: WHERE notification_id = p_nid;
9275:
9276: Wf_Event.AddParameterToList('NOTIFICATION_ID', p_nid, l_paramlist);
9277: Wf_Event.AddParameterToList('ROLE', l_recipient_role, l_paramlist);
9278: Wf_Event.AddParameterToList('GROUP_ID', l_group_id, l_paramlist);
9279: Wf_Event.AddParameterToList('Q_CORRELATION_ID', l_message_type||':'||
9280: l_message_name, l_paramlist);

Line 9277: Wf_Event.AddParameterToList('ROLE', l_recipient_role, l_paramlist);

9273: SET mail_status = 'MAIL'
9274: WHERE notification_id = p_nid;
9275:
9276: Wf_Event.AddParameterToList('NOTIFICATION_ID', p_nid, l_paramlist);
9277: Wf_Event.AddParameterToList('ROLE', l_recipient_role, l_paramlist);
9278: Wf_Event.AddParameterToList('GROUP_ID', l_group_id, l_paramlist);
9279: Wf_Event.AddParameterToList('Q_CORRELATION_ID', l_message_type||':'||
9280: l_message_name, l_paramlist);
9281:

Line 9278: Wf_Event.AddParameterToList('GROUP_ID', l_group_id, l_paramlist);

9274: WHERE notification_id = p_nid;
9275:
9276: Wf_Event.AddParameterToList('NOTIFICATION_ID', p_nid, l_paramlist);
9277: Wf_Event.AddParameterToList('ROLE', l_recipient_role, l_paramlist);
9278: Wf_Event.AddParameterToList('GROUP_ID', l_group_id, l_paramlist);
9279: Wf_Event.AddParameterToList('Q_CORRELATION_ID', l_message_type||':'||
9280: l_message_name, l_paramlist);
9281:
9282: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);

Line 9279: Wf_Event.AddParameterToList('Q_CORRELATION_ID', l_message_type||':'||

9275:
9276: Wf_Event.AddParameterToList('NOTIFICATION_ID', p_nid, l_paramlist);
9277: Wf_Event.AddParameterToList('ROLE', l_recipient_role, l_paramlist);
9278: Wf_Event.AddParameterToList('GROUP_ID', l_group_id, l_paramlist);
9279: Wf_Event.AddParameterToList('Q_CORRELATION_ID', l_message_type||':'||
9280: l_message_name, l_paramlist);
9281:
9282: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);
9283: l_language := role_info_tbl(1).language;

Line 9288: wf_event.AddParameterToList('OBJECT_NAME',

9284:
9285: select code into l_language from wf_languages where nls_language = l_language;
9286:
9287: -- AppSearch
9288: wf_event.AddParameterToList('OBJECT_NAME',
9289: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_paramlist);
9290: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_paramlist);
9291: wf_event.AddParameterToList('ID_TYPE', 'PK', l_paramlist);
9292: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_paramlist);

Line 9290: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_paramlist);

9286:
9287: -- AppSearch
9288: wf_event.AddParameterToList('OBJECT_NAME',
9289: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_paramlist);
9290: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_paramlist);
9291: wf_event.AddParameterToList('ID_TYPE', 'PK', l_paramlist);
9292: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_paramlist);
9293: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_paramlist);
9294: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_paramlist);

Line 9291: wf_event.AddParameterToList('ID_TYPE', 'PK', l_paramlist);

9287: -- AppSearch
9288: wf_event.AddParameterToList('OBJECT_NAME',
9289: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_paramlist);
9290: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_paramlist);
9291: wf_event.AddParameterToList('ID_TYPE', 'PK', l_paramlist);
9292: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_paramlist);
9293: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_paramlist);
9294: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_paramlist);
9295: wf_event.addParameterToList('PK_VALUE_2', l_language, l_paramlist);

Line 9292: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_paramlist);

9288: wf_event.AddParameterToList('OBJECT_NAME',
9289: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_paramlist);
9290: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_paramlist);
9291: wf_event.AddParameterToList('ID_TYPE', 'PK', l_paramlist);
9292: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_paramlist);
9293: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_paramlist);
9294: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_paramlist);
9295: wf_event.addParameterToList('PK_VALUE_2', l_language, l_paramlist);
9296:

Line 9293: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_paramlist);

9289: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_paramlist);
9290: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_paramlist);
9291: wf_event.AddParameterToList('ID_TYPE', 'PK', l_paramlist);
9292: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_paramlist);
9293: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_paramlist);
9294: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_paramlist);
9295: wf_event.addParameterToList('PK_VALUE_2', l_language, l_paramlist);
9296:
9297: Wf_Event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

Line 9294: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_paramlist);

9290: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_paramlist);
9291: wf_event.AddParameterToList('ID_TYPE', 'PK', l_paramlist);
9292: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_paramlist);
9293: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_paramlist);
9294: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_paramlist);
9295: wf_event.addParameterToList('PK_VALUE_2', l_language, l_paramlist);
9296:
9297: Wf_Event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
9298: p_event_key => to_char(p_nid),

Line 9295: wf_event.addParameterToList('PK_VALUE_2', l_language, l_paramlist);

9291: wf_event.AddParameterToList('ID_TYPE', 'PK', l_paramlist);
9292: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_paramlist);
9293: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_paramlist);
9294: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_paramlist);
9295: wf_event.addParameterToList('PK_VALUE_2', l_language, l_paramlist);
9296:
9297: Wf_Event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
9298: p_event_key => to_char(p_nid),
9299: p_parameters => l_paramlist);

Line 9297: Wf_Event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

9293: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_paramlist);
9294: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_paramlist);
9295: wf_event.addParameterToList('PK_VALUE_2', l_language, l_paramlist);
9296:
9297: Wf_Event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
9298: p_event_key => to_char(p_nid),
9299: p_parameters => l_paramlist);
9300:
9301: exception