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

2405: ORDER BY 1,3,2;
2406:
2407: CURSOR get_sc_batch(c_batch_id IN NUMBER) IS
2408: SELECT ship_confirm_rule_id, creation_date
2409: FROM wsh_picking_batches
2410: WHERE batch_id = c_batch_id;
2411:
2412: --
2413: l_ship_confirm_rule_rec WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%ROWTYPE;

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

3790:
3791: CURSOR c_close_trip(l_pickrel_batch_id NUMBER) is
3792: SELECT DISTINCT wpr.batch_id, wpb.creation_date,
3793: wscr.ac_close_trip_flag, wscr.ac_intransit_flag
3794: FROM wsh_picking_batches wpb, wsh_ship_confirm_rules wscr, wsh_pr_workers wpr
3795: WHERE wpr.batch_id = l_pickrel_batch_id
3796: AND wpr.type = 'PS'
3797: AND wpb.batch_id = wpr.pa_sc_batch_id
3798: AND wpb.ship_confirm_rule_id = wscr.ship_confirm_rule_id

Line 3870: wsh_picking_batches wpb

3866: SELECT wts.stop_id
3867: FROM wsh_trip_stops wts,
3868: wsh_delivery_legs wdl,
3869: wsh_new_deliveries wnd,
3870: wsh_picking_batches wpb
3871: WHERE p_batch_id IS NOT NULL
3872: AND wnd.batch_id = l_batch_id
3873: AND wdl.delivery_id = wnd.delivery_id
3874: AND wts.stop_id = wdl.pick_up_stop_id

Line 4043: l_task_planning_flag WSH_PICKING_BATCHES.task_planning_flag%TYPE;

4039: l_message VARCHAR2(2000);
4040: l_rowid VARCHAR2(30);
4041: l_curr_count NUMBER;
4042: l_batch_name VARCHAR2(30);
4043: l_task_planning_flag WSH_PICKING_BATCHES.task_planning_flag%TYPE;
4044: l_init_rules VARCHAR2(1) := FND_API.G_FALSE;
4045: l_print_cursor_flag VARCHAR2(1);
4046: l_pr_worker_rec_count NUMBER := 0;
4047: l_counter NUMBER := 0;

Line 5792: WSH_PICKING_BATCHES_PKG.Insert_Row (

5788: -- create pack/ship batch for this group.
5789: l_del_batch_id := NULL;
5790: l_del_batch_name := NULL;
5791:
5792: WSH_PICKING_BATCHES_PKG.Insert_Row (
5793: X_Rowid => l_tmp_row_id,
5794: X_Batch_Id => l_del_batch_id,
5795: P_Creation_Date => NULL,
5796: P_Created_By => NULL,

Line 5932: UPDATE wsh_picking_batches

5928:
5929: IF l_group_nums = 1 THEN
5930: -- if for one group of details through STF, then update
5931: -- PR batch to be a packing/shipping batch as well.
5932: UPDATE wsh_picking_batches
5933: SET ship_confirm_rule_id = l_sc_rule_id,
5934: autopack_flag = DECODE(l_act_ap_level,0,'N','Y'),
5935: autopack_level = l_act_ap_level
5936: WHERE batch_id = p_batch_id;

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

6883: wsh_debug_sv.log(l_module_name, 'calc. requested end date', l_reqEndDate);
6884: END IF;
6885: --
6886: IF l_debug_on THEN
6887: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
6888: END IF;
6889:
6890: -- bug5117876, insert statement is replace with the following call
6891: WSH_PICKING_BATCHES_PKG.Insert_Row(

Line 6891: WSH_PICKING_BATCHES_PKG.Insert_Row(

6887: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
6888: END IF;
6889:
6890: -- bug5117876, insert statement is replace with the following call
6891: WSH_PICKING_BATCHES_PKG.Insert_Row(
6892: X_Rowid => l_rowid,
6893: X_Batch_Id => l_batch_id,
6894: P_Creation_Date => SYSDATE,
6895: P_Created_By => l_user_id,

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

7080: -- Pre-reqs : None.
7081: -- Procedure: API to launch pick Release process based on input entity passed. Api dose
7082: -- 1. Get the Entity name for the passed entity
7083: -- 2. Get the entity status.
7084: -- 3. Create picking batch by calling WSH_PICKING_BATCHES_PKG.Insert_Row.
7085: -- 4. Update the detail lines with batch id.
7086: -- 5. Submit request to release batch created by calling WSH_PICKING_BATCHES_PKG.Submit_Release_Request
7087: -- Parameters :
7088: -- IN:

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

7082: -- 1. Get the Entity name for the passed entity
7083: -- 2. Get the entity status.
7084: -- 3. Create picking batch by calling WSH_PICKING_BATCHES_PKG.Insert_Row.
7085: -- 4. Update the detail lines with batch id.
7086: -- 5. Submit request to release batch created by calling WSH_PICKING_BATCHES_PKG.Submit_Release_Request
7087: -- Parameters :
7088: -- IN:
7089: -- p_trip_ids IN Trip id.
7090: -- p_stop_ids IN Stop Id.

Line 7232: FROM wsh_picking_batches

7228: Order_Header_Id,
7229: Order_Type_Id,
7230: Existing_Rsvs_Only_Flag,
7231: client_id -- LSP PROJECT
7232: FROM wsh_picking_batches
7233: WHERE batch_id = x_batch_id;
7234:
7235: l_batch_rec c_batch_info%ROWTYPE;
7236:

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

7573: END IF;
7574: CLOSE c_batch_info;
7575: --
7576: IF l_debug_on THEN
7577: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
7578: END IF;
7579: --
7580: WSH_PICKING_BATCHES_PKG.Insert_Row(
7581: X_Rowid => l_rowid,

Line 7580: WSH_PICKING_BATCHES_PKG.Insert_Row(

7576: IF l_debug_on THEN
7577: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
7578: END IF;
7579: --
7580: WSH_PICKING_BATCHES_PKG.Insert_Row(
7581: X_Rowid => l_rowid,
7582: X_Batch_Id => l_batch_id,
7583: P_Creation_Date => NULL,
7584: P_Created_By => NULL,

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

7663: ELSE
7664: --
7665: --
7666: IF l_debug_on THEN
7667: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
7668: END IF;
7669: --
7670: WSH_PICKING_BATCHES_PKG.Insert_Row(
7671: X_Rowid => l_rowid,

Line 7670: WSH_PICKING_BATCHES_PKG.Insert_Row(

7666: IF l_debug_on THEN
7667: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
7668: END IF;
7669: --
7670: WSH_PICKING_BATCHES_PKG.Insert_Row(
7671: X_Rowid => l_rowid,
7672: X_Batch_Id => l_batch_id,
7673: P_Creation_Date => NULL,
7674: P_Created_By => NULL,

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

7836: END IF;
7837:
7838:
7839: IF l_debug_on THEN
7840: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.SUBMIT_RELEASE_REQUEST',WSH_DEBUG_SV.C_PROC_LEVEL);
7841: END IF;
7842: --Submit request to release batch created.
7843: x_request_ids(l_index) := WSH_PICKING_BATCHES_PKG.Submit_Release_Request(
7844: p_batch_id => l_batch_id,

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

7839: IF l_debug_on THEN
7840: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.SUBMIT_RELEASE_REQUEST',WSH_DEBUG_SV.C_PROC_LEVEL);
7841: END IF;
7842: --Submit request to release batch created.
7843: x_request_ids(l_index) := WSH_PICKING_BATCHES_PKG.Submit_Release_Request(
7844: p_batch_id => l_batch_id,
7845: p_log_level => l_log_level,
7846: p_num_workers => 1, -- Always 1
7847: p_commit => 'N');