3:
4: /** Globals to hold Logging attributes **/
5: g_trace_on NUMBER := 0;
6:
7: g_loc_type_dock_door CONSTANT NUMBER := inv_globals.g_loc_type_dock_door;
8: g_loc_type_staging_lane CONSTANT NUMBER := inv_globals.g_loc_type_staging_lane;
9: g_loc_type_consolidation CONSTANT NUMBER := inv_globals.g_loc_type_consolidation;
10: g_loc_type_packing_station CONSTANT NUMBER := inv_globals.g_loc_type_packing_station;
11:
4: /** Globals to hold Logging attributes **/
5: g_trace_on NUMBER := 0;
6:
7: g_loc_type_dock_door CONSTANT NUMBER := inv_globals.g_loc_type_dock_door;
8: g_loc_type_staging_lane CONSTANT NUMBER := inv_globals.g_loc_type_staging_lane;
9: g_loc_type_consolidation CONSTANT NUMBER := inv_globals.g_loc_type_consolidation;
10: g_loc_type_packing_station CONSTANT NUMBER := inv_globals.g_loc_type_packing_station;
11:
12:
5: g_trace_on NUMBER := 0;
6:
7: g_loc_type_dock_door CONSTANT NUMBER := inv_globals.g_loc_type_dock_door;
8: g_loc_type_staging_lane CONSTANT NUMBER := inv_globals.g_loc_type_staging_lane;
9: g_loc_type_consolidation CONSTANT NUMBER := inv_globals.g_loc_type_consolidation;
10: g_loc_type_packing_station CONSTANT NUMBER := inv_globals.g_loc_type_packing_station;
11:
12:
13: PROCEDURE get_values_for_loc(p_sub IN VARCHAR2,
6:
7: g_loc_type_dock_door CONSTANT NUMBER := inv_globals.g_loc_type_dock_door;
8: g_loc_type_staging_lane CONSTANT NUMBER := inv_globals.g_loc_type_staging_lane;
9: g_loc_type_consolidation CONSTANT NUMBER := inv_globals.g_loc_type_consolidation;
10: g_loc_type_packing_station CONSTANT NUMBER := inv_globals.g_loc_type_packing_station;
11:
12:
13: PROCEDURE get_values_for_loc(p_sub IN VARCHAR2,
14: p_loc_id IN NUMBER,