DBA Data[Home] [Help]

APPS.CSR_SCHEDULER_PVT dependencies on CSF_RESOURCE_PUB

Line 388: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;

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:

Line 424: csf_resource_pub.get_resources_to_schedule(

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

Line 587: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;

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

Line 638: csf_resource_pub.get_resources_to_schedule(

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

Line 714: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;

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:

Line 771: csf_resource_pub.get_resources_to_schedule(

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

Line 1156: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;

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;

Line 1192: csf_resource_pub.get_resources_to_schedule(

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