55: close c;
56:
57: exception
58: when others then
59: wf_core.context('FND_SVC_COMP_PARAM_VALS_PKG', 'Insert_Row', X_COMPONENT_PARAMETER_ID);
60: raise;
61: end INSERT_ROW;
62:
63:
84: open c;
85: fetch c into recinfo;
86: if (c%notfound) then
87: close c;
88: wf_core.raise('WF_RECORD_DELETED');
89: end if;
90: close c;
91:
92: if ( ((recinfo.PARAMETER_VALUE = X_PARAMETER_VALUE)
97: AND (recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
98: ) then
99: null;
100: else
101: wf_core.raise('WF_RECORD_CHANGED');
102: end if;
103:
104: return;
105:
104: return;
105:
106: exception
107: when others then
108: wf_core.context('FND_SVC_COMP_PARAM_VALS_PKG', 'Lock_Row', X_COMPONENT_PARAMETER_ID);
109: raise;
110: end LOCK_ROW;
111:
112: procedure UPDATE_ROW (
160: l_object_version_number := l_object_version_number + 1;
161: else
162:
163: raise_application_error(-20002,
164: wf_core.translate('SVC_RECORD_ALREADY_UPDATED'));
165:
166: end if;
167:
168: end if;
283: end if;
284:
285: exception
286: when others then
287: wf_core.context('FND_SVC_COMP_PARAM_VALS_PKG', 'Update_Row', X_COMPONENT_PARAMETER_ID);
288: raise;
289: end UPDATE_ROW;
290:
291: procedure DELETE_ROW (
309: end if;
310: end if;
311: exception
312: when others then
313: wf_core.context('FND_SVC_COMP_PARAM_VALS_PKG', 'Delete_Row', X_COMPONENT_PARAMETER_ID);
314: raise;
315:
316: end DELETE_ROW;
317: