DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on JTF_VARCHAR2_TABLE_100

Line 940: , p_suggested_res_type_tbl IN jtf_varchar2_table_100

936: */
937: PROCEDURE add_suggested_resources(
938: p_res_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
939: , p_suggested_res_id_tbl IN jtf_number_table
940: , p_suggested_res_type_tbl IN jtf_varchar2_table_100
941: , p_start_date IN DATE
942: , p_end_date IN DATE
943: ) IS
944: i PLS_INTEGER;

Line 1092: , p_suggested_res_type_tbl IN jtf_varchar2_table_100

1088: , p_skill_flag IN VARCHAR2
1089: , p_calendar_flag IN VARCHAR2
1090: , p_sort_flag IN VARCHAR2
1091: , p_suggested_res_id_tbl IN jtf_number_table
1092: , p_suggested_res_type_tbl IN jtf_varchar2_table_100
1093: , x_res_tbl OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
1094: ) IS
1095: l_api_name CONSTANT VARCHAR2(30) := 'GET_RESOURCES_TO_SCHEDULE';
1096: l_api_version CONSTANT NUMBER := 1.0;

Line 1450: , p_suggested_res_type_tbl IN jtf_varchar2_table_100 DEFAULT NULL

1446: , p_skill_flag IN VARCHAR2 DEFAULT NULL
1447: , p_calendar_flag IN VARCHAR2 DEFAULT NULL
1448: , p_sort_flag IN VARCHAR2 DEFAULT NULL
1449: , p_suggested_res_id_tbl IN jtf_number_table DEFAULT NULL
1450: , p_suggested_res_type_tbl IN jtf_varchar2_table_100 DEFAULT NULL
1451: , x_res_tbl IN OUT NOCOPY csf_requests_pvt.resource_tbl_type
1452: ) IS
1453: l_api_name CONSTANT VARCHAR2(30) := 'GET_RESOURCES_TO_SCHEDULE(2)';
1454: l_api_version CONSTANT NUMBER := 1.0;