APPS.SHP_PICKING_BATCHES_PKG dependencies on SO_PICKING_BATCHES

Line 62: CURSOR C IS SELECT rowid FROM SO_PICKING_BATCHES_ALL

58: X_Attribute15 VARCHAR2,
59: X_Error_Report_Flag VARCHAR2,
60: X_Org_Id NUMBER
61: ) IS
62: CURSOR C IS SELECT rowid FROM SO_PICKING_BATCHES_ALL
63: WHERE batch_id = X_Batch_Id;
64: CURSOR NEXTID IS SELECT so_picking_batches_s.nextval FROM sys.dual;
65: CURSOR Batch (batch_name VARCHAR2) IS
66: Select count(*) From SO_PICKING_BATCHES_ALL

Line 64: CURSOR NEXTID IS SELECT so_picking_batches_s.nextval FROM sys.dual;

60: X_Org_Id NUMBER
61: ) IS
62: CURSOR C IS SELECT rowid FROM SO_PICKING_BATCHES_ALL
63: WHERE batch_id = X_Batch_Id;
64: CURSOR NEXTID IS SELECT so_picking_batches_s.nextval FROM sys.dual;
65: CURSOR Batch (batch_name VARCHAR2) IS
66: Select count(*) From SO_PICKING_BATCHES_ALL
67: Where NAME = batch_name;
68: userid NUMBER;

Line 66: Select count(*) From SO_PICKING_BATCHES_ALL

62: CURSOR C IS SELECT rowid FROM SO_PICKING_BATCHES_ALL
63: WHERE batch_id = X_Batch_Id;
64: CURSOR NEXTID IS SELECT so_picking_batches_s.nextval FROM sys.dual;
65: CURSOR Batch (batch_name VARCHAR2) IS
66: Select count(*) From SO_PICKING_BATCHES_ALL
67: Where NAME = batch_name;
68: userid NUMBER;
69: loginid NUMBER;
70: temp NUMBER;

Line 103: INSERT INTO SO_PICKING_BATCHES_ALL(

99:
100: CLOSE NEXTID;
101: End If;
102:
103: INSERT INTO SO_PICKING_BATCHES_ALL(
104: batch_id,
105: creation_date,
106: created_by,
107: last_update_date,

Line 285: FROM SO_PICKING_BATCHES_ALL

281: X_Org_Id NUMBER
282: ) IS
283: CURSOR C IS
284: SELECT *
285: FROM SO_PICKING_BATCHES_ALL
286: WHERE rowid = X_Rowid
287: FOR UPDATE of Batch_Id NOWAIT;
288: Recinfo C%ROWTYPE;
289:

Line 512: UPDATE SO_PICKING_BATCHES

508: BEGIN
509:
510: userid := FND_GLOBAL.USER_ID;
511: loginid := FND_GLOBAL.LOGIN_ID;
512: UPDATE SO_PICKING_BATCHES
513: SET
514: batch_id = X_Batch_Id,
515: last_update_date = SYSDATE,
516: last_updated_by = userid,

Line 569: DELETE FROM SO_PICKING_BATCHES

565: END Update_Row;
566:
567: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
568: BEGIN
569: DELETE FROM SO_PICKING_BATCHES
570: WHERE rowid = X_Rowid;
571:
572: if (SQL%NOTFOUND) then
573: Raise NO_DATA_FOUND;