2050:
2051: PROCEDURE process_extension_func2(
2052: p_tc_id IN hxc_time_building_blocks.time_building_block_id%TYPE
2053: ,p_tc_ovn IN hxc_time_building_blocks.object_version_number%TYPE
2054: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE
2055: ,p_ext_func2 IN hxc_time_recipients.extension_function2%TYPE
2056: ,p_previous_approver IN NUMBER
2057: ,p_next_approver OUT NOCOPY NUMBER
2058: )
2051: PROCEDURE process_extension_func2(
2052: p_tc_id IN hxc_time_building_blocks.time_building_block_id%TYPE
2053: ,p_tc_ovn IN hxc_time_building_blocks.object_version_number%TYPE
2054: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE
2055: ,p_ext_func2 IN hxc_time_recipients.extension_function2%TYPE
2056: ,p_previous_approver IN NUMBER
2057: ,p_next_approver OUT NOCOPY NUMBER
2058: )
2059: IS
2138: is
2139: --
2140: cursor csr_get_extension(p_time_recipient number) is
2141: select htr.extension_function2
2142: from hxc_time_recipients htr
2143: where htr.time_recipient_id = p_time_recipient;
2144:
2145:
2146: