199: IF p_lp_notification_type ='LP_COMPLETE' THEN
200: -- Get the next item key from the sequence
201: select hr_workflow_item_key_s.nextval
202: into l_item_key 203: from sys.dual; 204: ELSE
205: l_item_key := 'LP^' ||p_lp_enrollment_id || '^' || l_lp_details.notify_days_before_target||'^' ||to_char(sysdate,'DDMMRRRR');
206: END IF;
207: