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_PVT dependencies on JTF_TASKS_B

Line 4: g_entity CONSTANT jtf_tasks_b.entity%TYPE := 'TASK';

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;

Line 1076: l_task_number jtf_tasks_b.task_number%TYPE;

1072: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK';
1073:
1074: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1075: l_rowid ROWID;
1076: l_task_number jtf_tasks_b.task_number%TYPE;
1077: l_owner_id jtf_tasks_b.owner_id%TYPE := p_owner_id;
1078: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE := p_owner_type_code;
1079: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;
1080: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;

Line 1077: l_owner_id jtf_tasks_b.owner_id%TYPE := p_owner_id;

1073:
1074: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1075: l_rowid ROWID;
1076: l_task_number jtf_tasks_b.task_number%TYPE;
1077: l_owner_id jtf_tasks_b.owner_id%TYPE := p_owner_id;
1078: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE := p_owner_type_code;
1079: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;
1080: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;
1081: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;

Line 1078: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE := p_owner_type_code;

1074: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1075: l_rowid ROWID;
1076: l_task_number jtf_tasks_b.task_number%TYPE;
1077: l_owner_id jtf_tasks_b.owner_id%TYPE := p_owner_id;
1078: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE := p_owner_type_code;
1079: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;
1080: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;
1081: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;
1082: l_source_object_id jtf_tasks_b.source_object_id%TYPE := p_source_object_id;

Line 1079: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;

1075: l_rowid ROWID;
1076: l_task_number jtf_tasks_b.task_number%TYPE;
1077: l_owner_id jtf_tasks_b.owner_id%TYPE := p_owner_id;
1078: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE := p_owner_type_code;
1079: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;
1080: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;
1081: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;
1082: l_source_object_id jtf_tasks_b.source_object_id%TYPE := p_source_object_id;
1083: ---

Line 1080: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;

1076: l_task_number jtf_tasks_b.task_number%TYPE;
1077: l_owner_id jtf_tasks_b.owner_id%TYPE := p_owner_id;
1078: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE := p_owner_type_code;
1079: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;
1080: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;
1081: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;
1082: l_source_object_id jtf_tasks_b.source_object_id%TYPE := p_source_object_id;
1083: ---
1084: --- to fix bug #2224949

Line 1081: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;

1077: l_owner_id jtf_tasks_b.owner_id%TYPE := p_owner_id;
1078: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE := p_owner_type_code;
1079: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;
1080: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;
1081: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;
1082: l_source_object_id jtf_tasks_b.source_object_id%TYPE := p_source_object_id;
1083: ---
1084: --- to fix bug #2224949
1085: ---

Line 1082: l_source_object_id jtf_tasks_b.source_object_id%TYPE := p_source_object_id;

1078: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE := p_owner_type_code;
1079: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;
1080: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;
1081: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;
1082: l_source_object_id jtf_tasks_b.source_object_id%TYPE := p_source_object_id;
1083: ---
1084: --- to fix bug #2224949
1085: ---
1086: l_source_object_name jtf_tasks_b.source_object_name%TYPE := jtf_task_utl.check_truncation(p_object_name => p_source_object_name);

Line 1086: l_source_object_name jtf_tasks_b.source_object_name%TYPE := jtf_task_utl.check_truncation(p_object_name => p_source_object_name);

1082: l_source_object_id jtf_tasks_b.source_object_id%TYPE := p_source_object_id;
1083: ---
1084: --- to fix bug #2224949
1085: ---
1086: l_source_object_name jtf_tasks_b.source_object_name%TYPE := jtf_task_utl.check_truncation(p_object_name => p_source_object_name);
1087: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_source_object_type_code;
1088: l_duration jtf_tasks_b.DURATION%TYPE := p_duration;
1089: l_duration_uom jtf_tasks_b.duration_uom%TYPE := p_duration_uom;
1090: l_planned_effort jtf_tasks_b.planned_effort%TYPE := p_planned_effort;

Line 1087: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_source_object_type_code;

1083: ---
1084: --- to fix bug #2224949
1085: ---
1086: l_source_object_name jtf_tasks_b.source_object_name%TYPE := jtf_task_utl.check_truncation(p_object_name => p_source_object_name);
1087: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_source_object_type_code;
1088: l_duration jtf_tasks_b.DURATION%TYPE := p_duration;
1089: l_duration_uom jtf_tasks_b.duration_uom%TYPE := p_duration_uom;
1090: l_planned_effort jtf_tasks_b.planned_effort%TYPE := p_planned_effort;
1091: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE := p_planned_effort_uom;

Line 1088: l_duration jtf_tasks_b.DURATION%TYPE := p_duration;

1084: --- to fix bug #2224949
1085: ---
1086: l_source_object_name jtf_tasks_b.source_object_name%TYPE := jtf_task_utl.check_truncation(p_object_name => p_source_object_name);
1087: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_source_object_type_code;
1088: l_duration jtf_tasks_b.DURATION%TYPE := p_duration;
1089: l_duration_uom jtf_tasks_b.duration_uom%TYPE := p_duration_uom;
1090: l_planned_effort jtf_tasks_b.planned_effort%TYPE := p_planned_effort;
1091: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE := p_planned_effort_uom;
1092: l_actual_effort jtf_tasks_b.actual_effort%TYPE := p_actual_effort;

Line 1089: l_duration_uom jtf_tasks_b.duration_uom%TYPE := p_duration_uom;

1085: ---
1086: l_source_object_name jtf_tasks_b.source_object_name%TYPE := jtf_task_utl.check_truncation(p_object_name => p_source_object_name);
1087: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_source_object_type_code;
1088: l_duration jtf_tasks_b.DURATION%TYPE := p_duration;
1089: l_duration_uom jtf_tasks_b.duration_uom%TYPE := p_duration_uom;
1090: l_planned_effort jtf_tasks_b.planned_effort%TYPE := p_planned_effort;
1091: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE := p_planned_effort_uom;
1092: l_actual_effort jtf_tasks_b.actual_effort%TYPE := p_actual_effort;
1093: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE := p_actual_effort_uom;

Line 1090: l_planned_effort jtf_tasks_b.planned_effort%TYPE := p_planned_effort;

1086: l_source_object_name jtf_tasks_b.source_object_name%TYPE := jtf_task_utl.check_truncation(p_object_name => p_source_object_name);
1087: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_source_object_type_code;
1088: l_duration jtf_tasks_b.DURATION%TYPE := p_duration;
1089: l_duration_uom jtf_tasks_b.duration_uom%TYPE := p_duration_uom;
1090: l_planned_effort jtf_tasks_b.planned_effort%TYPE := p_planned_effort;
1091: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE := p_planned_effort_uom;
1092: l_actual_effort jtf_tasks_b.actual_effort%TYPE := p_actual_effort;
1093: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE := p_actual_effort_uom;
1094: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE := p_percentage_complete;

Line 1091: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE := p_planned_effort_uom;

1087: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_source_object_type_code;
1088: l_duration jtf_tasks_b.DURATION%TYPE := p_duration;
1089: l_duration_uom jtf_tasks_b.duration_uom%TYPE := p_duration_uom;
1090: l_planned_effort jtf_tasks_b.planned_effort%TYPE := p_planned_effort;
1091: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE := p_planned_effort_uom;
1092: l_actual_effort jtf_tasks_b.actual_effort%TYPE := p_actual_effort;
1093: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE := p_actual_effort_uom;
1094: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE := p_percentage_complete;
1095: l_reason_code jtf_tasks_b.reason_code%TYPE := p_reason_code;

