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_TIMESTORE_DEPOSIT_UTIL dependencies on HXC_TIME_BUILDING_BLOCKS

Line 177: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

173: -- process.
174: --
175: -----------------------------------------------------------------------------
176: PROCEDURE begin_approval (
177: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
178: p_blocks IN hxc_block_table_type
179: )
180: IS
181: l_proc VARCHAR2 (72);

Line 283: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

279: PROCEDURE save_timecard (
280: p_blocks IN OUT NOCOPY hxc_block_table_type,
281: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
282: p_messages IN OUT NOCOPY hxc_message_table_type,
283: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
284: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
285: )
286: IS
287: l_timecard_blocks hxc_timecard.block_list;

Line 284: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

280: p_blocks IN OUT NOCOPY hxc_block_table_type,
281: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
282: p_messages IN OUT NOCOPY hxc_message_table_type,
283: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
284: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
285: )
286: IS
287: l_timecard_blocks hxc_timecard.block_list;
288: l_day_blocks hxc_timecard.block_list;

Line 474: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

470: p_retrieval_process IN hxc_retrieval_processes.NAME%TYPE,
471: p_blocks IN OUT NOCOPY hxc_block_table_type,
472: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
473: p_messages IN OUT NOCOPY hxc_message_table_type,
474: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
475: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
476: )
477: IS
478: l_timecard_blocks hxc_timecard.block_list;

Line 475: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

471: p_blocks IN OUT NOCOPY hxc_block_table_type,
472: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
473: p_messages IN OUT NOCOPY hxc_message_table_type,
474: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
475: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
476: )
477: IS
478: l_timecard_blocks hxc_timecard.block_list;
479: l_day_blocks hxc_timecard.block_list;

Line 1500: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

1496: -- Exceptions: No Timecard found
1497: -- Wrong Timecard in PL/SQL Table
1498: -----------------------------------------------------------------------------
1499: PROCEDURE find_parent_building_block (
1500: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1501: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1502: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1503: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
1504: p_app_blocks IN hxc_block_table_type,

Line 1501: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

1497: -- Wrong Timecard in PL/SQL Table
1498: -----------------------------------------------------------------------------
1499: PROCEDURE find_parent_building_block (
1500: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1501: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1502: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1503: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
1504: p_app_blocks IN hxc_block_table_type,
1505: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

Line 1502: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

1498: -----------------------------------------------------------------------------
1499: PROCEDURE find_parent_building_block (
1500: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1501: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1502: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1503: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
1504: p_app_blocks IN hxc_block_table_type,
1505: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1506: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

Line 1503: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,

1499: PROCEDURE find_parent_building_block (
1500: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1501: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1502: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1503: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
1504: p_app_blocks IN hxc_block_table_type,
1505: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1506: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
1507: )

Line 1505: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

1501: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1502: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1503: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
1504: p_app_blocks IN hxc_block_table_type,
1505: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1506: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
1507: )
1508: IS
1509: l_proc VARCHAR2 (72);

Line 1506: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

1502: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1503: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
1504: p_app_blocks IN hxc_block_table_type,
1505: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1506: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
1507: )
1508: IS
1509: l_proc VARCHAR2 (72);
1510:

Line 1513: v_start_time hxc_time_building_blocks.start_time%TYPE,

1509: l_proc VARCHAR2 (72);
1510:
1511: -- This cursor will return the BB_ID and OVN of the current TBB.
1512: CURSOR csr_get_timecard_id (
1513: v_start_time hxc_time_building_blocks.start_time%TYPE,
1514: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
1515: v_resource_type hxc_time_building_blocks.resource_type%TYPE,
1516: v_scope hxc_time_building_blocks.SCOPE%TYPE
1517: )

Line 1514: v_resource_id hxc_time_building_blocks.resource_id%TYPE,

1510:
1511: -- This cursor will return the BB_ID and OVN of the current TBB.
1512: CURSOR csr_get_timecard_id (
1513: v_start_time hxc_time_building_blocks.start_time%TYPE,
1514: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
1515: v_resource_type hxc_time_building_blocks.resource_type%TYPE,
1516: v_scope hxc_time_building_blocks.SCOPE%TYPE
1517: )
1518: IS

Line 1515: v_resource_type hxc_time_building_blocks.resource_type%TYPE,

1511: -- This cursor will return the BB_ID and OVN of the current TBB.
1512: CURSOR csr_get_timecard_id (
1513: v_start_time hxc_time_building_blocks.start_time%TYPE,
1514: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
1515: v_resource_type hxc_time_building_blocks.resource_type%TYPE,
1516: v_scope hxc_time_building_blocks.SCOPE%TYPE
1517: )
1518: IS
1519: SELECT tbb.time_building_block_id,

Line 1516: v_scope hxc_time_building_blocks.SCOPE%TYPE

1512: CURSOR csr_get_timecard_id (
1513: v_start_time hxc_time_building_blocks.start_time%TYPE,
1514: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
1515: v_resource_type hxc_time_building_blocks.resource_type%TYPE,
1516: v_scope hxc_time_building_blocks.SCOPE%TYPE
1517: )
1518: IS
1519: SELECT tbb.time_building_block_id,
1520: MAX (tbb.object_version_number)

Line 1521: FROM hxc_time_building_blocks tbb, hxc_time_building_blocks parent_tbb

1517: )
1518: IS
1519: SELECT tbb.time_building_block_id,
1520: MAX (tbb.object_version_number)
1521: FROM hxc_time_building_blocks tbb, hxc_time_building_blocks parent_tbb
1522: WHERE tbb.SCOPE = v_scope
1523: AND tbb.resource_type = v_resource_type
1524: AND tbb.resource_id = v_resource_id
1525: AND v_start_time BETWEEN tbb.start_time AND tbb.stop_time

Line 1876: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

1872: -- Exceptions: No Timecard found
1873: -- Wrong Timecard in PL/SQL Table
1874: -----------------------------------------------------------------------------
1875: PROCEDURE find_parent_building_block (
1876: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1877: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1878: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1879: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
1880: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,

Line 1877: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

1873: -- Wrong Timecard in PL/SQL Table
1874: -----------------------------------------------------------------------------
1875: PROCEDURE find_parent_building_block (
1876: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1877: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1878: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1879: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
1880: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
1881: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

Line 1878: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

1874: -----------------------------------------------------------------------------
1875: PROCEDURE find_parent_building_block (
1876: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1877: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1878: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1879: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
1880: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
1881: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1882: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

Line 1879: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,

1875: PROCEDURE find_parent_building_block (
1876: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1877: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1878: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1879: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
1880: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
1881: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1882: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
1883: )

Line 1881: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

1877: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1878: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1879: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
1880: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
1881: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1882: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
1883: )
1884: IS
1885: l_proc VARCHAR2 (72);

Line 1882: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

1878: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1879: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
1880: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
1881: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1882: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
1883: )
1884: IS
1885: l_proc VARCHAR2 (72);
1886: l_blocks hxc_block_table_type;

Line 1939: p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

1935: --
1936: -- Exceptions: No Timecard found
1937: -----------------------------------------------------------------------------
1938: PROCEDURE get_timecard_bb_id (
1939: p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1940: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1941: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
1942: )
1943: IS

Line 1940: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

1936: -- Exceptions: No Timecard found
1937: -----------------------------------------------------------------------------
1938: PROCEDURE get_timecard_bb_id (
1939: p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1940: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1941: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
1942: )
1943: IS
1944: l_proc VARCHAR2 (72);

Line 1941: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

1937: -----------------------------------------------------------------------------
1938: PROCEDURE get_timecard_bb_id (
1939: p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1940: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1941: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
1942: )
1943: IS
1944: l_proc VARCHAR2 (72);
1945:

Line 1948: v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE

1944: l_proc VARCHAR2 (72);
1945:
1946: -- This cursor will return the BB_ID and OVN of the current TIMECARD BB of a BB.
1947: CURSOR csr_get_timecard_bb_id (
1948: v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE
1949: )
1950: IS
1951: SELECT time_building_block_id, MAX (object_version_number)
1952: FROM hxc_time_building_blocks

Line 1952: FROM hxc_time_building_blocks

1948: v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE
1949: )
1950: IS
1951: SELECT time_building_block_id, MAX (object_version_number)
1952: FROM hxc_time_building_blocks
1953: WHERE SCOPE = hxc_timecard.c_timecard_scope
1954: AND date_to = hr_general.end_of_time
1955: CONNECT BY PRIOR parent_building_block_id = time_building_block_id
1956: AND PRIOR parent_building_block_ovn = object_version_number

Line 1998: p_bb_id_to_find IN hxc_time_building_blocks.time_building_block_id%TYPE

1994: --
1995: -----------------------------------------------------------------------------
1996: FUNCTION get_index_in_bb_table (
1997: p_bb_table IN hxc_block_table_type,
1998: p_bb_id_to_find IN hxc_time_building_blocks.time_building_block_id%TYPE
1999: )
2000: RETURN PLS_INTEGER
2001: IS
2002: l_proc VARCHAR2 (72);

Line 2190: p_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

2186: -- this saves the user from having to find the ID of the parent block themselves
2187: -- This only works because there is no overlap in BB start and stop times
2188: -- Should this ever change than this procedure will cease to work as it might return multiple BB rows.
2189: /* PROCEDURE find_parent_building_block (
2190: p_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2191: p_object_version_number OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2192: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2193: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2194: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

Line 2191: p_object_version_number OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,

2187: -- This only works because there is no overlap in BB start and stop times
2188: -- Should this ever change than this procedure will cease to work as it might return multiple BB rows.
2189: /* PROCEDURE find_parent_building_block (
2190: p_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2191: p_object_version_number OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2192: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2193: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2194: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
2195: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

Line 2192: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,

2188: -- Should this ever change than this procedure will cease to work as it might return multiple BB rows.
2189: /* PROCEDURE find_parent_building_block (
2190: p_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2191: p_object_version_number OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2192: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2193: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2194: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
2195: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2196: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

Line 2193: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

2189: /* PROCEDURE find_parent_building_block (
2190: p_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2191: p_object_version_number OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2192: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2193: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2194: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
2195: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2196: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
2197: DEFAULT 'PERSON'

Line 2194: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

2190: p_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2191: p_object_version_number OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2192: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2193: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2194: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
2195: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2196: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
2197: DEFAULT 'PERSON'
2198: )

Line 2195: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

2191: p_object_version_number OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2192: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2193: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2194: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
2195: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2196: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
2197: DEFAULT 'PERSON'
2198: )
2199: IS

Line 2196: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

2192: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2193: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2194: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
2195: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2196: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
2197: DEFAULT 'PERSON'
2198: )
2199: IS
2200: l_proc VARCHAR2 (72)

Line 2209: -- v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE,

2205: -- It should always return only one row!
2206: -- if it does not, there is overlap in the start and stop times which should not happen!
2207: CURSOR csr_get_parent (
2208:
2209: -- v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE,
2210: v_scope hxc_time_building_blocks.SCOPE%TYPE,
2211: v_start_time hxc_time_building_blocks.start_time%TYPE,
2212: v_stop_time hxc_time_building_blocks.stop_time%TYPE,
2213: v_resource_id hxc_time_building_blocks.resource_id%TYPE,

Line 2210: v_scope hxc_time_building_blocks.SCOPE%TYPE,

2206: -- if it does not, there is overlap in the start and stop times which should not happen!
2207: CURSOR csr_get_parent (
2208:
2209: -- v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE,
2210: v_scope hxc_time_building_blocks.SCOPE%TYPE,
2211: v_start_time hxc_time_building_blocks.start_time%TYPE,
2212: v_stop_time hxc_time_building_blocks.stop_time%TYPE,
2213: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
2214: v_resource_type hxc_time_building_blocks.resource_type%TYPE

Line 2211: v_start_time hxc_time_building_blocks.start_time%TYPE,

2207: CURSOR csr_get_parent (
2208:
2209: -- v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE,
2210: v_scope hxc_time_building_blocks.SCOPE%TYPE,
2211: v_start_time hxc_time_building_blocks.start_time%TYPE,
2212: v_stop_time hxc_time_building_blocks.stop_time%TYPE,
2213: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
2214: v_resource_type hxc_time_building_blocks.resource_type%TYPE
2215: )

Line 2212: v_stop_time hxc_time_building_blocks.stop_time%TYPE,

2208:
2209: -- v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE,
2210: v_scope hxc_time_building_blocks.SCOPE%TYPE,
2211: v_start_time hxc_time_building_blocks.start_time%TYPE,
2212: v_stop_time hxc_time_building_blocks.stop_time%TYPE,
2213: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
2214: v_resource_type hxc_time_building_blocks.resource_type%TYPE
2215: )
2216: IS

Line 2213: v_resource_id hxc_time_building_blocks.resource_id%TYPE,

2209: -- v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE,
2210: v_scope hxc_time_building_blocks.SCOPE%TYPE,
2211: v_start_time hxc_time_building_blocks.start_time%TYPE,
2212: v_stop_time hxc_time_building_blocks.stop_time%TYPE,
2213: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
2214: v_resource_type hxc_time_building_blocks.resource_type%TYPE
2215: )
2216: IS
2217: SELECT time_building_block_id, MAX (object_version_number)

Line 2214: v_resource_type hxc_time_building_blocks.resource_type%TYPE

2210: v_scope hxc_time_building_blocks.SCOPE%TYPE,
2211: v_start_time hxc_time_building_blocks.start_time%TYPE,
2212: v_stop_time hxc_time_building_blocks.stop_time%TYPE,
2213: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
2214: v_resource_type hxc_time_building_blocks.resource_type%TYPE
2215: )
2216: IS
2217: SELECT time_building_block_id, MAX (object_version_number)
2218: FROM hxc_time_building_blocks

Line 2218: FROM hxc_time_building_blocks

2214: v_resource_type hxc_time_building_blocks.resource_type%TYPE
2215: )
2216: IS
2217: SELECT time_building_block_id, MAX (object_version_number)
2218: FROM hxc_time_building_blocks
2219: WHERE SCOPE = DECODE (v_scope, 'DAY', 'TIMECARD', 'DETAIL', 'DAY')
2220: AND v_start_time >= start_time
2221: AND v_stop_time <= stop_time
2222: AND v_resource_id = resource_id

Line 2267: (p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

2263: -- found in the PL/SQL Table, a negative index is being returned.
2264: --
2265: -----------------------------------------------------------------------------
2266: PROCEDURE get_timecard_tables
2267: (p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2268: -- p_time_recipient_id IN NUMBER,
2269: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2270: p_clear_mapping_cache IN BOOLEAN default false,
2271: p_app_blocks OUT NOCOPY hxc_block_table_type,

Line 2276: l_timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;

2272: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
2273: )
2274: IS
2275: l_proc VARCHAR2 (72);
2276: l_timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
2277: l_object_version_number hxc_time_building_blocks.object_version_number%TYPE;
2278: l_counter PLS_INTEGER;
2279: l_attributes hxc_attribute_table_type;
2280: BEGIN

Line 2277: l_object_version_number hxc_time_building_blocks.object_version_number%TYPE;

2273: )
2274: IS
2275: l_proc VARCHAR2 (72);
2276: l_timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
2277: l_object_version_number hxc_time_building_blocks.object_version_number%TYPE;
2278: l_counter PLS_INTEGER;
2279: l_attributes hxc_attribute_table_type;
2280: BEGIN
2281: g_debug := hr_utility.debug_enabled;

Line 2343: (p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

2339: -- Description: Overloaded procedure, using old PL/SQL Table for TBBs. See
2340: -- main get_timecard_tables for more information
2341: -----------------------------------------------------------------------------
2342: PROCEDURE get_timecard_tables
2343: (p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2344: -- p_time_recipient_id IN NUMBER,
2345: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2346: p_clear_mapping_cache IN BOOLEAN default false,
2347: p_app_blocks OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 3177: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

3173: -- start before an assignment exists for the resouce.
3174: --
3175: -----------------------------------------------------------------------------
3176: PROCEDURE find_current_period (
3177: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
3178: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
3179: p_day IN hxc_time_building_blocks.start_time%TYPE,
3180: p_start_time OUT NOCOPY DATE,
3181: p_stop_time OUT NOCOPY DATE

Line 3178: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

3174: --
3175: -----------------------------------------------------------------------------
3176: PROCEDURE find_current_period (
3177: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
3178: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
3179: p_day IN hxc_time_building_blocks.start_time%TYPE,
3180: p_start_time OUT NOCOPY DATE,
3181: p_stop_time OUT NOCOPY DATE
3182: )

Line 3179: p_day IN hxc_time_building_blocks.start_time%TYPE,

3175: -----------------------------------------------------------------------------
3176: PROCEDURE find_current_period (
3177: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
3178: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
3179: p_day IN hxc_time_building_blocks.start_time%TYPE,
3180: p_start_time OUT NOCOPY DATE,
3181: p_stop_time OUT NOCOPY DATE
3182: )
3183: IS

Line 3236: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

3232: END LOOP find_period;
3233: END find_current_period;
3234:
3235: FUNCTION cla_enabled (
3236: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3237: )
3238: RETURN BOOLEAN
3239: AS
3240: l_cla_enabled BOOLEAN;

Line 3244: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

3240: l_cla_enabled BOOLEAN;
3241: l_cla_terg_id hxc_pref_hierarchies.attribute1%TYPE;
3242:
3243: FUNCTION resource_id (
3244: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3245: )
3246: RETURN hxc_time_building_blocks.resource_id%TYPE
3247: AS
3248: l_resource_id hxc_time_building_blocks.resource_id%TYPE;

Line 3246: RETURN hxc_time_building_blocks.resource_id%TYPE

3242:
3243: FUNCTION resource_id (
3244: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3245: )
3246: RETURN hxc_time_building_blocks.resource_id%TYPE
3247: AS
3248: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
3249: BEGIN
3250: SELECT MAX (htbb.resource_id)

Line 3248: l_resource_id hxc_time_building_blocks.resource_id%TYPE;

3244: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3245: )
3246: RETURN hxc_time_building_blocks.resource_id%TYPE
3247: AS
3248: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
3249: BEGIN
3250: SELECT MAX (htbb.resource_id)
3251: INTO l_resource_id
3252: FROM hxc_time_building_blocks htbb

Line 3252: FROM hxc_time_building_blocks htbb

3248: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
3249: BEGIN
3250: SELECT MAX (htbb.resource_id)
3251: INTO l_resource_id
3252: FROM hxc_time_building_blocks htbb
3253: WHERE htbb.time_building_block_id = p_building_block_id
3254: AND resource_type = 'PERSON';
3255:
3256: RETURN l_resource_id;