APPS.FND_OAM_DSCRAM dependencies on FND_OAM_DS_PII_EXTENSIONS

Line 618: delete from FND_OAM_DS_PII_EXTENSIONS where privacy_attribute_code = attribute_code;

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
622: rollback;

Line 907: delete from FND_OAM_DS_PII_EXTENSIONS where privacy_attribute_code = attribute_code;

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;
911: raise;

Line 983: INSERT INTO FND_OAM_DS_PII_EXTENSIONS (PII_EXTENSION_ID,

979: l_last_update_login);
980:
981: --if it has a where clause, insert a pii_extensions row
982: IF l_where_clause IS NOT NULL THEN
983: INSERT INTO FND_OAM_DS_PII_EXTENSIONS (PII_EXTENSION_ID,
984: PRIVACY_ATTRIBUTE_CODE,
985: APPLICATION_ID,
986: TABLE_ID,
987: COLUMN_ID,

Line 995: VALUES (FND_OAM_DS_PII_EXTENSIONS_S.NEXTVAL,

991: LAST_UPDATED_BY,
992: LAST_UPDATE_DATE,
993: LAST_UPDATE_LOGIN
994: )
995: VALUES (FND_OAM_DS_PII_EXTENSIONS_S.NEXTVAL,
996: attribute_code,
997: l_application_id,
998: l_table_id,
999: l_column_id,

Line 1138: fnd_oam_ds_pii_extensions dpe,

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,
1140: fnd_product_installations pi,
1141: fnd_oracle_userid ou
1142: where pe.policy_id = v_policyid

Line 1139: fnd_oam_ds_pii_extensions dpe2,

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,
1140: fnd_product_installations pi,
1141: fnd_oracle_userid ou
1142: where pe.policy_id = v_policyid
1143: and pe.element_type = 'PII_ATTRIBUTE'

Line 1205: -- 1)fnd_oam_ds_pii_extensions for col_priv

1201: EXIT WHEN policy_attri_c%NOTFOUND;
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)));

Line 1207: -- 3)fnd_oam_ds_pii_extensions for attri (privacy_attribute_code set, table_id NULL)

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