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_ROLE_HIERARCHY dependencies on WF_CORE

Line 74: WF_CORE.Context('WF_ROLE_HIERARCHY', 'RaiseEvent', p_eventName,

70: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
71: g_modulePkg||'.RaiseEvent',
72: 'Exception: '||sqlerrm);
73: end if;
74: WF_CORE.Context('WF_ROLE_HIERARCHY', 'RaiseEvent', p_eventName,
75: p_relationshipID, p_superName, p_subName);
76: raise;
77: end RaiseEvent;
78:

Line 167: WF_CORE.Context('WF_ROLE_HIERARCHY', 'HierarchyEnabled', p_origSystem);

163: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
164: g_modulePkg||'.HierarchyEnabled',
165: 'Exception: '||sqlerrm);
166: end if;
167: WF_CORE.Context('WF_ROLE_HIERARCHY', 'HierarchyEnabled', p_origSystem);
168: raise;
169:
170: end HierarchyEnabled;
171:

Line 215: to_char(p_startDate,WF_CORE.canonical_date_mask)|| ', ' ||

211: -- BINDVAR_SCAN_IGNORE[9]
212: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
213: g_modulePkg||'.Calculate_Effective_Dates',
214: 'Begin Calculate_Effective_Dates('||
215: to_char(p_startDate,WF_CORE.canonical_date_mask)|| ', ' ||
216: to_char(p_endDate,WF_CORE.canonical_date_mask)|| ', ' ||
217: to_char(p_userStartDate,WF_CORE.canonical_date_mask)||', '||
218: to_char(p_userEndDate,WF_CORE.canonical_date_mask)||', ' ||
219: to_char(p_roleStartDate,WF_CORE.canonical_date_mask)||', '||

Line 216: to_char(p_endDate,WF_CORE.canonical_date_mask)|| ', ' ||

212: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
213: g_modulePkg||'.Calculate_Effective_Dates',
214: 'Begin Calculate_Effective_Dates('||
215: to_char(p_startDate,WF_CORE.canonical_date_mask)|| ', ' ||
216: to_char(p_endDate,WF_CORE.canonical_date_mask)|| ', ' ||
217: to_char(p_userStartDate,WF_CORE.canonical_date_mask)||', '||
218: to_char(p_userEndDate,WF_CORE.canonical_date_mask)||', ' ||
219: to_char(p_roleStartDate,WF_CORE.canonical_date_mask)||', '||
220: to_char(p_roleEndDate,WF_CORE.canonical_date_mask)||', '||

Line 217: to_char(p_userStartDate,WF_CORE.canonical_date_mask)||', '||

213: g_modulePkg||'.Calculate_Effective_Dates',
214: 'Begin Calculate_Effective_Dates('||
215: to_char(p_startDate,WF_CORE.canonical_date_mask)|| ', ' ||
216: to_char(p_endDate,WF_CORE.canonical_date_mask)|| ', ' ||
217: to_char(p_userStartDate,WF_CORE.canonical_date_mask)||', '||
218: to_char(p_userEndDate,WF_CORE.canonical_date_mask)||', ' ||
219: to_char(p_roleStartDate,WF_CORE.canonical_date_mask)||', '||
220: to_char(p_roleEndDate,WF_CORE.canonical_date_mask)||', '||
221: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask)||', '||

Line 218: to_char(p_userEndDate,WF_CORE.canonical_date_mask)||', ' ||

214: 'Begin Calculate_Effective_Dates('||
215: to_char(p_startDate,WF_CORE.canonical_date_mask)|| ', ' ||
216: to_char(p_endDate,WF_CORE.canonical_date_mask)|| ', ' ||
217: to_char(p_userStartDate,WF_CORE.canonical_date_mask)||', '||
218: to_char(p_userEndDate,WF_CORE.canonical_date_mask)||', ' ||
219: to_char(p_roleStartDate,WF_CORE.canonical_date_mask)||', '||
220: to_char(p_roleEndDate,WF_CORE.canonical_date_mask)||', '||
221: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask)||', '||
222: to_char(p_assignRoleEnd,WF_CORE.canonical_date_mask)||', '||

Line 219: to_char(p_roleStartDate,WF_CORE.canonical_date_mask)||', '||

215: to_char(p_startDate,WF_CORE.canonical_date_mask)|| ', ' ||
216: to_char(p_endDate,WF_CORE.canonical_date_mask)|| ', ' ||
217: to_char(p_userStartDate,WF_CORE.canonical_date_mask)||', '||
218: to_char(p_userEndDate,WF_CORE.canonical_date_mask)||', ' ||
219: to_char(p_roleStartDate,WF_CORE.canonical_date_mask)||', '||
220: to_char(p_roleEndDate,WF_CORE.canonical_date_mask)||', '||
221: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask)||', '||
222: to_char(p_assignRoleEnd,WF_CORE.canonical_date_mask)||', '||
223: to_char( p_effStartDate,WF_CORE.canonical_date_mask)||', '||

Line 220: to_char(p_roleEndDate,WF_CORE.canonical_date_mask)||', '||

216: to_char(p_endDate,WF_CORE.canonical_date_mask)|| ', ' ||
217: to_char(p_userStartDate,WF_CORE.canonical_date_mask)||', '||
218: to_char(p_userEndDate,WF_CORE.canonical_date_mask)||', ' ||
219: to_char(p_roleStartDate,WF_CORE.canonical_date_mask)||', '||
220: to_char(p_roleEndDate,WF_CORE.canonical_date_mask)||', '||
221: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask)||', '||
222: to_char(p_assignRoleEnd,WF_CORE.canonical_date_mask)||', '||
223: to_char( p_effStartDate,WF_CORE.canonical_date_mask)||', '||
224: to_char(p_effEndDate,WF_CORE.canonical_date_mask)||')');

Line 221: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask)||', '||

217: to_char(p_userStartDate,WF_CORE.canonical_date_mask)||', '||
218: to_char(p_userEndDate,WF_CORE.canonical_date_mask)||', ' ||
219: to_char(p_roleStartDate,WF_CORE.canonical_date_mask)||', '||
220: to_char(p_roleEndDate,WF_CORE.canonical_date_mask)||', '||
221: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask)||', '||
222: to_char(p_assignRoleEnd,WF_CORE.canonical_date_mask)||', '||
223: to_char( p_effStartDate,WF_CORE.canonical_date_mask)||', '||
224: to_char(p_effEndDate,WF_CORE.canonical_date_mask)||')');
225: end if;

Line 222: to_char(p_assignRoleEnd,WF_CORE.canonical_date_mask)||', '||

218: to_char(p_userEndDate,WF_CORE.canonical_date_mask)||', ' ||
219: to_char(p_roleStartDate,WF_CORE.canonical_date_mask)||', '||
220: to_char(p_roleEndDate,WF_CORE.canonical_date_mask)||', '||
221: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask)||', '||
222: to_char(p_assignRoleEnd,WF_CORE.canonical_date_mask)||', '||
223: to_char( p_effStartDate,WF_CORE.canonical_date_mask)||', '||
224: to_char(p_effEndDate,WF_CORE.canonical_date_mask)||')');
225: end if;
226: --Intialize effective start date to beginning of time

Line 223: to_char( p_effStartDate,WF_CORE.canonical_date_mask)||', '||

219: to_char(p_roleStartDate,WF_CORE.canonical_date_mask)||', '||
220: to_char(p_roleEndDate,WF_CORE.canonical_date_mask)||', '||
221: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask)||', '||
222: to_char(p_assignRoleEnd,WF_CORE.canonical_date_mask)||', '||
223: to_char( p_effStartDate,WF_CORE.canonical_date_mask)||', '||
224: to_char(p_effEndDate,WF_CORE.canonical_date_mask)||')');
225: end if;
226: --Intialize effective start date to beginning of time
227: p_effStartDate := to_date(1,'J');

Line 224: to_char(p_effEndDate,WF_CORE.canonical_date_mask)||')');

220: to_char(p_roleEndDate,WF_CORE.canonical_date_mask)||', '||
221: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask)||', '||
222: to_char(p_assignRoleEnd,WF_CORE.canonical_date_mask)||', '||
223: to_char( p_effStartDate,WF_CORE.canonical_date_mask)||', '||
224: to_char(p_effEndDate,WF_CORE.canonical_date_mask)||')');
225: end if;
226: --Intialize effective start date to beginning of time
227: p_effStartDate := to_date(1,'J');
228: --The effective start should be the greatest of all start dates.

Line 256: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Calculate_Effective_Dates',

252: g_modulePkg||'.Calculate_Effective_Dates',
253: 'Exception: '||sqlerrm);
254: end if;
255:
256: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Calculate_Effective_Dates',
257: to_char(p_startDate,WF_CORE.canonical_date_mask),
258: to_char(p_endDate,WF_CORE.canonical_date_mask),
259: to_char(p_userStartDate,WF_CORE.canonical_date_mask),
260: to_char(p_userEndDate,WF_CORE.canonical_date_mask),

Line 257: to_char(p_startDate,WF_CORE.canonical_date_mask),

253: 'Exception: '||sqlerrm);
254: end if;
255:
256: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Calculate_Effective_Dates',
257: to_char(p_startDate,WF_CORE.canonical_date_mask),
258: to_char(p_endDate,WF_CORE.canonical_date_mask),
259: to_char(p_userStartDate,WF_CORE.canonical_date_mask),
260: to_char(p_userEndDate,WF_CORE.canonical_date_mask),
261: to_char(p_roleStartDate,WF_CORE.canonical_date_mask),

Line 258: to_char(p_endDate,WF_CORE.canonical_date_mask),

