DBA Data[Home] [Help]

APPS.OKL_ACCOUNTING_UPDATE_PVT SQL Statements

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

Line: 21

  SELECT ae_header_id
  FROM OKL_AE_LINES
  WHERE ae_line_id = v_line_id;
Line: 26

  SELECT accounting_event_id
  FROM OKL_AE_HEADERS
  WHERE ae_header_id = v_hdr_id;
Line: 46

        OKL_ACCT_EVENT_PUB.UPDATE_ACCT_LINES(p_api_version       => p_api_version,
                                             p_init_msg_list     => p_init_msg_list,
                                             x_return_status     => l_return_status,
                                             x_msg_count         => x_msg_count,
                                             x_msg_data          => x_msg_data,
                                             p_aelv_rec          => l_aelv_rec,
                                             x_aelv_rec          => x_aelv_rec);
Line: 70

            OKL_ACCT_EVENT_PUB.UPDATE_ACCT_HEADER(p_api_version       => p_api_version,
                                                  p_init_msg_list     => p_init_msg_list,
                                                  x_return_status     => l_return_status,
                                                  x_msg_count         => x_msg_count,
                                                  x_msg_data          => x_msg_data,
                                                  p_aehv_rec          => l_aehv_rec_in,
                                                  x_aehv_rec          => l_aehv_rec_out);
Line: 80

                OKL_ACCT_EVENT_PUB.UPDATE_ACCT_EVENT(p_api_version       => p_api_version,
                                                     p_init_msg_list     => p_init_msg_list,
                                                     x_return_status     => l_return_status,
                                                     x_msg_count         => x_msg_count,
                                                     x_msg_data          => x_msg_data,
                                                     p_aetv_rec          => l_aetv_rec_in,
                                                     x_aetv_rec          => l_aetv_rec_out);
Line: 116

END UPDATE_ACCT_ENTRIES;