DBA Data[Home] [Help]

APPS.PER_HRWF_SYNCH dependencies on WF_EVENT

Line 116: l_entity := wf_event.getvalueforparameter(

112: --get the attribute CONTEXT value from the parameter list.
113: --
114: hr_utility.set_location('Start assigning values from param_list '||l_proc,25);
115:
116: l_entity := wf_event.getvalueforparameter(
117: p_name => 'CONTEXT',
118: p_parameterlist => p_parameters);
119: --
120: l_start_date_canonical := wf_event.getvalueforparameter(

Line 120: l_start_date_canonical := wf_event.getvalueforparameter(

116: l_entity := wf_event.getvalueforparameter(
117: p_name => 'CONTEXT',
118: p_parameterlist => p_parameters);
119: --
120: l_start_date_canonical := wf_event.getvalueforparameter(
121: p_name => 'STARTDATE',
122: p_parameterlist => p_parameters);
123:
124: l_end_date_canonical := wf_event.getvalueforparameter(

Line 124: l_end_date_canonical := wf_event.getvalueforparameter(

120: l_start_date_canonical := wf_event.getvalueforparameter(
121: p_name => 'STARTDATE',
122: p_parameterlist => p_parameters);
123:
124: l_end_date_canonical := wf_event.getvalueforparameter(
125: p_name => 'ENDDATE',
126: p_parameterlist => p_parameters);
127:
128: l_start_date := FND_DATE.canonical_to_date(l_start_date_canonical);

Line 137: l_person_id_canonical := wf_event.getvalueforparameter(

133: --
134: hr_utility.set_location('Person Record '||l_proc,35);
135: -- get attribute values of peson from parameter list.
136: --
137: l_person_id_canonical := wf_event.getvalueforparameter(
138: p_name => 'PERSONID',
139: p_parameterlist => p_parameters);
140: l_person_id := FND_NUMBER.canonical_to_number(l_person_id_canonical);
141: --

Line 144: l_person_party_id_canonical := wf_event.getvalueforparameter(

140: l_person_id := FND_NUMBER.canonical_to_number(l_person_id_canonical);
141: --
142: -- 3297591
143: --/*
144: l_person_party_id_canonical := wf_event.getvalueforparameter(
145: p_name => 'PERSONPARTYID',
146: p_parameterlist => p_parameters);
147: l_person_party_id := FND_NUMBER.canonical_to_number(l_person_party_id_canonical);
148: --*/

Line 168: l_assignment_id_canonical := wf_event.getvalueforparameter(

164: --
165: if l_entity = 'POSITION' then
166: --
167: hr_utility.set_location('Position Record '||l_proc,35);
168: l_assignment_id_canonical := wf_event.getvalueforparameter(
169: p_name => 'ASSIGNMENTID',
170: p_parameterlist => p_parameters);
171: --
172: l_assignment_id := FND_NUMBER.canonical_to_number(l_assignment_id_canonical);

Line 279: wf_event.addparametertolist(

275: --
276: if nvl(p_action,'NO_DELETE') = 'DELETE' then
277: --
278: hr_utility.set_location('Delete Person '||l_proc,20);
279: wf_event.addparametertolist(
280: p_name => 'DELETE',
281: p_value => 'TRUE',
282: p_parameterlist => l_parameters);
283: --

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

290: l_user_name := 'PER:'||p_rec.person_id;
291: end if;
292: close role_exists;
293: --
294: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);
295: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
296: wf_event.addparametertolist('PERSON_PARTY_ID',p_rec.party_id,l_parameters); -- 3297591
297: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
298: -- wf_event.addparametertolist('DisplayName',p_rec.full_name,l_parameters); -- 3297591

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

291: end if;
292: close role_exists;
293: --
294: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);
295: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
296: wf_event.addparametertolist('PERSON_PARTY_ID',p_rec.party_id,l_parameters); -- 3297591
297: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
298: -- wf_event.addparametertolist('DisplayName',p_rec.full_name,l_parameters); -- 3297591
299: wf_event.addparametertolist('DisplayName',l_display_name,l_parameters);

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

292: close role_exists;
293: --
294: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);
295: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
296: wf_event.addparametertolist('PERSON_PARTY_ID',p_rec.party_id,l_parameters); -- 3297591
297: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
298: -- wf_event.addparametertolist('DisplayName',p_rec.full_name,l_parameters); -- 3297591
299: wf_event.addparametertolist('DisplayName',l_display_name,l_parameters);
300: --

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

293: --
294: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);
295: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
296: wf_event.addparametertolist('PERSON_PARTY_ID',p_rec.party_id,l_parameters); -- 3297591
297: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
298: -- wf_event.addparametertolist('DisplayName',p_rec.full_name,l_parameters); -- 3297591
299: wf_event.addparametertolist('DisplayName',l_display_name,l_parameters);
300: --
301: wf_local_synch.propagate_role(

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

294: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);
295: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
296: wf_event.addparametertolist('PERSON_PARTY_ID',p_rec.party_id,l_parameters); -- 3297591
297: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
298: -- wf_event.addparametertolist('DisplayName',p_rec.full_name,l_parameters); -- 3297591
299: wf_event.addparametertolist('DisplayName',l_display_name,l_parameters);
300: --
301: wf_local_synch.propagate_role(
302: p_orig_system => 'PER',

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

295: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
296: wf_event.addparametertolist('PERSON_PARTY_ID',p_rec.party_id,l_parameters); -- 3297591
297: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
298: -- wf_event.addparametertolist('DisplayName',p_rec.full_name,l_parameters); -- 3297591
299: wf_event.addparametertolist('DisplayName',l_display_name,l_parameters);
300: --
301: wf_local_synch.propagate_role(
302: p_orig_system => 'PER',
303: p_orig_system_id => p_rec.person_id,

Line 341: wf_event.addparametertolist(

337: --
338: close role_exists;
339: --
340: hr_utility.set_location('start add params',63);
341: wf_event.addparametertolist(
342: p_name => 'USER_NAME',
343: p_value => l_user_name,
344: p_parameterlist => l_parameters);
345: /*

Line 346: wf_event.addparametertolist(

342: p_name => 'USER_NAME',
343: p_value => l_user_name,
344: p_parameterlist => l_parameters);
345: /*
346: wf_event.addparametertolist(
347: p_name => 'DisplayName',
348: p_value => p_rec.full_name,
349: p_parameterlist => l_parameters);
350: */ -- 3297591

Line 352: wf_event.addparametertolist(

348: p_value => p_rec.full_name,
349: p_parameterlist => l_parameters);
350: */ -- 3297591
351:
352: wf_event.addparametertolist(
353: p_name => 'DisplayName',
354: p_value => l_display_name,
355: p_parameterlist => l_parameters); -- 3297591
356:

Line 357: wf_event.addparametertolist(

353: p_name => 'DisplayName',
354: p_value => l_display_name,
355: p_parameterlist => l_parameters); -- 3297591
356:
357: wf_event.addparametertolist(
358: p_name => 'PERSON_PARTY_ID',
359: p_value => p_rec.party_id,
360: p_parameterlist => l_parameters); -- 3297591
361:

Line 363: wf_event.addparametertolist(

359: p_value => p_rec.party_id,
360: p_parameterlist => l_parameters); -- 3297591
361:
362: /* -- For now these are commented
363: wf_event.addparametertolist(
364: p_name => 'orclWorkFlowNotificationPref',
365: p_value => 'QUERY',
366: p_parameterlist => l_parameters);
367:

Line 368: wf_event.addparametertolist(

364: p_name => 'orclWorkFlowNotificationPref',
365: p_value => 'QUERY',
366: p_parameterlist => l_parameters);
367:
368: wf_event.addparametertolist(
369: p_name => 'preferredLanguage',
370: p_value => p_rec.correspondence_language,
371: p_parameterlist => l_parameters);
372:

Line 373: wf_event.addparametertolist(

369: p_name => 'preferredLanguage',
370: p_value => p_rec.correspondence_language,
371: p_parameterlist => l_parameters);
372:
373: wf_event.addparametertolist(
374: p_name => 'FascimileTelephoneNumber',
375: p_value => FAX,
376: p_parameterlist => l_parameters);
377: wf_event.addparametertolist(

Line 377: wf_event.addparametertolist(

373: wf_event.addparametertolist(
374: p_name => 'FascimileTelephoneNumber',
375: p_value => FAX,
376: p_parameterlist => l_parameters);
377: wf_event.addparametertolist(
378: p_name => 'orclNLSTerritory',
379: p_value => TERRITORY,
380: p_parameterlist => l_parameters);
381:

Line 383: wf_event.addparametertolist(

379: p_value => TERRITORY,
380: p_parameterlist => l_parameters);
381:
382: */
383: wf_event.addparametertolist(
384: p_name => 'mail',
385: p_value => p_rec.email_address,
386: p_parameterlist => l_parameters);
387:

Line 388: wf_event.addparametertolist(

384: p_name => 'mail',
385: p_value => p_rec.email_address,
386: p_parameterlist => l_parameters);
387:
388: wf_event.addparametertolist(
389: p_name => 'orclIsEnabled',
390: p_value => 'ACTIVE',
391: p_parameterlist => l_parameters);
392: -- bug 4635241 commented out the following line and set the value to Null.

Line 395: wf_event.addparametertolist(

391: p_parameterlist => l_parameters);
392: -- bug 4635241 commented out the following line and set the value to Null.
393: -- l_expiration_date := FND_DATE.date_to_canonical(p_rec.effective_end_date);
394: l_expiration_date := NULL;
395: wf_event.addparametertolist(
396: p_name => 'ExpirationDate',
397: p_value => l_expiration_date,
398: p_parameterlist => l_parameters);
399:

Line 400: wf_event.addparametertolist(

396: p_name => 'ExpirationDate',
397: p_value => l_expiration_date,
398: p_parameterlist => l_parameters);
399:
400: wf_event.addparametertolist(
401: p_name => 'orclWFOrigSystem',
402: p_value => 'PER',
403: p_parameterlist => l_parameters);
404:

Line 405: wf_event.addparametertolist(

401: p_name => 'orclWFOrigSystem',
402: p_value => 'PER',
403: p_parameterlist => l_parameters);
404:
405: wf_event.addparametertolist(
406: p_name => 'orclWFOrigSystemID',
407: p_value => p_rec.person_id,
408: p_parameterlist => l_parameters);
409: -- Bug 4597033

Line 412: wf_event.addparametertolist(

408: p_parameterlist => l_parameters);
409: -- Bug 4597033
410: -- If the transaction is an update then passing the overwrite parameter with value TRUE
411: if l_update = 'Y' then
412: wf_event.addparametertolist(
413: p_name => 'WFSYNCH_OVERWRITE',
414: p_value => 'TRUE',
415: p_parameterlist => l_parameters);
416: end if;

Line 445: wf_event.addparametertolist(

441: -- assign attributes and values for l_parameters.
442: --
443: hr_utility.set_location('Future Person '||l_proc,50);
444: --
445: wf_event.addparametertolist(
446: p_name => 'CONTEXT',
447: p_value => 'PERSON',
448: p_parameterlist => l_parameters);
449:

Line 450: wf_event.addparametertolist(

446: p_name => 'CONTEXT',
447: p_value => 'PERSON',
448: p_parameterlist => l_parameters);
449:
450: wf_event.addparametertolist(
451: p_name => 'PERSONID',
452: p_value => l_person_id_canonical,
453: p_parameterlist => l_parameters);
454: wf_event.addparametertolist(

Line 454: wf_event.addparametertolist(

450: wf_event.addparametertolist(
451: p_name => 'PERSONID',
452: p_value => l_person_id_canonical,
453: p_parameterlist => l_parameters);
454: wf_event.addparametertolist(
455: p_name => 'STARTDATE',
456: p_value => l_start_date_canonical,
457: p_parameterlist => l_parameters);
458: wf_event.addparametertolist(

Line 458: wf_event.addparametertolist(

454: wf_event.addparametertolist(
455: p_name => 'STARTDATE',
456: p_value => l_start_date_canonical,
457: p_parameterlist => l_parameters);
458: wf_event.addparametertolist(
459: p_name => 'ENDDATE',
460: p_value => l_end_date_canonical,
461: p_parameterlist => l_parameters);
462:

Line 620: wf_event.addparametertolist(

616: --
617: -- assign attributes and values for l_parameters.
618: --
619: --
620: wf_event.addparametertolist(
621: p_name => 'CONTEXT',
622: p_value => 'POSITION',
623: p_parameterlist => l_parameters);
624: wf_event.addparametertolist(

Line 624: wf_event.addparametertolist(

620: wf_event.addparametertolist(
621: p_name => 'CONTEXT',
622: p_value => 'POSITION',
623: p_parameterlist => l_parameters);
624: wf_event.addparametertolist(
625: p_name => 'ASSIGNMENTID',
626: p_value => l_assignment_id_canonical,
627: p_parameterlist => l_parameters);
628: wf_event.addparametertolist(

Line 628: wf_event.addparametertolist(

624: wf_event.addparametertolist(
625: p_name => 'ASSIGNMENTID',
626: p_value => l_assignment_id_canonical,
627: p_parameterlist => l_parameters);
628: wf_event.addparametertolist(
629: p_name => 'STARTDATE',
630: p_value => l_start_date_canonical,
631: p_parameterlist => l_parameters);
632: wf_event.addparametertolist(

Line 632: wf_event.addparametertolist(

628: wf_event.addparametertolist(
629: p_name => 'STARTDATE',
630: p_value => l_start_date_canonical,
631: p_parameterlist => l_parameters);
632: wf_event.addparametertolist(
633: p_name => 'ENDDATE',
634: p_value => l_end_date_canonical,
635: p_parameterlist => l_parameters);
636:

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

684: hr_utility.set_location('Reverse Termination.. '||l_proc,20);
685: --set the end of time as ATD
686: l_date := to_date('31-12-4712', 'DD-MM-YYYY');
687: -- set the status a ACTIVE
688: wf_event.addparametertolist('orclIsEnabled','ACTIVE',l_parameters); -- 4133057
689: end if;
690: --
691: --
692: -- if ROLE is already created, then assign USER_NAME to l_user_name.

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

699: end if;
700: --
701: close role_exists;
702: --
703: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);
704: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
705: --l_user_name := 'PER:'||p_rec.person_id;
706: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
707: --

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

700: --
701: close role_exists;
702: --
703: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);
704: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
705: --l_user_name := 'PER:'||p_rec.person_id;
706: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
707: --
708: hr_utility.set_location('Calling Propagate_role '||l_proc,30);

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

702: --
703: wf_event.addparametertolist('orclWFOrigSystem','PER',l_parameters);
704: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
705: --l_user_name := 'PER:'||p_rec.person_id;
706: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
707: --
708: hr_utility.set_location('Calling Propagate_role '||l_proc,30);
709: wf_local_synch.propagate_role(
710: p_orig_system => 'PER',