254: end if;
255:
256: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Calculate_Effective_Dates',
257: to_char(p_startDate,WF_CORE.canonical_date_mask),
258: to_char(p_endDate,WF_CORE.canonical_date_mask),
259: to_char(p_userStartDate,WF_CORE.canonical_date_mask),
260: to_char(p_userEndDate,WF_CORE.canonical_date_mask),
261: to_char(p_roleStartDate,WF_CORE.canonical_date_mask),
262: to_char(p_roleEndDate,WF_CORE.canonical_date_mask),

Line 259: to_char(p_userStartDate,WF_CORE.canonical_date_mask),

255:
256: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Calculate_Effective_Dates',
257: to_char(p_startDate,WF_CORE.canonical_date_mask),
258: to_char(p_endDate,WF_CORE.canonical_date_mask),
259: to_char(p_userStartDate,WF_CORE.canonical_date_mask),
260: to_char(p_userEndDate,WF_CORE.canonical_date_mask),
261: to_char(p_roleStartDate,WF_CORE.canonical_date_mask),
262: to_char(p_roleEndDate,WF_CORE.canonical_date_mask),
263: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask),

Line 260: to_char(p_userEndDate,WF_CORE.canonical_date_mask),

256: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Calculate_Effective_Dates',
257: to_char(p_startDate,WF_CORE.canonical_date_mask),
258: to_char(p_endDate,WF_CORE.canonical_date_mask),
259: to_char(p_userStartDate,WF_CORE.canonical_date_mask),
260: to_char(p_userEndDate,WF_CORE.canonical_date_mask),
261: to_char(p_roleStartDate,WF_CORE.canonical_date_mask),
262: to_char(p_roleEndDate,WF_CORE.canonical_date_mask),
263: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask),
264: to_char(p_assignRoleEnd,WF_CORE.canonical_date_mask),

Line 261: to_char(p_roleStartDate,WF_CORE.canonical_date_mask),

257: to_char(p_startDate,WF_CORE.canonical_date_mask),
258: to_char(p_endDate,WF_CORE.canonical_date_mask),
259: to_char(p_userStartDate,WF_CORE.canonical_date_mask),
260: to_char(p_userEndDate,WF_CORE.canonical_date_mask),
261: to_char(p_roleStartDate,WF_CORE.canonical_date_mask),
262: to_char(p_roleEndDate,WF_CORE.canonical_date_mask),
263: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask),
264: to_char(p_assignRoleEnd,WF_CORE.canonical_date_mask),
265: to_char(p_effStartDate,WF_CORE.canonical_date_mask),

Line 262: to_char(p_roleEndDate,WF_CORE.canonical_date_mask),

258: to_char(p_endDate,WF_CORE.canonical_date_mask),
259: to_char(p_userStartDate,WF_CORE.canonical_date_mask),
260: to_char(p_userEndDate,WF_CORE.canonical_date_mask),
261: to_char(p_roleStartDate,WF_CORE.canonical_date_mask),
262: to_char(p_roleEndDate,WF_CORE.canonical_date_mask),
263: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask),
264: to_char(p_assignRoleEnd,WF_CORE.canonical_date_mask),
265: to_char(p_effStartDate,WF_CORE.canonical_date_mask),
266: to_char(p_effEndDate,WF_CORE.canonical_date_mask));

Line 263: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask),

259: to_char(p_userStartDate,WF_CORE.canonical_date_mask),
260: to_char(p_userEndDate,WF_CORE.canonical_date_mask),
261: to_char(p_roleStartDate,WF_CORE.canonical_date_mask),
262: to_char(p_roleEndDate,WF_CORE.canonical_date_mask),
263: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask),
264: to_char(p_assignRoleEnd,WF_CORE.canonical_date_mask),
265: to_char(p_effStartDate,WF_CORE.canonical_date_mask),
266: to_char(p_effEndDate,WF_CORE.canonical_date_mask));
267:

Line 264: to_char(p_assignRoleEnd,WF_CORE.canonical_date_mask),

260: to_char(p_userEndDate,WF_CORE.canonical_date_mask),
261: to_char(p_roleStartDate,WF_CORE.canonical_date_mask),
262: to_char(p_roleEndDate,WF_CORE.canonical_date_mask),
263: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask),
264: to_char(p_assignRoleEnd,WF_CORE.canonical_date_mask),
265: to_char(p_effStartDate,WF_CORE.canonical_date_mask),
266: to_char(p_effEndDate,WF_CORE.canonical_date_mask));
267:
268: raise;

Line 265: to_char(p_effStartDate,WF_CORE.canonical_date_mask),

261: to_char(p_roleStartDate,WF_CORE.canonical_date_mask),
262: to_char(p_roleEndDate,WF_CORE.canonical_date_mask),
263: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask),
264: to_char(p_assignRoleEnd,WF_CORE.canonical_date_mask),
265: to_char(p_effStartDate,WF_CORE.canonical_date_mask),
266: to_char(p_effEndDate,WF_CORE.canonical_date_mask));
267:
268: raise;
269: end Calculate_Effective_Dates;

Line 266: to_char(p_effEndDate,WF_CORE.canonical_date_mask));

