6: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
7:
8: BEGIN
9:
10: Bom_Business_Event_PKG.Add_Parameter_To_List('INVENTORY_ITEM_ID', :new.inventory_item_id, l_parameter_list);
11: Bom_Business_Event_PKG.Add_Parameter_To_List('ORGANIZATION_ID', :new.organization_id, l_parameter_list);
12: Bom_Business_Event_PKG.Add_Parameter_To_List('ITEM_NAME', :new.ITEM_CONCAT_SEGMENTS, l_parameter_list);
13: Bom_Business_Event_PKG.Add_Parameter_To_List('ITEM_DESCRIPTION', :new.ITEM_DESCRIPTION, l_parameter_list);
14: Bom_Business_Event_PKG.Raise_event ( Bom_Business_Event_PKG.G_ITEM_MARKED_DEL_EVENT, 'DG'||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'),l_parameter_list);
7:
8: BEGIN
9:
10: Bom_Business_Event_PKG.Add_Parameter_To_List('INVENTORY_ITEM_ID', :new.inventory_item_id, l_parameter_list);
11: Bom_Business_Event_PKG.Add_Parameter_To_List('ORGANIZATION_ID', :new.organization_id, l_parameter_list);
12: Bom_Business_Event_PKG.Add_Parameter_To_List('ITEM_NAME', :new.ITEM_CONCAT_SEGMENTS, l_parameter_list);
13: Bom_Business_Event_PKG.Add_Parameter_To_List('ITEM_DESCRIPTION', :new.ITEM_DESCRIPTION, l_parameter_list);
14: Bom_Business_Event_PKG.Raise_event ( Bom_Business_Event_PKG.G_ITEM_MARKED_DEL_EVENT, 'DG'||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'),l_parameter_list);
15: END;
8: BEGIN
9:
10: Bom_Business_Event_PKG.Add_Parameter_To_List('INVENTORY_ITEM_ID', :new.inventory_item_id, l_parameter_list);
11: Bom_Business_Event_PKG.Add_Parameter_To_List('ORGANIZATION_ID', :new.organization_id, l_parameter_list);
12: Bom_Business_Event_PKG.Add_Parameter_To_List('ITEM_NAME', :new.ITEM_CONCAT_SEGMENTS, l_parameter_list);
13: Bom_Business_Event_PKG.Add_Parameter_To_List('ITEM_DESCRIPTION', :new.ITEM_DESCRIPTION, l_parameter_list);
14: Bom_Business_Event_PKG.Raise_event ( Bom_Business_Event_PKG.G_ITEM_MARKED_DEL_EVENT, 'DG'||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'),l_parameter_list);
15: END;
16:
9:
10: Bom_Business_Event_PKG.Add_Parameter_To_List('INVENTORY_ITEM_ID', :new.inventory_item_id, l_parameter_list);
11: Bom_Business_Event_PKG.Add_Parameter_To_List('ORGANIZATION_ID', :new.organization_id, l_parameter_list);
12: Bom_Business_Event_PKG.Add_Parameter_To_List('ITEM_NAME', :new.ITEM_CONCAT_SEGMENTS, l_parameter_list);
13: Bom_Business_Event_PKG.Add_Parameter_To_List('ITEM_DESCRIPTION', :new.ITEM_DESCRIPTION, l_parameter_list);
14: Bom_Business_Event_PKG.Raise_event ( Bom_Business_Event_PKG.G_ITEM_MARKED_DEL_EVENT, 'DG'||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'),l_parameter_list);
15: END;
16:
10: Bom_Business_Event_PKG.Add_Parameter_To_List('INVENTORY_ITEM_ID', :new.inventory_item_id, l_parameter_list);
11: Bom_Business_Event_PKG.Add_Parameter_To_List('ORGANIZATION_ID', :new.organization_id, l_parameter_list);
12: Bom_Business_Event_PKG.Add_Parameter_To_List('ITEM_NAME', :new.ITEM_CONCAT_SEGMENTS, l_parameter_list);
13: Bom_Business_Event_PKG.Add_Parameter_To_List('ITEM_DESCRIPTION', :new.ITEM_DESCRIPTION, l_parameter_list);
14: Bom_Business_Event_PKG.Raise_event ( Bom_Business_Event_PKG.G_ITEM_MARKED_DEL_EVENT, 'DG'||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'),l_parameter_list);
15: END;
16: