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_APPROVAL_WF_PKG dependencies on HXC_TIME_RECIPIENTS

Line 1610: ,p_time_recipient_id in HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE

1606: ------------------------- get_approval_period_id --------------------------
1607: --
1608: FUNCTION get_approval_period_id(
1609: p_resource_id in HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE
1610: ,p_time_recipient_id in HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE
1611: ,p_day_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
1612: ,p_timecard_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
1613: ,p_timecard_stop_time in HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE
1614: )

Line 1726: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE

1722: PROCEDURE get_application_period(
1723: p_app_period_func IN VARCHAR2
1724: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1725: ,p_day IN hxc_time_building_blocks.start_time%TYPE
1726: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE
1727: ,p_tc_start_time IN hxc_time_building_blocks.start_time%TYPE
1728: ,p_tc_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1729: ,p_assignment_periods IN hxc_timecard_utilities.periods
1730: ,p_period_start OUT NOCOPY hxc_time_building_blocks.start_time%TYPE

Line 2042: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE

2038: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
2039: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
2040: ,p_start_time IN hxc_time_building_blocks.start_time%TYPE
2041: ,p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
2042: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
2043: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE
2044: ,p_approval_comp IN approval_comp
2045: ,p_tc_resubmitted IN VARCHAR2
2046: -- ,p_first IN VARCHAR2

Line 2056: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE

2052: CURSOR c_app_period(
2053: p_resource_id hxc_time_building_blocks.resource_id%TYPE
2054: ,p_start_time hxc_time_building_blocks.start_time%TYPE
2055: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE
2056: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
2057: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE
2058: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
2059: ,p_category_sequence hxc_approval_comps.approval_order%TYPE
2060: )

Line 2896: hxc_time_recipients htr

2892: htr.application_period_function,
2893: htr.time_recipient_id
2894: from hxc_application_sets_v has,
2895: hxc_application_set_comps_v hasc,
2896: hxc_time_recipients htr
2897: where to_char(has.application_set_id) = p_app_set
2898: and hasc.application_set_id = has.application_set_id
2899: and hasc.time_recipient_id = htr.time_recipient_id;
2900: --

Line 2992: ,p_time_recipient hxc_time_recipients.time_recipient_id%TYPE

2988:
2989:
2990: CURSOR c_approval_comp(
2991: p_approval_style hxc_approval_styles.approval_style_id%TYPE
2992: ,p_time_recipient hxc_time_recipients.time_recipient_id%TYPE
2993: )
2994: IS
2995: SELECT approval_comp_id
2996: ,object_version_number

Line 3811: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE

3807: FUNCTION chk_app_approved(
3808: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
3809: ,p_period_start_date IN hxc_time_building_blocks.start_time%TYPE
3810: ,p_period_end_date IN hxc_time_building_blocks.stop_time%TYPE
3811: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
3812: ,p_recipient_sequence IN hxc_app_period_summary.recipient_sequence%TYPE
3813: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
3814: ,p_category_sequence IN hxc_app_period_summary.category_sequence%TYPE
3815: )

Line 3824: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE

3820: p_date DATE
3821: ,p_resource_id hxc_time_building_blocks.resource_id%TYPE
3822: ,p_period_start_date hxc_time_building_blocks.start_time%TYPE
3823: ,p_period_end_date hxc_time_building_blocks.stop_time%TYPE
3824: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
3825: ,p_recipient_sequence hxc_app_period_summary.recipient_sequence%TYPE
3826: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
3827: ,p_category_sequence hxc_app_period_summary.category_sequence%TYPE
3828: )

Line 4996: from hxc_time_recipients htr

4992: result IN OUT NOCOPY varchar2) is
4993: --
4994: cursor csr_get_extension(p_time_recipient number) is
4995: select htr.extension_function1
4996: from hxc_time_recipients htr
4997: where htr.time_recipient_id = p_time_recipient;
4998:
4999: cursor c_appr_comp(p_app_bb_id number,p_app_bb_ovn number)
5000: is

Line 5097: -- on hxc_time_recipients.

5093: hr_utility.set_location(l_proc, 40);
5094: end if;
5095: --
5096: -- Get the package.procedure from the extension_function1 column
5097: -- on hxc_time_recipients.
5098: --
5099: -- package.procedure(
5100: -- p_timecard_building_blocks => g_time_building_blocks,
5101: -- p_time_attributes => g_time_attributes,