eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSR_SCHEDULER_PVT dependencies on JTF_NUMBER_TABLE

Line 376: , p_resource_id_tbl IN jtf_number_table

372: , p_contracts_flag IN VARCHAR2
373: , p_ib_flag IN VARCHAR2
374: , p_territory_flag IN VARCHAR2
375: , p_skill_flag IN VARCHAR2
376: , p_resource_id_tbl IN jtf_number_table
377: , p_resource_type_tbl IN jtf_varchar2_table_100
378: , p_spares_mandatory IN VARCHAR2
379: , p_spares_source IN VARCHAR2
380: , p_consider_standby_shifts IN VARCHAR2

Line 707: , x_task_num_tbl OUT NOCOPY JTF_NUMBER_TABLE

703: , x_return_status OUT NOCOPY VARCHAR2
704: , x_msg_count OUT NOCOPY NUMBER
705: , x_msg_data OUT NOCOPY VARCHAR2
706: , p_request_id IN NUMBER
707: , x_task_num_tbl OUT NOCOPY JTF_NUMBER_TABLE
708: , x_msg_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
709: , x_task_id_tbl OUT NOCOPY JTF_NUMBER_TABLE
710: ) IS
711: l_api_version CONSTANT NUMBER := 1.0;

Line 709: , x_task_id_tbl OUT NOCOPY JTF_NUMBER_TABLE

705: , x_msg_data OUT NOCOPY VARCHAR2
706: , p_request_id IN NUMBER
707: , x_task_num_tbl OUT NOCOPY JTF_NUMBER_TABLE
708: , x_msg_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
709: , x_task_id_tbl OUT NOCOPY JTF_NUMBER_TABLE
710: ) IS
711: l_api_version CONSTANT NUMBER := 1.0;
712: l_api_name CONSTANT VARCHAR2(30) := 'FILL_REQUEST_RESOURCES';
713:

Line 720: l_task_num_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

716: iIndex PLS_INTEGER;
717: l_role VARCHAR2(30);
718:
719: l_count NUMBER := 1;
720: l_task_num_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
721: l_msg_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
722: l_task_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
723:
724: CURSOR c_request_task_list IS

Line 722: l_task_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

718:
719: l_count NUMBER := 1;
720: l_task_num_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
721: l_msg_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
722: l_task_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
723:
724: CURSOR c_request_task_list IS
725: SELECT rt.request_task_id
726: , t.task_number

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

1057: 0
1058: ) DESC NULLS LAST)
1059: AS comp_rank
1060: FROM jtf_terr_rsc_all trs, jtf_terr_all tra
1061: , TABLE( CAST ( csf_util_pvt.get_selected_terr_table AS jtf_number_table ) ) t
1062: WHERE trs.terr_id = t.column_value
1063: AND (p_terr_id IS NULL OR trs.terr_id = p_terr_id))
1064: WHERE comp_rank = 1;
1065:

Line 1066: l_res_id_tbl jtf_number_table;

1062: WHERE trs.terr_id = t.column_value
1063: AND (p_terr_id IS NULL OR trs.terr_id = p_terr_id))
1064: WHERE comp_rank = 1;
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

Line 1068: l_res_terrid_tbl jtf_number_table;

1064: WHERE comp_rank = 1;
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:

Line 1141: , p_task_id_tbl IN jtf_number_table

1137: , p_init_msg_list IN VARCHAR2
1138: , x_return_status OUT NOCOPY VARCHAR2
1139: , x_msg_count OUT NOCOPY NUMBER
1140: , x_msg_data OUT NOCOPY VARCHAR2
1141: , p_task_id_tbl IN jtf_number_table
1142: , p_start_date_tbl IN jtf_date_table
1143: , p_end_date_tbl IN jtf_date_table
1144: , x_task_resources_tbl OUT NOCOPY csf_task_resources_tbl_type
1145: ) IS

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

1149:
1150: CURSOR c_task_info IS
1151: SELECT source_object_id
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;

Line 1160: l_sr_id_tbl jtf_number_table;

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;
1161: l_res_preferred VARCHAR2(1);
1162: l_start_date DATE;
1163: l_end_date DATE;
1164: