APPS.FND_OAM_DSCRAM dependencies on FND_PRIVACY_ATTRIBUTES_B

Line 614: delete from FND_PRIVACY_ATTRIBUTES_B where privacy_attribute_code = attribute_code;

610: ) is
611:
612: begin
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;

Line 726: insert into FND_PRIVACY_ATTRIBUTES_B (PRIVACY_ATTRIBUTE_CODE,

722: attribute_code := 'DSCRAM_'||to_char(aid);
723:
724:
725: --create the attribute
726: insert into FND_PRIVACY_ATTRIBUTES_B (PRIVACY_ATTRIBUTE_CODE,
727: PRIVACY_ATTRIBUTE_TYPE,
728: SENSITIVITY,
729: PII_FLAG,
730: LOCKED_FLAG,

Line 818: UPDATE FND_PRIVACY_ATTRIBUTES_B

814:
815:
816: --create the attribute
817:
818: UPDATE FND_PRIVACY_ATTRIBUTES_B
819: SET DSCRAM_ALGO_ID = algoid,
820: LAST_UPDATED_BY = l_last_updated_by,
821: LAST_UPDATE_DATE = sysdate
822: where PRIVACY_ATTRIBUTE_CODE = attribute_code ;

Line 827: /* insert into FND_PRIVACY_ATTRIBUTES_B (PRIVACY_ATTRIBUTE_CODE,

823:
824:
825:
826:
827: /* insert into FND_PRIVACY_ATTRIBUTES_B (PRIVACY_ATTRIBUTE_CODE,
828: PRIVACY_ATTRIBUTE_TYPE,
829: SENSITIVITY,
830: PII_FLAG,
831: LOCKED_FLAG,

Line 904: --delete from FND_PRIVACY_ATTRIBUTES_B where privacy_attribute_code = attribute_code;

900: algoid number := NULL;
901:
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

Line 1134: fnd_privacy_attributes_b pa,

1130: dpe2.algo_id ext_attri_algo,
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,

Line 1208: -- 3)fnd_privacy_attributes_b

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:
1211: --if there is no algo id specified, use the default algo for this datatype
1212: IF l_algo_id IS NULL THEN