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

APPS.WF_DIRECTORY dependencies on WF_EVENT

Line 2334: event wf_event_t;

2330: l_lastupddt date;
2331: l_lastupdby number;
2332: l_creatby number;
2333: l_lastupdlog number;
2334: event wf_event_t;
2335: result varchar2(10);
2336: sub_id raw(20);
2337: begin
2338: if ((user_orig_system is NULL) or (user_orig_system_id is NULL) or

Line 2531: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);

2527: ) returning rowid into l_affectedRow;
2528:
2529: --We were able to insert the record, so we will raise the created event
2530: --Build parameter list.
2531: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);
2532: WF_EVENT.AddParameterToList('USER_NAME', CreateUserRole.user_name, l_params);
2533: WF_EVENT.AddParameterToList('ROLE_NAME', CreateUserRole.role_name, l_params);
2534: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2535: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);

Line 2532: WF_EVENT.AddParameterToList('USER_NAME', CreateUserRole.user_name, l_params);

2528:
2529: --We were able to insert the record, so we will raise the created event
2530: --Build parameter list.
2531: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);
2532: WF_EVENT.AddParameterToList('USER_NAME', CreateUserRole.user_name, l_params);
2533: WF_EVENT.AddParameterToList('ROLE_NAME', CreateUserRole.role_name, l_params);
2534: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2535: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);
2536: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);

Line 2533: WF_EVENT.AddParameterToList('ROLE_NAME', CreateUserRole.role_name, l_params);

2529: --We were able to insert the record, so we will raise the created event
2530: --Build parameter list.
2531: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);
2532: WF_EVENT.AddParameterToList('USER_NAME', CreateUserRole.user_name, l_params);
2533: WF_EVENT.AddParameterToList('ROLE_NAME', CreateUserRole.role_name, l_params);
2534: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2535: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);
2536: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2537: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', l_rorigSysID, l_params);

Line 2534: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);

2530: --Build parameter list.
2531: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);
2532: WF_EVENT.AddParameterToList('USER_NAME', CreateUserRole.user_name, l_params);
2533: WF_EVENT.AddParameterToList('ROLE_NAME', CreateUserRole.role_name, l_params);
2534: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2535: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);
2536: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2537: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', l_rorigSysID, l_params);
2538: WF_EVENT.AddParameterToList('START_DATE',

Line 2535: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);

2531: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);
2532: WF_EVENT.AddParameterToList('USER_NAME', CreateUserRole.user_name, l_params);
2533: WF_EVENT.AddParameterToList('ROLE_NAME', CreateUserRole.role_name, l_params);
2534: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2535: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);
2536: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2537: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', l_rorigSysID, l_params);
2538: WF_EVENT.AddParameterToList('START_DATE',
2539: to_char(trunc(CreateUserRole.start_date),

Line 2536: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);

2532: WF_EVENT.AddParameterToList('USER_NAME', CreateUserRole.user_name, l_params);
2533: WF_EVENT.AddParameterToList('ROLE_NAME', CreateUserRole.role_name, l_params);
2534: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2535: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);
2536: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2537: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', l_rorigSysID, l_params);
2538: WF_EVENT.AddParameterToList('START_DATE',
2539: to_char(trunc(CreateUserRole.start_date),
2540: WF_CORE.Canonical_Date_Mask),

Line 2537: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', l_rorigSysID, l_params);

2533: WF_EVENT.AddParameterToList('ROLE_NAME', CreateUserRole.role_name, l_params);
2534: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2535: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);
2536: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2537: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', l_rorigSysID, l_params);
2538: WF_EVENT.AddParameterToList('START_DATE',
2539: to_char(trunc(CreateUserRole.start_date),
2540: WF_CORE.Canonical_Date_Mask),
2541: l_params);

Line 2538: WF_EVENT.AddParameterToList('START_DATE',

2534: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2535: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);
2536: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2537: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', l_rorigSysID, l_params);
2538: WF_EVENT.AddParameterToList('START_DATE',
2539: to_char(trunc(CreateUserRole.start_date),
2540: WF_CORE.Canonical_Date_Mask),
2541: l_params);
2542: WF_EVENT.AddParameterToList('END_DATE',

Line 2542: WF_EVENT.AddParameterToList('END_DATE',

2538: WF_EVENT.AddParameterToList('START_DATE',
2539: to_char(trunc(CreateUserRole.start_date),
2540: WF_CORE.Canonical_Date_Mask),
2541: l_params);
2542: WF_EVENT.AddParameterToList('END_DATE',
2543: to_char(trunc(CreateUserRole.end_date),
2544: WF_CORE.Canonical_Date_Mask),
2545: l_params);
2546:

Line 2547: WF_EVENT.AddParameterToList('CREATED_BY',

2543: to_char(trunc(CreateUserRole.end_date),
2544: WF_CORE.Canonical_Date_Mask),
2545: l_params);
2546:
2547: WF_EVENT.AddParameterToList('CREATED_BY',
2548: to_char(CreateUserRole.created_by,
2549: WF_CORE.canonical_number_mask), l_params);
2550:
2551: WF_EVENT.AddParameterToList('CREATION_DATE',

Line 2551: WF_EVENT.AddParameterToList('CREATION_DATE',

2547: WF_EVENT.AddParameterToList('CREATED_BY',
2548: to_char(CreateUserRole.created_by,
2549: WF_CORE.canonical_number_mask), l_params);
2550:
2551: WF_EVENT.AddParameterToList('CREATION_DATE',
2552: to_char(CreateUserRole.creation_date,
2553: WF_CORE.canonical_date_mask), l_params);
2554:
2555: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',

Line 2555: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',

2551: WF_EVENT.AddParameterToList('CREATION_DATE',
2552: to_char(CreateUserRole.creation_date,
2553: WF_CORE.canonical_date_mask), l_params);
2554:
2555: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
2556: to_char(CreateUserRole.last_updated_by,
2557: WF_CORE.canonical_number_mask), l_params);
2558: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
2559: to_char(CreateUserRole.last_update_date,

Line 2558: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',

2554:
2555: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
2556: to_char(CreateUserRole.last_updated_by,
2557: WF_CORE.canonical_number_mask), l_params);
2558: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
2559: to_char(CreateUserRole.last_update_date,
2560: WF_CORE.canonical_date_mask), l_params);
2561: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
2562: to_char(CreateUserRole.last_update_login,

Line 2561: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',

2557: WF_CORE.canonical_number_mask), l_params);
2558: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
2559: to_char(CreateUserRole.last_update_date,
2560: WF_CORE.canonical_date_mask), l_params);
2561: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
2562: to_char(CreateUserRole.last_update_login,
2563: WF_CORE.canonical_number_mask), l_params);
2564: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',
2565: CreateUserRole.assignment_type, l_params);

Line 2564: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',

2560: WF_CORE.canonical_date_mask), l_params);
2561: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
2562: to_char(CreateUserRole.last_update_login,
2563: WF_CORE.canonical_number_mask), l_params);
2564: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',
2565: CreateUserRole.assignment_type, l_params);
2566: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
2567: CreateUserRole.parent_orig_system, l_params);
2568: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',

Line 2566: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',

2562: to_char(CreateUserRole.last_update_login,
2563: WF_CORE.canonical_number_mask), l_params);
2564: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',
2565: CreateUserRole.assignment_type, l_params);
2566: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
2567: CreateUserRole.parent_orig_system, l_params);
2568: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
2569: to_char(CreateUserRole.parent_orig_system_id,
2570: WF_CORE.canonical_number_mask), l_params);

Line 2568: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',

2564: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',
2565: CreateUserRole.assignment_type, l_params);
2566: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
2567: CreateUserRole.parent_orig_system, l_params);
2568: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
2569: to_char(CreateUserRole.parent_orig_system_id,
2570: WF_CORE.canonical_number_mask), l_params);
2571: WF_EVENT.AddParameterToList('PARTITION_ID', to_char(l_partitionID,
2572: WF_CORE.canonical_number_mask),l_params);

Line 2571: WF_EVENT.AddParameterToList('PARTITION_ID', to_char(l_partitionID,

2567: CreateUserRole.parent_orig_system, l_params);
2568: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
2569: to_char(CreateUserRole.parent_orig_system_id,
2570: WF_CORE.canonical_number_mask), l_params);
2571: WF_EVENT.AddParameterToList('PARTITION_ID', to_char(l_partitionID,
2572: WF_CORE.canonical_number_mask),l_params);
2573: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',
2574: CreateUserRole.assignment_reason, l_params);
2575: if (eventParams is not null and eventParams.count>0) then

Line 2573: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',

2569: to_char(CreateUserRole.parent_orig_system_id,
2570: WF_CORE.canonical_number_mask), l_params);
2571: WF_EVENT.AddParameterToList('PARTITION_ID', to_char(l_partitionID,
2572: WF_CORE.canonical_number_mask),l_params);
2573: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',
2574: CreateUserRole.assignment_reason, l_params);
2575: if (eventParams is not null and eventParams.count>0) then
2576: for i in eventParams.first..eventParams.last loop
2577: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),

Line 2577: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),

2573: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',
2574: CreateUserRole.assignment_reason, l_params);
2575: if (eventParams is not null and eventParams.count>0) then
2576: for i in eventParams.first..eventParams.last loop
2577: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),
2578: eventParams(i).getValue(),l_params);
2579: end loop;
2580: end if;
2581: --determine if BES is enabled

Line 2585: wf_event_t.initialize(event);

2581: --determine if BES is enabled
2582: if (wf_directory.System_Status()='DISABLED') then
2583: --Create the event that is to be raised
2584:
2585: wf_event_t.initialize(event);
2586: event.Send_Date := sysdate;
2587: event.Event_Name := 'oracle.apps.fnd.wf.ds.userRole.created';
2588: event.Event_Key := l_uOrigSys||':'||
2589: to_char(l_uOrigSysId)||'|'||

Line 2600: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.userRole.created',

2596: if (result='SUCCESS') then
2597: result:= WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF(sub_id,event);
2598: end if;
2599: else
2600: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.userRole.created',
2601: p_event_key=> l_uOrigSys||':'||
2602: to_char(l_uOrigSysId)||'|'||
2603: l_rOrigSys||':'||
2604: to_char(l_rOrigSysId)||'|'||

Line 2702: event wf_event_t;

2698: l_oldenddate date;
2699: l_UpdateWho BOOLEAN := nvl(updateWho,TRUE);
2700: l_partitionID number;
2701: l_partitionName varchar2(30);
2702: event wf_event_t;
2703: result varchar2(10);
2704: sub_id raw(20);
2705: begin
2706: -- Lookup origSys info if not provided.

Line 2881: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);

2877: --We were able to update an existing record, so we will raise the
2878: --updated event
2879:
2880: --Build parameter list.
2881: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);
2882: WF_EVENT.AddParameterToList('USER_NAME', SetUserRoleAttr.user_name,
2883: l_params);
2884: WF_EVENT.AddParameterToList('ROLE_NAME', SetUserRoleAttr.role_name,
2885: l_params);

Line 2882: WF_EVENT.AddParameterToList('USER_NAME', SetUserRoleAttr.user_name,

2878: --updated event
2879:
2880: --Build parameter list.
2881: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);
2882: WF_EVENT.AddParameterToList('USER_NAME', SetUserRoleAttr.user_name,
2883: l_params);
2884: WF_EVENT.AddParameterToList('ROLE_NAME', SetUserRoleAttr.role_name,
2885: l_params);
2886: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);

Line 2884: WF_EVENT.AddParameterToList('ROLE_NAME', SetUserRoleAttr.role_name,

2880: --Build parameter list.
2881: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);
2882: WF_EVENT.AddParameterToList('USER_NAME', SetUserRoleAttr.user_name,
2883: l_params);
2884: WF_EVENT.AddParameterToList('ROLE_NAME', SetUserRoleAttr.role_name,
2885: l_params);
2886: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2887: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', to_char(l_uorigSysID,
2888: WF_CORE.canonical_number_mask), l_params);

Line 2886: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);

2882: WF_EVENT.AddParameterToList('USER_NAME', SetUserRoleAttr.user_name,
2883: l_params);
2884: WF_EVENT.AddParameterToList('ROLE_NAME', SetUserRoleAttr.role_name,
2885: l_params);
2886: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2887: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', to_char(l_uorigSysID,
2888: WF_CORE.canonical_number_mask), l_params);
2889: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2890: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', to_char(l_rorigSysID,

Line 2887: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', to_char(l_uorigSysID,

2883: l_params);
2884: WF_EVENT.AddParameterToList('ROLE_NAME', SetUserRoleAttr.role_name,
2885: l_params);
2886: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2887: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', to_char(l_uorigSysID,
2888: WF_CORE.canonical_number_mask), l_params);
2889: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2890: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', to_char(l_rorigSysID,
2891: WF_CORE.canonical_number_mask), l_params);

Line 2889: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);

2885: l_params);
2886: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2887: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', to_char(l_uorigSysID,
2888: WF_CORE.canonical_number_mask), l_params);
2889: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2890: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', to_char(l_rorigSysID,
2891: WF_CORE.canonical_number_mask), l_params);
2892: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM', l_porigSys, l_params);
2893: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID', to_char(l_porigSysID,

Line 2890: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', to_char(l_rorigSysID,

2886: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2887: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', to_char(l_uorigSysID,
2888: WF_CORE.canonical_number_mask), l_params);
2889: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2890: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', to_char(l_rorigSysID,
2891: WF_CORE.canonical_number_mask), l_params);
2892: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM', l_porigSys, l_params);
2893: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID', to_char(l_porigSysID,
2894: WF_CORE.canonical_number_mask), l_params);

Line 2892: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM', l_porigSys, l_params);

2888: WF_CORE.canonical_number_mask), l_params);
2889: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2890: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', to_char(l_rorigSysID,
2891: WF_CORE.canonical_number_mask), l_params);
2892: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM', l_porigSys, l_params);
2893: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID', to_char(l_porigSysID,
2894: WF_CORE.canonical_number_mask), l_params);
2895: WF_EVENT.AddParameterToList('START_DATE',
2896: to_char(trunc(SetUserRoleAttr.start_date),

Line 2893: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID', to_char(l_porigSysID,

2889: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2890: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', to_char(l_rorigSysID,
2891: WF_CORE.canonical_number_mask), l_params);
2892: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM', l_porigSys, l_params);
2893: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID', to_char(l_porigSysID,
2894: WF_CORE.canonical_number_mask), l_params);
2895: WF_EVENT.AddParameterToList('START_DATE',
2896: to_char(trunc(SetUserRoleAttr.start_date),
2897: WF_CORE.canonical_date_mask),

Line 2895: WF_EVENT.AddParameterToList('START_DATE',

2891: WF_CORE.canonical_number_mask), l_params);
2892: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM', l_porigSys, l_params);
2893: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID', to_char(l_porigSysID,
2894: WF_CORE.canonical_number_mask), l_params);
2895: WF_EVENT.AddParameterToList('START_DATE',
2896: to_char(trunc(SetUserRoleAttr.start_date),
2897: WF_CORE.canonical_date_mask),
2898: l_params);
2899: WF_EVENT.AddParameterToList('END_DATE',

Line 2899: WF_EVENT.AddParameterToList('END_DATE',

2895: WF_EVENT.AddParameterToList('START_DATE',
2896: to_char(trunc(SetUserRoleAttr.start_date),
2897: WF_CORE.canonical_date_mask),
2898: l_params);
2899: WF_EVENT.AddParameterToList('END_DATE',
2900: to_char(trunc(SetUserRoleAttr.end_date),
2901: WF_CORE.canonical_date_mask),
2902: l_params);
2903:

Line 2910: WF_EVENT.AddParameterToList('OLD_START_DATE',

2906: (trunc(l_oldStartDate) <> trunc(SetUserRoleAttr.start_date))) or
2907: ((l_oldStartDate is NULL and SetUserRoleAttr.start_date is NOT NULL) or
2908: (SetUserRoleAttr.start_date is NULL and l_oldStartDate is NOT NULL))) then
2909:
2910: WF_EVENT.AddParameterToList('OLD_START_DATE',
2911: to_char(trunc(l_oldStartDate),
2912: WF_CORE.Canonical_Date_Mask),
2913: l_params);
2914: else

Line 2915: WF_EVENT.AddParameterToList('OLD_START_DATE', 'UNDEFINED',

2911: to_char(trunc(l_oldStartDate),
2912: WF_CORE.Canonical_Date_Mask),
2913: l_params);
2914: else
2915: WF_EVENT.AddParameterToList('OLD_START_DATE', '*UNDEFINED*',
2916: l_params);
2917: end if;
2918:
2919: if ((((l_oldEndDate is NOT NULL) and

Line 2926: WF_EVENT.AddParameterToList('OLD_END_DATE',

2922: ((l_oldEndDate is NULL and SetUserRoleAttr.end_date is NOT NULL)
2923: or (SetUserRoleAttr.end_date is NULL
2924: and l_oldEndDate is NOT NULL))) then
2925:
2926: WF_EVENT.AddParameterToList('OLD_END_DATE',
2927: to_char(trunc(l_oldEndDate),
2928: WF_CORE.Canonical_Date_Mask),
2929: l_params);
2930: else

Line 2931: WF_EVENT.AddParameterToList('OLD_END_DATE', 'UNDEFINED',

2927: to_char(trunc(l_oldEndDate),
2928: WF_CORE.Canonical_Date_Mask),
2929: l_params);
2930: else
2931: WF_EVENT.AddParameterToList('OLD_END_DATE', '*UNDEFINED*',
2932: l_params);
2933: end if;
2934:
2935:

Line 2936: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',

2932: l_params);
2933: end if;
2934:
2935:
2936: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
2937: to_char(SetUserRoleAttr.last_updated_by,
2938: WF_CORE.canonical_number_mask), l_params);
2939:
2940: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',

Line 2940: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',

2936: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
2937: to_char(SetUserRoleAttr.last_updated_by,
2938: WF_CORE.canonical_number_mask), l_params);
2939:
2940: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
2941: to_char(SetUserRoleAttr.last_update_date,
2942: WF_CORE.canonical_date_mask), l_params);
2943: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
2944: to_char(SetUserRoleAttr.last_update_login,

Line 2943: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',

2939:
2940: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
2941: to_char(SetUserRoleAttr.last_update_date,
2942: WF_CORE.canonical_date_mask), l_params);
2943: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
2944: to_char(SetUserRoleAttr.last_update_login,
2945: WF_CORE.canonical_number_mask), l_params);
2946:
2947: WF_EVENT.AddParameterToList('CREATED_BY',

Line 2947: WF_EVENT.AddParameterToList('CREATED_BY',

2943: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
2944: to_char(SetUserRoleAttr.last_update_login,
2945: WF_CORE.canonical_number_mask), l_params);
2946:
2947: WF_EVENT.AddParameterToList('CREATED_BY',
2948: to_char(SetUserRoleAttr.created_by,
2949: WF_CORE.canonical_number_mask), l_params);
2950:
2951: WF_EVENT.AddParameterToList('CREATION_DATE',

Line 2951: WF_EVENT.AddParameterToList('CREATION_DATE',

2947: WF_EVENT.AddParameterToList('CREATED_BY',
2948: to_char(SetUserRoleAttr.created_by,
2949: WF_CORE.canonical_number_mask), l_params);
2950:
2951: WF_EVENT.AddParameterToList('CREATION_DATE',
2952: to_char(SetUserRoleAttr.creation_date,
2953: WF_CORE.canonical_date_mask), l_params);
2954:
2955: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',

Line 2955: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',

2951: WF_EVENT.AddParameterToList('CREATION_DATE',
2952: to_char(SetUserRoleAttr.creation_date,
2953: WF_CORE.canonical_date_mask), l_params);
2954:
2955: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',
2956: SetUserRoleAttr.assignment_type, l_params);
2957:
2958: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',
2959: SetUserRoleAttr.assignment_reason, l_params);

Line 2958: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',

2954:
2955: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',
2956: SetUserRoleAttr.assignment_type, l_params);
2957:
2958: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',
2959: SetUserRoleAttr.assignment_reason, l_params);
2960:
2961: if (OverWrite) then
2962: WF_EVENT.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE',l_params );

Line 2962: WF_EVENT.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE',l_params );

2958: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',
2959: SetUserRoleAttr.assignment_reason, l_params);
2960:
2961: if (OverWrite) then
2962: WF_EVENT.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE',l_params );
2963: end if;
2964:
2965: if (l_updateWho) then
2966: WF_EVENT.AddParameterToList('UPDATE_WHO','TRUE',l_params);

Line 2966: WF_EVENT.AddParameterToList('UPDATE_WHO','TRUE',l_params);

2962: WF_EVENT.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE',l_params );
2963: end if;
2964:
2965: if (l_updateWho) then
2966: WF_EVENT.AddParameterToList('UPDATE_WHO','TRUE',l_params);
2967: end if;
2968:
2969: if (eventParams is not null and eventParams.count>0) then
2970: for i in eventParams.first..eventParams.last loop

Line 2971: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),

2967: end if;
2968:
2969: if (eventParams is not null and eventParams.count>0) then
2970: for i in eventParams.first..eventParams.last loop
2971: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),
2972: eventParams(i).getValue(),l_params);
2973: end loop;
2974: end if;
2975:

Line 2980: wf_event_t.initialize(event);

2976: --determine if BES is enabled
2977: if (wf_directory.System_Status()='DISABLED') then
2978: --Create the event that is to be raised
2979:
2980: wf_event_t.initialize(event);
2981: event.Send_Date := sysdate;
2982: event.Event_Name := 'oracle.apps.fnd.wf.ds.userRole.updated';
2983: event.Event_Key := l_uOrigSys||':'||
2984: to_char(l_uOrigSysId)||'|'||

Line 2996: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.userRole.updated',

2992: if (result='SUCCESS') then
2993: result:= WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF(sub_id,event);
2994: end if;
2995: else
2996: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.userRole.updated',
2997: p_event_key=> l_uOrigSys||':'||
2998: to_char(l_uOrigSysId)||'|'||
2999: l_rOrigSys||':'||
3000: to_char(l_rOrigSysId)||'|'||

Line 3604: WF_EVENT.AddParameterToList('USER_NAME', SetUserAttr.user_name, l_params);

3600: end if;
3601:
3602: --We were able to update the record, so we will raise the updated event
3603: --Build parameter list.
3604: WF_EVENT.AddParameterToList('USER_NAME', SetUserAttr.user_name, l_params);
3605: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetUserAttr.orig_system,
3606: l_params);
3607: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
3608: to_char(SetUserAttr.orig_system_id), l_params);

Line 3605: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetUserAttr.orig_system,

3601:
3602: --We were able to update the record, so we will raise the updated event
3603: --Build parameter list.
3604: WF_EVENT.AddParameterToList('USER_NAME', SetUserAttr.user_name, l_params);
3605: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetUserAttr.orig_system,
3606: l_params);
3607: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
3608: to_char(SetUserAttr.orig_system_id), l_params);
3609: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetUserAttr.display_name,

Line 3607: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',

3603: --Build parameter list.
3604: WF_EVENT.AddParameterToList('USER_NAME', SetUserAttr.user_name, l_params);
3605: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetUserAttr.orig_system,
3606: l_params);
3607: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
3608: to_char(SetUserAttr.orig_system_id), l_params);
3609: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetUserAttr.display_name,
3610: l_params);
3611: WF_EVENT.AddParameterToList('DESCRIPTION', SetUserAttr.description,

Line 3609: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetUserAttr.display_name,

3605: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetUserAttr.orig_system,
3606: l_params);
3607: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
3608: to_char(SetUserAttr.orig_system_id), l_params);
3609: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetUserAttr.display_name,
3610: l_params);
3611: WF_EVENT.AddParameterToList('DESCRIPTION', SetUserAttr.description,
3612: l_params);
3613: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',

Line 3611: WF_EVENT.AddParameterToList('DESCRIPTION', SetUserAttr.description,

3607: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
3608: to_char(SetUserAttr.orig_system_id), l_params);
3609: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetUserAttr.display_name,
3610: l_params);
3611: WF_EVENT.AddParameterToList('DESCRIPTION', SetUserAttr.description,
3612: l_params);
3613: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
3614: SetUserAttr.notification_preference, l_params);
3615: WF_EVENT.AddParameterToList('LANGUAGE', SetUserAttr.language, l_params);

Line 3613: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',

3609: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetUserAttr.display_name,
3610: l_params);
3611: WF_EVENT.AddParameterToList('DESCRIPTION', SetUserAttr.description,
3612: l_params);
3613: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
3614: SetUserAttr.notification_preference, l_params);
3615: WF_EVENT.AddParameterToList('LANGUAGE', SetUserAttr.language, l_params);
3616: WF_EVENT.AddParameterToList('TERRITORY', SetUserAttr.territory, l_params);
3617: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetUserAttr.email_address,

Line 3615: WF_EVENT.AddParameterToList('LANGUAGE', SetUserAttr.language, l_params);

3611: WF_EVENT.AddParameterToList('DESCRIPTION', SetUserAttr.description,
3612: l_params);
3613: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
3614: SetUserAttr.notification_preference, l_params);
3615: WF_EVENT.AddParameterToList('LANGUAGE', SetUserAttr.language, l_params);
3616: WF_EVENT.AddParameterToList('TERRITORY', SetUserAttr.territory, l_params);
3617: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetUserAttr.email_address,
3618: l_params);
3619: WF_EVENT.AddParameterToList('FAX', SetUserAttr.fax, l_params);

Line 3616: WF_EVENT.AddParameterToList('TERRITORY', SetUserAttr.territory, l_params);

3612: l_params);
3613: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
3614: SetUserAttr.notification_preference, l_params);
3615: WF_EVENT.AddParameterToList('LANGUAGE', SetUserAttr.language, l_params);
3616: WF_EVENT.AddParameterToList('TERRITORY', SetUserAttr.territory, l_params);
3617: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetUserAttr.email_address,
3618: l_params);
3619: WF_EVENT.AddParameterToList('FAX', SetUserAttr.fax, l_params);
3620: WF_EVENT.AddParameterToList('EXPIRATION_DATE',

Line 3617: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetUserAttr.email_address,

3613: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
3614: SetUserAttr.notification_preference, l_params);
3615: WF_EVENT.AddParameterToList('LANGUAGE', SetUserAttr.language, l_params);
3616: WF_EVENT.AddParameterToList('TERRITORY', SetUserAttr.territory, l_params);
3617: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetUserAttr.email_address,
3618: l_params);
3619: WF_EVENT.AddParameterToList('FAX', SetUserAttr.fax, l_params);
3620: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
3621: to_char(trunc(SetUserAttr.expiration_date),

Line 3619: WF_EVENT.AddParameterToList('FAX', SetUserAttr.fax, l_params);

3615: WF_EVENT.AddParameterToList('LANGUAGE', SetUserAttr.language, l_params);
3616: WF_EVENT.AddParameterToList('TERRITORY', SetUserAttr.territory, l_params);
3617: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetUserAttr.email_address,
3618: l_params);
3619: WF_EVENT.AddParameterToList('FAX', SetUserAttr.fax, l_params);
3620: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
3621: to_char(trunc(SetUserAttr.expiration_date),
3622: WF_CORE.Canonical_Date_Mask),
3623: l_params);

Line 3620: WF_EVENT.AddParameterToList('EXPIRATION_DATE',

3616: WF_EVENT.AddParameterToList('TERRITORY', SetUserAttr.territory, l_params);
3617: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetUserAttr.email_address,
3618: l_params);
3619: WF_EVENT.AddParameterToList('FAX', SetUserAttr.fax, l_params);
3620: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
3621: to_char(trunc(SetUserAttr.expiration_date),
3622: WF_CORE.Canonical_Date_Mask),
3623: l_params);
3624: WF_EVENT.AddParameterToList('STATUS', SetUserAttr.status, l_params);

Line 3624: WF_EVENT.AddParameterToList('STATUS', SetUserAttr.status, l_params);

3620: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
3621: to_char(trunc(SetUserAttr.expiration_date),
3622: WF_CORE.Canonical_Date_Mask),
3623: l_params);
3624: WF_EVENT.AddParameterToList('STATUS', SetUserAttr.status, l_params);
3625: WF_EVENT.AddParameterToList('START_DATE',
3626: to_char(trunc(SetUserAttr.start_date),
3627: WF_CORE.Canonical_Date_Mask),
3628: l_params);

Line 3625: WF_EVENT.AddParameterToList('START_DATE',

3621: to_char(trunc(SetUserAttr.expiration_date),
3622: WF_CORE.Canonical_Date_Mask),
3623: l_params);
3624: WF_EVENT.AddParameterToList('STATUS', SetUserAttr.status, l_params);
3625: WF_EVENT.AddParameterToList('START_DATE',
3626: to_char(trunc(SetUserAttr.start_date),
3627: WF_CORE.Canonical_Date_Mask),
3628: l_params);
3629: if ((((l_oldStartDate is NOT NULL) and

Line 3635: WF_EVENT.AddParameterToList('OLD_START_DATE',

3631: (trunc(l_oldStartDate) <> trunc(SetUserAttr.start_date))) or
3632: ((l_oldStartDate is NULL and SetUserAttr.start_date is NOT NULL) or
3633: (SetUserAttr.start_date is NULL and l_oldStartDate is NOT NULL))) then
3634:
3635: WF_EVENT.AddParameterToList('OLD_START_DATE',
3636: to_char(trunc(l_oldStartDate),
3637: WF_CORE.Canonical_Date_Mask),
3638: l_params);
3639: else

Line 3640: WF_EVENT.AddParameterToList('OLD_START_DATE', 'UNDEFINED',

3636: to_char(trunc(l_oldStartDate),
3637: WF_CORE.Canonical_Date_Mask),
3638: l_params);
3639: else
3640: WF_EVENT.AddParameterToList('OLD_START_DATE', '*UNDEFINED*',
3641: l_params);
3642: end if;
3643:
3644: if ((((l_oldEndDate is NOT NULL) and

Line 3651: WF_EVENT.AddParameterToList('OLD_END_DATE',

3647: ((l_oldEndDate is NULL and SetUserAttr.expiration_date is NOT NULL)
3648: or (SetUserAttr.expiration_date is NULL
3649: and l_oldEndDate is NOT NULL))) then
3650:
3651: WF_EVENT.AddParameterToList('OLD_END_DATE',
3652: to_char(trunc(l_oldEndDate),
3653: WF_CORE.Canonical_Date_Mask),
3654: l_params);
3655: else

Line 3656: WF_EVENT.AddParameterToList('OLD_END_DATE', 'UNDEFINED',

3652: to_char(trunc(l_oldEndDate),
3653: WF_CORE.Canonical_Date_Mask),
3654: l_params);
3655: else
3656: WF_EVENT.AddParameterToList('OLD_END_DATE', '*UNDEFINED*',
3657: l_params);
3658: end if;
3659:
3660: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',

Line 3660: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',

3656: WF_EVENT.AddParameterToList('OLD_END_DATE', '*UNDEFINED*',
3657: l_params);
3658: end if;
3659:
3660: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
3661: SetUserAttr.parent_orig_system, l_params);
3662: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
3663: to_char(SetUserAttr.parent_orig_system_id ,
3664: WF_CORE.canonical_number_mask), l_params);

Line 3662: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',

3658: end if;
3659:
3660: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
3661: SetUserAttr.parent_orig_system, l_params);
3662: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
3663: to_char(SetUserAttr.parent_orig_system_id ,
3664: WF_CORE.canonical_number_mask), l_params);
3665: WF_EVENT.AddParameterToList('OWNER_TAG', SetUserAttr.owner_tag, l_params);
3666: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',

Line 3665: WF_EVENT.AddParameterToList('OWNER_TAG', SetUserAttr.owner_tag, l_params);

3661: SetUserAttr.parent_orig_system, l_params);
3662: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
3663: to_char(SetUserAttr.parent_orig_system_id ,
3664: WF_CORE.canonical_number_mask), l_params);
3665: WF_EVENT.AddParameterToList('OWNER_TAG', SetUserAttr.owner_tag, l_params);
3666: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
3667: to_char(SetUserAttr.last_updated_by,
3668: WF_CORE.canonical_number_mask), l_params);
3669: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',

Line 3666: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',

3662: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
3663: to_char(SetUserAttr.parent_orig_system_id ,
3664: WF_CORE.canonical_number_mask), l_params);
3665: WF_EVENT.AddParameterToList('OWNER_TAG', SetUserAttr.owner_tag, l_params);
3666: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
3667: to_char(SetUserAttr.last_updated_by,
3668: WF_CORE.canonical_number_mask), l_params);
3669: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
3670: to_char(SetUserAttr.last_update_date,

Line 3669: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',

3665: WF_EVENT.AddParameterToList('OWNER_TAG', SetUserAttr.owner_tag, l_params);
3666: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
3667: to_char(SetUserAttr.last_updated_by,
3668: WF_CORE.canonical_number_mask), l_params);
3669: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
3670: to_char(SetUserAttr.last_update_date,
3671: WF_CORE.canonical_date_mask), l_params);
3672: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
3673: to_char(SetUserAttr.last_update_login ,

Line 3672: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',

3668: WF_CORE.canonical_number_mask), l_params);
3669: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
3670: to_char(SetUserAttr.last_update_date,
3671: WF_CORE.canonical_date_mask), l_params);
3672: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
3673: to_char(SetUserAttr.last_update_login ,
3674: WF_CORE.canonical_number_mask), l_params);
3675: WF_EVENT.AddParameterToList('CREATED_BY', to_char(SetUserAttr.created_by ,
3676: WF_CORE.canonical_number_mask), l_params);

Line 3675: WF_EVENT.AddParameterToList('CREATED_BY', to_char(SetUserAttr.created_by ,

3671: WF_CORE.canonical_date_mask), l_params);
3672: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
3673: to_char(SetUserAttr.last_update_login ,
3674: WF_CORE.canonical_number_mask), l_params);
3675: WF_EVENT.AddParameterToList('CREATED_BY', to_char(SetUserAttr.created_by ,
3676: WF_CORE.canonical_number_mask), l_params);
3677: WF_EVENT.AddParameterToList('CREATION_DATE',
3678: to_char(SetUserAttr.creation_date,
3679: WF_CORE.canonical_date_mask), l_params);

Line 3677: WF_EVENT.AddParameterToList('CREATION_DATE',

3673: to_char(SetUserAttr.last_update_login ,
3674: WF_CORE.canonical_number_mask), l_params);
3675: WF_EVENT.AddParameterToList('CREATED_BY', to_char(SetUserAttr.created_by ,
3676: WF_CORE.canonical_number_mask), l_params);
3677: WF_EVENT.AddParameterToList('CREATION_DATE',
3678: to_char(SetUserAttr.creation_date,
3679: WF_CORE.canonical_date_mask), l_params);
3680: if (eventParams is not null and eventParams.count>0) then
3681: for i in eventParams.first..eventParams.last loop

Line 3682: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),

3678: to_char(SetUserAttr.creation_date,
3679: WF_CORE.canonical_date_mask), l_params);
3680: if (eventParams is not null and eventParams.count>0) then
3681: for i in eventParams.first..eventParams.last loop
3682: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),
3683: eventParams(i).getValue(),l_params);
3684: end loop;
3685: end if;
3686:

Line 3687: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.user.updated',

3683: eventParams(i).getValue(),l_params);
3684: end loop;
3685: end if;
3686:
3687: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.user.updated',
3688: p_event_key=>user_name, p_parameters=>l_params);
3689:
3690: exception
3691: when others then

Line 4083: WF_EVENT.AddParameterToList('ROLE_NAME', SetRoleAttr.role_name, l_params);

4079: end if;
4080:
4081: --We were able to update the record, so we will raise the updated event
4082: --Build parameter list.
4083: WF_EVENT.AddParameterToList('ROLE_NAME', SetRoleAttr.role_name, l_params);
4084: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetRoleAttr.orig_system,
4085: l_params);
4086: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
4087: to_char(SetRoleAttr.orig_system_id), l_params);

Line 4084: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetRoleAttr.orig_system,

4080:
4081: --We were able to update the record, so we will raise the updated event
4082: --Build parameter list.
4083: WF_EVENT.AddParameterToList('ROLE_NAME', SetRoleAttr.role_name, l_params);
4084: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetRoleAttr.orig_system,
4085: l_params);
4086: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
4087: to_char(SetRoleAttr.orig_system_id), l_params);
4088: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetRoleAttr.display_name,

Line 4086: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',

4082: --Build parameter list.
4083: WF_EVENT.AddParameterToList('ROLE_NAME', SetRoleAttr.role_name, l_params);
4084: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetRoleAttr.orig_system,
4085: l_params);
4086: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
4087: to_char(SetRoleAttr.orig_system_id), l_params);
4088: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetRoleAttr.display_name,
4089: l_params);
4090: WF_EVENT.AddParameterToList('DESCRIPTION', SetRoleAttr.description,

Line 4088: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetRoleAttr.display_name,

4084: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetRoleAttr.orig_system,
4085: l_params);
4086: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
4087: to_char(SetRoleAttr.orig_system_id), l_params);
4088: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetRoleAttr.display_name,
4089: l_params);
4090: WF_EVENT.AddParameterToList('DESCRIPTION', SetRoleAttr.description,
4091: l_params);
4092: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',

Line 4090: WF_EVENT.AddParameterToList('DESCRIPTION', SetRoleAttr.description,

4086: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
4087: to_char(SetRoleAttr.orig_system_id), l_params);
4088: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetRoleAttr.display_name,
4089: l_params);
4090: WF_EVENT.AddParameterToList('DESCRIPTION', SetRoleAttr.description,
4091: l_params);
4092: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
4093: SetRoleAttr.notification_preference, l_params);
4094: WF_EVENT.AddParameterToList('LANGUAGE', SetRoleAttr.language, l_params);

Line 4092: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',

4088: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetRoleAttr.display_name,
4089: l_params);
4090: WF_EVENT.AddParameterToList('DESCRIPTION', SetRoleAttr.description,
4091: l_params);
4092: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
4093: SetRoleAttr.notification_preference, l_params);
4094: WF_EVENT.AddParameterToList('LANGUAGE', SetRoleAttr.language, l_params);
4095: WF_EVENT.AddParameterToList('TERRITORY', SetRoleAttr.territory, l_params);
4096: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetRoleAttr.email_address,

Line 4094: WF_EVENT.AddParameterToList('LANGUAGE', SetRoleAttr.language, l_params);

4090: WF_EVENT.AddParameterToList('DESCRIPTION', SetRoleAttr.description,
4091: l_params);
4092: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
4093: SetRoleAttr.notification_preference, l_params);
4094: WF_EVENT.AddParameterToList('LANGUAGE', SetRoleAttr.language, l_params);
4095: WF_EVENT.AddParameterToList('TERRITORY', SetRoleAttr.territory, l_params);
4096: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetRoleAttr.email_address,
4097: l_params);
4098: WF_EVENT.AddParameterToList('FAX', SetRoleAttr.fax, l_params);

Line 4095: WF_EVENT.AddParameterToList('TERRITORY', SetRoleAttr.territory, l_params);

4091: l_params);
4092: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
4093: SetRoleAttr.notification_preference, l_params);
4094: WF_EVENT.AddParameterToList('LANGUAGE', SetRoleAttr.language, l_params);
4095: WF_EVENT.AddParameterToList('TERRITORY', SetRoleAttr.territory, l_params);
4096: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetRoleAttr.email_address,
4097: l_params);
4098: WF_EVENT.AddParameterToList('FAX', SetRoleAttr.fax, l_params);
4099: WF_EVENT.AddParameterToList('EXPIRATION_DATE',

Line 4096: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetRoleAttr.email_address,

4092: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
4093: SetRoleAttr.notification_preference, l_params);
4094: WF_EVENT.AddParameterToList('LANGUAGE', SetRoleAttr.language, l_params);
4095: WF_EVENT.AddParameterToList('TERRITORY', SetRoleAttr.territory, l_params);
4096: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetRoleAttr.email_address,
4097: l_params);
4098: WF_EVENT.AddParameterToList('FAX', SetRoleAttr.fax, l_params);
4099: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
4100: to_char(trunc(SetRoleAttr.expiration_date),

Line 4098: WF_EVENT.AddParameterToList('FAX', SetRoleAttr.fax, l_params);

4094: WF_EVENT.AddParameterToList('LANGUAGE', SetRoleAttr.language, l_params);
4095: WF_EVENT.AddParameterToList('TERRITORY', SetRoleAttr.territory, l_params);
4096: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetRoleAttr.email_address,
4097: l_params);
4098: WF_EVENT.AddParameterToList('FAX', SetRoleAttr.fax, l_params);
4099: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
4100: to_char(trunc(SetRoleAttr.expiration_date),
4101: WF_CORE.Canonical_Date_Mask),
4102: l_params);

Line 4099: WF_EVENT.AddParameterToList('EXPIRATION_DATE',

4095: WF_EVENT.AddParameterToList('TERRITORY', SetRoleAttr.territory, l_params);
4096: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetRoleAttr.email_address,
4097: l_params);
4098: WF_EVENT.AddParameterToList('FAX', SetRoleAttr.fax, l_params);
4099: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
4100: to_char(trunc(SetRoleAttr.expiration_date),
4101: WF_CORE.Canonical_Date_Mask),
4102: l_params);
4103: WF_EVENT.AddParameterToList('STATUS', SetRoleAttr.status, l_params);

Line 4103: WF_EVENT.AddParameterToList('STATUS', SetRoleAttr.status, l_params);

4099: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
4100: to_char(trunc(SetRoleAttr.expiration_date),
4101: WF_CORE.Canonical_Date_Mask),
4102: l_params);
4103: WF_EVENT.AddParameterToList('STATUS', SetRoleAttr.status, l_params);
4104: WF_EVENT.AddParameterToList('START_DATE',
4105: to_char(trunc(SetRoleAttr.start_date),
4106: WF_CORE.Canonical_Date_Mask),
4107: l_params);

