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.FTE_LANE_SEARCH dependencies on DBMS_SQL

Line 333: -- using dbms_sql, given a cursor_id.

329: --
330: -- Description: This procedure takes in a bind variable array
331: -- and binds the variables according to the
332: -- bind variable index and bind variable type
333: -- using dbms_sql, given a cursor_id.
334: --
335: -- -----------------------------------------------------------------
336: PROCEDURE Bind_Vars(p_cursor_id IN NUMBER,
337: p_bindvars IN FTE_LANE_SEARCH_QUERY_GEN.bindvars) IS

Line 375: dbms_sql.BIND_VARIABLE(p_cursor_id, ':' || p_bindvars(l_counter).bindvarindex, to_number(p_bindvars(l_counter).bindvar));

371: WSH_DEBUG_SV.logmsg(l_module_name,'bind var ' || p_bindvars(l_counter).bindvarindex || ' = ' || p_bindvars(l_counter).bindvar,WSH_DEBUG_SV.C_PROC_LEVEL);
372: END IF;
373:
374: IF (p_bindvars(l_counter).bindtype = 'NUMBER') THEN
375: dbms_sql.BIND_VARIABLE(p_cursor_id, ':' || p_bindvars(l_counter).bindvarindex, to_number(p_bindvars(l_counter).bindvar));
376: --g_message := g_message || 'bind ' || p_bindvars(l_counter).bindvarindex || ' = ' || p_bindvars(l_counter).bindvar;
377: ELSIF (p_bindvars(l_counter).bindtype = 'DATE') THEN
378: dbms_sql.BIND_VARIABLE(p_cursor_id, ':' || p_bindvars(l_counter).bindvarindex, to_date(p_bindvars(l_counter).bindvar, 'mm-dd-yyyy hh24:mi'));
379: --g_message := g_message || 'bind ' || p_bindvars(l_counter).bindvarindex || ' = ' || 'to_date(''' || p_bindvars(l_counter).bindvar||''', ''mm-dd-yyyy hh24:mi'')';

Line 378: dbms_sql.BIND_VARIABLE(p_cursor_id, ':' || p_bindvars(l_counter).bindvarindex, to_date(p_bindvars(l_counter).bindvar, 'mm-dd-yyyy hh24:mi'));

374: IF (p_bindvars(l_counter).bindtype = 'NUMBER') THEN
375: dbms_sql.BIND_VARIABLE(p_cursor_id, ':' || p_bindvars(l_counter).bindvarindex, to_number(p_bindvars(l_counter).bindvar));
376: --g_message := g_message || 'bind ' || p_bindvars(l_counter).bindvarindex || ' = ' || p_bindvars(l_counter).bindvar;
377: ELSIF (p_bindvars(l_counter).bindtype = 'DATE') THEN
378: dbms_sql.BIND_VARIABLE(p_cursor_id, ':' || p_bindvars(l_counter).bindvarindex, to_date(p_bindvars(l_counter).bindvar, 'mm-dd-yyyy hh24:mi'));
379: --g_message := g_message || 'bind ' || p_bindvars(l_counter).bindvarindex || ' = ' || 'to_date(''' || p_bindvars(l_counter).bindvar||''', ''mm-dd-yyyy hh24:mi'')';
380: ELSE
381: dbms_sql.BIND_VARIABLE(p_cursor_id, ':' || p_bindvars(l_counter).bindvarindex, p_bindvars(l_counter).bindvar);
382: --g_message := g_message || 'bind ' || p_bindvars(l_counter).bindvarindex || ' = ''' || p_bindvars(l_counter).bindvar || '''';

Line 381: dbms_sql.BIND_VARIABLE(p_cursor_id, ':' || p_bindvars(l_counter).bindvarindex, p_bindvars(l_counter).bindvar);

377: ELSIF (p_bindvars(l_counter).bindtype = 'DATE') THEN
378: dbms_sql.BIND_VARIABLE(p_cursor_id, ':' || p_bindvars(l_counter).bindvarindex, to_date(p_bindvars(l_counter).bindvar, 'mm-dd-yyyy hh24:mi'));
379: --g_message := g_message || 'bind ' || p_bindvars(l_counter).bindvarindex || ' = ' || 'to_date(''' || p_bindvars(l_counter).bindvar||''', ''mm-dd-yyyy hh24:mi'')';
380: ELSE
381: dbms_sql.BIND_VARIABLE(p_cursor_id, ':' || p_bindvars(l_counter).bindvarindex, p_bindvars(l_counter).bindvar);
382: --g_message := g_message || 'bind ' || p_bindvars(l_counter).bindvarindex || ' = ''' || p_bindvars(l_counter).bindvar || '''';
383: END IF;
384: END LOOP;
385:

Line 671: v_lane_id dbms_sql.NUMBER_TABLE;

667: l_offset NUMBER := 0;
668: l_vehicles_discarded VARCHAR2(12000);
669:
670: -- variables of column type for binding sql stmt for lanes
671: v_lane_id dbms_sql.NUMBER_TABLE;
672: v_lane_number dbms_sql.VARCHAR2_TABLE;
673: v_party_name dbms_sql.VARCHAR2_TABLE;
674: v_origin_id dbms_sql.NUMBER_TABLE;
675: v_destination_id dbms_sql.NUMBER_TABLE;

Line 672: v_lane_number dbms_sql.VARCHAR2_TABLE;

668: l_vehicles_discarded VARCHAR2(12000);
669:
670: -- variables of column type for binding sql stmt for lanes
671: v_lane_id dbms_sql.NUMBER_TABLE;
672: v_lane_number dbms_sql.VARCHAR2_TABLE;
673: v_party_name dbms_sql.VARCHAR2_TABLE;
674: v_origin_id dbms_sql.NUMBER_TABLE;
675: v_destination_id dbms_sql.NUMBER_TABLE;
676: v_mode dbms_sql.VARCHAR2_TABLE;

Line 673: v_party_name dbms_sql.VARCHAR2_TABLE;

669:
670: -- variables of column type for binding sql stmt for lanes
671: v_lane_id dbms_sql.NUMBER_TABLE;
672: v_lane_number dbms_sql.VARCHAR2_TABLE;
673: v_party_name dbms_sql.VARCHAR2_TABLE;
674: v_origin_id dbms_sql.NUMBER_TABLE;
675: v_destination_id dbms_sql.NUMBER_TABLE;
676: v_mode dbms_sql.VARCHAR2_TABLE;
677: v_service dbms_sql.VARCHAR2_TABLE;

Line 674: v_origin_id dbms_sql.NUMBER_TABLE;

670: -- variables of column type for binding sql stmt for lanes
671: v_lane_id dbms_sql.NUMBER_TABLE;
672: v_lane_number dbms_sql.VARCHAR2_TABLE;
673: v_party_name dbms_sql.VARCHAR2_TABLE;
674: v_origin_id dbms_sql.NUMBER_TABLE;
675: v_destination_id dbms_sql.NUMBER_TABLE;
676: v_mode dbms_sql.VARCHAR2_TABLE;
677: v_service dbms_sql.VARCHAR2_TABLE;
678: v_commodity dbms_sql.VARCHAR2_TABLE;

Line 675: v_destination_id dbms_sql.NUMBER_TABLE;

671: v_lane_id dbms_sql.NUMBER_TABLE;
672: v_lane_number dbms_sql.VARCHAR2_TABLE;
673: v_party_name dbms_sql.VARCHAR2_TABLE;
674: v_origin_id dbms_sql.NUMBER_TABLE;
675: v_destination_id dbms_sql.NUMBER_TABLE;
676: v_mode dbms_sql.VARCHAR2_TABLE;
677: v_service dbms_sql.VARCHAR2_TABLE;
678: v_commodity dbms_sql.VARCHAR2_TABLE;
679: --v_equipment dbms_sql.VARCHAR2_TABLE;

Line 676: v_mode dbms_sql.VARCHAR2_TABLE;

672: v_lane_number dbms_sql.VARCHAR2_TABLE;
673: v_party_name dbms_sql.VARCHAR2_TABLE;
674: v_origin_id dbms_sql.NUMBER_TABLE;
675: v_destination_id dbms_sql.NUMBER_TABLE;
676: v_mode dbms_sql.VARCHAR2_TABLE;
677: v_service dbms_sql.VARCHAR2_TABLE;
678: v_commodity dbms_sql.VARCHAR2_TABLE;
679: --v_equipment dbms_sql.VARCHAR2_TABLE;
680: v_schedules_flag dbms_sql.VARCHAR2_TABLE;

Line 677: v_service dbms_sql.VARCHAR2_TABLE;

673: v_party_name dbms_sql.VARCHAR2_TABLE;
674: v_origin_id dbms_sql.NUMBER_TABLE;
675: v_destination_id dbms_sql.NUMBER_TABLE;
676: v_mode dbms_sql.VARCHAR2_TABLE;
677: v_service dbms_sql.VARCHAR2_TABLE;
678: v_commodity dbms_sql.VARCHAR2_TABLE;
679: --v_equipment dbms_sql.VARCHAR2_TABLE;
680: v_schedules_flag dbms_sql.VARCHAR2_TABLE;
681: v_distance dbms_sql.NUMBER_TABLE;

Line 678: v_commodity dbms_sql.VARCHAR2_TABLE;

674: v_origin_id dbms_sql.NUMBER_TABLE;
675: v_destination_id dbms_sql.NUMBER_TABLE;
676: v_mode dbms_sql.VARCHAR2_TABLE;
677: v_service dbms_sql.VARCHAR2_TABLE;
678: v_commodity dbms_sql.VARCHAR2_TABLE;
679: --v_equipment dbms_sql.VARCHAR2_TABLE;
680: v_schedules_flag dbms_sql.VARCHAR2_TABLE;
681: v_distance dbms_sql.NUMBER_TABLE;
682: v_port_of_loading dbms_sql.VARCHAR2_TABLE;

Line 679: --v_equipment dbms_sql.VARCHAR2_TABLE;

675: v_destination_id dbms_sql.NUMBER_TABLE;
676: v_mode dbms_sql.VARCHAR2_TABLE;
677: v_service dbms_sql.VARCHAR2_TABLE;
678: v_commodity dbms_sql.VARCHAR2_TABLE;
679: --v_equipment dbms_sql.VARCHAR2_TABLE;
680: v_schedules_flag dbms_sql.VARCHAR2_TABLE;
681: v_distance dbms_sql.NUMBER_TABLE;
682: v_port_of_loading dbms_sql.VARCHAR2_TABLE;
683: v_port_of_discharge dbms_sql.VARCHAR2_TABLE;

Line 680: v_schedules_flag dbms_sql.VARCHAR2_TABLE;

676: v_mode dbms_sql.VARCHAR2_TABLE;
677: v_service dbms_sql.VARCHAR2_TABLE;
678: v_commodity dbms_sql.VARCHAR2_TABLE;
679: --v_equipment dbms_sql.VARCHAR2_TABLE;
680: v_schedules_flag dbms_sql.VARCHAR2_TABLE;
681: v_distance dbms_sql.NUMBER_TABLE;
682: v_port_of_loading dbms_sql.VARCHAR2_TABLE;
683: v_port_of_discharge dbms_sql.VARCHAR2_TABLE;
684: v_transit_time dbms_sql.NUMBER_TABLE;

Line 681: v_distance dbms_sql.NUMBER_TABLE;

677: v_service dbms_sql.VARCHAR2_TABLE;
678: v_commodity dbms_sql.VARCHAR2_TABLE;
679: --v_equipment dbms_sql.VARCHAR2_TABLE;
680: v_schedules_flag dbms_sql.VARCHAR2_TABLE;
681: v_distance dbms_sql.NUMBER_TABLE;
682: v_port_of_loading dbms_sql.VARCHAR2_TABLE;
683: v_port_of_discharge dbms_sql.VARCHAR2_TABLE;
684: v_transit_time dbms_sql.NUMBER_TABLE;
685: v_rate_chart_name dbms_sql.VARCHAR2_TABLE;

Line 682: v_port_of_loading dbms_sql.VARCHAR2_TABLE;

678: v_commodity dbms_sql.VARCHAR2_TABLE;
679: --v_equipment dbms_sql.VARCHAR2_TABLE;
680: v_schedules_flag dbms_sql.VARCHAR2_TABLE;
681: v_distance dbms_sql.NUMBER_TABLE;
682: v_port_of_loading dbms_sql.VARCHAR2_TABLE;
683: v_port_of_discharge dbms_sql.VARCHAR2_TABLE;
684: v_transit_time dbms_sql.NUMBER_TABLE;
685: v_rate_chart_name dbms_sql.VARCHAR2_TABLE;
686: v_basis dbms_sql.VARCHAR2_TABLE;

Line 683: v_port_of_discharge dbms_sql.VARCHAR2_TABLE;

679: --v_equipment dbms_sql.VARCHAR2_TABLE;
680: v_schedules_flag dbms_sql.VARCHAR2_TABLE;
681: v_distance dbms_sql.NUMBER_TABLE;
682: v_port_of_loading dbms_sql.VARCHAR2_TABLE;
683: v_port_of_discharge dbms_sql.VARCHAR2_TABLE;
684: v_transit_time dbms_sql.NUMBER_TABLE;
685: v_rate_chart_name dbms_sql.VARCHAR2_TABLE;
686: v_basis dbms_sql.VARCHAR2_TABLE;
687: v_owner_id dbms_sql.NUMBER_TABLE;

Line 684: v_transit_time dbms_sql.NUMBER_TABLE;

680: v_schedules_flag dbms_sql.VARCHAR2_TABLE;
681: v_distance dbms_sql.NUMBER_TABLE;
682: v_port_of_loading dbms_sql.VARCHAR2_TABLE;
683: v_port_of_discharge dbms_sql.VARCHAR2_TABLE;
684: v_transit_time dbms_sql.NUMBER_TABLE;
685: v_rate_chart_name dbms_sql.VARCHAR2_TABLE;
686: v_basis dbms_sql.VARCHAR2_TABLE;
687: v_owner_id dbms_sql.NUMBER_TABLE;
688: v_carrier_id dbms_sql.NUMBER_TABLE;

Line 685: v_rate_chart_name dbms_sql.VARCHAR2_TABLE;

681: v_distance dbms_sql.NUMBER_TABLE;
682: v_port_of_loading dbms_sql.VARCHAR2_TABLE;
683: v_port_of_discharge dbms_sql.VARCHAR2_TABLE;
684: v_transit_time dbms_sql.NUMBER_TABLE;
685: v_rate_chart_name dbms_sql.VARCHAR2_TABLE;
686: v_basis dbms_sql.VARCHAR2_TABLE;
687: v_owner_id dbms_sql.NUMBER_TABLE;
688: v_carrier_id dbms_sql.NUMBER_TABLE;
689: v_mode_code dbms_sql.VARCHAR2_TABLE;

Line 686: v_basis dbms_sql.VARCHAR2_TABLE;

682: v_port_of_loading dbms_sql.VARCHAR2_TABLE;
683: v_port_of_discharge dbms_sql.VARCHAR2_TABLE;
684: v_transit_time dbms_sql.NUMBER_TABLE;
685: v_rate_chart_name dbms_sql.VARCHAR2_TABLE;
686: v_basis dbms_sql.VARCHAR2_TABLE;
687: v_owner_id dbms_sql.NUMBER_TABLE;
688: v_carrier_id dbms_sql.NUMBER_TABLE;
689: v_mode_code dbms_sql.VARCHAR2_TABLE;
690: v_transit_time_uom dbms_sql.VARCHAR2_TABLE;

Line 687: v_owner_id dbms_sql.NUMBER_TABLE;

683: v_port_of_discharge dbms_sql.VARCHAR2_TABLE;
684: v_transit_time dbms_sql.NUMBER_TABLE;
685: v_rate_chart_name dbms_sql.VARCHAR2_TABLE;
686: v_basis dbms_sql.VARCHAR2_TABLE;
687: v_owner_id dbms_sql.NUMBER_TABLE;
688: v_carrier_id dbms_sql.NUMBER_TABLE;
689: v_mode_code dbms_sql.VARCHAR2_TABLE;
690: v_transit_time_uom dbms_sql.VARCHAR2_TABLE;
691: v_special_handling dbms_sql.VARCHAR2_TABLE;

Line 688: v_carrier_id dbms_sql.NUMBER_TABLE;

684: v_transit_time dbms_sql.NUMBER_TABLE;
685: v_rate_chart_name dbms_sql.VARCHAR2_TABLE;
686: v_basis dbms_sql.VARCHAR2_TABLE;
687: v_owner_id dbms_sql.NUMBER_TABLE;
688: v_carrier_id dbms_sql.NUMBER_TABLE;
689: v_mode_code dbms_sql.VARCHAR2_TABLE;
690: v_transit_time_uom dbms_sql.VARCHAR2_TABLE;
691: v_special_handling dbms_sql.VARCHAR2_TABLE;
692: v_addl_instr dbms_sql.VARCHAR2_TABLE;

Line 689: v_mode_code dbms_sql.VARCHAR2_TABLE;

685: v_rate_chart_name dbms_sql.VARCHAR2_TABLE;
686: v_basis dbms_sql.VARCHAR2_TABLE;
687: v_owner_id dbms_sql.NUMBER_TABLE;
688: v_carrier_id dbms_sql.NUMBER_TABLE;
689: v_mode_code dbms_sql.VARCHAR2_TABLE;
690: v_transit_time_uom dbms_sql.VARCHAR2_TABLE;
691: v_special_handling dbms_sql.VARCHAR2_TABLE;
692: v_addl_instr dbms_sql.VARCHAR2_TABLE;
693: v_commodity_flag dbms_sql.VARCHAR2_TABLE;

Line 690: v_transit_time_uom dbms_sql.VARCHAR2_TABLE;

686: v_basis dbms_sql.VARCHAR2_TABLE;
687: v_owner_id dbms_sql.NUMBER_TABLE;
688: v_carrier_id dbms_sql.NUMBER_TABLE;
689: v_mode_code dbms_sql.VARCHAR2_TABLE;
690: v_transit_time_uom dbms_sql.VARCHAR2_TABLE;
691: v_special_handling dbms_sql.VARCHAR2_TABLE;
692: v_addl_instr dbms_sql.VARCHAR2_TABLE;
693: v_commodity_flag dbms_sql.VARCHAR2_TABLE;
694: --v_equipment_flag dbms_sql.VARCHAR2_TABLE;

Line 691: v_special_handling dbms_sql.VARCHAR2_TABLE;

687: v_owner_id dbms_sql.NUMBER_TABLE;
688: v_carrier_id dbms_sql.NUMBER_TABLE;
689: v_mode_code dbms_sql.VARCHAR2_TABLE;
690: v_transit_time_uom dbms_sql.VARCHAR2_TABLE;
691: v_special_handling dbms_sql.VARCHAR2_TABLE;
692: v_addl_instr dbms_sql.VARCHAR2_TABLE;
693: v_commodity_flag dbms_sql.VARCHAR2_TABLE;
694: --v_equipment_flag dbms_sql.VARCHAR2_TABLE;
695: v_service_flag dbms_sql.VARCHAR2_TABLE;

Line 692: v_addl_instr dbms_sql.VARCHAR2_TABLE;

688: v_carrier_id dbms_sql.NUMBER_TABLE;
689: v_mode_code dbms_sql.VARCHAR2_TABLE;
690: v_transit_time_uom dbms_sql.VARCHAR2_TABLE;
691: v_special_handling dbms_sql.VARCHAR2_TABLE;
692: v_addl_instr dbms_sql.VARCHAR2_TABLE;
693: v_commodity_flag dbms_sql.VARCHAR2_TABLE;
694: --v_equipment_flag dbms_sql.VARCHAR2_TABLE;
695: v_service_flag dbms_sql.VARCHAR2_TABLE;
696: v_comm_catg_id dbms_sql.NUMBER_TABLE;

Line 693: v_commodity_flag dbms_sql.VARCHAR2_TABLE;

689: v_mode_code dbms_sql.VARCHAR2_TABLE;
690: v_transit_time_uom dbms_sql.VARCHAR2_TABLE;
691: v_special_handling dbms_sql.VARCHAR2_TABLE;
692: v_addl_instr dbms_sql.VARCHAR2_TABLE;
693: v_commodity_flag dbms_sql.VARCHAR2_TABLE;
694: --v_equipment_flag dbms_sql.VARCHAR2_TABLE;
695: v_service_flag dbms_sql.VARCHAR2_TABLE;
696: v_comm_catg_id dbms_sql.NUMBER_TABLE;
697: --v_equipment_code dbms_sql.VARCHAR2_TABLE;

Line 694: --v_equipment_flag dbms_sql.VARCHAR2_TABLE;

690: v_transit_time_uom dbms_sql.VARCHAR2_TABLE;
691: v_special_handling dbms_sql.VARCHAR2_TABLE;
692: v_addl_instr dbms_sql.VARCHAR2_TABLE;
693: v_commodity_flag dbms_sql.VARCHAR2_TABLE;
694: --v_equipment_flag dbms_sql.VARCHAR2_TABLE;
695: v_service_flag dbms_sql.VARCHAR2_TABLE;
696: v_comm_catg_id dbms_sql.NUMBER_TABLE;
697: --v_equipment_code dbms_sql.VARCHAR2_TABLE;
698: v_service_code dbms_sql.VARCHAR2_TABLE;

Line 695: v_service_flag dbms_sql.VARCHAR2_TABLE;

691: v_special_handling dbms_sql.VARCHAR2_TABLE;
692: v_addl_instr dbms_sql.VARCHAR2_TABLE;
693: v_commodity_flag dbms_sql.VARCHAR2_TABLE;
694: --v_equipment_flag dbms_sql.VARCHAR2_TABLE;
695: v_service_flag dbms_sql.VARCHAR2_TABLE;
696: v_comm_catg_id dbms_sql.NUMBER_TABLE;
697: --v_equipment_code dbms_sql.VARCHAR2_TABLE;
698: v_service_code dbms_sql.VARCHAR2_TABLE;
699: v_distance_uom dbms_sql.VARCHAR2_TABLE;

Line 696: v_comm_catg_id dbms_sql.NUMBER_TABLE;

692: v_addl_instr dbms_sql.VARCHAR2_TABLE;
693: v_commodity_flag dbms_sql.VARCHAR2_TABLE;
694: --v_equipment_flag dbms_sql.VARCHAR2_TABLE;
695: v_service_flag dbms_sql.VARCHAR2_TABLE;
696: v_comm_catg_id dbms_sql.NUMBER_TABLE;
697: --v_equipment_code dbms_sql.VARCHAR2_TABLE;
698: v_service_code dbms_sql.VARCHAR2_TABLE;
699: v_distance_uom dbms_sql.VARCHAR2_TABLE;
700: v_rate_chart_id dbms_sql.NUMBER_TABLE;

Line 697: --v_equipment_code dbms_sql.VARCHAR2_TABLE;

693: v_commodity_flag dbms_sql.VARCHAR2_TABLE;
694: --v_equipment_flag dbms_sql.VARCHAR2_TABLE;
695: v_service_flag dbms_sql.VARCHAR2_TABLE;
696: v_comm_catg_id dbms_sql.NUMBER_TABLE;
697: --v_equipment_code dbms_sql.VARCHAR2_TABLE;
698: v_service_code dbms_sql.VARCHAR2_TABLE;
699: v_distance_uom dbms_sql.VARCHAR2_TABLE;
700: v_rate_chart_id dbms_sql.NUMBER_TABLE;
701: v_rate_chart_view_flag dbms_sql.VARCHAR2_TABLE;

Line 698: v_service_code dbms_sql.VARCHAR2_TABLE;

694: --v_equipment_flag dbms_sql.VARCHAR2_TABLE;
695: v_service_flag dbms_sql.VARCHAR2_TABLE;
696: v_comm_catg_id dbms_sql.NUMBER_TABLE;
697: --v_equipment_code dbms_sql.VARCHAR2_TABLE;
698: v_service_code dbms_sql.VARCHAR2_TABLE;
699: v_distance_uom dbms_sql.VARCHAR2_TABLE;
700: v_rate_chart_id dbms_sql.NUMBER_TABLE;
701: v_rate_chart_view_flag dbms_sql.VARCHAR2_TABLE;
702: v_effective_date dbms_sql.DATE_TABLE;

Line 699: v_distance_uom dbms_sql.VARCHAR2_TABLE;

695: v_service_flag dbms_sql.VARCHAR2_TABLE;
696: v_comm_catg_id dbms_sql.NUMBER_TABLE;
697: --v_equipment_code dbms_sql.VARCHAR2_TABLE;
698: v_service_code dbms_sql.VARCHAR2_TABLE;
699: v_distance_uom dbms_sql.VARCHAR2_TABLE;
700: v_rate_chart_id dbms_sql.NUMBER_TABLE;
701: v_rate_chart_view_flag dbms_sql.VARCHAR2_TABLE;
702: v_effective_date dbms_sql.DATE_TABLE;
703: v_expiry_date dbms_sql.DATE_TABLE;

Line 700: v_rate_chart_id dbms_sql.NUMBER_TABLE;

696: v_comm_catg_id dbms_sql.NUMBER_TABLE;
697: --v_equipment_code dbms_sql.VARCHAR2_TABLE;
698: v_service_code dbms_sql.VARCHAR2_TABLE;
699: v_distance_uom dbms_sql.VARCHAR2_TABLE;
700: v_rate_chart_id dbms_sql.NUMBER_TABLE;
701: v_rate_chart_view_flag dbms_sql.VARCHAR2_TABLE;
702: v_effective_date dbms_sql.DATE_TABLE;
703: v_expiry_date dbms_sql.DATE_TABLE;
704: v_origin_region_type dbms_sql.NUMBER_TABLE;

Line 701: v_rate_chart_view_flag dbms_sql.VARCHAR2_TABLE;

697: --v_equipment_code dbms_sql.VARCHAR2_TABLE;
698: v_service_code dbms_sql.VARCHAR2_TABLE;
699: v_distance_uom dbms_sql.VARCHAR2_TABLE;
700: v_rate_chart_id dbms_sql.NUMBER_TABLE;
701: v_rate_chart_view_flag dbms_sql.VARCHAR2_TABLE;
702: v_effective_date dbms_sql.DATE_TABLE;
703: v_expiry_date dbms_sql.DATE_TABLE;
704: v_origin_region_type dbms_sql.NUMBER_TABLE;
705: v_dest_region_type dbms_sql.NUMBER_TABLE;

Line 702: v_effective_date dbms_sql.DATE_TABLE;

698: v_service_code dbms_sql.VARCHAR2_TABLE;
699: v_distance_uom dbms_sql.VARCHAR2_TABLE;
700: v_rate_chart_id dbms_sql.NUMBER_TABLE;
701: v_rate_chart_view_flag dbms_sql.VARCHAR2_TABLE;
702: v_effective_date dbms_sql.DATE_TABLE;
703: v_expiry_date dbms_sql.DATE_TABLE;
704: v_origin_region_type dbms_sql.NUMBER_TABLE;
705: v_dest_region_type dbms_sql.NUMBER_TABLE;
706: v_comm_class_code dbms_sql.VARCHAR2_TABLE;

Line 703: v_expiry_date dbms_sql.DATE_TABLE;

699: v_distance_uom dbms_sql.VARCHAR2_TABLE;
700: v_rate_chart_id dbms_sql.NUMBER_TABLE;
701: v_rate_chart_view_flag dbms_sql.VARCHAR2_TABLE;
702: v_effective_date dbms_sql.DATE_TABLE;
703: v_expiry_date dbms_sql.DATE_TABLE;
704: v_origin_region_type dbms_sql.NUMBER_TABLE;
705: v_dest_region_type dbms_sql.NUMBER_TABLE;
706: v_comm_class_code dbms_sql.VARCHAR2_TABLE;
707: v_schedules_flag_code dbms_sql.VARCHAR2_TABLE;

Line 704: v_origin_region_type dbms_sql.NUMBER_TABLE;

700: v_rate_chart_id dbms_sql.NUMBER_TABLE;
701: v_rate_chart_view_flag dbms_sql.VARCHAR2_TABLE;
702: v_effective_date dbms_sql.DATE_TABLE;
703: v_expiry_date dbms_sql.DATE_TABLE;
704: v_origin_region_type dbms_sql.NUMBER_TABLE;
705: v_dest_region_type dbms_sql.NUMBER_TABLE;
706: v_comm_class_code dbms_sql.VARCHAR2_TABLE;
707: v_schedules_flag_code dbms_sql.VARCHAR2_TABLE;
708: v_lane_service_id dbms_sql.NUMBER_TABLE;

Line 705: v_dest_region_type dbms_sql.NUMBER_TABLE;

701: v_rate_chart_view_flag dbms_sql.VARCHAR2_TABLE;
702: v_effective_date dbms_sql.DATE_TABLE;
703: v_expiry_date dbms_sql.DATE_TABLE;
704: v_origin_region_type dbms_sql.NUMBER_TABLE;
705: v_dest_region_type dbms_sql.NUMBER_TABLE;
706: v_comm_class_code dbms_sql.VARCHAR2_TABLE;
707: v_schedules_flag_code dbms_sql.VARCHAR2_TABLE;
708: v_lane_service_id dbms_sql.NUMBER_TABLE;
709: v_tariff_name dbms_sql.VARCHAR2_TABLE;

Line 706: v_comm_class_code dbms_sql.VARCHAR2_TABLE;

702: v_effective_date dbms_sql.DATE_TABLE;
703: v_expiry_date dbms_sql.DATE_TABLE;
704: v_origin_region_type dbms_sql.NUMBER_TABLE;
705: v_dest_region_type dbms_sql.NUMBER_TABLE;
706: v_comm_class_code dbms_sql.VARCHAR2_TABLE;
707: v_schedules_flag_code dbms_sql.VARCHAR2_TABLE;
708: v_lane_service_id dbms_sql.NUMBER_TABLE;
709: v_tariff_name dbms_sql.VARCHAR2_TABLE;
710: v_lane_type dbms_sql.VARCHAR2_TABLE;

Line 707: v_schedules_flag_code dbms_sql.VARCHAR2_TABLE;

703: v_expiry_date dbms_sql.DATE_TABLE;
704: v_origin_region_type dbms_sql.NUMBER_TABLE;
705: v_dest_region_type dbms_sql.NUMBER_TABLE;
706: v_comm_class_code dbms_sql.VARCHAR2_TABLE;
707: v_schedules_flag_code dbms_sql.VARCHAR2_TABLE;
708: v_lane_service_id dbms_sql.NUMBER_TABLE;
709: v_tariff_name dbms_sql.VARCHAR2_TABLE;
710: v_lane_type dbms_sql.VARCHAR2_TABLE;
711:

Line 708: v_lane_service_id dbms_sql.NUMBER_TABLE;

704: v_origin_region_type dbms_sql.NUMBER_TABLE;
705: v_dest_region_type dbms_sql.NUMBER_TABLE;
706: v_comm_class_code dbms_sql.VARCHAR2_TABLE;
707: v_schedules_flag_code dbms_sql.VARCHAR2_TABLE;
708: v_lane_service_id dbms_sql.NUMBER_TABLE;
709: v_tariff_name dbms_sql.VARCHAR2_TABLE;
710: v_lane_type dbms_sql.VARCHAR2_TABLE;
711:
712: -- variables for keeping track of transit time info

Line 709: v_tariff_name dbms_sql.VARCHAR2_TABLE;

705: v_dest_region_type dbms_sql.NUMBER_TABLE;
706: v_comm_class_code dbms_sql.VARCHAR2_TABLE;
707: v_schedules_flag_code dbms_sql.VARCHAR2_TABLE;
708: v_lane_service_id dbms_sql.NUMBER_TABLE;
709: v_tariff_name dbms_sql.VARCHAR2_TABLE;
710: v_lane_type dbms_sql.VARCHAR2_TABLE;
711:
712: -- variables for keeping track of transit time info
713: l_transit_time NUMBER;

Line 710: v_lane_type dbms_sql.VARCHAR2_TABLE;

706: v_comm_class_code dbms_sql.VARCHAR2_TABLE;
707: v_schedules_flag_code dbms_sql.VARCHAR2_TABLE;
708: v_lane_service_id dbms_sql.NUMBER_TABLE;
709: v_tariff_name dbms_sql.VARCHAR2_TABLE;
710: v_lane_type dbms_sql.VARCHAR2_TABLE;
711:
712: -- variables for keeping track of transit time info
713: l_transit_time NUMBER;
714: l_transit_time_uom VARCHAR2(30);

Line 717: s_schedule_id dbms_sql.NUMBER_TABLE;

713: l_transit_time NUMBER;
714: l_transit_time_uom VARCHAR2(30);
715:
716: -- variables of column type for binding sql stmt for schedules
717: s_schedule_id dbms_sql.NUMBER_TABLE;
718: s_lane_id dbms_sql.NUMBER_TABLE;
719: s_lane_number dbms_sql.VARCHAR2_TABLE;
720: s_dep_date dbms_sql.DATE_TABLE;
721: s_arr_date dbms_sql.DATE_TABLE;

Line 718: s_lane_id dbms_sql.NUMBER_TABLE;

714: l_transit_time_uom VARCHAR2(30);
715:
716: -- variables of column type for binding sql stmt for schedules
717: s_schedule_id dbms_sql.NUMBER_TABLE;
718: s_lane_id dbms_sql.NUMBER_TABLE;
719: s_lane_number dbms_sql.VARCHAR2_TABLE;
720: s_dep_date dbms_sql.DATE_TABLE;
721: s_arr_date dbms_sql.DATE_TABLE;
722: s_transit_time dbms_sql.NUMBER_TABLE;

Line 719: s_lane_number dbms_sql.VARCHAR2_TABLE;

715:
716: -- variables of column type for binding sql stmt for schedules
717: s_schedule_id dbms_sql.NUMBER_TABLE;
718: s_lane_id dbms_sql.NUMBER_TABLE;
719: s_lane_number dbms_sql.VARCHAR2_TABLE;
720: s_dep_date dbms_sql.DATE_TABLE;
721: s_arr_date dbms_sql.DATE_TABLE;
722: s_transit_time dbms_sql.NUMBER_TABLE;
723: s_frequency dbms_sql.VARCHAR2_TABLE;

Line 720: s_dep_date dbms_sql.DATE_TABLE;

716: -- variables of column type for binding sql stmt for schedules
717: s_schedule_id dbms_sql.NUMBER_TABLE;
718: s_lane_id dbms_sql.NUMBER_TABLE;
719: s_lane_number dbms_sql.VARCHAR2_TABLE;
720: s_dep_date dbms_sql.DATE_TABLE;
721: s_arr_date dbms_sql.DATE_TABLE;
722: s_transit_time dbms_sql.NUMBER_TABLE;
723: s_frequency dbms_sql.VARCHAR2_TABLE;
724: s_effective_date dbms_sql.DATE_TABLE;

Line 721: s_arr_date dbms_sql.DATE_TABLE;

717: s_schedule_id dbms_sql.NUMBER_TABLE;
718: s_lane_id dbms_sql.NUMBER_TABLE;
719: s_lane_number dbms_sql.VARCHAR2_TABLE;
720: s_dep_date dbms_sql.DATE_TABLE;
721: s_arr_date dbms_sql.DATE_TABLE;
722: s_transit_time dbms_sql.NUMBER_TABLE;
723: s_frequency dbms_sql.VARCHAR2_TABLE;
724: s_effective_date dbms_sql.DATE_TABLE;
725: s_port_of_loading dbms_sql.VARCHAR2_TABLE;

Line 722: s_transit_time dbms_sql.NUMBER_TABLE;

718: s_lane_id dbms_sql.NUMBER_TABLE;
719: s_lane_number dbms_sql.VARCHAR2_TABLE;
720: s_dep_date dbms_sql.DATE_TABLE;
721: s_arr_date dbms_sql.DATE_TABLE;
722: s_transit_time dbms_sql.NUMBER_TABLE;
723: s_frequency dbms_sql.VARCHAR2_TABLE;
724: s_effective_date dbms_sql.DATE_TABLE;
725: s_port_of_loading dbms_sql.VARCHAR2_TABLE;
726: s_port_of_discharge dbms_sql.VARCHAR2_TABLE;

Line 723: s_frequency dbms_sql.VARCHAR2_TABLE;

719: s_lane_number dbms_sql.VARCHAR2_TABLE;
720: s_dep_date dbms_sql.DATE_TABLE;
721: s_arr_date dbms_sql.DATE_TABLE;
722: s_transit_time dbms_sql.NUMBER_TABLE;
723: s_frequency dbms_sql.VARCHAR2_TABLE;
724: s_effective_date dbms_sql.DATE_TABLE;
725: s_port_of_loading dbms_sql.VARCHAR2_TABLE;
726: s_port_of_discharge dbms_sql.VARCHAR2_TABLE;
727: s_expiry_date dbms_sql.DATE_TABLE;

Line 724: s_effective_date dbms_sql.DATE_TABLE;

720: s_dep_date dbms_sql.DATE_TABLE;
721: s_arr_date dbms_sql.DATE_TABLE;
722: s_transit_time dbms_sql.NUMBER_TABLE;
723: s_frequency dbms_sql.VARCHAR2_TABLE;
724: s_effective_date dbms_sql.DATE_TABLE;
725: s_port_of_loading dbms_sql.VARCHAR2_TABLE;
726: s_port_of_discharge dbms_sql.VARCHAR2_TABLE;
727: s_expiry_date dbms_sql.DATE_TABLE;
728: s_arr_date_indicator dbms_sql.NUMBER_TABLE;

Line 725: s_port_of_loading dbms_sql.VARCHAR2_TABLE;

721: s_arr_date dbms_sql.DATE_TABLE;
722: s_transit_time dbms_sql.NUMBER_TABLE;
723: s_frequency dbms_sql.VARCHAR2_TABLE;
724: s_effective_date dbms_sql.DATE_TABLE;
725: s_port_of_loading dbms_sql.VARCHAR2_TABLE;
726: s_port_of_discharge dbms_sql.VARCHAR2_TABLE;
727: s_expiry_date dbms_sql.DATE_TABLE;
728: s_arr_date_indicator dbms_sql.NUMBER_TABLE;
729: s_frequency_arrival dbms_sql.VARCHAR2_TABLE;

Line 726: s_port_of_discharge dbms_sql.VARCHAR2_TABLE;

722: s_transit_time dbms_sql.NUMBER_TABLE;
723: s_frequency dbms_sql.VARCHAR2_TABLE;
724: s_effective_date dbms_sql.DATE_TABLE;
725: s_port_of_loading dbms_sql.VARCHAR2_TABLE;
726: s_port_of_discharge dbms_sql.VARCHAR2_TABLE;
727: s_expiry_date dbms_sql.DATE_TABLE;
728: s_arr_date_indicator dbms_sql.NUMBER_TABLE;
729: s_frequency_arrival dbms_sql.VARCHAR2_TABLE;
730: s_origin_id dbms_sql.NUMBER_TABLE;

Line 727: s_expiry_date dbms_sql.DATE_TABLE;

723: s_frequency dbms_sql.VARCHAR2_TABLE;
724: s_effective_date dbms_sql.DATE_TABLE;
725: s_port_of_loading dbms_sql.VARCHAR2_TABLE;
726: s_port_of_discharge dbms_sql.VARCHAR2_TABLE;
727: s_expiry_date dbms_sql.DATE_TABLE;
728: s_arr_date_indicator dbms_sql.NUMBER_TABLE;
729: s_frequency_arrival dbms_sql.VARCHAR2_TABLE;
730: s_origin_id dbms_sql.NUMBER_TABLE;
731: s_destination_id dbms_sql.NUMBER_TABLE;

Line 728: s_arr_date_indicator dbms_sql.NUMBER_TABLE;

724: s_effective_date dbms_sql.DATE_TABLE;
725: s_port_of_loading dbms_sql.VARCHAR2_TABLE;
726: s_port_of_discharge dbms_sql.VARCHAR2_TABLE;
727: s_expiry_date dbms_sql.DATE_TABLE;
728: s_arr_date_indicator dbms_sql.NUMBER_TABLE;
729: s_frequency_arrival dbms_sql.VARCHAR2_TABLE;
730: s_origin_id dbms_sql.NUMBER_TABLE;
731: s_destination_id dbms_sql.NUMBER_TABLE;
732: s_mode dbms_sql.VARCHAR2_TABLE;

Line 729: s_frequency_arrival dbms_sql.VARCHAR2_TABLE;

725: s_port_of_loading dbms_sql.VARCHAR2_TABLE;
726: s_port_of_discharge dbms_sql.VARCHAR2_TABLE;
727: s_expiry_date dbms_sql.DATE_TABLE;
728: s_arr_date_indicator dbms_sql.NUMBER_TABLE;
729: s_frequency_arrival dbms_sql.VARCHAR2_TABLE;
730: s_origin_id dbms_sql.NUMBER_TABLE;
731: s_destination_id dbms_sql.NUMBER_TABLE;
732: s_mode dbms_sql.VARCHAR2_TABLE;
733: s_carrier_id dbms_sql.NUMBER_TABLE;

Line 730: s_origin_id dbms_sql.NUMBER_TABLE;

726: s_port_of_discharge dbms_sql.VARCHAR2_TABLE;
727: s_expiry_date dbms_sql.DATE_TABLE;
728: s_arr_date_indicator dbms_sql.NUMBER_TABLE;
729: s_frequency_arrival dbms_sql.VARCHAR2_TABLE;
730: s_origin_id dbms_sql.NUMBER_TABLE;
731: s_destination_id dbms_sql.NUMBER_TABLE;
732: s_mode dbms_sql.VARCHAR2_TABLE;
733: s_carrier_id dbms_sql.NUMBER_TABLE;
734: s_carrier_name dbms_sql.VARCHAR2_TABLE;

Line 731: s_destination_id dbms_sql.NUMBER_TABLE;

727: s_expiry_date dbms_sql.DATE_TABLE;
728: s_arr_date_indicator dbms_sql.NUMBER_TABLE;
729: s_frequency_arrival dbms_sql.VARCHAR2_TABLE;
730: s_origin_id dbms_sql.NUMBER_TABLE;
731: s_destination_id dbms_sql.NUMBER_TABLE;
732: s_mode dbms_sql.VARCHAR2_TABLE;
733: s_carrier_id dbms_sql.NUMBER_TABLE;
734: s_carrier_name dbms_sql.VARCHAR2_TABLE;
735: s_dep_time dbms_sql.VARCHAR2_TABLE;

Line 732: s_mode dbms_sql.VARCHAR2_TABLE;

728: s_arr_date_indicator dbms_sql.NUMBER_TABLE;
729: s_frequency_arrival dbms_sql.VARCHAR2_TABLE;
730: s_origin_id dbms_sql.NUMBER_TABLE;
731: s_destination_id dbms_sql.NUMBER_TABLE;
732: s_mode dbms_sql.VARCHAR2_TABLE;
733: s_carrier_id dbms_sql.NUMBER_TABLE;
734: s_carrier_name dbms_sql.VARCHAR2_TABLE;
735: s_dep_time dbms_sql.VARCHAR2_TABLE;
736: s_arr_time dbms_sql.VARCHAR2_TABLE;

Line 733: s_carrier_id dbms_sql.NUMBER_TABLE;

729: s_frequency_arrival dbms_sql.VARCHAR2_TABLE;
730: s_origin_id dbms_sql.NUMBER_TABLE;
731: s_destination_id dbms_sql.NUMBER_TABLE;
732: s_mode dbms_sql.VARCHAR2_TABLE;
733: s_carrier_id dbms_sql.NUMBER_TABLE;
734: s_carrier_name dbms_sql.VARCHAR2_TABLE;
735: s_dep_time dbms_sql.VARCHAR2_TABLE;
736: s_arr_time dbms_sql.VARCHAR2_TABLE;
737: s_frequency_type dbms_sql.VARCHAR2_TABLE;

Line 734: s_carrier_name dbms_sql.VARCHAR2_TABLE;

730: s_origin_id dbms_sql.NUMBER_TABLE;
731: s_destination_id dbms_sql.NUMBER_TABLE;
732: s_mode dbms_sql.VARCHAR2_TABLE;
733: s_carrier_id dbms_sql.NUMBER_TABLE;
734: s_carrier_name dbms_sql.VARCHAR2_TABLE;
735: s_dep_time dbms_sql.VARCHAR2_TABLE;
736: s_arr_time dbms_sql.VARCHAR2_TABLE;
737: s_frequency_type dbms_sql.VARCHAR2_TABLE;
738: s_transit_time_uom dbms_sql.VARCHAR2_TABLE;

Line 735: s_dep_time dbms_sql.VARCHAR2_TABLE;

731: s_destination_id dbms_sql.NUMBER_TABLE;
732: s_mode dbms_sql.VARCHAR2_TABLE;
733: s_carrier_id dbms_sql.NUMBER_TABLE;
734: s_carrier_name dbms_sql.VARCHAR2_TABLE;
735: s_dep_time dbms_sql.VARCHAR2_TABLE;
736: s_arr_time dbms_sql.VARCHAR2_TABLE;
737: s_frequency_type dbms_sql.VARCHAR2_TABLE;
738: s_transit_time_uom dbms_sql.VARCHAR2_TABLE;
739: s_vessel_type dbms_sql.VARCHAR2_TABLE;

Line 736: s_arr_time dbms_sql.VARCHAR2_TABLE;

732: s_mode dbms_sql.VARCHAR2_TABLE;
733: s_carrier_id dbms_sql.NUMBER_TABLE;
734: s_carrier_name dbms_sql.VARCHAR2_TABLE;
735: s_dep_time dbms_sql.VARCHAR2_TABLE;
736: s_arr_time dbms_sql.VARCHAR2_TABLE;
737: s_frequency_type dbms_sql.VARCHAR2_TABLE;
738: s_transit_time_uom dbms_sql.VARCHAR2_TABLE;
739: s_vessel_type dbms_sql.VARCHAR2_TABLE;
740: s_vessel_name dbms_sql.VARCHAR2_TABLE;

Line 737: s_frequency_type dbms_sql.VARCHAR2_TABLE;

733: s_carrier_id dbms_sql.NUMBER_TABLE;
734: s_carrier_name dbms_sql.VARCHAR2_TABLE;
735: s_dep_time dbms_sql.VARCHAR2_TABLE;
736: s_arr_time dbms_sql.VARCHAR2_TABLE;
737: s_frequency_type dbms_sql.VARCHAR2_TABLE;
738: s_transit_time_uom dbms_sql.VARCHAR2_TABLE;
739: s_vessel_type dbms_sql.VARCHAR2_TABLE;
740: s_vessel_name dbms_sql.VARCHAR2_TABLE;
741: s_voyage_number dbms_sql.VARCHAR2_TABLE;

Line 738: s_transit_time_uom dbms_sql.VARCHAR2_TABLE;

734: s_carrier_name dbms_sql.VARCHAR2_TABLE;
735: s_dep_time dbms_sql.VARCHAR2_TABLE;
736: s_arr_time dbms_sql.VARCHAR2_TABLE;
737: s_frequency_type dbms_sql.VARCHAR2_TABLE;
738: s_transit_time_uom dbms_sql.VARCHAR2_TABLE;
739: s_vessel_type dbms_sql.VARCHAR2_TABLE;
740: s_vessel_name dbms_sql.VARCHAR2_TABLE;
741: s_voyage_number dbms_sql.VARCHAR2_TABLE;
742: s_arr_time_w_ind dbms_sql.VARCHAR2_TABLE;

Line 739: s_vessel_type dbms_sql.VARCHAR2_TABLE;

735: s_dep_time dbms_sql.VARCHAR2_TABLE;
736: s_arr_time dbms_sql.VARCHAR2_TABLE;
737: s_frequency_type dbms_sql.VARCHAR2_TABLE;
738: s_transit_time_uom dbms_sql.VARCHAR2_TABLE;
739: s_vessel_type dbms_sql.VARCHAR2_TABLE;
740: s_vessel_name dbms_sql.VARCHAR2_TABLE;
741: s_voyage_number dbms_sql.VARCHAR2_TABLE;
742: s_arr_time_w_ind dbms_sql.VARCHAR2_TABLE;
743: s_mode_code dbms_sql.VARCHAR2_TABLE;

Line 740: s_vessel_name dbms_sql.VARCHAR2_TABLE;

736: s_arr_time dbms_sql.VARCHAR2_TABLE;
737: s_frequency_type dbms_sql.VARCHAR2_TABLE;
738: s_transit_time_uom dbms_sql.VARCHAR2_TABLE;
739: s_vessel_type dbms_sql.VARCHAR2_TABLE;
740: s_vessel_name dbms_sql.VARCHAR2_TABLE;
741: s_voyage_number dbms_sql.VARCHAR2_TABLE;
742: s_arr_time_w_ind dbms_sql.VARCHAR2_TABLE;
743: s_mode_code dbms_sql.VARCHAR2_TABLE;
744: s_service_code dbms_sql.VARCHAR2_TABLE;

Line 741: s_voyage_number dbms_sql.VARCHAR2_TABLE;

737: s_frequency_type dbms_sql.VARCHAR2_TABLE;
738: s_transit_time_uom dbms_sql.VARCHAR2_TABLE;
739: s_vessel_type dbms_sql.VARCHAR2_TABLE;
740: s_vessel_name dbms_sql.VARCHAR2_TABLE;
741: s_voyage_number dbms_sql.VARCHAR2_TABLE;
742: s_arr_time_w_ind dbms_sql.VARCHAR2_TABLE;
743: s_mode_code dbms_sql.VARCHAR2_TABLE;
744: s_service_code dbms_sql.VARCHAR2_TABLE;
745: s_service dbms_sql.VARCHAR2_TABLE;

Line 742: s_arr_time_w_ind dbms_sql.VARCHAR2_TABLE;

738: s_transit_time_uom dbms_sql.VARCHAR2_TABLE;
739: s_vessel_type dbms_sql.VARCHAR2_TABLE;
740: s_vessel_name dbms_sql.VARCHAR2_TABLE;
741: s_voyage_number dbms_sql.VARCHAR2_TABLE;
742: s_arr_time_w_ind dbms_sql.VARCHAR2_TABLE;
743: s_mode_code dbms_sql.VARCHAR2_TABLE;
744: s_service_code dbms_sql.VARCHAR2_TABLE;
745: s_service dbms_sql.VARCHAR2_TABLE;
746: s_frequency_type_code dbms_sql.VARCHAR2_TABLE;

Line 743: s_mode_code dbms_sql.VARCHAR2_TABLE;

739: s_vessel_type dbms_sql.VARCHAR2_TABLE;
740: s_vessel_name dbms_sql.VARCHAR2_TABLE;
741: s_voyage_number dbms_sql.VARCHAR2_TABLE;
742: s_arr_time_w_ind dbms_sql.VARCHAR2_TABLE;
743: s_mode_code dbms_sql.VARCHAR2_TABLE;
744: s_service_code dbms_sql.VARCHAR2_TABLE;
745: s_service dbms_sql.VARCHAR2_TABLE;
746: s_frequency_type_code dbms_sql.VARCHAR2_TABLE;
747: s_active_flag dbms_sql.VARCHAR2_TABLE;

Line 744: s_service_code dbms_sql.VARCHAR2_TABLE;

740: s_vessel_name dbms_sql.VARCHAR2_TABLE;
741: s_voyage_number dbms_sql.VARCHAR2_TABLE;
742: s_arr_time_w_ind dbms_sql.VARCHAR2_TABLE;
743: s_mode_code dbms_sql.VARCHAR2_TABLE;
744: s_service_code dbms_sql.VARCHAR2_TABLE;
745: s_service dbms_sql.VARCHAR2_TABLE;
746: s_frequency_type_code dbms_sql.VARCHAR2_TABLE;
747: s_active_flag dbms_sql.VARCHAR2_TABLE;
748:

Line 745: s_service dbms_sql.VARCHAR2_TABLE;

741: s_voyage_number dbms_sql.VARCHAR2_TABLE;
742: s_arr_time_w_ind dbms_sql.VARCHAR2_TABLE;
743: s_mode_code dbms_sql.VARCHAR2_TABLE;
744: s_service_code dbms_sql.VARCHAR2_TABLE;
745: s_service dbms_sql.VARCHAR2_TABLE;
746: s_frequency_type_code dbms_sql.VARCHAR2_TABLE;
747: s_active_flag dbms_sql.VARCHAR2_TABLE;
748:
749: l_num_rows NUMBER := 0;

Line 746: s_frequency_type_code dbms_sql.VARCHAR2_TABLE;

742: s_arr_time_w_ind dbms_sql.VARCHAR2_TABLE;
743: s_mode_code dbms_sql.VARCHAR2_TABLE;
744: s_service_code dbms_sql.VARCHAR2_TABLE;
745: s_service dbms_sql.VARCHAR2_TABLE;
746: s_frequency_type_code dbms_sql.VARCHAR2_TABLE;
747: s_active_flag dbms_sql.VARCHAR2_TABLE;
748:
749: l_num_rows NUMBER := 0;
750: l_lanes_rec fte_lane_rec;

Line 747: s_active_flag dbms_sql.VARCHAR2_TABLE;

743: s_mode_code dbms_sql.VARCHAR2_TABLE;
744: s_service_code dbms_sql.VARCHAR2_TABLE;
745: s_service dbms_sql.VARCHAR2_TABLE;
746: s_frequency_type_code dbms_sql.VARCHAR2_TABLE;
747: s_active_flag dbms_sql.VARCHAR2_TABLE;
748:
749: l_num_rows NUMBER := 0;
750: l_lanes_rec fte_lane_rec;
751: l_lanes_tab fte_lane_tab;

Line 1004: l_cursor_id := dbms_sql.OPEN_CURSOR;

1000: IF l_debug_on THEN
1001: WSH_DEBUG_SV.logmsg(l_module_name,'query:' || l_query1,WSH_DEBUG_SV.C_PROC_LEVEL);
1002: END IF;
1003:
1004: l_cursor_id := dbms_sql.OPEN_CURSOR;
1005: dbms_sql.PARSE(l_cursor_id, l_query1, DBMS_SQL.V7);
1006:
1007: Bind_Vars(l_cursor_id, l_bindvars1);
1008: Bind_Vars(l_cursor_id, l_bindvars3);

Line 1005: dbms_sql.PARSE(l_cursor_id, l_query1, DBMS_SQL.V7);

1001: WSH_DEBUG_SV.logmsg(l_module_name,'query:' || l_query1,WSH_DEBUG_SV.C_PROC_LEVEL);
1002: END IF;
1003:
1004: l_cursor_id := dbms_sql.OPEN_CURSOR;
1005: dbms_sql.PARSE(l_cursor_id, l_query1, DBMS_SQL.V7);
1006:
1007: Bind_Vars(l_cursor_id, l_bindvars1);
1008: Bind_Vars(l_cursor_id, l_bindvars3);
1009: Bind_Vars(l_cursor_id, l_bindvars4);

Line 1014: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_party_name, p_num_results, 1);

1010:
1011: -- [11/11] Add query type for Lane Group and Commitment -> 'T'
1012: if (p_source_type ='T') THEN
1013:
1014: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_party_name, p_num_results, 1);
1015: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_carrier_id, p_num_results, 1);
1016: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_origin_id, p_num_results, 1);
1017: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);
1018: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);

Line 1015: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_carrier_id, p_num_results, 1);

1011: -- [11/11] Add query type for Lane Group and Commitment -> 'T'
1012: if (p_source_type ='T') THEN
1013:
1014: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_party_name, p_num_results, 1);
1015: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_carrier_id, p_num_results, 1);
1016: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_origin_id, p_num_results, 1);
1017: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);
1018: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);
1019: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode_code, p_num_results, 1);

Line 1016: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_origin_id, p_num_results, 1);

1012: if (p_source_type ='T') THEN
1013:
1014: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_party_name, p_num_results, 1);
1015: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_carrier_id, p_num_results, 1);
1016: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_origin_id, p_num_results, 1);
1017: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);
1018: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);
1019: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode_code, p_num_results, 1);
1020: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_origin_region_type, p_num_results, 1);

Line 1017: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);

1013:
1014: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_party_name, p_num_results, 1);
1015: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_carrier_id, p_num_results, 1);
1016: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_origin_id, p_num_results, 1);
1017: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);
1018: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);
1019: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode_code, p_num_results, 1);
1020: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_origin_region_type, p_num_results, 1);
1021: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_lane_id, p_num_results, 1);

Line 1018: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);

1014: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_party_name, p_num_results, 1);
1015: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_carrier_id, p_num_results, 1);
1016: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_origin_id, p_num_results, 1);
1017: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);
1018: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);
1019: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode_code, p_num_results, 1);
1020: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_origin_region_type, p_num_results, 1);
1021: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_lane_id, p_num_results, 1);
1022:

Line 1019: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode_code, p_num_results, 1);

1015: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_carrier_id, p_num_results, 1);
1016: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_origin_id, p_num_results, 1);
1017: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);
1018: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);
1019: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode_code, p_num_results, 1);
1020: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_origin_region_type, p_num_results, 1);
1021: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_lane_id, p_num_results, 1);
1022:
1023: else

Line 1020: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_origin_region_type, p_num_results, 1);

1016: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_origin_id, p_num_results, 1);
1017: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);
1018: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);
1019: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode_code, p_num_results, 1);
1020: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_origin_region_type, p_num_results, 1);
1021: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_lane_id, p_num_results, 1);
1022:
1023: else
1024:

Line 1021: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_lane_id, p_num_results, 1);

1017: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);
1018: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);
1019: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode_code, p_num_results, 1);
1020: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_origin_region_type, p_num_results, 1);
1021: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_lane_id, p_num_results, 1);
1022:
1023: else
1024:
1025: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_lane_id, p_num_results, 1);

Line 1025: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_lane_id, p_num_results, 1);

1021: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_lane_id, p_num_results, 1);
1022:
1023: else
1024:
1025: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_lane_id, p_num_results, 1);
1026: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_lane_number, p_num_results, 1);
1027: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_party_name, p_num_results, 1);
1028: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);
1029: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);

Line 1026: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_lane_number, p_num_results, 1);

1022:
1023: else
1024:
1025: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_lane_id, p_num_results, 1);
1026: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_lane_number, p_num_results, 1);
1027: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_party_name, p_num_results, 1);
1028: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);
1029: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);
1030: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);

Line 1027: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_party_name, p_num_results, 1);

1023: else
1024:
1025: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_lane_id, p_num_results, 1);
1026: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_lane_number, p_num_results, 1);
1027: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_party_name, p_num_results, 1);
1028: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);
1029: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);
1030: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);
1031: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);

Line 1028: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);

1024:
1025: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_lane_id, p_num_results, 1);
1026: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_lane_number, p_num_results, 1);
1027: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_party_name, p_num_results, 1);
1028: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);
1029: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);
1030: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);
1031: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);
1032: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);

Line 1029: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);

1025: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_lane_id, p_num_results, 1);
1026: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_lane_number, p_num_results, 1);
1027: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_party_name, p_num_results, 1);
1028: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);
1029: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);
1030: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);
1031: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);
1032: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);
1033: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);

Line 1030: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);

1026: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_lane_number, p_num_results, 1);
1027: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_party_name, p_num_results, 1);
1028: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);
1029: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);
1030: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);
1031: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);
1032: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);
1033: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);
1034: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);

Line 1031: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);

1027: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_party_name, p_num_results, 1);
1028: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);
1029: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);
1030: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);
1031: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);
1032: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);
1033: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);
1034: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);
1035: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);

Line 1032: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);

1028: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);
1029: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);
1030: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);
1031: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);
1032: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);
1033: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);
1034: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);
1035: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);
1036: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);

Line 1033: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);

1029: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);
1030: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);
1031: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);
1032: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);
1033: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);
1034: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);
1035: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);
1036: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);
1037: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);

Line 1034: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);

1030: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);
1031: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);
1032: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);
1033: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);
1034: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);
1035: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);
1036: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);
1037: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);
1038: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);

Line 1035: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);

1031: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);
1032: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);
1033: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);
1034: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);
1035: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);
1036: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);
1037: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);
1038: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);
1039: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);

Line 1036: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);

1032: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);
1033: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);
1034: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);
1035: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);
1036: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);
1037: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);
1038: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);
1039: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);
1040: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);

Line 1037: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);

1033: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);
1034: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);
1035: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);
1036: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);
1037: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);
1038: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);
1039: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);
1040: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);
1041: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);

Line 1038: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);

1034: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);
1035: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);
1036: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);
1037: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);
1038: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);
1039: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);
1040: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);
1041: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);
1042: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);

Line 1039: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);

1035: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);
1036: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);
1037: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);
1038: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);
1039: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);
1040: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);
1041: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);
1042: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);
1043: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);

Line 1040: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);

1036: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);
1037: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);
1038: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);
1039: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);
1040: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);
1041: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);
1042: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);
1043: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);
1044: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);

Line 1041: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);

1037: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);
1038: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);
1039: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);
1040: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);
1041: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);
1042: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);
1043: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);
1044: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);
1045: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);

Line 1042: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);

1038: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);
1039: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);
1040: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);
1041: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);
1042: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);
1043: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);
1044: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);
1045: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);
1046: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);

Line 1043: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);

1039: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);
1040: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);
1041: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);
1042: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);
1043: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);
1044: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);
1045: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);
1046: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);
1047: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);

Line 1044: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);

1040: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);
1041: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);
1042: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);
1043: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);
1044: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);
1045: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);
1046: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);
1047: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);
1048: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);

Line 1045: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);

1041: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);
1042: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);
1043: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);
1044: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);
1045: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);
1046: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);
1047: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);
1048: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);
1049: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);

Line 1046: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);

1042: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);
1043: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);
1044: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);
1045: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);
1046: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);
1047: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);
1048: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);
1049: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);
1050: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);

Line 1047: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);

1043: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);
1044: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);
1045: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);
1046: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);
1047: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);
1048: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);
1049: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);
1050: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);
1051: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);

Line 1048: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);

1044: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);
1045: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);
1046: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);
1047: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);
1048: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);
1049: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);
1050: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);
1051: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);
1052: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);

Line 1049: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);

1045: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);
1046: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);
1047: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);
1048: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);
1049: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);
1050: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);
1051: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);
1052: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);
1053: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);

Line 1050: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);

1046: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);
1047: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);
1048: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);
1049: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);
1050: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);
1051: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);
1052: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);
1053: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);
1054: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);

Line 1051: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);

1047: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);
1048: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);
1049: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);
1050: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);
1051: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);
1052: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);
1053: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);
1054: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);
1055: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);

Line 1052: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);

1048: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);
1049: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);
1050: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);
1051: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);
1052: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);
1053: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);
1054: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);
1055: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);
1056: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);

Line 1053: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);

1049: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);
1050: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);
1051: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);
1052: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);
1053: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);
1054: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);
1055: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);
1056: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);
1057: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);

Line 1054: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);

1050: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);
1051: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);
1052: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);
1053: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);
1054: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);
1055: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);
1056: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);
1057: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);
1058: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);

Line 1055: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);

1051: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);
1052: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);
1053: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);
1054: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);
1055: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);
1056: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);
1057: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);
1058: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);
1059: dbms_sql.DEFINE_ARRAY(l_cursor_id, 35, v_lane_service_id, p_num_results, 1);

Line 1056: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);

1052: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);
1053: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);
1054: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);
1055: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);
1056: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);
1057: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);
1058: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);
1059: dbms_sql.DEFINE_ARRAY(l_cursor_id, 35, v_lane_service_id, p_num_results, 1);
1060: dbms_sql.DEFINE_ARRAY(l_cursor_id, 36, v_tariff_name, p_num_results, 1);

Line 1057: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);

1053: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);
1054: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);
1055: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);
1056: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);
1057: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);
1058: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);
1059: dbms_sql.DEFINE_ARRAY(l_cursor_id, 35, v_lane_service_id, p_num_results, 1);
1060: dbms_sql.DEFINE_ARRAY(l_cursor_id, 36, v_tariff_name, p_num_results, 1);
1061: dbms_sql.DEFINE_ARRAY(l_cursor_id, 37, v_lane_type, p_num_results, 1);

Line 1058: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);

1054: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);
1055: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);
1056: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);
1057: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);
1058: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);
1059: dbms_sql.DEFINE_ARRAY(l_cursor_id, 35, v_lane_service_id, p_num_results, 1);
1060: dbms_sql.DEFINE_ARRAY(l_cursor_id, 36, v_tariff_name, p_num_results, 1);
1061: dbms_sql.DEFINE_ARRAY(l_cursor_id, 37, v_lane_type, p_num_results, 1);
1062:

Line 1059: dbms_sql.DEFINE_ARRAY(l_cursor_id, 35, v_lane_service_id, p_num_results, 1);

1055: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);
1056: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);
1057: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);
1058: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);
1059: dbms_sql.DEFINE_ARRAY(l_cursor_id, 35, v_lane_service_id, p_num_results, 1);
1060: dbms_sql.DEFINE_ARRAY(l_cursor_id, 36, v_tariff_name, p_num_results, 1);
1061: dbms_sql.DEFINE_ARRAY(l_cursor_id, 37, v_lane_type, p_num_results, 1);
1062:
1063: end if;

Line 1060: dbms_sql.DEFINE_ARRAY(l_cursor_id, 36, v_tariff_name, p_num_results, 1);

1056: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);
1057: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);
1058: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);
1059: dbms_sql.DEFINE_ARRAY(l_cursor_id, 35, v_lane_service_id, p_num_results, 1);
1060: dbms_sql.DEFINE_ARRAY(l_cursor_id, 36, v_tariff_name, p_num_results, 1);
1061: dbms_sql.DEFINE_ARRAY(l_cursor_id, 37, v_lane_type, p_num_results, 1);
1062:
1063: end if;
1064:

Line 1061: dbms_sql.DEFINE_ARRAY(l_cursor_id, 37, v_lane_type, p_num_results, 1);

1057: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);
1058: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);
1059: dbms_sql.DEFINE_ARRAY(l_cursor_id, 35, v_lane_service_id, p_num_results, 1);
1060: dbms_sql.DEFINE_ARRAY(l_cursor_id, 36, v_tariff_name, p_num_results, 1);
1061: dbms_sql.DEFINE_ARRAY(l_cursor_id, 37, v_lane_type, p_num_results, 1);
1062:
1063: end if;
1064:
1065: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);

Line 1065: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);

1061: dbms_sql.DEFINE_ARRAY(l_cursor_id, 37, v_lane_type, p_num_results, 1);
1062:
1063: end if;
1064:
1065: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);
1066:
1067: LOOP
1068: l_rows_fetched := dbms_sql.FETCH_ROWS(l_cursor_id);
1069: IF (l_rows_fetched = 0) THEN

Line 1068: l_rows_fetched := dbms_sql.FETCH_ROWS(l_cursor_id);

1064:
1065: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);
1066:
1067: LOOP
1068: l_rows_fetched := dbms_sql.FETCH_ROWS(l_cursor_id);
1069: IF (l_rows_fetched = 0) THEN
1070: EXIT;
1071: END IF;
1072:

Line 1076: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_party_name);

1072:
1073: -- [11/11] Add query type for Lane Group and Commitment -> 'T'
1074: if (p_source_type ='T') THEN
1075:
1076: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_party_name);
1077: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_carrier_id);
1078: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_origin_id);
1079: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);
1080: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);

Line 1077: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_carrier_id);

1073: -- [11/11] Add query type for Lane Group and Commitment -> 'T'
1074: if (p_source_type ='T') THEN
1075:
1076: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_party_name);
1077: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_carrier_id);
1078: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_origin_id);
1079: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);
1080: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);
1081: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode_code);

Line 1078: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_origin_id);

1074: if (p_source_type ='T') THEN
1075:
1076: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_party_name);
1077: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_carrier_id);
1078: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_origin_id);
1079: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);
1080: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);
1081: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode_code);
1082: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_origin_region_type);

Line 1079: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);

1075:
1076: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_party_name);
1077: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_carrier_id);
1078: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_origin_id);
1079: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);
1080: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);
1081: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode_code);
1082: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_origin_region_type);
1083: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_lane_id);

Line 1080: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);

1076: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_party_name);
1077: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_carrier_id);
1078: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_origin_id);
1079: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);
1080: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);
1081: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode_code);
1082: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_origin_region_type);
1083: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_lane_id);
1084:

Line 1081: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode_code);

1077: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_carrier_id);
1078: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_origin_id);
1079: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);
1080: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);
1081: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode_code);
1082: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_origin_region_type);
1083: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_lane_id);
1084:
1085:

Line 1082: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_origin_region_type);

1078: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_origin_id);
1079: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);
1080: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);
1081: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode_code);
1082: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_origin_region_type);
1083: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_lane_id);
1084:
1085:
1086: else

Line 1083: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_lane_id);

1079: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);
1080: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);
1081: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode_code);
1082: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_origin_region_type);
1083: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_lane_id);
1084:
1085:
1086: else
1087:

Line 1088: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_lane_id);

1084:
1085:
1086: else
1087:
1088: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_lane_id);
1089: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_lane_number);
1090: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_party_name);
1091: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);
1092: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);

Line 1089: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_lane_number);

1085:
1086: else
1087:
1088: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_lane_id);
1089: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_lane_number);
1090: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_party_name);
1091: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);
1092: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);
1093: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);

Line 1090: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_party_name);

1086: else
1087:
1088: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_lane_id);
1089: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_lane_number);
1090: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_party_name);
1091: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);
1092: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);
1093: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);
1094: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);

Line 1091: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);

1087:
1088: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_lane_id);
1089: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_lane_number);
1090: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_party_name);
1091: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);
1092: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);
1093: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);
1094: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);
1095: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);

Line 1092: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);

1088: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_lane_id);
1089: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_lane_number);
1090: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_party_name);
1091: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);
1092: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);
1093: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);
1094: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);
1095: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);
1096: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);

Line 1093: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);

1089: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_lane_number);
1090: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_party_name);
1091: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);
1092: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);
1093: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);
1094: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);
1095: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);
1096: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);
1097: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);

Line 1094: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);

1090: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_party_name);
1091: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);
1092: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);
1093: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);
1094: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);
1095: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);
1096: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);
1097: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);
1098: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);

Line 1095: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);

1091: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);
1092: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);
1093: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);
1094: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);
1095: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);
1096: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);
1097: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);
1098: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);
1099: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);

Line 1096: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);

1092: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);
1093: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);
1094: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);
1095: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);
1096: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);
1097: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);
1098: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);
1099: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);
1100: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);

Line 1097: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);

1093: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);
1094: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);
1095: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);
1096: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);
1097: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);
1098: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);
1099: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);
1100: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);
1101: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);

Line 1098: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);

1094: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);
1095: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);
1096: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);
1097: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);
1098: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);
1099: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);
1100: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);
1101: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);
1102: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);

Line 1099: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);

1095: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);
1096: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);
1097: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);
1098: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);
1099: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);
1100: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);
1101: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);
1102: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);
1103: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);

Line 1100: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);

1096: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);
1097: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);
1098: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);
1099: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);
1100: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);
1101: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);
1102: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);
1103: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);
1104: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);

Line 1101: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);

1097: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);
1098: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);
1099: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);
1100: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);
1101: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);
1102: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);
1103: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);
1104: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);
1105: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);

Line 1102: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);

1098: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);
1099: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);
1100: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);
1101: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);
1102: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);
1103: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);
1104: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);
1105: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);
1106: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);

Line 1103: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);

1099: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);
1100: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);
1101: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);
1102: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);
1103: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);
1104: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);
1105: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);
1106: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);
1107: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);

Line 1104: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);

1100: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);
1101: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);
1102: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);
1103: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);
1104: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);
1105: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);
1106: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);
1107: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);
1108: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);

Line 1105: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);

1101: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);
1102: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);
1103: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);
1104: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);
1105: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);
1106: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);
1107: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);
1108: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);
1109: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);

Line 1106: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);

1102: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);
1103: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);
1104: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);
1105: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);
1106: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);
1107: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);
1108: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);
1109: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);
1110: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);

Line 1107: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);

1103: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);
1104: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);
1105: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);
1106: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);
1107: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);
1108: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);
1109: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);
1110: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);
1111: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);

Line 1108: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);

1104: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);
1105: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);
1106: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);
1107: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);
1108: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);
1109: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);
1110: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);
1111: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);
1112: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);

Line 1109: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);

1105: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);
1106: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);
1107: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);
1108: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);
1109: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);
1110: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);
1111: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);
1112: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);
1113: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);

Line 1110: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);

1106: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);
1107: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);
1108: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);
1109: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);
1110: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);
1111: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);
1112: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);
1113: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);
1114: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);

Line 1111: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);

1107: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);
1108: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);
1109: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);
1110: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);
1111: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);
1112: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);
1113: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);
1114: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);
1115: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);

Line 1112: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);

1108: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);
1109: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);
1110: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);
1111: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);
1112: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);
1113: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);
1114: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);
1115: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);
1116: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);

Line 1113: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);

1109: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);
1110: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);
1111: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);
1112: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);
1113: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);
1114: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);
1115: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);
1116: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);
1117: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);

Line 1114: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);

1110: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);
1111: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);
1112: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);
1113: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);
1114: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);
1115: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);
1116: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);
1117: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);
1118: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);

Line 1115: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);

1111: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);
1112: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);
1113: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);
1114: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);
1115: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);
1116: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);
1117: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);
1118: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);
1119: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);

Line 1116: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);

1112: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);
1113: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);
1114: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);
1115: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);
1116: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);
1117: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);
1118: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);
1119: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);
1120: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);

Line 1117: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);

1113: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);
1114: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);
1115: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);
1116: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);
1117: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);
1118: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);
1119: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);
1120: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);
1121: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);

Line 1118: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);

1114: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);
1115: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);
1116: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);
1117: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);
1118: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);
1119: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);
1120: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);
1121: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);
1122: dbms_sql.COLUMN_VALUE(l_cursor_id, 35, v_lane_service_id);

Line 1119: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);

1115: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);
1116: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);
1117: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);
1118: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);
1119: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);
1120: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);
1121: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);
1122: dbms_sql.COLUMN_VALUE(l_cursor_id, 35, v_lane_service_id);
1123: dbms_sql.COLUMN_VALUE(l_cursor_id, 36, v_tariff_name);

Line 1120: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);

1116: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);
1117: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);
1118: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);
1119: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);
1120: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);
1121: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);
1122: dbms_sql.COLUMN_VALUE(l_cursor_id, 35, v_lane_service_id);
1123: dbms_sql.COLUMN_VALUE(l_cursor_id, 36, v_tariff_name);
1124: dbms_sql.COLUMN_VALUE(l_cursor_id, 37, v_lane_type);

Line 1121: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);

1117: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);
1118: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);
1119: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);
1120: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);
1121: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);
1122: dbms_sql.COLUMN_VALUE(l_cursor_id, 35, v_lane_service_id);
1123: dbms_sql.COLUMN_VALUE(l_cursor_id, 36, v_tariff_name);
1124: dbms_sql.COLUMN_VALUE(l_cursor_id, 37, v_lane_type);
1125: end if;

Line 1122: dbms_sql.COLUMN_VALUE(l_cursor_id, 35, v_lane_service_id);

1118: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);
1119: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);
1120: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);
1121: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);
1122: dbms_sql.COLUMN_VALUE(l_cursor_id, 35, v_lane_service_id);
1123: dbms_sql.COLUMN_VALUE(l_cursor_id, 36, v_tariff_name);
1124: dbms_sql.COLUMN_VALUE(l_cursor_id, 37, v_lane_type);
1125: end if;
1126:

Line 1123: dbms_sql.COLUMN_VALUE(l_cursor_id, 36, v_tariff_name);

1119: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);
1120: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);
1121: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);
1122: dbms_sql.COLUMN_VALUE(l_cursor_id, 35, v_lane_service_id);
1123: dbms_sql.COLUMN_VALUE(l_cursor_id, 36, v_tariff_name);
1124: dbms_sql.COLUMN_VALUE(l_cursor_id, 37, v_lane_type);
1125: end if;
1126:
1127: FOR n IN 1..l_rows_fetched LOOP

Line 1124: dbms_sql.COLUMN_VALUE(l_cursor_id, 37, v_lane_type);

1120: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);
1121: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);
1122: dbms_sql.COLUMN_VALUE(l_cursor_id, 35, v_lane_service_id);
1123: dbms_sql.COLUMN_VALUE(l_cursor_id, 36, v_tariff_name);
1124: dbms_sql.COLUMN_VALUE(l_cursor_id, 37, v_lane_type);
1125: end if;
1126:
1127: FOR n IN 1..l_rows_fetched LOOP
1128:

Line 1365: dbms_sql.PARSE(l_cursor_id, l_query2, DBMS_SQL.V7);

1361: IF l_debug_on THEN
1362: WSH_DEBUG_SV.logmsg(l_module_name,'query2:' || l_query2,WSH_DEBUG_SV.C_PROC_LEVEL);
1363: END IF;
1364:
1365: dbms_sql.PARSE(l_cursor_id, l_query2, DBMS_SQL.V7);
1366:
1367: Bind_Vars(l_cursor_id, l_bindvars2);
1368: Bind_Vars(l_cursor_id, l_bindvars3);
1369: WSH_DEBUG_SV.logmsg(l_module_name,'Query^^^^^^^^ :'||l_query2 );

Line 1373: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_party_name, p_num_results, 1);

1369: WSH_DEBUG_SV.logmsg(l_module_name,'Query^^^^^^^^ :'||l_query2 );
1370: -- [11/11] Add query type for Lane Group and Commitment -> 'T'
1371: if (p_source_type ='T') THEN
1372:
1373: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_party_name, p_num_results, 1);
1374: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_carrier_id, p_num_results, 1);
1375: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_origin_id, p_num_results, 1);
1376: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);
1377: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);

Line 1374: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_carrier_id, p_num_results, 1);

1370: -- [11/11] Add query type for Lane Group and Commitment -> 'T'
1371: if (p_source_type ='T') THEN
1372:
1373: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_party_name, p_num_results, 1);
1374: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_carrier_id, p_num_results, 1);
1375: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_origin_id, p_num_results, 1);
1376: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);
1377: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);
1378: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode_code, p_num_results, 1);

Line 1375: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_origin_id, p_num_results, 1);

1371: if (p_source_type ='T') THEN
1372:
1373: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_party_name, p_num_results, 1);
1374: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_carrier_id, p_num_results, 1);
1375: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_origin_id, p_num_results, 1);
1376: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);
1377: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);
1378: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode_code, p_num_results, 1);
1379: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_origin_region_type, p_num_results, 1);

Line 1376: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);

1372:
1373: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_party_name, p_num_results, 1);
1374: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_carrier_id, p_num_results, 1);
1375: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_origin_id, p_num_results, 1);
1376: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);
1377: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);
1378: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode_code, p_num_results, 1);
1379: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_origin_region_type, p_num_results, 1);
1380: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_lane_id, p_num_results, 1);

Line 1377: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);

1373: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_party_name, p_num_results, 1);
1374: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_carrier_id, p_num_results, 1);
1375: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_origin_id, p_num_results, 1);
1376: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);
1377: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);
1378: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode_code, p_num_results, 1);
1379: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_origin_region_type, p_num_results, 1);
1380: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_lane_id, p_num_results, 1);
1381:

Line 1378: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode_code, p_num_results, 1);

1374: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_carrier_id, p_num_results, 1);
1375: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_origin_id, p_num_results, 1);
1376: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);
1377: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);
1378: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode_code, p_num_results, 1);
1379: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_origin_region_type, p_num_results, 1);
1380: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_lane_id, p_num_results, 1);
1381:
1382: else

Line 1379: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_origin_region_type, p_num_results, 1);

1375: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_origin_id, p_num_results, 1);
1376: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);
1377: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);
1378: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode_code, p_num_results, 1);
1379: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_origin_region_type, p_num_results, 1);
1380: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_lane_id, p_num_results, 1);
1381:
1382: else
1383:

Line 1380: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_lane_id, p_num_results, 1);

1376: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_destination_id, p_num_results, 1);
1377: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_mode, p_num_results, 1);
1378: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode_code, p_num_results, 1);
1379: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_origin_region_type, p_num_results, 1);
1380: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_lane_id, p_num_results, 1);
1381:
1382: else
1383:
1384: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_lane_id, p_num_results, 1);

Line 1384: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_lane_id, p_num_results, 1);

1380: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_lane_id, p_num_results, 1);
1381:
1382: else
1383:
1384: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_lane_id, p_num_results, 1);
1385: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_lane_number, p_num_results, 1);
1386: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_party_name, p_num_results, 1);
1387: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);
1388: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);

Line 1385: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_lane_number, p_num_results, 1);

1381:
1382: else
1383:
1384: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_lane_id, p_num_results, 1);
1385: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_lane_number, p_num_results, 1);
1386: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_party_name, p_num_results, 1);
1387: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);
1388: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);
1389: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);

Line 1386: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_party_name, p_num_results, 1);

1382: else
1383:
1384: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_lane_id, p_num_results, 1);
1385: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_lane_number, p_num_results, 1);
1386: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_party_name, p_num_results, 1);
1387: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);
1388: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);
1389: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);
1390: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);

Line 1387: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);

1383:
1384: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_lane_id, p_num_results, 1);
1385: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_lane_number, p_num_results, 1);
1386: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_party_name, p_num_results, 1);
1387: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);
1388: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);
1389: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);
1390: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);
1391: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);

Line 1388: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);

1384: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_lane_id, p_num_results, 1);
1385: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_lane_number, p_num_results, 1);
1386: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_party_name, p_num_results, 1);
1387: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);
1388: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);
1389: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);
1390: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);
1391: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);
1392: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);

Line 1389: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);

1385: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, v_lane_number, p_num_results, 1);
1386: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_party_name, p_num_results, 1);
1387: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);
1388: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);
1389: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);
1390: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);
1391: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);
1392: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);
1393: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);

Line 1390: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);

1386: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, v_party_name, p_num_results, 1);
1387: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);
1388: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);
1389: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);
1390: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);
1391: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);
1392: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);
1393: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);
1394: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);

Line 1391: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);

1387: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, v_origin_id, p_num_results, 1);
1388: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);
1389: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);
1390: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);
1391: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);
1392: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);
1393: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);
1394: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);
1395: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);

Line 1392: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);

1388: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, v_destination_id, p_num_results, 1);
1389: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);
1390: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);
1391: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);
1392: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);
1393: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);
1394: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);
1395: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);
1396: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);

Line 1393: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);

1389: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, v_mode, p_num_results, 1);
1390: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);
1391: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);
1392: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);
1393: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);
1394: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);
1395: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);
1396: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);
1397: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);

Line 1394: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);

1390: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, v_service, p_num_results, 1);
1391: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);
1392: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);
1393: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);
1394: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);
1395: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);
1396: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);
1397: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);
1398: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);

Line 1395: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);

1391: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, v_commodity, p_num_results, 1);
1392: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);
1393: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);
1394: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);
1395: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);
1396: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);
1397: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);
1398: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);
1399: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);

Line 1396: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);

1392: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, v_schedules_flag, p_num_results, 1);
1393: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);
1394: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);
1395: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);
1396: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);
1397: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);
1398: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);
1399: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);
1400: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);

Line 1397: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);

1393: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, v_distance, p_num_results, 1);
1394: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);
1395: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);
1396: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);
1397: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);
1398: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);
1399: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);
1400: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);
1401: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);

Line 1398: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);

1394: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, v_port_of_loading, p_num_results, 1);
1395: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);
1396: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);
1397: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);
1398: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);
1399: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);
1400: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);
1401: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);
1402: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);

Line 1399: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);

1395: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, v_port_of_discharge, p_num_results, 1);
1396: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);
1397: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);
1398: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);
1399: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);
1400: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);
1401: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);
1402: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);
1403: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);

Line 1400: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);

1396: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, v_transit_time, p_num_results, 1);
1397: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);
1398: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);
1399: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);
1400: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);
1401: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);
1402: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);
1403: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);
1404: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);

Line 1401: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);

1397: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, v_rate_chart_name, p_num_results, 1);
1398: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);
1399: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);
1400: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);
1401: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);
1402: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);
1403: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);
1404: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);
1405: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);

Line 1402: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);

1398: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, v_basis, p_num_results, 1);
1399: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);
1400: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);
1401: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);
1402: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);
1403: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);
1404: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);
1405: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);
1406: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);

Line 1403: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);

1399: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, v_owner_id, p_num_results, 1);
1400: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);
1401: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);
1402: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);
1403: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);
1404: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);
1405: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);
1406: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);
1407: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);

Line 1404: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);

1400: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, v_carrier_id, p_num_results, 1);
1401: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);
1402: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);
1403: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);
1404: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);
1405: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);
1406: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);
1407: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);
1408: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);

Line 1405: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);

1401: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, v_mode_code, p_num_results, 1);
1402: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);
1403: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);
1404: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);
1405: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);
1406: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);
1407: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);
1408: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);
1409: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);

Line 1406: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);

1402: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, v_transit_time_uom, p_num_results, 1);
1403: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);
1404: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);
1405: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);
1406: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);
1407: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);
1408: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);
1409: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);
1410: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);

Line 1407: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);

1403: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, v_special_handling, p_num_results, 1);
1404: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);
1405: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);
1406: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);
1407: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);
1408: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);
1409: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);
1410: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);
1411: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);

Line 1408: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);

1404: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, v_addl_instr, p_num_results, 1);
1405: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);
1406: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);
1407: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);
1408: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);
1409: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);
1410: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);
1411: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);
1412: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);

Line 1409: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);

1405: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, v_commodity_flag, p_num_results, 1);
1406: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);
1407: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);
1408: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);
1409: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);
1410: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);
1411: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);
1412: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);
1413: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);

Line 1410: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);

1406: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, v_service_flag, p_num_results, 1);
1407: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);
1408: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);
1409: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);
1410: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);
1411: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);
1412: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);
1413: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);
1414: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);

Line 1411: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);

1407: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, v_comm_catg_id, p_num_results, 1);
1408: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);
1409: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);
1410: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);
1411: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);
1412: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);
1413: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);
1414: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);
1415: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);

Line 1412: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);

1408: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, v_service_code, p_num_results, 1);
1409: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);
1410: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);
1411: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);
1412: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);
1413: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);
1414: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);
1415: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);
1416: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);

Line 1413: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);

1409: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, v_distance_uom, p_num_results, 1);
1410: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);
1411: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);
1412: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);
1413: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);
1414: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);
1415: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);
1416: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);
1417: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);

Line 1414: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);

1410: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, v_rate_chart_id, p_num_results, 1);
1411: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);
1412: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);
1413: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);
1414: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);
1415: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);
1416: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);
1417: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);
1418: dbms_sql.DEFINE_ARRAY(l_cursor_id, 35, v_lane_service_id, p_num_results, 1);

Line 1415: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);

1411: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, v_rate_chart_view_flag, p_num_results, 1);
1412: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);
1413: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);
1414: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);
1415: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);
1416: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);
1417: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);
1418: dbms_sql.DEFINE_ARRAY(l_cursor_id, 35, v_lane_service_id, p_num_results, 1);
1419: dbms_sql.DEFINE_ARRAY(l_cursor_id, 36, v_tariff_name, p_num_results, 1);

Line 1416: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);

1412: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, v_effective_date, p_num_results, 1);
1413: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);
1414: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);
1415: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);
1416: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);
1417: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);
1418: dbms_sql.DEFINE_ARRAY(l_cursor_id, 35, v_lane_service_id, p_num_results, 1);
1419: dbms_sql.DEFINE_ARRAY(l_cursor_id, 36, v_tariff_name, p_num_results, 1);
1420: dbms_sql.DEFINE_ARRAY(l_cursor_id, 37, v_lane_type, p_num_results, 1);

Line 1417: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);

1413: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, v_expiry_date, p_num_results, 1);
1414: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);
1415: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);
1416: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);
1417: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);
1418: dbms_sql.DEFINE_ARRAY(l_cursor_id, 35, v_lane_service_id, p_num_results, 1);
1419: dbms_sql.DEFINE_ARRAY(l_cursor_id, 36, v_tariff_name, p_num_results, 1);
1420: dbms_sql.DEFINE_ARRAY(l_cursor_id, 37, v_lane_type, p_num_results, 1);
1421: end if;

Line 1418: dbms_sql.DEFINE_ARRAY(l_cursor_id, 35, v_lane_service_id, p_num_results, 1);

1414: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, v_origin_region_type, p_num_results, 1);
1415: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);
1416: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);
1417: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);
1418: dbms_sql.DEFINE_ARRAY(l_cursor_id, 35, v_lane_service_id, p_num_results, 1);
1419: dbms_sql.DEFINE_ARRAY(l_cursor_id, 36, v_tariff_name, p_num_results, 1);
1420: dbms_sql.DEFINE_ARRAY(l_cursor_id, 37, v_lane_type, p_num_results, 1);
1421: end if;
1422:

Line 1419: dbms_sql.DEFINE_ARRAY(l_cursor_id, 36, v_tariff_name, p_num_results, 1);

1415: dbms_sql.DEFINE_ARRAY(l_cursor_id, 32, v_dest_region_type, p_num_results, 1);
1416: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);
1417: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);
1418: dbms_sql.DEFINE_ARRAY(l_cursor_id, 35, v_lane_service_id, p_num_results, 1);
1419: dbms_sql.DEFINE_ARRAY(l_cursor_id, 36, v_tariff_name, p_num_results, 1);
1420: dbms_sql.DEFINE_ARRAY(l_cursor_id, 37, v_lane_type, p_num_results, 1);
1421: end if;
1422:
1423: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);

Line 1420: dbms_sql.DEFINE_ARRAY(l_cursor_id, 37, v_lane_type, p_num_results, 1);

1416: dbms_sql.DEFINE_ARRAY(l_cursor_id, 33, v_comm_class_code, p_num_results, 1);
1417: dbms_sql.DEFINE_ARRAY(l_cursor_id, 34, v_schedules_flag_code, p_num_results, 1);
1418: dbms_sql.DEFINE_ARRAY(l_cursor_id, 35, v_lane_service_id, p_num_results, 1);
1419: dbms_sql.DEFINE_ARRAY(l_cursor_id, 36, v_tariff_name, p_num_results, 1);
1420: dbms_sql.DEFINE_ARRAY(l_cursor_id, 37, v_lane_type, p_num_results, 1);
1421: end if;
1422:
1423: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);
1424: LOOP

Line 1423: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);

1419: dbms_sql.DEFINE_ARRAY(l_cursor_id, 36, v_tariff_name, p_num_results, 1);
1420: dbms_sql.DEFINE_ARRAY(l_cursor_id, 37, v_lane_type, p_num_results, 1);
1421: end if;
1422:
1423: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);
1424: LOOP
1425: l_rows_fetched := dbms_sql.FETCH_ROWS(l_cursor_id);
1426: IF (l_rows_fetched = 0) THEN
1427: EXIT;

Line 1425: l_rows_fetched := dbms_sql.FETCH_ROWS(l_cursor_id);

1421: end if;
1422:
1423: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);
1424: LOOP
1425: l_rows_fetched := dbms_sql.FETCH_ROWS(l_cursor_id);
1426: IF (l_rows_fetched = 0) THEN
1427: EXIT;
1428: END IF;
1429:

Line 1433: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_party_name);

1429:
1430: -- [11/11] Add query type for Lane Group and Commitment -> 'T'
1431: if (p_source_type ='T') THEN
1432:
1433: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_party_name);
1434: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_carrier_id);
1435: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_origin_id);
1436: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);
1437: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);

Line 1434: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_carrier_id);

1430: -- [11/11] Add query type for Lane Group and Commitment -> 'T'
1431: if (p_source_type ='T') THEN
1432:
1433: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_party_name);
1434: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_carrier_id);
1435: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_origin_id);
1436: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);
1437: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);
1438: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode_code);

Line 1435: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_origin_id);

1431: if (p_source_type ='T') THEN
1432:
1433: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_party_name);
1434: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_carrier_id);
1435: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_origin_id);
1436: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);
1437: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);
1438: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode_code);
1439: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_origin_region_type);

Line 1436: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);

1432:
1433: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_party_name);
1434: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_carrier_id);
1435: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_origin_id);
1436: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);
1437: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);
1438: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode_code);
1439: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_origin_region_type);
1440: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_lane_id);

Line 1437: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);

1433: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_party_name);
1434: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_carrier_id);
1435: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_origin_id);
1436: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);
1437: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);
1438: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode_code);
1439: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_origin_region_type);
1440: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_lane_id);
1441:

Line 1438: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode_code);

1434: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_carrier_id);
1435: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_origin_id);
1436: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);
1437: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);
1438: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode_code);
1439: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_origin_region_type);
1440: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_lane_id);
1441:
1442: else

Line 1439: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_origin_region_type);

1435: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_origin_id);
1436: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);
1437: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);
1438: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode_code);
1439: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_origin_region_type);
1440: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_lane_id);
1441:
1442: else
1443:

Line 1440: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_lane_id);

1436: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_destination_id);
1437: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_mode);
1438: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode_code);
1439: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_origin_region_type);
1440: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_lane_id);
1441:
1442: else
1443:
1444: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_lane_id);

Line 1444: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_lane_id);

1440: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_lane_id);
1441:
1442: else
1443:
1444: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_lane_id);
1445: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_lane_number);
1446: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_party_name);
1447: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);
1448: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);

Line 1445: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_lane_number);

1441:
1442: else
1443:
1444: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_lane_id);
1445: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_lane_number);
1446: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_party_name);
1447: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);
1448: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);
1449: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);

Line 1446: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_party_name);

1442: else
1443:
1444: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_lane_id);
1445: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_lane_number);
1446: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_party_name);
1447: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);
1448: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);
1449: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);
1450: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);

Line 1447: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);

1443:
1444: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_lane_id);
1445: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_lane_number);
1446: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_party_name);
1447: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);
1448: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);
1449: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);
1450: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);
1451: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);

Line 1448: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);

1444: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_lane_id);
1445: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_lane_number);
1446: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_party_name);
1447: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);
1448: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);
1449: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);
1450: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);
1451: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);
1452: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);

Line 1449: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);

1445: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, v_lane_number);
1446: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_party_name);
1447: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);
1448: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);
1449: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);
1450: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);
1451: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);
1452: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);
1453: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);

Line 1450: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);

1446: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, v_party_name);
1447: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);
1448: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);
1449: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);
1450: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);
1451: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);
1452: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);
1453: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);
1454: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);

Line 1451: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);

1447: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, v_origin_id);
1448: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);
1449: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);
1450: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);
1451: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);
1452: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);
1453: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);
1454: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);
1455: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);

Line 1452: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);

1448: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, v_destination_id);
1449: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);
1450: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);
1451: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);
1452: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);
1453: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);
1454: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);
1455: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);
1456: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);

Line 1453: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);

1449: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, v_mode);
1450: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);
1451: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);
1452: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);
1453: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);
1454: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);
1455: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);
1456: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);
1457: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);

Line 1454: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);

1450: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, v_service);
1451: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);
1452: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);
1453: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);
1454: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);
1455: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);
1456: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);
1457: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);
1458: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);

Line 1455: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);

1451: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, v_commodity);
1452: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);
1453: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);
1454: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);
1455: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);
1456: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);
1457: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);
1458: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);
1459: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);

Line 1456: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);

1452: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, v_schedules_flag);
1453: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);
1454: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);
1455: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);
1456: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);
1457: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);
1458: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);
1459: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);
1460: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);

Line 1457: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);

1453: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, v_distance);
1454: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);
1455: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);
1456: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);
1457: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);
1458: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);
1459: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);
1460: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);
1461: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);

Line 1458: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);

1454: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, v_port_of_loading);
1455: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);
1456: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);
1457: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);
1458: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);
1459: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);
1460: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);
1461: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);
1462: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);

Line 1459: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);

1455: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, v_port_of_discharge);
1456: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);
1457: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);
1458: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);
1459: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);
1460: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);
1461: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);
1462: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);
1463: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);

Line 1460: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);

1456: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, v_transit_time);
1457: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);
1458: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);
1459: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);
1460: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);
1461: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);
1462: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);
1463: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);
1464: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);

Line 1461: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);

1457: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, v_rate_chart_name);
1458: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);
1459: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);
1460: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);
1461: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);
1462: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);
1463: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);
1464: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);
1465: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);

Line 1462: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);

1458: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, v_basis);
1459: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);
1460: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);
1461: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);
1462: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);
1463: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);
1464: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);
1465: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);
1466: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);

Line 1463: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);

1459: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, v_owner_id);
1460: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);
1461: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);
1462: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);
1463: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);
1464: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);
1465: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);
1466: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);
1467: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);

Line 1464: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);

1460: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, v_carrier_id);
1461: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);
1462: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);
1463: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);
1464: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);
1465: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);
1466: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);
1467: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);
1468: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);

Line 1465: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);

1461: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, v_mode_code);
1462: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);
1463: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);
1464: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);
1465: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);
1466: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);
1467: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);
1468: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);
1469: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);

Line 1466: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);

1462: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, v_transit_time_uom);
1463: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);
1464: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);
1465: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);
1466: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);
1467: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);
1468: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);
1469: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);
1470: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);

Line 1467: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);

1463: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, v_special_handling);
1464: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);
1465: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);
1466: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);
1467: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);
1468: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);
1469: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);
1470: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);
1471: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);

Line 1468: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);

1464: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, v_addl_instr);
1465: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);
1466: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);
1467: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);
1468: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);
1469: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);
1470: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);
1471: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);
1472: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);

Line 1469: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);

1465: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, v_commodity_flag);
1466: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);
1467: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);
1468: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);
1469: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);
1470: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);
1471: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);
1472: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);
1473: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);

Line 1470: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);

1466: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, v_service_flag);
1467: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);
1468: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);
1469: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);
1470: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);
1471: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);
1472: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);
1473: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);
1474: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);

Line 1471: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);

1467: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, v_comm_catg_id);
1468: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);
1469: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);
1470: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);
1471: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);
1472: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);
1473: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);
1474: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);
1475: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);

Line 1472: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);

1468: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, v_service_code);
1469: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);
1470: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);
1471: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);
1472: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);
1473: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);
1474: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);
1475: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);
1476: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);

Line 1473: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);

1469: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, v_distance_uom);
1470: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);
1471: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);
1472: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);
1473: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);
1474: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);
1475: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);
1476: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);
1477: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);

Line 1474: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);

1470: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, v_rate_chart_id);
1471: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);
1472: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);
1473: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);
1474: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);
1475: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);
1476: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);
1477: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);
1478: dbms_sql.COLUMN_VALUE(l_cursor_id, 35, v_lane_service_id);

Line 1475: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);

1471: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, v_rate_chart_view_flag);
1472: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);
1473: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);
1474: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);
1475: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);
1476: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);
1477: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);
1478: dbms_sql.COLUMN_VALUE(l_cursor_id, 35, v_lane_service_id);
1479: dbms_sql.COLUMN_VALUE(l_cursor_id, 36, v_tariff_name);

Line 1476: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);

1472: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, v_effective_date);
1473: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);
1474: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);
1475: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);
1476: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);
1477: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);
1478: dbms_sql.COLUMN_VALUE(l_cursor_id, 35, v_lane_service_id);
1479: dbms_sql.COLUMN_VALUE(l_cursor_id, 36, v_tariff_name);
1480: dbms_sql.COLUMN_VALUE(l_cursor_id, 37, v_lane_type);

Line 1477: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);

1473: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, v_expiry_date);
1474: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);
1475: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);
1476: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);
1477: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);
1478: dbms_sql.COLUMN_VALUE(l_cursor_id, 35, v_lane_service_id);
1479: dbms_sql.COLUMN_VALUE(l_cursor_id, 36, v_tariff_name);
1480: dbms_sql.COLUMN_VALUE(l_cursor_id, 37, v_lane_type);
1481:

Line 1478: dbms_sql.COLUMN_VALUE(l_cursor_id, 35, v_lane_service_id);

1474: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, v_origin_region_type);
1475: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);
1476: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);
1477: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);
1478: dbms_sql.COLUMN_VALUE(l_cursor_id, 35, v_lane_service_id);
1479: dbms_sql.COLUMN_VALUE(l_cursor_id, 36, v_tariff_name);
1480: dbms_sql.COLUMN_VALUE(l_cursor_id, 37, v_lane_type);
1481:
1482: end if;

Line 1479: dbms_sql.COLUMN_VALUE(l_cursor_id, 36, v_tariff_name);

1475: dbms_sql.COLUMN_VALUE(l_cursor_id, 32, v_dest_region_type);
1476: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);
1477: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);
1478: dbms_sql.COLUMN_VALUE(l_cursor_id, 35, v_lane_service_id);
1479: dbms_sql.COLUMN_VALUE(l_cursor_id, 36, v_tariff_name);
1480: dbms_sql.COLUMN_VALUE(l_cursor_id, 37, v_lane_type);
1481:
1482: end if;
1483:

Line 1480: dbms_sql.COLUMN_VALUE(l_cursor_id, 37, v_lane_type);

1476: dbms_sql.COLUMN_VALUE(l_cursor_id, 33, v_comm_class_code);
1477: dbms_sql.COLUMN_VALUE(l_cursor_id, 34, v_schedules_flag_code);
1478: dbms_sql.COLUMN_VALUE(l_cursor_id, 35, v_lane_service_id);
1479: dbms_sql.COLUMN_VALUE(l_cursor_id, 36, v_tariff_name);
1480: dbms_sql.COLUMN_VALUE(l_cursor_id, 37, v_lane_type);
1481:
1482: end if;
1483:
1484: FOR n IN 1..l_rows_fetched LOOP

Line 1680: dbms_sql.CLOSE_CURSOR(l_cursor_id);

1676:
1677: EXIT WHEN (l_rows_fetched < p_num_results OR l_lanes_tab.COUNT >= p_num_results);
1678:
1679: END LOOP;
1680: dbms_sql.CLOSE_CURSOR(l_cursor_id);
1681:
1682: END IF;
1683: -- call constraints API
1684:

Line 1713: l_cursor_id := dbms_sql.OPEN_CURSOR;

1709: IF l_debug_on THEN
1710: WSH_DEBUG_SV.logmsg(l_module_name,'schedule query: ' || l_query1,WSH_DEBUG_SV.C_PROC_LEVEL);
1711: END IF;
1712:
1713: l_cursor_id := dbms_sql.OPEN_CURSOR;
1714: dbms_sql.PARSE(l_cursor_id, l_query1, DBMS_SQL.V7);
1715:
1716: Bind_Vars(l_cursor_id, l_bindvars1);
1717:

Line 1714: dbms_sql.PARSE(l_cursor_id, l_query1, DBMS_SQL.V7);

1710: WSH_DEBUG_SV.logmsg(l_module_name,'schedule query: ' || l_query1,WSH_DEBUG_SV.C_PROC_LEVEL);
1711: END IF;
1712:
1713: l_cursor_id := dbms_sql.OPEN_CURSOR;
1714: dbms_sql.PARSE(l_cursor_id, l_query1, DBMS_SQL.V7);
1715:
1716: Bind_Vars(l_cursor_id, l_bindvars1);
1717:
1718: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, s_schedule_id, p_num_results, 1);

Line 1718: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, s_schedule_id, p_num_results, 1);

1714: dbms_sql.PARSE(l_cursor_id, l_query1, DBMS_SQL.V7);
1715:
1716: Bind_Vars(l_cursor_id, l_bindvars1);
1717:
1718: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, s_schedule_id, p_num_results, 1);
1719: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, s_lane_id, p_num_results, 1);
1720: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, s_lane_number, p_num_results, 1);
1721: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, s_dep_date, p_num_results, 1);
1722: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, s_arr_date, p_num_results, 1);

Line 1719: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, s_lane_id, p_num_results, 1);

1715:
1716: Bind_Vars(l_cursor_id, l_bindvars1);
1717:
1718: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, s_schedule_id, p_num_results, 1);
1719: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, s_lane_id, p_num_results, 1);
1720: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, s_lane_number, p_num_results, 1);
1721: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, s_dep_date, p_num_results, 1);
1722: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, s_arr_date, p_num_results, 1);
1723: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, s_transit_time, p_num_results, 1);

Line 1720: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, s_lane_number, p_num_results, 1);

1716: Bind_Vars(l_cursor_id, l_bindvars1);
1717:
1718: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, s_schedule_id, p_num_results, 1);
1719: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, s_lane_id, p_num_results, 1);
1720: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, s_lane_number, p_num_results, 1);
1721: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, s_dep_date, p_num_results, 1);
1722: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, s_arr_date, p_num_results, 1);
1723: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, s_transit_time, p_num_results, 1);
1724: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, s_frequency, p_num_results, 1);

Line 1721: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, s_dep_date, p_num_results, 1);

1717:
1718: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, s_schedule_id, p_num_results, 1);
1719: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, s_lane_id, p_num_results, 1);
1720: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, s_lane_number, p_num_results, 1);
1721: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, s_dep_date, p_num_results, 1);
1722: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, s_arr_date, p_num_results, 1);
1723: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, s_transit_time, p_num_results, 1);
1724: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, s_frequency, p_num_results, 1);
1725: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, s_effective_date, p_num_results, 1);

Line 1722: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, s_arr_date, p_num_results, 1);

1718: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, s_schedule_id, p_num_results, 1);
1719: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, s_lane_id, p_num_results, 1);
1720: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, s_lane_number, p_num_results, 1);
1721: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, s_dep_date, p_num_results, 1);
1722: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, s_arr_date, p_num_results, 1);
1723: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, s_transit_time, p_num_results, 1);
1724: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, s_frequency, p_num_results, 1);
1725: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, s_effective_date, p_num_results, 1);
1726: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, s_port_of_loading, p_num_results, 1);

Line 1723: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, s_transit_time, p_num_results, 1);

1719: dbms_sql.DEFINE_ARRAY(l_cursor_id, 2, s_lane_id, p_num_results, 1);
1720: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, s_lane_number, p_num_results, 1);
1721: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, s_dep_date, p_num_results, 1);
1722: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, s_arr_date, p_num_results, 1);
1723: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, s_transit_time, p_num_results, 1);
1724: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, s_frequency, p_num_results, 1);
1725: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, s_effective_date, p_num_results, 1);
1726: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, s_port_of_loading, p_num_results, 1);
1727: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, s_port_of_discharge, p_num_results, 1);

Line 1724: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, s_frequency, p_num_results, 1);

1720: dbms_sql.DEFINE_ARRAY(l_cursor_id, 3, s_lane_number, p_num_results, 1);
1721: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, s_dep_date, p_num_results, 1);
1722: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, s_arr_date, p_num_results, 1);
1723: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, s_transit_time, p_num_results, 1);
1724: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, s_frequency, p_num_results, 1);
1725: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, s_effective_date, p_num_results, 1);
1726: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, s_port_of_loading, p_num_results, 1);
1727: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, s_port_of_discharge, p_num_results, 1);
1728: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, s_expiry_date, p_num_results, 1);

Line 1725: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, s_effective_date, p_num_results, 1);

1721: dbms_sql.DEFINE_ARRAY(l_cursor_id, 4, s_dep_date, p_num_results, 1);
1722: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, s_arr_date, p_num_results, 1);
1723: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, s_transit_time, p_num_results, 1);
1724: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, s_frequency, p_num_results, 1);
1725: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, s_effective_date, p_num_results, 1);
1726: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, s_port_of_loading, p_num_results, 1);
1727: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, s_port_of_discharge, p_num_results, 1);
1728: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, s_expiry_date, p_num_results, 1);
1729: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, s_arr_date_indicator, p_num_results, 1);

Line 1726: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, s_port_of_loading, p_num_results, 1);

1722: dbms_sql.DEFINE_ARRAY(l_cursor_id, 5, s_arr_date, p_num_results, 1);
1723: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, s_transit_time, p_num_results, 1);
1724: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, s_frequency, p_num_results, 1);
1725: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, s_effective_date, p_num_results, 1);
1726: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, s_port_of_loading, p_num_results, 1);
1727: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, s_port_of_discharge, p_num_results, 1);
1728: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, s_expiry_date, p_num_results, 1);
1729: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, s_arr_date_indicator, p_num_results, 1);
1730: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, s_frequency_arrival, p_num_results, 1);

Line 1727: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, s_port_of_discharge, p_num_results, 1);

1723: dbms_sql.DEFINE_ARRAY(l_cursor_id, 6, s_transit_time, p_num_results, 1);
1724: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, s_frequency, p_num_results, 1);
1725: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, s_effective_date, p_num_results, 1);
1726: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, s_port_of_loading, p_num_results, 1);
1727: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, s_port_of_discharge, p_num_results, 1);
1728: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, s_expiry_date, p_num_results, 1);
1729: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, s_arr_date_indicator, p_num_results, 1);
1730: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, s_frequency_arrival, p_num_results, 1);
1731: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, s_origin_id, p_num_results, 1);

Line 1728: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, s_expiry_date, p_num_results, 1);

1724: dbms_sql.DEFINE_ARRAY(l_cursor_id, 7, s_frequency, p_num_results, 1);
1725: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, s_effective_date, p_num_results, 1);
1726: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, s_port_of_loading, p_num_results, 1);
1727: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, s_port_of_discharge, p_num_results, 1);
1728: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, s_expiry_date, p_num_results, 1);
1729: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, s_arr_date_indicator, p_num_results, 1);
1730: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, s_frequency_arrival, p_num_results, 1);
1731: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, s_origin_id, p_num_results, 1);
1732: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, s_destination_id, p_num_results, 1);

Line 1729: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, s_arr_date_indicator, p_num_results, 1);

1725: dbms_sql.DEFINE_ARRAY(l_cursor_id, 8, s_effective_date, p_num_results, 1);
1726: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, s_port_of_loading, p_num_results, 1);
1727: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, s_port_of_discharge, p_num_results, 1);
1728: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, s_expiry_date, p_num_results, 1);
1729: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, s_arr_date_indicator, p_num_results, 1);
1730: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, s_frequency_arrival, p_num_results, 1);
1731: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, s_origin_id, p_num_results, 1);
1732: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, s_destination_id, p_num_results, 1);
1733: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, s_mode, p_num_results, 1);

Line 1730: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, s_frequency_arrival, p_num_results, 1);

1726: dbms_sql.DEFINE_ARRAY(l_cursor_id, 9, s_port_of_loading, p_num_results, 1);
1727: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, s_port_of_discharge, p_num_results, 1);
1728: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, s_expiry_date, p_num_results, 1);
1729: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, s_arr_date_indicator, p_num_results, 1);
1730: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, s_frequency_arrival, p_num_results, 1);
1731: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, s_origin_id, p_num_results, 1);
1732: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, s_destination_id, p_num_results, 1);
1733: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, s_mode, p_num_results, 1);
1734: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, s_carrier_id, p_num_results, 1);

Line 1731: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, s_origin_id, p_num_results, 1);

1727: dbms_sql.DEFINE_ARRAY(l_cursor_id, 10, s_port_of_discharge, p_num_results, 1);
1728: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, s_expiry_date, p_num_results, 1);
1729: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, s_arr_date_indicator, p_num_results, 1);
1730: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, s_frequency_arrival, p_num_results, 1);
1731: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, s_origin_id, p_num_results, 1);
1732: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, s_destination_id, p_num_results, 1);
1733: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, s_mode, p_num_results, 1);
1734: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, s_carrier_id, p_num_results, 1);
1735: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, s_carrier_name, p_num_results, 1);

Line 1732: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, s_destination_id, p_num_results, 1);

1728: dbms_sql.DEFINE_ARRAY(l_cursor_id, 11, s_expiry_date, p_num_results, 1);
1729: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, s_arr_date_indicator, p_num_results, 1);
1730: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, s_frequency_arrival, p_num_results, 1);
1731: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, s_origin_id, p_num_results, 1);
1732: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, s_destination_id, p_num_results, 1);
1733: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, s_mode, p_num_results, 1);
1734: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, s_carrier_id, p_num_results, 1);
1735: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, s_carrier_name, p_num_results, 1);
1736: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, s_dep_time, p_num_results, 1);

Line 1733: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, s_mode, p_num_results, 1);

1729: dbms_sql.DEFINE_ARRAY(l_cursor_id, 12, s_arr_date_indicator, p_num_results, 1);
1730: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, s_frequency_arrival, p_num_results, 1);
1731: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, s_origin_id, p_num_results, 1);
1732: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, s_destination_id, p_num_results, 1);
1733: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, s_mode, p_num_results, 1);
1734: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, s_carrier_id, p_num_results, 1);
1735: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, s_carrier_name, p_num_results, 1);
1736: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, s_dep_time, p_num_results, 1);
1737: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, s_arr_time, p_num_results, 1);

Line 1734: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, s_carrier_id, p_num_results, 1);

1730: dbms_sql.DEFINE_ARRAY(l_cursor_id, 13, s_frequency_arrival, p_num_results, 1);
1731: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, s_origin_id, p_num_results, 1);
1732: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, s_destination_id, p_num_results, 1);
1733: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, s_mode, p_num_results, 1);
1734: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, s_carrier_id, p_num_results, 1);
1735: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, s_carrier_name, p_num_results, 1);
1736: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, s_dep_time, p_num_results, 1);
1737: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, s_arr_time, p_num_results, 1);
1738: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, s_frequency_type, p_num_results, 1); -- meaning

Line 1735: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, s_carrier_name, p_num_results, 1);

1731: dbms_sql.DEFINE_ARRAY(l_cursor_id, 14, s_origin_id, p_num_results, 1);
1732: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, s_destination_id, p_num_results, 1);
1733: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, s_mode, p_num_results, 1);
1734: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, s_carrier_id, p_num_results, 1);
1735: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, s_carrier_name, p_num_results, 1);
1736: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, s_dep_time, p_num_results, 1);
1737: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, s_arr_time, p_num_results, 1);
1738: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, s_frequency_type, p_num_results, 1); -- meaning
1739: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, s_transit_time_uom, p_num_results, 1);

Line 1736: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, s_dep_time, p_num_results, 1);

1732: dbms_sql.DEFINE_ARRAY(l_cursor_id, 15, s_destination_id, p_num_results, 1);
1733: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, s_mode, p_num_results, 1);
1734: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, s_carrier_id, p_num_results, 1);
1735: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, s_carrier_name, p_num_results, 1);
1736: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, s_dep_time, p_num_results, 1);
1737: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, s_arr_time, p_num_results, 1);
1738: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, s_frequency_type, p_num_results, 1); -- meaning
1739: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, s_transit_time_uom, p_num_results, 1);
1740: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, s_vessel_type, p_num_results, 1);

Line 1737: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, s_arr_time, p_num_results, 1);

1733: dbms_sql.DEFINE_ARRAY(l_cursor_id, 16, s_mode, p_num_results, 1);
1734: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, s_carrier_id, p_num_results, 1);
1735: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, s_carrier_name, p_num_results, 1);
1736: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, s_dep_time, p_num_results, 1);
1737: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, s_arr_time, p_num_results, 1);
1738: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, s_frequency_type, p_num_results, 1); -- meaning
1739: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, s_transit_time_uom, p_num_results, 1);
1740: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, s_vessel_type, p_num_results, 1);
1741: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, s_vessel_name, p_num_results, 1);

Line 1738: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, s_frequency_type, p_num_results, 1); -- meaning

1734: dbms_sql.DEFINE_ARRAY(l_cursor_id, 17, s_carrier_id, p_num_results, 1);
1735: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, s_carrier_name, p_num_results, 1);
1736: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, s_dep_time, p_num_results, 1);
1737: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, s_arr_time, p_num_results, 1);
1738: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, s_frequency_type, p_num_results, 1); -- meaning
1739: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, s_transit_time_uom, p_num_results, 1);
1740: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, s_vessel_type, p_num_results, 1);
1741: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, s_vessel_name, p_num_results, 1);
1742: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, s_voyage_number, p_num_results, 1);

Line 1739: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, s_transit_time_uom, p_num_results, 1);

1735: dbms_sql.DEFINE_ARRAY(l_cursor_id, 18, s_carrier_name, p_num_results, 1);
1736: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, s_dep_time, p_num_results, 1);
1737: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, s_arr_time, p_num_results, 1);
1738: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, s_frequency_type, p_num_results, 1); -- meaning
1739: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, s_transit_time_uom, p_num_results, 1);
1740: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, s_vessel_type, p_num_results, 1);
1741: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, s_vessel_name, p_num_results, 1);
1742: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, s_voyage_number, p_num_results, 1);
1743: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, s_arr_time_w_ind, p_num_results, 1);

Line 1740: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, s_vessel_type, p_num_results, 1);

1736: dbms_sql.DEFINE_ARRAY(l_cursor_id, 19, s_dep_time, p_num_results, 1);
1737: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, s_arr_time, p_num_results, 1);
1738: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, s_frequency_type, p_num_results, 1); -- meaning
1739: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, s_transit_time_uom, p_num_results, 1);
1740: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, s_vessel_type, p_num_results, 1);
1741: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, s_vessel_name, p_num_results, 1);
1742: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, s_voyage_number, p_num_results, 1);
1743: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, s_arr_time_w_ind, p_num_results, 1);
1744: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, s_mode_code, p_num_results, 1);

Line 1741: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, s_vessel_name, p_num_results, 1);

1737: dbms_sql.DEFINE_ARRAY(l_cursor_id, 20, s_arr_time, p_num_results, 1);
1738: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, s_frequency_type, p_num_results, 1); -- meaning
1739: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, s_transit_time_uom, p_num_results, 1);
1740: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, s_vessel_type, p_num_results, 1);
1741: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, s_vessel_name, p_num_results, 1);
1742: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, s_voyage_number, p_num_results, 1);
1743: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, s_arr_time_w_ind, p_num_results, 1);
1744: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, s_mode_code, p_num_results, 1);
1745: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, s_service_code, p_num_results, 1);

Line 1742: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, s_voyage_number, p_num_results, 1);

1738: dbms_sql.DEFINE_ARRAY(l_cursor_id, 21, s_frequency_type, p_num_results, 1); -- meaning
1739: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, s_transit_time_uom, p_num_results, 1);
1740: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, s_vessel_type, p_num_results, 1);
1741: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, s_vessel_name, p_num_results, 1);
1742: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, s_voyage_number, p_num_results, 1);
1743: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, s_arr_time_w_ind, p_num_results, 1);
1744: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, s_mode_code, p_num_results, 1);
1745: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, s_service_code, p_num_results, 1);
1746: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, s_service, p_num_results, 1);

Line 1743: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, s_arr_time_w_ind, p_num_results, 1);

1739: dbms_sql.DEFINE_ARRAY(l_cursor_id, 22, s_transit_time_uom, p_num_results, 1);
1740: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, s_vessel_type, p_num_results, 1);
1741: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, s_vessel_name, p_num_results, 1);
1742: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, s_voyage_number, p_num_results, 1);
1743: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, s_arr_time_w_ind, p_num_results, 1);
1744: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, s_mode_code, p_num_results, 1);
1745: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, s_service_code, p_num_results, 1);
1746: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, s_service, p_num_results, 1);
1747: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, s_frequency_type_code, p_num_results, 1);

Line 1744: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, s_mode_code, p_num_results, 1);

1740: dbms_sql.DEFINE_ARRAY(l_cursor_id, 23, s_vessel_type, p_num_results, 1);
1741: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, s_vessel_name, p_num_results, 1);
1742: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, s_voyage_number, p_num_results, 1);
1743: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, s_arr_time_w_ind, p_num_results, 1);
1744: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, s_mode_code, p_num_results, 1);
1745: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, s_service_code, p_num_results, 1);
1746: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, s_service, p_num_results, 1);
1747: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, s_frequency_type_code, p_num_results, 1);
1748: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, s_active_flag, p_num_results, 1);

Line 1745: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, s_service_code, p_num_results, 1);

1741: dbms_sql.DEFINE_ARRAY(l_cursor_id, 24, s_vessel_name, p_num_results, 1);
1742: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, s_voyage_number, p_num_results, 1);
1743: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, s_arr_time_w_ind, p_num_results, 1);
1744: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, s_mode_code, p_num_results, 1);
1745: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, s_service_code, p_num_results, 1);
1746: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, s_service, p_num_results, 1);
1747: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, s_frequency_type_code, p_num_results, 1);
1748: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, s_active_flag, p_num_results, 1);
1749:

Line 1746: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, s_service, p_num_results, 1);

1742: dbms_sql.DEFINE_ARRAY(l_cursor_id, 25, s_voyage_number, p_num_results, 1);
1743: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, s_arr_time_w_ind, p_num_results, 1);
1744: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, s_mode_code, p_num_results, 1);
1745: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, s_service_code, p_num_results, 1);
1746: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, s_service, p_num_results, 1);
1747: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, s_frequency_type_code, p_num_results, 1);
1748: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, s_active_flag, p_num_results, 1);
1749:
1750: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);

Line 1747: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, s_frequency_type_code, p_num_results, 1);

1743: dbms_sql.DEFINE_ARRAY(l_cursor_id, 26, s_arr_time_w_ind, p_num_results, 1);
1744: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, s_mode_code, p_num_results, 1);
1745: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, s_service_code, p_num_results, 1);
1746: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, s_service, p_num_results, 1);
1747: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, s_frequency_type_code, p_num_results, 1);
1748: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, s_active_flag, p_num_results, 1);
1749:
1750: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);
1751:

Line 1748: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, s_active_flag, p_num_results, 1);

1744: dbms_sql.DEFINE_ARRAY(l_cursor_id, 27, s_mode_code, p_num_results, 1);
1745: dbms_sql.DEFINE_ARRAY(l_cursor_id, 28, s_service_code, p_num_results, 1);
1746: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, s_service, p_num_results, 1);
1747: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, s_frequency_type_code, p_num_results, 1);
1748: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, s_active_flag, p_num_results, 1);
1749:
1750: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);
1751:
1752: LOOP

Line 1750: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);

1746: dbms_sql.DEFINE_ARRAY(l_cursor_id, 29, s_service, p_num_results, 1);
1747: dbms_sql.DEFINE_ARRAY(l_cursor_id, 30, s_frequency_type_code, p_num_results, 1);
1748: dbms_sql.DEFINE_ARRAY(l_cursor_id, 31, s_active_flag, p_num_results, 1);
1749:
1750: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);
1751:
1752: LOOP
1753: l_rows_fetched := dbms_sql.FETCH_ROWS(l_cursor_id);
1754: IF (l_rows_fetched = 0) THEN

Line 1753: l_rows_fetched := dbms_sql.FETCH_ROWS(l_cursor_id);

1749:
1750: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);
1751:
1752: LOOP
1753: l_rows_fetched := dbms_sql.FETCH_ROWS(l_cursor_id);
1754: IF (l_rows_fetched = 0) THEN
1755: EXIT;
1756: END IF;
1757:

Line 1758: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, s_schedule_id);

1754: IF (l_rows_fetched = 0) THEN
1755: EXIT;
1756: END IF;
1757:
1758: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, s_schedule_id);
1759: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, s_lane_id);
1760: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, s_lane_number);
1761: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, s_dep_date);
1762: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, s_arr_date);

Line 1759: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, s_lane_id);

1755: EXIT;
1756: END IF;
1757:
1758: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, s_schedule_id);
1759: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, s_lane_id);
1760: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, s_lane_number);
1761: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, s_dep_date);
1762: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, s_arr_date);
1763: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, s_transit_time);

Line 1760: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, s_lane_number);

1756: END IF;
1757:
1758: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, s_schedule_id);
1759: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, s_lane_id);
1760: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, s_lane_number);
1761: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, s_dep_date);
1762: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, s_arr_date);
1763: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, s_transit_time);
1764: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, s_frequency);

Line 1761: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, s_dep_date);

1757:
1758: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, s_schedule_id);
1759: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, s_lane_id);
1760: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, s_lane_number);
1761: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, s_dep_date);
1762: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, s_arr_date);
1763: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, s_transit_time);
1764: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, s_frequency);
1765: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, s_effective_date);

Line 1762: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, s_arr_date);

1758: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, s_schedule_id);
1759: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, s_lane_id);
1760: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, s_lane_number);
1761: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, s_dep_date);
1762: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, s_arr_date);
1763: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, s_transit_time);
1764: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, s_frequency);
1765: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, s_effective_date);
1766: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, s_port_of_loading);

Line 1763: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, s_transit_time);

1759: dbms_sql.COLUMN_VALUE(l_cursor_id, 2, s_lane_id);
1760: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, s_lane_number);
1761: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, s_dep_date);
1762: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, s_arr_date);
1763: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, s_transit_time);
1764: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, s_frequency);
1765: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, s_effective_date);
1766: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, s_port_of_loading);
1767: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, s_port_of_discharge);

Line 1764: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, s_frequency);

1760: dbms_sql.COLUMN_VALUE(l_cursor_id, 3, s_lane_number);
1761: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, s_dep_date);
1762: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, s_arr_date);
1763: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, s_transit_time);
1764: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, s_frequency);
1765: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, s_effective_date);
1766: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, s_port_of_loading);
1767: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, s_port_of_discharge);
1768: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, s_expiry_date);

Line 1765: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, s_effective_date);

1761: dbms_sql.COLUMN_VALUE(l_cursor_id, 4, s_dep_date);
1762: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, s_arr_date);
1763: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, s_transit_time);
1764: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, s_frequency);
1765: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, s_effective_date);
1766: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, s_port_of_loading);
1767: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, s_port_of_discharge);
1768: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, s_expiry_date);
1769: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, s_arr_date_indicator);

Line 1766: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, s_port_of_loading);

1762: dbms_sql.COLUMN_VALUE(l_cursor_id, 5, s_arr_date);
1763: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, s_transit_time);
1764: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, s_frequency);
1765: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, s_effective_date);
1766: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, s_port_of_loading);
1767: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, s_port_of_discharge);
1768: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, s_expiry_date);
1769: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, s_arr_date_indicator);
1770: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, s_frequency_arrival);

Line 1767: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, s_port_of_discharge);

1763: dbms_sql.COLUMN_VALUE(l_cursor_id, 6, s_transit_time);
1764: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, s_frequency);
1765: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, s_effective_date);
1766: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, s_port_of_loading);
1767: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, s_port_of_discharge);
1768: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, s_expiry_date);
1769: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, s_arr_date_indicator);
1770: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, s_frequency_arrival);
1771: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, s_origin_id);

Line 1768: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, s_expiry_date);

1764: dbms_sql.COLUMN_VALUE(l_cursor_id, 7, s_frequency);
1765: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, s_effective_date);
1766: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, s_port_of_loading);
1767: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, s_port_of_discharge);
1768: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, s_expiry_date);
1769: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, s_arr_date_indicator);
1770: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, s_frequency_arrival);
1771: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, s_origin_id);
1772: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, s_destination_id);

Line 1769: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, s_arr_date_indicator);

1765: dbms_sql.COLUMN_VALUE(l_cursor_id, 8, s_effective_date);
1766: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, s_port_of_loading);
1767: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, s_port_of_discharge);
1768: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, s_expiry_date);
1769: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, s_arr_date_indicator);
1770: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, s_frequency_arrival);
1771: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, s_origin_id);
1772: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, s_destination_id);
1773: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, s_mode);

Line 1770: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, s_frequency_arrival);

1766: dbms_sql.COLUMN_VALUE(l_cursor_id, 9, s_port_of_loading);
1767: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, s_port_of_discharge);
1768: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, s_expiry_date);
1769: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, s_arr_date_indicator);
1770: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, s_frequency_arrival);
1771: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, s_origin_id);
1772: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, s_destination_id);
1773: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, s_mode);
1774: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, s_carrier_id);

Line 1771: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, s_origin_id);

1767: dbms_sql.COLUMN_VALUE(l_cursor_id, 10, s_port_of_discharge);
1768: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, s_expiry_date);
1769: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, s_arr_date_indicator);
1770: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, s_frequency_arrival);
1771: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, s_origin_id);
1772: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, s_destination_id);
1773: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, s_mode);
1774: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, s_carrier_id);
1775: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, s_carrier_name);

Line 1772: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, s_destination_id);

1768: dbms_sql.COLUMN_VALUE(l_cursor_id, 11, s_expiry_date);
1769: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, s_arr_date_indicator);
1770: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, s_frequency_arrival);
1771: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, s_origin_id);
1772: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, s_destination_id);
1773: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, s_mode);
1774: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, s_carrier_id);
1775: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, s_carrier_name);
1776: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, s_dep_time);

Line 1773: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, s_mode);

1769: dbms_sql.COLUMN_VALUE(l_cursor_id, 12, s_arr_date_indicator);
1770: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, s_frequency_arrival);
1771: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, s_origin_id);
1772: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, s_destination_id);
1773: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, s_mode);
1774: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, s_carrier_id);
1775: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, s_carrier_name);
1776: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, s_dep_time);
1777: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, s_arr_time);

Line 1774: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, s_carrier_id);

1770: dbms_sql.COLUMN_VALUE(l_cursor_id, 13, s_frequency_arrival);
1771: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, s_origin_id);
1772: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, s_destination_id);
1773: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, s_mode);
1774: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, s_carrier_id);
1775: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, s_carrier_name);
1776: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, s_dep_time);
1777: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, s_arr_time);
1778: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, s_frequency_type);

Line 1775: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, s_carrier_name);

1771: dbms_sql.COLUMN_VALUE(l_cursor_id, 14, s_origin_id);
1772: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, s_destination_id);
1773: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, s_mode);
1774: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, s_carrier_id);
1775: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, s_carrier_name);
1776: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, s_dep_time);
1777: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, s_arr_time);
1778: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, s_frequency_type);
1779: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, s_transit_time_uom);

Line 1776: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, s_dep_time);

1772: dbms_sql.COLUMN_VALUE(l_cursor_id, 15, s_destination_id);
1773: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, s_mode);
1774: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, s_carrier_id);
1775: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, s_carrier_name);
1776: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, s_dep_time);
1777: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, s_arr_time);
1778: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, s_frequency_type);
1779: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, s_transit_time_uom);
1780: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, s_vessel_type);

Line 1777: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, s_arr_time);

1773: dbms_sql.COLUMN_VALUE(l_cursor_id, 16, s_mode);
1774: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, s_carrier_id);
1775: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, s_carrier_name);
1776: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, s_dep_time);
1777: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, s_arr_time);
1778: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, s_frequency_type);
1779: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, s_transit_time_uom);
1780: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, s_vessel_type);
1781: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, s_vessel_name);

Line 1778: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, s_frequency_type);

1774: dbms_sql.COLUMN_VALUE(l_cursor_id, 17, s_carrier_id);
1775: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, s_carrier_name);
1776: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, s_dep_time);
1777: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, s_arr_time);
1778: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, s_frequency_type);
1779: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, s_transit_time_uom);
1780: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, s_vessel_type);
1781: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, s_vessel_name);
1782: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, s_voyage_number);

Line 1779: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, s_transit_time_uom);

1775: dbms_sql.COLUMN_VALUE(l_cursor_id, 18, s_carrier_name);
1776: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, s_dep_time);
1777: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, s_arr_time);
1778: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, s_frequency_type);
1779: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, s_transit_time_uom);
1780: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, s_vessel_type);
1781: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, s_vessel_name);
1782: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, s_voyage_number);
1783: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, s_arr_time_w_ind);

Line 1780: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, s_vessel_type);

1776: dbms_sql.COLUMN_VALUE(l_cursor_id, 19, s_dep_time);
1777: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, s_arr_time);
1778: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, s_frequency_type);
1779: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, s_transit_time_uom);
1780: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, s_vessel_type);
1781: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, s_vessel_name);
1782: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, s_voyage_number);
1783: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, s_arr_time_w_ind);
1784: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, s_mode_code);

Line 1781: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, s_vessel_name);

1777: dbms_sql.COLUMN_VALUE(l_cursor_id, 20, s_arr_time);
1778: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, s_frequency_type);
1779: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, s_transit_time_uom);
1780: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, s_vessel_type);
1781: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, s_vessel_name);
1782: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, s_voyage_number);
1783: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, s_arr_time_w_ind);
1784: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, s_mode_code);
1785: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, s_service_code);

Line 1782: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, s_voyage_number);

1778: dbms_sql.COLUMN_VALUE(l_cursor_id, 21, s_frequency_type);
1779: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, s_transit_time_uom);
1780: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, s_vessel_type);
1781: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, s_vessel_name);
1782: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, s_voyage_number);
1783: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, s_arr_time_w_ind);
1784: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, s_mode_code);
1785: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, s_service_code);
1786: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, s_service);

Line 1783: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, s_arr_time_w_ind);

1779: dbms_sql.COLUMN_VALUE(l_cursor_id, 22, s_transit_time_uom);
1780: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, s_vessel_type);
1781: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, s_vessel_name);
1782: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, s_voyage_number);
1783: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, s_arr_time_w_ind);
1784: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, s_mode_code);
1785: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, s_service_code);
1786: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, s_service);
1787: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, s_frequency_type_code);

Line 1784: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, s_mode_code);

1780: dbms_sql.COLUMN_VALUE(l_cursor_id, 23, s_vessel_type);
1781: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, s_vessel_name);
1782: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, s_voyage_number);
1783: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, s_arr_time_w_ind);
1784: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, s_mode_code);
1785: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, s_service_code);
1786: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, s_service);
1787: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, s_frequency_type_code);
1788: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, s_active_flag);

Line 1785: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, s_service_code);

1781: dbms_sql.COLUMN_VALUE(l_cursor_id, 24, s_vessel_name);
1782: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, s_voyage_number);
1783: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, s_arr_time_w_ind);
1784: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, s_mode_code);
1785: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, s_service_code);
1786: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, s_service);
1787: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, s_frequency_type_code);
1788: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, s_active_flag);
1789:

Line 1786: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, s_service);

1782: dbms_sql.COLUMN_VALUE(l_cursor_id, 25, s_voyage_number);
1783: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, s_arr_time_w_ind);
1784: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, s_mode_code);
1785: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, s_service_code);
1786: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, s_service);
1787: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, s_frequency_type_code);
1788: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, s_active_flag);
1789:
1790: FOR n IN 1..l_rows_fetched LOOP

Line 1787: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, s_frequency_type_code);

1783: dbms_sql.COLUMN_VALUE(l_cursor_id, 26, s_arr_time_w_ind);
1784: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, s_mode_code);
1785: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, s_service_code);
1786: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, s_service);
1787: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, s_frequency_type_code);
1788: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, s_active_flag);
1789:
1790: FOR n IN 1..l_rows_fetched LOOP
1791: l_schedules_rec := fte_schedule_rec(s_schedule_id(n + l_offset),

Line 1788: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, s_active_flag);

1784: dbms_sql.COLUMN_VALUE(l_cursor_id, 27, s_mode_code);
1785: dbms_sql.COLUMN_VALUE(l_cursor_id, 28, s_service_code);
1786: dbms_sql.COLUMN_VALUE(l_cursor_id, 29, s_service);
1787: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, s_frequency_type_code);
1788: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, s_active_flag);
1789:
1790: FOR n IN 1..l_rows_fetched LOOP
1791: l_schedules_rec := fte_schedule_rec(s_schedule_id(n + l_offset),
1792: s_lane_id(n + l_offset),

Line 1838: dbms_sql.CLOSE_CURSOR(l_cursor_id);

1834: END IF;
1835:
1836: END LOOP;
1837:
1838: dbms_sql.CLOSE_CURSOR(l_cursor_id);
1839:
1840: END IF; -- end if p_search_type = 'L'
1841:
1842: --

Line 2046: v_rate_chart_id dbms_sql.VARCHAR2_TABLE;

2042: l_rows_fetched NUMBER := 0;
2043: l_num_rows NUMBER := 0;
2044: l_rate_chart_tab STRINGARRAY;
2045:
2046: v_rate_chart_id dbms_sql.VARCHAR2_TABLE;
2047:
2048: --
2049: l_debug_on BOOLEAN;
2050: --

Line 2125: l_cursor_id := dbms_sql.OPEN_CURSOR;

2121: WSH_DEBUG_SV.logmsg(l_module_name,'rate chart query:' || l_query,WSH_DEBUG_SV.C_PROC_LEVEL);
2122: END IF;
2123:
2124:
2125: l_cursor_id := dbms_sql.OPEN_CURSOR;
2126: dbms_sql.PARSE(l_cursor_id, l_query, DBMS_SQL.V7);
2127:
2128: Bind_Vars(l_cursor_id, l_bindvars);
2129:

Line 2126: dbms_sql.PARSE(l_cursor_id, l_query, DBMS_SQL.V7);

2122: END IF;
2123:
2124:
2125: l_cursor_id := dbms_sql.OPEN_CURSOR;
2126: dbms_sql.PARSE(l_cursor_id, l_query, DBMS_SQL.V7);
2127:
2128: Bind_Vars(l_cursor_id, l_bindvars);
2129:
2130: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_rate_chart_id, p_num_results, 1);

Line 2130: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_rate_chart_id, p_num_results, 1);

2126: dbms_sql.PARSE(l_cursor_id, l_query, DBMS_SQL.V7);
2127:
2128: Bind_Vars(l_cursor_id, l_bindvars);
2129:
2130: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_rate_chart_id, p_num_results, 1);
2131:
2132: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);
2133: LOOP
2134: l_rows_fetched := dbms_sql.FETCH_ROWS(l_cursor_id);

Line 2132: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);

2128: Bind_Vars(l_cursor_id, l_bindvars);
2129:
2130: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_rate_chart_id, p_num_results, 1);
2131:
2132: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);
2133: LOOP
2134: l_rows_fetched := dbms_sql.FETCH_ROWS(l_cursor_id);
2135: IF (l_rows_fetched = 0) THEN
2136: EXIT;

Line 2134: l_rows_fetched := dbms_sql.FETCH_ROWS(l_cursor_id);

2130: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_rate_chart_id, p_num_results, 1);
2131:
2132: l_rows_affected := dbms_sql.EXECUTE(l_cursor_id);
2133: LOOP
2134: l_rows_fetched := dbms_sql.FETCH_ROWS(l_cursor_id);
2135: IF (l_rows_fetched = 0) THEN
2136: EXIT;
2137: END IF;
2138: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_rate_chart_id);

Line 2138: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_rate_chart_id);

2134: l_rows_fetched := dbms_sql.FETCH_ROWS(l_cursor_id);
2135: IF (l_rows_fetched = 0) THEN
2136: EXIT;
2137: END IF;
2138: dbms_sql.COLUMN_VALUE(l_cursor_id, 1, v_rate_chart_id);
2139:
2140: FOR n IN 1..l_rows_fetched LOOP
2141: l_rate_chart_tab.EXTEND;
2142: l_rate_chart_tab(l_num_rows + 1) := v_rate_chart_id(n);

Line 2152: dbms_sql.CLOSE_CURSOR(l_cursor_id);

2148: EXIT;
2149: END IF;
2150:
2151: END LOOP;
2152: dbms_sql.CLOSE_CURSOR(l_cursor_id);
2153: x_rate_chart_ids := l_rate_chart_tab;
2154:
2155: --
2156: -- Debug Statements