APPS.QP_PRICING_ATTR_UTIL dependencies on QP_PTE_SEGMENTS

Line 1521: UPDATE qp_pte_segments set used_in_setup='Y'

1517:
1518: IF(p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL) AND
1519: (p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL) THEN
1520:
1521: UPDATE qp_pte_segments set used_in_setup='Y'
1522: WHERE nvl(used_in_setup,'N')='N'
1523: AND segment_id IN
1524: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1525: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute

Line 1535: UPDATE qp_pte_segments set used_in_setup='Y'

1531:
1532: IF(p_PRICING_ATTR_rec.product_attribute_context IS NOT NULL) AND
1533: (p_PRICING_ATTR_rec.product_attribute IS NOT NULL) THEN
1534:
1535: UPDATE qp_pte_segments set used_in_setup='Y'
1536: WHERE nvl(used_in_setup,'N')='N'
1537: AND segment_id IN
1538: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1539: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.product_attribute

Line 1785: UPDATE qp_pte_segments set used_in_setup='Y'

1781: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1782: IF(p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL) AND
1783: (p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL) THEN
1784:
1785: UPDATE qp_pte_segments set used_in_setup='Y'
1786: WHERE nvl(used_in_setup,'N')='N'
1787: AND segment_id IN
1788: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1789: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute

Line 1800: UPDATE qp_pte_segments set used_in_setup='Y'

1796:
1797: IF(p_PRICING_ATTR_rec.product_attribute_context IS NOT NULL) AND
1798: (p_PRICING_ATTR_rec.product_attribute IS NOT NULL) THEN
1799:
1800: UPDATE qp_pte_segments set used_in_setup='Y'
1801: WHERE nvl(used_in_setup,'N')='N'
1802: AND segment_id IN
1803: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1804: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.product_attribute