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 311: p_blocks IN OUT NOCOPY hxc_block_table_type,

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

Line 739: p_blocks IN OUT NOCOPY hxc_block_table_type,

735: p_approval_prc IN wf_process_activities.process_name%TYPE,
736: p_template IN VARCHAR2,
737: p_mode IN VARCHAR2,
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

Line 1315: -- Returns: hxc_block_table_type

1311: -----------------------------------------------------------------------------
1312: -- Type: Function
1313: -- Scope: Public
1314: -- Name: convert_tbb_to_type
1315: -- Returns: hxc_block_table_type
1316: -- IN Parameters: p_blocks -> The PL/SQL Timecard structure you want to convert
1317: --
1318: -- Description: Private Function that will convert the old PL/SQL Timecard
1319: -- structure to the new TYPE that is then returned

Line 1328: RETURN hxc_block_table_type

1324: -----------------------------------------------------------------------------
1325: FUNCTION convert_tbb_to_type (
1326: p_blocks IN hxc_self_service_time_deposit.timecard_info
1327: )
1328: RETURN hxc_block_table_type
1329: IS
1330: l_proc VARCHAR2 (72);
1331: l_blocks hxc_block_table_type;
1332: l_index PLS_INTEGER;

Line 1331: l_blocks hxc_block_table_type;

1327: )
1328: RETURN hxc_block_table_type
1329: IS
1330: l_proc VARCHAR2 (72);
1331: l_blocks hxc_block_table_type;
1332: l_index PLS_INTEGER;
1333: BEGIN
1334: g_debug := hr_utility.debug_enabled;
1335:

Line 1343: l_blocks := hxc_block_table_type ();

1339: hr_utility.set_location ('Entering:' || l_proc, 10);
1340: END IF;
1341:
1342: -- Initialize the collection
1343: l_blocks := hxc_block_table_type ();
1344: l_index := p_blocks.FIRST;
1345:
1346: LOOP
1347: EXIT WHEN NOT p_blocks.EXISTS (l_index);

Line 2146: p_app_blocks IN hxc_block_table_type,

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

Line 2528: l_blocks hxc_block_table_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;
2529: BEGIN
2530: g_debug := hr_utility.debug_enabled;
2531:
2532: IF g_debug

Line 2639: p_bb_table IN hxc_block_table_type,

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

Line 2913: p_app_blocks OUT NOCOPY hxc_block_table_type,

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,
2914: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
2915: )
2916: IS
2917: l_proc VARCHAR2 (72);

Line 2994: l_blocks hxc_block_table_type;

2990: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
2991: )
2992: IS
2993: l_proc VARCHAR2 (72);
2994: l_blocks hxc_block_table_type;
2995: BEGIN
2996: g_debug := hr_utility.debug_enabled;
2997:
2998: IF g_debug

Line 3106: p_app_blocks IN OUT NOCOPY hxc_block_table_type

3102: -- Description: This procedure will allow you to clear the TBB PL/SQL Table
3103: --
3104: -----------------------------------------------------------------------------
3105: PROCEDURE clear_building_block_table (
3106: p_app_blocks IN OUT NOCOPY hxc_block_table_type
3107: )
3108: IS
3109: l_proc VARCHAR2 (72);
3110: BEGIN

Line 3211: p_app_blocks IN hxc_block_table_type,

3207: -- are about to create or update a TC.
3208: --
3209: -----------------------------------------------------------------------------
3210: PROCEDURE request_lock (
3211: p_app_blocks IN hxc_block_table_type,
3212: p_messages IN OUT NOCOPY hxc_message_table_type,
3213: p_locked_success OUT NOCOPY BOOLEAN,
3214: p_row_lock_id OUT NOCOPY ROWID
3215: )

Line 3282: p_app_blocks IN hxc_block_table_type,

3278: -- period that you grabbed with request_lock.
3279: --
3280: -----------------------------------------------------------------------------
3281: PROCEDURE release_lock (
3282: p_app_blocks IN hxc_block_table_type,
3283: p_messages IN OUT NOCOPY hxc_message_table_type,
3284: p_released_success OUT NOCOPY BOOLEAN,
3285: p_row_lock_id IN OUT NOCOPY ROWID
3286: )

Line 3361: p_app_blocks IN hxc_block_table_type,

3357: -- This procedure is provided for debugging purposes.
3358: --
3359: -----------------------------------------------------------------------------
3360: PROCEDURE log_timecard (
3361: p_app_blocks IN hxc_block_table_type,
3362: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
3363: )
3364: IS
3365: l_proc VARCHAR2 (72);

Line 3546: l_blocks hxc_block_table_type;

3542: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
3543: )
3544: IS
3545: l_proc VARCHAR2 (72);
3546: l_blocks hxc_block_table_type;
3547: BEGIN
3548: g_debug := hr_utility.debug_enabled;
3549:
3550: IF g_debug