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.HXC_SUPERVISOR_DASHBOARD dependencies on HXC_TEMP_TCD

Line 155: hxc_timecard_summary tim, hxc_temp_tcd temp

151: NULL,LEAD(tim.start_time,1,NULL) over (partition by tim.resource_id Order by tim.stop_time) -1),
152: tim.approval_status
153:
154: FROM
155: hxc_timecard_summary tim, hxc_temp_tcd temp
156: WHERE tim.resource_id = temp.resource_id
157: tim.stop_time >= temp.start_time
158: and tim.start_time <= temp.stop_time';
159:

Line 165: timecard_exist from HXC_TEMP_TCD';

161:
162: l_sql2 varchar2(500) :=
163: ' select resource_id, start_time,
164: stop_time, approval_status,
165: timecard_exist from HXC_TEMP_TCD';
166:
167: connect_by_detected EXCEPTION;
168: PRAGMA EXCEPTION_INIT(connect_by_detected, -1436);
169:

Line 213: , hxc_temp_tcd temp

209: , 'P', temp.period_exist)
210: , temp.start_time
211: , temp.stop_time
212: FROM hxc_timecard_summary tim
213: , hxc_temp_tcd temp
214: WHERE tim.stop_time >= temp.start_time
215: AND tim.start_time <= temp.stop_time
216: AND temp.resource_id = tim.resource_id
217: AND temp.user_id = p_user_id;

Line 280: Delete extra records from GTT hxc_temp_tcd.

276: AND object_version_number = p_timecard_ovn
277: AND date_to = hr_general.end_of_time;
278:
279: /*
280: Delete extra records from GTT hxc_temp_tcd.
281: */
282:
283:
284:

Line 307: DELETE FROM hxc_temp_tcd

303: IF g_debug THEN
304: hr_utility.trace('deleting temp extra records');
305: END IF;
306:
307: DELETE FROM hxc_temp_tcd
308: WHERE resource_id in (SELECT distinct resource_id FROM hxc_temp_tcd WHERE period_exist = 'P' or period_exist = 'p')
309: AND period_exist = 'T';
310:
311: DELETE FROM hxc_temp_tcd

Line 308: WHERE resource_id in (SELECT distinct resource_id FROM hxc_temp_tcd WHERE period_exist = 'P' or period_exist = 'p')

304: hr_utility.trace('deleting temp extra records');
305: END IF;
306:
307: DELETE FROM hxc_temp_tcd
308: WHERE resource_id in (SELECT distinct resource_id FROM hxc_temp_tcd WHERE period_exist = 'P' or period_exist = 'p')
309: AND period_exist = 'T';
310:
311: DELETE FROM hxc_temp_tcd
312: WHERE resource_id in (SELECT distinct resource_id FROM hxc_temp_tcd WHERE period_exist = 'm')

Line 311: DELETE FROM hxc_temp_tcd

307: DELETE FROM hxc_temp_tcd
308: WHERE resource_id in (SELECT distinct resource_id FROM hxc_temp_tcd WHERE period_exist = 'P' or period_exist = 'p')
309: AND period_exist = 'T';
310:
311: DELETE FROM hxc_temp_tcd
312: WHERE resource_id in (SELECT distinct resource_id FROM hxc_temp_tcd WHERE period_exist = 'm')
313: AND period_exist = 'M';
314:
315: DELETE FROM hxc_temp_tcd

Line 312: WHERE resource_id in (SELECT distinct resource_id FROM hxc_temp_tcd WHERE period_exist = 'm')

308: WHERE resource_id in (SELECT distinct resource_id FROM hxc_temp_tcd WHERE period_exist = 'P' or period_exist = 'p')
309: AND period_exist = 'T';
310:
311: DELETE FROM hxc_temp_tcd
312: WHERE resource_id in (SELECT distinct resource_id FROM hxc_temp_tcd WHERE period_exist = 'm')
313: AND period_exist = 'M';
314:
315: DELETE FROM hxc_temp_tcd
316: WHERE resource_id in (SELECT distinct resource_id FROM hxc_temp_tcd WHERE period_exist = 'r')

Line 315: DELETE FROM hxc_temp_tcd

311: DELETE FROM hxc_temp_tcd
312: WHERE resource_id in (SELECT distinct resource_id FROM hxc_temp_tcd WHERE period_exist = 'm')
313: AND period_exist = 'M';
314:
315: DELETE FROM hxc_temp_tcd
316: WHERE resource_id in (SELECT distinct resource_id FROM hxc_temp_tcd WHERE period_exist = 'r')
317: AND period_exist = 'R';
318:
319: IF g_debug THEN

Line 316: WHERE resource_id in (SELECT distinct resource_id FROM hxc_temp_tcd WHERE period_exist = 'r')

312: WHERE resource_id in (SELECT distinct resource_id FROM hxc_temp_tcd WHERE period_exist = 'm')
313: AND period_exist = 'M';
314:
315: DELETE FROM hxc_temp_tcd
316: WHERE resource_id in (SELECT distinct resource_id FROM hxc_temp_tcd WHERE period_exist = 'r')
317: AND period_exist = 'R';
318:
319: IF g_debug THEN
320: hr_utility.trace('deleting temp extra records completed');

Line 392: DELETE FROM HXC_TEMP_TCD

388: l_proc := g_package||'delete_person_temp';
389: hr_utility.set_location('Entering:'|| l_proc, 10);
390: END IF;
391:
392: DELETE FROM HXC_TEMP_TCD
393: WHERE recurring_period_id <> p_recurring_period
394: AND user_id = p_user_id
395: AND PERIOD_EXIST = 'T';
396:

Line 415: DELETE FROM HXC_TEMP_TCD

411: l_proc := g_package||'clear_all_temp_tab';
412: hr_utility.set_location('Entering:'|| l_proc, 10);
413: END IF;
414:
415: DELETE FROM HXC_TEMP_TCD
416: WHERE user_id = p_user_id;
417:
418: DELETE FROM HXC_TCD_TIMECARDS
419: WHERE user_id = p_user_id;

Line 673: hxc_temp_tcd htt

669: ,htt.stop_time
670: ,ppos.date_start period_start_date
671: ,NVL(ppos.actual_termination_date,hr_general.end_of_time) period_end_date
672: FROM
673: hxc_temp_tcd htt
674: ,per_periods_of_service ppos
675: WHERE (htt.period_exist = p_period_exist OR
676: htt.period_exist = lower(p_period_exist))
677: AND ppos.person_id = htt.resource_id

Line 691: hxc_temp_tcd htt

687: ,htt.stop_time
688: ,ppos.date_start period_start_date
689: ,NVL(ppos.actual_termination_date,hr_general.end_of_time) period_end_date
690: FROM
691: hxc_temp_tcd htt
692: ,per_periods_of_placement ppos
693: WHERE (htt.period_exist = p_period_exist OR
694: htt.period_exist = lower(p_period_exist))
695: AND ppos.person_id = htt.resource_id

Line 710: , hxc_temp_tcd htt

706: , decode (greatest (asg.effective_start_date, htt.start_time), asg.effective_start_date
707: , 'M', 'R')
708: FROM per_all_assignments_f asg
709: , per_assignment_status_types past
710: , hxc_temp_tcd htt
711: WHERE asg.person_id = htt.resource_id
712: AND asg.effective_start_date > p_start_date
713: AND asg.effective_end_date < p_end_date
714: AND htt.user_id = p_user_id

Line 726: FROM hxc_temp_tcd htt

722: , htt.start_time
723: , htt.stop_time
724: , min (paaf.effective_start_date) start_date
725: , max (paaf.effective_end_date) end_date
726: FROM hxc_temp_tcd htt
727: , per_all_assignments_f paaf
728: , per_assignment_status_types past
729: WHERE paaf.person_id = htt.resource_id
730: AND paaf.effective_start_date <= p_end_date

Line 747: FROM hxc_temp_tcd

743: SELECT resource_id
744: , start_time
745: , stop_time
746: , period_exist
747: FROM hxc_temp_tcd
748: WHERE user_id = p_user_id;
749:
750: l_resource_id VARCHARTAB;
751: l_start_time DATETAB;

Line 769: UPDATE hxc_temp_tcd

765: FETCH c_emp_hire_records BULK COLLECT INTO l_resource_id,l_start_time,l_stop_time,l_period_start_date, l_period_end_date LIMIT 500;
766: EXIT WHEN l_resource_id.count = 0;
767:
768: FORALL i IN l_resource_id.FIRST..l_resource_id.LAST
769: UPDATE hxc_temp_tcd
770: SET period_exist = 'T',
771: period_start_date = l_period_start_date(i),
772: period_end_date = l_period_end_date(i)
773: WHERE user_id = l_user_id

Line 788: UPDATE hxc_temp_tcd

784: FETCH c_emp_hire_records BULK COLLECT INTO l_resource_id,l_start_time,l_stop_time,l_period_start_date, l_period_end_date LIMIT 500;
785: EXIT WHEN l_resource_id.count = 0;
786:
787: FORALL i IN l_resource_id.FIRST..l_resource_id.LAST
788: UPDATE hxc_temp_tcd
789: SET
790: period_start_date = l_period_start_date(i),
791: period_end_date = l_period_end_date(i)
792: WHERE user_id = l_user_id

Line 807: UPDATE hxc_temp_tcd

803: FETCH c_emp_hire_records BULK COLLECT INTO l_resource_id,l_start_time,l_stop_time,l_period_start_date, l_period_end_date LIMIT 500;
804: EXIT WHEN l_resource_id.count = 0;
805:
806: FORALL i IN l_resource_id.FIRST..l_resource_id.LAST
807: UPDATE hxc_temp_tcd
808: SET period_exist = 'T',
809: period_start_date = l_period_start_date(i),
810: period_end_date = l_period_end_date(i)
811: WHERE user_id = l_user_id

Line 828: UPDATE hxc_temp_tcd

824: FETCH c_cont_emp_hire_records BULK COLLECT INTO l_resource_id,l_start_time,l_stop_time,l_period_start_date, l_period_end_date LIMIT 500;
825: EXIT WHEN l_resource_id.count = 0;
826:
827: FORALL i IN l_resource_id.FIRST..l_resource_id.LAST
828: UPDATE hxc_temp_tcd
829: SET period_exist = 'T',
830: period_start_date = l_period_start_date(i),
831: period_end_date = l_period_end_date(i)
832: WHERE user_id = l_user_id

Line 848: UPDATE hxc_temp_tcd

844: FETCH c_cont_emp_hire_records BULK COLLECT INTO l_resource_id,l_start_time,l_stop_time,l_period_start_date, l_period_end_date LIMIT 500;
845: EXIT WHEN l_resource_id.count = 0;
846:
847: FORALL i IN l_resource_id.FIRST..l_resource_id.LAST
848: UPDATE hxc_temp_tcd
849: SET period_exist = 'T',
850: period_start_date = l_period_start_date(i),
851: period_end_date = l_period_end_date(i)
852: WHERE user_id = l_user_id

Line 870: UPDATE hxc_temp_tcd

866: hr_utility.trace('count :: '||l_resource_id.count);
867: exit when l_resource_id.count = 0;
868:
869: FORALL i IN l_resource_id.FIRST..l_resource_id.LAST
870: UPDATE hxc_temp_tcd
871: SET period_exist = l_exist(i)
872: WHERE user_id = l_user_id
873: AND resource_id = l_resource_id(i)
874: AND start_time = l_start_time(i)

Line 889: UPDATE hxc_temp_tcd

885: exit when l_resource_id.count = 0;
886:
887:
888: FORALL i IN l_resource_id.FIRST..l_resource_id.LAST
889: UPDATE hxc_temp_tcd
890: SET ASSG_START_DATE = l_period_start_date(i)
891: , ASSG_END_DATE = l_period_end_date(i)
892: WHERE user_id = l_user_id
893: AND resource_id = l_resource_id(i)

Line 920: hxc_temp_tcd htt,

916: ,per.npw_number) person_number,
917: per.full_name,
918: htt.resource_id
919: FROM
920: hxc_temp_tcd htt,
921: per_all_people_f per
922: WHERE htt.resource_id = per.person_id
923: AND trunc(per.effective_start_date) <= trunc(SYSDATE)
924: AND trunc(per.effective_end_date) >= trunc(SYSDATE)

