[Home] [Help]
1080:
1081: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;
1082: l_res_tbl jtf_assign_pub.assignresources_tbl_type;
1083: l_res_idx PLS_INTEGER;
1084: l_task_res_tbl csf_resource_tbl;
1085: l_sr_id_tbl jtf_number_table;
1086: l_res_preferred VARCHAR2(1);
1087: l_start_date DATE;
1088: l_end_date DATE;
1097: END IF;
1098:
1099: x_return_status := fnd_api.g_ret_sts_success;
1100:
1101: l_task_res_tbl := csf_resource_tbl();
1102: x_task_resources_tbl := csf_task_resources_tbl_type();
1103:
1104: OPEN c_task_info;
1105: FETCH c_task_info BULK COLLECT INTO l_sr_id_tbl;
1245: , p_init_msg_list IN VARCHAR2
1246: , x_return_status OUT NOCOPY VARCHAR2
1247: , x_msg_count OUT NOCOPY NUMBER
1248: , x_msg_data OUT NOCOPY VARCHAR2
1249: , p_resource_tbl IN csf_resource_tbl
1250: ) IS
1251: l_api_version CONSTANT NUMBER := 1.0;
1252: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_TRIPS_AND_TASKS';
1253:
1260: , jtf_task_assignments ta
1261: , jtf_task_statuses_b ts
1262: , csf_access_hours_b ah
1263: , cac_sr_object_capacity oc
1264: , TABLE ( CAST ( p_resource_tbl AS CSF_RESOURCE_TBL ) ) r
1265: WHERE t.task_id = ta.task_id
1266: AND ta.assignment_status_id = ts.task_status_id
1267: AND t.task_id = ah.task_id(+)
1268: AND ta.resource_id = oc.object_id