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_SELF_SERVICE_TIMECARD dependencies on HXC_BLOCK_TABLE_TYPE

Line 113: p_timecard_blocks IN HXC_BLOCK_TABLE_TYPE

109: --Removing the redudant attribute set from the last timecard when it is applied over a timecard, with zero
110: --Hrs Tempalte preference set.
111:
112: PROCEDURE remove_redundant_attributesets(
113: p_timecard_blocks IN HXC_BLOCK_TABLE_TYPE
114: ,p_timecard_attributes IN HXC_ATTRIBUTE_TABLE_TYPE
115: ,p_zero_template_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
116: ,p_zero_template_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
117: )

Line 115: ,p_zero_template_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

111:
112: PROCEDURE remove_redundant_attributesets(
113: p_timecard_blocks IN HXC_BLOCK_TABLE_TYPE
114: ,p_timecard_attributes IN HXC_ATTRIBUTE_TABLE_TYPE
115: ,p_zero_template_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
116: ,p_zero_template_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
117: )
118: IS
119:

Line 591: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,

587:
588: PROCEDURE modify_to_zero_hrs_template (
589: p_start_time IN VARCHAR2,
590: p_stop_time IN VARCHAR2,
591: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,
592: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE,
593: p_clear_comment IN VARCHAR2
594: )
595: IS

Line 1538: ,p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

1534: -- (NOTE: block ids cannot be -1!!! because of deposit logics)
1535: -----------------------------------------------------------------------------
1536: PROCEDURE assign_block_ids(
1537: p_start_id IN NUMBER
1538: ,p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
1539: ,p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
1540: )
1541: IS
1542: l_timecard_block_id hxc_time_building_blocks.time_building_block_id%TYPE := p_start_id;

Line 1694: ,p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

1690: PROCEDURE update_blocks(
1691: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1692: ,p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
1693: ,p_approval_style IN hxc_time_building_blocks.approval_style_id%TYPE
1694: ,p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
1695: ,p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1696: ,p_timecard_found OUT NOCOPY BOOLEAN
1697: )
1698: IS

Line 1751: p_blocks IN HXC_BLOCK_TABLE_TYPE

1747:
1748: -- given a block (day, timecard), find the record index
1749: -- need p_found flag because block index could be any number
1750: PROCEDURE find_block(
1751: p_blocks IN HXC_BLOCK_TABLE_TYPE
1752: ,p_new_block IN HXC_BLOCK_TYPE
1753: ,p_index OUT NOCOPY NUMBER
1754: ,p_found OUT NOCOPY BOOLEAN
1755: )

Line 1809: p_blocks IN HXC_BLOCK_TABLE_TYPE

1805: --------------------------------------------------------------------------------
1806: -- find next available dummy block id for additional detail blocks
1807: --------------------------------------------------------------------------------
1808: FUNCTION get_next_block_id(
1809: p_blocks IN HXC_BLOCK_TABLE_TYPE
1810: )
1811: RETURN hxc_time_building_blocks.time_building_block_id%TYPE
1812: IS
1813: l_min_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 1913: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

1909:
1910:
1911: PROCEDURE translate_alias(
1912: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
1913: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
1914: ,p_resource_id IN VARCHAR2
1915: ,p_start_time IN VARCHAR2
1916: ,p_stop_time IN VARCHAR2
1917: )

Line 1959: p_block_array IN OUT NOCOPY hxc_block_table_type

1955: p_resource_type IN VARCHAR2,
1956: p_start_time IN VARCHAR2,
1957: p_stop_time IN VARCHAR2,
1958: p_template_code IN VARCHAR2,
1959: p_block_array IN OUT NOCOPY hxc_block_table_type
1960: )
1961: IS
1962: -- Variables....
1963: l_day_exists BOOLEAN;

Line 1969: l_blocks hxc_block_table_type;

1965: l_cached BOOLEAN := FALSE ;
1966: l_cache_index BINARY_INTEGER;
1967: l_index_day BINARY_INTEGER;
1968: l_last_index BINARY_INTEGER;
1969: l_blocks hxc_block_table_type;
1970: l_next_block_id NUMBER;
1971: l_num_days NUMBER;
1972: l_new_start_time DATE;
1973: l_new_stop_time DATE;

Line 2019: l_blocks := hxc_block_table_type ();

2015: THEN
2016: IF NOT l_day_exists
2017: THEN
2018: -- cache day info that can be used for later updates as well...
2019: l_blocks := hxc_block_table_type ();
2020: l_cache_index := NULL;
2021: l_cache_index := p_block_array.FIRST;
2022: l_day_found := FALSE ;
2023:

Line 2119: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

2115: END chk_all_days_in_block;
2116:
2117:
2118: PROCEDURE append_blocks(
2119: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
2120: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
2121: ,p_new_blocks IN HXC_BLOCK_TABLE_TYPE
2122: ,p_new_attributes IN HXC_ATTRIBUTE_TABLE_TYPE
2123: ,p_overwrite IN VARCHAR2

Line 2121: ,p_new_blocks IN HXC_BLOCK_TABLE_TYPE

2117:
2118: PROCEDURE append_blocks(
2119: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
2120: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
2121: ,p_new_blocks IN HXC_BLOCK_TABLE_TYPE
2122: ,p_new_attributes IN HXC_ATTRIBUTE_TABLE_TYPE
2123: ,p_overwrite IN VARCHAR2
2124: ,p_start_time IN VARCHAR2
2125: ,p_stop_time IN VARCHAR2

Line 2132: l_complete_blocks HXC_BLOCK_TABLE_TYPE;

2128: ,p_template_code IN VARCHAR2
2129: ,p_remove_redundant_entries IN BOOLEAN
2130: )
2131: IS
2132: l_complete_blocks HXC_BLOCK_TABLE_TYPE;
2133: l_complete_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2134: l_new_blocks HXC_BLOCK_TABLE_TYPE;
2135: l_new_blocks_array HXC_BLOCK_TABLE_TYPE;
2136: l_new_attributes HXC_ATTRIBUTE_TABLE_TYPE;

Line 2134: l_new_blocks HXC_BLOCK_TABLE_TYPE;

2130: )
2131: IS
2132: l_complete_blocks HXC_BLOCK_TABLE_TYPE;
2133: l_complete_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2134: l_new_blocks HXC_BLOCK_TABLE_TYPE;
2135: l_new_blocks_array HXC_BLOCK_TABLE_TYPE;
2136: l_new_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2137: l_next_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
2138: l_complete_block_count NUMBER;

Line 2135: l_new_blocks_array HXC_BLOCK_TABLE_TYPE;

2131: IS
2132: l_complete_blocks HXC_BLOCK_TABLE_TYPE;
2133: l_complete_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2134: l_new_blocks HXC_BLOCK_TABLE_TYPE;
2135: l_new_blocks_array HXC_BLOCK_TABLE_TYPE;
2136: l_new_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2137: l_next_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
2138: l_complete_block_count NUMBER;
2139: l_complete_attribute_count NUMBER;

Line 2209: l_complete_blocks := HXC_BLOCK_TABLE_TYPE();

2205:
2206: RETURN;
2207: END IF;
2208:
2209: l_complete_blocks := HXC_BLOCK_TABLE_TYPE();
2210: l_complete_blocks := p_block_array;
2211:
2212: l_next_block_id := get_next_block_id(p_blocks => l_complete_blocks);
2213:

Line 2631: RETURN HXC_BLOCK_TABLE_TYPE

2627: /*
2628: FUNCTION blocks_to_array(
2629: p_blocks IN hxc_self_service_time_deposit.timecard_info
2630: )
2631: RETURN HXC_BLOCK_TABLE_TYPE
2632: IS
2633: l_block_array HXC_BLOCK_TABLE_TYPE;
2634: l_array_index NUMBER := 0;
2635: l_block_index NUMBER;

Line 2633: l_block_array HXC_BLOCK_TABLE_TYPE;

2629: p_blocks IN hxc_self_service_time_deposit.timecard_info
2630: )
2631: RETURN HXC_BLOCK_TABLE_TYPE
2632: IS
2633: l_block_array HXC_BLOCK_TABLE_TYPE;
2634: l_array_index NUMBER := 0;
2635: l_block_index NUMBER;
2636: l_proc VARCHAR2(50);
2637: l_block HXC_BLOCK_TYPE;

Line 2647: l_block_array := HXC_BLOCK_TABLE_TYPE();

2643: l_proc := 'blocks_to_array';
2644: hr_utility.set_location ( g_package||l_proc, 10);
2645: END IF;
2646:
2647: l_block_array := HXC_BLOCK_TABLE_TYPE();
2648:
2649: l_block_index := p_blocks.first;
2650: LOOP
2651: EXIT WHEN NOT p_blocks.exists(l_block_index);

Line 2691: (p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,

2687: END blocks_to_array;
2688: */
2689:
2690: PROCEDURE remove_blocks
2691: (p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,
2692: p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE,
2693: p_block_index IN NUMBER
2694: ) is
2695: l_index NUMBER;

Line 2781: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

2777: ,p_stop_time IN VARCHAR2
2778: ,p_template_code IN VARCHAR2
2779: ,p_approval_status IN VARCHAR2
2780: ,p_approval_style IN VARCHAR2
2781: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
2782: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
2783: ,p_message_string OUT NOCOPY VARCHAR2
2784: ,p_overwrite IN VARCHAR2 DEFAULT 'Y'
2785: ,p_exclude_hours_template in VARCHAR2 DEFAULT 'N'

Line 2793: l_blocks HXC_BLOCK_TABLE_TYPE;

2789: l_template_type VARCHAR2(50) := '';
2790: l_template_handle VARCHAR2(500) := '';
2791: l_template_action VARCHAR2(20) :='';
2792: l_temp_blocks hxc_self_service_time_deposit.timecard_info;
2793: l_blocks HXC_BLOCK_TABLE_TYPE;
2794: l_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2795: l_temp_attributes hxc_self_service_time_deposit.building_block_attribute_info;
2796: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
2797: l_block_string VARCHAR2(32767) := '';

Line 3564: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

3560: PROCEDURE translate_alias_timecards(
3561: p_resource_id IN VARCHAR2
3562: ,p_start_time IN VARCHAR2
3563: ,p_stop_time IN VARCHAR2
3564: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
3565: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
3566: )
3567: IS
3568: l_resource_id VARCHAR2(50) := NULL;

Line 3615: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

3611: p_resource_id IN VARCHAR2
3612: ,p_resource_type IN VARCHAR2
3613: ,p_start_time IN VARCHAR2
3614: ,p_stop_time IN VARCHAR2
3615: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
3616: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
3617: ,p_message_string OUT NOCOPY VARCHAR2
3618: ,p_review IN VARCHAR2
3619: )

Line 4019: p_blocks in out nocopy hxc_block_table_type,

4015: Procedure get_app_period_blocks_by_id
4016: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,
4017: p_start_time in date,
4018: p_stop_time in date,
4019: p_blocks in out nocopy hxc_block_table_type,
4020: p_attributes in out nocopy hxc_attribute_table_type
4021: ) IS
4022:
4023: Begin

Line 4051: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

4047: PROCEDURE get_app_period_blocks_by_id(
4048: p_resource_id IN VARCHAR2
4049: ,p_resource_type IN VARCHAR2
4050: ,p_app_period_id IN VARCHAR2
4051: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4052: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4053: ,p_message_string OUT NOCOPY VARCHAR2
4054: ,p_review IN VARCHAR2
4055: ,p_return_timecard IN VARCHAR2 DEFAULT 'Y'

Line 4564: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

4560: ,p_timecard_id IN VARCHAR2
4561: ,p_template_code IN VARCHAR2
4562: ,p_approval_status IN VARCHAR2
4563: ,p_create_template IN VARCHAR2
4564: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4565: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4566: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4567: ,p_message_string OUT NOCOPY VARCHAR2
4568: ,p_overwrite IN VARCHAR2

Line 4609: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

4605: ,p_timecard_id IN VARCHAR2
4606: ,p_template_code IN VARCHAR2
4607: ,p_approval_status IN VARCHAR2
4608: ,p_create_template IN VARCHAR2
4609: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4610: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4611: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4612: ,p_message_string OUT NOCOPY VARCHAR2
4613: ,p_overwrite IN VARCHAR2

Line 4655: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

4651: ,p_timecard_id IN VARCHAR2
4652: ,p_template_code IN VARCHAR2
4653: ,p_approval_status IN VARCHAR2
4654: ,p_create_template IN VARCHAR2
4655: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4656: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4657: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4658: ,p_message_string OUT NOCOPY VARCHAR2
4659: ,p_overwrite IN VARCHAR2

Line 4927: p_block_array := hxc_block_table_type();

4923:
4924: p_message_string := NULL;
4925: RETURN;
4926: ELSE
4927: p_block_array := hxc_block_table_type();
4928: p_attribute_array := hxc_attribute_table_type();
4929: END IF;
4930:
4931:

Line 5052: p_final_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

5048: END fetch_blocks_and_attributes;
5049:
5050:
5051: PROCEDURE add_block_attributes(
5052: p_final_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
5053: ,p_final_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
5054: ,p_new_block_array IN HXC_BLOCK_TABLE_TYPE
5055: ,p_new_attribute_array IN HXC_ATTRIBUTE_TABLE_TYPE
5056: ,p_start_att_id IN NUMBER

Line 5054: ,p_new_block_array IN HXC_BLOCK_TABLE_TYPE

5050:
5051: PROCEDURE add_block_attributes(
5052: p_final_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
5053: ,p_final_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
5054: ,p_new_block_array IN HXC_BLOCK_TABLE_TYPE
5055: ,p_new_attribute_array IN HXC_ATTRIBUTE_TABLE_TYPE
5056: ,p_start_att_id IN NUMBER
5057: )
5058: IS

Line 5098: ,p_block_array OUT NOCOPY HXC_BLOCK_TABLE_TYPE

5094: PROCEDURE fetch_appl_periods(
5095: p_resource_id IN VARCHAR2
5096: ,p_resource_type IN VARCHAR2
5097: ,p_timecard_id IN VARCHAR2
5098: ,p_block_array OUT NOCOPY HXC_BLOCK_TABLE_TYPE
5099: ,p_attribute_array OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
5100: ,p_message_string OUT NOCOPY VARCHAR2
5101: )
5102: IS

Line 5118: l_block_array HXC_BLOCK_TABLE_TYPE;

5114:
5115: l_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
5116: l_start_time hxc_timecard_summary.start_time%type;
5117: l_stop_time hxc_timecard_summary.stop_time%type;
5118: l_block_array HXC_BLOCK_TABLE_TYPE;
5119: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;
5120: l_message_string VARCHAR(2000) := NULL;
5121: l_count NUMBER;
5122: l_start_block_id NUMBER;

Line 5125: p_block_array := HXC_BLOCK_TABLE_TYPE();

5121: l_count NUMBER;
5122: l_start_block_id NUMBER;
5123: l_start_att_id NUMBER;
5124: BEGIN
5125: p_block_array := HXC_BLOCK_TABLE_TYPE();
5126: p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
5127:
5128: l_block_array := HXC_BLOCK_TABLE_TYPE();
5129: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();

Line 5128: l_block_array := HXC_BLOCK_TABLE_TYPE();

5124: BEGIN
5125: p_block_array := HXC_BLOCK_TABLE_TYPE();
5126: p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
5127:
5128: l_block_array := HXC_BLOCK_TABLE_TYPE();
5129: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
5130:
5131: l_count := 0;
5132: l_start_block_id := -2;

Line 5190: l_blocks HXC_BLOCK_TABLE_TYPE;

5186:
5187: l_template_handle VARCHAR2(500) := '';
5188: l_template_action VARCHAR2(20) :='';
5189: l_temp_blocks hxc_self_service_time_deposit.timecard_info;
5190: l_blocks HXC_BLOCK_TABLE_TYPE;
5191: l_attributes HXC_ATTRIBUTE_TABLE_TYPE;
5192: l_temp_attributes hxc_self_service_time_deposit.building_block_attribute_info;
5193: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
5194: l_block_string VARCHAR2(32767) := '';