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_TASK_ASSIGNMENTS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 140


    PROCEDURE update_free_busy_type
    (
      p_assignment_status_id     IN NUMBER,
      x_free_busy_type           IN OUT NOCOPY VARCHAR2
    )
    IS
    BEGIN
       select decode(cancelled_flag, 'Y', 'FREE',
              decode(rejected_flag,  'Y', 'FREE',
              decode(working_flag,   'Y', 'BUSY',
              decode(accepted_flag,  'Y', 'BUSY',
              decode(assigned_flag,  'Y', 'BUSY', x_free_busy_type )))))
         into x_free_busy_type
         from jtf_task_statuses_b
        where task_status_id = p_assignment_status_id;

Line: 155


    END update_free_busy_type;

Line: 295


	 SELECT 1
	   FROM jtf_task_all_assignments
	  WHERE ROWID = l_rowid;

Line: 303


      SELECT source_object_type_code
	   , recurrence_rule_id
	   , calendar_start_date
       , calendar_end_date
       , planned_effort
       , planned_effort_uom
       , entity
       , open_flag
	FROM jtf_tasks_b
       WHERE task_id = b_task_id;

Line: 398


	 SELECT jtf_task_assignments_s.nextval
	   INTO l_task_assignment_id
	   FROM dual;

Line: 451


               update_free_busy_type
               (
                p_assignment_status_id => l_assignment_status_id,
                x_free_busy_type       => l_free_busy_type
               );

Line: 460


      jtf_task_assignments_pkg.insert_row (
	 x_rowid => l_rowid,
	 x_task_assignment_id => l_task_assignment_id,
	 x_sched_travel_duration_uom => l_sched_travel_dur_uom,
	 x_actual_travel_distance => l_actual_travel_distance,
	 x_actual_travel_duration => l_actual_travel_duration,
	 x_actual_travel_duration_uom => l_actual_travel_dur_uom,
	 x_actual_start_date => l_actual_start_date,
	 x_actual_end_date => l_actual_end_date,
	 x_palm_flag => l_palm_flag,
	 x_wince_flag => l_wince_flag,
	 x_laptop_flag => l_laptop_flag,
	 x_device1_flag => l_device1_flag,
	 x_device2_flag => l_device2_flag,
	 x_device3_flag => l_device3_flag,
	 x_attribute1 => p_attribute1,
	 x_attribute2 => p_attribute2,
	 x_attribute3 => p_attribute3,
	 x_attribute4 => p_attribute4,
	 x_attribute5 => p_attribute5,
	 x_attribute6 => p_attribute6,
	 x_attribute7 => p_attribute7,
	 x_attribute8 => p_attribute8,
	 x_attribute9 => p_attribute9,
	 x_attribute10 => p_attribute10,
	 x_attribute11 => p_attribute11,
	 x_attribute12 => p_attribute12,
	 x_attribute13 => p_attribute13,
	 x_attribute14 => p_attribute14,
	 x_attribute15 => p_attribute15,
	 x_attribute_category => p_attribute_category,
	 x_task_id => l_task_id,
	 x_resource_id => l_resource_id,
	 x_actual_effort => l_act_eff,
	 x_actual_effort_uom => l_act_eff_uom,
	 x_schedule_flag => l_schedule_flag,
	 x_alarm_type_code => l_alarm_type_code,
	 x_alarm_contact => l_alarm_contact,
	 x_sched_travel_distance => l_sched_travel_distance,
	 x_sched_travel_duration => l_sched_travel_duration,
	 x_resource_type_code => l_resource_type_code,
	 x_creation_date => SYSDATE,
	 x_created_by => jtf_task_utl.created_by,
	 x_last_update_date => SYSDATE,
	 x_last_updated_by => jtf_task_utl.updated_by,
	 x_last_update_login => jtf_task_utl.login_id,
	 x_resource_territory_id => l_resource_territory_id,
	 x_assignment_status_id => l_assignment_status_id,
	 x_shift_construct_id => l_shift_construct_id,
	 x_assignee_role => l_assignee_role,
	 x_show_on_calendar => l_show_on_calendar,
	 x_category_id => l_category_id,
	 x_free_busy_type => NVL(l_free_busy_type, g_free_busy_type),
         x_booking_start_date => l_booking_start_date,
         x_booking_end_date => l_booking_end_date,
         x_object_capacity_id => p_object_capacity_id
      );

Line: 1096


   PROCEDURE update_task_assignment (
      p_api_version		     IN       NUMBER,
      p_object_version_number	     IN       OUT NOCOPY   NUMBER,
      p_init_msg_list		     IN       VARCHAR2 DEFAULT fnd_api.g_false,
      p_commit			     IN       VARCHAR2 DEFAULT fnd_api.g_false,
      p_task_assignment_id	     IN       NUMBER DEFAULT fnd_api.g_miss_num,
      p_resource_type_code	     IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_resource_id		     IN       NUMBER DEFAULT fnd_api.g_miss_num,
      p_actual_effort		     IN       NUMBER DEFAULT fnd_api.g_miss_num,
      p_actual_effort_uom	     IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_schedule_flag		     IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_alarm_type_code 	     IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_alarm_contact		     IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_sched_travel_distance	     IN       NUMBER DEFAULT fnd_api.g_miss_num,
      p_sched_travel_duration	     IN       NUMBER DEFAULT fnd_api.g_miss_num,
      p_sched_travel_duration_uom    IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_actual_travel_distance	     IN       NUMBER DEFAULT fnd_api.g_miss_num,
      p_actual_travel_duration	     IN       NUMBER DEFAULT fnd_api.g_miss_num,
      p_actual_travel_duration_uom   IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_actual_start_date	     IN       DATE DEFAULT fnd_api.g_miss_date,
      p_actual_end_date 	     IN       DATE DEFAULT fnd_api.g_miss_date,
      p_palm_flag		     IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_wince_flag		     IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_laptop_flag		     IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_device1_flag		     IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_device2_flag		     IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_device3_flag		     IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
      p_resource_territory_id	     IN       NUMBER DEFAULT fnd_api.g_miss_num,
      p_assignment_status_id	     IN       NUMBER DEFAULT fnd_api.g_miss_num,
      p_shift_construct_id	     IN       NUMBER DEFAULT fnd_api.g_miss_num,
      x_return_status		     OUT      NOCOPY      VARCHAR2,
      x_msg_count		     OUT      NOCOPY      NUMBER,
      x_msg_data		     OUT      NOCOPY      VARCHAR2,
      p_attribute1		     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute2		     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute3		     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute4		     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute5		     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute6		     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute7		     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute8		     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute9		     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute10		     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute11		     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute12		     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute13		     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute14		     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute15		     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_attribute_category	     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_assignee_role		     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_show_on_calendar	     IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
      p_category_id		     IN       NUMBER DEFAULT jtf_task_utl.g_miss_number,
      p_enable_workflow 	     IN       VARCHAR2,
      p_abort_workflow		     IN       VARCHAR2,
      p_free_busy_type		     IN       VARCHAR2
   )
   IS
   BEGIN
      jtf_task_assignments_pvt.update_task_assignment (
      p_api_version		     => p_api_version,
      p_object_version_number	     => p_object_version_number,
      p_init_msg_list		     => p_init_msg_list,
      p_commit			     => p_commit,
      p_task_assignment_id	     => p_task_assignment_id,
      p_resource_type_code	     => p_resource_type_code,
      p_resource_id		     => p_resource_id,
      p_actual_effort		     => p_actual_effort,
      p_actual_effort_uom	     => p_actual_effort_uom,
      p_schedule_flag		     => p_schedule_flag,
      p_alarm_type_code 	     => p_alarm_type_code,
      p_alarm_contact		     => p_alarm_contact,
      p_sched_travel_distance	     => p_sched_travel_distance,
      p_sched_travel_duration	     => p_sched_travel_duration,
      p_sched_travel_duration_uom    => p_sched_travel_duration_uom,
      p_actual_travel_distance	     => p_actual_travel_distance,
      p_actual_travel_duration	     => p_actual_travel_duration,
      p_actual_travel_duration_uom   => p_actual_travel_duration_uom,
      p_actual_start_date	     => p_actual_start_date,
      p_actual_end_date 	     => p_actual_end_date,
      p_palm_flag		     => p_palm_flag,
      p_wince_flag		     => p_wince_flag,
      p_laptop_flag		     => p_laptop_flag,
      p_device1_flag		     => p_device1_flag,
      p_device2_flag		     => p_device2_flag,
      p_device3_flag		     => p_device3_flag,
      p_resource_territory_id	     => p_resource_territory_id,
      p_assignment_status_id	     => p_assignment_status_id,
      p_shift_construct_id	     => p_shift_construct_id,
      x_return_status		     => x_return_status,
      x_msg_count		     => x_msg_count,
      x_msg_data		     => x_msg_data,
      p_attribute1		     => p_attribute1,
      p_attribute2		     => p_attribute2,
      p_attribute3		     => p_attribute3,
      p_attribute4		     => p_attribute4,
      p_attribute5		     => p_attribute5,
      p_attribute6		     => p_attribute6,
      p_attribute7		     => p_attribute7,
      p_attribute8		     => p_attribute8,
      p_attribute9		     => p_attribute9,
      p_attribute10		     => p_attribute10,
      p_attribute11		     => p_attribute11,
      p_attribute12		     => p_attribute12,
      p_attribute13		     => p_attribute13,
      p_attribute14		     => p_attribute14,
      p_attribute15		     => p_attribute15,
      p_attribute_category	     => p_attribute_category,
      p_assignee_role		     => p_assignee_role,
      p_show_on_calendar	     => p_show_on_calendar,
      p_category_id		     => p_category_id,
      p_enable_workflow 	     => p_enable_workflow,
      p_abort_workflow		     => p_abort_workflow,
      p_free_busy_type		     => p_free_busy_type,
      p_object_capacity_id           => fnd_api.g_miss_num
      );

Line: 1214


   PROCEDURE update_task_assignment (
      p_api_version		     IN       NUMBER,
      p_object_version_number	     IN OUT NOCOPY   NUMBER,
      p_init_msg_list		     IN       VARCHAR2 DEFAULT fnd_api.g_false,
      p_commit			     IN       VARCHAR2 DEFAULT fnd_api.g_false,
      p_task_assignment_id	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_resource_type_code	     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_resource_id		     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_actual_effort		     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_actual_effort_uom	     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_schedule_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_alarm_type_code 	     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_alarm_contact		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_sched_travel_distance	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_sched_travel_duration	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_sched_travel_duration_uom    IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_actual_travel_distance	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_actual_travel_duration	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_actual_travel_duration_uom   IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_actual_start_date	     IN       DATE DEFAULT fnd_api.g_miss_date,
      p_actual_end_date 	     IN       DATE DEFAULT fnd_api.g_miss_date,
      p_palm_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_wince_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_laptop_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_device1_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_device2_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_device3_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_resource_territory_id	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_assignment_status_id	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_shift_construct_id	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      x_return_status		     OUT NOCOPY      VARCHAR2,
      x_msg_count		     OUT NOCOPY      NUMBER,
      x_msg_data		     OUT NOCOPY      VARCHAR2,
      p_attribute1		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute2		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute3		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute4		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute5		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute6		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute7		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute8		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute9		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute10		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute11		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute12		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute13		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute14		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute15		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute_category	     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_assignee_role		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_show_on_calendar	     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_category_id		     IN       NUMBER
	    DEFAULT jtf_task_utl.g_miss_number,
      p_enable_workflow 	     IN       VARCHAR2,
      p_abort_workflow		     IN       VARCHAR2,
      p_free_busy_type		     IN       VARCHAR2,
      p_object_capacity_id           IN       NUMBER
   )
   IS
      l_api_version	CONSTANT NUMBER
	       := 1.0;

Line: 1317


	       := 'Update_Task_Assignment';

Line: 1382


      l_session 		 VARCHAR2(10) := 'UPDATE';

Line: 1397


	 SELECT task_id,
		assignment_status_id   old_assignment_status_id,
		DECODE (
		   p_resource_id,
		   fnd_api.g_miss_num, resource_id,
		   p_resource_id
		) resource_id,
		DECODE (
		   p_resource_type_code,
		   fnd_api.g_miss_char, resource_type_code,
		   p_resource_type_code
		) resource_type_code,
		DECODE (
		   p_assignment_status_id,
		   fnd_api.g_miss_num, assignment_status_id,
		   p_assignment_status_id
		) assignment_status_id,
		DECODE (
		   p_actual_effort,
		   fnd_api.g_miss_num, actual_effort,
		   p_actual_effort
		) actual_effort,
		DECODE (
		   p_actual_effort_uom,
		   fnd_api.g_miss_char, actual_effort_uom,
		   p_actual_effort_uom
		) actual_effort_uom,
		DECODE (
		   p_alarm_type_code,
		   fnd_api.g_miss_char, alarm_type_code,
		   p_alarm_type_code
		) alarm_type_code,
		DECODE (
		   p_alarm_contact,
		   fnd_api.g_miss_char, alarm_contact,
		   p_alarm_contact
		) alarm_contact,
		DECODE (
		   p_sched_travel_distance,
		   fnd_api.g_miss_num, sched_travel_distance,
		   p_sched_travel_distance
		) sched_travel_distance,
		DECODE (
		   p_sched_travel_duration,
		   fnd_api.g_miss_num, sched_travel_duration,
		   p_sched_travel_duration
		) sched_travel_duration,
		DECODE (
		   p_sched_travel_duration_uom,
		   fnd_api.g_miss_char, sched_travel_duration_uom,
		   p_sched_travel_duration_uom
		) sched_travel_dur_uom,
		DECODE (
		   p_actual_travel_distance,
		   fnd_api.g_miss_num, actual_travel_distance,
		   p_actual_travel_distance
		) actual_travel_distance,
		DECODE (
		   p_actual_travel_duration,
		   fnd_api.g_miss_num, actual_travel_duration,
		   p_actual_travel_duration
		) actual_travel_duration,
		DECODE (
		   p_resource_territory_id,
		   fnd_api.g_miss_num, resource_territory_id,
		   p_resource_territory_id
		) resource_territory_id,
		DECODE (
		   p_shift_construct_id,
		   fnd_api.g_miss_num, shift_construct_id,
		   p_shift_construct_id
		) shift_construct_id,
		DECODE (
		   p_actual_travel_duration_uom,
		   fnd_api.g_miss_char, actual_travel_duration_uom,
		   p_actual_travel_duration_uom
		) actual_travel_dur_uom,
		DECODE (
		   p_schedule_flag,
		   fnd_api.g_miss_char, schedule_flag,
		   p_schedule_flag
		) schedule_flag,
		DECODE (
		   p_actual_start_date,
		   fnd_api.g_miss_date, actual_start_date,
		   p_actual_start_date
		) actual_start_date,
		DECODE (
		   p_actual_end_date,
		   fnd_api.g_miss_date, actual_end_date,
		   p_actual_end_date
		) actual_end_date,
		DECODE (
		   p_palm_flag,
		   fnd_api.g_miss_char, palm_flag,
		   p_palm_flag
		) palm_flag,
		DECODE (
		   p_wince_flag,
		   fnd_api.g_miss_char, wince_flag,
		   p_wince_flag
		) wince_flag,
		DECODE (
		   p_laptop_flag,
		   fnd_api.g_miss_char, laptop_flag,
		   p_laptop_flag
		) laptop_flag,
		DECODE (
		   p_device1_flag,
		   fnd_api.g_miss_char, device1_flag,
		   p_device1_flag
		) device1_flag,
		DECODE (
		   p_device2_flag,
		   fnd_api.g_miss_char, device2_flag,
		   p_device2_flag
		) device2_flag,
		DECODE (
		   p_device3_flag,
		   fnd_api.g_miss_char, device3_flag,
		   p_device3_flag
		) device3_flag,
		DECODE (
		   p_assignee_role,
		   fnd_api.g_miss_char, assignee_role,
		   p_assignee_role
		) assignee_role,
		DECODE (
		   p_show_on_calendar,
		   fnd_api.g_miss_char, show_on_calendar,
		   p_show_on_calendar
		) show_on_calendar,
		DECODE (
		   p_category_id,
		   jtf_task_utl.g_miss_number, category_id,
		   p_category_id
		) category_id,
		DECODE (
		   p_attribute1,
		   fnd_api.g_miss_char, attribute1,
		   p_attribute1
		) attribute1,
		DECODE (
		   p_attribute2,
		   fnd_api.g_miss_char, attribute2,
		   p_attribute2
		) attribute2,
		DECODE (
		   p_attribute3,
		   fnd_api.g_miss_char, attribute3,
		   p_attribute3
		) attribute3,
		DECODE (
		   p_attribute4,
		   fnd_api.g_miss_char, attribute4,
		   p_attribute4
		) attribute4,
		DECODE (
		   p_attribute5,
		   fnd_api.g_miss_char, attribute5,
		   p_attribute5
		) attribute5,
		DECODE (
		   p_attribute6,
		   fnd_api.g_miss_char, attribute6,
		   p_attribute6
		) attribute6,
		DECODE (
		   p_attribute7,
		   fnd_api.g_miss_char, attribute7,
		   p_attribute7
		) attribute7,
		DECODE (
		   p_attribute8,
		   fnd_api.g_miss_char, attribute8,
		   p_attribute8
		) attribute8,
		DECODE (
		   p_attribute9,
		   fnd_api.g_miss_char, attribute9,
		   p_attribute9
		) attribute9,
		DECODE (
		   p_attribute10,
		   fnd_api.g_miss_char, attribute10,
		   p_attribute10
		) attribute10,
		DECODE (
		   p_attribute11,
		   fnd_api.g_miss_char, attribute11,
		   p_attribute11
		) attribute11,
		DECODE (
		   p_attribute12,
		   fnd_api.g_miss_char, attribute12,
		   p_attribute12
		) attribute12,
		DECODE (
		   p_attribute13,
		   fnd_api.g_miss_char, attribute13,
		   p_attribute13
		) attribute13,
		DECODE (
		   p_attribute14,
		   fnd_api.g_miss_char, attribute14,
		   p_attribute14
		) attribute14,
		DECODE (
		   p_attribute15,
		   fnd_api.g_miss_char, attribute15,
		   p_attribute15
		) attribute15,
		DECODE (
		   p_attribute_category,
		   fnd_api.g_miss_char, attribute_category,
		   p_attribute_category
		) attribute_category,
		DECODE (
		   p_free_busy_type,
		   jtf_task_utl.g_miss_char, free_busy_type,
		   p_free_busy_type
		) free_busy_type,
		DECODE (
		   p_object_capacity_id,
		   fnd_api.g_miss_num, object_capacity_id,
		   p_object_capacity_id
		) object_capacity_id
	   FROM jtf_task_all_assignments
	  WHERE task_assignment_id = l_task_assignment_id;

Line: 1647


      SELECT source_object_type_code
	   , recurrence_rule_id
	   , calendar_start_date
       , calendar_end_date
       , planned_effort
       , planned_effort_uom
       , open_flag
       , entity
	   FROM jtf_tasks_b
       WHERE task_id = b_task_id;

Line: 1668


      SAVEPOINT update_task_assign_pvt;

Line: 1786


	     --    to update the assignment status with accepted or rejected.
	     -- So this procedure must return right after the call because
	     --    the remaining process has already been processed
	     --    by response_invitation().
	     ----------------------------------------------------------------
	     RETURN;

Line: 1830


      UPDATE jtf_task_all_assignments
	 SET category_id = p_category_id
       WHERE task_id = l_task_id
	 AND resource_id = (SELECT resource_id
			    FROM jtf_rs_resource_extns
			    WHERE user_id = fnd_global.user_id)
	 AND resource_type_code not in ('RS_GROUP','RS_TEAM');

Line: 1864


      select assignee_role
      into l_assignee_role_db
      from jtf_task_all_assignments
      where task_assignment_id = l_task_assignment_id;

Line: 1870


	 UPDATE jtf_tasks_b
	    SET owner_id = l_resource_id,
		owner_type_code = l_resource_type_code
	  WHERE task_id = l_task_id;

Line: 1920


         update_free_busy_type(
            p_assignment_status_id => l_assignment_status_id,
            x_free_busy_type       => l_free_busy_type
         );

Line: 1927


      jtf_task_assignments_pkg.update_row (
	 x_task_assignment_id => l_task_assignment_id,
	 x_object_version_number => p_object_version_number,
	 x_sched_travel_duration_uom => l_sched_travel_dur_uom,
	 x_actual_travel_distance => l_actual_travel_distance,
	 x_actual_travel_duration => l_actual_travel_duration,
	 x_actual_travel_duration_uom => l_actual_travel_dur_uom,
	 x_actual_start_date => l_actual_start_date,
	 x_actual_end_date => l_actual_end_date,
	 x_palm_flag => l_palm_flag,
	 x_wince_flag => l_wince_flag,
	 x_laptop_flag => l_laptop_flag,
	 x_device1_flag => l_device1_flag,
	 x_device2_flag => l_device2_flag,
	 x_device3_flag => l_device3_flag,
	 x_attribute1 => task_ass.attribute1,
	 x_attribute2 => task_ass.attribute2,
	 x_attribute3 => task_ass.attribute3,
	 x_attribute4 => task_ass.attribute4,
	 x_attribute5 => task_ass.attribute5,
	 x_attribute6 => task_ass.attribute6,
	 x_attribute7 => task_ass.attribute7,
	 x_attribute8 => task_ass.attribute8,
	 x_attribute9 => task_ass.attribute9,
	 x_attribute10 => task_ass.attribute10,
	 x_attribute11 => task_ass.attribute11,
	 x_attribute12 => task_ass.attribute12,
	 x_attribute13 => task_ass.attribute13,
	 x_attribute14 => task_ass.attribute14,
	 x_attribute15 => task_ass.attribute15,
	 x_attribute_category => task_ass.attribute_category,
	 x_task_id => l_task_id,
	 x_resource_id => l_resource_id,
	 x_actual_effort => l_act_eff,
	 x_actual_effort_uom => l_act_eff_uom,
	 x_schedule_flag => l_schedule_flag,
	 x_alarm_type_code => l_alarm_type_code,
	 x_alarm_contact => l_alarm_contact,
	 x_sched_travel_distance => l_sched_travel_distance,
	 x_sched_travel_duration => l_sched_travel_duration,
	 x_resource_type_code => l_resource_type_code,
	 x_last_update_date => SYSDATE,
	 x_last_updated_by => jtf_task_utl.updated_by,
	 x_last_update_login => jtf_task_utl.login_id,
	 x_resource_territory_id => l_resource_territory_id,
	 x_assignment_status_id => l_assignment_status_id,
	 x_shift_construct_id => l_shift_construct_id,
	 x_assignee_role => l_assignee_role,
	 x_show_on_calendar => l_show_on_calendar,
       --x_category_id => l_category_id
	 x_free_busy_type => NVL(l_free_busy_type, g_free_busy_type),
   x_booking_start_date => l_booking_start_date,
	 x_booking_end_date => l_booking_end_date,
   x_object_capacity_id => l_object_capacity_id
      );

Line: 1995


	 jtf_task_utl.delete_party_reference(
	    p_reference_from	=> 'ASSIGNMENT',
	    p_task_id	    => l_task_id,
	    p_party_type_code	=> l_orig_res_type_code,
	    p_party_id	    => l_orig_res_id,
	    x_msg_count     => x_msg_count,
	    x_msg_data	    => x_msg_data,
	    x_return_status	=> x_return_status);

Line: 2060


     jtf_task_wf_events_pvt.publish_update_assignment(l_assignment_rec_new,l_assignment_rec_old,x_event_return_status);

Line: 2097


	 ROLLBACK TO update_task_assign_pvt;

Line: 2110


	 ROLLBACK TO update_task_assign_pvt;

Line: 2124


   PROCEDURE update_task_assignment (
      p_api_version		     IN       NUMBER,
      p_object_version_number	     IN OUT NOCOPY   NUMBER,
      p_init_msg_list		     IN       VARCHAR2 DEFAULT fnd_api.g_false,
      p_commit			     IN       VARCHAR2 DEFAULT fnd_api.g_false,
      p_task_assignment_id	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_resource_type_code	     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_resource_id		     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_actual_effort		     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_actual_effort_uom	     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_schedule_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_alarm_type_code 	     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_alarm_contact		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_sched_travel_distance	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_sched_travel_duration	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_sched_travel_duration_uom    IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_actual_travel_distance	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_actual_travel_duration	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_actual_travel_duration_uom   IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_actual_start_date	     IN       DATE DEFAULT fnd_api.g_miss_date,
      p_actual_end_date 	     IN       DATE DEFAULT fnd_api.g_miss_date,
      p_palm_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_wince_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_laptop_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_device1_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_device2_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_device3_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_resource_territory_id	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_assignment_status_id	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_shift_construct_id	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      x_return_status		     OUT NOCOPY      VARCHAR2,
      x_msg_count		     OUT NOCOPY      NUMBER,
      x_msg_data		     OUT NOCOPY      VARCHAR2,
      p_attribute1		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute2		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute3		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute4		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute5		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute6		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute7		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute8		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute9		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute10		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute11		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute12		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute13		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute14		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute15		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute_category	     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_assignee_role		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_show_on_calendar	     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_category_id		     IN       NUMBER
	    DEFAULT jtf_task_utl.g_miss_number
   )
   IS
   BEGIN
      jtf_task_assignments_pvt.update_task_assignment (
      p_api_version		     => p_api_version,
      p_object_version_number	     => p_object_version_number,
      p_init_msg_list		     => p_init_msg_list,
      p_commit			     => p_commit,
      p_task_assignment_id	     => p_task_assignment_id,
      p_resource_type_code	     => p_resource_type_code,
      p_resource_id		     => p_resource_id,
      p_actual_effort		     => p_actual_effort,
      p_actual_effort_uom	     => p_actual_effort_uom,
      p_schedule_flag		     => p_schedule_flag,
      p_alarm_type_code 	     => p_alarm_type_code,
      p_alarm_contact		     => p_alarm_contact,
      p_sched_travel_distance	     => p_sched_travel_distance,
      p_sched_travel_duration	     => p_sched_travel_duration,
      p_sched_travel_duration_uom    => p_sched_travel_duration_uom,
      p_actual_travel_distance	     => p_actual_travel_distance,
      p_actual_travel_duration	     => p_actual_travel_duration,
      p_actual_travel_duration_uom   => p_actual_travel_duration_uom,
      p_actual_start_date	     => p_actual_start_date,
      p_actual_end_date 	     => p_actual_end_date,
      p_palm_flag		     => p_palm_flag,
      p_wince_flag		     => p_wince_flag,
      p_laptop_flag		     => p_laptop_flag,
      p_device1_flag		     => p_device1_flag,
      p_device2_flag		     => p_device2_flag,
      p_device3_flag		     => p_device3_flag,
      p_resource_territory_id	     => p_resource_territory_id,
      p_assignment_status_id	     => p_assignment_status_id,
      p_shift_construct_id	     => p_shift_construct_id,
      x_return_status		     => x_return_status,
      x_msg_count		     => x_msg_count,
      x_msg_data		     => x_msg_data,
      p_attribute1		     => p_attribute1,
      p_attribute2		     => p_attribute2,
      p_attribute3		     => p_attribute3,
      p_attribute4		     => p_attribute4,
      p_attribute5		     => p_attribute5,
      p_attribute6		     => p_attribute6,
      p_attribute7		     => p_attribute7,
      p_attribute8		     => p_attribute8,
      p_attribute9		     => p_attribute9,
      p_attribute10		     => p_attribute10,
      p_attribute11		     => p_attribute11,
      p_attribute12		     => p_attribute12,
      p_attribute13		     => p_attribute13,
      p_attribute14		     => p_attribute14,
      p_attribute15		     => p_attribute15,
      p_attribute_category	     => p_attribute_category,
      p_assignee_role		     => p_assignee_role,
      p_show_on_calendar	     => p_show_on_calendar,
      p_category_id		     => p_category_id,
      p_enable_workflow 	     => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
      p_abort_workflow		     => fnd_profile.value('JTF_TASK_ABORT_PREV_WF'),
      p_free_busy_type		     => fnd_api.g_miss_char
      );

Line: 2279


    PROCEDURE update_task_assignment (
      p_api_version		     IN       NUMBER,
      p_object_version_number	     IN OUT NOCOPY   NUMBER,
      p_init_msg_list		     IN       VARCHAR2 DEFAULT fnd_api.g_false,
      p_commit			     IN       VARCHAR2 DEFAULT fnd_api.g_false,
      p_task_assignment_id	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_resource_type_code	     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_resource_id		     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_actual_effort		     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_actual_effort_uom	     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_schedule_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_alarm_type_code 	     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_alarm_contact		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_sched_travel_distance	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_sched_travel_duration	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_sched_travel_duration_uom    IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_actual_travel_distance	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_actual_travel_duration	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_actual_travel_duration_uom   IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_actual_start_date	     IN       DATE DEFAULT fnd_api.g_miss_date,
      p_actual_end_date 	     IN       DATE DEFAULT fnd_api.g_miss_date,
      p_palm_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_wince_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_laptop_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_device1_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_device2_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_device3_flag		     IN       VARCHAR2
	    DEFAULT fnd_api.g_miss_char,
      p_resource_territory_id	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_assignment_status_id	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      p_shift_construct_id	     IN       NUMBER
	    DEFAULT fnd_api.g_miss_num,
      x_return_status		     OUT NOCOPY      VARCHAR2,
      x_msg_count		     OUT NOCOPY      NUMBER,
      x_msg_data		     OUT NOCOPY      VARCHAR2,
      p_attribute1		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute2		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute3		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute4		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute5		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute6		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute7		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute8		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute9		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute10		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute11		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute12		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute13		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute14		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute15		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_attribute_category	     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_assignee_role		     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_show_on_calendar	     IN       VARCHAR2
	    DEFAULT jtf_task_utl.g_miss_char,
      p_category_id		     IN       NUMBER
	    DEFAULT jtf_task_utl.g_miss_number,
	  p_enable_workflow 	     IN       VARCHAR2,
      p_abort_workflow		     IN       VARCHAR2
   )
   IS
   BEGIN
      jtf_task_assignments_pvt.update_task_assignment (
      p_api_version		     => p_api_version,
      p_object_version_number	     => p_object_version_number,
      p_init_msg_list		     => p_init_msg_list,
      p_commit			     => p_commit,
      p_task_assignment_id	     => p_task_assignment_id,
      p_resource_type_code	     => p_resource_type_code,
      p_resource_id		     => p_resource_id,
      p_actual_effort		     => p_actual_effort,
      p_actual_effort_uom	     => p_actual_effort_uom,
      p_schedule_flag		     => p_schedule_flag,
      p_alarm_type_code 	     => p_alarm_type_code,
      p_alarm_contact		     => p_alarm_contact,
      p_sched_travel_distance	     => p_sched_travel_distance,
      p_sched_travel_duration	     => p_sched_travel_duration,
      p_sched_travel_duration_uom    => p_sched_travel_duration_uom,
      p_actual_travel_distance	     => p_actual_travel_distance,
      p_actual_travel_duration	     => p_actual_travel_duration,
      p_actual_travel_duration_uom   => p_actual_travel_duration_uom,
      p_actual_start_date	     => p_actual_start_date,
      p_actual_end_date 	     => p_actual_end_date,
      p_palm_flag		     => p_palm_flag,
      p_wince_flag		     => p_wince_flag,
      p_laptop_flag		     => p_laptop_flag,
      p_device1_flag		     => p_device1_flag,
      p_device2_flag		     => p_device2_flag,
      p_device3_flag		     => p_device3_flag,
      p_resource_territory_id	     => p_resource_territory_id,
      p_assignment_status_id	     => p_assignment_status_id,
      p_shift_construct_id	     => p_shift_construct_id,
      x_return_status		     => x_return_status,
      x_msg_count		     => x_msg_count,
      x_msg_data		     => x_msg_data,
      p_attribute1		     => p_attribute1,
      p_attribute2		     => p_attribute2,
      p_attribute3		     => p_attribute3,
      p_attribute4		     => p_attribute4,
      p_attribute5		     => p_attribute5,
      p_attribute6		     => p_attribute6,
      p_attribute7		     => p_attribute7,
      p_attribute8		     => p_attribute8,
      p_attribute9		     => p_attribute9,
      p_attribute10		     => p_attribute10,
      p_attribute11		     => p_attribute11,
      p_attribute12		     => p_attribute12,
      p_attribute13		     => p_attribute13,
      p_attribute14		     => p_attribute14,
      p_attribute15		     => p_attribute15,
      p_attribute_category	     => p_attribute_category,
      p_assignee_role		     => p_assignee_role,
      p_show_on_calendar	     => p_show_on_calendar,
      p_category_id		     => p_category_id,
      p_enable_workflow 	     => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
      p_abort_workflow		     => fnd_profile.value('JTF_TASK_ABORT_PREV_WF'),
      p_free_busy_type		     => fnd_api.g_miss_char
      );

Line: 2436


   PROCEDURE delete_task_assignment (
      p_api_version		IN	 NUMBER,
      p_object_version_number	IN	 NUMBER,
      p_init_msg_list		IN	 VARCHAR2 DEFAULT fnd_api.g_false,
      p_commit			IN	 VARCHAR2 DEFAULT fnd_api.g_false,
      p_task_assignment_id	IN	 NUMBER,
      x_return_status		OUT NOCOPY	VARCHAR2,
      x_msg_count		OUT NOCOPY	NUMBER,
      x_msg_data		OUT NOCOPY	VARCHAR2,
      p_enable_workflow 	IN	 VARCHAR2,
      p_abort_workflow		IN	 VARCHAR2,
      p_delete_option	      IN       VARCHAR2
   )
   IS
      --Declare the variables
      l_task_assignment_id   jtf_task_all_assignments.task_assignment_id%TYPE
	       := p_task_assignment_id;

Line: 2457


	 SELECT 1
	   FROM jtf_task_all_assignments
	  WHERE task_assignment_id = l_task_assignment_id;

Line: 2461


      l_session VARCHAR2(10) := 'DELETE';

Line: 2471


	 SELECT task_id, resource_id, resource_type_code, assignee_role, assignment_status_id
	   FROM jtf_task_all_assignments
	  WHERE task_assignment_id = b_task_assignment_id;

Line: 2482


      SELECT jtb.source_object_type_code
	   , jtb.recurrence_rule_id
	   , jtb.calendar_start_date
	   , jtb.task_id
	   , jtaa.resource_id
       , jtb.entity
	FROM jtf_tasks_b jtb
	   , jtf_task_all_assignments jtaa
       WHERE jtaa.task_assignment_id = b_task_assignment_id
	 AND jtb.task_id = jtaa.task_id;

Line: 2495


      l_delete_assignee_rec  jtf_task_repeat_assignment_pvt.delete_assignee_rec;

Line: 2502


      SAVEPOINT delete_task_ass_pvt;

Line: 2526


	 IF p_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE OR
	    p_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE OR
	    p_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ALL
	 THEN
	     l_delete_assignee_rec.recurrence_rule_id	 := rec_task.recurrence_rule_id;

Line: 2531


	     l_delete_assignee_rec.task_id		 := l_task_id;

Line: 2532


	     l_delete_assignee_rec.calendar_start_date	 := rec_task.calendar_start_date;

Line: 2533


	     l_delete_assignee_rec.resource_id		 := rec_task.resource_id;

Line: 2534


	     l_delete_assignee_rec.delete_option	 := p_delete_option;

Line: 2535


	     l_delete_assignee_rec.enable_workflow	 := p_enable_workflow;

Line: 2536


	     l_delete_assignee_rec.abort_workflow	 := p_abort_workflow;

Line: 2538


	     jtf_task_repeat_assignment_pvt.delete_assignee(
		p_api_version	      => 1.0,
		p_init_msg_list       => fnd_api.g_false,
		p_commit	      => fnd_api.g_false,
		p_delete_assignee_rec => l_delete_assignee_rec,
		x_return_status       => x_return_status,
		x_msg_count	      => x_msg_count,
		x_msg_data	      => x_msg_data
	     );

Line: 2549


	  ELSIF p_delete_option IS NOT NULL AND
		p_delete_option <> JTF_TASK_REPEAT_APPT_PVT.G_SKIP
	  THEN
	     fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');

Line: 2553


	     fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_delete_option ');

Line: 2613


      jtf_task_assignments_pkg.delete_row (
	 x_task_assignment_id => l_task_assignment_id
      );

Line: 2639


	    jtf_task_utl.delete_party_reference(
	       p_reference_from     => 'ASSIGNMENT',
	       p_task_id	=> l_task_id,
	       p_party_type_code	=> l_resource_type_code,
	       p_party_id	=> l_resource_id,
	       x_msg_count	=> x_msg_count,
	       x_msg_data	=> x_msg_data,
	       x_return_status	    => x_return_status);

Line: 2670


      jtf_task_wf_events_pvt.publish_delete_assignment(l_assignment_rec, x_event_return_status);

Line: 2702


	 ROLLBACK TO delete_task_ass_pvt;

Line: 2710


	 ROLLBACK TO delete_task_ass_pvt;

Line: 2724


   PROCEDURE delete_task_assignment (
      p_api_version		IN	 NUMBER,
      p_object_version_number	IN	 NUMBER,
      p_init_msg_list		IN	 VARCHAR2 DEFAULT fnd_api.g_false,
      p_commit			IN	 VARCHAR2 DEFAULT fnd_api.g_false,
      p_task_assignment_id	IN	 NUMBER,
      x_return_status		OUT NOCOPY	VARCHAR2,
      x_msg_count		OUT NOCOPY	NUMBER,
      x_msg_data		OUT NOCOPY	VARCHAR2,
      p_enable_workflow 	IN	 VARCHAR2,
      p_abort_workflow		IN	 VARCHAR2
   )
   IS
   BEGIN
      jtf_task_assignments_pvt.delete_task_assignment (
      p_api_version		=> p_api_version,
      p_object_version_number	=> p_object_version_number,
      p_init_msg_list		=> p_init_msg_list,
      p_commit			=> p_commit,
      p_task_assignment_id	=> p_task_assignment_id,
      x_return_status		=> x_return_status,
      x_msg_count		=> x_msg_count,
      x_msg_data		=> x_msg_data,
      p_enable_workflow 	=> p_enable_workflow,
      p_abort_workflow		=> p_abort_workflow,
      p_delete_option		=> JTF_TASK_REPEAT_APPT_PVT.G_ONE
      );

Line: 2753


   PROCEDURE delete_task_assignment (
      p_api_version		IN	 NUMBER,
      p_object_version_number	IN	 NUMBER,
      p_init_msg_list		IN	 VARCHAR2 DEFAULT fnd_api.g_false,
      p_commit			IN	 VARCHAR2 DEFAULT fnd_api.g_false,
      p_task_assignment_id	IN	 NUMBER,
      x_return_status		OUT NOCOPY	VARCHAR2,
      x_msg_count		OUT NOCOPY	NUMBER,
      x_msg_data		OUT NOCOPY	VARCHAR2
   )
   IS
   BEGIN
      jtf_task_assignments_pvt.delete_task_assignment (
      p_api_version		=> p_api_version,
      p_object_version_number	=> p_object_version_number,
      p_init_msg_list		=> p_init_msg_list,
      p_commit			=> p_commit,
      p_task_assignment_id	=> p_task_assignment_id,
      x_return_status		=> x_return_status,
      x_msg_count		=> x_msg_count,
      x_msg_data		=> x_msg_data,
      p_enable_workflow 	=> fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
      p_abort_workflow		=> fnd_profile.value('JTF_TASK_ABORT_PREV_WF')
      );