DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_TIMECARD_SUMMARY

Line 1112: hxc_timecard_summary_api.reevaluate_timecard_statuses

1108: ,notification_status = 'FINISHED'
1109: ,creation_date = l_creation_date
1110: where application_period_id = l_appl_period_bb_id;
1111:
1112: hxc_timecard_summary_api.reevaluate_timecard_statuses
1113: (p_application_period_id => l_appl_period_bb_id);
1114:
1115: update_latest_details(l_appl_period_bb_id);
1116:

Line 1361: hxc_timecard_summary_api.reevaluate_timecard_statuses(l_new_appl_bb_id);

1357: l_timecard_id
1358: ,l_new_appl_bb_id);
1359:
1360: --Bug 5554020.
1361: hxc_timecard_summary_api.reevaluate_timecard_statuses(l_new_appl_bb_id);
1362:
1363: END LOOP;
1364:
1365: CLOSE c_timecards;

Line 2194: hxc_timecard_summary_api.reevaluate_timecard_statuses(l_app_id);

2190: -- status is reevaluated so that if a period is not sent due
2191: -- to other changes in the timecard, the timecard has the
2192: -- appropriate status.
2193: --
2194: hxc_timecard_summary_api.reevaluate_timecard_statuses(l_app_id);
2195: hr_utility.trace('Return(4) - populated actioned App period - no changes. Use, but do not renotify');
2196: RETURN;
2197: END IF;
2198: end if;

Line 2421: hxc_timecard_summary_api.reevaluate_timecard_statuses(l_app_id);

2417: );
2418: --
2419: --115.118, Bug - 5554020
2420: --
2421: hxc_timecard_summary_api.reevaluate_timecard_statuses(l_app_id);
2422:
2423: g_trace := l_proc || '180';
2424: END IF;
2425:

Line 3394: ,p_timecard_id in hxc_timecard_summary.timecard_id%type

3390:
3391:
3392: CURSOR csr_get_appl_periods(
3393: p_resource_id in hxc_app_period_summary.resource_id%type
3394: ,p_timecard_id in hxc_timecard_summary.timecard_id%type
3395: )
3396: IS
3397: select aps.application_period_id,
3398: aps.start_time, -- period_start_date

Line 3923: FROM hxc_timecard_summary tc

3919: p_app_id IN hxc_time_building_blocks.time_building_block_id
3920: )
3921: IS
3922: SELECT tc.approval_style_id
3923: FROM hxc_timecard_summary tc
3924: ,hxc_timecard_application_summary ta
3925: WHERE ta.application_period_id = p_app_id
3926: AND tc.time_building_block_id = ta.time_building_block_id
3927:

Line 3956: from hxc_timecard_summary

3952: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3953: )
3954: IS
3955: select approval_style_id
3956: from hxc_timecard_summary
3957: where timecard_id = p_timecard_id;
3958: */
3959: BEGIN
3960: /*