DBA Data[Home] [Help]

APPS.EGO_TRACK_EVENTS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 45

            'oracle.apps.bom.structure.deleteSuccess','oracle.apps.bom.component.deleteSuccess')) THEN

            FOR i IN l_param_list.FIRST..l_param_list.LAST LOOP

                l_param_name  :=  l_param_list(i).getname;
Line: 81

      INSERT INTO EGO_BUSINESS_EVENTS_TRACKING (sequence_id, invoke_date, business_event_name, event_payload, inventory_item_id, organization_id, catalog_id, category_id)
      VALUES (EGO_EVENT_SEQ.nextval,sysdate,l_event_name,p_event,l_item_id,l_org_id,l_catalog_id,l_category_id);