114:
115:
116:
117: procedure cancel_previous_notifications
118: (p_app_bb_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
119: ,p_app_bb_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
120: );
121:
122: -- Bug 3390666 ,3855544
115:
116:
117: procedure cancel_previous_notifications
118: (p_app_bb_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
119: ,p_app_bb_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
120: );
121:
122: -- Bug 3390666 ,3855544
123: function get_login(
125: p_user_id IN NUMBER DEFAULT NULL)
126: return varchar2;
127:
128: PROCEDURE cancel_previous_notifications(
129: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
130: );
131:
132: PROCEDURE find_project_manager(
133: p_itemtype in varchar2,