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_F

Line 402: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,

398: */
399: -- Bug 12850901
400: -- Added variables to take in tc bb_id and ovn
401: FUNCTION is_retrievable (
402: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,
403: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,
404: p_person_id IN hxt_timecards_f.for_person_id%TYPE,
405: p_tc_bb_id IN NUMBER DEFAULT 0,
406: p_tc_ovn IN NUMBER DEFAULT 0

Line 403: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,

399: -- Bug 12850901
400: -- Added variables to take in tc bb_id and ovn
401: FUNCTION is_retrievable (
402: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,
403: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,
404: p_person_id IN hxt_timecards_f.for_person_id%TYPE,
405: p_tc_bb_id IN NUMBER DEFAULT 0,
406: p_tc_ovn IN NUMBER DEFAULT 0
407: )

Line 434: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,

430: WHERE time_building_block_id = p_id
431: AND object_version_number = p_ovn;
432:
433: FUNCTION timecard_id (
434: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,
435: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,
436: p_person_id IN hxt_timecards_f.for_person_id%TYPE
437: )
438: RETURN hxt_timecards_f.ID%TYPE

Line 435: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,

431: AND object_version_number = p_ovn;
432:
433: FUNCTION timecard_id (
434: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,
435: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,
436: p_person_id IN hxt_timecards_f.for_person_id%TYPE
437: )
438: RETURN hxt_timecards_f.ID%TYPE
439: AS

Line 443: p_sum_id hxt_sum_hours_worked_f.ID%TYPE

439: AS
440: l_proc VARCHAR2 (72);
441:
442: CURSOR csr_timecard_id_from_sum (
443: p_sum_id hxt_sum_hours_worked_f.ID%TYPE
444: )
445: IS
446: SELECT tim_id
447: FROM hxt_sum_hours_worked_f

Line 447: FROM hxt_sum_hours_worked_f

443: p_sum_id hxt_sum_hours_worked_f.ID%TYPE
444: )
445: IS
446: SELECT tim_id
447: FROM hxt_sum_hours_worked_f
448: WHERE ID = p_sum_id;
449:
450: CURSOR csr_timecard_id (
451: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,

Line 451: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,

447: FROM hxt_sum_hours_worked_f
448: WHERE ID = p_sum_id;
449:
450: CURSOR csr_timecard_id (
451: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,
452: p_person_id hxt_timecards_f.for_person_id%TYPE
453: )
454: IS
455: SELECT HTF.ID

Line 1972: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;

1968: l_sep_check_flag VARCHAR2 (30);
1969: l_old_sep_check_flag VARCHAR2 (30);
1970: l_hours NUMBER;
1971: l_old_hours NUMBER;
1972: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1973: l_old_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1974: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1975: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1976: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;

Line 1973: l_old_state_name hxt_sum_hours_worked_f.state_name%TYPE;

1969: l_old_sep_check_flag VARCHAR2 (30);
1970: l_hours NUMBER;
1971: l_old_hours NUMBER;
1972: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1973: l_old_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1974: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1975: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1976: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1977: l_old_city_name hxt_sum_hours_worked_f.city_name%TYPE;

Line 1974: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;

1970: l_hours NUMBER;
1971: l_old_hours NUMBER;
1972: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1973: l_old_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1974: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1975: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1976: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1977: l_old_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1978: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;

Line 1975: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;

1971: l_old_hours NUMBER;
1972: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1973: l_old_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1974: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1975: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1976: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1977: l_old_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1978: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1979: l_old_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;

Line 1976: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;

1972: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1973: l_old_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1974: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1975: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1976: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1977: l_old_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1978: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1979: l_old_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1980: --

Line 1977: l_old_city_name hxt_sum_hours_worked_f.city_name%TYPE;

1973: l_old_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1974: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1975: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1976: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1977: l_old_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1978: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1979: l_old_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1980: --
1981: l_tc_rowid ROWID;

Line 1978: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;

1974: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1975: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1976: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1977: l_old_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1978: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1979: l_old_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1980: --
1981: l_tc_rowid ROWID;
1982: --

Line 1979: l_old_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;

1975: l_old_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1976: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1977: l_old_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1978: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1979: l_old_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1980: --
1981: l_tc_rowid ROWID;
1982: --
1983: l_process_name VARCHAR2 (80);

Line 2321: UPDATE hxt_sum_hours_worked_f

2317: hr_utility.trace(' attribute14 :'||g_iv_table(TO_CHAR(p_time_building_block_id)).attribute14);
2318: hr_utility.trace(' attribute15 :'||g_iv_table(TO_CHAR(p_time_building_block_id)).attribute15);
2319: END IF;
2320:
2321: UPDATE hxt_sum_hours_worked_f
2322: SET attribute1 = g_iv_table(TO_CHAR(p_time_building_block_id)).attribute1,
2323: attribute2 = g_iv_table(TO_CHAR(p_time_building_block_id)).attribute2,
2324: attribute3 = g_iv_table(TO_CHAR(p_time_building_block_id)).attribute3,
2325: attribute4 = g_iv_table(TO_CHAR(p_time_building_block_id)).attribute4,

Line 3830: DELETE FROM hxt_sum_hours_worked_f

3826:
3827: --
3828: -- Delete the summary row itself.
3829: --
3830: DELETE FROM hxt_sum_hours_worked_f
3831: WHERE ID = l_time_summary_id;
3832: --
3833: END IF;
3834: