APPS.JTF_TASKS_PVT dependencies on JTF_TASK_REFERENCES_B

Line 1109: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE;

1105: l_task_assignment_id jtf_task_assignments.task_assignment_id%TYPE;
1106: l_category_id jtf_task_assignments.category_id%TYPE := p_category_id;
1107: l_owner_status_id jtf_task_assignments.assignment_status_id%TYPE;
1108: l_show_on_calendar jtf_task_assignments.show_on_calendar%TYPE;
1109: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE;
1110: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
1111: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
1112: x_event_return_status VARCHAR2(100);
1113: -- Booking enhancement

Line 3307: FROM jtf_task_references_b

3303:
3304: CURSOR c_ref(b_task_id jtf_tasks_b.task_id%TYPE, b_source_id hz_parties.party_id%TYPE) IS
3305: SELECT task_reference_id
3306: , object_version_number
3307: FROM jtf_task_references_b
3308: WHERE task_id = b_task_id AND object_id = b_source_id;
3309:
3310: l_orig_source_id jtf_tasks_b.source_object_id%TYPE;
3311: l_orig_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

Line 3314: l_obj_version_number jtf_task_references_b.object_version_number%TYPE;

3310: l_orig_source_id jtf_tasks_b.source_object_id%TYPE;
3311: l_orig_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
3312: l_entity jtf_tasks_b.entity%TYPE;
3313: l_orig_open_flag jtf_tasks_b.open_flag%TYPE;
3314: l_obj_version_number jtf_task_references_b.object_version_number%TYPE;
3315: l_task_ref_id jtf_task_references_b.task_reference_id%TYPE;
3316:
3317: CURSOR c_del_contacts(c_task_id jtf_tasks_b.task_id%TYPE) IS
3318: SELECT task_contact_id

Line 3315: l_task_ref_id jtf_task_references_b.task_reference_id%TYPE;

3311: l_orig_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
3312: l_entity jtf_tasks_b.entity%TYPE;
3313: l_orig_open_flag jtf_tasks_b.open_flag%TYPE;
3314: l_obj_version_number jtf_task_references_b.object_version_number%TYPE;
3315: l_task_ref_id jtf_task_references_b.task_reference_id%TYPE;
3316:
3317: CURSOR c_del_contacts(c_task_id jtf_tasks_b.task_id%TYPE) IS
3318: SELECT task_contact_id
3319: , contact_id