186: p_inserting IN BOOLEAN DEFAULT FALSE,
187: p_updating IN BOOLEAN DEFAULT FALSE,
188: p_deleting IN BOOLEAN DEFAULT FALSE
189: ) AS
190: v_created_date IGS_CO_ITM_ALL.create_dt%TYPE;
191: v_message_name varchar2(30);
192: CURSOR c_cor_item IS
193: SELECT create_dt
194: FROM IGS_CO_ITM_ALL
190: v_created_date IGS_CO_ITM_ALL.create_dt%TYPE;
191: v_message_name varchar2(30);
192: CURSOR c_cor_item IS
193: SELECT create_dt
194: FROM IGS_CO_ITM_ALL
195: WHERE correspondence_type = new_references.correspondence_type AND
196: reference_number = new_references.reference_number;
197: BEGIN
198: -- If trigger has not been disabled, perform required processing