29: , X_ATTRIBUTE14 VARCHAR2
30: , X_ATTRIBUTE15 VARCHAR2
31: ) IS
32:
33: cursor C is select RLTD_MODIFIER_ID from QP_RLTD_MODIFIERS
34: where RLTD_MODIFIER_ID = X_RLTD_MODIFIER_ID;
35:
36:
37:
37:
38: BEGIN
39:
40:
41: insert into QP_RLTD_MODIFIERS
42: (
43: RLTD_MODIFIER_ID
44: , CREATION_DATE
45: , CREATED_BY
136: , X_ATTRIBUTE15 VARCHAR2
137: ) IS
138:
139:
140: cursor C is select * from QP_RLTD_MODIFIERS
141: where RLTD_MODIFIER_ID = X_RLTD_MODIFIER_ID
142: for update of RLTD_MODIFIER_ID nowait;
143: Recinfo C%ROWTYPE;
144:
305: , X_ATTRIBUTE15 VARCHAR2
306: ) IS
307: begin
308:
309: UPDATE QP_RLTD_MODIFIERS
310: SET
311: RLTD_MODIFIER_ID = X_RLTD_MODIFIER_ID
312: , CREATION_DATE = X_CREATION_DATE
313: , CREATED_BY = X_CREATED_BY
346: X_TO_RLTD_MODIFIER_ID NUMBER
347: ) IS
348: begin
349:
350: delete from QP_RLTD_MODIFIERS
351: where TO_RLTD_MODIFIER_ID= X_TO_RLTD_MODIFIER_ID;
352:
353: if (SQL%NOTFOUND) then
354: Raise NO_DATA_FOUND;