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 518: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.orgchange',

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

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

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

Line 560: p_event_message WF_EVENT_T;

556: resultout in out NOCOPY varchar2)
557: is
558:
559: p_event_key varchar2(100);
560: p_event_message WF_EVENT_T;
561: p_event_data clob;
562: p_organization_data clob;
563: p_unique_key number;
564: p_organization_id number;

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

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

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

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

Line 657: p_event_message WF_EVENT_T;

653: resultout in out NOCOPY varchar2)
654: is
655:
656: p_event_key varchar2(100);
657: p_event_message WF_EVENT_T;
658: p_event_data clob;
659: p_organization_data clob;
660: p_unique_key number;
661: p_organization_id number;

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

703: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
704:
705:
706:
707: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.orgchange',
708: p_event_key => to_char(p_organization_id)||'-'||to_char(p_unique_key),
709: p_event_data => p_organization_data);
710:
711: end if;

Line 729: p_event_message WF_EVENT_T;

725: resultout in out NOCOPY varchar2)
726:
727: is
728: p_event_key varchar2(100);
729: p_event_message WF_EVENT_T;
730: p_event_data clob;
731: p_person_id per_all_people_f.person_id%type;
732: p_person_data clob;
733: p_assignment_data clob;

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

782:
783: if p_date > trunc(sysdate)
784: then
785:
786: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
787: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
788: wf_event.AddParameterToList('eff_date',p_date,myparameters);
789: wf_event.AddParameterToList('person_op_flag','I',myparameters);
790: wf_event.AddParameterToList('asg_op_flag','I',myparameters);

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

783: if p_date > trunc(sysdate)
784: then
785:
786: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
787: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
788: wf_event.AddParameterToList('eff_date',p_date,myparameters);
789: wf_event.AddParameterToList('person_op_flag','I',myparameters);
790: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
791: wf_event.AddParameterToList('event_data',p_event_data,myparameters);

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

784: then
785:
786: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
787: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
788: wf_event.AddParameterToList('eff_date',p_date,myparameters);
789: wf_event.AddParameterToList('person_op_flag','I',myparameters);
790: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
791: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
792:

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

785:
786: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
787: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
788: wf_event.AddParameterToList('eff_date',p_date,myparameters);
789: wf_event.AddParameterToList('person_op_flag','I',myparameters);
790: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
791: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
792:
793: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.person_callbackable',

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

786: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
787: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
788: wf_event.AddParameterToList('eff_date',p_date,myparameters);
789: wf_event.AddParameterToList('person_op_flag','I',myparameters);
790: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
791: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
792:
793: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.person_callbackable',
794: p_when => p_date,

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

787: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
788: wf_event.AddParameterToList('eff_date',p_date,myparameters);
789: wf_event.AddParameterToList('person_op_flag','I',myparameters);
790: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
791: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
792:
793: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.person_callbackable',
794: p_when => p_date,
795: p_parameters => myparameters);

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

811:
812:
813: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
814:
815: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',
816: p_event_key => to_char(p_person_id)||'-'||to_char(p_unique_key),
817: p_event_data => p_person_data);
818:
819: if p_assignment_id is not null

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

824:
825:
826: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
827:
828: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.asgchange',
829: p_event_key => to_char(p_assignment_id)||'-'||to_char(p_unique_key),
830: p_event_data => p_assignment_data);
831: end if;
832: end if;

Line 850: p_event_message WF_EVENT_T;

846: resultout in out NOCOPY varchar2)
847:
848: is
849: p_event_key varchar2(100);
850: p_event_message WF_EVENT_T;
851: p_event_data clob;
852: p_person_data clob;
853: p_person_id per_all_people_f.person_id%type;
854: p_assignment_data clob;

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

925:
926: if p_date > trunc(sysdate)
927: then
928:
929: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
930: wf_event.AddParameterToList('eff_date',p_date,myparameters);
931: wf_event.AddParameterToList('person_op_flag','U',myparameters);
932: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
933:

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

926: if p_date > trunc(sysdate)
927: then
928:
929: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
930: wf_event.AddParameterToList('eff_date',p_date,myparameters);
931: wf_event.AddParameterToList('person_op_flag','U',myparameters);
932: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
933:
934: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.person_callbackable',

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

927: then
928:
929: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
930: wf_event.AddParameterToList('eff_date',p_date,myparameters);
931: wf_event.AddParameterToList('person_op_flag','U',myparameters);
932: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
933:
934: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.person_callbackable',
935: p_when => p_date,

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

928:
929: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
930: wf_event.AddParameterToList('eff_date',p_date,myparameters);
931: wf_event.AddParameterToList('person_op_flag','U',myparameters);
932: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
933:
934: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.person_callbackable',
935: p_when => p_date,
936: p_parameters => myparameters);

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

946:
947:
948: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
949:
950: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',
951: p_event_key => to_char(p_person_id)||'-'||to_char(p_unique_key),
952: p_event_data => p_person_data);
953:
954:

Line 973: p_event_message WF_EVENT_T;

969: resultout in out NOCOPY varchar2)
970:
971: is
972: p_event_key varchar2(100);
973: p_event_message WF_EVENT_T;
974: p_event_data clob;
975: p_person_data clob;
976: p_person_id per_all_people_f.person_id%type;
977: p_unique_key number;

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

1039:
1040: if p_date > trunc(sysdate)
1041: then
1042:
1043: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1044: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1045: wf_event.AddParameterToList('address_id',p_address_id,myparameters);
1046: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1047:

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

1040: if p_date > trunc(sysdate)
1041: then
1042:
1043: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1044: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1045: wf_event.AddParameterToList('address_id',p_address_id,myparameters);
1046: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1047:
1048: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.address_callbackable',

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

1041: then
1042:
1043: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1044: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1045: wf_event.AddParameterToList('address_id',p_address_id,myparameters);
1046: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1047:
1048: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.address_callbackable',
1049: p_when => p_date,

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

1042:
1043: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1044: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1045: wf_event.AddParameterToList('address_id',p_address_id,myparameters);
1046: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1047:
1048: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.address_callbackable',
1049: p_when => p_date,
1050: p_parameters => myparameters);

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

1060:
1061: hr_utility.set_location('in hr_rir_wf.address '||p_address_id ,51);
1062: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1063:
1064: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',
1065: p_event_key => to_char(p_person_id)||'-'||to_char(p_unique_key),
1066: p_event_data => p_person_data);
1067:
1068:

Line 1090: p_event_message WF_EVENT_T;

1086:
1087: is
1088:
1089: p_event_key varchar2(100);
1090: p_event_message WF_EVENT_T;
1091: p_event_data clob;
1092: p_person_data clob;
1093: p_person_id per_all_people_f.person_id%type;
1094: p_unique_key number;

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

1155:
1156: if p_date > trunc(sysdate)
1157: then
1158:
1159: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1160: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1161: wf_event.AddParameterToList('phone_id',p_phone_id,myparameters);
1162: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1163:

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

1156: if p_date > trunc(sysdate)
1157: then
1158:
1159: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1160: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1161: wf_event.AddParameterToList('phone_id',p_phone_id,myparameters);
1162: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1163:
1164: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.phone_callbackable',

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

1157: then
1158:
1159: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1160: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1161: wf_event.AddParameterToList('phone_id',p_phone_id,myparameters);
1162: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1163:
1164: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.phone_callbackable',
1165: p_when => p_date,

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

1158:
1159: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1160: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1161: wf_event.AddParameterToList('phone_id',p_phone_id,myparameters);
1162: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1163:
1164: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.phone_callbackable',
1165: p_when => p_date,
1166: p_parameters => myparameters);

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

1176:
1177:
1178: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1179:
1180: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',
1181: p_event_key => to_char(p_person_id)||'-'||to_char(p_unique_key),
1182: p_event_data => p_person_data);
1183:
1184:

Line 1204: p_event_message WF_EVENT_T;

1200: resultout in out NOCOPY varchar2)
1201:
1202: is
1203: p_event_key varchar2(100);
1204: p_event_message WF_EVENT_T;
1205: p_event_data clob;
1206: p_assignment_data clob;
1207: p_unique_key number;
1208: v_document dbms_xmldom.domdocument;

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

1271: if p_eff_start_date > trunc(sysdate) -- to_date('10/10/2008','DD/MM/YYYY')
1272: then
1273:
1274:
1275: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1276: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1277: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1278: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
1279: wf_event.AddParameterToList('event_data',p_event_data,myparameters);

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

1272: then
1273:
1274:
1275: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1276: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1277: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1278: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
1279: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1280:

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

1273:
1274:
1275: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1276: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1277: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1278: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
1279: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1280:
1281: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',

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

1274:
1275: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1276: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1277: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1278: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
1279: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1280:
1281: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',
1282: p_when => p_eff_start_date,

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

1275: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1276: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1277: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1278: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
1279: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1280:
1281: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',
1282: p_when => p_eff_start_date,
1283: p_parameters => myparameters);

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

1290:
1291:
1292: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1293:
1294: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.asgchange',
1295: p_event_key => to_char(p_assignment_id)||'-'||to_char(p_unique_key),
1296: p_event_data => p_assignment_data);
1297:
1298: end if;

Line 1316: p_event_message WF_EVENT_T;

1312: resultout in out NOCOPY varchar2)
1313:
1314: is
1315: p_event_key varchar2(100);
1316: p_event_message WF_EVENT_T;
1317: p_event_data clob;
1318: p_assignment_data clob;
1319: p_unique_key number;
1320: v_document dbms_xmldom.domdocument;

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

1383: if p_eff_start_date > trunc(sysdate)
1384: then
1385:
1386:
1387: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1388: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1389: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1390: wf_event.AddParameterToList('asg_op_flag','U',myparameters);
1391: wf_event.AddParameterToList('event_data',p_event_data,myparameters);

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

1384: then
1385:
1386:
1387: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1388: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1389: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1390: wf_event.AddParameterToList('asg_op_flag','U',myparameters);
1391: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1392:

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

1385:
1386:
1387: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1388: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1389: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1390: wf_event.AddParameterToList('asg_op_flag','U',myparameters);
1391: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1392:
1393: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',

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

1386:
1387: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1388: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1389: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1390: wf_event.AddParameterToList('asg_op_flag','U',myparameters);
1391: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1392:
1393: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',
1394: p_when => p_eff_start_date,

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

1387: wf_event.AddParameterToList('person_id',p_person_id,myparameters);
1388: wf_event.AddParameterToList('assignment_id',p_assignment_id,myparameters);
1389: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1390: wf_event.AddParameterToList('asg_op_flag','U',myparameters);
1391: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1392:
1393: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',
1394: p_when => p_eff_start_date,
1395: p_parameters => myparameters);

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

1402:
1403:
1404: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1405:
1406: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.asgchange',
1407: p_event_key => to_char(p_assignment_id)||'-'||to_char(p_unique_key),
1408: p_event_data => p_assignment_data);
1409:
1410: end if;

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

2209:
2210: begin
2211:
2212:
2213: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2214: p_assignment_id := wf_event.getValueForParameter('assignment_id', my_parms);
2215: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2216: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2217: p_asg_op_flag := wf_event.getValueForParameter('asg_op_flag', my_parms);

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

2210: begin
2211:
2212:
2213: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2214: p_assignment_id := wf_event.getValueForParameter('assignment_id', my_parms);
2215: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2216: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2217: p_asg_op_flag := wf_event.getValueForParameter('asg_op_flag', my_parms);
2218:

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

2211:
2212:
2213: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2214: p_assignment_id := wf_event.getValueForParameter('assignment_id', my_parms);
2215: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2216: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2217: p_asg_op_flag := wf_event.getValueForParameter('asg_op_flag', my_parms);
2218:
2219: v_document := dbms_xmldom.newdomdocument(p_event_data);

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

2212:
2213: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2214: p_assignment_id := wf_event.getValueForParameter('assignment_id', my_parms);
2215: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2216: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2217: p_asg_op_flag := wf_event.getValueForParameter('asg_op_flag', my_parms);
2218:
2219: v_document := dbms_xmldom.newdomdocument(p_event_data);
2220:

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

2213: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2214: p_assignment_id := wf_event.getValueForParameter('assignment_id', my_parms);
2215: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2216: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2217: p_asg_op_flag := wf_event.getValueForParameter('asg_op_flag', my_parms);
2218:
2219: v_document := dbms_xmldom.newdomdocument(p_event_data);
2220:
2221: -- extract the effective_start_date from the xml event message

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

2420: p_date => to_date(p_eff_start_date,'DD/MM/YYYY'));
2421:
2422: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2423:
2424: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.asgchange',
2425: p_event_key => to_char(p_assignment_id)||'-'||to_char(p_unique_key),
2426: p_event_data => p_assignment_data);
2427:
2428: end if;

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

