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_PICK_LIST dependencies on WSH_PICKING_BATCHES

Line 63: g_allocation_method WSH_PICKING_BATCHES.ALLOCATION_METHOD%TYPE;

59: g_del_detail_ids WSH_PICK_LIST.DelDetTabTyp;
60: g_exp_pick_release_stat Inv_Express_Pick_Pub.P_Pick_Release_Status_Tbl;
61:
62: -- X-dock, declare package level global variables
63: g_allocation_method WSH_PICKING_BATCHES.ALLOCATION_METHOD%TYPE;
64: g_xdock_delivery_ids WSH_UTIL_CORE.Id_Tab_Type; -- used for X-dock only
65: g_xdock_detail_ids WSH_PICK_LIST.DelDetTabTyp; -- used for X-dock only
66:
67: /**************************

Line 2348: FROM wsh_picking_batches

2344: ORDER BY 1,3,2;
2345:
2346: CURSOR get_sc_batch(c_batch_id IN NUMBER) IS
2347: SELECT ship_confirm_rule_id, creation_date
2348: FROM wsh_picking_batches
2349: WHERE batch_id = c_batch_id;
2350:
2351: --
2352: l_ship_confirm_rule_rec WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%ROWTYPE;

Line 3706: FROM wsh_picking_batches wpb, wsh_ship_confirm_rules wscr, wsh_pr_workers wpr

3702:
3703: CURSOR c_close_trip(l_pickrel_batch_id NUMBER) is
3704: SELECT DISTINCT wpr.batch_id, wpb.creation_date,
3705: wscr.ac_close_trip_flag, wscr.ac_intransit_flag
3706: FROM wsh_picking_batches wpb, wsh_ship_confirm_rules wscr, wsh_pr_workers wpr
3707: WHERE wpr.batch_id = l_pickrel_batch_id
3708: AND wpr.type = 'PS'
3709: AND wpb.batch_id = wpr.pa_sc_batch_id
3710: AND wpb.ship_confirm_rule_id = wscr.ship_confirm_rule_id

Line 3782: wsh_picking_batches wpb

3778: SELECT wts.stop_id
3779: FROM wsh_trip_stops wts,
3780: wsh_delivery_legs wdl,
3781: wsh_new_deliveries wnd,
3782: wsh_picking_batches wpb
3783: WHERE p_batch_id IS NOT NULL
3784: AND wnd.batch_id = l_batch_id
3785: AND wdl.delivery_id = wnd.delivery_id
3786: AND wts.stop_id = wdl.pick_up_stop_id

Line 3953: l_task_planning_flag WSH_PICKING_BATCHES.task_planning_flag%TYPE;

3949: l_message VARCHAR2(2000);
3950: l_rowid VARCHAR2(30);
3951: l_curr_count NUMBER;
3952: l_batch_name VARCHAR2(30);
3953: l_task_planning_flag WSH_PICKING_BATCHES.task_planning_flag%TYPE;
3954: l_init_rules VARCHAR2(1) := FND_API.G_FALSE;
3955: l_print_cursor_flag VARCHAR2(1);
3956: l_pr_worker_rec_count NUMBER := 0;
3957: l_counter NUMBER := 0;

Line 5658: WSH_PICKING_BATCHES_PKG.Insert_Row (

5654: -- create pack/ship batch for this group.
5655: l_del_batch_id := NULL;
5656: l_del_batch_name := NULL;
5657:
5658: WSH_PICKING_BATCHES_PKG.Insert_Row (
5659: X_Rowid => l_tmp_row_id,
5660: X_Batch_Id => l_del_batch_id,
5661: P_Creation_Date => NULL,
5662: P_Created_By => NULL,

Line 5797: UPDATE wsh_picking_batches

5793:
5794: IF l_group_nums = 1 THEN
5795: -- if for one group of details through STF, then update
5796: -- PR batch to be a packing/shipping batch as well.
5797: UPDATE wsh_picking_batches
5798: SET ship_confirm_rule_id = l_sc_rule_id,
5799: autopack_flag = DECODE(l_act_ap_level,0,'N','Y'),
5800: autopack_level = l_act_ap_level
5801: WHERE batch_id = p_batch_id;

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

6743: wsh_debug_sv.log(l_module_name, 'calc. requested end date', l_reqEndDate);
6744: END IF;
6745: --
6746: IF l_debug_on THEN
6747: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
6748: END IF;
6749:
6750: -- bug5117876, insert statement is replace with the following call
6751: WSH_PICKING_BATCHES_PKG.Insert_Row(

Line 6751: WSH_PICKING_BATCHES_PKG.Insert_Row(

6747: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
6748: END IF;
6749:
6750: -- bug5117876, insert statement is replace with the following call
6751: WSH_PICKING_BATCHES_PKG.Insert_Row(
6752: X_Rowid => l_rowid,
6753: X_Batch_Id => l_batch_id,
6754: P_Creation_Date => SYSDATE,
6755: P_Created_By => l_user_id,

Line 6942: -- 3. Create picking batch by calling WSH_PICKING_BATCHES_PKG.Insert_Row.

6938: -- Pre-reqs : None.
6939: -- Procedure: API to launch pick Release process based on input entity passed. Api dose
6940: -- 1. Get the Entity name for the passed entity
6941: -- 2. Get the entity status.
6942: -- 3. Create picking batch by calling WSH_PICKING_BATCHES_PKG.Insert_Row.
6943: -- 4. Update the detail lines with batch id.
6944: -- 5. Submit request to release batch created by calling WSH_PICKING_BATCHES_PKG.Submit_Release_Request
6945: -- Parameters :
6946: -- IN:

Line 6944: -- 5. Submit request to release batch created by calling WSH_PICKING_BATCHES_PKG.Submit_Release_Request

6940: -- 1. Get the Entity name for the passed entity
6941: -- 2. Get the entity status.
6942: -- 3. Create picking batch by calling WSH_PICKING_BATCHES_PKG.Insert_Row.
6943: -- 4. Update the detail lines with batch id.
6944: -- 5. Submit request to release batch created by calling WSH_PICKING_BATCHES_PKG.Submit_Release_Request
6945: -- Parameters :
6946: -- IN:
6947: -- p_trip_ids IN Trip id.
6948: -- p_stop_ids IN Stop Id.

Line 7089: FROM wsh_picking_batches

7085: dynamic_replenishment_flag,
7086: Order_Header_Id,
7087: Order_Type_Id,
7088: Existing_Rsvs_Only_Flag
7089: FROM wsh_picking_batches
7090: WHERE batch_id = x_batch_id;
7091:
7092: l_batch_rec c_batch_info%ROWTYPE;
7093:

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

7430: END IF;
7431: CLOSE c_batch_info;
7432: --
7433: IF l_debug_on THEN
7434: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
7435: END IF;
7436: --
7437: WSH_PICKING_BATCHES_PKG.Insert_Row(
7438: X_Rowid => l_rowid,

Line 7437: WSH_PICKING_BATCHES_PKG.Insert_Row(

7433: IF l_debug_on THEN
7434: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
7435: END IF;
7436: --
7437: WSH_PICKING_BATCHES_PKG.Insert_Row(
7438: X_Rowid => l_rowid,
7439: X_Batch_Id => l_batch_id,
7440: P_Creation_Date => NULL,
7441: P_Created_By => NULL,

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

7518: ELSE
7519: --
7520: --
7521: IF l_debug_on THEN
7522: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
7523: END IF;
7524: --
7525: WSH_PICKING_BATCHES_PKG.Insert_Row(
7526: X_Rowid => l_rowid,

Line 7525: WSH_PICKING_BATCHES_PKG.Insert_Row(

7521: IF l_debug_on THEN
7522: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
7523: END IF;
7524: --
7525: WSH_PICKING_BATCHES_PKG.Insert_Row(
7526: X_Rowid => l_rowid,
7527: X_Batch_Id => l_batch_id,
7528: P_Creation_Date => NULL,
7529: P_Created_By => NULL,

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

7690: END IF;
7691:
7692:
7693: IF l_debug_on THEN
7694: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.SUBMIT_RELEASE_REQUEST',WSH_DEBUG_SV.C_PROC_LEVEL);
7695: END IF;
7696: --Submit request to release batch created.
7697: x_request_ids(l_index) := WSH_PICKING_BATCHES_PKG.Submit_Release_Request(
7698: p_batch_id => l_batch_id,

Line 7697: x_request_ids(l_index) := WSH_PICKING_BATCHES_PKG.Submit_Release_Request(

7693: IF l_debug_on THEN
7694: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.SUBMIT_RELEASE_REQUEST',WSH_DEBUG_SV.C_PROC_LEVEL);
7695: END IF;
7696: --Submit request to release batch created.
7697: x_request_ids(l_index) := WSH_PICKING_BATCHES_PKG.Submit_Release_Request(
7698: p_batch_id => l_batch_id,
7699: p_log_level => l_log_level,
7700: p_num_workers => 1, -- Always 1
7701: p_commit => 'N');