APPS.CSR_SCHEDULER_PVT dependencies on JTF_NUMBER_TABLE

Line 362: , p_resource_id_tbl IN jtf_number_table

358: , p_contracts_flag IN VARCHAR2
359: , p_ib_flag IN VARCHAR2
360: , p_territory_flag IN VARCHAR2
361: , p_skill_flag IN VARCHAR2
362: , p_resource_id_tbl IN jtf_number_table
363: , p_resource_type_tbl IN jtf_varchar2_table_100
364: , p_spares_likelihood IN NUMBER
365: , p_route_based_flag IN VARCHAR2
366: , p_disabled_access_hours_flag IN VARCHAR2

Line 990: , TABLE( CAST ( csf_util_pvt.get_selected_terr_table AS jtf_number_table ) ) t

986:
987: CURSOR c_resources IS
988: SELECT /*+ cardinality(t, 1) */ DISTINCT tr.resource_id, tr.resource_type
989: FROM jtf_terr_rsc_all tr
990: , TABLE( CAST ( csf_util_pvt.get_selected_terr_table AS jtf_number_table ) ) t
991: WHERE tr.terr_id = t.column_value
992: AND (p_terr_id IS NULL OR tr.terr_id = p_terr_id);
993:
994: l_res_id_tbl jtf_number_table;

Line 994: l_res_id_tbl jtf_number_table;

990: , TABLE( CAST ( csf_util_pvt.get_selected_terr_table AS jtf_number_table ) ) t
991: WHERE tr.terr_id = t.column_value
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;

Line 1067: , p_task_id_tbl IN jtf_number_table

1063: , p_init_msg_list IN VARCHAR2
1064: , x_return_status OUT NOCOPY VARCHAR2
1065: , x_msg_count OUT NOCOPY NUMBER
1066: , x_msg_data OUT NOCOPY VARCHAR2
1067: , p_task_id_tbl IN jtf_number_table
1068: , p_start_date_tbl IN jtf_date_table
1069: , p_end_date_tbl IN jtf_date_table
1070: , x_task_resources_tbl OUT NOCOPY csf_task_resources_tbl_type
1071: ) IS

Line 1078: , TABLE( CAST ( p_task_id_tbl AS jtf_number_table ) ) tt

1074:
1075: CURSOR c_task_info IS
1076: SELECT source_object_id
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;

Line 1085: l_sr_id_tbl jtf_number_table;

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;
1086: l_res_preferred VARCHAR2(1);
1087: l_start_date DATE;
1088: l_end_date DATE;
1089: