APPS.QP_DEFAULT_PRICE_LIST_LINE SQL Statements

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

Line: 156

   select qp_list_lines_s.nextval
   into l_list_line_id
   from dual;

Line: 201

    SELECT qp_rltd_modifier_grp_no_s.nextval
    into l_rltd_modifier_grp_no
    from dual;

Line: 223

	 select product_precedence
	 into l_prod_precedence
	 from qp_list_lines
	 where list_line_id = g_PRICE_LIST_LINE_rec.from_rltd_modifier_id;

Line: 299

  select price_break_type_code
  into l_price_break_type
  from qp_list_lines
  where list_line_id = g_price_list_line_rec.from_rltd_modifier_id
  and rownum < 2;

Line: 417

    select start_date_active
    into l_start_date
    from qp_list_headers_b
    where list_header_id = g_PRICE_LIST_LINE_rec.list_header_id;

Line: 1753

    IF g_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_PRICE_LIST_LINE_rec.last_updated_by := NULL;

Line: 1759

    IF g_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_PRICE_LIST_LINE_rec.last_update_date := NULL;

Line: 1765

    IF g_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_PRICE_LIST_LINE_rec.last_update_login := NULL;

Line: 1783

    IF g_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_PRICE_LIST_LINE_rec.program_update_date := NULL;

Line: 1827

    OR  g_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.rltd_modifier_group_no = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.product_precedence = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.number_effective_periods = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.operand = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.percent_price = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_PRICE_LIST_LINE_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE
    OR  g_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE
    OR  g_PRICE_LIST_LINE_rec.substitution_attribute = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.substitution_context = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.substitution_value = FND_API.G_MISS_CHAR
    THEN

	 oe_debug_pub.add('default attributes');