APPS.FND_OAM_DSCRAM dependencies on FND_OAM_DS_PSET_ELMNTS

Line 275: delete from FND_OAM_DS_PSET_ELMNTS where policyset_id = psetid;

271: and T.LANGUAGE = L.LANGUAGE_CODE);
272:
273: /* Delete all policy set elements for this policy set. */
274:
275: delete from FND_OAM_DS_PSET_ELMNTS where policyset_id = psetid;
276:
277: commit;
278: EXCEPTION
279: when others then

Line 411: select FND_OAM_DS_PSET_ELMNTS_S.nextval

407:
408: begin
409:
410: /* Get new ID */
411: select FND_OAM_DS_PSET_ELMNTS_S.nextval
412: into elementid
413: from sys.dual;
414:
415: /*insert*/

Line 417: insert into FND_OAM_DS_PSET_ELMNTS(

413: from sys.dual;
414:
415: /*insert*/
416:
417: insert into FND_OAM_DS_PSET_ELMNTS(
418: policyset_rel_id,
419: policyset_id,
420: policy_id,
421: CREATED_BY,

Line 448: delete from FND_OAM_DS_PSET_ELMNTS where policyset_id = psetid;

444:
445:
446: begin
447:
448: delete from FND_OAM_DS_PSET_ELMNTS where policyset_id = psetid;
449:
450: commit;
451: EXCEPTION
452: when others then

Line 639: delete from FND_OAM_DS_PSET_ELMNTS where policy_id = p_policy_id;

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:
642: commit;
643: EXCEPTION

Line 661: delete from FND_OAM_DS_PSET_ELMNTS where policyset_id = pset_id;

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;
664: EXCEPTION
665: when others then

Line 1108: from fnd_oam_ds_pset_elmnts

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;
1111:
1112: --CURSOR policy_c (v_policyid fnd_oam_ds_policies_b.policy_id%TYPE) IS