APPS.OKL_CS_TRANSACTIONS_PUB SQL Statements

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

Line: 8

  PROCEDURE get_totals (p_select          IN           VARCHAR2,
                        p_from            IN           VARCHAR2,
                        p_where           IN           VARCHAR2,
                        x_inv_total       OUT NOCOPY   NUMBER,
                        x_rec_total       OUT NOCOPY   NUMBER,
                        x_due_total       OUT NOCOPY   NUMBER,
			x_credit_total    OUT NOCOPY   NUMBER,
			x_adjust_total    OUT NOCOPY   NUMBER,
                        x_row_count       OUT NOCOPY   NUMBER,
                        x_return_status   OUT NOCOPY   VARCHAR2,
                        x_msg_count       OUT NOCOPY   NUMBER,
                        x_msg_data        OUT NOCOPY   VARCHAR2) IS

    l_return_status          VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 35

    okl_cs_transactions_pvt.get_totals (p_select          => p_select,
                                        p_from            => p_from,
                                        p_where           => p_where,
                                        x_inv_total       => x_inv_total,
                                        x_rec_total       => x_rec_total,
                                        x_due_total       => x_due_total,
                                        x_credit_total    => x_credit_total,
                                        x_adjust_total    => x_adjust_total,
                                        x_row_count       => x_row_count,
                                        x_return_status   => l_return_status,
                                        x_msg_count       => l_msg_count,
                                        x_msg_data        => l_msg_data);