DBA Data[Home] [Help]

APPS.CSR_SCHEDULER_PVT dependencies on CSF_RESOURCE_PUB

Line 372: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;

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:

Line 410: csf_resource_pub.get_resources_to_schedule(

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

Line 571: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;

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

Line 625: csf_resource_pub.get_resources_to_schedule(

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

Line 696: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;

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

Line 745: csf_resource_pub.get_resources_to_schedule(

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

Line 1081: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;

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;

Line 1117: csf_resource_pub.get_resources_to_schedule(

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