APPS.QP_VALIDATE_LIMITS SQL Statements

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

Line: 19

   SELECT list_type_code into l_list_type_code from QP_LIST_HEADERS_B
   WHERE LIST_HEADER_ID = p_LIMITS_rec.list_header_id;

Line: 153

   SELECT LIST_LINE_TYPE_CODE,
          BENEFIT_QTY,
          ACCRUAL_FLAG,
          ARITHMETIC_OPERATOR,
          MODIFIER_LEVEL_CODE,
          QUALIFICATION_IND
   INTO
          l_list_line_type_code,
          l_benefit_qty,
          l_accrual_flag,
          l_application_method,
          l_modifier_level_code,
          l_qualification_ind
   FROM   QP_LIST_LINES
   WHERE LIST_LINE_ID = p_LIMITS_rec.list_line_id;

Line: 874

    IF  p_LIMITS_rec.last_updated_by IS NOT NULL AND
        (   p_LIMITS_rec.last_updated_by <>
            p_old_LIMITS_rec.last_updated_by OR
            p_old_LIMITS_rec.last_updated_by IS NULL )
    THEN
        IF NOT QP_Validate.Last_Updated_By(p_LIMITS_rec.last_updated_by) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 885

    IF  p_LIMITS_rec.last_update_date IS NOT NULL AND
        (   p_LIMITS_rec.last_update_date <>
            p_old_LIMITS_rec.last_update_date OR
            p_old_LIMITS_rec.last_update_date IS NULL )
    THEN
        IF NOT QP_Validate.Last_Update_Date(p_LIMITS_rec.last_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 896

    IF  p_LIMITS_rec.last_update_login IS NOT NULL AND
        (   p_LIMITS_rec.last_update_login <>
            p_old_LIMITS_rec.last_update_login OR
            p_old_LIMITS_rec.last_update_login IS NULL )
    THEN
        IF NOT QP_Validate.Last_Update_Login(p_LIMITS_rec.last_update_login) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1096

    IF  p_LIMITS_rec.program_update_date IS NOT NULL AND
        (   p_LIMITS_rec.program_update_date <>
            p_old_LIMITS_rec.program_update_date OR
            p_old_LIMITS_rec.program_update_date IS NULL )
    THEN
        IF NOT QP_Validate.Program_Update_Date(p_LIMITS_rec.program_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1288

PROCEDURE Entity_Delete
(   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   p_LIMITS_rec                    IN  QP_Limits_PUB.Limits_Rec_Type
)
IS
l_return_status               VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 1299

    SELECT count(*) into l_dummy from QP_LIMIT_BALANCES
    WHERE limit_id = p_LIMITS_rec.limit_id
    AND nvl(consumed_amount,0) > 0;

Line: 1336

            ,   'Entity_Delete'
            );

Line: 1340

END Entity_Delete;

Line: 1343

PROCEDURE Entity_Update
(   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   p_LIMITS_rec                    IN  QP_Limits_PUB.Limits_Rec_Type
)
IS
l_return_status               VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 1359

    SELECT count(*) into l_dummy from QP_LIMIT_BALANCES
    WHERE limit_id = p_LIMITS_rec.limit_id
    AND nvl(consumed_amount,0) > 0;

Line: 1363

    SELECT MAX(consumed_amount) INTO l_consumed_amount FROM QP_LIMIT_BALANCES
    WHERE limit_id = p_LIMITS_rec.limit_id;

Line: 1512

            ,   'Entity_Delete'
            );

Line: 1516

END Entity_Update;