123:
124:
125:
126: procedure cancel_previous_notifications
127: (p_app_bb_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
128: ,p_app_bb_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
129: );
130:
131: -- Bug 3390666 ,3855544
124:
125:
126: procedure cancel_previous_notifications
127: (p_app_bb_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
128: ,p_app_bb_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
129: );
130:
131: -- Bug 3390666 ,3855544
132: function get_login(
134: p_user_id IN NUMBER DEFAULT NULL)
135: return varchar2;
136:
137: PROCEDURE cancel_previous_notifications(
138: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
139: );
140:
141: PROCEDURE find_project_manager(
142: p_itemtype in varchar2,