2: /* $Header: hxthcrtp.pkh 120.4.12020000.1 2012/06/27 09:55:44 appldev ship $ */
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: -- Bug 7557568
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: -- Bug 7557568
11: -- Added the following record type to process deleted details.
12: TYPE DETAIL_REC IS RECORD
31: g_an_id VARCHARTAB;
32: g_alias_id NUMBER;
33:
34: PROCEDURE synchronize_deletes_in_otlr
35: (p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
36: ,p_time_att_info IN hxc_self_Service_time_deposit.app_attributes_info
37: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
38: ,p_timecard_source IN VARCHAR -- added for 5137310
39: );
32: g_alias_id NUMBER;
33:
34: PROCEDURE synchronize_deletes_in_otlr
35: (p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
36: ,p_time_att_info IN hxc_self_Service_time_deposit.app_attributes_info
37: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
38: ,p_timecard_source IN VARCHAR -- added for 5137310
39: );
40:
33:
34: PROCEDURE synchronize_deletes_in_otlr
35: (p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
36: ,p_time_att_info IN hxc_self_Service_time_deposit.app_attributes_info
37: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
38: ,p_timecard_source IN VARCHAR -- added for 5137310
39: );
40:
41: PROCEDURE otm_validate_process
45: ,p_messages IN OUT NOCOPY VARCHAR2);
46: --
47: PROCEDURE validate_timecard
48: (p_operation IN VARCHAR2
49: ,p_time_building_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
50: ,p_time_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
51: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE);
52: --
53: Procedure otlr_validation_required
46: --
47: PROCEDURE validate_timecard
48: (p_operation IN VARCHAR2
49: ,p_time_building_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
50: ,p_time_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
51: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE);
52: --
53: Procedure otlr_validation_required
54: (p_operation in varchar2
47: PROCEDURE validate_timecard
48: (p_operation IN VARCHAR2
49: ,p_time_building_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
50: ,p_time_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
51: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE);
52: --
53: Procedure otlr_validation_required
54: (p_operation in varchar2
55: ,p_otm_explosion in varchar2
56: ,p_otm_rtr_id in number
57: ,p_app_set_id in number
58: ,p_timecard_id in number
59: ,p_timecard_ovn in number
60: ,p_time_building_blocks in hxc_self_service_time_deposit.timecard_info
61: ,p_time_att_info in hxc_self_Service_time_deposit.app_attributes_info
62: ,p_messages in out nocopy hxc_self_service_time_deposit.message_table
63: );
64: --
57: ,p_app_set_id in number
58: ,p_timecard_id in number
59: ,p_timecard_ovn in number
60: ,p_time_building_blocks in hxc_self_service_time_deposit.timecard_info
61: ,p_time_att_info in hxc_self_Service_time_deposit.app_attributes_info
62: ,p_messages in out nocopy hxc_self_service_time_deposit.message_table
63: );
64: --
65: PROCEDURE otlr_review_details(
58: ,p_timecard_id in number
59: ,p_timecard_ovn in number
60: ,p_time_building_blocks in hxc_self_service_time_deposit.timecard_info
61: ,p_time_att_info in hxc_self_Service_time_deposit.app_attributes_info
62: ,p_messages in out nocopy hxc_self_service_time_deposit.message_table
63: );
64: --
65: PROCEDURE otlr_review_details(
66: p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
62: ,p_messages in out nocopy hxc_self_service_time_deposit.message_table
63: );
64: --
65: PROCEDURE otlr_review_details(
66: p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
67: ,p_time_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
68: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
69: ,p_detail_build_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
70: ,p_detail_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info);
63: );
64: --
65: PROCEDURE otlr_review_details(
66: p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
67: ,p_time_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
68: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
69: ,p_detail_build_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
70: ,p_detail_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info);
71: --
64: --
65: PROCEDURE otlr_review_details(
66: p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
67: ,p_time_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
68: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
69: ,p_detail_build_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
70: ,p_detail_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info);
71: --
72: FUNCTION build_attributes(
65: PROCEDURE otlr_review_details(
66: p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
67: ,p_time_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
68: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
69: ,p_detail_build_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
70: ,p_detail_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info);
71: --
72: FUNCTION build_attributes(
73: p_detail_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
66: p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
67: ,p_time_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
68: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
69: ,p_detail_build_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
70: ,p_detail_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info);
71: --
72: FUNCTION build_attributes(
73: p_detail_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
74: )
69: ,p_detail_build_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
70: ,p_detail_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info);
71: --
72: FUNCTION build_attributes(
73: p_detail_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
74: )
75: RETURN HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info;
76: --
77:
71: --
72: FUNCTION build_attributes(
73: p_detail_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
74: )
75: RETURN HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info;
76: --
77:
78: -- Bug 8486310
79: -- Added new procedure to save Alt Name Identifiers.
81:
82: -- Bug 7557568
83: -- Added the following function to check if a detail is deleted
84: -- after a SAVE.
85: PROCEDURE check_restrict_edit( p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info,
86: p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.message_table );
87:
88:
89:
82: -- Bug 7557568
83: -- Added the following function to check if a detail is deleted
84: -- after a SAVE.
85: PROCEDURE check_restrict_edit( p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info,
86: p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.message_table );
87:
88:
89:
90: END hxt_hxc_retrieval_process;