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.QP_DEFAULT_LIMIT_BALANCES SQL Statements

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

Line: 39


    SELECT qp_limit_balances_s.nextval
    INTO   l_limit_balance_id
    FROM   dual;

Line: 760


    IF g_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_LIMIT_BALANCES_rec.last_updated_by := NULL;

Line: 766


    IF g_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_LIMIT_BALANCES_rec.last_update_date := NULL;

Line: 772


    IF g_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_LIMIT_BALANCES_rec.last_update_login := NULL;

Line: 790


    IF g_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_LIMIT_BALANCES_rec.program_update_date := NULL;

Line: 824


    OR  g_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM
    OR  g_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM
    OR  g_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR
    OR  g_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR
    OR  g_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR
    OR  g_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR
    OR  g_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
    OR  g_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR
    OR  g_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR
    OR  g_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR
    OR  g_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR
    OR  g_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
    OR  g_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR
    OR  g_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR
    OR  g_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR
    OR  g_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM
    OR  g_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_LIMIT_BALANCES_rec.request_id = FND_API.G_MISS_NUM
    OR  g_LIMIT_BALANCES_rec.reserved_amount = FND_API.G_MISS_NUM
    THEN

        QP_Default_Limit_Balances.Attributes
        (   p_LIMIT_BALANCES_rec          => g_LIMIT_BALANCES_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_LIMIT_BALANCES_rec          => x_LIMIT_BALANCES_rec
        );