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 927: if (WF_CORE.error_name = 'WF_DUP_USER_ROLE') then

923: assignment_type=>'I');
924:
925: exception
926: when OTHERS then
927: if (WF_CORE.error_name = 'WF_DUP_USER_ROLE') then
928: --Updating the existing user/role with an assignment_type of 'X'.
929: --The recursive call to cascade_RF() will validate the
930: --assignment_type and set it to the proper value.
931: WF_CORE.Clear;

Line 931: WF_CORE.Clear;

927: if (WF_CORE.error_name = 'WF_DUP_USER_ROLE') then
928: --Updating the existing user/role with an assignment_type of 'X'.
929: --The recursive call to cascade_RF() will validate the
930: --assignment_type and set it to the proper value.
931: WF_CORE.Clear;
932: WF_DIRECTORY.SetUserRoleAttr(user_name=>l_UserName,
933: role_name=>l_superiors(l_count).SUPER_NAME,
934: start_date=>l_startDate,
935: end_date=>l_endDate,

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

943: assignment_type=>'X',
944: updateWho=>UpdateWho);
945:
946: else
947: WF_CORE.Context('WF_ROLE_HIERARCHY','Cascade_RF',
948: p_event.getEventName( ), p_sub_guid);
949:
950: WF_EVENT.setErrorInfo(p_event, 'ERROR');
951:

Line 1551: WF_CORE.Clear;

1547: end if;
1548:
1549: retcode := '2';
1550: errbuf := sqlerrm;
1551: WF_CORE.Clear;
1552: end Propagate_CP;
1553:
1554:
1555: -- Denormalize_UR_Assignments(PRIVATE)

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

1642:
1643: l_RoleName := p_event.getValueForParameter('ROLE_NAME');
1644: l_UserName := p_event.getValueForParameter('USER_NAME');
1645: l_LastUpdatedBy := to_number(p_event.getValueForParameter(
1646: 'LAST_UPDATED_BY'), WF_CORE.canonical_number_mask);
1647: l_LastUpdateDate := nvl(to_date(p_event.getValueForParameter(
1648: 'LAST_UPDATE_DATE'),
1649: WF_CORE.canonical_date_mask),SYSDATE);
1650: l_LastUpdateLogin := to_number(p_event.getValueForParameter(

Line 1649: WF_CORE.canonical_date_mask),SYSDATE);

1645: l_LastUpdatedBy := to_number(p_event.getValueForParameter(
1646: 'LAST_UPDATED_BY'), WF_CORE.canonical_number_mask);
1647: l_LastUpdateDate := nvl(to_date(p_event.getValueForParameter(
1648: 'LAST_UPDATE_DATE'),
1649: WF_CORE.canonical_date_mask),SYSDATE);
1650: l_LastUpdateLogin := to_number(p_event.getValueForParameter(
1651: 'LAST_UPDATE_LOGIN'), WF_CORE.canonical_number_mask);
1652:
1653: l_OrigSystem := p_event.getValueForParameter('ORIG_SYSTEM');

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

1647: l_LastUpdateDate := nvl(to_date(p_event.getValueForParameter(
1648: 'LAST_UPDATE_DATE'),
1649: WF_CORE.canonical_date_mask),SYSDATE);
1650: l_LastUpdateLogin := to_number(p_event.getValueForParameter(
1651: 'LAST_UPDATE_LOGIN'), WF_CORE.canonical_number_mask);
1652:
1653: l_OrigSystem := p_event.getValueForParameter('ORIG_SYSTEM');
1654: l_OrigSystemID := to_number(p_event.getValueForParameter(
1655: 'ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);

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

1651: 'LAST_UPDATE_LOGIN'), WF_CORE.canonical_number_mask);
1652:
1653: l_OrigSystem := p_event.getValueForParameter('ORIG_SYSTEM');
1654: l_OrigSystemID := to_number(p_event.getValueForParameter(
1655: 'ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);
1656: l_StartDate := trunc(to_date(p_event.getValueForParameter('START_DATE'),
1657: WF_CORE.canonical_date_mask));
1658: l_EndDate:= trunc(to_date(p_event.getValueForParameter('EXPIRATION_DATE'),
1659: WF_CORE.canonical_date_mask));

Line 1657: WF_CORE.canonical_date_mask));

