APPS.QP_COPY_PRICELIST_PVT dependencies on DUAL

Line 402: FROM dual;

398: --Select next discount_header_id
399:
400: SELECT qp_list_headers_b_s.nextval
401: INTO l_new_discount_header_id
402: FROM dual;
403:
404: --bug#6636843
405: l_new_orig_system_hrd_Ref := QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(l_new_discount_header_id);
406:

Line 600: FROM dual;

596:
597: --Get new qualifier_id
598: SELECT qp_qualifiers_s.nextval
599: INTO l_new_qualifier_id
600: FROM dual;
601:
602: IF l_qp_qualifiers_rec.qualifier_attr_value =
603: TO_CHAR(p_from_list_header_id) AND
604: l_qp_qualifiers_rec.qualifier_context = p_context AND

Line 772: FROM dual;

768:
769: --Get New Discount Line Id
770: SELECT qp_list_lines_s.nextval
771: INTO l_new_discount_line_id
772: FROM dual;
773:
774: --Insert Discount Line
775: INSERT INTO qp_list_lines
776: (

Line 973: FROM dual;

969:
970: -- Get next pricing_attribute_id
971: SELECT qp_pricing_attributes_s.nextval
972: INTO l_new_pricing_attribute_id
973: FROM dual;
974:
975:
976: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'
977: then

Line 1121: FROM dual;

1117: LOOP
1118:
1119: SELECT qp_rltd_modifiers_s.nextval
1120: INTO l_new_rltd_modifier_id
1121: FROM dual;
1122:
1123: l_new_from_id := Get_New_Id(
1124: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
1125: l_mapping_tbl);

Line 1485: FROM dual;

1481: -- Get next list_header_id
1482:
1483: SELECT qp_list_headers_b_s.nextval
1484: INTO l_new_list_header_id
1485: FROM dual;
1486:
1487: -- Insert Price List Header information
1488:
1489: INSERT INTO qp_list_headers_all_b

Line 1687: FROM dual;

1683:
1684: --Get new qualifier_id
1685: SELECT qp_qualifiers_s.nextval
1686: INTO l_new_qualifier_id
1687: FROM dual;
1688:
1689: --To associate newly copied qualifiers (including secondary pricelists)
1690: --to the new price list
1691: IF p_from_list_header_id = l_qp_qualifiers_rec.list_header_id THEN

Line 2216: FROM dual;

2212: -- Get next list_line_id
2213:
2214: SELECT qp_list_lines_s.nextval
2215: INTO l_new_list_line_id
2216: FROM dual;
2217:
2218: INSERT INTO qp_list_lines
2219: (
2220: list_line_id,

Line 2446: FROM dual;

2442:
2443: -- Get next pricing_attribute_id
2444: SELECT qp_pricing_attributes_s.nextval
2445: INTO l_new_pricing_attribute_id
2446: FROM dual;
2447:
2448: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND
2449: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')
2450: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_list_lines_rec.list_line_id

Line 2610: FROM dual;

2606: LOOP
2607:
2608: SELECT qp_rltd_modifiers_s.nextval
2609: INTO l_new_rltd_modifier_id
2610: FROM dual;
2611:
2612: l_new_from_id := Get_New_Id(
2613: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
2614: l_mapping_tbl);