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 1836: ,p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

1832: -- (NOTE: block ids cannot be -1!!! because of deposit logics)
1833: -----------------------------------------------------------------------------
1834: PROCEDURE assign_block_ids(
1835: p_start_id IN NUMBER
1836: ,p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
1837: ,p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
1838: )
1839: IS
1840: l_timecard_block_id hxc_time_building_blocks.time_building_block_id%TYPE := p_start_id;

Line 1992: ,p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

1988: PROCEDURE update_blocks(
1989: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1990: ,p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
1991: ,p_approval_style IN hxc_time_building_blocks.approval_style_id%TYPE
1992: ,p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
1993: ,p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1994: ,p_timecard_found OUT NOCOPY BOOLEAN
1995: )
1996: IS

Line 2049: p_blocks IN HXC_BLOCK_TABLE_TYPE

2045:
2046: -- given a block (day, timecard), find the record index
2047: -- need p_found flag because block index could be any number
2048: PROCEDURE find_block(
2049: p_blocks IN HXC_BLOCK_TABLE_TYPE
2050: ,p_new_block IN HXC_BLOCK_TYPE
2051: ,p_index OUT NOCOPY NUMBER
2052: ,p_found OUT NOCOPY BOOLEAN
2053: )

Line 2107: p_blocks IN HXC_BLOCK_TABLE_TYPE

2103: --------------------------------------------------------------------------------
2104: -- find next available dummy block id for additional detail blocks
2105: --------------------------------------------------------------------------------
2106: FUNCTION get_next_block_id(
2107: p_blocks IN HXC_BLOCK_TABLE_TYPE
2108: )
2109: RETURN hxc_time_building_blocks.time_building_block_id%TYPE
2110: IS
2111: l_min_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 2211: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

2207:
2208:
2209: PROCEDURE translate_alias(
2210: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
2211: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
2212: ,p_resource_id IN VARCHAR2
2213: ,p_start_time IN VARCHAR2
2214: ,p_stop_time IN VARCHAR2
2215: )

Line 2257: p_block_array IN OUT NOCOPY hxc_block_table_type

2253: p_resource_type IN VARCHAR2,
2254: p_start_time IN VARCHAR2,
2255: p_stop_time IN VARCHAR2,
2256: p_template_code IN VARCHAR2,
2257: p_block_array IN OUT NOCOPY hxc_block_table_type
2258: )
2259: IS
2260: -- Variables....
2261: l_day_exists BOOLEAN;

Line 2267: l_blocks hxc_block_table_type;

2263: l_cached BOOLEAN := FALSE ;
2264: l_cache_index BINARY_INTEGER;
2265: l_index_day BINARY_INTEGER;
2266: l_last_index BINARY_INTEGER;
2267: l_blocks hxc_block_table_type;
2268: l_next_block_id NUMBER;
2269: l_num_days NUMBER;
2270: l_new_start_time DATE;
2271: l_new_stop_time DATE;

Line 2317: l_blocks := hxc_block_table_type ();

2313: THEN
2314: IF NOT l_day_exists
2315: THEN
2316: -- cache day info that can be used for later updates as well...
2317: l_blocks := hxc_block_table_type ();
2318: l_cache_index := NULL;
2319: l_cache_index := p_block_array.FIRST;
2320: l_day_found := FALSE ;
2321:

Line 2417: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

2413: END chk_all_days_in_block;
2414:
2415:
2416: PROCEDURE append_blocks(
2417: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
2418: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
2419: ,p_new_blocks IN HXC_BLOCK_TABLE_TYPE
2420: ,p_new_attributes IN HXC_ATTRIBUTE_TABLE_TYPE
2421: ,p_overwrite IN VARCHAR2

Line 2419: ,p_new_blocks IN HXC_BLOCK_TABLE_TYPE

2415:
2416: PROCEDURE append_blocks(
2417: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
2418: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
2419: ,p_new_blocks IN HXC_BLOCK_TABLE_TYPE
2420: ,p_new_attributes IN HXC_ATTRIBUTE_TABLE_TYPE
2421: ,p_overwrite IN VARCHAR2
2422: ,p_start_time IN VARCHAR2
2423: ,p_stop_time IN VARCHAR2

Line 2430: l_complete_blocks HXC_BLOCK_TABLE_TYPE;

2426: ,p_template_code IN VARCHAR2
2427: ,p_remove_redundant_entries IN BOOLEAN
2428: )
2429: IS
2430: l_complete_blocks HXC_BLOCK_TABLE_TYPE;
2431: l_complete_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2432: l_new_blocks HXC_BLOCK_TABLE_TYPE;
2433: l_new_blocks_array HXC_BLOCK_TABLE_TYPE;
2434: l_new_attributes HXC_ATTRIBUTE_TABLE_TYPE;

Line 2432: l_new_blocks HXC_BLOCK_TABLE_TYPE;

2428: )
2429: IS
2430: l_complete_blocks HXC_BLOCK_TABLE_TYPE;
2431: l_complete_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2432: l_new_blocks HXC_BLOCK_TABLE_TYPE;
2433: l_new_blocks_array HXC_BLOCK_TABLE_TYPE;
2434: l_new_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2435: l_next_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
2436: l_complete_block_count NUMBER;

Line 2433: l_new_blocks_array HXC_BLOCK_TABLE_TYPE;

2429: IS
2430: l_complete_blocks HXC_BLOCK_TABLE_TYPE;
2431: l_complete_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2432: l_new_blocks HXC_BLOCK_TABLE_TYPE;
2433: l_new_blocks_array HXC_BLOCK_TABLE_TYPE;
2434: l_new_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2435: l_next_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
2436: l_complete_block_count NUMBER;
2437: l_complete_attribute_count NUMBER;

Line 2507: l_complete_blocks := HXC_BLOCK_TABLE_TYPE();

2503:
2504: RETURN;
2505: END IF;
2506:
2507: l_complete_blocks := HXC_BLOCK_TABLE_TYPE();
2508: l_complete_blocks := p_block_array;
2509:
2510: l_next_block_id := get_next_block_id(p_blocks => l_complete_blocks);
2511:

Line 2931: RETURN HXC_BLOCK_TABLE_TYPE

2927: /*
2928: FUNCTION blocks_to_array(
2929: p_blocks IN hxc_self_service_time_deposit.timecard_info
2930: )
2931: RETURN HXC_BLOCK_TABLE_TYPE
2932: IS
2933: l_block_array HXC_BLOCK_TABLE_TYPE;
2934: l_array_index NUMBER := 0;
2935: l_block_index NUMBER;

Line 2933: l_block_array HXC_BLOCK_TABLE_TYPE;

2929: p_blocks IN hxc_self_service_time_deposit.timecard_info
2930: )
2931: RETURN HXC_BLOCK_TABLE_TYPE
2932: IS
2933: l_block_array HXC_BLOCK_TABLE_TYPE;
2934: l_array_index NUMBER := 0;
2935: l_block_index NUMBER;
2936: l_proc VARCHAR2(50);
2937: l_block HXC_BLOCK_TYPE;

Line 2947: l_block_array := HXC_BLOCK_TABLE_TYPE();

2943: l_proc := 'blocks_to_array';
2944: hr_utility.set_location ( g_package||l_proc, 10);
2945: END IF;
2946:
2947: l_block_array := HXC_BLOCK_TABLE_TYPE();
2948:
2949: l_block_index := p_blocks.first;
2950: LOOP
2951: EXIT WHEN NOT p_blocks.exists(l_block_index);

Line 2991: (p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,

2987: END blocks_to_array;
2988: */
2989:
2990: PROCEDURE remove_blocks
2991: (p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,
2992: p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE,
2993: p_block_index IN NUMBER
2994: ) is
2995: l_index NUMBER;

Line 3081: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

3077: ,p_stop_time IN VARCHAR2
3078: ,p_template_code IN VARCHAR2
3079: ,p_approval_status IN VARCHAR2
3080: ,p_approval_style IN VARCHAR2
3081: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
3082: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
3083: ,p_message_string OUT NOCOPY VARCHAR2
3084: ,p_overwrite IN VARCHAR2 DEFAULT 'Y'
3085: ,p_exclude_hours_template in VARCHAR2 DEFAULT 'N'

Line 3093: l_blocks HXC_BLOCK_TABLE_TYPE;

3089: l_template_type VARCHAR2(50) := '';
3090: l_template_handle VARCHAR2(500) := '';
3091: l_template_action VARCHAR2(20) :='';
3092: l_temp_blocks hxc_self_service_time_deposit.timecard_info;
3093: l_blocks HXC_BLOCK_TABLE_TYPE;
3094: l_attributes HXC_ATTRIBUTE_TABLE_TYPE;
3095: l_temp_attributes hxc_self_service_time_deposit.building_block_attribute_info;
3096: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
3097: l_block_string VARCHAR2(32767) := '';

Line 3900: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

3896: PROCEDURE translate_alias_timecards(
3897: p_resource_id IN VARCHAR2
3898: ,p_start_time IN VARCHAR2
3899: ,p_stop_time IN VARCHAR2
3900: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
3901: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
3902: )
3903: IS
3904: l_resource_id VARCHAR2(50) := NULL;

Line 3951: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

3947: p_resource_id IN VARCHAR2
3948: ,p_resource_type IN VARCHAR2
3949: ,p_start_time IN VARCHAR2
3950: ,p_stop_time IN VARCHAR2
3951: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
3952: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
3953: ,p_message_string OUT NOCOPY VARCHAR2
3954: ,p_review IN VARCHAR2
3955: )

Line 4355: p_blocks in out nocopy hxc_block_table_type,

4351: Procedure get_app_period_blocks_by_id
4352: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,
4353: p_start_time in date,
4354: p_stop_time in date,
4355: p_blocks in out nocopy hxc_block_table_type,
4356: p_attributes in out nocopy hxc_attribute_table_type
4357: ) IS
4358:
4359: Begin

Line 4387: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

