DBA Data[Home] [Help]

APPS.CSR_SCHEDULER_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 377: , p_resource_type_tbl IN jtf_varchar2_table_100

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
381: , p_route_based_flag IN VARCHAR2

Line 708: , x_msg_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

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

Line 721: l_msg_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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
725: SELECT rt.request_task_id

Line 1067: l_res_type_tbl jtf_varchar2_table_100;

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
1071: SAVEPOINT create_opt_request_pub;