APPS.CSF_REQUESTS_PVT dependencies on JTF_NUMBER_TABLE

Line 604: , p_resource_id_tbl IN jtf_number_table

600: , x_msg_data OUT NOCOPY VARCHAR2
601: , p_request_task_id IN NUMBER
602: , p_scheduled_start_date_tbl IN jtf_date_table
603: , p_scheduled_end_date_tbl IN jtf_date_table
604: , p_resource_id_tbl IN jtf_number_table
605: , p_resource_type_tbl IN jtf_varchar2_table_100
606: , p_cost_tbl IN jtf_number_table
607: , p_terr_id_tbl IN jtf_number_table
608: , p_win_to_promis_id_tbl IN jtf_number_table

Line 606: , p_cost_tbl IN jtf_number_table

602: , p_scheduled_start_date_tbl IN jtf_date_table
603: , p_scheduled_end_date_tbl IN jtf_date_table
604: , p_resource_id_tbl IN jtf_number_table
605: , p_resource_type_tbl IN jtf_varchar2_table_100
606: , p_cost_tbl IN jtf_number_table
607: , p_terr_id_tbl IN jtf_number_table
608: , p_win_to_promis_id_tbl IN jtf_number_table
609: , p_spares_cost_tbl IN jtf_number_table
610: , p_spares_date_tbl IN jtf_date_table

Line 607: , p_terr_id_tbl IN jtf_number_table

603: , p_scheduled_end_date_tbl IN jtf_date_table
604: , p_resource_id_tbl IN jtf_number_table
605: , p_resource_type_tbl IN jtf_varchar2_table_100
606: , p_cost_tbl IN jtf_number_table
607: , p_terr_id_tbl IN jtf_number_table
608: , p_win_to_promis_id_tbl IN jtf_number_table
609: , p_spares_cost_tbl IN jtf_number_table
610: , p_spares_date_tbl IN jtf_date_table
611: , x_plan_option_id_tbl OUT NOCOPY jtf_number_table

Line 608: , p_win_to_promis_id_tbl IN jtf_number_table

604: , p_resource_id_tbl IN jtf_number_table
605: , p_resource_type_tbl IN jtf_varchar2_table_100
606: , p_cost_tbl IN jtf_number_table
607: , p_terr_id_tbl IN jtf_number_table
608: , p_win_to_promis_id_tbl IN jtf_number_table
609: , p_spares_cost_tbl IN jtf_number_table
610: , p_spares_date_tbl IN jtf_date_table
611: , x_plan_option_id_tbl OUT NOCOPY jtf_number_table
612: ) IS

Line 609: , p_spares_cost_tbl IN jtf_number_table

605: , p_resource_type_tbl IN jtf_varchar2_table_100
606: , p_cost_tbl IN jtf_number_table
607: , p_terr_id_tbl IN jtf_number_table
608: , p_win_to_promis_id_tbl IN jtf_number_table
609: , p_spares_cost_tbl IN jtf_number_table
610: , p_spares_date_tbl IN jtf_date_table
611: , x_plan_option_id_tbl OUT NOCOPY jtf_number_table
612: ) IS
613: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PLAN_OPTIONS';

Line 611: , x_plan_option_id_tbl OUT NOCOPY jtf_number_table

607: , p_terr_id_tbl IN jtf_number_table
608: , p_win_to_promis_id_tbl IN jtf_number_table
609: , p_spares_cost_tbl IN jtf_number_table
610: , p_spares_date_tbl IN jtf_date_table
611: , x_plan_option_id_tbl OUT NOCOPY jtf_number_table
612: ) IS
613: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PLAN_OPTIONS';
614: l_api_version CONSTANT NUMBER := 1.0;
615:

Line 653: x_plan_option_id_tbl := jtf_number_table();

649: END IF;
650:
651: -- Initialize API return status to success
652: x_return_status := fnd_api.g_ret_sts_success;
653: x_plan_option_id_tbl := jtf_number_table();
654: IF p_resource_id_tbl IS NOT NULL AND p_resource_id_tbl.COUNT > 0 THEN
655:
656: j := p_resource_id_tbl.FIRST;
657: WHILE j IS NOT NULL LOOP