75: close c;
76:
77: exception
78: when others then
79: wf_core.context('FND_SVC_COMP_REQUESTS_H_PKG', 'Insert_Row', X_COMPONENT_ID, X_EVENT_NAME);
80: raise;
81:
82: end INSERT_ROW;
83:
120: open c;
121: fetch c into recinfo;
122: if (c%notfound) then
123: close c;
124: wf_core.raise('WF_RECORD_DELETED');
125: end if;
126: close c;
127:
128: if ( ((recinfo.EVENT_PARAMS = X_EVENT_PARAMS)
140: AND (recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
141: ) then
142: null;
143: else
144: wf_core.raise('WF_RECORD_CHANGED');
145: end if;
146:
147: return;
148:
147: return;
148:
149: exception
150: when others then
151: wf_core.context('FND_SVC_COMP_REQUESTS_H_PKG', 'Lock_Row', X_REQUEST_HISTORY_ID);
152: raise;
153: end LOCK_ROW;
154:
155: procedure UPDATE_ROW (
210: l_object_version_number := l_object_version_number + 1;
211: else
212:
213: raise_application_error(-20002,
214: wf_core.translate('SVC_RECORD_ALREADY_UPDATED'));
215:
216: end if;
217:
218: end if;
241:
242:
243: exception
244: when others then
245: wf_core.context('FND_SVC_COMP_REQUESTS_H_PKG', 'Update_Row', X_REQUEST_HISTORY_ID);
246: raise;
247: end UPDATE_ROW;
248:
249: procedure DELETE_ROW (
259:
260:
261: exception
262: when others then
263: wf_core.context('FND_SVC_COMP_REQUESTS_H_PKG', 'Delete_Row', X_REQUEST_HISTORY_ID);
264: raise;
265: end DELETE_ROW;
266:
267: end FND_SVC_COMP_REQUESTS_H_PKG;