7: * If there exists any Cancelled Task Assignment for the Task with the given
8: * Resource Information, then that Task Assignment is reused rather than creating a
9: * new Task Assignment afresh.
10: *
11: * If the Trip ID corresponding to the Task Assignment is passed as FND_API.G_MISS_NUM
12: * then the user doesnt want to link the Assignment to any Trip. So the Trip ID will
13: * be saved as NULL corresponding to the Task Assignment.
14: * If Trip ID is passed as NULL or not passed at all, then the API will try to find a
15: * Trip corresponding to the Assignment. Since we are dependent on Trips Model, any
15: * Trip corresponding to the Assignment. Since we are dependent on Trips Model, any
16: * Assignment created for a Field Service Task should be linked to a Trip (based on
17: * Actual Date / Scheduled Dates). If there exists no Trip or there exists multiple trips,
18: * then the API will error out. If Assignment shouldnt be linked to any Trip, then
19: * Trip ID should be passed as FND_API.G_MISS_NUM.
20: *
21: * Except for Task ID, Resouce ID, Resource Type Code all other parameters are optional.
22: */
23: PROCEDURE create_task_assignment (
87: * Given the Task Assignment ID and Task Object Version Number, it calls
88: * JTF Task Assignment API to update the Task Assignment with the new Attributes.
89: * It is actually a two step process
90: * 1. Updating the Task Assignment with the new Task Attributes except Status
91: * 2. Updating the Task Assignment with the new Task Status (if not FND_API.G_MISS_NUM)
92: * by calling UPDATE_ASSIGNMENT_STATUS.
93: *
94: * Because of the two step process, the returned Task Assignment Object
95: * Version Number might be incremented by 2 when user might have expected an
115: , x_msg_count OUT NOCOPY NUMBER
116: , x_msg_data OUT NOCOPY VARCHAR2
117: , p_task_assignment_id IN NUMBER
118: , p_object_version_number IN OUT NOCOPY NUMBER
119: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
120: , p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
121: , p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num
122: , p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
123: , p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
116: , x_msg_data OUT NOCOPY VARCHAR2
117: , p_task_assignment_id IN NUMBER
118: , p_object_version_number IN OUT NOCOPY NUMBER
119: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
120: , p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
121: , p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num
122: , p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
123: , p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
124: , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
117: , p_task_assignment_id IN NUMBER
118: , p_object_version_number IN OUT NOCOPY NUMBER
119: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
120: , p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
121: , p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num
122: , p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
123: , p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
124: , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
125: , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
118: , p_object_version_number IN OUT NOCOPY NUMBER
119: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
120: , p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
121: , p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num
122: , p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
123: , p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
124: , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
125: , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
126: , p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num
119: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
120: , p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
121: , p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num
122: , p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
123: , p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
124: , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
125: , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
126: , p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num
127: , p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num
120: , p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
121: , p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num
122: , p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
123: , p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
124: , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
125: , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
126: , p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num
127: , p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num
128: , p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
121: , p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num
122: , p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
123: , p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
124: , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
125: , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
126: , p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num
127: , p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num
128: , p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
129: , p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num
122: , p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
123: , p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
124: , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
125: , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
126: , p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num
127: , p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num
128: , p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
129: , p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num
130: , p_object_capacity_id IN NUMBER DEFAULT fnd_api.g_miss_num
123: , p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
124: , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
125: , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
126: , p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num
127: , p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num
128: , p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
129: , p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num
130: , p_object_capacity_id IN NUMBER DEFAULT fnd_api.g_miss_num
131: , p_update_task IN VARCHAR2 DEFAULT NULL
124: , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
125: , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
126: , p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num
127: , p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num
128: , p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
129: , p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num
130: , p_object_capacity_id IN NUMBER DEFAULT fnd_api.g_miss_num
131: , p_update_task IN VARCHAR2 DEFAULT NULL
132: , p_task_number IN VARCHAR2 DEFAULT csf_util_pvt.get_miss_char
125: , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
126: , p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num
127: , p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num
128: , p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
129: , p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num
130: , p_object_capacity_id IN NUMBER DEFAULT fnd_api.g_miss_num
131: , p_update_task IN VARCHAR2 DEFAULT NULL
132: , p_task_number IN VARCHAR2 DEFAULT csf_util_pvt.get_miss_char
133: , p_task_name IN VARCHAR2 DEFAULT csf_util_pvt.get_miss_char
126: , p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num
127: , p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num
128: , p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
129: , p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num
130: , p_object_capacity_id IN NUMBER DEFAULT fnd_api.g_miss_num
131: , p_update_task IN VARCHAR2 DEFAULT NULL
132: , p_task_number IN VARCHAR2 DEFAULT csf_util_pvt.get_miss_char
133: , p_task_name IN VARCHAR2 DEFAULT csf_util_pvt.get_miss_char
134: , p_resource_name IN VARCHAR2 DEFAULT csf_util_pvt.get_miss_char