APPS.JTF_TASKS_PVT dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 5: g_free_busy_type CONSTANT jtf_task_all_assignments.free_busy_type%TYPE := 'FREE';

1: PACKAGE BODY jtf_tasks_pvt AS
2: /* $Header: jtfvtktb.pls 120.18.12010000.2 2008/09/08 06:28:58 lokumar ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_TASKS_PVT';
4: g_entity CONSTANT jtf_tasks_b.entity%TYPE := 'TASK';
5: g_free_busy_type CONSTANT jtf_task_all_assignments.free_busy_type%TYPE := 'FREE';
6: v_select VARCHAR2(6000);
7: -- table for query_task
8: v_tbl jtf_tasks_pub.task_table_type;
9: -- table for query_task

Line 1115: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE := p_free_busy_type;

1111: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
1112: x_event_return_status VARCHAR2(100);
1113: -- Booking enhancement
1114: l_entity jtf_tasks_b.entity%TYPE := p_entity;
1115: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE := p_free_busy_type;
1116: l_open_flag VARCHAR2(1);
1117: l_task_confirmation_status jtf_tasks_b.task_confirmation_status%TYPE := p_task_confirmation_status;
1118: l_res_type jtf_task_rsc_reqs.resource_type_code%TYPE;
1119: l_req_units jtf_task_rsc_reqs.required_units%TYPE;

Line 3007: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE;

3003: l_calendar_end_date jtf_tasks_b.calendar_end_date%TYPE;
3004: l_date_selected jtf_tasks_b.date_selected%TYPE;
3005: l_owner_status_id jtf_task_assignments.assignment_status_id%TYPE;
3006: l_show_on_calendar jtf_task_assignments.show_on_calendar%TYPE;
3007: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE;
3008: l_task_confirmation_status jtf_tasks_b.task_confirmation_status%TYPE;
3009: l_task_confirmation_counter jtf_tasks_b.task_confirmation_counter%TYPE;
3010: l_task_split_flag jtf_tasks_b.task_split_flag%TYPE;
3011: l_enable_workflow VARCHAR2(1) := p_enable_workflow;

Line 3255: FROM jtf_task_all_assignments

3251: , DECODE(l_owner_status_id, fnd_api.g_miss_num, assignment_status_id, l_owner_status_id) assignment_status_id
3252: , DECODE(l_show_on_calendar, fnd_api.g_miss_char, show_on_calendar, l_show_on_calendar) show_on_calendar
3253: , DECODE(p_category_id, jtf_task_utl.g_miss_number, category_id, p_category_id) category_id
3254: , DECODE(p_free_busy_type, jtf_task_utl.g_miss_char, free_busy_type, p_free_busy_type) free_busy_type
3255: FROM jtf_task_all_assignments
3256: WHERE assignee_role = 'OWNER' AND task_id = b_task_id;
3257:
3258: task_ass_rec task_ass_u%ROWTYPE;
3259:

Line 3279: FROM jtf_task_all_assignments

3275: , actual_effort_uom
3276: , actual_travel_duration
3277: , actual_travel_duration_uom
3278: , assignee_role
3279: FROM jtf_task_all_assignments
3280: WHERE task_id = b_task_id
3281: ORDER BY assignee_role DESC;
3282:
3283: task_ass_orig_rec task_ass_orig%ROWTYPE;

Line 3285: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;

3281: ORDER BY assignee_role DESC;
3282:
3283: task_ass_orig_rec task_ass_orig%ROWTYPE;
3284: -- added for Bug 6031383
3285: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
3286: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
3287:
3288: CURSOR task_cust_orig(b_task_id IN NUMBER) IS
3289: SELECT customer_id

Line 3286: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;

3282:
3283: task_ass_orig_rec task_ass_orig%ROWTYPE;
3284: -- added for Bug 6031383
3285: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
3286: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
3287:
3288: CURSOR task_cust_orig(b_task_id IN NUMBER) IS
3289: SELECT customer_id
3290: FROM jtf_tasks_b

Line 4102: UPDATE jtf_task_all_assignments

4098: , x_booking_start_date => l_booking_start_date
4099: , x_booking_end_date => l_booking_end_date
4100: );
4101:
4102: UPDATE jtf_task_all_assignments
4103: SET booking_start_date = l_booking_start_date
4104: , booking_end_date = l_booking_end_date
4105: WHERE task_assignment_id = task_ass_orig_rec.task_assignment_id;
4106: END IF;

Line 4438: FROM jtf_task_all_assignments

4434:
4435: CURSOR c_assignments IS
4436: SELECT task_assignment_id
4437: , object_version_number
4438: FROM jtf_task_all_assignments
4439: WHERE task_id = l_task_id;
4440:
4441: -- Added to fix Bug # 2503657
4442: CURSOR c_contacts IS