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
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
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: );
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:
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
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
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
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: --
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(
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
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);
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: --
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(
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
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: )
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;
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: