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.HR_HRHD_RIR_WF dependencies on WF_EVENT

Line 15: p_event_message WF_EVENT_T;

11: resultout in out NOCOPY varchar2)
12: is
13:
14: p_event_key varchar2(100);
15: p_event_message WF_EVENT_T;
16: p_event_data clob;
17: p_job_data clob;
18: p_unique_key number;
19: p_job_id number;

Line 62: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.jobchange',

58: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
59:
60:
61:
62: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.jobchange',
63: p_event_key => to_char(p_job_id)||'-'||to_char(p_unique_key),
64: p_event_data => p_job_data);
65:
66: if p_date_to is not null

Line 76: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.jobchange',

72: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
73:
74:
75:
76: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.jobchange',
77: p_event_key => to_char(p_job_id)||'-'||to_char(p_unique_key),
78: p_event_data => p_job_data);
79: end if;
80:

Line 96: p_event_message WF_EVENT_T;

92: funcmode in varchar2,
93: resultout in out NOCOPY varchar2)
94: is
95: p_event_key varchar2(100);
96: p_event_message WF_EVENT_T;
97: p_event_data clob;
98: p_job_data clob;
99: p_unique_key number;
100: p_job_id number;

Line 141: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.jobchange',

137:
138: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
139:
140:
141: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.jobchange',
142: p_event_key => to_char(p_job_id)||'-'||to_char(p_unique_key),
143: p_event_data => p_job_data);
144:
145: if p_date_to is not null

Line 154: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.jobchange',

150:
151: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
152:
153:
154: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.jobchange',
155: p_event_key => to_char(p_job_id)||'-'||to_char(p_unique_key),
156: p_event_data => p_job_data);
157: end if;
158:

Line 173: p_event_message WF_EVENT_T;

169: funcmode in varchar2,
170: resultout in out NOCOPY varchar2)
171: is
172: p_event_key varchar2(100);
173: p_event_message WF_EVENT_T;
174: p_event_data clob;
175: p_job_data clob;
176: p_unique_key number;
177: p_job_id number;

Line 211: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.jobchange',

207: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
208:
209:
210:
211: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.jobchange',
212: p_event_key => to_char(p_job_id)||'-'||to_char(p_unique_key),
213: p_event_data => p_job_data);
214:
215:

Line 232: p_event_message WF_EVENT_T;

228: resultout in out NOCOPY varchar2)
229: is
230:
231: p_event_key varchar2(100);
232: p_event_message WF_EVENT_T;
233: p_event_data clob;
234: p_location_data clob;
235: p_unique_key number;
236: p_location_id number;

Line 277: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.locchange',

273: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
274:
275:
276:
277: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.locchange',
278: p_event_key => to_char(p_location_id)||'-'||to_char(p_unique_key),
279: p_event_data => p_location_data);
280:
281:

Line 293: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.locchange',

289: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
290:
291:
292:
293: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.locchange',
294: p_event_key => to_char(p_location_id)||'-'||to_char(p_unique_key),
295: p_event_data => p_location_data);
296: end if;
297:

Line 317: p_event_message WF_EVENT_T;

313: resultout in out NOCOPY varchar2)
314: is
315:
316: p_event_key varchar2(100);
317: p_event_message WF_EVENT_T;
318: p_event_data clob;
319: p_location_data clob;
320: p_unique_key number;
321: p_location_id number;

Line 361: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.locchange',

357:
358: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
359:
360:
361: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.locchange',
362: p_event_key => to_char(p_location_id)||'-'||to_char(p_unique_key),
363: p_event_data => p_location_data);
364:
365: if p_inactive_date is not null

Line 375: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.locchange',

371: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
372:
373:
374:
375: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.locchange',
376: p_event_key => to_char(p_location_id)||'-'||to_char(p_unique_key),
377: p_event_data => p_location_data);
378: end if;
379:

Line 399: p_event_message WF_EVENT_T;

