368: ) IS
369: l_api_version CONSTANT NUMBER := 1.0;
370: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SEARCH_REQUEST';
371:
372: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;
373: l_res_tbl csf_requests_pvt.resource_tbl_type;
374: j PLS_INTEGER;
375: k PLS_INTEGER;
376:
406:
407: -- Validate the Planned Window (same logic as that done in DC)
408: csf_tasks_pub.validate_planned_dates(l_task_info.planned_start_date, l_task_info.planned_end_date);
409:
410: csf_resource_pub.get_resources_to_schedule(
411: p_api_version => 1
412: , p_init_msg_list => fnd_api.g_false
413: , x_return_status => x_return_status
414: , x_msg_count => x_msg_count
567:
568: i PLS_INTEGER;
569: l_child_request_id NUMBER;
570: l_res_tbl csf_requests_pvt.resource_tbl_type;
571: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;
572:
573: CURSOR c_task_info (p_task_id NUMBER) IS
574: SELECT t.task_id
575: , t.planned_start_date
621: -- Validate the Planned Window (same logic as that done in DC)
622: csf_tasks_pub.validate_planned_dates(l_task_info.planned_start_date, l_task_info.planned_end_date);
623:
624: -- Get the Resources for this Task.
625: csf_resource_pub.get_resources_to_schedule(
626: p_api_version => 1
627: , p_init_msg_list => fnd_api.g_false
628: , x_return_status => x_return_status
629: , x_msg_count => x_msg_count
692: ) IS
693: l_api_version CONSTANT NUMBER := 1.0;
694: l_api_name CONSTANT VARCHAR2(30) := 'FILL_REQUEST_RESOURCES';
695:
696: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;
697: l_res_tbl csf_requests_pvt.resource_tbl_type;
698:
699: CURSOR c_request_task_list IS
700: SELECT rt.request_task_id
741: -- Validate the Planned Window (same logic as that done in DC)
742: csf_tasks_pub.validate_planned_dates(l_task_rec.planned_start_date, l_task_rec.planned_end_date);
743:
744: -- Get the Resources for this Task.
745: csf_resource_pub.get_resources_to_schedule(
746: p_api_version => 1
747: , p_init_msg_list => fnd_api.g_false
748: , x_return_status => x_return_status
749: , x_msg_count => x_msg_count
1077: FROM jtf_tasks_b t
1078: , TABLE( CAST ( p_task_id_tbl AS jtf_number_table ) ) tt
1079: WHERE t.task_id = tt.COLUMN_VALUE;
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;
1113: -- Validate the Planned Window (same logic as that done in DC)
1114: csf_tasks_pub.validate_planned_dates(l_start_date, l_end_date);
1115:
1116: -- Get the Resources for this Task.
1117: csf_resource_pub.get_resources_to_schedule(
1118: p_api_version => 1.0
1119: , p_init_msg_list => fnd_api.g_false
1120: , x_return_status => x_return_status
1121: , x_msg_count => x_msg_count