DBA Data[Home] [Help]

APPS.JTF_TASK_WF_UTIL dependencies on JTF_TASK_UTL

Line 402: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number

398:
399: PROCEDURE list_notify_roles(
400: p_event IN VARCHAR2
401: , p_task_id IN VARCHAR2
402: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
403: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
404: , p_new_owner_id IN NUMBER
405: , p_new_owner_code IN VARCHAR2
406: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number

Line 403: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

399: PROCEDURE list_notify_roles(
400: p_event IN VARCHAR2
401: , p_task_id IN VARCHAR2
402: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
403: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
404: , p_new_owner_id IN NUMBER
405: , p_new_owner_code IN VARCHAR2
406: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
407: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 406: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number

402: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
403: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
404: , p_new_owner_id IN NUMBER
405: , p_new_owner_code IN VARCHAR2
406: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
407: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
408: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
409: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
410: ) IS

Line 407: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

403: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
404: , p_new_owner_id IN NUMBER
405: , p_new_owner_code IN VARCHAR2
406: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
407: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
408: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
409: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
410: ) IS
411: CURSOR c_assignees(b_task_id jtf_tasks_b.task_id%TYPE) IS

Line 408: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number

404: , p_new_owner_id IN NUMBER
405: , p_new_owner_code IN VARCHAR2
406: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
407: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
408: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
409: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
410: ) IS
411: CURSOR c_assignees(b_task_id jtf_tasks_b.task_id%TYPE) IS
412: SELECT resource_id

Line 409: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

405: , p_new_owner_code IN VARCHAR2
406: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
407: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
408: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
409: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
410: ) IS
411: CURSOR c_assignees(b_task_id jtf_tasks_b.task_id%TYPE) IS
412: SELECT resource_id
413: , resource_type_code

Line 486: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number

482:
483: PROCEDURE create_notification(
484: p_event IN VARCHAR2
485: , p_task_id IN NUMBER
486: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
487: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
488: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
489: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
490: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number

Line 487: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

483: PROCEDURE create_notification(
484: p_event IN VARCHAR2
485: , p_task_id IN NUMBER
486: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
487: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
488: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
489: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
490: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
491: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 488: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number

484: p_event IN VARCHAR2
485: , p_task_id IN NUMBER
486: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
487: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
488: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
489: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
490: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
491: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
492: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number

Line 489: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

485: , p_task_id IN NUMBER
486: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
487: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
488: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
489: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
490: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
491: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
492: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
493: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number

Line 490: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number

486: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
487: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
488: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
489: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
490: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
491: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
492: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
493: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
494: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number

Line 491: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

487: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
488: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
489: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
490: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
491: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
492: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
493: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
494: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
495: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date

Line 492: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number

488: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
489: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
490: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
491: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
492: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
493: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
494: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
495: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
496: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date

Line 493: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number

489: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
490: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
491: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
492: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
493: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
494: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
495: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
496: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
497: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date

Line 494: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number

490: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
491: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
492: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
493: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
494: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
495: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
496: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
497: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
498: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date

Line 495: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date

491: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
492: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
493: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
494: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
495: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
496: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
497: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
498: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
499: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date

Line 496: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date

492: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
493: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
494: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
495: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
496: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
497: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
498: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
499: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
500: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date

Line 497: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date

493: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
494: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
495: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
496: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
497: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
498: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
499: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
500: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
501: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 498: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date

494: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
495: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
496: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
497: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
498: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
499: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
500: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
501: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
502: , p_abort_workflow IN VARCHAR2 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')

Line 499: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date

495: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
496: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
497: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
498: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
499: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
500: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
501: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
502: , p_abort_workflow IN VARCHAR2 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
503: , x_return_status OUT NOCOPY VARCHAR2

Line 500: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date

496: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
497: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
498: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
499: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
500: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
501: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
502: , p_abort_workflow IN VARCHAR2 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
503: , x_return_status OUT NOCOPY VARCHAR2
504: , x_msg_count OUT NOCOPY NUMBER

Line 501: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

497: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
498: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
499: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
500: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
501: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
502: , p_abort_workflow IN VARCHAR2 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
503: , x_return_status OUT NOCOPY VARCHAR2
504: , x_msg_count OUT NOCOPY NUMBER
505: , x_msg_data OUT NOCOPY VARCHAR2

Line 661: IF p_old_type NOT IN(l_task_rec.task_type_id, jtf_task_utl.g_miss_number) THEN

657: IF p_event = 'CHANGE_TASK_DETAILS' THEN
658: l_old_desc := NVL(p_old_description, l_not_entered);
659:
660: -- Task Type
661: IF p_old_type NOT IN(l_task_rec.task_type_id, jtf_task_utl.g_miss_number) THEN
662: OPEN c_type_name(p_old_type);
663: FETCH c_type_name INTO l_old_type_name;
664: IF c_type_name%NOTFOUND THEN
665: l_old_type_name := NULL;

Line 686: ELSIF p_old_priority NOT IN(NVL(l_task_rec.task_priority_id, 0), jtf_task_utl.g_miss_number) THEN

682: IF p_old_priority IS NULL THEN
683: IF l_task_rec.task_priority_id IS NOT NULL THEN
684: l_task_rec.task_priority_name := l_task_rec.task_priority_name || ' (' || l_not_entered || ')';
685: END IF;
686: ELSIF p_old_priority NOT IN(NVL(l_task_rec.task_priority_id, 0), jtf_task_utl.g_miss_number) THEN
687: OPEN c_priority_name(p_old_priority);
688: FETCH c_priority_name INTO l_old_priority_name;
689: IF c_priority_name%NOTFOUND THEN
690: l_old_priority_name := NULL;

Line 698: IF p_old_status NOT IN(l_task_rec.task_status_id, jtf_task_utl.g_miss_number) THEN

694: l_task_rec.task_priority_name := l_task_rec.task_priority_name || ' (' || l_old_priority_name || ')';
695: END IF;
696:
697: -- Task Status
698: IF p_old_status NOT IN(l_task_rec.task_status_id, jtf_task_utl.g_miss_number) THEN
699: OPEN c_status_name(p_old_status);
700: FETCH c_status_name INTO l_old_status_name;
701: IF c_status_name%NOTFOUND THEN
702: l_old_status_name := NULL;

Line 715: IF (p_old_planned_start_date NOT IN (l_task_rec.planned_start_date, jtf_task_utl.g_miss_date))

711: l_task_rec.task_status_name := l_task_rec.task_status_name || ' (' || l_old_status_name || ')';
712: END IF;
713:
714: -- Planned Start Date
715: IF (p_old_planned_start_date NOT IN (l_task_rec.planned_start_date, jtf_task_utl.g_miss_date))
716: OR (p_old_planned_start_date IS NULL AND l_task_rec.planned_start_date IS NOT NULL)
717: THEN
718: IF p_old_planned_start_date IS NULL THEN
719: l_old_date := l_not_entered;

Line 733: IF (p_old_planned_end_date NOT IN (l_task_rec.planned_end_date, jtf_task_utl.g_miss_date))

729: l_pln_start_change_text := l_pln_start_change_text || ' (' || l_old_date || ')';
730: END IF;
731:
732: -- Planned End Date
733: IF (p_old_planned_end_date NOT IN (l_task_rec.planned_end_date, jtf_task_utl.g_miss_date))
734: OR (p_old_planned_end_date IS NULL AND l_task_rec.planned_end_date IS NOT NULL)
735: THEN
736: IF p_old_planned_end_date IS NULL THEN
737: l_old_date := l_not_entered;

Line 751: IF ( p_old_scheduled_start_date NOT IN (l_task_rec.scheduled_start_date, jtf_task_utl.g_miss_date) )

747: l_pln_end_change_text := l_pln_end_change_text || ' (' || l_old_date || ')';
748: END IF;
749:
750: -- Scheduled Start Date
751: IF ( p_old_scheduled_start_date NOT IN (l_task_rec.scheduled_start_date, jtf_task_utl.g_miss_date) )
752: OR (p_old_scheduled_start_date IS NULL AND l_task_rec.scheduled_start_date IS NOT NULL)
753: THEN
754: IF p_old_scheduled_start_date IS NULL THEN
755: l_old_date := l_not_entered;

Line 769: IF ( p_old_scheduled_end_date NOT IN (l_task_rec.scheduled_end_date, jtf_task_utl.g_miss_date) )

765: l_sch_start_change_text := l_sch_start_change_text || ' (' || l_old_date || ')';
766: END IF;
767:
768: -- Scheduled End Date
769: IF ( p_old_scheduled_end_date NOT IN (l_task_rec.scheduled_end_date, jtf_task_utl.g_miss_date) )
770: OR (p_old_scheduled_end_date IS NULL AND l_task_rec.scheduled_end_date IS NOT NULL)
771: THEN
772: IF p_old_scheduled_end_date IS NULL THEN
773: l_old_date := l_not_entered;

Line 787: IF ( p_old_actual_start_date NOT IN (l_task_rec.actual_start_date, jtf_task_utl.g_miss_date) )

783: l_sch_end_change_text := l_sch_end_change_text || ' (' || l_old_date || ')';
784: END IF;
785:
786: -- Actual Start Date
787: IF ( p_old_actual_start_date NOT IN (l_task_rec.actual_start_date, jtf_task_utl.g_miss_date) )
788: OR (p_old_actual_start_date IS NULL AND l_task_rec.actual_start_date IS NOT NULL)
789: THEN
790: IF p_old_actual_start_date IS NULL THEN
791: l_old_date := l_not_entered;

Line 800: IF ( p_old_actual_end_date NOT IN (l_task_rec.actual_end_date, jtf_task_utl.g_miss_date) )

796: l_act_start_change_text := l_act_start_change_text || ' (' || l_old_date || ')';
797: END IF;
798:
799: -- Actual End Date
800: IF ( p_old_actual_end_date NOT IN (l_task_rec.actual_end_date, jtf_task_utl.g_miss_date) )
801: OR (p_old_actual_end_date IS NULL AND l_task_rec.actual_end_date IS NOT NULL)
802: THEN
803: IF p_old_actual_end_date IS NULL THEN
804: l_old_date := l_not_entered;