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(
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(
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);
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: --
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: --*/
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;
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);
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: --
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
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);
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: --
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(
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',
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,
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: /*
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
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:
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:
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:
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:
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(
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:
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:
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.
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:
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:
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:
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
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:
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:
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:
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(
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(
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:
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(
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(
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(
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:
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.
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: --
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);
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',
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
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,
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,
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:
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:
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);
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',
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',
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',
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',
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);