APPS.QP_VALIDATE_CURR_LISTS SQL Statements

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

Line: 49

        SELECT 'X'
        INTO   l_dummy_c
        FROM   fnd_currencies_vl
        WHERE  enabled_flag = 'Y'
        and    currency_flag = 'Y'
        and    currency_code = p_CURR_LISTS_rec.base_currency_code
        and    trunc(sysdate) between nvl(start_date_active,trunc(sysdate))
        and    nvl(end_date_active,trunc(sysdate));

Line: 73

          SELECT 'X'
          INTO l_dummy_c
          FROM qp_lookups
          WHERE lookup_type = 'MARKUP_OPERATOR' and
          lookup_code = p_CURR_LISTS_rec.base_markup_operator and
	  enabled_flag = 'Y' and
	  trunc(sysdate) between
	  nvl(start_date_active, trunc(sysdate)) and nvl(end_date_active, trunc(sysdate));

Line: 101

          SELECT 'X'
          INTO l_dummy_c
          FROM qp_price_formulas_vl
          WHERE trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
          and nvl(end_date_active, trunc(sysdate))
          and price_formula_id = p_CURR_LISTS_rec.base_markup_formula_id;

Line: 111

          SELECT 'X'
          INTO l_dummy_c
          FROM qp_price_formulas_vl fh
          WHERE trunc(sysdate) between nvl(fh.start_date_active, trunc(sysdate))
	  and nvl(fh.end_date_active, trunc(sysdate))
          and fh.price_formula_id = p_CURR_LISTS_rec.base_markup_formula_id
          and  not exists (Select 'x'
                           From qp_price_formula_lines fl
                           Where fl.price_formula_id = fh.price_formula_id
                           and fl.PRICE_FORMULA_LINE_TYPE_CODE = 'PLL'
                           and trunc(sysdate) between nvl(fl.start_date_active, trunc(sysdate))
			       and nvl(fl.end_date_active, trunc(sysdate)));

Line: 289

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

Line: 299

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

Line: 309

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

Line: 349

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

Line: 597

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

Line: 631

            ,   'Entity_Delete'
            );

Line: 635

END Entity_Delete;