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.HXT_OTC_RETRIEVAL_INTERFACE dependencies on HXT_SUM_HOURS_WORKED

Line 26: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,

22: || retrieved today or not (we cannot accept timecards if they were already send
23: || to payroll today as well because of current DT restrictions in OTLR)
24: */
25: FUNCTION is_retrievable (
26: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,
27: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,
28: p_person_id IN hxt_timecards_f.for_person_id%TYPE
29: )
30: RETURN BOOLEAN

Line 27: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,

23: || to payroll today as well because of current DT restrictions in OTLR)
24: */
25: FUNCTION is_retrievable (
26: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,
27: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,
28: p_person_id IN hxt_timecards_f.for_person_id%TYPE
29: )
30: RETURN BOOLEAN
31: AS

Line 40: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,

36: l_return_code NUMBER;
37: l_time_summary_id hxt_det_hours_worked_f.parent_id%TYPE;
38:
39: FUNCTION timecard_id (
40: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,
41: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,
42: p_person_id IN hxt_timecards_f.for_person_id%TYPE
43: )
44: RETURN hxt_timecards_f.ID%TYPE

Line 41: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,

37: l_time_summary_id hxt_det_hours_worked_f.parent_id%TYPE;
38:
39: FUNCTION timecard_id (
40: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,
41: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,
42: p_person_id IN hxt_timecards_f.for_person_id%TYPE
43: )
44: RETURN hxt_timecards_f.ID%TYPE
45: AS

Line 49: p_sum_id hxt_sum_hours_worked_f.ID%TYPE

45: AS
46: l_proc VARCHAR2 (72);
47:
48: CURSOR csr_timecard_id_from_sum (
49: p_sum_id hxt_sum_hours_worked_f.ID%TYPE
50: )
51: IS
52: SELECT tim_id
53: FROM hxt_sum_hours_worked_f

Line 53: FROM hxt_sum_hours_worked_f

49: p_sum_id hxt_sum_hours_worked_f.ID%TYPE
50: )
51: IS
52: SELECT tim_id
53: FROM hxt_sum_hours_worked_f
54: WHERE ID = p_sum_id;
55:
56: CURSOR csr_timecard_id (
57: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,

Line 57: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,

53: FROM hxt_sum_hours_worked_f
54: WHERE ID = p_sum_id;
55:
56: CURSOR csr_timecard_id (
57: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,
58: p_person_id hxt_timecards_f.for_person_id%TYPE
59: )
60: IS
61: SELECT HTF.ID

Line 296: FROM hxt_timecards_f HTF, hxt_sum_hours_worked hshw

292: SELECT hshw.ID, hshw.effective_start_date, hshw.effective_end_date,
293: hshw.tim_id
294: INTO p_time_summary_id, p_time_sum_start_date, p_time_sum_end_date,
295: p_tim_id
296: FROM hxt_timecards_f HTF, hxt_sum_hours_worked hshw
297: WHERE HTF.for_person_id = p_person_id
298: AND HTF.payroll_id = p_payroll_id
299: AND HTF.time_period_id = l_time_period_id
300: AND HTF.effective_end_date = hr_general.end_of_time

Line 1343: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE

1339: --
1340: l_errbuf VARCHAR2 (512) DEFAULT NULL;
1341: l_retcode NUMBER (9);
1342: --
1343: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE
1344: DEFAULT NULL;
1345: l_otm_error VARCHAR2 (2000) DEFAULT NULL;
1346: l_oracle_error VARCHAR2 (2000) DEFAULT NULL;
1347: --

Line 1382: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;

1378: l_sep_check_flag VARCHAR2 (30);
1379: l_old_sep_check_flag VARCHAR2 (30);
1380: l_hours NUMBER;
1381: l_old_hours NUMBER;
1382: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1383: l_old_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1384: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1385: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1386: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;

Line 1383: l_old_state_name hxt_sum_hours_worked_f.state_name%TYPE;

1379: l_old_sep_check_flag VARCHAR2 (30);
1380: l_hours NUMBER;
1381: l_old_hours NUMBER;
1382: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1383: l_old_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1384: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1385: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1386: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1387: l_old_city_name hxt_sum_hours_worked_f.city_name%TYPE;

Line 1384: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;

1380: l_hours NUMBER;
1381: l_old_hours NUMBER;
1382: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1383: l_old_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1384: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1385: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1386: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1387: l_old_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1388: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;

Line 1385: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;

1381: l_old_hours NUMBER;
1382: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1383: l_old_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1384: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1385: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1386: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1387: l_old_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1388: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1389: l_old_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;

Line 1386: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;

1382: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1383: l_old_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1384: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1385: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1386: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1387: l_old_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1388: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1389: l_old_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1390: --

Line 1387: l_old_city_name hxt_sum_hours_worked_f.city_name%TYPE;

1383: l_old_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1384: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1385: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1386: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1387: l_old_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1388: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1389: l_old_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1390: --
1391: l_tc_rowid ROWID;

Line 1388: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;

1384: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1385: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1386: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1387: l_old_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1388: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1389: l_old_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1390: --
1391: l_tc_rowid ROWID;
1392: --

Line 1389: l_old_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;

1385: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1386: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1387: l_old_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1388: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1389: l_old_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1390: --
1391: l_tc_rowid ROWID;
1392: --
1393: l_process_name VARCHAR2 (80);

Line 1531: FROM hxt_sum_hours_worked hshw, hxt_timecards ht

1527: --
1528: CURSOR get_timecard_id (p_tim_sum_id NUMBER)
1529: IS
1530: SELECT hshw.tim_id, ht.time_period_id
1531: FROM hxt_sum_hours_worked hshw, hxt_timecards ht
1532: WHERE hshw.ID = p_tim_sum_id AND hshw.tim_id = ht.ID;
1533:
1534: --
1535: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;

Line 1535: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;

1531: FROM hxt_sum_hours_worked hshw, hxt_timecards ht
1532: WHERE hshw.ID = p_tim_sum_id AND hshw.tim_id = ht.ID;
1533:
1534: --
1535: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;
1536: l_otm_error VARCHAR2 (2000) DEFAULT NULL;
1537: l_oracle_error VARCHAR2 (2000) DEFAULT NULL;
1538: l_time_period_id NUMBER;
1539: l_timecard_id NUMBER;

Line 3135: DELETE FROM hxt_sum_hours_worked_f

3131:
3132: --
3133: -- Delete the summary row itself.
3134: --
3135: DELETE FROM hxt_sum_hours_worked_f
3136: WHERE ID = l_time_summary_id;
3137: --
3138: END IF;
3139: