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 1511: ,p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info

1507:
1508: PROCEDURE build_attribute_detail(
1509: p_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1510: ,p_block_attribute IN OUT NOCOPY HXC_ATTRIBUTE_TYPE
1511: ,p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1512: ,p_template_type IN VARCHAR2
1513: )
1514: IS
1515: l_att_count NUMBER;

Line 1705: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info

1701:
1702:
1703:
1704: FUNCTION app_to_block_attributes(
1705: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
1706: ,p_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1707: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1708: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
1709: ,p_template_type IN VARCHAR2

Line 1714: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;

1710: )
1711: RETURN HXC_ATTRIBUTE_TABLE_TYPE
1712: IS
1713: l_block_attributes HXC_ATTRIBUTE_TABLE_TYPE;
1714: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
1715: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1716: l_app_attribute_index NUMBER;
1717: l_block_attribute_index NUMBER := 0;
1718:

Line 2217: -- l_attributes hxc_self_service_time_deposit.building_block_attribute_info;

2213: ,p_start_time IN VARCHAR2
2214: ,p_stop_time IN VARCHAR2
2215: )
2216: IS
2217: -- l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
2218: -- l_blocks hxc_self_service_time_deposit.timecard_info;
2219: l_messages HXC_MESSAGE_TABLE_TYPE;
2220:
2221: BEGIN

Line 2218: -- l_blocks hxc_self_service_time_deposit.timecard_info;

2214: ,p_stop_time IN VARCHAR2
2215: )
2216: IS
2217: -- l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
2218: -- l_blocks hxc_self_service_time_deposit.timecard_info;
2219: l_messages HXC_MESSAGE_TABLE_TYPE;
2220:
2221: BEGIN
2222:

Line 2847: p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info

2843:
2844:
2845: /*
2846: FUNCTION attributes_to_array(
2847: p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
2848: )
2849: RETURN HXC_ATTRIBUTE_TABLE_TYPE
2850: IS
2851: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;

Line 2929: p_blocks IN hxc_self_service_time_deposit.timecard_info

2925: */
2926:
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;

Line 3092: l_temp_blocks hxc_self_service_time_deposit.timecard_info;

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

Line 3095: l_temp_attributes hxc_self_service_time_deposit.building_block_attribute_info;

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

Line 3096: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;

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) := '';
3098: l_attribute_string VARCHAR2(32767) := '';
3099: l_message_string VARCHAR2(32767) := '';
3100: l_temp VARCHAR2(32767) := '';

Line 3698: ,p_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info

3694: /*
3695: PROCEDURE get_attributes(
3696: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3697: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
3698: ,p_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
3699: ,p_review IN VARCHAR2
3700: )
3701: IS
3702: l_attribute_index NUMBER;

Line 3703: l_temp_attribute hxc_self_service_time_deposit.attribute_info;

3699: ,p_review IN VARCHAR2
3700: )
3701: IS
3702: l_attribute_index NUMBER;
3703: l_temp_attribute hxc_self_service_time_deposit.attribute_info;
3704:
3705: CURSOR c_block_attributes(
3706: p_building_block_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
3707: ,p_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

Line 3793: ,p_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info

3789:
3790: PROCEDURE get_attributes(
3791: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3792: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
3793: ,p_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
3794: ,p_review IN VARCHAR2
3795: ,p_new_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE DEFAULT NULL
3796: )
3797: IS

Line 3799: l_temp_attribute hxc_self_service_time_deposit.attribute_info;

3795: ,p_new_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE DEFAULT NULL
3796: )
3797: IS
3798: l_attribute_index NUMBER;
3799: l_temp_attribute hxc_self_service_time_deposit.attribute_info;
3800:
3801: CURSOR c_block_attributes(
3802: p_building_block_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
3803: ,p_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

Line 3957: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;

3953: ,p_message_string OUT NOCOPY VARCHAR2
3954: ,p_review IN VARCHAR2
3955: )
3956: IS
3957: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
3958: l_blocks hxc_self_service_time_deposit.timecard_info;
3959: l_block_index NUMBER;
3960: l_parent_id hxc_time_building_blocks.time_building_block_id%TYPE;
3961:

Line 3958: l_blocks hxc_self_service_time_deposit.timecard_info;

3954: ,p_review IN VARCHAR2
3955: )
3956: IS
3957: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
3958: l_blocks hxc_self_service_time_deposit.timecard_info;
3959: l_block_index NUMBER;
3960: l_parent_id hxc_time_building_blocks.time_building_block_id%TYPE;
3961:
3962:

Line 4396: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;

4392: ,p_mode IN VARCHAR2 DEFAULT c_for_approver
4393: ,p_notif_id IN VARCHAR2 DEFAULT null
4394: )
4395: IS
4396: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
4397: l_blocks hxc_self_service_time_deposit.timecard_info;
4398: l_app_period hxc_self_service_time_deposit.building_block_info;
4399: l_block_index NUMBER;
4400: l_parent_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 4397: l_blocks hxc_self_service_time_deposit.timecard_info;

4393: ,p_notif_id IN VARCHAR2 DEFAULT null
4394: )
4395: IS
4396: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
4397: l_blocks hxc_self_service_time_deposit.timecard_info;
4398: l_app_period hxc_self_service_time_deposit.building_block_info;
4399: l_block_index NUMBER;
4400: l_parent_id hxc_time_building_blocks.time_building_block_id%TYPE;
4401: l_parent_ovn hxc_time_building_blocks.object_version_number%TYPE;

Line 4398: l_app_period hxc_self_service_time_deposit.building_block_info;

4394: )
4395: IS
4396: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
4397: l_blocks hxc_self_service_time_deposit.timecard_info;
4398: l_app_period hxc_self_service_time_deposit.building_block_info;
4399: l_block_index NUMBER;
4400: l_parent_id hxc_time_building_blocks.time_building_block_id%TYPE;
4401: l_parent_ovn hxc_time_building_blocks.object_version_number%TYPE;
4402: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 5013: l_blocks hxc_self_service_time_deposit.timecard_info;

5009: and trunc(start_time) = trunc(p_start_time)
5010: and trunc(stop_time) = trunc(p_stop_time);
5011:
5012:
5013: l_blocks hxc_self_service_time_deposit.timecard_info;
5014: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
5015: l_block_id hxc_time_building_blocks.time_building_block_id%TYPE;
5016: l_block_index NUMBER := 1;
5017: l_attribute_index NUMBER := 1;

Line 5014: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;

5010: and trunc(stop_time) = trunc(p_stop_time);
5011:
5012:
5013: l_blocks hxc_self_service_time_deposit.timecard_info;
5014: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
5015: l_block_id hxc_time_building_blocks.time_building_block_id%TYPE;
5016: l_block_index NUMBER := 1;
5017: l_attribute_index NUMBER := 1;
5018: l_block_string VARCHAR2(32767) := NULL;

Line 5608: l_temp_blocks hxc_self_service_time_deposit.timecard_info;

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

Line 5611: l_temp_attributes hxc_self_service_time_deposit.building_block_attribute_info;

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

Line 5612: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;

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) := '';
5614: l_attribute_string VARCHAR2(32767) := '';
5615: l_message_string VARCHAR2(32767) := '';
5616: l_block_index NUMBER := 1;