APPS.CLN_PO_CHANGE_ORDER SQL Statements

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

Line: 137

         l_line_num_tab.delete;-- Initialize array of PO lines

Line: 139

         SAVEPOINT PO_UPDATE_TXN;

Line: 156

            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_number,
                p_part_doc_no       => p_so_number,
                p_msg_text          => l_msg_text,
                p_status_code       => 0,
                p_int_ctl_num       => p_int_cont_num);

Line: 167

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

Line: 218

               ROLLBACK TO PO_UPDATE_TXN;

Line: 220

                       cln_debug_pub.Add('Rolledback PO_UPDATE_TXN transaction');

Line: 224

               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_number,
                  p_part_doc_no       => p_so_number,
                  p_msg_text          => l_error_status,
                  p_status_code       => 1,
                  p_int_ctl_num       => p_int_cont_num);

Line: 235

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

Line: 281

               ROLLBACK TO PO_UPDATE_TXN;

Line: 283

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

Line: 311

               ROLLBACK TO PO_UPDATE_TXN;

Line: 313

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

Line: 534

               ROLLBACK TO PO_UPDATE_TXN;

Line: 536

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

Line: 539

               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: 550

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

Line: 592

               ROLLBACK TO PO_UPDATE_TXN;

Line: 594

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

Line: 623

               ROLLBACK TO PO_UPDATE_TXN;

Line: 625

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

Line: 895

               ROLLBACK TO PO_UPDATE_TXN;

Line: 897

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

Line: 900

               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: 911

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

Line: 953

               ROLLBACK TO PO_UPDATE_TXN;

Line: 955

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

Line: 986

               ROLLBACK TO PO_UPDATE_TXN;

Line: 988

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

Line: 1100

               ROLLBACK TO PO_UPDATE_TXN;

Line: 1102

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

Line: 1105

               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: 1116

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

Line: 1141

               ROLLBACK TO PO_UPDATE_TXN;

Line: 1143

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

Line: 1166

               ROLLBACK TO PO_UPDATE_TXN;

Line: 1168

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

Line: 1229

      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: 1262

   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: 1282

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

Line: 1290

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

Line: 1293

      SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

Line: 1329

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

Line: 1332

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

Line: 1337

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

Line: 1348

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

Line: 1351

   END RAISE_UPDATE_COLLABORATION;

Line: 1411

            SELECT cln_generic_s.nextval INTO l_event_key FROM dual;