2533:
2534: begin
2535:
2536:
2537: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2538: p_person_op_flag := wf_event.getValueForParameter('person_op_flag', my_parms);
2539: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2540: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2541: v_document := dbms_xmldom.newdomdocument(p_event_data);

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

2534: begin
2535:
2536:
2537: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2538: p_person_op_flag := wf_event.getValueForParameter('person_op_flag', my_parms);
2539: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2540: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2541: v_document := dbms_xmldom.newdomdocument(p_event_data);
2542: -- extract the effective_end_date from the xml event message

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

2535:
2536:
2537: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2538: p_person_op_flag := wf_event.getValueForParameter('person_op_flag', my_parms);
2539: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2540: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2541: v_document := dbms_xmldom.newdomdocument(p_event_data);
2542: -- extract the effective_end_date from the xml event message
2543:

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

2536:
2537: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2538: p_person_op_flag := wf_event.getValueForParameter('person_op_flag', my_parms);
2539: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2540: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2541: v_document := dbms_xmldom.newdomdocument(p_event_data);
2542: -- extract the effective_end_date from the xml event message
2543:
2544: v_nodes := dbms_xmldom.getElementsByTagName(v_document, 'per_effective_end_date');

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

2764:
2765: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2766:
2767:
2768: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',
2769: p_event_key => to_char(p_person_id)||'-'||to_char(p_unique_key),
2770: p_event_data => p_person_data);
2771:
2772: end if;

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

2840: p_eff_date VARCHAR2(100);
2841:
2842: begin
2843:
2844: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2845: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2846: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2847: p_address_id := wf_event.getValueForParameter('address_id', my_parms);
2848: v_document := dbms_xmldom.newdomdocument(p_event_data);

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

2841:
2842: begin
2843:
2844: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2845: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2846: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2847: p_address_id := wf_event.getValueForParameter('address_id', my_parms);
2848: v_document := dbms_xmldom.newdomdocument(p_event_data);
2849:

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

2842: begin
2843:
2844: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2845: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2846: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2847: p_address_id := wf_event.getValueForParameter('address_id', my_parms);
2848: v_document := dbms_xmldom.newdomdocument(p_event_data);
2849:
2850:

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

2843:
2844: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
2845: p_date := wf_event.getValueForParameter('eff_date', my_parms);
2846: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
2847: p_address_id := wf_event.getValueForParameter('address_id', my_parms);
2848: v_document := dbms_xmldom.newdomdocument(p_event_data);
2849:
2850:
2851: -- extract the date_from from the xml event message

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

2984:
2985: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2986:
2987:
2988: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',
2989: p_event_key => to_char(p_person_id)||'-'||to_char(p_unique_key),
2990: p_event_data => p_person_data);
2991:
2992: end if;

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

3037: p_eff_date VARCHAR2(100);
3038:
3039: begin
3040:
3041: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
3042: p_date := wf_event.getValueForParameter('eff_date', my_parms);
3043: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
3044: p_phone_id := wf_event.getValueForParameter('phone_id', my_parms);
3045: v_document := dbms_xmldom.newdomdocument(p_event_data);

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

3038:
3039: begin
3040:
3041: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
3042: p_date := wf_event.getValueForParameter('eff_date', my_parms);
3043: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
3044: p_phone_id := wf_event.getValueForParameter('phone_id', my_parms);
3045: v_document := dbms_xmldom.newdomdocument(p_event_data);
3046:

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

3039: begin
3040:
3041: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
3042: p_date := wf_event.getValueForParameter('eff_date', my_parms);
3043: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
3044: p_phone_id := wf_event.getValueForParameter('phone_id', my_parms);
3045: v_document := dbms_xmldom.newdomdocument(p_event_data);
3046:
3047:

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

3040:
3041: p_person_id := wf_event.getValueForParameter('person_id', my_parms);
3042: p_date := wf_event.getValueForParameter('eff_date', my_parms);
3043: p_event_data := wf_event.getValueForParameter('event_data', my_parms);
3044: p_phone_id := wf_event.getValueForParameter('phone_id', my_parms);
3045: v_document := dbms_xmldom.newdomdocument(p_event_data);
3046:
3047:
3048: -- extract the date_from from the xml event message

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

3109:
3110: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
3111:
3112:
3113: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhd.personchange',
3114: p_event_key => to_char(p_person_id)||'-'||to_char(p_unique_key),
3115: p_event_data => p_person_data);
3116:
3117: end if;