APPS.WF_NOTIFICATION dependencies on WF_EVENT

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

1261: end if;
1262:
1263: -- Bug 2437347 raising event after DML operation on WF_NOTIFICATION_ATTRIBUTES
1264: if (aname = 'SENDER') then
1265: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
1266: wf_event.AddParameterToList(aname, avalue, l_parameterlist);
1267:
1268:
1269:

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

1262:
1263: -- Bug 2437347 raising event after DML operation on WF_NOTIFICATION_ATTRIBUTES
1264: if (aname = 'SENDER') then
1265: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
1266: wf_event.AddParameterToList(aname, avalue, l_parameterlist);
1267:
1268:
1269:
1270:

Line 1282: wf_event.AddParameterToList('OBJECT_NAME',

1278:
1279: select code into l_language from wf_languages where nls_language = l_language;
1280:
1281: -- AppSearch
1282: wf_event.AddParameterToList('OBJECT_NAME',
1283: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
1284: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
1285: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
1286: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

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

1280:
1281: -- AppSearch
1282: wf_event.AddParameterToList('OBJECT_NAME',
1283: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
1284: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
1285: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
1286: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
1287: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
1288: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

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

1281: -- AppSearch
1282: wf_event.AddParameterToList('OBJECT_NAME',
1283: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
1284: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
1285: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
1286: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
1287: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
1288: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
1289: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

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

1282: wf_event.AddParameterToList('OBJECT_NAME',
1283: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
1284: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
1285: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
1286: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
1287: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
1288: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
1289: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
1290: -- Raise the event

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

1283: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
1284: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
1285: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
1286: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
1287: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
1288: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
1289: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
1290: -- Raise the event
1291: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.setattrtext',

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

1284: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
1285: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
1286: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
1287: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
1288: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
1289: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
1290: -- Raise the event
1291: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.setattrtext',
1292: p_event_key => to_char(nid),

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

1285: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
1286: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
1287: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
1288: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
1289: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
1290: -- Raise the event
1291: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.setattrtext',
1292: p_event_key => to_char(nid),
1293: p_parameters => l_parameterlist);

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

1287: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
1288: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
1289: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
1290: -- Raise the event
1291: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.setattrtext',
1292: p_event_key => to_char(nid),
1293: p_parameters => l_parameterlist);
1294: end if;
1295:

Line 3701: attr_evalue wf_event_t;

3697: attr_tvalue varchar2(4000);
3698: attr_nvalue number;
3699: attr_dvalue date;
3700: -- Bug 2376033
3701: attr_evalue wf_event_t;
3702: -- Bug 2283697
3703: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
3704: -- the following variables for Dynamic SQL
3705: sqlbuf varchar2(2000);

Line 3819: wf_event_t.initialize(attr_evalue);

3815: end if;
3816:
3817: -- Bug 2376033 initialize event to fetch value using cb
3818: if (attr_type = 'EVENT') then
3819: wf_event_t.initialize(attr_evalue);
3820: end if;
3821:
3822: -- If there is a cb defined and the default vtype is ITEMATTR
3823: -- then call the cb to fetch possible item attribute value.

Line 3945: wf_event.AddParameterToList('IS_DUPLICATE','TRUE',l_parameterlist);

3941: into l_new_rcpt_role
3942: from WF_NOTIFICATIONS
3943: where NOTIFICATION_ID=nid;
3944: if SendSingle.Role<>l_new_rcpt_role then
3945: wf_event.AddParameterToList('IS_DUPLICATE','TRUE',l_parameterlist);
3946: end if;
3947:
3948: -- Denormalize the Notification after auto-routing is done
3949: Wf_Notification.Denormalize_Notification(nid);

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

3982:
3983: --Bug 2283697
3984: --To raise an EVENT whenever DML operation is performed on
3985: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
3986: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
3987: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
3988: wf_event.AddParameterToList('GROUP_ID',nvl(group_id,nid),l_parameterlist);
3989:
3990: wf_event.addParameterToList('Q_CORRELATION_ID', sendsingle.msg_type||':'||

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

3983: --Bug 2283697
3984: --To raise an EVENT whenever DML operation is performed on
3985: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
3986: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
3987: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
3988: wf_event.AddParameterToList('GROUP_ID',nvl(group_id,nid),l_parameterlist);
3989:
3990: wf_event.addParameterToList('Q_CORRELATION_ID', sendsingle.msg_type||':'||
3991: sendsingle.msg_name, l_parameterlist);

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

3984: --To raise an EVENT whenever DML operation is performed on
3985: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
3986: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
3987: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
3988: wf_event.AddParameterToList('GROUP_ID',nvl(group_id,nid),l_parameterlist);
3989:
3990: wf_event.addParameterToList('Q_CORRELATION_ID', sendsingle.msg_type||':'||
3991: sendsingle.msg_name, l_parameterlist);
3992:

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

3986: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
3987: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
3988: wf_event.AddParameterToList('GROUP_ID',nvl(group_id,nid),l_parameterlist);
3989:
3990: wf_event.addParameterToList('Q_CORRELATION_ID', sendsingle.msg_type||':'||
3991: sendsingle.msg_name, l_parameterlist);
3992:
3993: Wf_Directory.GetRoleInfo2(sendsingle.role, role_info_tbl);
3994: l_language := role_info_tbl(1).language;

Line 3999: wf_event.AddParameterToList('OBJECT_NAME',

3995:
3996: select code into l_language from wf_languages where nls_language = l_language;
3997:
3998: -- AppSearch
3999: wf_event.AddParameterToList('OBJECT_NAME',
4000: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4001: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4002: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4003: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

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

3997:
3998: -- AppSearch
3999: wf_event.AddParameterToList('OBJECT_NAME',
4000: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4001: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4002: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4003: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4004: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4005: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

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

3998: -- AppSearch
3999: wf_event.AddParameterToList('OBJECT_NAME',
4000: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4001: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4002: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4003: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4004: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4005: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4006: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

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

3999: wf_event.AddParameterToList('OBJECT_NAME',
4000: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4001: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4002: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4003: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4004: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4005: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4006: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4007:

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

4000: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4001: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4002: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4003: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4004: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4005: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4006: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4007:
4008:

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

4001: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4002: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4003: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4004: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4005: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4006: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4007:
4008:
4009:

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

4002: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4003: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4004: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4005: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4006: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4007:
4008:
4009:
4010: --Raise the event

Line 4011: if wf_event.phase_maxthreshold is null then

4007:
4008:
4009:
4010: --Raise the event
4011: if wf_event.phase_maxthreshold is null then
4012: -- means deferred mode , avoid synchronous processing of Send event
4013: wf_event.SetDispatchMode('ASYNC');
4014:
4015: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

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

4009:
4010: --Raise the event
4011: if wf_event.phase_maxthreshold is null then
4012: -- means deferred mode , avoid synchronous processing of Send event
4013: wf_event.SetDispatchMode('ASYNC');
4014:
4015: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
4016: p_event_key => to_char(nid),
4017: p_parameters => l_parameterlist);

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

4011: if wf_event.phase_maxthreshold is null then
4012: -- means deferred mode , avoid synchronous processing of Send event
4013: wf_event.SetDispatchMode('ASYNC');
4014:
4015: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
4016: p_event_key => to_char(nid),
4017: p_parameters => l_parameterlist);
4018:
4019: wf_event.phase_maxthreshold := null;

Line 4019: wf_event.phase_maxthreshold := null;

4015: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
4016: p_event_key => to_char(nid),
4017: p_parameters => l_parameterlist);
4018:
4019: wf_event.phase_maxthreshold := null;
4020: else
4021: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
4022: p_event_key => to_char(nid),
4023: p_parameters => l_parameterlist);

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

4017: p_parameters => l_parameterlist);
4018:
4019: wf_event.phase_maxthreshold := null;
4020: else
4021: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
4022: p_event_key => to_char(nid),
4023: p_parameters => l_parameterlist);
4024:
4025: end if;

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

4546:
4547: --Bug 2283697
4548: --To raise an EVENT whenever DML operation is performed on
4549: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4550: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4551: wf_event.AddParameterToList('NEW_ROLE',new_role,l_parameterlist);
4552: wf_event.AddParameterToList('MODE',fmode,l_parameterlist);
4553: if (user is not null) then
4554: wf_event.AddParameterToList('USER',user,l_parameterlist);

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

4547: --Bug 2283697
4548: --To raise an EVENT whenever DML operation is performed on
4549: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4550: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4551: wf_event.AddParameterToList('NEW_ROLE',new_role,l_parameterlist);
4552: wf_event.AddParameterToList('MODE',fmode,l_parameterlist);
4553: if (user is not null) then
4554: wf_event.AddParameterToList('USER',user,l_parameterlist);
4555: elsif (fmode = 'FORWARD') then

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

4548: --To raise an EVENT whenever DML operation is performed on
4549: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4550: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4551: wf_event.AddParameterToList('NEW_ROLE',new_role,l_parameterlist);
4552: wf_event.AddParameterToList('MODE',fmode,l_parameterlist);
4553: if (user is not null) then
4554: wf_event.AddParameterToList('USER',user,l_parameterlist);
4555: elsif (fmode = 'FORWARD') then
4556: wf_event.AddParameterToList('USER',old_role,l_parameterlist);

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

4550: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4551: wf_event.AddParameterToList('NEW_ROLE',new_role,l_parameterlist);
4552: wf_event.AddParameterToList('MODE',fmode,l_parameterlist);
4553: if (user is not null) then
4554: wf_event.AddParameterToList('USER',user,l_parameterlist);
4555: elsif (fmode = 'FORWARD') then
4556: wf_event.AddParameterToList('USER',old_role,l_parameterlist);
4557: else
4558: wf_event.AddParameterToList('USER',old_origrole,l_parameterlist);

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

4552: wf_event.AddParameterToList('MODE',fmode,l_parameterlist);
4553: if (user is not null) then
4554: wf_event.AddParameterToList('USER',user,l_parameterlist);
4555: elsif (fmode = 'FORWARD') then
4556: wf_event.AddParameterToList('USER',old_role,l_parameterlist);
4557: else
4558: wf_event.AddParameterToList('USER',old_origrole,l_parameterlist);
4559: end if;
4560:

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

4554: wf_event.AddParameterToList('USER',user,l_parameterlist);
4555: elsif (fmode = 'FORWARD') then
4556: wf_event.AddParameterToList('USER',old_role,l_parameterlist);
4557: else
4558: wf_event.AddParameterToList('USER',old_origrole,l_parameterlist);
4559: end if;
4560:
4561: -- <7641725> we need to include Q_CORRELATION_ID parameter
4562: wf_event.addParameterToList('Q_CORRELATION_ID'

Line 4562: wf_event.addParameterToList('Q_CORRELATION_ID'

4558: wf_event.AddParameterToList('USER',old_origrole,l_parameterlist);
4559: end if;
4560:
4561: -- <7641725> we need to include Q_CORRELATION_ID parameter
4562: wf_event.addParameterToList('Q_CORRELATION_ID'
4563: , l_msgType||':'||l_msgName, l_parameterlist);
4564:
4565: select WN.RECIPIENT_ROLE
4566: into l_recipient_role

Line 4576: wf_event.AddParameterToList('OBJECT_NAME',

4572:
4573: select code into l_language from wf_languages where nls_language = l_language;
4574:
4575: -- AppSearch
4576: wf_event.AddParameterToList('OBJECT_NAME',
4577: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4578: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4579: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4580: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

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

4574:
4575: -- AppSearch
4576: wf_event.AddParameterToList('OBJECT_NAME',
4577: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4578: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4579: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4580: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4581: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4582: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

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

4575: -- AppSearch
4576: wf_event.AddParameterToList('OBJECT_NAME',
4577: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4578: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4579: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4580: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4581: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4582: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4583: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

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

4576: wf_event.AddParameterToList('OBJECT_NAME',
4577: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4578: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4579: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4580: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4581: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4582: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4583: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4584:

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

4577: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4578: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4579: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4580: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4581: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4582: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4583: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4584:
4585:

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

4578: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4579: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4580: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4581: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4582: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4583: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4584:
4585:
4586: --Raise the event

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

4579: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4580: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4581: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4582: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4583: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4584:
4585:
4586: --Raise the event
4587: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.reassign',

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

4583: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4584:
4585:
4586: --Raise the event
4587: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.reassign',
4588: p_event_key => to_char(nid),
4589: p_parameters => l_parameterlist);
4590:
4591: exception

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

4779:
4780: --Bug 2283697
4781: --To raise an EVENT whenever DML operation is performed on
4782: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4783: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4784: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
4785: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type || ':'||
4786: l_msg_name, l_parameterlist);
4787:

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

4780: --Bug 2283697
4781: --To raise an EVENT whenever DML operation is performed on
4782: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4783: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4784: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
4785: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type || ':'||
4786: l_msg_name, l_parameterlist);
4787:
4788:

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

4781: --To raise an EVENT whenever DML operation is performed on
4782: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4783: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4784: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
4785: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type || ':'||
4786: l_msg_name, l_parameterlist);
4787:
4788:
4789: -- AppSearch

Line 4790: wf_event.AddParameterToList('OBJECT_NAME',

4786: l_msg_name, l_parameterlist);
4787:
4788:
4789: -- AppSearch
4790: wf_event.AddParameterToList('OBJECT_NAME',
4791: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4792: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4793: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4794: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

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

4788:
4789: -- AppSearch
4790: wf_event.AddParameterToList('OBJECT_NAME',
4791: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4792: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4793: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4794: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4795: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4796: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

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

4789: -- AppSearch
4790: wf_event.AddParameterToList('OBJECT_NAME',
4791: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4792: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4793: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4794: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4795: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4796: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4797: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

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

4790: wf_event.AddParameterToList('OBJECT_NAME',
4791: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4792: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4793: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4794: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4795: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4796: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4797: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4798:

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

4791: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
4792: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4793: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4794: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4795: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4796: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4797: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4798:
4799: --Raise the event

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

4792: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
4793: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4794: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4795: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4796: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4797: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4798:
4799: --Raise the event
4800: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.cancel',

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

4793: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
4794: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
4795: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
4796: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4797: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4798:
4799: --Raise the event
4800: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.cancel',
4801: p_event_key => to_char(nid),

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

4796: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
4797: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
4798:
4799: --Raise the event
4800: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.cancel',
4801: p_event_key => to_char(nid),
4802: p_parameters => l_parameterlist);
4803:
4804:

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

5252:
5253: --Bug 2283697
5254: --To raise an EVENT whenever DML operation is performed on
5255: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
5256: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
5257: wf_event.AddParameterToList('RESPONDER',close.responder,l_parameterlist);
5258:
5259: -- AppSearch
5260: wf_event.AddParameterToList('OBJECT_NAME',

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

5253: --Bug 2283697
5254: --To raise an EVENT whenever DML operation is performed on
5255: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
5256: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
5257: wf_event.AddParameterToList('RESPONDER',close.responder,l_parameterlist);
5258:
5259: -- AppSearch
5260: wf_event.AddParameterToList('OBJECT_NAME',
5261: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);

Line 5260: wf_event.AddParameterToList('OBJECT_NAME',

5256: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
5257: wf_event.AddParameterToList('RESPONDER',close.responder,l_parameterlist);
5258:
5259: -- AppSearch
5260: wf_event.AddParameterToList('OBJECT_NAME',
5261: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
5262: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
5263: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
5264: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

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

5258:
5259: -- AppSearch
5260: wf_event.AddParameterToList('OBJECT_NAME',
5261: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
5262: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
5263: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
5264: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
5265: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
5266: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

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

5259: -- AppSearch
5260: wf_event.AddParameterToList('OBJECT_NAME',
5261: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
5262: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
5263: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
5264: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
5265: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
5266: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
5267: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

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

5260: wf_event.AddParameterToList('OBJECT_NAME',
5261: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
5262: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
5263: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
5264: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
5265: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
5266: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
5267: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
5268:

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

5261: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
5262: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
5263: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
5264: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
5265: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
5266: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
5267: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
5268:
5269: --Raise the event

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

5262: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
5263: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
5264: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
5265: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
5266: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
5267: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
5268:
5269: --Raise the event
5270: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.close',

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

5263: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
5264: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
5265: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
5266: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
5267: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
5268:
5269: --Raise the event
5270: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.close',
5271: p_event_key => to_char(nid),

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

5266: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
5267: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
5268:
5269: --Raise the event
5270: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.close',
5271: p_event_key => to_char(nid),
5272: p_parameters => l_parameterlist);
5273:
5274: exception

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

6250:
6251: if (l_defer_denormalize) then
6252:
6253: -- To raise an EVENT when l_defer_denormalize is set true
6254: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
6255: wf_event.AddParameterToList('ROLE',l_user,l_parameterlist);
6256: wf_event.AddParameterToList('LANGUAGE',l_language,l_parameterlist);
6257: wf_event.AddParameterToList('TERRITORY',l_territory,l_parameterlist);
6258:

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

6251: if (l_defer_denormalize) then
6252:
6253: -- To raise an EVENT when l_defer_denormalize is set true
6254: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
6255: wf_event.AddParameterToList('ROLE',l_user,l_parameterlist);
6256: wf_event.AddParameterToList('LANGUAGE',l_language,l_parameterlist);
6257: wf_event.AddParameterToList('TERRITORY',l_territory,l_parameterlist);
6258:
6259: -- <7514495>

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

6252:
6253: -- To raise an EVENT when l_defer_denormalize is set true
6254: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
6255: wf_event.AddParameterToList('ROLE',l_user,l_parameterlist);
6256: wf_event.AddParameterToList('LANGUAGE',l_language,l_parameterlist);
6257: wf_event.AddParameterToList('TERRITORY',l_territory,l_parameterlist);
6258:
6259: -- <7514495>
6260: wf_event.AddParameterToList('NLS_DATE_FORMAT', l_nls_date_format,l_parameterlist);

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

6253: -- To raise an EVENT when l_defer_denormalize is set true
6254: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
6255: wf_event.AddParameterToList('ROLE',l_user,l_parameterlist);
6256: wf_event.AddParameterToList('LANGUAGE',l_language,l_parameterlist);
6257: wf_event.AddParameterToList('TERRITORY',l_territory,l_parameterlist);
6258:
6259: -- <7514495>
6260: wf_event.AddParameterToList('NLS_DATE_FORMAT', l_nls_date_format,l_parameterlist);
6261: wf_event.AddParameterToList('NLS_DATE_LANGUAGE', l_nls_date_language,l_parameterlist);

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

6256: wf_event.AddParameterToList('LANGUAGE',l_language,l_parameterlist);
6257: wf_event.AddParameterToList('TERRITORY',l_territory,l_parameterlist);
6258:
6259: -- <7514495>
6260: wf_event.AddParameterToList('NLS_DATE_FORMAT', l_nls_date_format,l_parameterlist);
6261: wf_event.AddParameterToList('NLS_DATE_LANGUAGE', l_nls_date_language,l_parameterlist);
6262: wf_event.AddParameterToList('NLS_CALENDAR', l_nls_calendar,l_parameterlist);
6263: wf_event.AddParameterToList('NLS_NUMERIC_CHARACTERS', l_nls_numeric_characters,l_parameterlist);
6264: wf_event.AddParameterToList('NLS_SORT', l_nls_sort,l_parameterlist);

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

6257: wf_event.AddParameterToList('TERRITORY',l_territory,l_parameterlist);
6258:
6259: -- <7514495>
6260: wf_event.AddParameterToList('NLS_DATE_FORMAT', l_nls_date_format,l_parameterlist);
6261: wf_event.AddParameterToList('NLS_DATE_LANGUAGE', l_nls_date_language,l_parameterlist);
6262: wf_event.AddParameterToList('NLS_CALENDAR', l_nls_calendar,l_parameterlist);
6263: wf_event.AddParameterToList('NLS_NUMERIC_CHARACTERS', l_nls_numeric_characters,l_parameterlist);
6264: wf_event.AddParameterToList('NLS_SORT', l_nls_sort,l_parameterlist);
6265: wf_event.AddParameterToList('NLS_CURRENCY', l_nls_currency,l_parameterlist);

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

6258:
6259: -- <7514495>
6260: wf_event.AddParameterToList('NLS_DATE_FORMAT', l_nls_date_format,l_parameterlist);
6261: wf_event.AddParameterToList('NLS_DATE_LANGUAGE', l_nls_date_language,l_parameterlist);
6262: wf_event.AddParameterToList('NLS_CALENDAR', l_nls_calendar,l_parameterlist);
6263: wf_event.AddParameterToList('NLS_NUMERIC_CHARACTERS', l_nls_numeric_characters,l_parameterlist);
6264: wf_event.AddParameterToList('NLS_SORT', l_nls_sort,l_parameterlist);
6265: wf_event.AddParameterToList('NLS_CURRENCY', l_nls_currency,l_parameterlist);
6266: --

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

6259: -- <7514495>
6260: wf_event.AddParameterToList('NLS_DATE_FORMAT', l_nls_date_format,l_parameterlist);
6261: wf_event.AddParameterToList('NLS_DATE_LANGUAGE', l_nls_date_language,l_parameterlist);
6262: wf_event.AddParameterToList('NLS_CALENDAR', l_nls_calendar,l_parameterlist);
6263: wf_event.AddParameterToList('NLS_NUMERIC_CHARACTERS', l_nls_numeric_characters,l_parameterlist);
6264: wf_event.AddParameterToList('NLS_SORT', l_nls_sort,l_parameterlist);
6265: wf_event.AddParameterToList('NLS_CURRENCY', l_nls_currency,l_parameterlist);
6266: --
6267:

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

6260: wf_event.AddParameterToList('NLS_DATE_FORMAT', l_nls_date_format,l_parameterlist);
6261: wf_event.AddParameterToList('NLS_DATE_LANGUAGE', l_nls_date_language,l_parameterlist);
6262: wf_event.AddParameterToList('NLS_CALENDAR', l_nls_calendar,l_parameterlist);
6263: wf_event.AddParameterToList('NLS_NUMERIC_CHARACTERS', l_nls_numeric_characters,l_parameterlist);
6264: wf_event.AddParameterToList('NLS_SORT', l_nls_sort,l_parameterlist);
6265: wf_event.AddParameterToList('NLS_CURRENCY', l_nls_currency,l_parameterlist);
6266: --
6267:
6268: if ( l_logSTMT ) then

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

6261: wf_event.AddParameterToList('NLS_DATE_LANGUAGE', l_nls_date_language,l_parameterlist);
6262: wf_event.AddParameterToList('NLS_CALENDAR', l_nls_calendar,l_parameterlist);
6263: wf_event.AddParameterToList('NLS_NUMERIC_CHARACTERS', l_nls_numeric_characters,l_parameterlist);
6264: wf_event.AddParameterToList('NLS_SORT', l_nls_sort,l_parameterlist);
6265: wf_event.AddParameterToList('NLS_CURRENCY', l_nls_currency,l_parameterlist);
6266: --
6267:
6268: if ( l_logSTMT ) then
6269: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'defer parameters: '||

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

6279: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module, 'END - deferring denormalization');
6280: end if;
6281:
6282: -- Raise the event
6283: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.denormalize',
6284: p_event_key => to_char(nid),
6285: p_parameters => l_parameterlist);
6286:
6287: return;

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

6864:
6865: -- Bug 2283697
6866: -- To raise an EVENT whenever DML operation is performed on
6867: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
6868: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
6869: wf_event.AddParameterToList('ROLE', username, l_parameterlist);
6870: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
6871: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
6872: l_messageName, l_parameterlist);

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

6865: -- Bug 2283697
6866: -- To raise an EVENT whenever DML operation is performed on
6867: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
6868: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
6869: wf_event.AddParameterToList('ROLE', username, l_parameterlist);
6870: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
6871: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
6872: l_messageName, l_parameterlist);
6873:

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

6866: -- To raise an EVENT whenever DML operation is performed on
6867: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
6868: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
6869: wf_event.AddParameterToList('ROLE', username, l_parameterlist);
6870: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
6871: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
6872: l_messageName, l_parameterlist);
6873:
6874:

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

6867: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
6868: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
6869: wf_event.AddParameterToList('ROLE', username, l_parameterlist);
6870: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
6871: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
6872: l_messageName, l_parameterlist);
6873:
6874:
6875: Wf_Directory.GetRoleInfo2(l_recip_role, role_info_tbl);

Line 6881: wf_event.AddParameterToList('OBJECT_NAME',

6877:
6878: select code into l_language from wf_languages where nls_language = l_language;
6879:
6880: -- AppSearch
6881: wf_event.AddParameterToList('OBJECT_NAME',
6882: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
6883: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
6884: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
6885: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

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

6879:
6880: -- AppSearch
6881: wf_event.AddParameterToList('OBJECT_NAME',
6882: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
6883: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
6884: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
6885: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
6886: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
6887: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

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

6880: -- AppSearch
6881: wf_event.AddParameterToList('OBJECT_NAME',
6882: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
6883: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
6884: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
6885: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
6886: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
6887: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
6888: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

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

6881: wf_event.AddParameterToList('OBJECT_NAME',
6882: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
6883: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
6884: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
6885: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
6886: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
6887: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
6888: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
6889:

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

6882: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
6883: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
6884: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
6885: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
6886: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
6887: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
6888: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
6889:
6890:

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

6883: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
6884: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
6885: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
6886: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
6887: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
6888: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
6889:
6890:
6891: -- Raise the event

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

6884: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
6885: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
6886: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
6887: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
6888: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
6889:
6890:
6891: -- Raise the event
6892: -- wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

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

6888: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
6889:
6890:
6891: -- Raise the event
6892: -- wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
6893: -- p_event_key => to_char(nid),
6894: -- p_parameters => l_parameterlist);
6895:
6896: -- <>

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

6893: -- p_event_key => to_char(nid),
6894: -- p_parameters => l_parameterlist);
6895:
6896: -- <>
6897: wf_event.Raise(p_event_name => l_event_name,
6898: p_event_key => to_char(nid),
6899: p_parameters => l_parameterlist);
6900:
6901: exception

Line 7126: wf_event.AddParameterToList('NOTIFICATION_ID', p_nid, l_parameterlist);

7122: wf_notification.clob_exists := null;
7123:
7124: -- To raise an EVENT whenever DML operation is performed on
7125: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7126: wf_event.AddParameterToList('NOTIFICATION_ID', p_nid, l_parameterlist);
7127: wf_event.AddParameterToList('ROLE', p_new_user, l_parameterlist);
7128: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, p_nid), l_parameterlist);
7129: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7130: l_messageName, l_parameterlist);

Line 7127: wf_event.AddParameterToList('ROLE', p_new_user, l_parameterlist);

7123:
7124: -- To raise an EVENT whenever DML operation is performed on
7125: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7126: wf_event.AddParameterToList('NOTIFICATION_ID', p_nid, l_parameterlist);
7127: wf_event.AddParameterToList('ROLE', p_new_user, l_parameterlist);
7128: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, p_nid), l_parameterlist);
7129: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7130: l_messageName, l_parameterlist);
7131:

Line 7128: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, p_nid), l_parameterlist);

7124: -- To raise an EVENT whenever DML operation is performed on
7125: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7126: wf_event.AddParameterToList('NOTIFICATION_ID', p_nid, l_parameterlist);
7127: wf_event.AddParameterToList('ROLE', p_new_user, l_parameterlist);
7128: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, p_nid), l_parameterlist);
7129: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7130: l_messageName, l_parameterlist);
7131:
7132:

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

