12: -- this procedure. No refernece to sequence in this procedure.
13: -- 2. All paramaters are IN parameter.
14: -- * -------------------------------------------------------------------------*
15: PROCEDURE insert_row
16: ( p_imp_maps_rec IN CN_IMP_MAPS_PVT.IMP_MAPS_REC_TYPE) IS
17:
18: BEGIN
19:
20: INSERT into CN_IMP_MAPS
104: -- 3. All paramaters are IN parameter.
105: -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
106: -- * -------------------------------------------------------------------------*
107: PROCEDURE update_row
108: ( p_imp_maps_rec IN CN_IMP_MAPS_PVT.IMP_MAPS_REC_TYPE) IS
109:
110: BEGIN
111:
112: UPDATE CN_IMP_MAPS oldrec
207: -- 3. All paramaters are IN parameter.
208: -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
209: -- * -------------------------------------------------------------------------*
210: PROCEDURE lock_update_row
211: ( p_imp_maps_rec IN CN_IMP_MAPS_PVT.IMP_MAPS_REC_TYPE) IS
212:
213: CURSOR c IS
214: SELECT object_version_number
215: FROM CN_IMP_MAPS