APPS.FND_PRIVACY_ATTRIBUTES_PKG dependencies on FND_PRIVACY_ATTRIBUTES_B

Line 38: cursor C is select ROWID from FND_PRIVACY_ATTRIBUTES_B

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 (

Line 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,

Line 199: from FND_PRIVACY_ATTRIBUTES_B

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:

Line 321: update FND_PRIVACY_ATTRIBUTES_B set

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,

Line 381: delete from FND_PRIVACY_ATTRIBUTES_B

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;

Line 395: from FND_PRIVACY_ATTRIBUTES_B B

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 (