7125: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7126: wf_event.AddParameterToList('NOTIFICATION_ID', p_nid, l_parameterlist);
7127: wf_event.AddParameterToList('ROLE', p_new_user, l_parameterlist);
7128: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, p_nid), l_parameterlist);
7129: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7130: l_messageName, l_parameterlist);
7131:
7132:
7133: Wf_Directory.GetRoleInfo2(l_recip_role, role_info_tbl);

Line 7139: wf_event.AddParameterToList('OBJECT_NAME',

7135:
7136: select code into l_language from wf_languages where nls_language = l_language;
7137:
7138: -- AppSearch
7139: wf_event.AddParameterToList('OBJECT_NAME',
7140: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7141: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7142: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7143: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

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

7137:
7138: -- AppSearch
7139: wf_event.AddParameterToList('OBJECT_NAME',
7140: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7141: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7142: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7143: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7144: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_parameterlist);
7145: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

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

7138: -- AppSearch
7139: wf_event.AddParameterToList('OBJECT_NAME',
7140: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7141: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7142: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7143: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7144: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_parameterlist);
7145: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7146: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

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

7139: wf_event.AddParameterToList('OBJECT_NAME',
7140: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7141: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7142: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7143: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7144: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_parameterlist);
7145: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7146: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7147:

Line 7144: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_parameterlist);

7140: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7141: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7142: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7143: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7144: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_parameterlist);
7145: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7146: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7147:
7148: wf_event.Raise(p_event_name => l_event_name,

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

7141: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7142: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7143: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7144: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_parameterlist);
7145: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7146: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7147:
7148: wf_event.Raise(p_event_name => l_event_name,
7149: p_event_key => to_char(p_nid),

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

7142: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7143: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7144: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_parameterlist);
7145: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7146: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7147:
7148: wf_event.Raise(p_event_name => l_event_name,
7149: p_event_key => to_char(p_nid),
7150: p_parameters => l_parameterlist);

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

7144: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_parameterlist);
7145: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7146: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7147:
7148: wf_event.Raise(p_event_name => l_event_name,
7149: p_event_key => to_char(p_nid),
7150: p_parameters => l_parameterlist);
7151:
7152: exception

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

7768:
7769: -- Bug 2283697
7770: -- To raise an EVENT whenever DML operation is performed on
7771: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7772: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7773:
7774: -- username MAY be a display name
7775: wf_event.AddParameterToList('ROLE', nvl(l_username, username), l_parameterlist);
7776: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);

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

7771: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7772: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7773:
7774: -- username MAY be a display name
7775: wf_event.AddParameterToList('ROLE', nvl(l_username, username), l_parameterlist);
7776: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7777: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7778: l_messageName, l_parameterlist);
7779:

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

7772: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7773:
7774: -- username MAY be a display name
7775: wf_event.AddParameterToList('ROLE', nvl(l_username, username), l_parameterlist);
7776: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7777: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7778: l_messageName, l_parameterlist);
7779:
7780: Wf_Directory.GetRoleInfo2(l_recip_role, role_info_tbl);

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

7773:
7774: -- username MAY be a display name
7775: wf_event.AddParameterToList('ROLE', nvl(l_username, username), l_parameterlist);
7776: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7777: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7778: l_messageName, l_parameterlist);
7779:
7780: Wf_Directory.GetRoleInfo2(l_recip_role, role_info_tbl);
7781: l_language := role_info_tbl(1).language;

