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

Line 580: wf_event.raise('oracle.apps.fnd.security.user.assignment.change',

576: p_creationDate => sysdate, /*Bug3626390 sysdate*/
577: p_lastUpdatedate=> sysdate,
578: p_assignmentReason=>description);
579:
580: wf_event.raise('oracle.apps.fnd.security.user.assignment.change',
581: Insert_Assignment.user_id||':'||
582: Insert_Assignment.responsibility_id,
583: null, null);
584: --we have to raise a differnt event as for USER_INFO_CACHE

Line 586: wf_event.addparametertolist(p_name => 'FND_USER_ID',

582: Insert_Assignment.responsibility_id,
583: null, null);
584: --we have to raise a differnt event as for USER_INFO_CACHE
585: --the key should be just the user_id
586: wf_event.addparametertolist(p_name => 'FND_USER_ID',
587: p_value => Insert_Assignment.user_id,
588: p_parameterlist => l_parameters);
589:
590: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',

Line 590: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',

586: wf_event.addparametertolist(p_name => 'FND_USER_ID',
587: p_value => Insert_Assignment.user_id,
588: p_parameterlist => l_parameters);
589:
590: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',
591: p_value => Insert_Assignment.responsibility_id,
592: p_parameterlist => l_parameters);
593:
594: wf_event.addparametertolist(p_name => 'FND_APPS_SHORT_NAME',

Line 594: wf_event.addparametertolist(p_name => 'FND_APPS_SHORT_NAME',

590: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',
591: p_value => Insert_Assignment.responsibility_id,
592: p_parameterlist => l_parameters);
593:
594: wf_event.addparametertolist(p_name => 'FND_APPS_SHORT_NAME',
595: p_value => appsname,
596: p_parameterlist => l_parameters);
597:
598: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_APPS_ID',

Line 598: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_APPS_ID',

594: wf_event.addparametertolist(p_name => 'FND_APPS_SHORT_NAME',
595: p_value => appsname,
596: p_parameterlist => l_parameters);
597:
598: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_APPS_ID',
599: p_value => Insert_Assignment.responsibility_application_id,
600: p_parameterlist => l_parameters);
601:
602: wf_event.raise(p_event_name => 'oracle.apps.fnd.user.role.insert',

Line 602: wf_event.raise(p_event_name => 'oracle.apps.fnd.user.role.insert',

598: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_APPS_ID',
599: p_value => Insert_Assignment.responsibility_application_id,
600: p_parameterlist => l_parameters);
601:
602: wf_event.raise(p_event_name => 'oracle.apps.fnd.user.role.insert',
603: p_event_key => to_char(Insert_Assignment.user_id)||':'||to_char(Insert_Assignment.responsibility_id)||':'||appsname||':'||to_char(Insert_Assignment.responsibility_application_id),
604: p_event_data => NULL,
605: p_parameters => l_parameters,
606: p_send_date => Sysdate);

Line 809: wf_event.raise('oracle.apps.fnd.security.user.assignment.change',

805: p_assignmentReason=>description,
806: p_updatewho => l_update_who); -- Bug5467610
807:
808:
809: wf_event.raise('oracle.apps.fnd.security.user.assignment.change',
810: Update_Assignment.user_id||':'||
811: Update_Assignment.responsibility_id,
812: null, null);
813: --Raise the invalidation event attached to the USER_INFO_CACHE

Line 817: --subscriptions are attcahed to the wf event.

813: --Raise the invalidation event attached to the USER_INFO_CACHE
814: --(ideally this should be done by the wf API once the propagation
815: --has been sucessful) / or if they are not doing it then we should attach
816: --our business event to the CACHE as we do not really know what
817: --subscriptions are attcahed to the wf event.
818: --o.k putting our event (but we need to change the b3664848.ldt
819: --and the event-subscription file to attach this event to the
820: --bes control group.
821: wf_event.addparametertolist(p_name => 'FND_USER_ID',

Line 821: wf_event.addparametertolist(p_name => 'FND_USER_ID',

817: --subscriptions are attcahed to the wf event.
818: --o.k putting our event (but we need to change the b3664848.ldt
819: --and the event-subscription file to attach this event to the
820: --bes control group.
821: wf_event.addparametertolist(p_name => 'FND_USER_ID',
822: p_value => Update_Assignment.user_id,
823: p_parameterlist => l_parameters);
824:
825: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',

Line 825: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',

821: wf_event.addparametertolist(p_name => 'FND_USER_ID',
822: p_value => Update_Assignment.user_id,
823: p_parameterlist => l_parameters);
824:
825: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',
826: p_value => Update_Assignment.responsibility_id,
827: p_parameterlist => l_parameters);
828:
829: wf_event.addparametertolist(p_name => 'FND_APPS_SHORT_NAME',

Line 829: wf_event.addparametertolist(p_name => 'FND_APPS_SHORT_NAME',

825: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',
826: p_value => Update_Assignment.responsibility_id,
827: p_parameterlist => l_parameters);
828:
829: wf_event.addparametertolist(p_name => 'FND_APPS_SHORT_NAME',
830: p_value => appsname,
831: p_parameterlist => l_parameters);
832:
833: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_APPS_ID',

Line 833: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_APPS_ID',

829: wf_event.addparametertolist(p_name => 'FND_APPS_SHORT_NAME',
830: p_value => appsname,
831: p_parameterlist => l_parameters);
832:
833: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_APPS_ID',
834: p_value => Update_Assignment.responsibility_application_id,
835: p_parameterlist => l_parameters);
836:
837: wf_event.raise(p_event_name => 'oracle.apps.fnd.user.role.update',

Line 837: wf_event.raise(p_event_name => 'oracle.apps.fnd.user.role.update',

833: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_APPS_ID',
834: p_value => Update_Assignment.responsibility_application_id,
835: p_parameterlist => l_parameters);
836:
837: wf_event.raise(p_event_name => 'oracle.apps.fnd.user.role.update',
838: p_event_key => to_char(Update_Assignment.user_id)||':'||to_char(Update_Assignment.responsibility_id)||':'||appsname||':'||to_char(Update_Assignment.responsibility_application_id),
839: p_event_data => NULL,
840: p_parameters => l_parameters,
841: p_send_date => Sysdate);

Line 1198: wf_event.AddParameterToList('USER_NAME',

1194: -- Insert or update role in workflow.
1195: -- Need to do this even if role already exists, to update
1196: -- attribute values.
1197: wf_parameters := NULL;
1198: wf_event.AddParameterToList('USER_NAME',
1199: role_name , wf_parameters);
1200: if(secgrpkey = 'STANDARD') then
1201: role_display_name := resp_name;
1202: else

Line 1206: wf_event.AddParameterToList('DISPLAYNAME',

1202: else
1203: role_display_name := resp_name||':'||secgrp_name;
1204: end if;
1205:
1206: wf_event.AddParameterToList('DISPLAYNAME',
1207: role_display_name, wf_parameters);
1208: wf_event.AddParameterToList('DESCRIPTION',
1209: descr, wf_parameters);
1210: wf_event.AddParameterToList('OWNER_TAG',

Line 1208: wf_event.AddParameterToList('DESCRIPTION',

1204: end if;
1205:
1206: wf_event.AddParameterToList('DISPLAYNAME',
1207: role_display_name, wf_parameters);
1208: wf_event.AddParameterToList('DESCRIPTION',
1209: descr, wf_parameters);
1210: wf_event.AddParameterToList('OWNER_TAG',
1211: applsname, wf_parameters);
1212: wf_event.AddParameterToList('RAISEERRORS',

Line 1210: wf_event.AddParameterToList('OWNER_TAG',

1206: wf_event.AddParameterToList('DISPLAYNAME',
1207: role_display_name, wf_parameters);
1208: wf_event.AddParameterToList('DESCRIPTION',
1209: descr, wf_parameters);
1210: wf_event.AddParameterToList('OWNER_TAG',
1211: applsname, wf_parameters);
1212: wf_event.AddParameterToList('RAISEERRORS',
1213: 'TRUE', wf_parameters);
1214:

Line 1212: wf_event.AddParameterToList('RAISEERRORS',

1208: wf_event.AddParameterToList('DESCRIPTION',
1209: descr, wf_parameters);
1210: wf_event.AddParameterToList('OWNER_TAG',
1211: applsname, wf_parameters);
1212: wf_event.AddParameterToList('RAISEERRORS',
1213: 'TRUE', wf_parameters);
1214:
1215: -- Bug4507634 added WFSYNCH_OVERWRITE and ORCLISENABLED parameters.
1216:

Line 1217: wf_event.AddParameterToList('WFSYNCH_OVERWRITE',

1213: 'TRUE', wf_parameters);
1214:
1215: -- Bug4507634 added WFSYNCH_OVERWRITE and ORCLISENABLED parameters.
1216:
1217: wf_event.AddParameterToList('WFSYNCH_OVERWRITE',
1218: 'TRUE', wf_parameters);
1219: if ((my_exp is null) OR
1220: (trunc(sysdate) between my_start and my_exp)) then
1221: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', wf_parameters);

Line 1221: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', wf_parameters);

1217: wf_event.AddParameterToList('WFSYNCH_OVERWRITE',
1218: 'TRUE', wf_parameters);
1219: if ((my_exp is null) OR
1220: (trunc(sysdate) between my_start and my_exp)) then
1221: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', wf_parameters);
1222: else
1223: wf_event.AddParameterToList('ORCLISENABLED', 'INACTIVE', wf_parameters);
1224: end if;
1225:

Line 1223: wf_event.AddParameterToList('ORCLISENABLED', 'INACTIVE', wf_parameters);

1219: if ((my_exp is null) OR
1220: (trunc(sysdate) between my_start and my_exp)) then
1221: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', wf_parameters);
1222: else
1223: wf_event.AddParameterToList('ORCLISENABLED', 'INACTIVE', wf_parameters);
1224: end if;
1225:
1226: -- Bug4864465 Adding the WHO column values to be propagated.
1227:

Line 1228: wf_event.AddParameterToList('LAST_UPDATED_BY',my_lastupdatedby,wf_parameters);

1224: end if;
1225:
1226: -- Bug4864465 Adding the WHO column values to be propagated.
1227:
1228: wf_event.AddParameterToList('LAST_UPDATED_BY',my_lastupdatedby,wf_parameters);
1229:
1230: -- Bug5729583 - Updated date values to use WF_CORE.canonical_date_mask.
1231:
1232: wf_event.AddParameterToList('LAST_UPDATE_DATE',

Line 1232: wf_event.AddParameterToList('LAST_UPDATE_DATE',

1228: wf_event.AddParameterToList('LAST_UPDATED_BY',my_lastupdatedby,wf_parameters);
1229:
1230: -- Bug5729583 - Updated date values to use WF_CORE.canonical_date_mask.
1231:
1232: wf_event.AddParameterToList('LAST_UPDATE_DATE',
1233: to_char(my_lastupdatedate,WF_CORE.canonical_date_mask),wf_parameters);
1234: wf_event.AddParameterToList('CREATED_BY',my_createdby,wf_parameters);
1235:
1236: -- Bug5729583 - Updated date values to use WF_CORE.canonical_date_mask.

Line 1234: wf_event.AddParameterToList('CREATED_BY',my_createdby,wf_parameters);

1230: -- Bug5729583 - Updated date values to use WF_CORE.canonical_date_mask.
1231:
1232: wf_event.AddParameterToList('LAST_UPDATE_DATE',
1233: to_char(my_lastupdatedate,WF_CORE.canonical_date_mask),wf_parameters);
1234: wf_event.AddParameterToList('CREATED_BY',my_createdby,wf_parameters);
1235:
1236: -- Bug5729583 - Updated date values to use WF_CORE.canonical_date_mask.
1237:
1238: wf_event.AddParameterToList('CREATION_DATE',to_char(my_creationdate,WF_CORE.canonical_date_mask),wf_parameters);

Line 1238: wf_event.AddParameterToList('CREATION_DATE',to_char(my_creationdate,WF_CORE.canonical_date_mask),wf_parameters);

1234: wf_event.AddParameterToList('CREATED_BY',my_createdby,wf_parameters);
1235:
1236: -- Bug5729583 - Updated date values to use WF_CORE.canonical_date_mask.
1237:
1238: wf_event.AddParameterToList('CREATION_DATE',to_char(my_creationdate,WF_CORE.canonical_date_mask),wf_parameters);
1239: wf_event.AddParameterToList('LAST_UPDATE_LOGIN',
1240: my_lastupdatelogin,wf_parameters);
1241:
1242: wf_local_synch.propagate_role(p_orig_system=>'FND_RESP',

Line 1239: wf_event.AddParameterToList('LAST_UPDATE_LOGIN',

1235:
1236: -- Bug5729583 - Updated date values to use WF_CORE.canonical_date_mask.
1237:
1238: wf_event.AddParameterToList('CREATION_DATE',to_char(my_creationdate,WF_CORE.canonical_date_mask),wf_parameters);
1239: wf_event.AddParameterToList('LAST_UPDATE_LOGIN',
1240: my_lastupdatelogin,wf_parameters);
1241:
1242: wf_local_synch.propagate_role(p_orig_system=>'FND_RESP',
1243: p_orig_system_id=>respid,

Line 1250: wf_event.AddParameterToList('USER_NAME',

1246: p_expiration_date=>enddate);
1247:
1248: -- Insert or update role in workflow for old_rolename.
1249: wf_parameters := NULL;
1250: wf_event.AddParameterToList('USER_NAME',
1251: old_rolename , wf_parameters);
1252:
1253: role_display_name := resp_name||':Any security group';
1254:

Line 1255: wf_event.AddParameterToList('DISPLAYNAME',

1251: old_rolename , wf_parameters);
1252:
1253: role_display_name := resp_name||':Any security group';
1254:
1255: wf_event.AddParameterToList('DISPLAYNAME',
1256: role_display_name, wf_parameters);
1257: wf_event.AddParameterToList('DESCRIPTION',
1258: descr, wf_parameters);
1259: wf_event.AddParameterToList('OWNER_TAG',

Line 1257: wf_event.AddParameterToList('DESCRIPTION',

1253: role_display_name := resp_name||':Any security group';
1254:
1255: wf_event.AddParameterToList('DISPLAYNAME',
1256: role_display_name, wf_parameters);
1257: wf_event.AddParameterToList('DESCRIPTION',
1258: descr, wf_parameters);
1259: wf_event.AddParameterToList('OWNER_TAG',
1260: applsname, wf_parameters);
1261: wf_event.AddParameterToList('RAISEERRORS',

Line 1259: wf_event.AddParameterToList('OWNER_TAG',

1255: wf_event.AddParameterToList('DISPLAYNAME',
1256: role_display_name, wf_parameters);
1257: wf_event.AddParameterToList('DESCRIPTION',
1258: descr, wf_parameters);
1259: wf_event.AddParameterToList('OWNER_TAG',
1260: applsname, wf_parameters);
1261: wf_event.AddParameterToList('RAISEERRORS',
1262: 'TRUE', wf_parameters);
1263:

Line 1261: wf_event.AddParameterToList('RAISEERRORS',

1257: wf_event.AddParameterToList('DESCRIPTION',
1258: descr, wf_parameters);
1259: wf_event.AddParameterToList('OWNER_TAG',
1260: applsname, wf_parameters);
1261: wf_event.AddParameterToList('RAISEERRORS',
1262: 'TRUE', wf_parameters);
1263:
1264: -- Bug4507634 added WFSYNCH_OVERWRITE parameter.
1265:

Line 1266: wf_event.AddParameterToList('WFSYNCH_OVERWRITE',

1262: 'TRUE', wf_parameters);
1263:
1264: -- Bug4507634 added WFSYNCH_OVERWRITE parameter.
1265:
1266: wf_event.AddParameterToList('WFSYNCH_OVERWRITE',
1267: 'TRUE', wf_parameters);
1268:
1269: -- Bug4699363 added parameter for ORCLISENABLED.
1270:

Line 1273: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', wf_parameters);

1269: -- Bug4699363 added parameter for ORCLISENABLED.
1270:
1271: if ((my_exp is null) OR
1272: (trunc(sysdate) between my_start and my_exp)) then
1273: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', wf_parameters);
1274: else
1275: wf_event.AddParameterToList('ORCLISENABLED', 'INACTIVE', wf_parameters);
1276: end if;
1277:

Line 1275: wf_event.AddParameterToList('ORCLISENABLED', 'INACTIVE', wf_parameters);

1271: if ((my_exp is null) OR
1272: (trunc(sysdate) between my_start and my_exp)) then
1273: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', wf_parameters);
1274: else
1275: wf_event.AddParameterToList('ORCLISENABLED', 'INACTIVE', wf_parameters);
1276: end if;
1277:
1278: -- Bug4864465 Adding the WHO column values to be propagated.
1279:

Line 1280: wf_event.AddParameterToList('LAST_UPDATED_BY',my_lastupdatedby,wf_parameters);

1276: end if;
1277:
1278: -- Bug4864465 Adding the WHO column values to be propagated.
1279:
1280: wf_event.AddParameterToList('LAST_UPDATED_BY',my_lastupdatedby,wf_parameters);
1281:
1282: -- Bug5729583 - Updated date values to use WF_CORE.canonical_date_mask.
1283:
1284: wf_event.AddParameterToList('LAST_UPDATE_DATE',

Line 1284: wf_event.AddParameterToList('LAST_UPDATE_DATE',

1280: wf_event.AddParameterToList('LAST_UPDATED_BY',my_lastupdatedby,wf_parameters);
1281:
1282: -- Bug5729583 - Updated date values to use WF_CORE.canonical_date_mask.
1283:
1284: wf_event.AddParameterToList('LAST_UPDATE_DATE',
1285: to_char(my_lastupdatedate,WF_CORE.canonical_date_mask), wf_parameters);
1286: wf_event.AddParameterToList('CREATED_BY',my_createdby, wf_parameters);
1287: wf_event.AddParameterToList('CREATION_DATE',to_char(my_creationdate,WF_CORE.canonical_date_mask),wf_parameters);
1288: wf_event.AddParameterToList('LAST_UPDATE_LOGIN',

Line 1286: wf_event.AddParameterToList('CREATED_BY',my_createdby, wf_parameters);

1282: -- Bug5729583 - Updated date values to use WF_CORE.canonical_date_mask.
1283:
1284: wf_event.AddParameterToList('LAST_UPDATE_DATE',
1285: to_char(my_lastupdatedate,WF_CORE.canonical_date_mask), wf_parameters);
1286: wf_event.AddParameterToList('CREATED_BY',my_createdby, wf_parameters);
1287: wf_event.AddParameterToList('CREATION_DATE',to_char(my_creationdate,WF_CORE.canonical_date_mask),wf_parameters);
1288: wf_event.AddParameterToList('LAST_UPDATE_LOGIN',
1289: my_lastupdatelogin, wf_parameters);
1290:

Line 1287: wf_event.AddParameterToList('CREATION_DATE',to_char(my_creationdate,WF_CORE.canonical_date_mask),wf_parameters);

1283:
1284: wf_event.AddParameterToList('LAST_UPDATE_DATE',
1285: to_char(my_lastupdatedate,WF_CORE.canonical_date_mask), wf_parameters);
1286: wf_event.AddParameterToList('CREATED_BY',my_createdby, wf_parameters);
1287: wf_event.AddParameterToList('CREATION_DATE',to_char(my_creationdate,WF_CORE.canonical_date_mask),wf_parameters);
1288: wf_event.AddParameterToList('LAST_UPDATE_LOGIN',
1289: my_lastupdatelogin, wf_parameters);
1290:
1291: wf_local_synch.propagate_role(p_orig_system=>'FND_RESP'||appid,

Line 1288: wf_event.AddParameterToList('LAST_UPDATE_LOGIN',

1284: wf_event.AddParameterToList('LAST_UPDATE_DATE',
1285: to_char(my_lastupdatedate,WF_CORE.canonical_date_mask), wf_parameters);
1286: wf_event.AddParameterToList('CREATED_BY',my_createdby, wf_parameters);
1287: wf_event.AddParameterToList('CREATION_DATE',to_char(my_creationdate,WF_CORE.canonical_date_mask),wf_parameters);
1288: wf_event.AddParameterToList('LAST_UPDATE_LOGIN',
1289: my_lastupdatelogin, wf_parameters);
1290:
1291: wf_local_synch.propagate_role(p_orig_system=>'FND_RESP'||appid,
1292: p_orig_system_id=>respid,