DBA Data[Home] [Help]

APPS.JTF_TASK_WF_UTIL dependencies on JTF_TASK_UTL

Line 435: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number

431:
432: PROCEDURE list_notify_roles(
433: p_event IN VARCHAR2
434: , p_task_id IN VARCHAR2
435: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
436: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
437: , p_new_owner_id IN NUMBER
438: , p_new_owner_code IN VARCHAR2
439: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number

Line 436: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

432: PROCEDURE list_notify_roles(
433: p_event IN VARCHAR2
434: , p_task_id IN VARCHAR2
435: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
436: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
437: , p_new_owner_id IN NUMBER
438: , p_new_owner_code IN VARCHAR2
439: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
440: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 439: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number

435: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
436: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
437: , p_new_owner_id IN NUMBER
438: , p_new_owner_code IN VARCHAR2
439: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
440: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
441: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
442: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
443: ) IS

Line 440: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

436: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
437: , p_new_owner_id IN NUMBER
438: , p_new_owner_code IN VARCHAR2
439: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
440: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
441: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
442: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
443: ) IS
444: CURSOR c_assignees(b_task_id jtf_tasks_b.task_id%TYPE) IS

Line 441: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number

437: , p_new_owner_id IN NUMBER
438: , p_new_owner_code IN VARCHAR2
439: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
440: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
441: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
442: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
443: ) IS
444: CURSOR c_assignees(b_task_id jtf_tasks_b.task_id%TYPE) IS
445: SELECT resource_id

Line 442: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

438: , p_new_owner_code IN VARCHAR2
439: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
440: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
441: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
442: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
443: ) IS
444: CURSOR c_assignees(b_task_id jtf_tasks_b.task_id%TYPE) IS
445: SELECT resource_id
446: , resource_type_code

Line 519: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number

515:
516: PROCEDURE create_notification(
517: p_event IN VARCHAR2
518: , p_task_id IN NUMBER
519: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
520: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
521: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
522: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
523: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number

Line 520: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

516: PROCEDURE create_notification(
517: p_event IN VARCHAR2
518: , p_task_id IN NUMBER
519: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
520: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
521: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
522: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
523: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
524: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 521: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number

517: p_event IN VARCHAR2
518: , p_task_id IN NUMBER
519: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
520: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
521: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
522: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
523: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
524: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
525: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number

Line 522: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

518: , p_task_id IN NUMBER
519: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
520: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
521: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
522: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
523: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
524: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
525: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
526: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number

Line 523: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number

519: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
520: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
521: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
522: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
523: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
524: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
525: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
526: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
527: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number

Line 524: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

520: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
521: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
522: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
523: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
524: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
525: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
526: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
527: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
528: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date

Line 525: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number

521: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
522: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
523: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
524: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
525: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
526: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
527: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
528: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
529: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date

Line 526: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number

522: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
523: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
524: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
525: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
526: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
527: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
528: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
529: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
530: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date

Line 527: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number

523: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
524: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
525: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
526: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
527: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
528: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
529: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
530: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
531: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date

Line 528: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date

524: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
525: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
526: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
527: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
528: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
529: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
530: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
531: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
532: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date

Line 529: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date

525: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
526: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
527: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
528: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
529: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
530: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
531: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
532: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
533: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date

Line 530: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date

526: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
527: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
528: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
529: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
530: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
531: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
532: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
533: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
534: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 531: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date

527: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
528: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
529: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
530: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
531: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
532: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
533: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
534: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
535: , p_abort_workflow IN VARCHAR2 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')

Line 532: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date

528: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
529: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
530: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
531: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
532: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
533: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
534: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
535: , p_abort_workflow IN VARCHAR2 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
536: , x_return_status OUT NOCOPY VARCHAR2

Line 533: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date

529: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
530: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
531: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
532: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
533: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
534: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
535: , p_abort_workflow IN VARCHAR2 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
536: , x_return_status OUT NOCOPY VARCHAR2
537: , x_msg_count OUT NOCOPY NUMBER

Line 534: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

530: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
531: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
532: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
533: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
534: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
535: , p_abort_workflow IN VARCHAR2 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
536: , x_return_status OUT NOCOPY VARCHAR2
537: , x_msg_count OUT NOCOPY NUMBER
538: , x_msg_data OUT NOCOPY VARCHAR2

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

690: IF p_event = 'CHANGE_TASK_DETAILS' THEN
691: l_old_desc := NVL(p_old_description, l_not_entered);
692:
693: -- Task Type
694: IF p_old_type NOT IN(l_task_rec.task_type_id, jtf_task_utl.g_miss_number) THEN
695: OPEN c_type_name(p_old_type);
696: FETCH c_type_name INTO l_old_type_name;
697: IF c_type_name%NOTFOUND THEN
698: l_old_type_name := NULL;

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

715: IF p_old_priority IS NULL THEN
716: IF l_task_rec.task_priority_id IS NOT NULL THEN
717: l_task_rec.task_priority_name := l_task_rec.task_priority_name || ' (' || l_not_entered || ')';
718: END IF;
719: ELSIF p_old_priority NOT IN(NVL(l_task_rec.task_priority_id, 0), jtf_task_utl.g_miss_number) THEN
720: OPEN c_priority_name(p_old_priority);
721: FETCH c_priority_name INTO l_old_priority_name;
722: IF c_priority_name%NOTFOUND THEN
723: l_old_priority_name := NULL;

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

727: l_task_rec.task_priority_name := l_task_rec.task_priority_name || ' (' || l_old_priority_name || ')';
728: END IF;
729:
730: -- Task Status
731: IF p_old_status NOT IN(l_task_rec.task_status_id, jtf_task_utl.g_miss_number) THEN
732: OPEN c_status_name(p_old_status);
733: FETCH c_status_name INTO l_old_status_name;
734: IF c_status_name%NOTFOUND THEN
735: l_old_status_name := NULL;

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

745: --l_task_rec.task_status_name := l_task_rec.task_status_name || ' (' || l_old_status_name || ')';
746: END IF;
747:
748: -- Planned Start Date
749: IF (p_old_planned_start_date NOT IN (l_task_rec.planned_start_date, jtf_task_utl.g_miss_date))
750: OR (p_old_planned_start_date IS NULL AND l_task_rec.planned_start_date IS NOT NULL)
751: THEN
752: IF p_old_planned_start_date IS NULL THEN
753: l_old_date := l_not_entered;

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

763: l_pln_start_change_text := l_pln_start_change_text || ' (' || l_old_date || ')';
764: END IF;
765:
766: -- Planned End Date
767: IF (p_old_planned_end_date NOT IN (l_task_rec.planned_end_date, jtf_task_utl.g_miss_date))
768: OR (p_old_planned_end_date IS NULL AND l_task_rec.planned_end_date IS NOT NULL)
769: THEN
770: IF p_old_planned_end_date IS NULL THEN
771: l_old_date := l_not_entered;

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

781: l_pln_end_change_text := l_pln_end_change_text || ' (' || l_old_date || ')';
782: END IF;
783:
784: -- Scheduled Start Date
785: IF ( p_old_scheduled_start_date NOT IN (l_task_rec.scheduled_start_date, jtf_task_utl.g_miss_date) )
786: OR (p_old_scheduled_start_date IS NULL AND l_task_rec.scheduled_start_date IS NOT NULL)
787: THEN
788: IF p_old_scheduled_start_date IS NULL THEN
789: l_old_date := l_not_entered;

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

799: l_sch_start_change_text := l_sch_start_change_text || ' (' || l_old_date || ')';
800: END IF;
801:
802: -- Scheduled End Date
803: IF ( p_old_scheduled_end_date NOT IN (l_task_rec.scheduled_end_date, jtf_task_utl.g_miss_date) )
804: OR (p_old_scheduled_end_date IS NULL AND l_task_rec.scheduled_end_date IS NOT NULL)
805: THEN
806: IF p_old_scheduled_end_date IS NULL THEN
807: l_old_date := l_not_entered;

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

817: l_sch_end_change_text := l_sch_end_change_text || ' (' || l_old_date || ')';
818: END IF;
819:
820: -- Actual Start Date
821: IF ( p_old_actual_start_date NOT IN (l_task_rec.actual_start_date, jtf_task_utl.g_miss_date) )
822: OR (p_old_actual_start_date IS NULL AND l_task_rec.actual_start_date IS NOT NULL)
823: THEN
824: IF p_old_actual_start_date IS NULL THEN
825: l_old_date := l_not_entered;

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

830: l_act_start_change_text := l_act_start_change_text || ' (' || l_old_date || ')';
831: END IF;
832:
833: -- Actual End Date
834: IF ( p_old_actual_end_date NOT IN (l_task_rec.actual_end_date, jtf_task_utl.g_miss_date) )
835: OR (p_old_actual_end_date IS NULL AND l_task_rec.actual_end_date IS NOT NULL)
836: THEN
837: IF p_old_actual_end_date IS NULL THEN
838: l_old_date := l_not_entered;