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_PRICING_ATTR SQL Statements

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

Line: 25


	select list_header_id into l_list_header_id from qp_list_lines where list_line_id = p_list_line_id;

Line: 53


	select pricing_phase_id into l_pricing_phase_id from qp_list_lines where list_line_id = p_list_line_id;

Line: 97


   select QP_PRICING_ATTR_GROUP_NO_S.nextval
   into   l_attribute_grouping_no
   from   dual;

Line: 129


    select QP_PRICING_ATTRIBUTES_S.nextval
    into   l_pricing_attribute_id
    from   dual;

Line: 847


    IF g_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_PRICING_ATTR_rec.last_updated_by := NULL;

Line: 853


    IF g_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_PRICING_ATTR_rec.last_update_date := NULL;

Line: 859


    IF g_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_PRICING_ATTR_rec.last_update_login := NULL;

Line: 877


    IF g_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_PRICING_ATTR_rec.program_update_date := NULL;

Line: 912


    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.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.comparison_operator_code = FND_API.G_MISS_CHAR
    OR  g_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM
    OR  g_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM
    OR  g_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR
    OR  g_PRICING_ATTR_rec.pricing_attribute_datatype = 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
    THEN

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