DBA Data[Home] [Help]

APPS.PER_HRWF_SYNCH dependencies on WF_EVENT

Line 124: l_entity := wf_event.getvalueforparameter(

120: --get the attribute CONTEXT value from the parameter list.
121: --
122: hr_utility.set_location('Start assigning values from param_list '||l_proc,25);
123:
124: l_entity := wf_event.getvalueforparameter(
125: p_name => 'CONTEXT',
126: p_parameterlist => p_parameters);
127: --
128: l_start_date_canonical := wf_event.getvalueforparameter(

Line 128: l_start_date_canonical := wf_event.getvalueforparameter(

124: l_entity := wf_event.getvalueforparameter(
125: p_name => 'CONTEXT',
126: p_parameterlist => p_parameters);
127: --
128: l_start_date_canonical := wf_event.getvalueforparameter(
129: p_name => 'STARTDATE',
130: p_parameterlist => p_parameters);
131:
132: l_end_date_canonical := wf_event.getvalueforparameter(

Line 132: l_end_date_canonical := wf_event.getvalueforparameter(

128: l_start_date_canonical := wf_event.getvalueforparameter(
129: p_name => 'STARTDATE',
130: p_parameterlist => p_parameters);
131:
132: l_end_date_canonical := wf_event.getvalueforparameter(
133: p_name => 'ENDDATE',
134: p_parameterlist => p_parameters);
135:
136: l_start_date := FND_DATE.canonical_to_date(l_start_date_canonical);

Line 145: l_person_id_canonical := wf_event.getvalueforparameter(

141: --
142: hr_utility.set_location('Person Record '||l_proc,35);
143: -- get attribute values of peson from parameter list.
144: --
145: l_person_id_canonical := wf_event.getvalueforparameter(
146: p_name => 'PERSONID',
147: p_parameterlist => p_parameters);
148: l_person_id := FND_NUMBER.canonical_to_number(l_person_id_canonical);
149: --

Line 152: l_person_party_id_canonical := wf_event.getvalueforparameter(

148: l_person_id := FND_NUMBER.canonical_to_number(l_person_id_canonical);
149: --
150: -- 3297591
151: --/*
152: l_person_party_id_canonical := wf_event.getvalueforparameter(
153: p_name => 'PERSONPARTYID',
154: p_parameterlist => p_parameters);
155: l_person_party_id := FND_NUMBER.canonical_to_number(l_person_party_id_canonical);
156: --*/

Line 176: l_person_id_canonical := wf_event.getvalueforparameter( p_name => 'PERSONID',

172: if l_entity = 'PERSON:TERMINATION' then
173:
174: hr_utility.set_location('Person Termination Record '||l_proc,46);
175:
176: l_person_id_canonical := wf_event.getvalueforparameter( p_name => 'PERSONID',
177: p_parameterlist => p_parameters);
178: l_person_id := FND_NUMBER.canonical_to_number(l_person_id_canonical);
179:
180: open l_pds_cur;

Line 195: l_assignment_id_canonical := wf_event.getvalueforparameter(

191: --
192: if l_entity = 'POSITION' then
193: --
194: hr_utility.set_location('Position Record '||l_proc,35);
195: l_assignment_id_canonical := wf_event.getvalueforparameter(
196: p_name => 'ASSIGNMENTID',
197: p_parameterlist => p_parameters);
198: --
199: l_assignment_id := FND_NUMBER.canonical_to_number(l_assignment_id_canonical);

Line 330: wf_event.addparametertolist(

326: --
327: if nvl(p_action,'NO_DELETE') = 'DELETE' then
328: --
329: hr_utility.set_location('Delete Person '||l_proc,20);
330: wf_event.addparametertolist(
331: p_name => 'DELETE',
332: p_value => 'TRUE',
333: p_parameterlist => l_parameters);
334: --

Line 345: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);

341: l_user_name := 'PER:'||p_rec.person_id;
342: end if;
343: close role_exists;
344: --
345: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);
346: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
347: wf_event.addparametertolist('PERSON_PARTY_ID',p_rec.party_id,l_parameters); -- 3297591
348: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
349: -- wf_event.addparametertolist('DisplayName',p_rec.full_name,l_parameters); -- 3297591

Line 346: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);

342: end if;
343: close role_exists;
344: --
345: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);
346: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
347: wf_event.addparametertolist('PERSON_PARTY_ID',p_rec.party_id,l_parameters); -- 3297591
348: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
349: -- wf_event.addparametertolist('DisplayName',p_rec.full_name,l_parameters); -- 3297591
350: wf_event.addparametertolist('DisplayName',l_display_name,l_parameters);

Line 347: wf_event.addparametertolist('PERSON_PARTY_ID',p_rec.party_id,l_parameters); -- 3297591

343: close role_exists;
344: --
345: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);
346: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
347: wf_event.addparametertolist('PERSON_PARTY_ID',p_rec.party_id,l_parameters); -- 3297591
348: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
349: -- wf_event.addparametertolist('DisplayName',p_rec.full_name,l_parameters); -- 3297591
350: wf_event.addparametertolist('DisplayName',l_display_name,l_parameters);
351: --

Line 348: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);

344: --
345: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);
346: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
347: wf_event.addparametertolist('PERSON_PARTY_ID',p_rec.party_id,l_parameters); -- 3297591
348: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
349: -- wf_event.addparametertolist('DisplayName',p_rec.full_name,l_parameters); -- 3297591
350: wf_event.addparametertolist('DisplayName',l_display_name,l_parameters);
351: --
352: wf_local_synch.propagate_role(

Line 349: -- wf_event.addparametertolist('DisplayName',p_rec.full_name,l_parameters); -- 3297591

345: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);
346: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
347: wf_event.addparametertolist('PERSON_PARTY_ID',p_rec.party_id,l_parameters); -- 3297591
348: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
349: -- wf_event.addparametertolist('DisplayName',p_rec.full_name,l_parameters); -- 3297591
350: wf_event.addparametertolist('DisplayName',l_display_name,l_parameters);
351: --
352: wf_local_synch.propagate_role(
353: p_orig_system => 'PER',

Line 350: wf_event.addparametertolist('DisplayName',l_display_name,l_parameters);

346: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
347: wf_event.addparametertolist('PERSON_PARTY_ID',p_rec.party_id,l_parameters); -- 3297591
348: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
349: -- wf_event.addparametertolist('DisplayName',p_rec.full_name,l_parameters); -- 3297591
350: wf_event.addparametertolist('DisplayName',l_display_name,l_parameters);
351: --
352: wf_local_synch.propagate_role(
353: p_orig_system => 'PER',
354: p_orig_system_id => p_rec.person_id,

Line 416: wf_event.addparametertolist(

412: --
413: close role_exists;
414: --
415: hr_utility.set_location('start add params',63);
416: wf_event.addparametertolist(
417: p_name => 'USER_NAME',
418: p_value => l_user_name,
419: p_parameterlist => l_parameters);
420: /*

Line 421: wf_event.addparametertolist(

417: p_name => 'USER_NAME',
418: p_value => l_user_name,
419: p_parameterlist => l_parameters);
420: /*
421: wf_event.addparametertolist(
422: p_name => 'DisplayName',
423: p_value => p_rec.full_name,
424: p_parameterlist => l_parameters);
425: */ -- 3297591

Line 427: wf_event.addparametertolist(

423: p_value => p_rec.full_name,
424: p_parameterlist => l_parameters);
425: */ -- 3297591
426:
427: wf_event.addparametertolist(
428: p_name => 'DisplayName',
429: p_value => l_display_name,
430: p_parameterlist => l_parameters); -- 3297591
431:

Line 432: wf_event.addparametertolist(

428: p_name => 'DisplayName',
429: p_value => l_display_name,
430: p_parameterlist => l_parameters); -- 3297591
431:
432: wf_event.addparametertolist(
433: p_name => 'PERSON_PARTY_ID',
434: p_value => p_rec.party_id,
435: p_parameterlist => l_parameters); -- 3297591
436:

Line 438: wf_event.addparametertolist(

434: p_value => p_rec.party_id,
435: p_parameterlist => l_parameters); -- 3297591
436:
437: /* -- For now these are commented
438: wf_event.addparametertolist(
439: p_name => 'orclWorkFlowNotificationPref',
440: p_value => 'QUERY',
441: p_parameterlist => l_parameters);
442:

Line 443: wf_event.addparametertolist(

439: p_name => 'orclWorkFlowNotificationPref',
440: p_value => 'QUERY',
441: p_parameterlist => l_parameters);
442:
443: wf_event.addparametertolist(
444: p_name => 'preferredLanguage',
445: p_value => p_rec.correspondence_language,
446: p_parameterlist => l_parameters);
447:

Line 448: wf_event.addparametertolist(

444: p_name => 'preferredLanguage',
445: p_value => p_rec.correspondence_language,
446: p_parameterlist => l_parameters);
447:
448: wf_event.addparametertolist(
449: p_name => 'FascimileTelephoneNumber',
450: p_value => FAX,
451: p_parameterlist => l_parameters);
452: wf_event.addparametertolist(

Line 452: wf_event.addparametertolist(

448: wf_event.addparametertolist(
449: p_name => 'FascimileTelephoneNumber',
450: p_value => FAX,
451: p_parameterlist => l_parameters);
452: wf_event.addparametertolist(
453: p_name => 'orclNLSTerritory',
454: p_value => TERRITORY,
455: p_parameterlist => l_parameters);
456:

Line 458: wf_event.addparametertolist(

454: p_value => TERRITORY,
455: p_parameterlist => l_parameters);
456:
457: */
458: wf_event.addparametertolist(
459: p_name => 'mail',
460: p_value => p_rec.email_address,
461: p_parameterlist => l_parameters);
462:

Line 463: wf_event.addparametertolist(

459: p_name => 'mail',
460: p_value => p_rec.email_address,
461: p_parameterlist => l_parameters);
462:
463: wf_event.addparametertolist(
464: p_name => 'orclIsEnabled',
465: p_value => 'ACTIVE',
466: p_parameterlist => l_parameters);
467: -- bug 4635241 commented out the following line and set the value to Null.

Line 470: wf_event.addparametertolist(

466: p_parameterlist => l_parameters);
467: -- bug 4635241 commented out the following line and set the value to Null.
468: -- l_expiration_date := FND_DATE.date_to_canonical(p_rec.effective_end_date);
469: l_expiration_date := NULL;
470: wf_event.addparametertolist(
471: p_name => 'ExpirationDate',
472: p_value => l_expiration_date,
473: p_parameterlist => l_parameters);
474:

Line 475: wf_event.addparametertolist(

471: p_name => 'ExpirationDate',
472: p_value => l_expiration_date,
473: p_parameterlist => l_parameters);
474:
475: wf_event.addparametertolist(
476: p_name => 'orclWFOrigSystem',
477: p_value => 'PER',
478: p_parameterlist => l_parameters);
479:

Line 480: wf_event.addparametertolist(

476: p_name => 'orclWFOrigSystem',
477: p_value => 'PER',
478: p_parameterlist => l_parameters);
479:
480: wf_event.addparametertolist(
481: p_name => 'orclWFOrigSystemID',
482: p_value => p_rec.person_id,
483: p_parameterlist => l_parameters);
484:

Line 487: wf_event.addparametertolist(p_name => 'description',

483: p_parameterlist => l_parameters);
484:
485: --Added below paramter description for bug#14767779
486:
487: wf_event.addparametertolist(p_name => 'description',
488: p_value => p_rec.full_name,
489: p_parameterlist => l_parameters);
490:
491: -- Bug 4597033

Line 494: wf_event.addparametertolist(

490:
491: -- Bug 4597033
492: -- If the transaction is an update then passing the overwrite parameter with value TRUE
493: if l_update = 'Y' then
494: wf_event.addparametertolist(
495: p_name => 'WFSYNCH_OVERWRITE',
496: p_value => 'TRUE',
497: p_parameterlist => l_parameters);
498:

Line 504: wf_event.addparametertolist(

500: fetch role_description into l_description ;
501: close role_description;
502: hr_utility.set_location('l_description '|| l_description,20);
503:
504: wf_event.addparametertolist(
505: p_name => 'description',
506: p_value => l_description,
507: p_parameterlist => l_parameters);
508:

Line 539: wf_event.addparametertolist(

535: -- assign attributes and values for l_parameters.
536: --
537: hr_utility.set_location('Future Person '||l_proc,50);
538: --
539: wf_event.addparametertolist(
540: p_name => 'CONTEXT',
541: p_value => 'PERSON',
542: p_parameterlist => l_parameters);
543:

Line 544: wf_event.addparametertolist(

540: p_name => 'CONTEXT',
541: p_value => 'PERSON',
542: p_parameterlist => l_parameters);
543:
544: wf_event.addparametertolist(
545: p_name => 'PERSONID',
546: p_value => l_person_id_canonical,
547: p_parameterlist => l_parameters);
548: wf_event.addparametertolist(

Line 548: wf_event.addparametertolist(

544: wf_event.addparametertolist(
545: p_name => 'PERSONID',
546: p_value => l_person_id_canonical,
547: p_parameterlist => l_parameters);
548: wf_event.addparametertolist(
549: p_name => 'STARTDATE',
550: p_value => l_start_date_canonical,
551: p_parameterlist => l_parameters);
552: wf_event.addparametertolist(

Line 552: wf_event.addparametertolist(

548: wf_event.addparametertolist(
549: p_name => 'STARTDATE',
550: p_value => l_start_date_canonical,
551: p_parameterlist => l_parameters);
552: wf_event.addparametertolist(
553: p_name => 'ENDDATE',
554: p_value => l_end_date_canonical,
555: p_parameterlist => l_parameters);
556:

Line 714: wf_event.addparametertolist(

710: --
711: -- assign attributes and values for l_parameters.
712: --
713: --
714: wf_event.addparametertolist(
715: p_name => 'CONTEXT',
716: p_value => 'POSITION',
717: p_parameterlist => l_parameters);
718: wf_event.addparametertolist(

Line 718: wf_event.addparametertolist(

714: wf_event.addparametertolist(
715: p_name => 'CONTEXT',
716: p_value => 'POSITION',
717: p_parameterlist => l_parameters);
718: wf_event.addparametertolist(
719: p_name => 'ASSIGNMENTID',
720: p_value => l_assignment_id_canonical,
721: p_parameterlist => l_parameters);
722: wf_event.addparametertolist(

Line 722: wf_event.addparametertolist(

718: wf_event.addparametertolist(
719: p_name => 'ASSIGNMENTID',
720: p_value => l_assignment_id_canonical,
721: p_parameterlist => l_parameters);
722: wf_event.addparametertolist(
723: p_name => 'STARTDATE',
724: p_value => l_start_date_canonical,
725: p_parameterlist => l_parameters);
726: wf_event.addparametertolist(

Line 726: wf_event.addparametertolist(

722: wf_event.addparametertolist(
723: p_name => 'STARTDATE',
724: p_value => l_start_date_canonical,
725: p_parameterlist => l_parameters);
726: wf_event.addparametertolist(
727: p_name => 'ENDDATE',
728: p_value => l_end_date_canonical,
729: p_parameterlist => l_parameters);
730:

Line 799: wf_event.addparametertolist('orclIsEnabled','ACTIVE',l_parameters); -- 4133057

795: hr_utility.set_location('Reverse Termination.. '||l_proc,20);
796: --set the end of time as ATD
797: l_date := to_date('31-12-4712', 'DD-MM-YYYY');
798: -- set the status a ACTIVE
799: wf_event.addparametertolist('orclIsEnabled','ACTIVE',l_parameters); -- 4133057
800: end if;
801: --
802: --
803: -- if ROLE is already created, then assign USER_NAME to l_user_name.

Line 814: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);

810: end if;
811: --
812: close role_exists;
813: --
814: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);
815: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
816: --l_user_name := 'PER:'||p_rec.person_id;
817: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
818: --

Line 815: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);

811: --
812: close role_exists;
813: --
814: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);
815: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
816: --l_user_name := 'PER:'||p_rec.person_id;
817: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
818: --
819: hr_utility.set_location('Calling Propagate_role '||l_proc,30);

Line 817: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);

813: --
814: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);
815: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
816: --l_user_name := 'PER:'||p_rec.person_id;
817: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
818: --
819: hr_utility.set_location('Calling Propagate_role '||l_proc,30);
820: wf_local_synch.propagate_role(
821: p_orig_system => 'PER',

Line 841: wf_event.addparametertolist('orclWFOrigSystem','PER_ROLE',l_parameters);

837: if p_action = 'TERMINATION' then
838:
839: if (trunc(nvl(p_date,p_rec.actual_termination_date)) < trunc(sysdate)) then
840:
841: wf_event.addparametertolist('orclWFOrigSystem','PER_ROLE',l_parameters);
842: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
843: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
844:
845: Begin

Line 842: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);

838:
839: if (trunc(nvl(p_date,p_rec.actual_termination_date)) < trunc(sysdate)) then
840:
841: wf_event.addparametertolist('orclWFOrigSystem','PER_ROLE',l_parameters);
842: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
843: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
844:
845: Begin
846: select description,

Line 843: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);

839: if (trunc(nvl(p_date,p_rec.actual_termination_date)) < trunc(sysdate)) then
840:
841: wf_event.addparametertolist('orclWFOrigSystem','PER_ROLE',l_parameters);
842: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
843: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
844:
845: Begin
846: select description,
847: notification_preference,

Line 864: wf_event.addparametertolist('DESCRIPTION',l_user_name,l_parameters);

860: l_parentOrigSys := null;
861: l_parentOrigSysID := null;
862: End;
863:
864: wf_event.addparametertolist('DESCRIPTION',l_user_name,l_parameters);
865: wf_event.addparametertolist('ORCLWORKFLOWNOTIFICATIONPREF',l_notificationPref,l_parameters);
866: wf_event.addparametertolist('ORCLWFPARENTORIGSYS',l_parentOrigSys,l_parameters);
867: wf_event.addparametertolist('ORCLWFPARENTORIGSYSID',l_parentOrigSysID,l_parameters);
868:

Line 865: wf_event.addparametertolist('ORCLWORKFLOWNOTIFICATIONPREF',l_notificationPref,l_parameters);

861: l_parentOrigSysID := null;
862: End;
863:
864: wf_event.addparametertolist('DESCRIPTION',l_user_name,l_parameters);
865: wf_event.addparametertolist('ORCLWORKFLOWNOTIFICATIONPREF',l_notificationPref,l_parameters);
866: wf_event.addparametertolist('ORCLWFPARENTORIGSYS',l_parentOrigSys,l_parameters);
867: wf_event.addparametertolist('ORCLWFPARENTORIGSYSID',l_parentOrigSysID,l_parameters);
868:
869:

Line 866: wf_event.addparametertolist('ORCLWFPARENTORIGSYS',l_parentOrigSys,l_parameters);

862: End;
863:
864: wf_event.addparametertolist('DESCRIPTION',l_user_name,l_parameters);
865: wf_event.addparametertolist('ORCLWORKFLOWNOTIFICATIONPREF',l_notificationPref,l_parameters);
866: wf_event.addparametertolist('ORCLWFPARENTORIGSYS',l_parentOrigSys,l_parameters);
867: wf_event.addparametertolist('ORCLWFPARENTORIGSYSID',l_parentOrigSysID,l_parameters);
868:
869:
870: hr_utility.set_location('Calling Propagate_role for PER_ROLE role'||l_proc,50);

Line 867: wf_event.addparametertolist('ORCLWFPARENTORIGSYSID',l_parentOrigSysID,l_parameters);

863:
864: wf_event.addparametertolist('DESCRIPTION',l_user_name,l_parameters);
865: wf_event.addparametertolist('ORCLWORKFLOWNOTIFICATIONPREF',l_notificationPref,l_parameters);
866: wf_event.addparametertolist('ORCLWFPARENTORIGSYS',l_parentOrigSys,l_parameters);
867: wf_event.addparametertolist('ORCLWFPARENTORIGSYSID',l_parentOrigSysID,l_parameters);
868:
869:
870: hr_utility.set_location('Calling Propagate_role for PER_ROLE role'||l_proc,50);
871: wf_local_synch.propagate_role( p_orig_system => 'PER',

Line 881: wf_event.addparametertolist(p_name => 'CONTEXT',

877: l_start_date_canonical := FND_DATE.date_to_canonical(p_rec.date_start);
878: l_end_date_canonical := FND_DATE.date_to_canonical(l_perrole_date);
879: l_person_id_canonical := FND_NUMBER.number_to_canonical(p_rec.person_id);
880:
881: wf_event.addparametertolist(p_name => 'CONTEXT',
882: p_value => 'PERSON:TERMINATION',
883: p_parameterlist => l_parameters);
884:
885: wf_event.addparametertolist(p_name => 'PERSON_ID',

Line 885: wf_event.addparametertolist(p_name => 'PERSON_ID',

881: wf_event.addparametertolist(p_name => 'CONTEXT',
882: p_value => 'PERSON:TERMINATION',
883: p_parameterlist => l_parameters);
884:
885: wf_event.addparametertolist(p_name => 'PERSON_ID',
886: p_value => l_person_id_canonical,
887: p_parameterlist => l_parameters);
888:
889: wf_event.addparametertolist(p_name => 'STARTDATE',

Line 889: wf_event.addparametertolist(p_name => 'STARTDATE',

885: wf_event.addparametertolist(p_name => 'PERSON_ID',
886: p_value => l_person_id_canonical,
887: p_parameterlist => l_parameters);
888:
889: wf_event.addparametertolist(p_name => 'STARTDATE',
890: p_value => l_start_date_canonical,
891: p_parameterlist => l_parameters);
892:
893: wf_event.addparametertolist(p_name => 'ENDDATE',

Line 893: wf_event.addparametertolist(p_name => 'ENDDATE',

889: wf_event.addparametertolist(p_name => 'STARTDATE',
890: p_value => l_start_date_canonical,
891: p_parameterlist => l_parameters);
892:
893: wf_event.addparametertolist(p_name => 'ENDDATE',
894: p_value => l_end_date_canonical,
895: p_parameterlist => l_parameters);
896:
897: hr_utility.set_location('Before calling call_me_later for PER_ROLE '||l_proc,50);