[Home] [Help]
1110: --start bug 2301959
1111:
1112: select start_date_active, end_date_active , revision, list_header_id
1113: into l_start_date_active, l_end_date_active, l_revision, l_list_header_id
1114: from qp_list_lines
1115: where list_line_id = l_pricing_attr_rec.list_line_id;
1116:
1117: IF (QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES IS NULL)
1118: THEN -- 5018856, 5024919 do not log request if N
1785: ,L.CUSTOMER_ITEM_ID
1786: ,L.BREAK_UOM_CODE
1787: ,L.BREAK_UOM_CONTEXT
1788: ,L.BREAK_UOM_ATTRIBUTE
1789: FROM QP_LIST_LINES L, QP_RLTD_MODIFIERS RM
1790: WHERE L.LIST_LINE_ID = RM.TO_RLTD_MODIFIER_ID
1791: AND RM.FROM_RLTD_MODIFIER_ID = p_list_line_id;
1792:
1793: --added for related lines duplication
1959: END LOOP;
1960:
1961: --added for related lines duplication
1962:
1963: SELECT list_line_type_code into l_list_line_type_code from QP_LIST_LINES where list_line_id=p_x_old_list_line_id;
1964: If l_list_line_type_code IN ('PBH') Then
1965:
1966: --Storing continuous_price_break_flag value for later use,to convert non continuous price break lines into continuous line.
1967:
1965:
1966: --Storing continuous_price_break_flag value for later use,to convert non continuous price break lines into continuous line.
1967:
1968: SELECT continuous_price_break_flag INTO l_continuous_price_break_flag
1969: FROM QP_LIST_LINES
1970: WHERE list_line_id=p_x_old_list_line_id;
1971: FOR l_implicit_rec IN l_LIST_LINE_csr(p_x_old_list_line_id) LOOP
1972:
1973:
1970: WHERE list_line_id=p_x_old_list_line_id;
1971: FOR l_implicit_rec IN l_LIST_LINE_csr(p_x_old_list_line_id) LOOP
1972:
1973:
1974: SELECT qp_List_lines_s.nextval INTO l_new_list_line_id
1975: FROM dual;
1976:
1977:
1978: