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 314: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

310: PROCEDURE save_timecard (
311: p_blocks IN OUT NOCOPY hxc_block_table_type,
312: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
313: p_messages IN OUT NOCOPY hxc_message_table_type,
314: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
315: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
316: )
317: IS
318: l_timecard_blocks hxc_timecard.block_list;

Line 315: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

311: p_blocks IN OUT NOCOPY hxc_block_table_type,
312: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
313: p_messages IN OUT NOCOPY hxc_message_table_type,
314: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
315: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
316: )
317: IS
318: l_timecard_blocks hxc_timecard.block_list;
319: l_day_blocks hxc_timecard.block_list;

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

738: p_retrieval_process IN hxc_retrieval_processes.NAME%TYPE,
739: p_blocks IN OUT NOCOPY hxc_block_table_type,
740: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
741: p_messages IN OUT NOCOPY hxc_message_table_type,
742: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
743: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
744: )
745: IS
746: l_timecard_blocks hxc_timecard.block_list;

Line 743: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

739: p_blocks IN OUT NOCOPY hxc_block_table_type,
740: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
741: p_messages IN OUT NOCOPY hxc_message_table_type,
742: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
743: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
744: )
745: IS
746: l_timecard_blocks hxc_timecard.block_list;
747: l_day_blocks hxc_timecard.block_list;

Line 2142: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

2138: -- Exceptions: No Timecard found
2139: -- Wrong Timecard in PL/SQL Table
2140: -----------------------------------------------------------------------------
2141: PROCEDURE find_parent_building_block (
2142: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2143: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2144: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
2145: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2146: p_app_blocks IN hxc_block_table_type,

Line 2143: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

2139: -- Wrong Timecard in PL/SQL Table
2140: -----------------------------------------------------------------------------
2141: PROCEDURE find_parent_building_block (
2142: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2143: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2144: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
2145: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2146: p_app_blocks IN hxc_block_table_type,
2147: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

Line 2144: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

2140: -----------------------------------------------------------------------------
2141: PROCEDURE find_parent_building_block (
2142: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2143: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2144: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
2145: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2146: p_app_blocks IN hxc_block_table_type,
2147: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2148: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

Line 2145: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,

2141: PROCEDURE find_parent_building_block (
2142: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2143: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2144: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
2145: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2146: p_app_blocks IN hxc_block_table_type,
2147: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2148: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
2149: )

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

2143: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2144: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
2145: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2146: p_app_blocks IN hxc_block_table_type,
2147: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2148: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
2149: )
2150: IS
2151: l_proc VARCHAR2 (72);

Line 2148: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

2144: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
2145: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2146: p_app_blocks IN hxc_block_table_type,
2147: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2148: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
2149: )
2150: IS
2151: l_proc VARCHAR2 (72);
2152:

Line 2155: v_start_time hxc_time_building_blocks.start_time%TYPE,

2151: l_proc VARCHAR2 (72);
2152:
2153: -- This cursor will return the BB_ID and OVN of the current TBB.
2154: CURSOR csr_get_timecard_id (
2155: v_start_time hxc_time_building_blocks.start_time%TYPE,
2156: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
2157: v_resource_type hxc_time_building_blocks.resource_type%TYPE,
2158: v_scope hxc_time_building_blocks.SCOPE%TYPE
2159: )

Line 2156: v_resource_id hxc_time_building_blocks.resource_id%TYPE,

2152:
2153: -- This cursor will return the BB_ID and OVN of the current TBB.
2154: CURSOR csr_get_timecard_id (
2155: v_start_time hxc_time_building_blocks.start_time%TYPE,
2156: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
2157: v_resource_type hxc_time_building_blocks.resource_type%TYPE,
2158: v_scope hxc_time_building_blocks.SCOPE%TYPE
2159: )
2160: IS

Line 2157: v_resource_type hxc_time_building_blocks.resource_type%TYPE,

2153: -- This cursor will return the BB_ID and OVN of the current TBB.
2154: CURSOR csr_get_timecard_id (
2155: v_start_time hxc_time_building_blocks.start_time%TYPE,
2156: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
2157: v_resource_type hxc_time_building_blocks.resource_type%TYPE,
2158: v_scope hxc_time_building_blocks.SCOPE%TYPE
2159: )
2160: IS
2161: SELECT tbb.time_building_block_id,

Line 2158: v_scope hxc_time_building_blocks.SCOPE%TYPE

2154: CURSOR csr_get_timecard_id (
2155: v_start_time hxc_time_building_blocks.start_time%TYPE,
2156: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
2157: v_resource_type hxc_time_building_blocks.resource_type%TYPE,
2158: v_scope hxc_time_building_blocks.SCOPE%TYPE
2159: )
2160: IS
2161: SELECT tbb.time_building_block_id,
2162: MAX (tbb.object_version_number)

Line 2163: FROM hxc_time_building_blocks tbb, hxc_time_building_blocks parent_tbb

2159: )
2160: IS
2161: SELECT tbb.time_building_block_id,
2162: MAX (tbb.object_version_number)
2163: FROM hxc_time_building_blocks tbb, hxc_time_building_blocks parent_tbb
2164: WHERE tbb.SCOPE = v_scope
2165: AND tbb.resource_type = v_resource_type
2166: AND tbb.resource_id = v_resource_id
2167: AND v_start_time BETWEEN tbb.start_time AND tbb.stop_time

