353: -- delete constraint rules if any
354: DELETE FROM OE_PC_RSET_SEL_COLS
355: WHERE record_set_id = x_record_set_id;
356:
357: -- delete all the validation pkgs from oe_pc_validation_pkgs table
358: DELETE FROM OE_PC_VALIDATION_PKGS
359: WHERE record_set_id = x_record_set_id;
360:
361: -- delete the tl table
354: DELETE FROM OE_PC_RSET_SEL_COLS
355: WHERE record_set_id = x_record_set_id;
356:
357: -- delete all the validation pkgs from oe_pc_validation_pkgs table
358: DELETE FROM OE_PC_VALIDATION_PKGS
359: WHERE record_set_id = x_record_set_id;
360:
361: -- delete the tl table
362: DELETE FROM OE_PC_RSETS_TL