APPS.FND_OAM_DSCRAM dependencies on FND_OAM_DS_POLICIES_B

Line 36: insert into FND_OAM_DS_POLICIES_B (

32: from sys.dual;
33:
34: /*insert into the base table*/
35:
36: insert into FND_OAM_DS_POLICIES_B (
37: policy_id,
38: CREATED_BY,
39: CREATION_DATE,
40: LAST_UPDATED_BY,

Line 97: update FND_OAM_DS_POLICIES_B

93: begin
94:
95: /*update*/
96:
97: update FND_OAM_DS_POLICIES_B
98: set LAST_UPDATED_BY = l_last_updated_by,
99: LAST_UPDATE_DATE = sysdate,
100: LAST_UPDATE_LOGIN = l_last_update_login
101: where policy_id = policyid;

Line 637: delete from FND_OAM_DS_POLICIES_B where policy_id = p_policy_id;

633: ) is
634:
635: begin
636:
637: delete from FND_OAM_DS_POLICIES_B where policy_id = p_policy_id;
638: delete from FND_OAM_DS_POLICIES_TL where policy_id = p_policy_id;
639: delete from FND_OAM_DS_PSET_ELMNTS where policy_id = p_policy_id;
640: delete from FND_OAM_DS_POLICY_ELMNTS where policy_id = p_policy_id;
641:

Line 1112: --CURSOR policy_c (v_policyid fnd_oam_ds_policies_b.policy_id%TYPE) IS

1108: from fnd_oam_ds_pset_elmnts
1109: where policyset_id = v_psetid;
1110: policy_rec pset_policy_c%ROWTYPE;
1111:
1112: --CURSOR policy_c (v_policyid fnd_oam_ds_policies_b.policy_id%TYPE) IS
1113: -- select element_type, PRIVACY_ATTRIBUTE_CODE, DELETE_ID
1114: -- from fnd_oam_ds_policy_elmnts
1115: -- where policy_id = v_policyid;
1116:

Line 1119: CURSOR policy_attri_c (v_policyid fnd_oam_ds_policies_b.policy_id%TYPE) IS

1115: -- where policy_id = v_policyid;
1116:
1117: --cursor to query pii attributes for a policy, assumes that the pii_extensions table
1118: --has only 0 or 1 corresponding rows for an attribute.
1119: CURSOR policy_attri_c (v_policyid fnd_oam_ds_policies_b.policy_id%TYPE) IS
1120: select pe.privacy_attribute_code privacy_attribute_code,
1121: ou.oracle_username owner,
1122: t.table_name table_name,
1123: c.column_name column_name,

Line 1162: CURSOR policy_delete_c (v_policyid fnd_oam_ds_policies_b.policy_id%TYPE) IS

1158: and pi.oracle_id = ou.oracle_id;
1159: attri_rec policy_attri_c%ROWTYPE;
1160:
1161: --cursor to query deletes/truncates for a policy
1162: CURSOR policy_delete_c (v_policyid fnd_oam_ds_policies_b.policy_id%TYPE) IS
1163: select d.delete_id, d.owner, d.table_name, d.where_clause, d.use_truncate_flag
1164: from fnd_oam_ds_deletes d, fnd_oam_ds_policy_elmnts pe
1165: where pe.policy_id = v_policyid
1166: and upper(pe.element_type) = 'DML_DELETE'