APPS.JTF_AM_WF_EVENTS_PUB SQL Statements

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

Line: 19

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

Line: 37

     SELECT Upper(Substr(p_event_name,22,(Instr(p_event_name,'.',1,5)-22))) into l_doc_type from dual;

Line: 38

     l_str:='SELECT JTF_AM_WF_'||l_doc_type||'_EVENT_S.nextval FROM DUAL';

Line: 342

    l_list.DELETE;

Line: 478

    l_list.DELETE;

Line: 551

    l_list.DELETE;

Line: 615

    l_list.DELETE;

Line: 754

    l_list.DELETE;

Line: 853

    l_list.DELETE;

Line: 969

    l_list.DELETE;

Line: 1376

      l_list.DELETE;

Line: 1448

      l_list.DELETE;