537: l_row_id amw_risks_all_vl.row_id%TYPE;
538:
539: CURSOR c_rev_id IS
540: SELECT AMW_RISK_REV_ID_S.NEXTVAL
541: FROM dual;
542:
543: CURSOR c_rev_id_exists (l_rev_id IN NUMBER) IS
544: SELECT 1
545: FROM AMW_RISKS_B
546: WHERE RISK_REV_ID = l_rev_id;
547:
548: CURSOR c_id IS
549: SELECT AMW_RISK_ID_S.NEXTVAL
550: FROM dual;
551:
552: CURSOR c_id_exists (l_id IN NUMBER) IS
553: SELECT 1
554: FROM AMW_RISKS_B