Customer wants to create trigger on wip_requirement_operations table.He wants to evaluate how much r

Customer wants to create trigger on wip_requirement_operations table.He wants to evaluate how much risk it is going to  have to systems, how much influence it would have on the system capacity.

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

End chwm_data_pkg;

/

Create Or Replace Package Body chwm_data_pkg Is

  -- Private type declarations

  Procedure popup_job_list(p_organization_id   Number,

                           p_wip_entity_id     Number,