Line 7787: wf_event.AddParameterToList('OBJECT_NAME',

7783: select code into l_language from wf_languages where nls_language = l_language;
7784:
7785:
7786: -- AppSearch
7787: wf_event.AddParameterToList('OBJECT_NAME',
7788: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7789: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7790: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7791: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

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

7785:
7786: -- AppSearch
7787: wf_event.AddParameterToList('OBJECT_NAME',
7788: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7789: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7790: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7791: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7792: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7793: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

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

7786: -- AppSearch
7787: wf_event.AddParameterToList('OBJECT_NAME',
7788: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7789: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7790: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7791: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7792: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7793: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7794: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

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

7787: wf_event.AddParameterToList('OBJECT_NAME',
7788: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7789: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7790: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7791: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7792: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7793: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7794: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7795:

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

7788: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7789: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7790: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7791: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7792: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7793: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7794: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7795:
7796:

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

7789: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7790: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7791: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7792: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7793: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7794: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7795:
7796:
7797: -- Raise the event

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

7790: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7791: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7792: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7793: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7794: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7795:
7796:
7797: -- Raise the event
7798: -- wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

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

7794: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7795:
7796:
7797: -- Raise the event
7798: -- wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
7799: -- p_event_key => to_char(nid),
7800: -- p_parameters => l_parameterlist);
7801:
7802: -- <>

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

7799: -- p_event_key => to_char(nid),
7800: -- p_parameters => l_parameterlist);
7801:
7802: -- <>
7803: wf_event.Raise(p_event_name => l_event_name,
7804: p_event_key => to_char(nid),
7805: p_parameters => l_parameterlist);
7806:
7807: exception

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

7927:
7928: -- Bug 2283697
7929: -- To raise an EVENT whenever DML operation is performed on
7930: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7931: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7932: -- skilaru 12-MAR-04 In UpdateInfo2 username would be null in Answer mode
7933: -- to keep the behaviour same just pass null as ROLE..
7934: wf_event.AddParameterToList('ROLE', null, l_parameterlist);
7935: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);

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

7930: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7931: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7932: -- skilaru 12-MAR-04 In UpdateInfo2 username would be null in Answer mode
7933: -- to keep the behaviour same just pass null as ROLE..
7934: wf_event.AddParameterToList('ROLE', null, l_parameterlist);
7935: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7936: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7937: l_messageName, l_parameterlist);
7938:

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

7931: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7932: -- skilaru 12-MAR-04 In UpdateInfo2 username would be null in Answer mode
7933: -- to keep the behaviour same just pass null as ROLE..
7934: wf_event.AddParameterToList('ROLE', null, l_parameterlist);
7935: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7936: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7937: l_messageName, l_parameterlist);
7938:
7939: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);

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

7932: -- skilaru 12-MAR-04 In UpdateInfo2 username would be null in Answer mode
7933: -- to keep the behaviour same just pass null as ROLE..
7934: wf_event.AddParameterToList('ROLE', null, l_parameterlist);
7935: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7936: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7937: l_messageName, l_parameterlist);
7938:
7939: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);
7940: l_language := role_info_tbl(1).language;

Line 7945: wf_event.AddParameterToList('OBJECT_NAME',

7941:
7942: select code into l_language from wf_languages where nls_language = l_language;
7943:
7944: -- AppSearch
7945: wf_event.AddParameterToList('OBJECT_NAME',
7946: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7947: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7948: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7949: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

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

7943:
7944: -- AppSearch
7945: wf_event.AddParameterToList('OBJECT_NAME',
7946: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7947: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7948: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7949: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7950: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7951: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

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

7944: -- AppSearch
7945: wf_event.AddParameterToList('OBJECT_NAME',
7946: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7947: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7948: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7949: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7950: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7951: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7952: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

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

7945: wf_event.AddParameterToList('OBJECT_NAME',
7946: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7947: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7948: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7949: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7950: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7951: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7952: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7953:

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

7946: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
7947: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7948: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7949: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7950: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7951: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7952: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7953:
7954:

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

7947: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
7948: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7949: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7950: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7951: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7952: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7953:
7954:
7955: -- Raise the event

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

7948: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
7949: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
7950: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
7951: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
7952: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7953:
7954:
7955: -- Raise the event
7956: -- wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

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

7952: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
7953:
7954:
7955: -- Raise the event
7956: -- wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
7957: -- p_event_key => to_char(nid),
7958: -- p_parameters => l_parameterlist);
7959:
7960: -- <>

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

7957: -- p_event_key => to_char(nid),
7958: -- p_parameters => l_parameterlist);
7959:
7960: -- <>
7961: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.answer',
7962: p_event_key => to_char(nid),
7963: p_parameters => l_parameterlist);
7964:
7965: exception

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

9520: UPDATE wf_notifications
9521: SET mail_status = 'MAIL'
9522: WHERE notification_id = p_nid;
9523:
9524: Wf_Event.AddParameterToList('NOTIFICATION_ID', p_nid, l_paramlist);
9525: Wf_Event.AddParameterToList('ROLE', l_recipient_role, l_paramlist);
9526: Wf_Event.AddParameterToList('GROUP_ID', l_group_id, l_paramlist);
9527: Wf_Event.AddParameterToList('Q_CORRELATION_ID', l_message_type||':'||
9528: l_message_name, l_paramlist);

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

9521: SET mail_status = 'MAIL'
9522: WHERE notification_id = p_nid;
9523:
9524: Wf_Event.AddParameterToList('NOTIFICATION_ID', p_nid, l_paramlist);
9525: Wf_Event.AddParameterToList('ROLE', l_recipient_role, l_paramlist);
9526: Wf_Event.AddParameterToList('GROUP_ID', l_group_id, l_paramlist);
9527: Wf_Event.AddParameterToList('Q_CORRELATION_ID', l_message_type||':'||
9528: l_message_name, l_paramlist);
9529:

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

9522: WHERE notification_id = p_nid;
9523:
9524: Wf_Event.AddParameterToList('NOTIFICATION_ID', p_nid, l_paramlist);
9525: Wf_Event.AddParameterToList('ROLE', l_recipient_role, l_paramlist);
9526: Wf_Event.AddParameterToList('GROUP_ID', l_group_id, l_paramlist);
9527: Wf_Event.AddParameterToList('Q_CORRELATION_ID', l_message_type||':'||
9528: l_message_name, l_paramlist);
9529:
9530: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);

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

9523:
9524: Wf_Event.AddParameterToList('NOTIFICATION_ID', p_nid, l_paramlist);
9525: Wf_Event.AddParameterToList('ROLE', l_recipient_role, l_paramlist);
9526: Wf_Event.AddParameterToList('GROUP_ID', l_group_id, l_paramlist);
9527: Wf_Event.AddParameterToList('Q_CORRELATION_ID', l_message_type||':'||
9528: l_message_name, l_paramlist);
9529:
9530: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);
9531: l_language := role_info_tbl(1).language;