395: resultout in out NOCOPY varchar2)
396: is
397:
398: p_event_key varchar2(100);
399: p_event_message WF_EVENT_T;
400: p_event_data clob;
401: p_location_data clob;
402: p_unique_key number;
403: p_location_id number;

Line 436: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.locchange',

432: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
433:
434:
435:
436: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.locchange',
437: p_event_key => to_char(p_location_id)||'-'||to_char(p_unique_key),
438: p_event_data => p_location_data);
439:
440:

Line 459: p_event_message WF_EVENT_T;

455: resultout in out NOCOPY varchar2)
456: is
457:
458: p_event_key varchar2(100);
459: p_event_message WF_EVENT_T;
460: p_event_data clob;
461: p_organization_data clob;
462: p_unique_key number;
463: p_organization_id number;

Line 522: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.orgchange',

518: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
519:
520:
521:
522: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.orgchange',
523: p_event_key => to_char(p_organization_id)||'-'||to_char(p_unique_key),
524: p_event_data => p_organization_data);
525:
526:

Line 538: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.orgchange',

534: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
535:
536:
537:
538: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.orgchange',
539: p_event_key => to_char(p_organization_id)||'-'||to_char(p_unique_key),
540: p_event_data => p_organization_data);
541: end if;
542:

Line 564: p_event_message WF_EVENT_T;

560: resultout in out NOCOPY varchar2)
561: is
562:
563: p_event_key varchar2(100);
564: p_event_message WF_EVENT_T;
565: p_event_data clob;
566: p_organization_data clob;
567: p_unique_key number;
568: p_organization_id number;

Line 623: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.orgchange',

619: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
620:
621:
622:
623: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.orgchange',
624: p_event_key => to_char(p_organization_id)||'-'||to_char(p_unique_key),
625: p_event_data => p_organization_data);
626:
627: if p_date_to is not null

Line 636: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.orgchange',

632:
633: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
634:
635:
636: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.orgchange',
637: p_event_key => to_char(p_organization_id)||'-'||to_char(p_unique_key),
638: p_event_data => p_organization_data);
639: end if;
640:

Line 661: p_event_message WF_EVENT_T;

657: resultout in out NOCOPY varchar2)
658: is
659:
660: p_event_key varchar2(100);
661: p_event_message WF_EVENT_T;
662: p_event_data clob;
663: p_organization_data clob;
664: p_unique_key number;
665: p_organization_id number;

Line 711: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.orgchange',

707: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
708:
709:
710:
711: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.orgchange',
712: p_event_key => to_char(p_organization_id)||'-'||to_char(p_unique_key),
713: p_event_data => p_organization_data);
714:
715: -- end if; --- Fix For Bug # 14587491

Line 733: p_event_message WF_EVENT_T;

729: resultout in out NOCOPY varchar2)
730:
731: is
732: p_event_key varchar2(100);
733: p_event_message WF_EVENT_T;
734: p_event_data clob;
735: p_person_id per_all_people_f.person_id%type;
736: p_person_data clob;
737: p_assignment_data clob;

Line 798: wf_event.AddParameterToList('person_id',p_person_id,myparameters);

794:
795: if p_date > trunc(sysdate)
796: then
797:
798: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
799: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
800: wf_event.AddParameterToList('eff_date',p_date,myparameters);
801: wf_event.AddParameterToList('person_op_flag','I',myparameters);
802: wf_event.AddParameterToList('asg_op_flag','I',myparameters);

Line 799: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);

795: if p_date > trunc(sysdate)
796: then
797:
798: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
799: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
800: wf_event.AddParameterToList('eff_date',p_date,myparameters);
801: wf_event.AddParameterToList('person_op_flag','I',myparameters);
802: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
803: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);

Line 800: wf_event.AddParameterToList('eff_date',p_date,myparameters);

796: then
797:
798: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
799: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
800: wf_event.AddParameterToList('eff_date',p_date,myparameters);
801: wf_event.AddParameterToList('person_op_flag','I',myparameters);
802: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
803: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
804: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);

Line 801: wf_event.AddParameterToList('person_op_flag','I',myparameters);

797:
798: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
799: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
800: wf_event.AddParameterToList('eff_date',p_date,myparameters);
801: wf_event.AddParameterToList('person_op_flag','I',myparameters);
802: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
803: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
804: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
805: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);

Line 802: wf_event.AddParameterToList('asg_op_flag','I',myparameters);

798: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
799: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
800: wf_event.AddParameterToList('eff_date',p_date,myparameters);
801: wf_event.AddParameterToList('person_op_flag','I',myparameters);
802: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
803: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
804: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
805: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
806:

Line 805: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);

801: wf_event.AddParameterToList('person_op_flag','I',myparameters);
802: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
803: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
804: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
805: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
806:
807: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
808:
809: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.person_callbackable',

Line 807: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);

803: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
804: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
805: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
806:
807: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
808:
809: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.person_callbackable',
810: p_when => p_date,
811: p_parameters => myparameters);

Line 831: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',

827:
828:
829: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
830:
831: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',
832: p_event_key => to_char(p_person_id)||'-'||to_char(p_unique_key),
833: p_event_data => p_person_data);
834:
835: if p_assignment_id is not null

Line 844: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.asgchange',

840:
841:
842: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
843:
844: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.asgchange',
845: p_event_key => to_char(p_assignment_id)||'-'||to_char(p_unique_key),
846: p_event_data => p_assignment_data);
847:
848: else

Line 856: wf_event.AddParameterToList('person_id',p_person_id,myparameters);

852: if p_date > trunc(sysdate)
853: then
854:
855:
856: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
857: wf_event.AddParameterToList('assignment_id',rec_ass.assignment_id,myparameters);
858: wf_event.AddParameterToList('p_eff_start_date',p_date ,myparameters);
859: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
860: l_transaction_id := null;

Line 857: wf_event.AddParameterToList('assignment_id',rec_ass.assignment_id,myparameters);

853: then
854:
855:
856: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
857: wf_event.AddParameterToList('assignment_id',rec_ass.assignment_id,myparameters);
858: wf_event.AddParameterToList('p_eff_start_date',p_date ,myparameters);
859: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
860: l_transaction_id := null;
861: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);

Line 858: wf_event.AddParameterToList('p_eff_start_date',p_date ,myparameters);

854:
855:
856: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
857: wf_event.AddParameterToList('assignment_id',rec_ass.assignment_id,myparameters);
858: wf_event.AddParameterToList('p_eff_start_date',p_date ,myparameters);
859: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
860: l_transaction_id := null;
861: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
862: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);

Line 859: wf_event.AddParameterToList('asg_op_flag','I',myparameters);

855:
856: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
857: wf_event.AddParameterToList('assignment_id',rec_ass.assignment_id,myparameters);
858: wf_event.AddParameterToList('p_eff_start_date',p_date ,myparameters);
859: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
860: l_transaction_id := null;
861: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
862: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
863: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);

Line 863: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);

859: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
860: l_transaction_id := null;
861: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
862: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
863: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
864:
865: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
866:
867: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',

Line 865: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);

861: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
862: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
863: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
864:
865: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
866:
867: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',
868: p_when => p_date,
869: p_parameters => myparameters);

Line 880: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.asgchange',

876:
877:
878: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
879:
880: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.asgchange',
881: p_event_key => to_char(rec_ass.assignment_id)||'-'||to_char(p_unique_key),
882: p_event_data => p_assignment_data);
883:
884: end if;

Line 908: p_event_message WF_EVENT_T;

904: resultout in out NOCOPY varchar2)
905:
906: is
907: p_event_key varchar2(100);
908: p_event_message WF_EVENT_T;
909: p_event_data clob;
910: p_person_data clob;
911: p_person_id per_all_people_f.person_id%type;
912: p_unique_key number;

Line 1028: wf_event.AddParameterToList('person_id',p_person_id,myparameters);

1024:
1025: if p_date > trunc(sysdate)
1026: then
1027:
1028: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1029: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1030: wf_event.AddParameterToList('person_op_flag','U',myparameters);
1031: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1032: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);

Line 1029: wf_event.AddParameterToList('eff_date',p_date,myparameters);

1025: if p_date > trunc(sysdate)
1026: then
1027:
1028: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1029: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1030: wf_event.AddParameterToList('person_op_flag','U',myparameters);
1031: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1032: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1033: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);

Line 1030: wf_event.AddParameterToList('person_op_flag','U',myparameters);

1026: then
1027:
1028: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1029: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1030: wf_event.AddParameterToList('person_op_flag','U',myparameters);
1031: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1032: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1033: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1034:

Line 1033: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);

1029: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1030: wf_event.AddParameterToList('person_op_flag','U',myparameters);
1031: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1032: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1033: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1034:
1035: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1036:
1037: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.person_callbackable',

Line 1035: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);

1031: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1032: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1033: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1034:
1035: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1036:
1037: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.person_callbackable',
1038: p_when => p_date,
1039: p_parameters => myparameters);

Line 1053: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',

1049:
1050:
1051: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1052:
1053: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',
1054: p_event_key => to_char(p_person_id)||'-'||to_char(p_unique_key),
1055: p_event_data => p_person_data);
1056:
1057:

Line 1073: wf_event.AddParameterToList('person_id',p_person_id,myparameters);

1069: if p_date > trunc(sysdate)
1070: then
1071:
1072:
1073: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1074: wf_event.AddParameterToList('assignment_id',rec_ass.assignment_id,myparameters);
1075: wf_event.AddParameterToList('p_eff_start_date',p_date ,myparameters);
1076: wf_event.AddParameterToList('asg_op_flag','U',myparameters);
1077: l_transaction_id := 0;

Line 1074: wf_event.AddParameterToList('assignment_id',rec_ass.assignment_id,myparameters);

1070: then
1071:
1072:
1073: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1074: wf_event.AddParameterToList('assignment_id',rec_ass.assignment_id,myparameters);
1075: wf_event.AddParameterToList('p_eff_start_date',p_date ,myparameters);
1076: wf_event.AddParameterToList('asg_op_flag','U',myparameters);
1077: l_transaction_id := 0;
1078: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);

Line 1075: wf_event.AddParameterToList('p_eff_start_date',p_date ,myparameters);

1071:
1072:
1073: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1074: wf_event.AddParameterToList('assignment_id',rec_ass.assignment_id,myparameters);
1075: wf_event.AddParameterToList('p_eff_start_date',p_date ,myparameters);
1076: wf_event.AddParameterToList('asg_op_flag','U',myparameters);
1077: l_transaction_id := 0;
1078: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1079: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);

Line 1076: wf_event.AddParameterToList('asg_op_flag','U',myparameters);

1072:
1073: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1074: wf_event.AddParameterToList('assignment_id',rec_ass.assignment_id,myparameters);
1075: wf_event.AddParameterToList('p_eff_start_date',p_date ,myparameters);
1076: wf_event.AddParameterToList('asg_op_flag','U',myparameters);
1077: l_transaction_id := 0;
1078: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1079: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1080: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);

Line 1080: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);

1076: wf_event.AddParameterToList('asg_op_flag','U',myparameters);
1077: l_transaction_id := 0;
1078: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1079: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1080: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1081:
1082: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1083:
1084: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',

Line 1082: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);

1078: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1079: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1080: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1081:
1082: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1083:
1084: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',
1085: p_when => p_date,
1086: p_parameters => myparameters);

Line 1097: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.asgchange',

1093:
1094:
1095: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1096:
1097: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.asgchange',
1098: p_event_key => to_char(rec_ass.assignment_id)||'-'||to_char(p_unique_key),
1099: p_event_data => p_assignment_data);
1100:
1101: end if;

Line 1123: p_event_message WF_EVENT_T;

1119: resultout in out NOCOPY varchar2)
1120:
1121: is
1122: p_event_key varchar2(100);
1123: p_event_message WF_EVENT_T;
1124: p_event_data clob;
1125: p_person_data clob;
1126: p_person_id per_all_people_f.person_id%type;
1127: p_unique_key number;

Line 1196: wf_event.AddParameterToList('person_id',p_person_id,myparameters);

1192:
1193: if p_date > trunc(sysdate)
1194: then
1195:
1196: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1197: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1198: wf_event.AddParameterToList('address_id',p_address_id,myparameters);
1199: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1200: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);

Line 1197: wf_event.AddParameterToList('eff_date',p_date,myparameters);

1193: if p_date > trunc(sysdate)
1194: then
1195:
1196: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1197: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1198: wf_event.AddParameterToList('address_id',p_address_id,myparameters);
1199: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1200: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1201: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);

Line 1198: wf_event.AddParameterToList('address_id',p_address_id,myparameters);

1194: then
1195:
1196: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1197: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1198: wf_event.AddParameterToList('address_id',p_address_id,myparameters);
1199: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1200: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1201: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1202:

Line 1201: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);

1197: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1198: wf_event.AddParameterToList('address_id',p_address_id,myparameters);
1199: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1200: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1201: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1202:
1203: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1204:
1205: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.address_callbackable',

Line 1203: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);

1199: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1200: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1201: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1202:
1203: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1204:
1205: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.address_callbackable',
1206: p_when => p_date,
1207: p_parameters => myparameters);

Line 1221: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',

1217:
1218: hr_utility.set_location('in hr_rir_wf.address '||p_address_id ,51);
1219: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1220:
1221: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',
1222: p_event_key => to_char(p_person_id)||'-'||to_char(p_unique_key),
1223: p_event_data => p_person_data);
1224:
1225:

Line 1247: p_event_message WF_EVENT_T;

1243:
1244: is
1245:
1246: p_event_key varchar2(100);
1247: p_event_message WF_EVENT_T;
1248: p_event_data clob;
1249: p_person_data clob;
1250: p_person_id per_all_people_f.person_id%type;
1251: p_unique_key number;

Line 1319: wf_event.AddParameterToList('person_id',p_person_id,myparameters);

1315:
1316: if p_date > trunc(sysdate)
1317: then
1318:
1319: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1320: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1321: wf_event.AddParameterToList('phone_id',p_phone_id,myparameters);
1322: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1323: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);

Line 1320: wf_event.AddParameterToList('eff_date',p_date,myparameters);

1316: if p_date > trunc(sysdate)
1317: then
1318:
1319: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1320: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1321: wf_event.AddParameterToList('phone_id',p_phone_id,myparameters);
1322: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1323: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1324: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);

Line 1321: wf_event.AddParameterToList('phone_id',p_phone_id,myparameters);

1317: then
1318:
1319: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1320: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1321: wf_event.AddParameterToList('phone_id',p_phone_id,myparameters);
1322: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1323: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1324: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1325:

Line 1324: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);

1320: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1321: wf_event.AddParameterToList('phone_id',p_phone_id,myparameters);
1322: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1323: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1324: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1325:
1326: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1327:
1328: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.phone_callbackable',

Line 1326: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);

1322: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1323: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1324: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1325:
1326: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1327:
1328: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.phone_callbackable',
1329: p_when => p_date,
1330: p_parameters => myparameters);

Line 1344: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',

1340:
1341:
1342: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1343:
1344: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',
1345: p_event_key => to_char(p_person_id)||'-'||to_char(p_unique_key),
1346: p_event_data => p_person_data);
1347:
1348:

Line 1368: p_event_message WF_EVENT_T;

1364: resultout in out NOCOPY varchar2)
1365:
1366: is
1367: p_event_key varchar2(100);
1368: p_event_message WF_EVENT_T;
1369: p_event_data clob;
1370: p_assignment_data clob;
1371: p_unique_key number;
1372: v_document dbms_xmldom.domdocument;

Line 1442: wf_event.AddParameterToList('person_id',p_person_id,myparameters);

1438: if p_eff_start_date > trunc(sysdate) -- to_date('10/10/2008','DD/MM/YYYY')
1439: then
1440:
1441:
1442: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1443: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1444: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1445: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
1446: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);

Line 1443: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);

1439: then
1440:
1441:
1442: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1443: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1444: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1445: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
1446: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1447: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);

Line 1444: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);

1440:
1441:
1442: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1443: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1444: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1445: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
1446: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1447: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1448: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);

Line 1445: wf_event.AddParameterToList('asg_op_flag','I',myparameters);

1441:
1442: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1443: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1444: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1445: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
1446: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1447: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1448: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1449:

Line 1448: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);

1444: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1445: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
1446: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1447: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1448: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1449:
1450: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1451:
1452: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',

Line 1450: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);

1446: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1447: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1448: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1449:
1450: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1451:
1452: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',
1453: p_when => p_eff_start_date,
1454: p_parameters => myparameters);

Line 1465: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.asgchange',

1461:
1462:
1463: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1464:
1465: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.asgchange',
1466: p_event_key => to_char(p_assignment_id)||'-'||to_char(p_unique_key),
1467: p_event_data => p_assignment_data);
1468:
1469: end if;

Line 1487: p_event_message WF_EVENT_T;

1483: resultout in out NOCOPY varchar2)
1484:
1485: is
1486: p_event_key varchar2(100);
1487: p_event_message WF_EVENT_T;
1488: p_event_data clob;
1489: p_assignment_data clob;
1490: p_unique_key number;
1491: v_document dbms_xmldom.domdocument;

Line 1561: wf_event.AddParameterToList('person_id',p_person_id,myparameters);

1557: if p_eff_start_date > trunc(sysdate)
1558: then
1559:
1560:
1561: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1562: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1563: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1564: wf_event.AddParameterToList('asg_op_flag','U',myparameters);
1565: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);

Line 1562: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);

1558: then
1559:
1560:
1561: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1562: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1563: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1564: wf_event.AddParameterToList('asg_op_flag','U',myparameters);
1565: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1566: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);

Line 1563: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);

1559:
1560:
1561: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1562: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1563: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1564: wf_event.AddParameterToList('asg_op_flag','U',myparameters);
1565: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1566: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1567: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);

Line 1564: wf_event.AddParameterToList('asg_op_flag','U',myparameters);

1560:
1561: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1562: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1563: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1564: wf_event.AddParameterToList('asg_op_flag','U',myparameters);
1565: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1566: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1567: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1568:

Line 1567: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);

1563: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1564: wf_event.AddParameterToList('asg_op_flag','U',myparameters);
1565: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1566: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1567: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1568:
1569: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1570:
1571: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',

Line 1569: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);

1565: hr_hrhd_event_data_handler.hrhd_push_event_data(p_event_data,l_transaction_id);
1566: l_transaction_id_canonical := FND_NUMBER.number_to_canonical(l_transaction_id);
1567: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1568:
1569: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1570:
1571: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',
1572: p_when => p_eff_start_date,
1573: p_parameters => myparameters);

Line 1584: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.asgchange',

1580:
1581:
1582: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1583:
1584: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.asgchange',
1585: p_event_key => to_char(p_assignment_id)||'-'||to_char(p_unique_key),
1586: p_event_data => p_assignment_data);
1587:
1588: end if;

Line 2403: p_person_id := wf_event.getValueForParameter('person_id', my_parms);

2399:
2400: begin
2401:
2402:
2403: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2404: p_assignment_id := wf_event.getValueForParameter('assignment_id', my_parms);
2405: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2406: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
2407: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);

Line 2404: p_assignment_id := wf_event.getValueForParameter('assignment_id', my_parms);

2400: begin
2401:
2402:
2403: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2404: p_assignment_id := wf_event.getValueForParameter('assignment_id', my_parms);
2405: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2406: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
2407: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
2408: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);

Line 2405: p_date := wf_event.getValueForParameter('eff_date', my_parms);

2401:
2402:
2403: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2404: p_assignment_id := wf_event.getValueForParameter('assignment_id', my_parms);
2405: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2406: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
2407: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
2408: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);
2409: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);

Line 2406: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);

2402:
2403: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2404: p_assignment_id := wf_event.getValueForParameter('assignment_id', my_parms);
2405: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2406: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
2407: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
2408: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);
2409: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2410: p_asg_op_flag := wf_event.getValueForParameter('asg_op_flag', my_parms);

Line 2409: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);

2405: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2406: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
2407: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
2408: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);
2409: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2410: p_asg_op_flag := wf_event.getValueForParameter('asg_op_flag', my_parms);
2411:
2412: v_document := dbms_xmldom.newdomdocument(p_event_data);
2413:

Line 2410: p_asg_op_flag := wf_event.getValueForParameter('asg_op_flag', my_parms);

2406: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
2407: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
2408: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);
2409: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2410: p_asg_op_flag := wf_event.getValueForParameter('asg_op_flag', my_parms);
2411:
2412: v_document := dbms_xmldom.newdomdocument(p_event_data);
2413:
2414: -- extract the effective_start_date from the xml event message

Line 2627: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.asgchange',

2623: p_date => to_date(p_eff_start_date,'DD/MM/YYYY'));
2624:
2625: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2626:
2627: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.asgchange',
2628: p_event_key => to_char(p_assignment_id)||'-'||to_char(p_unique_key),
2629: p_event_data => p_assignment_data);
2630:
2631: end if;

Line 2743: p_person_id := wf_event.getValueForParameter('person_id', my_parms);

2739:
2740: begin
2741:
2742:
2743: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2744: p_person_op_flag := wf_event.getValueForParameter('person_op_flag', my_parms);
2745: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2746: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
2747: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);

Line 2744: p_person_op_flag := wf_event.getValueForParameter('person_op_flag', my_parms);

2740: begin
2741:
2742:
2743: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2744: p_person_op_flag := wf_event.getValueForParameter('person_op_flag', my_parms);
2745: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2746: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
2747: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
2748: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);

Line 2745: p_date := wf_event.getValueForParameter('eff_date', my_parms);

2741:
2742:
2743: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2744: p_person_op_flag := wf_event.getValueForParameter('person_op_flag', my_parms);
2745: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2746: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
2747: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
2748: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);
2749: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);

Line 2746: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);

2742:
2743: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2744: p_person_op_flag := wf_event.getValueForParameter('person_op_flag', my_parms);
2745: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2746: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
2747: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
2748: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);
2749: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2750: v_document := dbms_xmldom.newdomdocument(p_event_data);

Line 2749: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);

2745: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2746: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
2747: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
2748: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);
2749: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2750: v_document := dbms_xmldom.newdomdocument(p_event_data);
2751: -- extract the effective_end_date from the xml event message
2752:
2753: v_nodes := dbms_xmldom.getElementsByTagName(v_document, 'per_effective_end_date');

Line 2977: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',

2973:
2974: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2975:
2976:
2977: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',
2978: p_event_key => to_char(p_person_id)||'-'||to_char(p_unique_key),
2979: p_event_data => p_person_data);
2980:
2981: end if;

Line 3061: p_person_id := wf_event.getValueForParameter('person_id', my_parms);

