APPS.JTF_ESC_WF_EVENTS_PVT SQL Statements

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

Line: 26

    l_list.DELETE;

Line: 33

  PROCEDURE publish_update_esc
  (
       P_ESC_REC	       IN      jtf_ec_pvt.Esc_Rec_type
  ) IS
   l_list			WF_PARAMETER_LIST_T;

Line: 45

       l_event_name := 'oracle.apps.jtf.cac.escalation.updateEscalation';

Line: 55

       l_list.DELETE;

Line: 58

 END publish_update_esc;

Line: 62

  PROCEDURE publish_delete_esc (
       P_ESC_REC	       IN      jtf_ec_pvt.Esc_Rec_type
  )
  IS
   l_list		WF_PARAMETER_LIST_T;

Line: 68

   l_event_name 	varchar2(240) := 'oracle.apps.jtf.cac.escalation.deleteEscalation';

Line: 82

    l_list.DELETE;

Line: 85

 END publish_delete_esc;

Line: 116

	l_list.DELETE;

Line: 120

  PROCEDURE publish_update_escref (
       P_ESC_REF_REC_OLD	       IN      Jtf_ec_references_pvt.Esc_ref_Rec,
       P_ESC_REF_REC_NEW	       IN      Jtf_ec_references_pvt.Esc_ref_Rec
  )
  IS
    l_list   WF_PARAMETER_LIST_T;

Line: 127

	l_event_name   VARCHAR2(240) := 'oracle.apps.jtf.cac.escalation.updateEscReference';

Line: 143

	l_list.DELETE;

Line: 144

  END publish_update_escref;

Line: 146

  PROCEDURE publish_delete_escref (
       P_ESC_REF_REC		   IN	   Jtf_ec_references_pvt.Esc_ref_Rec
  )
  IS
   l_list		    WF_PARAMETER_LIST_T;

Line: 152

   l_event_name 	varchar2(240) := 'oracle.apps.jtf.cac.escalation.deleteEscReference';

Line: 172

    l_list.DELETE;

Line: 173

 END publish_delete_escref;

Line: 183

	SELECT p_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;