APPS.QP_DEFAULT_PLL_PRICING_ATTR SQL Statements

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

Line: 29

   select attribute_grouping_no
   into l_attribute_grouping_no
   from qp_pricing_attributes
   where list_line_id = g_Pricing_Attr_rec.list_line_id
   and rownum < 2;

Line: 41

     select qp_pricing_attr_group_no_s.nextval
     into l_attribute_grouping_no
     from dual;

Line: 84

    SELECT list_header_id
    INTO   l_list_header_id
    FROM   qp_list_lines
    WHERE  list_line_id = a_list_line_id;

Line: 111

   select qp_pricing_attributes_s.nextval
   into l_pricing_attribute_id
   from dual;

Line: 271

    select product_attribute
    into l_prod_attr
    from qp_pricing_attributes
    where list_line_id = g_Pricing_Attr_rec.from_rltd_modifier_id
    and excluder_flag = 'N'
    and rownum < 2;

Line: 283

    select product_attribute
    into l_prod_attr
    from qp_pricing_attributes
    where list_line_id = g_Pricing_Attr_rec.list_line_id
    and excluder_flag = 'N'
    and rownum < 2;

Line: 311

    select product_attribute_context
    into l_prod_attr_cont
    from qp_pricing_attributes
    where list_line_id = g_Pricing_Attr_rec.from_rltd_modifier_id
    and excluder_flag = 'N'
    and rownum < 2;

Line: 323

    select product_attribute_context
    into l_prod_attr_cont
    from qp_pricing_attributes
    where list_line_id = g_Pricing_Attr_rec.list_line_id
    and excluder_flag = 'N'
    and rownum < 2;

Line: 349

    select product_attr_value
    into l_prod_attr_value
    from qp_pricing_attributes
    where list_line_id = g_Pricing_Attr_rec.from_rltd_modifier_id
    and excluder_flag = 'N'
    and rownum < 2;

Line: 361

    select product_attr_value
    into l_prod_attr_value
    from qp_pricing_attributes
    where list_line_id = g_Pricing_Attr_rec.list_line_id
    and excluder_flag = 'N'
    and rownum < 2;

Line: 387

    select product_uom_code
    into l_prod_uom
    from qp_pricing_attributes
    where list_line_id = g_Pricing_Attr_rec.from_rltd_modifier_id
    and excluder_flag = 'N'
    and rownum < 2;

Line: 399

    select product_uom_code
    into l_prod_uom
    from qp_pricing_attributes
    where list_line_id = g_Pricing_Attr_rec.list_line_id
    and excluder_flag = 'N'
    and rownum < 2;

Line: 998

    IF g_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_PRICING_ATTR_rec.last_updated_by := NULL;

Line: 1004

    IF g_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_PRICING_ATTR_rec.last_update_date := NULL;

Line: 1010

    IF g_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_PRICING_ATTR_rec.last_update_login := NULL;

Line: 1028

    IF g_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_PRICING_ATTR_rec.program_update_date := NULL;

Line: 1063

    OR  g_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM
    OR  g_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR
    OR  g_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR
    OR  g_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM
    OR  g_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR
    OR  g_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR
    OR  g_PRICING_ATTR_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM
    OR  g_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR
    OR  g_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR
    OR  g_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR
    OR  g_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR
    OR  g_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM
    OR  g_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM
    OR  g_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR
    OR  g_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR
    OR  g_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR
    THEN

        Qp_Default_pll_pricing_attr.Attributes
        (   p_PRICING_ATTR_rec            => g_PRICING_ATTR_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_PRICING_ATTR_rec            => x_PRICING_ATTR_rec
        );