APPS.FA_SORP_UTIL_PVT SQL Statements

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

Line: 33

    SELECT SORP_ENABLED_FLAG
    INTO l_sorp_enabled_flag
    FROM FA_BOOK_CONTROLS
    WHERE BOOK_TYPE_CODE = p_book_type_code;

Line: 104

        p_last_update_date => NULL,
        p_last_updated_by => NULL,
        p_last_update_login => NULL,
        p_who_mode => 'CREATE',
        p_log_level_rec => p_log_level_rec) then
        fa_debug_pkg.add(l_calling_fn,'create_sorp_neutral_acct', 'failed', p_log_level_rec => p_log_level_rec);

Line: 130

 * @param p_last_update_date standard who column information
 * @param p_last_updated_by standard who column information
 * @param p_last_update_login standard who column information
 * @param p_who_mode Indicates what kind of data need to be inserted into the who
 *        columns of fa_adjusments. In FA, some pieces of code insert the
 *        created by information and other places the updated by information for the
 *        who columns of FA_ADJUSTMENTS. Thus this column has been added to make
 *        this function generic and insert the appropriate data as required depending
 *        on where it is called from
 * @rep:scope private
 * @rep:lifecycle active
 * @rep:displayname create_sorp_neutral_acct
 * @rep:compatibility S
*/
FUNCTION create_sorp_neutral_acct (
    p_amount                IN NUMBER,
    p_reversal              IN VARCHAR2,
    p_adj                   IN OUT NOCOPY FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT,
    p_created_by            IN NUMBER,
    p_creation_date         IN DATE,
    p_last_update_date      IN DATE,
    p_last_updated_by       IN NUMBER,
    p_last_update_login     IN NUMBER,
    p_who_mode              IN VARCHAR2
    , p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type)

RETURN BOOLEAN IS
    pos_err EXCEPTION;

Line: 169

        fa_debug_pkg.add(l_calling_fn,'p_last_update_date', p_last_update_date, p_log_level_rec => p_log_level_rec);

Line: 170

        fa_debug_pkg.add(l_calling_fn,'p_last_updated_by', p_last_updated_by, p_log_level_rec => p_log_level_rec);

Line: 171

        fa_debug_pkg.add(l_calling_fn,'p_last_update_login', p_last_update_login, p_log_level_rec => p_log_level_rec);

Line: 206

                                              p_last_update_date,
                                              p_last_updated_by,
                                              p_last_update_login
                                              , p_log_level_rec => p_log_level_rec) then
                raise pos_err;

Line: 240

                                              p_last_update_date,
                                              p_last_updated_by,
                                              p_last_update_login
                                              , p_log_level_rec => p_log_level_rec) then
                raise pos_err;