eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_RULE_CRITERIA_PUB SQL Statements

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

Line: 16


PROCEDURE do_update_rule_criteria(
    p_rule_criteria_rec         IN OUT   NOCOPY RULE_CRITERIA_REC_TYPE,
    p_object_version_number IN OUT NOCOPY   NUMBER,
    x_return_status         IN OUT NOCOPY   VARCHAR2
);

Line: 74


    FUN_RULE_CRITERIA_PKG.Insert_Row (
	X_ROWID                           =>l_rowid,
	X_CRITERIA_ID                     =>p_rule_criteria_rec.criteria_id,
	X_RULE_DETAIL_ID                  =>p_rule_criteria_rec.rule_detail_id,
	X_CRITERIA_PARAM_ID               =>p_rule_criteria_rec.criteria_param_id,
	X_CONDITION                       =>p_rule_criteria_rec.condition,
	X_PARAM_VALUE                     =>p_rule_criteria_rec.param_value,
	X_CASE_SENSITIVE_FLAG             =>p_rule_criteria_rec.case_sensitive_flag,
	X_CREATED_BY_MODULE               =>p_rule_criteria_rec.created_by_module
    );

Line: 91


 |              do_update_rule_criteria
 |
 | DESCRIPTION
 |              Updates Rule Criteria
 |
 | SCOPE - PRIVATE
 |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
 |
 | ARGUMENTS  : IN:
 |              OUT:
 |          IN/ OUT:
 |                    p_rule_criteria_rec
 |                    p_object_version_number
 |                    x_return_status
 |
 | RETURNS    : NONE
 |
 | NOTES
 |
 | MODIFICATION HISTORY
 |
 +===========================================================================*/

PROCEDURE do_update_rule_criteria(
    p_rule_criteria_rec         IN OUT    NOCOPY RULE_CRITERIA_REC_TYPE,
    p_object_version_number     IN OUT NOCOPY  NUMBER,
    x_return_status             IN OUT NOCOPY  VARCHAR2
) IS

    l_object_version_number             NUMBER;

Line: 127


        SELECT OBJECT_VERSION_NUMBER,
               ROWID
        INTO   l_object_version_number,
               l_rowid
        FROM   FUN_RULE_CRITERIA
        WHERE  CRITERIA_ID = p_rule_criteria_rec.criteria_id
        FOR UPDATE NOWAIT;

Line: 170


    FUN_RULE_CRITERIA_PKG.Update_Row (
	X_CRITERIA_ID                     =>p_rule_criteria_rec.criteria_id,
	X_RULE_DETAIL_ID                  =>p_rule_criteria_rec.rule_detail_id,
	X_CRITERIA_PARAM_ID               =>p_rule_criteria_rec.criteria_param_id,
	X_CONDITION                       =>p_rule_criteria_rec.condition,
	X_PARAM_VALUE                     =>p_rule_criteria_rec.param_value,
	X_CASE_SENSITIVE_FLAG             =>p_rule_criteria_rec.case_sensitive_flag,
	X_CREATED_BY_MODULE               =>p_rule_criteria_rec.created_by_module
    );

Line: 278


 * PROCEDURE update_rule_criteria
 *
 * DESCRIPTION
 *     Updates Rule Criteria
 *
 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
 *
 * ARGUMENTS
 *   IN:
 *     p_init_msg_list                Initialize message stack if it is set to
 *                                    FND_API.G_TRUE. Default is FND_API.G_FALSE.
 *     p_rule_criteria_rec            Rule Criteria record.
 *   IN/OUT:
 *     p_object_version_number        Used for locking the being updated record.
 *   OUT:
 *     x_return_status                Return status after the call. The status can
 *                                    be FND_API.G_RET_STS_SUCCESS (success),
 *                                    FND_API.G_RET_STS_ERROR (error),
 *                                    FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
 *     x_msg_count                    Number of messages in message stack.
 *     x_msg_data                     Message text if x_msg_count is 1.
 *
 * NOTES
 *
 * MODIFICATION HISTORY
 *
 *   10-Sep-2004    Amulya Mishra     Created.
 *
 */

PROCEDURE update_rule_criteria (
    p_init_msg_list             IN     VARCHAR2 := FND_API.G_FALSE,
    p_rule_criteria_rec         IN     RULE_CRITERIA_REC_TYPE,
    p_object_version_number     IN OUT NOCOPY NUMBER,
    x_return_status             OUT NOCOPY    VARCHAR2,
    x_msg_count                 OUT NOCOPY    NUMBER,
    x_msg_data                  OUT NOCOPY    VARCHAR2
) IS

    l_rule_criteria_rec                    RULE_CRITERIA_REC_TYPE := p_rule_criteria_rec;

Line: 322


    SAVEPOINT update_rule_criteria;

Line: 348


    do_update_rule_criteria(
                             l_rule_criteria_rec,
                             p_object_version_number,
                             x_return_status);

Line: 364


        ROLLBACK TO update_rule_criteria;

Line: 372


        ROLLBACK TO update_rule_criteria;

Line: 380


        ROLLBACK TO update_rule_criteria;

Line: 389


END update_rule_criteria;

Line: 399


 *     FUN_RULES_PKG.Select_Row
 *
 * ARGUMENTS
 *   IN:
 *     p_init_msg_list                Initialize message stack if it is set to
 *                                    FND_API.G_TRUE. Default is FND_API.G_FALSE.
 *     p_criteria_id                  Criteria Id
 *     p_RULE_DETAIL_ID               Rule Id
 *   IN/OUT:
 *   OUT:
 *     x_rule_criteria_rec            Returned Rule Criteria record.
 *     x_return_status                Return status after the call. The status can
 *                                    be FND_API.G_RET_STS_SUCCESS (success),
 *                                    FND_API.G_RET_STS_ERROR (error),
 *                                    FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
 *     x_msg_count                    Number of messages in message stack.
 *     x_msg_data                     Message text if x_msg_count is 1.
 *
 * NOTES
 *
 * MODIFICATION HISTORY
 *
 *   10-Sep-2004    Amulya Mishra         Created.
 *
 */

PROCEDURE get_rule_criteria_rec (
    p_init_msg_list                         IN     VARCHAR2 := FND_API.G_FALSE,
    p_criteria_id                           IN     NUMBER,
    p_rule_detail_id                        IN     NUMBER,
    x_rule_criteria_rec                     OUT    NOCOPY RULE_CRITERIA_REC_TYPE,
    x_return_status                         OUT NOCOPY    VARCHAR2,
    x_msg_count                             OUT NOCOPY    NUMBER,
    x_msg_data                              OUT NOCOPY    VARCHAR2
) IS

BEGIN
    --Initialize message list if p_init_msg_list is set to TRUE.
    IF FND_API.to_Boolean(p_init_msg_list) THEN
        FND_MSG_PUB.initialize;

Line: 458


    FUN_RULE_CRITERIA_PKG.Select_Row (
	X_CRITERIA_ID                     =>x_rule_criteria_rec.criteria_id,
	X_RULE_DETAIL_ID                  =>x_rule_criteria_rec.rule_detail_id,
        X_CRITERIA_PARAM_ID               =>x_rule_criteria_rec.criteria_param_id,
	X_CONDITION                       =>x_rule_criteria_rec.condition,
	X_PARAM_VALUE                     =>x_rule_criteria_rec.param_value,
	X_CASE_SENSITIVE_FLAG             =>x_rule_criteria_rec.case_sensitive_flag,
	X_CREATED_BY_MODULE               =>x_rule_criteria_rec.created_by_module
    );

Line: 506


 * PROCEDURE delete_rule_criteria
 *
 * DESCRIPTION
 *     Deletes Rule Criteria.
 *
 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
 *
 *
 * ARGUMENTS
 *   IN:
 *     p_init_msg_list                Initialize message stack if it is set to
 *                                    FND_API.G_TRUE. Default is FND_API.G_FALSE.
 *     p_criteria_param_name          Criteria Param Name.
 *     p_rule_detail_id               Rule Detail Id
 *   IN/OUT:
 *   OUT:
 *     x_return_status                Return status after the call. The status can
 *                                    be FND_API.G_RET_STS_SUCCESS (success),
 *                                    FND_API.G_RET_STS_ERROR (error),
 *                                    FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
 *     x_msg_count                    Number of messages in message stack.
 *     x_msg_data                     Message text if x_msg_count is 1.
 *
 * NOTES
 *
 * MODIFICATION HISTORY
 *
 *   10-Sep-2004    Amulya Mishra       Created.
 *
 */

PROCEDURE delete_rule_criteria(
    p_init_msg_list           IN        VARCHAR2 := FND_API.G_FALSE,
    p_criteria_id             IN NUMBER,
    x_return_status           OUT NOCOPY       VARCHAR2,
    x_msg_count               OUT NOCOPY       NUMBER,
    x_msg_data                OUT NOCOPY       VARCHAR2
) IS


BEGIN

    -- standard start of API savepoint
    SAVEPOINT delete_rule_criteria;

Line: 560


    FUN_RULE_CRITERIA_PKG.Delete_Row (
        X_CRITERIA_ID =>p_criteria_id
    );

Line: 574


        ROLLBACK TO delete_rule_criteria;

Line: 582


        ROLLBACK TO delete_rule_criteria;

Line: 590


        ROLLBACK TO delete_rule_criteria;

Line: 599


END delete_rule_criteria;