[Home] [Help]
1: PACKAGE BODY jtf_tasks_pvt AS
2: /* $Header: jtfvtktb.pls 120.22 2010/09/13 07:22:47 anangupt 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
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;
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;
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:
3276: , actual_effort_uom
3277: , actual_travel_duration
3278: , actual_travel_duration_uom
3279: , assignee_role
3280: FROM jtf_task_all_assignments
3281: WHERE task_id = b_task_id
3282: ORDER BY assignee_role DESC;
3283:
3284: task_ass_orig_rec task_ass_orig%ROWTYPE;
3282: ORDER BY assignee_role DESC;
3283:
3284: task_ass_orig_rec task_ass_orig%ROWTYPE;
3285: -- added for Bug 6031383
3286: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
3287: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
3288:
3289: CURSOR task_cust_orig(b_task_id IN NUMBER) IS
3290: SELECT customer_id
3283:
3284: task_ass_orig_rec task_ass_orig%ROWTYPE;
3285: -- added for Bug 6031383
3286: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
3287: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
3288:
3289: CURSOR task_cust_orig(b_task_id IN NUMBER) IS
3290: SELECT customer_id
3291: FROM jtf_tasks_b
3335: l_date VARCHAR2(200);
3336: --BES enh 2391065
3337:
3338: /* moved from pub package*/
3339: CURSOR c_owner_status_id(b_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE) IS
3340: SELECT task_status_id
3341: FROM jtf_task_statuses_b
3342: WHERE task_status_id = b_owner_status_id
3343: --AND assigned_flag = 'Y'
4135: , x_booking_start_date => l_booking_start_date
4136: , x_booking_end_date => l_booking_end_date
4137: );
4138:
4139: UPDATE jtf_task_all_assignments
4140: SET booking_start_date = l_booking_start_date
4141: , booking_end_date = l_booking_end_date
4142: WHERE task_assignment_id = task_ass_orig_rec.task_assignment_id;
4143:
4515:
4516: CURSOR c_assignments IS
4517: SELECT task_assignment_id
4518: , object_version_number
4519: FROM jtf_task_all_assignments
4520: WHERE task_id = l_task_id;
4521:
4522: -- Added to fix Bug # 2503657
4523: CURSOR c_contacts IS