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.

[Home] [Help]

APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_TIME_RECIPIENTS

Line 1431: ,p_time_recipient_id in HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE

1427: ------------------------- get_approval_period_id --------------------------
1428: --
1429: FUNCTION get_approval_period_id(
1430: p_resource_id in HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE
1431: ,p_time_recipient_id in HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE
1432: ,p_day_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
1433: ,p_timecard_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
1434: ,p_timecard_stop_time in HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE
1435: )

Line 1547: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE

1543: PROCEDURE get_application_period(
1544: p_app_period_func IN VARCHAR2
1545: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1546: ,p_day IN hxc_time_building_blocks.start_time%TYPE
1547: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE
1548: ,p_tc_start_time IN hxc_time_building_blocks.start_time%TYPE
1549: ,p_tc_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1550: ,p_assignment_periods IN hxc_timecard_utilities.periods
1551: ,p_period_start OUT NOCOPY hxc_time_building_blocks.start_time%TYPE

Line 1863: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE

1859: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
1860: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1861: ,p_start_time IN hxc_time_building_blocks.start_time%TYPE
1862: ,p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1863: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
1864: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE
1865: ,p_approval_comp IN approval_comp
1866: ,p_tc_resubmitted IN VARCHAR2
1867: -- ,p_first IN VARCHAR2

Line 1877: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE

1873: CURSOR c_app_period(
1874: p_resource_id hxc_time_building_blocks.resource_id%TYPE
1875: ,p_start_time hxc_time_building_blocks.start_time%TYPE
1876: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE
1877: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
1878: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE
1879: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
1880: ,p_category_sequence hxc_approval_comps.approval_order%TYPE
1881: )

Line 2548: hxc_time_recipients htr

2544: htr.application_period_function,
2545: htr.time_recipient_id
2546: from hxc_application_sets_v has,
2547: hxc_application_set_comps_v hasc,
2548: hxc_time_recipients htr
2549: where to_char(has.application_set_id) = p_app_set
2550: and hasc.application_set_id = has.application_set_id
2551: and hasc.time_recipient_id = htr.time_recipient_id;
2552: --

Line 2644: ,p_time_recipient hxc_time_recipients.time_recipient_id%TYPE

2640:
2641:
2642: CURSOR c_approval_comp(
2643: p_approval_style hxc_approval_styles.approval_style_id%TYPE
2644: ,p_time_recipient hxc_time_recipients.time_recipient_id%TYPE
2645: )
2646: IS
2647: SELECT approval_comp_id
2648: ,object_version_number

Line 3180: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE

3176: FUNCTION chk_app_approved(
3177: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
3178: ,p_period_start_date IN hxc_time_building_blocks.start_time%TYPE
3179: ,p_period_end_date IN hxc_time_building_blocks.stop_time%TYPE
3180: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
3181: ,p_recipient_sequence IN hxc_app_period_summary.recipient_sequence%TYPE
3182: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
3183: ,p_category_sequence IN hxc_app_period_summary.category_sequence%TYPE
3184: )

Line 3193: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE

3189: p_date DATE
3190: ,p_resource_id hxc_time_building_blocks.resource_id%TYPE
3191: ,p_period_start_date hxc_time_building_blocks.start_time%TYPE
3192: ,p_period_end_date hxc_time_building_blocks.stop_time%TYPE
3193: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
3194: ,p_recipient_sequence hxc_app_period_summary.recipient_sequence%TYPE
3195: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
3196: ,p_category_sequence hxc_app_period_summary.category_sequence%TYPE
3197: )

Line 4309: from hxc_time_recipients htr

4305: result IN OUT NOCOPY varchar2) is
4306: --
4307: cursor csr_get_extension(p_time_recipient number) is
4308: select htr.extension_function1
4309: from hxc_time_recipients htr
4310: where htr.time_recipient_id = p_time_recipient;
4311:
4312: cursor c_appr_comp(p_app_bb_id number,p_app_bb_ovn number)
4313: is

Line 4410: -- on hxc_time_recipients.

4406: hr_utility.set_location(l_proc, 40);
4407: end if;
4408: --
4409: -- Get the package.procedure from the extension_function1 column
4410: -- on hxc_time_recipients.
4411: --
4412: -- package.procedure(
4413: -- p_timecard_building_blocks => g_time_building_blocks,
4414: -- p_time_attributes => g_time_attributes,