APPS.HXC_APP_PERIOD_SUMMARY_API dependencies on HXC_TIME_BUILDING_BLOCKS

Line 5: start_time hxc_time_building_blocks.start_time%TYPE

1: package hxc_app_period_summary_api AUTHID CURRENT_USER as
2: /* $Header: hxcapsumapi.pkh 120.1.12010000.1 2008/07/28 11:04:43 appldev ship $ */
3:
4: TYPE valid_period_rec IS RECORD (
5: start_time hxc_time_building_blocks.start_time%TYPE
6: ,stop_time hxc_time_building_blocks.stop_time%TYPE
7: );
8:
9: TYPE valid_period_tab IS TABLE OF valid_period_rec INDEX BY BINARY_INTEGER;

Line 6: ,stop_time hxc_time_building_blocks.stop_time%TYPE

2: /* $Header: hxcapsumapi.pkh 120.1.12010000.1 2008/07/28 11:04:43 appldev ship $ */
3:
4: TYPE valid_period_rec IS RECORD (
5: start_time hxc_time_building_blocks.start_time%TYPE
6: ,stop_time hxc_time_building_blocks.stop_time%TYPE
7: );
8:
9: TYPE valid_period_tab IS TABLE OF valid_period_rec INDEX BY BINARY_INTEGER;
10:

Line 39: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE

35: (p_application_period_id in hxc_app_period_summary.application_period_id%type);
36:
37:
38: PROCEDURE get_valid_periods(
39: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
40: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
41: ,p_start_date IN DATE
42: ,p_stop_date IN DATE
43: ,p_valid_status IN VARCHAR2