APPS.FND_OAM_DSCRAM dependencies on FND_OAM_DS_PSETS_B

Line 171: insert into FND_OAM_DS_PSETS_B (

167: from sys.dual;
168:
169: /*insert*/
170:
171: insert into FND_OAM_DS_PSETS_B (
172: policyset_id,
173: CREATED_BY,
174: CREATION_DATE,
175: LAST_UPDATED_BY,

Line 232: update FND_OAM_DS_PSETS_B

228: begin
229:
230: /*update*/
231:
232: update FND_OAM_DS_PSETS_B
233: set LAST_UPDATED_BY = l_last_updated_by,
234: LAST_UPDATE_DATE = sysdate,
235: LAST_UPDATE_LOGIN = l_last_update_login
236: where policyset_id = psetid;

Line 659: delete from FND_OAM_DS_PSETS_B where policyset_id = pset_id;

655: ) is
656:
657: begin
658:
659: delete from FND_OAM_DS_PSETS_B where policyset_id = pset_id;
660: delete from FND_OAM_DS_PSETS_TL where policyset_id = pset_id;
661: delete from FND_OAM_DS_PSET_ELMNTS where policyset_id = pset_id;
662:
663: commit;

Line 1106: CURSOR pset_policy_c (v_psetid fnd_oam_ds_psets_b.policyset_id%TYPE) IS

1102: IS
1103: l_ctxt VARCHAR2(60) := PKG_NAME||'IMPORT_POLICY_SET_TO_DSCFG';
1104:
1105: --cursor to query policies for a policy set
1106: CURSOR pset_policy_c (v_psetid fnd_oam_ds_psets_b.policyset_id%TYPE) IS
1107: select policy_id
1108: from fnd_oam_ds_pset_elmnts
1109: where policyset_id = v_psetid;
1110: policy_rec pset_policy_c%ROWTYPE;