1 package hxc_app_period_summary_api 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;
10
11 procedure app_period_create
12 (p_application_period_id in hxc_app_period_summary.application_period_id%type
13 ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode);
14
15
16 procedure app_period_create
17 (p_application_period_id in hxc_app_period_summary.application_period_id%type
18 ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
19 ,p_approval_status in hxc_app_period_summary.approval_status%type
20 ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
21 ,p_time_category_id in hxc_app_period_summary.time_category_id%type
22 ,p_start_time in hxc_app_period_summary.start_time%type
23 ,p_stop_time in hxc_app_period_summary.stop_time%type
24 ,p_resource_id in hxc_app_period_summary.resource_id%type
25 ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
26 ,p_category_sequence in hxc_app_period_summary.category_sequence%type
27 ,p_creation_date in hxc_app_period_summary.creation_date%type
28 ,p_notification_status in hxc_app_period_summary.notification_status%type
29 ,p_approver_id in hxc_app_period_summary.approver_id%type
30 ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
31 ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type default null
32 );
33
34 procedure app_period_delete
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
44 ,p_valid_periods OUT NOCOPY valid_period_tab
45 );
46
47 end hxc_app_period_summary_api;