Database Trigger Problems
Good afternoon. We are trying to create a new audit and trigger and are getting a compilation error. Any thoughts?
Thanks in advance,
Sarah
SQL>
SQL> CREATE OR REPLACE TRIGGER CART_TEMPL_INV_TR
2 AFTER INSERT OR UPDATE OR DELETE ON PS_CART_TEMPL_INV
3 FOR EACH ROW
4 DECLARE
5 V_AUDIT_OPRID VARCHAR2(64);
6 BEGIN
7 DBMS_APPLICATION_INFO.READ_CLIENT_INFO(V_AUDIT_OPRID);
8 IF INSERTING
9 THEN
10 INSERT INTO PS_AUDIT_CART_TMPL
11 VALUES (GET_PS_OPRID(V_AUDIT_OPRID),SYSDATE,'A',:NEW.BUSINESS_UNIT,:NEW.INV_CART_ID,:NEW.INV_ITEM_ID,:NEW.COMPARTMENT,:NEW.COUNT_ORDER,:NEW.QTY_OPTIMAL,:NEW.UNIT_OF_MEASURE,:NEW.AVG_CART_USAGE,:NEW.DISTRIB_TYPE,:NEW.TRANSFER_COST,:NEW.PRICE_MARKUP_PCT,:NEW.CHARGE_CODE,:NEW.USGC_STATUS,:NEW.USGC_INSTANCE,:NEW.ACCOUNT,:NEW.ALTACCT,:NEW.DEPTID,:NEW.OPERATING_UNIT,:NEW.PRODUCT,:NEW.FUND_CODE,:NEW.CLASS_FLD,:NEW.PROGRAM_CODE,:NEW.BUDGET_REF,:NEW.AFFILIATE,:NEW.AFFILIATE_INTRA1,:NEW.AFFILIATE_INTRA2,:NEW.CHARTFIELD1,:NEW.CHARTFIELD2,:NEW.CHARTFIELD3,:NEW.BUSINESS_UNIT_PC,:NEW.PROJECT_ID,:NEW.ACTIVITY_ID,:NEW.RESOURCE_TYPE,:NEW.RESOURCE_CATEGORY,:NEW.RESOURCE_SUB_CAT,:NEW.ANALYSIS_TYPE,:NEW.FOQ,:NEW.QTY_MAXIMUM,:NEW.COUNT_REQUIRED,:NEW.CART_REPLEN_CTRL,:NEW.CART_REPLEN_OPT,:NEW.CONS_NON_STOCK,:NEW.BCKORDR_CNCL_FLAG,:NEW.SPEEDTYPE_KEY,:NEW.COMBO_VALID_FLG,:NEW.MATERIAL_RECON_FLG,:NEW.USG_TRCKNG_METHOD,:NEW.CHARGE_MARKUP_PCNT,:NEW.CHARGE_MARKUP_AMT,:NEW.TRANSFER_CALC_TYPE,:NEW.SYNCID,:NEW.SYNCDTTM);