APPS.CLN_PO_CHG_ORDER_STATUS SQL Statements

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

Line: 106

         l_line_num_tab.delete;-- Initialize array of PO lines

Line: 108

         SAVEPOINT PO_UPDATE_TXN;

Line: 117

            RAISE_UPDATE_COLLABORATION(
                 x_return_status     => l_return_status,
                 x_msg_data          => l_return_msg,
                 p_ref_id            => p_app_ref_id,
                 p_doc_no            => p_po_id,
                 p_part_doc_no       => p_so_id,
                 p_msg_text          => x_msg_data,
                 p_status_code       => 1,
                 p_int_ctl_num       => p_int_ctl_num);

Line: 140

         RAISE_UPDATE_COLLABORATION(
              x_return_status     => l_return_status,
              x_msg_data          => l_return_msg,
              p_ref_id            => p_app_ref_id,
              p_doc_no            => p_po_id,
              p_part_doc_no       => p_so_id,
              p_msg_text          => l_msg_text,
              p_status_code       => 0,
              p_int_ctl_num       => p_int_ctl_num);

Line: 202

            ROLLBACK TO PO_UPDATE_TXN;

Line: 204

                    cln_debug_pub.Add('Rolledback PO_UPDATE_TXN transaction',1);

Line: 207

            RAISE_UPDATE_COLLABORATION(
               x_return_status     => l_return_status,
               x_msg_data          => l_return_msg,
               p_ref_id            => p_app_ref_id,
               --p_doc_no            => p_po_id,
               p_doc_no            => l_doc_no,         --bug #4889717
               p_part_doc_no       => p_so_id,
               p_msg_text          => l_error_status,
               p_status_code       => 1,
               p_int_ctl_num       => p_int_ctl_num);

Line: 219

                       cln_debug_pub.Add('RAISE_UPDATE_COLLABORATION CALL FAILED',1);

Line: 491

            ROLLBACK TO PO_UPDATE_TXN;

Line: 493

                    cln_debug_pub.Add('Rolledback PO_UPDATE_TXN transaction',1);

Line: 496

            RAISE_UPDATE_COLLABORATION(
               x_return_status     => l_return_status,
               x_msg_data          => l_return_msg,
               p_ref_id            => p_app_ref_id,
               --p_doc_no            => p_po_id,
               p_doc_no            => l_doc_no,       --bug #4889717
               p_part_doc_no       => p_so_id,
               p_msg_text          => l_error_status,
               p_status_code       => 1,
               p_int_ctl_num       => p_int_ctl_num);

Line: 508

                       cln_debug_pub.Add('RAISE_UPDATE_COLLABORATION CALL FAILED',1);

Line: 862

            ROLLBACK TO PO_UPDATE_TXN;

Line: 864

                    cln_debug_pub.Add('Rolledback PO_UPDATE_TXN transaction',1);

Line: 867

            RAISE_UPDATE_COLLABORATION(
               x_return_status     => l_return_status,
               x_msg_data          => l_return_msg,
               p_ref_id            => p_app_ref_id,
               --p_doc_no            => p_po_id,
               p_doc_no            => l_doc_no,    --bug #4889717
               p_part_doc_no       => p_so_id,
               p_msg_text          => l_error_status,
               p_status_code       => 1,
               p_int_ctl_num       => p_int_ctl_num);

Line: 879

                       cln_debug_pub.Add('RAISE_UPDATE_COLLABORATION CALL FAILED',1);

Line: 1039

              ROLLBACK TO PO_UPDATE_TXN;

Line: 1041

                      cln_debug_pub.Add('Rolledback PO_UPDATE_TXN transaction',1);

Line: 1044

              RAISE_UPDATE_COLLABORATION(
                 x_return_status     => l_return_status,
                 x_msg_data          => l_return_msg,
                 p_ref_id            => p_app_ref_id,
                 p_doc_no            => p_po_id,
                 p_part_doc_no       => p_so_num,
                 p_msg_text          => l_error_status,
                 p_status_code       => 1,
                 p_int_ctl_num       => p_int_ctl_num);

Line: 1055

                         cln_debug_pub.Add('RAISE_UPDATE_COLLABORATION CALL FAILED',1);

Line: 1139

      SELECT  PARTY_ID, PARTY_SITE_ID
      INTO    l_tp_id, l_tp_site_id
      FROM    ECX_TP_HEADERS
      WHERE   TP_HEADER_ID = p_tp_header_id;

Line: 1342

   PROCEDURE RAISE_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  VARCHAR2)
   IS
      l_cln_ch_parameters  wf_parameter_list_t;

Line: 1362

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

Line: 1367

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

Line: 1369

      SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

Line: 1399

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

Line: 1402

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

Line: 1405

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

Line: 1417

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

Line: 1419

   END RAISE_UPDATE_COLLABORATION;

Line: 1468

            SELECT cln_generic_s.nextval INTO l_event_key FROM dual;