DBA Data[Home] [Help]

APPS.FND_COL_PRIV_ATTRIBUTES_PKG dependencies on FND_COL_PRIV_ATTRIBUTES_B

Line 36: cursor C is select ROWID from FND_COL_PRIV_ATTRIBUTES_B

32: X_LAST_UPDATE_LOGIN in NUMBER,
33: X_DSCRAM_LEVEL in VARCHAR2,
34: X_DSCRAM_ALGO_ID in NUMBER
35: ) is
36: cursor C is select ROWID from FND_COL_PRIV_ATTRIBUTES_B
37: where PRIVACY_ATTRIBUTE_CODE = X_PRIVACY_ATTRIBUTE_CODE
38: and APPLICATION_ID = X_APPLICATION_ID
39: and TABLE_ID = X_TABLE_ID
40: and COLUMN_ID = X_COLUMN_ID

Line 43: insert into FND_COL_PRIV_ATTRIBUTES_B (

39: and TABLE_ID = X_TABLE_ID
40: and COLUMN_ID = X_COLUMN_ID
41: ;
42: begin
43: insert into FND_COL_PRIV_ATTRIBUTES_B (
44: PRIVACY_ATTRIBUTE_CODE,
45: APPLICATION_ID,
46: TABLE_ID,
47: COLUMN_ID,

Line 200: from FND_COL_PRIV_ATTRIBUTES_B

196: ATTRIBUTE_CATEGORY,
197: OBJECT_VERSION_NUMBER,
198: DSCRAM_LEVEL,
199: DSCRAM_ALGO_ID
200: from FND_COL_PRIV_ATTRIBUTES_B
201: where PRIVACY_ATTRIBUTE_CODE = X_PRIVACY_ATTRIBUTE_CODE
202: and APPLICATION_ID = X_APPLICATION_ID
203: and TABLE_ID = X_TABLE_ID
204: and COLUMN_ID = X_COLUMN_ID

Line 318: update FND_COL_PRIV_ATTRIBUTES_B set

314: X_DSCRAM_LEVEL in VARCHAR2,
315: X_DSCRAM_ALGO_ID in NUMBER
316: ) is
317: begin
318: update FND_COL_PRIV_ATTRIBUTES_B set
319: COLUMN_SEQUENCE = X_COLUMN_SEQUENCE,
320: ATTRIBUTE1 = X_ATTRIBUTE1,
321: ATTRIBUTE2 = X_ATTRIBUTE2,
322: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 385: delete from FND_COL_PRIV_ATTRIBUTES_B

381: if (sql%notfound) then
382: raise no_data_found;
383: end if;
384:
385: delete from FND_COL_PRIV_ATTRIBUTES_B
386: where PRIVACY_ATTRIBUTE_CODE = X_PRIVACY_ATTRIBUTE_CODE
387: and APPLICATION_ID = X_APPLICATION_ID
388: and TABLE_ID = X_TABLE_ID
389: and COLUMN_ID = X_COLUMN_ID;

Line 402: from FND_COL_PRIV_ATTRIBUTES_B B

398: begin
399: delete from FND_COL_PRIV_ATTRIBUTES_TL T
400: where not exists
401: (select NULL
402: from FND_COL_PRIV_ATTRIBUTES_B B
403: where B.PRIVACY_ATTRIBUTE_CODE = T.PRIVACY_ATTRIBUTE_CODE
404: and B.APPLICATION_ID = T.APPLICATION_ID
405: and B.TABLE_ID = T.TABLE_ID
406: and B.COLUMN_ID = T.COLUMN_ID