4383: PROCEDURE get_app_period_blocks_by_id(
4384: p_resource_id IN VARCHAR2
4385: ,p_resource_type IN VARCHAR2
4386: ,p_app_period_id IN VARCHAR2
4387: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4388: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4389: ,p_message_string OUT NOCOPY VARCHAR2
4390: ,p_review IN VARCHAR2
4391: ,p_return_timecard IN VARCHAR2 DEFAULT 'Y'

Line 4900: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

4896: ,p_timecard_id IN VARCHAR2
4897: ,p_template_code IN VARCHAR2
4898: ,p_approval_status IN VARCHAR2
4899: ,p_create_template IN VARCHAR2
4900: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4901: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4902: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4903: ,p_message_string OUT NOCOPY VARCHAR2
4904: ,p_overwrite IN VARCHAR2

Line 4945: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

4941: ,p_timecard_id IN VARCHAR2
4942: ,p_template_code IN VARCHAR2
4943: ,p_approval_status IN VARCHAR2
4944: ,p_create_template IN VARCHAR2
4945: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4946: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4947: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4948: ,p_message_string OUT NOCOPY VARCHAR2
4949: ,p_overwrite IN VARCHAR2

Line 4991: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

4987: ,p_timecard_id IN VARCHAR2
4988: ,p_template_code IN VARCHAR2
4989: ,p_approval_status IN VARCHAR2
4990: ,p_create_template IN VARCHAR2
4991: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4992: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4993: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4994: ,p_message_string OUT NOCOPY VARCHAR2
4995: ,p_overwrite IN VARCHAR2

Line 5281: p_block_array := hxc_block_table_type();

5277:
5278: p_message_string := NULL;
5279: RETURN;
5280: ELSE
5281: p_block_array := hxc_block_table_type();
5282: p_attribute_array := hxc_attribute_table_type();
5283: END IF;
5284:
5285:

Line 5471: p_final_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

5467: END fetch_blocks_and_attributes;
5468:
5469:
5470: PROCEDURE add_block_attributes(
5471: p_final_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
5472: ,p_final_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
5473: ,p_new_block_array IN HXC_BLOCK_TABLE_TYPE
5474: ,p_new_attribute_array IN HXC_ATTRIBUTE_TABLE_TYPE
5475: ,p_start_att_id IN NUMBER

Line 5473: ,p_new_block_array IN HXC_BLOCK_TABLE_TYPE

5469:
5470: PROCEDURE add_block_attributes(
5471: p_final_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
5472: ,p_final_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
5473: ,p_new_block_array IN HXC_BLOCK_TABLE_TYPE
5474: ,p_new_attribute_array IN HXC_ATTRIBUTE_TABLE_TYPE
5475: ,p_start_att_id IN NUMBER
5476: )
5477: IS

Line 5517: ,p_block_array OUT NOCOPY HXC_BLOCK_TABLE_TYPE

5513: PROCEDURE fetch_appl_periods(
5514: p_resource_id IN VARCHAR2
5515: ,p_resource_type IN VARCHAR2
5516: ,p_timecard_id IN VARCHAR2
5517: ,p_block_array OUT NOCOPY HXC_BLOCK_TABLE_TYPE
5518: ,p_attribute_array OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
5519: ,p_message_string OUT NOCOPY VARCHAR2
5520: )
5521: IS

Line 5537: l_block_array HXC_BLOCK_TABLE_TYPE;

5533:
5534: l_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
5535: l_start_time hxc_timecard_summary.start_time%type;
5536: l_stop_time hxc_timecard_summary.stop_time%type;
5537: l_block_array HXC_BLOCK_TABLE_TYPE;
5538: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;
5539: l_message_string VARCHAR(2000) := NULL;
5540: l_count NUMBER;
5541: l_start_block_id NUMBER;

Line 5544: p_block_array := HXC_BLOCK_TABLE_TYPE();

5540: l_count NUMBER;
5541: l_start_block_id NUMBER;
5542: l_start_att_id NUMBER;
5543: BEGIN
5544: p_block_array := HXC_BLOCK_TABLE_TYPE();
5545: p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
5546:
5547: l_block_array := HXC_BLOCK_TABLE_TYPE();
5548: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();

Line 5547: l_block_array := HXC_BLOCK_TABLE_TYPE();

5543: BEGIN
5544: p_block_array := HXC_BLOCK_TABLE_TYPE();
5545: p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
5546:
5547: l_block_array := HXC_BLOCK_TABLE_TYPE();
5548: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
5549:
5550: l_count := 0;
5551: l_start_block_id := -2;

Line 5609: l_blocks HXC_BLOCK_TABLE_TYPE;

5605:
5606: l_template_handle VARCHAR2(500) := '';
5607: l_template_action VARCHAR2(20) :='';
5608: l_temp_blocks hxc_self_service_time_deposit.timecard_info;
5609: l_blocks HXC_BLOCK_TABLE_TYPE;
5610: l_attributes HXC_ATTRIBUTE_TABLE_TYPE;
5611: l_temp_attributes hxc_self_service_time_deposit.building_block_attribute_info;
5612: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
5613: l_block_string VARCHAR2(32767) := '';