1653: l_OrigSystem := p_event.getValueForParameter('ORIG_SYSTEM');
1654: l_OrigSystemID := to_number(p_event.getValueForParameter(
1655: 'ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);
1656: l_StartDate := trunc(to_date(p_event.getValueForParameter('START_DATE'),
1657: WF_CORE.canonical_date_mask));
1658: l_EndDate:= trunc(to_date(p_event.getValueForParameter('EXPIRATION_DATE'),
1659: WF_CORE.canonical_date_mask));
1660:
1661: if (l_userName is NOT NULL and l_roleName is NOT NULL) then

Line 1659: WF_CORE.canonical_date_mask));

1655: 'ORIG_SYSTEM_ID'), WF_CORE.canonical_number_mask);
1656: l_StartDate := trunc(to_date(p_event.getValueForParameter('START_DATE'),
1657: WF_CORE.canonical_date_mask));
1658: l_EndDate:= trunc(to_date(p_event.getValueForParameter('EXPIRATION_DATE'),
1659: WF_CORE.canonical_date_mask));
1660:
1661: if (l_userName is NOT NULL and l_roleName is NOT NULL) then
1662: open c_userRoleAssignments (l_userName , l_roleName);
1663: elsif (l_userName is NOT NULL) then

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

1818: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
1819: g_modulePkg||'.Denormalize_UR_Assignments',
1820: 'Exception: '||sqlerrm);
1821: end if;
1822: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Denormalize_UR_Assignments',
1823: p_event.getEventName);
1824: raise;
1825:
1826:

Line 1982: WF_CORE.canonical_date_mask),SYSDATE);

1978: /* l_LastUpdatedBy := to_number(p_event.getValueForParameter(
1979: 'LAST_UPDATED_BY'));
1980: l_LastUpdateDate := nvl(to_date(p_event.getValueForParameter(
1981: 'LAST_UPDATE_DATE'),
1982: WF_CORE.canonical_date_mask),SYSDATE);
1983: l_LastUpdateLogin := to_number(p_event.getValueForParameter(
1984: 'LAST_UPDATE_LOGIN'));
1985: l_CreatedBy := to_number(p_event.getValueForParameter('CREATED_BY'));
1986: l_CreationDate := to_date(p_event.getValueForParameter('CREATION_DATE'),

Line 1987: WF_CORE.canonical_date_mask);*/

1983: l_LastUpdateLogin := to_number(p_event.getValueForParameter(
1984: 'LAST_UPDATE_LOGIN'));
1985: l_CreatedBy := to_number(p_event.getValueForParameter('CREATED_BY'));
1986: l_CreationDate := to_date(p_event.getValueForParameter('CREATION_DATE'),
1987: WF_CORE.canonical_date_mask);*/
1988:
1989: if (p_event.getValueForParameter('WFSYNCH_OVERWRITE') ='TRUE') then
1990: OverWrite := TRUE;
1991: else

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

2302: elsif c_UserRoleAssignments_r%ISOPEN then
2303: close c_UserRoleAssignments_r;
2304: end if;
2305:
2306: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Aggregate_User_Roles_RF',
2307: p_event.getEventName( ), p_sub_guid);
2308:
2309: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2310: return 'ERROR';

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

2458: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2459: g_modulePkg||'.GetRelationships', 'Exception: '||
2460: sqlerrm);
2461: end if;
2462: WF_CORE.Context('WF_ROLE_HIERARCHY', 'GetRelationships', p_name);
2463: raise;
2464:
2465: end GetRelationships;
2466:

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

2583: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2584: g_modulePkg||'.GetAllRelationships', 'Exception: '||
2585: sqlerrm);
2586: end if;
2587: WF_CORE.Context('WF_ROLE_HIERARCHY', 'GetAllRelationships', p_name);
2588: raise;
2589:
2590: end GetAllRelationships;
2591:

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

2646: FROM WF_LOCAL_ROLES
2647: WHERE NAME = p_sub_name;
2648: exception
2649: when NO_DATA_FOUND then
2650: WF_CORE.Token('NAME', p_sub_name);
2651: WF_CORE.Raise('WF_NO_ROLE');
2652: end;
2653:
2654: begin

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

2647: WHERE NAME = p_sub_name;
2648: exception
2649: when NO_DATA_FOUND then
2650: WF_CORE.Token('NAME', p_sub_name);
2651: WF_CORE.Raise('WF_NO_ROLE');
2652: end;
2653:
2654: begin
2655: SELECT ORIG_SYSTEM, PARTITION_ID

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

2657: FROM WF_LOCAL_ROLES
2658: WHERE NAME = p_super_name;
2659: exception
2660: when NO_DATA_FOUND then
2661: WF_CORE.Token('NAME', p_super_name);
2662: WF_CORE.Raise('WF_NO_ROLE');
2663: end;
2664:
2665: -- Obtain the relationship_id from WF_ROLE_HIERARCHIES_S.

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

2658: WHERE NAME = p_super_name;
2659: exception
2660: when NO_DATA_FOUND then
2661: WF_CORE.Token('NAME', p_super_name);
2662: WF_CORE.Raise('WF_NO_ROLE');
2663: end;
2664:
2665: -- Obtain the relationship_id from WF_ROLE_HIERARCHIES_S.
2666: select WF_ROLE_HIERARCHIES_S.NEXTVAL

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

2755: g_modulePkg||
2756: '.AddRelationship.Insert.DUP_VAL_ON_INDEX.NoUpdate',
2757: 'Active relationship exists, raising WFDS_DUP_HIERARCHY');
2758: end if;
2759: WF_CORE.Token('P_SUB_NAME', p_sub_name);
2760: WF_CORE.Token('P_SUPER_NAME', p_super_name);
2761: WF_CORE.Raise('WFDS_DUP_HIERARCHY');
2762: end if;
2763: end;

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

2756: '.AddRelationship.Insert.DUP_VAL_ON_INDEX.NoUpdate',
2757: 'Active relationship exists, raising WFDS_DUP_HIERARCHY');
2758: end if;
2759: WF_CORE.Token('P_SUB_NAME', p_sub_name);
2760: WF_CORE.Token('P_SUPER_NAME', p_super_name);
2761: WF_CORE.Raise('WFDS_DUP_HIERARCHY');
2762: end if;
2763: end;
2764:

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

2757: 'Active relationship exists, raising WFDS_DUP_HIERARCHY');
2758: end if;
2759: WF_CORE.Token('P_SUB_NAME', p_sub_name);
2760: WF_CORE.Token('P_SUPER_NAME', p_super_name);
2761: WF_CORE.Raise('WFDS_DUP_HIERARCHY');
2762: end if;
2763: end;
2764:
2765: --If either the superior or the subordinate is a newly created role we

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

2817: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2818: g_modulePkg||'.AddRelationship', 'Exception: '||
2819: sqlerrm);
2820: end if;
2821: WF_CORE.Context('WF_ROLE_HIERARCHY', 'AddRelationship', p_sub_name,
2822: p_super_name);
2823: WF_CORE.Raise('WFDS_HIERARCHY_LOOP');
2824:
2825: when OTHERS then

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

2819: sqlerrm);
2820: end if;
2821: WF_CORE.Context('WF_ROLE_HIERARCHY', 'AddRelationship', p_sub_name,
2822: p_super_name);
2823: WF_CORE.Raise('WFDS_HIERARCHY_LOOP');
2824:
2825: when OTHERS then
2826: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
2827: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,

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

2827: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2828: g_modulePkg||'.AddRelationship', 'Exception: '||
2829: sqlerrm);
2830: end if;
2831: WF_CORE.Context('WF_ROLE_HIERARCHY', 'AddRelationship', p_sub_name,
2832: p_super_name);
2833: raise;
2834: end AddRelationship;
2835:

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

2882: '.ExpireRelationship.Update.NoActiveRelationship',
2883: 'No Active relationship exists, '||
2884: 'raising WFDS_NO_HIERARCHY');
2885: end if;
2886: WF_CORE.Token('P_SUB_NAME', p_sub_name);
2887: WF_CORE.Token('P_SUPER_NAME', p_super_name);
2888: WF_CORE.Raise('WFDS_NO_HIERARCHY');
2889: end if;
2890:

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

2883: 'No Active relationship exists, '||
2884: 'raising WFDS_NO_HIERARCHY');
2885: end if;
2886: WF_CORE.Token('P_SUB_NAME', p_sub_name);
2887: WF_CORE.Token('P_SUPER_NAME', p_super_name);
2888: WF_CORE.Raise('WFDS_NO_HIERARCHY');
2889: end if;
2890:
2891: end;

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

2884: 'raising WFDS_NO_HIERARCHY');
2885: end if;
2886: WF_CORE.Token('P_SUB_NAME', p_sub_name);
2887: WF_CORE.Token('P_SUPER_NAME', p_super_name);
2888: WF_CORE.Raise('WFDS_NO_HIERARCHY');
2889: end if;
2890:
2891: end;
2892:

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

2913: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2914: g_modulePkg||'.ExpireRelationship', 'Exception: '||
2915: sqlerrm);
2916: end if;
2917: WF_CORE.Context('WF_ROLE_HIERARCHY', 'ExpireRelationship', p_sub_name,
2918: p_super_name);
2919: raise;
2920: end ExpireRelationship;
2921:

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

2946:
2947: exception
2948: when OTHERS then
2949:
2950: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Denormalize_User_Role_RF',
2951: p_event.getEventName( ), p_sub_guid);
2952:
2953: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2954: return 'ERROR';

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

2967: is
2968: l_updateTime DATE;
2969:
2970: begin
2971: select to_date(text, WF_CORE.canonical_date_mask)
2972: into l_UpdateTime
2973: from WF_RESOURCES
2974: where TYPE='WFTKN'
2975: and NAME = 'WFDS_HIERARCHY_UPD'

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

3003:
3004: begin
3005: g_trustTimeStamp := sysdate;
3006: update WF_RESOURCES
3007: set text = to_char(g_trustTimeStamp, WF_CORE.canonical_date_mask)
3008: where name = 'WFDS_HIERARCHY_UPD';
3009:
3010: if (sql%rowcount = 0) then
3011: begin

Line 3026: WF_CORE.canonical_date_mask),

3022: 'US',
3023: 'US',
3024: 0,
3025: to_char(g_trustTimeStamp,
3026: WF_CORE.canonical_date_mask),
3027: 0,
3028: 0);
3029: exception
3030: when DUP_VAL_ON_INDEX then

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

3066:
3067: if (l_enabled='Y') then
3068: if (p_forceRemove is null or not p_forceRemove) then
3069: -- raise error
3070: wf_core.token('P_RELATIONSHIPID',p_relationshipID);
3071: wf_core.raise('WFDS_ACTIVE_RELN');
3072: else
3073: --call API to expire this remationship forcefully
3074: l_relationshipID:=ExpireRelationship(l_subName,l_superName);

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

3067: if (l_enabled='Y') then
3068: if (p_forceRemove is null or not p_forceRemove) then
3069: -- raise error
3070: wf_core.token('P_RELATIONSHIPID',p_relationshipID);
3071: wf_core.raise('WFDS_ACTIVE_RELN');
3072: else
3073: --call API to expire this remationship forcefully
3074: l_relationshipID:=ExpireRelationship(l_subName,l_superName);
3075: