APPS.CAC_AVLBLTY_EVENTS_PVT SQL Statements

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

Line: 15

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

Line: 83

  l_ParameterList.DELETE;

Line: 88

PROCEDURE RAISE_UPDATE_SCHEDULE
/*******************************************************************************
**
** RAISE_UPDATE_SCHEDULE
**
**   Raise business event
**
*******************************************************************************/
( p_Schedule_Id          IN     NUMBER               -- id of the schedule
, p_Schedule_Category    IN     VARCHAR2
, p_Schdl_Start_Date     IN     DATE
, p_Schdl_End_Date       IN     DATE
)
IS

 l_ParameterList      WF_PARAMETER_LIST_T;

Line: 109

  l_EventName := 'oracle.apps.jtf.cac.scheduleRep.updateSchedule';

Line: 151

  l_ParameterList.DELETE;

Line: 153

END RAISE_UPDATE_SCHEDULE;

Line: 156

PROCEDURE RAISE_DELETE_SCHEDULE
/*******************************************************************************
**
** RAISE_DELETE_SCHEDULE
**
**   Raise business event
**
*******************************************************************************/
( p_Schedule_Id          IN     NUMBER               -- id of the schedule
, p_Schedule_Category    IN     VARCHAR2
, p_Schdl_Start_Date     IN     DATE
, p_Schdl_End_Date       IN     DATE
)
IS

 l_ParameterList      WF_PARAMETER_LIST_T;

Line: 177

  l_EventName := 'oracle.apps.jtf.cac.scheduleRep.deleteSchedule';

Line: 219

  l_ParameterList.DELETE;

Line: 221

END RAISE_DELETE_SCHEDULE;

Line: 310

  l_ParameterList.DELETE;

Line: 315

PROCEDURE RAISE_UPDATE_RESOURCE
/*******************************************************************************
**
** RAISE_UPDATE_RESOURCE
**
**   Raise business event
**
*******************************************************************************/
( p_Schedule_Id          IN     NUMBER               -- id of the schedule
, p_Schedule_Category    IN     VARCHAR2
, p_Schdl_Start_Date     IN     DATE
, p_Schdl_End_Date       IN     DATE
, p_Object_Type          IN     VARCHAR2
, p_Object_Id            IN     NUMBER
, p_Object_Start_Date    IN     DATE
, p_Object_End_Date      IN     DATE
)
IS

 l_ParameterList      WF_PARAMETER_LIST_T;

Line: 340

  l_EventName := 'oracle.apps.jtf.cac.scheduleRep.updateResource';

Line: 401

  l_ParameterList.DELETE;

Line: 403

END RAISE_UPDATE_RESOURCE;

Line: 492

  l_ParameterList.DELETE;