APPS.CLN_NP_UTILS_PKG SQL Statements

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

Line: 26

   PROCEDURE UPDATE_COLLABORATION(
      x_return_status      OUT NOCOPY VARCHAR2,
      x_msg_data           OUT NOCOPY VARCHAR2,
      p_ref_id             IN  VARCHAR2,
      p_doc_no             IN  VARCHAR2,
      p_part_doc_no        IN  VARCHAR2,
      p_msg_text           IN  VARCHAR2,
      p_status_code        IN  NUMBER,
      p_int_ctl_num        IN  NUMBER,
      p_tp_header_id       IN  NUMBER)
   IS
      l_cln_ch_parameters  wf_parameter_list_t;

Line: 48

         cln_debug_pub.Add('ENTERING UPDATE_COLLABORATION', 2);

Line: 55

      FND_MESSAGE.SET_TOKEN('EVENT','Update');

Line: 58

      SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

Line: 95

      WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',
                          l_event_key, NULL, l_cln_ch_parameters, NULL);

Line: 99

         cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update raised', 1);

Line: 103

         cln_debug_pub.Add('EXITING UPDATE_COLLABORATION', 2);

Line: 115

            cln_debug_pub.Add('EXITING UPDATE_COLLABORATION', 2);

Line: 117

   END UPDATE_COLLABORATION;

Line: 176

            SELECT cln_generic_s.nextval INTO l_event_key FROM dual;