3057: p_eff_date VARCHAR2(100);
3058:
3059: begin
3060:
3061: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
3062: p_date := wf_event.getValueForParameter('eff_date', my_parms);
3063: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
3064: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
3065: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);

Line 3062: p_date := wf_event.getValueForParameter('eff_date', my_parms);

3058:
3059: begin
3060:
3061: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
3062: p_date := wf_event.getValueForParameter('eff_date', my_parms);
3063: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
3064: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
3065: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);
3066: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);

Line 3063: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);

3059: begin
3060:
3061: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
3062: p_date := wf_event.getValueForParameter('eff_date', my_parms);
3063: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
3064: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
3065: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);
3066: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);
3067: p_address_id := wf_event.getValueForParameter('address_id', my_parms);

Line 3066: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);

3062: p_date := wf_event.getValueForParameter('eff_date', my_parms);
3063: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
3064: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
3065: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);
3066: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);
3067: p_address_id := wf_event.getValueForParameter('address_id', my_parms);
3068: v_document := dbms_xmldom.newdomdocument(p_event_data);
3069:
3070:

Line 3067: p_address_id := wf_event.getValueForParameter('address_id', my_parms);

3063: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
3064: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
3065: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);
3066: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);
3067: p_address_id := wf_event.getValueForParameter('address_id', my_parms);
3068: v_document := dbms_xmldom.newdomdocument(p_event_data);
3069:
3070:
3071: -- extract the date_from from the xml event message

Line 3219: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',

3215:
3216: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
3217:
3218:
3219: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',
3220: p_event_key => to_char(p_person_id)||'-'||to_char(p_unique_key),
3221: p_event_data => p_person_data);
3222:
3223: end if;

Line 3275: p_person_id := wf_event.getValueForParameter('person_id', my_parms);

3271: p_eff_date VARCHAR2(100);
3272:
3273: begin
3274:
3275: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
3276: p_date := wf_event.getValueForParameter('eff_date', my_parms);
3277: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
3278: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
3279: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);

Line 3276: p_date := wf_event.getValueForParameter('eff_date', my_parms);

3272:
3273: begin
3274:
3275: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
3276: p_date := wf_event.getValueForParameter('eff_date', my_parms);
3277: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
3278: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
3279: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);
3280: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);

Line 3277: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);

3273: begin
3274:
3275: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
3276: p_date := wf_event.getValueForParameter('eff_date', my_parms);
3277: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
3278: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
3279: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);
3280: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);
3281: p_phone_id := wf_event.getValueForParameter('phone_id', my_parms);

Line 3280: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);

3276: p_date := wf_event.getValueForParameter('eff_date', my_parms);
3277: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
3278: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
3279: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);
3280: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);
3281: p_phone_id := wf_event.getValueForParameter('phone_id', my_parms);
3282: v_document := dbms_xmldom.newdomdocument(p_event_data);
3283:
3284:

Line 3281: p_phone_id := wf_event.getValueForParameter('phone_id', my_parms);

3277: l_transaction_id_canonical := wf_event.getValueForParameter('transaction_id', my_parms);
3278: l_transaction_id := FND_NUMBER.canonical_to_number(l_transaction_id_canonical);
3279: hr_hrhd_event_data_handler.hrhd_retrieve_event_data(l_transaction_id, p_event_data);
3280: --p_event_data := wf_event.getValueForParameter('event_data', my_parms);
3281: p_phone_id := wf_event.getValueForParameter('phone_id', my_parms);
3282: v_document := dbms_xmldom.newdomdocument(p_event_data);
3283:
3284:
3285: -- extract the date_from from the xml event message

Line 3350: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',

3346:
3347: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
3348:
3349:
3350: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',
3351: p_event_key => to_char(p_person_id)||'-'||to_char(p_unique_key),
3352: p_event_data => p_person_data);
3353:
3354: end if;