64: )
65: RETURN hxc_deposit_wrapper_utilities.t_transaction;
66:
67: FUNCTION convert_tbb_to_type (
68: p_blocks IN hxc_self_service_time_deposit.timecard_info
69: )
70: RETURN hxc_block_table_type;
71:
72: PROCEDURE convert_app_attributes_to_type (
70: RETURN hxc_block_table_type;
71:
72: PROCEDURE convert_app_attributes_to_type (
73: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
74: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
75: );
76:
77: FUNCTION convert_to_dpwr_messages (p_messages IN hxc_message_table_type)
78: RETURN hxc_self_service_time_deposit.message_table;
74: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
75: );
76:
77: FUNCTION convert_to_dpwr_messages (p_messages IN hxc_message_table_type)
78: RETURN hxc_self_service_time_deposit.message_table;
79:
80: -- NOT USED
81: /* FUNCTION convert_msg_to_type (
82: p_messages IN hxc_self_service_time_deposit.message_table
78: RETURN hxc_self_service_time_deposit.message_table;
79:
80: -- NOT USED
81: /* FUNCTION convert_msg_to_type (
82: p_messages IN hxc_self_service_time_deposit.message_table
83: )
84: RETURN hxc_message_table_type; */
85: FUNCTION get_approval_status (p_mode IN VARCHAR2)
86: RETURN VARCHAR2;
99: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
100: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
101: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
102: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
103: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
104: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
105: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
106: );
107:
126: )
127: RETURN hxc_deposit_processes.deposit_process_id%TYPE;
128:
129: FUNCTION get_index_in_attr_table (
130: p_attr_table IN hxc_self_service_time_deposit.app_attributes_info,
131: p_attr_id_to_find IN hxc_time_attributes.time_attribute_id%TYPE,
132: p_attribute_name_to_find IN hxc_mapping_components.field_name%TYPE
133: )
134: RETURN PLS_INTEGER;
138: -- p_time_recipient_id IN NUMBER,
139: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
140: p_clear_mapping_cache IN BOOLEAN default false,
141: p_app_blocks OUT NOCOPY hxc_block_table_type,
142: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
143: );
144:
145: PROCEDURE get_timecard_tables (
146: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
146: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
147: -- p_time_recipient_id IN NUMBER,
148: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
149: p_clear_mapping_cache IN BOOLEAN default false,
150: p_app_blocks OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
151: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
152: );
153:
154: PROCEDURE get_bld_blk_info_type (
147: -- p_time_recipient_id IN NUMBER,
148: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
149: p_clear_mapping_cache IN BOOLEAN default false,
150: p_app_blocks OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
151: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
152: );
153:
154: PROCEDURE get_bld_blk_info_type (
155: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
162: p_app_blocks IN OUT NOCOPY hxc_block_table_type
163: );
164:
165: PROCEDURE clear_attribute_table (
166: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
167: );
168:
169: PROCEDURE clear_message_table (
170: p_messages IN OUT NOCOPY hxc_message_table_type
185: );
186:
187: PROCEDURE log_timecard (
188: p_app_blocks IN hxc_block_table_type,
189: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
190: );
191:
192: PROCEDURE log_timecard (
193: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
189: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
190: );
191:
192: PROCEDURE log_timecard (
193: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
194: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
195: );
196:
197: PROCEDURE log_messages (p_messages IN hxc_message_table_type);
190: );
191:
192: PROCEDURE log_timecard (
193: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
194: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
195: );
196:
197: PROCEDURE log_messages (p_messages IN hxc_message_table_type);
198:
196:
197: PROCEDURE log_messages (p_messages IN hxc_message_table_type);
198:
199: PROCEDURE log_messages (
200: p_messages IN hxc_self_service_time_deposit.message_table
201: );
202:
203: FUNCTION translate_message_table (
204: p_messages IN hxc_self_service_time_deposit.message_table
200: p_messages IN hxc_self_service_time_deposit.message_table
201: );
202:
203: FUNCTION translate_message_table (
204: p_messages IN hxc_self_service_time_deposit.message_table
205: )
206: RETURN translated_message_table;
207:
208: PROCEDURE find_current_period (