DBA Data[Home] [Help]

APPS.CSF_REQUESTS_PVT dependencies on JTF_NUMBER_TABLE

Line 626: , p_resource_id_tbl IN jtf_number_table

622: , x_msg_data OUT NOCOPY VARCHAR2
623: , p_request_task_id IN NUMBER
624: , p_scheduled_start_date_tbl IN jtf_date_table
625: , p_scheduled_end_date_tbl IN jtf_date_table
626: , p_resource_id_tbl IN jtf_number_table
627: , p_resource_type_tbl IN jtf_varchar2_table_100
628: , p_cost_tbl IN jtf_number_table
629: , p_terr_id_tbl IN jtf_number_table
630: , p_win_to_promis_id_tbl IN jtf_number_table

Line 628: , p_cost_tbl IN jtf_number_table

624: , p_scheduled_start_date_tbl IN jtf_date_table
625: , p_scheduled_end_date_tbl IN jtf_date_table
626: , p_resource_id_tbl IN jtf_number_table
627: , p_resource_type_tbl IN jtf_varchar2_table_100
628: , p_cost_tbl IN jtf_number_table
629: , p_terr_id_tbl IN jtf_number_table
630: , p_win_to_promis_id_tbl IN jtf_number_table
631: , p_spares_cost_tbl IN jtf_number_table
632: , p_spares_date_tbl IN jtf_date_table

Line 629: , p_terr_id_tbl IN jtf_number_table

625: , p_scheduled_end_date_tbl IN jtf_date_table
626: , p_resource_id_tbl IN jtf_number_table
627: , p_resource_type_tbl IN jtf_varchar2_table_100
628: , p_cost_tbl IN jtf_number_table
629: , p_terr_id_tbl IN jtf_number_table
630: , p_win_to_promis_id_tbl IN jtf_number_table
631: , p_spares_cost_tbl IN jtf_number_table
632: , p_spares_date_tbl IN jtf_date_table
633: , p_spares_warehouseInfo_tbl IN jtf_varchar2_table_4000 default null

Line 630: , p_win_to_promis_id_tbl IN jtf_number_table

626: , p_resource_id_tbl IN jtf_number_table
627: , p_resource_type_tbl IN jtf_varchar2_table_100
628: , p_cost_tbl IN jtf_number_table
629: , p_terr_id_tbl IN jtf_number_table
630: , p_win_to_promis_id_tbl IN jtf_number_table
631: , p_spares_cost_tbl IN jtf_number_table
632: , p_spares_date_tbl IN jtf_date_table
633: , p_spares_warehouseInfo_tbl IN jtf_varchar2_table_4000 default null
634: , p_spares_shippingMethod_tbl IN jtf_varchar2_table_4000 default null

Line 631: , p_spares_cost_tbl IN jtf_number_table

627: , p_resource_type_tbl IN jtf_varchar2_table_100
628: , p_cost_tbl IN jtf_number_table
629: , p_terr_id_tbl IN jtf_number_table
630: , p_win_to_promis_id_tbl IN jtf_number_table
631: , p_spares_cost_tbl IN jtf_number_table
632: , p_spares_date_tbl IN jtf_date_table
633: , p_spares_warehouseInfo_tbl IN jtf_varchar2_table_4000 default null
634: , p_spares_shippingMethod_tbl IN jtf_varchar2_table_4000 default null
635: , p_spares_shippingDistance_tbl IN jtf_varchar2_table_4000 default null

Line 637: , x_plan_option_id_tbl OUT NOCOPY jtf_number_table

633: , p_spares_warehouseInfo_tbl IN jtf_varchar2_table_4000 default null
634: , p_spares_shippingMethod_tbl IN jtf_varchar2_table_4000 default null
635: , p_spares_shippingDistance_tbl IN jtf_varchar2_table_4000 default null
636: , p_shift_type_tbl IN jtf_varchar2_table_100
637: , x_plan_option_id_tbl OUT NOCOPY jtf_number_table
638: ) IS
639: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PLAN_OPTIONS';
640: l_api_version CONSTANT NUMBER := 1.0;
641: l_shift_type varchar2(30) := null;

Line 683: x_plan_option_id_tbl := jtf_number_table();

679: END IF;
680:
681: -- Initialize API return status to success
682: x_return_status := fnd_api.g_ret_sts_success;
683: x_plan_option_id_tbl := jtf_number_table();
684: IF p_resource_id_tbl IS NOT NULL AND p_resource_id_tbl.COUNT > 0 THEN
685:
686: j := p_resource_id_tbl.FIRST;
687: WHILE j IS NOT NULL LOOP