APPS.CSF_RESOURCE_PUB dependencies on CSF_RESOURCE_TBL

Line 901: l_res_dist_tbl csf_resource_tbl;

897: l_return_status VARCHAR2(1);
898: l_msg_count NUMBER;
899: l_msg_data VARCHAR2(2000);
900: l_sorted_res_tbl jtf_assign_pub.assignresources_tbl_type;
901: l_res_dist_tbl csf_resource_tbl;
902: i PLS_INTEGER;
903: j PLS_INTEGER;
904: l_pref_res_cnt PLS_INTEGER;
905: l_address csf_resource_address_pvt.address_rec_type;

Line 924: FROM TABLE(CAST(l_res_dist_tbl AS csf_resource_tbl) )

920:
921: CURSOR c_sorted_resources IS
922: SELECT resource_index
923: , distance
924: FROM TABLE(CAST(l_res_dist_tbl AS csf_resource_tbl) )
925: ORDER BY preferred_resource_flag desc, distance, resource_index;
926: BEGIN
927: -- Validate the Geometry of the Task.
928: -- If Task has no or invalid geometry, no need to sort by distance at all

Line 964: l_res_dist_tbl := csf_resource_tbl();

960: l_task_lon := -9999;
961: l_task_lat := -9999;
962: END IF;
963:
964: l_res_dist_tbl := csf_resource_tbl();
965: i := p_unsorted_res_tbl.FIRST;
966: l_pref_res_cnt := 1;
967: WHILE i IS NOT NULL LOOP
968: l_res_position := get_location(p_unsorted_res_tbl(i).resource_id, p_unsorted_res_tbl(i).resource_type, p_start);

Line 1887: , x_res_tbl OUT NOCOPY csf_resource_tbl

1883: , p_contracts_flag IN VARCHAR2 DEFAULT NULL
1884: , p_ib_flag IN VARCHAR2 DEFAULT NULL
1885: , p_territory_flag IN VARCHAR2 DEFAULT NULL
1886: , p_skill_flag IN VARCHAR2 DEFAULT NULL
1887: , x_res_tbl OUT NOCOPY csf_resource_tbl
1888: ) IS
1889: l_api_name CONSTANT VARCHAR2(30) := 'GET_RESOURCES_TO_SCHEDULE(3)';
1890: l_api_version CONSTANT NUMBER := 1.0;
1891:

Line 1914: , TABLE( CAST( x_res_tbl AS csf_resource_tbl ) ) tr

1910: , t.name terr_name
1911: , tr.resource_index
1912: FROM jtf_rs_all_resources_vl r
1913: , jtf_terr_all t
1914: , TABLE( CAST( x_res_tbl AS csf_resource_tbl ) ) tr
1915: WHERE r.resource_id = tr.resource_id
1916: AND r.resource_type = tr.resource_type
1917: AND t.terr_id (+) = tr.terr_id;
1918: BEGIN

Line 1958: x_res_tbl := csf_resource_tbl();

1954:
1955:
1956:
1957: IF x_res_tbl IS NULL THEN
1958: x_res_tbl := csf_resource_tbl();
1959: END IF;
1960:
1961: --start with an empty table so that previous value are deleted
1962: x_res_tbl.delete;

Line 2034: ) RETURN csf_resource_tbl IS

2030: , p_contracts_flag IN VARCHAR2 DEFAULT NULL
2031: , p_ib_flag IN VARCHAR2 DEFAULT NULL
2032: , p_territory_flag IN VARCHAR2 DEFAULT NULL
2033: , p_skill_flag IN VARCHAR2 DEFAULT NULL
2034: ) RETURN csf_resource_tbl IS
2035: PRAGMA autonomous_transaction;
2036: --
2037: l_return_status VARCHAR2(1);
2038: l_msg_data VARCHAR2(2000);

Line 2040: l_res_tbl csf_resource_tbl;

2036: --
2037: l_return_status VARCHAR2(1);
2038: l_msg_data VARCHAR2(2000);
2039: l_msg_count NUMBER;
2040: l_res_tbl csf_resource_tbl;
2041: BEGIN
2042: get_resources_to_schedule(
2043: p_api_version => 1.0
2044: , p_init_msg_list => fnd_api.g_true

Line 2068: RETURN csf_resource_tbl IS

2064: , p_ib_flag IN VARCHAR2 DEFAULT NULL
2065: , p_territory_flag IN VARCHAR2 DEFAULT NULL
2066: , p_skill_flag IN VARCHAR2 DEFAULT NULL
2067: )
2068: RETURN csf_resource_tbl IS
2069: l_res_tbl csf_resource_tbl;
2070: BEGIN
2071: l_res_tbl :=
2072: get_resources_to_schedule_pvt(

Line 2069: l_res_tbl csf_resource_tbl;

2065: , p_territory_flag IN VARCHAR2 DEFAULT NULL
2066: , p_skill_flag IN VARCHAR2 DEFAULT NULL
2067: )
2068: RETURN csf_resource_tbl IS
2069: l_res_tbl csf_resource_tbl;
2070: BEGIN
2071: l_res_tbl :=
2072: get_resources_to_schedule_pvt(
2073: p_task_id => p_task_id