APPS.FND_OAM_DSCRAM dependencies on FND_COL_PRIV_ATTRIBUTES_B

Line 617: delete from FND_COL_PRIV_ATTRIBUTES_B where privacy_attribute_code = attribute_code;

613:
614: delete from FND_PRIVACY_ATTRIBUTES_B where privacy_attribute_code = attribute_code;
615: delete from FND_PRIVACY_ATTRIBUTES_TL where privacy_attribute_code = attribute_code;
616: delete from FND_OAM_DS_POLICY_ELMNTS where privacy_attribute_code = attribute_code;
617: delete from FND_COL_PRIV_ATTRIBUTES_B where privacy_attribute_code = attribute_code;
618: delete from FND_OAM_DS_PII_EXTENSIONS where privacy_attribute_code = attribute_code;
619: commit;
620: EXCEPTION
621: when others then

Line 906: delete from FND_COL_PRIV_ATTRIBUTES_B where privacy_attribute_code = attribute_code;

902: begin
903:
904: --delete from FND_PRIVACY_ATTRIBUTES_B where privacy_attribute_code = attribute_code;
905: delete from FND_PRIVACY_ATTRIBUTES_TL where privacy_attribute_code = attribute_code;
906: delete from FND_COL_PRIV_ATTRIBUTES_B where privacy_attribute_code = attribute_code;
907: delete from FND_OAM_DS_PII_EXTENSIONS where privacy_attribute_code = attribute_code;
908: EXCEPTION
909: when others then
910: rollback;

Line 952: --insert into fnd_col_priv_attributes_b

948: WHERE T.TABLE_NAME = upper(l_table_name)
949: AND T.TABLE_ID = C.TABLE_ID
950: AND C.COLUMN_NAME = upper(l_column_name);
951:
952: --insert into fnd_col_priv_attributes_b
953: INSERT INTO FND_COL_PRIV_ATTRIBUTES_B (PRIVACY_ATTRIBUTE_CODE,
954: APPLICATION_ID,
955: TABLE_ID,
956: COLUMN_ID,

Line 953: INSERT INTO FND_COL_PRIV_ATTRIBUTES_B (PRIVACY_ATTRIBUTE_CODE,

949: AND T.TABLE_ID = C.TABLE_ID
950: AND C.COLUMN_NAME = upper(l_column_name);
951:
952: --insert into fnd_col_priv_attributes_b
953: INSERT INTO FND_COL_PRIV_ATTRIBUTES_B (PRIVACY_ATTRIBUTE_CODE,
954: APPLICATION_ID,
955: TABLE_ID,
956: COLUMN_ID,
957: COLUMN_SEQUENCE,

Line 1031: delete from FND_COL_PRIV_ATTRIBUTES_B where

1027: begin
1028:
1029: --FIXME: this incurs an unnecessary full table scan of fnd_columns when we should be deleting using the
1030: --known attribute_code, application_id, table_id, column_id to get the index.
1031: delete from FND_COL_PRIV_ATTRIBUTES_B where
1032: PRIVACY_ATTRIBUTE_CODE = attribute_code
1033: and table_id = (select table_id from fnd_tables
1034: where table_name = upper(l_table_name))
1035: and column_id = (select column_id from fnd_columns c, fnd_tables t where

Line 1135: fnd_col_priv_attributes_b pc,

1131: dpe.algo_id ext_col_algo,
1132: dpe.where_clause where_clause
1133: from fnd_oam_ds_policy_elmnts pe,
1134: fnd_privacy_attributes_b pa,
1135: fnd_col_priv_attributes_b pc,
1136: fnd_tables t,
1137: fnd_columns c,
1138: fnd_oam_ds_pii_extensions dpe,
1139: fnd_oam_ds_pii_extensions dpe2,

Line 1206: -- 2)fnd_col_priv_attributes_b

1202: fnd_oam_debug.log(1, l_ctxt, 'Processing Attribute Code: '||attri_rec.privacy_attribute_code);
1203:
1204: --algo_id resolution is in the following order, higher is more specific:
1205: -- 1)fnd_oam_ds_pii_extensions for col_priv
1206: -- 2)fnd_col_priv_attributes_b
1207: -- 3)fnd_oam_ds_pii_extensions for attri (privacy_attribute_code set, table_id NULL)
1208: -- 3)fnd_privacy_attributes_b
1209: l_algo_id := NVL(attri_rec.ext_col_algo, NVL(attri_rec.col_algo, NVL(attri_rec.ext_attri_algo, attri_rec.attri_algo)));
1210: