APPS.FND_OAM_DSCRAM dependencies on FND_OAM_DS_POLICY_ELMNTS

Line 138: delete from FND_OAM_DS_POLICY_ELMNTS where policy_id = policyid;

134: and T.LANGUAGE = L.LANGUAGE_CODE);
135:
136: /* Delete all policy elements for this policy. */
137:
138: delete from FND_OAM_DS_POLICY_ELMNTS where policy_id = policyid;
139: commit;
140:
141: EXCEPTION
142: when others then

Line 301: select FND_OAM_DS_POLICY_ELMNTS_S.nextval

297:
298: begin
299:
300: /* Get new ID */
301: select FND_OAM_DS_POLICY_ELMNTS_S.nextval
302: into elementid
303: from sys.dual;
304:
305: /*insert*/

Line 307: insert into FND_OAM_DS_POLICY_ELMNTS(

303: from sys.dual;
304:
305: /*insert*/
306:
307: insert into FND_OAM_DS_POLICY_ELMNTS(
308: policy_rel_id,
309: policy_id,
310: element_type,
311: privacy_attribute_code,

Line 339: delete from FND_OAM_DS_POLICY_ELMNTS where policy_id = policyid;

335:
336:
337: begin
338:
339: delete from FND_OAM_DS_POLICY_ELMNTS where policy_id = policyid;
340:
341: commit;
342: EXCEPTION
343: when others then

Line 366: select FND_OAM_DS_POLICY_ELMNTS_S.nextval

362:
363: begin
364:
365: /* Get new ID */
366: select FND_OAM_DS_POLICY_ELMNTS_S.nextval
367: into elementid
368: from sys.dual;
369:
370: /*insert*/

Line 372: insert into FND_OAM_DS_POLICY_ELMNTS(

368: from sys.dual;
369:
370: /*insert*/
371:
372: insert into FND_OAM_DS_POLICY_ELMNTS(
373: policy_rel_id,
374: policy_id,
375: element_type,
376: delete_id,

Line 616: delete from FND_OAM_DS_POLICY_ELMNTS where privacy_attribute_code = attribute_code;

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;
619: commit;
620: EXCEPTION

Line 640: delete from FND_OAM_DS_POLICY_ELMNTS where policy_id = p_policy_id;

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:
642: commit;
643: EXCEPTION
644: when others then

Line 683: delete from FND_OAM_DS_POLICY_ELMNTS where delete_id = deleteid;

679:
680: begin
681:
682: delete from FND_OAM_DS_DELETES where delete_id = deleteid;
683: delete from FND_OAM_DS_POLICY_ELMNTS where delete_id = deleteid;
684: commit;
685: EXCEPTION
686: when others then
687: rollback;

Line 1114: -- from fnd_oam_ds_policy_elmnts

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:
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.

Line 1133: from fnd_oam_ds_policy_elmnts pe,

1129: pc.dscram_algo_id col_algo,
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,

Line 1164: from fnd_oam_ds_deletes d, fnd_oam_ds_policy_elmnts pe

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'
1167: and d.delete_id = pe.delete_id;
1168: delete_rec policy_delete_c%ROWTYPE;