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_SELF_SERVICE_TIME_DEPOSIT

Line 1213: ,p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info

1209:
1210: PROCEDURE build_attribute_detail(
1211: p_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1212: ,p_block_attribute IN OUT NOCOPY HXC_ATTRIBUTE_TYPE
1213: ,p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1214: ,p_template_type IN VARCHAR2
1215: )
1216: IS
1217: l_att_count NUMBER;

Line 1407: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info

1403:
1404:
1405:
1406: FUNCTION app_to_block_attributes(
1407: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
1408: ,p_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1409: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1410: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
1411: ,p_template_type IN VARCHAR2

Line 1416: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;

1412: )
1413: RETURN HXC_ATTRIBUTE_TABLE_TYPE
1414: IS
1415: l_block_attributes HXC_ATTRIBUTE_TABLE_TYPE;
1416: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
1417: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1418: l_app_attribute_index NUMBER;
1419: l_block_attribute_index NUMBER := 0;
1420:

Line 1919: -- l_attributes hxc_self_service_time_deposit.building_block_attribute_info;

1915: ,p_start_time IN VARCHAR2
1916: ,p_stop_time IN VARCHAR2
1917: )
1918: IS
1919: -- l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
1920: -- l_blocks hxc_self_service_time_deposit.timecard_info;
1921: l_messages HXC_MESSAGE_TABLE_TYPE;
1922:
1923: BEGIN

Line 1920: -- l_blocks hxc_self_service_time_deposit.timecard_info;

1916: ,p_stop_time IN VARCHAR2
1917: )
1918: IS
1919: -- l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
1920: -- l_blocks hxc_self_service_time_deposit.timecard_info;
1921: l_messages HXC_MESSAGE_TABLE_TYPE;
1922:
1923: BEGIN
1924:

Line 2547: p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info

2543:
2544:
2545: /*
2546: FUNCTION attributes_to_array(
2547: p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
2548: )
2549: RETURN HXC_ATTRIBUTE_TABLE_TYPE
2550: IS
2551: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;

Line 2629: p_blocks IN hxc_self_service_time_deposit.timecard_info

2625: */
2626:
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;

Line 2792: l_temp_blocks hxc_self_service_time_deposit.timecard_info;

2788: IS
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;

Line 2795: l_temp_attributes hxc_self_service_time_deposit.building_block_attribute_info;

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) := '';
2798: l_attribute_string VARCHAR2(32767) := '';
2799: l_message_string VARCHAR2(32767) := '';

Line 2796: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;

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) := '';
2798: l_attribute_string VARCHAR2(32767) := '';
2799: l_message_string VARCHAR2(32767) := '';
2800: l_temp VARCHAR2(32767) := '';

Line 3362: ,p_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info

3358: /*
3359: PROCEDURE get_attributes(
3360: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3361: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
3362: ,p_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
3363: ,p_review IN VARCHAR2
3364: )
3365: IS
3366: l_attribute_index NUMBER;

Line 3367: l_temp_attribute hxc_self_service_time_deposit.attribute_info;

3363: ,p_review IN VARCHAR2
3364: )
3365: IS
3366: l_attribute_index NUMBER;
3367: l_temp_attribute hxc_self_service_time_deposit.attribute_info;
3368:
3369: CURSOR c_block_attributes(
3370: p_building_block_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
3371: ,p_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

Line 3457: ,p_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info

3453:
3454: PROCEDURE get_attributes(
3455: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3456: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
3457: ,p_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
3458: ,p_review IN VARCHAR2
3459: ,p_new_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE DEFAULT NULL
3460: )
3461: IS

Line 3463: l_temp_attribute hxc_self_service_time_deposit.attribute_info;

3459: ,p_new_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE DEFAULT NULL
3460: )
3461: IS
3462: l_attribute_index NUMBER;
3463: l_temp_attribute hxc_self_service_time_deposit.attribute_info;
3464:
3465: CURSOR c_block_attributes(
3466: p_building_block_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
3467: ,p_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

Line 3621: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;

3617: ,p_message_string OUT NOCOPY VARCHAR2
3618: ,p_review IN VARCHAR2
3619: )
3620: IS
3621: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
3622: l_blocks hxc_self_service_time_deposit.timecard_info;
3623: l_block_index NUMBER;
3624: l_parent_id hxc_time_building_blocks.time_building_block_id%TYPE;
3625:

Line 3622: l_blocks hxc_self_service_time_deposit.timecard_info;

3618: ,p_review IN VARCHAR2
3619: )
3620: IS
3621: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
3622: l_blocks hxc_self_service_time_deposit.timecard_info;
3623: l_block_index NUMBER;
3624: l_parent_id hxc_time_building_blocks.time_building_block_id%TYPE;
3625:
3626:

Line 4060: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;

4056: ,p_mode IN VARCHAR2 DEFAULT c_for_approver
4057: ,p_notif_id IN VARCHAR2 DEFAULT null
4058: )
4059: IS
4060: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
4061: l_blocks hxc_self_service_time_deposit.timecard_info;
4062: l_app_period hxc_self_service_time_deposit.building_block_info;
4063: l_block_index NUMBER;
4064: l_parent_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 4061: l_blocks hxc_self_service_time_deposit.timecard_info;

4057: ,p_notif_id IN VARCHAR2 DEFAULT null
4058: )
4059: IS
4060: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
4061: l_blocks hxc_self_service_time_deposit.timecard_info;
4062: l_app_period hxc_self_service_time_deposit.building_block_info;
4063: l_block_index NUMBER;
4064: l_parent_id hxc_time_building_blocks.time_building_block_id%TYPE;
4065: l_parent_ovn hxc_time_building_blocks.object_version_number%TYPE;

Line 4062: l_app_period hxc_self_service_time_deposit.building_block_info;

4058: )
4059: IS
4060: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
4061: l_blocks hxc_self_service_time_deposit.timecard_info;
4062: l_app_period hxc_self_service_time_deposit.building_block_info;
4063: l_block_index NUMBER;
4064: l_parent_id hxc_time_building_blocks.time_building_block_id%TYPE;
4065: l_parent_ovn hxc_time_building_blocks.object_version_number%TYPE;
4066: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 4677: l_blocks hxc_self_service_time_deposit.timecard_info;

4673: and trunc(start_time) = trunc(p_start_time)
4674: and trunc(stop_time) = trunc(p_stop_time);
4675:
4676:
4677: l_blocks hxc_self_service_time_deposit.timecard_info;
4678: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
4679: l_block_id hxc_time_building_blocks.time_building_block_id%TYPE;
4680: l_block_index NUMBER := 1;
4681: l_attribute_index NUMBER := 1;

Line 4678: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;

4674: and trunc(stop_time) = trunc(p_stop_time);
4675:
4676:
4677: l_blocks hxc_self_service_time_deposit.timecard_info;
4678: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
4679: l_block_id hxc_time_building_blocks.time_building_block_id%TYPE;
4680: l_block_index NUMBER := 1;
4681: l_attribute_index NUMBER := 1;
4682: l_block_string VARCHAR2(32767) := NULL;

Line 5189: l_temp_blocks hxc_self_service_time_deposit.timecard_info;

5185: IS
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;

Line 5192: l_temp_attributes hxc_self_service_time_deposit.building_block_attribute_info;

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) := '';
5195: l_attribute_string VARCHAR2(32767) := '';
5196: l_message_string VARCHAR2(32767) := '';

Line 5193: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;

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) := '';
5195: l_attribute_string VARCHAR2(32767) := '';
5196: l_message_string VARCHAR2(32767) := '';
5197: l_block_index NUMBER := 1;