eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASKS_PUB dependencies on JTF_TASK_ALL_ASSIGNMENTS

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

1: PACKAGE BODY jtf_tasks_pub AS
2: /* $Header: jtfptktb.pls 120.15 2008/03/26 09:58:33 venjayar 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(

Line 681: l_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE;

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;

Line 695: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;

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

Line 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'

Line 2954: l_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE;

2950: l_duration jtf_tasks_b.DURATION%TYPE;
2951: l_duration_uom jtf_tasks_b.duration_uom%TYPE;
2952: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
2953: l_owner_id jtf_tasks_b.owner_id%TYPE;
2954: l_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
2955: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2956: l_reason_code jtf_tasks_b.reason_code%TYPE;
2957: l_private_flag jtf_tasks_b.private_flag%TYPE;
2958: l_publish_flag jtf_tasks_b.publish_flag%TYPE;

Line 3189: CURSOR c_owner_status_id(b_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE) IS

3185: WHERE task_id = l_task_id;
3186:
3187: task_rec c_task_update%ROWTYPE;
3188:
3189: CURSOR c_owner_status_id(b_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE) IS
3190: SELECT task_status_id
3191: FROM jtf_task_statuses_b
3192: WHERE task_status_id = b_owner_status_id
3193: --AND assigned_flag = 'Y'

Line 6316: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;

6312: l_source_task_id jtf_tasks_b.task_id%TYPE := p_source_task_id;
6313: l_target_task_id jtf_tasks_b.task_id%TYPE := p_target_task_id;
6314: l_task_number jtf_tasks_b.task_id%TYPE := p_source_task_number;
6315: l_dependency_id jtf_task_depends.dependency_id%TYPE;
6316: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
6317: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;
6318: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE;
6319: l_task_date_id jtf_task_dates.task_date_id%TYPE;
6320: l_recurrence_rule_id jtf_task_recur_rules.recurrence_rule_id%TYPE;

Line 6410: FROM jtf_tasks_vl tk, jtf_task_all_assignments tka

6406: , NVL(tka.show_on_calendar, NULL) show_on_calendar
6407: , NVL(tka.assignment_status_id, NULL) assignment_status_id
6408: , tka.free_busy_type free_busy_type
6409: , tk.entity
6410: FROM jtf_tasks_vl tk, jtf_task_all_assignments tka
6411: WHERE tk.task_id = l_source_task_id AND tk.task_id = tka.task_id(+) AND 'OWNER' = tka.assignee_role(+);
6412:
6413: -- Fetch also assignment details for OWNER, if present, as this is
6414: -- created by the task_create API

Line 6490: FROM jtf_task_all_assignments

6486: , assignee_role
6487: , show_on_calendar
6488: , category_id
6489: , free_busy_type
6490: FROM jtf_task_all_assignments
6491: WHERE task_id = l_source_task_id AND assignee_role = 'ASSIGNEE';
6492:
6493: -- Assignment record for OWNER is created by the task_create API
6494: CURSOR c1_assignments IS

Line 6522: FROM jtf_task_all_assignments

6518: , assignee_role
6519: , show_on_calendar
6520: , category_id
6521: , free_busy_type
6522: FROM jtf_task_all_assignments
6523: WHERE task_id = l_source_task_id AND assignee_role = 'ASSIGNEE';
6524:
6525: CURSOR c_notes(p_source_object_code IN VARCHAR2) IS
6526: SELECT jtf_note_id