[Home] [Help]
121: )
122: RETURN PLS_INTEGER;
123:
124: FUNCTION get_deposit_process_id (
125: p_deposit_process_name IN hxc_deposit_processes.NAME%TYPE
126: )
127: RETURN hxc_deposit_processes.deposit_process_id%TYPE;
128:
129: FUNCTION get_index_in_attr_table (
123:
124: FUNCTION get_deposit_process_id (
125: p_deposit_process_name IN hxc_deposit_processes.NAME%TYPE
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,
135: -- ARR: Next two procedures add p_clear_mapping_cache for update case
136: PROCEDURE get_timecard_tables (
137: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
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,
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: );
152: );
153:
154: PROCEDURE get_bld_blk_info_type (
155: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
156: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
157: p_bld_blk_info_type OUT NOCOPY hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
158: p_segment OUT NOCOPY hxc_mapping_components.SEGMENT%TYPE
159: );
160: