1 PACKAGE hxt_hxc_retrieval_process AS
2 /* $Header: hxthcrtp.pkh 120.1 2006/04/10 23:01:09 mbhammar noship $ */
3
4 --
5 g_full_name VARCHAR2(240);
6 g_messages hxc_self_service_time_deposit.message_table;
7 --
8 g_otm_messages hxc_self_service_time_deposit.message_table;
9
10 PROCEDURE synchronize_deletes_in_otlr
11 (p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
12 ,p_time_att_info IN hxc_self_Service_time_deposit.app_attributes_info
13 ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
14 ,p_timecard_source IN VARCHAR -- added for 5137310
15 );
16
17 PROCEDURE otm_validate_process
18 (p_operation IN VARCHAR2
19 ,p_time_building_blocks IN OUT NOCOPY VARCHAR2
20 ,p_time_attributes IN OUT NOCOPY VARCHAR2
21 ,p_messages IN OUT NOCOPY VARCHAR2);
22 --
23 PROCEDURE validate_timecard
24 (p_operation IN VARCHAR2
25 ,p_time_building_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
26 ,p_time_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
27 ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE);
28 --
29 Procedure otlr_validation_required
30 (p_operation in varchar2
31 ,p_otm_explosion in varchar2
32 ,p_otm_rtr_id in number
33 ,p_app_set_id in number
34 ,p_timecard_id in number
35 ,p_timecard_ovn in number
36 ,p_time_building_blocks in hxc_self_service_time_deposit.timecard_info
37 ,p_time_att_info in hxc_self_Service_time_deposit.app_attributes_info
38 ,p_messages in out nocopy hxc_self_service_time_deposit.message_table
39 );
40 --
41 PROCEDURE otlr_review_details(
42 p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
43 ,p_time_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
44 ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
45 ,p_detail_build_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
46 ,p_detail_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info);
47 --
48 FUNCTION build_attributes(
49 p_detail_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
50 )
51 RETURN HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info;
52 --
53 END hxt_hxc_retrieval_process;
54