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 906: FROM wsh_picking_batches

902: l_batch_creation_date DATE := NULL;
903:
904: CURSOR get_sc_batch IS
905: SELECT ship_confirm_rule_id, creation_date, actual_departure_date
906: FROM wsh_picking_batches
907: WHERE batch_id = p_sc_batch_id FOR UPDATE NOWAIT;
908:
909: -- 3667595
910: CURSOR get_pick_up_stops IS

Line 962: wsh_picking_batches wpb

958: SELECT wts.stop_id
959: FROM wsh_trip_stops wts,
960: wsh_delivery_legs wdl,
961: wsh_new_deliveries wnd,
962: wsh_picking_batches wpb
963: WHERE p_batch_id IS NOT NULL
964: AND wnd.batch_id = p_batch_id
965: AND wdl.delivery_id = wnd.delivery_id
966: AND wts.stop_id = wdl.pick_up_stop_id

Line 1976: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;

1972: l_return_status VARCHAR2(30) := NULL;
1973: l_rowid VARCHAR2(30);
1974: l_log_level NUMBER := 0;
1975: l_temp BOOLEAN;
1976: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;
1977: l_debug_on BOOLEAN;
1978: l_confirmed_del_tab WSH_UTIL_CORE.Id_Tab_Type;
1979: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
1980: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;

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

2078: x_return_status => l_return_status);
2079:
2080: -- should we also pack the input parameters into a record
2081: -- so I will pack them into record, and
2082: -- this is the record used to populate wsh_picking_batches
2083: -- otherwise i need to have a bunch of if stmt again to check the parameters
2084:
2085: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2086: raise WSH_SELECT_ERR;

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

2117: raise Adjust_Planned_Flag_Err;
2118: END IF;
2119: commit;
2120:
2121: -- insert new record in table WSH_PICKING_BATCHES, with NON_PICKING_FLAG = 'Y',
2122: -- SHIP_CONFIRM_RULE_ID =
2123:
2124: l_batch_rec.non_picking_flag := 'Y';
2125: l_batch_rec.ship_confirm_rule_id := p_ship_confirm_rule_id;

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

2143: END IF;
2144: --
2145: END IF;
2146:
2147: -- bug 5117876, direct insert into wsh_picking_batches table is replaced
2148: IF l_debug_on THEN
2149: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
2150: END IF;
2151:

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

2145: END IF;
2146:
2147: -- bug 5117876, direct insert into wsh_picking_batches table is replaced
2148: IF l_debug_on THEN
2149: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
2150: END IF;
2151:
2152: WSH_PICKING_BATCHES_PKG.Insert_Row(
2153: X_Rowid => l_rowid,

Line 2152: WSH_PICKING_BATCHES_PKG.Insert_Row(

2148: IF l_debug_on THEN
2149: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
2150: END IF;
2151:
2152: WSH_PICKING_BATCHES_PKG.Insert_Row(
2153: X_Rowid => l_rowid,
2154: X_Batch_Id => l_batch_rec.batch_id,
2155: P_Creation_Date => SYSDATE,
2156: P_Created_By => l_user_id,

Line 2457: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;

2453: l_log_level NUMBER := 0;
2454: l_return_status VARCHAR2(30) := NULL;
2455: l_rowid VARCHAR2(30);
2456: l_temp BOOLEAN;
2457: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;
2458: l_debug_on BOOLEAN;
2459: l_packed_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2460: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2461: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;

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

2540: END IF;
2541:
2542: IF l_selected_del_tab.count > 0 THEN
2543:
2544: -- insert new record in table WSH_PICKING_BATCHES, with NON_PICKING_FLAG = 'Y',
2545: -- SHIP_CONFIRM_RULE_ID =
2546:
2547: -- required fields for auto pack batch
2548: l_batch_rec.non_picking_flag := 'Y';

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

2555: WSH_DEBUG_SV.log(l_module_name, 'Auto Pack Flag', l_batch_rec.autopack_flag);
2556: WSH_DEBUG_SV.log(l_module_name, 'Auto Pack Level', l_batch_rec.autopack_level);
2557: END IF;
2558:
2559: -- bug 5117876, direct insert into wsh_picking_batches table is replaced
2560: IF l_debug_on THEN
2561: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
2562: END IF;
2563:

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

2557: END IF;
2558:
2559: -- bug 5117876, direct insert into wsh_picking_batches table is replaced
2560: IF l_debug_on THEN
2561: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
2562: END IF;
2563:
2564: WSH_PICKING_BATCHES_PKG.Insert_Row(
2565: X_Rowid => l_rowid,

Line 2564: WSH_PICKING_BATCHES_PKG.Insert_Row(

2560: IF l_debug_on THEN
2561: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
2562: END IF;
2563:
2564: WSH_PICKING_BATCHES_PKG.Insert_Row(
2565: X_Rowid => l_rowid,
2566: X_Batch_Id => l_batch_rec.batch_id,
2567: P_Creation_Date => SYSDATE,
2568: P_Created_By => l_user_id,