[Home] [Help]
111: )
112: RETURN PLS_INTEGER;
113:
114: FUNCTION get_deposit_process_id (
115: p_deposit_process_name IN hxc_deposit_processes.NAME%TYPE
116: )
117: RETURN hxc_deposit_processes.deposit_process_id%TYPE;
118:
119: FUNCTION get_index_in_attr_table (
113:
114: FUNCTION get_deposit_process_id (
115: p_deposit_process_name IN hxc_deposit_processes.NAME%TYPE
116: )
117: RETURN hxc_deposit_processes.deposit_process_id%TYPE;
118:
119: FUNCTION get_index_in_attr_table (
120: p_attr_table IN hxc_self_service_time_deposit.app_attributes_info,
121: p_attr_id_to_find IN hxc_time_attributes.time_attribute_id%TYPE,
125: -- ARR: Next two procedures add p_clear_mapping_cache for update case
126: PROCEDURE get_timecard_tables (
127: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
128: -- p_time_recipient_id IN NUMBER,
129: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
130: p_clear_mapping_cache IN BOOLEAN default false,
131: p_app_blocks OUT NOCOPY hxc_block_table_type,
132: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
133: );
134:
135: PROCEDURE get_timecard_tables (
136: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
137: -- p_time_recipient_id IN NUMBER,
138: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
139: p_clear_mapping_cache IN BOOLEAN default false,
140: p_app_blocks OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
141: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
142: );
142: );
143:
144: PROCEDURE get_bld_blk_info_type (
145: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
146: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
147: p_bld_blk_info_type OUT NOCOPY hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
148: p_segment OUT NOCOPY hxc_mapping_components.SEGMENT%TYPE
149: );
150: