1 package hxc_app_period_summary_pkg as
2 /* $Header: hxcapsum.pkh 120.0 2005/05/29 04:54:59 appldev noship $ */
3
4 procedure insert_summary_row
5 (p_application_period_id in hxc_app_period_summary.application_period_id%type
6 ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
7 ,p_approval_status in hxc_app_period_summary.approval_status%type
8 ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9 ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10 ,p_start_time in hxc_app_period_summary.start_time%type
11 ,p_stop_time in hxc_app_period_summary.stop_time%type
12 ,p_resource_id in hxc_app_period_summary.resource_id%type
13 ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14 ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15 ,p_creation_date in hxc_app_period_summary.creation_date%type
16 ,p_notification_status in hxc_app_period_summary.notification_status%type
17 ,p_approver_id in hxc_app_period_summary.approver_id%type
18 ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19 ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
20 ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
21 ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
22 ,p_data_set_id in hxc_app_period_summary.data_set_id%type
23 );
24
25 procedure insert_summary_row
26 (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
27 ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
28 ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
29 ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type);
30
31 procedure update_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
32 ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
33 ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
34 ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
35 ) ;
36
37
38 procedure delete_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type);
39
40 end hxc_app_period_summary_pkg;