APPS.OKL_ACCT_SOURCES_PUB SQL Statements

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

Line: 7

|  Procedure    : update_acct_src_custom_status                              |
|  Description  : Procedure to update only the custom status. This will be   |
|                 updated once the accounting sources are processed by the   |
|                 customer. This will be used at customization.              |
|  Parameters   : p_account_source_id - ID of the account sources record     |
|		  which requires to be updated.				     |
|		  p_custom_status - New status to which the account sources  |
|		  record to be updated					     |
|  History      : 07-05-04 santonyr    -- Created                            |
|                                                                            |
*============================================================================*/

  PROCEDURE update_acct_src_custom_status(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_account_source_id		   IN NUMBER,
    p_custom_status		   IN VARCHAR2) IS

    l_asev_rec                        asev_rec_type;

Line: 32

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_acct_src_custom_status';

Line: 36

    SAVEPOINT update_acct_src_custom_status;

Line: 46

    Okl_acct_sources_Pvt.update_acct_src_custom_status(
                               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_asev_rec      => l_asev_rec
                              ,x_asev_rec      => x_asev_rec
                              );

Line: 67

      ROLLBACK TO update_acct_src_custom_status;

Line: 75

      ROLLBACK TO update_acct_src_custom_status;

Line: 82

      Fnd_Msg_Pub.ADD_EXC_MSG('Okl_acct_sources_Pub','update_acct_src_custom_status');

Line: 90

  END   update_acct_src_custom_status;