APPS.QP_COPY_MODIFIERS_PVT dependencies on QP_LIST_LINES

Line 85: FROM qp_list_lines a

81: /*
82: CURSOR del_dup_cur (a_new_list_header_id NUMBER)
83: IS
84: SELECT *
85: FROM qp_list_lines a
86: WHERE EXISTS (SELECT NULL
87: FROM qp_list_lines b
88: WHERE a.inventory_item_id = b.inventory_item_id
89: AND a.list_line_type_code = b.list_line_type_code

Line 87: FROM qp_list_lines b

83: IS
84: SELECT *
85: FROM qp_list_lines a
86: WHERE EXISTS (SELECT NULL
87: FROM qp_list_lines b
88: WHERE a.inventory_item_id = b.inventory_item_id
89: AND a.list_line_type_code = b.list_line_type_code
90: AND a.list_header_id = b.list_header_id
91: AND a.list_header_id = a_new_list_header_id

Line 184: FROM qp_list_lines qll,qp_pricing_attributes qpa

180:
181: CURSOR del_dup_cur(a_new_list_header_id NUMBER)
182: IS
183: SELECT distinct qll.list_line_id,qpa.product_attribute_context,qpa.product_attribute,qpa.product_attr_value
184: FROM qp_list_lines qll,qp_pricing_attributes qpa
185: WHERE qll.list_header_id=a_new_list_header_id
186: AND qll.list_line_id=qpa.list_line_id(+);
187:
188: l_status BOOLEAN := TRUE;

Line 236: DELETE qp_list_lines

232:
233: delete qp_qualifiers
234: where list_line_id=l_del_dup_cur_rec.list_line_id;
235:
236: DELETE qp_list_lines
237: where list_line_id=l_del_dup_cur_rec.list_line_id;
238: END IF;
239:
240: END LOOP;

Line 252: DELETE qp_list_lines

248:
249: DELETE qp_pricing_attributes pa
250: WHERE pa.list_line_id = l_del_dup_cur_rec.list_line_id;
251:
252: DELETE qp_list_lines
253: WHERE CURRENT OF del_dup_cur;
254:
255: END LOOP;
256:

Line 377: FROM qp_list_lines

373:
374: CURSOR qp_discount_lines_cur(p_from_discount_header_id NUMBER)
375: IS
376: SELECT *
377: FROM qp_list_lines
378: WHERE list_header_id = p_from_discount_header_id
379: AND ((end_date_active IS NULL) OR (trunc(end_date_active) >= trunc(sysdate))); --Added for 2476973
380:
381: CURSOR qp_pricing_attributes_cur(p_from_discount_line_id NUMBER)

Line 923: select count(*) into l_cnt from qp_list_lines where list_line_id=l_line_id

919: If l_line_id is null then
920: insert_flag :='Y';
921: Else
922: Begin
923: select count(*) into l_cnt from qp_list_lines where list_line_id=l_line_id
924: AND ((end_date_active IS NULL) OR (trunc(end_date_active) >= trunc(sysdate)));
925: Exception
926: when no_data_found then
927: l_cnt:=0;

Line 938: SELECT qp_list_lines_s.nextval

934:
935: If insert_flag ='Y' then --end 2734611 changes
936:
937: --Get New Discount Line Id
938: SELECT qp_list_lines_s.nextval
939: INTO l_new_discount_line_id
940: FROM dual;
941:
942: --Insert Discount Line

Line 943: INSERT INTO qp_list_lines

939: INTO l_new_discount_line_id
940: FROM dual;
941:
942: --Insert Discount Line
943: INSERT INTO qp_list_lines
944: (
945: list_line_id,
946: creation_date,
947: created_by,

Line 1302: --,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_discount_line_id)

1298: l_qp_line_qualifiers_rec.header_quals_exist_flag,
1299: l_qp_line_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
1300: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1301: --,to_char(l_new_qualifier_id)
1302: --,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_discount_line_id)
1303: --,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
1304: );
1305:
1306: END LOOP;

Line 1486: --,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_discount_line_id)

1482: l_pric_attr_value_from_number,
1483: l_pric_attr_value_to_number
1484: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1485: --,to_char(l_new_pricing_attribute_id)
1486: --,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_discount_line_id)
1487: --,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
1488: );
1489:
1490: END LOOP; /* For copying pricing attributes for each discount line */

Line 1637: from qp_list_lines

1633:
1634: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1635: select min(list_line_id), max(list_line_id)
1636: into l_min_list_line_id, l_max_list_line_id
1637: from qp_list_lines
1638: where list_header_id = l_new_discount_header_id;
1639:
1640: QP_ATTR_GRP_PVT.Update_Qual_Segment_id(l_new_discount_header_id, null, -1, -1); -- Bug No 4331910
1641: QP_ATTR_GRP_PVT.Update_Qual_Segment_id(l_new_discount_header_id,

Line 1658: from qp_list_lines

1654: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1655: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
1656: select min(list_line_id), max(list_line_id)
1657: into l_min_list_line_id, l_max_list_line_id
1658: from qp_list_lines
1659: where list_header_id = l_new_discount_header_id; --bug12784298
1660: QP_PS_ATTR_GRP_PVT.g_call_from_setup := 'Y'; --bug12784298
1661: QP_PS_ATTR_GRP_PVT.Update_Qual_Segment_id(l_new_discount_header_id,
1662: null,