262: to_char(p_roleEndDate,WF_CORE.canonical_date_mask),
263: to_char(p_assignRoleStart,WF_CORE.canonical_date_mask),
264: to_char(p_assignRoleEnd,WF_CORE.canonical_date_mask),
265: to_char(p_effStartDate,WF_CORE.canonical_date_mask),
266: to_char(p_effEndDate,WF_CORE.canonical_date_mask));
267:
268: raise;
269: end Calculate_Effective_Dates;
270:

Line 437: WF_CORE.canonical_date_mask);

433: 'Retrieving parameters from the event.');
434: end if;
435: l_RoleName := p_event.getValueForParameter('ROLE_NAME');
436: l_StartDate := to_date(p_event.getValueForParameter('START_DATE'),
437: WF_CORE.canonical_date_mask);
438: l_EndDate := to_date(p_event.getValueForParameter('END_DATE'),
439: WF_CORE.canonical_date_mask);
440: l_UserName := p_event.getValueForParameter('USER_NAME');
441: l_UserOrigSystem := p_event.getValueForParameter('USER_ORIG_SYSTEM');

Line 439: WF_CORE.canonical_date_mask);

435: l_RoleName := p_event.getValueForParameter('ROLE_NAME');
436: l_StartDate := to_date(p_event.getValueForParameter('START_DATE'),
437: WF_CORE.canonical_date_mask);
438: l_EndDate := to_date(p_event.getValueForParameter('END_DATE'),
439: WF_CORE.canonical_date_mask);
440: l_UserName := p_event.getValueForParameter('USER_NAME');
441: l_UserOrigSystem := p_event.getValueForParameter('USER_ORIG_SYSTEM');
442: l_UserOrigSystemID := to_number(p_event.getValueForParameter(
443: 'USER_ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);

Line 443: 'USER_ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);

439: WF_CORE.canonical_date_mask);
440: l_UserName := p_event.getValueForParameter('USER_NAME');
441: l_UserOrigSystem := p_event.getValueForParameter('USER_ORIG_SYSTEM');
442: l_UserOrigSystemID := to_number(p_event.getValueForParameter(
443: 'USER_ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);
444: l_RoleOrigSystem := p_event.getValueForParameter('ROLE_ORIG_SYSTEM');
445: l_RoleOrigSystemID := to_number(p_event.getValueForParameter(
446: 'ROLE_ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);
447: l_OwnerTag := p_event.getValueForParameter('OWNER_TAG');

Line 446: 'ROLE_ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);

442: l_UserOrigSystemID := to_number(p_event.getValueForParameter(
443: 'USER_ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);
444: l_RoleOrigSystem := p_event.getValueForParameter('ROLE_ORIG_SYSTEM');
445: l_RoleOrigSystemID := to_number(p_event.getValueForParameter(
446: 'ROLE_ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);
447: l_OwnerTag := p_event.getValueForParameter('OWNER_TAG');
448: l_CreatedBy := to_number(p_event.getValueForParameter('CREATED_BY'),
449: WF_CORE.canonical_number_mask);
450: l_CreationDate := to_date(p_event.getValueForParameter('CREATION_DATE'),

Line 449: WF_CORE.canonical_number_mask);

445: l_RoleOrigSystemID := to_number(p_event.getValueForParameter(
446: 'ROLE_ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);
447: l_OwnerTag := p_event.getValueForParameter('OWNER_TAG');
448: l_CreatedBy := to_number(p_event.getValueForParameter('CREATED_BY'),
449: WF_CORE.canonical_number_mask);
450: l_CreationDate := to_date(p_event.getValueForParameter('CREATION_DATE'),
451: WF_CORE.canonical_date_mask);
452: l_LastUpdatedBy := to_number(p_event.getValueForParameter(
453: 'LAST_UPDATED_BY'), WF_CORE.canonical_number_mask);

Line 451: WF_CORE.canonical_date_mask);

447: l_OwnerTag := p_event.getValueForParameter('OWNER_TAG');
448: l_CreatedBy := to_number(p_event.getValueForParameter('CREATED_BY'),
449: WF_CORE.canonical_number_mask);
450: l_CreationDate := to_date(p_event.getValueForParameter('CREATION_DATE'),
451: WF_CORE.canonical_date_mask);
452: l_LastUpdatedBy := to_number(p_event.getValueForParameter(
453: 'LAST_UPDATED_BY'), WF_CORE.canonical_number_mask);
454: l_LastUpdateDate := to_date(p_event.getValueForParameter(
455: 'LAST_UPDATE_DATE'),

Line 453: 'LAST_UPDATED_BY'), WF_CORE.canonical_number_mask);

449: WF_CORE.canonical_number_mask);
450: l_CreationDate := to_date(p_event.getValueForParameter('CREATION_DATE'),
451: WF_CORE.canonical_date_mask);
452: l_LastUpdatedBy := to_number(p_event.getValueForParameter(
453: 'LAST_UPDATED_BY'), WF_CORE.canonical_number_mask);
454: l_LastUpdateDate := to_date(p_event.getValueForParameter(
455: 'LAST_UPDATE_DATE'),
456: WF_CORE.canonical_date_mask);
457: l_LastUpdateLogin := to_number(p_event.getValueForParameter(

Line 456: WF_CORE.canonical_date_mask);

452: l_LastUpdatedBy := to_number(p_event.getValueForParameter(
453: 'LAST_UPDATED_BY'), WF_CORE.canonical_number_mask);
454: l_LastUpdateDate := to_date(p_event.getValueForParameter(
455: 'LAST_UPDATE_DATE'),
456: WF_CORE.canonical_date_mask);
457: l_LastUpdateLogin := to_number(p_event.getValueForParameter(
458: 'LAST_UPDATE_LOGIN'), WF_CORE.canonical_number_mask);
459: l_assignmentReason := p_event.getValueForParameter('ASSIGNMENT_REASON');
460: l_rowid := chartorowid(p_event.getValueForParameter('ROWID'));

Line 458: 'LAST_UPDATE_LOGIN'), WF_CORE.canonical_number_mask);

454: l_LastUpdateDate := to_date(p_event.getValueForParameter(
455: 'LAST_UPDATE_DATE'),
456: WF_CORE.canonical_date_mask);
457: l_LastUpdateLogin := to_number(p_event.getValueForParameter(
458: 'LAST_UPDATE_LOGIN'), WF_CORE.canonical_number_mask);
459: l_assignmentReason := p_event.getValueForParameter('ASSIGNMENT_REASON');
460: l_rowid := chartorowid(p_event.getValueForParameter('ROWID'));
461: if (p_event.getValueForParameter('WFSYNCH_OVERWRITE') ='TRUE') then
462: OverWrite := TRUE;

Line 950: if (WF_CORE.error_name = 'WF_DUP_USER_ROLE') then

946: assignment_type=>'I');
947:
948: exception
949: when OTHERS then
950: if (WF_CORE.error_name = 'WF_DUP_USER_ROLE') then
951: --Updating the existing user/role with an assignment_type of 'X'.
952: --The recursive call to cascade_RF() will validate the
953: --assignment_type and set it to the proper value.
954: WF_CORE.Clear;

Line 954: WF_CORE.Clear;

950: if (WF_CORE.error_name = 'WF_DUP_USER_ROLE') then
951: --Updating the existing user/role with an assignment_type of 'X'.
952: --The recursive call to cascade_RF() will validate the
953: --assignment_type and set it to the proper value.
954: WF_CORE.Clear;
955: WF_DIRECTORY.SetUserRoleAttr(user_name=>l_UserName,
956: role_name=>l_superiors(l_count).SUPER_NAME,
957: start_date=>l_startDate,
958: end_date=>l_endDate,

Line 970: WF_CORE.Context('WF_ROLE_HIERARCHY','Cascade_RF',

966: assignment_type=>'X',
967: updateWho=>UpdateWho);
968:
969: else
970: WF_CORE.Context('WF_ROLE_HIERARCHY','Cascade_RF',
971: p_event.getEventName( ), p_sub_guid);
972:
973: WF_EVENT.setErrorInfo(p_event, 'ERROR');
974:

Line 1579: WF_CORE.Clear;

1575: end if;
1576:
1577: retcode := '2';
1578: errbuf := sqlerrm;
1579: WF_CORE.Clear;
1580: end Propagate_CP;
1581:
1582:
1583: -- Denormalize_UR_Assignments(PRIVATE)

Line 1674: 'LAST_UPDATED_BY'), WF_CORE.canonical_number_mask);

1670:
1671: l_RoleName := p_event.getValueForParameter('ROLE_NAME');
1672: l_UserName := p_event.getValueForParameter('USER_NAME');
1673: l_LastUpdatedBy := to_number(p_event.getValueForParameter(
1674: 'LAST_UPDATED_BY'), WF_CORE.canonical_number_mask);
1675: l_LastUpdateDate := nvl(to_date(p_event.getValueForParameter(
1676: 'LAST_UPDATE_DATE'),
1677: WF_CORE.canonical_date_mask),SYSDATE);
1678: l_LastUpdateLogin := to_number(p_event.getValueForParameter(

Line 1677: WF_CORE.canonical_date_mask),SYSDATE);

1673: l_LastUpdatedBy := to_number(p_event.getValueForParameter(
1674: 'LAST_UPDATED_BY'), WF_CORE.canonical_number_mask);
1675: l_LastUpdateDate := nvl(to_date(p_event.getValueForParameter(
1676: 'LAST_UPDATE_DATE'),
1677: WF_CORE.canonical_date_mask),SYSDATE);
1678: l_LastUpdateLogin := to_number(p_event.getValueForParameter(
1679: 'LAST_UPDATE_LOGIN'), WF_CORE.canonical_number_mask);
1680:
1681: l_OrigSystem := p_event.getValueForParameter('ORIG_SYSTEM');

Line 1679: 'LAST_UPDATE_LOGIN'), WF_CORE.canonical_number_mask);

1675: l_LastUpdateDate := nvl(to_date(p_event.getValueForParameter(
1676: 'LAST_UPDATE_DATE'),
1677: WF_CORE.canonical_date_mask),SYSDATE);
1678: l_LastUpdateLogin := to_number(p_event.getValueForParameter(
1679: 'LAST_UPDATE_LOGIN'), WF_CORE.canonical_number_mask);
1680:
1681: l_OrigSystem := p_event.getValueForParameter('ORIG_SYSTEM');
1682: l_OrigSystemID := to_number(p_event.getValueForParameter(
1683: 'ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);

Line 1683: 'ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);

1679: 'LAST_UPDATE_LOGIN'), WF_CORE.canonical_number_mask);
1680:
1681: l_OrigSystem := p_event.getValueForParameter('ORIG_SYSTEM');
1682: l_OrigSystemID := to_number(p_event.getValueForParameter(
1683: 'ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);
1684: l_StartDate := trunc(to_date(p_event.getValueForParameter('START_DATE'),
1685: WF_CORE.canonical_date_mask));
1686: l_EndDate:= trunc(to_date(p_event.getValueForParameter('EXPIRATION_DATE'),
1687: WF_CORE.canonical_date_mask));

Line 1685: WF_CORE.canonical_date_mask));

1681: l_OrigSystem := p_event.getValueForParameter('ORIG_SYSTEM');
1682: l_OrigSystemID := to_number(p_event.getValueForParameter(
1683: 'ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);
1684: l_StartDate := trunc(to_date(p_event.getValueForParameter('START_DATE'),
1685: WF_CORE.canonical_date_mask));
1686: l_EndDate:= trunc(to_date(p_event.getValueForParameter('EXPIRATION_DATE'),
1687: WF_CORE.canonical_date_mask));
1688:
1689: if (l_userName is NOT NULL and l_roleName is NOT NULL) then

Line 1687: WF_CORE.canonical_date_mask));

1683: 'ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);
1684: l_StartDate := trunc(to_date(p_event.getValueForParameter('START_DATE'),
1685: WF_CORE.canonical_date_mask));
1686: l_EndDate:= trunc(to_date(p_event.getValueForParameter('EXPIRATION_DATE'),
1687: WF_CORE.canonical_date_mask));
1688:
1689: if (l_userName is NOT NULL and l_roleName is NOT NULL) then
1690: open c_userRoleAssignments (l_userName , l_roleName);
1691: elsif (l_userName is NOT NULL) then

Line 1850: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Denormalize_UR_Assignments',

1846: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
1847: g_modulePkg||'.Denormalize_UR_Assignments',
1848: 'Exception: '||sqlerrm);
1849: end if;
1850: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Denormalize_UR_Assignments',
1851: p_event.getEventName);
1852: raise;
1853:
1854:

Line 2010: WF_CORE.canonical_date_mask),SYSDATE);

2006: /* l_LastUpdatedBy := to_number(p_event.getValueForParameter(
2007: 'LAST_UPDATED_BY'));
2008: l_LastUpdateDate := nvl(to_date(p_event.getValueForParameter(
2009: 'LAST_UPDATE_DATE'),
2010: WF_CORE.canonical_date_mask),SYSDATE);
2011: l_LastUpdateLogin := to_number(p_event.getValueForParameter(
2012: 'LAST_UPDATE_LOGIN'));
2013: l_CreatedBy := to_number(p_event.getValueForParameter('CREATED_BY'));
2014: l_CreationDate := to_date(p_event.getValueForParameter('CREATION_DATE'),

Line 2015: WF_CORE.canonical_date_mask);*/

2011: l_LastUpdateLogin := to_number(p_event.getValueForParameter(
2012: 'LAST_UPDATE_LOGIN'));
2013: l_CreatedBy := to_number(p_event.getValueForParameter('CREATED_BY'));
2014: l_CreationDate := to_date(p_event.getValueForParameter('CREATION_DATE'),
2015: WF_CORE.canonical_date_mask);*/
2016:
2017: if (p_event.getValueForParameter('WFSYNCH_OVERWRITE') ='TRUE') then
2018: OverWrite := TRUE;
2019: else

Line 2334: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Aggregate_User_Roles_RF',

2330: elsif c_UserRoleAssignments_r%ISOPEN then
2331: close c_UserRoleAssignments_r;
2332: end if;
2333:
2334: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Aggregate_User_Roles_RF',
2335: p_event.getEventName( ), p_sub_guid);
2336:
2337: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2338: return 'ERROR';

Line 2420: WF_CORE.Context('WF_ROLE_HIERARCHY', 'GetRelationships', p_name);

2416: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2417: g_modulePkg||'.GetRelationships', 'Exception: '||
2418: sqlerrm);
2419: end if;
2420: WF_CORE.Context('WF_ROLE_HIERARCHY', 'GetRelationships', p_name);
2421: raise;
2422:
2423: end GetRelationships;
2424:

Line 2545: WF_CORE.Context('WF_ROLE_HIERARCHY', 'GetAllRelationships', p_name);

2541: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2542: g_modulePkg||'.GetAllRelationships', 'Exception: '||
2543: sqlerrm);
2544: end if;
2545: WF_CORE.Context('WF_ROLE_HIERARCHY', 'GetAllRelationships', p_name);
2546: raise;
2547:
2548: end GetAllRelationships;
2549:

Line 2609: WF_CORE.Token('NAME', p_sub_name);

2605: FROM WF_LOCAL_ROLES
2606: WHERE NAME = p_sub_name;
2607: exception
2608: when NO_DATA_FOUND then
2609: WF_CORE.Token('NAME', p_sub_name);
2610: WF_CORE.Raise('WF_NO_ROLE');
2611: end;
2612:
2613: begin

Line 2610: WF_CORE.Raise('WF_NO_ROLE');

2606: WHERE NAME = p_sub_name;
2607: exception
2608: when NO_DATA_FOUND then
2609: WF_CORE.Token('NAME', p_sub_name);
2610: WF_CORE.Raise('WF_NO_ROLE');
2611: end;
2612:
2613: begin
2614: SELECT ORIG_SYSTEM, PARTITION_ID

Line 2620: WF_CORE.Token('NAME', p_super_name);

2616: FROM WF_LOCAL_ROLES
2617: WHERE NAME = p_super_name;
2618: exception
2619: when NO_DATA_FOUND then
2620: WF_CORE.Token('NAME', p_super_name);
2621: WF_CORE.Raise('WF_NO_ROLE');
2622: end;
2623:
2624: -- Obtain the relationship_id from WF_ROLE_HIERARCHIES_S.

Line 2621: WF_CORE.Raise('WF_NO_ROLE');

2617: WHERE NAME = p_super_name;
2618: exception
2619: when NO_DATA_FOUND then
2620: WF_CORE.Token('NAME', p_super_name);
2621: WF_CORE.Raise('WF_NO_ROLE');
2622: end;
2623:
2624: -- Obtain the relationship_id from WF_ROLE_HIERARCHIES_S.
2625: select WF_ROLE_HIERARCHIES_S.NEXTVAL

Line 2709: WF_CORE.Token('P_SUB_NAME', p_sub_name);

2705: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION, g_modulePkg||
2706: '.AddRelationship.Insert.DUP_VAL_ON_INDEX.NoUpdate',
2707: 'Active relationship exists, raising WFDS_DUP_HIERARCHY');
2708: end if;
2709: WF_CORE.Token('P_SUB_NAME', p_sub_name);
2710: WF_CORE.Token('P_SUPER_NAME', p_super_name);
2711: WF_CORE.Raise('WFDS_DUP_HIERARCHY');
2712: end if;
2713: -- If we are here then the ENABLED_FLAG is being changed, so we update

Line 2710: WF_CORE.Token('P_SUPER_NAME', p_super_name);

2706: '.AddRelationship.Insert.DUP_VAL_ON_INDEX.NoUpdate',
2707: 'Active relationship exists, raising WFDS_DUP_HIERARCHY');
2708: end if;
2709: WF_CORE.Token('P_SUB_NAME', p_sub_name);
2710: WF_CORE.Token('P_SUPER_NAME', p_super_name);
2711: WF_CORE.Raise('WFDS_DUP_HIERARCHY');
2712: end if;
2713: -- If we are here then the ENABLED_FLAG is being changed, so we update
2714: update WF_ROLE_HIERARCHIES set

Line 2711: WF_CORE.Raise('WFDS_DUP_HIERARCHY');

2707: 'Active relationship exists, raising WFDS_DUP_HIERARCHY');
2708: end if;
2709: WF_CORE.Token('P_SUB_NAME', p_sub_name);
2710: WF_CORE.Token('P_SUPER_NAME', p_super_name);
2711: WF_CORE.Raise('WFDS_DUP_HIERARCHY');
2712: end if;
2713: -- If we are here then the ENABLED_FLAG is being changed, so we update
2714: update WF_ROLE_HIERARCHIES set
2715: LAST_UPDATED_BY = WFA_SEC.USER_ID,

Line 2781: WF_CORE.Context('WF_ROLE_HIERARCHY', 'AddRelationship', p_sub_name,

2777: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2778: g_modulePkg||'.AddRelationship', 'Exception: '||
2779: sqlerrm);
2780: end if;
2781: WF_CORE.Context('WF_ROLE_HIERARCHY', 'AddRelationship', p_sub_name,
2782: p_super_name);
2783: WF_CORE.Raise('WFDS_HIERARCHY_LOOP');
2784:
2785: when OTHERS then

Line 2783: WF_CORE.Raise('WFDS_HIERARCHY_LOOP');

2779: sqlerrm);
2780: end if;
2781: WF_CORE.Context('WF_ROLE_HIERARCHY', 'AddRelationship', p_sub_name,
2782: p_super_name);
2783: WF_CORE.Raise('WFDS_HIERARCHY_LOOP');
2784:
2785: when OTHERS then
2786: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
2787: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,

Line 2791: WF_CORE.Context('WF_ROLE_HIERARCHY', 'AddRelationship', p_sub_name,

2787: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2788: g_modulePkg||'.AddRelationship', 'Exception: '||
2789: sqlerrm);
2790: end if;
2791: WF_CORE.Context('WF_ROLE_HIERARCHY', 'AddRelationship', p_sub_name,
2792: p_super_name);
2793: raise;
2794: end AddRelationship;
2795:

Line 2846: WF_CORE.Token('P_SUB_NAME', p_sub_name);

2842: '.ExpireRelationship.Update.NoActiveRelationship',
2843: 'No Active relationship exists, '||
2844: 'raising WFDS_NO_HIERARCHY');
2845: end if;
2846: WF_CORE.Token('P_SUB_NAME', p_sub_name);
2847: WF_CORE.Token('P_SUPER_NAME', p_super_name);
2848: WF_CORE.Raise('WFDS_NO_HIERARCHY');
2849: end if;
2850:

Line 2847: WF_CORE.Token('P_SUPER_NAME', p_super_name);

2843: 'No Active relationship exists, '||
2844: 'raising WFDS_NO_HIERARCHY');
2845: end if;
2846: WF_CORE.Token('P_SUB_NAME', p_sub_name);
2847: WF_CORE.Token('P_SUPER_NAME', p_super_name);
2848: WF_CORE.Raise('WFDS_NO_HIERARCHY');
2849: end if;
2850:
2851: end;

Line 2848: WF_CORE.Raise('WFDS_NO_HIERARCHY');

2844: 'raising WFDS_NO_HIERARCHY');
2845: end if;
2846: WF_CORE.Token('P_SUB_NAME', p_sub_name);
2847: WF_CORE.Token('P_SUPER_NAME', p_super_name);
2848: WF_CORE.Raise('WFDS_NO_HIERARCHY');
2849: end if;
2850:
2851: end;
2852:

Line 2877: WF_CORE.Context('WF_ROLE_HIERARCHY', 'ExpireRelationship', p_sub_name,

2873: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2874: g_modulePkg||'.ExpireRelationship', 'Exception: '||
2875: sqlerrm);
2876: end if;
2877: WF_CORE.Context('WF_ROLE_HIERARCHY', 'ExpireRelationship', p_sub_name,
2878: p_super_name);
2879: raise;
2880: end ExpireRelationship;
2881:

Line 2910: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Denormalize_User_Role_RF',

2906:
2907: exception
2908: when OTHERS then
2909:
2910: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Denormalize_User_Role_RF',
2911: p_event.getEventName( ), p_sub_guid);
2912:
2913: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2914: return 'ERROR';

Line 2931: select to_date(text, WF_CORE.canonical_date_mask)

2927: is
2928: l_updateTime DATE;
2929:
2930: begin
2931: select to_date(text, WF_CORE.canonical_date_mask)
2932: into l_UpdateTime
2933: from WF_RESOURCES
2934: where TYPE='WFTKN'
2935: and NAME = 'WFDS_HIERARCHY_UPD'

Line 2967: set text = to_char(g_trustTimeStamp, WF_CORE.canonical_date_mask)

2963:
2964: begin
2965: g_trustTimeStamp := sysdate;
2966: update WF_RESOURCES
2967: set text = to_char(g_trustTimeStamp, WF_CORE.canonical_date_mask)
2968: where name = 'WFDS_HIERARCHY_UPD';
2969:
2970: if (sql%rowcount = 0) then
2971: begin

Line 2986: WF_CORE.canonical_date_mask),

2982: 'US',
2983: 'US',
2984: 0,
2985: to_char(g_trustTimeStamp,
2986: WF_CORE.canonical_date_mask),
2987: 0,
2988: 0);
2989: exception
2990: when DUP_VAL_ON_INDEX then

Line 3030: wf_core.token('P_RELATIONSHIPID',p_relationshipID);

3026:
3027: if (l_enabled='Y') then
3028: if (p_forceRemove is null or not p_forceRemove) then
3029: -- raise error
3030: wf_core.token('P_RELATIONSHIPID',p_relationshipID);
3031: wf_core.raise('WFDS_ACTIVE_RELN');
3032: else
3033: --call API to expire this remationship forcefully
3034: l_relationshipID:=ExpireRelationship(l_subName,l_superName);

Line 3031: wf_core.raise('WFDS_ACTIVE_RELN');

3027: if (l_enabled='Y') then
3028: if (p_forceRemove is null or not p_forceRemove) then
3029: -- raise error
3030: wf_core.token('P_RELATIONSHIPID',p_relationshipID);
3031: wf_core.raise('WFDS_ACTIVE_RELN');
3032: else
3033: --call API to expire this remationship forcefully
3034: l_relationshipID:=ExpireRelationship(l_subName,l_superName);
3035: