21: PROCEDURE lock_record ( p_object_id IN NUMBER
22: ) IS
23: CURSOR C IS
24: SELECT *
25: FROM cn_objects
26: WHERE object_id = p_object_id
27: FOR UPDATE OF object_id NOWAIT;
28:
29: Recinfo C%ROWTYPE;
65: )
66: IS
67: BEGIN
68: x_object_version_no:=x_object_version_no+1;
69: UPDATE cn_objects SET
70: name = p_name
71: , description = p_description
72: , dependency_map_complete = p_dependency_map_complete
73: , object_status = p_status
109: , p_org_id IN NUMBER
110: )
111: IS
112: BEGIN
113: INSERT INTO cn_objects (
114: object_id
115: , name
116: , description
117: , dependency_map_complete