APPS.HXC_TIMECARD_APPROVAL dependencies on HXC_APP_PERIOD_SUMMARY

Line 7: TYPE application_period_table IS TABLE OF hxc_app_period_summary.APPLICATION_PERIOD_ID%TYPE;

3:
4: g_package varchar2(30) := 'hxc_timecard_approval.';
5: g_debug boolean := hr_utility.debug_enabled;
6:
7: TYPE application_period_table IS TABLE OF hxc_app_period_summary.APPLICATION_PERIOD_ID%TYPE;
8: TYPE tc_ap_links IS RECORD
9: (TIMECARD_ID hxc_tc_ap_links.TIMECARD_ID%TYPE,
10: APPLICATION_PERIOD_ID hxc_tc_ap_links.APPLICATION_PERIOD_ID%TYPE
11: );

Line 169: from hxc_app_period_summary

165: p_stop_time hxc_time_building_blocks.stop_time%TYPE,
166: p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
167: ) is
168: select application_period_id
169: from hxc_app_period_summary
170: where resource_id = p_resource_id
171: and trunc(start_time) = trunc(p_start_time)
172: and trunc(stop_time) = trunc(p_stop_time)
173: and time_recipient_id = p_time_recipient_id

Line 282: /* Remove the record from hxc_app_period_summary table */

278: hr_utility.set_location('Processing '||l_proc, 50);
279: end if;
280: /* Remove the existing record from hxc_ap_detail_links table */
281: hxc_ap_detail_links_pkg.delete_ap_detail_links(p_application_period_id => l_app_period_info(l_dup_index));
282: /* Remove the record from hxc_app_period_summary table */
283: hxc_app_period_summary_pkg.delete_summary_row(p_app_period_id => l_app_period_info(l_dup_index) );
284: End loop;
285: end if;
286: end loop;

Line 283: hxc_app_period_summary_pkg.delete_summary_row(p_app_period_id => l_app_period_info(l_dup_index) );

279: end if;
280: /* Remove the existing record from hxc_ap_detail_links table */
281: hxc_ap_detail_links_pkg.delete_ap_detail_links(p_application_period_id => l_app_period_info(l_dup_index));
282: /* Remove the record from hxc_app_period_summary table */
283: hxc_app_period_summary_pkg.delete_summary_row(p_app_period_id => l_app_period_info(l_dup_index) );
284: End loop;
285: end if;
286: end loop;
287:

Line 354: /* Get the creation date of the Timecard to populate in the hxc_app_period_summary table */

350: p_object_version_number => l_object_version_number
351: );
352:
353:
354: /* Get the creation date of the Timecard to populate in the hxc_app_period_summary table */
355: open c_creation_date(l_time_building_block_id , l_object_version_number );
356: fetch c_creation_date into l_creation_date;
357: close c_creation_date;
358: if g_debug then

Line 362: /* Call to create the Application period in hxc_app_period_summary table */

358: if g_debug then
359: hr_utility.set_location('Processing '||l_proc, 100);
360: end if;
361:
362: /* Call to create the Application period in hxc_app_period_summary table */
363: hxc_app_period_summary_pkg.insert_summary_row
364: (p_application_period_id => l_time_building_block_id,
365: p_application_period_ovn=> l_object_version_number,
366: p_approval_status => 'APPROVED',

Line 363: hxc_app_period_summary_pkg.insert_summary_row

359: hr_utility.set_location('Processing '||l_proc, 100);
360: end if;
361:
362: /* Call to create the Application period in hxc_app_period_summary table */
363: hxc_app_period_summary_pkg.insert_summary_row
364: (p_application_period_id => l_time_building_block_id,
365: p_application_period_ovn=> l_object_version_number,
366: p_approval_status => 'APPROVED',
367: p_time_recipient_id => l_appl_recipients(l_index),