Line 950: UPDATE hxc_temp_tcd

946: LIMIT 500;
947: EXIT WHEN l_person_ids.COUNT = 0;
948:
949: FORALL i IN l_person_ids.FIRST..l_person_ids.LAST
950: UPDATE hxc_temp_tcd
951: SET person_number = l_person_ids(i),
952: full_name = l_person_names(i)
953: WHERE user_id = p_user_id
954: AND resource_id = l_resource_ids(i);

Line 978: pay_all_payrolls_f pap, hxc_temp_tcd htt

974: DISTINCT
975: pap.payroll_name,
976: htt.payroll_name
977: FROM
978: pay_all_payrolls_f pap, hxc_temp_tcd htt
979: WHERE pap.payroll_id = htt.payroll_name
980: AND trunc(pap.effective_start_date) <= trunc(SYSDATE)
981: AND trunc(pap.effective_end_date) >= trunc(SYSDATE)
982: AND htt.user_id = p_user_id;

Line 1002: UPDATE hxc_temp_tcd

998:
999: EXIT WHEN l_payroll_ids.COUNT = 0;
1000:
1001: FORALL i IN l_payroll_ids.FIRST..l_payroll_ids.LAST
1002: UPDATE hxc_temp_tcd
1003: SET payroll_name = l_payroll_names(i)
1004: WHERE user_id = p_user_id
1005: AND payroll_name = l_payroll_ids(i);
1006: END LOOP;

Line 1028: hr_all_organization_units_tl hxo, hxc_temp_tcd htt

1024: DISTINCT
1025: hxo.name,
1026: htt.organization_name
1027: FROM
1028: hr_all_organization_units_tl hxo, hxc_temp_tcd htt
1029: WHERE hxo.organization_id = htt.organization_name
1030: AND htt.user_id = p_user_id
1031: AND hxo.language = userenv('LANG');
1032:

Line 1050: UPDATE hxc_temp_tcd

1046:
1047: EXIT WHEN l_organization_ids.COUNT = 0;
1048:
1049: FORALL i IN l_organization_ids.FIRST..l_organization_ids.LAST
1050: UPDATE hxc_temp_tcd
1051: SET organization_name = l_organization_names(i)
1052: WHERE user_id = p_user_id
1053: AND organization_name = l_organization_ids(i);
1054:

Line 1079: hr_locations_all_tl hxl, hxc_temp_tcd htt

1075: DISTINCT
1076: hxl.location_code,
1077: htt.location_name
1078: FROM
1079: hr_locations_all_tl hxl, hxc_temp_tcd htt
1080: WHERE hxl.location_id = htt.location_name
1081: AND htt.user_id = p_user_id
1082: AND hxl.language = userenv('LANG');
1083:

Line 1102: UPDATE hxc_temp_tcd

1098: LIMIT 500;
1099: EXIT WHEN l_location_ids.COUNT = 0;
1100:
1101: FORALL i IN l_location_ids.FIRST..l_location_ids.LAST
1102: UPDATE hxc_temp_tcd
1103: SET location_name = l_location_names(i)
1104: WHERE user_id = p_user_id
1105: AND location_name = l_location_ids(i);
1106:

Line 1130: per_all_people_f per, hxc_temp_tcd htt

1126: DISTINCT
1127: per.full_name,
1128: htt.supervisor_name
1129: FROM
1130: per_all_people_f per, hxc_temp_tcd htt
1131: WHERE per.person_id = htt.supervisor_name
1132: AND htt.user_id = p_user_id;
1133:
1134: l_supervisor_ids VARCHARTAB;

Line 1152: UPDATE hxc_temp_tcd

1148: LIMIT 500;
1149: EXIT WHEN l_supervisor_ids.COUNT = 0;
1150:
1151: FORALL i IN l_supervisor_ids.FIRST..l_supervisor_ids.LAST
1152: UPDATE hxc_temp_tcd
1153: SET supervisor_name = l_supervisor_names(i)
1154: WHERE user_id = p_user_id
1155: AND supervisor_name = l_supervisor_ids(i);
1156:

Line 1180: hxc_temp_tcd htt

1176: htt.resource_id
1177: FROM
1178: per_person_types ppt,
1179: per_person_type_usages_f ptu,
1180: hxc_temp_tcd htt
1181: WHERE htt.resource_id = ptu.person_id
1182: AND ppt.person_type_id = ptu.person_type_id
1183: AND trunc(ptu.effective_start_date) <= trunc(SYSDATE)
1184: AND trunc(ptu.effective_end_date) >= trunc(SYSDATE)

Line 1206: UPDATE hxc_temp_tcd

1202: LIMIT 500;
1203: EXIT WHEN l_resource_ids.COUNT = 0;
1204:
1205: FORALL i IN l_person_types.FIRST..l_person_types.LAST
1206: UPDATE hxc_temp_tcd
1207: SET person_type = l_person_types(i)
1208: WHERE user_id = p_user_id
1209: AND resource_id = l_resource_ids(i);
1210:

Line 1234: hxc_temp_tcd htt

1230: heg.name application_set_name,
1231: htt.resource_id
1232: FROM
1233: hxc_entity_groups heg,
1234: hxc_temp_tcd htt
1235: WHERE heg.entity_type = 'TIME_RECIPIENTS'
1236: AND htt.application IS NOT NULL
1237: AND heg.entity_group_id = htt.application
1238: AND htt.user_id = p_user_id;

Line 1258: UPDATE hxc_temp_tcd

1254: LIMIT 500;
1255: EXIT WHEN l_resource_ids.COUNT = 0;
1256:
1257: FORALL i IN l_applications.FIRST..l_applications.LAST
1258: UPDATE hxc_temp_tcd
1259: SET application = l_applications(i)
1260: WHERE user_id = p_user_id
1261: AND resource_id = l_resource_ids(i);
1262:

Line 1284: hxc_temp_tcd htt

1280: flv.meaning,
1281: htt.approval_status
1282: FROM
1283: fnd_lookup_values flv,
1284: hxc_temp_tcd htt
1285: WHERE flv.language = userenv('LANG')
1286: AND flv.view_application_id = 3
1287: AND flv.lookup_type = 'HXC_APPROVAL_STATUS'
1288: AND htt.approval_status = flv.lookup_code

Line 1310: UPDATE hxc_temp_tcd

1306:
1307: EXIT WHEN l_approval_status.COUNT = 0;
1308:
1309: FORALL i IN l_approval_status.FIRST..l_approval_status.LAST
1310: UPDATE hxc_temp_tcd
1311: SET meaning = l_meanings(i)
1312: WHERE user_id = p_user_id
1313: AND approval_status = l_approval_status(i);
1314:

Line 1335: hxc_temp_tcd htt

1331: htt.timecard_id,
1332: htt.timecard_ovn
1333: FROM
1334: hxc_time_building_blocks tim,
1335: hxc_temp_tcd htt
1336: WHERE tim.scope like 'TIMECARD'
1337: AND htt.timecard_id = tim.time_building_block_id
1338: AND htt.timecard_ovn = tim.object_version_number
1339: AND htt.user_id = p_user_id ;

Line 1365: UPDATE hxc_temp_tcd

1361:
1362: EXIT WHEN l_timecard_ids.COUNT = 0;
1363:
1364: FORALL i IN l_timecard_ids.FIRST..l_timecard_ids.LAST
1365: UPDATE hxc_temp_tcd
1366: SET last_modified_by = l_last_update_logins(i),
1367: last_modified_date = l_last_update_dates(i)
1368: WHERE user_id = p_user_id
1369: AND timecard_id = l_timecard_ids(i)

Line 1392: hxc_temp_tcd htt

1388: fu.user_name,
1389: htt.last_modified_by
1390: FROM
1391: fnd_user fu,
1392: hxc_temp_tcd htt
1393: WHERE fu.user_id = htt.last_modified_by
1394: AND htt.user_id = p_user_id;
1395:
1396:

Line 1417: UPDATE hxc_temp_tcd

1413: EXIT WHEN l_user_names.COUNT = 0;
1414:
1415: FOR i IN 1..l_last_modified_by.COUNT
1416: LOOP
1417: UPDATE hxc_temp_tcd
1418: SET last_modified_by = l_user_names(i)
1419: WHERE user_id = p_user_id
1420: AND last_modified_by = l_last_modified_by(i)
1421: AND last_modified_by IS NOT NULL;

Line 1440: FROM hxc_temp_tcd htt

1436: AS
1437: CURSOR c_timecards(p_user_id number)
1438: IS
1439: SELECT htt.timecard_id
1440: FROM hxc_temp_tcd htt
1441: WHERE htt.timecard_id IS NOT NULL
1442: AND htt.approval_status LIKE 'SUBMITTED'
1443: AND htt.user_id = p_user_id;
1444:

Line 1449: FROM hxc_temp_tcd htt

1445: CURSOR c_insert_application_period_id(p_user_id number)
1446: IS
1447: SELECT htt.timecard_id
1448: ,hta.application_period_id
1449: FROM hxc_temp_tcd htt
1450: ,hxc_tc_ap_links hta
1451: WHERE htt.timecard_id = hta.application_period_id
1452: AND htt.timecard_id IS NOT NULL
1453: AND htt.user_id = p_user_id;

Line 1510: UPDATE hxc_temp_tcd

1506: LIMIT 500;
1507: EXIT WHEN l_timecard_notif_ids.COUNT = 0;
1508:
1509: FORALL j IN l_timecard_notif_ids.FIRST..l_timecard_notif_ids.LAST
1510: UPDATE hxc_temp_tcd
1511: SET notification_id = l_notification_ids(j)
1512: WHERE user_id = p_user_id
1513: AND timecard_id = l_timecard_notif_ids(j);
1514:

Line 1591: hxc_temp_tcd

1587: timecard_id,
1588: timecard_ovn,
1589: meaning
1590: FROM
1591: hxc_temp_tcd
1592: WHERE timecard_exist = 'Y'
1593: AND user_id = p_user_id;
1594:
1595: IF g_debug THEN

Line 1632: hxc_temp_tcd

1628: assg_end_date,
1629: period_start_date,
1630: period_end_date
1631: FROM
1632: hxc_temp_tcd
1633: WHERE timecard_exist = 'N'
1634: AND user_id = p_user_id;
1635:
1636: cursor c_get_recurring_period_det(p_recurring_id number)

Line 2772: --DELETE FROM HXC_TEMP_TCD;

2768: END LOOP;
2769: IF g_debug THEN
2770: hr_utility.set_location(l_proc, 70);
2771: END IF;
2772: --DELETE FROM HXC_TEMP_TCD;
2773: FOR i IN l_person_det.FIRST..l_person_det.LAST
2774: LOOP
2775:
2776:

Line 2787: INSERT INTO HXC_TEMP_TCD

2783: l_flag := 'T';
2784: end if ;
2785:
2786:
2787: INSERT INTO HXC_TEMP_TCD
2788: (resource_id,
2789: start_time,
2790: stop_time,
2791: approval_status,

Line 2865: INSERT INTO HXC_TEMP_TCD

2861: AND (l_timecards_ne(i).first_end_time IS NOT NULL)
2862: --AND (l_timecards_ne(i).first_st_time < l_timecards_ne(i).first_end_time)
2863: --AND (l_timecards_ne(i).period_exist <> 'R')
2864: THEN
2865: INSERT INTO HXC_TEMP_TCD
2866: (resource_id,
2867: start_time,
2868: stop_time,
2869: approval_status,

Line 2909: INSERT INTO HXC_TEMP_TCD

2905: AND (l_timecards_ne(i).next_end_time IS NOT NULL)
2906: AND ( l_timecards_ne(i).next_st_time < l_timecards_ne(i).next_end_time)
2907: THEN
2908:
2909: INSERT INTO HXC_TEMP_TCD
2910: (resource_id,
2911: start_time,
2912: stop_time,
2913: approval_status,

Line 2952: INSERT INTO HXC_TEMP_TCD

2948: END LOOP;
2949:
2950: FOR i IN l_timecards_ne.FIRST..l_timecards_ne.LAST
2951: LOOP
2952: INSERT INTO HXC_TEMP_TCD
2953: (resource_id,
2954: start_time,
2955: stop_time,
2956: timecard_id,