APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_TIMECARD_SUMMARY

Line 1291: hxc_timecard_summary_api.reevaluate_timecard_statuses

1287: ,notification_status = 'FINISHED'
1288: ,creation_date = l_creation_date
1289: where application_period_id = l_appl_period_bb_id;
1290:
1291: hxc_timecard_summary_api.reevaluate_timecard_statuses
1292: (p_application_period_id => l_appl_period_bb_id);
1293:
1294: update_latest_details(l_appl_period_bb_id);
1295:

Line 1540: hxc_timecard_summary_api.reevaluate_timecard_statuses(l_new_appl_bb_id);

1536: l_timecard_id
1537: ,l_new_appl_bb_id);
1538:
1539: --Bug 5554020.
1540: hxc_timecard_summary_api.reevaluate_timecard_statuses(l_new_appl_bb_id);
1541:
1542: END LOOP;
1543:
1544: CLOSE c_timecards;

Line 2337: from hxc_timecard_summary

2333:
2334: /*
2335: select nvl(recorded_hours,0) + nvl(absence_hours,0)
2336: into l_total_hours
2337: from hxc_timecard_summary
2338: where resource_id = p_resource_id
2339: and start_time = p_start_time
2340: and trunc(stop_time) = trunc(p_stop_time);
2341: */

Line 2348: from hxc_timecard_summary

2344: -- The start time and stop time would not be right
2345: -- in this query in case of Midperiod Terminated/Rehired employees
2346: select nvl(recorded_hours,0) + nvl(absence_hours,0)
2347: into l_total_hours
2348: from hxc_timecard_summary
2349: where timecard_id = p_timecard_id;
2350:
2351:
2352:

Line 2467: hxc_timecard_summary_api.reevaluate_timecard_statuses(l_app_id);

2463: -- status is reevaluated so that if a period is not sent due
2464: -- to other changes in the timecard, the timecard has the
2465: -- appropriate status.
2466: --
2467: hxc_timecard_summary_api.reevaluate_timecard_statuses(l_app_id);
2468: hr_utility.trace('Return(4) - populated actioned App period - no changes. Use, but do not renotify');
2469: RETURN;
2470: END IF;
2471: end if;

Line 2768: hxc_timecard_summary_api.reevaluate_timecard_statuses(l_app_id);

2764: );
2765: --
2766: --115.118, Bug - 5554020
2767: --
2768: hxc_timecard_summary_api.reevaluate_timecard_statuses(l_app_id);
2769:
2770: g_trace := l_proc || '180';
2771: END IF;
2772:

Line 4026: ,p_timecard_id in hxc_timecard_summary.timecard_id%type

4022:
4023:
4024: CURSOR csr_get_appl_periods(
4025: p_resource_id in hxc_app_period_summary.resource_id%type
4026: ,p_timecard_id in hxc_timecard_summary.timecard_id%type
4027: )
4028: IS
4029: select aps.application_period_id,
4030: aps.start_time, -- period_start_date

Line 4575: FROM hxc_timecard_summary tc

4571: p_app_id IN hxc_time_building_blocks.time_building_block_id
4572: )
4573: IS
4574: SELECT tc.approval_style_id
4575: FROM hxc_timecard_summary tc
4576: ,hxc_timecard_application_summary ta
4577: WHERE ta.application_period_id = p_app_id
4578: AND tc.time_building_block_id = ta.time_building_block_id
4579:

Line 4608: from hxc_timecard_summary

4604: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
4605: )
4606: IS
4607: select approval_style_id
4608: from hxc_timecard_summary
4609: where timecard_id = p_timecard_id;
4610: */
4611: BEGIN
4612: /*