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_DETAILS_PUB SQL Statements

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

Line: 16


PROCEDURE do_update_rule_detail(
    p_rule_detail_rec         IN OUT   NOCOPY RULE_DETAILS_REC_TYPE,
    p_object_version_number IN OUT NOCOPY   NUMBER,
    x_return_status         IN OUT NOCOPY   VARCHAR2
);

Line: 75


    FUN_RULE_DETAILS_PKG.Insert_Row (
        X_ROWID                                =>l_rowid,
        X_RULE_DETAIL_ID	               =>p_rule_detail_rec.rule_detail_id,
        X_RULE_OBJECT_ID                       =>p_rule_detail_rec.rule_object_id,
        X_RULE_NAME		               =>p_rule_detail_rec.rule_name,
        X_SEQ			               =>p_rule_detail_rec.seq,
        X_OPERATOR                             =>p_rule_detail_rec.operator,
        X_ENABLED_FLAG                         =>p_rule_detail_rec.enabled_flag,
        X_RESULT_APPLICATION_ID                =>p_rule_detail_rec.result_application_id,
        X_RESULT_VALUE                         =>p_rule_detail_rec.result_value,
        X_CREATED_BY_MODULE                    =>p_rule_detail_rec.created_by_module
    );

Line: 95


 |              do_update_rule_detail
 |
 | DESCRIPTION
 |              Updates rules record
 |
 | SCOPE - PRIVATE
 |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
 |
 | ARGUMENTS  : IN:
 |              OUT:
 |          IN/ OUT:
 |                    p_rule_detail_rec
 |                    p_object_version_number
 |                    x_return_status
 |
 | RETURNS    : NONE
 |
 | NOTES
 |
 | MODIFICATION HISTORY
 |
 +===========================================================================*/

PROCEDURE do_update_rule_detail(
    p_rule_detail_rec          IN OUT    NOCOPY RULE_DETAILS_REC_TYPE,
    p_object_version_number     IN OUT NOCOPY  NUMBER,
    x_return_status             IN OUT NOCOPY  VARCHAR2
) IS

    l_object_version_number             NUMBER;

Line: 132


        SELECT OBJECT_VERSION_NUMBER,
               ROWID
        INTO   l_object_version_number,
               l_rowid
        FROM   FUN_rule_details
        WHERE RULE_DETAIL_ID = p_rule_detail_rec.rule_detail_id
        AND    RULE_OBJECT_ID     = p_rule_detail_rec.rule_object_id
        FOR UPDATE OF RULE_NAME NOWAIT;

Line: 176


    FUN_RULE_DETAILS_PKG.Update_Row (
        X_RULE_DETAIL_ID	               =>p_rule_detail_rec.rule_detail_id,
        X_RULE_OBJECT_ID                       =>p_rule_detail_rec.rule_object_id,
        X_RULE_NAME		               =>p_rule_detail_rec.rule_name,
        X_SEQ			               =>p_rule_detail_rec.seq,
        X_OPERATOR                             =>p_rule_detail_rec.operator,
        X_ENABLED_FLAG                         =>p_rule_detail_rec.enabled_flag,
        X_RESULT_APPLICATION_ID                =>p_rule_detail_rec.result_application_id,
        X_RESULT_VALUE                         =>p_rule_detail_rec.result_value,
        X_CREATED_BY_MODULE                    =>p_rule_detail_rec.created_by_module
    );

Line: 288


 * PROCEDURE update_rule_detail
 *
 * DESCRIPTION
 *     Updates A Rule
 *
 * 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_detail_rec              User defined Rules 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_detail(
    p_init_msg_list             IN     VARCHAR2 := FND_API.G_FALSE,
    p_rule_detail_rec          IN     rule_details_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_detail_rec                      rule_details_REC_TYPE := p_rule_detail_rec;

Line: 332


    SAVEPOINT update_rule_detail;

Line: 357


    do_update_rule_detail(
                             l_rule_detail_rec,
                             p_object_version_number,
                             x_return_status);

Line: 375


        ROLLBACK TO update_rule_detail;

Line: 383


        ROLLBACK TO update_rule_detail;

Line: 391


        ROLLBACK TO update_rule_detail;

Line: 406


END update_rule_detail;

Line: 416


 *     FUN_rule_details_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_rule_detail_id               Rule Id.
 *   IN/OUT:
 *   OUT:
 *     x_rule_detail_rec              Returns Rules 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_detail_rec (
    p_init_msg_list                         IN     VARCHAR2 := FND_API.G_FALSE,
    p_rule_detail_id                        IN     NUMBER,
    p_rule_object_id	                    IN     NUMBER,
    x_rule_detail_rec	                    OUT    NOCOPY RULE_DETAILS_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: 477


    FUN_RULE_DETAILS_PKG.Select_Row (
        X_RULE_NAME                       =>x_rule_detail_rec.rule_name,
	X_RULE_DETAIL_ID                  =>x_rule_detail_rec.rule_detail_id,
	X_RULE_OBJECT_ID                  =>x_rule_detail_rec.rule_object_id,
	X_SEQ                             =>x_rule_detail_rec.seq,
	X_OPERATOR                        =>x_rule_detail_rec.operator,
	X_ENABLED_FLAG                    =>x_rule_detail_rec.enabled_flag,
	X_RESULT_APPLICATION_ID           =>x_rule_detail_rec.result_application_id,
	X_RESULT_VALUE                    =>x_rule_detail_rec.result_value,
	X_CREATED_BY_MODULE               =>x_rule_detail_rec.created_by_module
    );

Line: 528


 * PROCEDURE delete_rule_detail
 *
 * DESCRIPTION
 *     Deletes A Rule.
 *
 * 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_name                    Rule Name.
 *     p_rule_object_id               Rule Object 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_detail(
    p_init_msg_list           IN        VARCHAR2 := FND_API.G_FALSE,
    p_rule_name               IN        VARCHAR2,
    p_rule_object_id	      IN        NUMBER,
    x_return_status           OUT NOCOPY       VARCHAR2,
    x_msg_count               OUT NOCOPY       NUMBER,
    x_msg_data                OUT NOCOPY       VARCHAR2
) IS

  l_rule_detail_id NUMBER;

Line: 573


    SAVEPOINT delete_rule_detail;

Line: 583


    SELECT rule_detail_id INTO l_rule_detail_id
    FROM fun_rule_details
    WHERE rule_object_id = p_rule_object_id
    AND rule_name = p_rule_name;

Line: 589


    FUN_RULE_DETAILS_PKG.Delete_Row (
        X_RULE_DETAIL_ID => l_rule_detail_id
    );

Line: 603


        ROLLBACK TO delete_rule_detail;

Line: 611


        ROLLBACK TO delete_rule_detail;

Line: 619


        ROLLBACK TO delete_rule_detail;

Line: 628


END delete_rule_detail;