PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center