[Home] [Help]
54: p_date_to => FALSE);
55:
56:
57:
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',
68: p_job_data := hr_hrhd_rir_wf.sif_job_data(p_job_id => p_job_id,
69: p_job_op_flag => 'U',
70: p_date_to => TRUE);
71:
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',
134: p_job_data := hr_hrhd_rir_wf.sif_job_data(p_job_id => p_job_id,
135: p_job_op_flag => 'I',
136: p_date_to => FALSE);
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),
147: p_job_data := hr_hrhd_rir_wf.sif_job_data(p_job_id => p_job_id,
148: p_job_op_flag => 'U',
149: p_date_to => TRUE);
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),
203: p_job_op_flag => 'D',
204: p_date_to => TRUE);
205:
206:
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',
269: p_location_data := hr_hrhd_rir_wf.sif_location_data(p_location_id => p_location_id,
270: p_loc_op_flag => 'I',
271: p_inactive_date => FALSE);
272:
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',
285: p_location_data := hr_hrhd_rir_wf.sif_location_data(p_location_id => p_location_id,
286: p_loc_op_flag => 'U',
287: p_inactive_date => TRUE);
288:
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',
354: p_location_data := hr_hrhd_rir_wf.sif_location_data(p_location_id => p_location_id,
355: p_loc_op_flag => 'U',
356: p_inactive_date => FALSE);
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),
367: p_location_data := hr_hrhd_rir_wf.sif_location_data(p_location_id => p_location_id,
368: p_loc_op_flag => 'U',
369: p_inactive_date => TRUE);
370:
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',
428: p_location_data := hr_hrhd_rir_wf.sif_location_data(p_location_id => p_location_id,
429: p_loc_op_flag => 'D',
430: p_inactive_date => TRUE);
431:
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',
514: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
515: p_org_op_flag => 'I',
516: p_date_to => FALSE);
517:
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',
530: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
531: p_org_op_flag => 'U',
532: p_date_to => TRUE);
533:
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',
615: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
616: p_org_op_flag => 'U',
617: p_date_to => FALSE);
618:
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',
629: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
630: p_org_op_flag => 'U',
631: p_date_to => TRUE);
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),
703: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
704: p_org_op_flag => 'D',
705: p_date_to => TRUE);
706:
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',
825: p_person_op_flag => 'I',
826: p_date => p_date);
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);
838: p_asg_op_flag => 'I',
839: p_date => p_date);
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);
874: p_asg_op_flag => 'I',
875: p_date => p_date);
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);
1047: p_person_op_flag => 'U',
1048: p_date => p_date);
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);
1091: p_asg_op_flag => 'U',
1092: p_date => p_date);
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);
1215: p_person_op_flag => 'U',
1216: p_date => p_date);
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);
1338: p_person_op_flag => 'U',
1339: p_date => p_date);
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);
1459: p_asg_op_flag => 'I',
1460: p_date => p_eff_start_date);
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);
1578: p_asg_op_flag => 'U',
1579: p_date => p_eff_start_date);
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);
1703: null as "BUSINESS_GROUP_ID",
1704: :1 as "ORGANIZATION_ID",
1705: to_char(trunc(sysdate),''YYYY-MM-DD'') as "EFFECTIVE_DATE",
1706: ''I'' as "EFFECTIVE_STATUS" ,
1707: cursor(select null lang_code ,null data from dual) as "ORGANIZATIONNAME",
1708: null as "LOCATION_ID",
1709: null as "MANAGER_ID"
1710: from dual
1711: ');
1706: ''I'' as "EFFECTIVE_STATUS" ,
1707: cursor(select null lang_code ,null data from dual) as "ORGANIZATIONNAME",
1708: null as "LOCATION_ID",
1709: null as "MANAGER_ID"
1710: from dual
1711: ');
1712:
1713: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_ORGANIZATION_id);
1714:
2062:
2063: to_char(trunc(sysdate),''YYYY-MM-DD'') as "EFFECTIVE_DATE",
2064: ''I'' as "EFFECTIVE_STATUS" ,
2065: :1 as "LOCATION_ID",
2066: cursor(select ''*'' lang_code ,''*'' data from dual) as "LOCATIONNAME",
2067: ''*'' as "STYLE",
2068: ''*'' as "COUNTRY",
2069: ''*'' as "ADDRESS_LINE_1",
2070: ''*'' as "ADDRESS_LINE_2",
2084: ''*'' as "LOC_INFORMATION17",
2085: ''*'' as "LOC_INFORMATION18",
2086: ''*'' as "LOC_INFORMATION19",
2087: ''*'' as "LOC_INFORMATION20"
2088: from dual
2089: ');
2090:
2091: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_location_id);
2092:
2214: ''*'' as "BUSINESS_GROUP_ID",
2215: :1 as "JOB_ID",
2216: to_char(trunc(sysdate),''YYYY-MM-DD'') as "EFFECTIVE_DATE",
2217: ''I'' as "EFFECTIVE_STATUS",
2218: cursor(select ''*'' lang_code ,''*'' data from dual) as "JOBNAME"
2219: from dual
2220: ');
2221:
2222: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_job_id);
2215: :1 as "JOB_ID",
2216: to_char(trunc(sysdate),''YYYY-MM-DD'') as "EFFECTIVE_DATE",
2217: ''I'' as "EFFECTIVE_STATUS",
2218: cursor(select ''*'' lang_code ,''*'' data from dual) as "JOBNAME"
2219: from dual
2220: ');
2221:
2222: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_job_id);
2223: else
2621: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id => p_assignment_id,
2622: p_asg_op_flag =>p_asg_op_flag,
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);
2970: p_phone_id => null,
2971: p_person_op_flag =>p_person_op_flag,
2972: p_date => to_date(p_date,'DD/MM/YYYY'));
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),
3212: p_phone_id => null,
3213: p_person_op_flag =>p_person_op_flag,
3214: p_date => to_date(p_date,'DD/MM/YYYY'));
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),
3343: p_phone_id => p_phone_id,
3344: p_person_op_flag =>'U',
3345: p_date => to_date(p_date,'DD/MM/YYYY'));
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),