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.12010000.2 2009/12/03 13:36:16 anvarshn ship $ */
3:
4:
5: --

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

2: /* $Header: WSHPRBTB.pls 120.3.12010000.2 2009/12/03 13:36:16 anvarshn 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 106: CURSOR C IS SELECT rowid FROM WSH_PICKING_BATCHES

102: p_Selected_Batch_Id NUMBER DEFAULT NULL,
103: p_client_Id NUMBER DEFAULT NULL --Modified R12.1.1 LSP PROJECT
104: ) IS
105: --
106: CURSOR C IS SELECT rowid FROM WSH_PICKING_BATCHES
107: WHERE batch_id = X_Batch_Id;
108:
109: -- bug 5117876, use sequence mtl_txn_request_headers_s
110: -- CURSOR NEXTID IS SELECT wsh_picking_batches_s.nextval FROM sys.dual;

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

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

Line 116: Select batch_id From WSH_PICKING_BATCHES

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

Line 120: Select batch_id From WSH_PICKING_BATCHES

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

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

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

Line 327: INSERT INTO WSH_PICKING_BATCHES(

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

Line 627: FROM WSH_PICKING_BATCHES

623: ) IS
624: --
625: CURSOR C IS
626: SELECT *
627: FROM WSH_PICKING_BATCHES
628: WHERE rowid = X_Rowid
629: FOR UPDATE of Batch_Id NOWAIT;
630: --
631: Recinfo C%ROWTYPE;

Line 1117: UPDATE WSH_PICKING_BATCHES

1113: --
1114: userid := FND_GLOBAL.USER_ID;
1115: loginid := FND_GLOBAL.LOGIN_ID;
1116: --
1117: UPDATE WSH_PICKING_BATCHES
1118: SET
1119: batch_id = P_Batch_Id,
1120: last_update_date = SYSDATE,
1121: last_updated_by = userid,

Line 1224: DELETE FROM WSH_PICKING_BATCHES

1220: WSH_DEBUG_SV.push(l_module_name);
1221: WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);
1222: END IF;
1223: --
1224: DELETE FROM WSH_PICKING_BATCHES
1225: WHERE rowid = X_Rowid;
1226: --
1227: if (SQL%NOTFOUND) then
1228: IF l_debug_on THEN

Line 1432: END WSH_PICKING_BATCHES_PKG;

1428: END IF;
1429: --
1430: END get_printer;
1431:
1432: END WSH_PICKING_BATCHES_PKG;