384: ) IS
385: l_api_version CONSTANT NUMBER := 1.0;
386: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SEARCH_REQUEST';
387:
388: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;
389: l_res_tbl csf_requests_pvt.resource_tbl_type;
390: j PLS_INTEGER;
391: k PLS_INTEGER;
392:
420:
421: -- Validate the Planned Window (same logic as that done in DC)
422: csf_tasks_pub.validate_planned_dates(l_task_info.planned_start_date, l_task_info.planned_end_date);
423:
424: csf_resource_pub.get_resources_to_schedule(
425: p_api_version => 1
426: , p_init_msg_list => fnd_api.g_false
427: , x_return_status => x_return_status
428: , x_msg_count => x_msg_count
583:
584: i PLS_INTEGER;
585: l_child_request_id NUMBER;
586: l_res_tbl csf_requests_pvt.resource_tbl_type;
587: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;
588:
589: CURSOR c_task_info (p_task_id NUMBER) IS
590: SELECT t.task_id, t.planned_start_date, t.planned_end_date, t.source_object_id
591: FROM jtf_tasks_b t
634: -- Validate the Planned Window (same logic as that done in DC)
635: csf_tasks_pub.validate_planned_dates(l_task_info.planned_start_date, l_task_info.planned_end_date);
636:
637: -- Get the Resources for this Task.
638: csf_resource_pub.get_resources_to_schedule(
639: p_api_version => 1
640: , p_init_msg_list => fnd_api.g_false
641: , x_return_status => x_return_status
642: , x_msg_count => x_msg_count
710: ) IS
711: l_api_version CONSTANT NUMBER := 1.0;
712: l_api_name CONSTANT VARCHAR2(30) := 'FILL_REQUEST_RESOURCES';
713:
714: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;
715: l_res_tbl csf_requests_pvt.resource_tbl_type;
716: iIndex PLS_INTEGER;
717: l_role VARCHAR2(30);
718:
767: -- Validate the Planned Window (same logic as that done in DC)
768: csf_tasks_pub.validate_planned_dates(l_task_rec.planned_start_date, l_task_rec.planned_end_date);
769:
770: -- Get the Resources for this Task.
771: csf_resource_pub.get_resources_to_schedule(
772: p_api_version => 1
773: , p_init_msg_list => fnd_api.g_true
774: , x_return_status => x_return_status
775: , x_msg_count => x_msg_count
1152: FROM jtf_tasks_b t
1153: , TABLE( CAST ( p_task_id_tbl AS jtf_number_table ) ) tt
1154: WHERE t.task_id = tt.COLUMN_VALUE;
1155:
1156: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;
1157: l_res_tbl jtf_assign_pub.assignresources_tbl_type;
1158: l_res_idx PLS_INTEGER;
1159: l_task_res_tbl csf_resource_tbl;
1160: l_sr_id_tbl jtf_number_table;
1188: -- Validate the Planned Window (same logic as that done in DC)
1189: csf_tasks_pub.validate_planned_dates(l_start_date, l_end_date);
1190:
1191: -- Get the Resources for this Task.
1192: csf_resource_pub.get_resources_to_schedule(
1193: p_api_version => 1.0
1194: , p_init_msg_list => fnd_api.g_false
1195: , x_return_status => x_return_status
1196: , x_msg_count => x_msg_count