[Home] [Help]
1: package hxc_timecard_summary_pkg AUTHID CURRENT_USER as
2: /* $Header: hxctcsum.pkh 120.1 2010/05/26 08:07:59 asrajago ship $ */
3:
4: c_normal_mode CONSTANT VARCHAR2(6) := 'NORMAL';
5: c_migration_mode CONSTANT VARCHAR2(9) := 'MIGRATION';
60: ,p_tk_audit_item_key in varchar2
61: );
62:
63: procedure update_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
64: ,p_approval_item_type in hxc_timecard_summary.approval_item_type%type
65: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type
66: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type
67: );
68:
61: );
62:
63: procedure update_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
64: ,p_approval_item_type in hxc_timecard_summary.approval_item_type%type
65: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type
66: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type
67: );
68:
69: procedure delete_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);
62:
63: procedure update_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
64: ,p_approval_item_type in hxc_timecard_summary.approval_item_type%type
65: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type
66: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type
67: );
68:
69: procedure delete_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);
70:
87: p_timecard_ovn IN NUMBER,
88: p_process_id IN NUMBER );
89:
90:
91: end hxc_timecard_summary_pkg;