Line 1092: l_actual_effort jtf_tasks_b.actual_effort%TYPE := p_actual_effort;

1088: l_duration jtf_tasks_b.DURATION%TYPE := p_duration;
1089: l_duration_uom jtf_tasks_b.duration_uom%TYPE := p_duration_uom;
1090: l_planned_effort jtf_tasks_b.planned_effort%TYPE := p_planned_effort;
1091: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE := p_planned_effort_uom;
1092: l_actual_effort jtf_tasks_b.actual_effort%TYPE := p_actual_effort;
1093: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE := p_actual_effort_uom;
1094: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE := p_percentage_complete;
1095: l_reason_code jtf_tasks_b.reason_code%TYPE := p_reason_code;
1096: l_date_selected jtf_tasks_b.date_selected%TYPE;

Line 1093: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE := p_actual_effort_uom;

1089: l_duration_uom jtf_tasks_b.duration_uom%TYPE := p_duration_uom;
1090: l_planned_effort jtf_tasks_b.planned_effort%TYPE := p_planned_effort;
1091: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE := p_planned_effort_uom;
1092: l_actual_effort jtf_tasks_b.actual_effort%TYPE := p_actual_effort;
1093: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE := p_actual_effort_uom;
1094: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE := p_percentage_complete;
1095: l_reason_code jtf_tasks_b.reason_code%TYPE := p_reason_code;
1096: l_date_selected jtf_tasks_b.date_selected%TYPE;
1097: l_calendar_start_date jtf_tasks_b.calendar_start_date%TYPE;

Line 1094: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE := p_percentage_complete;

1090: l_planned_effort jtf_tasks_b.planned_effort%TYPE := p_planned_effort;
1091: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE := p_planned_effort_uom;
1092: l_actual_effort jtf_tasks_b.actual_effort%TYPE := p_actual_effort;
1093: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE := p_actual_effort_uom;
1094: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE := p_percentage_complete;
1095: l_reason_code jtf_tasks_b.reason_code%TYPE := p_reason_code;
1096: l_date_selected jtf_tasks_b.date_selected%TYPE;
1097: l_calendar_start_date jtf_tasks_b.calendar_start_date%TYPE;
1098: l_calendar_end_date jtf_tasks_b.calendar_end_date%TYPE;

Line 1095: l_reason_code jtf_tasks_b.reason_code%TYPE := p_reason_code;

1091: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE := p_planned_effort_uom;
1092: l_actual_effort jtf_tasks_b.actual_effort%TYPE := p_actual_effort;
1093: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE := p_actual_effort_uom;
1094: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE := p_percentage_complete;
1095: l_reason_code jtf_tasks_b.reason_code%TYPE := p_reason_code;
1096: l_date_selected jtf_tasks_b.date_selected%TYPE;
1097: l_calendar_start_date jtf_tasks_b.calendar_start_date%TYPE;
1098: l_calendar_end_date jtf_tasks_b.calendar_end_date%TYPE;
1099: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE := p_planned_start_date;

Line 1096: l_date_selected jtf_tasks_b.date_selected%TYPE;

1092: l_actual_effort jtf_tasks_b.actual_effort%TYPE := p_actual_effort;
1093: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE := p_actual_effort_uom;
1094: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE := p_percentage_complete;
1095: l_reason_code jtf_tasks_b.reason_code%TYPE := p_reason_code;
1096: l_date_selected jtf_tasks_b.date_selected%TYPE;
1097: l_calendar_start_date jtf_tasks_b.calendar_start_date%TYPE;
1098: l_calendar_end_date jtf_tasks_b.calendar_end_date%TYPE;
1099: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE := p_planned_start_date;
1100: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE := p_planned_end_date;

Line 1097: l_calendar_start_date jtf_tasks_b.calendar_start_date%TYPE;

1093: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE := p_actual_effort_uom;
1094: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE := p_percentage_complete;
1095: l_reason_code jtf_tasks_b.reason_code%TYPE := p_reason_code;
1096: l_date_selected jtf_tasks_b.date_selected%TYPE;
1097: l_calendar_start_date jtf_tasks_b.calendar_start_date%TYPE;
1098: l_calendar_end_date jtf_tasks_b.calendar_end_date%TYPE;
1099: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE := p_planned_start_date;
1100: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE := p_planned_end_date;
1101: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := p_scheduled_start_date;

Line 1098: l_calendar_end_date jtf_tasks_b.calendar_end_date%TYPE;

1094: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE := p_percentage_complete;
1095: l_reason_code jtf_tasks_b.reason_code%TYPE := p_reason_code;
1096: l_date_selected jtf_tasks_b.date_selected%TYPE;
1097: l_calendar_start_date jtf_tasks_b.calendar_start_date%TYPE;
1098: l_calendar_end_date jtf_tasks_b.calendar_end_date%TYPE;
1099: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE := p_planned_start_date;
1100: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE := p_planned_end_date;
1101: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := p_scheduled_start_date;
1102: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := p_scheduled_end_date;

Line 1099: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE := p_planned_start_date;

1095: l_reason_code jtf_tasks_b.reason_code%TYPE := p_reason_code;
1096: l_date_selected jtf_tasks_b.date_selected%TYPE;
1097: l_calendar_start_date jtf_tasks_b.calendar_start_date%TYPE;
1098: l_calendar_end_date jtf_tasks_b.calendar_end_date%TYPE;
1099: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE := p_planned_start_date;
1100: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE := p_planned_end_date;
1101: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := p_scheduled_start_date;
1102: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := p_scheduled_end_date;
1103: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE := p_actual_start_date;

Line 1100: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE := p_planned_end_date;

1096: l_date_selected jtf_tasks_b.date_selected%TYPE;
1097: l_calendar_start_date jtf_tasks_b.calendar_start_date%TYPE;
1098: l_calendar_end_date jtf_tasks_b.calendar_end_date%TYPE;
1099: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE := p_planned_start_date;
1100: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE := p_planned_end_date;
1101: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := p_scheduled_start_date;
1102: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := p_scheduled_end_date;
1103: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE := p_actual_start_date;
1104: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE := p_actual_end_date;

Line 1101: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := p_scheduled_start_date;

1097: l_calendar_start_date jtf_tasks_b.calendar_start_date%TYPE;
1098: l_calendar_end_date jtf_tasks_b.calendar_end_date%TYPE;
1099: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE := p_planned_start_date;
1100: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE := p_planned_end_date;
1101: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := p_scheduled_start_date;
1102: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := p_scheduled_end_date;
1103: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE := p_actual_start_date;
1104: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE := p_actual_end_date;
1105: l_task_assignment_id jtf_task_assignments.task_assignment_id%TYPE;

Line 1102: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := p_scheduled_end_date;

1098: l_calendar_end_date jtf_tasks_b.calendar_end_date%TYPE;
1099: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE := p_planned_start_date;
1100: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE := p_planned_end_date;
1101: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := p_scheduled_start_date;
1102: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := p_scheduled_end_date;
1103: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE := p_actual_start_date;
1104: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE := p_actual_end_date;
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;

Line 1103: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE := p_actual_start_date;

1099: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE := p_planned_start_date;
1100: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE := p_planned_end_date;
1101: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := p_scheduled_start_date;
1102: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := p_scheduled_end_date;
1103: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE := p_actual_start_date;
1104: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE := p_actual_end_date;
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;

Line 1104: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE := p_actual_end_date;

1100: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE := p_planned_end_date;
1101: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := p_scheduled_start_date;
1102: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := p_scheduled_end_date;
1103: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE := p_actual_start_date;
1104: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE := p_actual_end_date;
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;

Line 1114: l_entity jtf_tasks_b.entity%TYPE := p_entity;

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
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;

Line 1117: l_task_confirmation_status jtf_tasks_b.task_confirmation_status%TYPE := p_task_confirmation_status;

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;
1120: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%TYPE;
1121: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;

Line 1130: FROM jtf_tasks_b

1126: WHERE task_type_id = l_task_type_id;
1127:
1128: CURSOR c_jtf_tasks IS
1129: SELECT 'Y'
1130: FROM jtf_tasks_b
1131: WHERE task_id = p_task_id;
1132:
1133: l_task_id_duplicate VARCHAR2(1);
1134: l_task_rec_type jtf_tasks_pvt.task_rec_type;

Line 2939: l_task_id jtf_tasks_b.task_id%TYPE;

2935: , p_child_position IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
2936: , p_child_sequence_num IN NUMBER DEFAULT jtf_task_utl.g_miss_number
2937: , p_location_id IN NUMBER
2938: ) IS
2939: l_task_id jtf_tasks_b.task_id%TYPE;
2940: l_task_number jtf_tasks_b.task_number%TYPE;
2941: l_task_type_id jtf_tasks_b.task_type_id%TYPE;
2942: l_task_status_id jtf_tasks_b.task_status_id%TYPE;
2943: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE;

Line 2940: l_task_number jtf_tasks_b.task_number%TYPE;

2936: , p_child_sequence_num IN NUMBER DEFAULT jtf_task_utl.g_miss_number
2937: , p_location_id IN NUMBER
2938: ) IS
2939: l_task_id jtf_tasks_b.task_id%TYPE;
2940: l_task_number jtf_tasks_b.task_number%TYPE;
2941: l_task_type_id jtf_tasks_b.task_type_id%TYPE;
2942: l_task_status_id jtf_tasks_b.task_status_id%TYPE;
2943: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE;
2944: l_owner_id jtf_tasks_b.owner_id%TYPE;

Line 2941: l_task_type_id jtf_tasks_b.task_type_id%TYPE;

2937: , p_location_id IN NUMBER
2938: ) IS
2939: l_task_id jtf_tasks_b.task_id%TYPE;
2940: l_task_number jtf_tasks_b.task_number%TYPE;
2941: l_task_type_id jtf_tasks_b.task_type_id%TYPE;
2942: l_task_status_id jtf_tasks_b.task_status_id%TYPE;
2943: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE;
2944: l_owner_id jtf_tasks_b.owner_id%TYPE;
2945: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;

Line 2942: l_task_status_id jtf_tasks_b.task_status_id%TYPE;

2938: ) IS
2939: l_task_id jtf_tasks_b.task_id%TYPE;
2940: l_task_number jtf_tasks_b.task_number%TYPE;
2941: l_task_type_id jtf_tasks_b.task_type_id%TYPE;
2942: l_task_status_id jtf_tasks_b.task_status_id%TYPE;
2943: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE;
2944: l_owner_id jtf_tasks_b.owner_id%TYPE;
2945: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
2946: l_assigned_by_id jtf_tasks_b.assigned_by_id%TYPE;

Line 2943: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE;

2939: l_task_id jtf_tasks_b.task_id%TYPE;
2940: l_task_number jtf_tasks_b.task_number%TYPE;
2941: l_task_type_id jtf_tasks_b.task_type_id%TYPE;
2942: l_task_status_id jtf_tasks_b.task_status_id%TYPE;
2943: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE;
2944: l_owner_id jtf_tasks_b.owner_id%TYPE;
2945: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
2946: l_assigned_by_id jtf_tasks_b.assigned_by_id%TYPE;
2947: l_cust_account_id jtf_tasks_b.cust_account_id%TYPE;

Line 2944: l_owner_id jtf_tasks_b.owner_id%TYPE;

2940: l_task_number jtf_tasks_b.task_number%TYPE;
2941: l_task_type_id jtf_tasks_b.task_type_id%TYPE;
2942: l_task_status_id jtf_tasks_b.task_status_id%TYPE;
2943: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE;
2944: l_owner_id jtf_tasks_b.owner_id%TYPE;
2945: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
2946: l_assigned_by_id jtf_tasks_b.assigned_by_id%TYPE;
2947: l_cust_account_id jtf_tasks_b.cust_account_id%TYPE;
2948: l_customer_id jtf_tasks_b.customer_id%TYPE;

Line 2945: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;

2941: l_task_type_id jtf_tasks_b.task_type_id%TYPE;
2942: l_task_status_id jtf_tasks_b.task_status_id%TYPE;
2943: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE;
2944: l_owner_id jtf_tasks_b.owner_id%TYPE;
2945: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
2946: l_assigned_by_id jtf_tasks_b.assigned_by_id%TYPE;
2947: l_cust_account_id jtf_tasks_b.cust_account_id%TYPE;
2948: l_customer_id jtf_tasks_b.customer_id%TYPE;
2949: l_address_id jtf_tasks_b.address_id%TYPE;

Line 2946: l_assigned_by_id jtf_tasks_b.assigned_by_id%TYPE;

2942: l_task_status_id jtf_tasks_b.task_status_id%TYPE;
2943: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE;
2944: l_owner_id jtf_tasks_b.owner_id%TYPE;
2945: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
2946: l_assigned_by_id jtf_tasks_b.assigned_by_id%TYPE;
2947: l_cust_account_id jtf_tasks_b.cust_account_id%TYPE;
2948: l_customer_id jtf_tasks_b.customer_id%TYPE;
2949: l_address_id jtf_tasks_b.address_id%TYPE;
2950: l_location_id hz_locations.location_id%TYPE;

Line 2947: l_cust_account_id jtf_tasks_b.cust_account_id%TYPE;

2943: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE;
2944: l_owner_id jtf_tasks_b.owner_id%TYPE;
2945: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
2946: l_assigned_by_id jtf_tasks_b.assigned_by_id%TYPE;
2947: l_cust_account_id jtf_tasks_b.cust_account_id%TYPE;
2948: l_customer_id jtf_tasks_b.customer_id%TYPE;
2949: l_address_id jtf_tasks_b.address_id%TYPE;
2950: l_location_id hz_locations.location_id%TYPE;
2951: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE;

Line 2948: l_customer_id jtf_tasks_b.customer_id%TYPE;

2944: l_owner_id jtf_tasks_b.owner_id%TYPE;
2945: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
2946: l_assigned_by_id jtf_tasks_b.assigned_by_id%TYPE;
2947: l_cust_account_id jtf_tasks_b.cust_account_id%TYPE;
2948: l_customer_id jtf_tasks_b.customer_id%TYPE;
2949: l_address_id jtf_tasks_b.address_id%TYPE;
2950: l_location_id hz_locations.location_id%TYPE;
2951: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE;
2952: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;

Line 2949: l_address_id jtf_tasks_b.address_id%TYPE;

2945: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
2946: l_assigned_by_id jtf_tasks_b.assigned_by_id%TYPE;
2947: l_cust_account_id jtf_tasks_b.cust_account_id%TYPE;
2948: l_customer_id jtf_tasks_b.customer_id%TYPE;
2949: l_address_id jtf_tasks_b.address_id%TYPE;
2950: l_location_id hz_locations.location_id%TYPE;
2951: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE;
2952: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
2953: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE;

Line 2951: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE;

2947: l_cust_account_id jtf_tasks_b.cust_account_id%TYPE;
2948: l_customer_id jtf_tasks_b.customer_id%TYPE;
2949: l_address_id jtf_tasks_b.address_id%TYPE;
2950: l_location_id hz_locations.location_id%TYPE;
2951: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE;
2952: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
2953: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE;
2954: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE;
2955: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE;

Line 2952: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;

2948: l_customer_id jtf_tasks_b.customer_id%TYPE;
2949: l_address_id jtf_tasks_b.address_id%TYPE;
2950: l_location_id hz_locations.location_id%TYPE;
2951: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE;
2952: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
2953: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE;
2954: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE;
2955: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE;
2956: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;

Line 2953: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE;

2949: l_address_id jtf_tasks_b.address_id%TYPE;
2950: l_location_id hz_locations.location_id%TYPE;
2951: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE;
2952: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
2953: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE;
2954: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE;
2955: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE;
2956: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
2957: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

Line 2954: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE;

2950: l_location_id hz_locations.location_id%TYPE;
2951: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE;
2952: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
2953: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE;
2954: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE;
2955: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE;
2956: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
2957: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
2958: l_timezone_id jtf_tasks_b.timezone_id%TYPE;

Line 2955: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE;

2951: l_planned_start_date jtf_tasks_b.planned_start_date%TYPE;
2952: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
2953: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE;
2954: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE;
2955: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE;
2956: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
2957: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
2958: l_timezone_id jtf_tasks_b.timezone_id%TYPE;
2959: l_source_object_id jtf_tasks_b.source_object_id%TYPE;

Line 2956: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;

2952: l_planned_end_date jtf_tasks_b.planned_end_date%TYPE;
2953: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE;
2954: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE;
2955: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE;
2956: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
2957: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
2958: l_timezone_id jtf_tasks_b.timezone_id%TYPE;
2959: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
2960: l_source_object_name jtf_tasks_b.source_object_name%TYPE;

Line 2957: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

2953: l_scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE;
2954: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE;
2955: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE;
2956: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
2957: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
2958: l_timezone_id jtf_tasks_b.timezone_id%TYPE;
2959: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
2960: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
2961: l_duration jtf_tasks_b.DURATION%TYPE;

Line 2958: l_timezone_id jtf_tasks_b.timezone_id%TYPE;

2954: l_scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE;
2955: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE;
2956: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
2957: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
2958: l_timezone_id jtf_tasks_b.timezone_id%TYPE;
2959: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
2960: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
2961: l_duration jtf_tasks_b.DURATION%TYPE;
2962: l_duration_uom jtf_tasks_b.duration_uom%TYPE;

Line 2959: l_source_object_id jtf_tasks_b.source_object_id%TYPE;

2955: l_actual_start_date jtf_tasks_b.actual_start_date%TYPE;
2956: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
2957: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
2958: l_timezone_id jtf_tasks_b.timezone_id%TYPE;
2959: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
2960: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
2961: l_duration jtf_tasks_b.DURATION%TYPE;
2962: l_duration_uom jtf_tasks_b.duration_uom%TYPE;
2963: l_planned_effort jtf_tasks_b.planned_effort%TYPE;

Line 2960: l_source_object_name jtf_tasks_b.source_object_name%TYPE;

2956: l_actual_end_date jtf_tasks_b.actual_end_date%TYPE;
2957: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
2958: l_timezone_id jtf_tasks_b.timezone_id%TYPE;
2959: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
2960: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
2961: l_duration jtf_tasks_b.DURATION%TYPE;
2962: l_duration_uom jtf_tasks_b.duration_uom%TYPE;
2963: l_planned_effort jtf_tasks_b.planned_effort%TYPE;
2964: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;

Line 2961: l_duration jtf_tasks_b.DURATION%TYPE;

2957: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
2958: l_timezone_id jtf_tasks_b.timezone_id%TYPE;
2959: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
2960: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
2961: l_duration jtf_tasks_b.DURATION%TYPE;
2962: l_duration_uom jtf_tasks_b.duration_uom%TYPE;
2963: l_planned_effort jtf_tasks_b.planned_effort%TYPE;
2964: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
2965: l_actual_effort jtf_tasks_b.actual_effort%TYPE;

Line 2962: l_duration_uom jtf_tasks_b.duration_uom%TYPE;

2958: l_timezone_id jtf_tasks_b.timezone_id%TYPE;
2959: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
2960: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
2961: l_duration jtf_tasks_b.DURATION%TYPE;
2962: l_duration_uom jtf_tasks_b.duration_uom%TYPE;
2963: l_planned_effort jtf_tasks_b.planned_effort%TYPE;
2964: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
2965: l_actual_effort jtf_tasks_b.actual_effort%TYPE;
2966: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;

Line 2963: l_planned_effort jtf_tasks_b.planned_effort%TYPE;

2959: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
2960: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
2961: l_duration jtf_tasks_b.DURATION%TYPE;
2962: l_duration_uom jtf_tasks_b.duration_uom%TYPE;
2963: l_planned_effort jtf_tasks_b.planned_effort%TYPE;
2964: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
2965: l_actual_effort jtf_tasks_b.actual_effort%TYPE;
2966: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;
2967: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;

Line 2964: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;

2960: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
2961: l_duration jtf_tasks_b.DURATION%TYPE;
2962: l_duration_uom jtf_tasks_b.duration_uom%TYPE;
2963: l_planned_effort jtf_tasks_b.planned_effort%TYPE;
2964: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
2965: l_actual_effort jtf_tasks_b.actual_effort%TYPE;
2966: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;
2967: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2968: l_reason_code jtf_tasks_b.reason_code%TYPE;

Line 2965: l_actual_effort jtf_tasks_b.actual_effort%TYPE;

2961: l_duration jtf_tasks_b.DURATION%TYPE;
2962: l_duration_uom jtf_tasks_b.duration_uom%TYPE;
2963: l_planned_effort jtf_tasks_b.planned_effort%TYPE;
2964: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
2965: l_actual_effort jtf_tasks_b.actual_effort%TYPE;
2966: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;
2967: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2968: l_reason_code jtf_tasks_b.reason_code%TYPE;
2969: l_private_flag jtf_tasks_b.private_flag%TYPE;

Line 2966: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;

2962: l_duration_uom jtf_tasks_b.duration_uom%TYPE;
2963: l_planned_effort jtf_tasks_b.planned_effort%TYPE;
2964: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
2965: l_actual_effort jtf_tasks_b.actual_effort%TYPE;
2966: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;
2967: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2968: l_reason_code jtf_tasks_b.reason_code%TYPE;
2969: l_private_flag jtf_tasks_b.private_flag%TYPE;
2970: l_publish_flag jtf_tasks_b.publish_flag%TYPE;

Line 2967: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;

2963: l_planned_effort jtf_tasks_b.planned_effort%TYPE;
2964: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
2965: l_actual_effort jtf_tasks_b.actual_effort%TYPE;
2966: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;
2967: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2968: l_reason_code jtf_tasks_b.reason_code%TYPE;
2969: l_private_flag jtf_tasks_b.private_flag%TYPE;
2970: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2971: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;

Line 2968: l_reason_code jtf_tasks_b.reason_code%TYPE;

2964: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
2965: l_actual_effort jtf_tasks_b.actual_effort%TYPE;
2966: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;
2967: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2968: l_reason_code jtf_tasks_b.reason_code%TYPE;
2969: l_private_flag jtf_tasks_b.private_flag%TYPE;
2970: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2971: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2972: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;

Line 2969: l_private_flag jtf_tasks_b.private_flag%TYPE;

2965: l_actual_effort jtf_tasks_b.actual_effort%TYPE;
2966: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;
2967: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2968: l_reason_code jtf_tasks_b.reason_code%TYPE;
2969: l_private_flag jtf_tasks_b.private_flag%TYPE;
2970: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2971: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2972: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;
2973: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;

Line 2970: l_publish_flag jtf_tasks_b.publish_flag%TYPE;

2966: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;
2967: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2968: l_reason_code jtf_tasks_b.reason_code%TYPE;
2969: l_private_flag jtf_tasks_b.private_flag%TYPE;
2970: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2971: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2972: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;
2973: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;
2974: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;

Line 2971: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;

2967: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2968: l_reason_code jtf_tasks_b.reason_code%TYPE;
2969: l_private_flag jtf_tasks_b.private_flag%TYPE;
2970: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2971: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2972: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;
2973: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;
2974: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;
2975: l_billable_flag jtf_tasks_b.billable_flag%TYPE;

Line 2972: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;

2968: l_reason_code jtf_tasks_b.reason_code%TYPE;
2969: l_private_flag jtf_tasks_b.private_flag%TYPE;
2970: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2971: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2972: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;
2973: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;
2974: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;
2975: l_billable_flag jtf_tasks_b.billable_flag%TYPE;
2976: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;

Line 2973: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;

2969: l_private_flag jtf_tasks_b.private_flag%TYPE;
2970: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2971: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2972: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;
2973: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;
2974: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;
2975: l_billable_flag jtf_tasks_b.billable_flag%TYPE;
2976: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;
2977: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;

Line 2974: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;

2970: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2971: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2972: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;
2973: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;
2974: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;
2975: l_billable_flag jtf_tasks_b.billable_flag%TYPE;
2976: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;
2977: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;
2978: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;

Line 2975: l_billable_flag jtf_tasks_b.billable_flag%TYPE;

2971: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2972: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;
2973: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;
2974: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;
2975: l_billable_flag jtf_tasks_b.billable_flag%TYPE;
2976: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;
2977: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;
2978: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
2979: l_notification_flag jtf_tasks_b.notification_flag%TYPE;

Line 2976: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;

2972: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;
2973: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;
2974: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;
2975: l_billable_flag jtf_tasks_b.billable_flag%TYPE;
2976: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;
2977: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;
2978: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
2979: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
2980: l_notification_period jtf_tasks_b.notification_period%TYPE;

Line 2977: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;

2973: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;
2974: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;
2975: l_billable_flag jtf_tasks_b.billable_flag%TYPE;
2976: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;
2977: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;
2978: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
2979: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
2980: l_notification_period jtf_tasks_b.notification_period%TYPE;
2981: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;

Line 2978: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;

2974: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;
2975: l_billable_flag jtf_tasks_b.billable_flag%TYPE;
2976: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;
2977: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;
2978: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
2979: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
2980: l_notification_period jtf_tasks_b.notification_period%TYPE;
2981: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;

Line 2979: l_notification_flag jtf_tasks_b.notification_flag%TYPE;

2975: l_billable_flag jtf_tasks_b.billable_flag%TYPE;
2976: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;
2977: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;
2978: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
2979: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
2980: l_notification_period jtf_tasks_b.notification_period%TYPE;
2981: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;
2983: l_alarm_start jtf_tasks_b.alarm_start%TYPE;

Line 2980: l_notification_period jtf_tasks_b.notification_period%TYPE;

2976: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;
2977: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;
2978: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
2979: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
2980: l_notification_period jtf_tasks_b.notification_period%TYPE;
2981: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;
2983: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
2984: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;

Line 2981: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;

2977: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;
2978: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
2979: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
2980: l_notification_period jtf_tasks_b.notification_period%TYPE;
2981: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;
2983: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
2984: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
2985: l_alarm_on jtf_tasks_b.alarm_on%TYPE;

Line 2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;

2978: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
2979: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
2980: l_notification_period jtf_tasks_b.notification_period%TYPE;
2981: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;
2983: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
2984: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
2985: l_alarm_on jtf_tasks_b.alarm_on%TYPE;
2986: l_alarm_count jtf_tasks_b.alarm_count%TYPE;

Line 2983: l_alarm_start jtf_tasks_b.alarm_start%TYPE;

2979: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
2980: l_notification_period jtf_tasks_b.notification_period%TYPE;
2981: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;
2983: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
2984: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
2985: l_alarm_on jtf_tasks_b.alarm_on%TYPE;
2986: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
2987: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;

Line 2984: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;

2980: l_notification_period jtf_tasks_b.notification_period%TYPE;
2981: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;
2983: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
2984: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
2985: l_alarm_on jtf_tasks_b.alarm_on%TYPE;
2986: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
2987: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;
2988: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;

Line 2985: l_alarm_on jtf_tasks_b.alarm_on%TYPE;

2981: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;
2983: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
2984: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
2985: l_alarm_on jtf_tasks_b.alarm_on%TYPE;
2986: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
2987: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;
2988: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
2989: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;

Line 2986: l_alarm_count jtf_tasks_b.alarm_count%TYPE;

2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;
2983: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
2984: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
2985: l_alarm_on jtf_tasks_b.alarm_on%TYPE;
2986: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
2987: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;
2988: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
2989: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
2990: l_palm_flag jtf_tasks_b.palm_flag%TYPE;

Line 2987: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;

2983: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
2984: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
2985: l_alarm_on jtf_tasks_b.alarm_on%TYPE;
2986: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
2987: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;
2988: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
2989: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
2990: l_palm_flag jtf_tasks_b.palm_flag%TYPE;
2991: l_wince_flag jtf_tasks_b.wince_flag%TYPE;

Line 2988: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;

2984: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
2985: l_alarm_on jtf_tasks_b.alarm_on%TYPE;
2986: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
2987: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;
2988: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
2989: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
2990: l_palm_flag jtf_tasks_b.palm_flag%TYPE;
2991: l_wince_flag jtf_tasks_b.wince_flag%TYPE;
2992: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;

Line 2989: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;

2985: l_alarm_on jtf_tasks_b.alarm_on%TYPE;
2986: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
2987: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;
2988: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
2989: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
2990: l_palm_flag jtf_tasks_b.palm_flag%TYPE;
2991: l_wince_flag jtf_tasks_b.wince_flag%TYPE;
2992: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;
2993: l_device1_flag jtf_tasks_b.device1_flag%TYPE;

Line 2990: l_palm_flag jtf_tasks_b.palm_flag%TYPE;

2986: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
2987: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;
2988: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
2989: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
2990: l_palm_flag jtf_tasks_b.palm_flag%TYPE;
2991: l_wince_flag jtf_tasks_b.wince_flag%TYPE;
2992: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;
2993: l_device1_flag jtf_tasks_b.device1_flag%TYPE;
2994: l_device2_flag jtf_tasks_b.device2_flag%TYPE;

Line 2991: l_wince_flag jtf_tasks_b.wince_flag%TYPE;

2987: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;
2988: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
2989: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
2990: l_palm_flag jtf_tasks_b.palm_flag%TYPE;
2991: l_wince_flag jtf_tasks_b.wince_flag%TYPE;
2992: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;
2993: l_device1_flag jtf_tasks_b.device1_flag%TYPE;
2994: l_device2_flag jtf_tasks_b.device2_flag%TYPE;
2995: l_device3_flag jtf_tasks_b.device3_flag%TYPE;

Line 2992: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;

2988: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
2989: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
2990: l_palm_flag jtf_tasks_b.palm_flag%TYPE;
2991: l_wince_flag jtf_tasks_b.wince_flag%TYPE;
2992: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;
2993: l_device1_flag jtf_tasks_b.device1_flag%TYPE;
2994: l_device2_flag jtf_tasks_b.device2_flag%TYPE;
2995: l_device3_flag jtf_tasks_b.device3_flag%TYPE;
2996: l_currency_code jtf_tasks_b.currency_code%TYPE;

Line 2993: l_device1_flag jtf_tasks_b.device1_flag%TYPE;

2989: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
2990: l_palm_flag jtf_tasks_b.palm_flag%TYPE;
2991: l_wince_flag jtf_tasks_b.wince_flag%TYPE;
2992: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;
2993: l_device1_flag jtf_tasks_b.device1_flag%TYPE;
2994: l_device2_flag jtf_tasks_b.device2_flag%TYPE;
2995: l_device3_flag jtf_tasks_b.device3_flag%TYPE;
2996: l_currency_code jtf_tasks_b.currency_code%TYPE;
2997: l_costs jtf_tasks_b.costs%TYPE;

Line 2994: l_device2_flag jtf_tasks_b.device2_flag%TYPE;

2990: l_palm_flag jtf_tasks_b.palm_flag%TYPE;
2991: l_wince_flag jtf_tasks_b.wince_flag%TYPE;
2992: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;
2993: l_device1_flag jtf_tasks_b.device1_flag%TYPE;
2994: l_device2_flag jtf_tasks_b.device2_flag%TYPE;
2995: l_device3_flag jtf_tasks_b.device3_flag%TYPE;
2996: l_currency_code jtf_tasks_b.currency_code%TYPE;
2997: l_costs jtf_tasks_b.costs%TYPE;
2998: l_org_id jtf_tasks_b.org_id%TYPE;

Line 2995: l_device3_flag jtf_tasks_b.device3_flag%TYPE;

2991: l_wince_flag jtf_tasks_b.wince_flag%TYPE;
2992: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;
2993: l_device1_flag jtf_tasks_b.device1_flag%TYPE;
2994: l_device2_flag jtf_tasks_b.device2_flag%TYPE;
2995: l_device3_flag jtf_tasks_b.device3_flag%TYPE;
2996: l_currency_code jtf_tasks_b.currency_code%TYPE;
2997: l_costs jtf_tasks_b.costs%TYPE;
2998: l_org_id jtf_tasks_b.org_id%TYPE;
2999: l_task_name jtf_tasks_tl.task_name%TYPE;

Line 2996: l_currency_code jtf_tasks_b.currency_code%TYPE;

2992: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;
2993: l_device1_flag jtf_tasks_b.device1_flag%TYPE;
2994: l_device2_flag jtf_tasks_b.device2_flag%TYPE;
2995: l_device3_flag jtf_tasks_b.device3_flag%TYPE;
2996: l_currency_code jtf_tasks_b.currency_code%TYPE;
2997: l_costs jtf_tasks_b.costs%TYPE;
2998: l_org_id jtf_tasks_b.org_id%TYPE;
2999: l_task_name jtf_tasks_tl.task_name%TYPE;
3000: l_description jtf_tasks_tl.description%TYPE;

Line 2997: l_costs jtf_tasks_b.costs%TYPE;

2993: l_device1_flag jtf_tasks_b.device1_flag%TYPE;
2994: l_device2_flag jtf_tasks_b.device2_flag%TYPE;
2995: l_device3_flag jtf_tasks_b.device3_flag%TYPE;
2996: l_currency_code jtf_tasks_b.currency_code%TYPE;
2997: l_costs jtf_tasks_b.costs%TYPE;
2998: l_org_id jtf_tasks_b.org_id%TYPE;
2999: l_task_name jtf_tasks_tl.task_name%TYPE;
3000: l_description jtf_tasks_tl.description%TYPE;
3001: l_escalation_level jtf_tasks_b.escalation_level%TYPE;

Line 2998: l_org_id jtf_tasks_b.org_id%TYPE;

2994: l_device2_flag jtf_tasks_b.device2_flag%TYPE;
2995: l_device3_flag jtf_tasks_b.device3_flag%TYPE;
2996: l_currency_code jtf_tasks_b.currency_code%TYPE;
2997: l_costs jtf_tasks_b.costs%TYPE;
2998: l_org_id jtf_tasks_b.org_id%TYPE;
2999: l_task_name jtf_tasks_tl.task_name%TYPE;
3000: l_description jtf_tasks_tl.description%TYPE;
3001: l_escalation_level jtf_tasks_b.escalation_level%TYPE;
3002: l_calendar_start_date jtf_tasks_b.calendar_start_date%TYPE;

Line 3001: l_escalation_level jtf_tasks_b.escalation_level%TYPE;

2997: l_costs jtf_tasks_b.costs%TYPE;
2998: l_org_id jtf_tasks_b.org_id%TYPE;
2999: l_task_name jtf_tasks_tl.task_name%TYPE;
3000: l_description jtf_tasks_tl.description%TYPE;
3001: l_escalation_level jtf_tasks_b.escalation_level%TYPE;
3002: l_calendar_start_date jtf_tasks_b.calendar_start_date%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;

Line 3002: l_calendar_start_date jtf_tasks_b.calendar_start_date%TYPE;

2998: l_org_id jtf_tasks_b.org_id%TYPE;
2999: l_task_name jtf_tasks_tl.task_name%TYPE;
3000: l_description jtf_tasks_tl.description%TYPE;
3001: l_escalation_level jtf_tasks_b.escalation_level%TYPE;
3002: l_calendar_start_date jtf_tasks_b.calendar_start_date%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;

Line 3003: l_calendar_end_date jtf_tasks_b.calendar_end_date%TYPE;

2999: l_task_name jtf_tasks_tl.task_name%TYPE;
3000: l_description jtf_tasks_tl.description%TYPE;
3001: l_escalation_level jtf_tasks_b.escalation_level%TYPE;
3002: l_calendar_start_date jtf_tasks_b.calendar_start_date%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;

Line 3004: l_date_selected jtf_tasks_b.date_selected%TYPE;

3000: l_description jtf_tasks_tl.description%TYPE;
3001: l_escalation_level jtf_tasks_b.escalation_level%TYPE;
3002: l_calendar_start_date jtf_tasks_b.calendar_start_date%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;

Line 3008: l_task_confirmation_status jtf_tasks_b.task_confirmation_status%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;
3012: l_abort_workflow VARCHAR2(1) := p_abort_workflow;

Line 3009: l_task_confirmation_counter jtf_tasks_b.task_confirmation_counter%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;
3012: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
3013: l_child_position jtf_tasks_b.child_position%TYPE;

Line 3010: l_task_split_flag jtf_tasks_b.task_split_flag%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;
3012: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
3013: l_child_position jtf_tasks_b.child_position%TYPE;
3014: l_child_sequence_num jtf_tasks_b.child_sequence_num%TYPE;

Line 3013: l_child_position jtf_tasks_b.child_position%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;
3012: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
3013: l_child_position jtf_tasks_b.child_position%TYPE;
3014: l_child_sequence_num jtf_tasks_b.child_sequence_num%TYPE;
3015:
3016: CURSOR c_task IS
3017: SELECT task_number

Line 3014: l_child_sequence_num jtf_tasks_b.child_sequence_num%TYPE;

3010: l_task_split_flag jtf_tasks_b.task_split_flag%TYPE;
3011: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
3012: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
3013: l_child_position jtf_tasks_b.child_position%TYPE;
3014: l_child_sequence_num jtf_tasks_b.child_sequence_num%TYPE;
3015:
3016: CURSOR c_task IS
3017: SELECT task_number
3018: , recurrence_rule_id

Line 3290: FROM jtf_tasks_b

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
3291: WHERE task_id = b_task_id;
3292:
3293: l_orig_cust_id jtf_tasks_b.customer_id%TYPE;
3294:

Line 3293: l_orig_cust_id jtf_tasks_b.customer_id%TYPE;

3289: SELECT customer_id
3290: FROM jtf_tasks_b
3291: WHERE task_id = b_task_id;
3292:
3293: l_orig_cust_id jtf_tasks_b.customer_id%TYPE;
3294:
3295: -- 2102281
3296: CURSOR task_source_orig(b_task_id IN NUMBER) IS
3297: SELECT source_object_id

Line 3301: FROM jtf_tasks_b

3297: SELECT source_object_id
3298: , source_object_type_code
3299: , entity
3300: , open_flag
3301: FROM jtf_tasks_b
3302: WHERE task_id = b_task_id;
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

Line 3304: CURSOR c_ref(b_task_id jtf_tasks_b.task_id%TYPE, b_source_id hz_parties.party_id%TYPE) IS

3300: , open_flag
3301: FROM jtf_tasks_b
3302: WHERE task_id = b_task_id;
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;

Line 3310: l_orig_source_id jtf_tasks_b.source_object_id%TYPE;

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;
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;

Line 3311: l_orig_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

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;
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;

Line 3312: l_entity jtf_tasks_b.entity%TYPE;

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;
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:

Line 3313: l_orig_open_flag jtf_tasks_b.open_flag%TYPE;

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;
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

Line 3317: CURSOR c_del_contacts(c_task_id jtf_tasks_b.task_id%TYPE) IS

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
3320: , object_version_number
3321: FROM jtf_task_contacts

Line 4330: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;

4326: , x_msg_data OUT NOCOPY VARCHAR2
4327: , p_enable_workflow IN VARCHAR2
4328: , p_abort_workflow IN VARCHAR2
4329: ) IS
4330: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
4331: l_recur_rule jtf_task_recur_rules.recurrence_rule_id%TYPE;
4332: l_date_selected jtf_task_recur_rules.date_selected%TYPE;
4333: l_planned_date jtf_tasks_b.planned_start_date%TYPE;
4334: l_scheduled_date jtf_tasks_b.scheduled_start_date%TYPE;

Line 4333: l_planned_date jtf_tasks_b.planned_start_date%TYPE;

4329: ) IS
4330: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
4331: l_recur_rule jtf_task_recur_rules.recurrence_rule_id%TYPE;
4332: l_date_selected jtf_task_recur_rules.date_selected%TYPE;
4333: l_planned_date jtf_tasks_b.planned_start_date%TYPE;
4334: l_scheduled_date jtf_tasks_b.scheduled_start_date%TYPE;
4335: l_actual_date jtf_tasks_b.actual_start_date%TYPE;
4336: l_obj_version jtf_tasks_b.object_version_number%TYPE;
4337: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

Line 4334: l_scheduled_date jtf_tasks_b.scheduled_start_date%TYPE;

4330: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
4331: l_recur_rule jtf_task_recur_rules.recurrence_rule_id%TYPE;
4332: l_date_selected jtf_task_recur_rules.date_selected%TYPE;
4333: l_planned_date jtf_tasks_b.planned_start_date%TYPE;
4334: l_scheduled_date jtf_tasks_b.scheduled_start_date%TYPE;
4335: l_actual_date jtf_tasks_b.actual_start_date%TYPE;
4336: l_obj_version jtf_tasks_b.object_version_number%TYPE;
4337: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
4338: l_source_object_id jtf_tasks_b.source_object_id%TYPE;

Line 4335: l_actual_date jtf_tasks_b.actual_start_date%TYPE;

4331: l_recur_rule jtf_task_recur_rules.recurrence_rule_id%TYPE;
4332: l_date_selected jtf_task_recur_rules.date_selected%TYPE;
4333: l_planned_date jtf_tasks_b.planned_start_date%TYPE;
4334: l_scheduled_date jtf_tasks_b.scheduled_start_date%TYPE;
4335: l_actual_date jtf_tasks_b.actual_start_date%TYPE;
4336: l_obj_version jtf_tasks_b.object_version_number%TYPE;
4337: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
4338: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
4339: l_calendar_start_date DATE;

Line 4336: l_obj_version jtf_tasks_b.object_version_number%TYPE;

4332: l_date_selected jtf_task_recur_rules.date_selected%TYPE;
4333: l_planned_date jtf_tasks_b.planned_start_date%TYPE;
4334: l_scheduled_date jtf_tasks_b.scheduled_start_date%TYPE;
4335: l_actual_date jtf_tasks_b.actual_start_date%TYPE;
4336: l_obj_version jtf_tasks_b.object_version_number%TYPE;
4337: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
4338: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
4339: l_calendar_start_date DATE;
4340: l_task_exclusion_id NUMBER;

Line 4337: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

4333: l_planned_date jtf_tasks_b.planned_start_date%TYPE;
4334: l_scheduled_date jtf_tasks_b.scheduled_start_date%TYPE;
4335: l_actual_date jtf_tasks_b.actual_start_date%TYPE;
4336: l_obj_version jtf_tasks_b.object_version_number%TYPE;
4337: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
4338: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
4339: l_calendar_start_date DATE;
4340: l_task_exclusion_id NUMBER;
4341: l_parent_child_count NUMBER;

Line 4338: l_source_object_id jtf_tasks_b.source_object_id%TYPE;

4334: l_scheduled_date jtf_tasks_b.scheduled_start_date%TYPE;
4335: l_actual_date jtf_tasks_b.actual_start_date%TYPE;
4336: l_obj_version jtf_tasks_b.object_version_number%TYPE;
4337: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
4338: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
4339: l_calendar_start_date DATE;
4340: l_task_exclusion_id NUMBER;
4341: l_parent_child_count NUMBER;
4342:

Line 4347: CURSOR c_recur_rule(b_task_id jtf_tasks_b.task_id%TYPE) IS

4343: -- ------------------------------------------------------------------------
4344: -- Retrieve recurrence rule id for the selected task, plus the start dates
4345: -- for that task, to fix bug #1975337
4346: -- ------------------------------------------------------------------------
4347: CURSOR c_recur_rule(b_task_id jtf_tasks_b.task_id%TYPE) IS
4348: SELECT recurrence_rule_id
4349: , planned_start_date
4350: , scheduled_start_date
4351: , actual_start_date

Line 4352: FROM jtf_tasks_b

4348: SELECT recurrence_rule_id
4349: , planned_start_date
4350: , scheduled_start_date
4351: , actual_start_date
4352: FROM jtf_tasks_b
4353: WHERE task_id = b_task_id;
4354:
4355: -- ------------------------------------------------------------------------
4356: -- Retrieve date used in recurrence rule

Line 4358: CURSOR c_recur_date(b_rule_id jtf_tasks_b.recurrence_rule_id%TYPE) IS

4354:
4355: -- ------------------------------------------------------------------------
4356: -- Retrieve date used in recurrence rule
4357: -- ------------------------------------------------------------------------
4358: CURSOR c_recur_date(b_rule_id jtf_tasks_b.recurrence_rule_id%TYPE) IS
4359: SELECT date_selected
4360: FROM jtf_task_recur_rules
4361: WHERE recurrence_rule_id = b_rule_id;
4362:

Line 4373: FROM jtf_tasks_b

4369: , object_version_number
4370: , source_object_type_code
4371: , -- Added for XP Sync Story #58
4372: calendar_start_date -- Added for XP Sync Story #58
4373: FROM jtf_tasks_b
4374: WHERE task_id = p_task_id
4375: UNION ALL
4376: SELECT task_id
4377: , object_version_number

Line 4381: FROM jtf_tasks_b

4377: , object_version_number
4378: , source_object_type_code
4379: , -- Added for XP Sync Story #58
4380: calendar_start_date -- Added for XP Sync Story #58
4381: FROM jtf_tasks_b
4382: WHERE recurrence_rule_id = l_recur_rule
4383: AND (
4384: (
4385: p_delete_future_recurrences = fnd_api.g_true

Line 4452: FROM jtf_task_phones a, jtf_tasks_b c

4448: -- Added to fix Bug # 2585935
4449: CURSOR c_contact_points IS
4450: SELECT a.object_version_number
4451: , a.task_phone_id
4452: FROM jtf_task_phones a, jtf_tasks_b c
4453: WHERE a.owner_table_name = 'JTF_TASKS_B'
4454: AND a.task_contact_id = c.task_id
4455: AND c.task_id = l_task_id;
4456:

Line 4453: WHERE a.owner_table_name = 'JTF_TASKS_B'

4449: CURSOR c_contact_points IS
4450: SELECT a.object_version_number
4451: , a.task_phone_id
4452: FROM jtf_task_phones a, jtf_tasks_b c
4453: WHERE a.owner_table_name = 'JTF_TASKS_B'
4454: AND a.task_contact_id = c.task_id
4455: AND c.task_id = l_task_id;
4456:
4457: --BES enh 2391065

Line 4465: FROM jtf_tasks_b

4461: CURSOR task_source_orig(b_task_id IN NUMBER) IS
4462: SELECT source_object_id
4463: , source_object_type_code
4464: , entity
4465: FROM jtf_tasks_b
4466: WHERE task_id = b_task_id;
4467:
4468: CURSOR c_parent_child(b_date_selected jtf_task_recur_rules.date_selected%TYPE) IS
4469: SELECT count(*) FROM

Line 4471: from jtf_tasks_b

4467:
4468: CURSOR c_parent_child(b_date_selected jtf_task_recur_rules.date_selected%TYPE) IS
4469: SELECT count(*) FROM
4470: (SELECT task_number
4471: from jtf_tasks_b
4472: where parent_task_id = p_task_id
4473: AND NVL(deleted_flag, 'N') = 'N'
4474: UNION ALL
4475: SELECT task_number

Line 4476: FROM jtf_tasks_b

4472: where parent_task_id = p_task_id
4473: AND NVL(deleted_flag, 'N') = 'N'
4474: UNION ALL
4475: SELECT task_number
4476: FROM jtf_tasks_b
4477: WHERE recurrence_rule_id = l_recur_rule
4478: AND (
4479: (
4480: p_delete_future_recurrences = fnd_api.g_true

Line 4506: from jtf_tasks_b

4502: )
4503: AND NVL(deleted_flag, 'N') = 'N'
4504: AND task_id <> p_task_id
4505: AND exists ( select *
4506: from jtf_tasks_b
4507: where parent_task_id = task_id ) );
4508:
4509: l_orig_source_object_id jtf_tasks_b.source_object_id%TYPE;
4510: l_orig_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

Line 4509: l_orig_source_object_id jtf_tasks_b.source_object_id%TYPE;

4505: AND exists ( select *
4506: from jtf_tasks_b
4507: where parent_task_id = task_id ) );
4508:
4509: l_orig_source_object_id jtf_tasks_b.source_object_id%TYPE;
4510: l_orig_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
4511: l_entity jtf_tasks_b.entity%TYPE;
4512: BEGIN
4513: SAVEPOINT delete_task_pvt;

Line 4510: l_orig_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

4506: from jtf_tasks_b
4507: where parent_task_id = task_id ) );
4508:
4509: l_orig_source_object_id jtf_tasks_b.source_object_id%TYPE;
4510: l_orig_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
4511: l_entity jtf_tasks_b.entity%TYPE;
4512: BEGIN
4513: SAVEPOINT delete_task_pvt;
4514: x_return_status := fnd_api.g_ret_sts_success;

Line 4511: l_entity jtf_tasks_b.entity%TYPE;

4507: where parent_task_id = task_id ) );
4508:
4509: l_orig_source_object_id jtf_tasks_b.source_object_id%TYPE;
4510: l_orig_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
4511: l_entity jtf_tasks_b.entity%TYPE;
4512: BEGIN
4513: SAVEPOINT delete_task_pvt;
4514: x_return_status := fnd_api.g_ret_sts_success;
4515:

Line 4791: UPDATE jtf_tasks_b

4787: x_return_status := fnd_api.g_ret_sts_unexp_error;
4788: RAISE fnd_api.g_exc_unexpected_error;
4789: END IF;
4790:
4791: UPDATE jtf_tasks_b
4792: SET deleted_flag = 'Y'
4793: , last_update_date = SYSDATE
4794: , last_updated_by = fnd_global.user_id
4795: , object_changed_date = SYSDATE