Line 9536: wf_event.AddParameterToList('OBJECT_NAME',

9532:
9533: select code into l_language from wf_languages where nls_language = l_language;
9534:
9535: -- AppSearch
9536: wf_event.AddParameterToList('OBJECT_NAME',
9537: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_paramlist);
9538: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_paramlist);
9539: wf_event.AddParameterToList('ID_TYPE', 'PK', l_paramlist);
9540: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_paramlist);

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

9534:
9535: -- AppSearch
9536: wf_event.AddParameterToList('OBJECT_NAME',
9537: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_paramlist);
9538: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_paramlist);
9539: wf_event.AddParameterToList('ID_TYPE', 'PK', l_paramlist);
9540: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_paramlist);
9541: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_paramlist);
9542: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_paramlist);

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

9535: -- AppSearch
9536: wf_event.AddParameterToList('OBJECT_NAME',
9537: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_paramlist);
9538: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_paramlist);
9539: wf_event.AddParameterToList('ID_TYPE', 'PK', l_paramlist);
9540: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_paramlist);
9541: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_paramlist);
9542: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_paramlist);
9543: wf_event.addParameterToList('PK_VALUE_2', l_language, l_paramlist);

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

9536: wf_event.AddParameterToList('OBJECT_NAME',
9537: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_paramlist);
9538: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_paramlist);
9539: wf_event.AddParameterToList('ID_TYPE', 'PK', l_paramlist);
9540: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_paramlist);
9541: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_paramlist);
9542: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_paramlist);
9543: wf_event.addParameterToList('PK_VALUE_2', l_language, l_paramlist);
9544:

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

9537: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_paramlist);
9538: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_paramlist);
9539: wf_event.AddParameterToList('ID_TYPE', 'PK', l_paramlist);
9540: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_paramlist);
9541: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_paramlist);
9542: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_paramlist);
9543: wf_event.addParameterToList('PK_VALUE_2', l_language, l_paramlist);
9544:
9545: Wf_Event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

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

9538: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_paramlist);
9539: wf_event.AddParameterToList('ID_TYPE', 'PK', l_paramlist);
9540: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_paramlist);
9541: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_paramlist);
9542: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_paramlist);
9543: wf_event.addParameterToList('PK_VALUE_2', l_language, l_paramlist);
9544:
9545: Wf_Event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
9546: p_event_key => to_char(p_nid),

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

9539: wf_event.AddParameterToList('ID_TYPE', 'PK', l_paramlist);
9540: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_paramlist);
9541: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_paramlist);
9542: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_paramlist);
9543: wf_event.addParameterToList('PK_VALUE_2', l_language, l_paramlist);
9544:
9545: Wf_Event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
9546: p_event_key => to_char(p_nid),
9547: p_parameters => l_paramlist);

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

9541: wf_event.addParameterToList('PK_VALUE_1', p_nid, l_paramlist);
9542: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_paramlist);
9543: wf_event.addParameterToList('PK_VALUE_2', l_language, l_paramlist);
9544:
9545: Wf_Event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
9546: p_event_key => to_char(p_nid),
9547: p_parameters => l_paramlist);
9548:
9549: exception

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

10080:
10081: --Bug 2283697
10082: --To raise an EVENT whenever DML operation is performed on
10083: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
10084: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
10085: wf_event.AddParameterToList('RESPONDER',respond2.responder,l_parameterlist);
10086:
10087: -- AppSearch
10088: wf_event.AddParameterToList('OBJECT_NAME',

Line 10085: wf_event.AddParameterToList('RESPONDER',respond2.responder,l_parameterlist);

10081: --Bug 2283697
10082: --To raise an EVENT whenever DML operation is performed on
10083: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
10084: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
10085: wf_event.AddParameterToList('RESPONDER',respond2.responder,l_parameterlist);
10086:
10087: -- AppSearch
10088: wf_event.AddParameterToList('OBJECT_NAME',
10089: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);

Line 10088: wf_event.AddParameterToList('OBJECT_NAME',

10084: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
10085: wf_event.AddParameterToList('RESPONDER',respond2.responder,l_parameterlist);
10086:
10087: -- AppSearch
10088: wf_event.AddParameterToList('OBJECT_NAME',
10089: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
10090: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
10091: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
10092: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);

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

10086:
10087: -- AppSearch
10088: wf_event.AddParameterToList('OBJECT_NAME',
10089: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
10090: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
10091: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
10092: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
10093: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
10094: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);

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

10087: -- AppSearch
10088: wf_event.AddParameterToList('OBJECT_NAME',
10089: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
10090: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
10091: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
10092: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
10093: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
10094: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
10095: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);

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

10088: wf_event.AddParameterToList('OBJECT_NAME',
10089: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
10090: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
10091: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
10092: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
10093: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
10094: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
10095: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
10096:

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

10089: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);
10090: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
10091: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
10092: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
10093: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
10094: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
10095: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
10096:
10097: --Raise the event

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

10090: wf_event.AddParameterToList('CHANGE_TYPE', 'INSERT',l_parameterlist);
10091: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
10092: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
10093: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
10094: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
10095: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
10096:
10097: --Raise the event
10098: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.respond',

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

10091: wf_event.AddParameterToList('ID_TYPE', 'PK', l_parameterlist);
10092: wf_event.addParameterToList('PK_NAME_1', 'NOTIFICATION_ID',l_parameterlist);
10093: wf_event.addParameterToList('PK_VALUE_1', nid, l_parameterlist);
10094: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
10095: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
10096:
10097: --Raise the event
10098: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.respond',
10099: p_event_key => to_char(nid),

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

10094: wf_event.addParameterToList('PK_NAME_2', 'LANGUAGE',l_parameterlist);
10095: wf_event.addParameterToList('PK_VALUE_2', l_language, l_parameterlist);
10096:
10097: --Raise the event
10098: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.respond',
10099: p_event_key => to_char(nid),
10100: p_parameters => l_parameterlist);
10101:
10102: -- If no callback, there is nothing else to do.

Line 10171: l_event wf_event_t;

10167: defer_response in varchar2 default null)
10168: is
10169:
10170: l_eventname varchar2(60) := 'oracle.apps.wf.notification.wl.response.message';
10171: l_event wf_event_t;
10172: l_parameterlist wf_parameter_list_t := wf_parameter_list_t() ;
10173: l_agent wf_agent_t := null ;
10174:
10175: l_itemType WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE := null;

Line 10216: l_agent.SYSTEM := wf_event.local_system_name;

10212:
10213: -- prepare event payload
10214: l_agent := wf_agent_t(null, null);
10215: l_agent.name := 'WF_NOTIFICATION_IN';
10216: l_agent.SYSTEM := wf_event.local_system_name;
10217:
10218: wf_event_t.initialize(l_event);
10219: l_event.event_name := l_eventname;
10220: l_event.event_key := nid;

Line 10218: wf_event_t.initialize(l_event);

10214: l_agent := wf_agent_t(null, null);
10215: l_agent.name := 'WF_NOTIFICATION_IN';
10216: l_agent.SYSTEM := wf_event.local_system_name;
10217:
10218: wf_event_t.initialize(l_event);
10219: l_event.event_name := l_eventname;
10220: l_event.event_key := nid;
10221: l_event.setFromAgent(l_agent);
10222: l_event.setPriority(1);

Line 10236: wf_event_ojmstext_qh.enqueue( l_event, l_agent);

10232: else
10233: l_event.AddParameterToList('RESPONSE_FOUND', 'FALSE');
10234: end if;
10235:
10236: wf_event_ojmstext_qh.enqueue( l_event, l_agent);
10237:
10238: else
10239: -- default synchronous processing
10240: wf_notification.respond(nid, respond_comment, responder, action_source);