[Home] [Help]
620: l_visit_task_id NUMBER;
621:
622: BEGIN
623:
624: -- Select ahl_task_links_s.nextval into l_task_link_id from dual;
625: -- Validate the values entered by the user
626:
627: IF(P_task_link_rec.visit_task_number is NULL or length(trim(P_task_link_rec.visit_task_number)) = 0 )
628: THEN --Added by tchimira for VWPE 12730539
692: ATTRIBUTE15,
693: PRECEDENCE_CONSTRAINT)
694: values
695: (
696: ahl_task_links_s.nextval,
697: 1,
698: sysdate,
699: fnd_global.user_id,
700: sysdate,