Just a comment about this query:
CREATE OR REPLACE TRIGGER RF_PROD_BOM_INS_TRG
BEFORE INSERT ON RF_PRODUCT_BOM
FOR EACH ROW
Declare
V_SeqVal Number;
BEGIN
Select F_PROD_BOM_SEQ.NEXTVAL Into V_SeqVal From Dual;
:New.PBRFNBR = V_SeqVal;
END;

Doing a similar thing in Oracle 9i, I noticed that
:New.PBRFNBR = V_SeqVal;
should be
:New.PBRFNBR := V_SeqVal;