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 2192: event wf_event_t;

2188: l_lastupddt date;
2189: l_lastupdby number;
2190: l_creatby number;
2191: l_lastupdlog number;
2192: event wf_event_t;
2193: result varchar2(10);
2194: sub_id raw(20);
2195: begin
2196: if ((user_orig_system is NULL) or (user_orig_system_id is NULL) or

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

2385: ) returning rowid into l_affectedRow;
2386:
2387: --We were able to insert the record, so we will raise the created event
2388: --Build parameter list.
2389: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);
2390: WF_EVENT.AddParameterToList('USER_NAME', CreateUserRole.user_name, l_params);
2391: WF_EVENT.AddParameterToList('ROLE_NAME', CreateUserRole.role_name, l_params);
2392: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2393: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);

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

2386:
2387: --We were able to insert the record, so we will raise the created event
2388: --Build parameter list.
2389: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);
2390: WF_EVENT.AddParameterToList('USER_NAME', CreateUserRole.user_name, l_params);
2391: WF_EVENT.AddParameterToList('ROLE_NAME', CreateUserRole.role_name, l_params);
2392: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2393: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);
2394: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);

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

2387: --We were able to insert the record, so we will raise the created event
2388: --Build parameter list.
2389: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);
2390: WF_EVENT.AddParameterToList('USER_NAME', CreateUserRole.user_name, l_params);
2391: WF_EVENT.AddParameterToList('ROLE_NAME', CreateUserRole.role_name, l_params);
2392: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2393: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);
2394: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2395: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', l_rorigSysID, l_params);

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

2388: --Build parameter list.
2389: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);
2390: WF_EVENT.AddParameterToList('USER_NAME', CreateUserRole.user_name, l_params);
2391: WF_EVENT.AddParameterToList('ROLE_NAME', CreateUserRole.role_name, l_params);
2392: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2393: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);
2394: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2395: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', l_rorigSysID, l_params);
2396: WF_EVENT.AddParameterToList('START_DATE',

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

2389: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);
2390: WF_EVENT.AddParameterToList('USER_NAME', CreateUserRole.user_name, l_params);
2391: WF_EVENT.AddParameterToList('ROLE_NAME', CreateUserRole.role_name, l_params);
2392: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2393: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);
2394: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2395: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', l_rorigSysID, l_params);
2396: WF_EVENT.AddParameterToList('START_DATE',
2397: to_char(trunc(CreateUserRole.start_date),

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

2390: WF_EVENT.AddParameterToList('USER_NAME', CreateUserRole.user_name, l_params);
2391: WF_EVENT.AddParameterToList('ROLE_NAME', CreateUserRole.role_name, l_params);
2392: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2393: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);
2394: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2395: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', l_rorigSysID, l_params);
2396: WF_EVENT.AddParameterToList('START_DATE',
2397: to_char(trunc(CreateUserRole.start_date),
2398: WF_CORE.Canonical_Date_Mask),

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

2391: WF_EVENT.AddParameterToList('ROLE_NAME', CreateUserRole.role_name, l_params);
2392: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2393: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);
2394: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2395: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', l_rorigSysID, l_params);
2396: WF_EVENT.AddParameterToList('START_DATE',
2397: to_char(trunc(CreateUserRole.start_date),
2398: WF_CORE.Canonical_Date_Mask),
2399: l_params);

Line 2396: WF_EVENT.AddParameterToList('START_DATE',

2392: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2393: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', l_uorigSysID, l_params);
2394: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2395: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', l_rorigSysID, l_params);
2396: WF_EVENT.AddParameterToList('START_DATE',
2397: to_char(trunc(CreateUserRole.start_date),
2398: WF_CORE.Canonical_Date_Mask),
2399: l_params);
2400: WF_EVENT.AddParameterToList('END_DATE',

Line 2400: WF_EVENT.AddParameterToList('END_DATE',

2396: WF_EVENT.AddParameterToList('START_DATE',
2397: to_char(trunc(CreateUserRole.start_date),
2398: WF_CORE.Canonical_Date_Mask),
2399: l_params);
2400: WF_EVENT.AddParameterToList('END_DATE',
2401: to_char(trunc(CreateUserRole.end_date),
2402: WF_CORE.Canonical_Date_Mask),
2403: l_params);
2404:

Line 2405: WF_EVENT.AddParameterToList('CREATED_BY',

2401: to_char(trunc(CreateUserRole.end_date),
2402: WF_CORE.Canonical_Date_Mask),
2403: l_params);
2404:
2405: WF_EVENT.AddParameterToList('CREATED_BY',
2406: to_char(CreateUserRole.created_by,
2407: WF_CORE.canonical_number_mask), l_params);
2408:
2409: WF_EVENT.AddParameterToList('CREATION_DATE',

Line 2409: WF_EVENT.AddParameterToList('CREATION_DATE',

2405: WF_EVENT.AddParameterToList('CREATED_BY',
2406: to_char(CreateUserRole.created_by,
2407: WF_CORE.canonical_number_mask), l_params);
2408:
2409: WF_EVENT.AddParameterToList('CREATION_DATE',
2410: to_char(CreateUserRole.creation_date,
2411: WF_CORE.canonical_date_mask), l_params);
2412:
2413: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',

Line 2413: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',

2409: WF_EVENT.AddParameterToList('CREATION_DATE',
2410: to_char(CreateUserRole.creation_date,
2411: WF_CORE.canonical_date_mask), l_params);
2412:
2413: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
2414: to_char(CreateUserRole.last_updated_by,
2415: WF_CORE.canonical_number_mask), l_params);
2416: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
2417: to_char(CreateUserRole.last_update_date,

Line 2416: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',

2412:
2413: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
2414: to_char(CreateUserRole.last_updated_by,
2415: WF_CORE.canonical_number_mask), l_params);
2416: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
2417: to_char(CreateUserRole.last_update_date,
2418: WF_CORE.canonical_date_mask), l_params);
2419: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
2420: to_char(CreateUserRole.last_update_login,

Line 2419: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',

2415: WF_CORE.canonical_number_mask), l_params);
2416: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
2417: to_char(CreateUserRole.last_update_date,
2418: WF_CORE.canonical_date_mask), l_params);
2419: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
2420: to_char(CreateUserRole.last_update_login,
2421: WF_CORE.canonical_number_mask), l_params);
2422: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',
2423: CreateUserRole.assignment_type, l_params);

Line 2422: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',

2418: WF_CORE.canonical_date_mask), l_params);
2419: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
2420: to_char(CreateUserRole.last_update_login,
2421: WF_CORE.canonical_number_mask), l_params);
2422: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',
2423: CreateUserRole.assignment_type, l_params);
2424: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
2425: CreateUserRole.parent_orig_system, l_params);
2426: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',

Line 2424: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',

2420: to_char(CreateUserRole.last_update_login,
2421: WF_CORE.canonical_number_mask), l_params);
2422: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',
2423: CreateUserRole.assignment_type, l_params);
2424: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
2425: CreateUserRole.parent_orig_system, l_params);
2426: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
2427: to_char(CreateUserRole.parent_orig_system_id,
2428: WF_CORE.canonical_number_mask), l_params);

Line 2426: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',

2422: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',
2423: CreateUserRole.assignment_type, l_params);
2424: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
2425: CreateUserRole.parent_orig_system, l_params);
2426: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
2427: to_char(CreateUserRole.parent_orig_system_id,
2428: WF_CORE.canonical_number_mask), l_params);
2429: WF_EVENT.AddParameterToList('PARTITION_ID', to_char(l_partitionID,
2430: WF_CORE.canonical_number_mask),l_params);

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

2425: CreateUserRole.parent_orig_system, l_params);
2426: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
2427: to_char(CreateUserRole.parent_orig_system_id,
2428: WF_CORE.canonical_number_mask), l_params);
2429: WF_EVENT.AddParameterToList('PARTITION_ID', to_char(l_partitionID,
2430: WF_CORE.canonical_number_mask),l_params);
2431: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',
2432: CreateUserRole.assignment_reason, l_params);
2433: if (eventParams is not null and eventParams.count>0) then

Line 2431: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',

2427: to_char(CreateUserRole.parent_orig_system_id,
2428: WF_CORE.canonical_number_mask), l_params);
2429: WF_EVENT.AddParameterToList('PARTITION_ID', to_char(l_partitionID,
2430: WF_CORE.canonical_number_mask),l_params);
2431: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',
2432: CreateUserRole.assignment_reason, l_params);
2433: if (eventParams is not null and eventParams.count>0) then
2434: for i in eventParams.first..eventParams.last loop
2435: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),

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

2431: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',
2432: CreateUserRole.assignment_reason, l_params);
2433: if (eventParams is not null and eventParams.count>0) then
2434: for i in eventParams.first..eventParams.last loop
2435: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),
2436: eventParams(i).getValue(),l_params);
2437: end loop;
2438: end if;
2439: --determine if BES is enabled

Line 2443: wf_event_t.initialize(event);

2439: --determine if BES is enabled
2440: if (wf_directory.System_Status()='DISABLED') then
2441: --Create the event that is to be raised
2442:
2443: wf_event_t.initialize(event);
2444: event.Send_Date := sysdate;
2445: event.Event_Name := 'oracle.apps.fnd.wf.ds.userRole.created';
2446: event.Event_Key := l_uOrigSys||':'||
2447: to_char(l_uOrigSysId)||'|'||

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

2454: if (result='SUCCESS') then
2455: result:= WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF(sub_id,event);
2456: end if;
2457: else
2458: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.userRole.created',
2459: p_event_key=> l_uOrigSys||':'||
2460: to_char(l_uOrigSysId)||'|'||
2461: l_rOrigSys||':'||
2462: to_char(l_rOrigSysId)||'|'||

Line 2560: event wf_event_t;

2556: l_oldenddate date;
2557: l_UpdateWho BOOLEAN := nvl(updateWho,TRUE);
2558: l_partitionID number;
2559: l_partitionName varchar2(30);
2560: event wf_event_t;
2561: result varchar2(10);
2562: sub_id raw(20);
2563: begin
2564: -- Lookup origSys info if not provided.

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

2729: --We were able to update an existing record, so we will raise the
2730: --updated event
2731:
2732: --Build parameter list.
2733: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);
2734: WF_EVENT.AddParameterToList('USER_NAME', SetUserRoleAttr.user_name,
2735: l_params);
2736: WF_EVENT.AddParameterToList('ROLE_NAME', SetUserRoleAttr.role_name,
2737: l_params);

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

2730: --updated event
2731:
2732: --Build parameter list.
2733: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);
2734: WF_EVENT.AddParameterToList('USER_NAME', SetUserRoleAttr.user_name,
2735: l_params);
2736: WF_EVENT.AddParameterToList('ROLE_NAME', SetUserRoleAttr.role_name,
2737: l_params);
2738: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);

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

2732: --Build parameter list.
2733: WF_EVENT.AddParameterToList('ROWID', ROWIDTOCHAR(l_affectedRow), l_params);
2734: WF_EVENT.AddParameterToList('USER_NAME', SetUserRoleAttr.user_name,
2735: l_params);
2736: WF_EVENT.AddParameterToList('ROLE_NAME', SetUserRoleAttr.role_name,
2737: l_params);
2738: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2739: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', to_char(l_uorigSysID,
2740: WF_CORE.canonical_number_mask), l_params);

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

2734: WF_EVENT.AddParameterToList('USER_NAME', SetUserRoleAttr.user_name,
2735: l_params);
2736: WF_EVENT.AddParameterToList('ROLE_NAME', SetUserRoleAttr.role_name,
2737: l_params);
2738: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2739: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', to_char(l_uorigSysID,
2740: WF_CORE.canonical_number_mask), l_params);
2741: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2742: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', to_char(l_rorigSysID,

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

2735: l_params);
2736: WF_EVENT.AddParameterToList('ROLE_NAME', SetUserRoleAttr.role_name,
2737: l_params);
2738: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2739: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', to_char(l_uorigSysID,
2740: WF_CORE.canonical_number_mask), l_params);
2741: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2742: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', to_char(l_rorigSysID,
2743: WF_CORE.canonical_number_mask), l_params);

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

2737: l_params);
2738: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2739: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', to_char(l_uorigSysID,
2740: WF_CORE.canonical_number_mask), l_params);
2741: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2742: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', to_char(l_rorigSysID,
2743: WF_CORE.canonical_number_mask), l_params);
2744: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM', l_porigSys, l_params);
2745: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID', to_char(l_porigSysID,

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

2738: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2739: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', to_char(l_uorigSysID,
2740: WF_CORE.canonical_number_mask), l_params);
2741: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2742: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', to_char(l_rorigSysID,
2743: WF_CORE.canonical_number_mask), l_params);
2744: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM', l_porigSys, l_params);
2745: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID', to_char(l_porigSysID,
2746: WF_CORE.canonical_number_mask), l_params);

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

2740: WF_CORE.canonical_number_mask), l_params);
2741: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2742: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', to_char(l_rorigSysID,
2743: WF_CORE.canonical_number_mask), l_params);
2744: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM', l_porigSys, l_params);
2745: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID', to_char(l_porigSysID,
2746: WF_CORE.canonical_number_mask), l_params);
2747: WF_EVENT.AddParameterToList('START_DATE',
2748: to_char(trunc(SetUserRoleAttr.start_date),

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

2741: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2742: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', to_char(l_rorigSysID,
2743: WF_CORE.canonical_number_mask), l_params);
2744: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM', l_porigSys, l_params);
2745: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID', to_char(l_porigSysID,
2746: WF_CORE.canonical_number_mask), l_params);
2747: WF_EVENT.AddParameterToList('START_DATE',
2748: to_char(trunc(SetUserRoleAttr.start_date),
2749: WF_CORE.canonical_date_mask),

Line 2747: WF_EVENT.AddParameterToList('START_DATE',

2743: WF_CORE.canonical_number_mask), l_params);
2744: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM', l_porigSys, l_params);
2745: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID', to_char(l_porigSysID,
2746: WF_CORE.canonical_number_mask), l_params);
2747: WF_EVENT.AddParameterToList('START_DATE',
2748: to_char(trunc(SetUserRoleAttr.start_date),
2749: WF_CORE.canonical_date_mask),
2750: l_params);
2751: WF_EVENT.AddParameterToList('END_DATE',

Line 2751: WF_EVENT.AddParameterToList('END_DATE',

2747: WF_EVENT.AddParameterToList('START_DATE',
2748: to_char(trunc(SetUserRoleAttr.start_date),
2749: WF_CORE.canonical_date_mask),
2750: l_params);
2751: WF_EVENT.AddParameterToList('END_DATE',
2752: to_char(trunc(SetUserRoleAttr.end_date),
2753: WF_CORE.canonical_date_mask),
2754: l_params);
2755:

Line 2762: WF_EVENT.AddParameterToList('OLD_START_DATE',

2758: (trunc(l_oldStartDate) <> trunc(SetUserRoleAttr.start_date))) or
2759: ((l_oldStartDate is NULL and SetUserRoleAttr.start_date is NOT NULL) or
2760: (SetUserRoleAttr.start_date is NULL and l_oldStartDate is NOT NULL))) then
2761:
2762: WF_EVENT.AddParameterToList('OLD_START_DATE',
2763: to_char(trunc(l_oldStartDate),
2764: WF_CORE.Canonical_Date_Mask),
2765: l_params);
2766: else

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

2763: to_char(trunc(l_oldStartDate),
2764: WF_CORE.Canonical_Date_Mask),
2765: l_params);
2766: else
2767: WF_EVENT.AddParameterToList('OLD_START_DATE', '*UNDEFINED*',
2768: l_params);
2769: end if;
2770:
2771: if ((((l_oldEndDate is NOT NULL) and

Line 2778: WF_EVENT.AddParameterToList('OLD_END_DATE',

2774: ((l_oldEndDate is NULL and SetUserRoleAttr.end_date is NOT NULL)
2775: or (SetUserRoleAttr.end_date is NULL
2776: and l_oldEndDate is NOT NULL))) then
2777:
2778: WF_EVENT.AddParameterToList('OLD_END_DATE',
2779: to_char(trunc(l_oldEndDate),
2780: WF_CORE.Canonical_Date_Mask),
2781: l_params);
2782: else

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

2779: to_char(trunc(l_oldEndDate),
2780: WF_CORE.Canonical_Date_Mask),
2781: l_params);
2782: else
2783: WF_EVENT.AddParameterToList('OLD_END_DATE', '*UNDEFINED*',
2784: l_params);
2785: end if;
2786:
2787:

Line 2788: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',

2784: l_params);
2785: end if;
2786:
2787:
2788: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
2789: to_char(SetUserRoleAttr.last_updated_by,
2790: WF_CORE.canonical_number_mask), l_params);
2791:
2792: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',

Line 2792: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',

2788: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
2789: to_char(SetUserRoleAttr.last_updated_by,
2790: WF_CORE.canonical_number_mask), l_params);
2791:
2792: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
2793: to_char(SetUserRoleAttr.last_update_date,
2794: WF_CORE.canonical_date_mask), l_params);
2795: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
2796: to_char(SetUserRoleAttr.last_update_login,

Line 2795: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',

2791:
2792: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
2793: to_char(SetUserRoleAttr.last_update_date,
2794: WF_CORE.canonical_date_mask), l_params);
2795: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
2796: to_char(SetUserRoleAttr.last_update_login,
2797: WF_CORE.canonical_number_mask), l_params);
2798:
2799: WF_EVENT.AddParameterToList('CREATED_BY',

Line 2799: WF_EVENT.AddParameterToList('CREATED_BY',

2795: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
2796: to_char(SetUserRoleAttr.last_update_login,
2797: WF_CORE.canonical_number_mask), l_params);
2798:
2799: WF_EVENT.AddParameterToList('CREATED_BY',
2800: to_char(SetUserRoleAttr.created_by,
2801: WF_CORE.canonical_number_mask), l_params);
2802:
2803: WF_EVENT.AddParameterToList('CREATION_DATE',

Line 2803: WF_EVENT.AddParameterToList('CREATION_DATE',

2799: WF_EVENT.AddParameterToList('CREATED_BY',
2800: to_char(SetUserRoleAttr.created_by,
2801: WF_CORE.canonical_number_mask), l_params);
2802:
2803: WF_EVENT.AddParameterToList('CREATION_DATE',
2804: to_char(SetUserRoleAttr.creation_date,
2805: WF_CORE.canonical_date_mask), l_params);
2806:
2807: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',

Line 2807: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',

2803: WF_EVENT.AddParameterToList('CREATION_DATE',
2804: to_char(SetUserRoleAttr.creation_date,
2805: WF_CORE.canonical_date_mask), l_params);
2806:
2807: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',
2808: SetUserRoleAttr.assignment_type, l_params);
2809:
2810: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',
2811: SetUserRoleAttr.assignment_reason, l_params);

Line 2810: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',

2806:
2807: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',
2808: SetUserRoleAttr.assignment_type, l_params);
2809:
2810: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',
2811: SetUserRoleAttr.assignment_reason, l_params);
2812:
2813: if (OverWrite) then
2814: WF_EVENT.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE',l_params );

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

2810: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',
2811: SetUserRoleAttr.assignment_reason, l_params);
2812:
2813: if (OverWrite) then
2814: WF_EVENT.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE',l_params );
2815: end if;
2816:
2817: if (l_updateWho) then
2818: WF_EVENT.AddParameterToList('UPDATE_WHO','TRUE',l_params);

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

2814: WF_EVENT.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE',l_params );
2815: end if;
2816:
2817: if (l_updateWho) then
2818: WF_EVENT.AddParameterToList('UPDATE_WHO','TRUE',l_params);
2819: end if;
2820:
2821: if (eventParams is not null and eventParams.count>0) then
2822: for i in eventParams.first..eventParams.last loop

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

2819: end if;
2820:
2821: if (eventParams is not null and eventParams.count>0) then
2822: for i in eventParams.first..eventParams.last loop
2823: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),
2824: eventParams(i).getValue(),l_params);
2825: end loop;
2826: end if;
2827:

Line 2832: wf_event_t.initialize(event);

2828: --determine if BES is enabled
2829: if (wf_directory.System_Status()='DISABLED') then
2830: --Create the event that is to be raised
2831:
2832: wf_event_t.initialize(event);
2833: event.Send_Date := sysdate;
2834: event.Event_Name := 'oracle.apps.fnd.wf.ds.userRole.updated';
2835: event.Event_Key := l_uOrigSys||':'||
2836: to_char(l_uOrigSysId)||'|'||

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

2844: if (result='SUCCESS') then
2845: result:= WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF(sub_id,event);
2846: end if;
2847: else
2848: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.userRole.updated',
2849: p_event_key=> l_uOrigSys||':'||
2850: to_char(l_uOrigSysId)||'|'||
2851: l_rOrigSys||':'||
2852: to_char(l_rOrigSysId)||'|'||

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

3452: end if;
3453:
3454: --We were able to update the record, so we will raise the updated event
3455: --Build parameter list.
3456: WF_EVENT.AddParameterToList('USER_NAME', SetUserAttr.user_name, l_params);
3457: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetUserAttr.orig_system,
3458: l_params);
3459: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
3460: to_char(SetUserAttr.orig_system_id), l_params);

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

3453:
3454: --We were able to update the record, so we will raise the updated event
3455: --Build parameter list.
3456: WF_EVENT.AddParameterToList('USER_NAME', SetUserAttr.user_name, l_params);
3457: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetUserAttr.orig_system,
3458: l_params);
3459: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
3460: to_char(SetUserAttr.orig_system_id), l_params);
3461: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetUserAttr.display_name,

Line 3459: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',

3455: --Build parameter list.
3456: WF_EVENT.AddParameterToList('USER_NAME', SetUserAttr.user_name, l_params);
3457: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetUserAttr.orig_system,
3458: l_params);
3459: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
3460: to_char(SetUserAttr.orig_system_id), l_params);
3461: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetUserAttr.display_name,
3462: l_params);
3463: WF_EVENT.AddParameterToList('DESCRIPTION', SetUserAttr.description,

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

3457: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetUserAttr.orig_system,
3458: l_params);
3459: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
3460: to_char(SetUserAttr.orig_system_id), l_params);
3461: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetUserAttr.display_name,
3462: l_params);
3463: WF_EVENT.AddParameterToList('DESCRIPTION', SetUserAttr.description,
3464: l_params);
3465: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',

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

3459: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
3460: to_char(SetUserAttr.orig_system_id), l_params);
3461: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetUserAttr.display_name,
3462: l_params);
3463: WF_EVENT.AddParameterToList('DESCRIPTION', SetUserAttr.description,
3464: l_params);
3465: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
3466: SetUserAttr.notification_preference, l_params);
3467: WF_EVENT.AddParameterToList('LANGUAGE', SetUserAttr.language, l_params);

Line 3465: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',

3461: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetUserAttr.display_name,
3462: l_params);
3463: WF_EVENT.AddParameterToList('DESCRIPTION', SetUserAttr.description,
3464: l_params);
3465: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
3466: SetUserAttr.notification_preference, l_params);
3467: WF_EVENT.AddParameterToList('LANGUAGE', SetUserAttr.language, l_params);
3468: WF_EVENT.AddParameterToList('TERRITORY', SetUserAttr.territory, l_params);
3469: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetUserAttr.email_address,

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

3463: WF_EVENT.AddParameterToList('DESCRIPTION', SetUserAttr.description,
3464: l_params);
3465: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
3466: SetUserAttr.notification_preference, l_params);
3467: WF_EVENT.AddParameterToList('LANGUAGE', SetUserAttr.language, l_params);
3468: WF_EVENT.AddParameterToList('TERRITORY', SetUserAttr.territory, l_params);
3469: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetUserAttr.email_address,
3470: l_params);
3471: WF_EVENT.AddParameterToList('FAX', SetUserAttr.fax, l_params);

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

3464: l_params);
3465: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
3466: SetUserAttr.notification_preference, l_params);
3467: WF_EVENT.AddParameterToList('LANGUAGE', SetUserAttr.language, l_params);
3468: WF_EVENT.AddParameterToList('TERRITORY', SetUserAttr.territory, l_params);
3469: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetUserAttr.email_address,
3470: l_params);
3471: WF_EVENT.AddParameterToList('FAX', SetUserAttr.fax, l_params);
3472: WF_EVENT.AddParameterToList('EXPIRATION_DATE',

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

3465: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
3466: SetUserAttr.notification_preference, l_params);
3467: WF_EVENT.AddParameterToList('LANGUAGE', SetUserAttr.language, l_params);
3468: WF_EVENT.AddParameterToList('TERRITORY', SetUserAttr.territory, l_params);
3469: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetUserAttr.email_address,
3470: l_params);
3471: WF_EVENT.AddParameterToList('FAX', SetUserAttr.fax, l_params);
3472: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
3473: to_char(trunc(SetUserAttr.expiration_date),

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

3467: WF_EVENT.AddParameterToList('LANGUAGE', SetUserAttr.language, l_params);
3468: WF_EVENT.AddParameterToList('TERRITORY', SetUserAttr.territory, l_params);
3469: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetUserAttr.email_address,
3470: l_params);
3471: WF_EVENT.AddParameterToList('FAX', SetUserAttr.fax, l_params);
3472: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
3473: to_char(trunc(SetUserAttr.expiration_date),
3474: WF_CORE.Canonical_Date_Mask),
3475: l_params);

Line 3472: WF_EVENT.AddParameterToList('EXPIRATION_DATE',

3468: WF_EVENT.AddParameterToList('TERRITORY', SetUserAttr.territory, l_params);
3469: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetUserAttr.email_address,
3470: l_params);
3471: WF_EVENT.AddParameterToList('FAX', SetUserAttr.fax, l_params);
3472: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
3473: to_char(trunc(SetUserAttr.expiration_date),
3474: WF_CORE.Canonical_Date_Mask),
3475: l_params);
3476: WF_EVENT.AddParameterToList('STATUS', SetUserAttr.status, l_params);

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

3472: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
3473: to_char(trunc(SetUserAttr.expiration_date),
3474: WF_CORE.Canonical_Date_Mask),
3475: l_params);
3476: WF_EVENT.AddParameterToList('STATUS', SetUserAttr.status, l_params);
3477: WF_EVENT.AddParameterToList('START_DATE',
3478: to_char(trunc(SetUserAttr.start_date),
3479: WF_CORE.Canonical_Date_Mask),
3480: l_params);

Line 3477: WF_EVENT.AddParameterToList('START_DATE',

3473: to_char(trunc(SetUserAttr.expiration_date),
3474: WF_CORE.Canonical_Date_Mask),
3475: l_params);
3476: WF_EVENT.AddParameterToList('STATUS', SetUserAttr.status, l_params);
3477: WF_EVENT.AddParameterToList('START_DATE',
3478: to_char(trunc(SetUserAttr.start_date),
3479: WF_CORE.Canonical_Date_Mask),
3480: l_params);
3481: if ((((l_oldStartDate is NOT NULL) and

Line 3487: WF_EVENT.AddParameterToList('OLD_START_DATE',

3483: (trunc(l_oldStartDate) <> trunc(SetUserAttr.start_date))) or
3484: ((l_oldStartDate is NULL and SetUserAttr.start_date is NOT NULL) or
3485: (SetUserAttr.start_date is NULL and l_oldStartDate is NOT NULL))) then
3486:
3487: WF_EVENT.AddParameterToList('OLD_START_DATE',
3488: to_char(trunc(l_oldStartDate),
3489: WF_CORE.Canonical_Date_Mask),
3490: l_params);
3491: else

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

3488: to_char(trunc(l_oldStartDate),
3489: WF_CORE.Canonical_Date_Mask),
3490: l_params);
3491: else
3492: WF_EVENT.AddParameterToList('OLD_START_DATE', '*UNDEFINED*',
3493: l_params);
3494: end if;
3495:
3496: if ((((l_oldEndDate is NOT NULL) and

Line 3503: WF_EVENT.AddParameterToList('OLD_END_DATE',

3499: ((l_oldEndDate is NULL and SetUserAttr.expiration_date is NOT NULL)
3500: or (SetUserAttr.expiration_date is NULL
3501: and l_oldEndDate is NOT NULL))) then
3502:
3503: WF_EVENT.AddParameterToList('OLD_END_DATE',
3504: to_char(trunc(l_oldEndDate),
3505: WF_CORE.Canonical_Date_Mask),
3506: l_params);
3507: else

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

3504: to_char(trunc(l_oldEndDate),
3505: WF_CORE.Canonical_Date_Mask),
3506: l_params);
3507: else
3508: WF_EVENT.AddParameterToList('OLD_END_DATE', '*UNDEFINED*',
3509: l_params);
3510: end if;
3511:
3512: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',

Line 3512: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',

3508: WF_EVENT.AddParameterToList('OLD_END_DATE', '*UNDEFINED*',
3509: l_params);
3510: end if;
3511:
3512: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
3513: SetUserAttr.parent_orig_system, l_params);
3514: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
3515: to_char(SetUserAttr.parent_orig_system_id ,
3516: WF_CORE.canonical_number_mask), l_params);

Line 3514: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',

3510: end if;
3511:
3512: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
3513: SetUserAttr.parent_orig_system, l_params);
3514: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
3515: to_char(SetUserAttr.parent_orig_system_id ,
3516: WF_CORE.canonical_number_mask), l_params);
3517: WF_EVENT.AddParameterToList('OWNER_TAG', SetUserAttr.owner_tag, l_params);
3518: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',

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

3513: SetUserAttr.parent_orig_system, l_params);
3514: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
3515: to_char(SetUserAttr.parent_orig_system_id ,
3516: WF_CORE.canonical_number_mask), l_params);
3517: WF_EVENT.AddParameterToList('OWNER_TAG', SetUserAttr.owner_tag, l_params);
3518: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
3519: to_char(SetUserAttr.last_updated_by,
3520: WF_CORE.canonical_number_mask), l_params);
3521: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',

Line 3518: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',

3514: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
3515: to_char(SetUserAttr.parent_orig_system_id ,
3516: WF_CORE.canonical_number_mask), l_params);
3517: WF_EVENT.AddParameterToList('OWNER_TAG', SetUserAttr.owner_tag, l_params);
3518: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
3519: to_char(SetUserAttr.last_updated_by,
3520: WF_CORE.canonical_number_mask), l_params);
3521: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
3522: to_char(SetUserAttr.last_update_date,

Line 3521: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',

3517: WF_EVENT.AddParameterToList('OWNER_TAG', SetUserAttr.owner_tag, l_params);
3518: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
3519: to_char(SetUserAttr.last_updated_by,
3520: WF_CORE.canonical_number_mask), l_params);
3521: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
3522: to_char(SetUserAttr.last_update_date,
3523: WF_CORE.canonical_date_mask), l_params);
3524: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
3525: to_char(SetUserAttr.last_update_login ,

Line 3524: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',

3520: WF_CORE.canonical_number_mask), l_params);
3521: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
3522: to_char(SetUserAttr.last_update_date,
3523: WF_CORE.canonical_date_mask), l_params);
3524: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
3525: to_char(SetUserAttr.last_update_login ,
3526: WF_CORE.canonical_number_mask), l_params);
3527: WF_EVENT.AddParameterToList('CREATED_BY', to_char(SetUserAttr.created_by ,
3528: WF_CORE.canonical_number_mask), l_params);

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

3523: WF_CORE.canonical_date_mask), l_params);
3524: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
3525: to_char(SetUserAttr.last_update_login ,
3526: WF_CORE.canonical_number_mask), l_params);
3527: WF_EVENT.AddParameterToList('CREATED_BY', to_char(SetUserAttr.created_by ,
3528: WF_CORE.canonical_number_mask), l_params);
3529: WF_EVENT.AddParameterToList('CREATION_DATE',
3530: to_char(SetUserAttr.creation_date,
3531: WF_CORE.canonical_date_mask), l_params);

Line 3529: WF_EVENT.AddParameterToList('CREATION_DATE',

3525: to_char(SetUserAttr.last_update_login ,
3526: WF_CORE.canonical_number_mask), l_params);
3527: WF_EVENT.AddParameterToList('CREATED_BY', to_char(SetUserAttr.created_by ,
3528: WF_CORE.canonical_number_mask), l_params);
3529: WF_EVENT.AddParameterToList('CREATION_DATE',
3530: to_char(SetUserAttr.creation_date,
3531: WF_CORE.canonical_date_mask), l_params);
3532: if (eventParams is not null and eventParams.count>0) then
3533: for i in eventParams.first..eventParams.last loop

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

3530: to_char(SetUserAttr.creation_date,
3531: WF_CORE.canonical_date_mask), l_params);
3532: if (eventParams is not null and eventParams.count>0) then
3533: for i in eventParams.first..eventParams.last loop
3534: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),
3535: eventParams(i).getValue(),l_params);
3536: end loop;
3537: end if;
3538:

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

3535: eventParams(i).getValue(),l_params);
3536: end loop;
3537: end if;
3538:
3539: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.user.updated',
3540: p_event_key=>user_name, p_parameters=>l_params);
3541:
3542: exception
3543: when others then

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

3931: end if;
3932:
3933: --We were able to update the record, so we will raise the updated event
3934: --Build parameter list.
3935: WF_EVENT.AddParameterToList('ROLE_NAME', SetRoleAttr.role_name, l_params);
3936: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetRoleAttr.orig_system,
3937: l_params);
3938: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
3939: to_char(SetRoleAttr.orig_system_id), l_params);

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

3932:
3933: --We were able to update the record, so we will raise the updated event
3934: --Build parameter list.
3935: WF_EVENT.AddParameterToList('ROLE_NAME', SetRoleAttr.role_name, l_params);
3936: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetRoleAttr.orig_system,
3937: l_params);
3938: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
3939: to_char(SetRoleAttr.orig_system_id), l_params);
3940: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetRoleAttr.display_name,

Line 3938: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',

3934: --Build parameter list.
3935: WF_EVENT.AddParameterToList('ROLE_NAME', SetRoleAttr.role_name, l_params);
3936: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetRoleAttr.orig_system,
3937: l_params);
3938: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
3939: to_char(SetRoleAttr.orig_system_id), l_params);
3940: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetRoleAttr.display_name,
3941: l_params);
3942: WF_EVENT.AddParameterToList('DESCRIPTION', SetRoleAttr.description,

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

3936: WF_EVENT.AddParameterToList('ORIG_SYSTEM', SetRoleAttr.orig_system,
3937: l_params);
3938: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
3939: to_char(SetRoleAttr.orig_system_id), l_params);
3940: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetRoleAttr.display_name,
3941: l_params);
3942: WF_EVENT.AddParameterToList('DESCRIPTION', SetRoleAttr.description,
3943: l_params);
3944: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',

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

3938: WF_EVENT.AddParameterToList('ORIG_SYSTEM_ID',
3939: to_char(SetRoleAttr.orig_system_id), l_params);
3940: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetRoleAttr.display_name,
3941: l_params);
3942: WF_EVENT.AddParameterToList('DESCRIPTION', SetRoleAttr.description,
3943: l_params);
3944: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
3945: SetRoleAttr.notification_preference, l_params);
3946: WF_EVENT.AddParameterToList('LANGUAGE', SetRoleAttr.language, l_params);

Line 3944: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',

3940: WF_EVENT.AddParameterToList('DISPLAY_NAME', SetRoleAttr.display_name,
3941: l_params);
3942: WF_EVENT.AddParameterToList('DESCRIPTION', SetRoleAttr.description,
3943: l_params);
3944: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
3945: SetRoleAttr.notification_preference, l_params);
3946: WF_EVENT.AddParameterToList('LANGUAGE', SetRoleAttr.language, l_params);
3947: WF_EVENT.AddParameterToList('TERRITORY', SetRoleAttr.territory, l_params);
3948: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetRoleAttr.email_address,

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

3942: WF_EVENT.AddParameterToList('DESCRIPTION', SetRoleAttr.description,
3943: l_params);
3944: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
3945: SetRoleAttr.notification_preference, l_params);
3946: WF_EVENT.AddParameterToList('LANGUAGE', SetRoleAttr.language, l_params);
3947: WF_EVENT.AddParameterToList('TERRITORY', SetRoleAttr.territory, l_params);
3948: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetRoleAttr.email_address,
3949: l_params);
3950: WF_EVENT.AddParameterToList('FAX', SetRoleAttr.fax, l_params);

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

3943: l_params);
3944: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
3945: SetRoleAttr.notification_preference, l_params);
3946: WF_EVENT.AddParameterToList('LANGUAGE', SetRoleAttr.language, l_params);
3947: WF_EVENT.AddParameterToList('TERRITORY', SetRoleAttr.territory, l_params);
3948: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetRoleAttr.email_address,
3949: l_params);
3950: WF_EVENT.AddParameterToList('FAX', SetRoleAttr.fax, l_params);
3951: WF_EVENT.AddParameterToList('EXPIRATION_DATE',

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

3944: WF_EVENT.AddParameterToList('NOTIFICATION_PREFERENCE',
3945: SetRoleAttr.notification_preference, l_params);
3946: WF_EVENT.AddParameterToList('LANGUAGE', SetRoleAttr.language, l_params);
3947: WF_EVENT.AddParameterToList('TERRITORY', SetRoleAttr.territory, l_params);
3948: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetRoleAttr.email_address,
3949: l_params);
3950: WF_EVENT.AddParameterToList('FAX', SetRoleAttr.fax, l_params);
3951: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
3952: to_char(trunc(SetRoleAttr.expiration_date),

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

3946: WF_EVENT.AddParameterToList('LANGUAGE', SetRoleAttr.language, l_params);
3947: WF_EVENT.AddParameterToList('TERRITORY', SetRoleAttr.territory, l_params);
3948: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetRoleAttr.email_address,
3949: l_params);
3950: WF_EVENT.AddParameterToList('FAX', SetRoleAttr.fax, l_params);
3951: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
3952: to_char(trunc(SetRoleAttr.expiration_date),
3953: WF_CORE.Canonical_Date_Mask),
3954: l_params);

Line 3951: WF_EVENT.AddParameterToList('EXPIRATION_DATE',

3947: WF_EVENT.AddParameterToList('TERRITORY', SetRoleAttr.territory, l_params);
3948: WF_EVENT.AddParameterToList('EMAIL_ADDRESS', SetRoleAttr.email_address,
3949: l_params);
3950: WF_EVENT.AddParameterToList('FAX', SetRoleAttr.fax, l_params);
3951: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
3952: to_char(trunc(SetRoleAttr.expiration_date),
3953: WF_CORE.Canonical_Date_Mask),
3954: l_params);
3955: WF_EVENT.AddParameterToList('STATUS', SetRoleAttr.status, l_params);

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

3951: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
3952: to_char(trunc(SetRoleAttr.expiration_date),
3953: WF_CORE.Canonical_Date_Mask),
3954: l_params);
3955: WF_EVENT.AddParameterToList('STATUS', SetRoleAttr.status, l_params);
3956: WF_EVENT.AddParameterToList('START_DATE',
3957: to_char(trunc(SetRoleAttr.start_date),
3958: WF_CORE.Canonical_Date_Mask),
3959: l_params);

Line 3956: WF_EVENT.AddParameterToList('START_DATE',

3952: to_char(trunc(SetRoleAttr.expiration_date),
3953: WF_CORE.Canonical_Date_Mask),
3954: l_params);
3955: WF_EVENT.AddParameterToList('STATUS', SetRoleAttr.status, l_params);
3956: WF_EVENT.AddParameterToList('START_DATE',
3957: to_char(trunc(SetRoleAttr.start_date),
3958: WF_CORE.Canonical_Date_Mask),
3959: l_params);
3960: if ((((l_oldStartDate is NOT NULL) and

Line 3966: WF_EVENT.AddParameterToList('OLD_START_DATE',

3962: (trunc(l_oldStartDate) <> trunc(SetRoleAttr.start_date))) or
3963: ((l_oldStartDate is NULL and SetRoleAttr.start_date is NOT NULL) or
3964: (SetRoleAttr.start_date is NULL and l_oldStartDate is NOT NULL))) then
3965:
3966: WF_EVENT.AddParameterToList('OLD_START_DATE',
3967: to_char(trunc(l_oldStartDate),
3968: WF_CORE.Canonical_Date_Mask),
3969: l_params);
3970: else

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

3967: to_char(trunc(l_oldStartDate),
3968: WF_CORE.Canonical_Date_Mask),
3969: l_params);
3970: else
3971: WF_EVENT.AddParameterToList('OLD_START_DATE', '*UNDEFINED*',
3972: l_params);
3973: end if;
3974:
3975: if ((((l_oldEndDate is NOT NULL) and

Line 3982: WF_EVENT.AddParameterToList('OLD_END_DATE',

3978: ((l_oldEndDate is NULL and SetRoleAttr.expiration_date is NOT NULL)
3979: or (SetRoleAttr.expiration_date is NULL
3980: and l_oldEndDate is NOT NULL))) then
3981:
3982: WF_EVENT.AddParameterToList('OLD_END_DATE',
3983: to_char(trunc(l_oldEndDate),
3984: WF_CORE.Canonical_Date_Mask),
3985: l_params);
3986: else

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

3983: to_char(trunc(l_oldEndDate),
3984: WF_CORE.Canonical_Date_Mask),
3985: l_params);
3986: else
3987: WF_EVENT.AddParameterToList('OLD_END_DATE', '*UNDEFINED*',
3988: l_params);
3989: end if;
3990:
3991: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',

Line 3991: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',

3987: WF_EVENT.AddParameterToList('OLD_END_DATE', '*UNDEFINED*',
3988: l_params);
3989: end if;
3990:
3991: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
3992: SetRoleAttr.parent_orig_system, l_params);
3993: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
3994: to_char(SetRoleAttr.parent_orig_system_id ,
3995: WF_CORE.canonical_number_mask),l_params);

Line 3993: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',

3989: end if;
3990:
3991: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
3992: SetRoleAttr.parent_orig_system, l_params);
3993: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
3994: to_char(SetRoleAttr.parent_orig_system_id ,
3995: WF_CORE.canonical_number_mask),l_params);
3996:
3997: WF_EVENT.AddParameterToList('OWNER_TAG', SetRoleAttr.owner_tag, l_params);

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

3993: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
3994: to_char(SetRoleAttr.parent_orig_system_id ,
3995: WF_CORE.canonical_number_mask),l_params);
3996:
3997: WF_EVENT.AddParameterToList('OWNER_TAG', SetRoleAttr.owner_tag, l_params);
3998: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
3999: to_char(SetRoleAttr.last_updated_by ,
4000: WF_CORE.canonical_number_mask), l_params);
4001: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',

Line 3998: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',

3994: to_char(SetRoleAttr.parent_orig_system_id ,
3995: WF_CORE.canonical_number_mask),l_params);
3996:
3997: WF_EVENT.AddParameterToList('OWNER_TAG', SetRoleAttr.owner_tag, l_params);
3998: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
3999: to_char(SetRoleAttr.last_updated_by ,
4000: WF_CORE.canonical_number_mask), l_params);
4001: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
4002: to_char(SetRoleAttr.last_update_date,

Line 4001: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',

3997: WF_EVENT.AddParameterToList('OWNER_TAG', SetRoleAttr.owner_tag, l_params);
3998: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
3999: to_char(SetRoleAttr.last_updated_by ,
4000: WF_CORE.canonical_number_mask), l_params);
4001: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
4002: to_char(SetRoleAttr.last_update_date,
4003: WF_CORE.canonical_date_mask), l_params);
4004: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
4005: to_char(SetRoleAttr.last_update_login ,

Line 4004: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',

4000: WF_CORE.canonical_number_mask), l_params);
4001: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
4002: to_char(SetRoleAttr.last_update_date,
4003: WF_CORE.canonical_date_mask), l_params);
4004: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
4005: to_char(SetRoleAttr.last_update_login ,
4006: WF_CORE.canonical_number_mask), l_params);
4007: if (eventParams is not null and eventParams.count>0) then
4008: for i in eventParams.first..eventParams.last loop

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

4005: to_char(SetRoleAttr.last_update_login ,
4006: WF_CORE.canonical_number_mask), l_params);
4007: if (eventParams is not null and eventParams.count>0) then
4008: for i in eventParams.first..eventParams.last loop
4009: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),
4010: eventParams(i).getValue(),l_params);
4011: end loop;
4012: end if;
4013: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.role.updated',

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

4009: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),
4010: eventParams(i).getValue(),l_params);
4011: end loop;
4012: end if;
4013: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.role.updated',
4014: p_event_key=>role_name, p_parameters=>l_params);
4015:
4016: exception
4017: when others then

Line 4761: -- p_event (WF_EVENT_T)

4757: -- Change_Name_References_RF (PRIVATE)
4758: --
4759: -- IN
4760: -- p_sub_guid (RAW)
4761: -- p_event (WF_EVENT_T)
4762: --
4763: -- RETURNS
4764: -- varchar2
4765: --

Line 4773: p_event in out NOCOPY WF_EVENT_T )

4769: -- set as deferred to offline the updates to return control back to the user
4770: -- more quickly.
4771: --
4772: function Change_Name_References_RF( p_sub_guid in RAW,
4773: p_event in out NOCOPY WF_EVENT_T )
4774: return VARCHAR2 is
4775: l_newName VARCHAR2(360);
4776: l_oldName VARCHAR2(360);
4777: