APPS.QP_VALIDATE_PRICE_LIST_LINE SQL Statements

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

Line: 62

	SELECT start_date_active, end_date_active INTO l_hdr_start_date, l_hdr_end_date FROM QP_LIST_HEADERS_ALL_B b
	WHERE b.list_header_id = p_PRICE_LIST_LINE_rec.list_header_id;

Line: 124

      SELECT count(*)
      INTO l_dummy_1
      FROM qp_price_breaks_v
      WHERE parent_list_line_id = p_PRICE_LIST_LINE_rec.list_line_id
        AND arithmetic_operator = 'BLOCK_PRICE';

Line: 146

      SELECT count(*)
      INTO l_dummy_1
      FROM qp_price_breaks_v
      WHERE parent_list_line_id = p_PRICE_LIST_LINE_rec.list_line_id
        AND (arithmetic_operator = 'UNIT_PRICE' OR recurring_value IS NOT NULL);

Line: 203

          select 'X'
          into   l_dummy_1
          from   qp_price_formulas_b
          where  price_formula_id = p_PRICE_LIST_LINE_rec.generate_using_formula_id
            and    not exists (select price_formula_line_type_code
                               from   qp_price_formula_lines
                               where  price_formula_id = p_PRICE_LIST_LINE_rec.generate_using_formula_id
                               and    price_formula_line_type_code = 'MV' );

Line: 227

          select 'X'
          into   l_dummy_1
          from   qp_price_formulas_b
          where  price_formula_id = p_PRICE_LIST_LINE_rec.price_by_formula_id
            and    not exists (select price_formula_line_type_code
                               from   qp_price_formula_lines
                               where  price_formula_id = p_PRICE_LIST_LINE_rec.price_by_formula_id
                               and    price_formula_line_type_code = 'MV' );

Line: 334

	   SELECT uom_code
	     INTO l_uom_code
	     FROM mtl_units_of_measure_vl
	     WHERE uom_code = p_PRICE_LIST_LINE_rec.break_uom_code
	     AND rownum<2;

Line: 563

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

Line: 573

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

Line: 583

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

Line: 795

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

Line: 1147

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

Line: 1181

            ,   'Entity_Delete'
            );

Line: 1185

END Entity_Delete;