APPS.WSH_PICKING_BATCHES_PKG dependencies on WSH_PICKING_BATCHES

Line 1: PACKAGE BODY WSH_PICKING_BATCHES_PKG as

1: PACKAGE BODY WSH_PICKING_BATCHES_PKG as
2: /* $Header: WSHPRBTB.pls 120.3 2007/12/21 14:21:35 mvudugul ship $ */
3:
4:
5: --

Line 6: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PICKING_BATCHES_PKG';

2: /* $Header: WSHPRBTB.pls 120.3 2007/12/21 14:21:35 mvudugul ship $ */
3:
4:
5: --
6: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PICKING_BATCHES_PKG';
7: --
8: -- Bug 3266659: Added P_Ship_Set_Smc_Flag for the pick release public API
9:
10: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,

Line 105: CURSOR C IS SELECT rowid FROM WSH_PICKING_BATCHES

101: p_Planned_Flag VARCHAR2 DEFAULT NULL,
102: p_Selected_Batch_Id NUMBER DEFAULT NULL
103: ) IS
104: --
105: CURSOR C IS SELECT rowid FROM WSH_PICKING_BATCHES
106: WHERE batch_id = X_Batch_Id;
107:
108: -- bug 5117876, use sequence mtl_txn_request_headers_s
109: -- CURSOR NEXTID IS SELECT wsh_picking_batches_s.nextval FROM sys.dual;

Line 109: -- CURSOR NEXTID IS SELECT wsh_picking_batches_s.nextval FROM sys.dual;

105: CURSOR C IS SELECT rowid FROM WSH_PICKING_BATCHES
106: WHERE batch_id = X_Batch_Id;
107:
108: -- bug 5117876, use sequence mtl_txn_request_headers_s
109: -- CURSOR NEXTID IS SELECT wsh_picking_batches_s.nextval FROM sys.dual;
110: CURSOR NEXTID IS SELECT mtl_txn_request_headers_s.nextval FROM sys.dual;
111:
112: -- bug 5117876, add one more parameter batchid
113: /*

Line 115: Select batch_id From WSH_PICKING_BATCHES

111:
112: -- bug 5117876, add one more parameter batchid
113: /*
114: CURSOR Batch (batch_name VARCHAR2) IS
115: Select batch_id From WSH_PICKING_BATCHES
116: Where NAME = batch_name;
117: */
118: CURSOR Batch (batch_name VARCHAR2, batchid NUMBER) IS
119: Select batch_id From WSH_PICKING_BATCHES

Line 119: Select batch_id From WSH_PICKING_BATCHES

115: Select batch_id From WSH_PICKING_BATCHES
116: Where NAME = batch_name;
117: */
118: CURSOR Batch (batch_name VARCHAR2, batchid NUMBER) IS
119: Select batch_id From WSH_PICKING_BATCHES
120: Where NAME = batch_name OR batch_id = batchid;
121:
122: --
123: CURSOR Move_Order (batch_name VARCHAR2) IS

Line 322: WSH_DEBUG_SV.log(l_module_name,'Inserting into WSH_PICKING_BATCHES');

318: END IF;
319: --End Bugfix#1724744.
320:
321: IF l_debug_on THEN
322: WSH_DEBUG_SV.log(l_module_name,'Inserting into WSH_PICKING_BATCHES');
323: END IF;
324:
325: INSERT INTO WSH_PICKING_BATCHES(
326: batch_id,

Line 325: INSERT INTO WSH_PICKING_BATCHES(

321: IF l_debug_on THEN
322: WSH_DEBUG_SV.log(l_module_name,'Inserting into WSH_PICKING_BATCHES');
323: END IF;
324:
325: INSERT INTO WSH_PICKING_BATCHES(
326: batch_id,
327: creation_date,
328: created_by,
329: last_update_date,

Line 622: FROM WSH_PICKING_BATCHES

618: ) IS
619: --
620: CURSOR C IS
621: SELECT *
622: FROM WSH_PICKING_BATCHES
623: WHERE rowid = X_Rowid
624: FOR UPDATE of Batch_Id NOWAIT;
625: --
626: Recinfo C%ROWTYPE;

Line 1106: UPDATE WSH_PICKING_BATCHES

1102: --
1103: userid := FND_GLOBAL.USER_ID;
1104: loginid := FND_GLOBAL.LOGIN_ID;
1105: --
1106: UPDATE WSH_PICKING_BATCHES
1107: SET
1108: batch_id = P_Batch_Id,
1109: last_update_date = SYSDATE,
1110: last_updated_by = userid,

Line 1212: DELETE FROM WSH_PICKING_BATCHES

1208: WSH_DEBUG_SV.push(l_module_name);
1209: WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);
1210: END IF;
1211: --
1212: DELETE FROM WSH_PICKING_BATCHES
1213: WHERE rowid = X_Rowid;
1214: --
1215: if (SQL%NOTFOUND) then
1216: IF l_debug_on THEN

Line 1420: END WSH_PICKING_BATCHES_PKG;

1416: END IF;
1417: --
1418: END get_printer;
1419:
1420: END WSH_PICKING_BATCHES_PKG;