[Home] [Help]
21:
22: CURSOR l_percent_cmpl_csr
23: IS
24: SELECT *
25: FROM pa_percent_completes
26: WHERE rowid = x_rowid
27: FOR UPDATE of project_id NOWAIT;
28:
29: Recinfo l_percent_cmpl_csr%ROWTYPE;
107: PROCEDURE Delete_Row (x_rowid IN VARCHAR2) IS
108:
109: BEGIN
110:
111: DELETE FROM pa_percent_completes
112: WHERE rowid = x_rowid;
113: IF (SQL%NOTFOUND) THEN
114: RAISE NO_DATA_FOUND;
115: END IF;