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 DUAL

Line 58: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

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',

Line 72: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

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',

Line 138: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

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),

Line 151: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

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),

Line 207: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

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',

Line 273: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

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',

Line 289: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

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',

Line 358: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

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),

Line 371: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

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',

Line 432: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

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',

Line 514: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

510: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
511: p_org_op_flag => 'I',
512: p_date_to => FALSE);
513:
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',

Line 530: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

526: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
527: p_org_op_flag => 'U',
528: p_date_to => TRUE);
529:
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',

Line 615: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

611: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
612: p_org_op_flag => 'U',
613: p_date_to => FALSE);
614:
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',

Line 629: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

625: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
626: p_org_op_flag => 'U',
627: p_date_to => TRUE);
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),

Line 703: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

699: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
700: p_org_op_flag => 'D',
701: p_date_to => TRUE);
702:
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',

Line 813: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

809: p_person_op_flag => 'I',
810: p_date => p_date);
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);

Line 826: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

822: p_asg_op_flag => 'I',
823: p_date => p_date);
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);

Line 948: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

944: p_person_op_flag => 'U',
945: p_date => p_date);
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);

Line 1062: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

1058: p_person_op_flag => 'U',
1059: p_date => p_date);
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);

Line 1178: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

1174: p_person_op_flag => 'U',
1175: p_date => p_date);
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);

Line 1292: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

1288: p_asg_op_flag => 'I',
1289: p_date => p_eff_start_date);
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);

Line 1404: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

1400: p_asg_op_flag => 'U',
1401: p_date => p_eff_start_date);
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);

Line 1527: cursor(select null lang_code ,null data from dual) as "ORGANIZATIONNAME",

1523: null as "BUSINESS_GROUP_ID",
1524: :1 as "ORGANIZATION_ID",
1525: to_char(trunc(sysdate),''YYYY-MM-DD'') as "EFFECTIVE_DATE",
1526: ''I'' as "EFFECTIVE_STATUS" ,
1527: cursor(select null lang_code ,null data from dual) as "ORGANIZATIONNAME",
1528: null as "LOCATION_ID",
1529: null as "MANAGER_ID"
1530: from dual
1531: ');

Line 1530: from dual

1526: ''I'' as "EFFECTIVE_STATUS" ,
1527: cursor(select null lang_code ,null data from dual) as "ORGANIZATIONNAME",
1528: null as "LOCATION_ID",
1529: null as "MANAGER_ID"
1530: from dual
1531: ');
1532:
1533: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_ORGANIZATION_id);
1534:

Line 1883: cursor(select '''' lang_code ,'''' data from dual) as "LOCATIONNAME",

1879:
1880: to_char(trunc(sysdate),''YYYY-MM-DD'') as "EFFECTIVE_DATE",
1881: ''I'' as "EFFECTIVE_STATUS" ,
1882: :1 as "LOCATION_ID",
1883: cursor(select ''*'' lang_code ,''*'' data from dual) as "LOCATIONNAME",
1884: ''*'' as "STYLE",
1885: ''*'' as "COUNTRY",
1886: ''*'' as "ADDRESS_LINE_1",
1887: ''*'' as "ADDRESS_LINE_2",

Line 1905: from dual

1901: ''*'' as "LOC_INFORMATION17",
1902: ''*'' as "LOC_INFORMATION18",
1903: ''*'' as "LOC_INFORMATION19",
1904: ''*'' as "LOC_INFORMATION20"
1905: from dual
1906: ');
1907:
1908: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_location_id);
1909:

Line 2035: cursor(select '''' lang_code ,'''' data from dual) as "JOBNAME"

2031: ''*'' as "BUSINESS_GROUP_ID",
2032: :1 as "JOB_ID",
2033: to_char(trunc(sysdate),''YYYY-MM-DD'') as "EFFECTIVE_DATE",
2034: ''I'' as "EFFECTIVE_STATUS",
2035: cursor(select ''*'' lang_code ,''*'' data from dual) as "JOBNAME"
2036: from dual
2037: ');
2038:
2039: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_job_id);

Line 2036: from dual

2032: :1 as "JOB_ID",
2033: to_char(trunc(sysdate),''YYYY-MM-DD'') as "EFFECTIVE_DATE",
2034: ''I'' as "EFFECTIVE_STATUS",
2035: cursor(select ''*'' lang_code ,''*'' data from dual) as "JOBNAME"
2036: from dual
2037: ');
2038:
2039: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_job_id);
2040: else

Line 2422: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

2418: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id => p_assignment_id,
2419: p_asg_op_flag =>p_asg_op_flag,
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);

Line 2765: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

2761: p_phone_id => null,
2762: p_person_op_flag =>p_person_op_flag,
2763: p_date => to_date(p_date,'DD/MM/YYYY'));
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),

Line 2985: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

2981: p_phone_id => null,
2982: p_person_op_flag =>p_person_op_flag,
2983: p_date => to_date(p_date,'DD/MM/YYYY'));
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),

Line 3110: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

3106: p_phone_id => p_phone_id,
3107: p_person_op_flag =>'U',
3108: p_date => to_date(p_date,'DD/MM/YYYY'));
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),