[Home] [Help]
305: , a.sched_travel_duration_uom
306: , tb.customer_id party_id
307: , NVL(sb.assigned_flag, 'N') assigned_flag
308: , tb.task_type_id
309: , csf_tasks_pub.get_task_address(tb.task_id,tb.address_id,tb.location_id,'Y') small_address
310: , pi.party_name party_name
311: , a.actual_travel_duration
312: , a.actual_travel_duration_uom
313: , tz.ACTIVE_TIMEZONE_CODE ic_tz_code
1445: , a.sched_travel_duration_uom
1446: , tb.customer_id party_id
1447: , NVL(sb.assigned_flag, 'N') assigned_flag
1448: , tb.task_type_id
1449: , csf_tasks_pub.get_task_address(tb.task_id,tb.address_id,tb.location_id,'Y') small_address
1450: , pi.party_name party_name
1451: , a.actual_travel_duration
1452: , a.actual_travel_duration_uom
1453: , tz.ACTIVE_TIMEZONE_CODE ic_tz_code
2415: , a.sched_travel_duration_uom
2416: , tb.customer_id party_id
2417: , NVL(sb.assigned_flag, 'N') assigned_flag
2418: , tb.task_type_id
2419: , csf_tasks_pub.get_task_address(tb.task_id,tb.address_id,tb.location_id,'Y') small_address
2420: , pi.party_name party_name
2421: , a.actual_travel_duration
2422: , a.actual_travel_duration_uom
2423: , tz.ACTIVE_TIMEZONE_CODE ic_tz_code
3142: , a.sched_travel_duration_uom
3143: , tb.customer_id party_id
3144: , NVL(sb.assigned_flag, 'N') assigned_flag
3145: , tb.task_type_id
3146: , csf_tasks_pub.get_task_address(tb.task_id,tb.address_id,tb.location_id,'Y') small_address
3147: , pi.party_name party_name
3148: , a.actual_travel_duration
3149: , a.actual_travel_duration_uom
3150: , tz.ACTIVE_TIMEZONE_CODE ic_tz_code
4701: test('Updating Task l_planned_effort_uom :'||l_planned_effort_uom);
4702: test('Updating Task l_task_status_id ;'||l_task_status_id);
4703: */
4704:
4705: csf_tasks_pub.update_task(
4706: p_api_version => 1.0
4707: , p_init_msg_list => fnd_api.g_true
4708: , p_commit => fnd_api.g_false
4709: , p_task_id => p_task_id
4872: FETCH c_parent_ovn INTO l_obj_ver_number;
4873: CLOSE c_parent_ovn;
4874:
4875: -- Sync up the Parent and all the other Siblings
4876: csf_tasks_pub.update_task_longer_than_shift(
4877: p_api_version => 1.0
4878: , p_init_msg_list => fnd_api.g_true
4879: , p_commit => fnd_api.g_false
4880: , x_return_status => x_return_status
4881: , x_msg_count => x_msg_count
4882: , x_msg_data => x_msg_data
4883: , p_task_id => l_parent_task_id
4884: , p_object_version_number => l_obj_ver_number
4885: , p_action => csf_tasks_pub.g_action_normal_to_parent
4886: );
4887: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN
4888: RAISE fnd_api.g_exc_error;
4889: END IF;
5355: AND NVL(tsb.cancelled_flag, 'N') <> 'Y'
5356: AND ca.task_id(+) = t.task_id
5357: AND pi.party_id(+) = t.customer_id
5358: AND ps.party_site_id(+) = t.address_id
5359: AND l.location_id(+) = csf_tasks_pub.get_task_location_id(t.task_id,t.address_id,t.location_id)
5360: AND cr.task_id(+) = t.task_id
5361: AND booking_end_date >= booking_start_date;
5362:
5363: ---------------------------------------------------------------------------------------------
5453: AND jd.task_id(+) = t.task_id
5454: AND jdd.dependent_on_task_id(+) = t.task_id
5455: AND pi.party_id(+) = t.customer_id
5456: AND ps.party_site_id(+) = t.address_id
5457: AND l.location_id(+) = csf_tasks_pub.get_task_location_id(t.task_id,t.address_id,t.location_id)
5458: AND cr.task_id(+) = t.task_id
5459: AND booking_end_date >= booking_start_date;
5460: ---------------------------------------------------------------------------------------------
5461: --Cursor C2 introduced when show labels on taskbar is false i.e remove join for hz_parties
6800: AND cpv.task_id = a.task_id
6801: AND ca.task_id(+) = t.task_id
6802: AND pi.party_id(+) = t.customer_id
6803: AND ps.party_site_id(+) = t.address_id
6804: AND l.location_id(+) = csf_tasks_pub.get_task_location_id(t.task_id,t.address_id,t.location_id)
6805: AND cr.task_id(+) = t.task_id
6806: AND (cpv.task_id <> -1 AND cpv.task_id <> p_task_id)
6807: AND tsb.task_status_id = t.task_status_id
6808: AND tsa.task_status_id = a.assignment_status_id
6882: AND cpv.task_id = a.task_id
6883: AND ca.task_id(+) = t.task_id
6884: AND pi.party_id(+) = t.customer_id
6885: AND ps.party_site_id(+) = t.address_id
6886: AND l.location_id(+) = csf_tasks_pub.get_task_location_id(t.task_id,t.address_id,t.location_id)
6887: AND cr.task_id(+) = t.task_id
6888: AND (cpv.task_id <> -1 AND cpv.task_id <> p_task_id)
6889: AND jd.task_id(+) = t.task_id
6890: AND jdd.dependent_on_task_id(+) = t.task_id
7125: AND NVL(tsb.cancelled_flag, 'N') <> 'Y'
7126: AND ca.task_id(+) = t.task_id
7127: AND pi.party_id(+) = t.customer_id
7128: AND ps.party_site_id(+) = t.address_id
7129: AND l.location_id(+) = csf_tasks_pub.get_task_location_id(t.task_id,t.address_id,t.location_id)
7130: AND cr.task_id(+) = t.task_id
7131: AND booking_end_date >= booking_start_date
7132: AND a.object_capacity_id <>res_info.object_capacity_id;
7133:
7228: AND jd.task_id(+) = t.task_id
7229: AND jdd.dependent_on_task_id(+) = t.task_id
7230: AND pi.party_id(+) = t.customer_id
7231: AND ps.party_site_id(+) = t.address_id
7232: AND l.location_id(+) = csf_tasks_pub.get_task_location_id(t.task_id,t.address_id,t.location_id)
7233: AND cr.task_id(+) = t.task_id
7234: AND booking_end_date >= booking_start_date
7235: AND a.object_capacity_id <>res_info.object_capacity_id;
7236: