What possible risks it would have to create a trigger on wip_requirement_operations
Hi ,
I want to create a trigger on table wip_requirement_operations. The purpose is to help with the performance issue in this table. Once the trigger is on, it would transfer some data into other tables.
But we do not know what risks it may have to our systems? Please give some advice.
here is the brief trigger i have made.
Create Or Replace Package chwm_data_pkg Is
-- Private type declarations
Procedure popup_job_list(p_organization_id Number,
p_wip_entity_id Number,
p_inventory_item_id Number,
p_operation_seq_num Number,
p_action_type Varchar2);