34: X_LAST_UPDATE_LOGIN in NUMBER,
35: X_DSCRAM_LEVEL in VARCHAR2,
36: X_DSCRAM_ALGO_ID in NUMBER
37: ) is
38: cursor C is select ROWID from FND_PRIVACY_ATTRIBUTES_B
39: where PRIVACY_ATTRIBUTE_CODE = X_PRIVACY_ATTRIBUTE_CODE
40: ;
41: begin
42: insert into FND_PRIVACY_ATTRIBUTES_B (
38: cursor C is select ROWID from FND_PRIVACY_ATTRIBUTES_B
39: where PRIVACY_ATTRIBUTE_CODE = X_PRIVACY_ATTRIBUTE_CODE
40: ;
41: begin
42: insert into FND_PRIVACY_ATTRIBUTES_B (
43: ATTRIBUTE8,
44: ATTRIBUTE9,
45: ATTRIBUTE10,
46: ATTRIBUTE11,
195: ATTRIBUTE6,
196: ATTRIBUTE7,
197: DSCRAM_LEVEL,
198: DSCRAM_ALGO_ID
199: from FND_PRIVACY_ATTRIBUTES_B
200: where PRIVACY_ATTRIBUTE_CODE = X_PRIVACY_ATTRIBUTE_CODE
201: for update of PRIVACY_ATTRIBUTE_CODE nowait;
202: recinfo c%rowtype;
203:
317: X_DSCRAM_LEVEL in VARCHAR2,
318: X_DSCRAM_ALGO_ID in NUMBER
319: ) is
320: begin
321: update FND_PRIVACY_ATTRIBUTES_B set
322: ATTRIBUTE8 = X_ATTRIBUTE8,
323: ATTRIBUTE9 = X_ATTRIBUTE9,
324: ATTRIBUTE10 = X_ATTRIBUTE10,
325: ATTRIBUTE11 = X_ATTRIBUTE11,
377: if (sql%notfound) then
378: raise no_data_found;
379: end if;
380:
381: delete from FND_PRIVACY_ATTRIBUTES_B
382: where PRIVACY_ATTRIBUTE_CODE = X_PRIVACY_ATTRIBUTE_CODE;
383:
384: if (sql%notfound) then
385: raise no_data_found;
391: begin
392: delete from FND_PRIVACY_ATTRIBUTES_TL T
393: where not exists
394: (select NULL
395: from FND_PRIVACY_ATTRIBUTES_B B
396: where B.PRIVACY_ATTRIBUTE_CODE = T.PRIVACY_ATTRIBUTE_CODE
397: );
398:
399: update FND_PRIVACY_ATTRIBUTES_TL T set (