APPS.JTF_NOTES_EVENTS_PVT SQL Statements

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

Line: 10

  	SELECT p_EventName ||'-'|| jtf_notes_wf_events_s.NEXTVAL INTO l_key FROM DUAL;

Line: 62

    l_ParameterList.DELETE;

Line: 68

  PROCEDURE RaiseUpdateNote
  ( p_NoteID            IN   NUMBER
  , p_SourceObjectCode  IN   VARCHAR2
  , p_SourceObjectID    IN   VARCHAR2
  )
  IS
   l_ParameterList      WF_PARAMETER_LIST_T;

Line: 76

   l_EventName          VARCHAR2(240) := 'oracle.apps.jtf.cac.notes.update';

Line: 105

    WF_EVENT.RAISE3( p_event_name     => 'oracle.apps.jtf.cac.notes.update'
                   , p_event_key      => l_ItemKey
                   , p_event_data     => NULL
                   , p_parameter_list => l_ParameterList
                   , p_send_date      => SYSDATE
                   );

Line: 115

    l_ParameterList.DELETE;

Line: 118

  END RaiseUpdateNote;

Line: 120

  PROCEDURE RaiseDeleteNote
  ( p_NoteID            IN   NUMBER
  , p_SourceObjectCode  IN   VARCHAR2
  , p_SourceObjectID    IN   VARCHAR2
  )
  IS
   l_ParameterList      WF_PARAMETER_LIST_T;

Line: 128

   l_EventName          VARCHAR2(240) := 'oracle.apps.jtf.cac.notes.delete';

Line: 157

    WF_EVENT.RAISE3( p_event_name     => 'oracle.apps.jtf.cac.notes.delete'
                   , p_event_key      => l_ItemKey
                   , p_event_data     => NULL
                   , p_parameter_list => l_ParameterList
                   , p_send_date      => SYSDATE
                   );

Line: 167

    l_ParameterList.DELETE;

Line: 169

  END RaiseDeleteNote;