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.WSH_BATCH_PROCESS dependencies on WSH_PICKING_BATCHES

Line 19: -- p_batch_rec : this record returns the fields for creating batch record in wsh_picking_batches table

15: -- and Auto_Pack_Deliveries_SRS to select deliveries according
16: -- to users entered quiteria.
17: -- Input Parameters:
18: -- p_input_info : this record contains all the input parameters
19: -- p_batch_rec : this record returns the fields for creating batch record in wsh_picking_batches table
20: -- Output Parameters:
21: -- x_selected_del_tab: returns a list of delivery ids which are selected according to the criteria
22: -- x_return_status - Success, Warning, Error, Unexpected Error
23: -- ----------------------------------------------------------------------

Line 27: p_batch_rec IN OUT NOCOPY WSH_PICKING_BATCHES%ROWTYPE,

23: -- ----------------------------------------------------------------------
24:
25: PROCEDURE Select_Deliveries (
26: p_input_info IN WSH_BATCH_PROCESS.Select_Criteria_Rec,
27: p_batch_rec IN OUT NOCOPY WSH_PICKING_BATCHES%ROWTYPE,
28: x_selected_del_tab OUT NOCOPY WSH_BATCH_PROCESS.Del_Info_Tab,
29: x_return_status OUT NOCOPY VARCHAR2)
30: IS
31:

Line 882: FROM wsh_picking_batches

878: l_batch_creation_date DATE := NULL;
879:
880: CURSOR get_sc_batch IS
881: SELECT ship_confirm_rule_id, creation_date, actual_departure_date
882: FROM wsh_picking_batches
883: WHERE batch_id = p_sc_batch_id FOR UPDATE NOWAIT;
884:
885: -- 3667595
886: CURSOR get_pick_up_stops IS

Line 938: wsh_picking_batches wpb

934: SELECT wts.stop_id
935: FROM wsh_trip_stops wts,
936: wsh_delivery_legs wdl,
937: wsh_new_deliveries wnd,
938: wsh_picking_batches wpb
939: WHERE p_batch_id IS NOT NULL
940: AND wnd.batch_id = p_batch_id
941: AND wdl.delivery_id = wnd.delivery_id
942: AND wts.stop_id = wdl.pick_up_stop_id

Line 1949: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;

1945: l_return_status VARCHAR2(30) := NULL;
1946: l_rowid VARCHAR2(30);
1947: l_log_level NUMBER := 0;
1948: l_temp BOOLEAN;
1949: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;
1950: l_debug_on BOOLEAN;
1951: l_confirmed_del_tab WSH_UTIL_CORE.Id_Tab_Type;
1952: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
1953: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;

Line 2054: -- this is the record used to populate wsh_picking_batches

2050: x_return_status => l_return_status);
2051:
2052: -- should we also pack the input parameters into a record
2053: -- so I will pack them into record, and
2054: -- this is the record used to populate wsh_picking_batches
2055: -- otherwise i need to have a bunch of if stmt again to check the parameters
2056:
2057: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2058: raise WSH_SELECT_ERR;

Line 2093: -- insert new record in table WSH_PICKING_BATCHES, with NON_PICKING_FLAG = 'Y',

2089: raise Adjust_Planned_Flag_Err;
2090: END IF;
2091: commit;
2092:
2093: -- insert new record in table WSH_PICKING_BATCHES, with NON_PICKING_FLAG = 'Y',
2094: -- SHIP_CONFIRM_RULE_ID =
2095:
2096: l_batch_rec.non_picking_flag := 'Y';
2097: l_batch_rec.ship_confirm_rule_id := p_ship_confirm_rule_id;

Line 2119: -- bug 5117876, direct insert into wsh_picking_batches table is replaced

2115: END IF;
2116: --
2117: END IF;
2118:
2119: -- bug 5117876, direct insert into wsh_picking_batches table is replaced
2120: IF l_debug_on THEN
2121: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
2122: END IF;
2123:

Line 2121: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);

2117: END IF;
2118:
2119: -- bug 5117876, direct insert into wsh_picking_batches table is replaced
2120: IF l_debug_on THEN
2121: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
2122: END IF;
2123:
2124: WSH_PICKING_BATCHES_PKG.Insert_Row(
2125: X_Rowid => l_rowid,

Line 2124: WSH_PICKING_BATCHES_PKG.Insert_Row(

2120: IF l_debug_on THEN
2121: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
2122: END IF;
2123:
2124: WSH_PICKING_BATCHES_PKG.Insert_Row(
2125: X_Rowid => l_rowid,
2126: X_Batch_Id => l_batch_rec.batch_id,
2127: P_Creation_Date => SYSDATE,
2128: P_Created_By => l_user_id,

Line 2427: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;

2423: l_log_level NUMBER := 0;
2424: l_return_status VARCHAR2(30) := NULL;
2425: l_rowid VARCHAR2(30);
2426: l_temp BOOLEAN;
2427: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;
2428: l_debug_on BOOLEAN;
2429: l_packed_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2430: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2431: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;

Line 2514: -- insert new record in table WSH_PICKING_BATCHES, with NON_PICKING_FLAG = 'Y',

2510: END IF;
2511:
2512: IF l_selected_del_tab.count > 0 THEN
2513:
2514: -- insert new record in table WSH_PICKING_BATCHES, with NON_PICKING_FLAG = 'Y',
2515: -- SHIP_CONFIRM_RULE_ID =
2516:
2517: -- required fields for auto pack batch
2518: l_batch_rec.non_picking_flag := 'Y';

Line 2529: -- bug 5117876, direct insert into wsh_picking_batches table is replaced

2525: WSH_DEBUG_SV.log(l_module_name, 'Auto Pack Flag', l_batch_rec.autopack_flag);
2526: WSH_DEBUG_SV.log(l_module_name, 'Auto Pack Level', l_batch_rec.autopack_level);
2527: END IF;
2528:
2529: -- bug 5117876, direct insert into wsh_picking_batches table is replaced
2530: IF l_debug_on THEN
2531: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
2532: END IF;
2533:

Line 2531: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);

2527: END IF;
2528:
2529: -- bug 5117876, direct insert into wsh_picking_batches table is replaced
2530: IF l_debug_on THEN
2531: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
2532: END IF;
2533:
2534: WSH_PICKING_BATCHES_PKG.Insert_Row(
2535: X_Rowid => l_rowid,

Line 2534: WSH_PICKING_BATCHES_PKG.Insert_Row(

2530: IF l_debug_on THEN
2531: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
2532: END IF;
2533:
2534: WSH_PICKING_BATCHES_PKG.Insert_Row(
2535: X_Rowid => l_rowid,
2536: X_Batch_Id => l_batch_rec.batch_id,
2537: P_Creation_Date => SYSDATE,
2538: P_Created_By => l_user_id,