Line 2518: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

2514: -- Exceptions: No Timecard found
2515: -- Wrong Timecard in PL/SQL Table
2516: -----------------------------------------------------------------------------
2517: PROCEDURE find_parent_building_block (
2518: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2519: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2520: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
2521: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2522: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,

Line 2519: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

2515: -- Wrong Timecard in PL/SQL Table
2516: -----------------------------------------------------------------------------
2517: PROCEDURE find_parent_building_block (
2518: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2519: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2520: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
2521: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2522: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
2523: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

Line 2520: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

2516: -----------------------------------------------------------------------------
2517: PROCEDURE find_parent_building_block (
2518: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2519: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2520: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
2521: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2522: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
2523: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2524: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

Line 2521: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,

2517: PROCEDURE find_parent_building_block (
2518: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2519: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2520: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
2521: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2522: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
2523: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2524: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
2525: )

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

2519: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2520: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
2521: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2522: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
2523: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2524: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
2525: )
2526: IS
2527: l_proc VARCHAR2 (72);

Line 2524: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

2520: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
2521: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2522: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
2523: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2524: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
2525: )
2526: IS
2527: l_proc VARCHAR2 (72);
2528: l_blocks hxc_block_table_type;

Line 2581: p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

2577: --
2578: -- Exceptions: No Timecard found
2579: -----------------------------------------------------------------------------
2580: PROCEDURE get_timecard_bb_id (
2581: p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2582: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2583: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
2584: )
2585: IS

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

2578: -- Exceptions: No Timecard found
2579: -----------------------------------------------------------------------------
2580: PROCEDURE get_timecard_bb_id (
2581: p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2582: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2583: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
2584: )
2585: IS
2586: l_proc VARCHAR2 (72);

Line 2583: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

2579: -----------------------------------------------------------------------------
2580: PROCEDURE get_timecard_bb_id (
2581: p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2582: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2583: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
2584: )
2585: IS
2586: l_proc VARCHAR2 (72);
2587:

Line 2590: v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE

2586: l_proc VARCHAR2 (72);
2587:
2588: -- This cursor will return the BB_ID and OVN of the current TIMECARD BB of a BB.
2589: CURSOR csr_get_timecard_bb_id (
2590: v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE
2591: )
2592: IS
2593: SELECT time_building_block_id, MAX (object_version_number)
2594: FROM hxc_time_building_blocks

Line 2594: FROM hxc_time_building_blocks

2590: v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE
2591: )
2592: IS
2593: SELECT time_building_block_id, MAX (object_version_number)
2594: FROM hxc_time_building_blocks
2595: WHERE SCOPE = hxc_timecard.c_timecard_scope
2596: AND date_to = hr_general.end_of_time
2597: CONNECT BY PRIOR parent_building_block_id = time_building_block_id
2598: AND PRIOR parent_building_block_ovn = object_version_number

Line 2640: p_bb_id_to_find IN hxc_time_building_blocks.time_building_block_id%TYPE

2636: --
2637: -----------------------------------------------------------------------------
2638: FUNCTION get_index_in_bb_table (
2639: p_bb_table IN hxc_block_table_type,
2640: p_bb_id_to_find IN hxc_time_building_blocks.time_building_block_id%TYPE
2641: )
2642: RETURN PLS_INTEGER
2643: IS
2644: l_proc VARCHAR2 (72);

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

2828: -- this saves the user from having to find the ID of the parent block themselves
2829: -- This only works because there is no overlap in BB start and stop times
2830: -- Should this ever change than this procedure will cease to work as it might return multiple BB rows.
2831: /* PROCEDURE find_parent_building_block (
2832: p_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2833: p_object_version_number OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2834: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2835: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2836: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

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

2829: -- This only works because there is no overlap in BB start and stop times
2830: -- Should this ever change than this procedure will cease to work as it might return multiple BB rows.
2831: /* PROCEDURE find_parent_building_block (
2832: p_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2833: p_object_version_number OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2834: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2835: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2836: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
2837: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

Line 2834: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,

2830: -- Should this ever change than this procedure will cease to work as it might return multiple BB rows.
2831: /* PROCEDURE find_parent_building_block (
2832: p_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2833: p_object_version_number OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2834: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2835: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2836: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
2837: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2838: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

Line 2835: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

2831: /* PROCEDURE find_parent_building_block (
2832: p_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2833: p_object_version_number OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2834: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2835: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2836: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
2837: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2838: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
2839: DEFAULT 'PERSON'

Line 2836: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

2832: p_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2833: p_object_version_number OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2834: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2835: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2836: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
2837: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2838: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
2839: DEFAULT 'PERSON'
2840: )

Line 2837: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

2833: p_object_version_number OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2834: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2835: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2836: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
2837: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2838: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
2839: DEFAULT 'PERSON'
2840: )
2841: IS

Line 2838: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

2834: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
2835: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
2836: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
2837: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
2838: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
2839: DEFAULT 'PERSON'
2840: )
2841: IS
2842: l_proc VARCHAR2 (72)

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

2847: -- It should always return only one row!
2848: -- if it does not, there is overlap in the start and stop times which should not happen!
2849: CURSOR csr_get_parent (
2850:
2851: -- v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE,
2852: v_scope hxc_time_building_blocks.SCOPE%TYPE,
2853: v_start_time hxc_time_building_blocks.start_time%TYPE,
2854: v_stop_time hxc_time_building_blocks.stop_time%TYPE,
2855: v_resource_id hxc_time_building_blocks.resource_id%TYPE,

Line 2852: v_scope hxc_time_building_blocks.SCOPE%TYPE,

2848: -- if it does not, there is overlap in the start and stop times which should not happen!
2849: CURSOR csr_get_parent (
2850:
2851: -- v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE,
2852: v_scope hxc_time_building_blocks.SCOPE%TYPE,
2853: v_start_time hxc_time_building_blocks.start_time%TYPE,
2854: v_stop_time hxc_time_building_blocks.stop_time%TYPE,
2855: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
2856: v_resource_type hxc_time_building_blocks.resource_type%TYPE

Line 2853: v_start_time hxc_time_building_blocks.start_time%TYPE,

2849: CURSOR csr_get_parent (
2850:
2851: -- v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE,
2852: v_scope hxc_time_building_blocks.SCOPE%TYPE,
2853: v_start_time hxc_time_building_blocks.start_time%TYPE,
2854: v_stop_time hxc_time_building_blocks.stop_time%TYPE,
2855: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
2856: v_resource_type hxc_time_building_blocks.resource_type%TYPE
2857: )

Line 2854: v_stop_time hxc_time_building_blocks.stop_time%TYPE,

2850:
2851: -- v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE,
2852: v_scope hxc_time_building_blocks.SCOPE%TYPE,
2853: v_start_time hxc_time_building_blocks.start_time%TYPE,
2854: v_stop_time hxc_time_building_blocks.stop_time%TYPE,
2855: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
2856: v_resource_type hxc_time_building_blocks.resource_type%TYPE
2857: )
2858: IS

Line 2855: v_resource_id hxc_time_building_blocks.resource_id%TYPE,

2851: -- v_tc_id hxc_time_building_blocks.time_building_block_id%TYPE,
2852: v_scope hxc_time_building_blocks.SCOPE%TYPE,
2853: v_start_time hxc_time_building_blocks.start_time%TYPE,
2854: v_stop_time hxc_time_building_blocks.stop_time%TYPE,
2855: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
2856: v_resource_type hxc_time_building_blocks.resource_type%TYPE
2857: )
2858: IS
2859: SELECT time_building_block_id, MAX (object_version_number)

Line 2856: v_resource_type hxc_time_building_blocks.resource_type%TYPE

2852: v_scope hxc_time_building_blocks.SCOPE%TYPE,
2853: v_start_time hxc_time_building_blocks.start_time%TYPE,
2854: v_stop_time hxc_time_building_blocks.stop_time%TYPE,
2855: v_resource_id hxc_time_building_blocks.resource_id%TYPE,
2856: v_resource_type hxc_time_building_blocks.resource_type%TYPE
2857: )
2858: IS
2859: SELECT time_building_block_id, MAX (object_version_number)
2860: FROM hxc_time_building_blocks

Line 2860: FROM hxc_time_building_blocks

2856: v_resource_type hxc_time_building_blocks.resource_type%TYPE
2857: )
2858: IS
2859: SELECT time_building_block_id, MAX (object_version_number)
2860: FROM hxc_time_building_blocks
2861: WHERE SCOPE = DECODE (v_scope, 'DAY', 'TIMECARD', 'DETAIL', 'DAY')
2862: AND v_start_time >= start_time
2863: AND v_stop_time <= stop_time
2864: AND v_resource_id = resource_id

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

2905: -- found in the PL/SQL Table, a negative index is being returned.
2906: --
2907: -----------------------------------------------------------------------------
2908: PROCEDURE get_timecard_tables
2909: (p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2910: -- p_time_recipient_id IN NUMBER,
2911: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2912: p_clear_mapping_cache IN BOOLEAN default false,
2913: p_app_blocks OUT NOCOPY hxc_block_table_type,

Line 2918: l_timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;

2914: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
2915: )
2916: IS
2917: l_proc VARCHAR2 (72);
2918: l_timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
2919: l_object_version_number hxc_time_building_blocks.object_version_number%TYPE;
2920: l_counter PLS_INTEGER;
2921: l_attributes hxc_attribute_table_type;
2922: BEGIN

Line 2919: l_object_version_number hxc_time_building_blocks.object_version_number%TYPE;

2915: )
2916: IS
2917: l_proc VARCHAR2 (72);
2918: l_timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
2919: l_object_version_number hxc_time_building_blocks.object_version_number%TYPE;
2920: l_counter PLS_INTEGER;
2921: l_attributes hxc_attribute_table_type;
2922: BEGIN
2923: g_debug := hr_utility.debug_enabled;

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

2981: -- Description: Overloaded procedure, using old PL/SQL Table for TBBs. See
2982: -- main get_timecard_tables for more information
2983: -----------------------------------------------------------------------------
2984: PROCEDURE get_timecard_tables
2985: (p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2986: -- p_time_recipient_id IN NUMBER,
2987: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2988: p_clear_mapping_cache IN BOOLEAN default false,
2989: p_app_blocks OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 3819: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

3815: -- start before an assignment exists for the resouce.
3816: --
3817: -----------------------------------------------------------------------------
3818: PROCEDURE find_current_period (
3819: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
3820: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
3821: p_day IN hxc_time_building_blocks.start_time%TYPE,
3822: p_start_time OUT NOCOPY DATE,
3823: p_stop_time OUT NOCOPY DATE

Line 3820: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

3816: --
3817: -----------------------------------------------------------------------------
3818: PROCEDURE find_current_period (
3819: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
3820: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
3821: p_day IN hxc_time_building_blocks.start_time%TYPE,
3822: p_start_time OUT NOCOPY DATE,
3823: p_stop_time OUT NOCOPY DATE
3824: )

Line 3821: p_day IN hxc_time_building_blocks.start_time%TYPE,

3817: -----------------------------------------------------------------------------
3818: PROCEDURE find_current_period (
3819: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
3820: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
3821: p_day IN hxc_time_building_blocks.start_time%TYPE,
3822: p_start_time OUT NOCOPY DATE,
3823: p_stop_time OUT NOCOPY DATE
3824: )
3825: IS

Line 3878: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

3874: END LOOP find_period;
3875: END find_current_period;
3876:
3877: FUNCTION cla_enabled (
3878: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3879: )
3880: RETURN BOOLEAN
3881: AS
3882: l_cla_enabled BOOLEAN;

Line 3886: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

3882: l_cla_enabled BOOLEAN;
3883: l_cla_terg_id hxc_pref_hierarchies.attribute1%TYPE;
3884:
3885: FUNCTION resource_id (
3886: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3887: )
3888: RETURN hxc_time_building_blocks.resource_id%TYPE
3889: AS
3890: l_resource_id hxc_time_building_blocks.resource_id%TYPE;

Line 3888: RETURN hxc_time_building_blocks.resource_id%TYPE

3884:
3885: FUNCTION resource_id (
3886: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3887: )
3888: RETURN hxc_time_building_blocks.resource_id%TYPE
3889: AS
3890: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
3891: BEGIN
3892: SELECT MAX (htbb.resource_id)

Line 3890: l_resource_id hxc_time_building_blocks.resource_id%TYPE;

3886: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3887: )
3888: RETURN hxc_time_building_blocks.resource_id%TYPE
3889: AS
3890: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
3891: BEGIN
3892: SELECT MAX (htbb.resource_id)
3893: INTO l_resource_id
3894: FROM hxc_time_building_blocks htbb

Line 3894: FROM hxc_time_building_blocks htbb

3890: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
3891: BEGIN
3892: SELECT MAX (htbb.resource_id)
3893: INTO l_resource_id
3894: FROM hxc_time_building_blocks htbb
3895: WHERE htbb.time_building_block_id = p_building_block_id
3896: AND resource_type = 'PERSON';
3897:
3898: RETURN l_resource_id;

Line 3947: PROCEDURE get_past_future_limits (p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

3943: -- dates till which a timecard can be created/updated through API
3944: --
3945: -- Procedure added for bug 8900783
3946: -----------------------------------------------------------------------------
3947: PROCEDURE get_past_future_limits (p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
3948: p_timecard_start_time IN date,
3949: p_timecard_stop_time IN date,
3950: p_messages IN OUT NOCOPY hxc_message_table_type)
3951: IS