408: -- delete constraint rules if any
409: DELETE FROM OE_PC_VTMPLT_COLS
410: WHERE validation_tmplt_id = x_validation_tmplt_id;
411:
412: -- delete all the validation pkgs from oe_pc_validation_pkgs table
413: DELETE FROM OE_PC_VALIDATION_PKGS
414: WHERE validation_tmplt_id = x_validation_tmplt_id;
415:
416: -- delete the tl table
409: DELETE FROM OE_PC_VTMPLT_COLS
410: WHERE validation_tmplt_id = x_validation_tmplt_id;
411:
412: -- delete all the validation pkgs from oe_pc_validation_pkgs table
413: DELETE FROM OE_PC_VALIDATION_PKGS
414: WHERE validation_tmplt_id = x_validation_tmplt_id;
415:
416: -- delete the tl table
417: DELETE FROM OE_PC_VTMPLTS_TL