[Home] [Help]
1: PACKAGE BODY jtf_tasks_pub AS
2: /* $Header: jtfptktb.pls 120.17 2009/09/07 13:15:43 anangupt ship $ */
3: g_entity CONSTANT jtf_tasks_b.entity%TYPE := 'TASK';
4: g_free_busy_type CONSTANT jtf_task_all_assignments.free_busy_type%TYPE := 'FREE';
5:
6: -- new version without table type parameters
7: -- Remove the fix of Bug 2152549
8: PROCEDURE create_task(
677: l_costs jtf_tasks_b.costs%TYPE := p_costs;
678: l_currency_code jtf_tasks_b.currency_code%TYPE := p_currency_code;
679: y BOOLEAN;
680: l_date_selected jtf_tasks_b.date_selected%TYPE;
681: l_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
682: l_type VARCHAR2(10);
683: l_msg_data VARCHAR2(2000); -- debug
684: l_task_id jtf_tasks_b.task_id%TYPE;
685: l_notes_id NUMBER;
691: /*** Start: Added a local variable to fix bug 2107464 ***/
692: l_task_contact_id jtf_task_contacts.task_contact_id%TYPE;
693: /*** End: Added a local variable to fix bug 2107464 ***/
694: l_task_date_id jtf_task_dates.task_date_id%TYPE;
695: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
696: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE;
697: current_record INTEGER;
698:
699: CURSOR c_owner_status_id(b_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE) IS
695: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
696: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE;
697: current_record INTEGER;
698:
699: CURSOR c_owner_status_id(b_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE) IS
700: SELECT task_status_id
701: FROM jtf_task_statuses_b
702: WHERE task_status_id = b_owner_status_id
703: --AND assigned_flag = 'Y'
6287: l_source_task_id jtf_tasks_b.task_id%TYPE := p_source_task_id;
6288: l_target_task_id jtf_tasks_b.task_id%TYPE := p_target_task_id;
6289: l_task_number jtf_tasks_b.task_id%TYPE := p_source_task_number;
6290: l_dependency_id jtf_task_depends.dependency_id%TYPE;
6291: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
6292: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;
6293: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE;
6294: l_task_date_id jtf_task_dates.task_date_id%TYPE;
6295: l_recurrence_rule_id jtf_task_recur_rules.recurrence_rule_id%TYPE;
6381: , NVL(tka.show_on_calendar, NULL) show_on_calendar
6382: , NVL(tka.assignment_status_id, NULL) assignment_status_id
6383: , tka.free_busy_type free_busy_type
6384: , tk.entity
6385: FROM jtf_tasks_vl tk, jtf_task_all_assignments tka
6386: WHERE tk.task_id = l_source_task_id AND tk.task_id = tka.task_id(+) AND 'OWNER' = tka.assignee_role(+);
6387:
6388: -- Fetch also assignment details for OWNER, if present, as this is
6389: -- created by the task_create API
6461: , assignee_role
6462: , show_on_calendar
6463: , category_id
6464: , free_busy_type
6465: FROM jtf_task_all_assignments
6466: WHERE task_id = l_source_task_id AND assignee_role = 'ASSIGNEE';
6467:
6468: -- Assignment record for OWNER is created by the task_create API
6469: CURSOR c1_assignments IS
6493: , assignee_role
6494: , show_on_calendar
6495: , category_id
6496: , free_busy_type
6497: FROM jtf_task_all_assignments
6498: WHERE task_id = l_source_task_id AND assignee_role = 'ASSIGNEE';
6499:
6500: CURSOR c_notes(p_source_object_code IN VARCHAR2) IS
6501: SELECT jtf_note_id