APPS.HXC_APP_PERIOD_SUMMARY_API dependencies on HXC_TIMECARD_SUMMARY

Line 67: if(p_mode = hxc_timecard_summary_pkg.c_normal_mode) then

63: l_time_recipient_id hxc_app_period_summary.time_recipient_id%type;
64:
65: Begin
66:
67: if(p_mode = hxc_timecard_summary_pkg.c_normal_mode) then
68: open app_period_info(p_application_period_id);
69: fetch app_period_info into l_resource_id, l_start_time, l_stop_time,l_time_recipient_id;
70: if (app_period_info%FOUND) then
71: for app_rec in app_periods_to_remove(l_resource_id,l_start_time,l_stop_time,l_time_recipient_id) loop

Line 87: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode

83: End app_period_clean_up;
84:
85: procedure app_period_create
86: (p_application_period_id in hxc_app_period_summary.application_period_id%type
87: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
88: ) is
89:
90: Begin
91: --

Line 120: if(p_mode = hxc_timecard_summary_pkg.c_normal_mode) then

116: --
117: -- 5. Reevaluate the timecard status
118: -- Not required on migration - status are
119: -- found as the migrated rows are created.
120: if(p_mode = hxc_timecard_summary_pkg.c_normal_mode) then
121: hxc_timecard_summary_api.reevaluate_timecard_statuses
122: (p_application_period_id => p_application_period_id);
123: end if;
124:

Line 121: hxc_timecard_summary_api.reevaluate_timecard_statuses

117: -- 5. Reevaluate the timecard status
118: -- Not required on migration - status are
119: -- found as the migrated rows are created.
120: if(p_mode = hxc_timecard_summary_pkg.c_normal_mode) then
121: hxc_timecard_summary_api.reevaluate_timecard_statuses
122: (p_application_period_id => p_application_period_id);
123: end if;
124:
125: --

Line 201: hxc_timecard_summary_api.reevaluate_timecard_statuses

197: --
198: --
199: -- 5. Reevaluate the timecard status
200: --
201: hxc_timecard_summary_api.reevaluate_timecard_statuses
202: (p_application_period_id => p_application_period_id);
203:
204: --
205: -- End create application period

Line 373: FROM hxc_timecard_summary tc

369: )
370: is
371: SELECT tc.start_time
372: ,tc.stop_time
373: FROM hxc_timecard_summary tc
374: WHERE tc.resource_id = p_resource_id
375: AND tc.start_time <= p_stop_date
376: AND tc.stop_time >= p_start_date
377: AND tc.approval_status in ('SUBMITTED','APPROVED')