APPS.QP_COPY_PRICELIST_PVT dependencies on DUAL

Line 411: FROM dual;

407: --Select next discount_header_id
408:
409: SELECT qp_list_headers_b_s.nextval
410: INTO l_new_discount_header_id
411: FROM dual;
412:
413: --bug#6636843
414: l_new_orig_system_hrd_Ref := QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(l_new_discount_header_id);
415:

Line 609: FROM dual;

605:
606: --Get new qualifier_id
607: SELECT qp_qualifiers_s.nextval
608: INTO l_new_qualifier_id
609: FROM dual;
610:
611: IF l_qp_qualifiers_rec.qualifier_attr_value =
612: TO_CHAR(p_from_list_header_id) AND
613: l_qp_qualifiers_rec.qualifier_context = p_context AND

Line 781: FROM dual;

777:
778: --Get New Discount Line Id
779: SELECT qp_list_lines_s.nextval
780: INTO l_new_discount_line_id
781: FROM dual;
782:
783: --Insert Discount Line
784: INSERT INTO qp_list_lines
785: (

Line 982: FROM dual;

978:
979: -- Get next pricing_attribute_id
980: SELECT qp_pricing_attributes_s.nextval
981: INTO l_new_pricing_attribute_id
982: FROM dual;
983:
984:
985: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'
986: then

Line 1123: FROM dual;

1119:
1120: --Get new qualifier_id
1121: SELECT qp_qualifiers_s.nextval
1122: INTO l_new_qualifier_id
1123: FROM dual;
1124:
1125: IF l_qp_qualifiers_rec.qualifier_attr_value =
1126: TO_CHAR(p_from_list_header_id) AND
1127: l_qp_qualifiers_rec.qualifier_context = p_context AND

Line 1302: FROM dual;

1298: LOOP
1299:
1300: SELECT qp_rltd_modifiers_s.nextval
1301: INTO l_new_rltd_modifier_id
1302: FROM dual;
1303:
1304: l_new_from_id := Get_New_Id(
1305: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
1306: l_mapping_tbl);

Line 1667: FROM dual;

1663: -- Get next list_header_id
1664:
1665: SELECT qp_list_headers_b_s.nextval
1666: INTO l_new_list_header_id
1667: FROM dual;
1668:
1669: -- Insert Price List Header information
1670:
1671: INSERT INTO qp_list_headers_all_b

Line 1870: FROM dual;

1866:
1867: --Get new qualifier_id
1868: SELECT qp_qualifiers_s.nextval
1869: INTO l_new_qualifier_id
1870: FROM dual;
1871:
1872: --To associate newly copied qualifiers (including secondary pricelists)
1873: --to the new price list
1874: IF p_from_list_header_id = l_qp_qualifiers_rec.list_header_id THEN

Line 2399: FROM dual;

2395: -- Get next list_line_id
2396:
2397: SELECT qp_list_lines_s.nextval
2398: INTO l_new_list_line_id
2399: FROM dual;
2400:
2401: INSERT INTO qp_list_lines
2402: (
2403: list_line_id,

Line 2629: FROM dual;

2625:
2626: -- Get next pricing_attribute_id
2627: SELECT qp_pricing_attributes_s.nextval
2628: INTO l_new_pricing_attribute_id
2629: FROM dual;
2630:
2631: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND
2632: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')
2633: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_list_lines_rec.list_line_id

Line 2793: FROM dual;

2789: LOOP
2790:
2791: SELECT qp_rltd_modifiers_s.nextval
2792: INTO l_new_rltd_modifier_id
2793: FROM dual;
2794:
2795: l_new_from_id := Get_New_Id(
2796: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
2797: l_mapping_tbl);