Line 4104: WF_EVENT.AddParameterToList('START_DATE',

4100: to_char(trunc(SetRoleAttr.expiration_date),
4101: WF_CORE.Canonical_Date_Mask),
4102: l_params);
4103: WF_EVENT.AddParameterToList('STATUS', SetRoleAttr.status, l_params);
4104: WF_EVENT.AddParameterToList('START_DATE',
4105: to_char(trunc(SetRoleAttr.start_date),
4106: WF_CORE.Canonical_Date_Mask),
4107: l_params);
4108: if ((((l_oldStartDate is NOT NULL) and

Line 4114: WF_EVENT.AddParameterToList('OLD_START_DATE',

4110: (trunc(l_oldStartDate) <> trunc(SetRoleAttr.start_date))) or
4111: ((l_oldStartDate is NULL and SetRoleAttr.start_date is NOT NULL) or
4112: (SetRoleAttr.start_date is NULL and l_oldStartDate is NOT NULL))) then
4113:
4114: WF_EVENT.AddParameterToList('OLD_START_DATE',
4115: to_char(trunc(l_oldStartDate),
4116: WF_CORE.Canonical_Date_Mask),
4117: l_params);
4118: else

Line 4119: WF_EVENT.AddParameterToList('OLD_START_DATE', 'UNDEFINED',

4115: to_char(trunc(l_oldStartDate),
4116: WF_CORE.Canonical_Date_Mask),
4117: l_params);
4118: else
4119: WF_EVENT.AddParameterToList('OLD_START_DATE', '*UNDEFINED*',
4120: l_params);
4121: end if;
4122:
4123: if ((((l_oldEndDate is NOT NULL) and

Line 4130: WF_EVENT.AddParameterToList('OLD_END_DATE',

4126: ((l_oldEndDate is NULL and SetRoleAttr.expiration_date is NOT NULL)
4127: or (SetRoleAttr.expiration_date is NULL
4128: and l_oldEndDate is NOT NULL))) then
4129:
4130: WF_EVENT.AddParameterToList('OLD_END_DATE',
4131: to_char(trunc(l_oldEndDate),
4132: WF_CORE.Canonical_Date_Mask),
4133: l_params);
4134: else

Line 4135: WF_EVENT.AddParameterToList('OLD_END_DATE', 'UNDEFINED',

4131: to_char(trunc(l_oldEndDate),
4132: WF_CORE.Canonical_Date_Mask),
4133: l_params);
4134: else
4135: WF_EVENT.AddParameterToList('OLD_END_DATE', '*UNDEFINED*',
4136: l_params);
4137: end if;
4138:
4139: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',

Line 4139: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',

4135: WF_EVENT.AddParameterToList('OLD_END_DATE', '*UNDEFINED*',
4136: l_params);
4137: end if;
4138:
4139: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
4140: SetRoleAttr.parent_orig_system, l_params);
4141: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
4142: to_char(SetRoleAttr.parent_orig_system_id ,
4143: WF_CORE.canonical_number_mask),l_params);

Line 4141: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',

4137: end if;
4138:
4139: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
4140: SetRoleAttr.parent_orig_system, l_params);
4141: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
4142: to_char(SetRoleAttr.parent_orig_system_id ,
4143: WF_CORE.canonical_number_mask),l_params);
4144:
4145: WF_EVENT.AddParameterToList('OWNER_TAG', SetRoleAttr.owner_tag, l_params);

Line 4145: WF_EVENT.AddParameterToList('OWNER_TAG', SetRoleAttr.owner_tag, l_params);

4141: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
4142: to_char(SetRoleAttr.parent_orig_system_id ,
4143: WF_CORE.canonical_number_mask),l_params);
4144:
4145: WF_EVENT.AddParameterToList('OWNER_TAG', SetRoleAttr.owner_tag, l_params);
4146: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
4147: to_char(SetRoleAttr.last_updated_by ,
4148: WF_CORE.canonical_number_mask), l_params);
4149: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',

Line 4146: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',

4142: to_char(SetRoleAttr.parent_orig_system_id ,
4143: WF_CORE.canonical_number_mask),l_params);
4144:
4145: WF_EVENT.AddParameterToList('OWNER_TAG', SetRoleAttr.owner_tag, l_params);
4146: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
4147: to_char(SetRoleAttr.last_updated_by ,
4148: WF_CORE.canonical_number_mask), l_params);
4149: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
4150: to_char(SetRoleAttr.last_update_date,

Line 4149: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',

4145: WF_EVENT.AddParameterToList('OWNER_TAG', SetRoleAttr.owner_tag, l_params);
4146: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
4147: to_char(SetRoleAttr.last_updated_by ,
4148: WF_CORE.canonical_number_mask), l_params);
4149: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
4150: to_char(SetRoleAttr.last_update_date,
4151: WF_CORE.canonical_date_mask), l_params);
4152: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
4153: to_char(SetRoleAttr.last_update_login ,

Line 4152: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',

4148: WF_CORE.canonical_number_mask), l_params);
4149: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
4150: to_char(SetRoleAttr.last_update_date,
4151: WF_CORE.canonical_date_mask), l_params);
4152: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
4153: to_char(SetRoleAttr.last_update_login ,
4154: WF_CORE.canonical_number_mask), l_params);
4155: if (eventParams is not null and eventParams.count>0) then
4156: for i in eventParams.first..eventParams.last loop

Line 4157: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),

4153: to_char(SetRoleAttr.last_update_login ,
4154: WF_CORE.canonical_number_mask), l_params);
4155: if (eventParams is not null and eventParams.count>0) then
4156: for i in eventParams.first..eventParams.last loop
4157: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),
4158: eventParams(i).getValue(),l_params);
4159: end loop;
4160: end if;
4161: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.role.updated',

Line 4161: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.role.updated',

4157: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),
4158: eventParams(i).getValue(),l_params);
4159: end loop;
4160: end if;
4161: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.role.updated',
4162: p_event_key=>role_name, p_parameters=>l_params);
4163:
4164: exception
4165: when others then

Line 4898: -- p_event (WF_EVENT_T)

4894: -- Change_Name_References_RF (PRIVATE)
4895: --
4896: -- IN
4897: -- p_sub_guid (RAW)
4898: -- p_event (WF_EVENT_T)
4899: --
4900: -- RETURNS
4901: -- varchar2
4902: --

Line 4910: p_event in out NOCOPY WF_EVENT_T )

4906: -- set as deferred to offline the updates to return control back to the user
4907: -- more quickly.
4908: --
4909: function Change_Name_References_RF( p_sub_guid in RAW,
4910: p_event in out NOCOPY WF_EVENT_T )
4911: return VARCHAR2 is
4912: l_newName VARCHAR2(360);
4913: l_oldName VARCHAR2(360);
4914: