12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from CUG_SR_TASK_ATTR_VALS_B
17: where SR_TASK_ATTR_VAL_ID = X_SR_TASK_ATTR_VAL_ID
18: ;
19: begin
20: insert into CUG_SR_TASK_ATTR_VALS_B (
16: cursor C is select ROWID from CUG_SR_TASK_ATTR_VALS_B
17: where SR_TASK_ATTR_VAL_ID = X_SR_TASK_ATTR_VAL_ID
18: ;
19: begin
20: insert into CUG_SR_TASK_ATTR_VALS_B (
21: SR_TASK_ATTR_VAL_ID,
22: OBJECT_VERSION_NUMBER,
23: TSK_TYP_ATTR_DEPEND_ID,
24: TASK_TYPE_ATTR_MAP_ID,
87: cursor c is select
88: OBJECT_VERSION_NUMBER,
89: TSK_TYP_ATTR_DEPEND_ID,
90: TASK_TYPE_ATTR_MAP_ID
91: from CUG_SR_TASK_ATTR_VALS_B
92: where SR_TASK_ATTR_VAL_ID = X_SR_TASK_ATTR_VAL_ID
93: for update of SR_TASK_ATTR_VAL_ID nowait;
94: recinfo c%rowtype;
95:
145: X_LAST_UPDATED_BY in NUMBER,
146: X_LAST_UPDATE_LOGIN in NUMBER
147: ) is
148: begin
149: update CUG_SR_TASK_ATTR_VALS_B set
150: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
151: TSK_TYP_ATTR_DEPEND_ID = X_TSK_TYP_ATTR_DEPEND_ID,
152: TASK_TYPE_ATTR_MAP_ID = X_TASK_TYPE_ATTR_MAP_ID,
153: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
183: if (sql%notfound) then
184: raise no_data_found;
185: end if;
186:
187: delete from CUG_SR_TASK_ATTR_VALS_B
188: where SR_TASK_ATTR_VAL_ID = X_SR_TASK_ATTR_VAL_ID;
189:
190: if (sql%notfound) then
191: raise no_data_found;
197: begin
198: delete from CUG_SR_TASK_ATTR_VALS_TL T
199: where not exists
200: (select NULL
201: from CUG_SR_TASK_ATTR_VALS_B B
202: where B.SR_TASK_ATTR_VAL_ID = T.SR_TASK_ATTR_VAL_ID
203: );
204:
205: update CUG_SR_TASK_ATTR_VALS_TL T set (