APPS.CSR_SCHEDULER_PVT dependencies on CSF_REQUESTS_PVT

Line 373: l_res_tbl csf_requests_pvt.resource_tbl_type;

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

Line 438: csf_requests_pvt.create_scheduler_request(

434: RAISE fnd_api.g_exc_unexpected_error;
435: END IF;
436:
437: -- Create Scheduler Search Request based on the given information.
438: csf_requests_pvt.create_scheduler_request(
439: p_api_version => 1
440: , p_init_msg_list => fnd_api.g_false
441: , p_commit => fnd_api.g_false
442: , x_return_status => x_return_status

Line 521: csf_requests_pvt.create_scheduler_request(

517: END IF;
518:
519: x_return_status := fnd_api.g_ret_sts_success;
520:
521: csf_requests_pvt.create_scheduler_request(
522: p_api_version => 1
523: , x_return_status => x_return_status
524: , x_msg_count => x_msg_count
525: , x_msg_data => x_msg_data

Line 562: , p_task_tbl IN csf_requests_pvt.object_tbl_type

558: PROCEDURE create_auto_request(
559: x_return_status OUT NOCOPY VARCHAR2
560: , x_msg_count OUT NOCOPY NUMBER
561: , x_msg_data OUT NOCOPY VARCHAR2
562: , p_task_tbl IN csf_requests_pvt.object_tbl_type
563: , p_find_resources IN VARCHAR2 DEFAULT fnd_api.g_true
564: , x_request_id OUT NOCOPY NUMBER
565: ) IS
566: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_AUTO_REQUEST';

Line 570: l_res_tbl csf_requests_pvt.resource_tbl_type;

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

Line 594: csf_requests_pvt.create_scheduler_request(

590:
591:
592: -- Create the SearchAndScheduleAuto Request which will serve as
593: -- the Parent Request for the subsequents requests created for each Task.
594: csf_requests_pvt.create_scheduler_request(
595: p_api_version => 1
596: , p_init_msg_list => fnd_api.g_true
597: , p_commit => fnd_api.g_false
598: , x_return_status => x_return_status

Line 651: csf_requests_pvt.create_scheduler_request(

647: RAISE fnd_api.g_exc_unexpected_error;
648: END IF;
649: END IF;
650:
651: csf_requests_pvt.create_scheduler_request(
652: p_api_version => 1
653: , p_init_msg_list => fnd_api.g_false
654: , p_commit => fnd_api.g_false
655: , x_return_status => x_return_status

Line 697: l_res_tbl csf_requests_pvt.resource_tbl_type;

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
701: , t.task_id

Line 770: csf_requests_pvt.create_resource_results(

766: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
767: RAISE fnd_api.g_exc_unexpected_error;
768: END IF;
769:
770: csf_requests_pvt.create_resource_results(
771: p_api_version => 1
772: , p_init_msg_list => fnd_api.g_false
773: , p_commit => fnd_api.g_false
774: , x_return_status => x_return_status

Line 810: , p_task_tbl IN csf_requests_pvt.object_tbl_type

806: , p_commit IN VARCHAR2
807: , x_return_status OUT NOCOPY VARCHAR2
808: , x_msg_count OUT NOCOPY NUMBER
809: , x_msg_data OUT NOCOPY VARCHAR2
810: , p_task_tbl IN csf_requests_pvt.object_tbl_type
811: , x_sched_request_id OUT NOCOPY NUMBER
812: , x_conc_request_id OUT NOCOPY NUMBER
813: ) IS
814: l_api_version CONSTANT NUMBER := 1.0;

Line 902: l_task_tbl csf_requests_pvt.object_tbl_type;

898:
899: l_where csf_dc_queries_b.where_clause%TYPE;
900: l_stmt VARCHAR2(2000);
901: c_task_list ref_cursor_type;
902: l_task_tbl csf_requests_pvt.object_tbl_type;
903: BEGIN
904: SAVEPOINT create_auto_request_pub;
905:
906: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

925:
926: -- Create the Task List Query using the WHERE CLAUSE
927: l_stmt := 'SELECT task_id FROM csf_ct_tasks WHERE ' || l_where || ' ORDER BY scheduled_start_date NULLS FIRST, planned_end_date, creation_date';
928:
929: l_task_tbl := csf_requests_pvt.object_tbl_type();
930:
931: -- Fetch the Task List
932: OPEN c_task_list FOR l_stmt;
933: FETCH c_task_list BULK COLLECT INTO l_task_tbl;

Line 996: l_resource_tbl csf_requests_pvt.resource_tbl_type;

992: AND (p_terr_id IS NULL OR tr.terr_id = p_terr_id);
993:
994: l_res_id_tbl jtf_number_table;
995: l_res_type_tbl jtf_varchar2_table_100;
996: l_resource_tbl csf_requests_pvt.resource_tbl_type;
997: BEGIN
998: SAVEPOINT create_opt_request_pub;
999:
1000: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

1008: OPEN c_resources;
1009: FETCH c_resources BULK COLLECT INTO l_res_id_tbl, l_res_type_tbl;
1010: CLOSE c_resources;
1011:
1012: l_resource_tbl := csf_requests_pvt.resource_tbl_type();
1013: FOR i IN 1..l_res_id_tbl.COUNT LOOP
1014: l_resource_tbl.EXTEND;
1015: l_resource_tbl(i).resource_id := l_res_id_tbl(i);
1016: l_resource_tbl(i).resource_type := l_res_type_tbl(i);

Line 1023: csf_requests_pvt.create_scheduler_request(

1019: l_resource_tbl(i).planwin_end := p_end_date;
1020: l_resource_tbl(i).preferred_resources_flag := 'N';
1021: END LOOP;
1022:
1023: csf_requests_pvt.create_scheduler_request(
1024: p_api_version => 1.0
1025: , x_return_status => x_return_status
1026: , x_msg_count => x_msg_count
1027: , x_msg_data => x_msg_data