DBA Data[Home] [Help]

APPS.OKC_TASK_PVT dependencies on JTF_TASKS_V

Line 649: l_task_status_name jtf_tasks_v.task_status%TYPE;

645: ,x_return_status OUT NOCOPY VARCHAR2
646: ,x_msg_count OUT NOCOPY NUMBER
647: ,x_msg_data OUT NOCOPY VARCHAR2) IS
648: l_api_name CONSTANT VARCHAR2(30) := 'update_task';
649: l_task_status_name jtf_tasks_v.task_status%TYPE;
650: l_task_status_id jtf_tasks_v.task_status_id%TYPE;
651: l_close_status_id jtf_tasks_v.task_status_id%TYPE;
652: l_open_status_id jtf_tasks_v.task_status_id%TYPE;
653: l_close_status_name jtf_tasks_v.task_status%TYPE;

Line 650: l_task_status_id jtf_tasks_v.task_status_id%TYPE;

646: ,x_msg_count OUT NOCOPY NUMBER
647: ,x_msg_data OUT NOCOPY VARCHAR2) IS
648: l_api_name CONSTANT VARCHAR2(30) := 'update_task';
649: l_task_status_name jtf_tasks_v.task_status%TYPE;
650: l_task_status_id jtf_tasks_v.task_status_id%TYPE;
651: l_close_status_id jtf_tasks_v.task_status_id%TYPE;
652: l_open_status_id jtf_tasks_v.task_status_id%TYPE;
653: l_close_status_name jtf_tasks_v.task_status%TYPE;
654: l_open_status_name jtf_tasks_v.task_status%TYPE;

Line 651: l_close_status_id jtf_tasks_v.task_status_id%TYPE;

647: ,x_msg_data OUT NOCOPY VARCHAR2) IS
648: l_api_name CONSTANT VARCHAR2(30) := 'update_task';
649: l_task_status_name jtf_tasks_v.task_status%TYPE;
650: l_task_status_id jtf_tasks_v.task_status_id%TYPE;
651: l_close_status_id jtf_tasks_v.task_status_id%TYPE;
652: l_open_status_id jtf_tasks_v.task_status_id%TYPE;
653: l_close_status_name jtf_tasks_v.task_status%TYPE;
654: l_open_status_name jtf_tasks_v.task_status%TYPE;
655: l_source_object_id jtf_tasks_b.source_object_id%TYPE;

Line 652: l_open_status_id jtf_tasks_v.task_status_id%TYPE;

648: l_api_name CONSTANT VARCHAR2(30) := 'update_task';
649: l_task_status_name jtf_tasks_v.task_status%TYPE;
650: l_task_status_id jtf_tasks_v.task_status_id%TYPE;
651: l_close_status_id jtf_tasks_v.task_status_id%TYPE;
652: l_open_status_id jtf_tasks_v.task_status_id%TYPE;
653: l_close_status_name jtf_tasks_v.task_status%TYPE;
654: l_open_status_name jtf_tasks_v.task_status%TYPE;
655: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
656: l_source_object_name jtf_tasks_b.source_object_name%TYPE;

Line 653: l_close_status_name jtf_tasks_v.task_status%TYPE;

649: l_task_status_name jtf_tasks_v.task_status%TYPE;
650: l_task_status_id jtf_tasks_v.task_status_id%TYPE;
651: l_close_status_id jtf_tasks_v.task_status_id%TYPE;
652: l_open_status_id jtf_tasks_v.task_status_id%TYPE;
653: l_close_status_name jtf_tasks_v.task_status%TYPE;
654: l_open_status_name jtf_tasks_v.task_status%TYPE;
655: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
656: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
657:

Line 654: l_open_status_name jtf_tasks_v.task_status%TYPE;

650: l_task_status_id jtf_tasks_v.task_status_id%TYPE;
651: l_close_status_id jtf_tasks_v.task_status_id%TYPE;
652: l_open_status_id jtf_tasks_v.task_status_id%TYPE;
653: l_close_status_name jtf_tasks_v.task_status%TYPE;
654: l_open_status_name jtf_tasks_v.task_status%TYPE;
655: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
656: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
657:
658: -- Replaced name with seeded ids to avoid translation issues - Bug 1683539