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_BLOCK_TABLE_TYPE

Line 12: p_blocks IN hxc_block_table_type

8: g_debug BOOLEAN := hr_utility.debug_enabled;
9:
10: FUNCTION perform_audit (
11: p_props IN hxc_timecard_prop_table_type,
12: p_blocks IN hxc_block_table_type
13: )
14: RETURN BOOLEAN
15: AS
16: l_cla_terg_id NUMBER := NULL;

Line 178: p_blocks IN hxc_block_table_type

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);
182: l_resubmit VARCHAR2 (10) := hxc_timecard.c_no;

Line 280: p_blocks IN OUT NOCOPY hxc_block_table_type,

276: -- DB with a status of WORKING. This whole procedure is mimicking
277: -- the Save as it happens in the deposit wrapper HXC_TIMECARD.
278: -----------------------------------------------------------------------------
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

Line 471: p_blocks IN OUT NOCOPY hxc_block_table_type,

467: p_approval_prc IN wf_process_activities.process_name%TYPE,
468: p_template IN VARCHAR2,
469: p_mode IN VARCHAR2,
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

Line 803: -- Returns: hxc_block_table_type

799: -----------------------------------------------------------------------------
800: -- Type: Function
801: -- Scope: Public
802: -- Name: convert_tbb_to_type
803: -- Returns: hxc_block_table_type
804: -- IN Parameters: p_blocks -> The PL/SQL Timecard structure you want to convert
805: --
806: -- Description: Private Function that will convert the old PL/SQL Timecard
807: -- structure to the new TYPE that is then returned

Line 816: RETURN hxc_block_table_type

812: -----------------------------------------------------------------------------
813: FUNCTION convert_tbb_to_type (
814: p_blocks IN hxc_self_service_time_deposit.timecard_info
815: )
816: RETURN hxc_block_table_type
817: IS
818: l_proc VARCHAR2 (72);
819: l_blocks hxc_block_table_type;
820: l_index PLS_INTEGER;

Line 819: l_blocks hxc_block_table_type;

815: )
816: RETURN hxc_block_table_type
817: IS
818: l_proc VARCHAR2 (72);
819: l_blocks hxc_block_table_type;
820: l_index PLS_INTEGER;
821: BEGIN
822: g_debug := hr_utility.debug_enabled;
823:

Line 831: l_blocks := hxc_block_table_type ();

827: hr_utility.set_location ('Entering:' || l_proc, 10);
828: END IF;
829:
830: -- Initialize the collection
831: l_blocks := hxc_block_table_type ();
832: l_index := p_blocks.FIRST;
833:
834: LOOP
835: EXIT WHEN NOT p_blocks.EXISTS (l_index);

Line 1504: p_app_blocks IN hxc_block_table_type,

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: )
1508: IS

Line 1886: l_blocks hxc_block_table_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;
1887: BEGIN
1888: g_debug := hr_utility.debug_enabled;
1889:
1890: IF g_debug

Line 1997: p_bb_table IN hxc_block_table_type,

1993: -- in the PL/SQL Table, a negative index is being returned.
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

Line 2271: p_app_blocks OUT NOCOPY hxc_block_table_type,

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,
2272: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
2273: )
2274: IS
2275: l_proc VARCHAR2 (72);

Line 2352: l_blocks hxc_block_table_type;

2348: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
2349: )
2350: IS
2351: l_proc VARCHAR2 (72);
2352: l_blocks hxc_block_table_type;
2353: BEGIN
2354: g_debug := hr_utility.debug_enabled;
2355:
2356: IF g_debug

Line 2464: p_app_blocks IN OUT NOCOPY hxc_block_table_type

2460: -- Description: This procedure will allow you to clear the TBB PL/SQL Table
2461: --
2462: -----------------------------------------------------------------------------
2463: PROCEDURE clear_building_block_table (
2464: p_app_blocks IN OUT NOCOPY hxc_block_table_type
2465: )
2466: IS
2467: l_proc VARCHAR2 (72);
2468: BEGIN

Line 2569: p_app_blocks IN hxc_block_table_type,

2565: -- are about to create or update a TC.
2566: --
2567: -----------------------------------------------------------------------------
2568: PROCEDURE request_lock (
2569: p_app_blocks IN hxc_block_table_type,
2570: p_messages IN OUT NOCOPY hxc_message_table_type,
2571: p_locked_success OUT NOCOPY BOOLEAN,
2572: p_row_lock_id OUT NOCOPY ROWID
2573: )

Line 2640: p_app_blocks IN hxc_block_table_type,

2636: -- period that you grabbed with request_lock.
2637: --
2638: -----------------------------------------------------------------------------
2639: PROCEDURE release_lock (
2640: p_app_blocks IN hxc_block_table_type,
2641: p_messages IN OUT NOCOPY hxc_message_table_type,
2642: p_released_success OUT NOCOPY BOOLEAN,
2643: p_row_lock_id IN OUT NOCOPY ROWID
2644: )

Line 2719: p_app_blocks IN hxc_block_table_type,

2715: -- This procedure is provided for debugging purposes.
2716: --
2717: -----------------------------------------------------------------------------
2718: PROCEDURE log_timecard (
2719: p_app_blocks IN hxc_block_table_type,
2720: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
2721: )
2722: IS
2723: l_proc VARCHAR2 (72);

Line 2904: l_blocks hxc_block_table_type;

2900: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
2901: )
2902: IS
2903: l_proc VARCHAR2 (72);
2904: l_blocks hxc_block_table_type;
2905: BEGIN
2906: g_debug := hr_utility.debug_enabled;
2907:
2908: IF g_debug