APPS.CSR_SCHEDULER_PVT dependencies on CSF_REQUESTS_PVT

Line 389: l_res_tbl csf_requests_pvt.resource_tbl_type;

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:
393: CURSOR c_task_info IS

Line 452: csf_requests_pvt.create_scheduler_request(

448: RAISE fnd_api.g_exc_unexpected_error;
449: END IF;
450:
451: -- Create Scheduler Search Request based on the given information.
452: csf_requests_pvt.create_scheduler_request(
453: p_api_version => 1
454: , p_init_msg_list => fnd_api.g_false
455: , p_commit => fnd_api.g_false
456: , x_return_status => x_return_status

Line 537: csf_requests_pvt.create_scheduler_request(

533: END IF;
534:
535: x_return_status := fnd_api.g_ret_sts_success;
536:
537: csf_requests_pvt.create_scheduler_request(
538: p_api_version => 1
539: , x_return_status => x_return_status
540: , x_msg_count => x_msg_count
541: , x_msg_data => x_msg_data

Line 578: , p_task_tbl IN csf_requests_pvt.object_tbl_type

574: PROCEDURE create_auto_request(
575: x_return_status OUT NOCOPY VARCHAR2
576: , x_msg_count OUT NOCOPY NUMBER
577: , x_msg_data OUT NOCOPY VARCHAR2
578: , p_task_tbl IN csf_requests_pvt.object_tbl_type
579: , p_find_resources IN VARCHAR2 DEFAULT fnd_api.g_true
580: , x_request_id OUT NOCOPY NUMBER
581: ) IS
582: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_AUTO_REQUEST';

Line 586: l_res_tbl csf_requests_pvt.resource_tbl_type;

582: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_AUTO_REQUEST';
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

Line 607: csf_requests_pvt.create_scheduler_request(

603:
604:
605: -- Create the SearchAndScheduleAuto Request which will serve as
606: -- the Parent Request for the subsequents requests created for each Task.
607: csf_requests_pvt.create_scheduler_request(
608: p_api_version => 1
609: , p_init_msg_list => fnd_api.g_true
610: , p_commit => fnd_api.g_false
611: , x_return_status => x_return_status

Line 664: csf_requests_pvt.create_scheduler_request(

660: RAISE fnd_api.g_exc_unexpected_error;
661: END IF;
662: END IF;
663:
664: csf_requests_pvt.create_scheduler_request(
665: p_api_version => 1
666: , p_init_msg_list => fnd_api.g_false
667: , p_commit => fnd_api.g_false
668: , x_return_status => x_return_status

Line 715: l_res_tbl csf_requests_pvt.resource_tbl_type;

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:
719: l_count NUMBER := 1;

Line 830: csf_requests_pvt.create_resource_results(

826: x_return_status := fnd_api.g_ret_sts_success;
827: END IF;
828:
829: IF l_res_tbl.count > 0 THEN
830: csf_requests_pvt.create_resource_results(
831: p_api_version => 1
832: , p_init_msg_list => fnd_api.g_false
833: , p_commit => fnd_api.g_false
834: , x_return_status => x_return_status

Line 875: , p_task_tbl IN csf_requests_pvt.object_tbl_type

871: , p_commit IN VARCHAR2
872: , x_return_status OUT NOCOPY VARCHAR2
873: , x_msg_count OUT NOCOPY NUMBER
874: , x_msg_data OUT NOCOPY VARCHAR2
875: , p_task_tbl IN csf_requests_pvt.object_tbl_type
876: , x_sched_request_id OUT NOCOPY NUMBER
877: , x_conc_request_id OUT NOCOPY NUMBER
878: ) IS
879: l_api_version CONSTANT NUMBER := 1.0;

Line 967: l_task_tbl csf_requests_pvt.object_tbl_type;

963:
964: l_where csf_dc_queries_b.where_clause%TYPE;
965: l_stmt VARCHAR2(4000);
966: c_task_list ref_cursor_type;
967: l_task_tbl csf_requests_pvt.object_tbl_type;
968: BEGIN
969: SAVEPOINT create_auto_request_pub;
970:
971: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 994: l_task_tbl := csf_requests_pvt.object_tbl_type();

990:
991: -- Create the Task List Query using the WHERE CLAUSE
992: l_stmt := 'SELECT task_id FROM csf_ct_tasks WHERE ' || l_where || ' ORDER BY scheduled_start_date NULLS FIRST, planned_end_date, creation_date';
993:
994: l_task_tbl := csf_requests_pvt.object_tbl_type();
995:
996: -- Fetch the Task List
997: OPEN c_task_list FOR l_stmt;
998: FETCH c_task_list BULK COLLECT INTO l_task_tbl;

Line 1069: l_resource_tbl csf_requests_pvt.resource_tbl_type;

1065:
1066: l_res_id_tbl jtf_number_table;
1067: l_res_type_tbl jtf_varchar2_table_100;
1068: l_res_terrid_tbl jtf_number_table;
1069: l_resource_tbl csf_requests_pvt.resource_tbl_type;
1070: BEGIN
1071: SAVEPOINT create_opt_request_pub;
1072:
1073: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 1085: l_resource_tbl := csf_requests_pvt.resource_tbl_type();

1081: OPEN c_resources;
1082: FETCH c_resources BULK COLLECT INTO l_res_id_tbl, l_res_type_tbl, l_res_terrid_tbl;
1083: CLOSE c_resources;
1084:
1085: l_resource_tbl := csf_requests_pvt.resource_tbl_type();
1086: FOR i IN 1..l_res_id_tbl.COUNT LOOP
1087: l_resource_tbl.EXTEND;
1088: l_resource_tbl(i).resource_id := l_res_id_tbl(i);
1089: l_resource_tbl(i).resource_type := l_res_type_tbl(i);

Line 1097: csf_requests_pvt.create_scheduler_request(

1093: l_resource_tbl(i).preferred_resources_flag := 'N';
1094: l_resource_tbl(i).TERRITORY_ID := l_res_terrid_tbl(i);
1095: END LOOP;
1096:
1097: csf_requests_pvt.create_scheduler_request(
1098: p_api_version => 1.0
1099: , x_return_status => x_return_status
1100: , x_msg_count => x_msg_count
1101: , x_msg_data => x_msg_data