APPS.HXC_AP_DETAIL_LINKS_PKG dependencies on HXC_TC_AP_LINKS

Line 6: TYPE app_period_tab IS TABLE OF hxc_tc_ap_links.application_period_id%TYPE INDEX BY BINARY_INTEGER;

2: /* $Header: hxcadtsum.pkb 120.2 2005/09/23 08:03:11 sechandr noship $ */
3:
4: g_debug BOOLEAN:= hr_utility.debug_enabled;
5: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
6: TYPE app_period_tab IS TABLE OF hxc_tc_ap_links.application_period_id%TYPE INDEX BY BINARY_INTEGER;
7:
8: procedure insert_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
9: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
10: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is

Line 106: FROM hxc_tc_ap_links tal

102: ,p_blocks in hxc_block_table_type) IS
103:
104: CURSOR csr_get_appl_period_id ( p_tbb_id NUMBER ) IS
105: SELECT tal.application_period_id
106: FROM hxc_tc_ap_links tal
107: WHERE tal.timecard_id = p_tbb_id;
108:
109: l_index PLS_INTEGER;
110: l_contiguous_index PLS_INTEGER;

Line 112: l_application_period_id hxc_tc_ap_links.application_period_id%TYPE;

108:
109: l_index PLS_INTEGER;
110: l_contiguous_index PLS_INTEGER;
111:
112: l_application_period_id hxc_tc_ap_links.application_period_id%TYPE;
113:
114: t_tbb_id tbb_id_tab;
115: t_app_period app_period_tab;
116: