APPS.SHP_PICKING_BATCHES_PKG dependencies on SO_PICKING_BATCHES_ALL

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 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: